count: 173, time: 0.02603006362915
, 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 (623773,623774,623775,623776,623777,623778,623779,623780,623781,623782,623783,623784,623785,623786,623787,623788,623789,623790,623791,623792,623793,623794,623795,623796,623797,623798,623799,623800,623801,623802,623803,623804,623805,623806,623807,623808,623809,623810,623811,623812,623813,623814,623815,623816,623817,623818,623819,623820,623821,623822,623823,623824,623825,623826,623827,623828,623829,623830,623831,623832,623834,623835,623836,623837,623838,623839,623840,623841,623842,623843,623844,623845,623846,623847,623848,623849,623850,623851,623852,623853,623854,623855,623856,623857,623858,623859,623860,623861,623862,623863,623864,623865,623866,623867,623868,623869,623870,623871,623872,623873,623874,623875,623876,623877,623878,623879,623880,623881,623882,623883,623884,623885,623886,623887,623888,623889,623890,623892,623893,623894,623895,623896,623897,623898,623899,623900,623901,623902,623903,623904,623905,623906,623907,623908,623909,623910,623911,623912,623913,623914,623915,623916,623917,623918,623919,623920,623921,623922,623923,623924,623925,623926,623927,623928,623929,623931,623932,623933,623934,623935,651058,662446,662447,662448,662449,662450,666377,680507,680508,680509,698385,698582,699525), array:
