count: 2173, time: 0.13412809371948
, 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 (195,196,197,628594,628595,628596,628597,628598,628599,628600,628601,628602,628603,628604,628605,628606,628607,628608,628609,631103,632865,658404,661959,661960,662481,662678,663009,664251,664656,667966,668201,668501,668695,669098,669784,669836,670293,670510,671813,671910,673526,674062,674666,674748,674903,675380,676855,679452,679551,680477,680819,681833,681837,682256,682257,682772,683564,683750,687357,687358,688049,688317,688406,688781,712197,696061,697106,697151,579201,615806,615942,631578,632714,632715,651060,651166,651167,651477,651817,657368,657818,658409,658603,661152,661153,661507,661508,661802,661908,662800,663059,663253,663341,663348,664021,664022,664254,664286,664306,664307,664498,664803,664966,665211,665257,666023,666024,666025,666085,666214,666663,667073,667268,667586,667742,667960,667978,668157,668682,670080,670307,670501,670927,670967,671498,671981,672321,672665,672792,672793,673068,673183,673738,674791,675276,676871,676974,677967,678337,678391,678402,678552,678718,678830,679141,679449,679677,679801,679908,679909,680446,680766,681110,681237,681525,681528,681564,682125,682274,682346,682851,682941,683221,683317,683443,683587,683707,683797,684051,684310,684317,684665,684716,684804,684931,684954,685026,685142,685395,685520,687196,688435,688789,689009,689137,690033,690216,690350,690400,690406,690414,695294,695642,695953,696641,696653,696737,697110,697194,698263,698264,698265,698266,698267,698411,698557,698558,698642,699375,699506,700416,700484,700559,700673,701170,701332,701365,701614,701626,702094,702866,702903,706957,706973,707140,707206,707208,707385,708539,710450,708955,710667,709098,710693,709311,711255,709449,711259,709681,711396,711565,711874,713869,713870,714460,714798,714809,715064,715967,716026,716332,716812,718015,718024,718251,718492,718635,719744,719745,720940,721563,721601,721893,721973,723048,723886,724912,723918,725295,724072,725812,726710,727160,727538,727544,727624,727818,576135,578452,632864,636446,658426,661406,663815,663816,663984,665773,666021,666022,667300,667722,667837,667996,668130,668131,668763,668993,669540,669834,670135,670278,670805,670952,670962,671026,671429,672313,672885,673398,673606,673797,673798,674268,674288,674387,674500,674501,674762,674847,674899,675025,675403,675655,675656,675861,676065,676369,676410,677574,678251,678252,678388,679307,679541,679913,680192,681454,683039,683189,683197,683492,684353,684412,684428,684494,686935,687417,687907,688076,688330,688333,688369,688510,688524,688525,690268,690366,690524,695628,698026,698099,698380,698940,699876,700057,700508,700753,700910,701646,702346,702562,703006,703052,707575,707635,707719,707848,707989,708284,708592,708734,709529,709864,710013,710114,710842,711894,712239,712664,712243,712816,715307,715308,717110,717655,719058,719316,719334,719335,719336,719623,720932,721170,721180,722016,722629,722912,722913,722914,722915,722916,722917,722918,723097,723123,723328,723329,723330,723588,724701,725309,725364,725473,725517,725518,725521,725975,726123,726222,726252,726253,726254,726850,726930,726986,727790,717202,575664,575669,575670,575671,625172,575672,575832,575903,575906,575990,575991,575992,575993,575994,575995,576014,576239,576240,576270,576289,576317,576318,576374,576375,576463,576464,576465,576605,576664,577556,577766,577784,577836,577837,577870,577902,578121,578277,578278,578334,578460,578461,578462,672766,578468,578471,578498,578505,578611,578680,578681,578734,578822,578928,579041,579113,579118,579119,682243,579120,579121,579123,579124,579126,683619,579162,579194,579196,579269,579452,579543,579646,579787,579889,579995,580051,612766,612866,612870,613391,615422,615423,615782,615783,615973,616258,616267,616456,616484,616536,625227,625274,625275,626317,626318,626319,626320,626321,626322,626323,626324,626325,626326,626327,626328,626329,626330,626331,708151,626332,626333,626334,626335,626336,626337,626338,626339,626340,626341,626342,626343,626344,626345,626346,626347,626348,626349,630943,630944,630977,630978,631233,631268,631299,631409,631440,631479,631480,631481,631556,631584,631704,631705,631707,631708,631803,631853,632117,632118,632250,632332,632333,632334,632339,632386,632424,632524,632610,632840,632897,632972,632973,633063,633099,633160,633183,636198,637342,650668,650796,651049,651200,651320,651348,651354,651541,651553,711485,651585,651604,651619,651748,651751,651775,651819,657212,657266,657269,657270,657271,657291,657423,657424,657432,657566,657638,657721,657727,657728,657734,657735,657773,657775,657860,657870,657934,657970,658124,658125,658133,658140,658142,658144,658146,658147,658220,658237,658244,658246,658247,658248,658250,658268,658336,658386,658393,658430,658560,658808,658827,658828,658869,658990,659310,659312,660054,660055,660056,660057,660058,660060,660061,660719,660720,660721,660722,660723,660724,660725,660726,660727,660728,660729,660730,660731,660732,660733,660734,660735,660736,660737,660738,660739,660740,660741,660742,660743,660744,660745,660746,660747,660748,660749,660750,660751,660752,660753,660754,660755,660756,660757,660758,660759,660760,660761,660762,660763,660764,660765,660766,660767,660768,660769,660770,660771,660772,660773,660774,660775,660776,660777,660778,660779,660780,660781,660782,660783,660784,660785,660786,660787,660788,660789,660790,660791,660792,660793,660794,660795,660796,660797,660798,660799,660800,661528,661529,661530,661531,661532,661533,661534,661535,661536,661537,661538,661539,661540,661541,661542,661543,661544,661545,661546,661547,661567,661568,661931,662123,662124,662125,662127,662128,662130,662131,662132,662133,662161,662187,662206,662207,662208,662209,662313,662345,662346,662379,662380,662388,662389,662390,662399,662400,662405,662409,662425,662426,662427,662428,662429,662430,662432,662433,662434,662436,662437,662453,662454,662457,662458,662468,662476,662477,662479,662480,662540,662541,662543,662544,662605,662606,662607,662636,662637,662638,662639,662640,662641,662642,662643,662644,662645,662646,662647,662648,662649,662650,662651,662652,662653,662654,662655,662656,662657,662658,662659,662660,662661,662662,662663,662744,662848,662860,663039,663074,663135,663136,663137,663138,663164,663170,663259,663260,663338,663479,663480,663481,663482,663511,663646,663651,663652,663654,663767,663770,663771,663916,664006,664007,664008,664073,664091,664138,664158,664196,664287,664365,664468,664469,664470,664590,664771,664875,664961,664975,664976,665267,665275,665420,665506,665518,665526,665621,665628,665656,665660,665682,665821,665822,665829,665852,665857,665994,666004,666018,666033,666034,666132,666159,666160,666161,666162,666163,666193,666194,666195,666196,666244,666443,666450,666473,666527,666568,666661,666664,666780,666862,666863,666864,666865,666866,666927,667051,667054,667055,667093,667096,667125,667248,667251,667304,667375,667402,667548,667549,667782,667839,667889,667899,668035,668062,668129,668212,668271,668323,668325,668351,668353,668365,668397,668404,668455,668482,668520,668526,668536,668537,668542,668594,668714,668895,668995,669105,669115,669166,669289,669392,669399,669413,669425,669437,669499,669539,669546,669561,669563,669629,669630,669829,669851,669931,669932,669933,669998,670015,670016,670087,670093,670094,670095,670276,670292,670332,670336,670384,670395,670538,670688,670918,670945,670947,670949,670951,670953,670964,670992,670999,671023,671024,671025,671028,671075,671242,671286,671287,671288,671289,671290,671291,671292,671293,671294,671295,671296,671297,671298,671299,671300,671301,671302,671303,671304,671305,671306,671307,671446,671504,671505,671545,671568,671572,671573,671601,671628,671629,671646,671748,671751,671804,671835,671872,671929,671953,672014,672054,672091,672146,672175,672227,672260,672261,672331,672343,672344,672345,672346,672496,672738,672897,672993,672994,673102,673103,673192,673193,673199,673202,673213,673306,673358,673399,673449,673477,673545,673563,673571,673572,673589,673598,673724,673760,673763,673796,673814,673856,673857,673858,673876,673883,673884,673904,673934,673937,673954,673955,673956,673957,673958,673959,673961,673962,673963,673965,673973,673974,673975,673976,674021,674022,674094,674095,674096,674179,674246,674247,674269,674270,674271,674357,674396,674420,674422,674423,674424,674425,674434,674622,674676,674698,674709,674713,674743,674760,674761,674767,674849,674850,674872,674873,674885,674886,674887,674888,674889,674890,674891,674892,674896,674909,674947,675090,675097,675197,675217,675258,675259,675261,675311,675382,675417,675438,675445,675480,675524,675561,675606,675685,675702,675708,675709,675711,675712,675782,675787,675810,675857,675858,675859,675915,675938,676002,676021,676025,676026,676027,676091,676101,676116,676150,676151,676152,676279,676288,676306,676353,676387,676400,676411,676412,676413,676414,676415,676494,676503,676644,676664,676674,676730,676830,676837,676844,677030,677037,677041,677066,677067,677069,677083,677097,677098,677120,677123,677146,677147,677167,677259,677260,677275,677279,677280,677422,677458,677462,677463,677464,677566,677621,677636,677719,677824,677836,677842,677845,677875,677919,677922,677936,677937,678018,678071,678099,678100,678101,678140,678180,678203,678313,678558,678662,678666,678723,678741,678860,678947,678959,679004,679064,679107,679137,679149,679308,679309,679310,679353,679357,679360,679388,679405,679524,679532,679638,679715,679729,679761,679813,679834,679920,679992,680027,680028,680048,680049,680050,680053,680088,680089,680105,680209,680239,680265,680424,680505,680510,680565,680591,680668,680670,680671,680673,680755,680757,680758,680817,680858,680901,681317,681362,681363,681390,681413,681476,681489,681500,681556,681687,681718,681721,681722,681936,681945,682018,682069,682174,682175,682203,682204,682278,682301,682305,682390,682407,682418,682419,682766,683025,683029,683082,683188,683227,683323,683336,683346,683480,683491,683494,683495,683501,683516,683567,683573,683724,683738,683753,683809,683886,683893,683958,683973,684000,684001,684032,684033,684034,684035,684081,684083,684105,684106,684120,684125,684411,684446,684483,684523,684562,684612,684652,684668,684673,684723,684744,684761,684762,684764,684768,684936,684942,685011,685038,685081,685082,685110,685118,685120,685132,685163,685234,685348,685375,685408,685448,685449,685551,685552,685615,685698,686504,686601,686602,686621,686742,686754,686784,686787,686801,687021,687231,687264,687356,687374,687384,687390,687394,687409,687413,687845,687862,687912,688060,688077,688216,688368,688399,688447,688533,688537,688586,688587,688601,688610,688698,688722,688742,688745,688762,688780,688850,688852,688877,688883,688976,689114,689160,689184,689220,689278,689411,689420,689618,689661,689697,689707,689710,689735,689914,690066,690233,690239,690287,690294,690329,690364,690468,690641,690642,690643,690645,690689,690715,690726,690785,695258,695260,695501,695641,695666,695798,695801,695845,695888,695890,695908,695911,695928,695929,696059,696104,696188,696201,696242,696257,696313,696562,696570,696571,696637,696638,696639,696654,696676,696999,697050,697058,697083,697109,697216,697244,697949,697954,697965,697971,697972,697995,697996,697997,698218,698221,698288,698290,698344,698417,698459,698497,698529,698530,698538,698675,698548,698766,698866,698898,698899,698907,698578,699023,699045,698584,699046,698585,699051,699090,699093,699099,699122,699132,699146,699148,699202,699269,699279,699281,699302,699338,699378,699425,699499,699522,699578,699660,699692,699740,699761,699783,699787,699810,699814,699897,699911,699952,699998,700004,700058,700067,700177,700261,700270,700274,700395,700411,700418,700493,700531,700538,700566,700567,700575,700577,700601,700678,700976,700844,701327,700932,701490,701574,701790,701822,701860,702021,702024,702047,702049,702055,702058,702059,702080,702115,702132,702170,702241,702255,702257,702266,702349,702414,702626,702714,702733,702823,702869,702901,703065,703251,706836,706894,706936,706954,706980,706995,707039,707059,707363,707365,707377,707489,707627,707631,707645,707841,707847,707852,707853,707914,707959,707964,707965,707982,708088,708146,708179,708190,708195,708201,708251,708253,708256,708329,708366,708483,708676,708678,708679,708688,708689,708691,708724,708820,709002,709022,709026,709032,709045,709119,709164,709285,709317,709318,709422,709446,709448,709487,709507,709532,709558,709574,709629,709758,709759,709824,709825,709826,709834,709960,710001,710014,710035,710276,710286,710287,710290,710421,710422,710426,710428,710441,710442,710446,710459,710688,710723,710775,710859,710928,710954,710982,710983,711002,711047,711260,711360,711428,711482,711588,711608,711675,711728,711764,711769,711927,711947,712055,712056,712059,712060,712216,712301,712303,712308,712309,712604,712621,712627,712700,712710,712755,712756,712757,712758,712836,712874,713098,712907,713138,712978,713148,713149,713158,713171,713241,713817,713843,713892,713927,714012,714014,714047,714083,714085,714086,714397,714411,714416,714481,714502,714552,714679,714902,714971,715076,715099,715104,715266,715267,715271,715555,715559,715592,715625,715634,715992,716255,716257,716325,716412,716491,716682,716694,716792,716914,717051,717054,717104,717109,717115,717158,717224,717580,717601,717602,717603,717604,717637,717670,717704,717725,717780,717940,718065,718275,718520,718600,718864,718870,718878,718903,718905,718947,718949,718950,718958,718959,719094,719186,719289,719292,719293,719313,719317,719325,719337,719361,719406,719493,719517,719607,719648,719696,719828,719829,719830,719982,720045,720052,720053,720064,720072,720073,720074,720075,720076,720077,720078,720079,720080,720081,720082,720083,720084,720085,720086,720087,720088,720089,720090,720091,720092,720093,720094,720095,720096,720097,720098,720099,720100,720101,720102,720103,720104,720105,720106,720107,720108,720109,720110,720111,720112,720113,720114,720115,720116,720117,720118,720119,720120,720121,720122,720123,720124,720125,720126,720127,720128,720129,720130,720131,720132,720133,720134,720135,720136,720137,720138,720139,720140,720141,720142,720143,720144,720145,720146,720147,720148,720149,720150,720151,720152,720153,720154,720155,720156,720157,720158,720159,720160,720161,720162,720163,720164,720165,720166,720167,720168,720169,720170,720171,720172,720173,720174,720175,720176,720177,720178,720179,720180,720181,720182,720183,720184,720185,720186,720187,720188,720189,720190,720191,720192,720193,720194,720232,720245,720251,720265,720286,720408,720431,720582,721372,721538,721640,721703,721829,721873,721879,721888,721900,721901,721964,721978,722216,722338,722464,722531,722855,722893,722923,723064,723065,723066,723140,723151,723181,723197,723249,723287,723334,723336,723353,723366,723367,723393,723521,723551,723560,723574,723598,723626,723627,723634,723635,723645,723693,723791,723821,723824,723828,723870,723914,723933,723947,724084,724204,724517,724545,724549,724817,724832,724858,724894,724899,724920,724921,724922,724923,724924,724925,725287,725366,725450,725525,725597,725793,725841,726217,725842,726218,725843,726221,726077,726228,726266,726267,726268,726830,726833,726849,726870,726872,726876,726879,726943,727035,727036,727111,727530,727532,727533,727534,727536,727537,727595,727607,727641,727734,727762,727776,727812,668721,683739,712290,712291,714313,716973,719346,719795,727580,667584,667585,683031,684389,710067,707260,708722), array:
