Выборка за текущий год, месяц.

0.0001462: pdoTools loaded
0.0000360: xPDO query object created
0.0000670: Added TVs filters
0.0005841: Included list of tvs: comment, expert_photo, HitsPage
0.0004621: leftJoined modTemplateVarResource as TVcomment
0.0003810: leftJoined modTemplateVarResource as TVexpert_photo
0.0003750: leftJoined modTemplateVarResource as TVhitspage
0.0007579: Added selection of modResource: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000200: Added selection of modTemplateVarResource: IFNULL(`value`, '0') AS `tv.comment`
0.0000160: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `tv.expert_photo`
0.0000160: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `tv.HitsPage`
0.0000908: Replaced TV conditions
0.0000730: Processed additional conditions
0.0007062: Added where condition: createdon:>=2014-05-28 00:00:00, 0=`TVhitspage`.`value` > '10', modResource.parent:IN(19,12,7976,8108,8209,8311,15594), modResource.published=1, modResource.deleted=0, modResource.isfolder=0
0.0000858: Replaced TV conditions
0.0002980: Sorted by modResource.publishedon, DESC
0.0000081: Limited to 5, offset 0
0.0007181: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, IFNULL(`TVcomment`.`value`, '0') AS `tv.comment`, IFNULL(`TVexpert_photo`.`value`, '') AS `tv.expert_photo`, IFNULL(`TVhitspage`.`value`, '') AS `tv.HitsPage` FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `TVcomment` ON `TVcomment`.`contentid` = `modResource`.`id` AND `TVcomment`.`tmplvarid` = 15 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVexpert_photo` ON `TVexpert_photo`.`contentid` = `modResource`.`id` AND `TVexpert_photo`.`tmplvarid` = 7 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVhitspage` ON `TVhitspage`.`contentid` = `modResource`.`id` AND `TVhitspage`.`tmplvarid` = 8 WHERE  ( `modResource`.`createdon` > '2014-05-28 00:00:00' AND `TVhitspage`.`value` > '10' AND `modResource`.`parent` IN (19,12,7976,8108,8209,8311,15594) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 AND `modResource`.`isfolder` = 0 )  ORDER BY modResource.publishedon DESC LIMIT 5 "
0.0627708: SQL executed
0.0002000: Total rows: 536
0.0001361: Rows fetched
0.0064921: Prepared and processed TVs
0.0020850: Loaded chunk "tmp"
0.0193532: Returning processed chunks
0.0939331: Total time
19 660 800: Memory usage