Symfony Profiler

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.show_primary_only AS show_primary_only_22,
  t0.leads_counter AS leads_counter_23,
  t0.listings_counter AS listings_counter_24,
  t0.synonyms AS synonyms_25,
  t0.full_path AS full_path_26,
  t0.reference_id AS reference_id_27,
  t0.type AS type_28,
  t0.eligible_for_mortgage AS eligible_for_mortgage_29,
  t0.is_compound_location AS is_compound_location_30,
  t0.parent_id AS parent_id_31,
  t0.location_compound_id AS location_compound_id_32,
  t0.rating_id AS rating_id_33,
  t0.listing_id AS listing_id_34
FROM
  locations t0
WHERE
  t0.slug IS NULL
LIMIT
  1

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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.slug IS NULL LIMIT 1;

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.score AS score_31,
  t0.is_imported AS is_imported_32,
  t0.subscription_expiry_date AS subscription_expiry_date_33,
  t0.credit_expiry_date AS credit_expiry_date_34,
  t0.soft_churn_date AS soft_churn_date_35,
  t0.reach_count AS reach_count_36,
  t0.synced AS synced_37,
  t0.reference_id AS reference_id_38,
  t0.has_email AS has_email_39,
  t0.client_served_count AS client_served_count_40,
  t0.enabled_marketing AS enabled_marketing_41,
  t0.zoho_synced AS zoho_synced_42,
  t0.recent_search_last_checked AS recent_search_last_checked_43,
  t0.listing_availability_last_checked AS listing_availability_last_checked_44,
  t0.recent_search_last_send AS recent_search_last_send_45,
  t0.boost_level AS boost_level_46,
  t0.boost AS boost_47,
  t0.is_phone_verified AS is_phone_verified_48,
  t0.auth_identifier AS auth_identifier_49,
  t0.auth_access_token AS auth_access_token_50,
  t0.auth_refresh_token AS auth_refresh_token_51,
  t0.auth_updated_at AS auth_updated_at_52,
  t0.parent_id AS parent_id_53,
  t0.logo AS logo_54,
  t0.personal_photo AS personal_photo_55,
  t0.subscription_id AS subscription_id_56,
  t0.company_id AS company_id_57,
  t0.staff_id AS staff_id_58,
  t0.team_id AS team_id_59,
  t0.developerField_id AS developerField_id_60,
  t0.phone_id AS phone_id_61,
  t62.id AS id_63,
  t62.balance AS balance_64,
  t62.status AS status_65,
  t62.created_at AS created_at_66,
  t62.updated_at AS updated_at_67,
  t62.user_id AS user_id_68
FROM
  users t0
  LEFT JOIN wallets t62 ON t62.user_id = t0.id
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.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61, t62.id AS id_63, t62.balance AS balance_64, t62.status AS status_65, t62.created_at AS created_at_66, t62.updated_at AS updated_at_67, t62.user_id AS user_id_68 FROM users t0 LEFT JOIN wallets t62 ON t62.user_id = t0.id WHERE t0.id = 13;

SELECT
  COUNT(*)
FROM
  listings t0
WHERE
  t0.user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 13 AND ((t0.deleted_at IS NULL));