Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.modified AS modified_2,
  c0_.created AS created_3
FROM
  categories c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.modified AS modified_2, c0_.created AS created_3 FROM categories c0_ ORDER BY c0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.image AS image_2,
  b0_.copy AS copy_3,
  b0_.publish_date AS publish_date_4,
  b0_.meta_title AS meta_title_5,
  b0_.meta_description AS meta_description_6,
  b0_.is_published AS is_published_7,
  b0_.modified AS modified_8,
  b0_.created AS created_9,
  b0_.alt AS alt_10,
  b0_.is_home_page AS is_home_page_11,
  b0_.home_image AS home_image_12,
  b0_.home_image_alt AS home_image_alt_13,
  b0_.home_title AS home_title_14,
  b0_.excerpt_length AS excerpt_length_15,
  b0_.url AS url_16
FROM
  blogs b0_
ORDER BY
  b0_.publish_date DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.copy AS copy_3, b0_.publish_date AS publish_date_4, b0_.meta_title AS meta_title_5, b0_.meta_description AS meta_description_6, b0_.is_published AS is_published_7, b0_.modified AS modified_8, b0_.created AS created_9, b0_.alt AS alt_10, b0_.is_home_page AS is_home_page_11, b0_.home_image AS home_image_12, b0_.home_image_alt AS home_image_alt_13, b0_.home_title AS home_title_14, b0_.excerpt_length AS excerpt_length_15, b0_.url AS url_16 FROM blogs b0_ ORDER BY b0_.publish_date DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.copy AS copy_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.publish_date AS publish_date_6,
  t0.is_published AS is_published_7,
  t0.modified AS modified_8,
  t0.created AS created_9,
  t0.is_header AS is_header_10,
  t0.is_footer AS is_footer_11,
  t0.is_meta_data AS is_meta_data_12
FROM
  pages t0
WHERE
  t0.title = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.title = 'News | Articles' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.image AS image_2,
  b0_.copy AS copy_3,
  b0_.publish_date AS publish_date_4,
  b0_.meta_title AS meta_title_5,
  b0_.meta_description AS meta_description_6,
  b0_.is_published AS is_published_7,
  b0_.modified AS modified_8,
  b0_.created AS created_9,
  b0_.alt AS alt_10,
  b0_.is_home_page AS is_home_page_11,
  b0_.home_image AS home_image_12,
  b0_.home_image_alt AS home_image_alt_13,
  b0_.home_title AS home_title_14,
  b0_.excerpt_length AS excerpt_length_15,
  b0_.url AS url_16,
  b1_.id AS id_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.modified AS modified_20,
  c2_.created AS created_21,
  b1_.blogs_id AS blogs_id_22,
  b1_.categories_id AS categories_id_23
FROM
  blogs b0_
  LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id
  LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id
WHERE
  b0_.is_published = ?
  AND b0_.publish_date <= ?
ORDER BY
  b0_.publish_date DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.copy AS copy_3, b0_.publish_date AS publish_date_4, b0_.meta_title AS meta_title_5, b0_.meta_description AS meta_description_6, b0_.is_published AS is_published_7, b0_.modified AS modified_8, b0_.created AS created_9, b0_.alt AS alt_10, b0_.is_home_page AS is_home_page_11, b0_.home_image AS home_image_12, b0_.home_image_alt AS home_image_alt_13, b0_.home_title AS home_title_14, b0_.excerpt_length AS excerpt_length_15, b0_.url AS url_16, b1_.id AS id_17, c2_.id AS id_18, c2_.name AS name_19, c2_.modified AS modified_20, c2_.created AS created_21, b1_.blogs_id AS blogs_id_22, b1_.categories_id AS categories_id_23 FROM blogs b0_ LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id WHERE b0_.is_published = 1 AND b0_.publish_date <= '2026-06-26 00:00:00' ORDER BY b0_.publish_date DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.image AS image_2,
          b0_.copy AS copy_3,
          b0_.publish_date AS publish_date_4,
          b0_.meta_title AS meta_title_5,
          b0_.meta_description AS meta_description_6,
          b0_.is_published AS is_published_7,
          b0_.modified AS modified_8,
          b0_.created AS created_9,
          b0_.alt AS alt_10,
          b0_.is_home_page AS is_home_page_11,
          b0_.home_image AS home_image_12,
          b0_.home_image_alt AS home_image_alt_13,
          b0_.home_title AS home_title_14,
          b0_.excerpt_length AS excerpt_length_15,
          b0_.url AS url_16,
          b1_.id AS id_17,
          c2_.id AS id_18,
          c2_.name AS name_19,
          c2_.modified AS modified_20,
          c2_.created AS created_21
        FROM
          blogs b0_
          LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id
          LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id
        WHERE
          b0_.is_published = ?
          AND b0_.publish_date <= ?
        ORDER BY
          b0_.publish_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.copy AS copy_3, b0_.publish_date AS publish_date_4, b0_.meta_title AS meta_title_5, b0_.meta_description AS meta_description_6, b0_.is_published AS is_published_7, b0_.modified AS modified_8, b0_.created AS created_9, b0_.alt AS alt_10, b0_.is_home_page AS is_home_page_11, b0_.home_image AS home_image_12, b0_.home_image_alt AS home_image_alt_13, b0_.home_title AS home_title_14, b0_.excerpt_length AS excerpt_length_15, b0_.url AS url_16, b1_.id AS id_17, c2_.id AS id_18, c2_.name AS name_19, c2_.modified AS modified_20, c2_.created AS created_21 FROM blogs b0_ LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id WHERE b0_.is_published = 1 AND b0_.publish_date <= '2026-06-26 00:00:00' ORDER BY b0_.publish_date DESC) dctrn_result) dctrn_table;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.logo AS logo_2,
  b0_.website AS website_3,
  b0_.description AS description_4,
  b0_.order_by AS order_by_5,
  b0_.modified AS modified_6,
  b0_.created AS created_7,
  b0_.is_active AS is_active_8,
  b0_.api_name AS api_name_9,
  b0_.is_menu AS is_menu_10,
  b0_.has_otc AS has_otc_11,
  b0_.has_published AS has_published_12,
  b0_.banner_lg AS banner_lg_13,
  b0_.banner_sm AS banner_sm_14,
  b0_.featured_items AS featured_items_15,
  b0_.video AS video_16,
  b0_.meta_title_landing AS meta_title_landing_17,
  b0_.meta_description_landing AS meta_description_landing_18,
  b0_.meta_title_search AS meta_title_search_19,
  b0_.meta_description_search AS meta_description_search_20
FROM
  brands b0_
WHERE
  b0_.has_otc = ?
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.website AS website_3, b0_.description AS description_4, b0_.order_by AS order_by_5, b0_.modified AS modified_6, b0_.created AS created_7, b0_.is_active AS is_active_8, b0_.api_name AS api_name_9, b0_.is_menu AS is_menu_10, b0_.has_otc AS has_otc_11, b0_.has_published AS has_published_12, b0_.banner_lg AS banner_lg_13, b0_.banner_sm AS banner_sm_14, b0_.featured_items AS featured_items_15, b0_.video AS video_16, b0_.meta_title_landing AS meta_title_landing_17, b0_.meta_description_landing AS meta_description_landing_18, b0_.meta_title_search AS meta_title_search_19, b0_.meta_description_search AS meta_description_search_20 FROM brands b0_ WHERE b0_.has_otc = 1 ORDER BY b0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.modified AS modified_3,
  t0.created AS created_4,
  t0.default_message AS default_message_5,
  t0.custom_message AS custom_message_6,
  t0.use_default_message AS use_default_message_7,
  t0.user_id AS user_id_8
FROM
  maintenance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.modified AS modified_3, t0.created AS created_4, t0.default_message AS default_message_5, t0.custom_message AS custom_message_6, t0.use_default_message AS use_default_message_7, t0.user_id AS user_id_8 FROM maintenance t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.job_title AS job_title_1,
  c0_.job_type AS job_type_2,
  c0_.posted AS posted_3,
  c0_.expires AS expires_4,
  c0_.url AS url_5,
  c0_.modified AS modified_6,
  c0_.created AS created_7
FROM
  careers c0_
WHERE
  c0_.posted <= ?
  AND c0_.expires >= ?
ORDER BY
  c0_.job_title ASC

SELECT c0_.id AS id_0, c0_.job_title AS job_title_1, c0_.job_type AS job_type_2, c0_.posted AS posted_3, c0_.expires AS expires_4, c0_.url AS url_5, c0_.modified AS modified_6, c0_.created AS created_7 FROM careers c0_ WHERE c0_.posted <= '2026-06-26' AND c0_.expires >= '2026-06-26' ORDER BY c0_.job_title ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.logo AS logo_2,
  b0_.website AS website_3,
  b0_.description AS description_4,
  b0_.order_by AS order_by_5,
  b0_.modified AS modified_6,
  b0_.created AS created_7,
  b0_.is_active AS is_active_8,
  b0_.api_name AS api_name_9,
  b0_.is_menu AS is_menu_10,
  b0_.has_otc AS has_otc_11,
  b0_.has_published AS has_published_12,
  b0_.banner_lg AS banner_lg_13,
  b0_.banner_sm AS banner_sm_14,
  b0_.featured_items AS featured_items_15,
  b0_.video AS video_16,
  b0_.meta_title_landing AS meta_title_landing_17,
  b0_.meta_description_landing AS meta_description_landing_18,
  b0_.meta_title_search AS meta_title_search_19,
  b0_.meta_description_search AS meta_description_search_20
FROM
  brands b0_
WHERE
  b0_.has_otc = ?
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.website AS website_3, b0_.description AS description_4, b0_.order_by AS order_by_5, b0_.modified AS modified_6, b0_.created AS created_7, b0_.is_active AS is_active_8, b0_.api_name AS api_name_9, b0_.is_menu AS is_menu_10, b0_.has_otc AS has_otc_11, b0_.has_published AS has_published_12, b0_.banner_lg AS banner_lg_13, b0_.banner_sm AS banner_sm_14, b0_.featured_items AS featured_items_15, b0_.video AS video_16, b0_.meta_title_landing AS meta_title_landing_17, b0_.meta_description_landing AS meta_description_landing_18, b0_.meta_title_search AS meta_title_search_19, b0_.meta_description_search AS meta_description_search_20 FROM brands b0_ WHERE b0_.has_otc = 1 ORDER BY b0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.copy AS copy_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.publish_date AS publish_date_6,
  t0.is_published AS is_published_7,
  t0.modified AS modified_8,
  t0.created AS created_9,
  t0.is_header AS is_header_10,
  t0.is_footer AS is_footer_11,
  t0.is_meta_data AS is_meta_data_12
FROM
  pages t0
WHERE
  t0.is_published = ?
  AND t0.is_header = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.is_published = 1 AND t0.is_header = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.button AS button_3,
  t0.link AS link_4,
  t0.image AS image_5,
  t0.is_active AS is_active_6,
  t0.modified AS modified_7,
  t0.created AS created_8
FROM
  pop_ups t0
WHERE
  t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.button AS button_3, t0.link AS link_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.modified AS modified_7, t0.created AS created_8 FROM pop_ups t0 WHERE t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.copy AS copy_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.publish_date AS publish_date_6,
  t0.is_published AS is_published_7,
  t0.modified AS modified_8,
  t0.created AS created_9,
  t0.is_header AS is_header_10,
  t0.is_footer AS is_footer_11,
  t0.is_meta_data AS is_meta_data_12
FROM
  pages t0
WHERE
  t0.is_published = ?
  AND t0.is_footer = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.is_published = 1 AND t0.is_footer = 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      publish_date_4
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.image AS image_2,
          b0_.copy AS copy_3,
          b0_.publish_date AS publish_date_4,
          b0_.meta_title AS meta_title_5,
          b0_.meta_description AS meta_description_6,
          b0_.is_published AS is_published_7,
          b0_.modified AS modified_8,
          b0_.created AS created_9,
          b0_.alt AS alt_10,
          b0_.is_home_page AS is_home_page_11,
          b0_.home_image AS home_image_12,
          b0_.home_image_alt AS home_image_alt_13,
          b0_.home_title AS home_title_14,
          b0_.excerpt_length AS excerpt_length_15,
          b0_.url AS url_16,
          b1_.id AS id_17,
          c2_.id AS id_18,
          c2_.name AS name_19,
          c2_.modified AS modified_20,
          c2_.created AS created_21
        FROM
          blogs b0_
          LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id
          LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id
        WHERE
          b0_.is_published = ?
          AND b0_.publish_date <= ?
      ) dctrn_result_inner
    ORDER BY
      publish_date_4 DESC
  ) dctrn_result
LIMIT
  6
OFFSET
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publish_date_4 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.copy AS copy_3, b0_.publish_date AS publish_date_4, b0_.meta_title AS meta_title_5, b0_.meta_description AS meta_description_6, b0_.is_published AS is_published_7, b0_.modified AS modified_8, b0_.created AS created_9, b0_.alt AS alt_10, b0_.is_home_page AS is_home_page_11, b0_.home_image AS home_image_12, b0_.home_image_alt AS home_image_alt_13, b0_.home_title AS home_title_14, b0_.excerpt_length AS excerpt_length_15, b0_.url AS url_16, b1_.id AS id_17, c2_.id AS id_18, c2_.name AS name_19, c2_.modified AS modified_20, c2_.created AS created_21 FROM blogs b0_ LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id WHERE b0_.is_published = 1 AND b0_.publish_date <= '2026-06-26 00:00:00') dctrn_result_inner ORDER BY publish_date_4 DESC) dctrn_result LIMIT 6 OFFSET 12;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.image AS image_2,
  b0_.copy AS copy_3,
  b0_.publish_date AS publish_date_4,
  b0_.meta_title AS meta_title_5,
  b0_.meta_description AS meta_description_6,
  b0_.is_published AS is_published_7,
  b0_.modified AS modified_8,
  b0_.created AS created_9,
  b0_.alt AS alt_10,
  b0_.is_home_page AS is_home_page_11,
  b0_.home_image AS home_image_12,
  b0_.home_image_alt AS home_image_alt_13,
  b0_.home_title AS home_title_14,
  b0_.excerpt_length AS excerpt_length_15,
  b0_.url AS url_16,
  b1_.id AS id_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.modified AS modified_20,
  c2_.created AS created_21,
  b1_.blogs_id AS blogs_id_22,
  b1_.categories_id AS categories_id_23
FROM
  blogs b0_
  LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id
  LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id
WHERE
  b0_.is_published = ?
  AND b0_.publish_date <= ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.publish_date DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.copy AS copy_3, b0_.publish_date AS publish_date_4, b0_.meta_title AS meta_title_5, b0_.meta_description AS meta_description_6, b0_.is_published AS is_published_7, b0_.modified AS modified_8, b0_.created AS created_9, b0_.alt AS alt_10, b0_.is_home_page AS is_home_page_11, b0_.home_image AS home_image_12, b0_.home_image_alt AS home_image_alt_13, b0_.home_title AS home_title_14, b0_.excerpt_length AS excerpt_length_15, b0_.url AS url_16, b1_.id AS id_17, c2_.id AS id_18, c2_.name AS name_19, c2_.modified AS modified_20, c2_.created AS created_21, b1_.blogs_id AS blogs_id_22, b1_.categories_id AS categories_id_23 FROM blogs b0_ LEFT JOIN blog_categories b1_ ON b0_.id = b1_.blogs_id LEFT JOIN categories c2_ ON b1_.categories_id = c2_.id WHERE b0_.is_published = 1 AND b0_.publish_date <= '2026-06-26 00:00:00' AND b0_.id IN (11, 4, 5, 3, 1, 2) ORDER BY b0_.publish_date DESC;