count: 391, time: 0.035519123077393
, 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 (575839,575913,576090,576175,576208,576210,576370,576398,577574,577679,577858,577903,578227,578336,578497,578524,579364,580451,580452,580453,580454,580455,580456,580457,580458,580459,580460,580461,580462,580463,580464,580465,580466,580467,580468,580469,580470,580471,580472,580473,580474,580475,580476,580477,580478,580479,580480,580481,580482,580483,580484,580485,580486,580487,580488,580489,580490,580491,580492,580493,580494,580495,580496,580497,580498,580499,580500,580501,580502,580503,580504,580505,580506,580507,580508,580509,580510,714615,714810,714886,714909,715222,715338,715765,715766,715777,716252,716322,716364,716559,716793,717065,717066,717075,717700,717739,717774,717941,717949,718245,718388,718479,718593,718713,718714,718715,718740,718891,719362,719826,720323,721165,721405,721521,721675,721810,721838,722063,722542,722543,722544,722545,722680,722682,722685,722686,722687,723284,723302,724086,724106,724771,725227,725599,725927,726289,726535,726536,726537,726544,726545,726546,726547,726548,726549,726571,726572,726573,726574,726778,727045,727056,727198,727199,727209,727210,727213,727255,727256,727663,727664,727802,595941,612868,616233,625220,631009,631614,632355,632863,650882,651274,657764,658396,659107,660704,660711,661949,662319,662363,662819,662912,662913,663182,663205,663284,663745,663983,664465,664475,664476,664572,665124,665602,665626,665683,666357,666374,666414,666926,667294,667624,667628,667811,667812,667861,668039,668239,668332,668830,669064,669157,669303,669415,669459,669502,670024,670096,670392,670727,670780,670972,671350,671440,671461,671608,671701,671798,671799,671818,672070,672087,672392,672578,672603,672657,672772,673748,673799,673881,674697,674864,675018,675342,676434,676553,676595,676735,676849,677219,677312,677396,677534,677929,677933,677975,678014,678336,678343,678533,678618,678619,678640,678989,679252,679316,679796,680009,680024,680174,680177,680283,680908,681066,681077,682191,682352,682486,682836,683241,683258,683293,684223,684298,684524,684525,684661,684724,684795,684828,684829,684831,685041,685463,685474,685573,685688,686619,687228,687272,687330,687957,687960,688093,688152,689116,689132,689135,689360,689894,690031,690263,690311,690384,690392,690481,690530,690688,695508,697046,697212,698054,698171,698550,698559,698571,698572,699094,699159,699691,700269,700389,700465,700576,700603,700679,700687,700701,700717,700757,700979,701085,701322,701488,701729,702339,702653,702748,706862,706934,707003,707099,707254,707427,708308,708331,708720,708842,709024,709297,709708,709967,709969,710139,710146,710297,710332,710333,710334,710335,710336,710341,710342,710707,710708,710949,711021,711101,711559,711641,711743,711821,712324,712559,712716,712769,713285,713913,713914,714036,714289), array:
