Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

怎么把程序文件中的所有sql语句及每句sql语句的运行时间显示出来

WBOY
Release： 2016-06-13 13:44:11
Original
956 people have browsed it

如何把程序文件中的所有sql语句及每句sql语句的运行时间显示出来？
php+mysql



------解决方案--------------------
如果你是要分析sql运行情况，
那么看mysql手册的“The Slow Query Log”一节吧，
然后分析log文件就行



------解决方案--------------------
数据库连接类里面的调试模式吧

好像adodb有
------解决方案--------------------
可以考虑下phpbb3中的代码

Related labels：
log mysql query sql
source：php.cn
Previous article： 新型ORM queryphp框架简介和教程入门解决办法 Next article： 怎么取得路径返回父目录呢
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
sql groupby not working, I want to group by code_branch ->select('a.statusasstatus','b.nameascustomer_name','e.nameasbranch_name','c.nameas...
From 2024-04-06 19:24:49
0
2
488
Record query under partial value conditions - SQL skill sharing I have a table called zipcode which has a column called code. The Code column contains the...
From 2024-04-06 16:01:26
0
1
395
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template