Symfony Profiler

SELECT
  d0_.quantity AS quantity_0,
  d0_.price AS price_1,
  d0_.currency AS currency_2,
  d0_.id AS id_3,
  d0_.version AS version_4,
  d0_.name AS name_5,
  d0_.delivery_id AS delivery_id_6
FROM
  delivered_services d0_
  INNER JOIN service_deliveries s1_ ON d0_.delivery_id = s1_.id
WHERE
  s1_.trip_id = ?
ORDER BY
  d0_.id ASC

SELECT d0_.quantity AS quantity_0, d0_.price AS price_1, d0_.currency AS currency_2, d0_.id AS id_3, d0_.version AS version_4, d0_.name AS name_5, d0_.delivery_id AS delivery_id_6 FROM delivered_services d0_ INNER JOIN service_deliveries s1_ ON d0_.delivery_id = s1_.id WHERE s1_.trip_id = 394 ORDER BY d0_.id ASC;

SELECT
  s0_.service_type AS service_type_0,
  s0_.start_date AS start_date_1,
  s0_.end_date AS end_date_2,
  s0_.virtual_properties AS virtual_properties_3,
  s0_.payment_mode AS payment_mode_4,
  s0_.payment_status AS payment_status_5,
  s0_.id AS id_6,
  s0_.version AS version_7,
  s0_.notes AS notes_8,
  s1_.bank_account_number AS bank_account_number_9,
  s1_.currency AS currency_10,
  s1_.tour_leader_notice AS tour_leader_notice_11,
  s1_.tin AS tin_12,
  s1_.website AS website_13,
  s1_.id AS id_14,
  s1_.version AS version_15,
  s1_.notes AS notes_16,
  s1_.email AS email_17,
  s1_.phone AS phone_18,
  s1_.name AS name_19,
  s1_.address_line AS address_line_20,
  s1_.address_postal_code AS address_postal_code_21,
  s1_.address_city AS address_city_22,
  s1_.address_country_code AS address_country_code_23,
  s1_.address_google_place AS address_google_place_24,
  s1_.birth_date AS birth_date_25,
  s1_.name_2 AS name_2_26,
  s1_.name_1 AS name_1_27,
  s1_.name_2 AS name_2_28,
  s0_.status_id AS status_id_29,
  s0_.trip_id AS trip_id_30,
  s0_.supplier_id AS supplier_id_31,
  s1_.discriminator AS discriminator_32,
  s1_.operator_id AS operator_id_33
FROM
  service_deliveries s0_
  INNER JOIN suppliers s1_ ON s0_.supplier_id = s1_.id
  AND s1_.discriminator IN (
    'TRANSPORT', 'ACCOMMODATION', 'ATTRACTION',
    'TOUR_LEADER'
  )
WHERE
  s0_.trip_id = ?
ORDER BY
  s0_.start_date ASC

SELECT s0_.service_type AS service_type_0, s0_.start_date AS start_date_1, s0_.end_date AS end_date_2, s0_.virtual_properties AS virtual_properties_3, s0_.payment_mode AS payment_mode_4, s0_.payment_status AS payment_status_5, s0_.id AS id_6, s0_.version AS version_7, s0_.notes AS notes_8, s1_.bank_account_number AS bank_account_number_9, s1_.currency AS currency_10, s1_.tour_leader_notice AS tour_leader_notice_11, s1_.tin AS tin_12, s1_.website AS website_13, s1_.id AS id_14, s1_.version AS version_15, s1_.notes AS notes_16, s1_.email AS email_17, s1_.phone AS phone_18, s1_.name AS name_19, s1_.address_line AS address_line_20, s1_.address_postal_code AS address_postal_code_21, s1_.address_city AS address_city_22, s1_.address_country_code AS address_country_code_23, s1_.address_google_place AS address_google_place_24, s1_.birth_date AS birth_date_25, s1_.name_2 AS name_2_26, s1_.name_1 AS name_1_27, s1_.name_2 AS name_2_28, s0_.status_id AS status_id_29, s0_.trip_id AS trip_id_30, s0_.supplier_id AS supplier_id_31, s1_.discriminator AS discriminator_32, s1_.operator_id AS operator_id_33 FROM service_deliveries s0_ INNER JOIN suppliers s1_ ON s0_.supplier_id = s1_.id AND s1_.discriminator IN ('TRANSPORT', 'ACCOMMODATION', 'ATTRACTION', 'TOUR_LEADER') WHERE s0_.trip_id = 394 ORDER BY s0_.start_date ASC;

SELECT
  t0.role AS role_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.password AS password_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.version AS version_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.operator_id AS operator_id_10
FROM
  employees t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.role AS role_1, t0.email AS email_2, t0.phone AS phone_3, t0.password AS password_4, t0.active AS active_5, t0.id AS id_6, t0.version AS version_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.operator_id AS operator_id_10 FROM employees t0 WHERE t0.email = 'aleksandra.salachna@allintravel.pl' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.version AS version_4,
  t0.name AS name_5,
  t0.text_color AS text_color_6,
  t0.text_background_color AS text_background_color_7,
  t0.operator_id AS operator_id_8,
  t0.discriminator
FROM
  dictionaries t0
WHERE
  t0.id = ?
  AND t0.discriminator IN (
    'accommodation_trip_field_status',
    'attraction_trip_field_status',
    'client_trip_field_status', 'contract_trip_field_status',
    'dates_trip_field_status', 'external_identifier_trip_field_status',
    'name_trip_field_status', 'organization_trip_field_status',
    'participants_counts_trip_field_status',
    'tour_leader_trip_field_status',
    'transport_trip_field_status'
  )

SELECT t0.code AS code_1, t0.position AS position_2, t0.id AS id_3, t0.version AS version_4, t0.name AS name_5, t0.text_color AS text_color_6, t0.text_background_color AS text_background_color_7, t0.operator_id AS operator_id_8, t0.discriminator FROM dictionaries t0 WHERE t0.id = 205 AND t0.discriminator IN ('accommodation_trip_field_status', 'attraction_trip_field_status', 'client_trip_field_status', 'contract_trip_field_status', 'dates_trip_field_status', 'external_identifier_trip_field_status', 'name_trip_field_status', 'organization_trip_field_status', 'participants_counts_trip_field_status', 'tour_leader_trip_field_status', 'transport_trip_field_status');

SELECT
  d0_.currency AS currency_0,
  SUM(d0_.quantity * d0_.price) AS sclr_1
FROM
  delivered_services d0_
  INNER JOIN service_deliveries s1_ ON d0_.delivery_id = s1_.id
WHERE
  s1_.trip_id = ?
  AND s1_.payment_mode = ?
GROUP BY
  d0_.currency

SELECT d0_.currency AS currency_0, SUM(d0_.quantity * d0_.price) AS sclr_1 FROM delivered_services d0_ INNER JOIN service_deliveries s1_ ON d0_.delivery_id = s1_.id WHERE s1_.trip_id = 394 AND s1_.payment_mode = 'tour_leader' GROUP BY d0_.currency;

SELECT
  a0_.field AS field_0,
  a0_.id AS id_1,
  a0_.version AS version_2,
  d1_.code AS code_3,
  d1_.position AS position_4,
  d1_.id AS id_5,
  d1_.version AS version_6,
  d1_.name AS name_7,
  d1_.text_color AS text_color_8,
  d1_.text_background_color AS text_background_color_9,
  a0_.trip_id AS trip_id_10,
  a0_.status_id AS status_id_11,
  d1_.discriminator AS discriminator_12,
  d1_.operator_id AS operator_id_13
FROM
  assigned_trip_field_statuses a0_
  INNER JOIN dictionaries d1_ ON a0_.status_id = d1_.id
  AND d1_.discriminator IN (
    'accommodation_trip_field_status',
    'attraction_trip_field_status',
    'client_trip_field_status', 'contract_trip_field_status',
    'dates_trip_field_status', 'external_identifier_trip_field_status',
    'name_trip_field_status', 'organization_trip_field_status',
    'participants_counts_trip_field_status',
    'tour_leader_trip_field_status',
    'transport_trip_field_status'
  )
WHERE
  a0_.trip_id IN (?)

SELECT a0_.field AS field_0, a0_.id AS id_1, a0_.version AS version_2, d1_.code AS code_3, d1_.position AS position_4, d1_.id AS id_5, d1_.version AS version_6, d1_.name AS name_7, d1_.text_color AS text_color_8, d1_.text_background_color AS text_background_color_9, a0_.trip_id AS trip_id_10, a0_.status_id AS status_id_11, d1_.discriminator AS discriminator_12, d1_.operator_id AS operator_id_13 FROM assigned_trip_field_statuses a0_ INNER JOIN dictionaries d1_ ON a0_.status_id = d1_.id AND d1_.discriminator IN ('accommodation_trip_field_status', 'attraction_trip_field_status', 'client_trip_field_status', 'contract_trip_field_status', 'dates_trip_field_status', 'external_identifier_trip_field_status', 'name_trip_field_status', 'organization_trip_field_status', 'participants_counts_trip_field_status', 'tour_leader_trip_field_status', 'transport_trip_field_status') WHERE a0_.trip_id IN (394);

SELECT
  t0.external_identifier AS external_identifier_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.paid_participants_count AS paid_participants_count_4,
  t0.free_participants_count AS free_participants_count_5,
  t0.contract AS contract_6,
  t0.virtual_properties AS virtual_properties_7,
  t0.properties_notes AS properties_notes_8,
  t0.creation_timestamp AS creation_timestamp_9,
  t0.id AS id_10,
  t0.version AS version_11,
  t0.notes AS notes_12,
  t0.name AS name_13,
  t0.supervisor_id AS supervisor_id_14,
  t0.client_id AS client_id_15,
  t0.organization_id AS organization_id_16,
  t0.offer_id AS offer_id_17,
  t0.operator_id AS operator_id_18
FROM
  trips t0
WHERE
  t0.id = ?

SELECT t0.external_identifier AS external_identifier_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.paid_participants_count AS paid_participants_count_4, t0.free_participants_count AS free_participants_count_5, t0.contract AS contract_6, t0.virtual_properties AS virtual_properties_7, t0.properties_notes AS properties_notes_8, t0.creation_timestamp AS creation_timestamp_9, t0.id AS id_10, t0.version AS version_11, t0.notes AS notes_12, t0.name AS name_13, t0.supervisor_id AS supervisor_id_14, t0.client_id AS client_id_15, t0.organization_id AS organization_id_16, t0.offer_id AS offer_id_17, t0.operator_id AS operator_id_18 FROM trips t0 WHERE t0.id = 394;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.external_identifier AS external_identifier_2,
  t0_.start_date AS start_date_3,
  t0_.end_date AS end_date_4,
  t0_.paid_participants_count AS paid_participants_count_5,
  t0_.free_participants_count AS free_participants_count_6,
  t0_.contract AS contract_7,
  t0_.supervisor_id AS sclr_8,
  t0_.client_id AS sclr_9,
  t0_.organization_id AS sclr_10,
  t0_.offer_id AS sclr_11,
  t0_.virtual_properties AS virtual_properties_12,
  t0_.properties_notes AS properties_notes_13,
  t0_.version AS version_14,
  t0_.creation_timestamp AS creation_timestamp_15
FROM
  trips t0_
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.external_identifier AS external_identifier_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.paid_participants_count AS paid_participants_count_5, t0_.free_participants_count AS free_participants_count_6, t0_.contract AS contract_7, t0_.supervisor_id AS sclr_8, t0_.client_id AS sclr_9, t0_.organization_id AS sclr_10, t0_.offer_id AS sclr_11, t0_.virtual_properties AS virtual_properties_12, t0_.properties_notes AS properties_notes_13, t0_.version AS version_14, t0_.creation_timestamp AS creation_timestamp_15 FROM trips t0_ WHERE t0_.id = 394;