[2023-04-25T10:51:04+08:00][sql] CONNECT:[ UseTime:0.019539s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.003467s ] [2023-04-25T10:51:04+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000351s ] [2023-04-25T10:51:04+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000207s ] [2023-04-25T10:51:04+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1682391064 WHERE `account` = 'admin' [ RunTime:0.001093s ] [2023-04-25T10:51:06+08:00][sql] CONNECT:[ UseTime:0.020783s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002655s ] [2023-04-25T10:51:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1682391066 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.000173s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.002514s ] [2023-04-25T10:51:06+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000466s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.002535s ] [2023-04-25T10:51:06+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000231s ] [2023-04-25T10:51:06+08:00][sql] CONNECT:[ UseTime:0.000799s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001697s ] [2023-04-25T10:51:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1682391066 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000138s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.002483s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000161s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1682265600 AND 1682351999 [ RunTime:0.000113s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1682352000 AND 1682438399 [ RunTime:0.000081s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000076s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1682265600 AND 1682351999 [ RunTime:0.000074s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1682352000 AND 1682438399 [ RunTime:0.000072s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.001476s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.000212s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682265600 AND 1682351999 [ RunTime:0.000105s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682352000 AND 1682438399 [ RunTime:0.000079s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.001445s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` GROUP BY `ip` ) `_group_count_` [ RunTime:0.000270s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682265600 AND 1682351999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000348s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682352000 AND 1682438399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000148s ] [2023-04-25T10:51:06+08:00][sql] CONNECT:[ UseTime:0.011943s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002465s ] [2023-04-25T10:51:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1682391066 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000159s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.002309s ] [2023-04-25T10:51:06+08:00][sql] SELECT `id`,`logo`,`name`,`visited_num` FROM `ls_shop` WHERE `visited_num` > 0 ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.000144s ] [2023-04-25T10:51:06+08:00][sql] CONNECT:[ UseTime:0.014674s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002409s ] [2023-04-25T10:51:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1682391066 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000187s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.002272s ] [2023-04-25T10:51:06+08:00][sql] SELECT `o`.`shop_id`,sum(o.order_amount) as order_amount,`s`.`logo`,`s`.`name` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` WHERE `order_amount` > 0 AND `pay_status` > 0 GROUP BY `shop_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.001484s ] [2023-04-25T10:51:06+08:00][sql] CONNECT:[ UseTime:0.013483s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002451s ] [2023-04-25T10:51:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1682391066 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000152s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.002044s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681056000 AND 1681142399 AND `pay_status` > 0 [ RunTime:0.000187s ] [2023-04-25T10:51:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.002362s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681056000 AND 1681142399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000464s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681142400 AND 1681228799 AND `pay_status` > 0 [ RunTime:0.000243s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681142400 AND 1681228799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000239s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681228800 AND 1681315199 AND `pay_status` > 0 [ RunTime:0.000127s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681228800 AND 1681315199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000160s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681315200 AND 1681401599 AND `pay_status` > 0 [ RunTime:0.000095s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681315200 AND 1681401599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000138s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681401600 AND 1681487999 AND `pay_status` > 0 [ RunTime:0.000087s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681401600 AND 1681487999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000097s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681488000 AND 1681574399 AND `pay_status` > 0 [ RunTime:0.000081s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681488000 AND 1681574399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000105s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681574400 AND 1681660799 AND `pay_status` > 0 [ RunTime:0.000155s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681574400 AND 1681660799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000174s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681660800 AND 1681747199 AND `pay_status` > 0 [ RunTime:0.000109s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681660800 AND 1681747199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000241s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681747200 AND 1681833599 AND `pay_status` > 0 [ RunTime:0.000125s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681747200 AND 1681833599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000165s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681833600 AND 1681919999 AND `pay_status` > 0 [ RunTime:0.000158s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681833600 AND 1681919999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000159s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681920000 AND 1682006399 AND `pay_status` > 0 [ RunTime:0.000107s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681920000 AND 1682006399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000189s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682006400 AND 1682092799 AND `pay_status` > 0 [ RunTime:0.000152s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682006400 AND 1682092799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000168s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682092800 AND 1682179199 AND `pay_status` > 0 [ RunTime:0.000097s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682092800 AND 1682179199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000106s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682179200 AND 1682265599 AND `pay_status` > 0 [ RunTime:0.000082s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682179200 AND 1682265599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000094s ] [2023-04-25T10:51:06+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682265600 AND 1682351999 AND `pay_status` > 0 [ RunTime:0.000079s ] [2023-04-25T10:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682265600 AND 1682351999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000125s ] [2023-04-25T10:51:11+08:00][sql] CONNECT:[ UseTime:0.016437s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001796s ] [2023-04-25T10:51:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1682391071 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000195s ] [2023-04-25T10:51:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.002517s ] [2023-04-25T10:51:11+08:00][sql] SELECT `id`,`name`,`image`,`sort`,`del`,`create_time`,`update_time` FROM `ls_shop_category` WHERE `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000193s ] [2023-04-25T10:51:11+08:00][sql] CONNECT:[ UseTime:0.022516s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-04-25T10:51:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001562s ] [2023-04-25T10:51:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1682391071 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000124s ] [2023-04-25T10:51:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.001479s ] [2023-04-25T10:51:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) [ RunTime:0.000154s ] [2023-04-25T10:51:11+08:00][sql] SELECT `id`,`cid`,`type`,`name`,`nickname`,`mobile`,`wallet`,`logo`,`background`,`license`,`keywords`,`intro`,`weight`,`trade_service_fee`,`weekdays`,`service_mobile`,`province_id`,`city_id`,`district_id`,`address`,`longitude`,`latitude`,`refund_address`,`run_start_time`,`run_end_time`,`is_run`,`is_freeze`,`is_product_audit`,`is_recommend`,`del`,`expire_time`,`create_time`,`update_time`,`score`,`star`,`visited_num`,`is_distribution`,`is_pay`,`cover`,`banner`,`business_license`,`other_qualifications`,`open_invoice`,`spec_invoice`,`delivery_type` FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) ORDER BY `id` DESC,`weight` ASC LIMIT 0,10 [ RunTime:0.000221s ] [2023-04-25T10:51:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.001342s ] [2023-04-25T10:51:11+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000123s ] [2023-04-25T10:51:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.002106s ] [2023-04-25T10:51:11+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `shop_id` IN (2,1) [ RunTime:0.000505s ]