Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.is_active AS is_active_3,
  p0_.location AS location_4,
  p0_.category_id AS category_id_5
FROM
  product_sliders p0_
WHERE
  p0_.location = ?
  AND p0_.is_active = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.is_active AS is_active_3, p0_.location AS location_4, p0_.category_id AS category_id_5 FROM product_sliders p0_ WHERE p0_.location = 'home' AND p0_.is_active = 1 ORDER BY p0_.id ASC;

SELECT
  r0_.id AS id_0,
  r0_.author_name AS author_name_1,
  r0_.rating AS rating_2,
  r0_.comment AS comment_3,
  r0_.pros AS pros_4,
  r0_.cons AS cons_5,
  r0_.status AS status_6,
  r0_.ip_address AS ip_address_7,
  r0_.created_at AS created_at_8,
  r0_.updated_at AS updated_at_9,
  r0_.product_id AS product_id_10,
  r0_.author_id AS author_id_11
FROM
  reviews r0_
WHERE
  r0_.status = ?
ORDER BY
  r0_.created_at DESC
LIMIT
  5

SELECT r0_.id AS id_0, r0_.author_name AS author_name_1, r0_.rating AS rating_2, r0_.comment AS comment_3, r0_.pros AS pros_4, r0_.cons AS cons_5, r0_.status AS status_6, r0_.ip_address AS ip_address_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.product_id AS product_id_10, r0_.author_id AS author_id_11 FROM reviews r0_ WHERE r0_.status = 1 ORDER BY r0_.created_at DESC LIMIT 5;

SELECT
  p0_.id AS id_0,
  p0_.url AS url_1,
  p0_.sort_order AS sort_order_2,
  p0_.type AS type_3,
  p0_.cover AS cover_4,
  p0_.show_on_home AS show_on_home_5,
  p0_.home_page_sort_order AS home_page_sort_order_6,
  p0_.product_id AS product_id_7
FROM
  product_video p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p0_.show_on_home = ?
ORDER BY
  p0_.home_page_sort_order ASC

SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.sort_order AS sort_order_2, p0_.type AS type_3, p0_.cover AS cover_4, p0_.show_on_home AS show_on_home_5, p0_.home_page_sort_order AS home_page_sort_order_6, p0_.product_id AS product_id_7 FROM product_video p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p0_.show_on_home = 1 ORDER BY p0_.home_page_sort_order ASC;

SELECT
  h0_.id AS id_0,
  h0_.image AS image_1,
  h0_.image_mobile AS image_mobile_2,
  h0_.title AS title_3,
  h0_.description AS description_4,
  h0_.link_url AS link_url_5,
  h0_.link_target AS link_target_6,
  h0_.sort_order AS sort_order_7,
  h0_.is_active AS is_active_8,
  h0_.created_at AS created_at_9,
  h0_.updated_at AS updated_at_10
FROM
  home_slider h0_
WHERE
  h0_.is_active = ?
ORDER BY
  h0_.sort_order ASC

SELECT h0_.id AS id_0, h0_.image AS image_1, h0_.image_mobile AS image_mobile_2, h0_.title AS title_3, h0_.description AS description_4, h0_.link_url AS link_url_5, h0_.link_target AS link_target_6, h0_.sort_order AS sort_order_7, h0_.is_active AS is_active_8, h0_.created_at AS created_at_9, h0_.updated_at AS updated_at_10 FROM home_slider h0_ WHERE h0_.is_active = 1 ORDER BY h0_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.content AS content_4
FROM
  home_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.content AS content_4 FROM home_page t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.expires_at AS expires_at_5,
  t0.user_id AS user_id_6
FROM
  wishlist t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.expires_at AS expires_at_5, t0.user_id AS user_id_6 FROM wishlist t0 WHERE t0.token = 'cb833b2f93dbc3ace6c8548c6c282de6' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.user_id AS user_id_1,
  c0_.token AS token_2,
  c0_.currency AS currency_3,
  c0_.pricing_policy AS pricing_policy_4,
  c0_.subtotal AS subtotal_5,
  c0_.discount_total AS discount_total_6,
  c0_.total AS total_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.expires_at AS expires_at_10,
  c0_.version AS version_11,
  c0_.shipping_method AS shipping_method_12,
  c0_.shipping_cost AS shipping_cost_13,
  c0_.ship_to_city AS ship_to_city_14,
  c0_.shipping_data AS shipping_data_15
FROM
  cart c0_
  LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id
  LEFT JOIN product p2_ ON c1_.product_id = p2_.id
  LEFT JOIN product_image p3_ ON p2_.id = p3_.product_id
  LEFT JOIN cart_item_option_assignment c5_ ON c1_.id = c5_.cart_item_id
  LEFT JOIN product_option_value_assignment p4_ ON p4_.id = c5_.product_option_value_assignment_id
  LEFT JOIN `option` o6_ ON p4_.option_id = o6_.id
  LEFT JOIN option_value o7_ ON p4_.value_id = o7_.id
WHERE
  c0_.token = ?
  AND (
    c0_.expires_at IS NULL
    OR c0_.expires_at > CURRENT_TIMESTAMP
  )
LIMIT
  1

SELECT c0_.id AS id_0, c0_.user_id AS user_id_1, c0_.token AS token_2, c0_.currency AS currency_3, c0_.pricing_policy AS pricing_policy_4, c0_.subtotal AS subtotal_5, c0_.discount_total AS discount_total_6, c0_.total AS total_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.expires_at AS expires_at_10, c0_.version AS version_11, c0_.shipping_method AS shipping_method_12, c0_.shipping_cost AS shipping_cost_13, c0_.ship_to_city AS ship_to_city_14, c0_.shipping_data AS shipping_data_15 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product p2_ ON c1_.product_id = p2_.id LEFT JOIN product_image p3_ ON p2_.id = p3_.product_id LEFT JOIN cart_item_option_assignment c5_ ON c1_.id = c5_.cart_item_id LEFT JOIN product_option_value_assignment p4_ ON p4_.id = c5_.product_option_value_assignment_id LEFT JOIN `option` o6_ ON p4_.option_id = o6_.id LEFT JOIN option_value o7_ ON p4_.value_id = o7_.id WHERE c0_.token = '6fe111ff-493f-463d-9517-18229f276758' AND (c0_.expires_at IS NULL OR c0_.expires_at > CURRENT_TIMESTAMP) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.product_name AS product_name_2,
  t0.unit_price AS unit_price_3,
  t0.qty AS qty_4,
  t0.row_total AS row_total_5,
  t0.options_price_modifier AS options_price_modifier_6,
  t0.effective_unit_price AS effective_unit_price_7,
  t0.options_hash AS options_hash_8,
  t0.selected_options_data AS selected_options_data_9,
  t0.options_snapshot AS options_snapshot_10,
  t0.priced_at AS priced_at_11,
  t0.version AS version_12,
  t0.cart_id AS cart_id_13,
  t0.product_id AS product_id_14
FROM
  cart_item t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.unit_price AS unit_price_3, t0.qty AS qty_4, t0.row_total AS row_total_5, t0.options_price_modifier AS options_price_modifier_6, t0.effective_unit_price AS effective_unit_price_7, t0.options_hash AS options_hash_8, t0.selected_options_data AS selected_options_data_9, t0.options_snapshot AS options_snapshot_10, t0.priced_at AS priced_at_11, t0.version AS version_12, t0.cart_id AS cart_id_13, t0.product_id AS product_id_14 FROM cart_item t0 WHERE t0.cart_id = 0x019AC8CAD851B24D0C212C4C8ADCED2C;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.visibility AS visibility_3,
  c0_.parent_category_id AS parent_category_id_4,
  c0_.meta_title AS meta_title_5,
  c0_.meta_description AS meta_description_6,
  c0_.meta_keywords AS meta_keywords_7,
  c0_.sort_order AS sort_order_8,
  c0_.meta_h1 AS meta_h1_9,
  c0_.description AS description_10,
  c0_.navbar_visibility AS navbar_visibility_11,
  c0_.footer_visibility AS footer_visibility_12
FROM
  category c0_
WHERE
  c0_.navbar_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.visibility AS visibility_3, c0_.parent_category_id AS parent_category_id_4, c0_.meta_title AS meta_title_5, c0_.meta_description AS meta_description_6, c0_.meta_keywords AS meta_keywords_7, c0_.sort_order AS sort_order_8, c0_.meta_h1 AS meta_h1_9, c0_.description AS description_10, c0_.navbar_visibility AS navbar_visibility_11, c0_.footer_visibility AS footer_visibility_12 FROM category c0_ WHERE c0_.navbar_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.visibility AS visibility_3,
  c0_.parent_category_id AS parent_category_id_4,
  c0_.meta_title AS meta_title_5,
  c0_.meta_description AS meta_description_6,
  c0_.meta_keywords AS meta_keywords_7,
  c0_.sort_order AS sort_order_8,
  c0_.meta_h1 AS meta_h1_9,
  c0_.description AS description_10,
  c0_.navbar_visibility AS navbar_visibility_11,
  c0_.footer_visibility AS footer_visibility_12
FROM
  category c0_
WHERE
  c0_.navbar_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.visibility AS visibility_3, c0_.parent_category_id AS parent_category_id_4, c0_.meta_title AS meta_title_5, c0_.meta_description AS meta_description_6, c0_.meta_keywords AS meta_keywords_7, c0_.sort_order AS sort_order_8, c0_.meta_h1 AS meta_h1_9, c0_.description AS description_10, c0_.navbar_visibility AS navbar_visibility_11, c0_.footer_visibility AS footer_visibility_12 FROM category c0_ WHERE c0_.navbar_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.expires_at AS expires_at_5,
  t0.user_id AS user_id_6
FROM
  wishlist t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.expires_at AS expires_at_5, t0.user_id AS user_id_6 FROM wishlist t0 WHERE t0.token = 'cb833b2f93dbc3ace6c8548c6c282de6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.expires_at AS expires_at_5,
  t0.user_id AS user_id_6
FROM
  wishlist t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.expires_at AS expires_at_5, t0.user_id AS user_id_6 FROM wishlist t0 WHERE t0.token = 'cb833b2f93dbc3ace6c8548c6c282de6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.expires_at AS expires_at_5,
  t0.user_id AS user_id_6
FROM
  wishlist t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.expires_at AS expires_at_5, t0.user_id AS user_id_6 FROM wishlist t0 WHERE t0.token = 'cb833b2f93dbc3ace6c8548c6c282de6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.expires_at AS expires_at_5,
  t0.user_id AS user_id_6
FROM
  wishlist t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.expires_at AS expires_at_5, t0.user_id AS user_id_6 FROM wishlist t0 WHERE t0.token = 'cb833b2f93dbc3ace6c8548c6c282de6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.expires_at AS expires_at_5,
  t0.user_id AS user_id_6
FROM
  wishlist t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.expires_at AS expires_at_5, t0.user_id AS user_id_6 FROM wishlist t0 WHERE t0.token = 'cb833b2f93dbc3ace6c8548c6c282de6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sort_order AS sort_order_2,
  t0.slider_id AS slider_id_3,
  t0.product_id AS product_id_4
FROM
  product_slider_items t0
WHERE
  t0.slider_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.slider_id AS slider_id_3, t0.product_id AS product_id_4 FROM product_slider_items t0 WHERE t0.slider_id = 1 ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.sort_order AS sort_order_4,
  t0.effective_price AS effective_price_5,
  t0.status AS status_6,
  t0.type AS type_7,
  t0.quantity AS quantity_8,
  t0.options_json AS options_json_9,
  t0.attribute_json AS attribute_json_10,
  t0.code AS code_11,
  t0.description AS description_12,
  t0.similar_group_id AS similar_group_id_13,
  t0.price AS price_14,
  t0.sale_price AS sale_price_15,
  t0.currency AS currency_16,
  t0.date_added AS date_added_17,
  t0.date_edited AS date_edited_18,
  t0.manufacturer_id AS manufacturer_id_19,
  t0.series_id AS series_id_20,
  t21.meta_title AS meta_title_22,
  t21.meta_description AS meta_description_23,
  t21.meta_keywords AS meta_keywords_24,
  t21.h1 AS h1_25,
  t21.product_id AS product_id_26
FROM
  product t0
  LEFT JOIN product_seo t21 ON t21.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.sort_order AS sort_order_4, t0.effective_price AS effective_price_5, t0.status AS status_6, t0.type AS type_7, t0.quantity AS quantity_8, t0.options_json AS options_json_9, t0.attribute_json AS attribute_json_10, t0.code AS code_11, t0.description AS description_12, t0.similar_group_id AS similar_group_id_13, t0.price AS price_14, t0.sale_price AS sale_price_15, t0.currency AS currency_16, t0.date_added AS date_added_17, t0.date_edited AS date_edited_18, t0.manufacturer_id AS manufacturer_id_19, t0.series_id AS series_id_20, t21.meta_title AS meta_title_22, t21.meta_description AS meta_description_23, t21.meta_keywords AS meta_keywords_24, t21.h1 AS h1_25, t21.product_id AS product_id_26 FROM product t0 LEFT JOIN product_seo t21 ON t21.product_id = t0.id WHERE t0.id = 159;

SELECT
  COUNT(*)
FROM
  product_option_value_assignment t0
WHERE
  t0.product_id = ?

SELECT COUNT(*) FROM product_option_value_assignment t0 WHERE t0.product_id = 159;