Query Metrics
799
Database Queries
8
Different statements
2776.96 ms
Query time
5
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1437.29 ms (51.76%) |
263 |
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:
[
9
]
|
|
570.82 ms (20.56%) |
263 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.cover AS cover_4, t0.position AS position_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
9
]
|
|
553.08 ms (19.92%) |
260 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.image_id AS image_id_3, t0.lang_id AS lang_id_4 FROM image_lang t0 WHERE t0.image_id = ?
Parameters:
[
830
]
|
|
138.10 ms (4.97%) |
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.brand_id AS brand_id_13, t14.id AS id_15, t14.manufacturer AS manufacturer_16, t14.brand AS brand_17, t14.product_range AS product_range_18, t14.commercial_reference AS commercial_reference_19, t14.product_reference AS product_reference_20, t14.info_reference AS info_reference_21, t14.gtin13 AS gtin13_22, t14.date_tarif AS date_tarif_23, t14.price_without_tax AS price_without_tax_24, t14.distributor_price_without_tax AS distributor_price_without_tax_25, t14.currency AS currency_26, t14.vat AS vat_27, t14.quantity AS quantity_28, t14.base_reference_unit AS base_reference_unit_29, t14.minimal_order_quantity AS minimal_order_quantity_30, t14.multiple_per_order AS multiple_per_order_31, t14.packaging_qty_min AS packaging_qty_min_32, t14.manufacturer_stored_product AS manufacturer_stored_product_33, t14.delivery_delay AS delivery_delay_34, t14.electronic_data_interchange AS electronic_data_interchange_35, t14.warranty_duration AS warranty_duration_36, t14.reference_status AS reference_status_37, t14.taric AS taric_38, t14.product_height AS product_height_39, t14.product_height_unity AS product_height_unity_40, t14.product_width AS product_width_41, t14.product_width_unity AS product_width_unity_42, t14.product_depth AS product_depth_43, t14.product_depth_unity AS product_depth_unity_44, t14.product_weight AS product_weight_45, t14.product_weight_unity AS product_weight_unity_46, t14.product_diameter AS product_diameter_47, t14.product_diameter_unity AS product_diameter_unity_48, t14.recommended_storage_limit_duration AS recommended_storage_limit_duration_49, t14.made_in AS made_in_50, t14.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_51, t14.product_id AS product_id_52, t14.product_attribute_id AS product_attribute_id_53, t54.id AS id_55, t54.brand AS brand_56, t54.commercial_reference AS commercial_reference_57, t54.quantity AS quantity_58, t54.gtin14 AS gtin14_59, t54.product_height AS product_height_60, t54.product_height_unity AS product_height_unity_61, t54.product_width AS product_width_62, t54.product_width_unity AS product_width_unity_63, t54.product_depth AS product_depth_64, t54.product_depth_unity AS product_depth_unity_65, t54.product_weight AS product_weight_66, t54.product_weight_unity AS product_weight_unity_67, t54.product_diameter AS product_diameter_68, t54.product_diameter_unity AS product_diameter_unity_69, t54.product_volume AS product_volume_70, t54.product_volume_unity AS product_volume_unity_71, t54.deposit AS deposit_72, t54.stacking_limit_count AS stacking_limit_count_73, t54.qc_type AS qc_type_74, t54.product_id AS product_id_75, t54.product_attribute_id AS product_attribute_id_76 FROM product t0 LEFT JOIN erpcommercial_data t14 ON t14.product_id = t0.id LEFT JOIN erplogistic_data t54 ON t54.product_id = t0.id ORDER BY t0.id ASC
Parameters:
[] |
|
50.62 ms (1.82%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4 FROM site t0
Parameters:
[] |
|
18.06 ms (0.65%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
7.97 ms (0.29%) |
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 FROM lang t0
Parameters:
[] |
|
1.03 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.date_add AS date_add_5, t0.date_upd AS date_upd_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.color AS color_9, t0.available_to AS available_to_10, t0.interface_lang_id AS interface_lang_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
102
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Lang |
|
| App\Entity\Product | No errors. |
| App\Entity\ProductLang | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\FeatureLang | No errors. |
| App\Entity\FeatureValue | No errors. |
| App\Entity\FeatureValueLang | No errors. |
| App\Entity\AttributeLang |
|
| App\Entity\AttributeValueLang | No errors. |
| App\Entity\AdvantageLang | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\ERPCommercialData |
|
| App\Entity\ProductAttribute | No errors. |
| App\Entity\ERPLogisticData |
|
| App\Entity\Image | No errors. |
| App\Entity\Advantage | No errors. |
| App\Entity\ERPCommercialDataLang |
|
| App\Entity\ImageLang | No errors. |