基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-09-21 09:00:13 HTTP/1.1 GET : http://www.lagxw.com/index.html
- 运行时间 : 0.108945s [ 吞吐率：9.18req/s ] 内存消耗：6,016.03kb 文件加载：153
- 查询信息 : 47 queries
- 缓存信息 : 0 reads,0 writes
- CONNECT:[ UseTime:0.000397s ] mysql:host=127.0.0.1;port=3306;dbname=lagxnew;charset=utf8
- SHOW FULL COLUMNS FROM `cms_operate_log` [ RunTime:0.000834s ]
- INSERT INTO `cms_operate_log` SET `user_id` = 1 , `user_name` = '系统' , `url` = 'http://www.lagxw.com/index.html' , `method` = 'GET' , `ip` = '18.191.60.249' , `content` = '[]' , `controller` = 'Index' , `action` = 'index' , `param` = NULL , `domain` = 'www' , `create_time` = 1726880413 [ RunTime:0.000320s ]
- SHOW FULL COLUMNS FROM `cms_company` [ RunTime:0.000637s ]
- SELECT `A`.`status`,`A`.`website`,`B`.* FROM `cms_company` `A` LEFT JOIN `cms_information` `B` ON `A`.`id`=`B`.`company_id` WHERE ( `A`.`website` LIKE '%www.lagxw.com%' ) AND `A`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000352s ]
- SHOW FULL COLUMNS FROM `cms_column` [ RunTime:0.000651s ]
- SELECT * FROM `cms_column` WHERE ( `is_show` = 1 AND `pid` = 0 AND `company_id` = 5 ) AND `cms_column`.`delete_time` = '0' ORDER BY `sort` ASC [ RunTime:0.000234s ]
- SELECT * FROM `cms_column` WHERE ( `is_show` = 1 AND `pid` > 0 AND `company_id` = 5 ) AND `cms_column`.`delete_time` = '0' ORDER BY `sort` ASC [ RunTime:0.000252s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 0 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000234s ]
- SHOW FULL COLUMNS FROM `cms_system_article` [ RunTime:0.000699s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( `A`.`is_recommend` = '1' AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 6 [ RunTime:0.000402s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`view_count` DESC LIMIT 6 [ RunTime:0.000418s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 6 [ RunTime:0.000420s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 0 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000214s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 30 or B.column_twoid = 30 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000337s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 32 or B.column_twoid = 32 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000315s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 37 or B.column_twoid = 37 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000588s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 38 or B.column_twoid = 38 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000494s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 44 or B.column_twoid = 44 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000374s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 48 or B.column_twoid = 48 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000388s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 52 or B.column_twoid = 52 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000433s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 53 or B.column_twoid = 53 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 9 [ RunTime:0.000313s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 0 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000316s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 30 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000218s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 31 or B.column_twoid = 31 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000379s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 32 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000204s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 33 or B.column_twoid = 33 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000364s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 34 or B.column_twoid = 34 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000384s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 35 or B.column_twoid = 35 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000336s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 36 or B.column_twoid = 36 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000362s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 37 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000249s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 55 or B.column_twoid = 55 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000451s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 38 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000236s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 39 or B.column_twoid = 39 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000365s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 40 or B.column_twoid = 40 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000345s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 41 or B.column_twoid = 41 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000370s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 42 or B.column_twoid = 42 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000360s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 43 or B.column_twoid = 43 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000346s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 44 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000234s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 45 or B.column_twoid = 45 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000341s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 46 or B.column_twoid = 46 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000334s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 47 or B.column_twoid = 47 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000357s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 48 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000209s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 49 or B.column_twoid = 49 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000299s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 50 or B.column_twoid = 50 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000295s ]
- SELECT `A`.*,B.title as category_name1,C.title as category_name2,D.title as category_name3,E.title as column_name1,F.title as column_name2 FROM `cms_system_article` `A` LEFT JOIN `cms_system_article_category` `B` ON `A`.`category_oneid`=`B`.`id` LEFT JOIN `cms_system_article_category` `C` ON `A`.`category_twoid`=`C`.`id` LEFT JOIN `cms_system_article_category` `D` ON `A`.`category_threeid`=`D`.`id` LEFT JOIN `cms_column` `E` ON `B`.`column_oneid`=`E`.`id` LEFT JOIN `cms_column` `F` ON `B`.`column_twoid`=`F`.`id` WHERE ( ( B.column_oneid = 51 or B.column_twoid = 51 ) AND `A`.`company_id` = '5' AND `A`.`is_show` = '1' ) AND `A`.`delete_time` = '0' ORDER BY `A`.`publish_time` DESC LIMIT 1 [ RunTime:0.000353s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 52 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000191s ]
- SELECT `id`,`title` FROM `cms_column` WHERE ( `pid` = 53 AND `company_id` = 5 AND `is_show` = 1 ) AND `cms_column`.`delete_time` = '0' [ RunTime:0.000199s ]
0.110624s
京ICP备01020131128068号-1
Copyright 2016-2024 两岸关系网 版权所有All Rights Reserved.
