SEOClerks

Full Stack Web/ Android/iOS/ Native Desktop Apps for $500

100% (15)
Attention: The owner of this service has not logged into SEOClerks for more than 30 days. It is highly recommend that you contact them before ordering this service. Last Login: 1825 days ago

Full Stack Web/ Android/iOS/ Native Desktop Apps

Want to make your idea of An Amazing website, app into a reality? Just let me what you want me to make.

I've expertise in:

* Node.js
* Go lang
* React
* React Native
* Native Android
* Postgres
* MongoDB
* MySQL
* SOAs, PHP, Python, Deployment through GC/AWS/cPanel, etc

Note: Please order this before discussing your deliverables and requirements finalized with me.


What's included

Source CodeResponse DesignBug FixingResale Rights

Tags

Node js Golang Postgresql Redis SOA

0.0

0 reviews

Rating breakdown


Extras
Quick 10 day delivery
If the seller fails to deliver the service in the specified time, the order will automatically cancel returning your funds.
$250

Other services by JyothiPrasad

$500 - In stock
Order Now
Process Time: 0.075433015823364

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM posts WHERE PID=7723281SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=772328

/opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() ()

SELECT * FROM categories1SELECT * FROM categories

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

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

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='772328' AND A.RATER=B.USERID1SELECT COUNT(A.RID) as total, SUM(bad) as badTotal, SUM(good) as goodTotal FROM ratings A, seoclerks.members B WHERE A.PID='772328' AND A.RATER=B.USERID

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

SELECT * FROM orders WHERE PID='772328' AND status in (1, 4, 6)1SELECT OID, stime, extradays1, extradays2, extradays3, extra1ordered, extra2ordered, extra3ordered, days, status, quantity, extras_data FROM orders WHERE PID='772328' AND status in (1, 4, 6)

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

UPDATE posts SET viewcount = viewcount + 1 WHERE PID='772328'1UPDATE posts SET viewcount = viewcount + 1 WHERE PID='772328'

/opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()

SELECT * FROM seoclerks.ratings WHERE USERID='268382' AND PID != 01SELECT good, bad FROM seoclerks.ratings WHERE USERID='268382' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM codeclerks.ratings WHERE USERID='268382' AND PID != 01SELECT good, bad FROM codeclerks.ratings WHERE USERID='268382' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM listingdock.ratings WHERE USERID='268382' AND PID != 01SELECT good, bad FROM listingdock.ratings WHERE USERID='268382' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM pixelclerks.ratings WHERE USERID='268382' AND PID != 01SELECT good, bad FROM pixelclerks.ratings WHERE USERID='268382' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM wordclerks.ratings WHERE USERID='268382' AND PID != 01SELECT good, bad FROM wordclerks.ratings WHERE USERID='268382' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

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 categories WHERE parentid = 0 1SELECT * FROM categories WHERE parentid = 0

/opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include()

SELECT * FROM seoclerks.members WHERE USERID=? 1SELECT usergroup FROM seoclerks.members WHERE USERID=?

/opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include()

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.4862901SELECT 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 (64) AND gtags like'%d%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4862900.486290
0.4777401SELECT 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 (64) AND gtags like'%Iconlogo%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4777400.477740
0.4368101SELECT 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 (74) AND gtags like'%Vps%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4368100.436810
0.4290291SELECT 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 (74) AND gtags like'%Css%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4290290.429029
0.4092941SELECT 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 (75) AND gtags like'%Webpage%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4092940.409294
0.3974381SELECT 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 (75) AND gtags like'%building%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.3974380.397438
0.2844241SELECT 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 (64) AND gtags like'%Iconlogo%' AND type !=99 0.2844240.284424
0.2629071SELECT 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 (74) AND gtags like'%Vps%' AND type !=99 0.2629070.262907
0.2331551SELECT 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 (74) AND gtags like'%new%' AND type !=99 0.2331550.233155
0.2229161SELECT 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 (63) AND gtags like'%debugging%' AND type !=99 0.2229160.222916