Symfony Profiler

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 = '66.249.73.130' AND i0_.is_active = 1 AND ((i0_.expires_at IS NULL OR i0_.expires_at > '2026-07-29 07:07:18'));

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.listing_type_enabled AS listing_type_enabled_7,
  t0.parent_id AS parent_id_8,
  t0.form_id AS form_id_9
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.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.slug = 'generator-jackery-explorer' LIMIT 1;

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
  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
  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.listing_type_enabled AS listing_type_enabled_7,
  t0.parent_id AS parent_id_8,
  t0.form_id AS form_id_9
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.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.parent_id = 1228;

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 = ?
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 = 1228 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,
  c2_.listing_type_enabled AS listing_type_enabled_50,
  l0_.owner_id AS owner_id_51,
  l0_.category_id AS category_id_52,
  l0_.location_id AS location_id_53,
  l0_.listing_type_id AS listing_type_id_54,
  l0_.offer_type_id AS offer_type_id_55,
  l0_.price_type_id AS price_type_id_56,
  l0_.state_id AS state_id_57,
  l0_.status_id AS status_id_58,
  c2_.parent_id AS parent_id_59,
  c2_.form_id AS form_id_60
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 = ?
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, c2_.listing_type_enabled AS listing_type_enabled_50, l0_.owner_id AS owner_id_51, l0_.category_id AS category_id_52, l0_.location_id AS location_id_53, l0_.listing_type_id AS listing_type_id_54, l0_.offer_type_id AS offer_type_id_55, l0_.price_type_id AS price_type_id_56, l0_.state_id AS state_id_57, l0_.status_id AS status_id_58, c2_.parent_id AS parent_id_59, c2_.form_id AS form_id_60 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 = 1228 ORDER BY l0_.updated_at DESC;

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.listing_type_enabled AS listing_type_enabled_7,
  t0.parent_id AS parent_id_8,
  t0.form_id AS form_id_9
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.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.id = 1081;

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.listing_type_enabled AS listing_type_enabled_7,
  t0.parent_id AS parent_id_8,
  t0.form_id AS form_id_9
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.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.id = 393;

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.listing_type_enabled AS listing_type_enabled_7,
  t0.parent_id AS parent_id_8,
  t0.form_id AS form_id_9
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.listing_type_enabled AS listing_type_enabled_7, t0.parent_id AS parent_id_8, t0.form_id AS form_id_9 FROM category t0 WHERE t0.id = 1;

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;