Query Metrics
243
Database Queries
4
Different statements
286.92 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
273.52 ms (95.33%) |
240 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_title AS sub_title_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.progression AS progression_8, t0.regulations AS regulations_9, t0.advices AS advices_10, t0.lang_id AS lang_id_11, t0.product_id AS product_id_12 FROM product_lang t0 WHERE t0.product_id = ?
Parameters:
[
16
]
|
5.62 ms (1.96%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.email AS email_5, t0.url AS url_6, t0.api_key AS api_key_7, t0.is_web_to_print_address AS is_web_to_print_address_8 FROM site t0
Parameters:
[] |
5.14 ms (1.79%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icu AS icu_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.main AS main_6, t0.is_interface AS is_interface_7, t8.id AS id_9, t8.email AS email_10, t8.roles AS roles_11, t8.password AS password_12, t8.date_add AS date_add_13, t8.date_upd AS date_upd_14, t8.firstname AS firstname_15, t8.lastname AS lastname_16, t8.color AS color_17, t8.available_to AS available_to_18, t8.auth_code AS auth_code_19, t8.mdd_brand_requested AS mdd_brand_requested_20, t8.interface_lang_id AS interface_lang_id_21, t8.lang_in_charge_id AS lang_in_charge_id_22 FROM lang t0 LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id
Parameters:
[] |
2.63 ms (0.92%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ean13 AS ean13_3, t0.isbn AS isbn_4, t0.mpn AS mpn_5, t0.price AS price_6, t0.width AS width_7, t0.height AS height_8, t0.depth AS depth_9, t0.weight AS weight_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.is_nc AS is_nc_13, t0.brand_id AS brand_id_14, t0.mdd_brand_id AS mdd_brand_id_15 FROM product t0 WHERE t0.mdd_brand_id IS NULL AND t0.is_nc = ?
Parameters:
[
0
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.