Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.public_number AS public_number_1,
  u0_.date AS date_2,
  u0_.email AS email_3,
  u0_.phone AS phone_4,
  u0_.phone_numeric AS phone_numeric_5,
  u0_.privacy_mask AS privacy_mask_6,
  u0_.push_settings_mask AS push_settings_mask_7,
  u0_.publish_daily_count AS publish_daily_count_8,
  u0_.publish_daily_at AS publish_daily_at_9,
  u0_.settings AS settings_10,
  u0_.password AS password_11,
  u0_.about AS about_12,
  u0_.stuff AS stuff_13,
  u0_.vk_code_verifier AS vk_code_verifier_14,
  u0_.vk_id AS vk_id_15,
  u0_.vk_avatar AS vk_avatar_16,
  u0_.new_email AS new_email_17,
  u0_.new_email_token AS new_email_token_18,
  u0_.status AS status_19,
  u0_.role AS role_20,
  u0_.last_visit_at AS last_visit_at_21,
  u0_.activity_status AS activity_status_22,
  u0_.confirm_token_token AS confirm_token_token_23,
  u0_.confirm_token_expires AS confirm_token_expires_24,
  u0_.name_first AS name_first_25,
  u0_.name_last AS name_last_26,
  u0_.name_middle AS name_middle_27,
  u0_.avatar_small_hash AS avatar_small_hash_28,
  u0_.avatar_original_hash AS avatar_original_hash_29,
  u0_.reset_token_token AS reset_token_token_30,
  u0_.reset_token_expires AS reset_token_expires_31,
  u0_.city_id AS city_id_32
FROM
  "user_users" u0_
WHERE
  u0_.email = ?

SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.last_visit_at AS last_visit_at_21, u0_.activity_status AS activity_status_22, u0_.confirm_token_token AS confirm_token_token_23, u0_.confirm_token_expires AS confirm_token_expires_24, u0_.name_first AS name_first_25, u0_.name_last AS name_last_26, u0_.name_middle AS name_middle_27, u0_.avatar_small_hash AS avatar_small_hash_28, u0_.avatar_original_hash AS avatar_original_hash_29, u0_.reset_token_token AS reset_token_token_30, u0_.reset_token_expires AS reset_token_expires_31, u0_.city_id AS city_id_32 FROM "user_users" u0_ WHERE u0_.email = 'usmian@yandex.ru';

SELECT
  a.id,
  a.main_photo_hash,
  a.title,
  a.description,
  a.city_id,
  a.main_instrument_id,
  a.main_instrument_title,
  a.instrument_data,
  a.city_name,
  a.user_id,
  a.category,
  a.type,
  a.status,
  a.repertoire,
  a.experience,
  a.institution_id,
  ir.title as institution_title,
  a.additional_education,
  a.education_type,
  a.specialty,
  a.views_counter,
  a.likes_counter,
  a.favorites_counter,
  a.image_counter,
  a.comments_counter,
  a.rating,
  a.reviews_counter,
  a.video_counter,
  a.audio_counter,
  a.order_timestamp,
  a.performance_start,
  a.job_type,
  a.job_date_from,
  a.job_date_to,
  a.performance_end,
  a.band_type_data,
  a.genres_data,
  a.metro_data,
  a.address_data,
  a.repair_specialty_data,
  a.option_data,
  a.schedule_data,
  a.office_data,
  a.good_data,
  a.office_id,
  a.company_id,
  a.created_at,
  a.updated_at,
  a.published_at,
  a.up_last_up_at,
  u.name_first,
  u.name_last,
  u.name_middle,
  u.avatar_small_hash,
  v.id IS NOT NULL as viewed,
  l.id IS NOT NULL as liked,
  f.id IS NOT NULL as added_to_favorite,
  a.price,
  a.min_hours,
  COALESCE(a.up_last_up_at, a.created_at) AS feed_cursor_at
FROM
  item_items a
  LEFT JOIN user_institutions_reference ir ON a.institution_id = ir.id
  LEFT JOIN user_users u ON a.user_id = u.id
  LEFT JOIN user_viewed_items v ON a.id = v.item_id
  AND v.user_id = ?
  LEFT JOIN user_favorite_items f ON a.id = f.item_id
  AND f.user_id = ?
  LEFT JOIN user_item_likes l ON a.id = l.item_id
  AND l.user_id = ?
WHERE
  (a.type = ?)
  AND (a.status = ?)
GROUP BY
  a.id,
  a.main_photo_hash,
  a.title,
  a.description,
  a.city_id,
  a.main_instrument_id,
  a.main_instrument_title,
  a.city_name,
  a.user_id,
  a.office_id,
  a.company_id,
  a.category,
  a.type,
  a.status,
  a.views_counter,
  a.likes_counter,
  a.favorites_counter,
  a.comments_counter,
  a.rating,
  a.reviews_counter,
  a.video_counter,
  a.audio_counter,
  a.image_counter,
  a.order_timestamp,
  a.created_at,
  a.updated_at,
  a.published_at,
  a.up_last_up_at,
  u.name_first,
  u.name_last,
  u.name_middle,
  u.avatar_small_hash,
  v.id,
  l.id,
  f.id,
  a.institution_id,
  ir.title,
  a.experience,
  a.price,
  a.min_hours
ORDER BY
  COALESCE(a.up_last_up_at, a.created_at) DESC,
  a.id DESC
LIMIT
  16

SELECT a.id, a.main_photo_hash, a.title, a.description, a.city_id, a.main_instrument_id, a.main_instrument_title, a.instrument_data, a.city_name, a.user_id, a.category, a.type, a.status, a.repertoire, a.experience, a.institution_id, ir.title as institution_title, a.additional_education, a.education_type, a.specialty, a.views_counter, a.likes_counter, a.favorites_counter, a.image_counter, a.comments_counter, a.rating, a.reviews_counter, a.video_counter, a.audio_counter, a.order_timestamp, a.performance_start, a.job_type, a.job_date_from, a.job_date_to, a.performance_end, a.band_type_data, a.genres_data, a.metro_data, a.address_data, a.repair_specialty_data, a.option_data, a.schedule_data, a.office_data, a.good_data, a.office_id, a.company_id, a.created_at, a.updated_at, a.published_at, a.up_last_up_at, u.name_first, u.name_last, u.name_middle, u.avatar_small_hash, v.id IS NOT NULL as viewed, l.id IS NOT NULL as liked, f.id IS NOT NULL as added_to_favorite, a.price, a.min_hours, COALESCE(a.up_last_up_at, a.created_at) AS feed_cursor_at FROM item_items a LEFT JOIN user_institutions_reference ir ON a.institution_id = ir.id LEFT JOIN user_users u ON a.user_id = u.id LEFT JOIN user_viewed_items v ON a.id = v.item_id AND v.user_id = '019efb3d-4132-79dd-abed-2f5eb76ecd0c' LEFT JOIN user_favorite_items f ON a.id = f.item_id AND f.user_id = '019efb3d-4132-79dd-abed-2f5eb76ecd0c' LEFT JOIN user_item_likes l ON a.id = l.item_id AND l.user_id = '019efb3d-4132-79dd-abed-2f5eb76ecd0c' WHERE (a.type = 'band_search_musician') AND (a.status = 'on_moderation') GROUP BY a.id, a.main_photo_hash, a.title, a.description, a.city_id, a.main_instrument_id, a.main_instrument_title, a.city_name, a.user_id, a.office_id, a.company_id, a.category, a.type, a.status, a.views_counter, a.likes_counter, a.favorites_counter, a.comments_counter, a.rating, a.reviews_counter, a.video_counter, a.audio_counter, a.image_counter, a.order_timestamp, a.created_at, a.updated_at, a.published_at, a.up_last_up_at, u.name_first, u.name_last, u.name_middle, u.avatar_small_hash, v.id, l.id, f.id, a.institution_id, ir.title, a.experience, a.price, a.min_hours ORDER BY COALESCE(a.up_last_up_at, a.created_at) DESC, a.id DESC LIMIT 16;