| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='staging' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='staging' AND status='1' | /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() () |
| SELECT * FROM categories WHERE seo=? | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories WHERE seo=? | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategoryInfoFromTypeSeo() |
| SELECT * FROM categories WHERE parentid=90 | 1 | SELECT CATID FROM categories WHERE parentid=90 | /opt/clerks-staging/docroot/include/functions/main.php 6366 GetCategoryChildString() () |
| SELECT * FROM categories WHERE parentid=90 ORDER BY total_items DESC LIMIT 8 | 1 | SELECT
name,
image_name,
seo,
h2header,
metatitle
FROM categories
WHERE parentid=90
ORDER BY total_items DESC
LIMIT 8 | /opt/clerks-staging/docroot/include/functions/main.php 6426 GetCategoryChild() () |
| SELECT * FROM categories WHERE CATID='42' | 1 | SELECT CATID, seo, name, h2header, metatitle, metakeywords, metadescription, metaheader, image_name FROM categories WHERE CATID='42' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM query_cache WHERE query= ? LIMIT 1 | 1 | SELECT `value`, `last_checked`
FROM query_cache
WHERE query= ?
LIMIT 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() queryCache() |
| SELECT * from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (90) AND gtags like'%y%' AND type !=99 | 1 | SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (90) AND gtags like'%y%' AND type !=99 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() queryCache() |
| INSERT INTO query_cache ( `query`, `value`, `request_count`, `last_checked`, `time_added` ) VALUES (?, ?, 1, UNIX_TIMESTAMP(NOW()), UNIX_TIMESTAMP(NOW())) | 1 | INSERT INTO query_cache
(
`query`, `value`, `request_count`, `last_checked`, `time_added`
)
VALUES (?, ?, 1, UNIX_TIMESTAMP(NOW()), UNIX_TIMESTAMP(NOW()))
| /opt/clerks-staging/docroot/include/functions/includes/cache.php 316 queryCache() () |
| SELECT * from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (90) AND gtags like'%y%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40 | 1 | SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (90) AND gtags like'%y%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (90) AND gtags like'%y%' AND type !=99 AND A.feat=1 | 1 | SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (90) AND gtags like'%y%' AND type !=99 AND A.feat=1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| SELECT * FROM promotions as p WHERE p.date_expire > UNIX_TIMESTAMP(NOW()) AND p.date_added < UNIX_TIMESTAMP(NOW()) ORDER BY p.date_added DESC | 1 | SELECT p.*
FROM promotions as p
WHERE p.date_expire > UNIX_TIMESTAMP(NOW())
AND p.date_added < UNIX_TIMESTAMP(NOW())
ORDER BY p.date_added DESC
| /opt/clerks-staging/docroot/index.php 2756 () () |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM categories WHERE parentid = 0 | 1 | SELECT *
FROM categories
WHERE parentid = 0
| /opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
| 0.415982 | 1 | SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (84) AND gtags like'%Homepageseo%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40 | 0.415982 | 0.415982 |
| 0.395112 | 1 | SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (90) AND gtags like'%y%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40 | 0.395112 | 0.395112 |
| 0.226374 | 1 | SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID | 0.226374 | 0.226374 |
| 0.206872 | 1 | SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (90) AND gtags like'%y%' AND type !=99 | 0.206872 | 0.206872 |
| 0.054204 | 1 | SELECT `value`, `last_checked` FROM query_cache WHERE query= ? LIMIT 1 | 0.054204 | 0.054204 |
| 0.052070 | 1 | SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.quesid IN (22533,22513,22569,22484,22516,22557,22445,22592,22593,22480,22566,22598,22545,22620,22604,22588,22582,12810,22542,22584,22625,22585,22626,22567,22529,22606,22624,22559,22610,22637,22586,22596,22643,22577,22639,22168,22687,22628,22640,22675,22583,22595,22649,22660,22581,22776,22655,22661,22528,22654,22827,22820,22774,22851,22803,22664,22839,11189,22817,22735,11200,11179,18956,17054,3484,22689,22877,22883,22835,22852,22836,22666,15973,15937,22605,22885,18003,21736,17095,10945,11029,10970,22894,19765,2970,22920,10382,21964,15831,10045,1891,5974,13494,22919,22912,22913,11249,11215,2373,9890,22923,5505,7142,21936,22318,5375,14116,2840,5272,5216,11262,20778,22941,22945,22880,22911,21744,22953,9874,13835,18450,22938,22937,22916,22959,2098,21459,22936,22308,22964,21031,3037,3062,18871,22453,16985,5801,2368,18132,14133,17081,1852,14348,1122,19748,2245,10139,2168,4984,14361,1804,22933,22989,14027,22965,15075,11434,10231,23024,23022,20001,2524,20467,15651,18779,1433,16793,1886,21715,5300,304,16772,3241,18736,20595,21847,6095,2331,2454,15716,16346,16037,23004,22932,20849,15161,19179,2485,2535,3154,10296,6219,23058,19770,20365,15538,15118,19263,21634,23025,13033,18168,12785,20969,12798,17650,18649,12788,13934,16808,19978,20902,10020,19148,11256,11024,1970,18629,15663,13633,3710,1902,20956,22837,19345,10105,12793,23085,23014,19253,15862,2775,9880,15561,16669,5179,17041,13632,9910,19342,16454,2077,11250,3327,13969,3033,19628,15655,14577,14356,15904,6963,16747,16860,14183,15376,2894,16934,17038,5478,17035,653,1787,18079,16969,23071,23072,23115,21982,11271,6802,22682,23114,2730,10760,17077,23012,23148,16043,7278,12842,13483,18783,13310,9971,22285,23135,23146,14852,21773,23138,6448,20144,21984,15426,19870,3288,13525,23174,23171,17013,23175,4348,23182,23167,2645,6284,14584,1903,23134,20674,17917,19235,10680,1896,14459,3158,23120,22888,23172,7826,11420,20473,14897,23140,23035,18857,11276,11209,17776,23189,12918,12898,18557,6757,13616,170,23216,6176,15974,4985,16091,23201,9912,5217,20970,12805,4534,23212,15509,23210,12681,11653,10268,13047,12890,20888,2973,23205,650,20271,10113,2668,13942,23241,12884,20831,20532,23042,21772,17887,10288,12826,18945,17745,1012,11173,5381,2600,17076,18672,16742,20206,16834,17645,5161,23280,22402,23285,23284,15142,21689,20869,16584,23283,23008,19548,10910,11127,9916,19763,23271,16682,2799,23204,23323,3249,9876,2634,1953,343,1767,23133,194,15280,15806,9931,21884,413,19298,16247,15940,2591,3017,2947,14528,22108,15722,1805,23305,23152,19336,23337,23355,17798,23354,23347,14153,23345,23343,15730,21883,7133,23372,18975,17713,17521,23365,1856,2432,23362,1828,23376,23359,2818,602,12806,14660,18620,23386,23389,23385,20854,23409,12895,19427,6189,18566,14181,2611,7030,16762,3069,23394,20167,16453,18022,16540,15399,23421,23420,23419,23415,23416,23430,23408,23357,23448,10800,23443,23439,14259,16519,16494,23418,15500,5855,23395,23449,23470,23457,23454,23478,13300,16718,10261,18535,21789,5422,4784,17655,23503,23496,13960,14028,23494,23515,23508,23523,23498,19009,10905,21641,10556,6209,6580,3811,23621,5970,18745,19555,10360,18020,22417,23790,11338,23788,72,16263,16290,23786,16439,16382,23783,11232,19405,11226,11240,2593,2263,13533,10068,6132,17108,16924,16820,5197,17556,2594,16915,16910,23798,16842,23793,18249,23782,23781,23776,23487,16975,23813,23800,16333,13489,13492,11246,20400,2495,1303,16972,13607,17057,22301,17654,11227,14493,2478,3676,342,2242,1846,3223,13517,13606,20934,13542,17862,17819,23830,16203,16230,23827,14509,2629,16757,23840,23816,23817,23819,23820,23821,23292,23850,11117,23845,18744,1638,23842,2969,10367,23857,18731,19465,13897,13038,19069,22998,15235,23847,20668,1868,13450,6940,21898,2660,13801,23866,23859,23861,23880,3540,23879,14661,23877,16587 ... String too long for GET parameter: 2062 | 0.052070 | 0.052070 |
