Symfony Profiler

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,
  g.price as price,
  g.section,
  g.brand,
  g.year,
  g.model,
  g.country,
  g.string_count,
  g.for_instrument_type,
  g.instrument_subtype,
  g.condition_new,
  g.is_negotiated_price,
  g.can_overprice,
  g.can_shipping,
  o.full_address,
  o.address_latitude,
  o.address_longitude,
  o.actualized_at as office_actualized_at,
  o.type as office_type,
  c.name as company_name,
  c.status as company_status,
  p.id AS promotion_id,
  p.name AS promotion_name,
  p.description AS promotion_description,
  p.rules AS promotion_rules,
  p.type AS promotion_type,
  p.start_at AS promotion_start_at,
  p.end_at AS promotion_end_at,
  p.created_at AS promotion_created_at,
  p.is_permanent AS promotion_is_permanent,
  p.closed_at AS promotion_closed_at,
  p.close_reason AS promotion_close_reason,
  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 = ?
  LEFT JOIN item_goods g ON a.id = g.item_id
  LEFT JOIN user_company_offices o ON a.office_id = o.id
  LEFT JOIN user_companies c ON a.company_id = c.id
  LEFT JOIN item_promotions p ON a.id = p.item_id
WHERE
  (a.status = ?)
  AND (
    a.id IN (?, ?, ?)
  )
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,
  g.price,
  g.section,
  g.brand,
  g.year,
  g.model,
  g.country,
  g.string_count,
  g.for_instrument_type,
  g.instrument_subtype,
  g.condition_new,
  g.is_negotiated_price,
  g.can_overprice,
  g.can_shipping,
  o.full_address,
  o.address_latitude,
  o.address_longitude,
  o.actualized_at,
  c.name,
  c.status,
  o.type,
  p.id,
  p.name,
  p.description,
  p.rules,
  p.type,
  p.start_at,
  p.end_at,
  p.created_at,
  p.is_permanent,
  p.closed_at,
  p.close_reason
ORDER BY
  COALESCE(a.up_last_up_at, a.created_at) DESC,
  a.id DESC
LIMIT
  31

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, g.price as price, g.section, g.brand, g.year, g.model, g.country, g.string_count, g.for_instrument_type, g.instrument_subtype, g.condition_new, g.is_negotiated_price, g.can_overprice, g.can_shipping, o.full_address, o.address_latitude, o.address_longitude, o.actualized_at as office_actualized_at, o.type as office_type, c.name as company_name, c.status as company_status, p.id AS promotion_id, p.name AS promotion_name, p.description AS promotion_description, p.rules AS promotion_rules, p.type AS promotion_type, p.start_at AS promotion_start_at, p.end_at AS promotion_end_at, p.created_at AS promotion_created_at, p.is_permanent AS promotion_is_permanent, p.closed_at AS promotion_closed_at, p.close_reason AS promotion_close_reason, 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' LEFT JOIN item_goods g ON a.id = g.item_id LEFT JOIN user_company_offices o ON a.office_id = o.id LEFT JOIN user_companies c ON a.company_id = c.id LEFT JOIN item_promotions p ON a.id = p.item_id WHERE (a.status = 'on_moderation') AND (a.id IN ('019de498-d869-0ac7-7171-0b23db391559', '019ffbb6-0601-7dfe-baf1-80eed4311a71', '01a0103b-2a35-7a12-bdec-b7333c8280d0')) 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, g.price, g.section, g.brand, g.year, g.model, g.country, g.string_count, g.for_instrument_type, g.instrument_subtype, g.condition_new, g.is_negotiated_price, g.can_overprice, g.can_shipping, o.full_address, o.address_latitude, o.address_longitude, o.actualized_at, c.name, c.status, o.type, p.id, p.name, p.description, p.rules, p.type, p.start_at, p.end_at, p.created_at, p.is_permanent, p.closed_at, p.close_reason ORDER BY COALESCE(a.up_last_up_at, a.created_at) DESC, a.id DESC LIMIT 31;

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_.is_online AS is_online_21,
  u0_.last_visit AS last_visit_22,
  u0_.last_visit_at AS last_visit_at_23,
  u0_.confirm_token_token AS confirm_token_token_24,
  u0_.confirm_token_expires AS confirm_token_expires_25,
  u0_.name_first AS name_first_26,
  u0_.name_last AS name_last_27,
  u0_.name_middle AS name_middle_28,
  u0_.avatar_small_hash AS avatar_small_hash_29,
  u0_.avatar_original_hash AS avatar_original_hash_30,
  u0_.reset_token_token AS reset_token_token_31,
  u0_.reset_token_expires AS reset_token_expires_32,
  u0_.city_id AS city_id_33
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_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = 'usmian@yandex.ru';

SELECT
  id,
  user_id,
  item_id,
  created_at
FROM
  user_favorite_items
WHERE
  user_id = ?

SELECT id, user_id, item_id, created_at FROM user_favorite_items WHERE user_id = '019efb3d-4132-79dd-abed-2f5eb76ecd0c';