Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.author AS author_2,
  b0_.year AS year_3,
  b0_.genre AS genre_4,
  b0_.description AS description_5,
  b0_.review AS review_6,
  b0_.created_at AS created_at_7,
  b0_.updated_at AS updated_at_8,
  b0_.sort_order AS sort_order_9,
  r1_.id AS id_10,
  r1_.text AS text_11,
  r1_.created_at AS created_at_12,
  a2_.id AS id_13,
  a2_.status AS status_14,
  a2_.type AS type_15,
  a2_.name AS name_16,
  a2_.path AS path_17,
  a2_.mime_type AS mime_type_18,
  a2_.size AS size_19,
  a2_.created_at AS created_at_20,
  a2_.updated_at AS updated_at_21,
  b3_.id AS id_22,
  b3_.answer AS answer_23,
  b0_.preview_id AS preview_id_24,
  b0_.user_id AS user_id_25,
  r1_.user_id AS user_id_26,
  r1_.book_id AS book_id_27,
  r1_.question_book_id AS question_book_id_28,
  a2_.user_id AS user_id_29,
  b3_.book_id AS book_id_30,
  b3_.user_id AS user_id_31,
  b3_.question_id AS question_id_32
FROM
  books b0_
  LEFT JOIN review_book r1_ ON b0_.id = r1_.book_id
  LEFT JOIN attachments a2_ ON b0_.preview_id = a2_.id
  LEFT JOIN book_question_answer b3_ ON b0_.id = b3_.book_id
  AND (b3_.user_id = ?)
WHERE
  r1_.id IN (
    SELECT
      r4_.id
    FROM
      review_book r4_
    WHERE
      r4_.book_id = b0_.id
      AND r4_.user_id = ?
  )
ORDER BY
  b0_.sort_order ASC,
  r1_.created_at DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.author AS author_2, b0_.year AS year_3, b0_.genre AS genre_4, b0_.description AS description_5, b0_.review AS review_6, b0_.created_at AS created_at_7, b0_.updated_at AS updated_at_8, b0_.sort_order AS sort_order_9, r1_.id AS id_10, r1_.text AS text_11, r1_.created_at AS created_at_12, a2_.id AS id_13, a2_.status AS status_14, a2_.type AS type_15, a2_.name AS name_16, a2_.path AS path_17, a2_.mime_type AS mime_type_18, a2_.size AS size_19, a2_.created_at AS created_at_20, a2_.updated_at AS updated_at_21, b3_.id AS id_22, b3_.answer AS answer_23, b0_.preview_id AS preview_id_24, b0_.user_id AS user_id_25, r1_.user_id AS user_id_26, r1_.book_id AS book_id_27, r1_.question_book_id AS question_book_id_28, a2_.user_id AS user_id_29, b3_.book_id AS book_id_30, b3_.user_id AS user_id_31, b3_.question_id AS question_id_32 FROM books b0_ LEFT JOIN review_book r1_ ON b0_.id = r1_.book_id LEFT JOIN attachments a2_ ON b0_.preview_id = a2_.id LEFT JOIN book_question_answer b3_ ON b0_.id = b3_.book_id AND (b3_.user_id = 124) WHERE r1_.id IN (SELECT r4_.id FROM review_book r4_ WHERE r4_.book_id = b0_.id AND r4_.user_id = 124) ORDER BY b0_.sort_order ASC, r1_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.status AS status_5,
  t0.phone_number AS phone_number_6,
  t0.email AS email_7,
  t0.firstname AS firstname_8,
  t0.lastname AS lastname_9,
  t0.sex AS sex_10,
  t0.relationship AS relationship_11,
  t0.birthday AS birthday_12,
  t0.height AS height_13,
  t0.children AS children_14,
  t0.food_type AS food_type_15,
  t0.zodiac_sign AS zodiac_sign_16,
  t0.human_design AS human_design_17,
  t0.human_design_type AS human_design_type_18,
  t0.instagram AS instagram_19,
  t0.vkontakte AS vkontakte_20,
  t0.youtube AS youtube_21,
  t0.website AS website_22,
  t0.contact_email AS contact_email_23,
  t0.contact_phone_number AS contact_phone_number_24,
  t0.telegram AS telegram_25,
  t0.odnoklassniki AS odnoklassniki_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.activity_at AS activity_at_29,
  t0.last_seen_at AS last_seen_at_30,
  t0.offer AS offer_31,
  t0.profile_status AS profile_status_32,
  t0.about_text AS about_text_33,
  t0.dating_description AS dating_description_34,
  t0.visibility AS visibility_35,
  t0.activity AS activity_36,
  t0.invite_id AS invite_id_37,
  t0.profile_picture_id AS profile_picture_id_38,
  t0.question_id AS question_id_39,
  t0.city_id AS city_id_40
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5, t0.phone_number AS phone_number_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.sex AS sex_10, t0.relationship AS relationship_11, t0.birthday AS birthday_12, t0.height AS height_13, t0.children AS children_14, t0.food_type AS food_type_15, t0.zodiac_sign AS zodiac_sign_16, t0.human_design AS human_design_17, t0.human_design_type AS human_design_type_18, t0.instagram AS instagram_19, t0.vkontakte AS vkontakte_20, t0.youtube AS youtube_21, t0.website AS website_22, t0.contact_email AS contact_email_23, t0.contact_phone_number AS contact_phone_number_24, t0.telegram AS telegram_25, t0.odnoklassniki AS odnoklassniki_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.activity_at AS activity_at_29, t0.last_seen_at AS last_seen_at_30, t0.offer AS offer_31, t0.profile_status AS profile_status_32, t0.about_text AS about_text_33, t0.dating_description AS dating_description_34, t0.visibility AS visibility_35, t0.activity AS activity_36, t0.invite_id AS invite_id_37, t0.profile_picture_id AS profile_picture_id_38, t0.question_id AS question_id_39, t0.city_id AS city_id_40 FROM users t0 WHERE t0.id = 124;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.status AS status_5,
  t0.phone_number AS phone_number_6,
  t0.email AS email_7,
  t0.firstname AS firstname_8,
  t0.lastname AS lastname_9,
  t0.sex AS sex_10,
  t0.relationship AS relationship_11,
  t0.birthday AS birthday_12,
  t0.height AS height_13,
  t0.children AS children_14,
  t0.food_type AS food_type_15,
  t0.zodiac_sign AS zodiac_sign_16,
  t0.human_design AS human_design_17,
  t0.human_design_type AS human_design_type_18,
  t0.instagram AS instagram_19,
  t0.vkontakte AS vkontakte_20,
  t0.youtube AS youtube_21,
  t0.website AS website_22,
  t0.contact_email AS contact_email_23,
  t0.contact_phone_number AS contact_phone_number_24,
  t0.telegram AS telegram_25,
  t0.odnoklassniki AS odnoklassniki_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.activity_at AS activity_at_29,
  t0.last_seen_at AS last_seen_at_30,
  t0.offer AS offer_31,
  t0.profile_status AS profile_status_32,
  t0.about_text AS about_text_33,
  t0.dating_description AS dating_description_34,
  t0.visibility AS visibility_35,
  t0.activity AS activity_36,
  t0.invite_id AS invite_id_37,
  t0.profile_picture_id AS profile_picture_id_38,
  t0.question_id AS question_id_39,
  t0.city_id AS city_id_40
FROM
  users t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5, t0.phone_number AS phone_number_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.sex AS sex_10, t0.relationship AS relationship_11, t0.birthday AS birthday_12, t0.height AS height_13, t0.children AS children_14, t0.food_type AS food_type_15, t0.zodiac_sign AS zodiac_sign_16, t0.human_design AS human_design_17, t0.human_design_type AS human_design_type_18, t0.instagram AS instagram_19, t0.vkontakte AS vkontakte_20, t0.youtube AS youtube_21, t0.website AS website_22, t0.contact_email AS contact_email_23, t0.contact_phone_number AS contact_phone_number_24, t0.telegram AS telegram_25, t0.odnoklassniki AS odnoklassniki_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.activity_at AS activity_at_29, t0.last_seen_at AS last_seen_at_30, t0.offer AS offer_31, t0.profile_status AS profile_status_32, t0.about_text AS about_text_33, t0.dating_description AS dating_description_34, t0.visibility AS visibility_35, t0.activity AS activity_36, t0.invite_id AS invite_id_37, t0.profile_picture_id AS profile_picture_id_38, t0.question_id AS question_id_39, t0.city_id AS city_id_40 FROM users t0 WHERE t0.username = 'shakti' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.type AS type_3,
  t0.name AS name_4,
  t0.path AS path_5,
  t0.mime_type AS mime_type_6,
  t0.size AS size_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10
FROM
  attachments t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.type AS type_3, t0.name AS name_4, t0.path AS path_5, t0.mime_type AS mime_type_6, t0.size AS size_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM attachments t0 WHERE t0.id = 2468;

UPDATE
  users
SET
  activity_at = ?
WHERE
  id = ?

UPDATE users SET activity_at = '2025-12-04 13:17:48' WHERE id = 124;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.status AS status_3,
  t0.started_at AS started_at_4,
  t0.expires_at AS expires_at_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.cancelled_at AS cancelled_at_8,
  t0.price AS price_9,
  t0.yoo_kassa_payment_id AS yoo_kassa_payment_id_10,
  t0.yoo_kassa_refund_id AS yoo_kassa_refund_id_11,
  t0.user_id AS user_id_12
FROM
  subscriptions t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.status AS status_3, t0.started_at AS started_at_4, t0.expires_at AS expires_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.cancelled_at AS cancelled_at_8, t0.price AS price_9, t0.yoo_kassa_payment_id AS yoo_kassa_payment_id_10, t0.yoo_kassa_refund_id AS yoo_kassa_refund_id_11, t0.user_id AS user_id_12 FROM subscriptions t0 WHERE t0.user_id = 124;

"START TRANSACTION"

"START TRANSACTION";