count: 100, time: 0.012511968612671
, 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 (577610,623772,579054,579055,615355,615409,627151,627152,627153,627154,627155,627156,627157,627158,627159,627160,627161,627162,627163,627164,627165,627166,627167,627168,627169,627170,627171,627172,627173,627174,627175,627176,627177,627178,627179,627180,627181,627182,627183,627184,627185,627186,627187,627188,627189,659389,659395,661577,663024,663750,664056,667958,667959,701656,668768,669182,670239,670714,670715,670716,671094,671095,671096,671097,671098,682190,684304,698717,699664,702628,702629,702630,702631,702632,702633,702634,702635,702636,702637,702638,702639,702640,702641,702642,702643,702644,702645,702646,702647,710840,712175,715571,719226,723649,724769,699216,699603,700072,701657,708608), array:
