Query Metrics
4
Database Queries
4
Different statements
283.28 ms
Query time
1
Invalid entities
0
Cache hits
3
Cache misses
3
Cache puts
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
96.60 ms (34.10%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.file_name AS file_name_3, t0.tries AS tries_4, t0.error AS error_5, t0.original AS original_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.synced_at AS synced_at_9, t0.index_at AS index_at_10, t0.product AS product_11 FROM product_photo t0 WHERE t0.product IN (?)
Parameters:
[
[
4
]
]
|
84.47 ms (29.82%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.barcode AS barcode_3, t0.title AS title_4, t0.original_title AS original_title_5, t0.search_title AS search_title_6, t0.slug AS slug_7, t0.origin AS origin_8, t0.link AS link_9, t0.inner_diameter_min AS inner_diameter_min_10, t0.inner_diameter_max AS inner_diameter_max_11, t0.outer_diameter_min AS outer_diameter_min_12, t0.outer_diameter_max AS outer_diameter_max_13, t0.width_min AS width_min_14, t0.width_max AS width_max_15, t0.weight AS weight_16, t0.gross_price AS gross_price_17, t0.minimal_quantity AS minimal_quantity_18, t0.disabled AS disabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.synced_at AS synced_at_22, t0.index_at AS index_at_23, t0.remote_id AS remote_id_24, t0.category AS category_25, t0.sub_category AS sub_category_26, t0.product_group AS product_group_27, t0.manufacturer AS manufacturer_28, t0.unit_of_measurement AS unit_of_measurement_29 FROM product t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
52.29 ms (18.46%) |
1 |
SELECT t0.id AS id_1, t0.page AS page_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.document AS document_7, t0.product AS product_8 FROM product_document t0 WHERE t0.product IN (?)
Parameters:
[
[
4
]
]
|
49.93 ms (17.62%) |
1 |
SELECT c0_.code AS code_0, c0_.name AS name_1, c0_.rate AS rate_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.synced_at AS synced_at_5, c0_.index_at AS index_at_6 FROM currency c0_ WHERE c0_.code = ?
Parameters:
[
"RSD"
]
|
client_rel_management connection
No database queries were performed.
client_rel_web_management connection
No database queries were performed.
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
client_rel_management | doctrine.dbal.client_rel_management_connection |
client_rel_web_management | doctrine.dbal.client_rel_web_management_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
client_rel_management | doctrine.orm.client_rel_management_entity_manager |
client_rel_web_management | doctrine.orm.client_rel_web_management_entity_manager |
Second Level Cache
0
Hits
3
Misses
3
Puts
Number of cache misses
Region | Misses |
---|---|
public | 3 |
Number of cache puts
Region | Puts |
---|---|
public | 3 |
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\ECommerce\Currency | No errors. |
App\Entity\ECommerce\Depot | No errors. |
App\Entity\ECommerce\Client | No errors. |
App\Entity\ECommerce\Shipping | No errors. |
App\Entity\ECommerce\Product | No errors. |
App\Entity\ECommerce\ProductCategory | No errors. |
App\Entity\ECommerce\ProductSubCategory | No errors. |
App\Entity\ECommerce\ProductGroup | No errors. |
App\Entity\ECommerce\ProductManufacturer | No errors. |
App\Entity\ECommerce\Unit | No errors. |
App\Entity\ECommerce\ProductPhoto | No errors. |
App\Entity\ECommerce\ProductDocument | No errors. |
App\Entity\ECommerce\DepotProduct |
|
App\Entity\ECommerce\ProductAlternative | No errors. |
App\Entity\ECommerce\ProductInfo | No errors. |
App\Entity\ECommerce\ProductTranslation | No errors. |
App\Entity\Content\Document | No errors. |
App\Entity\App\User | No errors. |
App\Entity\ECommerce\DepotTranslation | No errors. |
App\Entity\ECommerce\ClientGroup | No errors. |
App\Entity\ECommerce\Cart | No errors. |
App\Entity\ECommerce\Firm | No errors. |
App\Entity\ECommerce\ProductCategoryTranslation | No errors. |
App\Entity\ECommerce\Rebate | No errors. |
App\Entity\ECommerce\ProductInfoTranslation | No errors. |
App\Entity\Content\DocumentCategory | No errors. |
App\Entity\Content\DocumentTranslation | No errors. |
App\Entity\ECommerce\IndividualOrder | No errors. |
App\Entity\ECommerce\CartItem | No errors. |
App\Entity\ECommerce\Invoice | No errors. |
App\Entity\ECommerce\BankAccount | No errors. |
App\Entity\SEO\Seo | No errors. |
App\Entity\ECommerce\BillItem | No errors. |
App\Entity\ECommerce\Bill | No errors. |
client_rel_management entity manager
No loaded entities.
client_rel_web_management entity manager
No loaded entities.