Symfony Profiler

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 = '/' LIMIT 1;

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 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
LIMIT
  10

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 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 10:09:38' ORDER BY o1_.creation_date DESC LIMIT 10;

SELECT
  o0_.id AS id_0,
  o0_.logo AS logo_1,
  o0_.name AS name_2,
  o0_.created_at AS created_at_3,
  o0_.refrer_code AS refrer_code_4,
  o0_.facebook_link AS facebook_link_5,
  o0_.youtube_link AS youtube_link_6,
  o0_.instagram_link AS instagram_link_7,
  o0_.linkedin_link AS linkedin_link_8,
  o0_.visits_count AS visits_count_9,
  o0_.latitude AS latitude_10,
  o0_.longitude AS longitude_11,
  o0_.subscription_status AS subscription_status_12,
  o0_.email AS email_13,
  o0_.gain AS gain_14,
  o0_.total_members AS total_members_15,
  o0_.monetizing_enabled AS monetizing_enabled_16,
  o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17,
  o0_.description AS description_18,
  o0_.password AS password_19,
  o0_.subscribers_count AS subscribers_count_20,
  o0_.type AS type_21,
  o0_.address AS address_22,
  o0_.phone AS phone_23,
  o0_.whatsapp_phone AS whatsapp_phone_24,
  o0_.is_enabled AS is_enabled_25,
  o0_.can_create_coupon AS can_create_coupon_26,
  o0_.can_receive_partnership_request AS can_receive_partnership_request_27,
  o0_.website_link AS website_link_28,
  o0_.can_receive_agreements AS can_receive_agreements_29,
  o0_.can_send_agreements AS can_send_agreements_30,
  o0_.slug AS slug_31,
  o0_.devis_enabled AS devis_enabled_32,
  o0_.is_managed_in_house AS is_managed_in_house_33,
  o0_.is_slug_manuel AS is_slug_manuel_34,
  o0_.use_calendar AS use_calendar_35,
  o0_.params AS params_36,
  o0_.sector_id AS sector_id_37,
  o0_.city_id AS city_id_38,
  o0_.subscription_id AS subscription_id_39
FROM
  organization o0_
WHERE
  o0_.is_enabled = 1
ORDER BY
  o0_.created_at DESC
LIMIT
  10

SELECT o0_.id AS id_0, o0_.logo AS logo_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.refrer_code AS refrer_code_4, o0_.facebook_link AS facebook_link_5, o0_.youtube_link AS youtube_link_6, o0_.instagram_link AS instagram_link_7, o0_.linkedin_link AS linkedin_link_8, o0_.visits_count AS visits_count_9, o0_.latitude AS latitude_10, o0_.longitude AS longitude_11, o0_.subscription_status AS subscription_status_12, o0_.email AS email_13, o0_.gain AS gain_14, o0_.total_members AS total_members_15, o0_.monetizing_enabled AS monetizing_enabled_16, o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17, o0_.description AS description_18, o0_.password AS password_19, o0_.subscribers_count AS subscribers_count_20, o0_.type AS type_21, o0_.address AS address_22, o0_.phone AS phone_23, o0_.whatsapp_phone AS whatsapp_phone_24, o0_.is_enabled AS is_enabled_25, o0_.can_create_coupon AS can_create_coupon_26, o0_.can_receive_partnership_request AS can_receive_partnership_request_27, o0_.website_link AS website_link_28, o0_.can_receive_agreements AS can_receive_agreements_29, o0_.can_send_agreements AS can_send_agreements_30, o0_.slug AS slug_31, o0_.devis_enabled AS devis_enabled_32, o0_.is_managed_in_house AS is_managed_in_house_33, o0_.is_slug_manuel AS is_slug_manuel_34, o0_.use_calendar AS use_calendar_35, o0_.params AS params_36, o0_.sector_id AS sector_id_37, o0_.city_id AS city_id_38, o0_.subscription_id AS subscription_id_39 FROM organization o0_ WHERE o0_.is_enabled = 1 ORDER BY o0_.created_at DESC LIMIT 10;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (parent_id = ?)
  AND (rg.status = ?)
ORDER BY
  rgd.priority DESC

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (parent_id = 1) AND (rg.status = 1) ORDER BY rgd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = 1)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (rt.value = ?)
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'request_uri') AND (r.status = 1) AND (rt.value = '/') ORDER BY rd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = 1)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (
    (
      CHAR_LENGTH(
        TRIM(rt.value)
      ) > 0
    )
    AND (
      ? LIKE CONCAT(
        TRIM(rt.value),
        '%'
      )
    )
  )
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'request_uri_prefix') AND (r.status = 1) AND ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND ('/' LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = 1)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (rt.value = ?)
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'path_info') AND (r.status = 1) AND (rt.value = '/') ORDER BY rd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = 1)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (
    (
      CHAR_LENGTH(
        TRIM(rt.value)
      ) > 0
    )
    AND (
      ? LIKE CONCAT(
        TRIM(rt.value),
        '%'
      )
    )
  )
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'path_info_prefix') AND (r.status = 1) AND ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND ('/' LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = 1)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (rt.value = ?)
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'route') AND (r.status = 1) AND (rt.value = 'public_home') ORDER BY rd.priority DESC;

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = 1)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (
    (
      CHAR_LENGTH(
        TRIM(rt.value)
      ) > 0
    )
    AND (
      ? LIKE CONCAT(
        TRIM(rt.value),
        '%'
      )
    )
  )
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'route_prefix') AND (r.status = 1) AND ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND ('public_home' LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC;