差不多
文件目录
程序流程
不正确的
SQL
校正
- 请求信息 : 2024-07-20 18:03:12 HTTP/1.0 GET : //aecreus.com/index/Tuan/info.html?cate=36&id=302
- 运行时间 : 0.371819s [ 吞吐率:2.69req/s ] 内存消耗:4,947.41kb 文件加载:239
- 查询信息 : 122 queries
- 缓存信息 : 0 reads,1 writes
- 会话信息 : SESSION_ID=972d692e9c29a024fb0aa9aa43d2c2b7
- CONNECT:[ UseTime:0.000775s ] mysql:host=localhost;port=3306;dbname=aoyang;charset=utf8mb4
- SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.003075s ]
- SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000957s ]
- SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.002034s ]
- SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000747s ]
- SHOW FULL COLUMNS FROM `tp_module` [ RunTime:0.001989s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000523s ]
- SELECT * FROM `tp_module` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000553s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000410s ]
- SELECT * FROM `tp_module` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000484s ]
- SELECT * FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000516s ]
- SELECT * FROM `tp_module` WHERE `id` = 53 LIMIT 1 [ RunTime:0.000504s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000529s ]
- SELECT * FROM `tp_module` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000525s ]
- SELECT * FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000583s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000482s ]
- SELECT * FROM `tp_module` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000428s ]
- SELECT * FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000431s ]
- SELECT * FROM `tp_module` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000395s ]
- SELECT * FROM `tp_module` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000388s ]
- SELECT * FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000409s ]
- SELECT * FROM `tp_module` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000438s ]
- SELECT * FROM `tp_module` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000409s ]
- SELECT * FROM `tp_module` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000551s ]
- SELECT * FROM `tp_module` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000557s ]
- SELECT * FROM `tp_module` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000554s ]
- SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000838s ]
- SELECT `module_id` FROM `tp_cate` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000495s ]
- SELECT `table_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000510s ]
- SHOW FULL COLUMNS FROM `tp_field` [ RunTime:0.002034s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 52 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001364s ]
- SELECT * FROM `tp_cate` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000871s ]
- SELECT `id`,`parent_id` FROM `tp_cate` [ RunTime:0.000423s ]
- SHOW FULL COLUMNS FROM `tp_tuan` [ RunTime:0.002035s ]
- UPDATE `tp_tuan` SET `hits` = `hits` + 1 WHERE `id` = 302 [ RunTime:0.002819s ]
- SELECT * FROM `tp_module` WHERE `table_name` = 'tuan' LIMIT 1 [ RunTime:0.000669s ]
- SELECT * FROM `tp_tuan` WHERE `id` = 302 LIMIT 1 [ RunTime:0.000676s ]
- SELECT * FROM `tp_module` WHERE `table_name` = 'tuan' LIMIT 1 [ RunTime:0.000750s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 52 ORDER BY `sort`,`id` DESC [ RunTime:0.001424s ]
- SHOW FULL COLUMNS FROM `tp_dictionary` [ RunTime:0.001798s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '2' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000565s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Cate' LIMIT 1 [ RunTime:0.000647s ]
- SELECT * FROM `tp_field` WHERE `module_id` = 20 AND `field` = 'sort' LIMIT 1 [ RunTime:0.001561s ]
- SELECT * FROM `tp_module` WHERE `model_name` = 'Cate' LIMIT 1 [ RunTime:0.000704s ]
- SELECT `id` FROM `tp_module` WHERE `model_name` = 'Cate' LIMIT 1 [ RunTime:0.000409s ]
- SELECT `field` FROM `tp_field` WHERE ( field = 'pid' OR field = 'parent_id' ) AND `module_id` = 20 LIMIT 1 [ RunTime:0.000719s ]
- SELECT `id`,`cate_name`,`parent_id` FROM `tp_cate` ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000667s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '2' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000656s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '1' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000425s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000406s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000473s ]
- SELECT `dict_value`,`dict_label` FROM `tp_dictionary` WHERE `dict_type` = '2' ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000554s ]
- SELECT `id`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000442s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000373s ]
- SELECT * FROM `tp_cate` WHERE `is_menu` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000970s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000482s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000438s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000439s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 14 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000670s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000412s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000463s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000430s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000413s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000457s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 15 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000648s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000447s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000423s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 16 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000749s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000444s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000440s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000415s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000368s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 17 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000617s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000629s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000580s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000438s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000465s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000386s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000460s ]
- SHOW FULL COLUMNS FROM `tp_link` [ RunTime:0.001776s ]
- SELECT * FROM `tp_link` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000585s ]
- SELECT * FROM `tp_cate` WHERE `is_menu` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000882s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000463s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000457s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000478s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 14 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000664s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000438s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000432s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000448s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000427s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000436s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 15 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000672s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000425s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000412s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 16 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000685s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000458s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000494s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000414s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000434s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 17 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000712s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000423s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000424s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000439s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000414s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000437s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000428s ]
- SELECT * FROM `tp_cate` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000579s ]
- SELECT * FROM `tp_cate` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000598s ]
- SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000603s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 16 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000805s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000475s ]
- SELECT * FROM `tp_cate` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000591s ]
- SELECT * FROM `tp_cate` [ RunTime:0.000791s ]
- SELECT * FROM `tp_cate` WHERE `parent_id` = 16 ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000680s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000430s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000418s ]
- SELECT * FROM `tp_cate` WHERE `is_menu` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000948s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000473s ]
- SELECT * FROM `tp_cate` WHERE `id` = 77 LIMIT 1 [ RunTime:0.000592s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000433s ]
- SELECT * FROM `tp_cate` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000566s ]
- SELECT `model_name` FROM `tp_module` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000443s ]
- SELECT * FROM `tp_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000551s ]