count: 233, time: 0.019672155380249
, sql: SELECT `modx_site_content`.`id` as `cid`,`modx_site_content`.`parent`,`cats`.`pagetitle` as `category`,`modx_site_content_tmc`.`sku` as `tmcsku`,`modx_site_content_tmc`.`manuf`,`modx_site_content_params`.*,`modx_site_content_sklad`.* FROM `modx_site_content` JOIN `modx_site_content_tmc` ON `modx_site_content_tmc`.`resource` = `modx_site_content`.`id` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku` = `modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku` = `modx_site_content_tmc`.`sku` LEFT JOIN (SELECT `modx_site_content`.`pagetitle`,`modx_site_content`.`parent`,`modx_site_content`.`id` FROM `modx_site_content` WHERE `template`=3) as `cats` ON `cats`.`id` = `modx_site_content`.`parent` WHERE `published`=1 AND `deleted`=0 AND `modx_site_content`.`id` IN (576035,576036,576037,576038,576059,576072,577727,578578,579865,616637,625171,630825,631004,632476,632677,632753,632754,632979,632984,633039,633108,658238,659344,659345,659346,659347,659349,659352,659353,659354,659356,659357,659388,659390,659400,659415,659416,659417,659418,659419,659420,659421,659422,659424,659425,659426,659427,659428,659429,659430,659431,659432,659433,659434,660339,660340,660341,660342,660343,660344,660345,660346,660347,660348,660349,660350,661619,662150,664062,664706,664773,664774,664775,665604,665662,665663,665664,665665,665940,665964,665987,666302,666303,666417,666418,666432,668441,668442,668562,668563,668564,669082,671122,671124,671125,671707,671978,671979,672056,672267,672310,672449,673321,675247,676289,676291,676318,677087,677461,678184,678988,679134,679478,679479,679508,679521,679581,679646,680526,680527,680529,680592,680707,682698,682976,683070,683497,683758,683787,684067,684068,684144,684201,684587,684639,684640,684642,684643,684693,684837,685008,685594,685616,686540,686547,686567,687262,688411,688513,688570,688699,690009,695344,695875,696556,698415,699432,700117,700162,700634,700854,701319,701320,701625,701899,701965,702065,702066,702067,702110,702144,702732,706826,707023,707294,707303,707740,707759,707950,708348,708374,708563,709992,710150,710637,710939,711556,711625,711658,712453,712665,714042,714079,714212,714259,715133,715134,715684,715757,715930,716353,716790,717636,717804,717831,717832,717833,717834,718328,718329,718330,718633,718638,719259,719267,719633,719644,719789,721776,722112,722699,722925,723617,723699,724068,724109,724124,724170,724503,724725,725372,727264,709284), array:
