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 = 'sport-exterieur-motricite-sportive';

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 = 'Motricité Sportive');

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 336

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 = 'Motricité Sportive') ORDER BY p0_.id ASC LIMIT 24 OFFSET 336;

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 = 'Motricité Sportive') AND p0_.id IN (299140, 299141, 299142, 299143, 299179, 299180, 299181, 299182, 299183, 299184, 299185, 299186, 299193, 299194, 299195, 299196, 317623, 317626, 317627, 317628, 317647, 318129, 318181, 318183) 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 = 299140;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.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 = 317627;

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

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

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.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 = 318129;

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

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

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;