count: 577, time: 0.047568082809448
, 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 (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), array:
