Symfony Profiler

SELECT
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(p0_.latitude)
      ) * COS(
        RADIANS(p0_.longitude) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(p0_.latitude)
      )
    )
  ) AS sclr_0,
  p0_.id AS id_1,
  p0_.code AS code_2,
  p0_.area AS area_3,
  p0_.time_zone AS time_zone_4,
  p0_.latitude AS latitude_5,
  p0_.longitude AS longitude_6,
  p0_.province_code AS province_code_7,
  c1_.id AS id_8,
  c1_.name AS name_9,
  c1_.geometry AS geometry_10,
  c1_.coordinates AS coordinates_11,
  c1_.code AS code_12,
  c1_.latitude AS latitude_13,
  c1_.longitude AS longitude_14,
  p2_.id AS id_15,
  p2_.name AS name_16,
  p2_.code AS code_17,
  p2_.coordinates AS coordinates_18,
  p2_.geometry AS geometry_19,
  p2_.latitude AS latitude_20,
  p2_.longitude AS longitude_21,
  p0_.province_id AS province_id_22,
  p0_.city_id AS city_id_23,
  c1_.province_id AS province_id_24,
  p2_.country_id AS country_id_25
FROM
  postal_code p0_
  LEFT JOIN city c1_ ON p0_.city_id = c1_.id
  LEFT JOIN province p2_ ON c1_.province_id = p2_.id
WHERE
  p0_.latitude IS NOT NULL
  AND p0_.longitude IS NOT NULL
ORDER BY
  sclr_0 ASC
LIMIT
  1

SELECT (6371 * ACOS(COS(RADIANS(53.551811)) * COS(RADIANS(p0_.latitude)) * COS(RADIANS(p0_.longitude) - RADIANS(-114.215477)) + SIN(RADIANS(53.551811)) * SIN(RADIANS(p0_.latitude)))) AS sclr_0, p0_.id AS id_1, p0_.code AS code_2, p0_.area AS area_3, p0_.time_zone AS time_zone_4, p0_.latitude AS latitude_5, p0_.longitude AS longitude_6, p0_.province_code AS province_code_7, c1_.id AS id_8, c1_.name AS name_9, c1_.geometry AS geometry_10, c1_.coordinates AS coordinates_11, c1_.code AS code_12, c1_.latitude AS latitude_13, c1_.longitude AS longitude_14, p2_.id AS id_15, p2_.name AS name_16, p2_.code AS code_17, p2_.coordinates AS coordinates_18, p2_.geometry AS geometry_19, p2_.latitude AS latitude_20, p2_.longitude AS longitude_21, p0_.province_id AS province_id_22, p0_.city_id AS city_id_23, c1_.province_id AS province_id_24, p2_.country_id AS country_id_25 FROM postal_code p0_ LEFT JOIN city c1_ ON p0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id WHERE p0_.latitude IS NOT NULL AND p0_.longitude IS NOT NULL ORDER BY sclr_0 ASC 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.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 = 221;

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_.view_date AS view_date_0,
  l0_.view_count AS view_count_1
FROM
  listing_view_count l0_
WHERE
  l0_.listing_id = ?
  AND (
    l0_.view_date BETWEEN ?
    AND ?
  )
ORDER BY
  l0_.view_date ASC

SELECT l0_.view_date AS view_date_0, l0_.view_count AS view_count_1 FROM listing_view_count l0_ WHERE l0_.listing_id = 3247460 AND (l0_.view_date BETWEEN '2025-07-01' AND '2026-06-30') ORDER BY l0_.view_date 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 = 3247460 ORDER BY t0.sort_order ASC;

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.slug = ?
LIMIT
  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.slug = 'fully-serviced-acreage-lot' LIMIT 1;

SELECT
  l0_.view_date AS view_date_0,
  l0_.view_count AS view_count_1
FROM
  listing_view_count l0_
WHERE
  l0_.listing_id = ?
  AND l0_.view_date <= ?
  AND l0_.view_date >= ?
ORDER BY
  l0_.view_date ASC

SELECT l0_.view_date AS view_date_0, l0_.view_count AS view_count_1 FROM listing_view_count l0_ WHERE l0_.listing_id = 3247460 AND l0_.view_date <= '2026-06-05 00:00:00' AND l0_.view_date >= '2026-05-29 18:05:34' ORDER BY l0_.view_date 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 = 139;

"COMMIT"

"COMMIT";

UPDATE
  listing_view_count
SET
  view_count = ?,
  last_viewed_at = ?
WHERE
  id = ?

UPDATE listing_view_count SET view_count = 3, last_viewed_at = '2026-06-05 18:05:34' WHERE id = 770057;

SELECT
  MAX(l0_.last_viewed_at) AS sclr_0
FROM
  listing_view_count l0_
WHERE
  l0_.listing_id = ?

SELECT MAX(l0_.last_viewed_at) AS sclr_0 FROM listing_view_count l0_ WHERE l0_.listing_id = 3247460;

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.listing_id = ?
LIMIT
  1

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.listing_id = 3247460 LIMIT 1;

SELECT
  SUM(l0_.view_count) AS sclr_0
FROM
  listing_view_count l0_
WHERE
  l0_.listing_id = ?

SELECT SUM(l0_.view_count) AS sclr_0 FROM listing_view_count l0_ WHERE l0_.listing_id = 3247460;

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

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

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.slug = ?
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.slug = 'non-verified' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.view_date AS view_date_2,
  t0.view_count AS view_count_3,
  t0.last_viewed_at AS last_viewed_at_4,
  t0.listing_id AS listing_id_5
FROM
  listing_view_count t0
WHERE
  t0.listing_id = ?
  AND t0.view_date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.view_date AS view_date_2, t0.view_count AS view_count_3, t0.last_viewed_at AS last_viewed_at_4, t0.listing_id AS listing_id_5 FROM listing_view_count t0 WHERE t0.listing_id = 3247460 AND t0.view_date = '2026-06-05' LIMIT 1;

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

"START TRANSACTION"

"START TRANSACTION";