count: 410, time: 0.030086994171143
, 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 (580035,627504,627505,627506,627507,627508,627509,627510,627511,630251,630252,630253,630254,630255,630256,630257,630258,630259,630260,630261,630262,630263,630264,630265,630266,630267,630268,630269,630270,630271,630272,630273,630274,630275,630276,630277,630278,630279,630280,630281,630282,630283,630284,630285,630286,630287,630288,630289,630290,630291,630292,630293,630294,630295,630296,630297,630298,630299,630300,630301,630302,630303,630304,630305,630306,630307,630308,630309,630310,630311,630312,630313,630314,630315,630316,630317,630318,630319,630320,630321,630322,630323,630324,630325,630326,630327,630328,630329,630330,630331,630332,630333,630334,630335,630336,630337,630338,630339,630340,630341,630342,630343,630344,630345,630346,630347,630348,630349,630350,630351,630352,630353,630354,630355,630356,630357,630358,630359,630360,630361,630362,630363,630364,630365,630366,630367,630368,630369,630370,630371,630372,630373,630374,630375,630376,630377,630378,630379,630380,630381,630382,630383,630384,630385,630386,630387,630388,630389,630390,630391,630392,630393,630394,630395,630396,630397,630398,630399,630400,630401,630402,630403,630404,630405,630406,630407,630408,630409,630410,630411,630412,630413,630414,630415,630416,630417,630418,630419,630420,630421,630422,630423,630424,630425,630426,630427,630428,630429,630430,630431,630432,630433,630434,630435,630436,630437,630438,630439,630440,630441,630442,630443,630444,630445,630446,630447,630448,630449,630450,630451,630452,630453,630454,630455,630456,630457,630458,630459,630460,630461,630462,630463,630464,630465,630466,662348,663516,663533,663657,665336,665357,667072,668573,668636,669712,670686,671619,671878,672335,672744,673837,673838,673839,673840,673841,673842,673843,673844,673845,673846,673847,673848,673849,673940,674552,674717,674718,674719,674720,674721,677317,677607,677608,677609,677610,677611,677612,677613,677876,678166,679065,679066,680530,681414,681484,681555,682289,682857,682858,683450,684499,685649,687812,687813,688556,689657,689755,690345,697182,697200,697976,698539,698607,698694,698993,698994,699106,699107,699108,699219,699956,700251,700469,700511,700744,700745,700746,701042,701043,701224,701262,701437,701675,701835,701928,701929,701930,701931,701932,701933,701934,701935,701936,701937,701938,701939,701940,701941,702401,706831,707095,707219,707471,707523,707934,708082,709110,710674,711545,711835,712368,712369,712370,712371,712372,712373,712374,712375,712376,712377,712378,712379,712380,712381,712382,712443,712659,712930,712931,712932,712933,712934,713778,713780,714646,715729,715730,715731,715754,716969,717133,717717,718418,718424,718435,718438,719190,719191,719227,719228,719841,720553,720554,721678,721876,721927,721928,722358,722627,722722,722723,723134,723530,723536,724054,724128,724719,724720,725469,725848,726249,725921,726633,725922,726691,727105,727197,727574,727655,727774,727797,727974), array:
