Symfony Profiler

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

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
  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 = 'secret-beaches-itinerary-discover-the-algarve-out-of-sight' AND p1_.is_active = 1 AND p0_.is_active = 1 ORDER BY p0_.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 = 'en' AND w2_.is_public = 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.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
  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_.is_active = ?
  AND p1_.is_menu = ?
  AND p1_.is_public = ?
  AND p0_.is_active = ?
GROUP BY
  p1_.id
ORDER BY
  p1_.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_.is_active = 1 AND p1_.is_menu = 1 AND p1_.is_public = 1 AND p0_.is_active = 1 GROUP BY p1_.id ORDER BY p1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.icon AS icon_5
FROM
  social_network t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.url AS url_4, t0.icon AS icon_5 FROM social_network t0 WHERE t0.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.is_active AS is_active_3,
  t0.is_menu AS is_menu_4,
  t0.is_public AS is_public_5,
  t0.position AS position_6
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.is_active AS is_active_3, t0.is_menu AS is_menu_4, t0.is_public AS is_public_5, t0.position AS position_6 FROM page t0 WHERE t0.id = 12;

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;