128.25 ms
(56.61%)
|
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, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, c1_.id AS id_52, c1_.date_entered AS date_entered_53, c1_.date_modified AS date_modified_54, c1_.created_by AS created_by_55, c1_.modified_user_id AS modified_user_id_56, c1_.name AS name_57, c1_.slug AS slug_58, c1_.status AS status_59, c1_.description AS description_60, c1_.main AS main_61, c1_.type AS type_62, c1_.product_cnt AS product_cnt_63, c1_.site_product_cnt AS site_product_cnt_64, c1_.sort AS sort_65, c1_.seo_title AS seo_title_66, c1_.seo_description AS seo_description_67, m2_.id AS id_68, m2_.short_name AS short_name_69, m2_.name AS name_70, m2_.date_entered AS date_entered_71, m2_.date_modified AS date_modified_72, m2_.created_by AS created_by_73, m2_.modified_user_id AS modified_user_id_74, m2_.description AS description_75, m2_.code1c AS code1c_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212, p0_.modified_user_id AS modified_user_id_213, p0_.created_by_id AS created_by_id_214, p0_.measurement_unit_id AS measurement_unit_id_215, p0_.site_product_id AS site_product_id_216, p0_.storage_id AS storage_id_217, p0_.storage_element_id AS storage_element_id_218, p0_.language_id AS language_id_219, p0_.translation_id AS translation_id_220, p0_.main_media_id AS main_media_id_221, p0_.main_media_hover_id AS main_media_hover_id_222, c1_.parent_id AS parent_id_223, c1_.media_id AS media_id_224, c1_.language_id AS language_id_225, c1_.translation_id AS translation_id_226, p3_.modified_user_id AS modified_user_id_227, p3_.created_by_id AS created_by_id_228, p3_.measurement_unit_id AS measurement_unit_id_229, p3_.site_product_id AS site_product_id_230, p3_.storage_id AS storage_id_231, p3_.storage_element_id AS storage_element_id_232, p3_.language_id AS language_id_233, p3_.translation_id AS translation_id_234, p3_.main_media_id AS main_media_id_235, p3_.main_media_hover_id AS main_media_hover_id_236, p4_.modified_user_id AS modified_user_id_237, p4_.created_by_id AS created_by_id_238, p4_.measurement_unit_id AS measurement_unit_id_239, p4_.site_product_id AS site_product_id_240, p4_.storage_id AS storage_id_241, p4_.storage_element_id AS storage_element_id_242, p4_.language_id AS language_id_243, p4_.translation_id AS translation_id_244, p4_.main_media_id AS main_media_id_245, p4_.main_media_hover_id AS main_media_hover_id_246, m5_.product_id AS product_id_247, m5_.orders_id AS orders_id_248, m5_.users_id AS users_id_249, m5_.account_worker_id AS account_worker_id_250, m5_.form_answer_id AS form_answer_id_251, m5_.job_id AS job_id_252, m5_.resize_img_parent_id AS resize_img_parent_id_253, m6_.product_id AS product_id_254, m6_.orders_id AS orders_id_255, m6_.users_id AS users_id_256, m6_.account_worker_id AS account_worker_id_257, m6_.form_answer_id AS form_answer_id_258, m6_.job_id AS job_id_259, m6_.resize_img_parent_id AS resize_img_parent_id_260, m7_.product_id AS product_id_261, m7_.orders_id AS orders_id_262, m7_.users_id AS users_id_263, m7_.account_worker_id AS account_worker_id_264, m7_.form_answer_id AS form_answer_id_265, m7_.job_id AS job_id_266, m7_.resize_img_parent_id AS resize_img_parent_id_267, m8_.product_id AS product_id_268, m8_.orders_id AS orders_id_269, m8_.users_id AS users_id_270, m8_.account_worker_id AS account_worker_id_271, m8_.form_answer_id AS form_answer_id_272, m8_.job_id AS job_id_273, m8_.resize_img_parent_id AS resize_img_parent_id_274 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
29223
29205
29215
29213
29212
29187
29220
29224
29225
29191
29192
29201
29183
29184
29226
]
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,
p0_.salle_price AS salle_price_50,
p0_.normal_price AS normal_price_51,
c1_.id AS id_52,
c1_.date_entered AS date_entered_53,
c1_.date_modified AS date_modified_54,
c1_.created_by AS created_by_55,
c1_.modified_user_id AS modified_user_id_56,
c1_.name AS name_57,
c1_.slug AS slug_58,
c1_.status AS status_59,
c1_.description AS description_60,
c1_.main AS main_61,
c1_.type AS type_62,
c1_.product_cnt AS product_cnt_63,
c1_.site_product_cnt AS site_product_cnt_64,
c1_.sort AS sort_65,
c1_.seo_title AS seo_title_66,
c1_.seo_description AS seo_description_67,
m2_.id AS id_68,
m2_.short_name AS short_name_69,
m2_.name AS name_70,
m2_.date_entered AS date_entered_71,
m2_.date_modified AS date_modified_72,
m2_.created_by AS created_by_73,
m2_.modified_user_id AS modified_user_id_74,
m2_.description AS description_75,
m2_.code1c AS code1c_76,
p3_.id AS id_77,
p3_.name AS name_78,
p3_.date_entered AS date_entered_79,
p3_.date_modified AS date_modified_80,
p3_.description AS description_81,
p3_.code1c AS code1c_82,
p3_.barcode AS barcode_83,
p3_.status AS status_84,
p3_.price AS price_85,
p3_.price_income AS price_income_86,
p3_.mark_up AS mark_up_87,
p3_.min_mark_up AS min_mark_up_88,
p3_.packing_type AS packing_type_89,
p3_.packing_type_count AS packing_type_count_90,
p3_.discounts AS discounts_91,
p3_.count_order AS count_order_92,
p3_.product_to_order AS product_to_order_93,
p3_.article AS article_94,
p3_.nds AS nds_95,
p3_.service AS service_96,
p3_.transport_service AS transport_service_97,
p3_.exise AS exise_98,
p3_.expiration_date AS expiration_date_99,
p3_.unit_volume AS unit_volume_100,
p3_.net_weight AS net_weight_101,
p3_.gross_weight AS gross_weight_102,
p3_.go_by_weight AS go_by_weight_103,
p3_.packaging AS packaging_104,
p3_.old_code AS old_code_105,
p3_.show AS show_106,
p3_.balance AS balance_107,
p3_.deleted AS deleted_108,
p3_.category_cnt AS category_cnt_109,
p3_.price_category AS price_category_110,
p3_.is_salle AS is_salle_111,
p3_.is_new AS is_new_112,
p3_.is_top AS is_top_113,
p3_.old_price AS old_price_114,
p3_.discount_percent AS discount_percent_115,
p3_.date_last_price_income AS date_last_price_income_116,
p3_.video AS video_117,
p3_.is_video AS is_video_118,
p3_.is_free_shipping AS is_free_shipping_119,
p3_.warranty_period AS warranty_period_120,
p3_.min_balance AS min_balance_121,
p3_.min_balance_admin AS min_balance_admin_122,
p3_.main_category_id AS main_category_id_123,
p3_.discontinued AS discontinued_124,
p3_.seo_title AS seo_title_125,
p3_.seo_description AS seo_description_126,
p3_.salle_price AS salle_price_127,
p3_.normal_price AS normal_price_128,
p4_.id AS id_129,
p4_.name AS name_130,
p4_.date_entered AS date_entered_131,
p4_.date_modified AS date_modified_132,
p4_.description AS description_133,
p4_.code1c AS code1c_134,
p4_.barcode AS barcode_135,
p4_.status AS status_136,
p4_.price AS price_137,
p4_.price_income AS price_income_138,
p4_.mark_up AS mark_up_139,
p4_.min_mark_up AS min_mark_up_140,
p4_.packing_type AS packing_type_141,
p4_.packing_type_count AS packing_type_count_142,
p4_.discounts AS discounts_143,
p4_.count_order AS count_order_144,
p4_.product_to_order AS product_to_order_145,
p4_.article AS article_146,
p4_.nds AS nds_147,
p4_.service AS service_148,
p4_.transport_service AS transport_service_149,
p4_.exise AS exise_150,
p4_.expiration_date AS expiration_date_151,
p4_.unit_volume AS unit_volume_152,
p4_.net_weight AS net_weight_153,
p4_.gross_weight AS gross_weight_154,
p4_.go_by_weight AS go_by_weight_155,
p4_.packaging AS packaging_156,
p4_.old_code AS old_code_157,
p4_.show AS show_158,
p4_.balance AS balance_159,
p4_.deleted AS deleted_160,
p4_.category_cnt AS category_cnt_161,
p4_.price_category AS price_category_162,
p4_.is_salle AS is_salle_163,
p4_.is_new AS is_new_164,
p4_.is_top AS is_top_165,
p4_.old_price AS old_price_166,
p4_.discount_percent AS discount_percent_167,
p4_.date_last_price_income AS date_last_price_income_168,
p4_.video AS video_169,
p4_.is_video AS is_video_170,
p4_.is_free_shipping AS is_free_shipping_171,
p4_.warranty_period AS warranty_period_172,
p4_.min_balance AS min_balance_173,
p4_.min_balance_admin AS min_balance_admin_174,
p4_.main_category_id AS main_category_id_175,
p4_.discontinued AS discontinued_176,
p4_.seo_title AS seo_title_177,
p4_.seo_description AS seo_description_178,
p4_.salle_price AS salle_price_179,
p4_.normal_price AS normal_price_180,
m5_.id AS id_181,
m5_.upload_timestamp AS upload_timestamp_182,
m5_.main AS main_183,
m5_.file_path AS file_path_184,
m5_.type AS type_185,
m5_.name AS name_186,
m5_.size AS size_187,
m5_.sort AS sort_188,
m6_.id AS id_189,
m6_.upload_timestamp AS upload_timestamp_190,
m6_.main AS main_191,
m6_.file_path AS file_path_192,
m6_.type AS type_193,
m6_.name AS name_194,
m6_.size AS size_195,
m6_.sort AS sort_196,
m7_.id AS id_197,
m7_.upload_timestamp AS upload_timestamp_198,
m7_.main AS main_199,
m7_.file_path AS file_path_200,
m7_.type AS type_201,
m7_.name AS name_202,
m7_.size AS size_203,
m7_.sort AS sort_204,
m8_.id AS id_205,
m8_.upload_timestamp AS upload_timestamp_206,
m8_.main AS main_207,
m8_.file_path AS file_path_208,
m8_.type AS type_209,
m8_.name AS name_210,
m8_.size AS size_211,
m8_.sort AS sort_212,
p0_.modified_user_id AS modified_user_id_213,
p0_.created_by_id AS created_by_id_214,
p0_.measurement_unit_id AS measurement_unit_id_215,
p0_.site_product_id AS site_product_id_216,
p0_.storage_id AS storage_id_217,
p0_.storage_element_id AS storage_element_id_218,
p0_.language_id AS language_id_219,
p0_.translation_id AS translation_id_220,
p0_.main_media_id AS main_media_id_221,
p0_.main_media_hover_id AS main_media_hover_id_222,
c1_.parent_id AS parent_id_223,
c1_.media_id AS media_id_224,
c1_.language_id AS language_id_225,
c1_.translation_id AS translation_id_226,
p3_.modified_user_id AS modified_user_id_227,
p3_.created_by_id AS created_by_id_228,
p3_.measurement_unit_id AS measurement_unit_id_229,
p3_.site_product_id AS site_product_id_230,
p3_.storage_id AS storage_id_231,
p3_.storage_element_id AS storage_element_id_232,
p3_.language_id AS language_id_233,
p3_.translation_id AS translation_id_234,
p3_.main_media_id AS main_media_id_235,
p3_.main_media_hover_id AS main_media_hover_id_236,
p4_.modified_user_id AS modified_user_id_237,
p4_.created_by_id AS created_by_id_238,
p4_.measurement_unit_id AS measurement_unit_id_239,
p4_.site_product_id AS site_product_id_240,
p4_.storage_id AS storage_id_241,
p4_.storage_element_id AS storage_element_id_242,
p4_.language_id AS language_id_243,
p4_.translation_id AS translation_id_244,
p4_.main_media_id AS main_media_id_245,
p4_.main_media_hover_id AS main_media_hover_id_246,
m5_.product_id AS product_id_247,
m5_.orders_id AS orders_id_248,
m5_.users_id AS users_id_249,
m5_.account_worker_id AS account_worker_id_250,
m5_.form_answer_id AS form_answer_id_251,
m5_.job_id AS job_id_252,
m5_.resize_img_parent_id AS resize_img_parent_id_253,
m6_.product_id AS product_id_254,
m6_.orders_id AS orders_id_255,
m6_.users_id AS users_id_256,
m6_.account_worker_id AS account_worker_id_257,
m6_.form_answer_id AS form_answer_id_258,
m6_.job_id AS job_id_259,
m6_.resize_img_parent_id AS resize_img_parent_id_260,
m7_.product_id AS product_id_261,
m7_.orders_id AS orders_id_262,
m7_.users_id AS users_id_263,
m7_.account_worker_id AS account_worker_id_264,
m7_.form_answer_id AS form_answer_id_265,
m7_.job_id AS job_id_266,
m7_.resize_img_parent_id AS resize_img_parent_id_267,
m8_.product_id AS product_id_268,
m8_.orders_id AS orders_id_269,
m8_.users_id AS users_id_270,
m8_.account_worker_id AS account_worker_id_271,
m8_.form_answer_id AS form_answer_id_272,
m8_.job_id AS job_id_273,
m8_.resize_img_parent_id AS resize_img_parent_id_274
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, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, c1_.id AS id_52, c1_.date_entered AS date_entered_53, c1_.date_modified AS date_modified_54, c1_.created_by AS created_by_55, c1_.modified_user_id AS modified_user_id_56, c1_.name AS name_57, c1_.slug AS slug_58, c1_.status AS status_59, c1_.description AS description_60, c1_.main AS main_61, c1_.type AS type_62, c1_.product_cnt AS product_cnt_63, c1_.site_product_cnt AS site_product_cnt_64, c1_.sort AS sort_65, c1_.seo_title AS seo_title_66, c1_.seo_description AS seo_description_67, m2_.id AS id_68, m2_.short_name AS short_name_69, m2_.name AS name_70, m2_.date_entered AS date_entered_71, m2_.date_modified AS date_modified_72, m2_.created_by AS created_by_73, m2_.modified_user_id AS modified_user_id_74, m2_.description AS description_75, m2_.code1c AS code1c_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212, p0_.modified_user_id AS modified_user_id_213, p0_.created_by_id AS created_by_id_214, p0_.measurement_unit_id AS measurement_unit_id_215, p0_.site_product_id AS site_product_id_216, p0_.storage_id AS storage_id_217, p0_.storage_element_id AS storage_element_id_218, p0_.language_id AS language_id_219, p0_.translation_id AS translation_id_220, p0_.main_media_id AS main_media_id_221, p0_.main_media_hover_id AS main_media_hover_id_222, c1_.parent_id AS parent_id_223, c1_.media_id AS media_id_224, c1_.language_id AS language_id_225, c1_.translation_id AS translation_id_226, p3_.modified_user_id AS modified_user_id_227, p3_.created_by_id AS created_by_id_228, p3_.measurement_unit_id AS measurement_unit_id_229, p3_.site_product_id AS site_product_id_230, p3_.storage_id AS storage_id_231, p3_.storage_element_id AS storage_element_id_232, p3_.language_id AS language_id_233, p3_.translation_id AS translation_id_234, p3_.main_media_id AS main_media_id_235, p3_.main_media_hover_id AS main_media_hover_id_236, p4_.modified_user_id AS modified_user_id_237, p4_.created_by_id AS created_by_id_238, p4_.measurement_unit_id AS measurement_unit_id_239, p4_.site_product_id AS site_product_id_240, p4_.storage_id AS storage_id_241, p4_.storage_element_id AS storage_element_id_242, p4_.language_id AS language_id_243, p4_.translation_id AS translation_id_244, p4_.main_media_id AS main_media_id_245, p4_.main_media_hover_id AS main_media_hover_id_246, m5_.product_id AS product_id_247, m5_.orders_id AS orders_id_248, m5_.users_id AS users_id_249, m5_.account_worker_id AS account_worker_id_250, m5_.form_answer_id AS form_answer_id_251, m5_.job_id AS job_id_252, m5_.resize_img_parent_id AS resize_img_parent_id_253, m6_.product_id AS product_id_254, m6_.orders_id AS orders_id_255, m6_.users_id AS users_id_256, m6_.account_worker_id AS account_worker_id_257, m6_.form_answer_id AS form_answer_id_258, m6_.job_id AS job_id_259, m6_.resize_img_parent_id AS resize_img_parent_id_260, m7_.product_id AS product_id_261, m7_.orders_id AS orders_id_262, m7_.users_id AS users_id_263, m7_.account_worker_id AS account_worker_id_264, m7_.form_answer_id AS form_answer_id_265, m7_.job_id AS job_id_266, m7_.resize_img_parent_id AS resize_img_parent_id_267, m8_.product_id AS product_id_268, m8_.orders_id AS orders_id_269, m8_.users_id AS users_id_270, m8_.account_worker_id AS account_worker_id_271, m8_.form_answer_id AS form_answer_id_272, m8_.job_id AS job_id_273, m8_.resize_img_parent_id AS resize_img_parent_id_274 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, 29223, 29205, 29215, 29213, 29212, 29187, 29220, 29224, 29225, 29191, 29192, 29201, 29183, 29184, 29226) ORDER BY p0_.name ASC, m10_.sort DESC, p0_.discontinued DESC;
|
63.53 ms
(28.04%)
|
224 |
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;
|
19.62 ms
(8.66%)
|
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, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, c1_.id AS id_52, c1_.date_entered AS date_entered_53, c1_.date_modified AS date_modified_54, c1_.created_by AS created_by_55, c1_.modified_user_id AS modified_user_id_56, c1_.name AS name_57, c1_.slug AS slug_58, c1_.status AS status_59, c1_.description AS description_60, c1_.main AS main_61, c1_.type AS type_62, c1_.product_cnt AS product_cnt_63, c1_.site_product_cnt AS site_product_cnt_64, c1_.sort AS sort_65, c1_.seo_title AS seo_title_66, c1_.seo_description AS seo_description_67, m2_.id AS id_68, m2_.short_name AS short_name_69, m2_.name AS name_70, m2_.date_entered AS date_entered_71, m2_.date_modified AS date_modified_72, m2_.created_by AS created_by_73, m2_.modified_user_id AS modified_user_id_74, m2_.description AS description_75, m2_.code1c AS code1c_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212 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,
p0_.salle_price AS salle_price_50,
p0_.normal_price AS normal_price_51,
c1_.id AS id_52,
c1_.date_entered AS date_entered_53,
c1_.date_modified AS date_modified_54,
c1_.created_by AS created_by_55,
c1_.modified_user_id AS modified_user_id_56,
c1_.name AS name_57,
c1_.slug AS slug_58,
c1_.status AS status_59,
c1_.description AS description_60,
c1_.main AS main_61,
c1_.type AS type_62,
c1_.product_cnt AS product_cnt_63,
c1_.site_product_cnt AS site_product_cnt_64,
c1_.sort AS sort_65,
c1_.seo_title AS seo_title_66,
c1_.seo_description AS seo_description_67,
m2_.id AS id_68,
m2_.short_name AS short_name_69,
m2_.name AS name_70,
m2_.date_entered AS date_entered_71,
m2_.date_modified AS date_modified_72,
m2_.created_by AS created_by_73,
m2_.modified_user_id AS modified_user_id_74,
m2_.description AS description_75,
m2_.code1c AS code1c_76,
p3_.id AS id_77,
p3_.name AS name_78,
p3_.date_entered AS date_entered_79,
p3_.date_modified AS date_modified_80,
p3_.description AS description_81,
p3_.code1c AS code1c_82,
p3_.barcode AS barcode_83,
p3_.status AS status_84,
p3_.price AS price_85,
p3_.price_income AS price_income_86,
p3_.mark_up AS mark_up_87,
p3_.min_mark_up AS min_mark_up_88,
p3_.packing_type AS packing_type_89,
p3_.packing_type_count AS packing_type_count_90,
p3_.discounts AS discounts_91,
p3_.count_order AS count_order_92,
p3_.product_to_order AS product_to_order_93,
p3_.article AS article_94,
p3_.nds AS nds_95,
p3_.service AS service_96,
p3_.transport_service AS transport_service_97,
p3_.exise AS exise_98,
p3_.expiration_date AS expiration_date_99,
p3_.unit_volume AS unit_volume_100,
p3_.net_weight AS net_weight_101,
p3_.gross_weight AS gross_weight_102,
p3_.go_by_weight AS go_by_weight_103,
p3_.packaging AS packaging_104,
p3_.old_code AS old_code_105,
p3_.show AS show_106,
p3_.balance AS balance_107,
p3_.deleted AS deleted_108,
p3_.category_cnt AS category_cnt_109,
p3_.price_category AS price_category_110,
p3_.is_salle AS is_salle_111,
p3_.is_new AS is_new_112,
p3_.is_top AS is_top_113,
p3_.old_price AS old_price_114,
p3_.discount_percent AS discount_percent_115,
p3_.date_last_price_income AS date_last_price_income_116,
p3_.video AS video_117,
p3_.is_video AS is_video_118,
p3_.is_free_shipping AS is_free_shipping_119,
p3_.warranty_period AS warranty_period_120,
p3_.min_balance AS min_balance_121,
p3_.min_balance_admin AS min_balance_admin_122,
p3_.main_category_id AS main_category_id_123,
p3_.discontinued AS discontinued_124,
p3_.seo_title AS seo_title_125,
p3_.seo_description AS seo_description_126,
p3_.salle_price AS salle_price_127,
p3_.normal_price AS normal_price_128,
p4_.id AS id_129,
p4_.name AS name_130,
p4_.date_entered AS date_entered_131,
p4_.date_modified AS date_modified_132,
p4_.description AS description_133,
p4_.code1c AS code1c_134,
p4_.barcode AS barcode_135,
p4_.status AS status_136,
p4_.price AS price_137,
p4_.price_income AS price_income_138,
p4_.mark_up AS mark_up_139,
p4_.min_mark_up AS min_mark_up_140,
p4_.packing_type AS packing_type_141,
p4_.packing_type_count AS packing_type_count_142,
p4_.discounts AS discounts_143,
p4_.count_order AS count_order_144,
p4_.product_to_order AS product_to_order_145,
p4_.article AS article_146,
p4_.nds AS nds_147,
p4_.service AS service_148,
p4_.transport_service AS transport_service_149,
p4_.exise AS exise_150,
p4_.expiration_date AS expiration_date_151,
p4_.unit_volume AS unit_volume_152,
p4_.net_weight AS net_weight_153,
p4_.gross_weight AS gross_weight_154,
p4_.go_by_weight AS go_by_weight_155,
p4_.packaging AS packaging_156,
p4_.old_code AS old_code_157,
p4_.show AS show_158,
p4_.balance AS balance_159,
p4_.deleted AS deleted_160,
p4_.category_cnt AS category_cnt_161,
p4_.price_category AS price_category_162,
p4_.is_salle AS is_salle_163,
p4_.is_new AS is_new_164,
p4_.is_top AS is_top_165,
p4_.old_price AS old_price_166,
p4_.discount_percent AS discount_percent_167,
p4_.date_last_price_income AS date_last_price_income_168,
p4_.video AS video_169,
p4_.is_video AS is_video_170,
p4_.is_free_shipping AS is_free_shipping_171,
p4_.warranty_period AS warranty_period_172,
p4_.min_balance AS min_balance_173,
p4_.min_balance_admin AS min_balance_admin_174,
p4_.main_category_id AS main_category_id_175,
p4_.discontinued AS discontinued_176,
p4_.seo_title AS seo_title_177,
p4_.seo_description AS seo_description_178,
p4_.salle_price AS salle_price_179,
p4_.normal_price AS normal_price_180,
m5_.id AS id_181,
m5_.upload_timestamp AS upload_timestamp_182,
m5_.main AS main_183,
m5_.file_path AS file_path_184,
m5_.type AS type_185,
m5_.name AS name_186,
m5_.size AS size_187,
m5_.sort AS sort_188,
m6_.id AS id_189,
m6_.upload_timestamp AS upload_timestamp_190,
m6_.main AS main_191,
m6_.file_path AS file_path_192,
m6_.type AS type_193,
m6_.name AS name_194,
m6_.size AS size_195,
m6_.sort AS sort_196,
m7_.id AS id_197,
m7_.upload_timestamp AS upload_timestamp_198,
m7_.main AS main_199,
m7_.file_path AS file_path_200,
m7_.type AS type_201,
m7_.name AS name_202,
m7_.size AS size_203,
m7_.sort AS sort_204,
m8_.id AS id_205,
m8_.upload_timestamp AS upload_timestamp_206,
m8_.main AS main_207,
m8_.file_path AS file_path_208,
m8_.type AS type_209,
m8_.name AS name_210,
m8_.size AS size_211,
m8_.sort AS sort_212
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, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, c1_.id AS id_52, c1_.date_entered AS date_entered_53, c1_.date_modified AS date_modified_54, c1_.created_by AS created_by_55, c1_.modified_user_id AS modified_user_id_56, c1_.name AS name_57, c1_.slug AS slug_58, c1_.status AS status_59, c1_.description AS description_60, c1_.main AS main_61, c1_.type AS type_62, c1_.product_cnt AS product_cnt_63, c1_.site_product_cnt AS site_product_cnt_64, c1_.sort AS sort_65, c1_.seo_title AS seo_title_66, c1_.seo_description AS seo_description_67, m2_.id AS id_68, m2_.short_name AS short_name_69, m2_.name AS name_70, m2_.date_entered AS date_entered_71, m2_.date_modified AS date_modified_72, m2_.created_by AS created_by_73, m2_.modified_user_id AS modified_user_id_74, m2_.description AS description_75, m2_.code1c AS code1c_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212 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;
|
15.14 ms
(6.68%)
|
1 |
SELECT DISTINCT id_0, MIN(sclr_213) 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, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, c1_.id AS id_52, c1_.date_entered AS date_entered_53, c1_.date_modified AS date_modified_54, c1_.created_by AS created_by_55, c1_.modified_user_id AS modified_user_id_56, c1_.name AS name_57, c1_.slug AS slug_58, c1_.status AS status_59, c1_.description AS description_60, c1_.main AS main_61, c1_.type AS type_62, c1_.product_cnt AS product_cnt_63, c1_.site_product_cnt AS site_product_cnt_64, c1_.sort AS sort_65, c1_.seo_title AS seo_title_66, c1_.seo_description AS seo_description_67, m2_.id AS id_68, m2_.short_name AS short_name_69, m2_.name AS name_70, m2_.date_entered AS date_entered_71, m2_.date_modified AS date_modified_72, m2_.created_by AS created_by_73, m2_.modified_user_id AS modified_user_id_74, m2_.description AS description_75, m2_.code1c AS code1c_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212, ROW_NUMBER() OVER(ORDER BY p0_.name ASC, m9_.sort DESC, p0_.discontinued DESC) AS sclr_213 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_213) 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,
p0_.salle_price AS salle_price_50,
p0_.normal_price AS normal_price_51,
c1_.id AS id_52,
c1_.date_entered AS date_entered_53,
c1_.date_modified AS date_modified_54,
c1_.created_by AS created_by_55,
c1_.modified_user_id AS modified_user_id_56,
c1_.name AS name_57,
c1_.slug AS slug_58,
c1_.status AS status_59,
c1_.description AS description_60,
c1_.main AS main_61,
c1_.type AS type_62,
c1_.product_cnt AS product_cnt_63,
c1_.site_product_cnt AS site_product_cnt_64,
c1_.sort AS sort_65,
c1_.seo_title AS seo_title_66,
c1_.seo_description AS seo_description_67,
m2_.id AS id_68,
m2_.short_name AS short_name_69,
m2_.name AS name_70,
m2_.date_entered AS date_entered_71,
m2_.date_modified AS date_modified_72,
m2_.created_by AS created_by_73,
m2_.modified_user_id AS modified_user_id_74,
m2_.description AS description_75,
m2_.code1c AS code1c_76,
p3_.id AS id_77,
p3_.name AS name_78,
p3_.date_entered AS date_entered_79,
p3_.date_modified AS date_modified_80,
p3_.description AS description_81,
p3_.code1c AS code1c_82,
p3_.barcode AS barcode_83,
p3_.status AS status_84,
p3_.price AS price_85,
p3_.price_income AS price_income_86,
p3_.mark_up AS mark_up_87,
p3_.min_mark_up AS min_mark_up_88,
p3_.packing_type AS packing_type_89,
p3_.packing_type_count AS packing_type_count_90,
p3_.discounts AS discounts_91,
p3_.count_order AS count_order_92,
p3_.product_to_order AS product_to_order_93,
p3_.article AS article_94,
p3_.nds AS nds_95,
p3_.service AS service_96,
p3_.transport_service AS transport_service_97,
p3_.exise AS exise_98,
p3_.expiration_date AS expiration_date_99,
p3_.unit_volume AS unit_volume_100,
p3_.net_weight AS net_weight_101,
p3_.gross_weight AS gross_weight_102,
p3_.go_by_weight AS go_by_weight_103,
p3_.packaging AS packaging_104,
p3_.old_code AS old_code_105,
p3_.show AS show_106,
p3_.balance AS balance_107,
p3_.deleted AS deleted_108,
p3_.category_cnt AS category_cnt_109,
p3_.price_category AS price_category_110,
p3_.is_salle AS is_salle_111,
p3_.is_new AS is_new_112,
p3_.is_top AS is_top_113,
p3_.old_price AS old_price_114,
p3_.discount_percent AS discount_percent_115,
p3_.date_last_price_income AS date_last_price_income_116,
p3_.video AS video_117,
p3_.is_video AS is_video_118,
p3_.is_free_shipping AS is_free_shipping_119,
p3_.warranty_period AS warranty_period_120,
p3_.min_balance AS min_balance_121,
p3_.min_balance_admin AS min_balance_admin_122,
p3_.main_category_id AS main_category_id_123,
p3_.discontinued AS discontinued_124,
p3_.seo_title AS seo_title_125,
p3_.seo_description AS seo_description_126,
p3_.salle_price AS salle_price_127,
p3_.normal_price AS normal_price_128,
p4_.id AS id_129,
p4_.name AS name_130,
p4_.date_entered AS date_entered_131,
p4_.date_modified AS date_modified_132,
p4_.description AS description_133,
p4_.code1c AS code1c_134,
p4_.barcode AS barcode_135,
p4_.status AS status_136,
p4_.price AS price_137,
p4_.price_income AS price_income_138,
p4_.mark_up AS mark_up_139,
p4_.min_mark_up AS min_mark_up_140,
p4_.packing_type AS packing_type_141,
p4_.packing_type_count AS packing_type_count_142,
p4_.discounts AS discounts_143,
p4_.count_order AS count_order_144,
p4_.product_to_order AS product_to_order_145,
p4_.article AS article_146,
p4_.nds AS nds_147,
p4_.service AS service_148,
p4_.transport_service AS transport_service_149,
p4_.exise AS exise_150,
p4_.expiration_date AS expiration_date_151,
p4_.unit_volume AS unit_volume_152,
p4_.net_weight AS net_weight_153,
p4_.gross_weight AS gross_weight_154,
p4_.go_by_weight AS go_by_weight_155,
p4_.packaging AS packaging_156,
p4_.old_code AS old_code_157,
p4_.show AS show_158,
p4_.balance AS balance_159,
p4_.deleted AS deleted_160,
p4_.category_cnt AS category_cnt_161,
p4_.price_category AS price_category_162,
p4_.is_salle AS is_salle_163,
p4_.is_new AS is_new_164,
p4_.is_top AS is_top_165,
p4_.old_price AS old_price_166,
p4_.discount_percent AS discount_percent_167,
p4_.date_last_price_income AS date_last_price_income_168,
p4_.video AS video_169,
p4_.is_video AS is_video_170,
p4_.is_free_shipping AS is_free_shipping_171,
p4_.warranty_period AS warranty_period_172,
p4_.min_balance AS min_balance_173,
p4_.min_balance_admin AS min_balance_admin_174,
p4_.main_category_id AS main_category_id_175,
p4_.discontinued AS discontinued_176,
p4_.seo_title AS seo_title_177,
p4_.seo_description AS seo_description_178,
p4_.salle_price AS salle_price_179,
p4_.normal_price AS normal_price_180,
m5_.id AS id_181,
m5_.upload_timestamp AS upload_timestamp_182,
m5_.main AS main_183,
m5_.file_path AS file_path_184,
m5_.type AS type_185,
m5_.name AS name_186,
m5_.size AS size_187,
m5_.sort AS sort_188,
m6_.id AS id_189,
m6_.upload_timestamp AS upload_timestamp_190,
m6_.main AS main_191,
m6_.file_path AS file_path_192,
m6_.type AS type_193,
m6_.name AS name_194,
m6_.size AS size_195,
m6_.sort AS sort_196,
m7_.id AS id_197,
m7_.upload_timestamp AS upload_timestamp_198,
m7_.main AS main_199,
m7_.file_path AS file_path_200,
m7_.type AS type_201,
m7_.name AS name_202,
m7_.size AS size_203,
m7_.sort AS sort_204,
m8_.id AS id_205,
m8_.upload_timestamp AS upload_timestamp_206,
m8_.main AS main_207,
m8_.file_path AS file_path_208,
m8_.type AS type_209,
m8_.name AS name_210,
m8_.size AS size_211,
m8_.sort AS sort_212,
ROW_NUMBER() OVER(
ORDER BY
p0_.name ASC,
m9_.sort DESC,
p0_.discontinued DESC
) AS sclr_213
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_213) 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, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, c1_.id AS id_52, c1_.date_entered AS date_entered_53, c1_.date_modified AS date_modified_54, c1_.created_by AS created_by_55, c1_.modified_user_id AS modified_user_id_56, c1_.name AS name_57, c1_.slug AS slug_58, c1_.status AS status_59, c1_.description AS description_60, c1_.main AS main_61, c1_.type AS type_62, c1_.product_cnt AS product_cnt_63, c1_.site_product_cnt AS site_product_cnt_64, c1_.sort AS sort_65, c1_.seo_title AS seo_title_66, c1_.seo_description AS seo_description_67, m2_.id AS id_68, m2_.short_name AS short_name_69, m2_.name AS name_70, m2_.date_entered AS date_entered_71, m2_.date_modified AS date_modified_72, m2_.created_by AS created_by_73, m2_.modified_user_id AS modified_user_id_74, m2_.description AS description_75, m2_.code1c AS code1c_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212, ROW_NUMBER() OVER(ORDER BY p0_.name ASC, m9_.sort DESC, p0_.discontinued DESC) AS sclr_213 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;
|