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.
33 lines
5.1 KiB
33 lines
5.1 KiB
[2023-05-19T08:34:55+08:00][sql] CONNECT:[ UseTime:0.156716s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-19T08:34:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.063774s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.059706s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SELECT `user_id` FROM `ls_session` WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.060049s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.062874s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 2 AND `del` = 0 LIMIT 1 [ RunTime:0.060429s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SELECT `u`.*,`s`.`token`,`s`.`client` FROM `ls_user` `u` INNER JOIN `ls_session` `s` ON `u`.`id`=`s`.`user_id` WHERE `s`.`token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.060212s ]
|
|
[2023-05-19T08:34:55+08:00][sql] UPDATE `ls_session` SET `update_time` = 1684456494 , `expire_time` = 1684542894 WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' [ RunTime:0.062316s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SELECT `u`.*,`s`.`token`,`s`.`client` FROM `ls_user` `u` INNER JOIN `ls_session` `s` ON `u`.`id`=`s`.`user_id` WHERE `s`.`token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.060180s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_cart` [ RunTime:0.062229s ]
|
|
[2023-05-19T08:34:55+08:00][sql] SELECT SUM(`goods_num`) AS think_sum FROM `ls_cart` `c` INNER JOIN `ls_goods` `g` ON `g`.`id`=`c`.`goods_id` INNER JOIN `ls_goods_item` `i` ON `i`.`id`=`c`.`item_id` WHERE `g`.`status` = 1 AND `g`.`del` = 0 AND `c`.`user_id` = 2 [ RunTime:0.060242s ]
|
|
[2023-05-19T10:04:38+08:00][sql] CONNECT:[ UseTime:0.072701s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-19T10:04:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.047395s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.047600s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SELECT `user_id` FROM `ls_session` WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.044984s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.048153s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 2 AND `del` = 0 LIMIT 1 [ RunTime:0.051958s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SELECT `u`.*,`s`.`token`,`s`.`client` FROM `ls_user` `u` INNER JOIN `ls_session` `s` ON `u`.`id`=`s`.`user_id` WHERE `s`.`token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.071109s ]
|
|
[2023-05-19T10:04:38+08:00][sql] UPDATE `ls_session` SET `update_time` = 1684461877 , `expire_time` = 1684548277 WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' [ RunTime:0.072220s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SELECT `u`.*,`s`.`token`,`s`.`client` FROM `ls_user` `u` INNER JOIN `ls_session` `s` ON `u`.`id`=`s`.`user_id` WHERE `s`.`token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.046813s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_cart` [ RunTime:0.047477s ]
|
|
[2023-05-19T10:04:38+08:00][sql] SELECT SUM(`goods_num`) AS think_sum FROM `ls_cart` `c` INNER JOIN `ls_goods` `g` ON `g`.`id`=`c`.`goods_id` INNER JOIN `ls_goods_item` `i` ON `i`.`id`=`c`.`item_id` WHERE `g`.`status` = 1 AND `g`.`del` = 0 AND `c`.`user_id` = 2 [ RunTime:0.045929s ]
|
|
[2023-05-19T13:48:58+08:00][sql] CONNECT:[ UseTime:0.052319s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-19T13:48:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_session` [ RunTime:0.037492s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SELECT * FROM `ls_session` WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.033216s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SELECT `user_id` FROM `ls_session` WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.030392s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.032966s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 2 AND `del` = 0 LIMIT 1 [ RunTime:0.033796s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SELECT `u`.*,`s`.`token`,`s`.`client` FROM `ls_user` `u` INNER JOIN `ls_session` `s` ON `u`.`id`=`s`.`user_id` WHERE `s`.`token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.036684s ]
|
|
[2023-05-19T13:48:58+08:00][sql] UPDATE `ls_session` SET `update_time` = 1684475338 , `expire_time` = 1684561738 WHERE `token` = '9c13be8f27a56f4bf25177deb3dc4b7b' [ RunTime:0.033329s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SELECT `u`.*,`s`.`token`,`s`.`client` FROM `ls_user` `u` INNER JOIN `ls_session` `s` ON `u`.`id`=`s`.`user_id` WHERE `s`.`token` = '9c13be8f27a56f4bf25177deb3dc4b7b' LIMIT 1 [ RunTime:0.031407s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_cart` [ RunTime:0.051117s ]
|
|
[2023-05-19T13:48:58+08:00][sql] SELECT SUM(`goods_num`) AS think_sum FROM `ls_cart` `c` INNER JOIN `ls_goods` `g` ON `g`.`id`=`c`.`goods_id` INNER JOIN `ls_goods_item` `i` ON `i`.`id`=`c`.`item_id` WHERE `g`.`status` = 1 AND `g`.`del` = 0 AND `c`.`user_id` = 2 [ RunTime:0.031982s ]
|
|
|