Query Metrics

5 Database Queries
5 Different statements
2.43 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.58 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:
[
  "261"
]
2 0.09 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:
[
  "261"
  "en_US"
  "App\Entity\Product"
]
3 0.06 ms
"START TRANSACTION"
Parameters:
[]
4 0.32 ms
UPDATE product SET clicked_count = ? WHERE product_id = ?
Parameters:
[
  229
  261
]
5 1.38 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.