基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-09-21 08:54:45 HTTP/1.1 GET : http://www.lagxw.com/index.php?a=shows&catid=5&id=9577
- 运行时间 : 0.107805s [ 吞吐率:9.28req/s ] 内存消耗:6,030.73kb 文件加载:154
- 查询信息 : 47 queries
- 缓存信息 : 0 reads,0 writes
- CONNECT:[ UseTime:0.000358s ] mysql:host=127.0.0.1;port=3306;dbname=lagxnew;charset=utf8
- SHOW FULL COLUMNS FROM `cms_operate_log` [ RunTime:0.000847s ]
- INSERT INTO `cms_operate_log` SET `user_id` = 1 , `user_name` = '系统' , `url` = 'http://www.lagxw.com/index.php?a=shows&catid=5&id=9577' , `method` = 'GET' , `ip` = '3.138.123.106' , `content` = '{\"a\":\"shows\",\"catid\":\"5\",\"id\":\"9577\"}' , `controller` = 'Index' , `action` = 'index' , `param` = '9577' , `domain` = 'www' , `create_time` = 1726880085 [ RunTime:0.000355s ]
- SHOW FULL COLUMNS FROM `cms_company` [ RunTime:0.000704s ]
- 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.000331s ]
- SHOW FULL COLUMNS FROM `cms_column` [ RunTime:0.000672s ]
- 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.000255s ]
- 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.000258s ]
- 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.000239s ]
- SHOW FULL COLUMNS FROM `cms_system_article` [ RunTime:0.000762s ]
- 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.000375s ]
- 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.000372s ]
- 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.000399s ]
- 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.000256s ]
- 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.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 = 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.000377s ]
- 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.000601s ]
- 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.000449s ]
- 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.000434s ]
- 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.000359s ]
- 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.000440s ]
- 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.000326s ]
- 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.000348s ]
- 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.000245s ]
- 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.000397s ]
- 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.000227s ]
- 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.000346s ]
- 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.000300s ]
- 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.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 = 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.000355s ]
- 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.000219s ]
- 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.000404s ]
- 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.000261s ]
- 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.000328s ]
- 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.000324s ]
- 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.000335s ]
- 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.000339s ]
- 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.000319s ]
- 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.000231s ]
- 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.000305s ]
- 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.000327s ]
- 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.000354s ]
- 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.000222s ]
- 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.000304s ]
- 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.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 = 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.000355s ]
- 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.000214s ]
- 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.000247s ]
0.109736s