Symfony Profiler

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

Query Metrics

SELECT p0_.id AS id_0, p0_.required_products_for_free AS required_products_for_free_1, p0_.number_good_free AS number_good_free_2, p0_.unite AS unite_3, p0_.unity_free AS unity_free_4, p0_.date AS date_5, p0_.date_fin AS date_fin_6, p0_.status AS status_7, g1_.id AS id_8, g1_.brand AS brand_9, g1_.pricectns AS pricectns_10, g1_.pricebox AS pricebox_11, g1_.pricebottle AS pricebottle_12, g1_.priceitem AS priceitem_13, g1_.pricesac AS pricesac_14, g2_.id AS id_15, g2_.brand AS brand_16, g2_.pricectns AS pricectns_17, g2_.pricebox AS pricebox_18, g2_.pricebottle AS pricebottle_19, g2_.priceitem AS priceitem_20, g2_.pricesac AS pricesac_21, p0_.good_id AS good_id_22, p0_.good_free_id AS good_free_id_23 FROM promotion p0_ LEFT JOIN goods g1_ ON p0_.good_id = g1_.id LEFT JOIN goods g2_ ON p0_.good_free_id = g2_.id WHERE p0_.status = 1 AND (p0_.date_fin IS NULL OR p0_.date <= CURRENT_TIMESTAMP) ORDER BY p0_.date DESC

[]

SELECT
  p0_.id AS id_0,
  p0_.required_products_for_free AS required_products_for_free_1,
  p0_.number_good_free AS number_good_free_2,
  p0_.unite AS unite_3,
  p0_.unity_free AS unity_free_4,
  p0_.date AS date_5,
  p0_.date_fin AS date_fin_6,
  p0_.status AS status_7,
  g1_.id AS id_8,
  g1_.brand AS brand_9,
  g1_.pricectns AS pricectns_10,
  g1_.pricebox AS pricebox_11,
  g1_.pricebottle AS pricebottle_12,
  g1_.priceitem AS priceitem_13,
  g1_.pricesac AS pricesac_14,
  g2_.id AS id_15,
  g2_.brand AS brand_16,
  g2_.pricectns AS pricectns_17,
  g2_.pricebox AS pricebox_18,
  g2_.pricebottle AS pricebottle_19,
  g2_.priceitem AS priceitem_20,
  g2_.pricesac AS pricesac_21,
  p0_.good_id AS good_id_22,
  p0_.good_free_id AS good_free_id_23
FROM
  promotion p0_
  LEFT JOIN goods g1_ ON p0_.good_id = g1_.id
  LEFT JOIN goods g2_ ON p0_.good_free_id = g2_.id
WHERE
  p0_.status = 1
  AND (
    p0_.date_fin IS NULL
    OR p0_.date <= CURRENT_TIMESTAMP
  )
ORDER BY
  p0_.date DESC

SELECT p0_.id AS id_0, p0_.required_products_for_free AS required_products_for_free_1, p0_.number_good_free AS number_good_free_2, p0_.unite AS unite_3, p0_.unity_free AS unity_free_4, p0_.date AS date_5, p0_.date_fin AS date_fin_6, p0_.status AS status_7, g1_.id AS id_8, g1_.brand AS brand_9, g1_.pricectns AS pricectns_10, g1_.pricebox AS pricebox_11, g1_.pricebottle AS pricebottle_12, g1_.priceitem AS priceitem_13, g1_.pricesac AS pricesac_14, g2_.id AS id_15, g2_.brand AS brand_16, g2_.pricectns AS pricectns_17, g2_.pricebox AS pricebox_18, g2_.pricebottle AS pricebottle_19, g2_.priceitem AS priceitem_20, g2_.pricesac AS pricesac_21, p0_.good_id AS good_id_22, p0_.good_free_id AS good_free_id_23 FROM promotion p0_ LEFT JOIN goods g1_ ON p0_.good_id = g1_.id LEFT JOIN goods g2_ ON p0_.good_free_id = g2_.id WHERE p0_.status = 1 AND (p0_.date_fin IS NULL OR p0_.date <= CURRENT_TIMESTAMP) ORDER BY p0_.date DESC;