This is what I got
<pre>0.0000761: pdoTools loaded
0.0000210: xPDO query object created
0.0005250: Included list of tvs: <b>Foireann_1_Crest, Foireann_1_Name, Foireann_1_Score, Cluiche_Competition, Cluiche_Date, Cluiche_Venue, Foireann_2_Crest, Foireann_2_Name, Foireann_2_Score</b>
0.0001080: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVfoireann_1_crest</b>
0.0000701: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVfoireann_1_name</b>
0.0000679: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVfoireann_1_score</b>
0.0001199: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVcluiche_competition</b>
0.0000699: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVcluiche_date</b>
0.0000679: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVcluiche_venue</b>
0.0000679: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVfoireann_2_crest</b>
0.0000682: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVfoireann_2_name</b>
0.0000849: leftJoined <i>MODX\Revolution\modTemplateVarResource</i> as <b>TVfoireann_2_score</b>
0.0000951: Added selection of <b>modResource</b>: <small>`id`, `type`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `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`, `alias_visible`</small>
0.0000041: Added selection of <b>TVfoireann_1_crest</b>: <small>IFNULL(`value`, 'assets/images/crests/cpnag/cpnag-default.png') AS `tv.Foireann_1_Crest`</small>
0.0000029: Added selection of <b>TVfoireann_1_name</b>: <small>IFNULL(`value`, '') AS `tv.Foireann_1_Name`</small>
0.0000019: Added selection of <b>TVfoireann_1_score</b>: <small>IFNULL(`value`, '0-00') AS `tv.Foireann_1_Score`</small>
0.0000021: Added selection of <b>TVcluiche_competition</b>: <small>IFNULL(`value`, '') AS `tv.Cluiche_Competition`</small>
0.0000019: Added selection of <b>TVcluiche_date</b>: <small>IFNULL(`value`, '') AS `tv.Cluiche_Date`</small>
0.0000021: Added selection of <b>TVcluiche_venue</b>: <small>IFNULL(`value`, '') AS `tv.Cluiche_Venue`</small>
0.0000019: Added selection of <b>TVfoireann_2_crest</b>: <small>IFNULL(`value`, 'assets/images/crests/cpnag/cpnag-default.png') AS `tv.Foireann_2_Crest`</small>
0.0000021: Added selection of <b>TVfoireann_2_name</b>: <small>IFNULL(`value`, '') AS `tv.Foireann_2_Name`</small>
0.0000010: Added selection of <b>TVfoireann_2_score</b>: <small>IFNULL(`value`, '0-00') AS `tv.Foireann_2_Score`</small>
0.0000360: Replaced TV conditions
0.0005000: Processed additional conditions
0.0006590: Added where condition: <b>isfolder:==0, template:==15, `TVcluiche_date`.`value`:>=2024-05-24 15:56, modResource.parent:IN(10,156,250,274,158,184,157,254,255,256,257,258,264,265,259,260,261,266,267,268,269,298,299,300,301,302,262,263,270,271,303,251,252,297,275,276,168,181,175,182,197,169,170,171,172,173,174,176,177,178,183,206,208,229,179,180,207,221,222,223,224,225,226,227,228,232,201,202,203,204,205,230,231,196,198,199,200,185,187,189,190,186,191,188,192,193,194,195,216,217,218,219,220,246,247,272,273,159,161,166,160,162,163,164,165,167,244,245), modResource.published=1, modResource.deleted=0</b>
0.0000060: Replaced TV conditions
0.0000579: Sorted by <b>CAST(`TVcluiche_date`.`value` AS DATETIME)</b>, <b>ASC</b>
0.0000019: Limited to <b>9999</b>, offset <b>1</b>
0.0004470: SQL prepared <small>"SELECT `modResource`.`id`, `modResource`.`type`, `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`.`content`, `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`, `modResource`.`alias_visible`, IFNULL(`TVfoireann_1_crest`.`value`, 'assets/images/crests/cpnag/cpnag-default.png') AS `tv.Foireann_1_Crest`, IFNULL(`TVfoireann_1_name`.`value`, '') AS `tv.Foireann_1_Name`, IFNULL(`TVfoireann_1_score`.`value`, '0-00') AS `tv.Foireann_1_Score`, IFNULL(`TVcluiche_competition`.`value`, '') AS `tv.Cluiche_Competition`, IFNULL(`TVcluiche_date`.`value`, '') AS `tv.Cluiche_Date`, IFNULL(`TVcluiche_venue`.`value`, '') AS `tv.Cluiche_Venue`, IFNULL(`TVfoireann_2_crest`.`value`, 'assets/images/crests/cpnag/cpnag-default.png') AS `tv.Foireann_2_Crest`, IFNULL(`TVfoireann_2_name`.`value`, '') AS `tv.Foireann_2_Name`, IFNULL(`TVfoireann_2_score`.`value`, '0-00') AS `tv.Foireann_2_Score` FROM `cpnag_site_content` AS `modResource` LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVfoireann_1_crest` ON `TVfoireann_1_crest`.`contentid` = `modResource`.`id` AND `TVfoireann_1_crest`.`tmplvarid` = 1 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVfoireann_1_name` ON `TVfoireann_1_name`.`contentid` = `modResource`.`id` AND `TVfoireann_1_name`.`tmplvarid` = 2 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVfoireann_1_score` ON `TVfoireann_1_score`.`contentid` = `modResource`.`id` AND `TVfoireann_1_score`.`tmplvarid` = 3 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVcluiche_competition` ON `TVcluiche_competition`.`contentid` = `modResource`.`id` AND `TVcluiche_competition`.`tmplvarid` = 4 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVcluiche_date` ON `TVcluiche_date`.`contentid` = `modResource`.`id` AND `TVcluiche_date`.`tmplvarid` = 5 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVcluiche_venue` ON `TVcluiche_venue`.`contentid` = `modResource`.`id` AND `TVcluiche_venue`.`tmplvarid` = 6 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVfoireann_2_crest` ON `TVfoireann_2_crest`.`contentid` = `modResource`.`id` AND `TVfoireann_2_crest`.`tmplvarid` = 7 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVfoireann_2_name` ON `TVfoireann_2_name`.`contentid` = `modResource`.`id` AND `TVfoireann_2_name`.`tmplvarid` = 8 LEFT JOIN `cpnag_site_tmplvar_contentvalues` `TVfoireann_2_score` ON `TVfoireann_2_score`.`contentid` = `modResource`.`id` AND `TVfoireann_2_score`.`tmplvarid` = 9 WHERE ( `modResource`.`isfolder` = 0 AND `modResource`.`template` = 15 AND `TVcluiche_date`.`value` > '2024-05-24 15:56' AND `modResource`.`parent` IN (10,156,250,274,158,184,157,254,255,256,257,258,264,265,259,260,261,266,267,268,269,298,299,300,301,302,262,263,270,271,303,251,252,297,275,276,168,181,175,182,197,169,170,171,172,173,174,176,177,178,183,206,208,229,179,180,207,221,222,223,224,225,226,227,228,232,201,202,203,204,205,230,231,196,198,199,200,185,187,189,190,186,191,188,192,193,194,195,216,217,218,219,220,246,247,272,273,159,161,166,160,162,163,164,165,167,244,245) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 ) ORDER BY CAST(`TVcluiche_date`.`value` AS DATETIME) ASC LIMIT 1, 9999 "</small>
0.0054932: SQL executed
0.0001419: Rows fetched
0.9959071: Prepared and processed TVs
0.0011420: Loaded "modChunk" with name "gameUpcomingHome"
0.0290990: Returning processed chunks
1.0334880: <b>Total time</b>
6 291 456: <b>Memory usage</b>
</pre>