Symfony Profiler

SELECT
  COUNT(*)
FROM
  product t0
WHERE
  t0.category = ?

SELECT COUNT(*) FROM product t0 WHERE t0.category = 'Useful Guide';

SELECT
  t0.id AS id_1,
  t0.content_text AS content_text_2,
  t0.hyperlinks AS hyperlinks_3,
  t0.content_title AS content_title_4,
  t0.content_text_fr AS content_text_fr_5,
  t0.content_text_de AS content_text_de_6,
  t0.content_title_fr AS content_title_fr_7,
  t0.content_title_de AS content_title_de_8,
  t0.tab_title AS tab_title_9,
  t0.category AS category_10,
  t0.static_page_name AS static_page_name_11,
  t0.attachment AS attachment_12,
  t0.ranking AS ranking_13,
  t0.tab_title_fr AS tab_title_fr_14,
  t0.tab_title_de AS tab_title_de_15,
  t0.product_id AS product_id_16,
  t0.page_layout_id AS page_layout_id_17
FROM
  cms_copy t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.pros AS pros_4,
  t0.cons AS cons_5,
  t0.code AS code_6,
  t0.uses AS uses_7
FROM
  cms_copy_page_formats t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.pros AS pros_4, t0.cons AS cons_5, t0.code AS code_6, t0.uses AS uses_7 FROM cms_copy_page_formats t0 WHERE t0.id = 2;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.abbreviation AS abbreviation_2,
  l0_.icon AS icon_3,
  l0_.is_active AS is_active_4,
  l0_.linked_in_other AS linked_in_other_5,
  l0_.ranking AS ranking_6
FROM
  languages l0_
WHERE
  l0_.is_active = 1
ORDER BY
  l0_.ranking ASC

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC;

SELECT
  t0.id AS id_1,
  t0.product AS product_2,
  t0.ranking AS ranking_3,
  t0.is_active AS is_active_4,
  t0.include_in_footer AS include_in_footer_5,
  t0.category AS category_6,
  t0.include_in_contact_form AS include_in_contact_form_7,
  t0.notes AS notes_8,
  t0.new_client_email AS new_client_email_9,
  t0.menu_icon AS menu_icon_10,
  t0.menu_icon_colour AS menu_icon_colour_11,
  t0.helpful_guide_topic AS helpful_guide_topic_12
FROM
  product t0
WHERE
  t0.product = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.product = 'Flying' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.count AS count_3,
  t0.count_user AS count_user_4,
  t0.count_admin AS count_admin_5,
  t0.product_id AS product_id_6
FROM
  page_visit t0
WHERE
  t0.product_id = ?
  AND t0.date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.count AS count_3, t0.count_user AS count_user_4, t0.count_admin AS count_admin_5, t0.product_id AS product_id_6 FROM page_visit t0 WHERE t0.product_id = 2 AND t0.date = '2026-01-15' LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.content_text AS content_text_2,
  t0.hyperlinks AS hyperlinks_3,
  t0.content_title AS content_title_4,
  t0.content_text_fr AS content_text_fr_5,
  t0.content_text_de AS content_text_de_6,
  t0.content_title_fr AS content_title_fr_7,
  t0.content_title_de AS content_title_de_8,
  t0.tab_title AS tab_title_9,
  t0.category AS category_10,
  t0.static_page_name AS static_page_name_11,
  t0.attachment AS attachment_12,
  t0.ranking AS ranking_13,
  t0.tab_title_fr AS tab_title_fr_14,
  t0.tab_title_de AS tab_title_de_15,
  t0.product_id AS product_id_16,
  t0.page_layout_id AS page_layout_id_17
FROM
  cms_copy t0
WHERE
  t0.product_id = ?
  AND t0.ranking = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content_text AS content_text_2, t0.hyperlinks AS hyperlinks_3, t0.content_title AS content_title_4, t0.content_text_fr AS content_text_fr_5, t0.content_text_de AS content_text_de_6, t0.content_title_fr AS content_title_fr_7, t0.content_title_de AS content_title_de_8, t0.tab_title AS tab_title_9, t0.category AS category_10, t0.static_page_name AS static_page_name_11, t0.attachment AS attachment_12, t0.ranking AS ranking_13, t0.tab_title_fr AS tab_title_fr_14, t0.tab_title_de AS tab_title_de_15, t0.product_id AS product_id_16, t0.page_layout_id AS page_layout_id_17 FROM cms_copy t0 WHERE t0.product_id = 2 AND t0.ranking = '1' LIMIT 1;

INSERT INTO page_visit (
  date, count, count_user, count_admin,
  product_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO page_visit (date, count, count_user, count_admin, product_id) VALUES ('2026-01-15', 1, 0, 0, 2);

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.count AS count_3,
  t0.count_user AS count_user_4,
  t0.count_admin AS count_admin_5,
  t0.product_id AS product_id_6
FROM
  page_visit t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.count AS count_3, t0.count_user AS count_user_4, t0.count_admin AS count_admin_5, t0.product_id AS product_id_6 FROM page_visit t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.abbreviation = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.product AS product_2,
  t0.ranking AS ranking_3,
  t0.is_active AS is_active_4,
  t0.include_in_footer AS include_in_footer_5,
  t0.category AS category_6,
  t0.include_in_contact_form AS include_in_contact_form_7,
  t0.notes AS notes_8,
  t0.new_client_email AS new_client_email_9,
  t0.menu_icon AS menu_icon_10,
  t0.menu_icon_colour AS menu_icon_colour_11,
  t0.helpful_guide_topic AS helpful_guide_topic_12
FROM
  product t0
WHERE
  t0.include_in_footer = ?
  AND t0.is_active = ?
  AND t0.category = ?
ORDER BY
  t0.ranking ASC

SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.include_in_footer = '1' AND t0.is_active = '1' AND t0.category = 'Main' ORDER BY t0.ranking ASC;

SELECT
  t0.id AS id_1,
  t0.photo AS photo_2,
  t0.title AS title_3,
  t0.link AS link_4,
  t0.category AS category_5,
  t0.static_page_name AS static_page_name_6,
  t0.ranking AS ranking_7,
  t0.rotate AS rotate_8,
  t0.product_id AS product_id_9
FROM
  cms_photo t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.ranking ASC

SELECT t0.id AS id_1, t0.photo AS photo_2, t0.title AS title_3, t0.link AS link_4, t0.category AS category_5, t0.static_page_name AS static_page_name_6, t0.ranking AS ranking_7, t0.rotate AS rotate_8, t0.product_id AS product_id_9 FROM cms_photo t0 WHERE t0.product_id = 2 ORDER BY t0.ranking ASC;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.image AS image_3,
  t0.ranking AS ranking_4,
  t0.title AS title_5,
  t0.product_id AS product_id_6
FROM
  sub_page t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.image AS image_3, t0.ranking AS ranking_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM sub_page t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.product AS product_2,
  t0.ranking AS ranking_3,
  t0.is_active AS is_active_4,
  t0.include_in_footer AS include_in_footer_5,
  t0.category AS category_6,
  t0.include_in_contact_form AS include_in_contact_form_7,
  t0.notes AS notes_8,
  t0.new_client_email AS new_client_email_9,
  t0.menu_icon AS menu_icon_10,
  t0.menu_icon_colour AS menu_icon_colour_11,
  t0.helpful_guide_topic AS helpful_guide_topic_12
FROM
  product t0
WHERE
  t0.include_in_footer = ?
  AND t0.category = ?
ORDER BY
  t0.ranking ASC

SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9, t0.menu_icon AS menu_icon_10, t0.menu_icon_colour AS menu_icon_colour_11, t0.helpful_guide_topic AS helpful_guide_topic_12 FROM product t0 WHERE t0.include_in_footer = '1' AND t0.category = 'Sub' ORDER BY t0.ranking ASC;