msProduct и большое время создания страницы Parse Time
Здравствуйте!
Сдается мне что проблема кроется где-то в БД. Подскажите если кто-то сталкивался со следующей картиной:
Есть несколько вызовов msProducts на странице и как результат:
Сдается мне что проблема кроется где-то в БД. Подскажите если кто-то сталкивался со следующей картиной:
Есть несколько вызовов msProducts на странице и как результат:
<!--
<b>0.1408 s</b> - Query Time - Shows how long MODx took talking to the database
<b>751</b> - Query Count -Shows how many database queries MODX made
<b>8.5561 s</b> - Parse Time - Shows how long MODX took to parse the page
<b>8.6968 s</b> - Total Time - Shows the total time taken to parse/ render the page
<b>cache</b> - Source - Shows the source of page, whether is database or cache.
-->
Пример вызова:[[!msProducts?
&parents=`33`
&limit=`8`
&includeThumbs=`250x250`
&includeTVs=`imgTV,250x250,img`
&sortby=`editedon`
&sortdir=`DESC`
&tpl=`msProduct`
&where=`{"Data.new":"1"}`
]]
Если showLog включить то выдается следующее:
<pre class="msProductsLog">0.0002451: pdoTools loaded.
0.0059140: Conditions prepared
0.0000679: xPDO query object created
0.0010729: Included list of tvs: <b>img, imgTV</b>
0.0004530: leftJoined <i>msProductData</i> as <b>Data</b>
0.0002370: leftJoined <i>msVendor</i> as <b>Vendor</b>
0.0026350: leftJoined <i>msProductFile</i> as <b>250x250</b>
0.0004389: leftJoined <i>modTemplateVarResource</i> as <b>TVimg</b>
0.0002069: leftJoined <i>modTemplateVarResource</i> as <b>TVimgtv</b>
0.0000050: Grouped by <b>msProduct.id, `250x250`.url</b>
0.0000641: Added selection of <b>msProduct</b>: <small>`id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `alias_visible`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`</small>
0.0000329: Added selection of <b>msProductData</b>: <small>`article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`</small>
0.0000300: Added selection of <b>msVendor</b>: <small>`name` AS `vendor.name`, `resource` AS `vendor.resource`, `country` AS `vendor.country`, `logo` AS `vendor.logo`, `address` AS `vendor.address`, `phone` AS `vendor.phone`, `fax` AS `vendor.fax`, `email` AS `vendor.email`, `description` AS `vendor.description`, `properties` AS `vendor.properties`</small>
0.0000200: Added selection of <b>msProductFile</b>: <small>url as `250x250`</small>
0.0000789: Added selection of <b>modTemplateVarResource</b>: <small>IFNULL(`value`, '') AS `img`</small>
0.0000131: Added selection of <b>modTemplateVarResource</b>: <small>IFNULL(`value`, '') AS `imgTV`</small>
0.0000200: Replaced TV conditions
0.7495880: Processed additional conditions
0.7590969: Added where condition: <b>class_key=msProduct, Data.new=1, msProduct.parent:IN(33,25383,25263,25470,25618,32468,36906,32546,32428,26060,32438,32479,25357,32490,26178,25303,25459,27021,29622,32288,26106,26022,25833,26582,32404,36920,25736,26285,26777,25384,26063,27264,25639,25843,26031,26239,26335,26387,26517,26550,27224,30641,32318,36921,25737,26519,27558,30800,30039,25635,30104,25738,26175,26824,27193,28430,28708,28959,29015,29130,29358,29410,30343,26520,26895,28252,28567,29357,30724,30801,31413,30854,31434,30802,31414,31479,26286,27288,30974,30038,26287,26356,27287,28581,29961,36928,27289,27522,27529,27633,27634,27962,27973,27974,28033,28152,28153,28268,28269,28377,28572,28608,28656,28900,29265,29420,29998,30372,32313,30975,31159,31463,26778,27024,28063,30891,29618,29245,25837,26235,25385,25604,25661,25686,25690,25794,25816,25999,28438,30112,28087,29806,32312,31897,29619,30133,30379,30449,30469,30553,29246,29680,30096,28399,32407,30416,29415,25838,27118,27284,29849,31432,31565,26236,26504,26548,26851,27156,27447,27553,32403,31511,25386,25790,27660,27898,28637,31748,25605,28357,29232,29461,29577,29976,30673,31035,31286,31604,31817,31818,31979,32031,25662,25730,26690,26905,36875,32420,32300,26904,25687,25880,26302,27154,27367,27441,27742,28155,28304,28479,29280,30088,30930,31760,25691,26553,26709,26733,26812,26943,27091,27227,27237,27669,28195,28391,28402,28405,28415,28496,28568,28682,28743,28862,29208,29247,29467,29497,29794,30089,30183,30564,30963,31022,31226,31282,31442,31621,31846,32292,32293,32294,32295,32296,32297,32298,32299,32301,32302,32303,32304,32305,32306,32308,32309,32310,32311,32307,25795,25980,26238,26958,27706,28629,28852,29162,29640,30161,30543,31836,25817,32563,26000,26461,26614,27088,27495,27496,27497,27572,27647,28215,28492,28564,28565,28566,28706,28707,28732,29490,29491,29492,29570,30092,30222,28439,28860,30113,30450,30819,30888,30907,30909,31018,31206,31225,31411,31682,31924,26064,26598,27038,32314,32315,32316,32317,27265,30849,31257,32319,32320,30639,28720,30924,27811,28849,25640,26728,27033,32291,29304,29233,29483,28115,26937,26951,28065,28850,29006,29207,29644,29786,30886,31085,31268,31551,31669,31802,27369,30818,26849,28628,28709,25845,27016,27741,27978,28413,29195,28820,26032,28822,29949,30272,31230,32600,26033,26121,26922,27494,27675,27676,28132,31569,32078,28823,29338,30220,30221,29950,30028,30273,30338,30370,30578,30685,30799,30918,31231,31749,36878,36879,26240,26959,26336,26597,27628,36831,30762,29557,27755,27886,27451,29059,31052,31155,30087,26388,26721,31595,26722,31349,30053,31350,31451,27435,27194,27363,27687,28607,28818,30097,30367,30425,30530,31116,31261,31559,31603,31668,32013,26518,27922,28319,28992,29294,29400,29648,30032,30052,30267,30677,30978,31373,31593,31605,26274,25998,29955,27723,26551,28314,28944,27724,31395,28966,31901,27960,27395,26552,27972,28315,28401,26447,28945,29578,30480,30887,27191,27225,30976,27226,27745,28129,28493,29117,31153,31285,30977,31154,31410,30642,30669,30711,37076,28265,36938,36948,36989,37032,37058,37062,37073,37112,37369,37399,37497,37604,38568,25763,26079,25896,25339,25693,25272,25338,31228,28562,25874,29572,26459,27049,25354,25597,25596,25746,25266,25647,25264,25283,25435,26701,25707,25955,25786,25779,28147,25627,25636,26208,26363,26694,26980,31194,36926,37077,37248,38451,38488,39063,37078,37108,37234,37446,37704,37738,37249,38589,38935,38982,37250,37326,37542,37814,38590,38591,38704,38705,38791,38792,38862,38863,38912,38913,39030,39031,39034,39035,38936,38937,38946,38947,39009,39010,39050,39051,39070,39071,39083,39084,39090,39091,39096,39097,38983,38984,38987,38988,39037,39038,39081,39082,38452,38553,38584,38593,38604,38622,38632,38633,38489,38491,38490,38543,38597,38601,38616,38640,38702,38784,38795,38492,38598,38602,38617,38641,38703,38785,39064,39098,39065,39066,39079,39080,39087,39088,39099,39100,39113,39114,32408,32410,32411,32409,32413,32414,32415,32416,32412,29141,28266,28387,29134,29440,29847,30636,30917,31254,31999,36939,36968,37045,37126,37340,37390,37428,37468,37538,37563,37620,36940,36956,37024,37220,36941,36942,36943,36944,36945,36946,36947,36952,36953,36954,36958,36959,36960,36961,36962,36963,36964,36965,36966,36967,36972,36973,36974,36980,36981,36984,36985,36986,36987,36988,36992,36993,36994,36996,36997,36998,37000,37002,37005,37006,37007,37012,37013,37018,37019,37020,37021,37023,37027,37028,37029,37031,37035,37037,37038,37039,37042,37043,37049,37050,37052,37053,37054,37055,37056,37057,37061,37068,37070,37079,37080,37081,37082,37084,37087,37089,37092,37093,37094,37097,37101,37105,37107,37109,37110,37111,37114,37115,37116,37120,37125,37128,37131,37149,37150,37153,37154,37166,37167,37168,37177,37179,37190,37191,37192,37193,37194,37197,37201,37231,37235,37243,37255,37263,37271,37274,37276,37277,37278,37279,37288,37295,37300,37312,37328,37329,37330,37363,37384,37406,37410,37411,37422,37431,37472,37477,37486,37526,37533,37544,37574,37623,37647,37661,37698,37712,37786,37824,37874,37884,38019,36957,36979,36982,36999,37011,37014,37036,37041,37072,37086,37090,37118,37121,37185,37202,37260,37284,37317,37338,37389,37420,37515,37518,37617,37706,37722,37800,37025,37040,37069,37083,37088,37095,37106,37117,37137,37164,37180,37203,37228,37236,37272,37273,37286,37331,37221,37270,37289,37310,37351,37353,37357,37419,37423,37427,37452,37457,37478,37485,37512,37523,37541,37566,37609,37726,37732,37733,37736,37830,37886,38064,38230,36969,37051,37071,37102,37122,37155,37267,37404,37487,37490,37549,37677,37705,37046,37302,37503,37618,38313,37047,38131,37048,37215,37359,37395,37396,37397,37418,38311,38326,38393,38396,38404,38421,38442,38132,38397,38446,38525,38571,38637,38883,38889,39001,37303,37339,37493,37494,37495,37496,37551,37589,37590,37611,37612,37640,37641,37642,37643,37654,37692,37693,37739,37740,37820,37821,37901,37504,37557,37586,37587,37632,37619,37919,37966,38006,38054,38069,38285,38314,38423,38441,38454,38549,38677,38831,37127,37171,37172,37181,37182,37183,37184,37187,37204,37205,37207,37212,37216,37218,37219,37242,37244,37246,37247,37253,37256,37258,37259,37262,37265,37266,37268,37269,37296,37301,37304,37309,37311,37313,37318,37319,37323,37325,37352,37365,37375,37403,37421,37433,37454,37479,37481,37507,37508,37513,37521,37522,37534,37573,37610,37616,37627,37628,37629,37656,37669,37675,37696,37747,37758,37759,37776,37780,37812,37870,37882,37910,37977,37981,38031,38074,38081,38138,38157,38167,38249,38257,38295,38412,38578,37341,37407,37463,37516,37601,37602,37639,37714,37783,37855,37900,37907,38016,38104,38108,38236,38262,38321,38378,38440,38496,38500,38550,38614,38670,37391,37636,37777,37962,37429,37442,37560,37575,37599,37668,37682,37756,37822,37897,37927,37990,38120,38168,38242,38265,38533,38534,38535,37469,37530,37531,37532,37539,37845,37846,37847,38034,38035,37564,37622,37681,37729,37798,37621,37680,37837,37936,38149,38217,38333,38395,38539,38579,38623,38659,38713,38744,38765,38794,38835,38855,38885,38900,38934,38942,38985,39004,36949,36975,37132,37280,37360,37379,37414,37554,37972,38218,36950,38047,36951,36955,36970,36971,37003,37017,37022,37030,37085,37098,37099,37100,37129,37138,37139,37152,37159,37160,37161,37165,37233,37237,37240,37241,37291,37292,37293,37376,37447,37448,37449,37655,37849,37939,38067,38273,38588,38625,38709,39089,38048,38049,38127,38128,38186,38187,38220,38221,38277,38278,38413,38418,38475,38476,38477,38478,38560,38561,38564,38565,38778,38846,38857,38872,38879,38880,38903,38904,38908,38972,38973,38990,38991,39045,36976,37142,37662,37671,36977,37144,37229,36978,36983,37145,37176,37252,37327,37511,37230,37143,37151,37188,37189,37198,37307,37308,37322,37334,37335,37336,37350,37354,37356,37372,37373,37392,37437,37438,37455,37491,37492,37561,37562,37565,37625,37626,37635,37651,37652,37687,37663,37664,37695,37751,37801,37803,37806,37815,37834,37850,37872,37873,37902,37905,37926,37940,37975,37999,38000,38007,38020,38022,38033,38056,38080,38084,38090,38093,38098,38099,38150,38180,38185,38197,38200,38207,38216,38232,38233,38237,38252,38267,38268,38280,38319,38322,38349,38351,38371,38372,38377,38381,38383,38402,38406,38407,38414,38424,38425,38437,38453,38457,38470,38510,38512,38513,38514,38521,38530,38531,38542,38554,38555,38557,38567,38574,38575,38580,38585,38629,38630,38645,38652,38653,38657,38658,38665,38678,38679,38683,38684,38699,38700,38706,38707,38711,38720,38728,38729,38733,38735,38752,38753,38761,38772,38800,38801,38820,38826,38829,38830,38856,38860,38864,38865,38866,38868,38902,38943,37672,37762,38111,38634,38668,38806,39018,39020,37673,37749,37992,38156,38464,38551,37763,37766,37785,37805,37848,37890,38087,38174,38175,38231,38271,38272,38410,38411,38612,38669,38807,38838,38897,39019,39110,39021,39111,37133,37332,38144,37134,37135,37136,37169,37170,37195,37208,37209,37210,37261,37264,37285,37297,37320,37324,37337,37355,37366,37386,37405,37417,37432,37461,37464,37476,37483,37528,37540,37550,37579,37598,37615,37660,37699,37723,37734,37743,37877,38126,38159,38258,38275,38298,38299,38303,38332,38455,38501,38605,38618,38648,38672,38689,38747,38767,38769,38789,38793,38844,38921,37333,37580,37811,37853,37879,37974,38046,38091,38095,38121,38318,38323,38364,38757,38145,38417,38495,38526,38581,38642,38643,38666,38671,38682,38708,38760,38762,38781,38790,38818,38832,38861,38873,38881,38907,38926,38927,38938,38941,38970,38979,38980,38994,39015,39033,39049,39108,37281,37859,37880,38587,37282,37298,37364,37367,37378,37443,37444,37514,37519,37571,37657,37709,37713,37741,37768,37823,37865,37943,38038,38041,38115,38196,38208,38283,38309,38331,38348,38390,38391,38427,38504,38536,38819,37860,37913,37987,38073,38075,38261,37881,37986,38039,38044,38293,38294,38338,38527,38528,38566,38620,38685,38686,38715,38839,38840,37361,37362,37453,37462,37500,37600,37637,37689,37807,37887,37982,37984,38029,38165,38191,38240,38244,38370,38389,38468,38517,38651,38756,38827,38847,38854,38867,38895,38910,38992,37380,37381,37382,37383,37670,37742,37794,37795,37796,37797,37841,37866,37867,37868,37876,37963,37964,37965,37988,38106,38141,38222,38223,38224,38227,38238,38239,38284,38320,38334,38335,38336,38343,38354,38387,38436,38443,38487,38726,38750,38817,38834,38843,38875,38922,37415,37649,38101,38365,37416,37630,37638,37707,37784,37839,37898,37928,37969,38024,38160,38754,38917,37650,37724,37789,37793,37827,37878,37945,38032,38109,38123,38139,38140,38143,38176,38253,38270,38302,38342,38380,38408,38444,38450,38466,38483,38516,38556,38615,38646,38676,38680,38723,38755,38771,38780,38822,38102,38178,38276,38308,38400,38448,38458,38481,38493,38537,38558,38577,38606,38692,38732,38746,38751,38848,38911,38950,38956,39023,38366,38420,38508,38613,38647,38674,38687,38740,38768,38786,38815,38837,38852,38877,38898,38916,38948,38965,38974,37555,37556,37658,37857,37915,38025,38066,38119,38188,38201,38384,38523,38691,37973,38360,38376,38459,38673,38716,38814,38893,38940,38961,38995,39014,39046,38219,38340,38374,38438,38486,38607,38635,38638,38655,38660,38742,38758,38759,38774,38797,38824,38853,38870,38876,38890,38899,38939,38953,38966,38996,39002,39012,36990,37305,37439,37458,37545,37552,37727,37745,38051,38136,38505,38518,36991,36995,37001,37004,37008,37009,37010,37015,37016,37026,37044,37091,37130,37186,37211,37387,37450,37480,37527,37631,37645,37760,37769,37774,37782,37832,37835,37842,37843,37856,37903,37995,38011,38028,38096,38162,38171,38266,38324,38330,38379,38465,37306,38656,37440,37441,37932,37933,37934,37459,37546,37558,37567,37553,38190,37728,37735,37894,37895,37746,38287,38345,38052,38053,38209,38210,38346,38347,38359,38137,38506,38519,38520,38738,38739,37033,38886,37034,37398,37408,37529,37674,37755,37802,37825,37889,37908,37925,37937,38078,38082,38107,38118,38130,38135,38154,38161,38163,38173,38179,38194,38203,38212,38264,38279,38286,38350,38375,38415,38429,38460,38472,38479,38482,38498,38507,38563,38572,38681,38722,38741,38887,37059,37103,37123,37173,37222,37225,37348,37473,37060,37096,37140,37141,37206,37217,37227,37275,37290,37385,37388,37482,37488,37594,37104,37254,37358,37501,37688,37836,37862,38026,37124,37342,37347,37761,37844,38202,38325,38461,37174,37175,37199,37200,37223,37224,37344,37345,37346,37430,37595,37596,37790,37791,37792,37858,37996,37997,38181,38182,38183,38184,38255,37226,38254,37349,37374,37505,37506,37683,37684,37685,37686,37474,37475,37524,37525,38008,38009,38088,38089,38964,38981,38998,38999,39043,39044,39107,37063,37146,37393,37412,38225,38357,38850,37064,37066,37465,37911,37065,37196,37232,37509,37971,37067,37466,37467,37536,37537,37576,37912,38269,37147,37607,38502,37148,37157,37158,37377,37409,37608,37665,37691,37700,37715,37716,37765,37773,38193,38503,38696,37394,37451,37588,37613,37644,37659,37679,37711,37764,37781,37831,37854,37985,37989,38012,38085,38810,38821,38884,38969,39017,37413,37581,37646,37864,38027,38061,38226,38305,38306,38358,38439,38811,38851,37074,37162,37238,37314,37701,37753,37808,38858,39024,37075,37119,37156,37178,37213,37214,37245,37294,37321,37343,37368,37424,37426,37445,37456,37489,37543,37559,37572,37577,37593,37633,37697,37708,37710,37721,37737,37748,37752,37767,37770,37816,37833,37838,37869,37875,37917,37941,37944,37991,37994,38116,38164,38243,37163,37299,37510,37779,37883,37924,38356,38515,39059,37239,37251,37257,37502,37582,37583,37603,37624,37634,37667,37725,37730,37731,37750,37778,37788,37804,37810,37817,37828,37829,37863,37893,37909,37921,37922,37935,37942,37960,37961,37978,37979,37993,37998,38005,38015,38043,38045,38050,38057,38058,38059,38065,38094,38103,38110,38117,38122,38146,38151,38155,38158,38195,38213,38214,38215,38228,38229,38235,38248,38263,38274,38281,38288,38289,38292,38355,38362,38368,38369,38385,38394,38398,38399,38409,38426,38428,38463,38467,38471,38474,38484,38485,38494,38511,38522,38541,38562,38582,38608,38610,38611,38649,38663,38664,38710,38717,38718,38719,38721,38775,38776,38777,38779,38783,38796,38812,38813,38816,38841,38954,38955,39005,37315,37316,38570,38576,38595,38714,38944,38986,39016,39028,39042,39053,37702,37717,37775,37819,37980,38055,38072,38147,38148,38169,38250,38256,38282,38304,38532,38599,37754,37757,38023,38083,38105,38241,38312,38435,38447,38473,38583,38624,38631,38650,38945,37809,38524,38859,39086,39025,39039,39074,39115,39119,39122,37113,37283,37287,37916,38234,38290,38339,37370,37371,37425,37535,37547,37568,37597,37648,37666,37690,37744,37813,37818,37826,37851,37852,37861,37871,37885,37888,37892,37896,37904,37906,37918,37920,37923,37929,37938,37976,38001,38003,38004,38010,38017,38021,38030,38036,38037,38040,38042,38062,38068,38076,38077,38086,38092,38097,38112,38113,38129,38142,38152,38153,38170,38172,38177,38189,38206,38211,38245,38259,38260,38300,38301,38315,38316,38317,38329,38341,38386,38416,38433,38445,38449,38480,38529,38538,38644,37400,38070,38431,37401,37591,37771,38327,37402,37434,37460,37470,37471,37484,37614,37653,37676,37678,37694,37592,37703,38079,37772,37840,37970,38002,38114,38124,38422,38469,38497,38559,38573,38609,38328,38337,38361,38382,38430,38071,38363,38603,38804,38432,38871,38888,37498,37569,37584,37718,37946,37967,38204,38296,38626,38661,38693,38748,39061,37499,37517,37520,37548,38100,38688,37570,37578,37914,37930,37983,38133,38134,38192,38246,38247,38251,38307,38352,38401,38419,38462,38499,38509,38545,38621,38639,38654,38803,38845,38869,37585,37799,38456,38586,38594,38628,38690,38737,38805,38909,38929,38962,38976,38978,39011,39041,39047,39052,39103,37719,38546,37720,38125,38166,38434,38547,38552,38743,38763,38882,38925,38977,37947,37948,37949,37950,37951,37952,37953,37954,37955,37956,37957,37958,37959,38013,38014,38198,38199,37968,38063,38310,38344,38353,38367,38373,38403,38540,38544,38548,38592,38619,38636,38675,38697,38698,38712,38736,38745,38764,38773,38782,38787,38788,38802,38809,38823,38836,38874,38878,38905,38931,38932,38951,38952,38958,38968,38971,38993,38997,39003,39013,39036,39068,39093,38205,38600,38667,38727,38828,38849,38892,38920,38930,38297,38388,38596,38901,38923,38627,38906,38915,38928,38949,38957,38662,38770,38798,38891,38919,38960,39029,39060,38694,38695,38701,38724,38725,38734,38749,38825,38914,38933,39062,37605,38730,37606,37787,37891,37899,37931,38018,38060,38731,38766,38799,38808,38833,38842,38894,38896,38918,38967,38975,38989,39000,39032,39040,39058,39072,38569,25764,25848,26489,26806,27098,28967,32594,32595,32596,32597,25765,26130,26462,27980,28205,28358,31198,32017,25849,26490,27884,28090,28309,32593,36915,36916,36917,36918,26807,26938,28545,28640,28919,36919,27099,27312,32588,32590,32591,32592,28968,29174,29305,26080,27743,39139,26081,30602,31119,31998,27744,28247,28422,28518,28790,29090,29285,29351,29575,29671,29745,29803,29870,29944,39140,39141,32374,25897,26068,27891,28880,29443,32375,39142,39143,39144,39145,25898,32530,32531,27521,27152,28798,28456,26069,26523,27362,32417,32418,27892,28499,28881,29278,29643,29672,29945,30270,29444,25340,26339,25341,31323,31981,26340,26578,27094,28478,25694,25774,26082,26224,26587,26947,27011,29267,30650,25695,29292,26826,25775,26487,32401,32402,32440,26083,29791,31533,26225,26686,27574,28302,30388,31507,26588,29978,32532,28428,26948,28750,29448,32664,28429,32673,32670,32671,28751,28714,26949,27640,28386,32672,32667,32668,32669,31007,30204,29449,32665,32666,27012,30720,29268,30836,30651,32024,25273,26410,27432,29696,30443,32371,36932,25274,25352,25634,25650,30376,30645,31058,31117,31169,31170,31696,31803,31865,32009,32074,32075,32542,32543,32541,29217,27877,28888,26920,28112,27805,26411,28643,28036,39156,39157,30057,28032,28808,29576,28795,27279,28390,29099,29339,27727,39154,30202,32376,29171,30890,29977,29784,29739,29561,27433,27900,31475,32073,39146,39147,32369,29697,32370,32515,30444,30866,30894,30895,31235,32372,32373,36933,39075,27380,32222,27638,25377,26182,25381,28828,25770,25820,26053,26221,26454,26506,26610,26859,27539,28605,28986,29844,29871,39076,39077,39094,39095,39104,39105,27381,28118,29579,29865,32223,32545,32576,32577,32578,32579,36873,36874,36905,32525,32526,28752,29204,29698,27639,27957,28236,29038,25378,28654,30328,36829,39134,39136,39137,36923,25379,26051,30497,30668,31197,36924,28655,28965,30525,39135,30329,31528,32011,26183,26471,27215,27707,28264,32081,32384,25382,25883,26596,27212,27426,27875,28267,29706,32029,32030,28829,29481,29947,30769,31386,25771,26065,26282,26466,26687,28229,28700,26066,26078,26450,26688,26939,27139,27207,27349,27575,27850,28237,28230,29359,28701,29009,25821,27245,26054,26703,26874,27797,26055,29216,26704,26875,27798,26222,26613,27214,27571,27979,31515,32005,26455,27923,28041,28767,29394,26507,26827,26883,27629,26611,28227,29154,26860,27278,27785,28045,28348,28484,28729,29273,29546,29555,29695,30700,27540,28768,29783,28606,29337,29391,29715,30197,30331,28987,29845,29846,29872,36863,36864,36865,36867,36866,31229,31594,31763,31864,36868,36869,28887,30365,29255,28563,30330,30458,30885,31713,32023,30257,30071,25875,36844,36888,25876,25900,36898,36901,36902,36903,36904,31884,31714,28811,30004,29556,30277,30568,31263,30429,36897,36899,36887,36889,30126,30077,30091,32447,29573,29962,32448,32449,32450,26460,27247,28119,28906,29124,29170,29295,29592,29956,32053,39131,39132,39133,36896,27050,27573,36870,36871,36893,36894,25355,25629,26791,28836,25356,26338,26683,29231,30993,31517,31764,25630,26086,26850,27585,27981,29952,31728,32061,26792,32285,32286,28837,29293,30217,30723,31983,26328,25598,25983,32424,32425,32527,32426,29653,26695,25744,30531,29654,29866,30205,30529,30825,31011,31163,31267,26696,28611,30459,26697,27090,27450,28064,28501,29129,32674,28612,29462,30185,32565,30460,31021,31806,25745,26749,27878,29061,30473,31253,31558,30532,30896,31114,32366,36877,32367,26243,25747,25870,36892,26084,26276,26998,27351,30078,26244,26343,26508,26580,26790,26832,27290,27317,25748,26145,26723,26762,27052,27498,27799,27852,28123,28644,29340,29785,25871,25984,26169,26380,26399,26608,26871,27009,27080,27103,27104,27316,28635,28636,31825,31926,29057,30395,30422,29946,30768,26085,26510,27068,27138,27452,27519,27556,27641,27851,27912,28228,28813,28839,28921,29053,29065,29210,29417,26277,27453,27883,28238,28624,28886,28946,29463,26999,27302,27382,27352,30115,30079,30261,30278,30357,30535,30798,30921,30953,32103,32104,27421,27236,29115,29203,27603,28870,28301,29055,30082,31742,29374,30775,30051,28958,27658,26309,26774,27659,25267,27048,25642,25712,25884,26355,26848,27213,27646,27657,27693,28116,28388,28744,28956,29535,31078,31367,31368,31870,32133,32474,25648,26501,28984,29222,32475,25649,25701,25908,25948,26088,26089,26405,26406,26621,26881,27604,28555,28657,29423,30023,30026,30347,30633,30759,31535,31673,32006,26502,30465,30562,30823,31048,26706,27291,32487,30466,30589,30961,30191,30563,30954,30992,32566,32567,36861,30824,31006,31266,31933,36862,31049,31363,28985,29731,30613,29223,30021,31464,31971,26024,25265,25278,25281,25342,25348,25526,25552,25663,25826,25835,27044,27787,28240,28538,29941,26025,26665,26786,27178,27650,28220,29646,31431,31710,31800,32246,25275,25314,25336,25360,25389,25468,25484,25496,25528,25532,25584,25831,26119,26191,26241,26248,26264,26427,26864,27056,28054,31826,37435,25276,25613,27591,25277,25353,25588,26298,26346,26477,26509,26869,26870,27280,27474,27605,28074,28519,28830,29748,29782,30006,30311,30671,31200,31220,31934,32033,32121,32122,25614,26204,26207,26430,27129,27566,27903,27904,29001,29122,29581,29744,29811,30018,30387,30448,30920,31256,31729,31750,31875,31954,31988,32012,32248,27592,27598,25315,26047,26322,28206,25316,25317,25318,25319,25397,25608,25700,25791,25886,25910,26378,26379,26495,26691,26731,26732,26766,26822,26833,26878,26908,26989,27027,27105,27157,27205,27223,27294,27332,27391,27408,27478,27509,27510,27511,27643,27711,27712,27735,27750,27759,27760,27761,27762,27800,27801,27927,27961,27976,28114,28182,28427,28971,29180,29559,29694,29816,30212,30305,30389,30428,30687,31076,31239,31404,31552,31761,31867,31927,32232,32233,32234,26048,26767,26990,27392,27437,27438,28002,28579,29064,29104,29105,30260,30582,30876,31208,31530,31541,32025,32235,32236,26323,27120,29457,28207,29008,30139,30479,30721,30957,25337,25395,25696,25697,25879,25901,25993,26172,26184,26185,26210,26288,26289,26375,26376,26529,26554,26674,26675,26876,26934,27025,27042,27204,27305,27306,27324,27325,27463,27476,27477,27506,27507,27508,27567,27642,27680,27734,27860,27893,27913,27995,28042,28092,28093,28180,28181,28190,28255,28652,28867,28889,28926,28947,28948,29298,29388,29678,29732,29982,29994,30138,30662,30935,30955,30970,31075,31089,31128,31238,31287,31562,31796,31797,31798,31874,31902,32000,32105,32106,32107,32108,32109,32110,32111,32112,32113,32114,32115,32209,32210,32211,32212,32213,32214,32215,32216,25361,25401,26113,26804,25362,25609,25742,25810,25971,26028,26263,26475,26678,26823,26991,27043,27106,27684,28043,28379,28710,28733,29269,29270,29985,30041,30359,30472,30536,30797,30910,30981,31161,31199,31647,31799,31829,31972,32099,25402,26879,27295,27751,30706,30931,31111,31191,31243,31472,31622,31716,31929,32003,32139,26114,26305,26494,26531,26893,26935,27293,27405,27808,28086,28289,28306,28353,28972,29212,29271,29733,29867,30423,30478,31173,31563,26805,28192,28801,29582,25390,25534,25599,25818,25391,25937,25982,26087,26360,26456,26662,26692,26796,27095,27185,27233,27491,27576,27602,27664,27754,27872,27873,28392,28445,30282,30283,30912,30960,31734,31975,32091,25535,25536,25537,25538,25539,27820,27821,27822,27823,27824,28957,25600,25965,26096,26097,26098,26290,26368,26389,26535,26592,26615,26654,26664,26809,27085,27121,27220,27420,27570,30635,31420,31736,31737,31879,31977,25819,25951,25952,25953,26090,26091,26092,26093,26094,26095,26103,26255,26609,26663,26707,26897,27028,27115,27266,27400,27722,27756,27902,28349,28350,30160,31003,31735,31807,31872,31877,31976,32019,25469,26117,26730,28018,25485,25487,31930,25486,25549,26076,27020,27179,27235,27457,27563,27812,27827,27836,28026,28151,28616,28964,29005,29177,29549,29827,29828,29970,29971,29993,30100,30105,30165,30228,30326,30393,30418,30579,30702,30860,30889,30951,31069,31101,31313,31648,32059,32063,32123,32125,32126,32127,32128,32249,32251,32252,32253,25488,25489,25490,25491,25492,25493,25494,25495,25550,25551,25918,26213,26712,26713,27479,27828,28156,28157,28158,28159,28160,28408,28409,28410,28670,28671,28775,29066,29202,29310,29352,29817,29890,30166,30167,30168,30360,30488,30489,30490,30491,31102,31129,31931,25497,26205,27502,29311,29398,29708,29818,29829,30747,31209,31301,31915,31994,32040,25529,25860,25861,25862,25940,26424,26425,26570,26699,26725,26753,26799,26944,27231,27373,27637,27667,27719,28070,28197,28286,28296,28541,28757,30510,30511,30658,31176,31707,31708,31822,31997,25533,25657,26280,26351,26754,26755,27177,27531,27701,27819,27909,28051,28052,28297,28614,28615,29478,30198,30291,30681,30719,30968,31632,32237,32238,32239,25585,25902,26003,26131,26467,26880,27357,27608,28217,28312,28481,28547,28548,28784,28826,28855,28872,29033,29541,29542,29720,29721,29722,29777,30122,30206,30453,30689,30870,31013,31276,31283,31320,31497,31502,31717,31719,31739,31813,31814,32034,32116,32117,32118,32119,25832,26321,26514,26888,26894,26952,27586,28094,28244,29118,29389,29390,29617,30151,31677,31720,26120,27111,28246,29403,26192,26242,28369,29797,30734,30988,26249,27364,27597,27609,27615,27815,27880,27901,28025,28037,28050,28188,28320,28419,28450,28485,28521,28549,28551,28557,28578,28658,28694,28721,28758,28796,28859,29073,29187,29188,29308,29350,29369,29442,29547,29588,29670,29860,29885,29930,29969,30192,30348,30391,30544,31092,31193,31262,31532,31582,31600,31804,32120,32217,32218,32219,32220,32221,26265,28271,26266,27644,27652,27653,27685,28142,28325,29106,29418,39126,39127,39128,39129,28272,28355,28686,28738,28868,29221,29583,30269,30773,30899,31500,26428,26429,27007,28081,28175,28385,28397,28398,28662,28663,29787,30090,30316,30325,30626,30678,30859,31045,31118,26865,28875,29000,29466,29802,27057,27587,28138,28354,28737,28793,28916,29191,29645,30010,30374,31179,31775,31834,31886,32101,32269,28055,28056,28057,28058,28059,29286,29287,29288,29289,29290,29291,30135,30136,31125,31126,31513,31827,37436,38291,38392,38405,38924,38959,38963,39006,39007,39008,39026,39027,39055,39056,39069,39078,39085,39092,39101,39102,39109,39112,39116,39117,39118,39121,25279,25291,25296,25420,25500,25658,25709,25723,27578,28816,30731,25280,25387,25904,25926,26188,26457,26468,26574,26627,26816,26896,27089,27137,27596,27817,27940,27991,28204,28219,28330,28331,28347,28373,28414,28863,28879,28955,29072,29074,29935,30030,30094,30434,30521,30548,30883,31370,31476,31685,31757,25388,25925,26344,27135,27442,27443,27485,27486,27487,27869,28016,28162,28718,29027,29315,29434,29826,29896,29897,30046,30295,30320,30321,30657,30794,31304,31881,25927,26151,26152,26291,26473,26658,26969,27040,27146,27198,27323,27594,27595,27672,27737,27818,27870,27985,28100,28163,28164,28165,28166,28194,28280,28281,28282,28283,28284,28372,28394,28532,28533,28781,28783,28842,28890,28891,28892,28981,29112,29127,29316,29317,29326,29373,29405,29605,29756,29843,29990,30047,30296,30394,30492,30561,30696,31032,31033,31911,31952,32018,25292,25941,26016,26318,31556,31644,31900,31985,25297,25789,26070,26348,26365,27248,27249,27809,27932,27965,28907,29396,29833,29879,29908,30031,30224,30414,30445,30446,30571,30872,31062,31588,31698,31699,31770,25421,25741,25803,26035,26075,26150,26254,26751,26756,26757,26872,26929,27039,27071,27107,27145,27320,27778,27938,28067,28089,28127,28196,28617,28704,28787,28840,28841,29211,29550,29609,29880,29943,30033,30323,30522,30604,30643,30644,30755,30772,30871,30928,31037,31221,31260,31522,31610,31670,31841,32038,25501,25502,25503,25504,25505,25506,25507,25508,25509,25510,25511,25512,25513,25514,25515,25516,25517,25518,25519,25520,25521,25522,25540,25541,25543,25544,25545,25546,25547,25548,26010,26200,27488,27825,28167,28673,29243,29318,29319,29320,29321,29602,29685,29686,29687,29688,29689,29690,29755,29773,29819,30048,30173,30174,30175,30177,30178,30231,30297,30351,30406,30493,30504,30505,30506,30507,30508,30597,30609,30832,31056,31213,31377,31995,32043,25659,25905,26187,26354,26384,27356,27388,27471,27635,27677,27854,27967,28027,28344,28345,28645,28649,28696,28697,28699,28702,28893,29067,29068,29069,29178,29474,29594,29595,29736,29835,29965,30073,30134,30199,30293,30356,30523,30545,31036,31057,31127,31188,31331,31360,31658,31684,31878,31943,32135,25710,26230,26534,26926,27888,28034,28556,28609,28772,28824,29007,29096,29139,29345,29427,29459,29536,29668,29674,29741,29834,29858,29906,29958,29963,29964,30065,30368,30415,30709,30785,30812,30933,31247,31288,32014,32083,32191,32192,32247,25724,26128,26203,26931,27096,27550,28076,28843,29075,29102,29199,29300,29465,29725,30697,31137,31214,31665,31956,27579,27948,28102,28817,31906,31907,31958,31959,32231,30732,31481,31771,25282,25287,25711,25839,25968,25988,26008,26278,26449,26607,26729,27013,27029,27272,27523,27826,27858,27916,27959,28200,28202,28305,28359,28455,28495,28586,28797,28885,29062,29224,29226,29262,29482,29562,29747,29757,29759,29798,29859,29957,30081,30154,30289,30315,30409,30585,30619,30652,30670,30840,30851,30893,30982,31023,31086,31207,31244,31245,31353,31392,31441,31466,31553,31560,31571,31579,31583,31871,31946,32085,32124,32129,32136,32207,32208,32250,25343,25344,26279,26312,26626,26651,27017,27475,27704,28259,28323,28407,28765,28766,28858,28970,29402,29563,30084,30383,30606,30816,30962,30980,31124,31312,31504,31676,32062,25349,26211,25350,27100,27937,27953,28066,28322,28395,28441,28756,28905,28969,29095,29832,30164,30911,31053,31068,31090,31222,31341,31342,31702,31968,32199,32287,26212,26311,26313,26546,26936,26954,27849,27859,28270,28864,29034,29453,29455,29574,29728,29788,29874,29886,30085,30262,30552,30570,30623,30916,30925,31543,31570,31727,31849,31903,31921,31936,32130,32131,32132,32278,39130,25527,26118,26930,27240,27241,27243,27398,27681,28440,28458,28587,28588,28589,28659,28873,28978,28979,29144,29145,29146,29284,29307,29815,29862,29863,29864,29968,30281,30319,30385,30440,30441,30442,30482,30483,31083,31084,31317,31318,32200,32201,32202,32203,32204,32205,32206,32243,32244,32245,25553,25645,25554,25555,25556,25557,25558,25559,25560,25561,25562,25563,25589,27829,27830,27831,27832,29076,25646,26307,26409,26527,26671,26741,26882,27544,27931,29011,29197,29616,29842,29953,30180,31487,31745,31795,31832,31928,31942,32027,25664,26045,26162,27430,29049,25665,25863,26029,27616,27683,27746,27789,28149,28321,28343,28522,28526,28648,28794,28953,28999,29200,29301,29309,29393,29548,30015,30268,30684,31024,31091,31115,31160,31215,31325,31381,31738,31754,31823,31923,32240,26046,26398,26451,26955,27307,27489,27674,28130,28248,28367,28689,29746,30095,30193,30874,30990,31202,31362,31397,31446,26163,26932,27232,27358,27532,28451,31307,31355,31786,32241,32242,27431,29899,31396,29050,30575,25827,25954,26445,27148,27201,27246,27726,27885,27908,28361,28362,28366,29093,29133,29272,29344,29387,29456,29649,29712,30157,30725,30898,31017,31055,31534,32265,25836,27158,27464,28183,28940,30036,30804,31811,32072,27045,27335,28500,28974,29126,30728,31925,27788,28929,30146,32229,32230,28241,29135,31940,28539,30690,29942,31545,25284,25438,25828,26432,26525,27300,27503,25285,25651,28231,25286,25666,25878,26021,26342,26783,26928,29306,30037,30271,30437,30586,30663,30856,30857,30989,31100,31192,31196,31337,31440,31544,31768,31847,31966,32190,25652,26245,27304,27679,28990,29979,30369,30796,28232,28546,28792,30950,31585,25439,25743,26253,26407,26549,26924,27155,27399,27699,27977,28523,28962,29558,29936,32047,25829,25899,25943,26606,26628,26685,27008,27112,27127,27285,27370,27389,27848,28310,29153,30029,30784,30805,31227,31506,31801,31883,26433,26542,26763,28040,28486,28727,29551,29552,31494,31712,31789,26526,30005,31073,27301,27607,27763,30128,30349,30555,31178,31356,31539,31718,27504,28121,28494,29297,29485,29493,30080,30577,30647,31232,31237,31280,31596,25436,25721,25858,26037,26038,26039,26156,26201,26202,26316,26395,26396,26423,26565,26566,26602,26603,26604,26818,26819,26971,26972,27371,27372,27814,28069,30833,31135,36876,36872,32421,31609,31164,31354,30629,30605,29902,29484,26702,27208,27238,27465,27915,27970,28360,29060,29651,25708,25761,25842,26247,26273,26776,26884,26956,26957,27136,27209,27259,27319,27337,27490,27543,27557,27645,27802,28821,28980,30634,31020,31291,31989,25956,28901,28902,29419,30649,30821,30842,31146,31147,31449,25787,26189,26190,26385,26440,27239,27689,27966,28030,29092,29376,29392,29841,29974,30208,30648,30717,31311,31810,32102,32738,32739,28039,27625,32740,25780,26443,26670,26831,27182,27218,27538,27554,27731,28374,29251,29545,30310,28148,29100,29056,39022,39106,39120,39123,29451,36925,31219,30339,31619,25812,27086,27876,25628,25762,25813,26193,26332,26383,26444,26612,26735,26825,27000,27114,27379,28117,28328,28389,28677,28918,29194,29439,29569,29734,29960,30218,30567,30811,30959,31113,31184,31275,31407,31514,31835,31932,25637,25726,26040,26129,26448,26740,26752,26810,27041,27076,27303,27551,27582,27613,27941,28146,28223,28260,28483,28543,28724,28725,28997,29148,29384,29385,29642,29710,29723,29729,30002,30381,30392,30557,30574,30595,30596,30766,31165,31183,31557,32193,32194,32195,32196,32197,32262,25638,25781,25793,26470,26684,27729,28017,28998,29406,29494,29997,30184,30461,30573,30838,31087,31158,31284,31394,31438,31537,31848,31960,26209,26334,27087,29726,31051,31452,26364,26724,26981,27128,27346,27911,29039,30194,36929,36930,26746,25471,26779,25631,25946,25960,36890,28621,25823,26381,27806,28020,30430,32466,36845,32573,26747,32575,32321,26748,36836,36837,36838,36839,32478,26764,36833,36834,36835,32322,36832,32534,32538,32536,32535,32537,25472,29190,29445,29948,30312,31653,28113,28925,31969,31371,31348,30666,28544,36931,25807,31347,25644,30526,26020,31444,31499,30758,30686,30132,26484,26488,27390,28511,27958,27348,27347,27153,26320,25931,36927,25473,26560,29848,30340,30679,31450,31477,26561,30781,26562,26780,27964,28641,28857,29172,30317,30412,30850,25632,26001,29205,31839,26960,25633,26275,26404,29995,30287,30413,31743,26002,29206,30638,31840,28375,30421,29471,26961,27321,28669,28939,29125,30371,29992,30162,32540,31758,32539,31162,26181,30102,25947,30219,31970,30757,31372,31838,29876,32544,32470,30590,30435,32368,31726,26852,30452,36841,36842,26736,36843,26112,28812,29765,29766,30390,28510,36895,30770,30314,25981,31837,27192,30771,31652,31357,31346,31050,25961,29058,28251,27725,29473,29711,28993,31299,36840,31081,36891,28622,28705,29446,30560,31272,31454,31654,31765,32084,25824,28848,26382,28352,28668,28910,29875,31991,27807,28021,29767,30054,30431,30432,36849,36857,36850,36858,32467,36846,36847,36848,36859,36860,32574,25619,26026,26331,26711,27184,27406,27407,27692,27998,28083,28084,28233,28263,28333,28553,28631,28685,28769,28806,28949,28950,29155,29382,29395,29620,29677,29836,30020,30034,30195,30588,30630,30675,30714,31398,32469,32511,32763,32471,32756,32476,32484,32488,32494,32499,32759,32503,32506,32508,32767,32513,32559,32571,32746,32748,32752,32765,32775,36854,32473,36852,36853,32481,32501,32505,32510,32523,36855,32524,32528,32564,32512,32562,32568,32570,32745,32750,32777,32472,32516,32569,32517,32744,39138,32757,32758,32762,36856,32477,32521,32520,32519,32492,32599,32743,32497,32496,32486,32518,32502,32485,32493,32522,32598,32741,32742,32764,32489,32498,32495,32529,32500,32760,32761,32504,32507,32751,32509,32768,32769,32770,32771,32772,32773,32774,32514,32778,32779,32560,32561,36851,32572,32747,32749,32753,32754,32755,32766,32776,36886,36907,36908,36914,36909,36910,36911,36913,36912,32547,32550,32555,32548,32551,32552,32553,32554,32556,32557,32558,32582,32587,32580,32583,32584,32432,32430,32431,36830,32433,32435,32436,32437,32434,32429,32581,32585,32586,29163,31079,26061,31478,27341,27422,27648,28719,30103,30223,30266,30342,26059,32080,29164,31080,26062,26337,26575,28019,29991,30286,30884,39149,39048,32589,39057,39067,39073,39125,36900,39152,36935,39148,39054,39150,39151,36880,36881,36882,36883,36884,36885,36934,36936,36937,39153,32441,32439,32443,32442,32445,32446,32444,39124,32480,25358,26719,27360,27376,30620,25359,26310,29185,29909,30716,26720,26923,27093,28943,27361,28317,30336,32290,27377,28091,28371,29996,30621,32491,32533,32549,26179,26781,27001,27002,27342,27695,27696,28639,29401,30163,30341,30426,31412,32324,32325,32326,32327,32328,32329,32330,32331,32332,32333,32334,32335,32336,32337,32338,32339,32340,32341,32342,32343,32344,32345,32346,32347,32348,32349,32350,32351,32352,32353,32355,32356,32357,32358,32359,32360,32361,32362,32363,32364,32365,26296,25305,25304,26622,27298,27803,30835,26297,25930,27997,25307,31345,26623,26624,26625,27322,27568,27569,28288,29103,27299,27804,27956,29253,29254,29343,30813,25460,25869,26167,26435,26571,26668,27345,27622,27739,27794,27795,28104,28198,28488,28620,31217,31457,31486,31508,31635,31756,31941,32097,32284,27022,27180,28108,32259,29623,32289,26107,26108,26109,26788,26789,27353,27354,27355,28666,30946,26023,26110,26111,30969,31054,31061,31662,31724,31740,25834,26027,26584,27149,28131,29201,29889,29905,30534,30718,31151,31361,31885,26583,32405,32406), msProduct.published=1, msProduct.deleted=0</b>
0.0000448: Replaced TV conditions
0.0003421: Sorted by <b>msProduct.editedon</b>, <b>DESC</b>
0.0000072: Limited to <b>8</b>, offset <b>0</b>
0.0019610: SQL prepared <small>"SELECT `msProduct`.`id`, `msProduct`.`type`, `msProduct`.`contentType`, `msProduct`.`pagetitle`, `msProduct`.`longtitle`, `msProduct`.`description`, `msProduct`.`alias`, `msProduct`.`alias_visible`, `msProduct`.`link_attributes`, `msProduct`.`published`, `msProduct`.`pub_date`, `msProduct`.`unpub_date`, `msProduct`.`parent`, `msProduct`.`isfolder`, `msProduct`.`introtext`, `msProduct`.`richtext`, `msProduct`.`template`, `msProduct`.`menuindex`, `msProduct`.`searchable`, `msProduct`.`cacheable`, `msProduct`.`createdby`, `msProduct`.`createdon`, `msProduct`.`editedby`, `msProduct`.`editedon`, `msProduct`.`deleted`, `msProduct`.`deletedon`, `msProduct`.`deletedby`, `msProduct`.`publishedon`, `msProduct`.`publishedby`, `msProduct`.`menutitle`, `msProduct`.`donthit`, `msProduct`.`privateweb`, `msProduct`.`privatemgr`, `msProduct`.`content_dispo`, `msProduct`.`hidemenu`, `msProduct`.`class_key`, `msProduct`.`context_key`, `msProduct`.`content_type`, `msProduct`.`uri`, `msProduct`.`uri_override`, `msProduct`.`hide_children_in_tree`, `msProduct`.`show_in_tree`, `msProduct`.`properties`, `Data`.`article`, `Data`.`price`, `Data`.`old_price`, `Data`.`weight`, `Data`.`image`, `Data`.`thumb`, `Data`.`vendor`, `Data`.`made_in`, `Data`.`new`, `Data`.`popular`, `Data`.`favorite`, `Data`.`tags`, `Data`.`color`, `Data`.`size`, `Data`.`source`, `Vendor`.`name` AS `vendor.name`, `Vendor`.`resource` AS `vendor.resource`, `Vendor`.`country` AS `vendor.country`, `Vendor`.`logo` AS `vendor.logo`, `Vendor`.`address` AS `vendor.address`, `Vendor`.`phone` AS `vendor.phone`, `Vendor`.`fax` AS `vendor.fax`, `Vendor`.`email` AS `vendor.email`, `Vendor`.`description` AS `vendor.description`, `Vendor`.`properties` AS `vendor.properties`, `250x250`.url as `250x250`, IFNULL(`TVimg`.`value`, '') AS `img`, IFNULL(`TVimgtv`.`value`, '') AS `imgTV` FROM `modx_site_content` AS `msProduct` LEFT JOIN `modx_ms2_products` `Data` ON `msProduct`.`id` = `Data`.`id` LEFT JOIN `modx_ms2_vendors` `Vendor` ON Data.vendor=Vendor.id LEFT JOIN `modx_ms2_product_files` `250x250` ON `250x250`.product_id = msProduct.id AND `250x250`.rank = 0 AND `250x250`.path LIKE '%/250x250/%' LEFT JOIN `modx_site_tmplvar_contentvalues` `TVimg` ON `TVimg`.`contentid` = `msProduct`.`id` AND `TVimg`.`tmplvarid` = 6 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVimgtv` ON `TVimgtv`.`contentid` = `msProduct`.`id` AND `TVimgtv`.`tmplvarid` = 27 WHERE ( `msProduct`.`class_key` = 'msProduct' AND `Data`.`new` = '1' AND `msProduct`.`parent` IN (33,25383,25263,25470,25618,32468,36906,32546,32428,26060,32438,32479,25357,32490,26178,25303,25459,27021,29622,32288,26106,26022,25833,26582,32404,36920,25736,26285,26777,25384,26063,27264,25639,25843,26031,26239,26335,26387,26517,26550,27224,30641,32318,36921,25737,26519,27558,30800,30039,25635,30104,25738,26175,26824,27193,28430,28708,28959,29015,29130,29358,29410,30343,26520,26895,28252,28567,29357,30724,30801,31413,30854,31434,30802,31414,31479,26286,27288,30974,30038,26287,26356,27287,28581,29961,36928,27289,27522,27529,27633,27634,27962,27973,27974,28033,28152,28153,28268,28269,28377,28572,28608,28656,28900,29265,29420,29998,30372,32313,30975,31159,31463,26778,27024,28063,30891,29618,29245,25837,26235,25385,25604,25661,25686,25690,25794,25816,25999,28438,30112,28087,29806,32312,31897,29619,30133,30379,30449,30469,30553,29246,29680,30096,28399,32407,30416,29415,25838,27118,27284,29849,31432,31565,26236,26504,26548,26851,27156,27447,27553,32403,31511,25386,25790,27660,27898,28637,31748,25605,28357,29232,29461,29577,29976,30673,31035,31286,31604,31817,31818,31979,32031,25662,25730,26690,26905,36875,32420,32300,26904,25687,25880,26302,27154,27367,27441,27742,28155,28304,28479,29280,30088,30930,31760,25691,26553,26709,26733,26812,26943,27091,27227,27237,27669,28195,28391,28402,28405,28415,28496,28568,28682,28743,28862,29208,29247,29467,29497,29794,30089,30183,30564,30963,31022,31226,31282,31442,31621,31846,32292,32293,32294,32295,32296,32297,32298,32299,32301,32302,32303,32304,32305,32306,32308,32309,32310,32311,32307,25795,25980,26238,26958,27706,28629,28852,29162,29640,30161,30543,31836,25817,32563,26000,26461,26614,27088,27495,27496,27497,27572,27647,28215,28492,28564,28565,28566,28706,28707,28732,29490,29491,29492,29570,30092,30222,28439,28860,30113,30450,30819,30888,30907,30909,31018,31206,31225,31411,31682,31924,26064,26598,27038,32314,32315,32316,32317,27265,30849,31257,32319,32320,30639,28720,30924,27811,28849,25640,26728,27033,32291,29304,29233,29483,28115,26937,26951,28065,28850,29006,29207,29644,29786,30886,31085,31268,31551,31669,31802,27369,30818,26849,28628,28709,25845,27016,27741,27978,28413,29195,28820,26032,28822,29949,30272,31230,32600,26033,26121,26922,27494,27675,27676,28132,31569,32078,28823,29338,30220,30221,29950,30028,30273,30338,30370,30578,30685,30799,30918,31231,31749,36878,36879,26240,26959,26336,26597,27628,36831,30762,29557,27755,27886,27451,29059,31052,31155,30087,26388,26721,31595,26722,31349,30053,31350,31451,27435,27194,27363,27687,28607,28818,30097,30367,30425,30530,31116,31261,31559,31603,31668,32013,26518,27922,28319,28992,29294,29400,29648,30032,30052,30267,30677,30978,31373,31593,31605,26274,25998,29955,27723,26551,28314,28944,27724,31395,28966,31901,27960,27395,26552,27972,28315,28401,26447,28945,29578,30480,30887,27191,27225,30976,27226,27745,28129,28493,29117,31153,31285,30977,31154,31410,30642,30669,30711,37076,28265,36938,36948,36989,37032,37058,37062,37073,37112,37369,37399,37497,37604,38568,25763,26079,25896,25339,25693,25272,25338,31228,28562,25874,29572,26459,27049,25354,25597,25596,25746,25266,25647,25264,25283,25435,26701,25707,25955,25786,25779,28147,25627,25636,26208,26363,26694,26980,31194,36926,37077,37248,38451,38488,39063,37078,37108,37234,37446,37704,37738,37249,38589,38935,38982,37250,37326,37542,37814,38590,38591,38704,38705,38791,38792,38862,38863,38912,38913,39030,39031,39034,39035,38936,38937,38946,38947,39009,39010,39050,39051,39070,39071,39083,39084,39090,39091,39096,39097,38983,38984,38987,38988,39037,39038,39081,39082,38452,38553,38584,38593,38604,38622,38632,38633,38489,38491,38490,38543,38597,38601,38616,38640,38702,38784,38795,38492,38598,38602,38617,38641,38703,38785,39064,39098,39065,39066,39079,39080,39087,39088,39099,39100,39113,39114,32408,32410,32411,32409,32413,32414,32415,32416,32412,29141,28266,28387,29134,29440,29847,30636,30917,31254,31999,36939,36968,37045,37126,37340,37390,37428,37468,37538,37563,37620,36940,36956,37024,37220,36941,36942,36943,36944,36945,36946,36947,36952,36953,36954,36958,36959,36960,36961,36962,36963,36964,36965,36966,36967,36972,36973,36974,36980,36981,36984,36985,36986,36987,36988,36992,36993,36994,36996,36997,36998,37000,37002,37005,37006,37007,37012,37013,37018,37019,37020,37021,37023,37027,37028,37029,37031,37035,37037,37038,37039,37042,37043,37049,37050,37052,37053,37054,37055,37056,37057,37061,37068,37070,37079,37080,37081,37082,37084,37087,37089,37092,37093,37094,37097,37101,37105,37107,37109,37110,37111,37114,37115,37116,37120,37125,37128,37131,37149,37150,37153,37154,37166,37167,37168,37177,37179,37190,37191,37192,37193,37194,37197,37201,37231,37235,37243,37255,37263,37271,37274,37276,37277,37278,37279,37288,37295,37300,37312,37328,37329,37330,37363,37384,37406,37410,37411,37422,37431,37472,37477,37486,37526,37533,37544,37574,37623,37647,37661,37698,37712,37786,37824,37874,37884,38019,36957,36979,36982,36999,37011,37014,37036,37041,37072,37086,37090,37118,37121,37185,37202,37260,37284,37317,37338,37389,37420,37515,37518,37617,37706,37722,37800,37025,37040,37069,37083,37088,37095,37106,37117,37137,37164,37180,37203,37228,37236,37272,37273,37286,37331,37221,37270,37289,37310,37351,37353,37357,37419,37423,37427,37452,37457,37478,37485,37512,37523,37541,37566,37609,37726,37732,37733,37736,37830,37886,38064,38230,36969,37051,37071,37102,37122,37155,37267,37404,37487,37490,37549,37677,37705,37046,37302,37503,37618,38313,37047,38131,37048,37215,37359,37395,37396,37397,37418,38311,38326,38393,38396,38404,38421,38442,38132,38397,38446,38525,38571,38637,38883,38889,39001,37303,37339,37493,37494,37495,37496,37551,37589,37590,37611,37612,37640,37641,37642,37643,37654,37692,37693,37739,37740,37820,37821,37901,37504,37557,37586,37587,37632,37619,37919,37966,38006,38054,38069,38285,38314,38423,38441,38454,38549,38677,38831,37127,37171,37172,37181,37182,37183,37184,37187,37204,37205,37207,37212,37216,37218,37219,37242,37244,37246,37247,37253,37256,37258,37259,37262,37265,37266,37268,37269,37296,37301,37304,37309,37311,37313,37318,37319,37323,37325,37352,37365,37375,37403,37421,37433,37454,37479,37481,37507,37508,37513,37521,37522,37534,37573,37610,37616,37627,37628,37629,37656,37669,37675,37696,37747,37758,37759,37776,37780,37812,37870,37882,37910,37977,37981,38031,38074,38081,38138,38157,38167,38249,38257,38295,38412,38578,37341,37407,37463,37516,37601,37602,37639,37714,37783,37855,37900,37907,38016,38104,38108,38236,38262,38321,38378,38440,38496,38500,38550,38614,38670,37391,37636,37777,37962,37429,37442,37560,37575,37599,37668,37682,37756,37822,37897,37927,37990,38120,38168,38242,38265,38533,38534,38535,37469,37530,37531,37532,37539,37845,37846,37847,38034,38035,37564,37622,37681,37729,37798,37621,37680,37837,37936,38149,38217,38333,38395,38539,38579,38623,38659,38713,38744,38765,38794,38835,38855,38885,38900,38934,38942,38985,39004,36949,36975,37132,37280,37360,37379,37414,37554,37972,38218,36950,38047,36951,36955,36970,36971,37003,37017,37022,37030,37085,37098,37099,37100,37129,37138,37139,37152,37159,37160,37161,37165,37233,37237,37240,37241,37291,37292,37293,37376,37447,37448,37449,37655,37849,37939,38067,38273,38588,38625,38709,39089,38048,38049,38127,38128,38186,38187,38220,38221,38277,38278,38413,38418,38475,38476,38477,38478,38560,38561,38564,38565,38778,38846,38857,38872,38879,38880,38903,38904,38908,38972,38973,38990,38991,39045,36976,37142,37662,37671,36977,37144,37229,36978,36983,37145,37176,37252,37327,37511,37230,37143,37151,37188,37189,37198,37307,37308,37322,37334,37335,37336,37350,37354,37356,37372,37373,37392,37437,37438,37455,37491,37492,37561,37562,37565,37625,37626,37635,37651,37652,37687,37663,37664,37695,37751,37801,37803,37806,37815,37834,37850,37872,37873,37902,37905,37926,37940,37975,37999,38000,38007,38020,38022,38033,38056,38080,38084,38090,38093,38098,38099,38150,38180,38185,38197,38200,38207,38216,38232,38233,38237,38252,38267,38268,38280,38319,38322,38349,38351,38371,38372,38377,38381,38383,38402,38406,38407,38414,38424,38425,38437,38453,38457,38470,38510,38512,38513,38514,38521,38530,38531,38542,38554,38555,38557,38567,38574,38575,38580,38585,38629,38630,38645,38652,38653,38657,38658,38665,38678,38679,38683,38684,38699,38700,38706,38707,38711,38720,38728,38729,38733,38735,38752,38753,38761,38772,38800,38801,38820,38826,38829,38830,38856,38860,38864,38865,38866,38868,38902,38943,37672,37762,38111,38634,38668,38806,39018,39020,37673,37749,37992,38156,38464,38551,37763,37766,37785,37805,37848,37890,38087,38174,38175,38231,38271,38272,38410,38411,38612,38669,38807,38838,38897,39019,39110,39021,39111,37133,37332,38144,37134,37135,37136,37169,37170,37195,37208,37209,37210,37261,37264,37285,37297,37320,37324,37337,37355,37366,37386,37405,37417,37432,37461,37464,37476,37483,37528,37540,37550,37579,37598,37615,37660,37699,37723,37734,37743,37877,38126,38159,38258,38275,38298,38299,38303,38332,38455,38501,38605,38618,38648,38672,38689,38747,38767,38769,38789,38793,38844,38921,37333,37580,37811,37853,37879,37974,38046,38091,38095,38121,38318,38323,38364,38757,38145,38417,38495,38526,38581,38642,38643,38666,38671,38682,38708,38760,38762,38781,38790,38818,38832,38861,38873,38881,38907,38926,38927,38938,38941,38970,38979,38980,38994,39015,39033,39049,39108,37281,37859,37880,38587,37282,37298,37364,37367,37378,37443,37444,37514,37519,37571,37657,37709,37713,37741,37768,37823,37865,37943,38038,38041,38115,38196,38208,38283,38309,38331,38348,38390,38391,38427,38504,38536,38819,37860,37913,37987,38073,38075,38261,37881,37986,38039,38044,38293,38294,38338,38527,38528,38566,38620,38685,38686,38715,38839,38840,37361,37362,37453,37462,37500,37600,37637,37689,37807,37887,37982,37984,38029,38165,38191,38240,38244,38370,38389,38468,38517,38651,38756,38827,38847,38854,38867,38895,38910,38992,37380,37381,37382,37383,37670,37742,37794,37795,37796,37797,37841,37866,37867,37868,37876,37963,37964,37965,37988,38106,38141,38222,38223,38224,38227,38238,38239,38284,38320,38334,38335,38336,38343,38354,38387,38436,38443,38487,38726,38750,38817,38834,38843,38875,38922,37415,37649,38101,38365,37416,37630,37638,37707,37784,37839,37898,37928,37969,38024,38160,38754,38917,37650,37724,37789,37793,37827,37878,37945,38032,38109,38123,38139,38140,38143,38176,38253,38270,38302,38342,38380,38408,38444,38450,38466,38483,38516,38556,38615,38646,38676,38680,38723,38755,38771,38780,38822,38102,38178,38276,38308,38400,38448,38458,38481,38493,38537,38558,38577,38606,38692,38732,38746,38751,38848,38911,38950,38956,39023,38366,38420,38508,38613,38647,38674,38687,38740,38768,38786,38815,38837,38852,38877,38898,38916,38948,38965,38974,37555,37556,37658,37857,37915,38025,38066,38119,38188,38201,38384,38523,38691,37973,38360,38376,38459,38673,38716,38814,38893,38940,38961,38995,39014,39046,38219,38340,38374,38438,38486,38607,38635,38638,38655,38660,38742,38758,38759,38774,38797,38824,38853,38870,38876,38890,38899,38939,38953,38966,38996,39002,39012,36990,37305,37439,37458,37545,37552,37727,37745,38051,38136,38505,38518,36991,36995,37001,37004,37008,37009,37010,37015,37016,37026,37044,37091,37130,37186,37211,37387,37450,37480,37527,37631,37645,37760,37769,37774,37782,37832,37835,37842,37843,37856,37903,37995,38011,38028,38096,38162,38171,38266,38324,38330,38379,38465,37306,38656,37440,37441,37932,37933,37934,37459,37546,37558,37567,37553,38190,37728,37735,37894,37895,37746,38287,38345,38052,38053,38209,38210,38346,38347,38359,38137,38506,38519,38520,38738,38739,37033,38886,37034,37398,37408,37529,37674,37755,37802,37825,37889,37908,37925,37937,38078,38082,38107,38118,38130,38135,38154,38161,38163,38173,38179,38194,38203,38212,38264,38279,38286,38350,38375,38415,38429,38460,38472,38479,38482,38498,38507,38563,38572,38681,38722,38741,38887,37059,37103,37123,37173,37222,37225,37348,37473,37060,37096,37140,37141,37206,37217,37227,37275,37290,37385,37388,37482,37488,37594,37104,37254,37358,37501,37688,37836,37862,38026,37124,37342,37347,37761,37844,38202,38325,38461,37174,37175,37199,37200,37223,37224,37344,37345,37346,37430,37595,37596,37790,37791,37792,37858,37996,37997,38181,38182,38183,38184,38255,37226,38254,37349,37374,37505,37506,37683,37684,37685,37686,37474,37475,37524,37525,38008,38009,38088,38089,38964,38981,38998,38999,39043,39044,39107,37063,37146,37393,37412,38225,38357,38850,37064,37066,37465,37911,37065,37196,37232,37509,37971,37067,37466,37467,37536,37537,37576,37912,38269,37147,37607,38502,37148,37157,37158,37377,37409,37608,37665,37691,37700,37715,37716,37765,37773,38193,38503,38696,37394,37451,37588,37613,37644,37659,37679,37711,37764,37781,37831,37854,37985,37989,38012,38085,38810,38821,38884,38969,39017,37413,37581,37646,37864,38027,38061,38226,38305,38306,38358,38439,38811,38851,37074,37162,37238,37314,37701,37753,37808,38858,39024,37075,37119,37156,37178,37213,37214,37245,37294,37321,37343,37368,37424,37426,37445,37456,37489,37543,37559,37572,37577,37593,37633,37697,37708,37710,37721,37737,37748,37752,37767,37770,37816,37833,37838,37869,37875,37917,37941,37944,37991,37994,38116,38164,38243,37163,37299,37510,37779,37883,37924,38356,38515,39059,37239,37251,37257,37502,37582,37583,37603,37624,37634,37667,37725,37730,37731,37750,37778,37788,37804,37810,37817,37828,37829,37863,37893,37909,37921,37922,37935,37942,37960,37961,37978,37979,37993,37998,38005,38015,38043,38045,38050,38057,38058,38059,38065,38094,38103,38110,38117,38122,38146,38151,38155,38158,38195,38213,38214,38215,38228,38229,38235,38248,38263,38274,38281,38288,38289,38292,38355,38362,38368,38369,38385,38394,38398,38399,38409,38426,38428,38463,38467,38471,38474,38484,38485,38494,38511,38522,38541,38562,38582,38608,38610,38611,38649,38663,38664,38710,38717,38718,38719,38721,38775,38776,38777,38779,38783,38796,38812,38813,38816,38841,38954,38955,39005,37315,37316,38570,38576,38595,38714,38944,38986,39016,39028,39042,39053,37702,37717,37775,37819,37980,38055,38072,38147,38148,38169,38250,38256,38282,38304,38532,38599,37754,37757,38023,38083,38105,38241,38312,38435,38447,38473,38583,38624,38631,38650,38945,37809,38524,38859,39086,39025,39039,39074,39115,39119,39122,37113,37283,37287,37916,38234,38290,38339,37370,37371,37425,37535,37547,37568,37597,37648,37666,37690,37744,37813,37818,37826,37851,37852,37861,37871,37885,37888,37892,37896,37904,37906,37918,37920,37923,37929,37938,37976,38001,38003,38004,38010,38017,38021,38030,38036,38037,38040,38042,38062,38068,38076,38077,38086,38092,38097,38112,38113,38129,38142,38152,38153,38170,38172,38177,38189,38206,38211,38245,38259,38260,38300,38301,38315,38316,38317,38329,38341,38386,38416,38433,38445,38449,38480,38529,38538,38644,37400,38070,38431,37401,37591,37771,38327,37402,37434,37460,37470,37471,37484,37614,37653,37676,37678,37694,37592,37703,38079,37772,37840,37970,38002,38114,38124,38422,38469,38497,38559,38573,38609,38328,38337,38361,38382,38430,38071,38363,38603,38804,38432,38871,38888,37498,37569,37584,37718,37946,37967,38204,38296,38626,38661,38693,38748,39061,37499,37517,37520,37548,38100,38688,37570,37578,37914,37930,37983,38133,38134,38192,38246,38247,38251,38307,38352,38401,38419,38462,38499,38509,38545,38621,38639,38654,38803,38845,38869,37585,37799,38456,38586,38594,38628,38690,38737,38805,38909,38929,38962,38976,38978,39011,39041,39047,39052,39103,37719,38546,37720,38125,38166,38434,38547,38552,38743,38763,38882,38925,38977,37947,37948,37949,37950,37951,37952,37953,37954,37955,37956,37957,37958,37959,38013,38014,38198,38199,37968,38063,38310,38344,38353,38367,38373,38403,38540,38544,38548,38592,38619,38636,38675,38697,38698,38712,38736,38745,38764,38773,38782,38787,38788,38802,38809,38823,38836,38874,38878,38905,38931,38932,38951,38952,38958,38968,38971,38993,38997,39003,39013,39036,39068,39093,38205,38600,38667,38727,38828,38849,38892,38920,38930,38297,38388,38596,38901,38923,38627,38906,38915,38928,38949,38957,38662,38770,38798,38891,38919,38960,39029,39060,38694,38695,38701,38724,38725,38734,38749,38825,38914,38933,39062,37605,38730,37606,37787,37891,37899,37931,38018,38060,38731,38766,38799,38808,38833,38842,38894,38896,38918,38967,38975,38989,39000,39032,39040,39058,39072,38569,25764,25848,26489,26806,27098,28967,32594,32595,32596,32597,25765,26130,26462,27980,28205,28358,31198,32017,25849,26490,27884,28090,28309,32593,36915,36916,36917,36918,26807,26938,28545,28640,28919,36919,27099,27312,32588,32590,32591,32592,28968,29174,29305,26080,27743,39139,26081,30602,31119,31998,27744,28247,28422,28518,28790,29090,29285,29351,29575,29671,29745,29803,29870,29944,39140,39141,32374,25897,26068,27891,28880,29443,32375,39142,39143,39144,39145,25898,32530,32531,27521,27152,28798,28456,26069,26523,27362,32417,32418,27892,28499,28881,29278,29643,29672,29945,30270,29444,25340,26339,25341,31323,31981,26340,26578,27094,28478,25694,25774,26082,26224,26587,26947,27011,29267,30650,25695,29292,26826,25775,26487,32401,32402,32440,26083,29791,31533,26225,26686,27574,28302,30388,31507,26588,29978,32532,28428,26948,28750,29448,32664,28429,32673,32670,32671,28751,28714,26949,27640,28386,32672,32667,32668,32669,31007,30204,29449,32665,32666,27012,30720,29268,30836,30651,32024,25273,26410,27432,29696,30443,32371,36932,25274,25352,25634,25650,30376,30645,31058,31117,31169,31170,31696,31803,31865,32009,32074,32075,32542,32543,32541,29217,27877,28888,26920,28112,27805,26411,28643,28036,39156,39157,30057,28032,28808,29576,28795,27279,28390,29099,29339,27727,39154,30202,32376,29171,30890,29977,29784,29739,29561,27433,27900,31475,32073,39146,39147,32369,29697,32370,32515,30444,30866,30894,30895,31235,32372,32373,36933,39075,27380,32222,27638,25377,26182,25381,28828,25770,25820,26053,26221,26454,26506,26610,26859,27539,28605,28986,29844,29871,39076,39077,39094,39095,39104,39105,27381,28118,29579,29865,32223,32545,32576,32577,32578,32579,36873,36874,36905,32525,32526,28752,29204,29698,27639,27957,28236,29038,25378,28654,30328,36829,39134,39136,39137,36923,25379,26051,30497,30668,31197,36924,28655,28965,30525,39135,30329,31528,32011,26183,26471,27215,27707,28264,32081,32384,25382,25883,26596,27212,27426,27875,28267,29706,32029,32030,28829,29481,29947,30769,31386,25771,26065,26282,26466,26687,28229,28700,26066,26078,26450,26688,26939,27139,27207,27349,27575,27850,28237,28230,29359,28701,29009,25821,27245,26054,26703,26874,27797,26055,29216,26704,26875,27798,26222,26613,27214,27571,27979,31515,32005,26455,27923,28041,28767,29394,26507,26827,26883,27629,26611,28227,29154,26860,27278,27785,28045,28348,28484,28729,29273,29546,29555,29695,30700,27540,28768,29783,28606,29337,29391,29715,30197,30331,28987,29845,29846,29872,36863,36864,36865,36867,36866,31229,31594,31763,31864,36868,36869,28887,30365,29255,28563,30330,30458,30885,31713,32023,30257,30071,25875,36844,36888,25876,25900,36898,36901,36902,36903,36904,31884,31714,28811,30004,29556,30277,30568,31263,30429,36897,36899,36887,36889,30126,30077,30091,32447,29573,29962,32448,32449,32450,26460,27247,28119,28906,29124,29170,29295,29592,29956,32053,39131,39132,39133,36896,27050,27573,36870,36871,36893,36894,25355,25629,26791,28836,25356,26338,26683,29231,30993,31517,31764,25630,26086,26850,27585,27981,29952,31728,32061,26792,32285,32286,28837,29293,30217,30723,31983,26328,25598,25983,32424,32425,32527,32426,29653,26695,25744,30531,29654,29866,30205,30529,30825,31011,31163,31267,26696,28611,30459,26697,27090,27450,28064,28501,29129,32674,28612,29462,30185,32565,30460,31021,31806,25745,26749,27878,29061,30473,31253,31558,30532,30896,31114,32366,36877,32367,26243,25747,25870,36892,26084,26276,26998,27351,30078,26244,26343,26508,26580,26790,26832,27290,27317,25748,26145,26723,26762,27052,27498,27799,27852,28123,28644,29340,29785,25871,25984,26169,26380,26399,26608,26871,27009,27080,27103,27104,27316,28635,28636,31825,31926,29057,30395,30422,29946,30768,26085,26510,27068,27138,27452,27519,27556,27641,27851,27912,28228,28813,28839,28921,29053,29065,29210,29417,26277,27453,27883,28238,28624,28886,28946,29463,26999,27302,27382,27352,30115,30079,30261,30278,30357,30535,30798,30921,30953,32103,32104,27421,27236,29115,29203,27603,28870,28301,29055,30082,31742,29374,30775,30051,28958,27658,26309,26774,27659,25267,27048,25642,25712,25884,26355,26848,27213,27646,27657,27693,28116,28388,28744,28956,29535,31078,31367,31368,31870,32133,32474,25648,26501,28984,29222,32475,25649,25701,25908,25948,26088,26089,26405,26406,26621,26881,27604,28555,28657,29423,30023,30026,30347,30633,30759,31535,31673,32006,26502,30465,30562,30823,31048,26706,27291,32487,30466,30589,30961,30191,30563,30954,30992,32566,32567,36861,30824,31006,31266,31933,36862,31049,31363,28985,29731,30613,29223,30021,31464,31971,26024,25265,25278,25281,25342,25348,25526,25552,25663,25826,25835,27044,27787,28240,28538,29941,26025,26665,26786,27178,27650,28220,29646,31431,31710,31800,32246,25275,25314,25336,25360,25389,25468,25484,25496,25528,25532,25584,25831,26119,26191,26241,26248,26264,26427,26864,27056,28054,31826,37435,25276,25613,27591,25277,25353,25588,26298,26346,26477,26509,26869,26870,27280,27474,27605,28074,28519,28830,29748,29782,30006,30311,30671,31200,31220,31934,32033,32121,32122,25614,26204,26207,26430,27129,27566,27903,27904,29001,29122,29581,29744,29811,30018,30387,30448,30920,31256,31729,31750,31875,31954,31988,32012,32248,27592,27598,25315,26047,26322,28206,25316,25317,25318,25319,25397,25608,25700,25791,25886,25910,26378,26379,26495,26691,26731,26732,26766,26822,26833,26878,26908,26989,27027,27105,27157,27205,27223,27294,27332,27391,27408,27478,27509,27510,27511,27643,27711,27712,27735,27750,27759,27760,27761,27762,27800,27801,27927,27961,27976,28114,28182,28427,28971,29180,29559,29694,29816,30212,30305,30389,30428,30687,31076,31239,31404,31552,31761,31867,31927,32232,32233,32234,26048,26767,26990,27392,27437,27438,28002,28579,29064,29104,29105,30260,30582,30876,31208,31530,31541,32025,32235,32236,26323,27120,29457,28207,29008,30139,30479,30721,30957,25337,25395,25696,25697,25879,25901,25993,26172,26184,26185,26210,26288,26289,26375,26376,26529,26554,26674,26675,26876,26934,27025,27042,27204,27305,27306,27324,27325,27463,27476,27477,27506,27507,27508,27567,27642,27680,27734,27860,27893,27913,27995,28042,28092,28093,28180,28181,28190,28255,28652,28867,28889,28926,28947,28948,29298,29388,29678,29732,29982,29994,30138,30662,30935,30955,30970,31075,31089,31128,31238,31287,31562,31796,31797,31798,31874,31902,32000,32105,32106,32107,32108,32109,32110,32111,32112,32113,32114,32115,32209,32210,32211,32212,32213,32214,32215,32216,25361,25401,26113,26804,25362,25609,25742,25810,25971,26028,26263,26475,26678,26823,26991,27043,27106,27684,28043,28379,28710,28733,29269,29270,29985,30041,30359,30472,30536,30797,30910,30981,31161,31199,31647,31799,31829,31972,32099,25402,26879,27295,27751,30706,30931,31111,31191,31243,31472,31622
Комментарии: 8
У вас большой
Ну и
чет многовато)
8.5561 s — Parse Timeнужно смотреть чанк msProduct
Ну и
751 — Query Count -Shows how many database queries MODX made
чет многовато)
Спасибо что откликнулись и так быстро!
Код чанка следующий:
Код чанка следующий:
<div class="col-xs-6 col-lg-3 ms2_product" style="padding: 0 !important">
<div class="element relative">
<form method="post" class="ms2_form">
<div class="element-buttons">
<div class="table">
<div class="table-cell text-center">
[[+template:is=`3`:then=`
<div>
<button class="to-cart-yellow" type="submit" name="ms2_action" value="cart/add"><i class="material-icons">shopping_cart</i> В корзину</button>
<input type="hidden" name="id" value="{$id}">
<input type="hidden" name="options" value="[]">
<input type="hidden" name="count" id="count-{$id}" value="1">
</div>
`:else=``]]
<div class="push15"></div>
<div>
<a href="{$_modx->makeUrl($id)}" class="to-cart-white"><i class="material-icons">navigate_next</i>Подробнее</a>
</div>
</div>
</div>
</div>
<div class="inner">
<div class="img-wrapper">
<div class="table">
<div class="table-cell text-center">
[[+class_key:is=`msCategory`:then=`
[[+tv.imgTV:is=``:then=`<img src="[[+tv.img:default=`[[!msGallery?tpl=`msGalleryCategory`&product=`[[+id]]`&limit=`1`]]`:phpthumbon=`w=200&f=webp&q=65`]]" data-img="[[+tv.img:default=`[[!msGallery?tpl=`msGalleryCategory`&product=`[[+id]]`&limit=`1`]]`:phpthumbon=`w=200&f=webp&q=65`]]" class="zerone lazy" alt="{$pagetitle}" />`:else=`<img src="[[+tv.imgTV]]" data-img="[[+tv.imgTV]]" class="zerone lazy" alt="{$pagetitle}" />`]]
`:else=``]]
[[+template:is=`3`:then=`
[[+imgTV:is=``:then=`<img src="[[+img:default=`[[!msGallery?tpl=`msGalleryCategory`&product=`[[+id]]`&limit=`1`]]`:phpthumbon=`w=200&f=webp&q=65`]]" data-img="[[+img:default=`[[!msGallery?tpl=`msGalleryCategory`&product=`[[+id]]`&limit=`1`]]`:phpthumbon=`w=200&f=webp&q=65`]]" class="zerone lazy x" alt="{$pagetitle}" />`:else=`<img src="[[+imgTV]]" data-img="[[+imgTV]]" class="zerone lazy y" alt="{$pagetitle}" />`]]
`:else=``]]
</div>
</div>
</div>
<div class="category"><span>[[pdoField?&id=`[[+id]]`&topLevel=`2`]]</span></div>
<div class="title">
<div class="table">
<div class="table-cell">
<h6>{$pagetitle}</h6>
</div>
</div>
</div>
[[+class_key:is=`msCategory`:then=``:else=`
<div class="catalog-flags">
[[+new:is=`1`:then=`
<p><i class="material-icons">star</i> [[%ms2_frontend_new]] <i class="material-icons">star</i></p>
`:else=``]]
[[+popular:is=`1`:then=`
<p><i class="material-icons">star</i> [[%ms2_frontend_popular]] <i class="material-icons">star</i></p>
`:else=``]]
[[+favorite:is=`1`:then=`
<p><i class="material-icons">star</i> [[%ms2_frontend_favorite]] <i class="material-icons">star</i></p>
`:else=``]]
</div>
`]]
[[+template:is=`3`:then=`
<div class="element-price-wrap">
{if $old_price?}
<span class="old-price strike f12 red">{$old_price} {'ms2_frontend_currency' | lexicon}</span>
{/if}
<span class="price">[[+price]]</span> <span>{'ms2_frontend_currency' | lexicon}</span>
<!-- [[pdoField? &id=`[[+id]]` &field=`pricetv`]] -->
</div>
`:else=``]]
</div>
</form>
</div>
</div>
Чанк выглядит ужасно)
Оптимизируйте.
Во-первых, в чанке доступен Fenom, а у вас смесь из Fenom и родного парсера MODX.
И в этом вся проблема.
Если вы не знаете, то вот это
В первом примере КОД 1 и КОД 2 все равно ВСЕГДА сначала выполняются (!), а только потом парсер показывает результат в зависимости от условия.
Учитывая, что у вас там внутри еще вызовы различных сниппетов…
А вот во втором примере все работает хорошо, сначала проверяется условие, и только потом выполняется КОД 1 или КОД 2.
Далее
ну и самый трэш здесь
Оптимизируйте.
Во-первых, в чанке доступен Fenom, а у вас смесь из Fenom и родного парсера MODX.
И в этом вся проблема.
Если вы не знаете, то вот это
[[+template:is=`3`:then=`КОД 1`:else=`КОД 2`]]
и вот это{if $template == 2}
КОД 1
{else}
КОД 2
{/if}
работает совершенно по разному!В первом примере КОД 1 и КОД 2 все равно ВСЕГДА сначала выполняются (!), а только потом парсер показывает результат в зависимости от условия.
Учитывая, что у вас там внутри еще вызовы различных сниппетов…
А вот во втором примере все работает хорошо, сначала проверяется условие, и только потом выполняется КОД 1 или КОД 2.
Далее
<!-- [[pdoField? &id=`[[+id]]` &field=`pricetv`]] -->
это комментарий html! Код все равно выполняется!!!ну и самый трэш здесь
[[+tv.imgTV:is=``:then=`
<img
src="[[+tv.img:default=`[[!msGallery?tpl=`msGalleryCategory`&product=`[[+id]]`&limit=`1`]]`:phpthumbon=`w=200&f=webp&q=65`]]"
data-img="[[+tv.img:default=`[[!msGallery?tpl=`msGalleryCategory`&product=`[[+id]]`&limit=`1`]]`:phpthumbon=`w=200&f=webp&q=65`]]"
class="zerone lazy"
alt="{$pagetitle}" />
`:else=`
<img src="[[+tv.imgTV]]"
data-img="[[+tv.imgTV]]"
class="zerone lazy"
alt="{$pagetitle}" />
`]]
я даже разбираться боюсь и не хочу, это просто кладезь тормозов.
Спасибо! Попробую оптимизировать код чанка и снова замерю скорость
Код оптимизировал. Однако время осталось все же очень большим. Для эксперимента сделал практически пустую страницу с pdoMenu и результатами порядка 200 элементов
0,7 c на выборку 200 элементов — это перебор
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
[[pdoMenu? &parents=`0` &scheme=`full` &level=`3` &where=`{"template:!=":3}`]]
<b>[^qt^]</b> - Query Time - Shows how long MODx took talking to the database <br />
<b>[^q^]</b> - Query Count -Shows how many database queries MODX made <br />
<b>[^p^]</b> - Parse Time - Shows how long MODX took to parse the page <br />
<b>[^t^]</b> - Total Time - Shows the total time taken to parse/ render the page <br />
<b>[^s^]</b> - Source - Shows the source of page, whether is database or cache. <br />
</body>
</html>
Результат:0.0053 s - Query Time - Shows how long MODx took talking to the database
3 - Query Count -Shows how many database queries MODX made
0.2581 s - Parse Time - Shows how long MODX took to parse the page
0.2634 s - Total Time - Shows the total time taken to parse/ render the page
cache - Source - Shows the source of page, whether is database or cache.
Поставил debugParser и вот картина:# Tag Queries Queries time, s Parse Time, s
1 [[pdoMenu? &parents=`0` &scheme=`full` &level=`3` &where=`{"template:!=":3}`]] 12 0.0100107 0.4148281
Total parse time 0.7210090 s
Total queries 20
Total queries time 0.0185585 s
Memory peak usage 12 Mb
MODX version MODX Revolution 2.7.3-pl (advanced)
PHP version 5.6.40
Database version mysql 10.2.39-MariaDB
From cache false
Дело явно не в msProduct. 0,7 c на выборку 200 элементов — это перебор
Я вижу «Результат 0.2634 s — Total Time» — если у вас в pdoMenu 200 элементов рендерится — выглядит приемлемым (ну может хостинг не самый быстрый).
Когда работает debugParser — считай видим результат без кеша. Вообще долго конечно, 0,7 с, но опять же… 200 элементов… При этом время на sql запросы маленькое, а вот парсинг долгий…
Ради прикола вызвал этот же код на одном из своих сайтов, где 25000 страниц, а при генерации меню с level=3 генерируется около 1800 пунктов в этом самом меню.
1й вызов (без кеша):
Может у вас плагины какие-нибудь висят или еще что-то подобное?
Когда работает debugParser — считай видим результат без кеша. Вообще долго конечно, 0,7 с, но опять же… 200 элементов… При этом время на sql запросы маленькое, а вот парсинг долгий…
Ради прикола вызвал этот же код на одном из своих сайтов, где 25000 страниц, а при генерации меню с level=3 генерируется около 1800 пунктов в этом самом меню.
1й вызов (без кеша):
0.4623 s — Query Time — Shows how long MODx took talking to the database2 вызов (с кешем):
1844 — Query Count -Shows how many database queries MODX made
0.8484 s — Parse Time — Shows how long MODX took to parse the page
1.3107 s — Total Time — Shows the total time taken to parse/ render the page
database — Source — Shows the source of page, whether is database or cache.
0.0041 s — Query Time — Shows how long MODx took talking to the databaseкак видно, во втором случае все очень хорошо и быстро отрабатывает…
21 — Query Count -Shows how many database queries MODX made
0.0325 s — Parse Time — Shows how long MODX took to parse the page
0.0366 s — Total Time — Shows the total time taken to parse/ render the page
cache — Source — Shows the source of page, whether is database or cache.
Может у вас плагины какие-нибудь висят или еще что-то подобное?
MODX version MODX Revolution 2.7.3-pl (advanced)
PHP version 5.6.40
А обновить движок или php пробовали? Хотя бы до php 7.2?А pdoTools — у вас какой версии?
Пока вопрос повышения версии php упирается в работу старых дополнений, несовместимых с 7. Но такой вариант в планах есть в любом случае.
pdoTools 2.12.7-pl
pdoTools 2.12.7-pl
Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.