Query Metrics

121 Database Queries
20 Different statements
26.53 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.97 ms
SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.model AS model_3, p0_.description AS description_4, p0_.detail_description AS detail_description_5, p0_.deleted AS deleted_6, p0_.pic AS pic_7, p0_.warranty AS warranty_8, p0_.cost_min AS cost_min_9, p0_.create_time AS create_time_10, s1_.product_id AS product_id_11, s1_.group_id AS group_id_12, s1_.product_type AS product_type_13, s1_.is_show_in_catalog AS is_show_in_catalog_14, s1_.presence AS presence_15, s1_.presence_str AS presence_str_16, s1_.rating AS rating_17, p2_.product_id AS product_id_18, p2_.url_code AS url_code_19, p2_.rating AS rating_20, p2_.seo_title AS seo_title_21, p2_.seo_description AS seo_description_22, p2_.seo_keyword AS seo_keyword_23, p3_.id AS id_24, p3_.default AS default_25, p3_.change_data AS change_data_26, p3_.show_img AS show_img_27, p3_.show_price AS show_price_28, p3_.show_presence AS show_presence_29, p3_.features_sharing AS features_sharing_30, p3_.manual_sharing AS manual_sharing_31, p3_.features AS features_32, p0_.category_id AS category_id_33, s1_.category_id AS category_id_34, s1_.catalog_product_id AS catalog_product_id_35, s1_.product_id AS product_id_36, p2_.product_id AS product_id_37, p3_.product_id AS product_id_38 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 IN (SELECT DISTINCT s4_.catalog_product_id AS sclr_39 FROM sf_product_index s4_ WHERE s4_.catalog_product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR s4_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) ORDER BY FIELD(p0_.product_id, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ASC LIMIT 20
Parameters:
[
  "207555"
  "207560"
  "207563"
  "202675"
  "202695"
  "202696"
  "202698"
  "207407"
  "207233"
  "207234"
  "207237"
  "207238"
  "202513"
  "202515"
  "202516"
  "202517"
  "202708"
  "202710"
  "202712"
  "202749"
  "207555"
  "207560"
  "207563"
  "202675"
  "202695"
  "202696"
  "202698"
  "207407"
  "207233"
  "207234"
  "207237"
  "207238"
  "202513"
  "202515"
  "202516"
  "202517"
  "202708"
  "202710"
  "202712"
  "202749"
  "207555"
  "207560"
  "207563"
  "202675"
  "202695"
  "202696"
  "202698"
  "207407"
  "207233"
  "207234"
  "207237"
  "207238"
  "202513"
  "202515"
  "202516"
  "202517"
  "202708"
  "202710"
  "202712"
  "202749"
]
2 0.28 ms
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = ? LIMIT 1
Parameters:
[
  "es"
]
3 0.19 ms
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
Parameters:
[]
4 0.17 ms
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
Parameters:
[]
5 0.29 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207555
  "unit"
]
6 0.14 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207555
]
7 0.18 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207555
  1
]
8 0.14 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207555
  1
]
9 0.14 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207555
]
10 0.16 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207560
  "unit"
]
11 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207560
]
12 0.14 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207560
  1
]
13 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207560
  1
]
14 0.13 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207560
]
15 0.15 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207563
  "unit"
]
16 0.08 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207563
]
17 0.15 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207563
  1
]
18 0.09 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207563
  1
]
19 0.08 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207563
]
20 0.15 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202675
  "unit"
]
21 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202675
]
22 0.14 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202675
  1
]
23 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202675
  1
]
24 0.13 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202675
]
25 0.15 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202695
  "unit"
]
26 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202695
]
27 0.25 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202695
  1
]
28 0.14 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202695
  1
]
29 0.12 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202695
]
30 0.19 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202696
  "unit"
]
31 0.10 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202696
]
32 0.10 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202696
  1
]
33 0.09 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202696
  1
]
34 0.14 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202696
]
35 0.17 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202698
  "unit"
]
36 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202698
]
37 0.11 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202698
  1
]
38 0.09 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202698
  1
]
39 0.16 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202698
]
40 1.71 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207407
  "unit"
]
41 0.47 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207407
]
42 0.61 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207407
  1
]
43 0.43 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207407
  1
]
44 0.38 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207407
]
45 0.16 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207233
  "unit"
]
46 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207233
]
47 0.16 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207233
  1
]
48 0.17 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207233
  1
]
49 0.14 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207233
]
50 0.16 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207234
  "unit"
]
51 0.13 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207234
]
52 0.16 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207234
  1
]
53 0.09 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207234
  1
]
54 0.08 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207234
]
55 0.18 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207237
  "unit"
]
56 0.10 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207237
]
57 0.15 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207237
  1
]
58 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207237
  1
]
59 0.09 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207237
]
60 0.13 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207238
  "unit"
]
61 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207238
]
62 0.10 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207238
  1
]
63 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207238
  1
]
64 0.08 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207238
]
65 0.19 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202513
  "unit"
]
66 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202513
]
67 0.09 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202513
  1
]
68 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202513
  1
]
69 0.20 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202513
]
70 0.13 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202515
  "unit"
]
71 0.08 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202515
]
72 0.09 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202515
  1
]
73 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202515
  1
]
74 0.11 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202515
]
75 0.13 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202516
  "unit"
]
76 0.08 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202516
]
77 0.10 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202516
  1
]
78 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202516
  1
]
79 0.09 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202516
]
80 0.13 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202517
  "unit"
]
81 0.08 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202517
]
82 0.09 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202517
  1
]
83 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202517
  1
]
84 0.08 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202517
]
85 0.11 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202708
  "unit"
]
86 0.10 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202708
]
87 0.10 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202708
  1
]
88 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202708
  1
]
89 0.08 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202708
]
90 0.19 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202710
  "unit"
]
91 0.08 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202710
]
92 0.09 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202710
  1
]
93 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202710
  1
]
94 0.09 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202710
]
95 0.12 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202712
  "unit"
]
96 0.08 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202712
]
97 0.09 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202712
  1
]
98 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202712
  1
]
99 0.08 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202712
]
100 0.12 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  202749
  "unit"
]
101 0.08 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  202749
]
102 0.10 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  202749
  1
]
103 0.08 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  202749
  1
]
104 0.09 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  202749
]
105 1.86 ms
SELECT COUNT(DISTINCT p0_.product_id) AS sclr_0 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 IN (SELECT DISTINCT s4_.catalog_product_id AS sclr_1 FROM sf_product_index s4_ WHERE s4_.catalog_product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR s4_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) ORDER BY p0_.product_id ASC
Parameters:
[
  "207555"
  "207560"
  "207563"
  "202675"
  "202695"
  "202696"
  "202698"
  "207407"
  "207233"
  "207234"
  "207237"
  "207238"
  "202513"
  "202515"
  "202516"
  "202517"
  "202708"
  "202710"
  "202712"
  "202749"
  "207555"
  "207560"
  "207563"
  "202675"
  "202695"
  "202696"
  "202698"
  "207407"
  "207233"
  "207234"
  "207237"
  "207238"
  "202513"
  "202515"
  "202516"
  "202517"
  "202708"
  "202710"
  "202712"
  "202749"
]
106 0.77 ms
SELECT AVG(c0_.assessment) AS sclr_0, c0_.id_article AS id_article_1 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND c0_.id_article IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.status = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.assessment <> 0 GROUP BY c0_.id_article
Parameters:
[
  "product"
  207555
  207560
  207563
  202675
  202695
  202696
  202698
  207407
  207233
  207234
  207237
  207238
  202513
  202515
  202516
  202517
  202708
  202710
  202712
  202749
  1
]
107 0.73 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.position AS position_2, l0_.description AS description_3, l0_.active AS active_4, l0_.offset AS offset_5, l0_.img AS img_6, p1_.product_id AS product_id_7 FROM labels l0_ INNER JOIN labels_products l2_ ON l0_.id = l2_.label_id INNER JOIN Products p1_ ON p1_.product_id = l2_.product_id WHERE p1_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND l0_.active = ?
Parameters:
[
  207555
  207560
  207563
  202675
  202695
  202696
  202698
  207407
  207233
  207234
  207237
  207238
  202513
  202515
  202516
  202517
  202708
  202710
  202712
  202749
  1
]
108 0.60 ms
SELECT c0_.id AS id_0, c0_.term AS term_1, c0_.is_no_commission AS is_no_commission_2, c0_.credit_rule_id AS credit_rule_id_3, b1_.id AS id_4, b1_.name AS name_5, b1_.is_active AS is_active_6, b1_.handler AS handler_7, b1_.logo AS logo_8, b1_.created_at AS created_at_9, b1_.updated_at AS updated_at_10, c0_.product_id AS product_id_11, c0_.bank_id AS bank_id_12 FROM credits_index c0_ INNER JOIN banks b1_ ON c0_.bank_id = b1_.id WHERE b1_.is_active = ? AND c0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.term > ?
Parameters:
[
  1
  207555
  207560
  207563
  202675
  202695
  202696
  202698
  207407
  207233
  207234
  207237
  207238
  202513
  202515
  202516
  202517
  202708
  202710
  202712
  202749
  1
]
109 0.92 ms
SELECT s0_.product_id AS sclr_0 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) GROUP BY s0_.product_id ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC
Parameters:
[
  "g"
  "group"
  207555
  207560
  207563
  202675
  202695
  202696
  202698
  207407
  207233
  207234
  207237
  207238
  202513
  202515
  202516
  202517
  202708
  202710
  202712
  202749
  "2026-11-20 14:54:43"
  "2026-11-20 14:54:43"
]
110 0.27 ms
SELECT s0_.setting_id AS setting_id_0, s0_.type AS type_1, s0_.setting_name AS setting_name_2, s0_.setting_value AS setting_value_3, s0_.description AS description_4 FROM store_settings s0_ LEFT JOIN kk_settings_ln k1_ ON s0_.setting_id = k1_.setting_id WHERE s0_.type = 'site' AND s0_.setting_name IN (?, ?, ?) LIMIT 3
Parameters:
[
  "notify_top"
  "datepicker"
  "notify_url"
]
111 0.28 ms
SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.model AS model_3, p0_.description AS description_4, p0_.detail_description AS detail_description_5, p0_.deleted AS deleted_6, p0_.pic AS pic_7, p0_.warranty AS warranty_8, p0_.cost_min AS cost_min_9, p0_.create_time AS create_time_10, s1_.product_id AS product_id_11, s1_.group_id AS group_id_12, s1_.product_type AS product_type_13, s1_.is_show_in_catalog AS is_show_in_catalog_14, s1_.presence AS presence_15, s1_.presence_str AS presence_str_16, s1_.rating AS rating_17, p2_.product_id AS product_id_18, p2_.url_code AS url_code_19, p2_.rating AS rating_20, p2_.seo_title AS seo_title_21, p2_.seo_description AS seo_description_22, p2_.seo_keyword AS seo_keyword_23, p3_.id AS id_24, p3_.default AS default_25, p3_.change_data AS change_data_26, p3_.show_img AS show_img_27, p3_.show_price AS show_price_28, p3_.show_presence AS show_presence_29, p3_.features_sharing AS features_sharing_30, p3_.manual_sharing AS manual_sharing_31, p3_.features AS features_32, p0_.category_id AS category_id_33, s1_.category_id AS category_id_34, s1_.catalog_product_id AS catalog_product_id_35, s1_.product_id AS product_id_36, p2_.product_id AS product_id_37, p3_.product_id AS product_id_38 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 IN (SELECT DISTINCT s4_.catalog_product_id AS sclr_39 FROM sf_product_index s4_ WHERE s4_.catalog_product_id IN (?) OR s4_.product_id IN (?))) ORDER BY FIELD(p0_.product_id, ?) ASC LIMIT 10
Parameters:
[
  "207580"
  "207580"
  "207580"
]
112 0.18 ms
SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (?) AND f1_.use_as = ? ORDER BY f3_.weight ASC, f1_.weight ASC
Parameters:
[
  207580
  "unit"
]
113 0.09 ms
SELECT t0.id AS id_1, t0.price_type AS price_type_2, t0.price AS price_3, t0.old_price AS old_price_4, t0.product_id AS product_id_5, t0.currency_id AS currency_id_6 FROM sf_product_price_index t0 WHERE t0.product_id = ?
Parameters:
[
  207580
]
114 0.14 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.content AS content_2, c0_.isNew AS isNew_3, c0_.type_comment AS type_comment_4, c0_.id_article AS id_article_5, c0_.assessment AS assessment_6, c0_.email AS email_7, c0_.url AS url_8, c0_.phone AS phone_9, c0_.created AS created_10, c0_.author AS author_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.user_id AS user_id_14 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  "product"
  207580
  1
]
115 0.09 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.id_article = ? AND c0_.status = ? ORDER BY c0_.id ASC
Parameters:
[
  "product"
  207580
  1
]
116 0.14 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.in_percent AS in_percent_3, t0.description AS description_4, t0.date_end AS date_end_5, t0.product_id AS product_id_6, t0.currency_id AS currency_id_7 FROM sf_product_discount_index t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  207580
]
117 0.09 ms
SELECT COUNT(DISTINCT p0_.product_id) AS sclr_0 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 IN (SELECT DISTINCT s4_.catalog_product_id AS sclr_1 FROM sf_product_index s4_ WHERE s4_.catalog_product_id IN (?) OR s4_.product_id IN (?))) ORDER BY p0_.product_id ASC
Parameters:
[
  "207580"
  "207580"
]
118 0.08 ms
SELECT AVG(c0_.assessment) AS sclr_0, c0_.id_article AS id_article_1 FROM COMMENT c0_ WHERE c0_.type_comment = ? AND c0_.id_article IN (?) AND c0_.status = ? AND (c0_.parent_id IS NULL OR c0_.parent_id = 0) AND c0_.assessment <> 0 GROUP BY c0_.id_article
Parameters:
[
  "product"
  207580
  1
]
119 0.09 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.position AS position_2, l0_.description AS description_3, l0_.active AS active_4, l0_.offset AS offset_5, l0_.img AS img_6, p1_.product_id AS product_id_7 FROM labels l0_ INNER JOIN labels_products l2_ ON l0_.id = l2_.label_id INNER JOIN Products p1_ ON p1_.product_id = l2_.product_id WHERE p1_.product_id IN (?) AND l0_.active = ?
Parameters:
[
  207580
  1
]
120 0.09 ms
SELECT c0_.id AS id_0, c0_.term AS term_1, c0_.is_no_commission AS is_no_commission_2, c0_.credit_rule_id AS credit_rule_id_3, b1_.id AS id_4, b1_.name AS name_5, b1_.is_active AS is_active_6, b1_.handler AS handler_7, b1_.logo AS logo_8, b1_.created_at AS created_at_9, b1_.updated_at AS updated_at_10, c0_.product_id AS product_id_11, c0_.bank_id AS bank_id_12 FROM credits_index c0_ INNER JOIN banks b1_ ON c0_.bank_id = b1_.id WHERE b1_.is_active = ? AND c0_.product_id IN (?) AND c0_.term > ?
Parameters:
[
  1
  207580
  1
]
121 0.83 ms
SELECT s0_.product_id AS sclr_0 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = ?) INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> ?) WHERE s0_.product_id IN (?) AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= ?) AND (s0_.date_end IS NULL OR s0_.date_end >= ?) GROUP BY s0_.product_id ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC
Parameters:
[
  "g"
  "group"
  207580
  "2026-11-20 14:54:44"
  "2026-11-20 14:54:44"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.