SEOClerks


Create New Job Showing page: 1 of 1

I am creating a knit functional network of resellers interested in building...

  • hotline
    hotline Level 1
  • Seoexper Seo Sem

    intergrate stripe gateway into my site stripe payment gateway credit card i...

  • rlencouk
    rlencouk Level 1
  • Php Mmsql

    connect 3 sites together one login 2 mysql 1 mmsql databases 2md5 one is bl...

  • rlencouk
    rlencouk Level 1
  • Php Mysql Mmsql

    first i build the datbses connection script include < php include appli...

  • rlencouk
    rlencouk Level 1
  • Php5 6 Php7

    Database - MySQL ? Build a database for a system, using one of the social n...

  • tahorul09
    tahorul09 Level 1
  • Msql Database

    who can connect two site together using websockets or tcp ip connection bot...

  • rlencouk
    rlencouk Level 1
  • Php5 6 Php7

    i just need the mysql in the code i include upgrading to mmsql ill pay 5- w...

  • rlencouk
    rlencouk Level 1
  • Php Mysql Mmsql

    i will pay but ive also got a trade on this site if some one want to upgrad...

  • rlencouk
    rlencouk Level 1
  • Programm Php7 Mysql

    hello i have quite a few games i need to install in to my gaming site i nee...

  • rlencouk
    rlencouk Level 1
  • Php Mysql Mmsql

    who can upgrade my data base for me any one have the sofware for this simpl...

  • rlencouk
    rlencouk Level 1
  • Sql Mysql Mmsql

    job 1 upgrade php 5.2 script from register globals to ouath php 7.15 with s...

  • pokerlobby
    pokerlobby Level 1
  • Php Mysql Mmsql

    1 registration process basic i want to handle with with a wp plugin already...

  • VirtaPay
    VirtaPay Level 1
  • Mysql Php Wordpres
    Order Now
    Process Time: 0.32936310768127

    Possible Duplicate queries found!
    MatchCountSQLScript
    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 AND (A.tags LIKE '%Msql%' OR A.skills LIKE '%Msql%')1SELECT 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 AND (A.tags LIKE '%Msql%' OR A.skills LIKE '%Msql%')

    /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 AND (A.tags LIKE '%Msql%' OR A.skills LIKE '%Msql%') ORDER BY A.lastgigedit desc LIMIT 0,401SELECT 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 AND (A.tags LIKE '%Msql%' OR A.skills LIKE '%Msql%') ORDER BY A.lastgigedit desc LIMIT 0,40

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

    SELECT * FROM wantbids WHERE active=1 AND wantid='58559'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58559'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='67824'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67824'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='67395'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67395'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='67331'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67331'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='58464'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58464'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='56527'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56527'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='55888'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55888'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='55633'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55633'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='55497'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55497'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='55440'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55440'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='55329'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55329'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='20336'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='20336'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    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()

    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
    0.4353761SELECT 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 (22) AND gtags like'%SEOBacklinks%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4353760.435376
    0.1464631SELECT 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 AND (A.tags LIKE '%Msql%' OR A.skills LIKE '%Msql%') ORDER BY A.lastgigedit desc LIMIT 0,400.1464630.146463
    0.1169341SELECT 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 AND (A.tags LIKE '%Msql%' OR A.skills LIKE '%Msql%')0.1169340.116934