SEOClerks

Answers from user aqibarif74 Page 4

Order Now
Process Time: 0.055454015731812

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM seoclerks.members WHERE username='aqibarif74' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='aqibarif74' AND status='1'

/opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()

SELECT * FROM answers WHERE userid=109501SELECT distinct quesid FROM answers WHERE userid=10950

/opt/clerks-staging/docroot/faq.php 258 () ()

SELECT * 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 (2280,1873,2311,2278,2843,2839,2713,2895,2772,2490,2452,2369,2408,2007,1913,1738,1693,1101,520,550,2870,2899,2612,506,40,695,465,1105,1109,3518,3516,3511,3521,3485,3526,3543,3542,3528,3545,3535,3576,8330,8328,8327,8335,8340,8342,8364,8413,8431,8429,10339,10342,10343,10434,10458,10477,10515,10516,11492,12885,13034,13091,13093,15335,16729,22096,22093,22090,22116,22118,22104,22002,22119,22121,22120,22129,22140,22136,22148,22152,22160,22159,22162,22163,22167,22181,22195,22198,22203,22207,22223,22221,22217,22213,22230,22226,22228,22247,22246,22275,22293,22312,22307,22353,22359,22373,22357,22408,22411,22465,22478,22482,22500,22464,22544,22641,22764,22801,22656,22845,22969,23119,23192,23524,23557,23613,23800,23909,24017,24066,29638,29716) LIMIT 11SELECT count(A.quesid) as total 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 (2280,1873,2311,2278,2843,2839,2713,2895,2772,2490,2452,2369,2408,2007,1913,1738,1693,1101,520,550,2870,2899,2612,506,40,695,465,1105,1109,3518,3516,3511,3521,3485,3526,3543,3542,3528,3545,3535,3576,8330,8328,8327,8335,8340,8342,8364,8413,8431,8429,10339,10342,10343,10434,10458,10477,10515,10516,11492,12885,13034,13091,13093,15335,16729,22096,22093,22090,22116,22118,22104,22002,22119,22121,22120,22129,22140,22136,22148,22152,22160,22159,22162,22163,22167,22181,22195,22198,22203,22207,22223,22221,22217,22213,22230,22226,22228,22247,22246,22275,22293,22312,22307,22353,22359,22373,22357,22408,22411,22465,22478,22482,22500,22464,22544,22641,22764,22801,22656,22845,22969,23119,23192,23524,23557,23613,23800,23909,24017,24066,29638,29716) LIMIT 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * 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 (2280,1873,2311,2278,2843,2839,2713,2895,2772,2490,2452,2369,2408,2007,1913,1738,1693,1101,520,550,2870,2899,2612,506,40,695,465,1105,1109,3518,3516,3511,3521,3485,3526,3543,3542,3528,3545,3535,3576,8330,8328,8327,8335,8340,8342,8364,8413,8431,8429,10339,10342,10343,10434,10458,10477,10515,10516,11492,12885,13034,13091,13093,15335,16729,22096,22093,22090,22116,22118,22104,22002,22119,22121,22120,22129,22140,22136,22148,22152,22160,22159,22162,22163,22167,22181,22195,22198,22203,22207,22223,22221,22217,22213,22230,22226,22228,22247,22246,22275,22293,22312,22307,22353,22359,22373,22357,22408,22411,22465,22478,22482,22500,22464,22544,22641,22764,22801,22656,22845,22969,23119,23192,23524,23557,23613,23800,23909,24017,24066,29638,29716) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 120, 401SELECT 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 (2280,1873,2311,2278,2843,2839,2713,2895,2772,2490,2452,2369,2408,2007,1913,1738,1693,1101,520,550,2870,2899,2612,506,40,695,465,1105,1109,3518,3516,3511,3521,3485,3526,3543,3542,3528,3545,3535,3576,8330,8328,8327,8335,8340,8342,8364,8413,8431,8429,10339,10342,10343,10434,10458,10477,10515,10516,11492,12885,13034,13091,13093,15335,16729,22096,22093,22090,22116,22118,22104,22002,22119,22121,22120,22129,22140,22136,22148,22152,22160,22159,22162,22163,22167,22181,22195,22198,22203,22207,22223,22221,22217,22213,22230,22226,22228,22247,22246,22275,22293,22312,22307,22353,22359,22373,22357,22408,22411,22465,22478,22482,22500,22464,22544,22641,22764,22801,22656,22845,22969,23119,23192,23524,23557,23613,23800,23909,24017,24066,29638,29716) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 120, 40

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * from questions as A where A.status='1' 1SELECT count(A.quesid) as total from questions as A where A.status='1'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM answers as A where A.status='1' 1SELECT count(A.ansid) as total FROM answers as A where A.status='1'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * from categories_wanttotrade order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

SELECT * FROM seoclerks.members WHERE USERID='1177'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1177'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='5297'1SELECT profilepicture FROM seoclerks.members WHERE USERID='5297'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='2637'1SELECT profilepicture FROM seoclerks.members WHERE USERID='2637'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='1'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

select * from categories_faq order by name asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin