Symfony Profiler

SELECT
  c.id as category_id,
  COUNT(
    DISTINCT CASE WHEN l.id IS NOT NULL
    AND u.id IS NOT NULL THEN
      l.id
    ELSE
      NULL
    END
  ) as count
FROM
  category c
  LEFT JOIN listing l ON l.category_id = c.id
  AND l.is_active = 1
  LEFT JOIN user u ON l.owner_id = u.id
  AND u.is_active = 1
  LEFT JOIN price_type pt ON l.price_type_id = pt.id
  LEFT JOIN listing_type lt ON l.listing_type_id = lt.id
GROUP BY
  c.id

SELECT c.id as category_id,
                COUNT(DISTINCT CASE WHEN l.id IS NOT NULL AND u.id IS NOT NULL  THEN l.id ELSE NULL END) as count FROM category c LEFT JOIN listing l ON l.category_id = c.id AND l.is_active = 1 LEFT JOIN user u ON l.owner_id = u.id AND u.is_active = 1 LEFT JOIN price_type pt ON l.price_type_id = pt.id LEFT JOIN listing_type lt ON l.listing_type_id = lt.id GROUP BY c.id;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.is_value AS is_value_2,
  COUNT(l1_.id) AS sclr_3
FROM
  price_type p0_
  INNER JOIN listing l1_ ON p0_.id = l1_.price_type_id
GROUP BY
  p0_.id

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_value AS is_value_2, COUNT(l1_.id) AS sclr_3 FROM price_type p0_ INNER JOIN listing l1_ ON p0_.id = l1_.price_type_id GROUP BY p0_.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.label AS label_5,
  t0.sort_order AS sort_order_6,
  t0.parent_id AS parent_id_7,
  t0.form_id AS form_id_8
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.parent_id = 1001;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.parent_id AS sclr_3
FROM
  category c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS sclr_3 FROM category c0_ ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.is_primary AS is_primary_3,
  t0.url AS url_4,
  t0.sort_order AS sort_order_5,
  t0.original_name AS original_name_6,
  t0.listing_id AS listing_id_7
FROM
  listing_image t0
WHERE
  t0.listing_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_primary AS is_primary_3, t0.url AS url_4, t0.sort_order AS sort_order_5, t0.original_name AS original_name_6, t0.listing_id AS listing_id_7 FROM listing_image t0 WHERE t0.listing_id = 3224843 ORDER BY t0.sort_order ASC;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2,
  l0_.description AS description_3,
  l0_.price AS price_4,
  l0_.is_active AS is_active_5,
  l0_.fields AS fields_6,
  l0_.latitude AS latitude_7,
  l0_.longitude AS longitude_8,
  l0_.lookup AS lookup_9,
  l0_.is_business AS is_business_10,
  l0_.url AS url_11,
  l0_.phone_number AS phone_number_12,
  l0_.condition_rating AS condition_rating_13,
  l0_.media_url AS media_url_14,
  l0_.created_at AS created_at_15,
  l0_.updated_at AS updated_at_16,
  u1_.id AS id_17,
  u1_.email AS email_18,
  u1_.slug AS slug_19,
  u1_.roles AS roles_20,
  u1_.password AS password_21,
  u1_.forsalebyowner_user_id AS forsalebyowner_user_id_22,
  u1_.first_name AS first_name_23,
  u1_.last_name AS last_name_24,
  u1_.user_name AS user_name_25,
  u1_.phone AS phone_26,
  u1_.created_at AS created_at_27,
  u1_.google_id AS google_id_28,
  u1_.avatar AS avatar_29,
  u1_.tagline AS tagline_30,
  u1_.is_active AS is_active_31,
  u1_.confirmation_token AS confirmation_token_32,
  u1_.confirmation_token_expires_at AS confirmation_token_expires_at_33,
  u1_.promo_code AS promo_code_34,
  u1_.show_phone_in_brochure AS show_phone_in_brochure_35,
  u1_.default_search_view AS default_search_view_36,
  u1_.description AS description_37,
  u1_.website_address AS website_address_38,
  u1_.allow_non_verified AS allow_non_verified_39,
  u1_.latitude AS latitude_40,
  u1_.longitude AS longitude_41,
  u1_.address AS address_42,
  u1_.show_address_in_brochure AS show_address_in_brochure_43,
  c2_.id AS id_44,
  c2_.name AS name_45,
  c2_.slug AS slug_46,
  c2_.is_active AS is_active_47,
  c2_.label AS label_48,
  c2_.sort_order AS sort_order_49,
  l0_.owner_id AS owner_id_50,
  l0_.category_id AS category_id_51,
  l0_.location_id AS location_id_52,
  l0_.listing_type_id AS listing_type_id_53,
  l0_.offer_type_id AS offer_type_id_54,
  l0_.price_type_id AS price_type_id_55,
  l0_.state_id AS state_id_56,
  l0_.status_id AS status_id_57,
  c2_.parent_id AS parent_id_58,
  c2_.form_id AS form_id_59
FROM
  listing l0_
  LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON l0_.category_id = c2_.id
  LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id
WHERE
  l0_.is_active = 1
  AND u1_.is_active = 1
  AND l0_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  l0_.updated_at DESC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.price AS price_4, l0_.is_active AS is_active_5, l0_.fields AS fields_6, l0_.latitude AS latitude_7, l0_.longitude AS longitude_8, l0_.lookup AS lookup_9, l0_.is_business AS is_business_10, l0_.url AS url_11, l0_.phone_number AS phone_number_12, l0_.condition_rating AS condition_rating_13, l0_.media_url AS media_url_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, u1_.id AS id_17, u1_.email AS email_18, u1_.slug AS slug_19, u1_.roles AS roles_20, u1_.password AS password_21, u1_.forsalebyowner_user_id AS forsalebyowner_user_id_22, u1_.first_name AS first_name_23, u1_.last_name AS last_name_24, u1_.user_name AS user_name_25, u1_.phone AS phone_26, u1_.created_at AS created_at_27, u1_.google_id AS google_id_28, u1_.avatar AS avatar_29, u1_.tagline AS tagline_30, u1_.is_active AS is_active_31, u1_.confirmation_token AS confirmation_token_32, u1_.confirmation_token_expires_at AS confirmation_token_expires_at_33, u1_.promo_code AS promo_code_34, u1_.show_phone_in_brochure AS show_phone_in_brochure_35, u1_.default_search_view AS default_search_view_36, u1_.description AS description_37, u1_.website_address AS website_address_38, u1_.allow_non_verified AS allow_non_verified_39, u1_.latitude AS latitude_40, u1_.longitude AS longitude_41, u1_.address AS address_42, u1_.show_address_in_brochure AS show_address_in_brochure_43, c2_.id AS id_44, c2_.name AS name_45, c2_.slug AS slug_46, c2_.is_active AS is_active_47, c2_.label AS label_48, c2_.sort_order AS sort_order_49, l0_.owner_id AS owner_id_50, l0_.category_id AS category_id_51, l0_.location_id AS location_id_52, l0_.listing_type_id AS listing_type_id_53, l0_.offer_type_id AS offer_type_id_54, l0_.price_type_id AS price_type_id_55, l0_.state_id AS state_id_56, l0_.status_id AS status_id_57, c2_.parent_id AS parent_id_58, c2_.form_id AS form_id_59 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id IN (1001, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1096, 1098, 1199, 1214) ORDER BY l0_.updated_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.geometry AS geometry_3,
  t0.coordinates AS coordinates_4,
  t0.code AS code_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.province_id AS province_id_8
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.geometry AS geometry_3, t0.coordinates AS coordinates_4, t0.code AS code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.province_id AS province_id_8 FROM city t0 WHERE t0.id = 982;

SELECT
  t0.id AS id_1,
  t0.additional_stores AS additional_stores_2,
  t0.override_listing_limit AS override_listing_limit_3,
  t0.override_store_limit AS override_store_limit_4,
  t0.starts_at AS starts_at_5,
  t0.ends_at AS ends_at_6,
  t0.token AS token_7,
  t0.is_recurring AS is_recurring_8,
  t0.user_id AS user_id_9,
  t0.pricing_option_id AS pricing_option_id_10
FROM
  subscription t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.additional_stores AS additional_stores_2, t0.override_listing_limit AS override_listing_limit_3, t0.override_store_limit AS override_store_limit_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.token AS token_7, t0.is_recurring AS is_recurring_8, t0.user_id AS user_id_9, t0.pricing_option_id AS pricing_option_id_10 FROM subscription t0 WHERE t0.user_id = 403;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.coordinates AS coordinates_4,
  t0.geometry AS geometry_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.country_id AS country_id_8
FROM
  province t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.coordinates AS coordinates_4, t0.geometry AS geometry_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8 FROM province t0 WHERE t0.id = 1;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  listing l0_
  LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON l0_.category_id = c2_.id
  LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id
WHERE
  l0_.is_active = 1
  AND u1_.is_active = 1
  AND l0_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  l0_.updated_at DESC

SELECT COUNT(l0_.id) AS sclr_0 FROM listing l0_ LEFT JOIN `user` u1_ ON l0_.owner_id = u1_.id LEFT JOIN category c2_ ON l0_.category_id = c2_.id LEFT JOIN listing_type l3_ ON l0_.listing_type_id = l3_.id WHERE l0_.is_active = 1 AND u1_.is_active = 1 AND l0_.category_id IN (1001, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1096, 1098, 1199, 1214) ORDER BY l0_.updated_at DESC;

SELECT
  i0_.id AS id_0,
  i0_.ip_address AS ip_address_1,
  i0_.reason AS reason_2,
  i0_.created_at AS created_at_3,
  i0_.expires_at AS expires_at_4,
  i0_.is_active AS is_active_5,
  i0_.created_by_id AS created_by_id_6
FROM
  `ip_blacklist` i0_
WHERE
  i0_.ip_address = ?
  AND i0_.is_active = 1
  AND (
    (
      i0_.expires_at IS NULL
      OR i0_.expires_at > ?
    )
  )

SELECT i0_.id AS id_0, i0_.ip_address AS ip_address_1, i0_.reason AS reason_2, i0_.created_at AS created_at_3, i0_.expires_at AS expires_at_4, i0_.is_active AS is_active_5, i0_.created_by_id AS created_by_id_6 FROM `ip_blacklist` i0_ WHERE i0_.ip_address = '216.73.217.9' AND i0_.is_active = 1 AND ((i0_.expires_at IS NULL OR i0_.expires_at > '2026-06-05 15:52:03'));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.label AS label_5,
  t0.sort_order AS sort_order_6,
  t0.parent_id AS parent_id_7,
  t0.form_id AS form_id_8
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.id = 997;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.label AS label_5,
  t0.sort_order AS sort_order_6,
  t0.parent_id AS parent_id_7,
  t0.form_id AS form_id_8
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.label AS label_5, t0.sort_order AS sort_order_6, t0.parent_id AS parent_id_7, t0.form_id AS form_id_8 FROM category t0 WHERE t0.slug = 'electric-urban-transport-e-bikes' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.word_limit AS word_limit_3,
  t0.photo_limit AS photo_limit_4,
  t0.conversation_limit AS conversation_limit_5,
  t0.allowed_media_link AS allowed_media_link_6,
  t0.slug AS slug_7,
  t0.base_listing_limit AS base_listing_limit_8,
  t0.base_store_limit AS base_store_limit_9,
  t0.listings_per_addon_store AS listings_per_addon_store_10,
  t0.is_active AS is_active_11,
  t0.is_custom AS is_custom_12,
  t0.addon_store_price AS addon_store_price_13,
  t0.description AS description_14,
  t0.allowed_website AS allowed_website_15
FROM
  plan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.word_limit AS word_limit_3, t0.photo_limit AS photo_limit_4, t0.conversation_limit AS conversation_limit_5, t0.allowed_media_link AS allowed_media_link_6, t0.slug AS slug_7, t0.base_listing_limit AS base_listing_limit_8, t0.base_store_limit AS base_store_limit_9, t0.listings_per_addon_store AS listings_per_addon_store_10, t0.is_active AS is_active_11, t0.is_custom AS is_custom_12, t0.addon_store_price AS addon_store_price_13, t0.description AS description_14, t0.allowed_website AS allowed_website_15 FROM plan t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.is_active AS is_active_3,
  t0.billing_cycle AS billing_cycle_4,
  t0.plan_id AS plan_id_5
FROM
  plan_pricing_option t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.is_active AS is_active_3, t0.billing_cycle AS billing_cycle_4, t0.plan_id AS plan_id_5 FROM plan_pricing_option t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category_form t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category_form t0 WHERE t0.id = 1;