| 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 | 1 |
| 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` = 'trw'
LIMIT 1 | | 1 | 1 | 1 |
| 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` = 'trw-mercedes-benz'
LIMIT 1 | | 1 | 1 | 5 |
| 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` = 36487 AND `Product`.`subcat_id` = 36514
ORDER BY `MediaArticle`.`main_by` DESC
LIMIT 51 | | 51 | 51 | 11 |
| 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` = 36487 AND `Product`.`subcat_id` = 36514 | | 1 | 1 | 10 |
| 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 (37257, 37273, 37289, 37305, 37321, 37337, 37353, 37369, 37385, 37401, 37417, 37433, 37449, 37465, 37481, 37497, 37513, 37529, 37545, 37561, 37577, 37593, 37258, 37274, 37290, 37306, 37322, 37338, 37354, 37370, 37386, 37402, 37418, 37434, 37450, 37466, 37482, 37498, 37514, 37530, 37546, 37562, 37578, 37594, 37259, 37275, 37291, 37307, 37323, 37339, 37355)
ORDER BY `MediaArticle`.`main_by` DESC | | 51 | 51 | 16 |
| 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 | 6 |
| 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 | 3 |
| 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 | 7 |
| 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 | 78 |
| 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 | 1 |
| 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 |
Заказано 
