Symfony Profiler

SELECT
  t0.currency_id AS currency_id_1,
  t0.currency AS currency_2,
  t0.is_cash AS is_cash_3,
  t0.rate AS rate_4
FROM
  Currencies t0

SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0;

SELECT
  p0_.product_id AS product_id_0,
  p0_.product AS product_1,
  p0_.pn AS pn_2,
  p0_.description AS description_3,
  p0_.detail_description AS detail_description_4,
  p0_.deleted AS deleted_5,
  p0_.pic AS pic_6,
  p0_.warranty AS warranty_7,
  p0_.cost_min AS cost_min_8,
  p0_.create_time AS create_time_9,
  s1_.product_id AS product_id_10,
  s1_.group_id AS group_id_11,
  s1_.product_type AS product_type_12,
  s1_.is_show_in_catalog AS is_show_in_catalog_13,
  s1_.presence AS presence_14,
  s1_.presence_str AS presence_str_15,
  s1_.rating AS rating_16,
  p2_.product_id AS product_id_17,
  p2_.url_code AS url_code_18,
  p2_.rating AS rating_19,
  p2_.seo_title AS seo_title_20,
  p2_.seo_description AS seo_description_21,
  p2_.seo_keyword AS seo_keyword_22,
  p3_.id AS id_23,
  p3_.default AS default_24,
  p3_.change_data AS change_data_25,
  p3_.show_img AS show_img_26,
  p3_.show_price AS show_price_27,
  p3_.show_presence AS show_presence_28,
  p3_.features_sharing AS features_sharing_29,
  p3_.manual_sharing AS manual_sharing_30,
  p3_.features AS features_31,
  p0_.category_id AS category_id_32,
  s1_.category_id AS category_id_33,
  s1_.catalog_product_id AS catalog_product_id_34,
  s1_.product_id AS product_id_35,
  p2_.product_id AS product_id_36,
  p3_.product_id AS product_id_37
FROM
  Products p0_
  INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id
  INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id
  LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id
WHERE
  p0_.deleted = 0
  AND p2_.url_code <> ''
  AND p0_.product_id = ?
LIMIT
  1

SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p0_.product_id = 1020 LIMIT 1;

SELECT
  s0_.stock_id AS stock_id_0,
  COUNT(s1_.stock_products_id) AS sclr_1,
  SUM(
    IF(
      s2_.presence > 0
      AND s2_.product_type <> ?,
      1,
      0
    )
  ) AS sclr_2
FROM
  stock s0_
  INNER JOIN stock_products s1_ ON s0_.stock_id = s1_.stock_id
  INNER JOIN Products p3_ ON s1_.product_id = p3_.product_id
  INNER JOIN sf_product_index s2_ ON p3_.product_id = s2_.product_id
WHERE
  p3_.deleted = 0
  AND s0_.product_id = ?
GROUP BY
  s0_.stock_id
HAVING
  sclr_1 = sclr_2

SELECT s0_.stock_id AS stock_id_0, COUNT(s1_.stock_products_id) AS sclr_1, SUM(IF(s2_.presence > 0 AND s2_.product_type <> 'group', 1, 0)) AS sclr_2 FROM stock s0_ INNER JOIN stock_products s1_ ON s0_.stock_id = s1_.stock_id INNER JOIN Products p3_ ON s1_.product_id = p3_.product_id INNER JOIN sf_product_index s2_ ON p3_.product_id = s2_.product_id WHERE p3_.deleted = 0 AND s0_.product_id = 1020 GROUP BY s0_.stock_id HAVING sclr_1 = sclr_2;

SELECT
  s0_.stock_id AS stock_id_0,
  s0_.stock_code AS stock_code_1,
  p1_.product_id AS product_id_2,
  p1_.product AS product_3,
  p1_.pn AS pn_4,
  p1_.description AS description_5,
  p1_.detail_description AS detail_description_6,
  p1_.deleted AS deleted_7,
  p1_.pic AS pic_8,
  p1_.warranty AS warranty_9,
  p1_.cost_min AS cost_min_10,
  p1_.create_time AS create_time_11,
  p2_.product_id AS product_id_12,
  p2_.url_code AS url_code_13,
  p2_.rating AS rating_14,
  p2_.seo_title AS seo_title_15,
  p2_.seo_description AS seo_description_16,
  p2_.seo_keyword AS seo_keyword_17,
  s3_.product_id AS product_id_18,
  s3_.group_id AS group_id_19,
  s3_.product_type AS product_type_20,
  s3_.is_show_in_catalog AS is_show_in_catalog_21,
  s3_.presence AS presence_22,
  s3_.presence_str AS presence_str_23,
  s3_.rating AS rating_24,
  s0_.product_id AS product_id_25,
  p1_.category_id AS category_id_26,
  p2_.product_id AS product_id_27,
  s3_.category_id AS category_id_28,
  s3_.catalog_product_id AS catalog_product_id_29,
  s3_.product_id AS product_id_30
FROM
  stock s0_
  INNER JOIN Products p1_ ON s0_.product_id = p1_.product_id
  INNER JOIN Products_Data p2_ ON p1_.product_id = p2_.product_id
  INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id
WHERE
  p1_.deleted = 0
  AND s0_.stock_id IN (?)
LIMIT
  1

SELECT s0_.stock_id AS stock_id_0, s0_.stock_code AS stock_code_1, p1_.product_id AS product_id_2, p1_.product AS product_3, p1_.pn AS pn_4, p1_.description AS description_5, p1_.detail_description AS detail_description_6, p1_.deleted AS deleted_7, p1_.pic AS pic_8, p1_.warranty AS warranty_9, p1_.cost_min AS cost_min_10, p1_.create_time AS create_time_11, p2_.product_id AS product_id_12, p2_.url_code AS url_code_13, p2_.rating AS rating_14, p2_.seo_title AS seo_title_15, p2_.seo_description AS seo_description_16, p2_.seo_keyword AS seo_keyword_17, s3_.product_id AS product_id_18, s3_.group_id AS group_id_19, s3_.product_type AS product_type_20, s3_.is_show_in_catalog AS is_show_in_catalog_21, s3_.presence AS presence_22, s3_.presence_str AS presence_str_23, s3_.rating AS rating_24, s0_.product_id AS product_id_25, p1_.category_id AS category_id_26, p2_.product_id AS product_id_27, s3_.category_id AS category_id_28, s3_.catalog_product_id AS catalog_product_id_29, s3_.product_id AS product_id_30 FROM stock s0_ INNER JOIN Products p1_ ON s0_.product_id = p1_.product_id INNER JOIN Products_Data p2_ ON p1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id WHERE p1_.deleted = 0 AND s0_.stock_id IN (0) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.stock_id) AS sclr_0
FROM
  stock s0_
  INNER JOIN Products p1_ ON s0_.product_id = p1_.product_id
  INNER JOIN Products_Data p2_ ON p1_.product_id = p2_.product_id
  INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id
WHERE
  p1_.deleted = 0
  AND s0_.stock_id IN (?)
ORDER BY
  s0_.stock_id ASC

SELECT COUNT(DISTINCT s0_.stock_id) AS sclr_0 FROM stock s0_ INNER JOIN Products p1_ ON s0_.product_id = p1_.product_id INNER JOIN Products_Data p2_ ON p1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id WHERE p1_.deleted = 0 AND s0_.stock_id IN (0) ORDER BY s0_.stock_id ASC;