Query Metrics
83
Database Queries
5
Different statements
103.98 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
70.63 ms (67.93%) |
67 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.advantages AS advantages_4, t0.image AS image_5, t0.qrcode AS qrcode_6, t0.description AS description_7, t0.picto1 AS picto1_8, t0.picto2 AS picto2_9, t0.picto3 AS picto3_10, t0.picto4 AS picto4_11, t0.certif1 AS certif1_12, t0.certif2 AS certif2_13, t0.binder AS binder_14, t0.pigments AS pigments_15, t0.solvents AS solvents_16, t0.voc_content AS voc_content_17, t0.marking_duration AS marking_duration_18, t0.autonomy AS autonomy_19, t0.drying_time AS drying_time_20, t0.storage AS storage_21, t0.technical_warranty AS technical_warranty_22, t0.manufacturer AS manufacturer_23, t0.size AS size_24, t0.diameter AS diameter_25, t0.volume AS volume_26, t0.weight AS weight_27, t0.packaging AS packaging_28, t0.advices AS advices_29, t0.security AS security_30, t0.security_img1 AS security_img1_31, t0.security_img2 AS security_img2_32, t0.security_img3 AS security_img3_33, t0.security_img4 AS security_img4_34, t0.end_of_life AS end_of_life_35, t0.instructions AS instructions_36, t0.instructions_img AS instructions_img_37, t0.version AS version_38, t0.progression AS progression_39, t0.lang_id AS lang_id_40, t0.product_id AS product_id_41 FROM product_web_to_print_lang t0 WHERE t0.product_id = ?
Parameters:
[
14
]
|
13.62 ms (13.09%) |
13 |
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.brand_id = ? AND t0.is_nc = ?
Parameters:
[ 2 0 ] |
11.48 ms (11.04%) |
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:
[] |
4.49 ms (4.32%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.friendly_url AS friendly_url_3, t0.technima_brand AS technima_brand_4, t0.logo AS logo_5 FROM brand t0 WHERE t0.technima_brand = ?
Parameters:
[
1
]
|
3.77 ms (3.63%) |
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:
[] |
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.