SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.007837s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.002943s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.006468s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.003362s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.003507s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002149s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.003771s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.004046s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003334s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.014264s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005079s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.004471s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.002854s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001801s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001671s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.006405s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002000s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001429s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001997s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002810s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.003879s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002591s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002535s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.004764s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002639s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.003936s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.003836s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.002405s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.002415s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003123s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003977s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003260s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.002260s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004716s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009953s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009315s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010577s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009787s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008344s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.008080s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.004099s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.005690s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.000886s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001699s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.004152s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.004657s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003619s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.001266s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002420s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.005139s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002663s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.003193s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002084s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002249s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.015497s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.002109s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.003786s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003121s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.001890s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002732s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.016758s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.002012s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.002092s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001917s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002864s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001299s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001903s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001078s ]
SELECT * FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000945s ]
SELECT * FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000846s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000542s ]
(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 = 228) [ RunTime:0.002081s ]
SELECT * FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000807s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000488s ]
(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 = 228) [ RunTime:0.002002s ]
SELECT * FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.011177s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000561s ]
(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 = 228) [ RunTime:0.001962s ]
SELECT * FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000843s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 228 LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000530s ]
(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 = 228) [ RunTime:0.002007s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000899s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.000851s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 82 LIMIT 1 [ RunTime:0.029294s ]
SELECT * FROM `xms_document` WHERE `catid` = '82' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.002265s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.009307s ]
SELECT * FROM `xms_document` WHERE `catid` = '34' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.002375s ]
SELECT * FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.002368s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.002403s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001542s ]
SELECT * FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.001018s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001691s ]
SELECT * FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.001575s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000995s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001674s ]
SELECT * FROM `xms_document` WHERE `catid` = '32' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` DESC,`sortid` ASC LIMIT 100 [ RunTime:0.002554s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.004706s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000808s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003188s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.003513s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.002231s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000899s ]
SELECT * FROM `xms_document` WHERE `catid` = '33' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.004732s ]
SELECT * FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.003139s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001528s ]
SELECT * FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.001182s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.007392s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.000824s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.000781s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001501s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.005181s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.000823s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.000793s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003698s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.006135s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002941s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002640s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002967s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.004011s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.005079s ]
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=20 ) ORDER BY sortid asc [ RunTime:0.001862s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.003227s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.004544s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.004362s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002354s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003097s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.006736s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.001984s ]
SELECT * FROM `xms_document` WHERE ( catid='87' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003032s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008461s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.014036s ]
SELECT * FROM `xms_document` WHERE ( catid='62' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003061s ]
SELECT * FROM `xms_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.005739s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000606s ]
SELECT * FROM `xms_document` WHERE ( catid='63' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002424s ]
SELECT * FROM `xms_category` WHERE `id` = 63 LIMIT 1 [ RunTime:0.003260s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000905s ]
SELECT * FROM `xms_document` WHERE ( catid='64' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004540s ]
SELECT * FROM `xms_category` WHERE `id` = 64 LIMIT 1 [ RunTime:0.003635s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000539s ]
SELECT * FROM `xms_document` WHERE ( catid='45' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002288s ]
SELECT * FROM `xms_category` WHERE `id` = 45 LIMIT 1 [ RunTime:0.003508s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 23 LIMIT 1 [ RunTime:0.001524s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003600s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006016s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005908s ]
