Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.parent_id AS parent_id_5
FROM
  blo_category t0
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.position ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.parent_id AS parent_id_5 FROM blo_category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC, t0.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.price AS price_4,
  b0_.promo_price AS promo_price_5,
  b0_.sku AS sku_6,
  b0_.stock_qty AS stock_qty_7,
  b0_.status AS status_8,
  b0_.product_type AS product_type_9,
  b0_.currency AS currency_10,
  b0_.created_at AS created_at_11,
  b0_.updated_at AS updated_at_12,
  b0_.shop_id AS shop_id_13,
  b0_.category_id AS category_id_14
FROM
  blo_product b0_
  INNER JOIN blo_shop b1_ ON b0_.shop_id = b1_.id
WHERE
  b0_.status = ?
  AND b1_.status = ?
ORDER BY
  b0_.created_at DESC
LIMIT
  8

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.price AS price_4, b0_.promo_price AS promo_price_5, b0_.sku AS sku_6, b0_.stock_qty AS stock_qty_7, b0_.status AS status_8, b0_.product_type AS product_type_9, b0_.currency AS currency_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12, b0_.shop_id AS shop_id_13, b0_.category_id AS category_id_14 FROM blo_product b0_ INNER JOIN blo_shop b1_ ON b0_.shop_id = b1_.id WHERE b0_.status = 'APPROVED' AND b1_.status = 'ACTIVE' ORDER BY b0_.created_at DESC LIMIT 8;

SELECT
  b0_.id AS id_0,
  b0_.position AS position_1,
  b0_.title_override AS title_override_2,
  b0_.subtitle_override AS subtitle_override_3,
  b0_.background_image AS background_image_4,
  b0_.active AS active_5,
  b1_.id AS id_6,
  b1_.title AS title_7,
  b1_.slug AS slug_8,
  b1_.description AS description_9,
  b1_.price AS price_10,
  b1_.promo_price AS promo_price_11,
  b1_.sku AS sku_12,
  b1_.stock_qty AS stock_qty_13,
  b1_.status AS status_14,
  b1_.product_type AS product_type_15,
  b1_.currency AS currency_16,
  b1_.created_at AS created_at_17,
  b1_.updated_at AS updated_at_18,
  b0_.product_id AS product_id_19,
  b1_.shop_id AS shop_id_20,
  b1_.category_id AS category_id_21
FROM
  blo_home_slider_item b0_
  LEFT JOIN blo_product b1_ ON b0_.product_id = b1_.id
WHERE
  b0_.active = ?
ORDER BY
  b0_.position ASC,
  b0_.id ASC

SELECT b0_.id AS id_0, b0_.position AS position_1, b0_.title_override AS title_override_2, b0_.subtitle_override AS subtitle_override_3, b0_.background_image AS background_image_4, b0_.active AS active_5, b1_.id AS id_6, b1_.title AS title_7, b1_.slug AS slug_8, b1_.description AS description_9, b1_.price AS price_10, b1_.promo_price AS promo_price_11, b1_.sku AS sku_12, b1_.stock_qty AS stock_qty_13, b1_.status AS status_14, b1_.product_type AS product_type_15, b1_.currency AS currency_16, b1_.created_at AS created_at_17, b1_.updated_at AS updated_at_18, b0_.product_id AS product_id_19, b1_.shop_id AS shop_id_20, b1_.category_id AS category_id_21 FROM blo_home_slider_item b0_ LEFT JOIN blo_product b1_ ON b0_.product_id = b1_.id WHERE b0_.active = 1 ORDER BY b0_.position ASC, b0_.id ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.price AS price_4,
  b0_.promo_price AS promo_price_5,
  b0_.sku AS sku_6,
  b0_.stock_qty AS stock_qty_7,
  b0_.status AS status_8,
  b0_.product_type AS product_type_9,
  b0_.currency AS currency_10,
  b0_.created_at AS created_at_11,
  b0_.updated_at AS updated_at_12,
  b0_.shop_id AS shop_id_13,
  b0_.category_id AS category_id_14
FROM
  blo_product b0_
  INNER JOIN blo_shop b1_ ON b0_.shop_id = b1_.id
WHERE
  b0_.status = ?
  AND b1_.status = ?
  AND b0_.promo_price IS NOT NULL
  AND b0_.promo_price > 0
ORDER BY
  b0_.updated_at DESC
LIMIT
  8

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.price AS price_4, b0_.promo_price AS promo_price_5, b0_.sku AS sku_6, b0_.stock_qty AS stock_qty_7, b0_.status AS status_8, b0_.product_type AS product_type_9, b0_.currency AS currency_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12, b0_.shop_id AS shop_id_13, b0_.category_id AS category_id_14 FROM blo_product b0_ INNER JOIN blo_shop b1_ ON b0_.shop_id = b1_.id WHERE b0_.status = 'APPROVED' AND b1_.status = 'ACTIVE' AND b0_.promo_price IS NOT NULL AND b0_.promo_price > 0 ORDER BY b0_.updated_at DESC LIMIT 8;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.cout AS cout_2,
  p0_.prix AS prix_3,
  p0_.statut AS statut_4,
  p0_.stock AS stock_5,
  p0_.image AS image_6,
  p0_.quantite_alerte AS quantite_alerte_7,
  p0_.date_expiration AS date_expiration_8,
  p0_.user_id AS user_id_9
FROM
  produit p0_
WHERE
  p0_.stock <= p0_.quantite_alerte
  AND p0_.statut = 0

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.cout AS cout_2, p0_.prix AS prix_3, p0_.statut AS statut_4, p0_.stock AS stock_5, p0_.image AS image_6, p0_.quantite_alerte AS quantite_alerte_7, p0_.date_expiration AS date_expiration_8, p0_.user_id AS user_id_9 FROM produit p0_ WHERE p0_.stock <= p0_.quantite_alerte AND p0_.statut = 0;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  blo_site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM blo_site_setting t0 WHERE t0.setting_key = 'site_logo' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.customer_id AS customer_id_5
FROM
  blo_cart t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.customer_id AS customer_id_5 FROM blo_cart t0 WHERE t0.session_id = 'bv93nc4aonqmg7m66111jvs52m' LIMIT 1;