| 1 | SELECT `Settings`.`id`, `Settings`.`admin_email`, `Settings`.`manager_emails`, `Settings`.`gpz_brands`, `Settings`.`sf_header`, `Settings`.`sf_footer`, `Settings`.`sf_details`, `Settings`.`tpl_product_descr_by`, `Settings`.`tpl_product_descr_ru`, `Settings`.`tpl_product_seo_title_by`, `Settings`.`tpl_product_seo_title_ru`, `Settings`.`tpl_product_seo_keywords_by`, `Settings`.`tpl_product_seo_keywords_ru`, `Settings`.`tpl_product_seo_descr_by`, `Settings`.`tpl_product_seo_descr_ru`, `Settings`.`show_fake`
FROM `fyre_vcars`.`settings` AS `Settings`
WHERE 1 = 1
LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `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`, `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`
FROM `fyre_vcars`.`categories` AS `Category`
LEFT JOIN `fyre_vcars`.`seo` AS `Seo` ON (`Seo`.`object_id` = `Category`.`id` AND `Seo`.`object_type` = 'Category')
WHERE `Category`.`slug` = 'fp-diesel'
LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `Subcategory`.`id`, `Subcategory`.`created`, `Subcategory`.`modified`, `Subcategory`.`slug`, `Subcategory`.`title`, `Subcategory`.`cat_id`, `Subcategory`.`body_by`, `Subcategory`.`body_ru`, `Subcategory`.`sorting`, `Subcategory`.`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`, `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`
FROM `fyre_vcars`.`subcategories` AS `Subcategory`
LEFT JOIN `fyre_vcars`.`categories` AS `Category` ON (`Subcategory`.`cat_id` = `Category`.`id`)
LEFT JOIN `fyre_vcars`.`seo` AS `Seo` ON (`Seo`.`object_id` = `Subcategory`.`id` AND `Seo`.`object_type` = 'Subcategory')
WHERE `Subcategory`.`slug` = 'john-deere'
LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT `Product`.`id`
FROM `fyre_vcars`.`products` AS `Product`
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')
WHERE `Product`.`published` = '1' AND `Product`.`cat_id` = 228557 AND `Product`.`subcat_id` = 228576
ORDER BY `MediaArticle`.`main_by` DESC
LIMIT 51 | | 51 | 51 | 8 |
| 5 | SELECT COUNT(*) AS `count`
FROM `fyre_vcars`.`products` AS `Product`
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`)
WHERE `Product`.`published` = '1' AND `Product`.`cat_id` = 228557 AND `Product`.`subcat_id` = 228576 | | 1 | 1 | 5 |
| 6 | 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 (250916, 250932, 250948, 250964, 250980, 250996, 251012, 251028, 251044, 251060, 251076, 251092, 251108, 251124, 251140, 251156, 251172, 251188, 251204, 251220, 251236, 251252, 251268, 251284, 251300, 251316, 251332, 251348, 251364, 251380, 251396, 251412, 251428, 251444, 251460, 251476, 251492, 251508, 251524, 251540, 251556, 251572, 251588, 251604, 251620, 251636, 251652, 251668, 251684, 251700, 251716)
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`, `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`.`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`.`published` = '1' | | 38 | 38 | 4 |
| 8 | 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 |
| 9 | SELECT `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`
FROM `fyre_vcars`.`categories` AS `Category`
WHERE `Category`.`is_fake` = '0' AND `Category`.`export_by` = '1'
ORDER BY `Category`.`sorting` ASC | | 30 | 30 | 2 |
| 10 | SELECT `Subcategory`.`id`, `Subcategory`.`created`, `Subcategory`.`modified`, `Subcategory`.`slug`, `Subcategory`.`title`, `Subcategory`.`cat_id`, `Subcategory`.`body_by`, `Subcategory`.`body_ru`, `Subcategory`.`sorting`, `Subcategory`.`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`
FROM `fyre_vcars`.`subcategories` AS `Subcategory`
LEFT JOIN `fyre_vcars`.`categories` AS `Category` ON (`Subcategory`.`cat_id` = `Category`.`id`)
WHERE `Subcategory`.`is_fake` = '0'
ORDER BY `Subcategory`.`sorting` ASC | | 344 | 344 | 26 |
| 11 | SELECT `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`
FROM `fyre_vcars`.`seo` AS `Seo`
WHERE `Seo`.`object_id` = 271 AND `Seo`.`object_type` = 'Page' | | 0 | 0 | 0 |
| 12 | SELECT `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`
FROM `fyre_vcars`.`seo` AS `Seo`
WHERE `Seo`.`object_id` = 283 AND `Seo`.`object_type` = 'Page' | | 0 | 0 | 0 |
Заказано 
