|
______________________________________________________________________ 001 ___
|
|
Count : 40 (50.00%)
|
|
Time : 2 s total, 50 ms avg, 0 to 1 s max (66.67%)
|
|
95% of Time : 0 total, 0 avg, 0 to 0 max
|
|
Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
|
|
95% of Lock : 0 total, 0 avg, 0 to 0 max
|
|
Rows sent : 13 avg, 0 to 127 max (92.61%)
|
|
Rows examined : 14.89k avg, 14.88k to 15.01k max (50.02%)
|
|
Database :
|
|
Users :
|
|
typo3_dbu@ 192.168.1.14 : 100.00% (40) of query, 100.00% (80) of all users
|
|
|
|
Query abstract:
|
|
SELECT * FROM cache_extensions WHERE N=N AND extkey LIKE 'S' AND reviewstate >= N AND state!=N ORDER BY category, title LIMIT N,N;
|
|
|
|
Query sample:
|
|
SELECT *
|
|
FROM cache_extensions
|
|
WHERE
|
|
1=1 AND extkey LIKE '%aboutmodules%' AND reviewstate >= 0 AND state!=5
|
|
ORDER BY category, title
|
|
LIMIT 0,500;
|
|
|
|
______________________________________________________________________ 002 ___
|
|
Count : 40 (50.00%)
|
|
Time : 1 s total, 25 ms avg, 0 to 1 s max (33.33%)
|
|
95% of Time : 0 total, 0 avg, 0 to 0 max
|
|
Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
|
|
95% of Lock : 0 total, 0 avg, 0 to 0 max
|
|
Rows sent : 1 avg, 1 to 1 max (7.39%)
|
|
Rows examined : 14.88k avg, 14.88k to 14.88k max (49.98%)
|
|
Database : typo3
|
|
Users :
|
|
typo3_dbu@ 192.168.1.14 : 100.00% (40) of query, 100.00% (80) of all users
|
|
|
|
Query abstract:
|
|
SELECT COUNT(*) AS cnt FROM cache_extensions WHERE N=N AND extkey LIKE 'S' AND reviewstate >= N AND state!=N;
|
|
|
|
Query sample:
|
|
SELECT count(*) as cnt
|
|
FROM cache_extensions
|
|
WHERE
|
|
1=1 AND extkey LIKE '%aboutmodules%' AND reviewstate >= 0 AND state!=5;
|
