Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 15
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, p3_.level AS level_30, c4_.id AS id_31, c4_.name AS name_32, c4_.displayed_order AS displayed_order_33, c4_.is_in_footer AS is_in_footer_34, c4_.slug AS slug_35, p5_.id AS id_36, p5_.price_ht AS price_ht_37, p5_.price_ttc AS price_ttc_38, p5_.discount AS discount_39, p6_.id AS id_40, p6_.min AS min_41, p6_.max AS max_42, p6_.codelot AS codelot_43, c7_.id AS id_44, c7_.name AS name_45, c7_.name_display AS name_display_46, c7_.is_visible_btob AS is_visible_btob_47, c7_.is_referencement AS is_referencement_48, p1_.price_id AS price_id_49, p1_.product_id AS product_id_50, p3_.product_id AS product_id_51, p3_.category_id AS category_id_52, c4_.category_parent_id AS category_parent_id_53, p5_.product_id AS product_id_54, p6_.customer_catalog_id AS customer_catalog_id_55, p6_.product_id AS product_id_56 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p3_ ON p0_.id = p3_.product_id LEFT JOIN category c4_ ON p3_.category_id = c4_.id LEFT JOIN promotion p5_ ON p0_.id = p5_.product_id LEFT JOIN product_catalog p6_ ON p0_.id = p6_.product_id LEFT JOIN customer_catalog c7_ ON p6_.customer_catalog_id = c7_.id WHERE p0_.id = ?

[
  421243
]

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.manufacturer AS manufacturer_2,
  p0_.short_label AS short_label_3,
  p0_.long_label AS long_label_4,
  p0_.weight AS weight_5,
  p0_.sold_by AS sold_by_6,
  p0_.ppht AS ppht_7,
  p0_.ppttc AS ppttc_8,
  p0_.paht AS paht_9,
  p0_.pattc AS pattc_10,
  p0_.legal_discount_library AS legal_discount_library_11,
  p0_.fidelity_bonus AS fidelity_bonus_12,
  p0_.brand AS brand_13,
  p0_.time_limit AS time_limit_14,
  p0_.coef AS coef_15,
  p0_.is_discountable AS is_discountable_16,
  p0_.is_btob AS is_btob_17,
  p0_.is_btoc AS is_btoc_18,
  p0_.is_customizable AS is_customizable_19,
  p0_.is_library AS is_library_20,
  p0_.is_nathan AS is_nathan_21,
  p0_.is_green AS is_green_22,
  p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23,
  p0_.is_active AS is_active_24,
  p0_.slug AS slug_25,
  p1_.id AS id_26,
  p1_.price_ht AS price_ht_27,
  p1_.price_ttc AS price_ttc_28,
  p2_.id AS id_29,
  p3_.level AS level_30,
  c4_.id AS id_31,
  c4_.name AS name_32,
  c4_.displayed_order AS displayed_order_33,
  c4_.is_in_footer AS is_in_footer_34,
  c4_.slug AS slug_35,
  p5_.id AS id_36,
  p5_.price_ht AS price_ht_37,
  p5_.price_ttc AS price_ttc_38,
  p5_.discount AS discount_39,
  p6_.id AS id_40,
  p6_.min AS min_41,
  p6_.max AS max_42,
  p6_.codelot AS codelot_43,
  c7_.id AS id_44,
  c7_.name AS name_45,
  c7_.name_display AS name_display_46,
  c7_.is_visible_btob AS is_visible_btob_47,
  c7_.is_referencement AS is_referencement_48,
  p1_.price_id AS price_id_49,
  p1_.product_id AS product_id_50,
  p3_.product_id AS product_id_51,
  p3_.category_id AS category_id_52,
  c4_.category_parent_id AS category_parent_id_53,
  p5_.product_id AS product_id_54,
  p6_.customer_catalog_id AS customer_catalog_id_55,
  p6_.product_id AS product_id_56
FROM
  product p0_
  LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id
  LEFT JOIN price p2_ ON p1_.price_id = p2_.id
  LEFT JOIN product_category p3_ ON p0_.id = p3_.product_id
  LEFT JOIN category c4_ ON p3_.category_id = c4_.id
  LEFT JOIN promotion p5_ ON p0_.id = p5_.product_id
  LEFT JOIN product_catalog p6_ ON p0_.id = p6_.product_id
  LEFT JOIN customer_catalog c7_ ON p6_.customer_catalog_id = c7_.id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, p3_.level AS level_30, c4_.id AS id_31, c4_.name AS name_32, c4_.displayed_order AS displayed_order_33, c4_.is_in_footer AS is_in_footer_34, c4_.slug AS slug_35, p5_.id AS id_36, p5_.price_ht AS price_ht_37, p5_.price_ttc AS price_ttc_38, p5_.discount AS discount_39, p6_.id AS id_40, p6_.min AS min_41, p6_.max AS max_42, p6_.codelot AS codelot_43, c7_.id AS id_44, c7_.name AS name_45, c7_.name_display AS name_display_46, c7_.is_visible_btob AS is_visible_btob_47, c7_.is_referencement AS is_referencement_48, p1_.price_id AS price_id_49, p1_.product_id AS product_id_50, p3_.product_id AS product_id_51, p3_.category_id AS category_id_52, c4_.category_parent_id AS category_parent_id_53, p5_.product_id AS product_id_54, p6_.customer_catalog_id AS customer_catalog_id_55, p6_.product_id AS product_id_56 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p3_ ON p0_.id = p3_.product_id LEFT JOIN category c4_ ON p3_.category_id = c4_.id LEFT JOIN promotion p5_ ON p0_.id = p5_.product_id LEFT JOIN product_catalog p6_ ON p0_.id = p6_.product_id LEFT JOIN customer_catalog c7_ ON p6_.customer_catalog_id = c7_.id WHERE p0_.id = 421243;