count: 1104, time: 0.07396411895752
, 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 (574717,574718,574719,574720,574721,574722,574723,574724,574725,574726,574727,574728,574729,574730,574731,574732,574733,574734,574735,574736,574737,574738,574739,574740,574741,574742,574743,574744,574745,574746,574747,574748,574749,574750,574751,574752,574753,574754,574755,574756,574757,574758,574759,574760,574761,574762,574763,574764,574765,574766,574767,574768,574769,574770,574771,574772,574773,574774,574775,574776,574777,574778,574779,574780,574781,574782,574783,574784,574785,574786,574787,574788,574789,574790,574791,574792,574793,574794,574795,574796,574797,574798,574799,574800,574801,574802,574803,574804,574805,574806,574807,574808,574809,574810,574811,574812,574813,574814,574815,574816,574817,574818,574819,574820,574821,574822,574823,574824,574825,574826,574827,574828,574829,574830,574831,574832,574833,574834,574835,574836,574837,574838,574839,574840,574841,574842,574843,574844,631267,574845,574846,574847,574848,574849,574850,574851,574852,574853,574854,574855,574856,574857,574858,574859,574860,574861,574862,574863,574864,574865,574866,574867,574868,574869,574870,574871,574872,574873,574874,574875,574876,574877,574878,574879,574880,574881,574882,574883,574884,574885,574886,574887,574888,574889,574890,574891,574892,574893,574894,574895,574896,574897,574898,574899,574900,574901,574902,574903,574904,574905,574906,574907,574908,574909,574910,574911,574912,574913,574914,574915,574916,574917,574918,574919,574920,574921,574922,574923,574924,574925,574926,574927,574928,574929,574930,574931,574932,574933,574934,574935,574936,574937,574938,574939,574940,574941,574942,574943,574944,574945,574946,574947,574948,574949,574950,574951,574952,574953,574954,574955,574956,574957,574958,574959,574960,574961,574962,574963,574964,574965,574966,574967,574968,574969,574970,574971,574972,574973,574974,574975,574976,574977,574978,574979,574980,574981,574982,574983,574984,574985,574986,574987,574988,574989,574990,574991,574992,574993,574994,574995,574996,574997,574998,574999,575000,575001,575002,575003,575004,575005,575006,575007,575008,575009,575010,575011,575012,575013,575014,575015,575016,575017,575018,575019,575020,575021,575022,575023,575024,575025,575026,575027,575028,575029,575030,575031,575032,575033,575034,575035,575036,575037,575038,575039,575040,575041,575042,575043,575044,575045,575046,575047,575048,575049,575050,575051,575052,575053,575054,575055,575056,575057,575058,575059,575060,575061,575062,575063,575064,575065,575066,575067,575068,575069,575070,575071,575072,575073,575074,575075,575076,575077,575078,575079,575080,575081,575082,575083,575084,575085,575086,575087,575088,575089,575090,575091,575092,575093,575094,575095,575096,575097,575098,575099,575100,575101,575102,575103,575104,575105,575106,575107,575108,575109,575110,575111,575112,575113,575114,575115,575116,575117,575118,575119,575120,575121,575122,575123,575124,575125,575126,575127,575128,575129,575130,575131,575132,575133,575134,575135,575136,575137,575138,575139,575140,575141,575142,575143,575144,575145,575146,575147,575148,575149,575150,575151,575152,575153,575154,575155,575156,575157,575158,575159,575160,575161,575162,575163,575164,575165,575166,575167,575168,575169,575170,575171,575172,575173,575174,575175,575176,575177,575178,575179,575180,575181,575182,575183,575184,575185,575186,575187,575188,575189,575190,575191,575192,575193,575194,575195,575196,575197,575198,575199,575200,575201,575202,575203,575204,575205,575206,575207,575208,575209,575210,575211,575212,575213,575214,575215,575216,575217,575218,575219,575220,575221,575222,575223,575224,575225,575226,575227,575228,575229,575230,575231,575232,575233,575234,575235,575236,575237,575238,575239,575240,575241,575242,575243,575244,575245,575246,575247,575248,575249,575250,575251,575252,575253,575254,575255,575256,575257,575258,575259,575260,575261,575262,575263,575264,575265,575266,575267,575268,575269,575270,575271,575272,575273,575274,575275,575276,575277,575278,575279,575280,575281,575282,575283,575284,575285,575286,575287,575288,575289,575290,575291,575292,575293,575294,575295,575296,575297,575298,575299,575300,575301,575302,575303,575304,575305,575306,575307,575308,575309,575310,575311,575312,575313,575314,575315,575316,575317,575318,575319,575320,575321,575322,575323,575324,575325,575326,575327,575328,575329,575330,575331,575332,575333,575334,575335,575336,575337,575338,575339,575340,575341,575342,575343,575344,575345,575346,575347,575348,575349,575350,575351,575352,575353,575354,575355,575356,575357,575358,575359,575360,575361,575362,575363,575364,575365,575366,575367,575368,575369,575370,575371,575372,575373,575374,575375,575376,575377,575378,575379,575380,575381,575382,575383,575384,575385,575386,575387,575388,575389,575390,575391,575392,575393,575394,575395,575396,575397,575398,575399,575400,575401,575402,575403,575404,575405,575406,575407,575408,575409,575410,575411,575412,575413,575414,575415,575416,575417,575418,575419,575420,575421,575422,575423,575424,575425,575426,575427,575428,575429,575430,575431,575432,575433,575434,575435,575436,575437,575438,575439,575440,575441,575442,575443,575444,575445,575446,575447,575448,575449,575450,575451,575452,575453,575454,575455,575456,575457,575458,575459,575460,575461,575462,575463,575464,575465,575466,575467,575468,575469,575470,575471,575472,575473,575474,575475,575476,575477,575478,575479,575480,575481,575482,575483,575484,575485,575486,575487,575488,575489,575490,575491,575492,575493,575494,575495,576152,577565,577678,578870,579903,579977,579979,579980,579981,579982,579983,579984,579985,579986,579987,580147,580149,580151,580164,580165,580166,580167,580168,580169,580170,580171,596028,630989,630992,631459,631747,631759,632810,633078,637352,650618,658191,660633,660634,660635,660636,660637,660638,660801,660802,661498,662895,663094,663180,663320,663602,663620,663634,665448,665616,665966,666831,668155,668699,668916,669235,669544,670268,670310,670751,670804,670920,671269,671393,671610,671881,671952,672720,673314,673315,673715,673795,674008,674063,674205,674206,674519,674589,674878,675876,675940,676419,677224,677400,677793,677795,677798,677799,677800,677801,677802,677803,677804,677805,677806,677807,677809,678090,678268,678348,678437,678561,678567,678876,678931,679562,679591,679643,679966,680030,680078,680309,680517,680706,680792,680864,680939,681079,681170,681321,681532,681715,682055,682343,682344,682345,682545,682948,683482,684315,684644,684645,684772,686837,684886,685067,685130,685523,686508,686509,686510,686675,686881,686929,687254,687280,687309,687369,687965,687967,688245,688705,689226,689356,689796,689821,690713,690735,695349,695559,695561,695565,695734,696325,696605,697173,697242,698689,698865,698882,698948,698998,699084,699393,699422,699471,699792,700226,700617,700836,701208,701594,701798,702944,703089,707018,707019,707324,708110,708266,708372,708392,708402,708710,708717,709156,709309,709761,709767,710052,710642,710772,711294,711337,711567,711574,711604,711619,711920,711930,711995,712061,712062,712063,712202,712523,713106,713301,713930,714081,714082,714256,714345,714348,714471,714803,714976,715091,715678,715974,716037,716398,716401,716971,717716,717735,717844,717988,718042,718285,718476,718854,719173,719476,720363,721704,722602,722729,723053,723138,723139,723262,723529,723624,723625,723687,724108,725197,725365,725381,725382,725383,725384,725385,725386,725387,725388,725389,725390,725391,725392,725393,725394,725395,725396,725397,725398,725399,725400,725401,725402,725403,725404,725405,725406,725407,725408,725409,725410,725411,725412,725413,725414,725415,725416,725417,725418,725419,725420,725421,725422,725423,725424,725425,725426,725427,725428,725429,725430,725527,725528,725661,725889,726309,726821,726979,727126,727155,727605,630792), array:
