Symfony Profiler

SELECT
  t0.address AS address_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.shop_active AS shop_active_4,
  t0.shop_button_text AS shop_button_text_5,
  t0.shop_link AS shop_link_6,
  t0.shop_target AS shop_target_7,
  t0.roulette_active AS roulette_active_8,
  t0.roulette_link AS roulette_link_9,
  t0.roulette_text AS roulette_text_10,
  t0.roulette_image AS roulette_image_11,
  t0.roulette_banner_home AS roulette_banner_home_12,
  t0.roulette_target AS roulette_target_13,
  t0.header_logo_color AS header_logo_color_14,
  t0.header_logo_white AS header_logo_white_15,
  t0.footer_logo AS footer_logo_16,
  t0.link_buses AS link_buses_17,
  t0.link_services AS link_services_18,
  t0.link_spare_parts AS link_spare_parts_19,
  t0.link_spare_parts_warranty AS link_spare_parts_warranty_20,
  t0.link_online_store AS link_online_store_21,
  t0.link_technical_assistance AS link_technical_assistance_22,
  t0.link_after_sales_trucks AS link_after_sales_trucks_23,
  t0.link_after_sales_buses AS link_after_sales_buses_24,
  t0.link_claim_trucks AS link_claim_trucks_25,
  t0.link_claim_buses AS link_claim_buses_26,
  t0.sent_title AS sent_title_27,
  t0.sent_text AS sent_text_28,
  t0.sent_button_home_text AS sent_button_home_text_29,
  t0.sent_button_models_text AS sent_button_models_text_30,
  t0.error_title AS error_title_31,
  t0.error_text AS error_text_32,
  t0.error_button_home_text AS error_button_home_text_33,
  t0.error_button_models_text AS error_button_models_text_34,
  t0.error_404_title AS error_404_title_35,
  t0.error_404_text AS error_404_text_36,
  t0.error_404_button_home_text AS error_404_button_home_text_37,
  t0.error_404_button_models_text AS error_404_button_models_text_38,
  t0.social_whatsapp_show AS social_whatsapp_show_39,
  t0.social_whatsapp_number AS social_whatsapp_number_40,
  t0.social_whatsapp_message AS social_whatsapp_message_41,
  t0.social_facebook_show AS social_facebook_show_42,
  t0.social_facebook_link AS social_facebook_link_43,
  t0.social_linkedin_show AS social_linkedin_show_44,
  t0.social_linkedin_link AS social_linkedin_link_45,
  t0.social_youtube_show AS social_youtube_show_46,
  t0.social_youtube_link AS social_youtube_link_47,
  t0.social_blog_show AS social_blog_show_48,
  t0.social_blog_link AS social_blog_link_49,
  t0.social_blog_categories AS social_blog_categories_50,
  t0.social_blog_posts AS social_blog_posts_51,
  t0.seo_indexing AS seo_indexing_52,
  t0.seo_favicon AS seo_favicon_53,
  t0.seo_title AS seo_title_54,
  t0.seo_description AS seo_description_55,
  t0.scripts_meta AS scripts_meta_56,
  t0.scripts_header AS scripts_header_57,
  t0.scripts_body AS scripts_body_58,
  t0.scripts_footer AS scripts_footer_59,
  t0.captcha_show AS captcha_show_60,
  t0.captcha_site AS captcha_site_61,
  t0.captcha_secret AS captcha_secret_62,
  t0.id AS id_63,
  t0.created_at AS created_at_64,
  t0.modified_at AS modified_at_65,
  t0.created_user AS created_user_66,
  t0.modified_user AS modified_user_67
FROM
  info t0
WHERE
  t0.id = ?

SELECT t0.address AS address_1, t0.phone AS phone_2, t0.email AS email_3, t0.shop_active AS shop_active_4, t0.shop_button_text AS shop_button_text_5, t0.shop_link AS shop_link_6, t0.shop_target AS shop_target_7, t0.roulette_active AS roulette_active_8, t0.roulette_link AS roulette_link_9, t0.roulette_text AS roulette_text_10, t0.roulette_image AS roulette_image_11, t0.roulette_banner_home AS roulette_banner_home_12, t0.roulette_target AS roulette_target_13, t0.header_logo_color AS header_logo_color_14, t0.header_logo_white AS header_logo_white_15, t0.footer_logo AS footer_logo_16, t0.link_buses AS link_buses_17, t0.link_services AS link_services_18, t0.link_spare_parts AS link_spare_parts_19, t0.link_spare_parts_warranty AS link_spare_parts_warranty_20, t0.link_online_store AS link_online_store_21, t0.link_technical_assistance AS link_technical_assistance_22, t0.link_after_sales_trucks AS link_after_sales_trucks_23, t0.link_after_sales_buses AS link_after_sales_buses_24, t0.link_claim_trucks AS link_claim_trucks_25, t0.link_claim_buses AS link_claim_buses_26, t0.sent_title AS sent_title_27, t0.sent_text AS sent_text_28, t0.sent_button_home_text AS sent_button_home_text_29, t0.sent_button_models_text AS sent_button_models_text_30, t0.error_title AS error_title_31, t0.error_text AS error_text_32, t0.error_button_home_text AS error_button_home_text_33, t0.error_button_models_text AS error_button_models_text_34, t0.error_404_title AS error_404_title_35, t0.error_404_text AS error_404_text_36, t0.error_404_button_home_text AS error_404_button_home_text_37, t0.error_404_button_models_text AS error_404_button_models_text_38, t0.social_whatsapp_show AS social_whatsapp_show_39, t0.social_whatsapp_number AS social_whatsapp_number_40, t0.social_whatsapp_message AS social_whatsapp_message_41, t0.social_facebook_show AS social_facebook_show_42, t0.social_facebook_link AS social_facebook_link_43, t0.social_linkedin_show AS social_linkedin_show_44, t0.social_linkedin_link AS social_linkedin_link_45, t0.social_youtube_show AS social_youtube_show_46, t0.social_youtube_link AS social_youtube_link_47, t0.social_blog_show AS social_blog_show_48, t0.social_blog_link AS social_blog_link_49, t0.social_blog_categories AS social_blog_categories_50, t0.social_blog_posts AS social_blog_posts_51, t0.seo_indexing AS seo_indexing_52, t0.seo_favicon AS seo_favicon_53, t0.seo_title AS seo_title_54, t0.seo_description AS seo_description_55, t0.scripts_meta AS scripts_meta_56, t0.scripts_header AS scripts_header_57, t0.scripts_body AS scripts_body_58, t0.scripts_footer AS scripts_footer_59, t0.captcha_show AS captcha_show_60, t0.captcha_site AS captcha_site_61, t0.captcha_secret AS captcha_secret_62, t0.id AS id_63, t0.created_at AS created_at_64, t0.modified_at AS modified_at_65, t0.created_user AS created_user_66, t0.modified_user AS modified_user_67 FROM info t0 WHERE t0.id = 1;

SELECT
  t0.document_types AS document_types_1,
  t0.contact_title AS contact_title_2,
  t0.contact_text AS contact_text_3,
  t0.contact_types AS contact_types_4,
  t0.contact_receiver AS contact_receiver_5,
  t0.promotion_receiver AS promotion_receiver_6,
  t0.application_receiver AS application_receiver_7,
  t0.truck_quotation_receiver AS truck_quotation_receiver_8,
  t0.bus_quotation_receiver AS bus_quotation_receiver_9,
  t0.service_quotation_title AS service_quotation_title_10,
  t0.service_quotation_receiver AS service_quotation_receiver_11,
  t0.id AS id_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.created_user AS created_user_15,
  t0.modified_user AS modified_user_16
FROM
  forms t0
WHERE
  t0.id = ?

SELECT t0.document_types AS document_types_1, t0.contact_title AS contact_title_2, t0.contact_text AS contact_text_3, t0.contact_types AS contact_types_4, t0.contact_receiver AS contact_receiver_5, t0.promotion_receiver AS promotion_receiver_6, t0.application_receiver AS application_receiver_7, t0.truck_quotation_receiver AS truck_quotation_receiver_8, t0.bus_quotation_receiver AS bus_quotation_receiver_9, t0.service_quotation_title AS service_quotation_title_10, t0.service_quotation_receiver AS service_quotation_receiver_11, t0.id AS id_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.created_user AS created_user_15, t0.modified_user AS modified_user_16 FROM forms t0 WHERE t0.id = 1;

SELECT
  s0_.title AS title_0,
  s0_.link AS link_1,
  s0_.active AS active_2,
  s0_.position AS position_3,
  s0_.id AS id_4,
  s0_.created_at AS created_at_5,
  s0_.modified_at AS modified_at_6,
  s0_.created_user AS created_user_7,
  s0_.modified_user AS modified_user_8
FROM
  service s0_
WHERE
  s0_.active = 1
ORDER BY
  s0_.position ASC

SELECT s0_.title AS title_0, s0_.link AS link_1, s0_.active AS active_2, s0_.position AS position_3, s0_.id AS id_4, s0_.created_at AS created_at_5, s0_.modified_at AS modified_at_6, s0_.created_user AS created_user_7, s0_.modified_user AS modified_user_8 FROM service s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC;

SELECT
  t0.banner_desktop AS banner_desktop_1,
  t0.banner_tablet AS banner_tablet_2,
  t0.banner_mobile AS banner_mobile_3,
  t0.return_link AS return_link_4,
  t0.return_target AS return_target_5,
  t0.both_title AS both_title_6,
  t0.both_image AS both_image_7,
  t0.both_image_hover AS both_image_hover_8,
  t0.both_description AS both_description_9,
  t0.trucks_title AS trucks_title_10,
  t0.trucks_image AS trucks_image_11,
  t0.trucks_image_hover AS trucks_image_hover_12,
  t0.trucks_description AS trucks_description_13,
  t0.buses_title AS buses_title_14,
  t0.buses_image AS buses_image_15,
  t0.buses_image_hover AS buses_image_hover_16,
  t0.buses_description AS buses_description_17,
  t0.advertising_show AS advertising_show_18,
  t0.advertising_image AS advertising_image_19,
  t0.advertising_link AS advertising_link_20,
  t0.advertising_target AS advertising_target_21,
  t0.id AS id_22,
  t0.created_at AS created_at_23,
  t0.modified_at AS modified_at_24,
  t0.created_user AS created_user_25,
  t0.modified_user AS modified_user_26
FROM
  models t0
WHERE
  t0.id = ?

SELECT t0.banner_desktop AS banner_desktop_1, t0.banner_tablet AS banner_tablet_2, t0.banner_mobile AS banner_mobile_3, t0.return_link AS return_link_4, t0.return_target AS return_target_5, t0.both_title AS both_title_6, t0.both_image AS both_image_7, t0.both_image_hover AS both_image_hover_8, t0.both_description AS both_description_9, t0.trucks_title AS trucks_title_10, t0.trucks_image AS trucks_image_11, t0.trucks_image_hover AS trucks_image_hover_12, t0.trucks_description AS trucks_description_13, t0.buses_title AS buses_title_14, t0.buses_image AS buses_image_15, t0.buses_image_hover AS buses_image_hover_16, t0.buses_description AS buses_description_17, t0.advertising_show AS advertising_show_18, t0.advertising_image AS advertising_image_19, t0.advertising_link AS advertising_link_20, t0.advertising_target AS advertising_target_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.modified_at AS modified_at_24, t0.created_user AS created_user_25, t0.modified_user AS modified_user_26 FROM models t0 WHERE t0.id = 1;

SELECT
  d0_.title AS title_0,
  d0_.message AS message_1,
  d0_.active AS active_2,
  d0_.position AS position_3,
  d0_.slug AS slug_4,
  d0_.id AS id_5,
  d0_.created_at AS created_at_6,
  d0_.modified_at AS modified_at_7,
  d0_.created_user AS created_user_8,
  d0_.modified_user AS modified_user_9
FROM
  department d0_
  INNER JOIN city c1_ ON d0_.id = c1_.department_id
  INNER JOIN establishment e2_ ON c1_.id = e2_.city_id
WHERE
  d0_.active = 1
  AND c1_.active = 1
  AND e2_.active = 1
ORDER BY
  d0_.position ASC,
  d0_.title ASC

SELECT d0_.title AS title_0, d0_.message AS message_1, d0_.active AS active_2, d0_.position AS position_3, d0_.slug AS slug_4, d0_.id AS id_5, d0_.created_at AS created_at_6, d0_.modified_at AS modified_at_7, d0_.created_user AS created_user_8, d0_.modified_user AS modified_user_9 FROM department d0_ INNER JOIN city c1_ ON d0_.id = c1_.department_id INNER JOIN establishment e2_ ON c1_.id = e2_.city_id WHERE d0_.active = 1 AND c1_.active = 1 AND e2_.active = 1 ORDER BY d0_.position ASC, d0_.title ASC;

SELECT
  e0_.title AS title_0,
  e0_.description AS description_1,
  e0_.icon AS icon_2,
  e0_.active AS active_3,
  e0_.show_in_form_quotation_services AS show_in_form_quotation_services_4,
  e0_.position AS position_5,
  e0_.slug AS slug_6,
  e0_.id AS id_7,
  e0_.created_at AS created_at_8,
  e0_.modified_at AS modified_at_9,
  e0_.created_user AS created_user_10,
  e0_.modified_user AS modified_user_11
FROM
  establishment_category e0_
WHERE
  e0_.active = 1
ORDER BY
  e0_.position ASC

SELECT e0_.title AS title_0, e0_.description AS description_1, e0_.icon AS icon_2, e0_.active AS active_3, e0_.show_in_form_quotation_services AS show_in_form_quotation_services_4, e0_.position AS position_5, e0_.slug AS slug_6, e0_.id AS id_7, e0_.created_at AS created_at_8, e0_.modified_at AS modified_at_9, e0_.created_user AS created_user_10, e0_.modified_user AS modified_user_11 FROM establishment_category e0_ WHERE e0_.active = 1 ORDER BY e0_.position ASC;

SELECT
  e0_.title AS title_0,
  e0_.address AS address_1,
  e0_.contacts AS contacts_2,
  e0_.link AS link_3,
  e0_.active AS active_4,
  e0_.position AS position_5,
  e0_.slug AS slug_6,
  e0_.id AS id_7,
  e0_.created_at AS created_at_8,
  e0_.modified_at AS modified_at_9,
  e0_.created_user AS created_user_10,
  e0_.modified_user AS modified_user_11,
  e0_.city_id AS city_id_12,
  e0_.category_id AS category_id_13
FROM
  establishment e0_
WHERE
  e0_.active = 1
ORDER BY
  e0_.position ASC

SELECT e0_.title AS title_0, e0_.address AS address_1, e0_.contacts AS contacts_2, e0_.link AS link_3, e0_.active AS active_4, e0_.position AS position_5, e0_.slug AS slug_6, e0_.id AS id_7, e0_.created_at AS created_at_8, e0_.modified_at AS modified_at_9, e0_.created_user AS created_user_10, e0_.modified_user AS modified_user_11, e0_.city_id AS city_id_12, e0_.category_id AS category_id_13 FROM establishment e0_ WHERE e0_.active = 1 ORDER BY e0_.position ASC;

SELECT
  t0.title AS title_1,
  t0.text_1 AS text_1_2,
  t0.text_2 AS text_2_3,
  t0.text_3 AS text_3_4,
  t0.no_results AS no_results_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.modified_at AS modified_at_8,
  t0.created_user AS created_user_9,
  t0.modified_user AS modified_user_10
FROM
  network t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.text_1 AS text_1_2, t0.text_2 AS text_2_3, t0.text_3 AS text_3_4, t0.no_results AS no_results_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.created_user AS created_user_9, t0.modified_user AS modified_user_10 FROM network t0 WHERE t0.id = 1;

SELECT
  t0.indexing AS indexing_1,
  t0.path AS path_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.social_title AS social_title_5,
  t0.social_description AS social_description_6,
  t0.social_image AS social_image_7,
  t0.scripts_meta AS scripts_meta_8,
  t0.scripts_header AS scripts_header_9,
  t0.scripts_body AS scripts_body_10,
  t0.scripts_footer AS scripts_footer_11,
  t0.id AS id_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.created_user AS created_user_15,
  t0.modified_user AS modified_user_16
FROM
  seo t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.indexing AS indexing_1, t0.path AS path_2, t0.title AS title_3, t0.description AS description_4, t0.social_title AS social_title_5, t0.social_description AS social_description_6, t0.social_image AS social_image_7, t0.scripts_meta AS scripts_meta_8, t0.scripts_header AS scripts_header_9, t0.scripts_body AS scripts_body_10, t0.scripts_footer AS scripts_footer_11, t0.id AS id_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.created_user AS created_user_15, t0.modified_user AS modified_user_16 FROM seo t0 WHERE t0.path = '/red-buses' LIMIT 1;