count: 259, time: 0.020693063735962
, 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 (578415,578932,632742,651750,657450,657921,658263,658764,658982,659387,661509,661641,662789,664274,664275,664873,665846,666007,666019,666026,666064,666227,666590,666659,666711,666919,666973,667325,667473,667665,667756,668280,668465,668466,668815,668816,668898,669178,669315,669345,669984,670071,670081,670103,670128,670165,670222,670223,670264,670265,670482,670494,670531,671114,671422,671637,672007,682502,672015,672276,672398,683179,672627,683180,672628,683181,673383,673744,674474,674686,674749,674790,674945,675078,685114,675641,675693,675746,675817,676258,676853,676862,677412,678052,678141,678142,678143,678920,678929,678958,679610,680235,680326,680366,680491,680492,680493,680494,680607,680611,680642,681039,681071,681121,681599,681683,682176,683028,683248,683355,683356,683383,683507,683529,684075,684177,684300,684359,684496,684691,685000,685191,685222,685707,687087,687088,687297,687840,688173,688408,695304,688935,695333,689074,695334,689075,695667,689315,695922,689746,699067,690340,699123,690341,699283,690418,700620,690419,700659,690491,701191,701387,701511,701700,701993,702284,702825,702831,707283,708193,708814,708815,708816,708817,709266,709010,709711,711216,712946,712947,712948,712949,712950,712951,712952,712953,712954,712955,712956,712957,712960,712961,712962,712963,712964,713273,713601,713602,713603,713604,713605,713606,713607,713608,713609,713610,713611,713612,713613,713614,713615,713616,713617,713618,713619,713620,713621,713622,713623,713624,713625,713626,713627,713628,713629,713630,713631,713632,713633,713634,713635,713636,713637,713638,713639,713640,713641,713642,713643,713644,713645,713948,713966,714445,714574,718253,718765,719127,719727,720046,720566,658212,723144,723186,723900,724914,725807,726726,658763,727554,727570,720425,716347,726664,718831,663744,707372,667398,677099), array:
