https://catalogue.lelorrain.fr/produits/154601

Query Metrics

6 Database Queries
6 Different statements
15.30 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 9.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.stock AS stock_5, t0.accessory AS accessory_6, t0.header AS header_7, t0.footer AS footer_8, t0.sub_type AS sub_type_9, t0.capacity AS capacity_10, t0.length AS length_11, t0.height AS height_12, t0.gas AS gas_13, t0.caliber AS caliber_14, t0.thickness AS thickness_15, t0.speed AS speed_16, t0.thread AS thread_17, t0.title AS title_18, t0.sub_title AS sub_title_19, t0.accessory_txt AS accessory_txt_20, t0.weight AS weight_21, t0.main_reference AS main_reference_22, t0.donnees_techniques AS donnees_techniques_23, t0.video_produit AS video_produit_24, t0.categorie1 AS categorie1_25, t0.categorie2 AS categorie2_26, t0.categorie3 AS categorie3_27, t0.derniere_categorie AS derniere_categorie_28, t0.graduation AS graduation_29, t0.in_port AS in_port_30, t0.out_port AS out_port_31, t0.bool_graduation AS bool_graduation_32, t0.bool_in_port AS bool_in_port_33, t0.bool_out_port AS bool_out_port_34, t0.flow_pressure AS flow_pressure_35, t0.maximum_pressure AS maximum_pressure_36, t0.drilling_thickness AS drilling_thickness_37, t0.pressure_in_bar AS pressure_in_bar_38, t0.accessory_type AS accessory_type_39, t0.drift_thickness AS drift_thickness_40, t0.gouging_thickness AS gouging_thickness_41, t0.speed_gl AS speed_gl_42, t0.sub_sub_type AS sub_sub_type_43, t0.created_at AS created_at_44, t0.slug AS slug_45, t0.categories_id AS categories_id_46, t0.answer1_id AS answer1_id_47, t0.answer2_id AS answer2_id_48, t0.answer3_id AS answer3_id_49, t0.answer4_id AS answer4_id_50, t0.answer5_id AS answer5_id_51, t0.answer6_id AS answer6_id_52 FROM products t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "154601"
]
2 0.65 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.reference_article AS reference_article_3, t0.designation AS designation_4, t0.nomenclature AS nomenclature_5, t0.famille AS famille_6, t0.prix_vente AS prix_vente_7, t0.date_creation AS date_creation_8, t0.classe_tarifaire AS classe_tarifaire_9 FROM tarifs t0 WHERE t0.reference_article = ?
Parameters:
[
  "154601"
]
3 2.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.stock AS stock_5, t0.accessory AS accessory_6, t0.header AS header_7, t0.footer AS footer_8, t0.sub_type AS sub_type_9, t0.capacity AS capacity_10, t0.length AS length_11, t0.height AS height_12, t0.gas AS gas_13, t0.caliber AS caliber_14, t0.thickness AS thickness_15, t0.speed AS speed_16, t0.thread AS thread_17, t0.title AS title_18, t0.sub_title AS sub_title_19, t0.accessory_txt AS accessory_txt_20, t0.weight AS weight_21, t0.main_reference AS main_reference_22, t0.donnees_techniques AS donnees_techniques_23, t0.video_produit AS video_produit_24, t0.categorie1 AS categorie1_25, t0.categorie2 AS categorie2_26, t0.categorie3 AS categorie3_27, t0.derniere_categorie AS derniere_categorie_28, t0.graduation AS graduation_29, t0.in_port AS in_port_30, t0.out_port AS out_port_31, t0.bool_graduation AS bool_graduation_32, t0.bool_in_port AS bool_in_port_33, t0.bool_out_port AS bool_out_port_34, t0.flow_pressure AS flow_pressure_35, t0.maximum_pressure AS maximum_pressure_36, t0.drilling_thickness AS drilling_thickness_37, t0.pressure_in_bar AS pressure_in_bar_38, t0.accessory_type AS accessory_type_39, t0.drift_thickness AS drift_thickness_40, t0.gouging_thickness AS gouging_thickness_41, t0.speed_gl AS speed_gl_42, t0.sub_sub_type AS sub_sub_type_43, t0.created_at AS created_at_44, t0.slug AS slug_45, t0.categories_id AS categories_id_46, t0.answer1_id AS answer1_id_47, t0.answer2_id AS answer2_id_48, t0.answer3_id AS answer3_id_49, t0.answer4_id AS answer4_id_50, t0.answer5_id AS answer5_id_51, t0.answer6_id AS answer6_id_52 FROM products t0 INNER JOIN products_products ON t0.id = products_products.products_source WHERE products_products.products_target = ?
Parameters:
[
  599
]
4 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.products_id AS products_id_3 FROM images t0 WHERE t0.products_id = ?
Parameters:
[
  599
]
5 1.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.stock AS stock_5, t0.accessory AS accessory_6, t0.header AS header_7, t0.footer AS footer_8, t0.sub_type AS sub_type_9, t0.capacity AS capacity_10, t0.length AS length_11, t0.height AS height_12, t0.gas AS gas_13, t0.caliber AS caliber_14, t0.thickness AS thickness_15, t0.speed AS speed_16, t0.thread AS thread_17, t0.title AS title_18, t0.sub_title AS sub_title_19, t0.accessory_txt AS accessory_txt_20, t0.weight AS weight_21, t0.main_reference AS main_reference_22, t0.donnees_techniques AS donnees_techniques_23, t0.video_produit AS video_produit_24, t0.categorie1 AS categorie1_25, t0.categorie2 AS categorie2_26, t0.categorie3 AS categorie3_27, t0.derniere_categorie AS derniere_categorie_28, t0.graduation AS graduation_29, t0.in_port AS in_port_30, t0.out_port AS out_port_31, t0.bool_graduation AS bool_graduation_32, t0.bool_in_port AS bool_in_port_33, t0.bool_out_port AS bool_out_port_34, t0.flow_pressure AS flow_pressure_35, t0.maximum_pressure AS maximum_pressure_36, t0.drilling_thickness AS drilling_thickness_37, t0.pressure_in_bar AS pressure_in_bar_38, t0.accessory_type AS accessory_type_39, t0.drift_thickness AS drift_thickness_40, t0.gouging_thickness AS gouging_thickness_41, t0.speed_gl AS speed_gl_42, t0.sub_sub_type AS sub_sub_type_43, t0.created_at AS created_at_44, t0.slug AS slug_45, t0.categories_id AS categories_id_46, t0.answer1_id AS answer1_id_47, t0.answer2_id AS answer2_id_48, t0.answer3_id AS answer3_id_49, t0.answer4_id AS answer4_id_50, t0.answer5_id AS answer5_id_51, t0.answer6_id AS answer6_id_52 FROM products t0 INNER JOIN products_linked ON t0.id = products_linked.products_target WHERE products_linked.products_source = ?
Parameters:
[
  599
]
6 1.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.stock AS stock_5, t0.accessory AS accessory_6, t0.header AS header_7, t0.footer AS footer_8, t0.sub_type AS sub_type_9, t0.capacity AS capacity_10, t0.length AS length_11, t0.height AS height_12, t0.gas AS gas_13, t0.caliber AS caliber_14, t0.thickness AS thickness_15, t0.speed AS speed_16, t0.thread AS thread_17, t0.title AS title_18, t0.sub_title AS sub_title_19, t0.accessory_txt AS accessory_txt_20, t0.weight AS weight_21, t0.main_reference AS main_reference_22, t0.donnees_techniques AS donnees_techniques_23, t0.video_produit AS video_produit_24, t0.categorie1 AS categorie1_25, t0.categorie2 AS categorie2_26, t0.categorie3 AS categorie3_27, t0.derniere_categorie AS derniere_categorie_28, t0.graduation AS graduation_29, t0.in_port AS in_port_30, t0.out_port AS out_port_31, t0.bool_graduation AS bool_graduation_32, t0.bool_in_port AS bool_in_port_33, t0.bool_out_port AS bool_out_port_34, t0.flow_pressure AS flow_pressure_35, t0.maximum_pressure AS maximum_pressure_36, t0.drilling_thickness AS drilling_thickness_37, t0.pressure_in_bar AS pressure_in_bar_38, t0.accessory_type AS accessory_type_39, t0.drift_thickness AS drift_thickness_40, t0.gouging_thickness AS gouging_thickness_41, t0.speed_gl AS speed_gl_42, t0.sub_sub_type AS sub_sub_type_43, t0.created_at AS created_at_44, t0.slug AS slug_45, t0.categories_id AS categories_id_46, t0.answer1_id AS answer1_id_47, t0.answer2_id AS answer2_id_48, t0.answer3_id AS answer3_id_49, t0.answer4_id AS answer4_id_50, t0.answer5_id AS answer5_id_51, t0.answer6_id AS answer6_id_52 FROM products t0 INNER JOIN products_products ON t0.id = products_products.products_target WHERE products_products.products_source = ?
Parameters:
[
  599
]

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\Products
  • The field App\Entity\Products#accessories_webapp_sources is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Products#accessories_webapp does not contain the required 'inversedBy="accessories_webapp_sources"' attribute.
App\Entity\Categories No errors.
App\Entity\Images No errors.
App\Entity\OrdersDetails No errors.
App\Entity\ProductAccessories No errors.
App\Entity\Tarifs No errors.