SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.006462s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.006883s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.010495s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.001934s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.002488s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001035s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.002309s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.001920s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001744s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.017434s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007213s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.002348s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.005014s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002693s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002820s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002944s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003704s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002254s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003521s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.004518s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002137s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002186s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002137s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.003563s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.001976s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.005107s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002275s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.003301s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.000972s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002158s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.001996s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.005699s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.000902s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002420s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009462s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008266s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.013371s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005315s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006068s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.005195s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.002003s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002172s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001283s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002110s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003021s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002366s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002569s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.005547s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.003530s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.004612s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001577s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.004783s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.004430s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001610s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.003446s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.003397s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.003476s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.004955s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002992s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003347s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.005157s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.002429s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.002103s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003683s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002737s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.004628s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.002116s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002871s ]
SELECT * FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.004464s ]
SELECT * FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.002596s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.005713s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000601s ]
(SELECT rownum - 1 AS ROW FROM (SELECT *, (@i :=@i + 1) AS rownum FROM xms_document, (SELECT @i := 0) AS it WHERE states=1 and catid=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 95) [ RunTime:0.005144s ]
SELECT * FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.006721s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.001082s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001684s ]
(SELECT rownum - 1 AS ROW FROM (SELECT *, (@i :=@i + 1) AS rownum FROM xms_document, (SELECT @i := 0) AS it WHERE states=1 and catid=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 95) [ RunTime:0.003927s ]
SELECT * FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.006324s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.003625s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001625s ]
(SELECT rownum + 1 AS ROW FROM (SELECT *, (@i :=@i + 1) AS rownum FROM xms_document, (SELECT @i := 0) AS it WHERE states=1 and catid=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 95) [ RunTime:0.007367s ]
SELECT * FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.003568s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 95 LIMIT 1 [ RunTime:0.003343s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.004271s ]
(SELECT rownum + 1 AS ROW FROM (SELECT *, (@i :=@i + 1) AS rownum FROM xms_document, (SELECT @i := 0) AS it WHERE states=1 and catid=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 95) [ RunTime:0.002073s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006986s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003681s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 82 LIMIT 1 [ RunTime:0.000665s ]
SELECT * FROM `xms_document` WHERE `catid` = '82' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.002716s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003361s ]
SELECT * FROM `xms_document` WHERE `catid` = '32' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` DESC,`sortid` ASC LIMIT 100 [ RunTime:0.003324s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.005236s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.002238s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.005253s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000719s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000606s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.009179s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002978s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.016579s ]
SELECT * FROM `xms_document` WHERE `catid` = '34' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.002949s ]
SELECT * FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.005909s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.003534s ]
SELECT * FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.005713s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000666s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 89 LIMIT 1 [ RunTime:0.001207s ]
SELECT * FROM `xms_document` WHERE `catid` = '89' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` DESC,`sortid` DESC LIMIT 100 [ RunTime:0.003764s ]
SELECT * FROM `xms_category` WHERE `id` = 89 LIMIT 1 [ RunTime:0.012084s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002116s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.001439s ]
SELECT * FROM `xms_document` WHERE `catid` = '33' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.004077s ]
SELECT * FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.006915s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001363s ]
SELECT * FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.002161s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002784s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.001450s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.002268s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002721s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002068s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002197s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002762s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002067s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002427s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002276s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002267s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002209s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.019518s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002445s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002274s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002276s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002244s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.002255s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.001349s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002209s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003108s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.000880s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.000807s ]
SELECT * FROM `xms_document` WHERE ( catid='87' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004787s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003267s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007389s ]
SELECT * FROM `xms_document` WHERE ( catid='62' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005459s ]
SELECT * FROM `xms_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.006145s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.001094s ]
SELECT * FROM `xms_document` WHERE ( catid='63' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008397s ]
SELECT * FROM `xms_category` WHERE `id` = 63 LIMIT 1 [ RunTime:0.005465s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.002817s ]
SELECT * FROM `xms_document` WHERE ( catid='64' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005137s ]
SELECT * FROM `xms_category` WHERE `id` = 64 LIMIT 1 [ RunTime:0.014328s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 29 LIMIT 1 [ RunTime:0.001088s ]
SELECT * FROM `xms_document` WHERE ( catid='45' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003479s ]
SELECT * FROM `xms_category` WHERE `id` = 45 LIMIT 1 [ RunTime:0.004659s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000858s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003595s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010231s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.011143s ]
