Symfony Profiler

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tickets t0_
  LEFT JOIN institutions i1_ ON t0_.institutions_id = i1_.id
  LEFT JOIN `user` u2_ ON t0_.user_id = u2_.id
  LEFT JOIN tickets_status t3_ ON t0_.status_id = t3_.id
  LEFT JOIN user_data u4_ ON u2_.id = u4_.user_id
  LEFT JOIN cars c5_ ON u2_.id = c5_.user_id
  LEFT JOIN tickets_history t6_ ON t0_.id = t6_.tickets_id
  AND (
    t6_.id = (
      SELECT
        MIN(t7_.id) AS sclr_1
      FROM
        tickets_history t7_
      WHERE
        t7_.tickets_id = t0_.id
    )
  )
  LEFT JOIN `user` u8_ ON t6_.user_id = u8_.id
  LEFT JOIN user_data u9_ ON u8_.id = u9_.user_id

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tickets t0_ LEFT JOIN institutions i1_ ON t0_.institutions_id = i1_.id LEFT JOIN `user` u2_ ON t0_.user_id = u2_.id LEFT JOIN tickets_status t3_ ON t0_.status_id = t3_.id LEFT JOIN user_data u4_ ON u2_.id = u4_.user_id LEFT JOIN cars c5_ ON u2_.id = c5_.user_id LEFT JOIN tickets_history t6_ ON t0_.id = t6_.tickets_id AND (t6_.id = (SELECT MIN(t7_.id) AS sclr_1 FROM tickets_history t7_ WHERE t7_.tickets_id = t0_.id)) LEFT JOIN `user` u8_ ON t6_.user_id = u8_.id LEFT JOIN user_data u9_ ON u8_.id = u9_.user_id;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.date_add AS date_add_2,
  t0_.date_modify AS date_modify_3,
  t0_.coordinator AS coordinator_4,
  t0_.coordinator_phone AS coordinator_phone_5,
  t0_.date_of_visit AS date_of_visit_6,
  t0_.number_of_children AS number_of_children_7,
  t0_.email_poster AS email_poster_8,
  t0_.rate AS rate_9,
  t0_.provision AS provision_10,
  t0_.costs_accommodation AS costs_accommodation_11,
  t0_.other_costs AS other_costs_12,
  t0_.downloaded_in_cash AS downloaded_in_cash_13,
  (
    (
      COALESCE(u1_.paycheck_procent, 0.25) * (
        (
          COALESCE(t0_.number_of_children, 0) * COALESCE(t0_.rate, 0)
        ) - COALESCE(t0_.provision, 0)
      )
    ) - COALESCE(t0_.downloaded_in_cash, 0)
  ) AS sclr_14,
  (
    (
      COALESCE(t0_.number_of_children, 0) * COALESCE(t0_.rate, 0)
    ) - COALESCE(t0_.provision, 0)
  ) AS sclr_15,
  (
    COALESCE(u1_.paycheck_procent, 0.25) * (
      (
        COALESCE(t0_.number_of_children, 0) * COALESCE(t0_.rate, 0)
      ) - COALESCE(t0_.provision, 0)
    )
  ) AS sclr_16,
  (
    COALESCE(t0_.number_of_kilometers, 0) * (
      COALESCE(c2_.combustion, 0) / 100
    ) * COALESCE(t0_.fuel_price, 0)
  ) AS sclr_17,
  t0_.fuel_price AS fuel_price_18,
  t0_.number_of_kilometers AS number_of_kilometers_19,
  i3_.id AS id_20,
  i3_.wojewodztwo AS wojewodztwo_21,
  i3_.powiat AS powiat_22,
  i3_.gmina AS gmina_23,
  i3_.typ AS typ_24,
  i3_.publicznosc_status AS publicznosc_status_25,
  i3_.miejscowosc AS miejscowosc_26,
  i3_.kod_pocztowy AS kod_pocztowy_27,
  i3_.numer_budynku AS numer_budynku_28,
  i3_.numer_lokalu AS numer_lokalu_29,
  i3_.ulica AS ulica_30,
  u1_.id AS id_31,
  u1_.name AS name_32,
  u1_.last_name AS last_name_33,
  u1_.color AS color_34,
  t4_.name AS name_35,
  u5_.name AS name_36,
  u5_.last_name AS last_name_37
FROM
  tickets t0_
  LEFT JOIN institutions i3_ ON t0_.institutions_id = i3_.id
  LEFT JOIN `user` u6_ ON t0_.user_id = u6_.id
  LEFT JOIN tickets_status t4_ ON t0_.status_id = t4_.id
  LEFT JOIN user_data u1_ ON u6_.id = u1_.user_id
  LEFT JOIN cars c2_ ON u6_.id = c2_.user_id
  LEFT JOIN tickets_history t7_ ON t0_.id = t7_.tickets_id
  AND (
    t7_.id = (
      SELECT
        MIN(t8_.id) AS sclr_38
      FROM
        tickets_history t8_
      WHERE
        t8_.tickets_id = t0_.id
    )
  )
  LEFT JOIN `user` u9_ ON t7_.user_id = u9_.id
  LEFT JOIN user_data u5_ ON u9_.id = u5_.user_id
ORDER BY
  t0_.id ASC
LIMIT
  100
OFFSET
  6100

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.date_add AS date_add_2, t0_.date_modify AS date_modify_3, t0_.coordinator AS coordinator_4, t0_.coordinator_phone AS coordinator_phone_5, t0_.date_of_visit AS date_of_visit_6, t0_.number_of_children AS number_of_children_7, t0_.email_poster AS email_poster_8, t0_.rate AS rate_9, t0_.provision AS provision_10, t0_.costs_accommodation AS costs_accommodation_11, t0_.other_costs AS other_costs_12, t0_.downloaded_in_cash AS downloaded_in_cash_13, ((COALESCE(u1_.paycheck_procent, 0.25) * ((COALESCE(t0_.number_of_children, 0) * COALESCE(t0_.rate, 0)) - COALESCE(t0_.provision, 0))) - COALESCE(t0_.downloaded_in_cash, 0)) AS sclr_14, ((COALESCE(t0_.number_of_children, 0) * COALESCE(t0_.rate, 0)) - COALESCE(t0_.provision, 0)) AS sclr_15, (COALESCE(u1_.paycheck_procent, 0.25) * ((COALESCE(t0_.number_of_children, 0) * COALESCE(t0_.rate, 0)) - COALESCE(t0_.provision, 0))) AS sclr_16, (COALESCE(t0_.number_of_kilometers, 0) * (COALESCE(c2_.combustion, 0) / 100) * COALESCE(t0_.fuel_price, 0)) AS sclr_17, t0_.fuel_price AS fuel_price_18, t0_.number_of_kilometers AS number_of_kilometers_19, i3_.id AS id_20, i3_.wojewodztwo AS wojewodztwo_21, i3_.powiat AS powiat_22, i3_.gmina AS gmina_23, i3_.typ AS typ_24, i3_.publicznosc_status AS publicznosc_status_25, i3_.miejscowosc AS miejscowosc_26, i3_.kod_pocztowy AS kod_pocztowy_27, i3_.numer_budynku AS numer_budynku_28, i3_.numer_lokalu AS numer_lokalu_29, i3_.ulica AS ulica_30, u1_.id AS id_31, u1_.name AS name_32, u1_.last_name AS last_name_33, u1_.color AS color_34, t4_.name AS name_35, u5_.name AS name_36, u5_.last_name AS last_name_37 FROM tickets t0_ LEFT JOIN institutions i3_ ON t0_.institutions_id = i3_.id LEFT JOIN `user` u6_ ON t0_.user_id = u6_.id LEFT JOIN tickets_status t4_ ON t0_.status_id = t4_.id LEFT JOIN user_data u1_ ON u6_.id = u1_.user_id LEFT JOIN cars c2_ ON u6_.id = c2_.user_id LEFT JOIN tickets_history t7_ ON t0_.id = t7_.tickets_id AND (t7_.id = (SELECT MIN(t8_.id) AS sclr_38 FROM tickets_history t8_ WHERE t8_.tickets_id = t0_.id)) LEFT JOIN `user` u9_ ON t7_.user_id = u9_.id LEFT JOIN user_data u5_ ON u9_.id = u5_.user_id ORDER BY t0_.id ASC LIMIT 100 OFFSET 6100;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.confirmed AS confirmed_6,
  t0.actived AS actived_7,
  t0.access AS access_8,
  t0.date_register AS date_register_9,
  t0.date_activity AS date_activity_10,
  t0.api_token AS api_token_11,
  t0.google_calendar AS google_calendar_12,
  t0.google_order AS google_order_13,
  t14.id AS id_15,
  t14.name AS name_16,
  t14.last_name AS last_name_17,
  t14.phone AS phone_18,
  t14.street AS street_19,
  t14.postcode AS postcode_20,
  t14.city AS city_21,
  t14.nip AS nip_22,
  t14.company AS company_23,
  t14.regon AS regon_24,
  t14.home_number AS home_number_25,
  t14.apartment_number AS apartment_number_26,
  t14.description AS description_27,
  t14.social_facebook AS social_facebook_28,
  t14.social_twitter AS social_twitter_29,
  t14.social_instagram AS social_instagram_30,
  t14.social_linkedin AS social_linkedin_31,
  t14.social_youtube AS social_youtube_32,
  t14.color AS color_33,
  t14.paycheck_procent AS paycheck_procent_34,
  t14.second_color AS second_color_35,
  t14.user_id AS user_id_36,
  t14.photo_id AS photo_id_37,
  t14.user_email_template_id AS user_email_template_id_38,
  t39.id AS id_40,
  t39.sender_email AS sender_email_41,
  t39.sender_label AS sender_label_42,
  t39.sender_pass AS sender_pass_43,
  t39.sender_host AS sender_host_44,
  t39.sender_port AS sender_port_45,
  t39.footer AS footer_46,
  t39.receiver_host AS receiver_host_47,
  t39.receiver_port AS receiver_port_48,
  t39.last_generation_imap_ai_response AS last_generation_imap_ai_response_49,
  t39.user_id AS user_id_50,
  t51.id AS id_52,
  t51.title AS title_53,
  t51.car_type AS car_type_54,
  t51.date_add AS date_add_55,
  t51.date_modify AS date_modify_56,
  t51.content AS content_57,
  t51.combustion AS combustion_58,
  t51.current_odometer AS current_odometer_59,
  t51.odometer_since_inspection AS odometer_since_inspection_60,
  t51.insurance_expiration_date AS insurance_expiration_date_61,
  t51.inspection_expiration_date AS inspection_expiration_date_62,
  t51.status_id AS status_id_63,
  t51.user_id AS user_id_64,
  t65.id AS id_66,
  t65.title AS title_67,
  t65.date_add AS date_add_68,
  t65.date_modify AS date_modify_69,
  t65.number AS number_70,
  t65.register_date AS register_date_71,
  t65.service_date AS service_date_72,
  t65.status_id AS status_id_73,
  t65.user_id AS user_id_74
FROM
  `user` t0
  LEFT JOIN user_data t14 ON t14.user_id = t0.id
  LEFT JOIN user_email t39 ON t39.user_id = t0.id
  LEFT JOIN cars t51 ON t51.user_id = t0.id
  LEFT JOIN cash_registers t65 ON t65.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.is_verified AS is_verified_5, t0.confirmed AS confirmed_6, t0.actived AS actived_7, t0.access AS access_8, t0.date_register AS date_register_9, t0.date_activity AS date_activity_10, t0.api_token AS api_token_11, t0.google_calendar AS google_calendar_12, t0.google_order AS google_order_13, t14.id AS id_15, t14.name AS name_16, t14.last_name AS last_name_17, t14.phone AS phone_18, t14.street AS street_19, t14.postcode AS postcode_20, t14.city AS city_21, t14.nip AS nip_22, t14.company AS company_23, t14.regon AS regon_24, t14.home_number AS home_number_25, t14.apartment_number AS apartment_number_26, t14.description AS description_27, t14.social_facebook AS social_facebook_28, t14.social_twitter AS social_twitter_29, t14.social_instagram AS social_instagram_30, t14.social_linkedin AS social_linkedin_31, t14.social_youtube AS social_youtube_32, t14.color AS color_33, t14.paycheck_procent AS paycheck_procent_34, t14.second_color AS second_color_35, t14.user_id AS user_id_36, t14.photo_id AS photo_id_37, t14.user_email_template_id AS user_email_template_id_38, t39.id AS id_40, t39.sender_email AS sender_email_41, t39.sender_label AS sender_label_42, t39.sender_pass AS sender_pass_43, t39.sender_host AS sender_host_44, t39.sender_port AS sender_port_45, t39.footer AS footer_46, t39.receiver_host AS receiver_host_47, t39.receiver_port AS receiver_port_48, t39.last_generation_imap_ai_response AS last_generation_imap_ai_response_49, t39.user_id AS user_id_50, t51.id AS id_52, t51.title AS title_53, t51.car_type AS car_type_54, t51.date_add AS date_add_55, t51.date_modify AS date_modify_56, t51.content AS content_57, t51.combustion AS combustion_58, t51.current_odometer AS current_odometer_59, t51.odometer_since_inspection AS odometer_since_inspection_60, t51.insurance_expiration_date AS insurance_expiration_date_61, t51.inspection_expiration_date AS inspection_expiration_date_62, t51.status_id AS status_id_63, t51.user_id AS user_id_64, t65.id AS id_66, t65.title AS title_67, t65.date_add AS date_add_68, t65.date_modify AS date_modify_69, t65.number AS number_70, t65.register_date AS register_date_71, t65.service_date AS service_date_72, t65.status_id AS status_id_73, t65.user_id AS user_id_74 FROM `user` t0 LEFT JOIN user_data t14 ON t14.user_id = t0.id LEFT JOIN user_email t39 ON t39.user_id = t0.id LEFT JOIN cars t51 ON t51.user_id = t0.id LEFT JOIN cash_registers t65 ON t65.user_id = t0.id WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.name AS name_3,
  t0.status_id AS status_id_4
FROM
  tickets_status_variants t0
WHERE
  t0.status_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.name AS name_3, t0.status_id AS status_id_4 FROM tickets_status_variants t0 WHERE t0.status_id = 8;

SELECT
  count(t0_.id) AS sclr_0
FROM
  tickets t0_

SELECT count(t0_.id) AS sclr_0 FROM tickets t0_;

SELECT
  t0.id AS id_1,
  t0.access_token AS access_token_2,
  t0.refresh_token AS refresh_token_3,
  t0.access_token_expiry AS access_token_expiry_4
FROM
  secret t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.refresh_token AS refresh_token_3, t0.access_token_expiry AS access_token_expiry_4 FROM secret t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.color AS color_4,
  t0.name_action AS name_action_5,
  t0.color_text AS color_text_6,
  t0.color_id AS color_id_7,
  t0.email_template_id AS email_template_id_8,
  t0.email_template_admin_id AS email_template_admin_id_9
FROM
  tickets_status t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.color AS color_4, t0.name_action AS name_action_5, t0.color_text AS color_text_6, t0.color_id AS color_id_7, t0.email_template_id AS email_template_id_8, t0.email_template_admin_id AS email_template_admin_id_9 FROM tickets_status t0;