You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
205 lines
29 KiB
205 lines
29 KiB
[2023-05-26T11:03:43+08:00][sql] CONNECT:[ UseTime:0.155690s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T11:03:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.031484s ]
|
|
[2023-05-26T11:03:43+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`image`,`level` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `sort` ASC [ RunTime:0.029785s ]
|
|
[2023-05-26T11:03:43+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`image`,`level` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `sort` ASC [ RunTime:0.029688s ]
|
|
[2023-05-26T11:03:43+08:00][sql] SELECT `id`,`name`,`pid`,`image`,`level` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` ASC [ RunTime:0.030005s ]
|
|
[2023-05-26T11:03:43+08:00][sql] CONNECT:[ UseTime:0.137736s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T11:03:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_navigation` [ RunTime:0.054392s ]
|
|
[2023-05-26T11:03:43+08:00][sql] SELECT `name`,`status`,`page_path`,`selected_icon`,`un_selected_icon` FROM `ls_dev_navigation` WHERE `del` = 0 ORDER BY `id` DESC [ RunTime:0.052195s ]
|
|
[2023-05-26T11:03:43+08:00][sql] CONNECT:[ UseTime:0.138971s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T11:03:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_article` [ RunTime:0.056590s ]
|
|
[2023-05-26T11:03:43+08:00][sql] SELECT `id`,`title` FROM `ls_article` WHERE `del` = 0 AND `is_notice` = 1 AND `is_show` = 1 ORDER BY `create_time` DESC LIMIT 3 [ RunTime:0.054285s ]
|
|
[2023-05-26T11:03:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.057650s ]
|
|
[2023-05-26T11:03:43+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website' AND `name` = 'pc_logo' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.056266s ]
|
|
[2023-05-26T11:03:45+08:00][sql] CONNECT:[ UseTime:0.059570s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.041984s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT * FROM `ls_stat` WHERE `ip` = '127.0.0.1' AND `create_time` BETWEEN 1685030400 AND 1685116799 LIMIT 1 [ RunTime:0.039432s ]
|
|
[2023-05-26T11:03:45+08:00][sql] INSERT INTO `ls_stat` SET `ip` = '127.0.0.1' , `count` = 1 , `create_time` = 1685070224 [ RunTime:0.060595s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_article` [ RunTime:0.042053s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`title` FROM `ls_article` WHERE `del` = 0 AND `is_show` = 1 AND `is_notice` = 1 ORDER BY `create_time` DESC,`id` DESC LIMIT 3 [ RunTime:0.039574s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.042279s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT id,name,image,min_price,market_price,sales_actual,create_time,sales_virtual,(sales_actual + sales_virtual) as sales_total FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 ORDER BY `sales_total` DESC,`sales_actual` DESC,`sort_weight` ASC,`create_time` DESC,`id` DESC LIMIT 9 [ RunTime:0.040382s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT g.id,g.name,g.image,g.min_price,g.market_price,g.sales_actual,g.create_time,g.sales_virtual,(sales_actual + sales_virtual) as sales_total FROM `ls_goods` `g` INNER JOIN `ls_shop` `s` ON `s`.`id`=`g`.`shop_id` WHERE `g`.`del` = 0 AND `g`.`status` = 1 AND `g`.`audit_status` = 1 AND `s`.`del` = 0 AND `s`.`is_freeze` = 0 AND `s`.`is_run` = 1 ORDER BY `g`.`create_time` DESC,`sales_actual` DESC,`sort_weight` ASC,`g`.`id` DESC LIMIT 3 [ RunTime:0.040933s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.041995s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`name`,`logo`,`background`,`expire_time`,`cover`,`banner`,`visited_num` FROM `ls_shop` WHERE `del` = 0 AND `is_recommend` = 1 AND `is_freeze` = 0 AND `is_run` = 1 ORDER BY `weight` ASC,`id` DESC [ RunTime:0.039753s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`name`,`logo`,`background`,`expire_time`,`cover`,`banner`,`visited_num` FROM `ls_shop` WHERE `del` = 0 AND `is_recommend` = 1 AND `is_freeze` = 0 AND `is_run` = 1 ORDER BY `weight` ASC,`id` DESC [ RunTime:0.039878s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_time` [ RunTime:0.053447s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`start_time`,`end_time` FROM `ls_seckill_time` WHERE `del` = 0 ORDER BY `start_time` ASC [ RunTime:0.040214s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_activity_area` [ RunTime:0.045605s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`name`,synopsis as title,`image` FROM `ls_activity_area` WHERE `del` = 0 AND `status` = 1 [ RunTime:0.039658s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.042350s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`content`,`image`,`user_id` FROM `ls_community_article` WHERE `del` = 0 AND `status` = 1 ORDER BY `like` DESC,`id` DESC LIMIT 10 [ RunTime:0.039907s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.043224s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 2 [ RunTime:0.039623s ]
|
|
[2023-05-26T11:03:45+08:00][sql] CONNECT:[ UseTime:0.066287s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.046263s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `a`.* FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 23 AND `ap`.`terminal` = '2' AND `a`.`status` = 1 AND `a`.`del` = 0 AND `ap`.`status` = 1 AND `ap`.`del` = 0 ORDER BY `a`.`sort` ASC,`a`.`id` DESC [ RunTime:0.044280s ]
|
|
[2023-05-26T11:03:45+08:00][sql] CONNECT:[ UseTime:0.063479s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T11:03:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_column` [ RunTime:0.043917s ]
|
|
[2023-05-26T11:03:45+08:00][sql] SELECT `id`,`name`,`remark` FROM `ls_goods_column` WHERE `del` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.042473s ]
|
|
[2023-05-26T11:03:46+08:00][sql] CONNECT:[ UseTime:0.064558s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T11:03:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.048216s ]
|
|
[2023-05-26T11:03:46+08:00][sql] SELECT `id`,`name` FROM `ls_shop` WHERE `del` = 1 OR `is_freeze` = 1 OR `is_run` = 0 [ RunTime:0.042187s ]
|
|
[2023-05-26T11:03:46+08:00][sql] SELECT `id`,`name` FROM `ls_shop` WHERE `expire_time` <> 0 AND `expire_time` <= 1685070225 [ RunTime:0.042805s ]
|
|
[2023-05-26T11:03:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.044835s ]
|
|
[2023-05-26T11:03:46+08:00][sql] SELECT id,name,image,market_price,min_price,sales_actual,column_ids,sort_weight,sales_virtual,(sales_actual + sales_virtual) as sales_total FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 AND FIND_IN_SET('1', `column_ids`) ORDER BY `sort_weight` ASC,`sales_actual` DESC,`create_time` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.042480s ]
|
|
[2023-05-26T11:03:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 AND FIND_IN_SET('1', `column_ids`) [ RunTime:0.041726s ]
|
|
[2023-05-26T14:27:07+08:00][sql] CONNECT:[ UseTime:0.065447s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.049131s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Null]' LIMIT 1 [ RunTime:0.045728s ]
|
|
[2023-05-26T14:27:07+08:00][sql] CONNECT:[ UseTime:0.043822s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.030825s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Null]' LIMIT 1 [ RunTime:0.040062s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_live_room` [ RunTime:0.031251s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_live_room` WHERE `del` = 0 [ RunTime:0.028760s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT * FROM `ls_live_room` WHERE `del` = 0 AND `wx_room_id` > 0 ORDER BY `live_status` ASC,`sort` ASC,`id` DESC [ RunTime:0.029553s ]
|
|
[2023-05-26T14:27:07+08:00][sql] CONNECT:[ UseTime:0.089479s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.063544s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Null]' LIMIT 1 [ RunTime:0.063601s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_navigation` [ RunTime:0.060448s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT `name`,`status`,`page_path`,`selected_icon`,`un_selected_icon` FROM `ls_dev_navigation` WHERE `del` = 0 ORDER BY `id` DESC [ RunTime:0.059027s ]
|
|
[2023-05-26T14:27:07+08:00][sql] CONNECT:[ UseTime:0.089061s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.055294s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Null]' LIMIT 1 [ RunTime:0.096526s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.073802s ]
|
|
[2023-05-26T14:27:07+08:00][sql] SELECT `id`,`name`,`image`,`bg_image` FROM `ls_goods_category` WHERE `del` = 0 AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC [ RunTime:0.097348s ]
|
|
[2023-05-26T14:27:08+08:00][sql] CONNECT:[ UseTime:0.050802s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.034928s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.033245s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_menu_decorate` [ RunTime:0.034909s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT `name`,`image`,`link_type`,`link_address` FROM `ls_menu_decorate` WHERE `decorate_type` = 1 AND `del` = 0 AND `is_show` = 1 ORDER BY `sort` DESC [ RunTime:0.033444s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution` [ RunTime:0.039421s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT * FROM `ls_distribution` WHERE ( `user_id` IS NULL ) AND `ls_distribution`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.039960s ]
|
|
[2023-05-26T14:27:08+08:00][sql] CONNECT:[ UseTime:0.073116s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.058248s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Null]' LIMIT 1 [ RunTime:0.077218s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.046764s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT `a`.* FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 7 AND `ap`.`terminal` = '1' AND `a`.`status` = 1 AND `a`.`del` = 0 AND `ap`.`status` = 1 AND `ap`.`del` = 0 ORDER BY `a`.`sort` ASC,`a`.`id` DESC [ RunTime:0.046626s ]
|
|
[2023-05-26T14:27:08+08:00][sql] CONNECT:[ UseTime:0.062982s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.030570s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Null]' LIMIT 1 [ RunTime:0.030388s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.037403s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT `a`.* FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 8 AND `ap`.`terminal` = '1' AND `a`.`status` = 1 AND `a`.`del` = 0 AND `ap`.`status` = 1 AND `ap`.`del` = 0 ORDER BY `a`.`sort` ASC,`a`.`id` DESC [ RunTime:0.032838s ]
|
|
[2023-05-26T14:27:08+08:00][sql] CONNECT:[ UseTime:0.083684s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.058076s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Null]' LIMIT 1 [ RunTime:0.054099s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.055550s ]
|
|
[2023-05-26T14:27:08+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'footprint' AND `shop_id` = 0 [ RunTime:0.051895s ]
|
|
[2023-05-26T14:27:09+08:00][sql] CONNECT:[ UseTime:0.085608s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.046438s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.033691s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.035933s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT * FROM `ls_stat` WHERE `ip` = '127.0.0.1' AND `create_time` BETWEEN 1685030400 AND 1685116799 LIMIT 1 [ RunTime:0.033683s ]
|
|
[2023-05-26T14:27:09+08:00][sql] UPDATE `ls_stat` SET `count` = `count` + 1 WHERE `id` = 25 [ RunTime:0.036579s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_article` [ RunTime:0.040896s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`title` FROM `ls_article` WHERE `del` = 0 AND `is_show` = 1 AND `is_notice` = 1 ORDER BY `create_time` DESC,`id` DESC LIMIT 3 [ RunTime:0.036325s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.042816s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT id,name,image,min_price,market_price,sales_actual,create_time,sales_virtual,(sales_actual + sales_virtual) as sales_total FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 ORDER BY `sales_total` DESC,`sales_actual` DESC,`sort_weight` ASC,`create_time` DESC,`id` DESC LIMIT 9 [ RunTime:0.038262s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT g.id,g.name,g.image,g.min_price,g.market_price,g.sales_actual,g.create_time,g.sales_virtual,(sales_actual + sales_virtual) as sales_total FROM `ls_goods` `g` INNER JOIN `ls_shop` `s` ON `s`.`id`=`g`.`shop_id` WHERE `g`.`del` = 0 AND `g`.`status` = 1 AND `g`.`audit_status` = 1 AND `s`.`del` = 0 AND `s`.`is_freeze` = 0 AND `s`.`is_run` = 1 ORDER BY `g`.`create_time` DESC,`sales_actual` DESC,`sort_weight` ASC,`g`.`id` DESC LIMIT 3 [ RunTime:0.034173s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.043753s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`name`,`logo`,`background`,`expire_time`,`cover`,`banner`,`visited_num` FROM `ls_shop` WHERE `del` = 0 AND `is_recommend` = 1 AND `is_freeze` = 0 AND `is_run` = 1 ORDER BY `weight` ASC,`id` DESC [ RunTime:0.034102s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`name`,`logo`,`background`,`expire_time`,`cover`,`banner`,`visited_num` FROM `ls_shop` WHERE `del` = 0 AND `is_recommend` = 1 AND `is_freeze` = 0 AND `is_run` = 1 ORDER BY `weight` ASC,`id` DESC [ RunTime:0.034199s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_time` [ RunTime:0.036769s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`start_time`,`end_time` FROM `ls_seckill_time` WHERE `del` = 0 ORDER BY `start_time` ASC [ RunTime:0.038775s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_activity_area` [ RunTime:0.038392s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`name`,synopsis as title,`image` FROM `ls_activity_area` WHERE `del` = 0 AND `status` = 1 [ RunTime:0.043033s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.051373s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`content`,`image`,`user_id` FROM `ls_community_article` WHERE `del` = 0 AND `status` = 1 ORDER BY `like` DESC,`id` DESC LIMIT 10 [ RunTime:0.043067s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.043683s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 2 [ RunTime:0.034236s ]
|
|
[2023-05-26T14:27:09+08:00][sql] CONNECT:[ UseTime:0.137561s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.076813s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.061253s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.070619s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'mnp' AND `name` = 'app_id' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.061547s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'mnp' AND `name` = 'secret' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.067134s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'mnp' AND `name` = 'mch_id' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.097581s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'mnp' AND `name` = 'key' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.065591s ]
|
|
[2023-05-26T14:27:09+08:00][sql] CONNECT:[ UseTime:0.044121s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.032666s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.037489s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_live_room` [ RunTime:0.031469s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_live_room` WHERE `del` = 0 [ RunTime:0.030399s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT * FROM `ls_live_room` WHERE `del` = 0 AND `wx_room_id` > 0 ORDER BY `live_status` ASC,`sort` ASC,`id` DESC [ RunTime:0.038317s ]
|
|
[2023-05-26T14:27:09+08:00][sql] CONNECT:[ UseTime:0.053898s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.039734s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.039337s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_column` [ RunTime:0.037701s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`name`,`remark` FROM `ls_goods_column` WHERE `del` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.038065s ]
|
|
[2023-05-26T14:27:09+08:00][sql] CONNECT:[ UseTime:0.043588s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.033073s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.031727s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.032152s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`name` FROM `ls_shop` WHERE `del` = 1 OR `is_freeze` = 1 OR `is_run` = 0 [ RunTime:0.029076s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT `id`,`name` FROM `ls_shop` WHERE `expire_time` <> 0 AND `expire_time` <= 1685082429 [ RunTime:0.029335s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.031438s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT id,name,image,market_price,min_price,sales_actual,column_ids,sort_weight,sales_virtual,(sales_actual + sales_virtual) as sales_total FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 AND FIND_IN_SET('1', `column_ids`) ORDER BY `sort_weight` ASC,`sales_actual` DESC,`create_time` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.029768s ]
|
|
[2023-05-26T14:27:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 AND FIND_IN_SET('1', `column_ids`) [ RunTime:0.029091s ]
|
|
[2023-05-26T14:27:36+08:00][sql] CONNECT:[ UseTime:0.068902s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.051537s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.045952s ]
|
|
[2023-05-26T14:27:36+08:00][sql] CONNECT:[ UseTime:0.044470s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.039649s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.029188s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_menu_decorate` [ RunTime:0.031724s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SELECT `name`,`image`,`link_type`,`link_address` FROM `ls_menu_decorate` WHERE `decorate_type` = 2 AND `del` = 0 AND `is_show` = 1 ORDER BY `sort` DESC [ RunTime:0.029590s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution` [ RunTime:0.033159s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SELECT * FROM `ls_distribution` WHERE ( `user_id` IS NULL ) AND `ls_distribution`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.029399s ]
|
|
[2023-05-26T14:27:36+08:00][sql] CONNECT:[ UseTime:0.060559s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.039061s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.037288s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_column` [ RunTime:0.039019s ]
|
|
[2023-05-26T14:27:36+08:00][sql] SELECT `id`,`name`,`remark` FROM `ls_goods_column` WHERE `del` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.037167s ]
|
|
[2023-05-26T14:27:37+08:00][sql] CONNECT:[ UseTime:0.078214s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.052724s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.051013s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.052411s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'mnp' AND `name` = 'mch_id' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.050351s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'mnp' AND `name` = 'key' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.050106s ]
|
|
[2023-05-26T14:27:37+08:00][sql] CONNECT:[ UseTime:0.085468s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:27:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.070698s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.056219s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.055216s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT `id`,`name` FROM `ls_shop` WHERE `del` = 1 OR `is_freeze` = 1 OR `is_run` = 0 [ RunTime:0.053062s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT `id`,`name` FROM `ls_shop` WHERE `expire_time` <> 0 AND `expire_time` <= 1685082457 [ RunTime:0.053247s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.056423s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT id,name,image,market_price,min_price,sales_actual,column_ids,sort_weight,sales_virtual,(sales_actual + sales_virtual) as sales_total FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 AND FIND_IN_SET('1', `column_ids`) ORDER BY `sort_weight` ASC,`sales_actual` DESC,`create_time` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.053982s ]
|
|
[2023-05-26T14:27:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `audit_status` = 1 AND FIND_IN_SET('1', `column_ids`) [ RunTime:0.053055s ]
|
|
[2023-05-26T14:28:10+08:00][sql] CONNECT:[ UseTime:0.065220s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.052396s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.043520s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.045109s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT `a`.* FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 30 AND `ap`.`terminal` = '1' AND `a`.`status` = 1 AND `a`.`del` = 0 AND `ap`.`status` = 1 AND `ap`.`del` = 0 ORDER BY `a`.`sort` ASC,`a`.`id` DESC [ RunTime:0.049611s ]
|
|
[2023-05-26T14:28:10+08:00][sql] CONNECT:[ UseTime:0.066840s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.054976s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.045877s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.044620s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT `id`,`name` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.042572s ]
|
|
[2023-05-26T14:28:10+08:00][sql] CONNECT:[ UseTime:0.067694s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.047275s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.045218s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.046972s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT `id`,`name` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.045241s ]
|
|
[2023-05-26T14:28:10+08:00][sql] CONNECT:[ UseTime:0.068229s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.049011s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.046211s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.048248s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` `a` INNER JOIN `ls_resource_category` `c` ON `c`.`id`=`a`.`cid` WHERE `a`.`del` = 0 AND `a`.`is_show` = 1 AND `c`.`del` = 0 AND `c`.`is_show` = 1 [ RunTime:0.046599s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`image`,`a`.`visit`,`a`.`likes`,`a`.`intro`,`a`.`content`,`a`.`create_time`,`a`.`price`,`a`.`type`,`a`.`province_id`,`a`.`city_id`,`a`.`district_id` FROM `ls_resource` `a` INNER JOIN `ls_resource_category` `c` ON `c`.`id`=`a`.`cid` WHERE `a`.`del` = 0 AND `a`.`is_show` = 1 AND `c`.`del` = 0 AND `c`.`is_show` = 1 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.047256s ]
|
|
[2023-05-26T14:28:10+08:00][sql] CONNECT:[ UseTime:0.080243s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.054366s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.051033s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.052165s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT `id`,`name` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.052721s ]
|
|
[2023-05-26T14:28:10+08:00][sql] CONNECT:[ UseTime:0.082671s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.065223s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.055241s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.055605s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` `a` INNER JOIN `ls_resource_category` `c` ON `c`.`id`=`a`.`cid` WHERE `a`.`del` = 0 AND `a`.`is_show` = 1 AND `c`.`del` = 0 AND `c`.`is_show` = 1 [ RunTime:0.053853s ]
|
|
[2023-05-26T14:28:10+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`image`,`a`.`visit`,`a`.`likes`,`a`.`intro`,`a`.`content`,`a`.`create_time`,`a`.`price`,`a`.`type`,`a`.`province_id`,`a`.`city_id`,`a`.`district_id` FROM `ls_resource` `a` INNER JOIN `ls_resource_category` `c` ON `c`.`id`=`a`.`cid` WHERE `a`.`del` = 0 AND `a`.`is_show` = 1 AND `c`.`del` = 0 AND `c`.`is_show` = 1 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.057866s ]
|
|
[2023-05-26T14:28:11+08:00][sql] CONNECT:[ UseTime:0.078890s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-26T14:28:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.054850s ]
|
|
[2023-05-26T14:28:11+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '[object Undefined]' LIMIT 1 [ RunTime:0.052971s ]
|
|
[2023-05-26T14:28:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.054880s ]
|
|
[2023-05-26T14:28:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` `a` INNER JOIN `ls_resource_category` `c` ON `c`.`id`=`a`.`cid` WHERE `a`.`del` = 0 AND `a`.`is_show` = 1 AND `c`.`del` = 0 AND `c`.`is_show` = 1 [ RunTime:0.052436s ]
|
|
[2023-05-26T14:28:11+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`image`,`a`.`visit`,`a`.`likes`,`a`.`intro`,`a`.`content`,`a`.`create_time`,`a`.`price`,`a`.`type`,`a`.`province_id`,`a`.`city_id`,`a`.`district_id` FROM `ls_resource` `a` INNER JOIN `ls_resource_category` `c` ON `c`.`id`=`a`.`cid` WHERE `a`.`del` = 0 AND `a`.`is_show` = 1 AND `c`.`del` = 0 AND `c`.`is_show` = 1 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.054667s ]
|
|
|