count: 604, time: 0.078090906143188
, 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 (577928,578163,578416,578469,718602,718604,667786,578781,579134,579701,579702,579939,580162,611573,612944,615338,615581,615696,615927,615932,718040,718508,718509,717663,718510,717666,718511,717975,718530,718531,718532,718695,718728,718732,718774,718787,718804,718845,718982,718985,718999,719081,719121,719182,719340,719427,719441,719511,719729,719990,720215,720220,720275,720581,695758,718001,721413,721493,721506,721797,722021,722064,722098,722363,722410,722421,722588,722826,722943,723037,723187,723265,723285,723534,723582,723637,723726,724063,724148,724156,724168,724538,724564,724574,724676,724770,724772,724797,724807,725311,725460,725510,725654,725804,726057,726505,726511,726769,726837,726866,726867,726935,727142,727150,727551,727625,727806,727940,727960,727984,727992,715717,715718,630751,630754,630788,631119,631152,631178,631180,631181,631188,631216,631301,631592,631662,631741,631969,631976,631982,632088,632094,632104,632335,632417,632437,632700,632750,632769,632783,650523,650559,650848,650919,651558,651583,651736,651760,657341,657583,657584,657592,657680,657930,658122,658565,661207,661209,661226,661267,662347,662735,662966,663040,663408,663410,663535,663670,664124,664969,665119,665234,665277,665363,665609,665632,666296,666333,666349,666477,666535,666582,666583,666836,667034,667696,667943,668097,668181,668224,668447,668606,668648,668914,669165,669200,669370,669658,669852,670023,670092,670243,670295,670296,670393,670400,670549,670593,670941,671128,671129,671416,671930,671945,672445,672465,672500,672702,672713,672886,673161,673527,673634,674567,674593,674640,674737,674944,674964,675003,675374,675381,675451,675481,675483,675544,675549,675564,675584,675795,676009,676205,676283,676584,676586,676757,676938,677019,677053,677410,677504,677535,677735,678039,678181,678422,678424,678426,678724,678855,678865,679114,679732,679750,679772,679841,680029,680195,680228,680420,680490,680499,680564,680623,680636,680637,680705,680791,681296,681298,681897,682007,682048,682144,682205,682237,682880,683151,683152,683267,683435,683436,683754,683832,684011,684159,684662,684678,684694,685042,685043,685089,685429,685450,685720,686586,686633,686694,686854,686904,687162,687334,687421,687722,687746,687975,688328,688405,688926,689546,689859,689910,690139,690413,690655,690657,695307,695345,695873,698727,696191,698824,698851,698883,698884,696407,696478,696482,699160,699163,699194,699223,699228,699276,699289,699309,699310,696727,696728,699394,699434,697154,699496,697175,699533,699626,699741,699760,698018,699890,699921,698075,699926,699959,698197,700122,700123,698337,698349,700240,698355,700247,700276,700299,700329,700375,700390,700409,700413,700518,700519,700522,700523,700524,700525,700633,700641,700646,700686,700690,700694,700695,700696,700697,700742,700798,700887,701023,701049,701104,701252,701256,701282,701321,701374,701464,701491,701637,701673,701676,701709,701737,701787,701873,701920,702074,702097,702113,702174,702215,702271,702293,702302,702329,702360,702418,702556,702623,702659,702689,702811,702852,702868,702870,702989,703253,706810,706830,706851,706930,706979,707001,707010,707051,707292,707293,707448,707599,707602,707733,707747,707753,707774,707780,707781,707827,707992,708078,708169,708191,708286,708347,708351,708428,708470,708601,708848,708877,708949,708970,708977,709232,709321,709451,709456,709486,709491,709530,709729,709742,709743,709816,709879,709880,709889,709944,709996,709997,710016,710044,710055,710086,710257,710259,710302,710503,710648,710692,710715,710749,710765,710795,710829,710836,710854,710910,711130,711131,711174,711215,711244,711284,711333,711372,711563,711572,711579,711603,711623,711746,711830,711919,712076,712207,712208,712225,712349,712437,712458,712466,712488,712516,712544,712689,712715,712808,712818,712829,712859,712862,712863,712891,712927,718709,713227,713897,714002,714217,714268,714407,714440,714441,714565,714607,714642,714645,720569,714663,714759,714761,714887,714888,715164,715165,715166,715231,715272,715344,715546,715600,715601,715602,715603,715604,715605,715606,715607,715608,715609,715610,715612,715613,715614,715615,715616,715617,715618,715619,715635,715794,715906,715956,715960,716016,716317,716150,716349,716387,716427,716467,716528,716593,716717,716898,717017), array:
