single_sql.log 82 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752
  1. ---------------------------------------------------------------
  2. [2023-12-22T17:52:26+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
  3. [ sql ] [ DB ] CONNECT:[ UseTime:0.153397s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  4. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.103277s ]
  5. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.119193s ]
  6. [ sql ] [ SQL ] SELECT * FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.123016s ]
  7. ---------------------------------------------------------------
  8. [2023-12-22T17:52:33+08:00] 127.0.0.1 GET gaoyx.com/user/message/edit.html?id=229&spm=m-64-175-301&open_type=modal
  9. [ sql ] [ DB ] CONNECT:[ UseTime:0.156802s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  10. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.107809s ]
  11. [ sql ] [ SQL ] SELECT * FROM `dd_label_message` WHERE `id` = 229 LIMIT 1 [ RunTime:0.102580s ]
  12. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.105971s ]
  13. [ sql ] [ SQL ] SELECT id,title,IF(id,'video',0) module FROM `dd_video_intro` WHERE `is_deleted` = 0 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.122879s ]
  14. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.105193s ]
  15. [ sql ] [ SQL ] SELECT `id`,`title`,`video_id` FROM `dd_video_url` WHERE `status` = 1 AND `is_deleted` = 0 AND `release_time` < '2023-12-22 17:52:28' AND `status` = 1 AND `video_id` IN (106,105,103,100,0) ORDER BY `sort` DESC [ RunTime:0.102934s ]
  16. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.105362s ]
  17. [ sql ] [ SQL ] SELECT id,title,IF(id,'datum',0) module FROM `dd_datum_intro` WHERE `is_deleted` = 0 ORDER BY `id` DESC [ RunTime:0.103790s ]
  18. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.108957s ]
  19. [ sql ] [ SQL ] SELECT `id`,`release_time`,`datum_id`,`user_id`,`title`,`url`,`is_encrypt`,`pdf_clear`,`sort`,`is_vip`,`transmit_num`,`down_num`,`read_num`,`is_down`,`comment_switch` FROM `dd_datum_url` WHERE `release_time` < '2023-12-22 17:52:29' AND `is_deleted` = 0 AND `status` = 1 AND `datum_id` IN (32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17) [ RunTime:0.102842s ]
  20. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.104891s ]
  21. [ sql ] [ SQL ] SELECT id,title,IF(id,'article',0) module FROM `dd_article_intro` WHERE `is_deleted` = 0 ORDER BY `id` ASC [ RunTime:0.105643s ]
  22. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.103560s ]
  23. [ sql ] [ SQL ] SELECT `id`,`article_id`,`title`,`video_id` FROM `dd_article_item` WHERE `is_deleted` = 0 AND `article_id` IN (47,48,49,50,53) ORDER BY `sort` DESC [ RunTime:0.106282s ]
  24. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.104231s ]
  25. [ sql ] [ SQL ] SELECT g.id,g.title,IF(g.id,'supplier',0) module FROM `dd_supplier` `g` WHERE `g`.`is_deleted` = 0 AND `status` = 1 [ RunTime:0.123705s ]
  26. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.103218s ]
  27. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 33 AND `g`.`status` = 1 [ RunTime:0.103849s ]
  28. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 34 AND `g`.`status` = 1 [ RunTime:0.101395s ]
  29. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 35 AND `g`.`status` = 1 [ RunTime:0.126351s ]
  30. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.101848s ]
  31. [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.105498s ]
  32. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.101347s ]
  33. [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.123458s ]
  34. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.102384s ]
  35. [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.104709s ]
  36. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.102441s ]
  37. [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.102983s ]
  38. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.106575s ]
  39. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.103444s ]
  40. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.102989s ]
  41. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.125644s ]
  42. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 [ RunTime:0.103589s ]
  43. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 34 [ RunTime:0.103694s ]
  44. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 35 [ RunTime:0.108461s ]
  45. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 36 [ RunTime:0.104692s ]
  46. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 37 [ RunTime:0.102955s ]
  47. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 40 [ RunTime:0.103916s ]
  48. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 41 [ RunTime:0.102863s ]
  49. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 42 [ RunTime:0.106362s ]
  50. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 43 [ RunTime:0.110634s ]
  51. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 44 [ RunTime:0.107159s ]
  52. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 45 [ RunTime:0.106413s ]
  53. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.132019s ]
  54. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.122555s ]
  55. ---------------------------------------------------------------
  56. [2023-12-22T17:52:44+08:00] 127.0.0.1 GET gaoyx.com/user/message/add.html?spm=m-64-175-301&open_type=modal
  57. [ sql ] [ DB ] CONNECT:[ UseTime:0.151438s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  58. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.101993s ]
  59. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.099833s ]
  60. [ sql ] [ SQL ] SELECT id,title,IF(id,'video',0) module FROM `dd_video_intro` WHERE `is_deleted` = 0 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.120386s ]
  61. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.098710s ]
  62. [ sql ] [ SQL ] SELECT `id`,`title`,`video_id` FROM `dd_video_url` WHERE `status` = 1 AND `is_deleted` = 0 AND `release_time` < '2023-12-22 17:52:40' AND `status` = 1 AND `video_id` IN (106,105,103,100,0) ORDER BY `sort` DESC [ RunTime:0.121805s ]
  63. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.101626s ]
  64. [ sql ] [ SQL ] SELECT id,title,IF(id,'datum',0) module FROM `dd_datum_intro` WHERE `is_deleted` = 0 ORDER BY `id` DESC [ RunTime:0.098757s ]
  65. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.100167s ]
  66. [ sql ] [ SQL ] SELECT `id`,`release_time`,`datum_id`,`user_id`,`title`,`url`,`is_encrypt`,`pdf_clear`,`sort`,`is_vip`,`transmit_num`,`down_num`,`read_num`,`is_down`,`comment_switch` FROM `dd_datum_url` WHERE `release_time` < '2023-12-22 17:52:40' AND `is_deleted` = 0 AND `status` = 1 AND `datum_id` IN (32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17) [ RunTime:0.102986s ]
  67. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.098241s ]
  68. [ sql ] [ SQL ] SELECT id,title,IF(id,'article',0) module FROM `dd_article_intro` WHERE `is_deleted` = 0 ORDER BY `id` ASC [ RunTime:0.098281s ]
  69. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.099103s ]
  70. [ sql ] [ SQL ] SELECT `id`,`article_id`,`title`,`video_id` FROM `dd_article_item` WHERE `is_deleted` = 0 AND `article_id` IN (47,48,49,50,53) ORDER BY `sort` DESC [ RunTime:0.125316s ]
  71. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.099562s ]
  72. [ sql ] [ SQL ] SELECT g.id,g.title,IF(g.id,'supplier',0) module FROM `dd_supplier` `g` WHERE `g`.`is_deleted` = 0 AND `status` = 1 [ RunTime:0.122095s ]
  73. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.103304s ]
  74. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 33 AND `g`.`status` = 1 [ RunTime:0.119951s ]
  75. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 34 AND `g`.`status` = 1 [ RunTime:0.119853s ]
  76. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 35 AND `g`.`status` = 1 [ RunTime:0.122775s ]
  77. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.103075s ]
  78. [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.121482s ]
  79. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.099963s ]
  80. [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.099792s ]
  81. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.099764s ]
  82. [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.120526s ]
  83. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.098834s ]
  84. [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117678s ]
  85. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.098228s ]
  86. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.117482s ]
  87. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.104456s ]
  88. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.119940s ]
  89. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 [ RunTime:0.119726s ]
  90. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 34 [ RunTime:0.121096s ]
  91. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 35 [ RunTime:0.102680s ]
  92. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 36 [ RunTime:0.119828s ]
  93. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 37 [ RunTime:0.105923s ]
  94. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 40 [ RunTime:0.121513s ]
  95. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 41 [ RunTime:0.100946s ]
  96. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 42 [ RunTime:0.103251s ]
  97. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 43 [ RunTime:0.104588s ]
  98. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 44 [ RunTime:0.119155s ]
  99. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 45 [ RunTime:0.118178s ]
  100. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.099244s ]
  101. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.121182s ]
  102. ---------------------------------------------------------------
  103. [2023-12-22T17:56:08+08:00] 127.0.0.1 GET gaoyx.com/admin.html
  104. [ sql ] [ DB ] CONNECT:[ UseTime:0.153206s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  105. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.095284s ]
  106. [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.343259s ]
  107. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.095993s ]
  108. [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.093102s ]
  109. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.108305s ]
  110. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:4.294390s ]
  111. ---------------------------------------------------------------
  112. [2023-12-22T17:56:09+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
  113. [ sql ] [ DB ] CONNECT:[ UseTime:0.177155s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  114. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.141225s ]
  115. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.119126s ]
  116. [ sql ] [ SQL ] SELECT * FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.117264s ]
  117. ---------------------------------------------------------------
  118. [2023-12-22T17:56:16+08:00] 127.0.0.1 GET gaoyx.com/user/message/add.html?spm=m-64-175-301&open_type=modal
  119. [ sql ] [ DB ] CONNECT:[ UseTime:0.160534s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  120. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.152643s ]
  121. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.109111s ]
  122. [ sql ] [ SQL ] SELECT id,title,IF(id,'video',0) module FROM `dd_video_intro` WHERE `is_deleted` = 0 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.104546s ]
  123. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.371633s ]
  124. [ sql ] [ SQL ] SELECT `id`,`title`,`video_id` FROM `dd_video_url` WHERE `status` = 1 AND `is_deleted` = 0 AND `release_time` < '2023-12-22 17:56:11' AND `status` = 1 AND `video_id` IN (106,105,103,100,0) ORDER BY `sort` DESC [ RunTime:0.394128s ]
  125. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.125549s ]
  126. [ sql ] [ SQL ] SELECT id,title,IF(id,'datum',0) module FROM `dd_datum_intro` WHERE `is_deleted` = 0 ORDER BY `id` DESC [ RunTime:0.145844s ]
  127. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.104143s ]
  128. [ sql ] [ SQL ] SELECT `id`,`release_time`,`datum_id`,`user_id`,`title`,`url`,`is_encrypt`,`pdf_clear`,`sort`,`is_vip`,`transmit_num`,`down_num`,`read_num`,`is_down`,`comment_switch` FROM `dd_datum_url` WHERE `release_time` < '2023-12-22 17:56:12' AND `is_deleted` = 0 AND `status` = 1 AND `datum_id` IN (32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17) [ RunTime:0.108503s ]
  129. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.108125s ]
  130. [ sql ] [ SQL ] SELECT id,title,IF(id,'article',0) module FROM `dd_article_intro` WHERE `is_deleted` = 0 ORDER BY `id` ASC [ RunTime:0.117892s ]
  131. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.114746s ]
  132. [ sql ] [ SQL ] SELECT `id`,`article_id`,`title`,`video_id` FROM `dd_article_item` WHERE `is_deleted` = 0 AND `article_id` IN (47,48,49,50,53) ORDER BY `sort` DESC [ RunTime:0.118116s ]
  133. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.117014s ]
  134. [ sql ] [ SQL ] SELECT g.id,g.title,IF(g.id,'supplier',0) module FROM `dd_supplier` `g` WHERE `g`.`is_deleted` = 0 AND `status` = 1 [ RunTime:0.105198s ]
  135. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.103558s ]
  136. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 33 AND `g`.`status` = 1 [ RunTime:0.111516s ]
  137. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 34 AND `g`.`status` = 1 [ RunTime:0.106098s ]
  138. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 35 AND `g`.`status` = 1 [ RunTime:0.103310s ]
  139. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.104460s ]
  140. [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.115408s ]
  141. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.106859s ]
  142. [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.104596s ]
  143. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.106467s ]
  144. [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.123180s ]
  145. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.105086s ]
  146. [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.119346s ]
  147. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.107694s ]
  148. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.106963s ]
  149. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.110240s ]
  150. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.105788s ]
  151. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 [ RunTime:0.102132s ]
  152. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 34 [ RunTime:0.119820s ]
  153. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 35 [ RunTime:0.118805s ]
  154. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 36 [ RunTime:0.453925s ]
  155. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 37 [ RunTime:0.106376s ]
  156. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 40 [ RunTime:0.103151s ]
  157. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 41 [ RunTime:0.115482s ]
  158. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 42 [ RunTime:0.108758s ]
  159. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 43 [ RunTime:0.109096s ]
  160. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 44 [ RunTime:0.104438s ]
  161. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 45 [ RunTime:0.106626s ]
  162. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.109943s ]
  163. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.140946s ]
  164. ---------------------------------------------------------------
  165. [2023-12-22T17:56:52+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
  166. [ sql ] [ DB ] CONNECT:[ UseTime:0.170516s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  167. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.106131s ]
  168. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.114394s ]
  169. [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.098601s ]
  170. ---------------------------------------------------------------
  171. [2023-12-22T17:56:53+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
  172. [ sql ] [ DB ] CONNECT:[ UseTime:0.162889s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  173. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.100785s ]
  174. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.098742s ]
  175. [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.101275s ]
  176. ---------------------------------------------------------------
  177. [2023-12-22T17:56:56+08:00] 127.0.0.1 GET gaoyx.com/nutrition/datum_cate/index.html?spm=m-140-165-166
  178. [ sql ] [ DB ] CONNECT:[ UseTime:0.178055s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  179. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_cate` [ RunTime:0.103274s ]
  180. [ sql ] [ SQL ] SELECT * FROM `dd_datum_cate` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.104506s ]
  181. ---------------------------------------------------------------
  182. [2023-12-22T17:56:58+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
  183. [ sql ] [ DB ] CONNECT:[ UseTime:0.157394s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  184. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.102233s ]
  185. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.097873s ]
  186. [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.095855s ]
  187. ---------------------------------------------------------------
  188. [2023-12-22T17:56:58+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
  189. [ sql ] [ DB ] CONNECT:[ UseTime:0.152211s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  190. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.101918s ]
  191. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.107819s ]
  192. ---------------------------------------------------------------
  193. [2023-12-22T18:00:10+08:00] 127.0.0.1 GET gaoyx.com/admin.html
  194. [ sql ] [ DB ] CONNECT:[ UseTime:0.152778s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  195. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.104698s ]
  196. [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.115006s ]
  197. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.108304s ]
  198. [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.111216s ]
  199. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.104799s ]
  200. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.752650s ]
  201. ---------------------------------------------------------------
  202. [2023-12-22T18:00:11+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
  203. [ sql ] [ DB ] CONNECT:[ UseTime:0.161324s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  204. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.108564s ]
  205. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.105611s ]
  206. ---------------------------------------------------------------
  207. [2023-12-22T18:00:12+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
  208. [ sql ] [ DB ] CONNECT:[ UseTime:0.153991s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  209. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.107249s ]
  210. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.106483s ]
  211. [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.103450s ]
  212. ---------------------------------------------------------------
  213. [2023-12-22T18:00:15+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
  214. [ sql ] [ DB ] CONNECT:[ UseTime:0.152255s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  215. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.104066s ]
  216. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.122039s ]
  217. [ sql ] [ SQL ] SELECT * FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.104323s ]
  218. ---------------------------------------------------------------
  219. [2023-12-22T18:00:26+08:00] 127.0.0.1 GET gaoyx.com/user/message/add.html?spm=m-64-175-301&open_type=modal
  220. [ sql ] [ DB ] CONNECT:[ UseTime:0.166217s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  221. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.109245s ]
  222. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.108786s ]
  223. [ sql ] [ SQL ] SELECT id,title,IF(id,'video',0) module FROM `dd_video_intro` WHERE `is_deleted` = 0 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.109402s ]
  224. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.113219s ]
  225. [ sql ] [ SQL ] SELECT `id`,`title`,`video_id` FROM `dd_video_url` WHERE `status` = 1 AND `is_deleted` = 0 AND `release_time` < '2023-12-22 18:00:22' AND `status` = 1 AND `video_id` IN (106,105,103,100,0) ORDER BY `sort` DESC [ RunTime:0.108257s ]
  226. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.109527s ]
  227. [ sql ] [ SQL ] SELECT id,title,IF(id,'datum',0) module FROM `dd_datum_intro` WHERE `is_deleted` = 0 ORDER BY `id` DESC [ RunTime:0.110894s ]
  228. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.110809s ]
  229. [ sql ] [ SQL ] SELECT `id`,`release_time`,`datum_id`,`user_id`,`title`,`url`,`is_encrypt`,`pdf_clear`,`sort`,`is_vip`,`transmit_num`,`down_num`,`read_num`,`is_down`,`comment_switch` FROM `dd_datum_url` WHERE `release_time` < '2023-12-22 18:00:22' AND `is_deleted` = 0 AND `status` = 1 AND `datum_id` IN (32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17) [ RunTime:0.109360s ]
  230. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.112708s ]
  231. [ sql ] [ SQL ] SELECT id,title,IF(id,'article',0) module FROM `dd_article_intro` WHERE `is_deleted` = 0 ORDER BY `id` ASC [ RunTime:0.108631s ]
  232. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.111464s ]
  233. [ sql ] [ SQL ] SELECT `id`,`article_id`,`title`,`video_id` FROM `dd_article_item` WHERE `is_deleted` = 0 AND `article_id` IN (47,48,49,50,53) ORDER BY `sort` DESC [ RunTime:0.110150s ]
  234. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.111240s ]
  235. [ sql ] [ SQL ] SELECT g.id,g.title,IF(g.id,'supplier',0) module FROM `dd_supplier` `g` WHERE `g`.`is_deleted` = 0 AND `status` = 1 [ RunTime:0.109866s ]
  236. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.111398s ]
  237. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 33 AND `g`.`status` = 1 [ RunTime:0.112329s ]
  238. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 34 AND `g`.`status` = 1 [ RunTime:0.110772s ]
  239. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 35 AND `g`.`status` = 1 [ RunTime:0.112543s ]
  240. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.112221s ]
  241. [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.112303s ]
  242. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.110836s ]
  243. [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.111288s ]
  244. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.110428s ]
  245. [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.110219s ]
  246. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.111337s ]
  247. [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.108479s ]
  248. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.108968s ]
  249. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.111575s ]
  250. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.110765s ]
  251. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.111353s ]
  252. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 [ RunTime:0.110491s ]
  253. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 34 [ RunTime:0.113119s ]
  254. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 35 [ RunTime:0.110091s ]
  255. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 36 [ RunTime:0.109303s ]
  256. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 37 [ RunTime:0.109322s ]
  257. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 40 [ RunTime:0.112882s ]
  258. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 41 [ RunTime:0.111532s ]
  259. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 42 [ RunTime:0.112337s ]
  260. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 43 [ RunTime:0.112306s ]
  261. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 44 [ RunTime:0.109029s ]
  262. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 45 [ RunTime:0.110848s ]
  263. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.112876s ]
  264. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_goods_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.108900s ]
  265. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.117512s ]
  266. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 30 [ RunTime:0.110666s ]
  267. ---------------------------------------------------------------
  268. [2023-12-22T18:01:18+08:00] 127.0.0.1 GET gaoyx.com/admin.html
  269. [ sql ] [ DB ] CONNECT:[ UseTime:0.160679s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  270. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.112028s ]
  271. [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.105224s ]
  272. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.106495s ]
  273. [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.108514s ]
  274. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.107118s ]
  275. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.749779s ]
  276. ---------------------------------------------------------------
  277. [2023-12-22T18:01:19+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
  278. [ sql ] [ DB ] CONNECT:[ UseTime:0.147815s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  279. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.099487s ]
  280. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.115396s ]
  281. [ sql ] [ SQL ] SELECT * FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.118196s ]
  282. ---------------------------------------------------------------
  283. [2023-12-22T18:01:28+08:00] 127.0.0.1 GET gaoyx.com/user/message/add.html?spm=m-64-175-301&open_type=modal
  284. [ sql ] [ DB ] CONNECT:[ UseTime:0.319383s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  285. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.102519s ]
  286. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.098677s ]
  287. [ sql ] [ SQL ] SELECT id,title,IF(id,'video',0) module FROM `dd_video_intro` WHERE `is_deleted` = 0 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.120010s ]
  288. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.101168s ]
  289. [ sql ] [ SQL ] SELECT `id`,`title`,`video_id` FROM `dd_video_url` WHERE `status` = 1 AND `is_deleted` = 0 AND `release_time` < '2023-12-22 18:01:23' AND `status` = 1 AND `video_id` IN (106,105,103,100,0) ORDER BY `sort` DESC [ RunTime:0.121794s ]
  290. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.100409s ]
  291. [ sql ] [ SQL ] SELECT id,title,IF(id,'datum',0) module FROM `dd_datum_intro` WHERE `is_deleted` = 0 ORDER BY `id` DESC [ RunTime:0.101617s ]
  292. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.099440s ]
  293. [ sql ] [ SQL ] SELECT `id`,`release_time`,`datum_id`,`user_id`,`title`,`url`,`is_encrypt`,`pdf_clear`,`sort`,`is_vip`,`transmit_num`,`down_num`,`read_num`,`is_down`,`comment_switch` FROM `dd_datum_url` WHERE `release_time` < '2023-12-22 18:01:23' AND `is_deleted` = 0 AND `status` = 1 AND `datum_id` IN (32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17) [ RunTime:0.119656s ]
  294. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.099197s ]
  295. [ sql ] [ SQL ] SELECT id,title,IF(id,'article',0) module FROM `dd_article_intro` WHERE `is_deleted` = 0 ORDER BY `id` ASC [ RunTime:0.096119s ]
  296. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.097804s ]
  297. [ sql ] [ SQL ] SELECT `id`,`article_id`,`title`,`video_id` FROM `dd_article_item` WHERE `is_deleted` = 0 AND `article_id` IN (47,48,49,50,53) ORDER BY `sort` DESC [ RunTime:0.118214s ]
  298. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.098429s ]
  299. [ sql ] [ SQL ] SELECT g.id,g.title,IF(g.id,'supplier',0) module FROM `dd_supplier` `g` WHERE `g`.`is_deleted` = 0 AND `status` = 1 [ RunTime:0.118631s ]
  300. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.099513s ]
  301. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 33 AND `g`.`status` = 1 [ RunTime:0.117771s ]
  302. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 34 AND `g`.`status` = 1 [ RunTime:0.118717s ]
  303. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 35 AND `g`.`status` = 1 [ RunTime:0.118554s ]
  304. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.098155s ]
  305. [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.118238s ]
  306. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.098057s ]
  307. [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117473s ]
  308. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.099850s ]
  309. [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.116845s ]
  310. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.098131s ]
  311. [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117202s ]
  312. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.100100s ]
  313. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.120102s ]
  314. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.096880s ]
  315. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.117710s ]
  316. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 [ RunTime:0.122028s ]
  317. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 34 [ RunTime:0.107098s ]
  318. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 35 [ RunTime:0.116191s ]
  319. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 36 [ RunTime:0.116281s ]
  320. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 37 [ RunTime:0.116638s ]
  321. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 40 [ RunTime:0.118776s ]
  322. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 41 [ RunTime:0.104006s ]
  323. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 42 [ RunTime:0.117448s ]
  324. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 43 [ RunTime:0.120123s ]
  325. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 44 [ RunTime:0.117784s ]
  326. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 45 [ RunTime:0.116493s ]
  327. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099453s ]
  328. [ sql ] [ SQL ] SELECT id,title,IF(id,'mall',0) module FROM `dd_goods_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.117771s ]
  329. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.097941s ]
  330. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 30 [ RunTime:0.104479s ]
  331. ---------------------------------------------------------------
  332. [2023-12-22T18:02:31+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
  333. [ sql ] [ DB ] CONNECT:[ UseTime:0.151841s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  334. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.100685s ]
  335. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.098635s ]
  336. [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.102367s ]
  337. ---------------------------------------------------------------
  338. [2023-12-22T18:02:33+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
  339. [ sql ] [ DB ] CONNECT:[ UseTime:0.146704s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  340. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099966s ]
  341. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.117813s ]
  342. ---------------------------------------------------------------
  343. [2023-12-22T18:02:35+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/second.html?pid=28&spm=m-136-283-284
  344. [ sql ] [ DB ] CONNECT:[ UseTime:0.141770s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  345. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.094115s ]
  346. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 [ RunTime:0.113299s ]
  347. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.113871s ]
  348. ---------------------------------------------------------------
  349. [2023-12-22T18:02:37+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/third.html?pid=29&spm=m-136-283-284
  350. [ sql ] [ DB ] CONNECT:[ UseTime:0.156082s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  351. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.102812s ]
  352. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 [ RunTime:0.100105s ]
  353. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.100870s ]
  354. ---------------------------------------------------------------
  355. [2023-12-22T18:02:39+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/second.html?pid=28&spm=m-136-283-284
  356. [ sql ] [ DB ] CONNECT:[ UseTime:0.148716s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  357. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.100657s ]
  358. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 [ RunTime:0.117273s ]
  359. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.117998s ]
  360. ---------------------------------------------------------------
  361. [2023-12-22T18:02:40+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
  362. [ sql ] [ DB ] CONNECT:[ UseTime:0.148235s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  363. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.098155s ]
  364. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.118864s ]
  365. ---------------------------------------------------------------
  366. [2023-12-22T18:02:42+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/second.html?pid=26&spm=m-136-283-284
  367. [ sql ] [ DB ] CONNECT:[ UseTime:0.157954s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  368. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.112001s ]
  369. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 [ RunTime:0.103443s ]
  370. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.104193s ]
  371. ---------------------------------------------------------------
  372. [2023-12-22T18:02:43+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/third.html?pid=27&spm=m-136-283-284
  373. [ sql ] [ DB ] CONNECT:[ UseTime:0.161024s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  374. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.108260s ]
  375. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 [ RunTime:0.105063s ]
  376. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.104957s ]
  377. ---------------------------------------------------------------
  378. [2023-12-22T18:04:13+08:00] 127.0.0.1 GET gaoyx.com/mall/store_goods/index.html?spm=m-136-283-285
  379. [ sql ] [ DB ] CONNECT:[ UseTime:0.146546s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  380. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.100697s ]
  381. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_goods` WHERE `is_deleted` = 0 [ RunTime:0.097273s ]
  382. [ sql ] [ SQL ] SELECT * FROM `dd_store_goods` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.293896s ]
  383. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.098975s ]
  384. [ sql ] [ SQL ] SELECT `id`,`title`,`pid`,`lev` FROM `dd_goods_cate` WHERE `status` = 1 AND `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.119401s ]
  385. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods_item` [ RunTime:0.098039s ]
  386. [ sql ] [ SQL ] SELECT * FROM `dd_store_goods_item` WHERE `status` = 1 AND `goods_id` IN (52,53,54,55,56,57,58,59,60,61,62,63,64) [ RunTime:0.169269s ]
  387. ---------------------------------------------------------------
  388. [2023-12-22T18:04:14+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
  389. [ sql ] [ DB ] CONNECT:[ UseTime:0.149132s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  390. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099653s ]
  391. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.119160s ]
  392. ---------------------------------------------------------------
  393. [2023-12-22T18:04:16+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/second.html?pid=28&spm=m-136-283-284
  394. [ sql ] [ DB ] CONNECT:[ UseTime:0.150447s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  395. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.100046s ]
  396. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 [ RunTime:0.120911s ]
  397. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.100471s ]
  398. ---------------------------------------------------------------
  399. [2023-12-22T18:04:17+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/third.html?pid=29&spm=m-136-283-284
  400. [ sql ] [ DB ] CONNECT:[ UseTime:0.149696s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  401. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099676s ]
  402. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 [ RunTime:0.117448s ]
  403. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.122775s ]
  404. ---------------------------------------------------------------
  405. [2023-12-22T18:04:19+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/add.html?pid=29&lev=3&spm=m-136-283-284&open_type=modal
  406. [ sql ] [ DB ] CONNECT:[ UseTime:0.153916s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  407. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.103343s ]
  408. ---------------------------------------------------------------
  409. [2023-12-22T18:04:21+08:00] 127.0.0.1 POST gaoyx.com/admin.html?s=admin/api.plugs/check&spm=m-136-283-284
  410. [ sql ] [ DB ] CONNECT:[ UseTime:0.147562s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  411. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.095771s ]
  412. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:1.092432s ]
  413. ---------------------------------------------------------------
  414. [2023-12-22T18:04:28+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
  415. [ sql ] [ DB ] CONNECT:[ UseTime:0.147970s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  416. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.098647s ]
  417. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.119649s ]
  418. ---------------------------------------------------------------
  419. [2023-12-22T18:04:30+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/second.html?pid=26&spm=m-136-283-284
  420. [ sql ] [ DB ] CONNECT:[ UseTime:0.159115s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  421. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.105715s ]
  422. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 [ RunTime:0.107568s ]
  423. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.102727s ]
  424. ---------------------------------------------------------------
  425. [2023-12-22T18:04:31+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/third.html?pid=27&spm=m-136-283-284
  426. [ sql ] [ DB ] CONNECT:[ UseTime:0.163599s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  427. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.104545s ]
  428. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 [ RunTime:0.104048s ]
  429. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.103674s ]
  430. ---------------------------------------------------------------
  431. [2023-12-22T18:04:34+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/add.html?pid=27&lev=3&spm=m-136-283-284&open_type=modal
  432. [ sql ] [ DB ] CONNECT:[ UseTime:0.153165s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  433. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.103215s ]
  434. ---------------------------------------------------------------
  435. [2023-12-22T18:04:49+08:00] 127.0.0.1 POST gaoyx.com/mall/goods_cate/add.html?pid=27&lev=3&spm=m-136-283-284&open_type=modal
  436. [ sql ] [ DB ] CONNECT:[ UseTime:0.149864s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  437. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.100400s ]
  438. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.099215s ]
  439. [ sql ] [ SQL ] INSERT INTO `dd_goods_cate` (`title` , `logo` , `pid` , `lev`) VALUES ('非日用品' , 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/2023-12-22/dd396d31ed34e7bf/569e6f0e77bd2e88.jpg' , 27 , 3) [ RunTime:0.118234s ]
  440. ---------------------------------------------------------------
  441. [2023-12-22T18:04:52+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/third.html?pid=27&spm=m-136-283-284
  442. [ sql ] [ DB ] CONNECT:[ UseTime:0.151006s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  443. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099640s ]
  444. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 [ RunTime:0.104118s ]
  445. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.120869s ]
  446. ---------------------------------------------------------------
  447. [2023-12-22T18:05:16+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
  448. [ sql ] [ DB ] CONNECT:[ UseTime:0.158424s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  449. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.105518s ]
  450. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.102500s ]
  451. [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.109295s ]
  452. ---------------------------------------------------------------
  453. [2023-12-22T18:05:17+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
  454. [ sql ] [ DB ] CONNECT:[ UseTime:0.174934s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  455. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.098021s ]
  456. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.103979s ]
  457. [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.095300s ]
  458. ---------------------------------------------------------------
  459. [2023-12-22T18:05:19+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
  460. [ sql ] [ DB ] CONNECT:[ UseTime:0.160108s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  461. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.103414s ]
  462. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.114805s ]
  463. [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.104366s ]
  464. ---------------------------------------------------------------
  465. [2023-12-22T18:05:20+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
  466. [ sql ] [ DB ] CONNECT:[ UseTime:0.144180s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  467. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.100693s ]
  468. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.125116s ]
  469. [ sql ] [ SQL ] SELECT * FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.114290s ]
  470. ---------------------------------------------------------------
  471. [2023-12-22T18:05:26+08:00] 127.0.0.1 GET gaoyx.com/user/message/add.html?spm=m-64-175-301&open_type=modal
  472. [ sql ] [ DB ] CONNECT:[ UseTime:0.149022s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  473. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.098931s ]
  474. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.097475s ]
  475. [ sql ] [ SQL ] SELECT id,title,IF(id,'video',0) module FROM `dd_video_intro` WHERE `is_deleted` = 0 AND `status` = 1 ORDER BY `id` DESC [ RunTime:0.121208s ]
  476. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.100358s ]
  477. [ sql ] [ SQL ] SELECT `id`,`title`,`video_id` FROM `dd_video_url` WHERE `status` = 1 AND `is_deleted` = 0 AND `release_time` < '2023-12-22 18:05:21' AND `status` = 1 AND `video_id` IN (106,105,103,100,0) ORDER BY `sort` DESC [ RunTime:0.117419s ]
  478. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.106565s ]
  479. [ sql ] [ SQL ] SELECT id,title,IF(id,'datum',0) module FROM `dd_datum_intro` WHERE `is_deleted` = 0 ORDER BY `id` DESC [ RunTime:0.104647s ]
  480. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.100632s ]
  481. [ sql ] [ SQL ] SELECT `id`,`release_time`,`datum_id`,`user_id`,`title`,`url`,`is_encrypt`,`pdf_clear`,`sort`,`is_vip`,`transmit_num`,`down_num`,`read_num`,`is_down`,`comment_switch` FROM `dd_datum_url` WHERE `release_time` < '2023-12-22 18:05:21' AND `is_deleted` = 0 AND `status` = 1 AND `datum_id` IN (32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17) [ RunTime:0.118148s ]
  482. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.108577s ]
  483. [ sql ] [ SQL ] SELECT id,title,IF(id,'article',0) module FROM `dd_article_intro` WHERE `is_deleted` = 0 ORDER BY `id` ASC [ RunTime:0.111518s ]
  484. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.097003s ]
  485. [ sql ] [ SQL ] SELECT `id`,`article_id`,`title`,`video_id` FROM `dd_article_item` WHERE `is_deleted` = 0 AND `article_id` IN (47,48,49,50,53) ORDER BY `sort` DESC [ RunTime:0.123135s ]
  486. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.097995s ]
  487. [ sql ] [ SQL ] SELECT g.id,g.title,IF(g.id,'supplier',0) module FROM `dd_supplier` `g` WHERE `g`.`is_deleted` = 0 AND `status` = 1 [ RunTime:0.121317s ]
  488. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.099698s ]
  489. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 33 AND `g`.`status` = 1 [ RunTime:0.117166s ]
  490. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 34 AND `g`.`status` = 1 [ RunTime:0.098890s ]
  491. [ sql ] [ SQL ] SELECT g.id,g.supplier_id,g.name title,IF(g.id,'supplier',0) module FROM `dd_supplier_goods` `g` WHERE `g`.`is_deleted` = 0 AND `supplier_id` = 35 AND `g`.`status` = 1 [ RunTime:0.119442s ]
  492. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.096901s ]
  493. [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117121s ]
  494. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.098974s ]
  495. [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.120230s ]
  496. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.100743s ]
  497. [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.116773s ]
  498. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.107584s ]
  499. [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117208s ]
  500. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.099926s ]
  501. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.103575s ]
  502. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.096982s ]
  503. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.117103s ]
  504. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 [ RunTime:0.102575s ]
  505. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 34 [ RunTime:0.117388s ]
  506. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 35 [ RunTime:0.105475s ]
  507. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 36 [ RunTime:0.118024s ]
  508. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 37 [ RunTime:0.111036s ]
  509. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 40 [ RunTime:0.117406s ]
  510. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 41 [ RunTime:0.115070s ]
  511. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 42 [ RunTime:0.103442s ]
  512. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 43 [ RunTime:0.105056s ]
  513. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 44 [ RunTime:0.116454s ]
  514. [ sql ] [ SQL ] SELECT id,title,IF(id,'recruit',0) module FROM `dd_recruit` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 45 [ RunTime:0.115327s ]
  515. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.096005s ]
  516. [ sql ] [ SQL ] SELECT id,title,IF(id,'mall',0) module FROM `dd_goods_cate` WHERE `status` = 1 AND `is_deleted` = 0 AND `lev` = 3 [ RunTime:0.115290s ]
  517. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.094734s ]
  518. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 30 [ RunTime:0.117453s ]
  519. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 31 [ RunTime:0.114372s ]
  520. [ sql ] [ SQL ] SELECT id,name as title,IF(id,'mall',0) module FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.116223s ]
  521. ---------------------------------------------------------------
  522. [2023-12-25T11:08:23+08:00] 127.0.0.1 GET gaoyx.com/admin.html
  523. [ sql ] [ DB ] CONNECT:[ UseTime:0.149612s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  524. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.100554s ]
  525. [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.097277s ]
  526. ---------------------------------------------------------------
  527. [2023-12-25T11:08:24+08:00] 127.0.0.1 GET gaoyx.com/admin/login.html
  528. [ sql ] [ DB ] CONNECT:[ UseTime:0.175568s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  529. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.112935s ]
  530. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.723935s ]
  531. ---------------------------------------------------------------
  532. [2023-12-25T13:50:37+08:00] 127.0.0.1 GET gaoyx.com/admin/login.html
  533. [ sql ] [ DB ] CONNECT:[ UseTime:0.160756s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  534. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.112650s ]
  535. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:1.194055s ]
  536. ---------------------------------------------------------------
  537. [2023-12-25T13:50:42+08:00] 127.0.0.1 POST gaoyx.com/admin/login.html
  538. [ sql ] [ DB ] CONNECT:[ UseTime:0.155178s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  539. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.104730s ]
  540. [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `is_deleted` = 0 AND `username` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.104276s ]
  541. [ sql ] [ SQL ] UPDATE `dd_system_user` SET `login_ip` = '127.0.0.1' , `login_at` = now() , `login_num` = login_num+1 WHERE `id` = 10000 [ RunTime:0.103143s ]
  542. [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.107151s ]
  543. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_log` [ RunTime:0.102947s ]
  544. [ sql ] [ SQL ] INSERT INTO `dd_system_log` (`node` , `action` , `content` , `geoip` , `username`) VALUES ('admin/login/index' , '系统管理' , '用户登录系统后台成功' , '127.0.0.1' , 'admin') [ RunTime:0.126351s ]
  545. ---------------------------------------------------------------
  546. [2023-12-25T13:50:42+08:00] 127.0.0.1 GET gaoyx.com/admin.html
  547. [ sql ] [ DB ] CONNECT:[ UseTime:0.163946s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  548. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.116899s ]
  549. [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.117242s ]
  550. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.117488s ]
  551. [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.108402s ]
  552. ---------------------------------------------------------------
  553. [2023-12-25T13:50:43+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
  554. [ sql ] [ DB ] CONNECT:[ UseTime:0.159831s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  555. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.109709s ]
  556. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.103769s ]
  557. [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.112748s ]
  558. ---------------------------------------------------------------
  559. [2023-12-25T13:50:52+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176
  560. [ sql ] [ DB ] CONNECT:[ UseTime:0.158025s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  561. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.109739s ]
  562. [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.101865s ]
  563. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.106048s ]
  564. [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.099812s ]
  565. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.101027s ]
  566. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_member` `m` LEFT JOIN `dd_user_wallet` `w` ON `m`.`id`=`w`.`user_id` WHERE `m`.`is_deleted` = 0 [ RunTime:0.107155s ]
  567. [ sql ] [ SQL ] SELECT `m`.`id`,`m`.`openid`,`m`.`name`,`m`.`is_first`,`m`.`headimg`,`m`.`level_exp`,`m`.`phone`,`m`.`status`,`m`.`create_at`,`m`.`account_type`,`w`.`growth`,`w`.`integral`,`w`.`money`,`m`.`tag_id`,`label` FROM `dd_store_member` `m` LEFT JOIN `dd_user_wallet` `w` ON `m`.`id`=`w`.`user_id` WHERE `m`.`is_deleted` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.107943s ]
  568. [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.103271s ]
  569. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 517 LIMIT 1 [ RunTime:0.103609s ]
  570. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.103122s ]
  571. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 517 AND `r`.`end_time` > 1703483447 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120971s ]
  572. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 516 LIMIT 1 [ RunTime:0.102417s ]
  573. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 516 AND `r`.`end_time` > 1703483448 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.107101s ]
  574. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 515 LIMIT 1 [ RunTime:0.104776s ]
  575. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 515 AND `r`.`end_time` > 1703483448 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.121944s ]
  576. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 514 LIMIT 1 [ RunTime:0.102293s ]
  577. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 514 AND `r`.`end_time` > 1703483448 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.124170s ]
  578. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 513 LIMIT 1 [ RunTime:0.106973s ]
  579. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 513 AND `r`.`end_time` > 1703483448 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.106196s ]
  580. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 512 LIMIT 1 [ RunTime:0.104925s ]
  581. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 512 AND `r`.`end_time` > 1703483448 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.106590s ]
  582. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 511 LIMIT 1 [ RunTime:0.101311s ]
  583. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 511 AND `r`.`end_time` > 1703483449 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.107314s ]
  584. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 510 LIMIT 1 [ RunTime:0.103658s ]
  585. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 510 AND `r`.`end_time` > 1703483449 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120344s ]
  586. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 509 LIMIT 1 [ RunTime:0.100820s ]
  587. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 509 AND `r`.`end_time` > 1703483449 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120448s ]
  588. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 508 LIMIT 1 [ RunTime:0.100859s ]
  589. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 508 AND `r`.`end_time` > 1703483449 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.106461s ]
  590. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 507 LIMIT 1 [ RunTime:0.103769s ]
  591. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 507 AND `r`.`end_time` > 1703483449 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120745s ]
  592. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 506 LIMIT 1 [ RunTime:0.100969s ]
  593. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 506 AND `r`.`end_time` > 1703483450 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.124557s ]
  594. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 505 LIMIT 1 [ RunTime:0.100089s ]
  595. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 505 AND `r`.`end_time` > 1703483450 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.121311s ]
  596. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 504 LIMIT 1 [ RunTime:0.104838s ]
  597. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 504 AND `r`.`end_time` > 1703483450 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.104181s ]
  598. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 503 LIMIT 1 [ RunTime:0.102520s ]
  599. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 503 AND `r`.`end_time` > 1703483450 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.122299s ]
  600. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 502 LIMIT 1 [ RunTime:0.106102s ]
  601. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 502 AND `r`.`end_time` > 1703483451 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.122880s ]
  602. [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.100056s ]
  603. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 501 LIMIT 1 [ RunTime:0.105651s ]
  604. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 501 AND `r`.`end_time` > 1703483451 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.122227s ]
  605. [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.102601s ]
  606. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 500 LIMIT 1 [ RunTime:0.103473s ]
  607. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 500 AND `r`.`end_time` > 1703483451 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.123023s ]
  608. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 499 LIMIT 1 [ RunTime:0.113429s ]
  609. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 499 AND `r`.`end_time` > 1703483451 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.122325s ]
  610. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 498 LIMIT 1 [ RunTime:0.111459s ]
  611. [ sql ] [ SQL ] SELECT `r`.`id`,`r`.`level_id`,`r`.`end_time`,`r`.`end_date`,`l`.`name`,`l`.`logo`,`l`.`icons`,`r`.`user_id` FROM `dd_user_level_rank` `r` LEFT JOIN `dd_user_level` `l` ON `l`.`id`=`r`.`level_id` WHERE `r`.`user_id` = 498 AND `r`.`end_time` > 1703483452 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.102371s ]
  612. ---------------------------------------------------------------
  613. [2023-12-25T13:50:57+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
  614. [ sql ] [ DB ] CONNECT:[ UseTime:0.158665s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  615. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.108258s ]
  616. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.105109s ]
  617. [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.106971s ]
  618. ---------------------------------------------------------------
  619. [2023-12-25T13:51:00+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
  620. [ sql ] [ DB ] CONNECT:[ UseTime:0.153111s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  621. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.100721s ]
  622. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.103238s ]
  623. [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.102718s ]
  624. ---------------------------------------------------------------
  625. [2023-12-25T13:51:01+08:00] 127.0.0.1 GET gaoyx.com/nutrition/datum_cate/index.html?spm=m-140-165-166
  626. [ sql ] [ DB ] CONNECT:[ UseTime:0.159049s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  627. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_cate` [ RunTime:0.107013s ]
  628. [ sql ] [ SQL ] SELECT * FROM `dd_datum_cate` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.109939s ]
  629. ---------------------------------------------------------------
  630. [2023-12-25T13:51:03+08:00] 127.0.0.1 GET gaoyx.com/order/level_order/index.html?spm=m-150-253
  631. [ sql ] [ DB ] CONNECT:[ UseTime:0.160192s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  632. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_level_order` [ RunTime:0.111548s ]
  633. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_level_order` `o` LEFT JOIN `dd_store_member` `u` ON `o`.`user_id`=`u`.`id` LEFT JOIN `dd_user_level` `l` ON `o`.`level_id`=`l`.`id` WHERE `o`.`is_deleted` = 0 AND `o`.`cancel_state` = 0 AND `o`.`pay_state` = 1 [ RunTime:0.122944s ]
  634. [ sql ] [ SQL ] SELECT `o`.*,u.name u_name,u.phone u_phone,l.name level_name FROM `dd_level_order` `o` LEFT JOIN `dd_store_member` `u` ON `o`.`user_id`=`u`.`id` LEFT JOIN `dd_user_level` `l` ON `o`.`level_id`=`l`.`id` WHERE `o`.`is_deleted` = 0 AND `o`.`cancel_state` = 0 AND `o`.`pay_state` = 1 ORDER BY `o`.`id` DESC LIMIT 0,20 [ RunTime:0.122818s ]
  635. ---------------------------------------------------------------
  636. [2023-12-25T13:51:04+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
  637. [ sql ] [ DB ] CONNECT:[ UseTime:0.163253s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  638. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.104909s ]
  639. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.106373s ]
  640. [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.105812s ]
  641. ---------------------------------------------------------------
  642. [2023-12-25T13:51:54+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
  643. [ sql ] [ DB ] CONNECT:[ UseTime:0.163659s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  644. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.111568s ]
  645. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.106139s ]
  646. [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.112463s ]
  647. ---------------------------------------------------------------
  648. [2023-12-25T13:51:55+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
  649. [ sql ] [ DB ] CONNECT:[ UseTime:0.150008s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  650. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099457s ]
  651. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.119486s ]
  652. ---------------------------------------------------------------
  653. [2023-12-25T13:56:54+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList
  654. [ sql ] [ DB ] CONNECT:[ UseTime:0.158848s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  655. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.105977s ]
  656. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:1.002978s ]
  657. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.106471s ]
  658. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.104647s ]
  659. ---------------------------------------------------------------
  660. [2023-12-25T13:57:17+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList?third_classify=33
  661. [ sql ] [ DB ] CONNECT:[ UseTime:0.162475s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  662. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.105347s ]
  663. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.108680s ]
  664. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.101986s ]
  665. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` = 33 LIMIT 1 [ RunTime:0.103763s ]
  666. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.106613s ]
  667. [ sql ] [ SQL ] SELECT `id`,`name`,`label`,`sale_num`,`cover`,`specs` FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.105870s ]
  668. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 33 [ RunTime:0.108833s ]
  669. ---------------------------------------------------------------
  670. [2023-12-25T13:57:24+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList?third_classify=32
  671. [ sql ] [ DB ] CONNECT:[ UseTime:0.155468s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  672. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.104154s ]
  673. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.101508s ]
  674. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.103218s ]
  675. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` = 32 LIMIT 1 [ RunTime:0.100149s ]
  676. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.104571s ]
  677. [ sql ] [ SQL ] SELECT `id`,`name`,`label`,`sale_num`,`cover`,`specs` FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.105318s ]
  678. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.101174s ]
  679. ---------------------------------------------------------------
  680. [2023-12-25T14:05:56+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList?third_classify=32
  681. [ sql ] [ DB ] CONNECT:[ UseTime:0.163657s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
  682. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.108380s ]
  683. [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.997169s ]
  684. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.106603s ]
  685. [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.105232s ]
  686. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.106769s ]
  687. [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` = 32 LIMIT 1 [ RunTime:0.107927s ]
  688. [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.109621s ]
  689. [ sql ] [ SQL ] SELECT `id`,`name`,`label`,`sale_num`,`cover`,`specs` FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.109506s ]
  690. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.115093s ]