Query Metrics
7
Database Queries
7
Different statements
74.12 ms
Query time
6
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 27.67 ms |
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, t15.id AS id_16, t15.manufacturer AS manufacturer_17, t15.brand AS brand_18, t15.product_range AS product_range_19, t15.commercial_reference AS commercial_reference_20, t15.product_reference AS product_reference_21, t15.info_reference AS info_reference_22, t15.gtin13 AS gtin13_23, t15.date_tarif AS date_tarif_24, t15.price_without_tax AS price_without_tax_25, t15.distributor_price_without_tax AS distributor_price_without_tax_26, t15.currency AS currency_27, t15.vat AS vat_28, t15.quantity AS quantity_29, t15.base_reference_unit AS base_reference_unit_30, t15.minimal_order_quantity AS minimal_order_quantity_31, t15.multiple_per_order AS multiple_per_order_32, t15.packaging_qty_min AS packaging_qty_min_33, t15.manufacturer_stored_product AS manufacturer_stored_product_34, t15.delivery_delay AS delivery_delay_35, t15.electronic_data_interchange AS electronic_data_interchange_36, t15.warranty_duration AS warranty_duration_37, t15.reference_status AS reference_status_38, t15.taric AS taric_39, t15.product_height AS product_height_40, t15.product_height_unity AS product_height_unity_41, t15.product_width AS product_width_42, t15.product_width_unity AS product_width_unity_43, t15.product_depth AS product_depth_44, t15.product_depth_unity AS product_depth_unity_45, t15.product_weight AS product_weight_46, t15.product_weight_unity AS product_weight_unity_47, t15.product_diameter AS product_diameter_48, t15.product_diameter_unity AS product_diameter_unity_49, t15.recommended_storage_limit_duration AS recommended_storage_limit_duration_50, t15.made_in AS made_in_51, t15.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_52, t15.product_id AS product_id_53, t15.product_attribute_id AS product_attribute_id_54, t55.id AS id_56, t55.brand AS brand_57, t55.commercial_reference AS commercial_reference_58, t55.quantity AS quantity_59, t55.gtin14 AS gtin14_60, t55.product_height AS product_height_61, t55.product_height_unity AS product_height_unity_62, t55.product_width AS product_width_63, t55.product_width_unity AS product_width_unity_64, t55.product_depth AS product_depth_65, t55.product_depth_unity AS product_depth_unity_66, t55.product_weight AS product_weight_67, t55.product_weight_unity AS product_weight_unity_68, t55.product_diameter AS product_diameter_69, t55.product_diameter_unity AS product_diameter_unity_70, t55.product_volume AS product_volume_71, t55.product_volume_unity AS product_volume_unity_72, t55.deposit AS deposit_73, t55.stacking_limit_count AS stacking_limit_count_74, t55.qc_type AS qc_type_75, t55.product_id AS product_id_76, t55.product_attribute_id AS product_attribute_id_77 FROM product t0 LEFT JOIN erpcommercial_data t15 ON t15.product_id = t0.id LEFT JOIN erplogistic_data t55 ON t55.product_id = t0.id WHERE t0.is_nc = ?
Parameters:
[
1
]
|
2 | 9.10 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.interface_lang_id AS interface_lang_id_20, t8.lang_in_charge_id AS lang_in_charge_id_21 FROM lang t0 LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id
Parameters:
[] |
3 | 13.98 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.product_id = ?
Parameters:
[
9
]
|
4 | 4.79 ms |
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 | 5.03 ms |
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.id = ?
Parameters:
[
2
]
|
6 | 8.28 ms |
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
]
|
7 | 5.28 ms |
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
]
|
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\Product |
|
App\Entity\Brand | No errors. |
App\Entity\ERPCommercialData |
|
App\Entity\ProductAttribute | No errors. |
App\Entity\ERPLogisticData |
|
App\Entity\ProductLang | No errors. |
App\Entity\ProductWebToPrintLang | No errors. |
App\Entity\Image | No errors. |
App\Entity\FeatureValue | No errors. |
App\Entity\Advantage | No errors. |
App\Entity\File | No errors. |
App\Entity\ERPCommercialDataLang |
|
App\Entity\Lang |
|
App\Entity\User | No errors. |
App\Entity\Site | No errors. |
App\Entity\FeatureLang | No errors. |
App\Entity\FeatureValueLang | No errors. |
App\Entity\AttributeLang |
|
App\Entity\AttributeValueLang | No errors. |
App\Entity\AdvantageLang | No errors. |
App\Entity\PolicyLang | No errors. |
App\Entity\ImageLang | No errors. |