Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.website AS website_4,
  t0.description AS description_5,
  t0.order_by AS order_by_6,
  t0.modified AS modified_7,
  t0.created AS created_8,
  t0.is_active AS is_active_9,
  t0.api_name AS api_name_10,
  t0.is_menu AS is_menu_11,
  t0.has_otc AS has_otc_12,
  t0.has_published AS has_published_13,
  t0.banner_lg AS banner_lg_14,
  t0.banner_sm AS banner_sm_15,
  t0.featured_items AS featured_items_16,
  t0.video AS video_17,
  t0.meta_title_landing AS meta_title_landing_18,
  t0.meta_description_landing AS meta_description_landing_19,
  t0.meta_title_search AS meta_title_search_20,
  t0.meta_description_search AS meta_description_search_21
FROM
  brands t0
WHERE
  t0.api_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.website AS website_4, t0.description AS description_5, t0.order_by AS order_by_6, t0.modified AS modified_7, t0.created AS created_8, t0.is_active AS is_active_9, t0.api_name AS api_name_10, t0.is_menu AS is_menu_11, t0.has_otc AS has_otc_12, t0.has_published AS has_published_13, t0.banner_lg AS banner_lg_14, t0.banner_sm AS banner_sm_15, t0.featured_items AS featured_items_16, t0.video AS video_17, t0.meta_title_landing AS meta_title_landing_18, t0.meta_description_landing AS meta_description_landing_19, t0.meta_title_search AS meta_title_search_20, t0.meta_description_search AS meta_description_search_21 FROM brands t0 WHERE t0.api_name = 'troy' LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.item_id AS item_id_1,
  i0_.tax_id AS tax_id_2,
  i0_.name AS name_3,
  i0_.description AS description_4,
  i0_.manufacturer AS manufacturer_5,
  i0_.sku AS sku_6,
  i0_.rate AS rate_7,
  i0_.stock AS stock_8,
  i0_.tax_percentage AS tax_percentage_9,
  i0_.status AS status_10,
  i0_.is_discount AS is_discount_11,
  i0_.modified AS modified_12,
  i0_.created AS created_13,
  i0_.slug AS slug_14,
  i0_.is_controlled AS is_controlled_15,
  i0_.cogs AS cogs_16,
  i0_.short_expiry_discount AS short_expiry_discount_17,
  i0_.short_expiry AS short_expiry_18,
  i0_.target_gp AS target_gp_19,
  i0_.is_otc AS is_otc_20,
  i0_.related_items AS related_items_21,
  i0_.display_name AS display_name_22,
  i0_.otc_rate AS otc_rate_23,
  i0_.is_clearance AS is_clearance_24,
  i0_.total_ordered AS total_ordered_25,
  i0_.product_type AS product_type_26,
  i0_.shop_status AS shop_status_27,
  i0_.discount AS discount_28,
  i0_.base_rate AS base_rate_29,
  i0_.intro AS intro_30,
  i0_.meta_title AS meta_title_31,
  i0_.meta_description AS meta_description_32,
  i0_.url AS url_33,
  i0_.special_type_id AS special_type_id_34,
  i0_.discount_type_id AS discount_type_id_35,
  i0_.brand_id AS brand_id_36
FROM
  items i0_
WHERE
  i0_.id IN (?, ?, ?)

SELECT i0_.id AS id_0, i0_.item_id AS item_id_1, i0_.tax_id AS tax_id_2, i0_.name AS name_3, i0_.description AS description_4, i0_.manufacturer AS manufacturer_5, i0_.sku AS sku_6, i0_.rate AS rate_7, i0_.stock AS stock_8, i0_.tax_percentage AS tax_percentage_9, i0_.status AS status_10, i0_.is_discount AS is_discount_11, i0_.modified AS modified_12, i0_.created AS created_13, i0_.slug AS slug_14, i0_.is_controlled AS is_controlled_15, i0_.cogs AS cogs_16, i0_.short_expiry_discount AS short_expiry_discount_17, i0_.short_expiry AS short_expiry_18, i0_.target_gp AS target_gp_19, i0_.is_otc AS is_otc_20, i0_.related_items AS related_items_21, i0_.display_name AS display_name_22, i0_.otc_rate AS otc_rate_23, i0_.is_clearance AS is_clearance_24, i0_.total_ordered AS total_ordered_25, i0_.product_type AS product_type_26, i0_.shop_status AS shop_status_27, i0_.discount AS discount_28, i0_.base_rate AS base_rate_29, i0_.intro AS intro_30, i0_.meta_title AS meta_title_31, i0_.meta_description AS meta_description_32, i0_.url AS url_33, i0_.special_type_id AS special_type_id_34, i0_.discount_type_id AS discount_type_id_35, i0_.brand_id AS brand_id_36 FROM items i0_ WHERE i0_.id IN ('339', '579', '587');

SELECT
  c0_.id AS id_0,
  c0_.phone AS phone_1,
  c0_.code AS code_2,
  c0_.name AS name_3,
  c0_.modified AS modified_4,
  c0_.created AS created_5,
  c0_.is_active AS is_active_6,
  c0_.currency AS currency_7
FROM
  countries c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.phone AS phone_1, c0_.code AS code_2, c0_.name AS name_3, c0_.modified AS modified_4, c0_.created AS created_5, c0_.is_active AS is_active_6, c0_.currency AS currency_7 FROM countries c0_ ORDER BY c0_.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
  t0.id AS id_1,
  t0.modified AS modified_2,
  t0.created AS created_3,
  t0.brand_id AS brand_id_4,
  t0.brand_category_name_id AS brand_category_name_id_5
FROM
  brands_categories t0
WHERE
  t0.brand_id = ?

SELECT t0.id AS id_1, t0.modified AS modified_2, t0.created AS created_3, t0.brand_id AS brand_id_4, t0.brand_category_name_id AS brand_category_name_id_5 FROM brands_categories t0 WHERE t0.brand_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.modified AS modified_3, t0.created AS created_4 FROM brand_category_names t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.modified AS modified_3,
  t0.created AS created_4
FROM
  brand_category_names t0
WHERE
  t0.id = ?