Symfony Profiler

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,
  i1_.id AS id_34,
  i1_.image AS image_35,
  i1_.is_default AS is_default_36,
  i1_.modified AS modified_37,
  i1_.created AS created_38,
  i1_.order_by AS order_by_39,
  i2_.id AS id_40,
  i3_.id AS id_41,
  i3_.name AS name_42,
  i3_.modified AS modified_43,
  i3_.created AS created_44,
  i0_.special_type_id AS special_type_id_45,
  i0_.discount_type_id AS discount_type_id_46,
  i0_.brand_id AS brand_id_47,
  i1_.item_id AS item_id_48,
  i2_.items_id AS items_id_49,
  i2_.item_categories_id AS item_categories_id_50
FROM
  items i0_
  LEFT JOIN item_images i1_ ON i0_.id = i1_.item_id
  LEFT JOIN items_categories i2_ ON i0_.id = i2_.items_id
  LEFT JOIN item_categories i3_ ON i2_.item_categories_id = i3_.id
WHERE
  i0_.is_otc = ?
  AND i0_.manufacturer = ?
  AND i0_.status = ?
  AND i0_.shop_status = ?
  AND i0_.name NOT IN (?, ?, ?, ?, ?, ?)
  AND i0_.product_type = ?
ORDER BY
  i0_.display_name ASC

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, i1_.id AS id_34, i1_.image AS image_35, i1_.is_default AS is_default_36, i1_.modified AS modified_37, i1_.created AS created_38, i1_.order_by AS order_by_39, i2_.id AS id_40, i3_.id AS id_41, i3_.name AS name_42, i3_.modified AS modified_43, i3_.created AS created_44, i0_.special_type_id AS special_type_id_45, i0_.discount_type_id AS discount_type_id_46, i0_.brand_id AS brand_id_47, i1_.item_id AS item_id_48, i2_.items_id AS items_id_49, i2_.item_categories_id AS item_categories_id_50 FROM items i0_ LEFT JOIN item_images i1_ ON i0_.id = i1_.item_id LEFT JOIN items_categories i2_ ON i0_.id = i2_.items_id LEFT JOIN item_categories i3_ ON i2_.item_categories_id = i3_.id WHERE i0_.is_otc = 1 AND i0_.manufacturer = 'kyron' AND i0_.status = 'active' AND i0_.shop_status = 1 AND i0_.name NOT IN ('Delivery Charges - Others', 'Saracen Delivery Charges', 'Documentation Charges', 'Service Charges', 'Shipping Cost', 'Training Support') AND i0_.product_type = 'goods' ORDER BY i0_.display_name ASC;

SELECT
  d.*,
  dt.type
FROM
  discounts d
  JOIN discount_types dt ON d.discount_type_id = dt.id
WHERE
  (
    JSON_CONTAINS(d.products, '["52"]')
    OR JSON_CONTAINS(d.products, '["all"]')
    OR JSON_CONTAINS(d.brands, '["7"]')
    OR JSON_CONTAINS(d.brands, '["all"]')
  )
  AND (
    JSON_CONTAINS(d.contacts, '["0"]')
    OR JSON_CONTAINS(d.contacts, '["all"]')
  )
  AND d.start_date <= '2026-06-26'
  AND d.end_date >= '2026-06-26'
  AND (
    d.discount_type_id = 1
    OR d.discount_type_id = 3
    OR d.discount_type_id = 4
  )
  AND d.status = 1
LIMIT
  1

SELECT d.*, dt.type FROM 
                discounts d
                JOIN discount_types dt ON d.discount_type_id = dt.id
             WHERE (
                 JSON_CONTAINS(d.products, '["52"]') OR JSON_CONTAINS(d.products, '["all"]')
             OR 
                 JSON_CONTAINS(d.brands, '["7"]') OR JSON_CONTAINS(d.brands, '["all"]')
             )
            AND
                 (
                     JSON_CONTAINS(d.contacts, '["0"]') OR JSON_CONTAINS(d.contacts, '["all"]')
                 )
            AND
                 d.start_date <= '2026-06-26' 
           AND 
                 d.end_date >= '2026-06-26'
            AND
                 (d.discount_type_id = 1 OR d.discount_type_id = 3 OR d.discount_type_id = 4)
             AND d.status = 1
            LIMIT 1
         ;

SELECT
  t0.id AS id_1,
  t0.price_list_id AS price_list_id_2,
  t0.name AS name_3,
  t0.status AS status_4,
  t0.modified AS modified_5,
  t0.created AS created_6
FROM
  price_lists t0
WHERE
  t0.price_list_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_list_id AS price_list_id_2, t0.name AS name_3, t0.status AS status_4, t0.modified AS modified_5, t0.created AS created_6 FROM price_lists t0 WHERE t0.price_list_id = '1625918000044039275' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.modified AS modified_3,
  t0.created AS created_4,
  t0.vat AS vat_5,
  t0.sub_total AS sub_total_6,
  t0.total AS total_7,
  t0.delivery_fee AS delivery_fee_8,
  t0.discount AS discount_9,
  t0.attatchment AS attatchment_10,
  t0.total_items AS total_items_11,
  t0.is_sales_order AS is_sales_order_12,
  t0.is_package AS is_package_13,
  t0.is_shipment AS is_shipment_14,
  t0.is_invoice AS is_invoice_15,
  t0.sales_order_no AS sales_order_no_16,
  t0.invoice_no AS invoice_no_17,
  t0.invoice_id AS invoice_id_18,
  t0.prescription AS prescription_19,
  t0.payment_link AS payment_link_20,
  t0.po_number AS po_number_21,
  t0.is_smart_order AS is_smart_order_22,
  t0.entity_id AS entity_id_23,
  t0.entity_user_id AS entity_user_id_24,
  t0.billing_address_id AS billing_address_id_25,
  t0.shipping_address_id AS shipping_address_id_26,
  t27.id AS id_28,
  t27.sales_order_id AS sales_order_id_29,
  t27.sales_order_number AS sales_order_number_30,
  t27.modified AS modified_31,
  t27.created AS created_32,
  t27.basket_id AS basket_id_33,
  t0.payment_type_id AS payment_type_id_34,
  t35.id AS id_36,
  t35.would_recommend AS would_recommend_37,
  t35.comments AS comments_38,
  t35.modified AS modified_39,
  t35.created AS created_40,
  t35.entity_user_id AS entity_user_id_41,
  t35.basket_id AS basket_id_42
FROM
  baskets t0
  LEFT JOIN sales_orders t27 ON t27.basket_id = t0.id
  LEFT JOIN feedback t35 ON t35.basket_id = t0.id
WHERE
  t0.entity_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.modified AS modified_3, t0.created AS created_4, t0.vat AS vat_5, t0.sub_total AS sub_total_6, t0.total AS total_7, t0.delivery_fee AS delivery_fee_8, t0.discount AS discount_9, t0.attatchment AS attatchment_10, t0.total_items AS total_items_11, t0.is_sales_order AS is_sales_order_12, t0.is_package AS is_package_13, t0.is_shipment AS is_shipment_14, t0.is_invoice AS is_invoice_15, t0.sales_order_no AS sales_order_no_16, t0.invoice_no AS invoice_no_17, t0.invoice_id AS invoice_id_18, t0.prescription AS prescription_19, t0.payment_link AS payment_link_20, t0.po_number AS po_number_21, t0.is_smart_order AS is_smart_order_22, t0.entity_id AS entity_id_23, t0.entity_user_id AS entity_user_id_24, t0.billing_address_id AS billing_address_id_25, t0.shipping_address_id AS shipping_address_id_26, t27.id AS id_28, t27.sales_order_id AS sales_order_id_29, t27.sales_order_number AS sales_order_number_30, t27.modified AS modified_31, t27.created AS created_32, t27.basket_id AS basket_id_33, t0.payment_type_id AS payment_type_id_34, t35.id AS id_36, t35.would_recommend AS would_recommend_37, t35.comments AS comments_38, t35.modified AS modified_39, t35.created AS created_40, t35.entity_user_id AS entity_user_id_41, t35.basket_id AS basket_id_42 FROM baskets t0 LEFT JOIN sales_orders t27 ON t27.basket_id = t0.id LEFT JOIN feedback t35 ON t35.basket_id = t0.id WHERE t0.entity_id = 0 AND t0.status = 'open' LIMIT 1;

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
  t0.id AS id_1,
  t0.price_list_item_id AS price_list_item_id_2,
  t0.item_id AS item_id_3,
  t0.name AS name_4,
  t0.rate AS rate_5,
  t0.modified AS modified_6,
  t0.created AS created_7,
  t0.price_list_id AS price_list_id_8
FROM
  price_list_items t0
WHERE
  t0.price_list_id = ?
  AND t0.item_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_list_item_id AS price_list_item_id_2, t0.item_id AS item_id_3, t0.name AS name_4, t0.rate AS rate_5, t0.modified AS modified_6, t0.created AS created_7, t0.price_list_id AS price_list_id_8 FROM price_list_items t0 WHERE t0.price_list_id = 16 AND t0.item_id = '1625918000004123055' LIMIT 1;

SELECT
  SUM(b0_.qty) AS sclr_0
FROM
  batches b0_
WHERE
  b0_.item_id = ?
GROUP BY
  b0_.item_id

SELECT SUM(b0_.qty) AS sclr_0 FROM batches b0_ WHERE b0_.item_id = '1625918000004123055' GROUP BY b0_.item_id;

SELECT
  t0.id AS id_1,
  t0.item_id AS item_id_2,
  t0.tax_id AS tax_id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.manufacturer AS manufacturer_6,
  t0.sku AS sku_7,
  t0.rate AS rate_8,
  t0.stock AS stock_9,
  t0.tax_percentage AS tax_percentage_10,
  t0.status AS status_11,
  t0.is_discount AS is_discount_12,
  t0.modified AS modified_13,
  t0.created AS created_14,
  t0.slug AS slug_15,
  t0.is_controlled AS is_controlled_16,
  t0.cogs AS cogs_17,
  t0.short_expiry_discount AS short_expiry_discount_18,
  t0.short_expiry AS short_expiry_19,
  t0.target_gp AS target_gp_20,
  t0.is_otc AS is_otc_21,
  t0.related_items AS related_items_22,
  t0.display_name AS display_name_23,
  t0.otc_rate AS otc_rate_24,
  t0.is_clearance AS is_clearance_25,
  t0.total_ordered AS total_ordered_26,
  t0.product_type AS product_type_27,
  t0.shop_status AS shop_status_28,
  t0.discount AS discount_29,
  t0.base_rate AS base_rate_30,
  t0.intro AS intro_31,
  t0.meta_title AS meta_title_32,
  t0.meta_description AS meta_description_33,
  t0.url AS url_34,
  t0.special_type_id AS special_type_id_35,
  t0.discount_type_id AS discount_type_id_36,
  t0.brand_id AS brand_id_37
FROM
  items t0
WHERE
  t0.item_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.tax_id AS tax_id_3, t0.name AS name_4, t0.description AS description_5, t0.manufacturer AS manufacturer_6, t0.sku AS sku_7, t0.rate AS rate_8, t0.stock AS stock_9, t0.tax_percentage AS tax_percentage_10, t0.status AS status_11, t0.is_discount AS is_discount_12, t0.modified AS modified_13, t0.created AS created_14, t0.slug AS slug_15, t0.is_controlled AS is_controlled_16, t0.cogs AS cogs_17, t0.short_expiry_discount AS short_expiry_discount_18, t0.short_expiry AS short_expiry_19, t0.target_gp AS target_gp_20, t0.is_otc AS is_otc_21, t0.related_items AS related_items_22, t0.display_name AS display_name_23, t0.otc_rate AS otc_rate_24, t0.is_clearance AS is_clearance_25, t0.total_ordered AS total_ordered_26, t0.product_type AS product_type_27, t0.shop_status AS shop_status_28, t0.discount AS discount_29, t0.base_rate AS base_rate_30, t0.intro AS intro_31, t0.meta_title AS meta_title_32, t0.meta_description AS meta_description_33, t0.url AS url_34, t0.special_type_id AS special_type_id_35, t0.discount_type_id AS discount_type_id_36, t0.brand_id AS brand_id_37 FROM items t0 WHERE t0.item_id = '1625918000004123055' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3,
  t0.modified AS modified_4,
  t0.created AS created_5,
  t0.api_id AS api_id_6
FROM
  api_details t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.modified AS modified_4, t0.created AS created_5, t0.api_id AS api_id_6 FROM api_details t0 WHERE t0.label = 'OTC ID' 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 = ?
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 = 'kyron' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.image AS image_1,
  c0_.alt AS alt_2,
  c0_.caption_title AS caption_title_3,
  c0_.caption AS caption_4,
  c0_.url AS url_5,
  c0_.is_published AS is_published_6,
  c0_.modified AS modified_7,
  c0_.created AS created_8,
  c0_.order_by AS order_by_9,
  c0_.page AS page_10,
  c0_.brand AS brand_11,
  c0_.link AS link_12,
  c0_.display_rule AS display_rule_13,
  c0_.is_video AS is_video_14
FROM
  carousel c0_
WHERE
  c0_.brand = ?
  AND c0_.is_published = ?
  AND c0_.display_rule IN (?, ?, ?)
ORDER BY
  c0_.order_by ASC

SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.alt AS alt_2, c0_.caption_title AS caption_title_3, c0_.caption AS caption_4, c0_.url AS url_5, c0_.is_published AS is_published_6, c0_.modified AS modified_7, c0_.created AS created_8, c0_.order_by AS order_by_9, c0_.page AS page_10, c0_.brand AS brand_11, c0_.link AS link_12, c0_.display_rule AS display_rule_13, c0_.is_video AS is_video_14 FROM carousel c0_ WHERE c0_.brand = 'Kyron Labs' AND c0_.is_published = 1 AND c0_.display_rule IN ('Not Logged In', 'Both', '') ORDER BY c0_.order_by ASC;

SELECT
  d.*,
  dt.type
FROM
  discounts d
  JOIN discount_types dt ON d.discount_type_id = dt.id
WHERE
  (
    JSON_CONTAINS(d.products, '["72"]')
    OR JSON_CONTAINS(d.products, '["all"]')
    OR JSON_CONTAINS(d.brands, '["7"]')
    OR JSON_CONTAINS(d.brands, '["all"]')
  )
  AND (
    JSON_CONTAINS(d.contacts, '["0"]')
    OR JSON_CONTAINS(d.contacts, '["all"]')
  )
  AND d.start_date <= '2026-06-26'
  AND d.end_date >= '2026-06-26'
  AND (
    d.discount_type_id = 1
    OR d.discount_type_id = 3
    OR d.discount_type_id = 4
  )
  AND d.status = 1
LIMIT
  1

SELECT d.*, dt.type FROM 
                discounts d
                JOIN discount_types dt ON d.discount_type_id = dt.id
             WHERE (
                 JSON_CONTAINS(d.products, '["72"]') OR JSON_CONTAINS(d.products, '["all"]')
             OR 
                 JSON_CONTAINS(d.brands, '["7"]') OR JSON_CONTAINS(d.brands, '["all"]')
             )
            AND
                 (
                     JSON_CONTAINS(d.contacts, '["0"]') OR JSON_CONTAINS(d.contacts, '["all"]')
                 )
            AND
                 d.start_date <= '2026-06-26' 
           AND 
                 d.end_date >= '2026-06-26'
            AND
                 (d.discount_type_id = 1 OR d.discount_type_id = 3 OR d.discount_type_id = 4)
             AND d.status = 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.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 = 'Search Results' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3,
  t0.modified AS modified_4,
  t0.created AS created_5,
  t0.api_id AS api_id_6
FROM
  api_details t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.modified AS modified_4, t0.created AS created_5, t0.api_id AS api_id_6 FROM api_details t0;