[ DB ] CONNECT:[ UseTime:0.005947s ] mysql:dbname=zystc_com;host=localhost;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wejoy_ad` [ RunTime:0.000715s ]
[ SQL ] SELECT `id` FROM `wejoy_ad` WHERE `is_show` = 1 AND `id` = 2 LIMIT 1 [ RunTime:0.000451s ]
[ SQL ] SHOW COLUMNS FROM `wejoy_ad_list` [ RunTime:0.000715s ]
[ 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.000422s ]
[ SQL ] SHOW COLUMNS FROM `wejoy_category` [ RunTime:0.004104s ]
[ SQL ] SELECT `id` FROM `wejoy_category` WHERE ( `guid` = 'shouye' ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000922s ]
[ 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.002656s ]
[ SQL ] SELECT `id` FROM `wejoy_category` WHERE ( `guid` = 'lianxiwomen' ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.010457s ]
[ 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.000362s ]
[ 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.000219s ]
[ 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.000222s ]
[ SQL ] SHOW COLUMNS FROM `wejoy_article` [ RunTime:0.000801s ]
[ SQL ] UPDATE `wejoy_article` SET `views`=views+1 WHERE ( `id` = 212 ) AND `wejoy_article`.`delete_time` IS NULL [ RunTime:0.006645s ]
[ SQL ] SELECT * FROM `wejoy_article` WHERE ( `id` = 212 ) AND `wejoy_article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1636084876 AND `id` <> 212 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.000744s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1636084876 AND `id` <> 212 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.003684s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1636084876 AND `id` <> 212 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.000676s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1636084876 AND `id` <> 212 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.000674s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1636084876 AND `id` <> 212 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.001364s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` >= 1 AND `update_time` >= 1636084876 AND `id` <> 212 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.002130s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1636084876 AND `id` <> 212 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.004401s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1636084876 AND `id` <> 212 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.000669s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1636084876 AND `id` <> 212 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.000689s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1636084876 AND `id` <> 212 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.000640s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1636084876 AND `id` <> 212 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.001580s ]
[ SQL ] SELECT `id`,`title` FROM `wejoy_article` WHERE ( `order_id` <= 1 AND `update_time` <= 1636084876 AND `id` <> 212 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.002378s ]
[ SQL ] SELECT `id` FROM `wejoy_category` WHERE ( `guid` = 'zhaoshangxinwen' ) AND `wejoy_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000443s ]
[ 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.004619s ]
[ 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.000932s ]
鄂公网安备 42010202002330号