Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.version AS version_4,
  t0.name AS name_5,
  t0.content AS content_6,
  t0.slug AS slug_7,
  t0.path AS path_8,
  t0.enable_group_restrictions AS enable_group_restrictions_9,
  t0.enable_role_restrictions AS enable_role_restrictions_10,
  t0.status AS status_11,
  t0.primary_image AS primary_image_12,
  t0.seo_page_title AS seo_page_title_13,
  t0.seo_description AS seo_description_14,
  t0.seo_keywords AS seo_keywords_15,
  t0.display_order AS display_order_16,
  t0.parent_id AS parent_id_17,
  t0.language_id AS language_id_18
FROM
  content_pages_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.label AS label_5,
  t0.url AS url_6,
  t0.auto_update AS auto_update_7,
  t0.open_new_window AS open_new_window_8,
  t0.display_order AS display_order_9,
  t0.type AS type_10,
  t0.menu_id AS menu_id_11,
  t0.page_id AS page_id_12,
  t0.parent_id AS parent_id_13
FROM
  content_menus_menuitem t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = 3 ORDER BY t0.display_order ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.path AS path_6,
  t0.enabled AS enabled_7,
  t0.description AS description_8,
  t0.seo_title AS seo_title_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.seo_description AS seo_description_11,
  t0.primary_image_id AS primary_image_id_12
FROM
  commerce_products_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.slug AS slug_5, t0.path AS path_6, t0.enabled AS enabled_7, t0.description AS description_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.primary_image_id AS primary_image_id_12 FROM commerce_products_product t0 WHERE t0.id = 581;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.label AS label_5,
  t0.url AS url_6,
  t0.auto_update AS auto_update_7,
  t0.open_new_window AS open_new_window_8,
  t0.display_order AS display_order_9,
  t0.type AS type_10,
  t0.menu_id AS menu_id_11,
  t0.page_id AS page_id_12,
  t0.parent_id AS parent_id_13
FROM
  content_menus_menuitem t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.menu_id = 3 ORDER BY t0.display_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.modified AS modified_3,
  c0_.identifier AS identifier_4,
  c0_.name AS name_5,
  c0_.is_locked AS is_locked_6,
  c0_.disable_child_items AS disable_child_items_7,
  c0_.language_id AS language_id_8
FROM
  content_menus_menu c0_
WHERE
  c0_.identifier = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7, c0_.language_id AS language_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = 'primary' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.name AS name_3,
  c0_.slug AS slug_4,
  c0_.path AS path_5,
  c0_.price AS price_6,
  c0_.weight AS weight_7,
  c0_.stock AS stock_8,
  c0_.tax_inclusive AS tax_inclusive_9,
  c0_.quantity_type_other AS quantity_type_other_10,
  c0_.product_id AS product_id_11,
  c0_.quantitytype_id AS quantitytype_id_12,
  c0_.taxrate_id AS taxrate_id_13
FROM
  commerce_products_variant c0_
  INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id
WHERE
  c1_.enabled = ?
  AND EXISTS (
    SELECT
      1
    FROM
      product_category p2_
    WHERE
      p2_.product_id = c1_.id
      AND p2_.category_id IN (?)
  )
  AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.slug AS slug_4, c0_.path AS path_5, c0_.price AS price_6, c0_.weight AS weight_7, c0_.stock AS stock_8, c0_.tax_inclusive AS tax_inclusive_9, c0_.quantity_type_other AS quantity_type_other_10, c0_.product_id AS product_id_11, c0_.quantitytype_id AS quantitytype_id_12, c0_.taxrate_id AS taxrate_id_13 FROM commerce_products_variant c0_ INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id WHERE c1_.enabled = 1 AND EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (275)) AND c0_.id IN (1125, 1127, 1129, 1131, 1124, 1126, 1128, 1130) ORDER BY c0_.name ASC;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  commerce_products_variant c0_
  INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id
WHERE
  c1_.enabled = ?
  AND EXISTS (
    SELECT
      1
    FROM
      product_category p2_
    WHERE
      p2_.product_id = c1_.id
      AND p2_.category_id IN (?)
  )

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM commerce_products_variant c0_ INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id WHERE c1_.enabled = 1 AND EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (275));

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1
FROM
  commerce_products_variant c0_
  INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id
WHERE
  c1_.enabled = ?
  AND EXISTS (
    SELECT
      1
    FROM
      product_category p2_
    WHERE
      p2_.product_id = c1_.id
      AND p2_.category_id IN (?)
  )
ORDER BY
  c0_.name ASC
LIMIT
  50

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1 FROM commerce_products_variant c0_ INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id WHERE c1_.enabled = 1 AND EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (275)) ORDER BY c0_.name ASC LIMIT 50;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.`key` AS key_4,
  t0.value AS value_5
FROM
  system_config t0

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.`key` AS key_4, t0.value AS value_5 FROM system_config t0;

SELECT
  l0_.id AS id_0,
  l0_.uuid AS uuid_1,
  l0_.created AS created_2,
  l0_.modified AS modified_3,
  l0_.locale AS locale_4,
  l0_.name AS name_5,
  l0_.icon AS icon_6,
  l0_.is_locked AS is_locked_7
FROM
  languages_language l0_

SELECT l0_.id AS id_0, l0_.uuid AS uuid_1, l0_.created AS created_2, l0_.modified AS modified_3, l0_.locale AS locale_4, l0_.name AS name_5, l0_.icon AS icon_6, l0_.is_locked AS is_locked_7 FROM languages_language l0_;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.name AS name_3,
  c0_.description AS description_4,
  c0_.slug AS slug_5,
  c0_.path AS path_6,
  c0_.image AS image_7,
  c0_.seo_title AS seo_title_8,
  c0_.seo_keywords AS seo_keywords_9,
  c0_.seo_description AS seo_description_10,
  c0_.parent_id AS parent_id_11
FROM
  commerce_categories_category c0_
WHERE
  c0_.parent_id IS NULL

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.description AS description_4, c0_.slug AS slug_5, c0_.path AS path_6, c0_.image AS image_7, c0_.seo_title AS seo_title_8, c0_.seo_keywords AS seo_keywords_9, c0_.seo_description AS seo_description_10, c0_.parent_id AS parent_id_11 FROM commerce_categories_category c0_ WHERE c0_.parent_id IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.name AS name_3,
  c0_.description AS description_4,
  c0_.slug AS slug_5,
  c0_.path AS path_6,
  c0_.image AS image_7,
  c0_.seo_title AS seo_title_8,
  c0_.seo_keywords AS seo_keywords_9,
  c0_.seo_description AS seo_description_10,
  c0_.parent_id AS parent_id_11
FROM
  commerce_categories_category c0_
WHERE
  c0_.path = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.description AS description_4, c0_.slug AS slug_5, c0_.path AS path_6, c0_.image AS image_7, c0_.seo_title AS seo_title_8, c0_.seo_keywords AS seo_keywords_9, c0_.seo_description AS seo_description_10, c0_.parent_id AS parent_id_11 FROM commerce_categories_category c0_ WHERE c0_.path = 'sugar-free/sugar-free-hard-candy' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.path AS path_7,
  t0.image AS image_8,
  t0.seo_title AS seo_title_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.seo_description AS seo_description_11,
  t0.parent_id AS parent_id_12
FROM
  commerce_categories_category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.image AS image_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.parent_id AS parent_id_12 FROM commerce_categories_category t0 WHERE t0.parent_id = 275;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.text AS text_3,
  c0_.url AS url_4,
  c0_.ignore_before AS ignore_before_5,
  c0_.ignore_after AS ignore_after_6
FROM
  content_autolinks_autolink c0_

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.text AS text_3, c0_.url AS url_4, c0_.ignore_before AS ignore_before_5, c0_.ignore_after AS ignore_after_6 FROM content_autolinks_autolink c0_;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.path AS path_7,
  t0.image AS image_8,
  t0.seo_title AS seo_title_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.seo_description AS seo_description_11,
  t0.parent_id AS parent_id_12
FROM
  commerce_categories_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.image AS image_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.parent_id AS parent_id_12 FROM commerce_categories_category t0 WHERE t0.id = 272;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.rate AS rate_5
FROM
  commerce_tax_rate t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.rate AS rate_5 FROM commerce_tax_rate t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4
FROM
  commerce_products_quantitytype t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4 FROM commerce_products_quantitytype t0 WHERE t0.id = 55;