Query Metrics
3
Database Queries
3
Different statements
10.36 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.55 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.supplier_reference AS supplier_reference_3, t0.location AS location_4, t0.ean13 AS ean13_5, t0.isbn AS isbn_6, t0.upc AS upc_7, t0.mpn AS mpn_8, t0.weight AS weight_9, t0.default_on AS default_on_10, t0.product_id AS product_id_11, t12.id AS id_13, t12.manufacturer AS manufacturer_14, t12.brand AS brand_15, t12.product_range AS product_range_16, t12.commercial_reference AS commercial_reference_17, t12.product_reference AS product_reference_18, t12.info_reference AS info_reference_19, t12.gtin13 AS gtin13_20, t12.date_tarif AS date_tarif_21, t12.price_without_tax AS price_without_tax_22, t12.distributor_price_without_tax AS distributor_price_without_tax_23, t12.currency AS currency_24, t12.vat AS vat_25, t12.quantity AS quantity_26, t12.base_reference_unit AS base_reference_unit_27, t12.minimal_order_quantity AS minimal_order_quantity_28, t12.multiple_per_order AS multiple_per_order_29, t12.packaging_qty_min AS packaging_qty_min_30, t12.manufacturer_stored_product AS manufacturer_stored_product_31, t12.delivery_delay AS delivery_delay_32, t12.electronic_data_interchange AS electronic_data_interchange_33, t12.warranty_duration AS warranty_duration_34, t12.reference_status AS reference_status_35, t12.taric AS taric_36, t12.product_height AS product_height_37, t12.product_height_unity AS product_height_unity_38, t12.product_width AS product_width_39, t12.product_width_unity AS product_width_unity_40, t12.product_depth AS product_depth_41, t12.product_depth_unity AS product_depth_unity_42, t12.product_weight AS product_weight_43, t12.product_weight_unity AS product_weight_unity_44, t12.product_diameter AS product_diameter_45, t12.product_diameter_unity AS product_diameter_unity_46, t12.recommended_storage_limit_duration AS recommended_storage_limit_duration_47, t12.made_in AS made_in_48, t12.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_49, t12.product_id AS product_id_50, t12.product_attribute_id AS product_attribute_id_51, t52.id AS id_53, t52.brand AS brand_54, t52.commercial_reference AS commercial_reference_55, t52.quantity AS quantity_56, t52.gtin14 AS gtin14_57, t52.product_height AS product_height_58, t52.product_height_unity AS product_height_unity_59, t52.product_width AS product_width_60, t52.product_width_unity AS product_width_unity_61, t52.product_depth AS product_depth_62, t52.product_depth_unity AS product_depth_unity_63, t52.product_weight AS product_weight_64, t52.product_weight_unity AS product_weight_unity_65, t52.product_diameter AS product_diameter_66, t52.product_diameter_unity AS product_diameter_unity_67, t52.product_volume AS product_volume_68, t52.product_volume_unity AS product_volume_unity_69, t52.deposit AS deposit_70, t52.stacking_limit_count AS stacking_limit_count_71, t52.qc_type AS qc_type_72, t52.product_id AS product_id_73, t52.product_attribute_id AS product_attribute_id_74 FROM product_attribute t0 LEFT JOIN erpcommercial_data t12 ON t12.product_attribute_id = t0.id LEFT JOIN erplogistic_data t52 ON t52.product_attribute_id = t0.id WHERE t0.id = ?
Parameters:
[
"421"
]
|
2 | 3.89 ms |
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 WHERE t0.id = ?
Parameters:
[
1
]
|
3 | 1.92 ms |
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.lang_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ 1 9 ] |
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.