Query Metrics
5
Database Queries
5
Different statements
2.77 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.65 ms |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ WHERE p0_.product_id = ?
Parameters:
[
"1216"
]
|
| 2 | 0.16 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "1216" "en_US" "App\Entity\Product" ] |
| 3 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 0.37 ms |
UPDATE product SET clicked_count = ? WHERE product_id = ?
Parameters:
[ 260 1216 ] |
| 5 | 1.50 ms |
"COMMIT"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| dynamic_conn | doctrine.dbal.dynamic_conn_connection |
| eshop_conn | doctrine.dbal.eshop_conn_connection |
| eshop_demo_conn | doctrine.dbal.eshop_demo_conn_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| dynamic_em | doctrine.orm.dynamic_em_entity_manager |
| eshop_em | doctrine.orm.eshop_em_entity_manager |
| eshop_demo_em | doctrine.orm.eshop_demo_em_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |
| App\Entity\Price | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\ProductGroup | No errors. |
| App\Entity\Department | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| App\Entity\ProductTranslation | No errors. |
dynamic_em entity manager
No loaded entities.
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.