Symfony Profiler

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 = 3190576;

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 = 3190581 ORDER BY t0.sort_order ASC;

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 18:05:34'));

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,
  l0_.owner_id AS owner_id_17,
  l0_.category_id AS category_id_18,
  l0_.location_id AS location_id_19,
  l0_.listing_type_id AS listing_type_id_20,
  l0_.offer_type_id AS offer_type_id_21,
  l0_.price_type_id AS price_type_id_22,
  l0_.state_id AS state_id_23,
  l0_.status_id AS status_id_24
FROM
  listing l0_
WHERE
  l0_.owner_id = ?
  AND l0_.is_active = ?
  AND l0_.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, l0_.owner_id AS owner_id_17, l0_.category_id AS category_id_18, l0_.location_id AS location_id_19, l0_.listing_type_id AS listing_type_id_20, l0_.offer_type_id AS offer_type_id_21, l0_.price_type_id AS price_type_id_22, l0_.state_id AS state_id_23, l0_.status_id AS status_id_24 FROM listing l0_ WHERE l0_.owner_id = 469 AND l0_.is_active = 1 AND l0_.id IN (3190581, 3190576, 3190586, 3190585, 3190584, 3190583, 3190582, 3190580, 3190579, 3190578, 3190577, 3190587) ORDER BY l0_.updated_at DESC;

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,
  s0_.user_id AS user_id_19,
  s0_.layout_id AS layout_id_20
FROM
  store s0_
  LEFT JOIN store_listing s1_ ON s0_.id = s1_.store_id
WHERE
  s0_.user_id = ?
  AND s1_.image IS NOT NULL
ORDER BY
  s0_.id 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, s0_.user_id AS user_id_19, s0_.layout_id AS layout_id_20 FROM store s0_ LEFT JOIN store_listing s1_ ON s0_.id = s1_.store_id WHERE s0_.user_id = 469 AND s1_.image IS NOT NULL ORDER BY s0_.id 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 = '469';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        FROM
          listing l0_
        WHERE
          l0_.owner_id = ?
          AND l0_.is_active = ?
        ORDER BY
          l0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM listing l0_ WHERE l0_.owner_id = 469 AND l0_.is_active = 1 ORDER BY l0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      updated_at_16
    FROM
      (
        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
        FROM
          listing l0_
        WHERE
          l0_.owner_id = ?
          AND l0_.is_active = ?
      ) dctrn_result_inner
    ORDER BY
      updated_at_16 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_16 FROM (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 FROM listing l0_ WHERE l0_.owner_id = 469 AND l0_.is_active = 1) dctrn_result_inner ORDER BY updated_at_16 DESC) dctrn_result LIMIT 12;

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 = 469;

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 = 36;

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;