count: 1044, time: 0.64787006378174
, 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 (210,211,212,214,215,216,217,218,615799,615810,630467,630468,630469,630470,630701,630784,631126,631258,631323,631712,658205,665116,666221,666222,666223,666224,666561,666598,666599,666600,666601,666602,668243,668773,668790,668791,668799,669207,669285,669803,669804,669805,669806,669807,669808,669809,669811,669812,669813,669814,669815,669816,670590,670591,670864,670993,671423,672508,672569,672716,673579,674653,675270,675468,675469,675470,676215,676989,677228,677907,677908,677909,680457,681230,681574,681725,681726,681728,681729,681730,681731,681732,681733,681734,681735,681736,681737,681738,681739,681740,681741,681742,681743,681744,681745,681746,681747,681748,682373,683622,683660,683661,683662,683663,683664,683665,683666,683667,683668,683669,683670,683671,683672,683673,683674,710004,683675,683676,683677,684070,684230,684632,685490,685596,685597,685598,685601,685602,685603,685604,685605,685606,686560,688095,688552,689096,689097,689098,689099,689754,689788,695514,695515,695516,695518,695519,695520,695521,695522,695523,695524,698646,712198,698647,698650,696139,697005,697006,697007,697008,697012,697015,697927,707961,580027,580028,580037,580039,612922,628937,628938,628939,628940,628941,628942,628943,628944,628945,628946,628947,628948,628949,628950,628951,628952,628953,628954,628955,628956,628957,628958,628959,628960,628961,628962,628963,628964,628965,628966,628967,628968,628969,628970,628971,628972,628973,628974,628975,628976,628977,628978,628979,628980,628981,628982,628983,628984,628985,628986,628987,628988,628989,628990,628991,628992,628993,628994,628995,628996,628997,628998,628999,629000,629001,629002,629003,629004,629005,629006,629007,629008,629009,629010,629011,629012,629013,629014,631735,632643,651015,672384,674924,674925,674926,674927,674928,674929,674931,674933,674934,686773,686774,686775,686776,686777,686778,686779,686780,686781,686782,697298,697299,699986,703106,706869,707347,709465,709526,712779,718668,723678,726665,577737,578590,580034,580042,615967,626706,626707,626708,626709,626710,626711,629565,629566,629567,629568,629569,629570,629571,629572,629573,629574,629575,629576,629577,629578,629579,629580,629581,629582,629583,629584,629585,629586,629587,629588,629589,629590,629591,629592,629593,629594,629595,629596,629597,629598,629599,629600,629601,629602,629603,629604,629605,629606,629607,629608,629609,629610,629611,629612,629613,629614,629615,658520,661470,663335,670667,672085,674714,674715,674716,676210,678187,679238,679239,679517,680383,681609,681610,681716,681727,688528,689805,689871,690299,690323,690324,690325,690326,690327,697000,697001,697002,697003,697004,697016,697019,697020,697021,697022,697119,699033,701285,702949,707355,707629,710979,716517,718094,720230,722348,722349,722350,726954,727178,727180,727181,727182,727183,727184,727185,727186,630471,630472,630473,630474,630475,630476,630477,630478,630479,630480,630481,630482,630483,630484,630485,630486,630487,630488,630489,630490,630491,630492,630493,630494,630495,630496,630497,630498,630499,630500,630501,630502,630503,630504,630505,630506,630507,630508,630509,630510,630511,630512,630513,630514,630515,630516,630517,630518,630519,680112,687174,698379,712468,715144,717684,717967,718017,718019,726650,577886,577888,577891,577892,577901,577908,577910,577954,578303,578304,578305,578306,578307,578310,578311,578314,578425,578552,578553,578556,578557,578558,578559,578584,578585,578586,578587,578591,578592,578889,578891,579241,579242,579243,579244,579245,579246,580029,580030,580031,580032,580033,580043,612926,612927,612928,612929,612931,613610,613614,613792,616473,616474,625304,629075,629076,629077,629078,629079,629080,629081,629082,629083,629084,629085,629086,629087,629088,629089,629090,629091,629092,629093,629094,629095,629096,629097,629098,629099,629100,629101,629102,629103,629104,629105,629106,629107,629108,629109,629110,629111,629112,629113,629114,629115,629116,629117,629118,629119,629120,629121,629122,629123,629124,629125,629126,629127,629128,629129,629130,629131,629132,629133,629134,629135,629136,629137,629138,629139,629140,629141,629142,629143,629144,707844,629145,629146,629147,629148,629149,629150,629151,629152,629153,629154,629155,629156,629157,629158,629159,629160,629161,629162,629163,629164,629165,629166,629167,629168,629169,629170,629171,629172,629173,629174,629175,629176,629177,629178,629179,629180,629181,629182,629183,629184,629185,629186,629187,629188,629189,629190,629191,629192,629193,629194,629195,629196,629197,629198,629199,629200,629201,629202,629203,629204,629205,629206,629207,629208,629209,629210,629211,629212,629213,629214,629215,629216,629217,629218,629219,629220,629221,629222,629223,629224,629225,629226,629227,629228,629229,629230,629231,629232,629233,629234,629235,629616,629617,629618,629619,629620,629621,629622,629623,629624,629625,629626,629627,629628,629629,629630,629631,629632,629633,629634,629635,629636,629637,629638,629639,629640,629641,629642,629643,629644,629645,629646,629647,629648,629649,629650,629651,629652,629653,629654,629655,629656,629657,629658,629659,629660,629661,629662,629663,629664,629665,629666,629667,629668,629669,629670,629671,629672,629673,629674,629675,629676,629677,629678,629679,629680,629681,629682,629683,629684,629685,629686,629687,629688,629689,629690,629691,629692,629693,629694,629695,629696,629697,629698,629699,629700,629701,629702,629703,629704,629705,629706,629707,629708,629709,629710,629711,629712,629713,629714,629715,629716,629717,629718,629719,629720,629721,629722,629723,629724,629725,629726,629727,629728,629729,629730,629731,629732,629733,629734,629735,629736,629737,629738,629739,629740,629741,629742,629743,629744,629745,629746,629747,629748,629749,629750,629751,629752,629753,629754,629755,629756,629757,629758,629759,629760,629761,629762,629763,629764,629765,629766,629767,629768,629769,629770,629771,629772,629773,629774,629775,629776,629777,629778,629779,629780,629781,629782,629783,629784,629785,629786,629787,629788,629789,629790,629791,629792,629793,629794,629795,629796,629797,629798,629799,629800,629801,629802,629803,629804,629805,629806,629807,629808,629809,629810,629811,629812,629813,629814,629815,629816,629817,629818,629819,629820,629821,629822,629823,629824,629825,629826,629827,629828,629829,629830,629831,629832,629833,629834,629835,629836,629837,629838,629839,629840,629841,629842,629843,629844,629845,629846,629847,629848,629849,629850,629851,629852,629853,629854,629855,629856,629857,629858,629859,629860,629861,629862,629863,629864,629865,629866,629867,629868,629869,629870,629871,629872,629873,632904,633097,663120,663121,665780,666208,669187,669500,670821,670826,670827,670828,670829,670830,670831,670832,670833,670834,671464,671465,671466,671467,672937,674416,674807,674808,674809,674935,675755,676159,677595,677596,677597,677598,677605,677615,677616,677619,677895,678727,678887,678888,679233,679234,679235,679236,679237,679240,679241,679242,679243,679244,679245,679246,679247,679248,679671,679707,680953,681415,681503,681618,681619,682286,682526,682671,682743,684350,684516,687824,687825,689100,689101,689102,697121,697183,698471,698574,698761,698762,698763,698790,701925,702165,706817,706818,707638,708080,709086,709111,709421,709819,709891,711279,711551,711552,711553,711958,713767,713980,715839,716366,716576,717869,718410,718543,718653,718741,719370,719541,720530,722107,722548,722994,723171,723172,724562,725593,725643,725966,726001,726981,726982,726983,727566,709999,718868,718869,719681,720590,723133,723303,723304,723306,723837,726964,726965,726966,727147,727528,678845,680092,682937,701253,701254,702084,706856,706857,707119,707120,707121,707122,707123,707124,707126,707127,707128,707129,707737), array:
