Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.telegram_id AS telegram_id_6,
  t0.is_verified AS is_verified_7,
  t8.id AS id_9,
  t8.published AS published_10,
  t8.order_id AS order_id_11,
  t8.first_name AS first_name_12,
  t8.last_name AS last_name_13,
  t8.middle_name AS middle_name_14,
  t8.sport_rank AS sport_rank_15,
  t8.is_online AS is_online_16,
  t8.created_at AS created_at_17,
  t8.updated_at AS updated_at_18,
  t8.image_name AS image_name_19,
  t8.image_original_name AS image_original_name_20,
  t8.image_mime_type AS image_mime_type_21,
  t8.image_size AS image_size_22,
  t8.image_dimensions AS image_dimensions_23,
  t8.user_id AS user_id_24,
  t25.id AS id_26,
  t25.first_name AS first_name_27,
  t25.last_name AS last_name_28,
  t25.middle_name AS middle_name_29,
  t25.gender AS gender_30,
  t25.created_at AS created_at_31,
  t25.updated_at AS updated_at_32,
  t25.user_id AS user_id_33
FROM
  `user` t0
  LEFT JOIN trainer t8 ON t8.user_id = t0.id
  LEFT JOIN manager t25 ON t25.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.telegram_id AS telegram_id_6, t0.is_verified AS is_verified_7, t8.id AS id_9, t8.published AS published_10, t8.order_id AS order_id_11, t8.first_name AS first_name_12, t8.last_name AS last_name_13, t8.middle_name AS middle_name_14, t8.sport_rank AS sport_rank_15, t8.is_online AS is_online_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.image_name AS image_name_19, t8.image_original_name AS image_original_name_20, t8.image_mime_type AS image_mime_type_21, t8.image_size AS image_size_22, t8.image_dimensions AS image_dimensions_23, t8.user_id AS user_id_24, t25.id AS id_26, t25.first_name AS first_name_27, t25.last_name AS last_name_28, t25.middle_name AS middle_name_29, t25.gender AS gender_30, t25.created_at AS created_at_31, t25.updated_at AS updated_at_32, t25.user_id AS user_id_33 FROM `user` t0 LEFT JOIN trainer t8 ON t8.user_id = t0.id LEFT JOIN manager t25 ON t25.user_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.middle_name AS middle_name_4,
  t0.preferred_name AS preferred_name_5,
  t0.gender AS gender_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image_name AS image_name_9,
  t0.image_original_name AS image_original_name_10,
  t0.image_mime_type AS image_mime_type_11,
  t0.image_size AS image_size_12,
  t0.image_dimensions AS image_dimensions_13
FROM
  client t0

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.middle_name AS middle_name_4, t0.preferred_name AS preferred_name_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_name AS image_name_9, t0.image_original_name AS image_original_name_10, t0.image_mime_type AS image_mime_type_11, t0.image_size AS image_size_12, t0.image_dimensions AS image_dimensions_13 FROM client t0;

SELECT
  t0.id AS id_1,
  t0.published AS published_2,
  t0.order_id AS order_id_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.middle_name AS middle_name_6,
  t0.sport_rank AS sport_rank_7,
  t0.is_online AS is_online_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_name AS image_name_11,
  t0.image_original_name AS image_original_name_12,
  t0.image_mime_type AS image_mime_type_13,
  t0.image_size AS image_size_14,
  t0.image_dimensions AS image_dimensions_15,
  t0.user_id AS user_id_16
FROM
  trainer t0

SELECT t0.id AS id_1, t0.published AS published_2, t0.order_id AS order_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.middle_name AS middle_name_6, t0.sport_rank AS sport_rank_7, t0.is_online AS is_online_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_name AS image_name_11, t0.image_original_name AS image_original_name_12, t0.image_mime_type AS image_mime_type_13, t0.image_size AS image_size_14, t0.image_dimensions AS image_dimensions_15, t0.user_id AS user_id_16 FROM trainer t0;

SELECT
  t0.id AS id_6,
  t0.issue_date AS issue_date_7,
  t0.first_name AS first_name_8,
  t0.middle_name AS middle_name_9,
  t0.last_name AS last_name_10,
  t0.status AS status_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.client_id AS client_id_14,
  t0.discr,
  t1.series_and_number AS series_and_number_15,
  t1.department_code AS department_code_16,
  t1.issued_by AS issued_by_17,
  t1.address AS address_18,
  t1.gender AS gender_19,
  t1.birth_date AS birth_date_20,
  t2.series_and_number AS series_and_number_21,
  t2.issued_by AS issued_by_22,
  t2.expiration_date AS expiration_date_23,
  t2.weapon_model AS weapon_model_24,
  t2.caliber AS caliber_25,
  t2.weapon_serial_number AS weapon_serial_number_26,
  t2.permit_type AS permit_type_27,
  t3.series_and_number AS series_and_number_28,
  t4.medical_institution AS medical_institution_29,
  t4.series_and_number AS series_and_number_30,
  t5.series_and_number AS series_and_number_31
FROM
  document t0
  LEFT JOIN passport t1 ON t0.id = t1.id
  LEFT JOIN weapon_permit t2 ON t0.id = t2.id
  LEFT JOIN psych_permit t3 ON t0.id = t3.id
  LEFT JOIN med_cert t4 ON t0.id = t4.id
  LEFT JOIN criminal_record t5 ON t0.id = t5.id

SELECT t0.id AS id_6, t0.issue_date AS issue_date_7, t0.first_name AS first_name_8, t0.middle_name AS middle_name_9, t0.last_name AS last_name_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.client_id AS client_id_14, t0.discr, t1.series_and_number AS series_and_number_15, t1.department_code AS department_code_16, t1.issued_by AS issued_by_17, t1.address AS address_18, t1.gender AS gender_19, t1.birth_date AS birth_date_20, t2.series_and_number AS series_and_number_21, t2.issued_by AS issued_by_22, t2.expiration_date AS expiration_date_23, t2.weapon_model AS weapon_model_24, t2.caliber AS caliber_25, t2.weapon_serial_number AS weapon_serial_number_26, t2.permit_type AS permit_type_27, t3.series_and_number AS series_and_number_28, t4.medical_institution AS medical_institution_29, t4.series_and_number AS series_and_number_30, t5.series_and_number AS series_and_number_31 FROM document t0 LEFT JOIN passport t1 ON t0.id = t1.id LEFT JOIN weapon_permit t2 ON t0.id = t2.id LEFT JOIN psych_permit t3 ON t0.id = t3.id LEFT JOIN med_cert t4 ON t0.id = t4.id LEFT JOIN criminal_record t5 ON t0.id = t5.id;

SELECT
  t0.id AS id_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.discr_type
FROM
  category t0
  LEFT JOIN weapon_category t1 ON t0.id = t1.id
  LEFT JOIN training_category t2 ON t0.id = t2.id

SELECT t0.id AS id_3, t0.title AS title_4, t0.description AS description_5, t0.discr_type FROM category t0 LEFT JOIN weapon_category t1 ON t0.id = t1.id LEFT JOIN training_category t2 ON t0.id = t2.id;

SELECT
  g0_.id AS id_0,
  g0_.lft AS lft_1,
  g0_.lvl AS lvl_2,
  g0_.rgt AS rgt_3,
  g0_.slug AS slug_4,
  g0_.created_at AS created_at_5,
  g0_.updated_at AS updated_at_6,
  g0_.image_name AS image_name_7,
  g0_.image_original_name AS image_original_name_8,
  g0_.image_mime_type AS image_mime_type_9,
  g0_.image_size AS image_size_10,
  g0_.image_dimensions AS image_dimensions_11,
  g0_.tree_root AS tree_root_12,
  g0_.parent_id AS parent_id_13
FROM
  gallery_category g0_
WHERE
  g0_.parent_id IS NULL
ORDER BY
  g0_.lft ASC

SELECT g0_.id AS id_0, g0_.lft AS lft_1, g0_.lvl AS lvl_2, g0_.rgt AS rgt_3, g0_.slug AS slug_4, g0_.created_at AS created_at_5, g0_.updated_at AS updated_at_6, g0_.image_name AS image_name_7, g0_.image_original_name AS image_original_name_8, g0_.image_mime_type AS image_mime_type_9, g0_.image_size AS image_size_10, g0_.image_dimensions AS image_dimensions_11, g0_.tree_root AS tree_root_12, g0_.parent_id AS parent_id_13 FROM gallery_category g0_ WHERE g0_.parent_id IS NULL ORDER BY g0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.comment AS comment_3,
  t0.shot_count AS shot_count_4,
  t0.shot_fired AS shot_fired_5,
  t0.shot_trainer_fired AS shot_trainer_fired_6,
  t0.shot_trainer AS shot_trainer_7,
  t0.shot_brought AS shot_brought_8,
  t0.start_at AS start_at_9,
  t0.end_at AS end_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.trainer_id AS trainer_id_13,
  t0.client_id AS client_id_14,
  t0.service_id AS service_id_15,
  t0.gallery_direction_id AS gallery_direction_id_16
FROM
  mobile_lesson t0

SELECT t0.id AS id_1, t0.status AS status_2, t0.comment AS comment_3, t0.shot_count AS shot_count_4, t0.shot_fired AS shot_fired_5, t0.shot_trainer_fired AS shot_trainer_fired_6, t0.shot_trainer AS shot_trainer_7, t0.shot_brought AS shot_brought_8, t0.start_at AS start_at_9, t0.end_at AS end_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.trainer_id AS trainer_id_13, t0.client_id AS client_id_14, t0.service_id AS service_id_15, t0.gallery_direction_id AS gallery_direction_id_16 FROM mobile_lesson t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.calc_type AS calc_type_3,
  t0.prepaid_shots AS prepaid_shots_4,
  t0.reserve_shots AS reserve_shots_5,
  t0.trainer_shots AS trainer_shots_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  service t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.calc_type AS calc_type_3, t0.prepaid_shots AS prepaid_shots_4, t0.reserve_shots AS reserve_shots_5, t0.trainer_shots AS trainer_shots_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM service t0;

SELECT
  t0.id AS id_1,
  t0.pin_code_hash AS pin_code_hash_2,
  t0.token AS token_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.user_id AS user_id_6
FROM
  login_token t0

SELECT t0.id AS id_1, t0.pin_code_hash AS pin_code_hash_2, t0.token AS token_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6 FROM login_token t0;

SELECT
  t0.id AS id_1,
  t0.device_identifier AS device_identifier_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.trainer_id AS trainer_id_5
FROM
  trainer_device_session t0

SELECT t0.id AS id_1, t0.device_identifier AS device_identifier_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.trainer_id AS trainer_id_5 FROM trainer_device_session t0;

SELECT
  t0.id AS id_6,
  t0.issue_date AS issue_date_7,
  t0.first_name AS first_name_8,
  t0.middle_name AS middle_name_9,
  t0.last_name AS last_name_10,
  t0.status AS status_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.client_id AS client_id_14,
  t0.discr,
  t1.series_and_number AS series_and_number_15,
  t1.department_code AS department_code_16,
  t1.issued_by AS issued_by_17,
  t1.address AS address_18,
  t1.gender AS gender_19,
  t1.birth_date AS birth_date_20,
  t2.series_and_number AS series_and_number_21,
  t2.issued_by AS issued_by_22,
  t2.expiration_date AS expiration_date_23,
  t2.weapon_model AS weapon_model_24,
  t2.caliber AS caliber_25,
  t2.weapon_serial_number AS weapon_serial_number_26,
  t2.permit_type AS permit_type_27,
  t3.series_and_number AS series_and_number_28,
  t4.medical_institution AS medical_institution_29,
  t4.series_and_number AS series_and_number_30,
  t5.series_and_number AS series_and_number_31
FROM
  document t0
  LEFT JOIN passport t1 ON t0.id = t1.id
  LEFT JOIN weapon_permit t2 ON t0.id = t2.id
  LEFT JOIN psych_permit t3 ON t0.id = t3.id
  LEFT JOIN med_cert t4 ON t0.id = t4.id
  LEFT JOIN criminal_record t5 ON t0.id = t5.id
WHERE
  t0.client_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_6, t0.issue_date AS issue_date_7, t0.first_name AS first_name_8, t0.middle_name AS middle_name_9, t0.last_name AS last_name_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.client_id AS client_id_14, t0.discr, t1.series_and_number AS series_and_number_15, t1.department_code AS department_code_16, t1.issued_by AS issued_by_17, t1.address AS address_18, t1.gender AS gender_19, t1.birth_date AS birth_date_20, t2.series_and_number AS series_and_number_21, t2.issued_by AS issued_by_22, t2.expiration_date AS expiration_date_23, t2.weapon_model AS weapon_model_24, t2.caliber AS caliber_25, t2.weapon_serial_number AS weapon_serial_number_26, t2.permit_type AS permit_type_27, t3.series_and_number AS series_and_number_28, t4.medical_institution AS medical_institution_29, t4.series_and_number AS series_and_number_30, t5.series_and_number AS series_and_number_31 FROM document t0 LEFT JOIN passport t1 ON t0.id = t1.id LEFT JOIN weapon_permit t2 ON t0.id = t2.id LEFT JOIN psych_permit t3 ON t0.id = t3.id LEFT JOIN med_cert t4 ON t0.id = t4.id LEFT JOIN criminal_record t5 ON t0.id = t5.id WHERE t0.client_id = 1 ORDER BY t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.comment AS comment_3,
  t0.shot_count AS shot_count_4,
  t0.shot_fired AS shot_fired_5,
  t0.shot_trainer_fired AS shot_trainer_fired_6,
  t0.shot_trainer AS shot_trainer_7,
  t0.shot_brought AS shot_brought_8,
  t0.start_at AS start_at_9,
  t0.end_at AS end_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.trainer_id AS trainer_id_13,
  t0.client_id AS client_id_14,
  t0.service_id AS service_id_15,
  t0.gallery_direction_id AS gallery_direction_id_16
FROM
  mobile_lesson t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.comment AS comment_3, t0.shot_count AS shot_count_4, t0.shot_fired AS shot_fired_5, t0.shot_trainer_fired AS shot_trainer_fired_6, t0.shot_trainer AS shot_trainer_7, t0.shot_brought AS shot_brought_8, t0.start_at AS start_at_9, t0.end_at AS end_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.trainer_id AS trainer_id_13, t0.client_id AS client_id_14, t0.service_id AS service_id_15, t0.gallery_direction_id AS gallery_direction_id_16 FROM mobile_lesson t0 WHERE t0.client_id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.total_amount AS total_amount_3,
  t0.payment_method AS payment_method_4,
  t0.status AS status_5,
  t0.payment_url AS payment_url_6,
  t0.payment_identifier AS payment_identifier_7,
  t0.payment_details AS payment_details_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.client_id AS client_id_11,
  t0.mobile_lesson_id AS mobile_lesson_id_12
FROM
  invoice t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.total_amount AS total_amount_3, t0.payment_method AS payment_method_4, t0.status AS status_5, t0.payment_url AS payment_url_6, t0.payment_identifier AS payment_identifier_7, t0.payment_details AS payment_details_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.client_id AS client_id_11, t0.mobile_lesson_id AS mobile_lesson_id_12 FROM invoice t0 WHERE t0.client_id = 1;

SELECT
  t0.id AS id_6,
  t0.issue_date AS issue_date_7,
  t0.first_name AS first_name_8,
  t0.middle_name AS middle_name_9,
  t0.last_name AS last_name_10,
  t0.status AS status_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.client_id AS client_id_14,
  t0.discr,
  t1.series_and_number AS series_and_number_15,
  t1.department_code AS department_code_16,
  t1.issued_by AS issued_by_17,
  t1.address AS address_18,
  t1.gender AS gender_19,
  t1.birth_date AS birth_date_20,
  t2.series_and_number AS series_and_number_21,
  t2.issued_by AS issued_by_22,
  t2.expiration_date AS expiration_date_23,
  t2.weapon_model AS weapon_model_24,
  t2.caliber AS caliber_25,
  t2.weapon_serial_number AS weapon_serial_number_26,
  t2.permit_type AS permit_type_27,
  t3.series_and_number AS series_and_number_28,
  t4.medical_institution AS medical_institution_29,
  t4.series_and_number AS series_and_number_30,
  t5.series_and_number AS series_and_number_31
FROM
  document t0
  LEFT JOIN passport t1 ON t0.id = t1.id
  LEFT JOIN weapon_permit t2 ON t0.id = t2.id
  LEFT JOIN psych_permit t3 ON t0.id = t3.id
  LEFT JOIN med_cert t4 ON t0.id = t4.id
  LEFT JOIN criminal_record t5 ON t0.id = t5.id
WHERE
  t0.client_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_6, t0.issue_date AS issue_date_7, t0.first_name AS first_name_8, t0.middle_name AS middle_name_9, t0.last_name AS last_name_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.client_id AS client_id_14, t0.discr, t1.series_and_number AS series_and_number_15, t1.department_code AS department_code_16, t1.issued_by AS issued_by_17, t1.address AS address_18, t1.gender AS gender_19, t1.birth_date AS birth_date_20, t2.series_and_number AS series_and_number_21, t2.issued_by AS issued_by_22, t2.expiration_date AS expiration_date_23, t2.weapon_model AS weapon_model_24, t2.caliber AS caliber_25, t2.weapon_serial_number AS weapon_serial_number_26, t2.permit_type AS permit_type_27, t3.series_and_number AS series_and_number_28, t4.medical_institution AS medical_institution_29, t4.series_and_number AS series_and_number_30, t5.series_and_number AS series_and_number_31 FROM document t0 LEFT JOIN passport t1 ON t0.id = t1.id LEFT JOIN weapon_permit t2 ON t0.id = t2.id LEFT JOIN psych_permit t3 ON t0.id = t3.id LEFT JOIN med_cert t4 ON t0.id = t4.id LEFT JOIN criminal_record t5 ON t0.id = t5.id WHERE t0.client_id = 2 ORDER BY t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.comment AS comment_3,
  t0.shot_count AS shot_count_4,
  t0.shot_fired AS shot_fired_5,
  t0.shot_trainer_fired AS shot_trainer_fired_6,
  t0.shot_trainer AS shot_trainer_7,
  t0.shot_brought AS shot_brought_8,
  t0.start_at AS start_at_9,
  t0.end_at AS end_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.trainer_id AS trainer_id_13,
  t0.client_id AS client_id_14,
  t0.service_id AS service_id_15,
  t0.gallery_direction_id AS gallery_direction_id_16
FROM
  mobile_lesson t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.comment AS comment_3, t0.shot_count AS shot_count_4, t0.shot_fired AS shot_fired_5, t0.shot_trainer_fired AS shot_trainer_fired_6, t0.shot_trainer AS shot_trainer_7, t0.shot_brought AS shot_brought_8, t0.start_at AS start_at_9, t0.end_at AS end_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.trainer_id AS trainer_id_13, t0.client_id AS client_id_14, t0.service_id AS service_id_15, t0.gallery_direction_id AS gallery_direction_id_16 FROM mobile_lesson t0 WHERE t0.client_id = 2;