107.98 ms
(60.22%)
|
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, c1_.id AS id_50, c1_.date_entered AS date_entered_51, c1_.date_modified AS date_modified_52, c1_.created_by AS created_by_53, c1_.modified_user_id AS modified_user_id_54, c1_.name AS name_55, c1_.slug AS slug_56, c1_.status AS status_57, c1_.description AS description_58, c1_.main AS main_59, c1_.type AS type_60, c1_.product_cnt AS product_cnt_61, c1_.site_product_cnt AS site_product_cnt_62, c1_.sort AS sort_63, c1_.seo_title AS seo_title_64, c1_.seo_description AS seo_description_65, m2_.id AS id_66, m2_.short_name AS short_name_67, m2_.name AS name_68, m2_.date_entered AS date_entered_69, m2_.date_modified AS date_modified_70, m2_.created_by AS created_by_71, m2_.modified_user_id AS modified_user_id_72, m2_.description AS description_73, m2_.code1c AS code1c_74, p3_.id AS id_75, p3_.name AS name_76, p3_.date_entered AS date_entered_77, p3_.date_modified AS date_modified_78, p3_.description AS description_79, p3_.code1c AS code1c_80, p3_.barcode AS barcode_81, p3_.status AS status_82, p3_.price AS price_83, p3_.price_income AS price_income_84, p3_.mark_up AS mark_up_85, p3_.min_mark_up AS min_mark_up_86, p3_.packing_type AS packing_type_87, p3_.packing_type_count AS packing_type_count_88, p3_.discounts AS discounts_89, p3_.count_order AS count_order_90, p3_.product_to_order AS product_to_order_91, p3_.article AS article_92, p3_.nds AS nds_93, p3_.service AS service_94, p3_.transport_service AS transport_service_95, p3_.exise AS exise_96, p3_.expiration_date AS expiration_date_97, p3_.unit_volume AS unit_volume_98, p3_.net_weight AS net_weight_99, p3_.gross_weight AS gross_weight_100, p3_.go_by_weight AS go_by_weight_101, p3_.packaging AS packaging_102, p3_.old_code AS old_code_103, p3_.show AS show_104, p3_.balance AS balance_105, p3_.deleted AS deleted_106, p3_.category_cnt AS category_cnt_107, p3_.price_category AS price_category_108, p3_.is_salle AS is_salle_109, p3_.is_new AS is_new_110, p3_.is_top AS is_top_111, p3_.old_price AS old_price_112, p3_.discount_percent AS discount_percent_113, p3_.date_last_price_income AS date_last_price_income_114, p3_.video AS video_115, p3_.is_video AS is_video_116, p3_.is_free_shipping AS is_free_shipping_117, p3_.warranty_period AS warranty_period_118, p3_.min_balance AS min_balance_119, p3_.min_balance_admin AS min_balance_admin_120, p3_.main_category_id AS main_category_id_121, p3_.discontinued AS discontinued_122, p3_.seo_title AS seo_title_123, p3_.seo_description AS seo_description_124, p4_.id AS id_125, p4_.name AS name_126, p4_.date_entered AS date_entered_127, p4_.date_modified AS date_modified_128, p4_.description AS description_129, p4_.code1c AS code1c_130, p4_.barcode AS barcode_131, p4_.status AS status_132, p4_.price AS price_133, p4_.price_income AS price_income_134, p4_.mark_up AS mark_up_135, p4_.min_mark_up AS min_mark_up_136, p4_.packing_type AS packing_type_137, p4_.packing_type_count AS packing_type_count_138, p4_.discounts AS discounts_139, p4_.count_order AS count_order_140, p4_.product_to_order AS product_to_order_141, p4_.article AS article_142, p4_.nds AS nds_143, p4_.service AS service_144, p4_.transport_service AS transport_service_145, p4_.exise AS exise_146, p4_.expiration_date AS expiration_date_147, p4_.unit_volume AS unit_volume_148, p4_.net_weight AS net_weight_149, p4_.gross_weight AS gross_weight_150, p4_.go_by_weight AS go_by_weight_151, p4_.packaging AS packaging_152, p4_.old_code AS old_code_153, p4_.show AS show_154, p4_.balance AS balance_155, p4_.deleted AS deleted_156, p4_.category_cnt AS category_cnt_157, p4_.price_category AS price_category_158, p4_.is_salle AS is_salle_159, p4_.is_new AS is_new_160, p4_.is_top AS is_top_161, p4_.old_price AS old_price_162, p4_.discount_percent AS discount_percent_163, p4_.date_last_price_income AS date_last_price_income_164, p4_.video AS video_165, p4_.is_video AS is_video_166, p4_.is_free_shipping AS is_free_shipping_167, p4_.warranty_period AS warranty_period_168, p4_.min_balance AS min_balance_169, p4_.min_balance_admin AS min_balance_admin_170, p4_.main_category_id AS main_category_id_171, p4_.discontinued AS discontinued_172, p4_.seo_title AS seo_title_173, p4_.seo_description AS seo_description_174, m5_.id AS id_175, m5_.upload_timestamp AS upload_timestamp_176, m5_.main AS main_177, m5_.file_path AS file_path_178, m5_.type AS type_179, m5_.name AS name_180, m5_.size AS size_181, m5_.sort AS sort_182, m6_.id AS id_183, m6_.upload_timestamp AS upload_timestamp_184, m6_.main AS main_185, m6_.file_path AS file_path_186, m6_.type AS type_187, m6_.name AS name_188, m6_.size AS size_189, m6_.sort AS sort_190, m7_.id AS id_191, m7_.upload_timestamp AS upload_timestamp_192, m7_.main AS main_193, m7_.file_path AS file_path_194, m7_.type AS type_195, m7_.name AS name_196, m7_.size AS size_197, m7_.sort AS sort_198, m8_.id AS id_199, m8_.upload_timestamp AS upload_timestamp_200, m8_.main AS main_201, m8_.file_path AS file_path_202, m8_.type AS type_203, m8_.name AS name_204, m8_.size AS size_205, m8_.sort AS sort_206, p0_.modified_user_id AS modified_user_id_207, p0_.created_by_id AS created_by_id_208, p0_.measurement_unit_id AS measurement_unit_id_209, p0_.site_product_id AS site_product_id_210, p0_.storage_id AS storage_id_211, p0_.storage_element_id AS storage_element_id_212, p0_.language_id AS language_id_213, p0_.translation_id AS translation_id_214, p0_.main_media_id AS main_media_id_215, p0_.main_media_hover_id AS main_media_hover_id_216, c1_.parent_id AS parent_id_217, c1_.media_id AS media_id_218, c1_.language_id AS language_id_219, c1_.translation_id AS translation_id_220, p3_.modified_user_id AS modified_user_id_221, p3_.created_by_id AS created_by_id_222, p3_.measurement_unit_id AS measurement_unit_id_223, p3_.site_product_id AS site_product_id_224, p3_.storage_id AS storage_id_225, p3_.storage_element_id AS storage_element_id_226, p3_.language_id AS language_id_227, p3_.translation_id AS translation_id_228, p3_.main_media_id AS main_media_id_229, p3_.main_media_hover_id AS main_media_hover_id_230, p4_.modified_user_id AS modified_user_id_231, p4_.created_by_id AS created_by_id_232, p4_.measurement_unit_id AS measurement_unit_id_233, p4_.site_product_id AS site_product_id_234, p4_.storage_id AS storage_id_235, p4_.storage_element_id AS storage_element_id_236, p4_.language_id AS language_id_237, p4_.translation_id AS translation_id_238, p4_.main_media_id AS main_media_id_239, p4_.main_media_hover_id AS main_media_hover_id_240, m5_.product_id AS product_id_241, m5_.orders_id AS orders_id_242, m5_.users_id AS users_id_243, m5_.account_worker_id AS account_worker_id_244, m5_.form_answer_id AS form_answer_id_245, m5_.job_id AS job_id_246, m5_.resize_img_parent_id AS resize_img_parent_id_247, m6_.product_id AS product_id_248, m6_.orders_id AS orders_id_249, m6_.users_id AS users_id_250, m6_.account_worker_id AS account_worker_id_251, m6_.form_answer_id AS form_answer_id_252, m6_.job_id AS job_id_253, m6_.resize_img_parent_id AS resize_img_parent_id_254, m7_.product_id AS product_id_255, m7_.orders_id AS orders_id_256, m7_.users_id AS users_id_257, m7_.account_worker_id AS account_worker_id_258, m7_.form_answer_id AS form_answer_id_259, m7_.job_id AS job_id_260, m7_.resize_img_parent_id AS resize_img_parent_id_261, m8_.product_id AS product_id_262, m8_.orders_id AS orders_id_263, m8_.users_id AS users_id_264, m8_.account_worker_id AS account_worker_id_265, m8_.form_answer_id AS form_answer_id_266, m8_.job_id AS job_id_267, m8_.resize_img_parent_id AS resize_img_parent_id_268 FROM products p0_ INNER JOIN products_category p9_ ON p0_.id = p9_.products_id INNER JOIN category c1_ ON c1_.id = p9_.category_id LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id LEFT JOIN media_object m10_ ON p0_.id = m10_.product_id WHERE p0_.id IN (SELECT p11_.id FROM products p11_ INNER JOIN products_category p13_ ON p11_.id = p13_.products_id INNER JOIN category c12_ ON c12_.id = p13_.category_id WHERE p11_.deleted = ? AND p11_.deleted = ? AND p11_.deleted = ? AND p11_.deleted = ? AND c12_.slug = ? AND p11_.show = ? AND p11_.discontinued = ?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC, m10_.sort DESC, p0_.discontinued DESC
Parameters: [
0
0
0
0
"novinki"
"true"
"false"
29180
29181
29182
29217
29214
29206
29179
29216
29177
29221
29218
29204
29154
29207
29205
29215
29213
29212
29187
29220
29191
29192
29201
29183
29184
]
SELECT
p0_.id AS id_0,
p0_.name AS name_1,
p0_.date_entered AS date_entered_2,
p0_.date_modified AS date_modified_3,
p0_.description AS description_4,
p0_.code1c AS code1c_5,
p0_.barcode AS barcode_6,
p0_.status AS status_7,
p0_.price AS price_8,
p0_.price_income AS price_income_9,
p0_.mark_up AS mark_up_10,
p0_.min_mark_up AS min_mark_up_11,
p0_.packing_type AS packing_type_12,
p0_.packing_type_count AS packing_type_count_13,
p0_.discounts AS discounts_14,
p0_.count_order AS count_order_15,
p0_.product_to_order AS product_to_order_16,
p0_.article AS article_17,
p0_.nds AS nds_18,
p0_.service AS service_19,
p0_.transport_service AS transport_service_20,
p0_.exise AS exise_21,
p0_.expiration_date AS expiration_date_22,
p0_.unit_volume AS unit_volume_23,
p0_.net_weight AS net_weight_24,
p0_.gross_weight AS gross_weight_25,
p0_.go_by_weight AS go_by_weight_26,
p0_.packaging AS packaging_27,
p0_.old_code AS old_code_28,
p0_.show AS show_29,
p0_.balance AS balance_30,
p0_.deleted AS deleted_31,
p0_.category_cnt AS category_cnt_32,
p0_.price_category AS price_category_33,
p0_.is_salle AS is_salle_34,
p0_.is_new AS is_new_35,
p0_.is_top AS is_top_36,
p0_.old_price AS old_price_37,
p0_.discount_percent AS discount_percent_38,
p0_.date_last_price_income AS date_last_price_income_39,
p0_.video AS video_40,
p0_.is_video AS is_video_41,
p0_.is_free_shipping AS is_free_shipping_42,
p0_.warranty_period AS warranty_period_43,
p0_.min_balance AS min_balance_44,
p0_.min_balance_admin AS min_balance_admin_45,
p0_.main_category_id AS main_category_id_46,
p0_.discontinued AS discontinued_47,
p0_.seo_title AS seo_title_48,
p0_.seo_description AS seo_description_49,
c1_.id AS id_50,
c1_.date_entered AS date_entered_51,
c1_.date_modified AS date_modified_52,
c1_.created_by AS created_by_53,
c1_.modified_user_id AS modified_user_id_54,
c1_.name AS name_55,
c1_.slug AS slug_56,
c1_.status AS status_57,
c1_.description AS description_58,
c1_.main AS main_59,
c1_.type AS type_60,
c1_.product_cnt AS product_cnt_61,
c1_.site_product_cnt AS site_product_cnt_62,
c1_.sort AS sort_63,
c1_.seo_title AS seo_title_64,
c1_.seo_description AS seo_description_65,
m2_.id AS id_66,
m2_.short_name AS short_name_67,
m2_.name AS name_68,
m2_.date_entered AS date_entered_69,
m2_.date_modified AS date_modified_70,
m2_.created_by AS created_by_71,
m2_.modified_user_id AS modified_user_id_72,
m2_.description AS description_73,
m2_.code1c AS code1c_74,
p3_.id AS id_75,
p3_.name AS name_76,
p3_.date_entered AS date_entered_77,
p3_.date_modified AS date_modified_78,
p3_.description AS description_79,
p3_.code1c AS code1c_80,
p3_.barcode AS barcode_81,
p3_.status AS status_82,
p3_.price AS price_83,
p3_.price_income AS price_income_84,
p3_.mark_up AS mark_up_85,
p3_.min_mark_up AS min_mark_up_86,
p3_.packing_type AS packing_type_87,
p3_.packing_type_count AS packing_type_count_88,
p3_.discounts AS discounts_89,
p3_.count_order AS count_order_90,
p3_.product_to_order AS product_to_order_91,
p3_.article AS article_92,
p3_.nds AS nds_93,
p3_.service AS service_94,
p3_.transport_service AS transport_service_95,
p3_.exise AS exise_96,
p3_.expiration_date AS expiration_date_97,
p3_.unit_volume AS unit_volume_98,
p3_.net_weight AS net_weight_99,
p3_.gross_weight AS gross_weight_100,
p3_.go_by_weight AS go_by_weight_101,
p3_.packaging AS packaging_102,
p3_.old_code AS old_code_103,
p3_.show AS show_104,
p3_.balance AS balance_105,
p3_.deleted AS deleted_106,
p3_.category_cnt AS category_cnt_107,
p3_.price_category AS price_category_108,
p3_.is_salle AS is_salle_109,
p3_.is_new AS is_new_110,
p3_.is_top AS is_top_111,
p3_.old_price AS old_price_112,
p3_.discount_percent AS discount_percent_113,
p3_.date_last_price_income AS date_last_price_income_114,
p3_.video AS video_115,
p3_.is_video AS is_video_116,
p3_.is_free_shipping AS is_free_shipping_117,
p3_.warranty_period AS warranty_period_118,
p3_.min_balance AS min_balance_119,
p3_.min_balance_admin AS min_balance_admin_120,
p3_.main_category_id AS main_category_id_121,
p3_.discontinued AS discontinued_122,
p3_.seo_title AS seo_title_123,
p3_.seo_description AS seo_description_124,
p4_.id AS id_125,
p4_.name AS name_126,
p4_.date_entered AS date_entered_127,
p4_.date_modified AS date_modified_128,
p4_.description AS description_129,
p4_.code1c AS code1c_130,
p4_.barcode AS barcode_131,
p4_.status AS status_132,
p4_.price AS price_133,
p4_.price_income AS price_income_134,
p4_.mark_up AS mark_up_135,
p4_.min_mark_up AS min_mark_up_136,
p4_.packing_type AS packing_type_137,
p4_.packing_type_count AS packing_type_count_138,
p4_.discounts AS discounts_139,
p4_.count_order AS count_order_140,
p4_.product_to_order AS product_to_order_141,
p4_.article AS article_142,
p4_.nds AS nds_143,
p4_.service AS service_144,
p4_.transport_service AS transport_service_145,
p4_.exise AS exise_146,
p4_.expiration_date AS expiration_date_147,
p4_.unit_volume AS unit_volume_148,
p4_.net_weight AS net_weight_149,
p4_.gross_weight AS gross_weight_150,
p4_.go_by_weight AS go_by_weight_151,
p4_.packaging AS packaging_152,
p4_.old_code AS old_code_153,
p4_.show AS show_154,
p4_.balance AS balance_155,
p4_.deleted AS deleted_156,
p4_.category_cnt AS category_cnt_157,
p4_.price_category AS price_category_158,
p4_.is_salle AS is_salle_159,
p4_.is_new AS is_new_160,
p4_.is_top AS is_top_161,
p4_.old_price AS old_price_162,
p4_.discount_percent AS discount_percent_163,
p4_.date_last_price_income AS date_last_price_income_164,
p4_.video AS video_165,
p4_.is_video AS is_video_166,
p4_.is_free_shipping AS is_free_shipping_167,
p4_.warranty_period AS warranty_period_168,
p4_.min_balance AS min_balance_169,
p4_.min_balance_admin AS min_balance_admin_170,
p4_.main_category_id AS main_category_id_171,
p4_.discontinued AS discontinued_172,
p4_.seo_title AS seo_title_173,
p4_.seo_description AS seo_description_174,
m5_.id AS id_175,
m5_.upload_timestamp AS upload_timestamp_176,
m5_.main AS main_177,
m5_.file_path AS file_path_178,
m5_.type AS type_179,
m5_.name AS name_180,
m5_.size AS size_181,
m5_.sort AS sort_182,
m6_.id AS id_183,
m6_.upload_timestamp AS upload_timestamp_184,
m6_.main AS main_185,
m6_.file_path AS file_path_186,
m6_.type AS type_187,
m6_.name AS name_188,
m6_.size AS size_189,
m6_.sort AS sort_190,
m7_.id AS id_191,
m7_.upload_timestamp AS upload_timestamp_192,
m7_.main AS main_193,
m7_.file_path AS file_path_194,
m7_.type AS type_195,
m7_.name AS name_196,
m7_.size AS size_197,
m7_.sort AS sort_198,
m8_.id AS id_199,
m8_.upload_timestamp AS upload_timestamp_200,
m8_.main AS main_201,
m8_.file_path AS file_path_202,
m8_.type AS type_203,
m8_.name AS name_204,
m8_.size AS size_205,
m8_.sort AS sort_206,
p0_.modified_user_id AS modified_user_id_207,
p0_.created_by_id AS created_by_id_208,
p0_.measurement_unit_id AS measurement_unit_id_209,
p0_.site_product_id AS site_product_id_210,
p0_.storage_id AS storage_id_211,
p0_.storage_element_id AS storage_element_id_212,
p0_.language_id AS language_id_213,
p0_.translation_id AS translation_id_214,
p0_.main_media_id AS main_media_id_215,
p0_.main_media_hover_id AS main_media_hover_id_216,
c1_.parent_id AS parent_id_217,
c1_.media_id AS media_id_218,
c1_.language_id AS language_id_219,
c1_.translation_id AS translation_id_220,
p3_.modified_user_id AS modified_user_id_221,
p3_.created_by_id AS created_by_id_222,
p3_.measurement_unit_id AS measurement_unit_id_223,
p3_.site_product_id AS site_product_id_224,
p3_.storage_id AS storage_id_225,
p3_.storage_element_id AS storage_element_id_226,
p3_.language_id AS language_id_227,
p3_.translation_id AS translation_id_228,
p3_.main_media_id AS main_media_id_229,
p3_.main_media_hover_id AS main_media_hover_id_230,
p4_.modified_user_id AS modified_user_id_231,
p4_.created_by_id AS created_by_id_232,
p4_.measurement_unit_id AS measurement_unit_id_233,
p4_.site_product_id AS site_product_id_234,
p4_.storage_id AS storage_id_235,
p4_.storage_element_id AS storage_element_id_236,
p4_.language_id AS language_id_237,
p4_.translation_id AS translation_id_238,
p4_.main_media_id AS main_media_id_239,
p4_.main_media_hover_id AS main_media_hover_id_240,
m5_.product_id AS product_id_241,
m5_.orders_id AS orders_id_242,
m5_.users_id AS users_id_243,
m5_.account_worker_id AS account_worker_id_244,
m5_.form_answer_id AS form_answer_id_245,
m5_.job_id AS job_id_246,
m5_.resize_img_parent_id AS resize_img_parent_id_247,
m6_.product_id AS product_id_248,
m6_.orders_id AS orders_id_249,
m6_.users_id AS users_id_250,
m6_.account_worker_id AS account_worker_id_251,
m6_.form_answer_id AS form_answer_id_252,
m6_.job_id AS job_id_253,
m6_.resize_img_parent_id AS resize_img_parent_id_254,
m7_.product_id AS product_id_255,
m7_.orders_id AS orders_id_256,
m7_.users_id AS users_id_257,
m7_.account_worker_id AS account_worker_id_258,
m7_.form_answer_id AS form_answer_id_259,
m7_.job_id AS job_id_260,
m7_.resize_img_parent_id AS resize_img_parent_id_261,
m8_.product_id AS product_id_262,
m8_.orders_id AS orders_id_263,
m8_.users_id AS users_id_264,
m8_.account_worker_id AS account_worker_id_265,
m8_.form_answer_id AS form_answer_id_266,
m8_.job_id AS job_id_267,
m8_.resize_img_parent_id AS resize_img_parent_id_268
FROM
products p0_
INNER JOIN products_category p9_ ON p0_.id = p9_.products_id
INNER JOIN category c1_ ON c1_.id = p9_.category_id
LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id
LEFT JOIN products p3_ ON p0_.translation_id = p3_.id
LEFT JOIN products p4_ ON p0_.id = p4_.translation_id
LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id
LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id
LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id
LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id
LEFT JOIN media_object m10_ ON p0_.id = m10_.product_id
WHERE
p0_.id IN (
SELECT
p11_.id
FROM
products p11_
INNER JOIN products_category p13_ ON p11_.id = p13_.products_id
INNER JOIN category c12_ ON c12_.id = p13_.category_id
WHERE
p11_.deleted = ?
AND p11_.deleted = ?
AND p11_.deleted = ?
AND p11_.deleted = ?
AND c12_.slug = ?
AND p11_.show = ?
AND p11_.discontinued = ?
)
AND p0_.id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?
)
ORDER BY
p0_.name ASC,
m10_.sort DESC,
p0_.discontinued DESC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, c1_.id AS id_50, c1_.date_entered AS date_entered_51, c1_.date_modified AS date_modified_52, c1_.created_by AS created_by_53, c1_.modified_user_id AS modified_user_id_54, c1_.name AS name_55, c1_.slug AS slug_56, c1_.status AS status_57, c1_.description AS description_58, c1_.main AS main_59, c1_.type AS type_60, c1_.product_cnt AS product_cnt_61, c1_.site_product_cnt AS site_product_cnt_62, c1_.sort AS sort_63, c1_.seo_title AS seo_title_64, c1_.seo_description AS seo_description_65, m2_.id AS id_66, m2_.short_name AS short_name_67, m2_.name AS name_68, m2_.date_entered AS date_entered_69, m2_.date_modified AS date_modified_70, m2_.created_by AS created_by_71, m2_.modified_user_id AS modified_user_id_72, m2_.description AS description_73, m2_.code1c AS code1c_74, p3_.id AS id_75, p3_.name AS name_76, p3_.date_entered AS date_entered_77, p3_.date_modified AS date_modified_78, p3_.description AS description_79, p3_.code1c AS code1c_80, p3_.barcode AS barcode_81, p3_.status AS status_82, p3_.price AS price_83, p3_.price_income AS price_income_84, p3_.mark_up AS mark_up_85, p3_.min_mark_up AS min_mark_up_86, p3_.packing_type AS packing_type_87, p3_.packing_type_count AS packing_type_count_88, p3_.discounts AS discounts_89, p3_.count_order AS count_order_90, p3_.product_to_order AS product_to_order_91, p3_.article AS article_92, p3_.nds AS nds_93, p3_.service AS service_94, p3_.transport_service AS transport_service_95, p3_.exise AS exise_96, p3_.expiration_date AS expiration_date_97, p3_.unit_volume AS unit_volume_98, p3_.net_weight AS net_weight_99, p3_.gross_weight AS gross_weight_100, p3_.go_by_weight AS go_by_weight_101, p3_.packaging AS packaging_102, p3_.old_code AS old_code_103, p3_.show AS show_104, p3_.balance AS balance_105, p3_.deleted AS deleted_106, p3_.category_cnt AS category_cnt_107, p3_.price_category AS price_category_108, p3_.is_salle AS is_salle_109, p3_.is_new AS is_new_110, p3_.is_top AS is_top_111, p3_.old_price AS old_price_112, p3_.discount_percent AS discount_percent_113, p3_.date_last_price_income AS date_last_price_income_114, p3_.video AS video_115, p3_.is_video AS is_video_116, p3_.is_free_shipping AS is_free_shipping_117, p3_.warranty_period AS warranty_period_118, p3_.min_balance AS min_balance_119, p3_.min_balance_admin AS min_balance_admin_120, p3_.main_category_id AS main_category_id_121, p3_.discontinued AS discontinued_122, p3_.seo_title AS seo_title_123, p3_.seo_description AS seo_description_124, p4_.id AS id_125, p4_.name AS name_126, p4_.date_entered AS date_entered_127, p4_.date_modified AS date_modified_128, p4_.description AS description_129, p4_.code1c AS code1c_130, p4_.barcode AS barcode_131, p4_.status AS status_132, p4_.price AS price_133, p4_.price_income AS price_income_134, p4_.mark_up AS mark_up_135, p4_.min_mark_up AS min_mark_up_136, p4_.packing_type AS packing_type_137, p4_.packing_type_count AS packing_type_count_138, p4_.discounts AS discounts_139, p4_.count_order AS count_order_140, p4_.product_to_order AS product_to_order_141, p4_.article AS article_142, p4_.nds AS nds_143, p4_.service AS service_144, p4_.transport_service AS transport_service_145, p4_.exise AS exise_146, p4_.expiration_date AS expiration_date_147, p4_.unit_volume AS unit_volume_148, p4_.net_weight AS net_weight_149, p4_.gross_weight AS gross_weight_150, p4_.go_by_weight AS go_by_weight_151, p4_.packaging AS packaging_152, p4_.old_code AS old_code_153, p4_.show AS show_154, p4_.balance AS balance_155, p4_.deleted AS deleted_156, p4_.category_cnt AS category_cnt_157, p4_.price_category AS price_category_158, p4_.is_salle AS is_salle_159, p4_.is_new AS is_new_160, p4_.is_top AS is_top_161, p4_.old_price AS old_price_162, p4_.discount_percent AS discount_percent_163, p4_.date_last_price_income AS date_last_price_income_164, p4_.video AS video_165, p4_.is_video AS is_video_166, p4_.is_free_shipping AS is_free_shipping_167, p4_.warranty_period AS warranty_period_168, p4_.min_balance AS min_balance_169, p4_.min_balance_admin AS min_balance_admin_170, p4_.main_category_id AS main_category_id_171, p4_.discontinued AS discontinued_172, p4_.seo_title AS seo_title_173, p4_.seo_description AS seo_description_174, m5_.id AS id_175, m5_.upload_timestamp AS upload_timestamp_176, m5_.main AS main_177, m5_.file_path AS file_path_178, m5_.type AS type_179, m5_.name AS name_180, m5_.size AS size_181, m5_.sort AS sort_182, m6_.id AS id_183, m6_.upload_timestamp AS upload_timestamp_184, m6_.main AS main_185, m6_.file_path AS file_path_186, m6_.type AS type_187, m6_.name AS name_188, m6_.size AS size_189, m6_.sort AS sort_190, m7_.id AS id_191, m7_.upload_timestamp AS upload_timestamp_192, m7_.main AS main_193, m7_.file_path AS file_path_194, m7_.type AS type_195, m7_.name AS name_196, m7_.size AS size_197, m7_.sort AS sort_198, m8_.id AS id_199, m8_.upload_timestamp AS upload_timestamp_200, m8_.main AS main_201, m8_.file_path AS file_path_202, m8_.type AS type_203, m8_.name AS name_204, m8_.size AS size_205, m8_.sort AS sort_206, p0_.modified_user_id AS modified_user_id_207, p0_.created_by_id AS created_by_id_208, p0_.measurement_unit_id AS measurement_unit_id_209, p0_.site_product_id AS site_product_id_210, p0_.storage_id AS storage_id_211, p0_.storage_element_id AS storage_element_id_212, p0_.language_id AS language_id_213, p0_.translation_id AS translation_id_214, p0_.main_media_id AS main_media_id_215, p0_.main_media_hover_id AS main_media_hover_id_216, c1_.parent_id AS parent_id_217, c1_.media_id AS media_id_218, c1_.language_id AS language_id_219, c1_.translation_id AS translation_id_220, p3_.modified_user_id AS modified_user_id_221, p3_.created_by_id AS created_by_id_222, p3_.measurement_unit_id AS measurement_unit_id_223, p3_.site_product_id AS site_product_id_224, p3_.storage_id AS storage_id_225, p3_.storage_element_id AS storage_element_id_226, p3_.language_id AS language_id_227, p3_.translation_id AS translation_id_228, p3_.main_media_id AS main_media_id_229, p3_.main_media_hover_id AS main_media_hover_id_230, p4_.modified_user_id AS modified_user_id_231, p4_.created_by_id AS created_by_id_232, p4_.measurement_unit_id AS measurement_unit_id_233, p4_.site_product_id AS site_product_id_234, p4_.storage_id AS storage_id_235, p4_.storage_element_id AS storage_element_id_236, p4_.language_id AS language_id_237, p4_.translation_id AS translation_id_238, p4_.main_media_id AS main_media_id_239, p4_.main_media_hover_id AS main_media_hover_id_240, m5_.product_id AS product_id_241, m5_.orders_id AS orders_id_242, m5_.users_id AS users_id_243, m5_.account_worker_id AS account_worker_id_244, m5_.form_answer_id AS form_answer_id_245, m5_.job_id AS job_id_246, m5_.resize_img_parent_id AS resize_img_parent_id_247, m6_.product_id AS product_id_248, m6_.orders_id AS orders_id_249, m6_.users_id AS users_id_250, m6_.account_worker_id AS account_worker_id_251, m6_.form_answer_id AS form_answer_id_252, m6_.job_id AS job_id_253, m6_.resize_img_parent_id AS resize_img_parent_id_254, m7_.product_id AS product_id_255, m7_.orders_id AS orders_id_256, m7_.users_id AS users_id_257, m7_.account_worker_id AS account_worker_id_258, m7_.form_answer_id AS form_answer_id_259, m7_.job_id AS job_id_260, m7_.resize_img_parent_id AS resize_img_parent_id_261, m8_.product_id AS product_id_262, m8_.orders_id AS orders_id_263, m8_.users_id AS users_id_264, m8_.account_worker_id AS account_worker_id_265, m8_.form_answer_id AS form_answer_id_266, m8_.job_id AS job_id_267, m8_.resize_img_parent_id AS resize_img_parent_id_268 FROM products p0_ INNER JOIN products_category p9_ ON p0_.id = p9_.products_id INNER JOIN category c1_ ON c1_.id = p9_.category_id LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id LEFT JOIN media_object m10_ ON p0_.id = m10_.product_id WHERE p0_.id IN (SELECT p11_.id FROM products p11_ INNER JOIN products_category p13_ ON p11_.id = p13_.products_id INNER JOIN category c12_ ON c12_.id = p13_.category_id WHERE p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND c12_.slug = 'novinki' AND p11_.show = 'true' AND p11_.discontinued = 'false') AND p0_.id IN (29180, 29181, 29182, 29217, 29214, 29206, 29179, 29216, 29177, 29221, 29218, 29204, 29154, 29207, 29205, 29215, 29213, 29212, 29187, 29220, 29191, 29192, 29201, 29183, 29184) ORDER BY p0_.name ASC, m10_.sort DESC, p0_.discontinued DESC;
|
27.91 ms
(15.56%)
|
204 |
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = 20412;
|
26.99 ms
(15.05%)
|
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, c1_.id AS id_50, c1_.date_entered AS date_entered_51, c1_.date_modified AS date_modified_52, c1_.created_by AS created_by_53, c1_.modified_user_id AS modified_user_id_54, c1_.name AS name_55, c1_.slug AS slug_56, c1_.status AS status_57, c1_.description AS description_58, c1_.main AS main_59, c1_.type AS type_60, c1_.product_cnt AS product_cnt_61, c1_.site_product_cnt AS site_product_cnt_62, c1_.sort AS sort_63, c1_.seo_title AS seo_title_64, c1_.seo_description AS seo_description_65, m2_.id AS id_66, m2_.short_name AS short_name_67, m2_.name AS name_68, m2_.date_entered AS date_entered_69, m2_.date_modified AS date_modified_70, m2_.created_by AS created_by_71, m2_.modified_user_id AS modified_user_id_72, m2_.description AS description_73, m2_.code1c AS code1c_74, p3_.id AS id_75, p3_.name AS name_76, p3_.date_entered AS date_entered_77, p3_.date_modified AS date_modified_78, p3_.description AS description_79, p3_.code1c AS code1c_80, p3_.barcode AS barcode_81, p3_.status AS status_82, p3_.price AS price_83, p3_.price_income AS price_income_84, p3_.mark_up AS mark_up_85, p3_.min_mark_up AS min_mark_up_86, p3_.packing_type AS packing_type_87, p3_.packing_type_count AS packing_type_count_88, p3_.discounts AS discounts_89, p3_.count_order AS count_order_90, p3_.product_to_order AS product_to_order_91, p3_.article AS article_92, p3_.nds AS nds_93, p3_.service AS service_94, p3_.transport_service AS transport_service_95, p3_.exise AS exise_96, p3_.expiration_date AS expiration_date_97, p3_.unit_volume AS unit_volume_98, p3_.net_weight AS net_weight_99, p3_.gross_weight AS gross_weight_100, p3_.go_by_weight AS go_by_weight_101, p3_.packaging AS packaging_102, p3_.old_code AS old_code_103, p3_.show AS show_104, p3_.balance AS balance_105, p3_.deleted AS deleted_106, p3_.category_cnt AS category_cnt_107, p3_.price_category AS price_category_108, p3_.is_salle AS is_salle_109, p3_.is_new AS is_new_110, p3_.is_top AS is_top_111, p3_.old_price AS old_price_112, p3_.discount_percent AS discount_percent_113, p3_.date_last_price_income AS date_last_price_income_114, p3_.video AS video_115, p3_.is_video AS is_video_116, p3_.is_free_shipping AS is_free_shipping_117, p3_.warranty_period AS warranty_period_118, p3_.min_balance AS min_balance_119, p3_.min_balance_admin AS min_balance_admin_120, p3_.main_category_id AS main_category_id_121, p3_.discontinued AS discontinued_122, p3_.seo_title AS seo_title_123, p3_.seo_description AS seo_description_124, p4_.id AS id_125, p4_.name AS name_126, p4_.date_entered AS date_entered_127, p4_.date_modified AS date_modified_128, p4_.description AS description_129, p4_.code1c AS code1c_130, p4_.barcode AS barcode_131, p4_.status AS status_132, p4_.price AS price_133, p4_.price_income AS price_income_134, p4_.mark_up AS mark_up_135, p4_.min_mark_up AS min_mark_up_136, p4_.packing_type AS packing_type_137, p4_.packing_type_count AS packing_type_count_138, p4_.discounts AS discounts_139, p4_.count_order AS count_order_140, p4_.product_to_order AS product_to_order_141, p4_.article AS article_142, p4_.nds AS nds_143, p4_.service AS service_144, p4_.transport_service AS transport_service_145, p4_.exise AS exise_146, p4_.expiration_date AS expiration_date_147, p4_.unit_volume AS unit_volume_148, p4_.net_weight AS net_weight_149, p4_.gross_weight AS gross_weight_150, p4_.go_by_weight AS go_by_weight_151, p4_.packaging AS packaging_152, p4_.old_code AS old_code_153, p4_.show AS show_154, p4_.balance AS balance_155, p4_.deleted AS deleted_156, p4_.category_cnt AS category_cnt_157, p4_.price_category AS price_category_158, p4_.is_salle AS is_salle_159, p4_.is_new AS is_new_160, p4_.is_top AS is_top_161, p4_.old_price AS old_price_162, p4_.discount_percent AS discount_percent_163, p4_.date_last_price_income AS date_last_price_income_164, p4_.video AS video_165, p4_.is_video AS is_video_166, p4_.is_free_shipping AS is_free_shipping_167, p4_.warranty_period AS warranty_period_168, p4_.min_balance AS min_balance_169, p4_.min_balance_admin AS min_balance_admin_170, p4_.main_category_id AS main_category_id_171, p4_.discontinued AS discontinued_172, p4_.seo_title AS seo_title_173, p4_.seo_description AS seo_description_174, m5_.id AS id_175, m5_.upload_timestamp AS upload_timestamp_176, m5_.main AS main_177, m5_.file_path AS file_path_178, m5_.type AS type_179, m5_.name AS name_180, m5_.size AS size_181, m5_.sort AS sort_182, m6_.id AS id_183, m6_.upload_timestamp AS upload_timestamp_184, m6_.main AS main_185, m6_.file_path AS file_path_186, m6_.type AS type_187, m6_.name AS name_188, m6_.size AS size_189, m6_.sort AS sort_190, m7_.id AS id_191, m7_.upload_timestamp AS upload_timestamp_192, m7_.main AS main_193, m7_.file_path AS file_path_194, m7_.type AS type_195, m7_.name AS name_196, m7_.size AS size_197, m7_.sort AS sort_198, m8_.id AS id_199, m8_.upload_timestamp AS upload_timestamp_200, m8_.main AS main_201, m8_.file_path AS file_path_202, m8_.type AS type_203, m8_.name AS name_204, m8_.size AS size_205, m8_.sort AS sort_206 FROM products p0_ INNER JOIN products_category p9_ ON p0_.id = p9_.products_id INNER JOIN category c1_ ON c1_.id = p9_.category_id LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id LEFT JOIN media_object m10_ ON p0_.id = m10_.product_id WHERE p0_.id IN (SELECT p11_.id FROM products p11_ INNER JOIN products_category p13_ ON p11_.id = p13_.products_id INNER JOIN category c12_ ON c12_.id = p13_.category_id WHERE p11_.deleted = ? AND p11_.deleted = ? AND p11_.deleted = ? AND p11_.deleted = ? AND c12_.slug = ? AND p11_.show = ? AND p11_.discontinued = ?) ORDER BY p0_.name ASC, m10_.sort DESC, p0_.discontinued DESC) dctrn_result) dctrn_table
Parameters: [
0
0
0
0
"novinki"
"true"
"false"
]
SELECT
COUNT(*) AS dctrn_count
FROM
(
SELECT
DISTINCT id_0
FROM
(
SELECT
p0_.id AS id_0,
p0_.name AS name_1,
p0_.date_entered AS date_entered_2,
p0_.date_modified AS date_modified_3,
p0_.description AS description_4,
p0_.code1c AS code1c_5,
p0_.barcode AS barcode_6,
p0_.status AS status_7,
p0_.price AS price_8,
p0_.price_income AS price_income_9,
p0_.mark_up AS mark_up_10,
p0_.min_mark_up AS min_mark_up_11,
p0_.packing_type AS packing_type_12,
p0_.packing_type_count AS packing_type_count_13,
p0_.discounts AS discounts_14,
p0_.count_order AS count_order_15,
p0_.product_to_order AS product_to_order_16,
p0_.article AS article_17,
p0_.nds AS nds_18,
p0_.service AS service_19,
p0_.transport_service AS transport_service_20,
p0_.exise AS exise_21,
p0_.expiration_date AS expiration_date_22,
p0_.unit_volume AS unit_volume_23,
p0_.net_weight AS net_weight_24,
p0_.gross_weight AS gross_weight_25,
p0_.go_by_weight AS go_by_weight_26,
p0_.packaging AS packaging_27,
p0_.old_code AS old_code_28,
p0_.show AS show_29,
p0_.balance AS balance_30,
p0_.deleted AS deleted_31,
p0_.category_cnt AS category_cnt_32,
p0_.price_category AS price_category_33,
p0_.is_salle AS is_salle_34,
p0_.is_new AS is_new_35,
p0_.is_top AS is_top_36,
p0_.old_price AS old_price_37,
p0_.discount_percent AS discount_percent_38,
p0_.date_last_price_income AS date_last_price_income_39,
p0_.video AS video_40,
p0_.is_video AS is_video_41,
p0_.is_free_shipping AS is_free_shipping_42,
p0_.warranty_period AS warranty_period_43,
p0_.min_balance AS min_balance_44,
p0_.min_balance_admin AS min_balance_admin_45,
p0_.main_category_id AS main_category_id_46,
p0_.discontinued AS discontinued_47,
p0_.seo_title AS seo_title_48,
p0_.seo_description AS seo_description_49,
c1_.id AS id_50,
c1_.date_entered AS date_entered_51,
c1_.date_modified AS date_modified_52,
c1_.created_by AS created_by_53,
c1_.modified_user_id AS modified_user_id_54,
c1_.name AS name_55,
c1_.slug AS slug_56,
c1_.status AS status_57,
c1_.description AS description_58,
c1_.main AS main_59,
c1_.type AS type_60,
c1_.product_cnt AS product_cnt_61,
c1_.site_product_cnt AS site_product_cnt_62,
c1_.sort AS sort_63,
c1_.seo_title AS seo_title_64,
c1_.seo_description AS seo_description_65,
m2_.id AS id_66,
m2_.short_name AS short_name_67,
m2_.name AS name_68,
m2_.date_entered AS date_entered_69,
m2_.date_modified AS date_modified_70,
m2_.created_by AS created_by_71,
m2_.modified_user_id AS modified_user_id_72,
m2_.description AS description_73,
m2_.code1c AS code1c_74,
p3_.id AS id_75,
p3_.name AS name_76,
p3_.date_entered AS date_entered_77,
p3_.date_modified AS date_modified_78,
p3_.description AS description_79,
p3_.code1c AS code1c_80,
p3_.barcode AS barcode_81,
p3_.status AS status_82,
p3_.price AS price_83,
p3_.price_income AS price_income_84,
p3_.mark_up AS mark_up_85,
p3_.min_mark_up AS min_mark_up_86,
p3_.packing_type AS packing_type_87,
p3_.packing_type_count AS packing_type_count_88,
p3_.discounts AS discounts_89,
p3_.count_order AS count_order_90,
p3_.product_to_order AS product_to_order_91,
p3_.article AS article_92,
p3_.nds AS nds_93,
p3_.service AS service_94,
p3_.transport_service AS transport_service_95,
p3_.exise AS exise_96,
p3_.expiration_date AS expiration_date_97,
p3_.unit_volume AS unit_volume_98,
p3_.net_weight AS net_weight_99,
p3_.gross_weight AS gross_weight_100,
p3_.go_by_weight AS go_by_weight_101,
p3_.packaging AS packaging_102,
p3_.old_code AS old_code_103,
p3_.show AS show_104,
p3_.balance AS balance_105,
p3_.deleted AS deleted_106,
p3_.category_cnt AS category_cnt_107,
p3_.price_category AS price_category_108,
p3_.is_salle AS is_salle_109,
p3_.is_new AS is_new_110,
p3_.is_top AS is_top_111,
p3_.old_price AS old_price_112,
p3_.discount_percent AS discount_percent_113,
p3_.date_last_price_income AS date_last_price_income_114,
p3_.video AS video_115,
p3_.is_video AS is_video_116,
p3_.is_free_shipping AS is_free_shipping_117,
p3_.warranty_period AS warranty_period_118,
p3_.min_balance AS min_balance_119,
p3_.min_balance_admin AS min_balance_admin_120,
p3_.main_category_id AS main_category_id_121,
p3_.discontinued AS discontinued_122,
p3_.seo_title AS seo_title_123,
p3_.seo_description AS seo_description_124,
p4_.id AS id_125,
p4_.name AS name_126,
p4_.date_entered AS date_entered_127,
p4_.date_modified AS date_modified_128,
p4_.description AS description_129,
p4_.code1c AS code1c_130,
p4_.barcode AS barcode_131,
p4_.status AS status_132,
p4_.price AS price_133,
p4_.price_income AS price_income_134,
p4_.mark_up AS mark_up_135,
p4_.min_mark_up AS min_mark_up_136,
p4_.packing_type AS packing_type_137,
p4_.packing_type_count AS packing_type_count_138,
p4_.discounts AS discounts_139,
p4_.count_order AS count_order_140,
p4_.product_to_order AS product_to_order_141,
p4_.article AS article_142,
p4_.nds AS nds_143,
p4_.service AS service_144,
p4_.transport_service AS transport_service_145,
p4_.exise AS exise_146,
p4_.expiration_date AS expiration_date_147,
p4_.unit_volume AS unit_volume_148,
p4_.net_weight AS net_weight_149,
p4_.gross_weight AS gross_weight_150,
p4_.go_by_weight AS go_by_weight_151,
p4_.packaging AS packaging_152,
p4_.old_code AS old_code_153,
p4_.show AS show_154,
p4_.balance AS balance_155,
p4_.deleted AS deleted_156,
p4_.category_cnt AS category_cnt_157,
p4_.price_category AS price_category_158,
p4_.is_salle AS is_salle_159,
p4_.is_new AS is_new_160,
p4_.is_top AS is_top_161,
p4_.old_price AS old_price_162,
p4_.discount_percent AS discount_percent_163,
p4_.date_last_price_income AS date_last_price_income_164,
p4_.video AS video_165,
p4_.is_video AS is_video_166,
p4_.is_free_shipping AS is_free_shipping_167,
p4_.warranty_period AS warranty_period_168,
p4_.min_balance AS min_balance_169,
p4_.min_balance_admin AS min_balance_admin_170,
p4_.main_category_id AS main_category_id_171,
p4_.discontinued AS discontinued_172,
p4_.seo_title AS seo_title_173,
p4_.seo_description AS seo_description_174,
m5_.id AS id_175,
m5_.upload_timestamp AS upload_timestamp_176,
m5_.main AS main_177,
m5_.file_path AS file_path_178,
m5_.type AS type_179,
m5_.name AS name_180,
m5_.size AS size_181,
m5_.sort AS sort_182,
m6_.id AS id_183,
m6_.upload_timestamp AS upload_timestamp_184,
m6_.main AS main_185,
m6_.file_path AS file_path_186,
m6_.type AS type_187,
m6_.name AS name_188,
m6_.size AS size_189,
m6_.sort AS sort_190,
m7_.id AS id_191,
m7_.upload_timestamp AS upload_timestamp_192,
m7_.main AS main_193,
m7_.file_path AS file_path_194,
m7_.type AS type_195,
m7_.name AS name_196,
m7_.size AS size_197,
m7_.sort AS sort_198,
m8_.id AS id_199,
m8_.upload_timestamp AS upload_timestamp_200,
m8_.main AS main_201,
m8_.file_path AS file_path_202,
m8_.type AS type_203,
m8_.name AS name_204,
m8_.size AS size_205,
m8_.sort AS sort_206
FROM
products p0_
INNER JOIN products_category p9_ ON p0_.id = p9_.products_id
INNER JOIN category c1_ ON c1_.id = p9_.category_id
LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id
LEFT JOIN products p3_ ON p0_.translation_id = p3_.id
LEFT JOIN products p4_ ON p0_.id = p4_.translation_id
LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id
LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id
LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id
LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id
LEFT JOIN media_object m10_ ON p0_.id = m10_.product_id
WHERE
p0_.id IN (
SELECT
p11_.id
FROM
products p11_
INNER JOIN products_category p13_ ON p11_.id = p13_.products_id
INNER JOIN category c12_ ON c12_.id = p13_.category_id
WHERE
p11_.deleted = ?
AND p11_.deleted = ?
AND p11_.deleted = ?
AND p11_.deleted = ?
AND c12_.slug = ?
AND p11_.show = ?
AND p11_.discontinued = ?
)
ORDER BY
p0_.name ASC,
m10_.sort DESC,
p0_.discontinued DESC
) dctrn_result
) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, c1_.id AS id_50, c1_.date_entered AS date_entered_51, c1_.date_modified AS date_modified_52, c1_.created_by AS created_by_53, c1_.modified_user_id AS modified_user_id_54, c1_.name AS name_55, c1_.slug AS slug_56, c1_.status AS status_57, c1_.description AS description_58, c1_.main AS main_59, c1_.type AS type_60, c1_.product_cnt AS product_cnt_61, c1_.site_product_cnt AS site_product_cnt_62, c1_.sort AS sort_63, c1_.seo_title AS seo_title_64, c1_.seo_description AS seo_description_65, m2_.id AS id_66, m2_.short_name AS short_name_67, m2_.name AS name_68, m2_.date_entered AS date_entered_69, m2_.date_modified AS date_modified_70, m2_.created_by AS created_by_71, m2_.modified_user_id AS modified_user_id_72, m2_.description AS description_73, m2_.code1c AS code1c_74, p3_.id AS id_75, p3_.name AS name_76, p3_.date_entered AS date_entered_77, p3_.date_modified AS date_modified_78, p3_.description AS description_79, p3_.code1c AS code1c_80, p3_.barcode AS barcode_81, p3_.status AS status_82, p3_.price AS price_83, p3_.price_income AS price_income_84, p3_.mark_up AS mark_up_85, p3_.min_mark_up AS min_mark_up_86, p3_.packing_type AS packing_type_87, p3_.packing_type_count AS packing_type_count_88, p3_.discounts AS discounts_89, p3_.count_order AS count_order_90, p3_.product_to_order AS product_to_order_91, p3_.article AS article_92, p3_.nds AS nds_93, p3_.service AS service_94, p3_.transport_service AS transport_service_95, p3_.exise AS exise_96, p3_.expiration_date AS expiration_date_97, p3_.unit_volume AS unit_volume_98, p3_.net_weight AS net_weight_99, p3_.gross_weight AS gross_weight_100, p3_.go_by_weight AS go_by_weight_101, p3_.packaging AS packaging_102, p3_.old_code AS old_code_103, p3_.show AS show_104, p3_.balance AS balance_105, p3_.deleted AS deleted_106, p3_.category_cnt AS category_cnt_107, p3_.price_category AS price_category_108, p3_.is_salle AS is_salle_109, p3_.is_new AS is_new_110, p3_.is_top AS is_top_111, p3_.old_price AS old_price_112, p3_.discount_percent AS discount_percent_113, p3_.date_last_price_income AS date_last_price_income_114, p3_.video AS video_115, p3_.is_video AS is_video_116, p3_.is_free_shipping AS is_free_shipping_117, p3_.warranty_period AS warranty_period_118, p3_.min_balance AS min_balance_119, p3_.min_balance_admin AS min_balance_admin_120, p3_.main_category_id AS main_category_id_121, p3_.discontinued AS discontinued_122, p3_.seo_title AS seo_title_123, p3_.seo_description AS seo_description_124, p4_.id AS id_125, p4_.name AS name_126, p4_.date_entered AS date_entered_127, p4_.date_modified AS date_modified_128, p4_.description AS description_129, p4_.code1c AS code1c_130, p4_.barcode AS barcode_131, p4_.status AS status_132, p4_.price AS price_133, p4_.price_income AS price_income_134, p4_.mark_up AS mark_up_135, p4_.min_mark_up AS min_mark_up_136, p4_.packing_type AS packing_type_137, p4_.packing_type_count AS packing_type_count_138, p4_.discounts AS discounts_139, p4_.count_order AS count_order_140, p4_.product_to_order AS product_to_order_141, p4_.article AS article_142, p4_.nds AS nds_143, p4_.service AS service_144, p4_.transport_service AS transport_service_145, p4_.exise AS exise_146, p4_.expiration_date AS expiration_date_147, p4_.unit_volume AS unit_volume_148, p4_.net_weight AS net_weight_149, p4_.gross_weight AS gross_weight_150, p4_.go_by_weight AS go_by_weight_151, p4_.packaging AS packaging_152, p4_.old_code AS old_code_153, p4_.show AS show_154, p4_.balance AS balance_155, p4_.deleted AS deleted_156, p4_.category_cnt AS category_cnt_157, p4_.price_category AS price_category_158, p4_.is_salle AS is_salle_159, p4_.is_new AS is_new_160, p4_.is_top AS is_top_161, p4_.old_price AS old_price_162, p4_.discount_percent AS discount_percent_163, p4_.date_last_price_income AS date_last_price_income_164, p4_.video AS video_165, p4_.is_video AS is_video_166, p4_.is_free_shipping AS is_free_shipping_167, p4_.warranty_period AS warranty_period_168, p4_.min_balance AS min_balance_169, p4_.min_balance_admin AS min_balance_admin_170, p4_.main_category_id AS main_category_id_171, p4_.discontinued AS discontinued_172, p4_.seo_title AS seo_title_173, p4_.seo_description AS seo_description_174, m5_.id AS id_175, m5_.upload_timestamp AS upload_timestamp_176, m5_.main AS main_177, m5_.file_path AS file_path_178, m5_.type AS type_179, m5_.name AS name_180, m5_.size AS size_181, m5_.sort AS sort_182, m6_.id AS id_183, m6_.upload_timestamp AS upload_timestamp_184, m6_.main AS main_185, m6_.file_path AS file_path_186, m6_.type AS type_187, m6_.name AS name_188, m6_.size AS size_189, m6_.sort AS sort_190, m7_.id AS id_191, m7_.upload_timestamp AS upload_timestamp_192, m7_.main AS main_193, m7_.file_path AS file_path_194, m7_.type AS type_195, m7_.name AS name_196, m7_.size AS size_197, m7_.sort AS sort_198, m8_.id AS id_199, m8_.upload_timestamp AS upload_timestamp_200, m8_.main AS main_201, m8_.file_path AS file_path_202, m8_.type AS type_203, m8_.name AS name_204, m8_.size AS size_205, m8_.sort AS sort_206 FROM products p0_ INNER JOIN products_category p9_ ON p0_.id = p9_.products_id INNER JOIN category c1_ ON c1_.id = p9_.category_id LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id LEFT JOIN media_object m10_ ON p0_.id = m10_.product_id WHERE p0_.id IN (SELECT p11_.id FROM products p11_ INNER JOIN products_category p13_ ON p11_.id = p13_.products_id INNER JOIN category c12_ ON c12_.id = p13_.category_id WHERE p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND c12_.slug = 'novinki' AND p11_.show = 'true' AND p11_.discontinued = 'false') ORDER BY p0_.name ASC, m10_.sort DESC, p0_.discontinued DESC) dctrn_result) dctrn_table;
|
16.44 ms
(9.17%)
|
1 |
SELECT DISTINCT id_0, MIN(sclr_207) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, c1_.id AS id_50, c1_.date_entered AS date_entered_51, c1_.date_modified AS date_modified_52, c1_.created_by AS created_by_53, c1_.modified_user_id AS modified_user_id_54, c1_.name AS name_55, c1_.slug AS slug_56, c1_.status AS status_57, c1_.description AS description_58, c1_.main AS main_59, c1_.type AS type_60, c1_.product_cnt AS product_cnt_61, c1_.site_product_cnt AS site_product_cnt_62, c1_.sort AS sort_63, c1_.seo_title AS seo_title_64, c1_.seo_description AS seo_description_65, m2_.id AS id_66, m2_.short_name AS short_name_67, m2_.name AS name_68, m2_.date_entered AS date_entered_69, m2_.date_modified AS date_modified_70, m2_.created_by AS created_by_71, m2_.modified_user_id AS modified_user_id_72, m2_.description AS description_73, m2_.code1c AS code1c_74, p3_.id AS id_75, p3_.name AS name_76, p3_.date_entered AS date_entered_77, p3_.date_modified AS date_modified_78, p3_.description AS description_79, p3_.code1c AS code1c_80, p3_.barcode AS barcode_81, p3_.status AS status_82, p3_.price AS price_83, p3_.price_income AS price_income_84, p3_.mark_up AS mark_up_85, p3_.min_mark_up AS min_mark_up_86, p3_.packing_type AS packing_type_87, p3_.packing_type_count AS packing_type_count_88, p3_.discounts AS discounts_89, p3_.count_order AS count_order_90, p3_.product_to_order AS product_to_order_91, p3_.article AS article_92, p3_.nds AS nds_93, p3_.service AS service_94, p3_.transport_service AS transport_service_95, p3_.exise AS exise_96, p3_.expiration_date AS expiration_date_97, p3_.unit_volume AS unit_volume_98, p3_.net_weight AS net_weight_99, p3_.gross_weight AS gross_weight_100, p3_.go_by_weight AS go_by_weight_101, p3_.packaging AS packaging_102, p3_.old_code AS old_code_103, p3_.show AS show_104, p3_.balance AS balance_105, p3_.deleted AS deleted_106, p3_.category_cnt AS category_cnt_107, p3_.price_category AS price_category_108, p3_.is_salle AS is_salle_109, p3_.is_new AS is_new_110, p3_.is_top AS is_top_111, p3_.old_price AS old_price_112, p3_.discount_percent AS discount_percent_113, p3_.date_last_price_income AS date_last_price_income_114, p3_.video AS video_115, p3_.is_video AS is_video_116, p3_.is_free_shipping AS is_free_shipping_117, p3_.warranty_period AS warranty_period_118, p3_.min_balance AS min_balance_119, p3_.min_balance_admin AS min_balance_admin_120, p3_.main_category_id AS main_category_id_121, p3_.discontinued AS discontinued_122, p3_.seo_title AS seo_title_123, p3_.seo_description AS seo_description_124, p4_.id AS id_125, p4_.name AS name_126, p4_.date_entered AS date_entered_127, p4_.date_modified AS date_modified_128, p4_.description AS description_129, p4_.code1c AS code1c_130, p4_.barcode AS barcode_131, p4_.status AS status_132, p4_.price AS price_133, p4_.price_income AS price_income_134, p4_.mark_up AS mark_up_135, p4_.min_mark_up AS min_mark_up_136, p4_.packing_type AS packing_type_137, p4_.packing_type_count AS packing_type_count_138, p4_.discounts AS discounts_139, p4_.count_order AS count_order_140, p4_.product_to_order AS product_to_order_141, p4_.article AS article_142, p4_.nds AS nds_143, p4_.service AS service_144, p4_.transport_service AS transport_service_145, p4_.exise AS exise_146, p4_.expiration_date AS expiration_date_147, p4_.unit_volume AS unit_volume_148, p4_.net_weight AS net_weight_149, p4_.gross_weight AS gross_weight_150, p4_.go_by_weight AS go_by_weight_151, p4_.packaging AS packaging_152, p4_.old_code AS old_code_153, p4_.show AS show_154, p4_.balance AS balance_155, p4_.deleted AS deleted_156, p4_.category_cnt AS category_cnt_157, p4_.price_category AS price_category_158, p4_.is_salle AS is_salle_159, p4_.is_new AS is_new_160, p4_.is_top AS is_top_161, p4_.old_price AS old_price_162, p4_.discount_percent AS discount_percent_163, p4_.date_last_price_income AS date_last_price_income_164, p4_.video AS video_165, p4_.is_video AS is_video_166, p4_.is_free_shipping AS is_free_shipping_167, p4_.warranty_period AS warranty_period_168, p4_.min_balance AS min_balance_169, p4_.min_balance_admin AS min_balance_admin_170, p4_.main_category_id AS main_category_id_171, p4_.discontinued AS discontinued_172, p4_.seo_title AS seo_title_173, p4_.seo_description AS seo_description_174, m5_.id AS id_175, m5_.upload_timestamp AS upload_timestamp_176, m5_.main AS main_177, m5_.file_path AS file_path_178, m5_.type AS type_179, m5_.name AS name_180, m5_.size AS size_181, m5_.sort AS sort_182, m6_.id AS id_183, m6_.upload_timestamp AS upload_timestamp_184, m6_.main AS main_185, m6_.file_path AS file_path_186, m6_.type AS type_187, m6_.name AS name_188, m6_.size AS size_189, m6_.sort AS sort_190, m7_.id AS id_191, m7_.upload_timestamp AS upload_timestamp_192, m7_.main AS main_193, m7_.file_path AS file_path_194, m7_.type AS type_195, m7_.name AS name_196, m7_.size AS size_197, m7_.sort AS sort_198, m8_.id AS id_199, m8_.upload_timestamp AS upload_timestamp_200, m8_.main AS main_201, m8_.file_path AS file_path_202, m8_.type AS type_203, m8_.name AS name_204, m8_.size AS size_205, m8_.sort AS sort_206, ROW_NUMBER() OVER(ORDER BY p0_.name ASC, m9_.sort DESC, p0_.discontinued DESC) AS sclr_207 FROM products p0_ INNER JOIN products_category p10_ ON p0_.id = p10_.products_id INNER JOIN category c1_ ON c1_.id = p10_.category_id LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id LEFT JOIN media_object m9_ ON p0_.id = m9_.product_id WHERE p0_.id IN (SELECT p11_.id FROM products p11_ INNER JOIN products_category p13_ ON p11_.id = p13_.products_id INNER JOIN category c12_ ON c12_.id = p13_.category_id WHERE p11_.deleted = ? AND p11_.deleted = ? AND p11_.deleted = ? AND p11_.deleted = ? AND c12_.slug = ? AND p11_.show = ? AND p11_.discontinued = ?)) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 30
Parameters: [
0
0
0
0
"novinki"
"true"
"false"
]
SELECT
DISTINCT id_0,
MIN(sclr_207) AS dctrn_minrownum
FROM
(
SELECT
p0_.id AS id_0,
p0_.name AS name_1,
p0_.date_entered AS date_entered_2,
p0_.date_modified AS date_modified_3,
p0_.description AS description_4,
p0_.code1c AS code1c_5,
p0_.barcode AS barcode_6,
p0_.status AS status_7,
p0_.price AS price_8,
p0_.price_income AS price_income_9,
p0_.mark_up AS mark_up_10,
p0_.min_mark_up AS min_mark_up_11,
p0_.packing_type AS packing_type_12,
p0_.packing_type_count AS packing_type_count_13,
p0_.discounts AS discounts_14,
p0_.count_order AS count_order_15,
p0_.product_to_order AS product_to_order_16,
p0_.article AS article_17,
p0_.nds AS nds_18,
p0_.service AS service_19,
p0_.transport_service AS transport_service_20,
p0_.exise AS exise_21,
p0_.expiration_date AS expiration_date_22,
p0_.unit_volume AS unit_volume_23,
p0_.net_weight AS net_weight_24,
p0_.gross_weight AS gross_weight_25,
p0_.go_by_weight AS go_by_weight_26,
p0_.packaging AS packaging_27,
p0_.old_code AS old_code_28,
p0_.show AS show_29,
p0_.balance AS balance_30,
p0_.deleted AS deleted_31,
p0_.category_cnt AS category_cnt_32,
p0_.price_category AS price_category_33,
p0_.is_salle AS is_salle_34,
p0_.is_new AS is_new_35,
p0_.is_top AS is_top_36,
p0_.old_price AS old_price_37,
p0_.discount_percent AS discount_percent_38,
p0_.date_last_price_income AS date_last_price_income_39,
p0_.video AS video_40,
p0_.is_video AS is_video_41,
p0_.is_free_shipping AS is_free_shipping_42,
p0_.warranty_period AS warranty_period_43,
p0_.min_balance AS min_balance_44,
p0_.min_balance_admin AS min_balance_admin_45,
p0_.main_category_id AS main_category_id_46,
p0_.discontinued AS discontinued_47,
p0_.seo_title AS seo_title_48,
p0_.seo_description AS seo_description_49,
c1_.id AS id_50,
c1_.date_entered AS date_entered_51,
c1_.date_modified AS date_modified_52,
c1_.created_by AS created_by_53,
c1_.modified_user_id AS modified_user_id_54,
c1_.name AS name_55,
c1_.slug AS slug_56,
c1_.status AS status_57,
c1_.description AS description_58,
c1_.main AS main_59,
c1_.type AS type_60,
c1_.product_cnt AS product_cnt_61,
c1_.site_product_cnt AS site_product_cnt_62,
c1_.sort AS sort_63,
c1_.seo_title AS seo_title_64,
c1_.seo_description AS seo_description_65,
m2_.id AS id_66,
m2_.short_name AS short_name_67,
m2_.name AS name_68,
m2_.date_entered AS date_entered_69,
m2_.date_modified AS date_modified_70,
m2_.created_by AS created_by_71,
m2_.modified_user_id AS modified_user_id_72,
m2_.description AS description_73,
m2_.code1c AS code1c_74,
p3_.id AS id_75,
p3_.name AS name_76,
p3_.date_entered AS date_entered_77,
p3_.date_modified AS date_modified_78,
p3_.description AS description_79,
p3_.code1c AS code1c_80,
p3_.barcode AS barcode_81,
p3_.status AS status_82,
p3_.price AS price_83,
p3_.price_income AS price_income_84,
p3_.mark_up AS mark_up_85,
p3_.min_mark_up AS min_mark_up_86,
p3_.packing_type AS packing_type_87,
p3_.packing_type_count AS packing_type_count_88,
p3_.discounts AS discounts_89,
p3_.count_order AS count_order_90,
p3_.product_to_order AS product_to_order_91,
p3_.article AS article_92,
p3_.nds AS nds_93,
p3_.service AS service_94,
p3_.transport_service AS transport_service_95,
p3_.exise AS exise_96,
p3_.expiration_date AS expiration_date_97,
p3_.unit_volume AS unit_volume_98,
p3_.net_weight AS net_weight_99,
p3_.gross_weight AS gross_weight_100,
p3_.go_by_weight AS go_by_weight_101,
p3_.packaging AS packaging_102,
p3_.old_code AS old_code_103,
p3_.show AS show_104,
p3_.balance AS balance_105,
p3_.deleted AS deleted_106,
p3_.category_cnt AS category_cnt_107,
p3_.price_category AS price_category_108,
p3_.is_salle AS is_salle_109,
p3_.is_new AS is_new_110,
p3_.is_top AS is_top_111,
p3_.old_price AS old_price_112,
p3_.discount_percent AS discount_percent_113,
p3_.date_last_price_income AS date_last_price_income_114,
p3_.video AS video_115,
p3_.is_video AS is_video_116,
p3_.is_free_shipping AS is_free_shipping_117,
p3_.warranty_period AS warranty_period_118,
p3_.min_balance AS min_balance_119,
p3_.min_balance_admin AS min_balance_admin_120,
p3_.main_category_id AS main_category_id_121,
p3_.discontinued AS discontinued_122,
p3_.seo_title AS seo_title_123,
p3_.seo_description AS seo_description_124,
p4_.id AS id_125,
p4_.name AS name_126,
p4_.date_entered AS date_entered_127,
p4_.date_modified AS date_modified_128,
p4_.description AS description_129,
p4_.code1c AS code1c_130,
p4_.barcode AS barcode_131,
p4_.status AS status_132,
p4_.price AS price_133,
p4_.price_income AS price_income_134,
p4_.mark_up AS mark_up_135,
p4_.min_mark_up AS min_mark_up_136,
p4_.packing_type AS packing_type_137,
p4_.packing_type_count AS packing_type_count_138,
p4_.discounts AS discounts_139,
p4_.count_order AS count_order_140,
p4_.product_to_order AS product_to_order_141,
p4_.article AS article_142,
p4_.nds AS nds_143,
p4_.service AS service_144,
p4_.transport_service AS transport_service_145,
p4_.exise AS exise_146,
p4_.expiration_date AS expiration_date_147,
p4_.unit_volume AS unit_volume_148,
p4_.net_weight AS net_weight_149,
p4_.gross_weight AS gross_weight_150,
p4_.go_by_weight AS go_by_weight_151,
p4_.packaging AS packaging_152,
p4_.old_code AS old_code_153,
p4_.show AS show_154,
p4_.balance AS balance_155,
p4_.deleted AS deleted_156,
p4_.category_cnt AS category_cnt_157,
p4_.price_category AS price_category_158,
p4_.is_salle AS is_salle_159,
p4_.is_new AS is_new_160,
p4_.is_top AS is_top_161,
p4_.old_price AS old_price_162,
p4_.discount_percent AS discount_percent_163,
p4_.date_last_price_income AS date_last_price_income_164,
p4_.video AS video_165,
p4_.is_video AS is_video_166,
p4_.is_free_shipping AS is_free_shipping_167,
p4_.warranty_period AS warranty_period_168,
p4_.min_balance AS min_balance_169,
p4_.min_balance_admin AS min_balance_admin_170,
p4_.main_category_id AS main_category_id_171,
p4_.discontinued AS discontinued_172,
p4_.seo_title AS seo_title_173,
p4_.seo_description AS seo_description_174,
m5_.id AS id_175,
m5_.upload_timestamp AS upload_timestamp_176,
m5_.main AS main_177,
m5_.file_path AS file_path_178,
m5_.type AS type_179,
m5_.name AS name_180,
m5_.size AS size_181,
m5_.sort AS sort_182,
m6_.id AS id_183,
m6_.upload_timestamp AS upload_timestamp_184,
m6_.main AS main_185,
m6_.file_path AS file_path_186,
m6_.type AS type_187,
m6_.name AS name_188,
m6_.size AS size_189,
m6_.sort AS sort_190,
m7_.id AS id_191,
m7_.upload_timestamp AS upload_timestamp_192,
m7_.main AS main_193,
m7_.file_path AS file_path_194,
m7_.type AS type_195,
m7_.name AS name_196,
m7_.size AS size_197,
m7_.sort AS sort_198,
m8_.id AS id_199,
m8_.upload_timestamp AS upload_timestamp_200,
m8_.main AS main_201,
m8_.file_path AS file_path_202,
m8_.type AS type_203,
m8_.name AS name_204,
m8_.size AS size_205,
m8_.sort AS sort_206,
ROW_NUMBER() OVER(
ORDER BY
p0_.name ASC,
m9_.sort DESC,
p0_.discontinued DESC
) AS sclr_207
FROM
products p0_
INNER JOIN products_category p10_ ON p0_.id = p10_.products_id
INNER JOIN category c1_ ON c1_.id = p10_.category_id
LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id
LEFT JOIN products p3_ ON p0_.translation_id = p3_.id
LEFT JOIN products p4_ ON p0_.id = p4_.translation_id
LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id
LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id
LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id
LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id
LEFT JOIN media_object m9_ ON p0_.id = m9_.product_id
WHERE
p0_.id IN (
SELECT
p11_.id
FROM
products p11_
INNER JOIN products_category p13_ ON p11_.id = p13_.products_id
INNER JOIN category c12_ ON c12_.id = p13_.category_id
WHERE
p11_.deleted = ?
AND p11_.deleted = ?
AND p11_.deleted = ?
AND p11_.deleted = ?
AND c12_.slug = ?
AND p11_.show = ?
AND p11_.discontinued = ?
)
) dctrn_result
GROUP BY
id_0
ORDER BY
dctrn_minrownum ASC
LIMIT
30
SELECT DISTINCT id_0, MIN(sclr_207) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, c1_.id AS id_50, c1_.date_entered AS date_entered_51, c1_.date_modified AS date_modified_52, c1_.created_by AS created_by_53, c1_.modified_user_id AS modified_user_id_54, c1_.name AS name_55, c1_.slug AS slug_56, c1_.status AS status_57, c1_.description AS description_58, c1_.main AS main_59, c1_.type AS type_60, c1_.product_cnt AS product_cnt_61, c1_.site_product_cnt AS site_product_cnt_62, c1_.sort AS sort_63, c1_.seo_title AS seo_title_64, c1_.seo_description AS seo_description_65, m2_.id AS id_66, m2_.short_name AS short_name_67, m2_.name AS name_68, m2_.date_entered AS date_entered_69, m2_.date_modified AS date_modified_70, m2_.created_by AS created_by_71, m2_.modified_user_id AS modified_user_id_72, m2_.description AS description_73, m2_.code1c AS code1c_74, p3_.id AS id_75, p3_.name AS name_76, p3_.date_entered AS date_entered_77, p3_.date_modified AS date_modified_78, p3_.description AS description_79, p3_.code1c AS code1c_80, p3_.barcode AS barcode_81, p3_.status AS status_82, p3_.price AS price_83, p3_.price_income AS price_income_84, p3_.mark_up AS mark_up_85, p3_.min_mark_up AS min_mark_up_86, p3_.packing_type AS packing_type_87, p3_.packing_type_count AS packing_type_count_88, p3_.discounts AS discounts_89, p3_.count_order AS count_order_90, p3_.product_to_order AS product_to_order_91, p3_.article AS article_92, p3_.nds AS nds_93, p3_.service AS service_94, p3_.transport_service AS transport_service_95, p3_.exise AS exise_96, p3_.expiration_date AS expiration_date_97, p3_.unit_volume AS unit_volume_98, p3_.net_weight AS net_weight_99, p3_.gross_weight AS gross_weight_100, p3_.go_by_weight AS go_by_weight_101, p3_.packaging AS packaging_102, p3_.old_code AS old_code_103, p3_.show AS show_104, p3_.balance AS balance_105, p3_.deleted AS deleted_106, p3_.category_cnt AS category_cnt_107, p3_.price_category AS price_category_108, p3_.is_salle AS is_salle_109, p3_.is_new AS is_new_110, p3_.is_top AS is_top_111, p3_.old_price AS old_price_112, p3_.discount_percent AS discount_percent_113, p3_.date_last_price_income AS date_last_price_income_114, p3_.video AS video_115, p3_.is_video AS is_video_116, p3_.is_free_shipping AS is_free_shipping_117, p3_.warranty_period AS warranty_period_118, p3_.min_balance AS min_balance_119, p3_.min_balance_admin AS min_balance_admin_120, p3_.main_category_id AS main_category_id_121, p3_.discontinued AS discontinued_122, p3_.seo_title AS seo_title_123, p3_.seo_description AS seo_description_124, p4_.id AS id_125, p4_.name AS name_126, p4_.date_entered AS date_entered_127, p4_.date_modified AS date_modified_128, p4_.description AS description_129, p4_.code1c AS code1c_130, p4_.barcode AS barcode_131, p4_.status AS status_132, p4_.price AS price_133, p4_.price_income AS price_income_134, p4_.mark_up AS mark_up_135, p4_.min_mark_up AS min_mark_up_136, p4_.packing_type AS packing_type_137, p4_.packing_type_count AS packing_type_count_138, p4_.discounts AS discounts_139, p4_.count_order AS count_order_140, p4_.product_to_order AS product_to_order_141, p4_.article AS article_142, p4_.nds AS nds_143, p4_.service AS service_144, p4_.transport_service AS transport_service_145, p4_.exise AS exise_146, p4_.expiration_date AS expiration_date_147, p4_.unit_volume AS unit_volume_148, p4_.net_weight AS net_weight_149, p4_.gross_weight AS gross_weight_150, p4_.go_by_weight AS go_by_weight_151, p4_.packaging AS packaging_152, p4_.old_code AS old_code_153, p4_.show AS show_154, p4_.balance AS balance_155, p4_.deleted AS deleted_156, p4_.category_cnt AS category_cnt_157, p4_.price_category AS price_category_158, p4_.is_salle AS is_salle_159, p4_.is_new AS is_new_160, p4_.is_top AS is_top_161, p4_.old_price AS old_price_162, p4_.discount_percent AS discount_percent_163, p4_.date_last_price_income AS date_last_price_income_164, p4_.video AS video_165, p4_.is_video AS is_video_166, p4_.is_free_shipping AS is_free_shipping_167, p4_.warranty_period AS warranty_period_168, p4_.min_balance AS min_balance_169, p4_.min_balance_admin AS min_balance_admin_170, p4_.main_category_id AS main_category_id_171, p4_.discontinued AS discontinued_172, p4_.seo_title AS seo_title_173, p4_.seo_description AS seo_description_174, m5_.id AS id_175, m5_.upload_timestamp AS upload_timestamp_176, m5_.main AS main_177, m5_.file_path AS file_path_178, m5_.type AS type_179, m5_.name AS name_180, m5_.size AS size_181, m5_.sort AS sort_182, m6_.id AS id_183, m6_.upload_timestamp AS upload_timestamp_184, m6_.main AS main_185, m6_.file_path AS file_path_186, m6_.type AS type_187, m6_.name AS name_188, m6_.size AS size_189, m6_.sort AS sort_190, m7_.id AS id_191, m7_.upload_timestamp AS upload_timestamp_192, m7_.main AS main_193, m7_.file_path AS file_path_194, m7_.type AS type_195, m7_.name AS name_196, m7_.size AS size_197, m7_.sort AS sort_198, m8_.id AS id_199, m8_.upload_timestamp AS upload_timestamp_200, m8_.main AS main_201, m8_.file_path AS file_path_202, m8_.type AS type_203, m8_.name AS name_204, m8_.size AS size_205, m8_.sort AS sort_206, ROW_NUMBER() OVER(ORDER BY p0_.name ASC, m9_.sort DESC, p0_.discontinued DESC) AS sclr_207 FROM products p0_ INNER JOIN products_category p10_ ON p0_.id = p10_.products_id INNER JOIN category c1_ ON c1_.id = p10_.category_id LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id LEFT JOIN media_object m9_ ON p0_.id = m9_.product_id WHERE p0_.id IN (SELECT p11_.id FROM products p11_ INNER JOIN products_category p13_ ON p11_.id = p13_.products_id INNER JOIN category c12_ ON c12_.id = p13_.category_id WHERE p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND c12_.slug = 'novinki' AND p11_.show = 'true' AND p11_.discontinued = 'false')) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 30;
|