[ DB ] CONNECT:[ UseTime:0.000270s ] mysql:dbname=zystc_com;host=localhost;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wejoy_ad` [ RunTime:0.000754s ]
[ SQL ] SELECT `id` FROM `wejoy_ad` WHERE `is_show` = 1 AND `id` = 2 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SHOW COLUMNS FROM `wejoy_ad_list` [ RunTime:0.000571s ]
[ SQL ] SELECT `ad_name`,`ad_img`,`ad_link`,`ad_target` FROM `wejoy_ad_list` WHERE ( `is_show` > 0 AND `is_show` = 1 ) AND `ad_id` = 2 ORDER BY order_id desc, id desc [ RunTime:0.000257s ]
[ SQL ] SHOW COLUMNS FROM `wejoy_category` [ RunTime:0.000751s ]
[ SQL ] SELECT `id` FROM `wejoy_category` WHERE ( `guid` = 'shouye' ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT * FROM `wejoy_category` WHERE ( `parent_id` = 2 AND `is_show` = 1 ) AND `wejoy_category`.`delete_time` IS NULL ORDER BY `order_id` desc [ RunTime:0.000299s ]
[ SQL ] SELECT `id` FROM `wejoy_category` WHERE ( `guid` = 'lianxiwomen' ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT * FROM `wejoy_category` WHERE ( `parent_id` = 8 AND `is_show` = 1 ) AND `wejoy_category`.`delete_time` IS NULL ORDER BY `order_id` desc [ RunTime:0.000271s ]
[ SQL ] SELECT `cate_name` FROM `wejoy_category` WHERE ( `guid` = 'zhaoshangxinwen' AND `is_show` = 1 ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT `cate_name` FROM `wejoy_category` WHERE ( `guid` = 'zhaoshangzhengce' AND `is_show` = 1 ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SHOW COLUMNS FROM `wejoy_article` [ RunTime:0.000773s ]
[ SQL ] UPDATE `wejoy_article` SET `views`=views+1 WHERE ( `id` = 217 ) AND `wejoy_article`.`delete_time` IS NULL [ RunTime:0.002608s ]
[ SQL ] SELECT * FROM `wejoy_article` WHERE ( `id` = 217 ) AND `wejoy_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` asc,`update_time` asc,`id` asc LIMIT 1 [ RunTime:0.000533s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` asc,`update_time` asc,`id` asc LIMIT 1 [ RunTime:0.000523s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` asc,`update_time` asc,`id` asc LIMIT 1 [ RunTime:0.000464s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` asc,`update_time` asc,`id` asc LIMIT 1 [ RunTime:0.000483s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` asc,`update_time` asc,`id` asc LIMIT 1 [ RunTime:0.000518s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` asc,`update_time` asc,`id` asc LIMIT 1 [ RunTime:0.000470s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` desc,`update_time` desc,`id` desc LIMIT 1 [ RunTime:0.000446s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` desc,`update_time` desc,`id` desc LIMIT 1 [ RunTime:0.000447s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` desc,`update_time` desc,`id` desc LIMIT 1 [ RunTime:0.000484s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` desc,`update_time` desc,`id` desc LIMIT 1 [ RunTime:0.000469s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` desc,`update_time` desc,`id` desc LIMIT 1 [ RunTime:0.000554s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1637308709 AND `id` <> 217 AND `cate_id` = 15 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `order_id` desc,`update_time` desc,`id` desc LIMIT 1 [ RunTime:0.000470s ]
[ SQL ] SELECT `id` FROM `wejoy_category` WHERE ( `guid` = 'zhaoshangxinwen' ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `wejoy_article` WHERE ( ( `cate_id` = 5 OR `parent_path` LIKE '%,5,%' ) AND `is_show` = 1 ) AND `wejoy_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `wejoy_article` WHERE ( ( `cate_id` = 5 OR `parent_path` LIKE '%,5,%' ) AND `is_show` = 1 ) AND `wejoy_article`.`delete_time` IS NULL ORDER BY `views` desc,`order_id` desc,`update_time` desc,`id` desc LIMIT 0,9 [ RunTime:0.000640s ]
鄂公网安备 42010202002330号