联系我们-烟台华莱数据技术有限公司

当前位置：首页联系我们

烟台华莱数据技术有限公司

Yantai Hualai Data Technology Co. Ltd.

咨询热线
0535-3022690

E-mail
hlsj@hualai.com.cn

地址
山东省烟台市高新区科技大道69号创业大厦西区21楼

传真
0535-3022700

网址
www.hualai.com.cn

关注华莱公众号

基本文件流程错误 SQL 调试

E:\web\0026\index.php ( 0.67 KB )
E:\web\0026\Include\ThinkPHP.php ( 4.70 KB )
E:\web\0026\Include\Library\Think\Think.class.php ( 12.32 KB )
E:\web\0026\Include\Library\Think\Storage.class.php ( 1.38 KB )
E:\web\0026\Include\Library\Think\Storage\Driver\File.class.php ( 3.54 KB )
E:\web\0026\Include\Mode\common.php ( 2.82 KB )
E:\web\0026\Include\Common\functions.php ( 51.83 KB )
E:\web\0026\App\Common\Common\function.php ( 43.57 KB )
E:\web\0026\Include\Library\Think\Hook.class.php ( 4.02 KB )
E:\web\0026\Include\Library\Think\App.class.php ( 13.46 KB )
E:\web\0026\Include\Library\Think\Dispatcher.class.php ( 15.03 KB )
E:\web\0026\Include\Library\Think\Route.class.php ( 13.38 KB )
E:\web\0026\Include\Library\Think\Controller.class.php ( 10.95 KB )
E:\web\0026\Include\Library\Think\View.class.php ( 7.96 KB )
E:\web\0026\Include\Library\Behavior\BuildLiteBehavior.class.php ( 3.69 KB )
E:\web\0026\Include\Library\Behavior\ParseTemplateBehavior.class.php ( 3.89 KB )
E:\web\0026\Include\Library\Behavior\ContentReplaceBehavior.class.php ( 1.91 KB )
E:\web\0026\Include\Conf\convention.php ( 11.24 KB )
E:\web\0026\App\Common\Conf\config.php ( 1.57 KB )
E:\web\0026\App\Common\Conf\tags.php ( 0.14 KB )
E:\web\0026\Include\Lang\zh-cn.php ( 2.57 KB )
E:\web\0026\Include\Conf\debug.php ( 1.50 KB )
E:\web\0026\App\Common\Common\other.php ( 0.21 KB )
E:\web\0026\App\Common\Conf\db.php ( 0.22 KB )
E:\web\0026\App\Home\Conf\config.php ( 1.25 KB )
E:\web\0026\App\Home\Common\function.php ( 0.09 KB )
E:\web\0026\Include\Library\Behavior\ReadHtmlCacheBehavior.class.php ( 5.62 KB )
E:\web\0026\App\Home\Controller\ListController.class.php ( 5.68 KB )
E:\web\0026\App\Home\Controller\HomeCommonController.class.php ( 1.19 KB )
E:\web\0026\Include\Library\Think\Model.class.php ( 66.57 KB )
E:\web\0026\Include\Library\Think\Db.class.php ( 5.68 KB )
E:\web\0026\Include\Library\Think\Db\Driver\Mysql.class.php ( 6.53 KB )
E:\web\0026\Include\Library\Think\Db\Driver.class.php ( 40.85 KB )
E:\web\0026\App\Common\Lib\Category.class.php ( 3.97 KB )
E:\web\0026\App\Common\LibTag\Wang.class.php ( 1.35 KB )
E:\web\0026\Include\Library\Think\Template\TagLib.class.php ( 9.19 KB )
E:\web\0026\Include\Library\Think\Template.class.php ( 28.38 KB )
E:\web\0026\App\Common\Model\CategoryViewModel.class.php ( 1.44 KB )
E:\web\0026\App\Common\Model\ExViewModel.class.php ( 6.06 KB )
E:\web\0026\Include\Library\Think\Model\ViewModel.class.php ( 9.58 KB )
E:\web\0026\App\Common\Lib\Page.class.php ( 6.06 KB )
E:\web\0026\App\Common\LibTag\Yang.class.php ( 63.28 KB )
E:\web\0026\App\Common\LibTag\Other.class.php ( 1.33 KB )
E:\web\0026\Include\Library\Think\Template\TagLib\Cx.class.php ( 22.62 KB )
E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php ( 20.45 KB )
E:\web\0026\App\Common\Model\ArcViewModel.class.php ( 2.95 KB )
E:\web\0026\Include\Library\Behavior\WriteHtmlCacheBehavior.class.php ( 0.98 KB )
E:\web\0026\Include\Library\Behavior\ShowPageTraceBehavior.class.php ( 5.27 KB )

[8] Undefined index: pid E:\web\0026\App\Home\Controller\ListController.class.php 第 48 行.
[8] Undefined variable: status E:\web\0026\App\Common\Common\function.php 第 106 行.
[8] Undefined variable: update E:\web\0026\App\Common\Common\function.php 第 108 行.
[2] Missing argument 1 for Think\Model::where(), called in E:\web\0026\App\Home\Controller\ListController.class.php on line 134 and defined E:\web\0026\Include\Library\Think\Model.class.php 第 1771 行.
[8] Undefined variable: where E:\web\0026\Include\Library\Think\Model.class.php 第 1779 行.
[8] Undefined variable: where E:\web\0026\Include\Library\Think\Model.class.php 第 1782 行.
[8] Undefined variable: where E:\web\0026\Include\Library\Think\Model.class.php 第 1790 行.
[2] Missing argument 1 for Think\Model::where(), called in E:\web\0026\App\Home\Controller\ListController.class.php on line 139 and defined E:\web\0026\Include\Library\Think\Model.class.php 第 1771 行.
[8] Undefined variable: where E:\web\0026\Include\Library\Think\Model.class.php 第 1779 行.
[8] Undefined variable: where E:\web\0026\Include\Library\Think\Model.class.php 第 1782 行.
[8] Undefined variable: where E:\web\0026\Include\Library\Think\Model.class.php 第 1790 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 40 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 43 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 43 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 45 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 40 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 43 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 40 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 43 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 43 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 40 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 43 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 32 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 35 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 43 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 139 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant jumpurl - assumed 'jumpurl' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 139 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 139 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 139 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 136 行.
[8] Use of undefined constant id - assumed 'id' E:\web\0026\App\Runtime\Cache\Home\a99bff7208e12b4179a634c0b063b10f.php 第 140 行.

SHOW COLUMNS FROM `xyh_visitor` [ RunTime:0.0018s ]
SELECT * FROM `xyh_visitor` WHERE ( datetime = 1732204800 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `xyh_visitor` WHERE ( datetime = 1732204800 and find_in_set('18.191.87.157',ips) ) LIMIT 1 [ RunTime:0.0002s ]
UPDATE `xyh_visitor` SET `ips`='116.179.32.221,104.232.79.138,35.231.59.131,112.13.112.6,112.13.112.75,14.103.83.67,216.244.66.200,104.243.129.94,121.237.36.29,14.128.63.14,121.237.36.27,39.173.107.140,121.237.36.30,219.82.2.110,113.215.189.246,121.237.36.28,40.77.167.65,116.179.32.33,77.74.177.114,220.181.108.166,198.2.234.176,47.103.91.135,112.86.225.253,116.179.32.43,43.152.72.247,223.109.252.227,17.241.219.80,185.191.171.7,17.241.75.216,220.181.108.102,220.181.108.84,112.86.225.62,124.64.200.148,124.237.211.93,205.234.146.2,220.181.108.169,220.181.108.144,185.147.125.23,124.237.211.223,39.173.107.153,116.179.32.70,115.209.76.199,49.76.97.177,180.119.80.77,183.166.146.74,125.123.154.222,223.247.166.86,183.148.3.204,183.166.170.89,110.82.164.4,117.65.1.16,49.64.184.154,60.184.193.78,125.121.118.96,121.227.129.113,122.236.24.119,122.236.26.173,121.226.4.58,125.105.226.157,114.233.8.11,115.226.247.220,183.7.104.121,60.184.255.227,60.184.253.182,175.155.3.90,113.133.227.129,27.191.60.185,114.103.73.230,59.56.38.26,182.107.181.155,27.156.187.148,182.107.180.231,58.52.86.158,183.158.102.135,117.27.2.179,122.232.238.167,116.179.32.236,60.188.9.135,113.141.91.58,220.181.108.155,18.224.31.90,220.181.108.103,60.188.10.15,39.173.107.253,17.241.75.61,223.109.252.184,112.86.225.53,112.0.180.195,208.100.26.247,110.176.103.24,170.106.73.216,192.95.30.12,195.191.219.132,185.191.171.13,220.181.108.146,112.86.225.224,116.179.32.19,42.236.101.237,121.229.156.21,52.167.144.235,18.223.125.236,18.216.42.122,18.191.9.9,185.191.171.16,18.191.87.157',`count`=count + 1 WHERE `id` = 2291 [ RunTime:0.0002s ]
SHOW COLUMNS FROM `xyh_category_access` [ RunTime:0.0015s ]
SELECT `roleid` FROM `xyh_category_access` WHERE `catid` = 7 AND `flag` = 0 AND `action` = 'visit' [ RunTime:0.0001s ]
SHOW COLUMNS FROM `xyh_category` [ RunTime:0.0013s ]
SELECT * FROM `xyh_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `xyh_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.0002s ]
SHOW COLUMNS FROM `xyh_category` [ RunTime:0.0014s ]
SHOW COLUMNS FROM `xyh_model` [ RunTime:0.0015s ]
SELECT category.id AS id,category.name AS name,category.ename AS ename,category.catpic AS catpic,category.image AS image,category.pid AS pid,category.modelid AS modelid,category.type AS type,category.seotitle AS seotitle,category.keywords AS keywords,category.description AS description,category.template_category AS template_category,category.template_list AS template_list,category.template_show AS template_show,category.des AS des,category.status AS status,category.sort AS sort,category.eng AS eng,category.pictureurls AS pictureurls,model.name AS modelname,model.tablename AS tablename FROM xyh_category category LEFT JOIN xyh_model model ON category.modelid = model.id WHERE ( pid=1 ) ORDER BY category.sort ASC,category.id ASC [ RunTime:0.0003s ]
SELECT `content` FROM `xyh_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `xyh_job` [ RunTime:0.0015s ]
SELECT COUNT(*) AS tp_count FROM `xyh_job` LIMIT 1 [ RunTime:0.0001s ]
SELECT * FROM `xyh_job` ORDER BY job_id DESC LIMIT 0,10 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `xyh_article` [ RunTime:0.0014s ]
SELECT article.id AS id,article.title AS title,article.shorttitle AS shorttitle,article.color AS color,article.copyfrom AS copyfrom,article.author AS author,article.keywords AS keywords,article.litpic AS litpic,article.description AS description,article.publishtime AS publishtime,article.updatetime AS updatetime,article.click AS click,article.cid AS cid,article.commentflag AS commentflag,article.flag AS flag,article.jumpurl AS jumpurl,article.status AS status,article.userid AS userid,article.aid AS aid,article.pictureurls AS pictureurls,article.orderlist AS orderlist,category.name AS catename,category.ename AS ename,category.modelid AS modelid FROM xyh_article article LEFT JOIN xyh_category category ON article.cid = category.id WHERE article.status = 0 AND article.cid IN (2) ORDER BY article.orderlist desc,article.publishtime DESC LIMIT 100 [ RunTime:0.0004s ]
SELECT * FROM `xyh_category` WHERE `pid` = 7 ORDER BY sort asc,id asc LIMIT 1 [ RunTime:0.0002s ]
SELECT article.id AS id,article.title AS title,article.shorttitle AS shorttitle,article.color AS color,article.copyfrom AS copyfrom,article.author AS author,article.keywords AS keywords,article.litpic AS litpic,article.description AS description,article.publishtime AS publishtime,article.updatetime AS updatetime,article.click AS click,article.cid AS cid,article.commentflag AS commentflag,article.flag AS flag,article.jumpurl AS jumpurl,article.status AS status,article.userid AS userid,article.aid AS aid,article.pictureurls AS pictureurls,article.orderlist AS orderlist,category.name AS catename,category.ename AS ename,category.modelid AS modelid FROM xyh_article article LEFT JOIN xyh_category category ON article.cid = category.id WHERE article.status = 0 AND article.cid IN (2) ORDER BY article.orderlist desc,article.publishtime DESC LIMIT 100 [ RunTime:0.0004s ]