count: 523, time: 0.036128997802734
, 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 (578243,578573,578705,578939,578940,579003,579174,579192,579193,579195,579493,613026,615966,621102,621103,621104,621105,621106,621107,621108,621109,621110,621111,621112,621113,621114,621115,621116,621117,621118,621119,621120,621121,621122,621123,621124,621125,621126,621127,621128,621129,621130,621131,621132,621133,621134,621135,621136,621137,621138,621139,621140,621141,621142,621143,621144,621145,621146,621147,621148,621149,621150,621151,621152,621153,621154,621155,621156,621157,621158,621159,621160,621161,621162,621163,621164,621165,621166,621167,621168,621169,621170,621171,621172,621173,621174,621175,621176,621177,621178,621179,621180,621181,621182,621183,621184,621185,621186,621187,621188,621189,621190,621191,621192,621193,621194,621195,621196,621197,621198,621199,621200,621201,621202,621203,621204,621205,621206,621207,621208,621209,621210,621211,621212,621213,621214,621215,621216,621217,621218,621219,621220,621221,621222,621223,621224,621225,621226,621227,621228,621229,621230,621231,621232,621233,621234,621235,621236,621237,621238,621239,621240,621241,621242,621243,621244,621245,621246,621247,621248,621249,621250,621251,621252,621253,621254,621255,621256,621257,621258,621259,621260,621261,621262,621263,621264,621265,621266,621267,621268,621269,621270,621271,621272,621273,621274,621275,621276,621277,621278,621279,621280,621281,621282,621283,621284,621285,621286,621287,621288,621289,621290,621291,621292,621293,621294,621295,621296,621297,621298,621299,621300,621301,621302,621303,621304,621305,621306,621307,621308,621309,621310,621311,621312,621313,621314,621315,621316,621317,621318,621319,621320,621321,621322,621323,621324,621325,621326,621327,621328,621329,621330,621331,621332,621333,621334,621335,621336,621337,621338,621339,621340,621341,621342,621343,621344,621345,621346,621347,621348,621349,621350,621351,625228,625229,630702,631624,632085,632641,632851,632852,632853,632854,632867,633139,637510,660142,663413,663574,664035,664036,664343,664580,664624,664827,665460,665531,665652,665908,665909,665910,665911,665983,666108,666436,666437,666795,666963,667155,667156,667166,667267,667306,667386,667388,667389,667649,667850,667851,668006,668231,668278,668284,668347,668456,669004,669005,669038,669267,669524,669527,669528,670137,670138,670231,670254,670625,671197,671380,671496,671712,671731,672737,672935,672936,673051,673053,673054,673447,673600,673647,674252,674526,674527,674529,674530,674531,674532,674533,674534,674535,674536,675193,675566,675571,675790,676313,676743,676744,676745,676748,677855,677856,677857,678320,678531,678953,679068,679459,679685,680055,680139,681149,681762,682350,683941,683942,684602,684871,684872,684873,684874,684875,685469,685470,685471,685472,685473,686677,687076,687911,687943,687962,687963,688102,688219,688220,688221,688223,688297,688749,688837,688967,689006,689134,689628,689701,689702,689891,690519,690520,695901,695985,697116,697274,698097,698271,698467,698618,698944,698971,699232,699233,699372,699384,699560,700354,700429,700775,701124,701128,701150,701174,701193,701281,701578,701714,701715,701716,701962,702005,702243,702348,702572,702605,702930,706833,706834,707469,706855,707470,707533,707996,707997,708101,708102,708283,708480,709159,710118,710163,710164,710222,710541,710742,710860,710882,710883,710884,710885,710898,710899,710901,710915,710916,710917,710918,710935,711765,711875,711931,712101,712115,712116,712117,712242,713065,715069,718524,718723,718724,718745,718746,718806,718913,719630,719723,719724,719771,720298,722094,722095,722720,722919,723259,723324,723325,723677,723823,723908,723957,723958,724179,724792,725333,726669,726988,727980,631653,650521,666931,672728,679806,681929,689378), array:
