| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID | 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
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,40 | 1 | SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture
FROM wanttobuy A,
categories_wanttobuy B,
seoclerks.members C
WHERE
A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
ORDER BY A.bdays desc
LIMIT 0,40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1639' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1639' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='22848' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22848' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='23053' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23053' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='24700' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24700' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1640' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1640' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1840' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1840' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='2226' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2226' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='5261' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='5261' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='4213' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4213' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='4360' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4360' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='25429' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25429' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='52625' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52625' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='2563' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2563' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='2660' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2660' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='7438' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='7438' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='16414' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='16414' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='19500' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='19500' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='22366' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22366' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='23362' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23362' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='25158' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25158' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='37652' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37652' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='43590' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43590' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='45940' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45940' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='9055' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='9055' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='10347' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='10347' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='36434' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36434' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='22119' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22119' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='25918' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25918' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='15579' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15579' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='1641' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1641' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='47366' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47366' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='4135' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4135' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='24776' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24776' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='33558' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33558' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='38008' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38008' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='38909' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38909' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='39390' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39390' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='46891' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46891' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='46893' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46893' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='46896' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46896' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| 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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| 0.417483 | 2 | 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.219150 | 0.198333 |
| Avg Time | Count | SQL | Max | Min |
| 0.397944 | 1 | SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,40 | 0.397944 | 0.397944 |
| 0.390581 | 1 | SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,40 | 0.390581 | 0.390581 |
| 0.208742 | 2 | 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.219150 | 0.198333 |
| 0.075606 | 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: 2061 | 0.075606 | 0.075606 |
