ホーム エクスプローラ ヘルプ
登録 サインイン
zy_duanju
/
duanju_manage
6
0
フォーク 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: 3ae9d89bc1
ブランチ タグ
duanju_manage
/
storage
/
logs
/
query
/
20230519.log

20230519.log 3.2 KB
履歴 Raw

12345678910111213141516171819202122 
  1. [2023-05-19 11:16] select count(*) as aggregate from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `users`.`id` = 1 and `roles`.`identify` = administrator | 158.84 ms
    2. 

  2. [2023-05-19 11:16] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 21.46 ms
    3. 

  3. [2023-05-19 11:16] select `pay_products`.`price`, `pay_products`.`type`, `pay_products`.`given`, `pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `sequence` from `pay_template_items` inner join `pay_products` on `pay_products`.`id` = `pay_template_items`.`pay_product_id` where `pay_template_id` = 5 and `pay_template_items`.`status` = 1 order by `pay_template_items`.`sequence` asc | 21.68 ms
    4. 

  4. 

  5. [2023-05-19 11:40] select count(*) as aggregate from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `users`.`id` = 1 and `roles`.`identify` = administrator | 154.52 ms
    6. 

  6. [2023-05-19 11:40] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 30.42 ms
    7. 

  7. [2023-05-19 11:40] select `pay_products`.`price`, `pay_products`.`type`, `pay_products`.`given`, `pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `sequence`, `pay_template_items`.`id` as `pay_template_item_id` from `pay_template_items` inner join `pay_products` on `pay_products`.`id` = `pay_template_items`.`pay_product_id` where `pay_template_id` = 5 and `pay_template_items`.`status` = 1 order by `pay_template_items`.`sequence` asc | 34.56 ms
    8. 

  8. 

  9. [2023-05-19 15:32] select * from `pay_template_items` where `pay_template_items`.`id` = 5 limit 1 | 171.16 ms
    10. 

  10. [2023-05-19 15:32] select * from `pay_products` where (`price` = 9 and `type` = COIN and `given` = 1000) limit 1 | 28 ms
    11. 

  11. [2023-05-19 15:32] update `pay_template_items` set `status` = 0, `pay_template_items`.`updated_at` = 2023-05-19 15:32:19 where `id` = 5 | 32.32 ms
    12. 

  12. [2023-05-19 15:32] insert into `pay_template_items` (`pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `status`, `sequence`, `created_at`, `updated_at`) values (1, 12, 1, 1, 1, 0, 2023-05-19 15:32:20, 2023-05-19 15:32:20) | 33.64 ms
    13. 

  13. 

  14. [2023-05-19 15:34] select * from `pay_template_items` where `pay_template_items`.`id` = 31 limit 1 | 130.37 ms
    15. 

  15. [2023-05-19 15:34] select * from `pay_products` where (`price` = 9 and `type` = COIN and `given` = 1000) limit 1 | 25.9 ms
    16. 

  16. [2023-05-19 15:34] update `pay_template_items` set `is_default` = 1, `pay_template_items`.`updated_at` = 2023-05-19 15:34:22 where `id` = 31 | 30.12 ms
    17. 

  17. 

  18. [2023-05-19 15:34] select * from `pay_template_items` where `pay_template_items`.`id` = 31 limit 1 | 136.09 ms
    19. 

  19. [2023-05-19 15:34] select * from `pay_products` where (`price` = 10 and `type` = COIN and `given` = 1000) limit 1 | 27.68 ms
    20. 

  20. [2023-05-19 15:34] update `pay_template_items` set `status` = 0, `pay_template_items`.`updated_at` = 2023-05-19 15:34:54 where `id` = 31 | 31.82 ms
    21. 

  21. [2023-05-19 15:34] insert into `pay_template_items` (`pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `status`, `sequence`, `created_at`, `updated_at`) values (5, 7, 1, 1, 1, 0, 2023-05-19 15:34:54, 2023-05-19 15:34:54) | 31.38 ms
    22. 

  22.