| 5 | SELECT `Product`.`id`, `Product`.`created`, `Product`.`modified`, `Product`.`title`, `Product`.`title_rus`, `Product`.`detail_num`, `Product`.`motor`, `Product`.`article_date`, `Product`.`code`, `Product`.`source_url`, `Product`.`slug`, `Product`.`page_id`, `Product`.`teaser`, `Product`.`teaser_ru`, `Product`.`teaser_ua`, `Product`.`body`, `Product`.`body_ru`, `Product`.`body_ua`, `Product`.`featured`, `Product`.`featured_by`, `Product`.`featured_ru`, `Product`.`featured_ua`, `Product`.`published`, `Product`.`brand_id`, `Product`.`sorting`, `Product`.`price`, `Product`.`cat_id`, `Product`.`subcat_id`, `Product`.`count`, `Product`.`active`, `Product`.`show_detailnum`, `Product`.`processed`, `Product`.`export_bg`, `Product`.`is_subdomain`, `Product`.`orig_id`, `Product`.`export_by`, `Product`.`export_ru`, `Product`.`is_fake`, `Category`.`id`, `Category`.`created`, `Category`.`modified`, `Category`.`slug`, `Category`.`title`, `Category`.`body_by`, `Category`.`body_ru`, `Category`.`sorting`, `Category`.`export_by`, `Category`.`export_ru`, `Category`.`is_fake`, `Subcategory`.`id`, `Subcategory`.`created`, `Subcategory`.`modified`, `Subcategory`.`slug`, `Subcategory`.`title`, `Subcategory`.`cat_id`, `Subcategory`.`body_by`, `Subcategory`.`body_ru`, `Subcategory`.`sorting`, `Subcategory`.`is_fake`, `MediaArticle`.`id`, `MediaArticle`.`created`, `MediaArticle`.`media_type`, `MediaArticle`.`object_type`, `MediaArticle`.`object_id`, `MediaArticle`.`file`, `MediaArticle`.`ext`, `MediaArticle`.`main`, `MediaArticle`.`orig_fname`, `MediaArticle`.`orig_fsize`, `MediaArticle`.`orig_w`, `MediaArticle`.`orig_h`, `MediaArticle`.`alt`, `MediaArticle`.`main_by`, `MediaArticle`.`main_ru`, `MediaArticle`.`main_bg`, `MediaArticle`.`main_ua`, `MediaArticle`.`show_by`, `MediaArticle`.`show_ru`, `MediaArticle`.`show_bg`, `MediaArticle`.`show_ua`, `MediaArticle`.`alt_by`, `MediaArticle`.`alt_ru`, `MediaArticle`.`alt_ua`, `MediaArticle`.`alt_bg`, `Search`.`id`, `Search`.`body`, `Seo`.`id`, `Seo`.`object_type`, `Seo`.`object_id`, `Seo`.`title`, `Seo`.`descr`, `Seo`.`keywords`, `Seo`.`title_by`, `Seo`.`descr_by`, `Seo`.`keywords_by`, `Seo`.`title_ru`, `Seo`.`descr_ru`, `Seo`.`keywords_ru`, `Seo`.`title_ua`, `Seo`.`descr_ua`, `Seo`.`keywords_ua`, `PMFormData`.`id`, `PMFormData`.`object_type`, `PMFormData`.`object_id`, `PMFormData`.`recalc`, `PMFormData`.`fk_6`, `PMFormData`.`fk_7`, `PMFormData`.`fk_8`, `PMFormData`.`fk_9`, `PMFormData`.`fk_10`, `PMFormData`.`fk_11`, `PMFormData`.`fk_12`, `PMFormData`.`fk_13`, `PMFormData`.`fk_14`, `PMFormData`.`fk_15`, `PMFormData`.`fk_17`, `PMFormData`.`fk_18`, `PMFormData`.`fk_21`, `PMFormData`.`fk_23`, `PMFormData`.`fk_24`, `PMFormData`.`fk_25`, `PMFormData`.`fk_28`, `PMFormData`.`fk_29`, `PMFormData`.`fk_30`, `PMFormData`.`fk_31`, `PMFormData`.`fk_32`, `PMFormData`.`fk_33`, `PMFormData`.`fk_34`, `PMFormData`.`fk_35`, `PMFormData`.`fk_36`, `PMFormData`.`fk_40`, `PMFormData`.`fk_41`, `PMFormData`.`fk_42`, `PMFormData`.`fk_43`, `PMFormData`.`fk_44`, `PMFormData`.`fk_45`, `PMFormData`.`fk_46`, `PMFormData`.`fk_48`, `PMFormData`.`fk_49`, `PMFormData`.`fk_50`, `PMFormData`.`fk_51`, `PMFormData`.`fk_52`, `PMFormData`.`fk_53`, `PMFormData`.`fk_54`, `PMFormData`.`fk_55`, `PMFormData`.`fk_56`, `PMFormData`.`fk_57`, `PMFormData`.`fk_60`, `PMFormData`.`fk_61`, `PMFormData`.`fk_62`, `PMFormData`.`fk_63`, `PMFormData`.`fk_64`, `PMFormData`.`fk_65`, `PMFormData`.`fk_66`, `PMFormData`.`fk_67`, `PMFormData`.`fk_68`, `PMFormData`.`fk_69`, `PMFormData`.`fk_70`, `PMFormData`.`fk_71`, `PMFormData`.`fk_72`, `PMFormData`.`fk_77`, `PMFormData`.`fk_78`, `PMFormData`.`fk_79`, `PMFormData`.`fk_80`, `PMFormData`.`fk_81`, `PMFormData`.`fk_82`, `PMFormData`.`fk_83`, `PMFormData`.`fk_84`, `PMFormData`.`fk_85`, `PMFormData`.`fk_86`, `PMFormData`.`fk_87`, `PMFormData`.`fk_90`, `PMFormData`.`fk_93`, `PMFormData`.`fk_95`, `PMFormData`.`fk_96`, `PMFormData`.`fk_97`, `PMFormData`.`fk_98`, `PMFormData`.`fk_99`, `PMFormData`.`fk_100`, `PMFormData`.`fk_102`, `PMFormData`.`fk_103`, `PMFormData`.`fk_104`, `PMFormData`.`fk_105`, `PMFormData`.`fk_106`, `PMFormData`.`fk_107`, `PMFormData`.`fk_110`, `PMFormData`.`fk_112`, `PMFormData`.`fk_116`, `PMFormData`.`fk_117`, `PMFormData`.`fk_118`, `PMFormData`.`fk_119`, `PMFormData`.`fk_120`, `PMFormData`.`fk_121`, `PMFormData`.`fk_123`, `PMFormData`.`fk_124`
FROM `fyre_vcars`.`products` AS `Product`
LEFT JOIN `fyre_vcars`.`categories` AS `Category` ON (`Product`.`cat_id` = `Category`.`id`)
LEFT JOIN `fyre_vcars`.`subcategories` AS `Subcategory` ON (`Product`.`subcat_id` = `Subcategory`.`id`)
LEFT JOIN `fyre_vcars`.`media` AS `MediaArticle` ON (`MediaArticle`.`object_id` = `Product`.`id` AND `MediaArticle`.`media_type` = 'image' AND `MediaArticle`.`object_type` = 'Product' AND `MediaArticle`.`main_by` = '1')
LEFT JOIN `fyre_vcars`.`search` AS `Search` ON (`Search`.`id` = `Product`.`id`)
LEFT JOIN `fyre_vcars`.`seo` AS `Seo` ON (`Seo`.`object_id` = `Product`.`id` AND `Seo`.`object_type` = 'Product')
LEFT JOIN `fyre_vcars`.`form_data` AS `PMFormData` ON (`PMFormData`.`object_id` = `Product`.`id` AND `PMFormData`.`object_type` = 'ProductParam')
WHERE `Product`.`id` IN (421994, 420604, 418567, 422663, 426786, 418583, 422679, 426802, 418599, 422695, 426818, 418615, 422711, 426834, 418631, 422727, 426850, 418647, 422743, 426866, 418663, 422759, 426882, 418679, 422775, 426898, 418695, 422791, 426914, 418711, 422807, 426930, 418727, 422823, 426946, 418743, 422839, 426962, 418759, 422855, 426978, 418775, 422871, 426994, 418791, 422887, 427010, 418807, 422903, 427026, 418823)
ORDER BY `MediaArticle`.`main_by` DESC | | 51 | 51 | 7 |
| 7 | SELECT `Brand`.`id`, `Brand`.`created`, `Brand`.`modified`, `Brand`.`slug`, `Brand`.`title`, `Brand`.`teaser_by`, `Brand`.`teaser_ru`, `Brand`.`body_by`, `Brand`.`body_ru`, `Brand`.`featured`, `Brand`.`published`, `Brand`.`sorting`, `Brand`.`is_fake`, `Seo`.`id`, `Seo`.`object_type`, `Seo`.`object_id`, `Seo`.`title`, `Seo`.`descr`, `Seo`.`keywords`, `Seo`.`title_by`, `Seo`.`descr_by`, `Seo`.`keywords_by`, `Seo`.`title_ru`, `Seo`.`descr_ru`, `Seo`.`keywords_ru`, `Seo`.`title_ua`, `Seo`.`descr_ua`, `Seo`.`keywords_ua`, `MediaArticle`.`id`, `MediaArticle`.`created`, `MediaArticle`.`media_type`, `MediaArticle`.`object_type`, `MediaArticle`.`object_id`, `MediaArticle`.`file`, `MediaArticle`.`ext`, `MediaArticle`.`main`, `MediaArticle`.`orig_fname`, `MediaArticle`.`orig_fsize`, `MediaArticle`.`orig_w`, `MediaArticle`.`orig_h`, `MediaArticle`.`alt`, `MediaArticle`.`main_by`, `MediaArticle`.`main_ru`, `MediaArticle`.`main_bg`, `MediaArticle`.`main_ua`, `MediaArticle`.`show_by`, `MediaArticle`.`show_ru`, `MediaArticle`.`show_bg`, `MediaArticle`.`show_ua`, `MediaArticle`.`alt_by`, `MediaArticle`.`alt_ru`, `MediaArticle`.`alt_ua`, `MediaArticle`.`alt_bg`
FROM `fyre_vcars`.`brands` AS `Brand`
LEFT JOIN `fyre_vcars`.`seo` AS `Seo` ON (`Seo`.`object_id` = `Brand`.`id` AND `Seo`.`object_type` = 'Brand')
LEFT JOIN `fyre_vcars`.`media` AS `MediaArticle` ON (`MediaArticle`.`object_id` = `Brand`.`id` AND `MediaArticle`.`media_type` = 'image' AND `MediaArticle`.`object_type` = 'Brand' AND `MediaArticle`.`main_by` = '1')
WHERE `Brand`.`is_fake` = '1' | | 16 | 16 | 1 |
Заказано 
