| 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 `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`, `Seo`.`id`, `Seo`.`object_type`, `Seo`.`object_id`, `Seo`.`title`, `Seo`.`descr`, `Seo`.`keywords` 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') LEFT JOIN `fyre_agroby`.`seo` AS `Seo` ON (`Seo`.`object_id` = `News`.`id` AND `Seo`.`object_type` = 'Page') WHERE `slug` = 'deutz-fahr-prezentoval-modeli-traktorov-6-serii' AND `subdomain_id` IN (0, NULL) AND `News`.`object_type` = 'News' ORDER BY `subdomain_id` DESC LIMIT 1 | | 1 | 1 | 1 |
| 5 | UPDATE `fyre_agroby`.`pages` SET views = views + 1 WHERE id = 27 | | 1 | 1 | 0 |
| 6 | SELECT `Section`.`id`, `Section`.`title` FROM `fyre_agroby`.`sections` AS `Section` WHERE 1 = 1 ORDER BY `sorting` ASC | | 8 | 8 | 0 |
| 7 | 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 | 7 |
| 8 | 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 | 0 |
| 9 | 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`, `Seo`.`id`, `Seo`.`object_type`, `Seo`.`object_id`, `Seo`.`title`, `Seo`.`descr`, `Seo`.`keywords` FROM `fyre_agroby`.`pages` AS `Page` LEFT JOIN `fyre_agroby`.`seo` AS `Seo` ON (`Seo`.`object_id` = `Page`.`id` AND `Seo`.`object_type` = 'Page') WHERE `Page`.`slug` = 'en-version' AND `Page`.`object_type` = 'Page' LIMIT 1 | | 1 | 1 | 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` = 1 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC | | 0 | 0 | 0 |
| 11 | 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 |
| 12 | 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 |
| 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` = (41) ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC | | 4 | 4 | 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` = 4 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC | | 2 | 2 | 0 |
| 15 | 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 |
| 16 | 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 |
| 17 | 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 |
| 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` IN (43, 53, 39, 56) ORDER BY `Media`.`main` DESC, `media_type` ASC, `id` ASC | | 4 | 4 | 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` = 7 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` = (45) 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` = 8 AND `active` = '1' ORDER BY `Banner`.`sorting` ASC | | 1 | 1 | 0 |
| 22 | 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 |
| 23 | 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 |
| 24 |
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 | 0 |
| 25 | UPDATE messengers SET used = used + 1 WHERE id = 3 | | 1 | 1 | 0 |
| 26 | UPDATE messengers SET used = used + 1 WHERE id = 4 | | 1 | 1 | 0 |
| 27 | 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`, `Seo`.`id`, `Seo`.`object_type`, `Seo`.`object_id`, `Seo`.`title`, `Seo`.`descr`, `Seo`.`keywords` FROM `fyre_agroby`.`pages` AS `Page` LEFT JOIN `fyre_agroby`.`seo` AS `Seo` ON (`Seo`.`object_id` = `Page`.`id` AND `Seo`.`object_type` = 'Page') WHERE `Page`.`slug` = 'cookies' AND `Page`.`object_type` = 'Page' LIMIT 1 | | 1 | 1 | 0 |