Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo_white AS logo_white_3,
  t0.logo AS logo_4,
  t0.is_edit AS is_edit_5,
  t0.mail_logo AS mail_logo_6,
  t0.mail_logo_background AS mail_logo_background_7,
  t0.site_address AS site_address_8,
  t0.phone AS phone_9,
  t0.mail AS mail_10,
  t0.address AS address_11,
  t0.panel_site_address AS panel_site_address_12,
  t0.language AS language_13,
  t0.is_domestic_hotel AS is_domestic_hotel_14,
  t0.is_abroad_hotel AS is_abroad_hotel_15,
  t0.is_cyprus_hotel AS is_cyprus_hotel_16,
  t0.is_domestic_tour AS is_domestic_tour_17,
  t0.is_abroad_tour AS is_abroad_tour_18,
  t0.is_domestic_flight AS is_domestic_flight_19,
  t0.is_abroad_flight AS is_abroad_flight_20,
  t0.is_domestic_transfer AS is_domestic_transfer_21,
  t0.is_abroad_transfer AS is_abroad_transfer_22,
  t0.noreply_mail AS noreply_mail_23,
  t0.user_id AS user_id_24
FROM
  sites t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo_white AS logo_white_3, t0.logo AS logo_4, t0.is_edit AS is_edit_5, t0.mail_logo AS mail_logo_6, t0.mail_logo_background AS mail_logo_background_7, t0.site_address AS site_address_8, t0.phone AS phone_9, t0.mail AS mail_10, t0.address AS address_11, t0.panel_site_address AS panel_site_address_12, t0.language AS language_13, t0.is_domestic_hotel AS is_domestic_hotel_14, t0.is_abroad_hotel AS is_abroad_hotel_15, t0.is_cyprus_hotel AS is_cyprus_hotel_16, t0.is_domestic_tour AS is_domestic_tour_17, t0.is_abroad_tour AS is_abroad_tour_18, t0.is_domestic_flight AS is_domestic_flight_19, t0.is_abroad_flight AS is_abroad_flight_20, t0.is_domestic_transfer AS is_domestic_transfer_21, t0.is_abroad_transfer AS is_abroad_transfer_22, t0.noreply_mail AS noreply_mail_23, t0.user_id AS user_id_24 FROM sites t0 WHERE t0.name = 'PUZZLEBOOKING' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.status AS status_7,
  t0.type AS type_8,
  t0.phone AS phone_9,
  t0.address AS address_10,
  t0.api_token AS api_token_11,
  t0.last_login_date AS last_login_date_12,
  t0.puzzle_code AS puzzle_code_13,
  t0.deleted_at AS deleted_at_14,
  t0.agency_id AS agency_id_15,
  t0.lighting_contract_id AS lighting_contract_id_16,
  t0.consent_contract_id AS consent_contract_id_17,
  t0.register_message_contract_id AS register_message_contract_id_18,
  t0.register_phone_contract_id AS register_phone_contract_id_19,
  t0.register_email_contract_id AS register_email_contract_id_20
FROM
  user t0
WHERE
  t0.api_token = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.status AS status_7, t0.type AS type_8, t0.phone AS phone_9, t0.address AS address_10, t0.api_token AS api_token_11, t0.last_login_date AS last_login_date_12, t0.puzzle_code AS puzzle_code_13, t0.deleted_at AS deleted_at_14, t0.agency_id AS agency_id_15, t0.lighting_contract_id AS lighting_contract_id_16, t0.consent_contract_id AS consent_contract_id_17, t0.register_message_contract_id AS register_message_contract_id_18, t0.register_phone_contract_id AS register_phone_contract_id_19, t0.register_email_contract_id AS register_email_contract_id_20 FROM user t0 WHERE t0.api_token = '48ad20ecb44a117d53768ed2bb942af01' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.seo_menu_category_id AS seo_menu_category_id_4
FROM
  seo_menu_category_translation t0
WHERE
  t0.seo_menu_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.seo_menu_category_id AS seo_menu_category_id_4 FROM seo_menu_category_translation t0 WHERE t0.seo_menu_category_id = 48;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.type AS type_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keyword AS meta_keyword_6,
  t0.status AS status_7,
  t0.redirect AS redirect_8,
  t0.redirect_code AS redirect_code_9,
  t0.marketing_campaign_id AS marketing_campaign_id_10,
  t0.hotel_destination_id AS hotel_destination_id_11,
  t0.hotel_category_id AS hotel_category_id_12,
  t0.hotel_id AS hotel_id_13,
  t0.tour_destination_id AS tour_destination_id_14,
  t0.tour_id AS tour_id_15,
  t0.tour_category_id AS tour_category_id_16,
  t0.tour_type_id AS tour_type_id_17,
  t0.landmark_id AS landmark_id_18,
  t0.destination_hotel_id AS destination_hotel_id_19,
  t20.id AS id_21,
  t20.tour_type_id AS tour_type_id_22,
  t20.seo_page_id AS seo_page_id_23,
  t0.tour_hotel_destination_id AS tour_hotel_destination_id_24,
  t0.tour_country_id AS tour_country_id_25,
  t0.hotel_page_destination_id AS hotel_page_destination_id_26
FROM
  seo_page t0
  LEFT JOIN tour_type_label t20 ON t20.seo_page_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.status AS status_7, t0.redirect AS redirect_8, t0.redirect_code AS redirect_code_9, t0.marketing_campaign_id AS marketing_campaign_id_10, t0.hotel_destination_id AS hotel_destination_id_11, t0.hotel_category_id AS hotel_category_id_12, t0.hotel_id AS hotel_id_13, t0.tour_destination_id AS tour_destination_id_14, t0.tour_id AS tour_id_15, t0.tour_category_id AS tour_category_id_16, t0.tour_type_id AS tour_type_id_17, t0.landmark_id AS landmark_id_18, t0.destination_hotel_id AS destination_hotel_id_19, t20.id AS id_21, t20.tour_type_id AS tour_type_id_22, t20.seo_page_id AS seo_page_id_23, t0.tour_hotel_destination_id AS tour_hotel_destination_id_24, t0.tour_country_id AS tour_country_id_25, t0.hotel_page_destination_id AS hotel_page_destination_id_26 FROM seo_page t0 LEFT JOIN tour_type_label t20 ON t20.seo_page_id = t0.id WHERE t0.id = 14318;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sequence AS sequence_3,
  t0.icon AS icon_4,
  t0.parent_id AS parent_id_5,
  t0.seo_page_id AS seo_page_id_6,
  t0.site_id AS site_id_7
FROM
  seo_menu_category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.icon AS icon_4, t0.parent_id AS parent_id_5, t0.seo_page_id AS seo_page_id_6, t0.site_id AS site_id_7 FROM seo_menu_category t0 WHERE t0.parent_id = 48;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.redirect AS redirect_3,
  t0.seo_page_id AS seo_page_id_4,
  t0.site_id AS site_id_5
FROM
  seo_page_sites t0
WHERE
  t0.seo_page_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.redirect AS redirect_3, t0.seo_page_id AS seo_page_id_4, t0.site_id AS site_id_5 FROM seo_page_sites t0 WHERE t0.seo_page_id = 14318;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.puzzle_code AS puzzle_code_4,
  t0.fax AS fax_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.payment_type AS payment_type_8,
  t0.email AS email_9,
  t0.vat_office AS vat_office_10,
  t0.vat_number AS vat_number_11,
  t0.document_voucher AS document_voucher_12,
  t0.credit_amount AS credit_amount_13,
  t0.credit_cur AS credit_cur_14,
  t0.agency_rate AS agency_rate_15,
  t0.agency_package_tour_program_rate AS agency_package_tour_program_rate_16,
  t0.deleted_at AS deleted_at_17,
  t0.site_id AS site_id_18
FROM
  agency t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.puzzle_code AS puzzle_code_4, t0.fax AS fax_5, t0.phone AS phone_6, t0.address AS address_7, t0.payment_type AS payment_type_8, t0.email AS email_9, t0.vat_office AS vat_office_10, t0.vat_number AS vat_number_11, t0.document_voucher AS document_voucher_12, t0.credit_amount AS credit_amount_13, t0.credit_cur AS credit_cur_14, t0.agency_rate AS agency_rate_15, t0.agency_package_tour_program_rate AS agency_package_tour_program_rate_16, t0.deleted_at AS deleted_at_17, t0.site_id AS site_id_18 FROM agency t0 WHERE t0.id = 4 AND ((t0.deleted_at IS NULL));

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.sequence AS sequence_2,
  s0_.icon AS icon_3,
  s0_.parent_id AS parent_id_4,
  s0_.seo_page_id AS seo_page_id_5,
  s0_.site_id AS site_id_6
FROM
  seo_menu_category s0_
  INNER JOIN sites s1_ ON s0_.site_id = s1_.id
WHERE
  s1_.name = ?
  AND s0_.parent_id IS NULL
ORDER BY
  s0_.sequence ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.sequence AS sequence_2, s0_.icon AS icon_3, s0_.parent_id AS parent_id_4, s0_.seo_page_id AS seo_page_id_5, s0_.site_id AS site_id_6 FROM seo_menu_category s0_ INNER JOIN sites s1_ ON s0_.site_id = s1_.id WHERE s1_.name = 'PUZZLEBOOKING' AND s0_.parent_id IS NULL ORDER BY s0_.sequence ASC;