Symfony Profiler

SELECT
  s0_.identifier AS identifier_0,
  s0_.type AS type_1,
  s0_.label AS label_2,
  s0_.value AS value_3,
  s0_.id AS id_4,
  s0_.uuid AS uuid_5,
  s0_.created AS created_6,
  s0_.modified AS modified_7
FROM
  system_config s0_

SELECT s0_.identifier AS identifier_0, s0_.type AS type_1, s0_.label AS label_2, s0_.value AS value_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM system_config s0_;

SELECT
  s0_.name AS name_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.import_matches AS import_matches_3,
  s0_.id AS id_4,
  s0_.uuid AS uuid_5,
  s0_.created AS created_6,
  s0_.modified AS modified_7
FROM
  services_service s0_
ORDER BY
  s0_.name ASC

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ ORDER BY s0_.name ASC;

SELECT
  s0_.name AS name_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.import_matches AS import_matches_3,
  s0_.id AS id_4,
  s0_.uuid AS uuid_5,
  s0_.created AS created_6,
  s0_.modified AS modified_7
FROM
  services_service s0_
WHERE
  s0_.slug = ?
LIMIT
  1

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ WHERE s0_.slug = 'close-protection-operatives' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_21
    FROM
      (
        SELECT
          l0_.reference AS reference_0,
          l0_.legacy_reference AS legacy_reference_1,
          l0_.is_published AS is_published_2,
          l0_.is_pending AS is_pending_3,
          l0_.title AS title_4,
          l0_.summary AS summary_5,
          l0_.address1 AS address1_6,
          l0_.address2 AS address2_7,
          l0_.city AS city_8,
          l0_.region AS region_9,
          l0_.postcode AS postcode_10,
          l0_.country AS country_11,
          l0_.website AS website_12,
          l0_.contact_name AS contact_name_13,
          l0_.primary_number AS primary_number_14,
          l0_.secondary_number AS secondary_number_15,
          l0_.tertiary_number AS tertiary_number_16,
          l0_.email AS email_17,
          l0_.latitude AS latitude_18,
          l0_.longitude AS longitude_19,
          l0_.legacy_listing AS legacy_listing_20,
          l0_.id AS id_21,
          l0_.uuid AS uuid_22,
          l0_.created AS created_23,
          l0_.modified AS modified_24
        FROM
          listings_listing l0_
          LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id
          LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id
        WHERE
          l0_.is_published = ?
          AND l0_.country = ?
          AND s1_.id = ?
        ORDER BY
          l0_.created DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_21 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = 1 AND l0_.country = 'GB' AND s1_.id = 6 ORDER BY l0_.created DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_21
FROM
  (
    SELECT
      DISTINCT id_21,
      created_23
    FROM
      (
        SELECT
          l0_.reference AS reference_0,
          l0_.legacy_reference AS legacy_reference_1,
          l0_.is_published AS is_published_2,
          l0_.is_pending AS is_pending_3,
          l0_.title AS title_4,
          l0_.summary AS summary_5,
          l0_.address1 AS address1_6,
          l0_.address2 AS address2_7,
          l0_.city AS city_8,
          l0_.region AS region_9,
          l0_.postcode AS postcode_10,
          l0_.country AS country_11,
          l0_.website AS website_12,
          l0_.contact_name AS contact_name_13,
          l0_.primary_number AS primary_number_14,
          l0_.secondary_number AS secondary_number_15,
          l0_.tertiary_number AS tertiary_number_16,
          l0_.email AS email_17,
          l0_.latitude AS latitude_18,
          l0_.longitude AS longitude_19,
          l0_.legacy_listing AS legacy_listing_20,
          l0_.id AS id_21,
          l0_.uuid AS uuid_22,
          l0_.created AS created_23,
          l0_.modified AS modified_24,
          s1_.name AS name_25,
          s1_.slug AS slug_26,
          s1_.description AS description_27,
          s1_.import_matches AS import_matches_28,
          s1_.id AS id_29,
          s1_.uuid AS uuid_30,
          s1_.created AS created_31,
          s1_.modified AS modified_32
        FROM
          listings_listing l0_
          LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id
          LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id
        WHERE
          l0_.is_published = ?
          AND l0_.country = ?
          AND s1_.id = ?
      ) dctrn_result_inner
    ORDER BY
      created_23 DESC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_21 FROM (SELECT DISTINCT id_21, created_23 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24, s1_.name AS name_25, s1_.slug AS slug_26, s1_.description AS description_27, s1_.import_matches AS import_matches_28, s1_.id AS id_29, s1_.uuid AS uuid_30, s1_.created AS created_31, s1_.modified AS modified_32 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = 1 AND l0_.country = 'GB' AND s1_.id = 6) dctrn_result_inner ORDER BY created_23 DESC) dctrn_result LIMIT 50;

SELECT
  l0_.start_date AS start_date_0,
  l0_.end_date AS end_date_1,
  l0_.type AS type_2,
  l0_.duration AS duration_3,
  l0_.country AS country_4,
  l0_.id AS id_5,
  l0_.uuid AS uuid_6,
  l0_.created AS created_7,
  l0_.modified AS modified_8,
  l0_.listing_id AS listing_id_9,
  l0_.service_id AS service_id_10
FROM
  listings_upgrade l0_
WHERE
  l0_.type = ?
  AND l0_.country = ?
  AND l0_.service_id = ?
  AND l0_.start_date <= ?
  AND l0_.end_date >= ?

SELECT l0_.start_date AS start_date_0, l0_.end_date AS end_date_1, l0_.type AS type_2, l0_.duration AS duration_3, l0_.country AS country_4, l0_.id AS id_5, l0_.uuid AS uuid_6, l0_.created AS created_7, l0_.modified AS modified_8, l0_.listing_id AS listing_id_9, l0_.service_id AS service_id_10 FROM listings_upgrade l0_ WHERE l0_.type = 'premium' AND l0_.country = 'GB' AND l0_.service_id = 6 AND l0_.start_date <= '2025-12-27 12:37:42' AND l0_.end_date >= '2025-12-27 12:37:42';