count: 91, time: 0.014633893966675
, 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 (578319,615569,616608,631324,631505,661988,661989,661990,661992,661993,662097,662729,666271,670522,671413,671787,673291,681360,681566,682393,683111,695736,698043,701378,702725,706814,706972,707024,707994,707999,708000,708001,708003,708004,708005,708006,708007,708008,708009,708010,708011,708012,708013,708014,708015,708400,708994,709872,711241,712566,714765,715306,715547,715548,715549,717673,717676,717677,717678,717679,717680,717788,717789,717792,717793,717851,718706,719194,719309,719359,719804,720255,721410,721572,721573,721574,721575,721576,721588,721589,721591,721592,721944,721945,722023,722024,724535,724536,725474,725919,725920,726711,726902,707966), array:
