Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 51
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Migrations 13
• Debug
• Messages
• Emails
• EasyAdmin
• Netgen Layouts
• Configuration

Query Metrics

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.status AS status_2 FROM offer_org o0_ INNER JOIN offer o1_ ON o0_.offer_id = o1_.id INNER JOIN organization o2_ ON o0_.org_id = o2_.id LEFT JOIN organization o3_ ON o1_.from_org_id = o3_.id LEFT JOIN tag_offer t5_ ON o1_.id = t5_.offer_id LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id WHERE o1_.validity_date > ? ORDER BY o1_.creation_date DESC) dctrn_result) dctrn_table

[
  "2024-09-28 12:09:34"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.creation_date AS creation_date_1,
          o0_.status AS status_2
        FROM
          offer_org o0_
          INNER JOIN offer o1_ ON o0_.offer_id = o1_.id
          INNER JOIN organization o2_ ON o0_.org_id = o2_.id
          LEFT JOIN organization o3_ ON o1_.from_org_id = o3_.id
          LEFT JOIN tag_offer t5_ ON o1_.id = t5_.offer_id
          LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id
        WHERE
          o1_.validity_date > ?
        ORDER BY
          o1_.creation_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.status AS status_2 FROM offer_org o0_ INNER JOIN offer o1_ ON o0_.offer_id = o1_.id INNER JOIN organization o2_ ON o0_.org_id = o2_.id LEFT JOIN organization o3_ ON o1_.from_org_id = o3_.id LEFT JOIN tag_offer t5_ ON o1_.id = t5_.offer_id LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id WHERE o1_.validity_date > '2024-09-28 12:09:34' ORDER BY o1_.creation_date DESC) dctrn_result) dctrn_table;

SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.status AS status_2, o0_.org_id AS org_id_3, o0_.offer_id AS offer_id_4 FROM offer_org o0_ INNER JOIN organization o1_ ON o0_.org_id = o1_.id INNER JOIN offer o2_ ON o0_.offer_id = o2_.id WHERE o1_.id IN (2) AND o2_.validity_date > ? AND (o2_.next_time_type IS NULL OR o2_.next_time_type = 0)

[
  "2024-09-28 12:09:34"
]

SELECT
  o0_.id AS id_0,
  o0_.creation_date AS creation_date_1,
  o0_.status AS status_2,
  o0_.org_id AS org_id_3,
  o0_.offer_id AS offer_id_4
FROM
  offer_org o0_
  INNER JOIN organization o1_ ON o0_.org_id = o1_.id
  INNER JOIN offer o2_ ON o0_.offer_id = o2_.id
WHERE
  o1_.id IN (2)
  AND o2_.validity_date > ?
  AND (
    o2_.next_time_type IS NULL
    OR o2_.next_time_type = 0
  )

SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.status AS status_2, o0_.org_id AS org_id_3, o0_.offer_id AS offer_id_4 FROM offer_org o0_ INNER JOIN organization o1_ ON o0_.org_id = o1_.id INNER JOIN offer o2_ ON o0_.offer_id = o2_.id WHERE o1_.id IN (2) AND o2_.validity_date > '2024-09-28 12:09:34' AND (o2_.next_time_type IS NULL OR o2_.next_time_type = 0);

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, creation_date_5 FROM (SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.status AS status_2, o1_.id AS id_3, o1_.total_coupons AS total_coupons_4, o1_.creation_date AS creation_date_5, o1_.discount AS discount_6, o1_.discount_type AS discount_type_7, o1_.validity_date AS validity_date_8, o1_.validity_days AS validity_days_9, o1_.picture AS picture_10, o1_.conditions AS conditions_11, o1_.promotion_code AS promotion_code_12, o1_.all_cities AS all_cities_13, o1_.group_id AS group_id_14, o1_.status AS status_15, o1_.auto_send AS auto_send_16, o1_.next_time_type AS next_time_type_17 FROM offer_org o0_ INNER JOIN offer o1_ ON o0_.offer_id = o1_.id INNER JOIN organization o2_ ON o0_.org_id = o2_.id LEFT JOIN organization o3_ ON o1_.from_org_id = o3_.id LEFT JOIN tag_offer t5_ ON o1_.id = t5_.offer_id LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id WHERE o1_.validity_date > ?) dctrn_result_inner ORDER BY creation_date_5 DESC) dctrn_result LIMIT 20

[
  "2024-09-28 12:09:34"
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      creation_date_5
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.creation_date AS creation_date_1,
          o0_.status AS status_2,
          o1_.id AS id_3,
          o1_.total_coupons AS total_coupons_4,
          o1_.creation_date AS creation_date_5,
          o1_.discount AS discount_6,
          o1_.discount_type AS discount_type_7,
          o1_.validity_date AS validity_date_8,
          o1_.validity_days AS validity_days_9,
          o1_.picture AS picture_10,
          o1_.conditions AS conditions_11,
          o1_.promotion_code AS promotion_code_12,
          o1_.all_cities AS all_cities_13,
          o1_.group_id AS group_id_14,
          o1_.status AS status_15,
          o1_.auto_send AS auto_send_16,
          o1_.next_time_type AS next_time_type_17
        FROM
          offer_org o0_
          INNER JOIN offer o1_ ON o0_.offer_id = o1_.id
          INNER JOIN organization o2_ ON o0_.org_id = o2_.id
          LEFT JOIN organization o3_ ON o1_.from_org_id = o3_.id
          LEFT JOIN tag_offer t5_ ON o1_.id = t5_.offer_id
          LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id
        WHERE
          o1_.validity_date > ?
      ) dctrn_result_inner
    ORDER BY
      creation_date_5 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, creation_date_5 FROM (SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.status AS status_2, o1_.id AS id_3, o1_.total_coupons AS total_coupons_4, o1_.creation_date AS creation_date_5, o1_.discount AS discount_6, o1_.discount_type AS discount_type_7, o1_.validity_date AS validity_date_8, o1_.validity_days AS validity_days_9, o1_.picture AS picture_10, o1_.conditions AS conditions_11, o1_.promotion_code AS promotion_code_12, o1_.all_cities AS all_cities_13, o1_.group_id AS group_id_14, o1_.status AS status_15, o1_.auto_send AS auto_send_16, o1_.next_time_type AS next_time_type_17 FROM offer_org o0_ INNER JOIN offer o1_ ON o0_.offer_id = o1_.id INNER JOIN organization o2_ ON o0_.org_id = o2_.id LEFT JOIN organization o3_ ON o1_.from_org_id = o3_.id LEFT JOIN tag_offer t5_ ON o1_.id = t5_.offer_id LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id WHERE o1_.validity_date > '2024-09-28 12:09:34') dctrn_result_inner ORDER BY creation_date_5 DESC) dctrn_result LIMIT 20;

SELECT t0.id AS id_1, t0.source_route AS source_route_2, t0.target_route AS target_route_3, t0.creation_date AS creation_date_4 FROM redirections t0 WHERE t0.source_route = ? LIMIT 1

[
  "/coupons"
]

SELECT
  t0.id AS id_1,
  t0.source_route AS source_route_2,
  t0.target_route AS target_route_3,
  t0.creation_date AS creation_date_4
FROM
  redirections t0
WHERE
  t0.source_route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.source_route AS source_route_2, t0.target_route AS target_route_3, t0.creation_date AS creation_date_4 FROM redirections t0 WHERE t0.source_route = '/coupons' LIMIT 1;