Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.first AS first_3,
  t0.src AS src_4,
  t0.product_id AS product_id_5
FROM
  images t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.first ASC

SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = 23638 ORDER BY t0.first ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.created_at AS created_at_4,
  p0_.active AS active_5,
  p0_.code_ean AS code_ean_6,
  p0_.last_modification AS last_modification_7,
  p0_.old_price AS old_price_8,
  p0_.promo AS promo_9,
  p0_.top AS top_10,
  p0_.weight AS weight_11,
  p0_.reference AS reference_12,
  p0_.valid AS valid_13,
  p0_.tvarate AS tvarate_14,
  (
    CASE WHEN SUM(s1_.quantity) > 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_15,
  p0_.brand_id AS brand_id_16
FROM
  products p0_
  INNER JOIN stock s1_ ON (s1_.product_id = p0_.id)
  INNER JOIN categories_products c2_
WHERE
  c2_.categories_id IN (?)
  AND c2_.products_id = p0_.id
  AND p0_.active = 1
  AND p0_.valid = 1
GROUP BY
  p0_.reference
ORDER BY
  sclr_15 DESC,
  p0_.name ASC
LIMIT
  24

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.active AS active_5, p0_.code_ean AS code_ean_6, p0_.last_modification AS last_modification_7, p0_.old_price AS old_price_8, p0_.promo AS promo_9, p0_.top AS top_10, p0_.weight AS weight_11, p0_.reference AS reference_12, p0_.valid AS valid_13, p0_.tvarate AS tvarate_14, (CASE WHEN SUM(s1_.quantity) > 0 THEN 1 ELSE 0 END) AS sclr_15, p0_.brand_id AS brand_id_16 FROM products p0_ INNER JOIN stock s1_ ON (s1_.product_id = p0_.id) INNER JOIN categories_products c2_ WHERE c2_.categories_id IN ('138') AND c2_.products_id = p0_.id AND p0_.active = 1 AND p0_.valid = 1 GROUP BY p0_.reference ORDER BY sclr_15 DESC, p0_.name ASC LIMIT 24;

SELECT
  t0.id AS id_1,
  t0.price_distributor AS price_distributor_2,
  t0.price_suggested AS price_suggested_3,
  t0.date_update AS date_update_4,
  t0.price AS price_5,
  t0.selected AS selected_6,
  t0.tvarate AS tvarate_7,
  t0.product_id AS product_id_8,
  t0.distributor_id AS distributor_id_9
FROM
  prices t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.selected ASC

SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = 23638 ORDER BY t0.selected ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.link AS link_4,
  t0.position AS position_5,
  t0.title AS title_6,
  t0.icon AS icon_7,
  t0.thumbnail AS thumbnail_8,
  t0.image AS image_9,
  t0.margin AS margin_10,
  t0.description AS description_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0
  INNER JOIN categories_products ON t0.id = categories_products.categories_id
WHERE
  categories_products.products_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = 23638;

SELECT
  COUNT(DISTINCT p.reference) as nbProducts,
  min(pr.price) as priceMin,
  max(pr.price) as priceMax
FROM
  `products` as p
  INNER JOIN prices as pr
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (138)
  )
  AND p.id = pr.product_id
  AND pr.selected = 1
  AND p.active = 1
  AND p.valid = 1

SELECT COUNT(DISTINCT p.reference) as nbProducts, min(pr.price) as priceMin, max(pr.price) as priceMax 
                FROM `products` as p
                INNER JOIN prices as pr
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (138))
                AND p.id = pr.product_id
                AND pr.selected = 1
                AND p.active = 1
                AND p.valid = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.link AS link_4,
  t0.position AS position_5,
  t0.title AS title_6,
  t0.icon AS icon_7,
  t0.thumbnail AS thumbnail_8,
  t0.image AS image_9,
  t0.margin AS margin_10,
  t0.description AS description_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 WHERE t0.link = 'sextoys-homme-masturbateur-imitation-vagin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_rating AS date_rating_2,
  t0.recommanded AS recommanded_3,
  t0.facility_use AS facility_use_4,
  t0.quality_price AS quality_price_5,
  t0.design AS design_6,
  t0.material AS material_7,
  t0.pseudo AS pseudo_8,
  t0.email AS email_9,
  t0.avis AS avis_10,
  t0.utile_in AS utile_in_11,
  t0.utile_out AS utile_out_12,
  t0.active AS active_13,
  t0.rating AS rating_14,
  t0.validated AS validated_15,
  t0.product_id AS product_id_16
FROM
  product_rating t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = 23638;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.ref_distributor AS ref_distributor_3,
  t0.end AS end_4,
  t0.product_id AS product_id_5,
  t0.distributor_id AS distributor_id_6
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = 23638;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.feature_line_id AS feature_line_id_3
FROM
  product_features t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = 23638;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.link AS link_4,
  t0.position AS position_5,
  t0.title AS title_6,
  t0.icon AS icon_7,
  t0.thumbnail AS thumbnail_8,
  t0.image AS image_9,
  t0.margin AS margin_10,
  t0.description AS description_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 WHERE t0.id = 16;

SELECT
  distinct fl.id as id,
  fl.value as name,
  fl.data as code
FROM
  `products` as p
  INNER JOIN product_features as pf
  INNER JOIN features_lines as fl
  INNER JOIN features_list as flist
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (138)
  )
  AND pf.product_id = p.id
  AND pf.feature_line_id = fl.id
  AND p.active = 1
  AND p.valid = 1
  AND flist.id = fl.attribute_id
  AND flist.feature = 'Couleur'
ORDER BY
  fl.value ASC

SELECT distinct fl.id as id, fl.value as name, fl.data as code
                FROM `products` as p
                INNER JOIN product_features as pf
                INNER JOIN features_lines as fl
                INNER JOIN features_list as flist
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (138))
                AND pf.product_id = p.id 
                AND pf.feature_line_id = fl.id 
                AND p.active = 1 
                AND p.valid = 1
                AND flist.id = fl.attribute_id 
                AND flist.feature = 'Couleur'
                ORDER BY fl.value ASC;

SELECT
  distinct fl.id as id,
  fl.value as name,
  fl.data as code
FROM
  products p
  INNER JOIN product_features pf
  INNER JOIN features_lines fl
  INNER JOIN features_list flist
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (138)
  )
  AND pf.product_id = p.id
  AND pf.feature_line_id = fl.id
  AND p.active = 1
  AND p.valid = 1
  AND flist.id = fl.attribute_id
  AND flist.feature = 'Taille'
ORDER BY
  fl.value ASC

SELECT distinct fl.id as id, fl.value as name, fl.data as code
                FROM products p 
                INNER JOIN product_features pf 
                INNER JOIN features_lines fl 
                INNER JOIN features_list flist 
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (138))
                AND pf.product_id = p.id 
                AND pf.feature_line_id = fl.id 
                AND p.active = 1 
                AND p.valid = 1
                AND flist.id = fl.attribute_id 
                AND flist.feature = 'Taille'
                ORDER BY fl.value ASC;

SELECT
  distinct b.id,
  b.name
FROM
  products p
  INNER JOIN brand b
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (138)
  )
  AND b.id = p.brand_id
  AND p.active = 1
  AND p.valid = 1
ORDER BY
  b.name ASC

SELECT distinct b.id, b.name
            FROM products p
            INNER JOIN brand b
            WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (138))
            AND b.id = p.brand_id
            AND p.active = 1
            AND p.valid = 1
            ORDER BY b.name ASC
        ;

SELECT
  distinct fl.id as id,
  fl.value as name,
  fl.data as code
FROM
  products p
  INNER JOIN product_features pf
  INNER JOIN features_lines fl
  INNER JOIN features_list flist
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (138)
  )
  AND pf.product_id = p.id
  AND pf.feature_line_id = fl.id
  AND p.active = 1
  AND p.valid = 1
  AND flist.id = fl.attribute_id
  AND flist.feature = 'Matière'
ORDER BY
  fl.value ASC

SELECT distinct fl.id as id, fl.value as name, fl.data as code
                FROM products p 
                INNER JOIN product_features pf 
                INNER JOIN features_lines fl 
                INNER JOIN features_list flist 
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (138))
                AND pf.product_id = p.id 
                AND pf.feature_line_id = fl.id 
                AND p.active = 1 
                AND p.valid = 1
                AND flist.id = fl.attribute_id
                AND flist.feature = 'Matière'
                ORDER BY fl.value ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.description AS description_4,
  t0.distributors AS distributors_5,
  t0.distributor_id AS distributor_id_6
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.description AS description_4, t0.distributors AS distributors_5, t0.distributor_id AS distributor_id_6 FROM brand t0 WHERE t0.id = 532;