123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587 |
- ---------------------------------------------------------------
- [2023-12-22T17:52:26+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153397s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.103277s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.119193s ]
- [ 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 ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.156802s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.107809s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_label_message` WHERE `id` = 229 LIMIT 1 [ RunTime:0.102580s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.105971s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.105193s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.105362s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.108957s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.104891s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.103560s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.104231s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.103218s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.101848s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.105498s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.101347s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.123458s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.102384s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.104709s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.102441s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.102983s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.106575s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.102989s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.132019s ]
- [ 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 ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151438s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.101993s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.099833s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.098710s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.101626s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.100167s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.098241s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.099103s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.099562s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.103304s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.103075s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.121482s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.099963s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.099792s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.099764s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.120526s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.098834s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117678s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.098228s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.104456s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.099244s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T17:56:08+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153206s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.095284s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.343259s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.095993s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.093102s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.108305s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:4.294390s ]
- ---------------------------------------------------------------
- [2023-12-22T17:56:09+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
- [ sql ] [ DB ] CONNECT:[ UseTime:0.177155s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.141225s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.119126s ]
- [ 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 ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.160534s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.152643s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.109111s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.371633s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.125549s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.104143s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.108125s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.114746s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.117014s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.103558s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.104460s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.115408s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.106859s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.104596s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.106467s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.123180s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.105086s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.119346s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.107694s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.110240s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.109943s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T17:56:52+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.170516s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.106131s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.114394s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T17:56:53+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.162889s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.100785s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.098742s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.101275s ]
- ---------------------------------------------------------------
- [2023-12-22T17:56:56+08:00] 127.0.0.1 GET gaoyx.com/nutrition/datum_cate/index.html?spm=m-140-165-166
- [ sql ] [ DB ] CONNECT:[ UseTime:0.178055s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_cate` [ RunTime:0.103274s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_datum_cate` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.104506s ]
- ---------------------------------------------------------------
- [2023-12-22T17:56:58+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.157394s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.102233s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.097873s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T17:56:58+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
- [ sql ] [ DB ] CONNECT:[ UseTime:0.152211s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.101918s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.107819s ]
- ---------------------------------------------------------------
- [2023-12-22T18:00:10+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.152778s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.104698s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.115006s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.108304s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.111216s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.104799s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.752650s ]
- ---------------------------------------------------------------
- [2023-12-22T18:00:11+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
- [ sql ] [ DB ] CONNECT:[ UseTime:0.161324s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.108564s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.105611s ]
- ---------------------------------------------------------------
- [2023-12-22T18:00:12+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153991s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.107249s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.106483s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.103450s ]
- ---------------------------------------------------------------
- [2023-12-22T18:00:15+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
- [ sql ] [ DB ] CONNECT:[ UseTime:0.152255s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.104066s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.122039s ]
- [ 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 ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.166217s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.109245s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.108786s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.113219s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.109527s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.110809s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.112708s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.111464s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.111240s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.111398s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.112221s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.112303s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.110836s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.111288s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.110428s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.110219s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.111337s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.108479s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.108968s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.110765s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.112876s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.117512s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T18:01:18+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.160679s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.112028s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.105224s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.106495s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.108514s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.107118s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.749779s ]
- ---------------------------------------------------------------
- [2023-12-22T18:01:19+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
- [ sql ] [ DB ] CONNECT:[ UseTime:0.147815s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.099487s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.115396s ]
- [ 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 ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.319383s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.102519s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.098677s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.101168s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.100409s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.099440s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.099197s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.097804s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.098429s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.099513s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.098155s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.118238s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.098057s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117473s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.099850s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.116845s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.098131s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117202s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.100100s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.096880s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099453s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.097941s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T18:02:31+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151841s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.100685s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.098635s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T18:02:33+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
- [ sql ] [ DB ] CONNECT:[ UseTime:0.146704s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099966s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.117813s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.141770s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.094115s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 [ RunTime:0.113299s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.113871s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.156082s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.102812s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 [ RunTime:0.100105s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.100870s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.148716s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.100657s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 [ RunTime:0.117273s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.117998s ]
- ---------------------------------------------------------------
- [2023-12-22T18:02:40+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
- [ sql ] [ DB ] CONNECT:[ UseTime:0.148235s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.098155s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.118864s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.157954s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.112001s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 [ RunTime:0.103443s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.104193s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.161024s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.108260s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 [ RunTime:0.105063s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.104957s ]
- ---------------------------------------------------------------
- [2023-12-22T18:04:13+08:00] 127.0.0.1 GET gaoyx.com/mall/store_goods/index.html?spm=m-136-283-285
- [ sql ] [ DB ] CONNECT:[ UseTime:0.146546s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.100697s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_goods` WHERE `is_deleted` = 0 [ RunTime:0.097273s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_goods` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.293896s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.098975s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods_item` [ RunTime:0.098039s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-22T18:04:14+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149132s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099653s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.119160s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.150447s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.100046s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 [ RunTime:0.120911s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 28 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.100471s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149696s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099676s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 [ RunTime:0.117448s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 29 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.122775s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153916s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.103343s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.147562s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.095771s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:1.092432s ]
- ---------------------------------------------------------------
- [2023-12-22T18:04:28+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
- [ sql ] [ DB ] CONNECT:[ UseTime:0.147970s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.098647s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.119649s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.159115s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.105715s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 [ RunTime:0.107568s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 26 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.102727s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.163599s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.104545s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 [ RunTime:0.104048s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.103674s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153165s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.103215s ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149864s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.100400s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.099215s ]
- [ 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 ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151006s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099640s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 [ RunTime:0.104118s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 27 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.120869s ]
- ---------------------------------------------------------------
- [2023-12-22T18:05:16+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158424s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.105518s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.102500s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.109295s ]
- ---------------------------------------------------------------
- [2023-12-22T18:05:17+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.174934s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.098021s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.103979s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.095300s ]
- ---------------------------------------------------------------
- [2023-12-22T18:05:19+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.160108s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.103414s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.114805s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.104366s ]
- ---------------------------------------------------------------
- [2023-12-22T18:05:20+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
- [ sql ] [ DB ] CONNECT:[ UseTime:0.144180s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.100693s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.125116s ]
- [ 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 ]
- ---------------------------------------------------------------
- [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
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149022s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.098931s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_intro` [ RunTime:0.097475s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_video_url` [ RunTime:0.100358s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_intro` [ RunTime:0.106565s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_url` [ RunTime:0.100632s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_intro` [ RunTime:0.108577s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_article_item` [ RunTime:0.097003s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier` [ RunTime:0.097995s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_supplier_goods` [ RunTime:0.099698s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_press` [ RunTime:0.096901s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'press',0) module FROM `dd_press` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117121s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.098974s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'activity',0) module FROM `dd_activity` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.120230s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.100743s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'forum',0) module FROM `dd_user_forum` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.116773s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.107584s ]
- [ sql ] [ SQL ] SELECT id,title,IF(id,'demand',0) module FROM `dd_platform_demand` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.117208s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit_cate` [ RunTime:0.099926s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.096982s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.096005s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.094734s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T11:08:23+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149612s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.100554s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.097277s ]
- ---------------------------------------------------------------
- [2023-12-25T11:08:24+08:00] 127.0.0.1 GET gaoyx.com/admin/login.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.175568s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.112935s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.723935s ]
- ---------------------------------------------------------------
- [2023-12-25T13:50:37+08:00] 127.0.0.1 GET gaoyx.com/admin/login.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.160756s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.112650s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:1.194055s ]
- ---------------------------------------------------------------
- [2023-12-25T13:50:42+08:00] 127.0.0.1 POST gaoyx.com/admin/login.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.155178s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.104730s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `is_deleted` = 0 AND `username` = 'admin' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.104276s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.107151s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_log` [ RunTime:0.102947s ]
- [ sql ] [ SQL ] INSERT INTO `dd_system_log` (`node` , `action` , `content` , `geoip` , `username`) VALUES ('admin/login/index' , '系统管理' , '用户登录系统后台成功' , '127.0.0.1' , 'admin') [ RunTime:0.126351s ]
- ---------------------------------------------------------------
- [2023-12-25T13:50:42+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.163946s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.116899s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.117242s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.117488s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.108402s ]
- ---------------------------------------------------------------
- [2023-12-25T13:50:43+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.159831s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.109709s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.103769s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.112748s ]
- ---------------------------------------------------------------
- [2023-12-25T13:50:52+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158025s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.109739s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.101865s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.106048s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.099812s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.101027s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.103271s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 517 LIMIT 1 [ RunTime:0.103609s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.103122s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 516 LIMIT 1 [ RunTime:0.102417s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 515 LIMIT 1 [ RunTime:0.104776s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 514 LIMIT 1 [ RunTime:0.102293s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 513 LIMIT 1 [ RunTime:0.106973s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 512 LIMIT 1 [ RunTime:0.104925s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 511 LIMIT 1 [ RunTime:0.101311s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 510 LIMIT 1 [ RunTime:0.103658s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 509 LIMIT 1 [ RunTime:0.100820s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 508 LIMIT 1 [ RunTime:0.100859s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 507 LIMIT 1 [ RunTime:0.103769s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 506 LIMIT 1 [ RunTime:0.100969s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 505 LIMIT 1 [ RunTime:0.100089s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 504 LIMIT 1 [ RunTime:0.104838s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 503 LIMIT 1 [ RunTime:0.102520s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 502 LIMIT 1 [ RunTime:0.106102s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.100056s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 501 LIMIT 1 [ RunTime:0.105651s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.102601s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 500 LIMIT 1 [ RunTime:0.103473s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 499 LIMIT 1 [ RunTime:0.113429s ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 498 LIMIT 1 [ RunTime:0.111459s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T13:50:57+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158665s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.108258s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.105109s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.106971s ]
- ---------------------------------------------------------------
- [2023-12-25T13:51:00+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153111s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.100721s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.103238s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T13:51:01+08:00] 127.0.0.1 GET gaoyx.com/nutrition/datum_cate/index.html?spm=m-140-165-166
- [ sql ] [ DB ] CONNECT:[ UseTime:0.159049s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_cate` [ RunTime:0.107013s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_datum_cate` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.109939s ]
- ---------------------------------------------------------------
- [2023-12-25T13:51:03+08:00] 127.0.0.1 GET gaoyx.com/order/level_order/index.html?spm=m-150-253
- [ sql ] [ DB ] CONNECT:[ UseTime:0.160192s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_level_order` [ RunTime:0.111548s ]
- [ 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 ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T13:51:04+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.163253s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.104909s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.106373s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.105812s ]
- ---------------------------------------------------------------
- [2023-12-25T13:51:54+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.163659s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.111568s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.106139s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T13:51:55+08:00] 127.0.0.1 GET gaoyx.com/mall/goods_cate/index.html?spm=m-136-283-284
- [ sql ] [ DB ] CONNECT:[ UseTime:0.150008s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.099457s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `is_deleted` = 0 AND `pid` = 0 ORDER BY `id` DESC,`id` ASC [ RunTime:0.119486s ]
- ---------------------------------------------------------------
- [2023-12-25T13:56:54+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158848s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.105977s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:1.002978s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.106471s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.104647s ]
- ---------------------------------------------------------------
- [2023-12-25T13:57:17+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList?third_classify=33
- [ sql ] [ DB ] CONNECT:[ UseTime:0.162475s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.105347s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.108680s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.101986s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` = 33 LIMIT 1 [ RunTime:0.103763s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.106613s ]
- [ 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 ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T13:57:24+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList?third_classify=32
- [ sql ] [ DB ] CONNECT:[ UseTime:0.155468s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.104154s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.101508s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.103218s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` = 32 LIMIT 1 [ RunTime:0.100149s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.104571s ]
- [ 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 ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T14:05:56+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList?third_classify=32
- [ sql ] [ DB ] CONNECT:[ UseTime:0.163657s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.108380s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.997169s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.106603s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.105232s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.106769s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` = 32 LIMIT 1 [ RunTime:0.107927s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.109621s ]
- [ 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 ]
- [ 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 ]
- ---------------------------------------------------------------
- [2023-12-25T14:06:11+08:00] 127.0.0.1 POST gaoyx.com/api/Mall/getGoodsList?third_classify=32
- [ sql ] [ DB ] CONNECT:[ UseTime:0.159358s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.113070s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.127032s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_goods_cate` [ RunTime:0.101226s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_goods_cate` WHERE `id` = 32 LIMIT 1 [ RunTime:0.098648s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_goods` [ RunTime:0.097232s ]
- [ 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.102414s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_goods` WHERE `status` = 1 AND `is_deleted` = 0 AND `third_classify` = 32 [ RunTime:0.121913s ]
- ---------------------------------------------------------------
- [2023-12-25T17:52:10+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.150352s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.100008s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.100134s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.102695s ]
- ---------------------------------------------------------------
- [2023-12-25T17:52:56+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154489s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.099985s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.099760s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.099112s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.103302s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.106292s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.741499s ]
- ---------------------------------------------------------------
- [2023-12-25T17:52:57+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151691s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.101256s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.098713s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.099971s ]
- ---------------------------------------------------------------
- [2023-12-25T17:53:39+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.156561s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.105876s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.103180s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.106969s ]
- ---------------------------------------------------------------
- [2023-12-25T17:56:29+08:00] 127.0.0.1 GET gaoyx.com/synth/bill_type/index.html?spm=m-307-308-309
- [ sql ] [ DB ] CONNECT:[ UseTime:0.150889s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_type` [ RunTime:0.099936s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_bill_type` WHERE `is_deleted` = 0 ORDER BY `sort` DESC [ RunTime:0.097298s ]
- ---------------------------------------------------------------
- [2023-12-25T17:57:46+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151665s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.100454s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.102467s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.102554s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.099692s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.100175s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.763641s ]
- ---------------------------------------------------------------
- [2023-12-25T17:57:47+08:00] 127.0.0.1 GET gaoyx.com/synth/bill_type/index.html?spm=m-307-308-309
- [ sql ] [ DB ] CONNECT:[ UseTime:0.165834s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_type` [ RunTime:0.108791s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_bill_type` WHERE `is_deleted` = 0 ORDER BY `sort` DESC [ RunTime:0.106254s ]
- ---------------------------------------------------------------
- [2023-12-25T17:58:37+08:00] 127.0.0.1 GET gaoyx.com/synth/bill_type/index.html?spm=m-307-308-309
- [ sql ] [ DB ] CONNECT:[ UseTime:0.164797s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_type` [ RunTime:0.107604s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_bill_type` WHERE `is_deleted` = 0 ORDER BY `sort` DESC [ RunTime:0.107172s ]
- ---------------------------------------------------------------
- [2023-12-25T17:59:38+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158948s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.105323s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.107211s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.106058s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.122792s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.106678s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.736145s ]
- ---------------------------------------------------------------
- [2023-12-25T17:59:38+08:00] 127.0.0.1 GET gaoyx.com/synth/bill_type/index.html?spm=m-307-308-309
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151809s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_type` [ RunTime:0.104529s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_bill_type` WHERE `is_deleted` = 0 ORDER BY `sort` DESC [ RunTime:0.100214s ]
- ---------------------------------------------------------------
- [2023-12-25T18:00:27+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.168775s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.108706s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.107786s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.107503s ]
- ---------------------------------------------------------------
- [2023-12-25T18:04:11+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.147996s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.098812s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.097572s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.097253s ]
- ---------------------------------------------------------------
- [2023-12-25T18:16:43+08:00] 127.0.0.1 GET gaoyx.com/operate/contact/index.html?spm=m-277-280-298
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151220s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_contact` [ RunTime:0.102595s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_contact` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.099156s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_contact` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` ASC LIMIT 0,20 [ RunTime:0.103480s ]
- ---------------------------------------------------------------
- [2023-12-25T18:17:12+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154160s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.104597s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.098681s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.098654s ]
- ---------------------------------------------------------------
- [2023-12-25T18:18:12+08:00] 127.0.0.1 GET gaoyx.com/nutrition/datum_cate/index.html?spm=m-140-165-166
- [ sql ] [ DB ] CONNECT:[ UseTime:0.150060s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_cate` [ RunTime:0.100331s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_datum_cate` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.098525s ]
- ---------------------------------------------------------------
- [2023-12-25T18:18:14+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.159231s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.105275s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.104033s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.113357s ]
- ---------------------------------------------------------------
- [2023-12-25T18:18:19+08:00] 127.0.0.1 GET gaoyx.com/operate/forum/index.html?spm=m-277-278-279
- [ sql ] [ DB ] CONNECT:[ UseTime:0.161189s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.104318s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.105679s ]
- [ sql ] [ SQL ] SELECT f.*,u.name,u.phone,u.headimg,IFNULL((SELECT count(r.id) reply_num FROM dd_forum_reply as r where r.forum_id = f.id AND r.is_deleted = 0),0) reply_num FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.103940s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.106236s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.772942s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_forum_reply_comment` [ RunTime:0.105886s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 64 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103688s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 89 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102925s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 88 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103272s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 87 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102634s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 86 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.105231s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 85 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.104838s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 84 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103192s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 83 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.104338s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 82 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.104193s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 81 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102123s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 80 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103597s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 79 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.107070s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 78 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.124162s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 77 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.107446s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 76 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103398s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 75 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103184s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 74 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102746s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 73 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102296s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 72 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103912s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 68 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103066s ]
- ---------------------------------------------------------------
- [2023-12-25T18:18:55+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.146739s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.100935s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.096446s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.096848s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.095687s ]
- ---------------------------------------------------------------
- [2023-12-25T18:18:58+08:00] 127.0.0.1 GET gaoyx.com/operate/forum/index.html?spm=m-277-278-279
- [ sql ] [ DB ] CONNECT:[ UseTime:0.155897s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.106346s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.101886s ]
- [ sql ] [ SQL ] SELECT f.*,u.name,u.phone,u.headimg,IFNULL((SELECT count(r.id) reply_num FROM dd_forum_reply as r where r.forum_id = f.id AND r.is_deleted = 0),0) reply_num FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.102134s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_forum_reply_comment` [ RunTime:0.101860s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 64 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.111347s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 89 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121116s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 88 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122779s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 87 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103866s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 86 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.110834s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 85 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120868s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 84 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121005s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 83 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.115041s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 82 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120804s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 81 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.110423s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 80 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.123553s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 79 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121182s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 78 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120388s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 77 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122020s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 76 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121487s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 75 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121130s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 74 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120282s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 73 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102455s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 72 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122273s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 68 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.105268s ]
- ---------------------------------------------------------------
- [2023-12-25T18:20:16+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154318s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.103263s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.101369s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.102049s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.100699s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.103550s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.753044s ]
- ---------------------------------------------------------------
- [2023-12-25T18:20:19+08:00] 127.0.0.1 GET gaoyx.com/operate/forum/index.html?spm=m-277-278-279
- [ sql ] [ DB ] CONNECT:[ UseTime:0.156857s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.101201s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.099831s ]
- [ sql ] [ SQL ] SELECT f.*,u.name,u.phone,u.headimg,IFNULL((SELECT count(r.id) reply_num FROM dd_forum_reply as r where r.forum_id = f.id AND r.is_deleted = 0),0) reply_num FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.102335s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_forum_reply_comment` [ RunTime:0.099823s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 64 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120284s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 89 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121405s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 88 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.110010s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 87 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120583s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 86 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120117s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 85 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119884s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 84 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120693s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 83 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119800s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 82 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121523s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 81 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119931s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 80 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.100671s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 79 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120888s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 78 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.123866s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 77 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119459s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 76 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119939s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 75 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121568s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 74 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119641s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 73 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119629s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 72 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119091s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 68 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119948s ]
- ---------------------------------------------------------------
- [2023-12-25T18:20:49+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154311s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.104942s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.102097s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.101204s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.102412s ]
- ---------------------------------------------------------------
- [2023-12-25T18:20:52+08:00] 127.0.0.1 GET gaoyx.com/operate/forum/index.html?spm=m-277-278-279
- [ sql ] [ DB ] CONNECT:[ UseTime:0.151109s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.100492s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.099919s ]
- [ sql ] [ SQL ] SELECT f.*,u.name,u.phone,u.headimg,IFNULL((SELECT count(r.id) reply_num FROM dd_forum_reply as r where r.forum_id = f.id AND r.is_deleted = 0),0) reply_num FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.099713s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_forum_reply_comment` [ RunTime:0.098782s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 64 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119892s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 89 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.109207s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 88 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.118594s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 87 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120141s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 86 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119817s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 85 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119783s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 84 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121734s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 83 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119157s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 82 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.105586s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 81 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121037s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 80 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120853s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 79 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119328s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 78 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120237s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 77 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.118297s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 76 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119072s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 75 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120219s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 74 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120280s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 73 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.100011s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 72 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121071s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 68 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.119003s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:16+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.143478s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.095279s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.093418s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.093383s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:21+08:00] 127.0.0.1 GET gaoyx.com/nutrition/datum_cate/index.html?spm=m-140-165-166
- [ sql ] [ DB ] CONNECT:[ UseTime:0.155869s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_cate` [ RunTime:0.102763s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_datum_cate` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.102398s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:26+08:00] 127.0.0.1 GET gaoyx.com/order/level_order/index.html?spm=m-150-253
- [ sql ] [ DB ] CONNECT:[ UseTime:0.152180s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_level_order` [ RunTime:0.104481s ]
- [ 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.110969s ]
- [ 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.120988s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:31+08:00] 127.0.0.1 GET gaoyx.com/synth/bill_type/index.html?spm=m-307-308-309
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154822s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_type` [ RunTime:0.107181s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_bill_type` WHERE `is_deleted` = 0 ORDER BY `sort` DESC [ RunTime:0.101867s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:37+08:00] 127.0.0.1 GET gaoyx.com/admin/config/info.html?spm=m-2-4-11
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153291s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.104557s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.770893s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:40+08:00] 127.0.0.1 GET gaoyx.com/nutrition/datum_cate/index.html?spm=m-140-165-166
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158104s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_datum_cate` [ RunTime:0.102696s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_datum_cate` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.102201s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:41+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.156959s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.106348s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.104444s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.103999s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:42+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.147712s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.098485s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.097502s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.098058s ]
- ---------------------------------------------------------------
- [2023-12-25T18:22:45+08:00] 127.0.0.1 GET gaoyx.com/operate/forum/index.html?spm=m-277-278-279
- [ sql ] [ DB ] CONNECT:[ UseTime:0.156441s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.102928s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.101362s ]
- [ sql ] [ SQL ] SELECT f.*,u.name,u.phone,u.headimg,IFNULL((SELECT count(r.id) reply_num FROM dd_forum_reply as r where r.forum_id = f.id AND r.is_deleted = 0),0) reply_num FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.104660s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_forum_reply_comment` [ RunTime:0.104163s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 64 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122222s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 89 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121857s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 88 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.123091s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 87 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122398s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 86 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102663s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 85 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.123334s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 84 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.107576s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 83 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.104470s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 82 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.123935s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 81 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.104077s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 80 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.124395s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 79 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102786s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 78 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.123183s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 77 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102731s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 76 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.106025s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 75 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102877s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 74 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102493s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 73 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102945s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 72 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103989s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 68 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.102849s ]
- ---------------------------------------------------------------
- [2023-12-26T08:39:55+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.182979s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.104673s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.116000s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.103314s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.104565s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.105551s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.316630s ]
- ---------------------------------------------------------------
- [2023-12-26T08:39:58+08:00] 127.0.0.1 GET gaoyx.com/operate/forum/index.html?spm=m-277-278-279
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158260s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_forum` [ RunTime:0.104573s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.100521s ]
- [ sql ] [ SQL ] SELECT f.*,u.name,u.phone,u.headimg,IFNULL((SELECT count(r.id) reply_num FROM dd_forum_reply as r where r.forum_id = f.id AND r.is_deleted = 0),0) reply_num FROM `dd_user_forum` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.104250s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_forum_reply_comment` [ RunTime:0.101213s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 64 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.101205s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 89 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121892s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 88 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121740s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 87 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.104903s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 86 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.127089s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 85 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.111521s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 84 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.109559s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 83 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.108442s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 82 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121772s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 81 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.106180s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 80 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121465s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 79 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.101743s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 78 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121037s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 77 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.113997s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 76 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122881s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 75 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.103767s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 74 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.121426s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 73 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122979s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 72 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.122453s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_forum_reply_comment` WHERE `forum_id` = 68 AND `reply_id` = 0 AND `is_deleted` < 2 [ RunTime:0.120677s ]
- ---------------------------------------------------------------
- [2023-12-26T10:21:51+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.167262s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.097272s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.098152s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.098699s ]
- ---------------------------------------------------------------
- [2023-12-26T10:21:58+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176
- [ sql ] [ DB ] CONNECT:[ UseTime:0.166194s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.103916s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.106536s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.110070s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.106494s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.104598s ]
- [ 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.102696s ]
- [ 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.101942s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.103865s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 520 LIMIT 1 [ RunTime:0.106898s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.103751s ]
- [ 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` = 520 AND `r`.`end_time` > 1703557314 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.115468s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 519 LIMIT 1 [ RunTime:0.104678s ]
- [ 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` = 519 AND `r`.`end_time` > 1703557314 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.103990s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 518 LIMIT 1 [ RunTime:0.105859s ]
- [ 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` = 518 AND `r`.`end_time` > 1703557314 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.108115s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 517 LIMIT 1 [ RunTime:0.108490s ]
- [ 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` > 1703557314 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.102791s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 516 LIMIT 1 [ RunTime:0.103723s ]
- [ 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` > 1703557314 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.104641s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 515 LIMIT 1 [ RunTime:0.104921s ]
- [ 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` > 1703557315 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.122565s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 514 LIMIT 1 [ RunTime:0.113260s ]
- [ 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` > 1703557315 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.121853s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 513 LIMIT 1 [ RunTime:0.101218s ]
- [ 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` > 1703557315 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.121395s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 512 LIMIT 1 [ RunTime:0.106073s ]
- [ 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` > 1703557315 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.123219s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 511 LIMIT 1 [ RunTime:0.104324s ]
- [ 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` > 1703557316 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.104286s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 510 LIMIT 1 [ RunTime:0.105836s ]
- [ 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` > 1703557316 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.106429s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 509 LIMIT 1 [ RunTime:0.102013s ]
- [ 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` > 1703557316 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.123183s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 508 LIMIT 1 [ RunTime:0.101720s ]
- [ 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` > 1703557316 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.105227s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 507 LIMIT 1 [ RunTime:0.102034s ]
- [ 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` > 1703557316 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.103002s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 506 LIMIT 1 [ RunTime:0.099678s ]
- [ 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` > 1703557317 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.105777s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 505 LIMIT 1 [ RunTime:0.101827s ]
- [ 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` > 1703557317 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.126540s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 504 LIMIT 1 [ RunTime:0.101622s ]
- [ 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` > 1703557317 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.104553s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 503 LIMIT 1 [ RunTime:0.102855s ]
- [ 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` > 1703557317 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.106813s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 502 LIMIT 1 [ RunTime:0.112789s ]
- [ 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` > 1703557318 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.107330s ]
- [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.102506s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 501 LIMIT 1 [ RunTime:0.105657s ]
- [ 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` > 1703557318 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.123160s ]
- [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.100333s ]
- ---------------------------------------------------------------
- [2023-12-26T10:22:02+08:00] 127.0.0.1 GET gaoyx.com/user/member/facility.html?user_id=520&spm=m-64-175-176&open_type=modal
- [ sql ] [ DB ] CONNECT:[ UseTime:0.157499s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_facility` [ RunTime:0.112511s ]
- [ sql ] [ SQL ] SELECT `type`,`facility` FROM `dd_user_facility` WHERE `user_id` = 520 [ RunTime:0.101417s ]
- ---------------------------------------------------------------
- [2023-12-26T10:22:14+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176&name=&phone=18905497965&create_at=&account_type=0&level_id=0&label_id=0
- [ sql ] [ DB ] CONNECT:[ UseTime:0.162979s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.103240s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.101921s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.109530s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.102049s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.104936s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) [ RunTime:0.107712s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.365705s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.103438s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 479 LIMIT 1 [ RunTime:0.106184s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.104493s ]
- [ 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` = 479 AND `r`.`end_time` > 1703557334 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.105966s ]
- ---------------------------------------------------------------
- [2023-12-26T10:22:16+08:00] 127.0.0.1 GET gaoyx.com/user/member/facility.html?user_id=479&spm=m-64-175-176&open_type=modal
- [ sql ] [ DB ] CONNECT:[ UseTime:0.170538s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_facility` [ RunTime:0.112611s ]
- [ sql ] [ SQL ] SELECT `type`,`facility` FROM `dd_user_facility` WHERE `user_id` = 479 [ RunTime:0.109430s ]
- ---------------------------------------------------------------
- [2023-12-26T10:22:21+08:00] 127.0.0.1 POST gaoyx.com/user/member/facility.html?user_id=479&spm=m-64-175-176&open_type=modal
- [ sql ] [ DB ] CONNECT:[ UseTime:0.254370s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_facility` [ RunTime:0.102281s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_facility` WHERE `user_id` = 479 AND `type` = 1 LIMIT 1 [ RunTime:0.118480s ]
- [ sql ] [ SQL ] UPDATE `dd_user_facility` SET `user_id` = 479 , `type` = 1 , `facility` = '' , `set_time` = '2023-12-26 10:22:19' WHERE `user_id` = 479 AND `type` = 1 [ RunTime:0.107608s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_facility` WHERE `user_id` = 479 AND `type` = 2 LIMIT 1 [ RunTime:0.122524s ]
- [ sql ] [ SQL ] UPDATE `dd_user_facility` SET `user_id` = 479 , `type` = 2 , `facility` = '' , `set_time` = '2023-12-26 10:22:20' WHERE `user_id` = 479 AND `type` = 2 [ RunTime:0.120574s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_facility` WHERE `user_id` = 479 AND `type` = 3 LIMIT 1 [ RunTime:0.101400s ]
- [ sql ] [ SQL ] UPDATE `dd_user_facility` SET `user_id` = 479 , `type` = 3 , `facility` = '' , `set_time` = '2023-12-26 10:22:21' WHERE `user_id` = 479 AND `type` = 3 [ RunTime:0.121116s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_facility` WHERE `user_id` = 479 AND `type` = 4 LIMIT 1 [ RunTime:0.100781s ]
- [ sql ] [ SQL ] UPDATE `dd_user_facility` SET `user_id` = 479 , `type` = 4 , `facility` = '' , `set_time` = '2023-12-26 10:22:21' WHERE `user_id` = 479 AND `type` = 4 [ RunTime:0.102062s ]
- ---------------------------------------------------------------
- [2023-12-26T10:22:25+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176&name=&phone=18905497965&create_at=&account_type=0&level_id=0&label_id=0
- [ sql ] [ DB ] CONNECT:[ UseTime:0.173700s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.109262s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.106375s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.112133s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.109389s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.106526s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) [ RunTime:0.110835s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.110754s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.106695s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 479 LIMIT 1 [ RunTime:0.117061s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.107958s ]
- [ 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` = 479 AND `r`.`end_time` > 1703557345 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.130175s ]
- ---------------------------------------------------------------
- [2023-12-26T10:22:43+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149283s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.100225s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.097928s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.098281s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.098942s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.097221s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.315277s ]
- ---------------------------------------------------------------
- [2023-12-26T10:22:44+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176&name=&phone=18905497965&create_at=&account_type=0&level_id=0&label_id=0
- [ sql ] [ DB ] CONNECT:[ UseTime:0.144563s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.092881s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.093920s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.093411s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.095553s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.096165s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) [ RunTime:0.114325s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.113452s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.093196s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 479 LIMIT 1 [ RunTime:0.093407s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.095982s ]
- [ 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` = 479 AND `r`.`end_time` > 1703557364 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.116296s ]
- ---------------------------------------------------------------
- [2023-12-26T10:23:30+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.155991s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.105117s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.100599s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.100900s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.099355s ]
- ---------------------------------------------------------------
- [2023-12-26T10:23:31+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176&name=&phone=18905497965&create_at=&account_type=0&level_id=0&label_id=0
- [ sql ] [ DB ] CONNECT:[ UseTime:0.152638s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.100944s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.105113s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.100180s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.099440s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.106285s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) [ RunTime:0.101808s ]
- [ 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 AND ( `m`.`phone` LIKE '%18905497965%' OR `m`.`email` LIKE '%18905497965%' ) ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.119635s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.121500s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 479 LIMIT 1 [ RunTime:0.102323s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.100637s ]
- [ 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` = 479 AND `r`.`end_time` > 1703557411 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.121951s ]
- ---------------------------------------------------------------
- [2023-12-26T10:23:40+08:00] 127.0.0.1 GET gaoyx.com/user/member/index.html?spm=m-64-175-176&name=&phone=&create_at=&account_type=0&level_id=0&label_id=0
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153577s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_tag` [ RunTime:0.101423s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_user_tag` [ RunTime:0.100015s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level` [ RunTime:0.101735s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.101350s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.101089s ]
- [ 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.101419s ]
- [ 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.102376s ]
- [ sql ] [ SQL ] SELECT `id`,`name` FROM `dd_user_level` [ RunTime:0.099669s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 520 LIMIT 1 [ RunTime:0.100132s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_level_rank` [ RunTime:0.103478s ]
- [ 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` = 520 AND `r`.`end_time` > 1703557415 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.102748s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 519 LIMIT 1 [ RunTime:0.100768s ]
- [ 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` = 519 AND `r`.`end_time` > 1703557416 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.119481s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 518 LIMIT 1 [ RunTime:0.103057s ]
- [ 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` = 518 AND `r`.`end_time` > 1703557416 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.102341s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 517 LIMIT 1 [ RunTime:0.102943s ]
- [ 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` > 1703557416 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120880s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 516 LIMIT 1 [ RunTime:0.102356s ]
- [ 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` > 1703557416 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.121640s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 515 LIMIT 1 [ RunTime:0.099393s ]
- [ 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` > 1703557417 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.101528s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 514 LIMIT 1 [ RunTime:0.102780s ]
- [ 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` > 1703557417 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.121348s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 513 LIMIT 1 [ RunTime:0.103521s ]
- [ 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` > 1703557417 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.102573s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 512 LIMIT 1 [ RunTime:0.099330s ]
- [ 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` > 1703557417 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.119893s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 511 LIMIT 1 [ RunTime:0.098704s ]
- [ 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` > 1703557417 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.107325s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 510 LIMIT 1 [ RunTime:0.101898s ]
- [ 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` > 1703557418 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.106261s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 509 LIMIT 1 [ RunTime:0.098992s ]
- [ 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` > 1703557418 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.099545s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 508 LIMIT 1 [ RunTime:0.103550s ]
- [ 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` > 1703557418 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.117041s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 507 LIMIT 1 [ RunTime:0.112966s ]
- [ 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` > 1703557418 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.122111s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 506 LIMIT 1 [ RunTime:0.103123s ]
- [ 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` > 1703557418 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.102693s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 505 LIMIT 1 [ RunTime:0.100783s ]
- [ 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` > 1703557419 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120262s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 504 LIMIT 1 [ RunTime:0.099225s ]
- [ 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` > 1703557419 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.100773s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 503 LIMIT 1 [ RunTime:0.102590s ]
- [ 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` > 1703557419 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.101964s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 502 LIMIT 1 [ RunTime:0.106548s ]
- [ 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` > 1703557419 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120566s ]
- [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.098908s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `bind_id` = 501 LIMIT 1 [ RunTime:0.098163s ]
- [ 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` > 1703557420 ORDER BY `r`.`level_id` DESC LIMIT 1 [ RunTime:0.120944s ]
- [ sql ] [ SQL ] SELECT `title` FROM `dd_user_tag` WHERE `id` = 7 [ RunTime:0.097598s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:12+08:00] 127.0.0.1 GET gaoyx.com/user/message/index.html?spm=m-64-175-301
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154334s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_label_message` [ RunTime:0.103742s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_label_message` WHERE `type` IN (2,3) AND `is_deleted` = 0 [ RunTime:0.121546s ]
- [ 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.103807s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:13+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.157819s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.106808s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.103409s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.103298s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:14+08:00] 127.0.0.1 GET gaoyx.com/order/level_order/index.html?spm=m-150-253
- [ sql ] [ DB ] CONNECT:[ UseTime:0.159665s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_level_order` [ RunTime:0.105371s ]
- [ 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.105847s ]
- [ 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.107285s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:16+08:00] 127.0.0.1 GET gaoyx.com/mall/express_company/index.html?spm=m-136-196-200
- [ sql ] [ DB ] CONNECT:[ UseTime:0.152925s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_express_company` [ RunTime:0.097943s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_express_company` WHERE `is_deleted` = 0 [ RunTime:0.102930s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_express_company` WHERE `is_deleted` = 0 ORDER BY `status` DESC,`sort` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.101318s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:17+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.161327s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.105929s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.100993s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.102987s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:18+08:00] 127.0.0.1 GET gaoyx.com/operate/cover/index.html?spm=m-277-280-300
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153452s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_cover` [ RunTime:0.102060s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_cover` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.099042s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_cover` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` ASC LIMIT 0,20 [ RunTime:0.101543s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:20+08:00] 127.0.0.1 GET gaoyx.com/operate/contact/index.html?spm=m-277-280-298
- [ sql ] [ DB ] CONNECT:[ UseTime:0.164154s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_contact` [ RunTime:0.110385s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_contact` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.101653s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_contact` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` ASC LIMIT 0,20 [ RunTime:0.101108s ]
- ---------------------------------------------------------------
- [2023-12-26T11:21:25+08:00] 127.0.0.1 GET gaoyx.com/operate/cover/index.html?spm=m-277-280-300
- [ sql ] [ DB ] CONNECT:[ UseTime:0.163006s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_cover` [ RunTime:0.105701s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_cover` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.104082s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_cover` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` ASC LIMIT 0,20 [ RunTime:0.104829s ]
- ---------------------------------------------------------------
- [2023-12-26T11:22:27+08:00] 127.0.0.1 POST gaoyx.com/api/Expedite/getModulesCover?tag=search
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154042s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.102966s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:1.187016s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.103630s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 495 LIMIT 1 [ RunTime:0.101430s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_cover` [ RunTime:0.101970s ]
- [ sql ] [ SQL ] SELECT `tag`,`cover`,`place` FROM `dd_cover` WHERE `tag` = 'search' [ RunTime:0.101275s ]
- ---------------------------------------------------------------
- [2023-12-26T11:22:39+08:00] 127.0.0.1 GET gaoyx.com/operate/cover/edit.html?id=11&spm=m-277-280-300&open_type=modal
- [ sql ] [ DB ] CONNECT:[ UseTime:0.163275s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_cover` [ RunTime:0.135199s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_cover` WHERE `id` = 11 LIMIT 1 [ RunTime:0.139694s ]
- ---------------------------------------------------------------
- [2023-12-26T14:03:39+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.159250s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.108788s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.105590s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.105941s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.105415s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.104564s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.748637s ]
- ---------------------------------------------------------------
- [2023-12-26T14:03:40+08:00] 127.0.0.1 GET gaoyx.com/user/group/index.html?spm=m-64-175-254
- [ sql ] [ DB ] CONNECT:[ UseTime:0.144329s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_user_group` [ RunTime:0.095014s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_user_group` [ RunTime:0.096192s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_user_group` ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.099532s ]
- ---------------------------------------------------------------
- [2023-12-26T14:03:41+08:00] 127.0.0.1 GET gaoyx.com/mall/banner/index.html?spm=m-277-280-197
- [ sql ] [ DB ] CONNECT:[ UseTime:0.157104s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_banner` [ RunTime:0.104099s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_store_banner` WHERE `is_deleted` = 0 [ RunTime:0.106296s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_banner` WHERE `is_deleted` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 0,20 [ RunTime:0.101389s ]
- ---------------------------------------------------------------
- [2023-12-26T14:03:45+08:00] 127.0.0.1 GET gaoyx.com/operate/recruit/index.html?spm=m-277-289-291
- [ sql ] [ DB ] CONNECT:[ UseTime:0.160193s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.103974s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.105258s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.367374s ]
- ---------------------------------------------------------------
- [2023-12-26T14:07:16+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149998s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.101742s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.102778s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.101278s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.103329s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.097479s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.745861s ]
- ---------------------------------------------------------------
- [2023-12-26T14:07:17+08:00] 127.0.0.1 GET gaoyx.com/operate/recruit/index.html?spm=m-277-289-291
- [ sql ] [ DB ] CONNECT:[ UseTime:0.153371s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.102671s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.103115s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.400197s ]
- ---------------------------------------------------------------
- [2023-12-26T14:07:56+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.145652s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.099781s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.093665s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.095568s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.098645s ]
- ---------------------------------------------------------------
- [2023-12-26T14:07:57+08:00] 127.0.0.1 GET gaoyx.com/operate/recruit/index.html?spm=m-277-289-291
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154195s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.101130s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.100508s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.407216s ]
- ---------------------------------------------------------------
- [2023-12-26T14:08:20+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154400s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.100300s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.098419s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.098860s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.098079s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.103087s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.775983s ]
- ---------------------------------------------------------------
- [2023-12-26T14:08:21+08:00] 127.0.0.1 GET gaoyx.com/operate/recruit/index.html?spm=m-277-289-291
- [ sql ] [ DB ] CONNECT:[ UseTime:0.149575s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.100134s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.098410s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.410615s ]
- ---------------------------------------------------------------
- [2023-12-26T14:08:59+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.164833s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.113431s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.105675s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.106205s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.103963s ]
- ---------------------------------------------------------------
- [2023-12-26T14:09:00+08:00] 127.0.0.1 GET gaoyx.com/operate/recruit/index.html?spm=m-277-289-291
- [ sql ] [ DB ] CONNECT:[ UseTime:0.164237s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.118181s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.109978s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.359614s ]
- ---------------------------------------------------------------
- [2023-12-26T14:09:26+08:00] 127.0.0.1 GET gaoyx.com/operate/activity/index.html?spm=m-277-287-288
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158186s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity_sponsor` [ RunTime:0.108051s ]
- [ sql ] [ SQL ] SELECT `id`,`title`,`is_deleted`,`status` FROM `dd_activity_sponsor` WHERE `status` = 1 AND `is_deleted` = 0 [ RunTime:0.103391s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_activity` [ RunTime:0.106464s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_activity` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.105249s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_activity` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.105774s ]
- ---------------------------------------------------------------
- [2023-12-26T14:09:32+08:00] 127.0.0.1 GET gaoyx.com/operate/recruit/index.html?spm=m-277-289-291
- [ sql ] [ DB ] CONNECT:[ UseTime:0.154287s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_recruit` [ RunTime:0.139976s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 [ RunTime:0.125368s ]
- [ sql ] [ SQL ] SELECT `f`.* FROM `dd_recruit` `f` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.366193s ]
- ---------------------------------------------------------------
- [2023-12-26T14:09:34+08:00] 127.0.0.1 GET gaoyx.com/operate/platform_demand/index.html?spm=m-277-292-297
- [ sql ] [ DB ] CONNECT:[ UseTime:0.156148s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.108454s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_platform_demand` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.103476s ]
- [ sql ] [ SQL ] SELECT `f`.*,`u`.`name`,`u`.`phone`,`u`.`headimg` FROM `dd_platform_demand` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.156001s ]
- ---------------------------------------------------------------
- [2023-12-26T14:10:29+08:00] 127.0.0.1 GET gaoyx.com/admin.html
- [ sql ] [ DB ] CONNECT:[ UseTime:0.158912s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_user` [ RunTime:0.107055s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_user` WHERE `id` = 10000 LIMIT 1 [ RunTime:0.104555s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_menu` [ RunTime:0.106019s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_system_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.102691s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.104337s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.826672s ]
- ---------------------------------------------------------------
- [2023-12-26T14:10:30+08:00] 127.0.0.1 GET gaoyx.com/operate/platform_demand/index.html?spm=m-277-292-297
- [ sql ] [ DB ] CONNECT:[ UseTime:0.162209s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_platform_demand` [ RunTime:0.104169s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_platform_demand` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 [ RunTime:0.105226s ]
- [ sql ] [ SQL ] SELECT `f`.*,`u`.`name`,`u`.`phone`,`u`.`headimg` FROM `dd_platform_demand` `f` LEFT JOIN `dd_store_member` `u` ON `u`.`id`=`f`.`user_id` WHERE `f`.`is_deleted` = 0 ORDER BY `sort` DESC,`f`.`id` DESC LIMIT 0,20 [ RunTime:0.154577s ]
- ---------------------------------------------------------------
- [2023-12-26T14:11:06+08:00] 127.0.0.1 GET gaoyx.com/synth/bill_type/index.html?spm=m-307-308-309
- [ sql ] [ DB ] CONNECT:[ UseTime:0.155097s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_type` [ RunTime:0.104934s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_bill_type` WHERE `is_deleted` = 0 ORDER BY `sort` DESC [ RunTime:0.101372s ]
- ---------------------------------------------------------------
- [2023-12-26T14:11:08+08:00] 127.0.0.1 GET gaoyx.com/synth/bill_apply/index.html?spm=m-307-308-324
- [ sql ] [ DB ] CONNECT:[ UseTime:0.161308s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_type` [ RunTime:0.107102s ]
- [ sql ] [ SQL ] SELECT `id`,`title` FROM `dd_bill_type` WHERE `is_deleted` = 0 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.107397s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_bill_apply` [ RunTime:0.111586s ]
- [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `dd_bill_apply` `i` LEFT JOIN `dd_store_member` `m` ON `m`.`id`=`i`.`user_id` LEFT JOIN `dd_level_order` `l` ON `l`.`id`=`i`.`order_id` LEFT JOIN `dd_store_order` `s` ON `s`.`id`=`i`.`order_id` LEFT JOIN `dd_activity_apply` `a` ON `a`.`id`=`i`.`order_id` LEFT JOIN `dd_bill_type` `b` ON `b`.`id`=`i`.`type` [ RunTime:0.107768s ]
- [ sql ] [ SQL ] SELECT `i`.*,b.title type_name,`m`.`headimg`,m.name as user_name,`m`.`phone`,`l`.`order_no` FROM `dd_bill_apply` `i` LEFT JOIN `dd_store_member` `m` ON `m`.`id`=`i`.`user_id` LEFT JOIN `dd_level_order` `l` ON `l`.`id`=`i`.`order_id` LEFT JOIN `dd_store_order` `s` ON `s`.`id`=`i`.`order_id` LEFT JOIN `dd_activity_apply` `a` ON `a`.`id`=`i`.`order_id` LEFT JOIN `dd_bill_type` `b` ON `b`.`id`=`i`.`type` ORDER BY `i`.`id` DESC LIMIT 0,20 [ RunTime:0.109446s ]
- ---------------------------------------------------------------
- [2023-12-26T14:16:03+08:00] 127.0.0.1 POST gaoyx.com/api/Expedite/getTotalMarkNum
- [ sql ] [ DB ] CONNECT:[ UseTime:0.155531s ] mysql:host=120.79.86.50;port=3306;dbname=gaoyixia_hdlkeji;charset=utf8mb4
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_system_config` [ RunTime:0.117007s ]
- [ sql ] [ SQL ] SELECT `name`,`value` FROM `dd_system_config` [ RunTime:0.793720s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `dd_store_member` [ RunTime:0.103389s ]
- [ sql ] [ SQL ] SELECT * FROM `dd_store_member` WHERE `id` = 1566 LIMIT 1 [ RunTime:0.101522s ]
|