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 = 'hygiene-entretien-produits-d-hygiene';

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 = 'Produits d\'Hygiène');

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

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 = 'Produits d\'Hygiène') ORDER BY p0_.id ASC LIMIT 24;

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 = 'Produits d\'Hygiène') AND p0_.id IN (1933, 6533, 29334, 29335, 54645, 59250, 59421, 59422, 59425, 59929, 64430, 64431, 64432, 64443, 64615, 64616, 70294, 70298, 70299, 70300, 70570, 70571, 70759, 77938) 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 = 1933;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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