count: 152, time: 0.019479036331177
, 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 (578451,579978,625177,625249,628514,628515,628516,628517,628518,628519,628520,628521,628522,628523,628524,628525,628526,628527,628528,628529,628530,628531,628532,628533,628534,628535,628536,628537,628538,628539,628540,628541,628542,628543,628544,628545,628546,628547,628548,628549,628550,628551,628552,628553,628554,628555,628556,628557,628558,628559,628560,628561,628562,628563,628564,628565,628566,628567,628568,628569,628570,628571,628572,628573,628574,628575,628576,628577,628578,628579,628580,628581,628582,628583,628584,628585,628586,628587,628588,628589,628590,628591,628592,628593,631022,631104,632011,637493,658190,659465,664149,667678,667853,668827,669002,669597,669598,669599,669600,669601,669602,669603,669604,669606,669651,670783,672097,679190,683593,683594,684444,684445,684893,686718,686719,686720,688256,700173,701030,701031,701032,701033,701034,701035,701499,707190,707409,708482,709095,709104,710539,710714,710809,710810,712217,715242,715246,717641,717784,717926,718020,719145,721648,723018,723338,723682,724055,724561,724675,724849,724850,726331), array:
