Symfony Profiler

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.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.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 = 'Stripe' 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 = ?
    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 = 'cn' AND w2_.is_public = 1 LIMIT 1;

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
  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 = 'footer' AND p1_.is_active = 1 AND p0_.is_active = 1 ORDER BY p0_.position ASC;

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 = 8;

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.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 = 2;

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 = 3;

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 = 4;

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 = 5;

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 = 9;

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 = 10;

SELECT
  1 AS sclr_0
FROM
  itinerary i0_
  INNER JOIN itinerary_vehicle i2_ ON i0_.id = i2_.itinerary_id
  INNER JOIN vehicle v1_ ON v1_.id = i2_.vehicle_id
  INNER JOIN itinerary_schedule i3_ ON i0_.id = i3_.itinerary_id
WHERE
  i0_.is_active = ?
  AND i0_.week_days > 0
LIMIT
  1

SELECT 1 AS sclr_0 FROM itinerary i0_ INNER JOIN itinerary_vehicle i2_ ON i0_.id = i2_.itinerary_id INNER JOIN vehicle v1_ ON v1_.id = i2_.vehicle_id INNER JOIN itinerary_schedule i3_ ON i0_.id = i3_.itinerary_id WHERE i0_.is_active = 1 AND i0_.week_days > 0 LIMIT 1;

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,
  t0_.is_shared AS is_shared_5,
  t0_.booking_hours_advance AS booking_hours_advance_6,
  t0_.expire_payment AS expire_payment_7,
  t0_.ui_positions AS ui_positions_8,
  t0_.has_contact_form AS has_contact_form_9,
  t0_.email_template_id AS email_template_id_10,
  t0_.pdf_template_id AS pdf_template_id_11,
  t0_.terms_conditions_id AS terms_conditions_id_12
FROM
  trip_option t0_
WHERE
  t0_.is_active = ?
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, t0_.is_shared AS is_shared_5, t0_.booking_hours_advance AS booking_hours_advance_6, t0_.expire_payment AS expire_payment_7, t0_.ui_positions AS ui_positions_8, t0_.has_contact_form AS has_contact_form_9, t0_.email_template_id AS email_template_id_10, t0_.pdf_template_id AS pdf_template_id_11, t0_.terms_conditions_id AS terms_conditions_id_12 FROM trip_option t0_ WHERE t0_.is_active = 1 ORDER BY t0_.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.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
  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
  INNER JOIN cargo_builder c2_ ON l0_.cargo_builder_id = c2_.id
  INNER JOIN trip_option t3_ ON c2_.trip_option_id = t3_.id
WHERE
  l0_.is_active = 1
  AND t3_.id = ?
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 INNER JOIN cargo_builder c2_ ON l0_.cargo_builder_id = c2_.id INNER JOIN trip_option t3_ ON c2_.trip_option_id = t3_.id WHERE l0_.is_active = 1 AND t3_.id = 2 ORDER BY l1_.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
  INNER JOIN pax_builder p2_ ON p0_.pax_builder_id = p2_.id
  INNER JOIN trip_option t3_ ON p2_.trip_option_id = t3_.id
WHERE
  p0_.is_active = 1
  AND t3_.id = ?
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 INNER JOIN pax_builder p2_ ON p0_.pax_builder_id = p2_.id INNER JOIN trip_option t3_ ON p2_.trip_option_id = t3_.id WHERE p0_.is_active = 1 AND t3_.id = 2 ORDER BY p1_.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
  INNER JOIN cargo_builder c2_ ON b0_.cargo_builder_id = c2_.id
  INNER JOIN trip_option t3_ ON c2_.trip_option_id = t3_.id
WHERE
  b0_.is_active = 1
  AND t3_.id = ?
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 INNER JOIN cargo_builder c2_ ON b0_.cargo_builder_id = c2_.id INNER JOIN trip_option t3_ ON c2_.trip_option_id = t3_.id WHERE b0_.is_active = 1 AND t3_.id = 2 ORDER BY b1_.position ASC;

SELECT
  i0_.id AS id_0,
  i0_.distance AS distance_1,
  i0_.week_days AS week_days_2,
  i0_.is_active AS is_active_3
FROM
  itinerary i0_
  INNER JOIN itinerary_schedule i1_ ON i0_.id = i1_.itinerary_id
  INNER JOIN itinerary_vehicle i3_ ON i0_.id = i3_.itinerary_id
  INNER JOIN vehicle v2_ ON v2_.id = i3_.vehicle_id
WHERE
  i0_.week_days > 0
  AND i0_.is_active = 1
  AND v2_.is_active = 1
  AND v2_.status = ?

SELECT i0_.id AS id_0, i0_.distance AS distance_1, i0_.week_days AS week_days_2, i0_.is_active AS is_active_3 FROM itinerary i0_ INNER JOIN itinerary_schedule i1_ ON i0_.id = i1_.itinerary_id INNER JOIN itinerary_vehicle i3_ ON i0_.id = i3_.itinerary_id INNER JOIN vehicle v2_ ON v2_.id = i3_.vehicle_id WHERE i0_.week_days > 0 AND i0_.is_active = 1 AND v2_.is_active = 1 AND v2_.status = 'available';

SELECT
  t0.id AS id_1,
  t0.time AS time_2,
  t0.itinerary_point_id AS itinerary_point_id_3,
  t0.itinerary_id AS itinerary_id_4
FROM
  itinerary_schedule t0
WHERE
  t0.itinerary_id = ?
ORDER BY
  t0.time ASC

SELECT t0.id AS id_1, t0.time AS time_2, t0.itinerary_point_id AS itinerary_point_id_3, t0.itinerary_id AS itinerary_id_4 FROM itinerary_schedule t0 WHERE t0.itinerary_id = 1 ORDER BY t0.time ASC;