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 = 'decoration-lampes';

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN characteristic c1_ ON (p0_.id = c1_.product_id)
  INNER JOIN characteristic_label c2_ ON (
    c1_.characteristic_label_id = c2_.id
  )
WHERE
  (
    (
      c2_.id = 5
      OR c2_.id = 6
    )
  )
  AND (c1_.value = ?)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN characteristic c1_ ON (p0_.id = c1_.product_id) INNER JOIN characteristic_label c2_ ON (c1_.characteristic_label_id = c2_.id) WHERE ((c2_.id = 5 OR c2_.id = 6)) AND (c1_.value = 'Lampes');

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  product p0_
  INNER JOIN characteristic c1_ ON (p0_.id = c1_.product_id)
  INNER JOIN characteristic_label c2_ ON (
    c1_.characteristic_label_id = c2_.id
  )
WHERE
  (
    (
      c2_.id = 5
      OR c2_.id = 6
    )
  )
  AND (c1_.value = ?)
ORDER BY
  p0_.id ASC
LIMIT
  24 OFFSET 72

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ INNER JOIN characteristic c1_ ON (p0_.id = c1_.product_id) INNER JOIN characteristic_label c2_ ON (c1_.characteristic_label_id = c2_.id) WHERE ((c2_.id = 5 OR c2_.id = 6)) AND (c1_.value = 'Lampes') ORDER BY p0_.id ASC LIMIT 24 OFFSET 72;

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 characteristic c1_ ON (p0_.id = c1_.product_id)
  INNER JOIN characteristic_label c2_ ON (
    c1_.characteristic_label_id = c2_.id
  )
WHERE
  (
    (
      c2_.id = 5
      OR c2_.id = 6
    )
  )
  AND (c1_.value = ?)
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.id ASC

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 characteristic c1_ ON (p0_.id = c1_.product_id) INNER JOIN characteristic_label c2_ ON (c1_.characteristic_label_id = c2_.id) WHERE ((c2_.id = 5 OR c2_.id = 6)) AND (c1_.value = 'Lampes') AND p0_.id IN (200166, 201140, 201141, 201142, 201147, 201148, 201149, 203619, 211130, 216093, 216529, 216530, 216531, 216532, 216533, 216534, 217352, 217353, 217354, 217359, 217360, 217662, 217739, 217742) ORDER BY p0_.id ASC;

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.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 = ?

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 = 200166;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 120;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 110;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 1130;

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 = ?

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 = 201140;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 170;

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 = ?

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 = 201141;

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 = ?

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 = 201142;

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 = ?

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 = 201147;

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 = ?

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 = 201148;

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 = ?

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 = 201149;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 720;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 100;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 540;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 10030;

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 = ?

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 = 203619;

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 = ?

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 = 211130;

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 = ?

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 = 216093;

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 = ?

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 = 216529;

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 = ?

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 = 216530;

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 = ?

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 = 216531;

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 = ?

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 = 216532;

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 = ?

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 = 216533;

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 = ?

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 = 216534;

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 = ?

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 = 217352;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 10070;

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 = ?

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 = 217353;

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 = ?

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 = 217354;

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 = ?

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 = 217359;

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 = ?

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 = 217360;

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 = ?

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 = 217662;

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 = ?

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 = 217739;

SELECT
  t0.id AS id_1,
  t0.list_order AS list_order_2,
  t0.is_display_site AS is_display_site_3,
  t0.is_search_site AS is_search_site_4,
  t0.label AS label_5
FROM
  characteristic_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.is_display_site AS is_display_site_3, t0.is_search_site AS is_search_site_4, t0.label AS label_5 FROM characteristic_label t0 WHERE t0.id = 10;

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 = ?

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 = 217742;

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 = 200166 LIMIT 1;