count: 164, time: 0.022352933883667
, 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 (575989,577794,578341,578347,578378,578652,578676,578875,579096,579110,579320,630964,630965,631634,632658,651773,657247,657564,662572,662818,663353,663625,663817,665519,666282,667130,667547,667559,670219,670220,671485,673313,673879,676693,677531,677682,677689,677816,677817,677921,677997,678651,577932,678894,678962,679855,680094,689072,689112,680364,689126,689391,681145,689699,689700,681827,689888,682450,690152,682838,690463,682839,695930,698356,698545,578128,683463,683464,683479,684174,684682,685386,685563,685689,686886,687127,687181,698692,698783,699474,699613,699614,700425,700725,702235,702578,702716,706927,707168,707214,708291,708474,708486,709462,709596,709597,709599,709615,709841,710010,711880,713159,714338,714669,714808,714946,718029,719295,719465,719986,720336,721523,722941,723146,723250,723808,723811,723934,725285,725328,725545,726188,725705,727065,579115,579678,579753,611565,616630,619257,631006,631007,631064,631469,631470,632475,632670,632824,651270,657666,657717,658289,658290,662599,663127,663854,667296,667937,669014,671031,671918,672371,673169,675198,675200,676661,676980,677050,679911,681680,681888,684390,687275,687781,689341), array: