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.institution,
  a.additional_education,
  a.education_type,
  a.specialty,
  a.views_counter,
  a.likes_counter,
  a.favorites_counter,
  a.comments_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.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.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
FROM
  item_items a
  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.user_id = ?
ORDER BY
  a.order_timestamp DESC
LIMIT
  30

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.institution, a.additional_education, a.education_type, a.specialty, a.views_counter, a.likes_counter, a.favorites_counter, a.comments_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.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.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 FROM item_items a 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 = '73ee8243-c222-4e78-8531-b0b1108d27bc' LEFT JOIN user_favorite_items f ON a.id = f.item_id AND f.user_id = '73ee8243-c222-4e78-8531-b0b1108d27bc' LEFT JOIN user_item_likes l ON a.id = l.item_id AND l.user_id = '73ee8243-c222-4e78-8531-b0b1108d27bc' WHERE a.user_id = '73ee8243-c222-4e78-8531-b0b1108d27bc' ORDER BY a.order_timestamp DESC LIMIT 30;

SELECT
  u0_.id AS id_0,
  u0_.date AS date_1,
  u0_.email AS email_2,
  u0_.phone AS phone_3,
  u0_.phone_numeric AS phone_numeric_4,
  u0_.privacy_mask AS privacy_mask_5,
  u0_.push_settings_mask AS push_settings_mask_6,
  u0_.password AS password_7,
  u0_.about AS about_8,
  u0_.stuff AS stuff_9,
  u0_.vk_code_verifier AS vk_code_verifier_10,
  u0_.vk_id AS vk_id_11,
  u0_.vk_avatar AS vk_avatar_12,
  u0_.new_email AS new_email_13,
  u0_.new_email_token AS new_email_token_14,
  u0_.status AS status_15,
  u0_.role AS role_16,
  u0_.is_online AS is_online_17,
  u0_.last_visit AS last_visit_18,
  u0_.last_visit_at AS last_visit_at_19,
  u0_.confirm_token_token AS confirm_token_token_20,
  u0_.confirm_token_expires AS confirm_token_expires_21,
  u0_.name_first AS name_first_22,
  u0_.name_last AS name_last_23,
  u0_.name_middle AS name_middle_24,
  u0_.avatar_small_hash AS avatar_small_hash_25,
  u0_.avatar_original_hash AS avatar_original_hash_26,
  u0_.reset_token_token AS reset_token_token_27,
  u0_.reset_token_expires AS reset_token_expires_28,
  u0_.city_id AS city_id_29
FROM
  "user_users" u0_
WHERE
  u0_.email = ?

SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.phone AS phone_3, u0_.phone_numeric AS phone_numeric_4, u0_.privacy_mask AS privacy_mask_5, u0_.push_settings_mask AS push_settings_mask_6, u0_.password AS password_7, u0_.about AS about_8, u0_.stuff AS stuff_9, u0_.vk_code_verifier AS vk_code_verifier_10, u0_.vk_id AS vk_id_11, u0_.vk_avatar AS vk_avatar_12, u0_.new_email AS new_email_13, u0_.new_email_token AS new_email_token_14, u0_.status AS status_15, u0_.role AS role_16, u0_.is_online AS is_online_17, u0_.last_visit AS last_visit_18, u0_.last_visit_at AS last_visit_at_19, u0_.confirm_token_token AS confirm_token_token_20, u0_.confirm_token_expires AS confirm_token_expires_21, u0_.name_first AS name_first_22, u0_.name_last AS name_last_23, u0_.name_middle AS name_middle_24, u0_.avatar_small_hash AS avatar_small_hash_25, u0_.avatar_original_hash AS avatar_original_hash_26, u0_.reset_token_token AS reset_token_token_27, u0_.reset_token_expires AS reset_token_expires_28, u0_.city_id AS city_id_29 FROM "user_users" u0_ WHERE u0_.email = '80e51a4e-1b0b-456a-93dd-210d099ca9ed@775d2008-9edb-4e71-bccf-e3a51be771ba.com';

SELECT
  u0_.id AS id_0,
  u0_.date AS date_1,
  u0_.email AS email_2,
  u0_.phone AS phone_3,
  u0_.phone_numeric AS phone_numeric_4,
  u0_.privacy_mask AS privacy_mask_5,
  u0_.push_settings_mask AS push_settings_mask_6,
  u0_.password AS password_7,
  u0_.about AS about_8,
  u0_.stuff AS stuff_9,
  u0_.vk_code_verifier AS vk_code_verifier_10,
  u0_.vk_id AS vk_id_11,
  u0_.vk_avatar AS vk_avatar_12,
  u0_.new_email AS new_email_13,
  u0_.new_email_token AS new_email_token_14,
  u0_.status AS status_15,
  u0_.role AS role_16,
  u0_.is_online AS is_online_17,
  u0_.last_visit AS last_visit_18,
  u0_.last_visit_at AS last_visit_at_19,
  u0_.confirm_token_token AS confirm_token_token_20,
  u0_.confirm_token_expires AS confirm_token_expires_21,
  u0_.name_first AS name_first_22,
  u0_.name_last AS name_last_23,
  u0_.name_middle AS name_middle_24,
  u0_.avatar_small_hash AS avatar_small_hash_25,
  u0_.avatar_original_hash AS avatar_original_hash_26,
  u0_.reset_token_token AS reset_token_token_27,
  u0_.reset_token_expires AS reset_token_expires_28,
  u0_.city_id AS city_id_29
FROM
  "user_users" u0_
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.date AS date_1, u0_.email AS email_2, u0_.phone AS phone_3, u0_.phone_numeric AS phone_numeric_4, u0_.privacy_mask AS privacy_mask_5, u0_.push_settings_mask AS push_settings_mask_6, u0_.password AS password_7, u0_.about AS about_8, u0_.stuff AS stuff_9, u0_.vk_code_verifier AS vk_code_verifier_10, u0_.vk_id AS vk_id_11, u0_.vk_avatar AS vk_avatar_12, u0_.new_email AS new_email_13, u0_.new_email_token AS new_email_token_14, u0_.status AS status_15, u0_.role AS role_16, u0_.is_online AS is_online_17, u0_.last_visit AS last_visit_18, u0_.last_visit_at AS last_visit_at_19, u0_.confirm_token_token AS confirm_token_token_20, u0_.confirm_token_expires AS confirm_token_expires_21, u0_.name_first AS name_first_22, u0_.name_last AS name_last_23, u0_.name_middle AS name_middle_24, u0_.avatar_small_hash AS avatar_small_hash_25, u0_.avatar_original_hash AS avatar_original_hash_26, u0_.reset_token_token AS reset_token_token_27, u0_.reset_token_expires AS reset_token_expires_28, u0_.city_id AS city_id_29 FROM "user_users" u0_ WHERE u0_.id = '73ee8243-c222-4e78-8531-b0b1108d27bc';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  COUNT(DISTINCT a.id) AS total_results
FROM
  item_items a
WHERE
  a.user_id = ?
LIMIT
  1

SELECT COUNT(DISTINCT a.id) AS total_results FROM item_items a WHERE a.user_id = '73ee8243-c222-4e78-8531-b0b1108d27bc' LIMIT 1;

UPDATE
  "user_users"
SET
  last_visit_at = ?
WHERE
  id = ?

UPDATE "user_users" SET last_visit_at = '2026-05-03 22:55:41' WHERE id = '73ee8243-c222-4e78-8531-b0b1108d27bc';

"COMMIT"

"COMMIT";