[2023-05-12T10:12:03+08:00][sql] CONNECT:[ UseTime:0.001093s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.003394s ] [2023-05-12T10:12:03+08:00][sql] SELECT `a`.* FROM `ls_shop_admin` `a` INNER JOIN `ls_shop` `s` ON `s`.`id`=`a`.`shop_id` WHERE `a`.`account` = '777777' AND `a`.`del` = 0 LIMIT 1 [ RunTime:0.000881s ] [2023-05-12T10:12:03+08:00][sql] SELECT `a`.`id`,`a`.`account`,`a`.`name`,`role_id`,`shop_id`,`s`.`name` AS `shop_name` FROM `ls_shop_admin` `a` INNER JOIN `ls_shop` `s` ON `s`.`id`=`a`.`shop_id` WHERE `a`.`account` = '777777' AND `a`.`del` = 0 LIMIT 1 [ RunTime:0.000289s ] [2023-05-12T10:12:03+08:00][sql] UPDATE `ls_shop_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683857523 WHERE `account` = '777777' [ RunTime:0.000686s ] [2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.001151s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.011451s ] [2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000244s ] [2023-05-12T10:12:05+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000500s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.009685s ] [2023-05-12T10:12:05+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000263s ] [2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.001168s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003338s ] [2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000217s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003156s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 [ RunTime:0.000284s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000210s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000177s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 [ RunTime:0.000183s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000169s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000158s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.010097s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000359s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000247s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000215s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.013565s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 2 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.000359s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.000252s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.000212s ] [2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.001047s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003090s ] [2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000271s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003566s ] [2023-05-12T10:12:05+08:00][sql] SELECT sum(o.order_amount) as order_amount,`og`.`goods_id` FROM `ls_order` `o` INNER JOIN `ls_order_goods` `og` ON `og`.`order_id`=`o`.`id` WHERE `o`.`shop_id` = 2 AND `o`.`pay_status` > 0 GROUP BY `og`.`goods_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.009276s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.000812s ] [2023-05-12T10:12:05+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000209s ] [2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.022271s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003316s ] [2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000287s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003398s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.000263s ] [2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.002951s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000272s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.000191s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000214s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.000182s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000204s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.000173s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000203s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.000174s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000193s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.000171s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000287s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.000239s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000257s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.000188s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000252s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.000187s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000220s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.000183s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000251s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.000213s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000197s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.000172s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000255s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.000176s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000188s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.000161s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000183s ] [2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.000159s ] [2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000181s ] [2023-05-12T10:12:06+08:00][sql] CONNECT:[ UseTime:0.001270s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.002941s ] [2023-05-12T10:12:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000321s ] [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.003118s ] [2023-05-12T10:12:06+08:00][sql] SELECT goods_id,count(DISTINCT user_id) as visited_num FROM `ls_goods_click` WHERE `shop_id` = 2 GROUP BY `goods_id` ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.000530s ] [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003849s ] [2023-05-12T10:12:06+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000270s ] [2023-05-12T10:12:06+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000209s ] [2023-05-12T10:12:06+08:00][sql] CONNECT:[ UseTime:0.001121s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003121s ] [2023-05-12T10:12:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ] [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.003346s ] [2023-05-12T10:12:06+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.000264s ] [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.002893s ] [2023-05-12T10:12:06+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` ASC [ RunTime:0.000225s ] [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003498s ] [2023-05-12T10:12:06+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 2 [ RunTime:0.000538s ] [2023-05-12T10:12:06+08:00][sql] CONNECT:[ UseTime:0.001121s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003153s ] [2023-05-12T10:12:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000204s ] [2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003278s ] [2023-05-12T10:12:06+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 2 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.000512s ] [2023-05-12T10:12:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 2 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) [ RunTime:0.000248s ] [2023-05-12T10:12:10+08:00][sql] CONNECT:[ UseTime:0.001141s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003320s ] [2023-05-12T10:12:10+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000248s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.003080s ] [2023-05-12T10:12:10+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.000251s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.002832s ] [2023-05-12T10:12:10+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` ASC [ RunTime:0.000231s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.003166s ] [2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.000354s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.002932s ] [2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000231s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.002849s ] [2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.000211s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.002781s ] [2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 2 [ RunTime:0.000186s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003428s ] [2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000391s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.003133s ] [2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 8 [ RunTime:0.000262s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.002819s ] [2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 8 [ RunTime:0.000224s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.002766s ] [2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 8 [ RunTime:0.000182s ] [2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.002829s ] [2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 8 [ RunTime:0.000316s ] [2023-05-12T10:16:27+08:00][sql] CONNECT:[ UseTime:0.001138s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003816s ] [2023-05-12T10:16:27+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000271s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.003027s ] [2023-05-12T10:16:27+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.000246s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.003570s ] [2023-05-12T10:16:27+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` ASC [ RunTime:0.000492s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.003091s ] [2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.000216s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.002849s ] [2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000195s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.002810s ] [2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.000197s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.003443s ] [2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 2 [ RunTime:0.000291s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003438s ] [2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000354s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.002791s ] [2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 7 [ RunTime:0.000194s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.003009s ] [2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 7 [ RunTime:0.000291s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.003703s ] [2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 7 [ RunTime:0.000261s ] [2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.002812s ] [2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 7 [ RunTime:0.000195s ] [2023-05-12T10:16:32+08:00][sql] CONNECT:[ UseTime:0.001159s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:16:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003193s ] [2023-05-12T10:16:32+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000208s ] [2023-05-12T10:16:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.007637s ] [2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'type' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000402s ] [2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'wechat' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000359s ] [2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'phone' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000321s ] [2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'business_time' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000335s ] [2023-05-12T10:16:40+08:00][sql] CONNECT:[ UseTime:0.001243s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003158s ] [2023-05-12T10:16:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000204s ] [2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003257s ] [2023-05-12T10:16:40+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 `id` = 2 LIMIT 1 [ RunTime:0.000361s ] [2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.002844s ] [2023-05-12T10:16:40+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000207s ] [2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.003014s ] [2023-05-12T10:16:40+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'map' AND `name` = 'tx_map_key' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000254s ] [2023-05-12T10:16:58+08:00][sql] CONNECT:[ UseTime:0.001163s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:16:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003167s ] [2023-05-12T10:16:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000191s ] [2023-05-12T10:16:58+08:00][sql] CONNECT:[ UseTime:0.001110s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:16:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003444s ] [2023-05-12T10:16:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000224s ] [2023-05-12T10:16:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_bank` [ RunTime:0.007398s ] [2023-05-12T10:16:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_bank` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000261s ] [2023-05-12T10:16:58+08:00][sql] SELECT `id`,`shop_id`,`name`,`branch`,`nickname`,`account`,`del`,`create_time`,`update_time` FROM `ls_shop_bank` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000211s ] [2023-05-12T10:17:03+08:00][sql] CONNECT:[ UseTime:0.001185s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003429s ] [2023-05-12T10:17:03+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000222s ] [2023-05-12T10:17:08+08:00][sql] CONNECT:[ UseTime:0.001186s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003140s ] [2023-05-12T10:17:08+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000196s ] [2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.003052s ] [2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'express' AND `name` = 'way' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000243s ] [2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kd100' AND `name` = 'appkey' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000224s ] [2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kd100' AND `name` = 'appsecret' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000255s ] [2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'appkey' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000235s ] [2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'appsecret' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000226s ] [2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'type' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000290s ] [2023-05-12T10:17:08+08:00][sql] CONNECT:[ UseTime:0.001185s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000735s ] [2023-05-12T10:17:08+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000223s ] [2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.003080s ] [2023-05-12T10:17:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_freight` WHERE `shop_id` = 2 [ RunTime:0.000439s ] [2023-05-12T10:17:08+08:00][sql] SELECT * FROM `ls_freight` WHERE `shop_id` = 2 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000276s ] [2023-05-12T10:17:11+08:00][sql] CONNECT:[ UseTime:0.001211s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000747s ] [2023-05-12T10:17:11+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000191s ] [2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.003058s ] [2023-05-12T10:17:11+08:00][sql] SELECT * FROM `ls_shop_role` WHERE `del` = 0 [ RunTime:0.000221s ] [2023-05-12T10:17:11+08:00][sql] CONNECT:[ UseTime:0.001226s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000723s ] [2023-05-12T10:17:11+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000184s ] [2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.003208s ] [2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.003089s ] [2023-05-12T10:17:11+08:00][sql] SELECT `id`,`name` FROM `ls_shop_role` WHERE `del` = 0 [ RunTime:0.000370s ] [2023-05-12T10:17:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_admin` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000214s ] [2023-05-12T10:17:11+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `del` = 0 AND `shop_id` = 2 LIMIT 0,10 [ RunTime:0.000218s ] [2023-05-12T10:17:15+08:00][sql] CONNECT:[ UseTime:0.001140s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000717s ] [2023-05-12T10:17:15+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000195s ] [2023-05-12T10:17:15+08:00][sql] CONNECT:[ UseTime:0.001135s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.001067s ] [2023-05-12T10:17:15+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000205s ] [2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role_auth_index` [ RunTime:0.003421s ] [2023-05-12T10:17:15+08:00][sql] SELECT `m`.`name` AS `name`,`r`.`role_id` AS `role_id` FROM `ls_shop_role_auth_index` `r` INNER JOIN `ls_dev_shop_auth` `m` ON `r`.`menu_auth_id`=`m`.`id` WHERE `m`.`del` = 0 ORDER BY `sort` DESC [ RunTime:0.004825s ] [2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.003286s ] [2023-05-12T10:17:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_role` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000246s ] [2023-05-12T10:17:15+08:00][sql] SELECT * FROM `ls_shop_role` WHERE `del` = 0 AND `shop_id` = 2 LIMIT 0,10 [ RunTime:0.000192s ] [2023-05-12T10:17:24+08:00][sql] CONNECT:[ UseTime:0.001136s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000726s ] [2023-05-12T10:17:24+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000214s ] [2023-05-12T10:17:28+08:00][sql] CONNECT:[ UseTime:0.001412s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000776s ] [2023-05-12T10:17:28+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ] [2023-05-12T10:17:28+08:00][sql] CONNECT:[ UseTime:0.001113s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000949s ] [2023-05-12T10:17:28+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000280s ] [2023-05-12T10:17:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_kefu` [ RunTime:0.008394s ] [2023-05-12T10:17:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_kefu` `k` INNER JOIN `ls_shop_admin` `a` ON `a`.`id`=`k`.`admin_id` WHERE `a`.`del` = 0 AND `k`.`del` = 0 AND `k`.`shop_id` = 2 [ RunTime:0.003186s ] [2023-05-12T10:17:28+08:00][sql] SELECT `k`.*,`a`.`account` FROM `ls_kefu` `k` INNER JOIN `ls_shop_admin` `a` ON `a`.`id`=`k`.`admin_id` WHERE `a`.`del` = 0 AND `k`.`del` = 0 AND `k`.`shop_id` = 2 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000348s ] [2023-05-12T10:17:29+08:00][sql] CONNECT:[ UseTime:0.001213s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003121s ] [2023-05-12T10:17:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000214s ] [2023-05-12T10:17:29+08:00][sql] CONNECT:[ UseTime:0.001178s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000772s ] [2023-05-12T10:17:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000275s ] [2023-05-12T10:17:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_kefu_lang` [ RunTime:0.006687s ] [2023-05-12T10:17:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_kefu_lang` WHERE `shop_id` = 2 [ RunTime:0.000226s ] [2023-05-12T10:17:29+08:00][sql] SELECT * FROM `ls_kefu_lang` WHERE `shop_id` = 2 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000191s ] [2023-05-12T10:17:33+08:00][sql] CONNECT:[ UseTime:0.001819s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000932s ] [2023-05-12T10:17:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000229s ] [2023-05-12T10:17:33+08:00][sql] CONNECT:[ UseTime:0.001151s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000737s ] [2023-05-12T10:17:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000182s ] [2023-05-12T10:17:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_printer_config` [ RunTime:0.006798s ] [2023-05-12T10:17:33+08:00][sql] SELECT * FROM `ls_printer_config` WHERE `shop_id` = 2 AND `del` = 0 LIMIT 1 [ RunTime:0.000424s ] [2023-05-12T10:17:33+08:00][sql] INSERT INTO `ls_printer_config` SET `name` = 'ζ˜“θ”δΊ‘' , `shop_id` = 2 , `client_id` = 0 , `client_secret` = 0 , `type` = 1 , `update_time` = 1683857853 [ RunTime:0.000303s ] [2023-05-12T10:17:33+08:00][sql] SELECT * FROM `ls_printer_config` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000239s ] [2023-05-12T10:17:34+08:00][sql] CONNECT:[ UseTime:0.001178s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000803s ] [2023-05-12T10:17:34+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000201s ] [2023-05-12T10:17:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.003697s ] [2023-05-12T10:17:34+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'printer' AND `name` = 'yly_template' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000308s ] [2023-05-12T10:17:35+08:00][sql] CONNECT:[ UseTime:0.001178s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000751s ] [2023-05-12T10:17:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000198s ] [2023-05-12T10:17:35+08:00][sql] CONNECT:[ UseTime:0.001140s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000734s ] [2023-05-12T10:17:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ] [2023-05-12T10:17:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_printer` [ RunTime:0.007147s ] [2023-05-12T10:17:35+08:00][sql] SELECT * FROM `ls_printer` `p` WHERE `p`.`del` = 0 AND `p`.`shop_id` = 2 ORDER BY `p`.`id` DESC LIMIT 0,10 [ RunTime:0.000280s ] [2023-05-12T10:17:37+08:00][sql] CONNECT:[ UseTime:0.001288s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000892s ] [2023-05-12T10:17:37+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000227s ] [2023-05-12T10:17:38+08:00][sql] CONNECT:[ UseTime:0.001114s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000953s ] [2023-05-12T10:17:38+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ] [2023-05-12T10:17:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_live_room` [ RunTime:0.007093s ] [2023-05-12T10:17:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_live_room` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000251s ] [2023-05-12T10:17:38+08:00][sql] SELECT * FROM `ls_live_room` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000247s ] [2023-05-12T10:17:41+08:00][sql] CONNECT:[ UseTime:0.001134s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000854s ] [2023-05-12T10:17:41+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000257s ] [2023-05-12T10:17:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_order_goods` [ RunTime:0.010365s ] [2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 2 [ RunTime:0.000349s ] [2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 2 AND `settlement_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000195s ] [2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 1 [ RunTime:0.000165s ] [2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 1 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000163s ] [2023-05-12T10:17:41+08:00][sql] SELECT sum(dog.money) AS `total_money`,`og`.`image` AS `goods_image`,`og`.`goods_name` FROM `ls_distribution_order_goods` `dog` LEFT JOIN `ls_order_goods` `og` ON `og`.`id`=`dog`.`order_goods_id` WHERE `dog`.`shop_id` = 2 AND `dog`.`status` = 2 GROUP BY `dog`.`money`,`og`.`image`,`og`.`goods_name` ORDER BY `total_money` DESC LIMIT 10 [ RunTime:0.002952s ] [2023-05-12T10:17:42+08:00][sql] CONNECT:[ UseTime:0.001136s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000752s ] [2023-05-12T10:17:42+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000188s ] [2023-05-12T10:17:42+08:00][sql] CONNECT:[ UseTime:0.001137s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000741s ] [2023-05-12T10:17:42+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000191s ] [2023-05-12T10:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_coupon` [ RunTime:0.008456s ] [2023-05-12T10:17:42+08:00][sql] UPDATE `ls_coupon` SET `status` = 0 , `update_time` = 1683857862 WHERE `send_time_start` < 1683857862 AND `send_time_end` < 1683857862 AND `status` = 1 AND `shop_id` = 2 [ RunTime:0.000250s ] [2023-05-12T10:17:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_coupon` WHERE `del` = 0 AND `shop_id` = 2 AND `status` = 1 [ RunTime:0.000198s ] [2023-05-12T10:17:42+08:00][sql] SELECT `id`,`name`,`money`,`use_goods_type`,use_goods_type as use_goods_type_desc,`condition_type`,`condition_money`,condition_type as condition_type_desc,`send_total_type`,send_total_type as send_total_type_desc,`send_total`,`get_type`,get_type as get_type_desc,`status`,status as statusDesc,`send_time_start`,`send_time_end`,send_time_start as send_time,`use_time_type`,`use_time_start`,`use_time_end`,`use_time`,use_time_type as use_time_desc,`create_time` FROM `ls_coupon` WHERE `del` = 0 AND `shop_id` = 2 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000289s ] [2023-05-12T10:17:43+08:00][sql] CONNECT:[ UseTime:0.001156s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000765s ] [2023-05-12T10:17:43+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000197s ] [2023-05-12T10:17:43+08:00][sql] CONNECT:[ UseTime:0.001105s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-12T10:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000796s ] [2023-05-12T10:17:43+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000189s ] [2023-05-12T10:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_invoice` [ RunTime:0.007430s ] [2023-05-12T10:17:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_order_invoice` `i` INNER JOIN `ls_order` `o` ON `o`.`id`=`i`.`order_id` WHERE `o`.`shop_id` = 2 [ RunTime:0.002525s ] [2023-05-12T10:17:43+08:00][sql] SELECT `i`.*,`o`.`order_sn`,`o`.`order_amount`,`order_status`,`o`.`create_time` AS `order_create_time` FROM `ls_order_invoice` `i` INNER JOIN `ls_order` `o` ON `o`.`id`=`i`.`order_id` WHERE `o`.`shop_id` = 2 ORDER BY `i`.`id` DESC LIMIT 0,10 [ RunTime:0.000320s ]