Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale_id AS locale_id_3,
  t0.luggage_id AS luggage_id_4
FROM
  luggage_translation t0
WHERE
  t0.luggage_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 2;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.zone AS zone_2,
  l0_.coordinates AS coordinates_3,
  l0_.is_airport AS is_airport_4,
  l0_.is_online AS is_online_5,
  l0_.is_active AS is_active_6,
  l0_.check_in_time AS check_in_time_7,
  l0_.is_favorite AS is_favorite_8,
  l0_.position AS position_9,
  l0_.type AS type_10,
  l0_.iso AS iso_11
FROM
  location l0_
  INNER JOIN course c1_ ON (
    c1_.from_id = l0_.id
    OR c1_.to_id = l0_.id
  )
WHERE
  l0_.is_active = 1
  AND l0_.is_online = 1
  AND c1_.is_active = 1
  AND c1_.is_online = 1
ORDER BY
  l0_.is_favorite DESC,
  l0_.position ASC,
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.zone AS zone_2, l0_.coordinates AS coordinates_3, l0_.is_airport AS is_airport_4, l0_.is_online AS is_online_5, l0_.is_active AS is_active_6, l0_.check_in_time AS check_in_time_7, l0_.is_favorite AS is_favorite_8, l0_.position AS position_9, l0_.type AS type_10, l0_.iso AS iso_11 FROM location l0_ INNER JOIN course c1_ ON (c1_.from_id = l0_.id OR c1_.to_id = l0_.id) WHERE l0_.is_active = 1 AND l0_.is_online = 1 AND c1_.is_active = 1 AND c1_.is_online = 1 ORDER BY l0_.is_favorite DESC, l0_.position ASC, l0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.name AS name_3,
  t0.email_booking AS email_booking_4,
  t0.email_financial AS email_financial_5,
  t0.phone_booking AS phone_booking_6,
  t0.phone_financial AS phone_financial_7,
  t0.domain AS domain_8,
  t0.markup AS markup_9,
  t0.percentage AS percentage_10,
  t0.is_yft_money_collect AS is_yft_money_collect_11,
  t0.invoicing AS invoicing_12,
  t0.is_client_account AS is_client_account_13,
  t0.comment AS comment_14,
  t0.is_voucher_operator_required AS is_voucher_operator_required_15,
  t0.is_main_operator AS is_main_operator_16,
  t0.code_igniter_id AS code_igniter_id_17,
  t0.pickup_time_slot AS pickup_time_slot_18,
  t0.has_main_season AS has_main_season_19,
  t0.user_id AS user_id_20
FROM
  operator t0
WHERE
  t0.is_main_operator = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.file AS file_2, t0.name AS name_3, t0.email_booking AS email_booking_4, t0.email_financial AS email_financial_5, t0.phone_booking AS phone_booking_6, t0.phone_financial AS phone_financial_7, t0.domain AS domain_8, t0.markup AS markup_9, t0.percentage AS percentage_10, t0.is_yft_money_collect AS is_yft_money_collect_11, t0.invoicing AS invoicing_12, t0.is_client_account AS is_client_account_13, t0.comment AS comment_14, t0.is_voucher_operator_required AS is_voucher_operator_required_15, t0.is_main_operator AS is_main_operator_16, t0.code_igniter_id AS code_igniter_id_17, t0.pickup_time_slot AS pickup_time_slot_18, t0.has_main_season AS has_main_season_19, t0.user_id AS user_id_20 FROM operator t0 WHERE t0.is_main_operator = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.reference AS reference_3,
  t0.position AS position_4
FROM
  luggage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 2;

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1,
  p0_.is_mobile_active AS is_mobile_active_2,
  p0_.file AS file_3,
  p0_.position AS position_4,
  p0_.file_in_banner AS file_in_banner_5,
  p0_.page_id AS page_id_6
FROM
  page_template p0_
  INNER JOIN page p1_ ON p0_.page_id = p1_.id
WHERE
  p1_.reference = ?
  AND p1_.is_active = ?
  AND p0_.is_active = ?
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.is_mobile_active AS is_mobile_active_2, p0_.file AS file_3, p0_.position AS position_4, p0_.file_in_banner AS file_in_banner_5, p0_.page_id AS page_id_6 FROM page_template p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p1_.reference = 'home' AND p1_.is_active = 1 AND p0_.is_active = 1 ORDER BY p0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale_id AS locale_id_3,
  t0.box_option_id AS box_option_id_4
FROM
  box_option_translation t0
WHERE
  t0.box_option_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.locale_id AS locale_id_4,
  t0.page_template_id AS page_template_id_5
FROM
  page_template_translation t0
WHERE
  t0.page_template_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.api_key AS api_key_4,
  t0.auth_token AS auth_token_5,
  t0.headers AS headers_6,
  t0.timeout AS timeout_7,
  t0.max_retry_attempts AS max_retry_attempts_8,
  t0.retry_interval AS retry_interval_9,
  t0.request_parameters AS request_parameters_10,
  t0.response_mapping AS response_mapping_11,
  t0.endpoint AS endpoint_12
FROM
  api_configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = 'CodeIgniterFetch' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_backend_active AS is_backend_active_3,
  t0.is_frontend_active AS is_frontend_active_4,
  t0.is_favorite AS is_favorite_5,
  t0.alias AS alias_6,
  t0.moloni_language_id AS moloni_language_id_7
FROM
  locale t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_backend_active AS is_backend_active_3, t0.is_frontend_active AS is_frontend_active_4, t0.is_favorite AS is_favorite_5, t0.alias AS alias_6, t0.moloni_language_id AS moloni_language_id_7 FROM locale t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.locale_id AS locale_id_4,
  t0.passenger_id AS passenger_id_5
FROM
  passenger_translation t0
WHERE
  t0.passenger_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale_id AS locale_id_4, t0.passenger_id AS passenger_id_5 FROM passenger_translation t0 WHERE t0.passenger_id = 2;

SELECT
  t0.encryption AS encryption_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.maintenance AS maintenance_4,
  t0.address AS address_5,
  t0.office_ip_address AS office_ip_address_6,
  t0.postal_code AS postal_code_7,
  t0.city AS city_8,
  t0.email AS email_9,
  t0.email_password AS email_password_10,
  t0.email_port AS email_port_11,
  t0.email_smtp AS email_smtp_12,
  t0.password_reset_days AS password_reset_days_13,
  t0.has_password_reset AS has_password_reset_14,
  t0.phone AS phone_15,
  t0.helpdesk AS helpdesk_16,
  t0.meta_keywords AS meta_keywords_17,
  t0.meta_description AS meta_description_18,
  t0.fiscal_number AS fiscal_number_19,
  t0.domain AS domain_20,
  t0.file AS file_21,
  t0.coords_google_maps AS coords_google_maps_22,
  t0.profit_margin AS profit_margin_23,
  t0.first_tag_head AS first_tag_head_24,
  t0.first_tag_body AS first_tag_body_25,
  t0.last_tag_head AS last_tag_head_26,
  t0.license AS license_27,
  t0.booking_hours_advance AS booking_hours_advance_28,
  t0.commercial_registry_office AS commercial_registry_office_29,
  t0.expire_payment AS expire_payment_30
FROM
  company t0
LIMIT
  1

SELECT t0.encryption AS encryption_1, t0.id AS id_2, t0.name AS name_3, t0.maintenance AS maintenance_4, t0.address AS address_5, t0.office_ip_address AS office_ip_address_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.email AS email_9, t0.email_password AS email_password_10, t0.email_port AS email_port_11, t0.email_smtp AS email_smtp_12, t0.password_reset_days AS password_reset_days_13, t0.has_password_reset AS has_password_reset_14, t0.phone AS phone_15, t0.helpdesk AS helpdesk_16, t0.meta_keywords AS meta_keywords_17, t0.meta_description AS meta_description_18, t0.fiscal_number AS fiscal_number_19, t0.domain AS domain_20, t0.file AS file_21, t0.coords_google_maps AS coords_google_maps_22, t0.profit_margin AS profit_margin_23, t0.first_tag_head AS first_tag_head_24, t0.first_tag_body AS first_tag_body_25, t0.last_tag_head AS last_tag_head_26, t0.license AS license_27, t0.booking_hours_advance AS booking_hours_advance_28, t0.commercial_registry_office AS commercial_registry_office_29, t0.expire_payment AS expire_payment_30 FROM company t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.position AS position_3,
  t0.reference AS reference_4,
  t0.configuration_id AS configuration_id_5
FROM
  passenger t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4, t0.configuration_id AS configuration_id_5 FROM passenger t0 WHERE t0.id = 2;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.zone AS zone_2,
  l0_.coordinates AS coordinates_3,
  l0_.is_airport AS is_airport_4,
  l0_.is_online AS is_online_5,
  l0_.is_active AS is_active_6,
  l0_.check_in_time AS check_in_time_7,
  l0_.is_favorite AS is_favorite_8,
  l0_.position AS position_9,
  l0_.type AS type_10,
  l0_.iso AS iso_11
FROM
  location l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.zone AS zone_2, l0_.coordinates AS coordinates_3, l0_.is_airport AS is_airport_4, l0_.is_online AS is_online_5, l0_.is_active AS is_active_6, l0_.check_in_time AS check_in_time_7, l0_.is_favorite AS is_favorite_8, l0_.position AS position_9, l0_.type AS type_10, l0_.iso AS iso_11 FROM location l0_;

SELECT
  p0_.id AS id_0,
  p0_.min AS min_1,
  p0_.max AS max_2,
  p0_.is_active AS is_active_3,
  p0_.is_required AS is_required_4,
  p0_.passenger_id AS passenger_id_5,
  p0_.pax_builder_id AS pax_builder_id_6
FROM
  passenger_configuration p0_
  INNER JOIN passenger p1_ ON p0_.passenger_id = p1_.id
WHERE
  p0_.is_active = 1
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p0_.min AS min_1, p0_.max AS max_2, p0_.is_active AS is_active_3, p0_.is_required AS is_required_4, p0_.passenger_id AS passenger_id_5, p0_.pax_builder_id AS pax_builder_id_6 FROM passenger_configuration p0_ INNER JOIN passenger p1_ ON p0_.passenger_id = p1_.id WHERE p0_.is_active = 1 ORDER BY p1_.position ASC;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.html AS html_2,
  w0_.locale_id AS locale_id_3,
  w0_.warning_id AS warning_id_4
FROM
  warning_translation w0_
  LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id
  LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id
WHERE
  (
    w2_.is_active = ?
    OR w2_.id IS NULL
  )
  AND l1_.name = ?
  AND w2_.is_public = ?
LIMIT
  1

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.html AS html_2, w0_.locale_id AS locale_id_3, w0_.warning_id AS warning_id_4 FROM warning_translation w0_ LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id WHERE (w2_.is_active = 1 OR w2_.id IS NULL) AND l1_.name = 'de' AND w2_.is_public = 1 LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.min AS min_1,
  l0_.max AS max_2,
  l0_.is_active AS is_active_3,
  l0_.is_required AS is_required_4,
  l0_.max_allowed AS max_allowed_5,
  l0_.luggage_id AS luggage_id_6,
  l0_.cargo_builder_id AS cargo_builder_id_7
FROM
  luggage_configuration l0_
  INNER JOIN luggage l1_ ON l0_.luggage_id = l1_.id
WHERE
  l0_.is_active = 1
ORDER BY
  l1_.position ASC

SELECT l0_.id AS id_0, l0_.min AS min_1, l0_.max AS max_2, l0_.is_active AS is_active_3, l0_.is_required AS is_required_4, l0_.max_allowed AS max_allowed_5, l0_.luggage_id AS luggage_id_6, l0_.cargo_builder_id AS cargo_builder_id_7 FROM luggage_configuration l0_ INNER JOIN luggage l1_ ON l0_.luggage_id = l1_.id WHERE l0_.is_active = 1 ORDER BY l1_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t0_.percentage AS percentage_2,
  t0_.position AS position_3,
  t0_.is_active AS is_active_4
FROM
  trip_option t0_
WHERE
  t0_.is_active = 1
ORDER BY
  t0_.position ASC

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.percentage AS percentage_2, t0_.position AS position_3, t0_.is_active AS is_active_4 FROM trip_option t0_ WHERE t0_.is_active = 1 ORDER BY t0_.position ASC;

SELECT
  b0_.id AS id_0,
  b0_.is_active AS is_active_1,
  b0_.is_required AS is_required_2,
  b0_.box_id AS box_id_3,
  b0_.cargo_builder_id AS cargo_builder_id_4
FROM
  box_configuration b0_
  INNER JOIN box b1_ ON b0_.box_id = b1_.id
WHERE
  b0_.is_active = 1
ORDER BY
  b1_.position ASC

SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.is_required AS is_required_2, b0_.box_id AS box_id_3, b0_.cargo_builder_id AS cargo_builder_id_4 FROM box_configuration b0_ INNER JOIN box b1_ ON b0_.box_id = b1_.id WHERE b0_.is_active = 1 ORDER BY b1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.name AS name_3,
  t0.email_booking AS email_booking_4,
  t0.email_financial AS email_financial_5,
  t0.phone_booking AS phone_booking_6,
  t0.phone_financial AS phone_financial_7,
  t0.domain AS domain_8,
  t0.markup AS markup_9,
  t0.percentage AS percentage_10,
  t0.is_yft_money_collect AS is_yft_money_collect_11,
  t0.invoicing AS invoicing_12,
  t0.is_client_account AS is_client_account_13,
  t0.comment AS comment_14,
  t0.is_voucher_operator_required AS is_voucher_operator_required_15,
  t0.is_main_operator AS is_main_operator_16,
  t0.code_igniter_id AS code_igniter_id_17,
  t0.pickup_time_slot AS pickup_time_slot_18,
  t0.has_main_season AS has_main_season_19,
  t0.user_id AS user_id_20
FROM
  operator t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.file AS file_2, t0.name AS name_3, t0.email_booking AS email_booking_4, t0.email_financial AS email_financial_5, t0.phone_booking AS phone_booking_6, t0.phone_financial AS phone_financial_7, t0.domain AS domain_8, t0.markup AS markup_9, t0.percentage AS percentage_10, t0.is_yft_money_collect AS is_yft_money_collect_11, t0.invoicing AS invoicing_12, t0.is_client_account AS is_client_account_13, t0.comment AS comment_14, t0.is_voucher_operator_required AS is_voucher_operator_required_15, t0.is_main_operator AS is_main_operator_16, t0.code_igniter_id AS code_igniter_id_17, t0.pickup_time_slot AS pickup_time_slot_18, t0.has_main_season AS has_main_season_19, t0.user_id AS user_id_20 FROM operator t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_backend_active AS is_backend_active_3,
  t0.is_frontend_active AS is_frontend_active_4,
  t0.is_favorite AS is_favorite_5,
  t0.alias AS alias_6,
  t0.moloni_language_id AS moloni_language_id_7
FROM
  locale t0
WHERE
  t0.is_frontend_active = ?
ORDER BY
  t0.is_favorite DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_backend_active AS is_backend_active_3, t0.is_frontend_active AS is_frontend_active_4, t0.is_favorite AS is_favorite_5, t0.alias AS alias_6, t0.moloni_language_id AS moloni_language_id_7 FROM locale t0 WHERE t0.is_frontend_active = 1 ORDER BY t0.is_favorite DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.trip_option_id AS trip_option_id_4,
  t0.locale_id AS locale_id_5
FROM
  trip_option_translation t0
WHERE
  t0.trip_option_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.trip_option_id AS trip_option_id_4, t0.locale_id AS locale_id_5 FROM trip_option_translation t0 WHERE t0.trip_option_id = 1;