| 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 (368535, 372790, 368554, 372807, 368570, 372823, 368586, 372840, 368602, 372858, 368618, 372874, 368634, 372890, 368650, 372906, 368666, 372922, 368682, 372938, 368698, 372954, 368714, 372970, 368730, 372986, 368746, 373002, 368762, 373018, 368778, 373034, 368795, 373050, 368811, 373066, 368827, 373082, 368844, 373098, 368860, 373114, 368876, 373130, 368892, 373146, 368908, 373162, 368924, 373178, 368944) ORDER BY `MediaArticle`.`main_by` DESC | | 51 | 51 | 6 |
| 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 |