StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTo get MYSQL query execution time in Query
primarykey
Id
16434879
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-08T07:20:24.613
FavoriteCount
5
LastActivityDate
2016-01-26T21:28:27.790
LastEditDate
2013-05-14T13:12:15.660
LastEditorUserId
2090453
OwnerUserId
2090453
ParentId
0
PostTypeId
1
Score
7
ViewCount
26767
LastEditorDisplayName
text
Body
I am developing a query browser, working with some large database and I need to know the time taken for executing the query. I can see the time once the query is executed succesfully in PHPMYADMIN. Profiling or <code>Showing rows 0 - 29 (2,000 total, Query took 0.0145 sec)</code> Ex: Profiling <pre><code>SELECT * FROM `larger_table`; Status Time starting 0.000026 checking permissions 0.000006 Opening tables 0.000014 System lock 0.000010 init 0.000022 optimizing 0.000004 statistics 0.000007 preparing 0.000005 executing 0.000001 Sending data 0.014138 end 0.000004 query end 0.000002 closing tables 0.000005 freeing items 0.000091 logging slow query 0.000003 cleaning up 0.000002 </code></pre> In Query Browser I can see the time it takes in the bottom of the browser window. So how can I get the execution time of the query when submit the query for execution. i.e When I give the following query: <pre><code>SELECT * FROM `larger_table`; </code></pre> The query should return the time for execution it. This I should catch in PHP and show to the Users.When the user gives some query to executed in browser. Is there any way to find the execution time when the query is submitted.? Kindly check the Images where I marked the estimated time. <img src="https://i.stack.imgur.com/331Tg.png" alt="enter image description here"> <img src="https://i.stack.imgur.com/40zx8.png" alt="enter image description here"> I found some thing <a href="http://forums.mysql.com/read.php?108,51989,230038#msg-230038" rel="noreferrer">Check this</a>
Tags
<php><mysql><sql><database><phpmyadmin>
Title
To get MYSQL query execution time in Query
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTomPHP
UserOwnerUserId
1. USTomPHP
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POTo get MYSQL query execution time in Query
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POTo get MYSQL query execution time in Query
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POTo get MYSQL query execution time in Query
 UserUserId
 USTomPHP
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.