AgroMotors.by

+375 29 716 67 53 Влад
+375 44 716 67 50 Антон

220030, Минск, ул. Свердлова, дом 11.

vlad@agromotors.by

(vitacars) 10 queries took 2961 ms
Nr	Query	Affected	Num. rows	Took (ms)
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 `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' ORDER BY `MediaArticle`.`main_by` DESC LIMIT 51	51	51	1478
3	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'	1	1	1443
4	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 (339549, 331236, 352300, 322984, 331370, 4924, 365069, 811480, 292008, 297644, 36319, 344333, 36335, 36351, 36367, 36383, 348582, 36399, 36415, 36433, 36449, 36465, 36483, 5345, 327905, 323719, 319555, 357371, 319668, 1080, 1096, 1114, 1131, 1149, 311341, 1167, 1184, 1206, 340817, 1222, 1243, 1262, 1279, 1295, 1311, 1327, 1343, 1359, 1375, 1391, 328430) ORDER BY `MediaArticle`.`main_by` DESC	51	51	15
5	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	3
6	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
7	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
8	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	19
9	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
10	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

(vitacars) 10 queries took 2961 ms

Query

Error

Affected

Num. rows

Took (ms)

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

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'
ORDER BY `MediaArticle`.`main_by` DESC
LIMIT 51

1478

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'

1443

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 (339549, 331236, 352300, 322984, 331370, 4924, 365069, 811480, 292008, 297644, 36319, 344333, 36335, 36351, 36367, 36383, 348582, 36399, 36415, 36433, 36449, 36465, 36483, 5345, 327905, 323719, 319555, 357371, 319668, 1080, 1096, 1114, 1131, 1149, 311341, 1167, 1184, 1206, 340817, 1222, 1243, 1262, 1279, 1295, 1311, 1327, 1343, 1359, 1375, 1391, 328430)
ORDER BY `MediaArticle`.`main_by` DESC

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'

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'

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

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

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'

(default) 25 queries took 21 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Settings`.`id`, `Settings`.`admin_email`, `Settings`.`address`, `Settings`.`phone`, `Settings`.`phone1`, `Settings`.`phone2`, `Settings`.`email`, `Settings`.`skype`, `Settings`.`price_prefix`, `Settings`.`price_postfix`, `Settings`.`int_div`, `Settings`.`float_div`, `Settings`.`decimals`, `Settings`.`xchg_rur`, `Settings`.`sectionizer`, `Settings`.`contacts_email`, `Settings`.`orders_email`, `Settings`.`fk_price`, `Settings`.`fk_price2`, `Settings`.`brand_prices` FROM `fyre_agroby`.`settings` AS `Settings` WHERE 1 = 1 LIMIT 1	1	1	0
2	SELECT `News`.`id`, `News`.`created`, `News`.`modified`, `News`.`object_type`, `News`.`object_id`, `News`.`section`, `News`.`title`, `News`.`article_date`, `News`.`author`, `News`.`source_url`, `News`.`slug`, `News`.`teaser`, `News`.`body`, `News`.`featured`, `News`.`published`, `News`.`brand_id`, `News`.`sorting`, `News`.`price`, `News`.`active`, `News`.`cat_id`, `News`.`subcat_id`, `News`.`subdomain_id`, `News`.`views`, `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h` FROM `fyre_agroby`.`pages` AS `News` LEFT JOIN `fyre_agroby`.`media` AS `Media` ON (`Media`.`object_id` = `News`.`id` AND `Media`.`media_type` = 'image' AND `Media`.`object_type` = 'Page' AND `Media`.`main` = '1') WHERE `News`.`featured` = '1' AND `News`.`published` = '1' AND `News`.`subdomain_id` IN (0, NULL) AND `News`.`object_type` = 'News' ORDER BY `News`.`subdomain_id` DESC, `News`.`sorting` ASC, `News`.`created` DESC	8	8	4
3	SELECT `Offer`.`id`, `Offer`.`created`, `Offer`.`modified`, `Offer`.`object_type`, `Offer`.`object_id`, `Offer`.`section`, `Offer`.`title`, `Offer`.`article_date`, `Offer`.`author`, `Offer`.`source_url`, `Offer`.`slug`, `Offer`.`teaser`, `Offer`.`body`, `Offer`.`featured`, `Offer`.`published`, `Offer`.`brand_id`, `Offer`.`sorting`, `Offer`.`price`, `Offer`.`active`, `Offer`.`cat_id`, `Offer`.`subcat_id`, `Offer`.`subdomain_id`, `Offer`.`views`, `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h` FROM `fyre_agroby`.`pages` AS `Offer` LEFT JOIN `fyre_agroby`.`media` AS `Media` ON (`Media`.`object_id` = `Offer`.`id` AND `Media`.`media_type` = 'image' AND `Media`.`object_type` = 'Page' AND `Media`.`main` = '1') WHERE `Offer`.`featured` = '1' AND `Offer`.`published` = '1' AND `Offer`.`subdomain_id` IN (0, NULL) AND `Offer`.`object_type` = 'Offer' ORDER BY `Offer`.`sorting` ASC, `Offer`.`created` DESC	2	2	2
4	SELECT `Section`.`id`, `Section`.`title` FROM `fyre_agroby`.`sections` AS `Section` WHERE 1 = 1 ORDER BY `sorting` ASC	8	8	0
5	SELECT `SectionArticle`.`id`, `SectionArticle`.`created`, `SectionArticle`.`modified`, `SectionArticle`.`object_type`, `SectionArticle`.`object_id`, `SectionArticle`.`section`, `SectionArticle`.`title`, `SectionArticle`.`article_date`, `SectionArticle`.`author`, `SectionArticle`.`source_url`, `SectionArticle`.`slug`, `SectionArticle`.`teaser`, `SectionArticle`.`body`, `SectionArticle`.`featured`, `SectionArticle`.`published`, `SectionArticle`.`brand_id`, `SectionArticle`.`sorting`, `SectionArticle`.`price`, `SectionArticle`.`active`, `SectionArticle`.`cat_id`, `SectionArticle`.`subcat_id`, `SectionArticle`.`subdomain_id`, `SectionArticle`.`views` FROM `fyre_agroby`.`pages` AS `SectionArticle` WHERE `SectionArticle`.`published` = '1' AND `SectionArticle`.`object_type` = 'SectionArticle' ORDER BY `SectionArticle`.`sorting` ASC	160	160	8
6	SELECT `Page`.`slug`, `Page`.`title` FROM `fyre_agroby`.`pages` AS `Page` WHERE `slug` IN ('magazini-zapchastei', 'about-us', 'policy', 'privacy') AND `subdomain_id` = 0 AND `Page`.`object_type` = 'Page'	4	4	1
7	SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`object_type`, `Page`.`object_id`, `Page`.`section`, `Page`.`title`, `Page`.`article_date`, `Page`.`author`, `Page`.`source_url`, `Page`.`slug`, `Page`.`teaser`, `Page`.`body`, `Page`.`featured`, `Page`.`published`, `Page`.`brand_id`, `Page`.`sorting`, `Page`.`price`, `Page`.`active`, `Page`.`cat_id`, `Page`.`subcat_id`, `Page`.`subdomain_id`, `Page`.`views` FROM `fyre_agroby`.`pages` AS `Page` WHERE `Page`.`slug` = 'en-version' AND `Page`.`object_type` = 'Page' LIMIT 1	1	1	0
8	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 1 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	0	0	0
9	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 2 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	0	0	0
10	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 3 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	1	1	0
11	SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h` FROM `fyre_agroby`.`media` AS `Media` WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` = (41) ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC	4	4	1
12	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 4 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	2	2	0
13	SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h` FROM `fyre_agroby`.`media` AS `Media` WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` IN (51, 52) ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC	0	0	1
14	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 5 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	0	0	0
15	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 6 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	4	4	0
16	SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h` FROM `fyre_agroby`.`media` AS `Media` WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` IN (43, 53, 39, 56) ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC	4	4	1
17	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 7 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	1	1	0
18	SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h` FROM `fyre_agroby`.`media` AS `Media` WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` = (45) ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC	0	0	1
19	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 8 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	1	1	0
20	SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h` FROM `fyre_agroby`.`media` AS `Media` WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` = (46) ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC	0	0	1
21	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options` FROM `fyre_agroby`.`banners` AS `Banner` WHERE `slot` = 9 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC	0	0	0
22	SELECT ms., `Messenger`. FROM ( SELECT `type`, AVG(sorting) as sorting, (SELECT id FROM messengers AS mu WHERE mt.type = mu.type AND active = 1 ORDER BY used LIMIT 1 ) AS id FROM messengers AS mt WHERE mt.active = 1 GROUP BY `type` ORDER BY sorting) AS ms INNER JOIN messengers AS `Messenger` ON `Messenger`.id = ms.id ORDER BY ms.sorting	2	2	1
23	UPDATE messengers SET used = used + 1 WHERE id = 3	1	1	0
24	UPDATE messengers SET used = used + 1 WHERE id = 4	1	1	0
25	SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`object_type`, `Page`.`object_id`, `Page`.`section`, `Page`.`title`, `Page`.`article_date`, `Page`.`author`, `Page`.`source_url`, `Page`.`slug`, `Page`.`teaser`, `Page`.`body`, `Page`.`featured`, `Page`.`published`, `Page`.`brand_id`, `Page`.`sorting`, `Page`.`price`, `Page`.`active`, `Page`.`cat_id`, `Page`.`subcat_id`, `Page`.`subdomain_id`, `Page`.`views` FROM `fyre_agroby`.`pages` AS `Page` WHERE `Page`.`slug` = 'cookies' AND `Page`.`object_type` = 'Page' LIMIT 1	1	1	0

(default) 25 queries took 21 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Settings`.`id`, `Settings`.`admin_email`, `Settings`.`address`, `Settings`.`phone`, `Settings`.`phone1`, `Settings`.`phone2`, `Settings`.`email`, `Settings`.`skype`, `Settings`.`price_prefix`, `Settings`.`price_postfix`, `Settings`.`int_div`, `Settings`.`float_div`, `Settings`.`decimals`, `Settings`.`xchg_rur`, `Settings`.`sectionizer`, `Settings`.`contacts_email`, `Settings`.`orders_email`, `Settings`.`fk_price`, `Settings`.`fk_price2`, `Settings`.`brand_prices`
FROM `fyre_agroby`.`settings` AS `Settings`
WHERE 1 = 1
LIMIT 1

SELECT `News`.`id`, `News`.`created`, `News`.`modified`, `News`.`object_type`, `News`.`object_id`, `News`.`section`, `News`.`title`, `News`.`article_date`, `News`.`author`, `News`.`source_url`, `News`.`slug`, `News`.`teaser`, `News`.`body`, `News`.`featured`, `News`.`published`, `News`.`brand_id`, `News`.`sorting`, `News`.`price`, `News`.`active`, `News`.`cat_id`, `News`.`subcat_id`, `News`.`subdomain_id`, `News`.`views`, `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h`
FROM `fyre_agroby`.`pages` AS `News`
LEFT JOIN `fyre_agroby`.`media` AS `Media` ON (`Media`.`object_id` = `News`.`id` AND `Media`.`media_type` = 'image' AND `Media`.`object_type` = 'Page' AND `Media`.`main` = '1')
WHERE `News`.`featured` = '1' AND `News`.`published` = '1' AND `News`.`subdomain_id` IN (0, NULL) AND `News`.`object_type` = 'News'
ORDER BY `News`.`subdomain_id` DESC, `News`.`sorting` ASC, `News`.`created` DESC

SELECT `Offer`.`id`, `Offer`.`created`, `Offer`.`modified`, `Offer`.`object_type`, `Offer`.`object_id`, `Offer`.`section`, `Offer`.`title`, `Offer`.`article_date`, `Offer`.`author`, `Offer`.`source_url`, `Offer`.`slug`, `Offer`.`teaser`, `Offer`.`body`, `Offer`.`featured`, `Offer`.`published`, `Offer`.`brand_id`, `Offer`.`sorting`, `Offer`.`price`, `Offer`.`active`, `Offer`.`cat_id`, `Offer`.`subcat_id`, `Offer`.`subdomain_id`, `Offer`.`views`, `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h`
FROM `fyre_agroby`.`pages` AS `Offer`
LEFT JOIN `fyre_agroby`.`media` AS `Media` ON (`Media`.`object_id` = `Offer`.`id` AND `Media`.`media_type` = 'image' AND `Media`.`object_type` = 'Page' AND `Media`.`main` = '1')
WHERE `Offer`.`featured` = '1' AND `Offer`.`published` = '1' AND `Offer`.`subdomain_id` IN (0, NULL) AND `Offer`.`object_type` = 'Offer'
ORDER BY `Offer`.`sorting` ASC, `Offer`.`created` DESC

SELECT `Section`.`id`, `Section`.`title`
FROM `fyre_agroby`.`sections` AS `Section`
WHERE 1 = 1
ORDER BY `sorting` ASC

SELECT `SectionArticle`.`id`, `SectionArticle`.`created`, `SectionArticle`.`modified`, `SectionArticle`.`object_type`, `SectionArticle`.`object_id`, `SectionArticle`.`section`, `SectionArticle`.`title`, `SectionArticle`.`article_date`, `SectionArticle`.`author`, `SectionArticle`.`source_url`, `SectionArticle`.`slug`, `SectionArticle`.`teaser`, `SectionArticle`.`body`, `SectionArticle`.`featured`, `SectionArticle`.`published`, `SectionArticle`.`brand_id`, `SectionArticle`.`sorting`, `SectionArticle`.`price`, `SectionArticle`.`active`, `SectionArticle`.`cat_id`, `SectionArticle`.`subcat_id`, `SectionArticle`.`subdomain_id`, `SectionArticle`.`views`
FROM `fyre_agroby`.`pages` AS `SectionArticle`
WHERE `SectionArticle`.`published` = '1' AND `SectionArticle`.`object_type` = 'SectionArticle'
ORDER BY `SectionArticle`.`sorting` ASC

160

SELECT `Page`.`slug`, `Page`.`title`
FROM `fyre_agroby`.`pages` AS `Page`
WHERE `slug` IN ('magazini-zapchastei', 'about-us', 'policy', 'privacy') AND `subdomain_id` = 0 AND `Page`.`object_type` = 'Page'

SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`object_type`, `Page`.`object_id`, `Page`.`section`, `Page`.`title`, `Page`.`article_date`, `Page`.`author`, `Page`.`source_url`, `Page`.`slug`, `Page`.`teaser`, `Page`.`body`, `Page`.`featured`, `Page`.`published`, `Page`.`brand_id`, `Page`.`sorting`, `Page`.`price`, `Page`.`active`, `Page`.`cat_id`, `Page`.`subcat_id`, `Page`.`subdomain_id`, `Page`.`views`
FROM `fyre_agroby`.`pages` AS `Page`
WHERE `Page`.`slug` = 'en-version' AND `Page`.`object_type` = 'Page'
LIMIT 1

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 1 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 2 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 3 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h`
FROM `fyre_agroby`.`media` AS `Media`
WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` = (41)
ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 4 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h`
FROM `fyre_agroby`.`media` AS `Media`
WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` IN (51, 52)
ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 5 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 6 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h`
FROM `fyre_agroby`.`media` AS `Media`
WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` IN (43, 53, 39, 56)
ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 7 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h`
FROM `fyre_agroby`.`media` AS `Media`
WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` = (45)
ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 8 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT `Media`.`created`, `Media`.`id`, `Media`.`media_type`, `Media`.`object_type`, `Media`.`object_id`, `Media`.`file`, `Media`.`ext`, `Media`.`main`, `Media`.`orig_fname`, `Media`.`orig_fsize`, `Media`.`orig_w`, `Media`.`orig_h`
FROM `fyre_agroby`.`media` AS `Media`
WHERE `Media`.`object_type` = 'Banner' AND `Media`.`media_type` = 'image' AND `Media`.`object_id` = (46)
ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`type`, `Banner`.`slot`, `Banner`.`active`, `Banner`.`sorting`, `Banner`.`options`
FROM `fyre_agroby`.`banners` AS `Banner`
WHERE `slot` = 9 AND `active` = '1'
ORDER BY `Banner`.`sorting` ASC

SELECT ms.*, `Messenger`.* FROM ( SELECT `type`, AVG(sorting) as sorting, (SELECT id
FROM messengers AS mu
WHERE mt.type = mu.type AND active = 1
ORDER BY used
LIMIT 1 ) AS id
FROM messengers AS mt
WHERE mt.active = 1
GROUP BY `type`
ORDER BY sorting) AS ms INNER
JOIN messengers AS `Messenger` ON `Messenger`.id = ms.id ORDER BY ms.sorting

UPDATE messengers SET used = used + 1
WHERE id = 3

UPDATE messengers SET used = used + 1
WHERE id = 4

SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`object_type`, `Page`.`object_id`, `Page`.`section`, `Page`.`title`, `Page`.`article_date`, `Page`.`author`, `Page`.`source_url`, `Page`.`slug`, `Page`.`teaser`, `Page`.`body`, `Page`.`featured`, `Page`.`published`, `Page`.`brand_id`, `Page`.`sorting`, `Page`.`price`, `Page`.`active`, `Page`.`cat_id`, `Page`.`subcat_id`, `Page`.`subdomain_id`, `Page`.`views`
FROM `fyre_agroby`.`pages` AS `Page`
WHERE `Page`.`slug` = 'cookies' AND `Page`.`object_type` = 'Page'
LIMIT 1

Мы используем cookies, чтобы сделать сайт удобнее

Результаты поиска | Страница 1