count: 605, time: 0.046581029891968
, 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 (577518,577611,578823,578824,579179,579288,615827,615829,615830,615831,615832,615835,615836,615837,615840,616498,616501,688607,689105,689106,689107,689108,689109,689131,689760,689761,695608,695609,695610,695611,695612,695613,695635,695956,696581,696582,696583,700777,700778,700779,700780,700781,700782,700783,700784,700785,700786,700787,700788,700789,700790,700791,700792,701223,707004,707215,707262,707263,707264,707265,707266,707267,707277,707278,707279,707332,707333,707505,707511,707512,707513,707823,708613,708614,711503,711504,711505,711506,711507,711508,711509,625308,711534,712424,712425,712426,712428,712429,712430,712431,712432,712433,712434,712438,712439,712440,712441,712444,712445,712449,712624,714662,716461,717098,717105,717799,717800,717830,717895,719229,725685,725686,726915,658622,663273,663274,663275,663276,663277,666215,668569,668570,668856,669923,670901,671278,672074,674362,674980,677602,678019,679273,679274,679516,681612,681613,681614,681615,681616,681989,682241,682789,682790,682802,682803,682804,682805,682806,682807,682808,682809,682810,682813,682814,682815,682816,682817,682818,682831,682832,682833,682834,683403,683447,683781,683782,688420,688421,688422,688423,688424,688425,688426,578937,579221,579222,579223,579224,579225,689167,698542,700506,707006,707401,708404,713925,718153,718594,718595,718718,719223,719660,719787,719788,719796,720240,720243,720500,720502,721951,722929,723651,724862,725798,725886,725906,726286,726800,726809,726843,726985,727138,711810,711811,711812,711813,711814,711815,711816,631241,631242,631243,631609,651260,666128,670802,681595,579002,631237,631238,631239,631240,661951,617697,617698,617699,617700,617701,617702,617703,617704,617705,617706,617707,617708,617709,617710,617711,617712,617713,617714,617715,617716,617717,617718,617719,617720,617721,617722,617723,617724,617725,617726,617727,617728,617729,617730,617731,617732,617733,617734,617735,617736,617737,617738,617739,617740,617741,617742,617743,617744,617745,617746,617747,617748,617749,617750,617751,617752,617753,617754,617755,617756,617757,617758,617759,617760,617761,617762,617763,617764,617765,617766,617767,617768,617769,617770,617771,617772,617773,617774,617775,617776,617777,617778,617779,617780,617781,617782,617783,617784,617785,617786,617787,617788,617789,617790,617791,617792,617793,617794,617795,617796,617797,617798,617799,617800,617801,617802,617803,617804,617805,617806,617807,617808,617809,617810,617811,617812,617813,617814,617815,689194,696284,696285,696286,696287,696288,696289,696290,696291,696292,696293,696294,696295,698777,698778,699005,699988,700410,701040,701818,702088,702230,706848,706872,707075,707517,707519,707971,708077,713956,714119,719525,721374,724581,724582,637515,637516,661779,666069,666300,666301,666310,668032,670335,672202,672203,674044,676302,678062,678155,678593,678744,679171,680485,681941,682299,682501,684438,687018,696108,700070,700260,712642,712643,712644,725985,627466,627467,627468,627469,627470,627471,627472,627473,627474,627475,627476,627477,627478,627479,637476,637477,671151,688823,690295,700621,701549,702035,702121,702536,702537,702542,702543,703075,707766,707864,708475,708512,708611,709018,713191,713959,713962,713963,715419,716017,716806,719078,720027,723803,725566,628273,628274,628275,628276,628277,628278,628279,628280,628281,628282,628283,628284,628285,628286,628287,628288,628289,628290,628291,628292,628293,628294,628295,628296,628297,628298,628299,628300,628301,628302,658063,661952,662147,664234,664235,668100,668263,670786,671445,675842,676991,677161,678377,678378,678379,678380,678381,678382,682375,682859,683007,683154,683537,684306,713141,714207,628816,628817,628818,628819,628820,628821,628822,628823,628824,628825,628826,628827,628828,628829,630673,630674,630675,630676,630677,630678,630679,630680,630681,630682,630683,630684,630685,630686,630687,630688,630689,630690,630691,630692,630693,630694,630695,630696,630697,630698,630699,630700,637494,663397,676366,699694,699983,700150,702231,702232,702997,707061,707520,709260,712446,713823,713961,715156,717036,720511,722310,722936,722980,725610,726613,628786,628788,628789,628790,628791,628793,628794,628795,628797,628798,628799,628801,628802,628803,628804,628805,628806,628807,628808,628809,628810,628811,628812,628813,628814,628815,670671,671674), array:
