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 = '74.7.227.16' AND i0_.is_active = 1 AND ((i0_.expires_at IS NULL OR i0_.expires_at > '2026-07-30 12:21:22'));

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.position AS position_3,
  s0_.header_image AS header_image_4,
  s0_.background_image AS background_image_5,
  s0_.shelf_image AS shelf_image_6,
  s0_.is_published AS is_published_7,
  s0_.header_text AS header_text_8,
  s0_.header_text_type AS header_text_type_9,
  s0_.header_sign_type AS header_sign_type_10,
  s0_.header_font_size AS header_font_size_11,
  s0_.header_background_color AS header_background_color_12,
  s0_.header_text_color AS header_text_color_13,
  s0_.header_font_weight AS header_font_weight_14,
  s0_.frame_color AS frame_color_15,
  s0_.background_color AS background_color_16,
  s0_.created_at AS created_at_17,
  s0_.updated_at AS updated_at_18,
  RAND() AS sclr_19,
  s0_.user_id AS user_id_20,
  s0_.layout_id AS layout_id_21
FROM
  store s0_
  INNER JOIN store_listing s1_ ON s0_.id = s1_.store_id
WHERE
  s1_.image IS NOT NULL
  AND s0_.is_published = ?
ORDER BY
  sclr_19 ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.position AS position_3, s0_.header_image AS header_image_4, s0_.background_image AS background_image_5, s0_.shelf_image AS shelf_image_6, s0_.is_published AS is_published_7, s0_.header_text AS header_text_8, s0_.header_text_type AS header_text_type_9, s0_.header_sign_type AS header_sign_type_10, s0_.header_font_size AS header_font_size_11, s0_.header_background_color AS header_background_color_12, s0_.header_text_color AS header_text_color_13, s0_.header_font_weight AS header_font_weight_14, s0_.frame_color AS frame_color_15, s0_.background_color AS background_color_16, s0_.created_at AS created_at_17, s0_.updated_at AS updated_at_18, RAND() AS sclr_19, s0_.user_id AS user_id_20, s0_.layout_id AS layout_id_21 FROM store s0_ INNER JOIN store_listing s1_ ON s0_.id = s1_.store_id WHERE s1_.image IS NOT NULL AND s0_.is_published = 1 ORDER BY sclr_19 ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.slug AS slug_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.forsalebyowner_user_id AS forsalebyowner_user_id_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.user_name AS user_name_9,
  t0.phone AS phone_10,
  t0.created_at AS created_at_11,
  t0.google_id AS google_id_12,
  t0.avatar AS avatar_13,
  t0.tagline AS tagline_14,
  t0.is_active AS is_active_15,
  t0.confirmation_token AS confirmation_token_16,
  t0.confirmation_token_expires_at AS confirmation_token_expires_at_17,
  t0.promo_code AS promo_code_18,
  t0.show_phone_in_brochure AS show_phone_in_brochure_19,
  t0.default_search_view AS default_search_view_20,
  t0.description AS description_21,
  t0.website_address AS website_address_22,
  t0.allow_non_verified AS allow_non_verified_23,
  t0.latitude AS latitude_24,
  t0.longitude AS longitude_25,
  t0.address AS address_26,
  t0.show_address_in_brochure AS show_address_in_brochure_27
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.slug AS slug_3, t0.roles AS roles_4, t0.password AS password_5, t0.forsalebyowner_user_id AS forsalebyowner_user_id_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.user_name AS user_name_9, t0.phone AS phone_10, t0.created_at AS created_at_11, t0.google_id AS google_id_12, t0.avatar AS avatar_13, t0.tagline AS tagline_14, t0.is_active AS is_active_15, t0.confirmation_token AS confirmation_token_16, t0.confirmation_token_expires_at AS confirmation_token_expires_at_17, t0.promo_code AS promo_code_18, t0.show_phone_in_brochure AS show_phone_in_brochure_19, t0.default_search_view AS default_search_view_20, t0.description AS description_21, t0.website_address AS website_address_22, t0.allow_non_verified AS allow_non_verified_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.address AS address_26, t0.show_address_in_brochure AS show_address_in_brochure_27 FROM `user` t0 WHERE t0.id = 454;

SELECT
  t0.id AS id_1,
  t0.store_row AS store_row_2,
  t0.store_column AS store_column_3,
  t0.position AS position_4,
  t0.image AS image_5,
  t0.store_id AS store_id_6,
  t0.listing_id AS listing_id_7
FROM
  store_listing t0
WHERE
  t0.store_id = ?

SELECT t0.id AS id_1, t0.store_row AS store_row_2, t0.store_column AS store_column_3, t0.position AS position_4, t0.image AS image_5, t0.store_id AS store_id_6, t0.listing_id AS listing_id_7 FROM store_listing t0 WHERE t0.store_id = 38;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.fields AS fields_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.lookup AS lookup_10,
  t0.is_business AS is_business_11,
  t0.url AS url_12,
  t0.phone_number AS phone_number_13,
  t0.condition_rating AS condition_rating_14,
  t0.media_url AS media_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.owner_id AS owner_id_18,
  t0.category_id AS category_id_19,
  t0.location_id AS location_id_20,
  t0.listing_type_id AS listing_type_id_21,
  t0.offer_type_id AS offer_type_id_22,
  t0.price_type_id AS price_type_id_23,
  t0.state_id AS state_id_24,
  t0.status_id AS status_id_25
FROM
  listing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.id = 3228846;

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

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

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.fields AS fields_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.lookup AS lookup_10,
  t0.is_business AS is_business_11,
  t0.url AS url_12,
  t0.phone_number AS phone_number_13,
  t0.condition_rating AS condition_rating_14,
  t0.media_url AS media_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.owner_id AS owner_id_18,
  t0.category_id AS category_id_19,
  t0.location_id AS location_id_20,
  t0.listing_type_id AS listing_type_id_21,
  t0.offer_type_id AS offer_type_id_22,
  t0.price_type_id AS price_type_id_23,
  t0.state_id AS state_id_24,
  t0.status_id AS status_id_25
FROM
  listing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.id = 3234532;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.fields AS fields_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.lookup AS lookup_10,
  t0.is_business AS is_business_11,
  t0.url AS url_12,
  t0.phone_number AS phone_number_13,
  t0.condition_rating AS condition_rating_14,
  t0.media_url AS media_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.owner_id AS owner_id_18,
  t0.category_id AS category_id_19,
  t0.location_id AS location_id_20,
  t0.listing_type_id AS listing_type_id_21,
  t0.offer_type_id AS offer_type_id_22,
  t0.price_type_id AS price_type_id_23,
  t0.state_id AS state_id_24,
  t0.status_id AS status_id_25
FROM
  listing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.id = 3234533;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.fields AS fields_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.lookup AS lookup_10,
  t0.is_business AS is_business_11,
  t0.url AS url_12,
  t0.phone_number AS phone_number_13,
  t0.condition_rating AS condition_rating_14,
  t0.media_url AS media_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.owner_id AS owner_id_18,
  t0.category_id AS category_id_19,
  t0.location_id AS location_id_20,
  t0.listing_type_id AS listing_type_id_21,
  t0.offer_type_id AS offer_type_id_22,
  t0.price_type_id AS price_type_id_23,
  t0.state_id AS state_id_24,
  t0.status_id AS status_id_25
FROM
  listing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.id = 3234535;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.fields AS fields_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.lookup AS lookup_10,
  t0.is_business AS is_business_11,
  t0.url AS url_12,
  t0.phone_number AS phone_number_13,
  t0.condition_rating AS condition_rating_14,
  t0.media_url AS media_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.owner_id AS owner_id_18,
  t0.category_id AS category_id_19,
  t0.location_id AS location_id_20,
  t0.listing_type_id AS listing_type_id_21,
  t0.offer_type_id AS offer_type_id_22,
  t0.price_type_id AS price_type_id_23,
  t0.state_id AS state_id_24,
  t0.status_id AS status_id_25
FROM
  listing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.id = 3249618;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.fields AS fields_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.lookup AS lookup_10,
  t0.is_business AS is_business_11,
  t0.url AS url_12,
  t0.phone_number AS phone_number_13,
  t0.condition_rating AS condition_rating_14,
  t0.media_url AS media_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.owner_id AS owner_id_18,
  t0.category_id AS category_id_19,
  t0.location_id AS location_id_20,
  t0.listing_type_id AS listing_type_id_21,
  t0.offer_type_id AS offer_type_id_22,
  t0.price_type_id AS price_type_id_23,
  t0.state_id AS state_id_24,
  t0.status_id AS status_id_25
FROM
  listing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.id = 3249621;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.fields AS fields_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.lookup AS lookup_10,
  t0.is_business AS is_business_11,
  t0.url AS url_12,
  t0.phone_number AS phone_number_13,
  t0.condition_rating AS condition_rating_14,
  t0.media_url AS media_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.owner_id AS owner_id_18,
  t0.category_id AS category_id_19,
  t0.location_id AS location_id_20,
  t0.listing_type_id AS listing_type_id_21,
  t0.offer_type_id AS offer_type_id_22,
  t0.price_type_id AS price_type_id_23,
  t0.state_id AS state_id_24,
  t0.status_id AS status_id_25
FROM
  listing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.id = 3249622;