Symfony Profiler

SELECT
  COUNT(*)
FROM
  comments t0
WHERE
  (
    t0.status = ?
    AND t0.discussion_id = ?
  )

SELECT COUNT(*) FROM comments t0 WHERE (t0.status = 2 AND t0.discussion_id = 8);

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.alias AS alias_2,
  l0_.description AS description_3,
  l0_.slug AS slug_4,
  l0_.lat AS lat_5,
  l0_.lon AS lon_6,
  l0_.zoom AS zoom_7,
  l0_.coordinates AS coordinates_8,
  l0_.searchable AS searchable_9,
  l0_.home_filter AS home_filter_10,
  l0_.statistics_filter AS statistics_filter_11,
  l0_.neighborhood_filter AS neighborhood_filter_12,
  l0_.compound_filter AS compound_filter_13,
  l0_.estimate AS estimate_14,
  l0_.disabled AS disabled_15,
  l0_.synced AS synced_16,
  l0_.level AS level_17,
  l0_._left AS _left_18,
  l0_._right AS _right_19,
  l0_.root AS root_20,
  l0_.leads_counter AS leads_counter_21,
  l0_.listings_counter AS listings_counter_22,
  l0_.keyword AS keyword_23,
  l0_.full_path AS full_path_24,
  l0_.reference_id AS reference_id_25,
  l0_.eligible_for_mortgage AS eligible_for_mortgage_26,
  l0_.is_compound_location AS is_compound_location_27,
  l0_.parent_id AS parent_id_28,
  l0_.location_compound_id AS location_compound_id_29,
  l0_.rating_id AS rating_id_30,
  l0_.listing_id AS listing_id_31
FROM
  locations l0_
WHERE
  l0_._left <= 4
  AND l0_._right >= 5
  AND l0_.root = ?
ORDER BY
  l0_._left ASC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.keyword AS keyword_23, l0_.full_path AS full_path_24, l0_.reference_id AS reference_id_25, l0_.eligible_for_mortgage AS eligible_for_mortgage_26, l0_.is_compound_location AS is_compound_location_27, l0_.parent_id AS parent_id_28, l0_.location_compound_id AS location_compound_id_29, l0_.rating_id AS rating_id_30, l0_.listing_id AS listing_id_31 FROM locations l0_ WHERE l0_._left <= 4 AND l0_._right >= 5 AND l0_.root = 43 ORDER BY l0_._left ASC;

SELECT
  c0_.id AS id_0,
  c0_.content AS content_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.deleted_at AS deleted_at_4,
  c0_.status AS status_5,
  (
    SELECT
      COUNT(c1_.id) AS sclr_7
    FROM
      comments_likes c1_
    WHERE
      c1_.type = ?
      AND c1_.comment_id = c0_.id
  ) AS sclr_6,
  (
    SELECT
      COUNT(c2_.id) AS sclr_9
    FROM
      comments_likes c2_
    WHERE
      c2_.type = ?
      AND c2_.comment_id = c0_.id
  ) AS sclr_8,
  c0_.user_id AS user_id_10,
  c0_.discussion_id AS discussion_id_11
FROM
  comments c0_
WHERE
  c0_.discussion_id = ?
  AND c0_.status = ?
ORDER BY
  sclr_6 DESC,
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.deleted_at AS deleted_at_4, c0_.status AS status_5, (SELECT COUNT(c1_.id) AS sclr_7 FROM comments_likes c1_ WHERE c1_.type = 1 AND c1_.comment_id = c0_.id) AS sclr_6, (SELECT COUNT(c2_.id) AS sclr_9 FROM comments_likes c2_ WHERE c2_.type = 2 AND c2_.comment_id = c0_.id) AS sclr_8, c0_.user_id AS user_id_10, c0_.discussion_id AS discussion_id_11 FROM comments c0_ WHERE c0_.discussion_id = 8 AND c0_.status = 2 ORDER BY sclr_6 DESC, c0_.created_at DESC;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  leads l0_
WHERE
  l0_.user_ip = ?
  AND l0_.created_at >= ?

SELECT COUNT(l0_.id) AS sclr_0 FROM leads l0_ WHERE l0_.user_ip = '192.168.5.202' AND l0_.created_at >= '2024-09-29 07:01:53';

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.full_name AS full_name_13,
  t0.bio AS bio_14,
  t0.phone_number AS phone_number_15,
  t0.is_valid_logo AS is_valid_logo_16,
  t0.is_valid_personal_photo AS is_valid_personal_photo_17,
  t0.is_migrated_phone AS is_migrated_phone_18,
  t0.is_valid_email AS is_valid_email_19,
  t0.user_type AS user_type_20,
  t0.language AS language_21,
  t0.legacy AS legacy_22,
  t0.facebook_id AS facebook_id_23,
  t0.google_id AS google_id_24,
  t0.registration_ip AS registration_ip_25,
  t0.created_at AS created_at_26,
  t0.last_update AS last_update_27,
  t0.global_unsubscribe AS global_unsubscribe_28,
  t0.customer_profiling_queue_date AS customer_profiling_queue_date_29,
  t0.is_quick_registered AS is_quick_registered_30,
  t0.is_imported AS is_imported_31,
  t0.subscription_expiry_date AS subscription_expiry_date_32,
  t0.credit_expiry_date AS credit_expiry_date_33,
  t0.soft_churn_date AS soft_churn_date_34,
  t0.reach_count AS reach_count_35,
  t0.synced AS synced_36,
  t0.reference_id AS reference_id_37,
  t0.has_email AS has_email_38,
  t0.client_served_count AS client_served_count_39,
  t0.enabled_marketing AS enabled_marketing_40,
  t0.zoho_synced AS zoho_synced_41,
  t0.recent_search_last_checked AS recent_search_last_checked_42,
  t0.recent_search_last_send AS recent_search_last_send_43,
  t0.auth_identifier AS auth_identifier_44,
  t0.auth_access_token AS auth_access_token_45,
  t0.auth_refresh_token AS auth_refresh_token_46,
  t0.auth_updated_at AS auth_updated_at_47,
  t0.parent_id AS parent_id_48,
  t0.logo AS logo_49,
  t0.personal_photo AS personal_photo_50,
  t0.company_id AS company_id_51,
  t0.staff_id AS staff_id_52,
  t0.team_id AS team_id_53,
  t0.developerField_id AS developerField_id_54
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.is_imported AS is_imported_31, t0.subscription_expiry_date AS subscription_expiry_date_32, t0.credit_expiry_date AS credit_expiry_date_33, t0.soft_churn_date AS soft_churn_date_34, t0.reach_count AS reach_count_35, t0.synced AS synced_36, t0.reference_id AS reference_id_37, t0.has_email AS has_email_38, t0.client_served_count AS client_served_count_39, t0.enabled_marketing AS enabled_marketing_40, t0.zoho_synced AS zoho_synced_41, t0.recent_search_last_checked AS recent_search_last_checked_42, t0.recent_search_last_send AS recent_search_last_send_43, t0.auth_identifier AS auth_identifier_44, t0.auth_access_token AS auth_access_token_45, t0.auth_refresh_token AS auth_refresh_token_46, t0.auth_updated_at AS auth_updated_at_47, t0.parent_id AS parent_id_48, t0.logo AS logo_49, t0.personal_photo AS personal_photo_50, t0.company_id AS company_id_51, t0.staff_id AS staff_id_52, t0.team_id AS team_id_53, t0.developerField_id AS developerField_id_54 FROM users t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.alias AS alias_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.lat AS lat_6,
  t0.lon AS lon_7,
  t0.zoom AS zoom_8,
  t0.coordinates AS coordinates_9,
  t0.searchable AS searchable_10,
  t0.home_filter AS home_filter_11,
  t0.statistics_filter AS statistics_filter_12,
  t0.neighborhood_filter AS neighborhood_filter_13,
  t0.compound_filter AS compound_filter_14,
  t0.estimate AS estimate_15,
  t0.disabled AS disabled_16,
  t0.synced AS synced_17,
  t0.level AS level_18,
  t0._left AS _left_19,
  t0._right AS _right_20,
  t0.root AS root_21,
  t0.leads_counter AS leads_counter_22,
  t0.listings_counter AS listings_counter_23,
  t0.keyword AS keyword_24,
  t0.full_path AS full_path_25,
  t0.reference_id AS reference_id_26,
  t0.eligible_for_mortgage AS eligible_for_mortgage_27,
  t0.is_compound_location AS is_compound_location_28,
  t0.parent_id AS parent_id_29,
  t0.location_compound_id AS location_compound_id_30,
  t0.rating_id AS rating_id_31,
  t0.listing_id AS listing_id_32
FROM
  locations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.eligible_for_mortgage AS eligible_for_mortgage_27, t0.is_compound_location AS is_compound_location_28, t0.parent_id AS parent_id_29, t0.location_compound_id AS location_compound_id_30, t0.rating_id AS rating_id_31, t0.listing_id AS listing_id_32 FROM locations t0 WHERE t0.id = 45;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.comments_counter AS comments_counter_6,
  t0.deleted_at AS deleted_at_7,
  t0.severity AS severity_8,
  t0.subscribers_notified AS subscribers_notified_9,
  t0.reach_count AS reach_count_10,
  t0.user_id AS user_id_11,
  t0.location_id AS location_id_12,
  t0.category_id AS category_id_13
FROM
  discussions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.comments_counter AS comments_counter_6, t0.deleted_at AS deleted_at_7, t0.severity AS severity_8, t0.subscribers_notified AS subscribers_notified_9, t0.reach_count AS reach_count_10, t0.user_id AS user_id_11, t0.location_id AS location_id_12, t0.category_id AS category_id_13 FROM discussions t0 WHERE t0.id = '8';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.private AS private_4,
  t0.level AS level_5,
  t0._left AS _left_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.compound_related AS compound_related_9,
  t0.reference_id AS reference_id_10,
  t0.exchangeable AS exchangeable_11,
  t0.is_evaluable AS is_evaluable_12,
  t0.synced AS synced_13,
  t0.searchable AS searchable_14,
  t0.deleted_at AS deleted_at_15,
  t0.custom_order AS custom_order_16,
  t0.parent_id AS parent_id_17
FROM
  property_types t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.private AS private_4, t0.level AS level_5, t0._left AS _left_6, t0._right AS _right_7, t0.root AS root_8, t0.compound_related AS compound_related_9, t0.reference_id AS reference_id_10, t0.exchangeable AS exchangeable_11, t0.is_evaluable AS is_evaluable_12, t0.synced AS synced_13, t0.searchable AS searchable_14, t0.deleted_at AS deleted_at_15, t0.custom_order AS custom_order_16, t0.parent_id AS parent_id_17 FROM property_types t0 WHERE t0.id = 2 LIMIT 1;

SELECT
  COUNT(*)
FROM
  listings t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.synced AS synced_4
FROM
  listing_score_settings t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.url AS url_2,
  a0_.description AS description_3,
  a0_.customer_title AS customer_title_4,
  a0_.customer_url AS customer_url_5,
  a0_.customer_description AS customer_description_6,
  a0_.end_at AS end_at_7,
  a0_.start_at AS start_at_8,
  a0_.color AS color_9,
  a0_.counter AS counter_10,
  a0_.top_bar AS top_bar_11,
  a0_.appear_on_mobile AS appear_on_mobile_12
FROM
  announcements a0_
WHERE
  a0_.top_bar IN (?)
  AND a0_.end_at >= ?

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (1) AND a0_.end_at >= '2024-09-29 07:16:55';

SELECT
  p0_.id AS id_0
FROM
  property_types p0_
WHERE
  p0_._right < 9
  AND p0_._left > 2
  AND p0_.root = ?

SELECT p0_.id AS id_0 FROM property_types p0_ WHERE p0_._right < 9 AND p0_._left > 2 AND p0_.root = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3
FROM
  discussions_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3 FROM discussions_categories t0 WHERE t0.id = 1;