-
有宝贝
上海上海市闵行区
有宝贝
-
保证金
-
0
-
成立日期
-
2022-05-30
-
所在地
-
上海上海市闵行区
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-06-14 20:11:11 HTTP/1.1 GET : http://www.qdcyw.com/index/Index/brand_search.html?area=0&category_id=53&money=3
- 运行时间 : 0.209477s [ 吞吐率:4.77req/s ] 内存消耗:6,135.64kb 文件加载:245
- 查询信息 : 184 queries
- 缓存信息 : 0 reads,1 writes
- 会话信息 : SESSION_ID=0764793af70d6e3b5b7b47a9aa1b3263
- CONNECT:[ UseTime:0.000430s ] mysql:host=127.0.0.1;port=3306;dbname=www_qdcyw_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.000854s ]
- SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000356s ]
- SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000587s ]
- SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000210s ]
- SHOW FULL COLUMNS FROM `tp_module` [ RunTime:0.000526s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000220s ]
- SELECT * FROM `tp_module` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000184s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000171s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000174s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000146s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000154s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000172s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000154s ]
- SELECT * FROM `tp_module` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000164s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000167s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000160s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000155s ]
- SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000242s ]
- SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.000499s ]
- SELECT * FROM `tp_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort` DESC [ RunTime:0.000411s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 1 AND `status` = 1 [ RunTime:0.000634s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 32 AND `status` = 1 [ RunTime:0.000633s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 23 AND `status` = 1 [ RunTime:0.000583s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 286 AND `status` = 1 [ RunTime:0.000650s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 31 AND `status` = 1 [ RunTime:0.000705s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 33 AND `status` = 1 [ RunTime:0.000582s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 34 AND `status` = 1 [ RunTime:0.000551s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 35 AND `status` = 1 [ RunTime:0.000566s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 36 AND `status` = 1 [ RunTime:0.000551s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 325 AND `status` = 1 [ RunTime:0.000563s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 338 AND `status` = 1 [ RunTime:0.000556s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 357 AND `status` = 1 [ RunTime:0.000552s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 385 AND `status` = 1 [ RunTime:0.000543s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 394 AND `status` = 1 [ RunTime:0.000559s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 414 AND `status` = 1 [ RunTime:0.000559s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 421 AND `status` = 1 [ RunTime:0.000537s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 427 AND `status` = 1 [ RunTime:0.000530s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 434 AND `status` = 1 [ RunTime:0.000535s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 453 AND `status` = 1 [ RunTime:0.000550s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 469 AND `status` = 1 [ RunTime:0.000557s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 479 AND `status` = 1 [ RunTime:0.000541s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 483 AND `status` = 1 [ RunTime:0.000548s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 496 AND `status` = 1 [ RunTime:0.000545s ]
- SELECT * FROM `tp_category` WHERE `parent_id` = 249 AND `status` = 1 [ RunTime:0.000554s ]
- SHOW FULL COLUMNS FROM `tp_debris` [ RunTime:0.000608s ]
- SELECT * FROM `tp_debris` WHERE `status` = 1 ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000224s ]
- SELECT * FROM `tp_category` WHERE `status` = 1 AND `parent_id` = 0 [ RunTime:0.000573s ]
- SELECT * FROM `tp_category` WHERE `status` = 1 AND `id` = 53 LIMIT 1 [ RunTime:0.000207s ]
- SELECT * FROM `tp_category` WHERE `status` = 1 AND `parent_id` = 32 [ RunTime:0.000571s ]
- SHOW FULL COLUMNS FROM `tp_area` [ RunTime:0.000504s ]
- SELECT * FROM `tp_area` WHERE `pid` = 0 AND `id` NOT IN (3211,3212,3213) [ RunTime:0.001534s ]
- SELECT `id` FROM `tp_category` WHERE `status` = 1 AND `parent_id` = 53 [ RunTime:0.000288s ]
- SHOW FULL COLUMNS FROM `tp_shoper` [ RunTime:0.000665s ]
- SELECT COUNT(*) AS think_count FROM `tp_shoper` WHERE `status` = 1 AND `category_id` = 53 AND `tzje` = 3 LIMIT 1 [ RunTime:0.000348s ]
- SELECT * FROM `tp_shoper` WHERE `status` = 1 AND `category_id` = 53 AND `tzje` = 3 ORDER BY `sort` DESC LIMIT 0,50 [ RunTime:0.000514s ]
- SHOW FULL COLUMNS FROM `tp_dictionary` [ RunTime:0.000448s ]
- SELECT `dict_label` FROM `tp_dictionary` WHERE `dict_type` = '16' AND `dict_value` = '3' LIMIT 1 [ RunTime:0.000180s ]
- SELECT * FROM `tp_cate` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000242s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 [ RunTime:0.000177s ]
- SELECT * FROM `tp_cate` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000202s ]
- SELECT * FROM `tp_module` WHERE `id` = 29 [ RunTime:0.000185s ]
- SELECT * FROM `tp_cate` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000412s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000170s ]
- SELECT * FROM `tp_cate` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000184s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000168s ]
- SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000171s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000158s ]
- SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000163s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000141s ]
- SELECT * FROM `tp_cate` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000174s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000142s ]
- SELECT * FROM `tp_cate` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000159s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000143s ]
- SELECT * FROM `tp_cate` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000162s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000140s ]
- SELECT * FROM `tp_cate` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000175s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000142s ]
- SELECT * FROM `tp_cate` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000158s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000142s ]
- SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000215s ]
- SELECT * FROM `tp_area` WHERE `id` = 780 LIMIT 1 [ RunTime:0.000202s ]
- SELECT * FROM `tp_area` WHERE `id` = 3218 LIMIT 1 [ RunTime:0.000143s ]
- SELECT * FROM `tp_area` WHERE `id` = 788 LIMIT 1 [ RunTime:0.000190s ]
- SELECT * FROM `tp_cate` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000179s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000160s ]
- SELECT `id`,`parent_id` FROM `tp_cate` [ RunTime:0.000170s ]
- SHOW FULL COLUMNS FROM `tp_article` [ RunTime:0.000661s ]
- SELECT COUNT(*) AS think_count FROM `tp_article` WHERE ( status = 1 ) AND `cate_id` IN (4,15,16,17,18) LIMIT 1 [ RunTime:0.000804s ]
- SELECT * FROM `tp_article` WHERE ( status = 1 ) AND `cate_id` IN (4,15,16,17,18) ORDER BY `create_time` DESC LIMIT 0,15 [ RunTime:0.000933s ]
- SELECT * FROM `tp_cate` WHERE `id` = 4 [ RunTime:0.000202s ]
- SELECT * FROM `tp_cate` WHERE `id` = 4 [ RunTime:0.000159s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000147s ]
- SHOW FULL COLUMNS FROM `tp_field` [ RunTime:0.000547s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000585s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000163s ]
- SHOW FULL COLUMNS FROM `tp_dictionary_type` [ RunTime:0.000416s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000173s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '1' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000229s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Cate' LIMIT 1 [ RunTime:0.000176s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 20 AND `field` = 'sort' LIMIT 1 [ RunTime:0.000342s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Cate' LIMIT 1 [ RunTime:0.000182s ]
- SELECT `id` FROM `tp_module` WHERE `model_name` = 'Cate' LIMIT 1 [ RunTime:0.000121s ]
- SELECT `field` FROM `tp_field` WHERE ( field = 'pid' OR field = 'parent_id' ) AND `module_id` = 20 LIMIT 1 [ RunTime:0.000182s ]
- SELECT `id`,`cate_name`,`parent_id` FROM `tp_cate` ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000155s ]
- SELECT `id` FROM `tp_cate` WHERE `module_id` = 19 [ RunTime:0.000156s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'UsersType' LIMIT 1 [ RunTime:0.000156s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 6 AND `field` = 'sort' LIMIT 1 [ RunTime:0.000377s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'UsersType' LIMIT 1 [ RunTime:0.000217s ]
- SELECT `id` FROM `tp_module` WHERE `model_name` = 'UsersType' LIMIT 1 [ RunTime:0.000136s ]
- SELECT `field` FROM `tp_field` WHERE ( field = 'pid' OR field = 'parent_id' ) AND `module_id` = 6 LIMIT 1 [ RunTime:0.000312s ]
- SHOW FULL COLUMNS FROM `tp_users_type` [ RunTime:0.000593s ]
- SELECT `id`,`name` FROM `tp_users_type` ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000138s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Shoper' LIMIT 1 [ RunTime:0.000234s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 28 AND `field` = 'sort' LIMIT 1 [ RunTime:0.000536s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Shoper' LIMIT 1 [ RunTime:0.000193s ]
- SELECT `id` FROM `tp_module` WHERE `model_name` = 'Shoper' LIMIT 1 [ RunTime:0.000142s ]
- SELECT `field` FROM `tp_field` WHERE ( field = 'pid' OR field = 'parent_id' ) AND `module_id` = 28 LIMIT 1 [ RunTime:0.000282s ]
- SELECT `id`,`ppmc` FROM `tp_shoper` ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000728s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '13' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000217s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Category' LIMIT 1 [ RunTime:0.000316s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 27 AND `field` = 'sort' LIMIT 1 [ RunTime:0.000674s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Category' LIMIT 1 [ RunTime:0.000273s ]
- SELECT `id` FROM `tp_module` WHERE `model_name` = 'Category' LIMIT 1 [ RunTime:0.000192s ]
- SELECT `field` FROM `tp_field` WHERE ( field = 'pid' OR field = 'parent_id' ) AND `module_id` = 27 LIMIT 1 [ RunTime:0.000316s ]
- SELECT `id`,`cate_name`,`parent_id` FROM `tp_category` ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000845s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.001044s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000372s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000320s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000996s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000270s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000273s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000903s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000393s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000237s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000660s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000199s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000188s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000656s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000175s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000182s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000593s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000187s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000203s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000624s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000184s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000202s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000664s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000230s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000212s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000623s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000178s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000168s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000640s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000165s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000183s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000582s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000170s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000160s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000587s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000164s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000179s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000581s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000173s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000161s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000591s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000166s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000180s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 19 [ RunTime:0.000573s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 [ RunTime:0.000173s ]
- SELECT * FROM `tp_dictionary_type` WHERE `id` IN (0,1,13) [ RunTime:0.000168s ]
- SHOW FULL COLUMNS FROM `tp_link` [ RunTime:0.000608s ]
- SELECT * FROM `tp_link` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000200s ]
- SELECT * FROM `tp_cate` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000200s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 [ RunTime:0.000149s ]
- SELECT * FROM `tp_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000182s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 [ RunTime:0.000155s ]
- SELECT * FROM `tp_cate` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000173s ]
- SELECT * FROM `tp_module` WHERE `id` = 29 [ RunTime:0.000157s ]
- SELECT * FROM `tp_cate` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000175s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 [ RunTime:0.000142s ]
- SELECT * FROM `tp_cate` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000170s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 [ RunTime:0.000150s ]
- SELECT * FROM `tp_cate` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000174s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 [ RunTime:0.000148s ]
0.215881s