Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.price_ht AS price_ht_2,
  p0_.stock AS stock_3,
  p0_.desctription AS desctription_4,
  p0_.picture AS picture_5,
  p0_.linkspictures AS linkspictures_6,
  p0_.statdispo AS statdispo_7,
  p0_.stateval AS stateval_8,
  p0_.statetype AS statetype_9,
  p0_.points AS points_10,
  p0_.search_count AS search_count_11,
  p0_.key_word AS key_word_12,
  p0_.modules AS modules_13,
  p0_.enabled AS enabled_14,
  p0_.show_price AS show_price_15,
  COUNT(d1_.id) AS sclr_16,
  p0_.user_add_id AS user_add_id_17,
  p0_.fkcategorie_id AS fkcategorie_id_18,
  p0_.fksous_categorie_id AS fksous_categorie_id_19,
  p0_.fkdevise_id AS fkdevise_id_20,
  p0_.shop_id AS shop_id_21
FROM
  product p0_
  INNER JOIN details_orders d1_ ON (d1_.idproduct_id = p0_.id)
WHERE
  p0_.enabled = 1
  AND p0_.statdispo > 0
GROUP BY
  p0_.id
ORDER BY
  sclr_16 DESC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.stock AS stock_3, p0_.desctription AS desctription_4, p0_.picture AS picture_5, p0_.linkspictures AS linkspictures_6, p0_.statdispo AS statdispo_7, p0_.stateval AS stateval_8, p0_.statetype AS statetype_9, p0_.points AS points_10, p0_.search_count AS search_count_11, p0_.key_word AS key_word_12, p0_.modules AS modules_13, p0_.enabled AS enabled_14, p0_.show_price AS show_price_15, COUNT(d1_.id) AS sclr_16, p0_.user_add_id AS user_add_id_17, p0_.fkcategorie_id AS fkcategorie_id_18, p0_.fksous_categorie_id AS fksous_categorie_id_19, p0_.fkdevise_id AS fkdevise_id_20, p0_.shop_id AS shop_id_21 FROM product p0_ INNER JOIN details_orders d1_ ON (d1_.idproduct_id = p0_.id) WHERE p0_.enabled = 1 AND p0_.statdispo > 0 GROUP BY p0_.id ORDER BY sclr_16 DESC LIMIT 12;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.price_ht AS price_ht_2,
  p0_.stock AS stock_3,
  p0_.desctription AS desctription_4,
  p0_.picture AS picture_5,
  p0_.linkspictures AS linkspictures_6,
  p0_.statdispo AS statdispo_7,
  p0_.stateval AS stateval_8,
  p0_.statetype AS statetype_9,
  p0_.points AS points_10,
  p0_.search_count AS search_count_11,
  p0_.key_word AS key_word_12,
  p0_.modules AS modules_13,
  p0_.enabled AS enabled_14,
  p0_.show_price AS show_price_15,
  p0_.user_add_id AS user_add_id_16,
  p0_.fkcategorie_id AS fkcategorie_id_17,
  p0_.fksous_categorie_id AS fksous_categorie_id_18,
  p0_.fkdevise_id AS fkdevise_id_19,
  p0_.shop_id AS shop_id_20
FROM
  product p0_
WHERE
  p0_.enabled = 1
  AND p0_.statdispo > 0
ORDER BY
  p0_.id DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.stock AS stock_3, p0_.desctription AS desctription_4, p0_.picture AS picture_5, p0_.linkspictures AS linkspictures_6, p0_.statdispo AS statdispo_7, p0_.stateval AS stateval_8, p0_.statetype AS statetype_9, p0_.points AS points_10, p0_.search_count AS search_count_11, p0_.key_word AS key_word_12, p0_.modules AS modules_13, p0_.enabled AS enabled_14, p0_.show_price AS show_price_15, p0_.user_add_id AS user_add_id_16, p0_.fkcategorie_id AS fkcategorie_id_17, p0_.fksous_categorie_id AS fksous_categorie_id_18, p0_.fkdevise_id AS fkdevise_id_19, p0_.shop_id AS shop_id_20 FROM product p0_ WHERE p0_.enabled = 1 AND p0_.statdispo > 0 ORDER BY p0_.id DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.price_dealer AS price_dealer_2,
  t0.nbr_dealer_prod AS nbr_dealer_prod_3,
  t0.price_customer AS price_customer_4,
  t0.supplier_price AS supplier_price_5,
  t0.price_bulk_customer AS price_bulk_customer_6,
  t0.promo_price_dealer AS promo_price_dealer_7,
  t0.promo_price_customer AS promo_price_customer_8,
  t0.promo_price_bulk_customer AS promo_price_bulk_customer_9,
  t0.promo_start_at AS promo_start_at_10,
  t0.promo_end_at AS promo_end_at_11,
  t0.is_promo_active AS is_promo_active_12,
  t0.nbr_bulk_prod AS nbr_bulk_prod_13,
  t0.taxe_product AS taxe_product_14,
  t0.product_id AS product_id_15
FROM
  price_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = 109;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.included_users AS included_users_3,
  t0.extra_user_price AS extra_user_price_4,
  t0.product_id AS product_id_5,
  t0.subscription_type_id AS subscription_type_id_6
FROM
  product_subscription_price t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.included_users AS included_users_3, t0.extra_user_price AS extra_user_price_4, t0.product_id AS product_id_5, t0.subscription_type_id AS subscription_type_id_6 FROM product_subscription_price t0 WHERE t0.product_id = 109;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  devise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM devise t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  categori_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.price_dealer AS price_dealer_2,
  t0.nbr_dealer_prod AS nbr_dealer_prod_3,
  t0.price_customer AS price_customer_4,
  t0.supplier_price AS supplier_price_5,
  t0.price_bulk_customer AS price_bulk_customer_6,
  t0.promo_price_dealer AS promo_price_dealer_7,
  t0.promo_price_customer AS promo_price_customer_8,
  t0.promo_price_bulk_customer AS promo_price_bulk_customer_9,
  t0.promo_start_at AS promo_start_at_10,
  t0.promo_end_at AS promo_end_at_11,
  t0.is_promo_active AS is_promo_active_12,
  t0.nbr_bulk_prod AS nbr_bulk_prod_13,
  t0.taxe_product AS taxe_product_14,
  t0.product_id AS product_id_15
FROM
  price_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = 107;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  categori_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.price_dealer AS price_dealer_2,
  t0.nbr_dealer_prod AS nbr_dealer_prod_3,
  t0.price_customer AS price_customer_4,
  t0.supplier_price AS supplier_price_5,
  t0.price_bulk_customer AS price_bulk_customer_6,
  t0.promo_price_dealer AS promo_price_dealer_7,
  t0.promo_price_customer AS promo_price_customer_8,
  t0.promo_price_bulk_customer AS promo_price_bulk_customer_9,
  t0.promo_start_at AS promo_start_at_10,
  t0.promo_end_at AS promo_end_at_11,
  t0.is_promo_active AS is_promo_active_12,
  t0.nbr_bulk_prod AS nbr_bulk_prod_13,
  t0.taxe_product AS taxe_product_14,
  t0.product_id AS product_id_15
FROM
  price_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = 106;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  categori_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.price_dealer AS price_dealer_2,
  t0.nbr_dealer_prod AS nbr_dealer_prod_3,
  t0.price_customer AS price_customer_4,
  t0.supplier_price AS supplier_price_5,
  t0.price_bulk_customer AS price_bulk_customer_6,
  t0.promo_price_dealer AS promo_price_dealer_7,
  t0.promo_price_customer AS promo_price_customer_8,
  t0.promo_price_bulk_customer AS promo_price_bulk_customer_9,
  t0.promo_start_at AS promo_start_at_10,
  t0.promo_end_at AS promo_end_at_11,
  t0.is_promo_active AS is_promo_active_12,
  t0.nbr_bulk_prod AS nbr_bulk_prod_13,
  t0.taxe_product AS taxe_product_14,
  t0.product_id AS product_id_15
FROM
  price_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = 105;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  categori_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = 1;