Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.displayed_order AS displayed_order_2,
  c0_.is_in_footer AS is_in_footer_3,
  c0_.slug AS slug_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.displayed_order AS displayed_order_7,
  c1_.is_in_footer AS is_in_footer_8,
  c1_.slug AS slug_9,
  c2_.id AS id_10,
  c2_.name AS name_11,
  c2_.displayed_order AS displayed_order_12,
  c2_.is_in_footer AS is_in_footer_13,
  c2_.slug AS slug_14,
  c0_.category_parent_id AS category_parent_id_15,
  c1_.category_parent_id AS category_parent_id_16,
  c2_.category_parent_id AS category_parent_id_17
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id
  LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id
WHERE
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.slug = 'cartouches-toners-hp';

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
  INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id
WHERE
  c1_.id IN (?)
  AND p0_.is_active = 1
  AND p0_.is_btoc = 1

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id WHERE c1_.id IN (21) AND p0_.is_active = 1 AND p0_.is_btoc = 1;

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
  INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id
WHERE
  c1_.id IN (?)
  AND p0_.is_active = 1
  AND p0_.is_btoc = 1
LIMIT
  30 OFFSET 600

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id WHERE c1_.id IN (21) AND p0_.is_active = 1 AND p0_.is_btoc = 1 LIMIT 30 OFFSET 600;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.manufacturer AS manufacturer_2,
  p0_.short_label AS short_label_3,
  p0_.long_label AS long_label_4,
  p0_.weight AS weight_5,
  p0_.sold_by AS sold_by_6,
  p0_.ppht AS ppht_7,
  p0_.ppttc AS ppttc_8,
  p0_.paht AS paht_9,
  p0_.pattc AS pattc_10,
  p0_.legal_discount_library AS legal_discount_library_11,
  p0_.fidelity_bonus AS fidelity_bonus_12,
  p0_.brand AS brand_13,
  p0_.time_limit AS time_limit_14,
  p0_.coef AS coef_15,
  p0_.is_discountable AS is_discountable_16,
  p0_.is_btob AS is_btob_17,
  p0_.is_btoc AS is_btoc_18,
  p0_.is_customizable AS is_customizable_19,
  p0_.is_library AS is_library_20,
  p0_.is_nathan AS is_nathan_21,
  p0_.is_green AS is_green_22,
  p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23,
  p0_.is_active AS is_active_24,
  p0_.slug AS slug_25
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
  INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id
WHERE
  c1_.id IN (?)
  AND p0_.is_active = 1
  AND p0_.is_btoc = 1
  AND p0_.id IN (?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id WHERE c1_.id IN (21) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.id IN (523219, 523220, 523221, 523222);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.displayed_order AS displayed_order_2,
  c0_.is_in_footer AS is_in_footer_3,
  c0_.slug AS slug_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.displayed_order AS displayed_order_7,
  c1_.is_in_footer AS is_in_footer_8,
  c1_.slug AS slug_9,
  c2_.id AS id_10,
  c2_.name AS name_11,
  c2_.displayed_order AS displayed_order_12,
  c2_.is_in_footer AS is_in_footer_13,
  c2_.slug AS slug_14,
  c0_.category_parent_id AS category_parent_id_15,
  c1_.category_parent_id AS category_parent_id_16,
  c2_.category_parent_id AS category_parent_id_17
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id
  LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id
WHERE
  c0_.category_parent_id IS NULL

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.category_parent_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.displayed_order AS displayed_order_3,
  t0.is_in_footer AS is_in_footer_4,
  t0.slug AS slug_5,
  t0.category_parent_id AS category_parent_id_6
FROM
  category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.value AS value_1,
  c1_.id AS id_2,
  c1_.list_order AS list_order_3,
  c1_.is_display_site AS is_display_site_4,
  c1_.is_search_site AS is_search_site_5,
  c1_.label AS label_6,
  c0_.product_id AS product_id_7,
  c0_.characteristic_label_id AS characteristic_label_id_8
FROM
  characteristic c0_
  INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id
WHERE
  c0_.product_id IN (?, ?, ?, ?)
  AND c1_.is_display_site = ?

SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id IN (523219, 523220, 523221, 523222) AND c1_.is_display_site = 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_id AS product_id_3,
  t0.characteristic_label_id AS characteristic_label_id_4
FROM
  characteristic t0
WHERE
  t0.product_id = ?
  AND t0.characteristic_label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = 523219 AND t0.characteristic_label_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value1 AS value1_3,
  t0.value2 AS value2_4,
  t0.value3 AS value3_5
FROM
  parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = 'TarifDefaut' LIMIT 1;

SELECT
  t0.id AS id_1
FROM
  price t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = 'CAISSE2011' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.price_id AS price_id_4,
  t0.product_id AS product_id_5
FROM
  product_price t0
WHERE
  t0.price_id = ?
  AND t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = 'CAISSE2011' AND t0.product_id = 523219 LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.quantity AS quantity_1,
  d0_.price_ht AS price_ht_2,
  d0_.price_ttc AS price_ttc_3,
  d0_.product_id AS product_id_4,
  d0_.product_price_id AS product_price_id_5,
  d0_.promotion_id AS promotion_id_6,
  d0_.market_id AS market_id_7
FROM
  decreasing_price d0_
WHERE
  d0_.product_id = ?
  AND d0_.quantity <= ?
ORDER BY
  d0_.quantity DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = 523219 AND d0_.quantity <= 1 ORDER BY d0_.quantity DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.discount AS discount_4,
  t0.product_id AS product_id_5
FROM
  promotion t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = 523219;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_id AS product_id_3,
  t0.characteristic_label_id AS characteristic_label_id_4
FROM
  characteristic t0
WHERE
  t0.product_id = ?
  AND t0.characteristic_label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = 523220 AND t0.characteristic_label_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.price_id AS price_id_4,
  t0.product_id AS product_id_5
FROM
  product_price t0
WHERE
  t0.price_id = ?
  AND t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = 'CAISSE2011' AND t0.product_id = 523220 LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.quantity AS quantity_1,
  d0_.price_ht AS price_ht_2,
  d0_.price_ttc AS price_ttc_3,
  d0_.product_id AS product_id_4,
  d0_.product_price_id AS product_price_id_5,
  d0_.promotion_id AS promotion_id_6,
  d0_.market_id AS market_id_7
FROM
  decreasing_price d0_
WHERE
  d0_.product_id = ?
  AND d0_.quantity <= ?
ORDER BY
  d0_.quantity DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = 523220 AND d0_.quantity <= 1 ORDER BY d0_.quantity DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.discount AS discount_4,
  t0.product_id AS product_id_5
FROM
  promotion t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = 523220;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_id AS product_id_3,
  t0.characteristic_label_id AS characteristic_label_id_4
FROM
  characteristic t0
WHERE
  t0.product_id = ?
  AND t0.characteristic_label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = 523221 AND t0.characteristic_label_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.price_id AS price_id_4,
  t0.product_id AS product_id_5
FROM
  product_price t0
WHERE
  t0.price_id = ?
  AND t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = 'CAISSE2011' AND t0.product_id = 523221 LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.quantity AS quantity_1,
  d0_.price_ht AS price_ht_2,
  d0_.price_ttc AS price_ttc_3,
  d0_.product_id AS product_id_4,
  d0_.product_price_id AS product_price_id_5,
  d0_.promotion_id AS promotion_id_6,
  d0_.market_id AS market_id_7
FROM
  decreasing_price d0_
WHERE
  d0_.product_id = ?
  AND d0_.quantity <= ?
ORDER BY
  d0_.quantity DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = 523221 AND d0_.quantity <= 1 ORDER BY d0_.quantity DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.discount AS discount_4,
  t0.product_id AS product_id_5
FROM
  promotion t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = 523221;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_id AS product_id_3,
  t0.characteristic_label_id AS characteristic_label_id_4
FROM
  characteristic t0
WHERE
  t0.product_id = ?
  AND t0.characteristic_label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = 523222 AND t0.characteristic_label_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.price_id AS price_id_4,
  t0.product_id AS product_id_5
FROM
  product_price t0
WHERE
  t0.price_id = ?
  AND t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = 'CAISSE2011' AND t0.product_id = 523222 LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.quantity AS quantity_1,
  d0_.price_ht AS price_ht_2,
  d0_.price_ttc AS price_ttc_3,
  d0_.product_id AS product_id_4,
  d0_.product_price_id AS product_price_id_5,
  d0_.promotion_id AS promotion_id_6,
  d0_.market_id AS market_id_7
FROM
  decreasing_price d0_
WHERE
  d0_.product_id = ?
  AND d0_.quantity <= ?
ORDER BY
  d0_.quantity DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = 523222 AND d0_.quantity <= 1 ORDER BY d0_.quantity DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.discount AS discount_4,
  t0.product_id AS product_id_5
FROM
  promotion t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = 523222;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.displayed_order AS displayed_order_3,
  t0.is_in_footer AS is_in_footer_4,
  t0.slug AS slug_5,
  t0.category_parent_id AS category_parent_id_6
FROM
  category t0
WHERE
  t0.is_in_footer = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.is_in_footer = 1;