পিগমেন্টেশন দূর করার উপায় কি? - বাংলাহাব Answers - বাংলায় প্রশ্ন উত্তর সাইট

পিগমেন্টেশন দূর করার উপায় কি?

2 উত্তর

সম্পর্কিত প্রশ্নগুলো

0 টি ভোট

2 টি উত্তর

ব্ল্যাক হেডস দূর করার উপায় কি?

30 নভেম্বর 2019 "রূপচর্চা" বিভাগে জিজ্ঞাসা করেছেন Rajdip (56.1k পয়েন্ট)

0 টি ভোট

1 উত্তর

হাতের কালো ভাব দূর করার উপায় কি ?

27 জুলাই 2019 "রূপচর্চা" বিভাগে জিজ্ঞাসা করেছেন কেয়া হাজরা (250 পয়েন্ট)

0 টি ভোট

3 টি উত্তর

চেহারা থেকে বয়সের ছাপ দূর করার কিছু উপায় জানতে চাই

13 নভেম্বর 2019 "রূপচর্চা" বিভাগে জিজ্ঞাসা করেছেন Rajdip (56.1k পয়েন্ট)

0 টি ভোট

3 টি উত্তর

ব্রণ দূর করার সহজ কোন উপায় আছে?

31 অক্টোবর 2019 "রূপচর্চা" বিভাগে জিজ্ঞাসা করেছেন Rajdip (56.1k পয়েন্ট)

0 টি ভোট

2 টি উত্তর

মুখের দাগ দূর করার উপায় জানতে চাই

24 অক্টোবর 2019 "রূপচর্চা" বিভাগে জিজ্ঞাসা করেছেন Rajdip (56.1k পয়েন্ট)

×

ফেসবুকে আমাদেরকে লাইক কর

Show your Support. Become a FAN!

বাংলাহাব Answers ভাষায় সমস্যা সমাধানের একটি নির্ভরযোগ্য মাধ্যম। এখানে আপনি আপনার প্রশ্ন করার পাশাপাশি অন্যদের প্রশ্নে উত্তর প্রদান করে অবদান রাখতে পারেন অনলাইনে বিভিন্ন সমস্যার সমাধানের জন্য সবথেকে বড় এবং উন্মুক্ত তথ্যভাণ্ডার গড়ে তোলার কাজে।

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	53.4	31%	51.9	30%	46	1.1	0%	2	0.4	0%	243k	28%
Control	17.1	10%	12.6	7%	10	5.5	3%	12	0.0	0%	135k	15%
View	26.9	16%	26.5	15%	24	0.0	0%	0	0.5	0%	114k	13%
Theme	69.7	41%	16.6	9%	4	55.6	33%	14	0.0	0%	373k	43%
Stats	1.2	0%	0.2	0%	0	1.0	0%	1	0.0	0%	0k	0%
Total	168.3	100%	107.7	64%	84	63.2	37%	29	0.0	0%	867k	100%

ask.banglahub.com.bd/public/index.php
public/qa-include/qa-index.php
public/qa-include/qa-base.php
ask.banglahub.com.bd/public/qa-config.php
qa-include/vendor/password_compat.php
Q2A/Util/Usage.php
Q2A/Plugin/PluginManager.php
Q2A/Util/Metadata.php
qa-plugin/Donut-admin/qa-plugin.php
qa-plugin/Donut-admin/functions.php
Donut-admin/admin/options.php
Donut-admin/admin/admin-routing.php
qa-plugin/Welcome-Widget-master/qa-plugin.php
qa-plugin/ai-research/qa-plugin.php
qa-plugin/bn-ime/qa-plugin.php
qa-plugin/event-logger/qa-plugin.php
qa-plugin/gemini-ai/qa-plugin.php
qa-plugin/q2a-facebook-like-box-master/qa-plugin.php
qa-plugin/q2a-open-login-master/qa-plugin.php
qa-plugin/q2a-open-login-master/providers.php
qa-plugin/q2a-topusers-per-month-master/qa-plugin.php
qa-plugin/q2apro-quick-edit-master/qa-plugin.php
qa-plugin/q2apro-sceditor-premium-master/qa-plugin.php
qa-plugin/q2apro-stop-spam-master/qa-plugin.php
qa-plugin/show-online-user-count/qa-plugin.php
qa-plugin/simple-social-sharing/qa-plugin.php
qa-plugin/wysiwyg-editor/qa-plugin.php
public/qa-include/qa-db.php
public/qa-include/qa-page.php
qa-include/app/page.php
qa-include/app/cookies.php
qa-include/app/format.php
qa-include/app/users.php
qa-include/app/options.php
qa-include/db/options.php
qa-include/db/selects.php
qa-include/db/maxima.php
qa-plugin/basic-adsense/qa-plugin.php
qa-plugin/example-page/qa-plugin.php
qa-plugin/mouseover-layer/qa-plugin.php
qa-plugin/opensearch-support/qa-plugin.php
qa-plugin/q2a-use-cdn-master/qa-plugin.php
qa-plugin/tag-cloud-widget/qa-plugin.php
qa-plugin/xml-sitemap/qa-plugin.php
qa-plugin/q2a-open-login-master/qa-open-login.php
q2a-open-login-master/HybridAuth/autoload.php
qa-plugin/q2a-open-login-master/qa-open-utils.php
q2a-open-login-master/HybridAuth/Hybridauth.php
HybridAuth/Logger/Logger.php
HybridAuth/Logger/LoggerInterface.php
HybridAuth/Storage/Session.php
HybridAuth/Storage/StorageInterface.php
qa-include/pages/question.php
qa-include/util/sort.php
qa-include/util/string.php
qa-include/app/captcha.php
qa-include/pages/question-view.php
qa-include/app/updates.php
Q2A/Storage/CacheFactory.php
Q2A/Storage/FileCacheDriver.php
Q2A/Storage/CacheDriver.php
qa-include/app/limits.php
qa-include/lang/qa-lang-main.php
qa-lang/bn/qa-lang-main.php
qa-include/plugins/qa-widget-related-qs.php
qa-include/plugins/qa-widget-category-list.php
qa-include/plugins/qa-widget-ask-box.php
qa-plugin/q2a-topusers-per-month-master/qa-tupm-widget.php
qa-plugin/tag-cloud-widget/qa-tag-cloud.php
qa-include/plugins/qa-widget-activity-count.php
qa-plugin/simple-social-sharing/qa-simple-social-sharing-widget.php
qa-plugin/q2a-facebook-like-box-master/qa-facebook-like-box.php
qa-plugin/q2a-open-login-master/qa-open-lang-default.php
qa-include/app/posts.php
qa-include/app/post-create.php
qa-include/db/post-create.php
qa-include/db/points.php
qa-include/db/hotness.php
qa-include/app/post-update.php
qa-include/db/post-update.php
qa-include/plugins/qa-viewer-basic.php
qa-include/lang/qa-lang-users.php
qa-lang/bn/qa-lang-users.php
qa-include/util/image.php
qa-include/lang/qa-lang-question.php
qa-lang/bn/qa-lang-question.php
public/qa-include/qa-theme-base.php
qa-theme/SnowFlat/qa-theme.php
qa-plugin/q2a-facebook-like-box-master/qa-facebook-like-box-admin.php
qa-plugin/q2a-topusers-per-month-master/qa-tupm-lang.php

SELECT title, content FROM qtoazt_options

0.85 ms - 816 rows - 2 columns

SELECT 'db_time' AS `title`, UNIX_TIMESTAMP(NOW()) AS `content`

0.20 ms - 1 row - 2 columns

SELECT qtoazt_posts.postid, qtoazt_posts.categoryid, qtoazt_posts.type, LEFT(qtoazt_posts.type, 1) AS `basetype`, INSTR(qtoazt_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qtoazt_posts.type, '_QUEUED')>0 AS `queued`, qtoazt_posts.acount, qtoazt_posts.amaxvote, qtoazt_posts.selchildid, qtoazt_posts.closedbyid, qtoazt_posts.upvotes, qtoazt_posts.downvotes, qtoazt_posts.netvotes, qtoazt_posts.views, qtoazt_posts.hotness, qtoazt_posts.flagcount, qtoazt_posts.title, qtoazt_posts.tags, UNIX_TIMESTAMP(qtoazt_posts.created) AS `created`, qtoazt_posts.name, qtoazt_categories.title AS `categoryname`, qtoazt_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qtoazt_posts.catidpath1, qtoazt_posts.catidpath2, qtoazt_posts.catidpath3, qtoazt_posts.categoryid) AS `categoryids`, qtoazt_posts.content AS `content`, qtoazt_posts.notify AS `notify`, UNIX_TIMESTAMP(qtoazt_posts.updated) AS `updated`, qtoazt_posts.updatetype AS `updatetype`, qtoazt_posts.format, qtoazt_posts.lastuserid, qtoazt_posts.lastip AS `lastip`, qtoazt_posts.parentid, qtoazt_posts.lastviewip AS `lastviewip`, qtoazt_posts.userid, qtoazt_posts.cookieid, qtoazt_posts.createip AS `createip`, qtoazt_userpoints.points, qtoazt_users.flags, qtoazt_users.level, qtoazt_users.email AS `email`, qtoazt_users.handle AS `handle`, BINARY qtoazt_users.avatarblobid AS `avatarblobid`, qtoazt_users.avatarwidth, qtoazt_users.avatarheight, lastusers.handle AS `lasthandle` FROM qtoazt_posts LEFT JOIN qtoazt_categories ON qtoazt_categories.categoryid=qtoazt_posts.categoryid LEFT JOIN qtoazt_users ON qtoazt_posts.userid=qtoazt_users.userid LEFT JOIN qtoazt_users AS lastusers ON qtoazt_posts.lastuserid=lastusers.userid LEFT JOIN qtoazt_userpoints ON qtoazt_posts.userid=qtoazt_userpoints.userid WHERE qtoazt_posts.postid=9857

0.93 ms - 1 row - 44 columns

SELECT qtoazt_posts.postid, qtoazt_posts.categoryid, qtoazt_posts.type, LEFT(qtoazt_posts.type, 1) AS `basetype`, INSTR(qtoazt_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qtoazt_posts.type, '_QUEUED')>0 AS `queued`, qtoazt_posts.acount, qtoazt_posts.amaxvote, qtoazt_posts.selchildid, qtoazt_posts.closedbyid, qtoazt_posts.upvotes, qtoazt_posts.downvotes, qtoazt_posts.netvotes, qtoazt_posts.views, qtoazt_posts.hotness, qtoazt_posts.flagcount, qtoazt_posts.title, qtoazt_posts.tags, UNIX_TIMESTAMP(qtoazt_posts.created) AS `created`, qtoazt_posts.name, qtoazt_categories.title AS `categoryname`, qtoazt_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qtoazt_posts.catidpath1, qtoazt_posts.catidpath2, qtoazt_posts.catidpath3, qtoazt_posts.categoryid) AS `categoryids`, qtoazt_posts.content AS `content`, qtoazt_posts.notify AS `notify`, UNIX_TIMESTAMP(qtoazt_posts.updated) AS `updated`, qtoazt_posts.updatetype AS `updatetype`, qtoazt_posts.format, qtoazt_posts.lastuserid, qtoazt_posts.lastip AS `lastip`, qtoazt_posts.parentid, qtoazt_posts.lastviewip AS `lastviewip`, qtoazt_posts.userid, qtoazt_posts.cookieid, qtoazt_posts.createip AS `createip`, qtoazt_userpoints.points, qtoazt_users.flags, qtoazt_users.level, qtoazt_users.email AS `email`, qtoazt_users.handle AS `handle`, BINARY qtoazt_users.avatarblobid AS `avatarblobid`, qtoazt_users.avatarwidth, qtoazt_users.avatarheight, lastusers.handle AS `lasthandle` FROM qtoazt_posts LEFT JOIN qtoazt_categories ON qtoazt_categories.categoryid=qtoazt_posts.categoryid LEFT JOIN qtoazt_users ON qtoazt_posts.userid=qtoazt_users.userid LEFT JOIN qtoazt_users AS lastusers ON qtoazt_posts.lastuserid=lastusers.userid LEFT JOIN qtoazt_userpoints ON qtoazt_posts.userid=qtoazt_userpoints.userid WHERE qtoazt_posts.parentid=9857

0.55 ms - 2 rows - 44 columns

SELECT qtoazt_posts.postid, qtoazt_posts.categoryid, qtoazt_posts.type, LEFT(qtoazt_posts.type, 1) AS `basetype`, INSTR(qtoazt_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qtoazt_posts.type, '_QUEUED')>0 AS `queued`, qtoazt_posts.acount, qtoazt_posts.amaxvote, qtoazt_posts.selchildid, qtoazt_posts.closedbyid, qtoazt_posts.upvotes, qtoazt_posts.downvotes, qtoazt_posts.netvotes, qtoazt_posts.views, qtoazt_posts.hotness, qtoazt_posts.flagcount, qtoazt_posts.title, qtoazt_posts.tags, UNIX_TIMESTAMP(qtoazt_posts.created) AS `created`, qtoazt_posts.name, qtoazt_categories.title AS `categoryname`, qtoazt_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qtoazt_posts.catidpath1, qtoazt_posts.catidpath2, qtoazt_posts.catidpath3, qtoazt_posts.categoryid) AS `categoryids`, qtoazt_posts.content AS `content`, qtoazt_posts.notify AS `notify`, UNIX_TIMESTAMP(qtoazt_posts.updated) AS `updated`, qtoazt_posts.updatetype AS `updatetype`, qtoazt_posts.format, qtoazt_posts.lastuserid, qtoazt_posts.lastip AS `lastip`, qtoazt_posts.parentid, qtoazt_posts.lastviewip AS `lastviewip`, qtoazt_posts.userid, qtoazt_posts.cookieid, qtoazt_posts.createip AS `createip`, qtoazt_userpoints.points, qtoazt_users.flags, qtoazt_users.level, qtoazt_users.email AS `email`, qtoazt_users.handle AS `handle`, BINARY qtoazt_users.avatarblobid AS `avatarblobid`, qtoazt_users.avatarwidth, qtoazt_users.avatarheight, lastusers.handle AS `lasthandle` FROM qtoazt_posts LEFT JOIN qtoazt_categories ON qtoazt_categories.categoryid=qtoazt_posts.categoryid LEFT JOIN qtoazt_users ON qtoazt_posts.userid=qtoazt_users.userid LEFT JOIN qtoazt_users AS lastusers ON qtoazt_posts.lastuserid=lastusers.userid LEFT JOIN qtoazt_userpoints ON qtoazt_posts.userid=qtoazt_userpoints.userid JOIN qtoazt_posts AS parents ON qtoazt_posts.parentid=parents.postid WHERE parents.parentid=9857 AND LEFT(parents.type, 1)='A'

0.40 ms - 0 rows - 44 columns

SELECT qtoazt_posts.postid, qtoazt_posts.categoryid, qtoazt_posts.type, LEFT(qtoazt_posts.type, 1) AS `basetype`, INSTR(qtoazt_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qtoazt_posts.type, '_QUEUED')>0 AS `queued`, qtoazt_posts.acount, qtoazt_posts.amaxvote, qtoazt_posts.selchildid, qtoazt_posts.closedbyid, qtoazt_posts.upvotes, qtoazt_posts.downvotes, qtoazt_posts.netvotes, qtoazt_posts.views, qtoazt_posts.hotness, qtoazt_posts.flagcount, qtoazt_posts.title, qtoazt_posts.tags, UNIX_TIMESTAMP(qtoazt_posts.created) AS `created`, qtoazt_posts.name, qtoazt_categories.title AS `categoryname`, qtoazt_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qtoazt_posts.catidpath1, qtoazt_posts.catidpath2, qtoazt_posts.catidpath3, qtoazt_posts.categoryid) AS `categoryids`, qtoazt_posts.userid, qtoazt_posts.cookieid, qtoazt_posts.createip AS `createip`, qtoazt_userpoints.points, qtoazt_users.flags, qtoazt_users.level, qtoazt_users.email AS `email`, qtoazt_users.handle AS `handle`, BINARY qtoazt_users.avatarblobid AS `avatarblobid`, qtoazt_users.avatarwidth, qtoazt_users.avatarheight FROM qtoazt_posts LEFT JOIN qtoazt_categories ON qtoazt_categories.categoryid=qtoazt_posts.categoryid LEFT JOIN qtoazt_users ON qtoazt_posts.userid=qtoazt_users.userid LEFT JOIN qtoazt_userpoints ON qtoazt_posts.userid=qtoazt_userpoints.userid WHERE qtoazt_posts.postid=(SELECT IF(LEFT(parent.type, 1)='A', parent.parentid, parent.postid) FROM qtoazt_posts AS child LEFT JOIN qtoazt_posts AS parent ON parent.postid=child.parentid WHERE child.postid=9857 AND parent.type IN('Q','A'))

0.34 ms - 0 rows - 34 columns

SELECT qtoazt_posts.postid, qtoazt_posts.categoryid, qtoazt_posts.type, LEFT(qtoazt_posts.type, 1) AS `basetype`, INSTR(qtoazt_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qtoazt_posts.type, '_QUEUED')>0 AS `queued`, qtoazt_posts.acount, qtoazt_posts.amaxvote, qtoazt_posts.selchildid, qtoazt_posts.closedbyid, qtoazt_posts.upvotes, qtoazt_posts.downvotes, qtoazt_posts.netvotes, qtoazt_posts.views, qtoazt_posts.hotness, qtoazt_posts.flagcount, qtoazt_posts.title, qtoazt_posts.tags, UNIX_TIMESTAMP(qtoazt_posts.created) AS `created`, qtoazt_posts.name, qtoazt_categories.title AS `categoryname`, qtoazt_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qtoazt_posts.catidpath1, qtoazt_posts.catidpath2, qtoazt_posts.catidpath3, qtoazt_posts.categoryid) AS `categoryids`, qtoazt_posts.content AS `content`, qtoazt_posts.notify AS `notify`, UNIX_TIMESTAMP(qtoazt_posts.updated) AS `updated`, qtoazt_posts.updatetype AS `updatetype`, qtoazt_posts.format, qtoazt_posts.lastuserid, qtoazt_posts.lastip AS `lastip`, qtoazt_posts.parentid, qtoazt_posts.lastviewip AS `lastviewip`, qtoazt_posts.userid, qtoazt_posts.cookieid, qtoazt_posts.createip AS `createip`, qtoazt_userpoints.points, qtoazt_users.flags, qtoazt_users.level, qtoazt_users.email AS `email`, qtoazt_users.handle AS `handle`, BINARY qtoazt_users.avatarblobid AS `avatarblobid`, qtoazt_users.avatarwidth, qtoazt_users.avatarheight, lastusers.handle AS `lasthandle` FROM qtoazt_posts LEFT JOIN qtoazt_categories ON qtoazt_categories.categoryid=qtoazt_posts.categoryid LEFT JOIN qtoazt_users ON qtoazt_posts.userid=qtoazt_users.userid LEFT JOIN qtoazt_users AS lastusers ON qtoazt_posts.lastuserid=lastusers.userid LEFT JOIN qtoazt_userpoints ON qtoazt_posts.userid=qtoazt_userpoints.userid WHERE qtoazt_posts.postid=(SELECT closedbyid FROM qtoazt_posts WHERE postid=9857)

0.70 ms - 0 rows - 44 columns

SELECT qtoazt_posts.postid, qtoazt_posts.categoryid, qtoazt_posts.type, LEFT(qtoazt_posts.type, 1) AS `basetype`, INSTR(qtoazt_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qtoazt_posts.type, '_QUEUED')>0 AS `queued`, qtoazt_posts.acount, qtoazt_posts.amaxvote, qtoazt_posts.selchildid, qtoazt_posts.closedbyid, qtoazt_posts.upvotes, qtoazt_posts.downvotes, qtoazt_posts.netvotes, qtoazt_posts.views, qtoazt_posts.hotness, qtoazt_posts.flagcount, qtoazt_posts.title, qtoazt_posts.tags, UNIX_TIMESTAMP(qtoazt_posts.created) AS `created`, qtoazt_posts.name, qtoazt_categories.title AS `categoryname`, qtoazt_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qtoazt_posts.catidpath1, qtoazt_posts.catidpath2, qtoazt_posts.catidpath3, qtoazt_posts.categoryid) AS `categoryids`, qtoazt_posts.content AS `content`, qtoazt_posts.notify AS `notify`, UNIX_TIMESTAMP(qtoazt_posts.updated) AS `updated`, qtoazt_posts.updatetype AS `updatetype`, qtoazt_posts.format, qtoazt_posts.lastuserid, qtoazt_posts.lastip AS `lastip`, qtoazt_posts.parentid, qtoazt_posts.lastviewip AS `lastviewip`, qtoazt_posts.userid, qtoazt_posts.cookieid, qtoazt_posts.createip AS `createip`, qtoazt_userpoints.points, qtoazt_users.flags, qtoazt_users.level, qtoazt_users.email AS `email`, qtoazt_users.handle AS `handle`, BINARY qtoazt_users.avatarblobid AS `avatarblobid`, qtoazt_users.avatarwidth, qtoazt_users.avatarheight, lastusers.handle AS `lasthandle` FROM qtoazt_posts LEFT JOIN qtoazt_categories ON qtoazt_categories.categoryid=qtoazt_posts.categoryid LEFT JOIN qtoazt_users ON qtoazt_posts.userid=qtoazt_users.userid LEFT JOIN qtoazt_users AS lastusers ON qtoazt_posts.lastuserid=lastusers.userid LEFT JOIN qtoazt_userpoints ON qtoazt_posts.userid=qtoazt_userpoints.userid WHERE qtoazt_posts.closedbyid=9857

0.46 ms - 0 rows - 44 columns

SELECT title, content FROM qtoazt_postmetas WHERE postid=9857 AND title='qa_q_extra'

0.27 ms - 0 rows - 2 columns

SELECT qtoazt_categories.categoryid, MAX(qtoazt_categories.parentid) AS `parentid`, MAX(qtoazt_categories.title) AS `title`, MAX(qtoazt_categories.tags) AS `tags`, MAX(qtoazt_categories.qcount) AS `qcount`, MAX(qtoazt_categories.position) AS `position`, COUNT(child.categoryid) AS `childcount`, MAX(qtoazt_categories.content) AS `content`, MAX(qtoazt_categories.backpath) AS `backpath` FROM qtoazt_categories JOIN (SELECT NULL AS parentkey UNION SELECT grandparent.parentid FROM qtoazt_categories JOIN qtoazt_categories AS parent ON qtoazt_categories.parentid=parent.categoryid JOIN qtoazt_categories AS grandparent ON parent.parentid=grandparent.categoryid WHERE qtoazt_categories.categoryid=(SELECT categoryid FROM qtoazt_posts WHERE postid=9857) UNION SELECT parent.parentid FROM qtoazt_categories JOIN qtoazt_categories AS parent ON qtoazt_categories.parentid=parent.categoryid WHERE qtoazt_categories.categoryid=(SELECT categoryid FROM qtoazt_posts WHERE postid=9857) UNION SELECT parentid FROM qtoazt_categories WHERE categoryid=(SELECT categoryid FROM qtoazt_posts WHERE postid=9857) UNION SELECT categoryid FROM qtoazt_categories WHERE categoryid=(SELECT categoryid FROM qtoazt_posts WHERE postid=9857)) y ON qtoazt_categories.parentid<=>parentkey LEFT JOIN qtoazt_categories AS child ON child.parentid=qtoazt_categories.categoryid GROUP BY qtoazt_categories.categoryid ORDER BY qtoazt_categories.position

1.01 ms - 51 rows - 9 columns

SELECT action, period, count FROM qtoazt_iplimits WHERE ip=UNHEX('d849d82f')

0.34 ms - 0 rows - 3 columns

SELECT pageid, title, flags, permit+0 AS `permit`, nav, tags, position, heading FROM qtoazt_pages WHERE nav IN ('B','M','O','F') ORDER BY position

0.24 ms - 2 rows - 8 columns

SELECT widgetid, place, position, tags, title FROM qtoazt_widgets ORDER BY position

0.13 ms - 11 rows - 5 columns

SELECT entityid, entitytype, level FROM qtoazt_userlevels WHERE userid=NULL

0.15 ms - 0 rows - 3 columns

SELECT qtoazt_posts.postid, qtoazt_posts.categoryid, qtoazt_posts.type, LEFT(qtoazt_posts.type, 1) AS `basetype`, INSTR(qtoazt_posts.type, '_HIDDEN')>0 AS `hidden`, INSTR(qtoazt_posts.type, '_QUEUED')>0 AS `queued`, qtoazt_posts.acount, qtoazt_posts.amaxvote, qtoazt_posts.selchildid, qtoazt_posts.closedbyid, qtoazt_posts.upvotes, qtoazt_posts.downvotes, qtoazt_posts.netvotes, qtoazt_posts.views, qtoazt_posts.hotness, qtoazt_posts.flagcount, qtoazt_posts.title, qtoazt_posts.tags, UNIX_TIMESTAMP(qtoazt_posts.created) AS `created`, qtoazt_posts.name, qtoazt_categories.title AS `categoryname`, qtoazt_categories.backpath AS `categorybackpath`, CONCAT_WS(',', qtoazt_posts.catidpath1, qtoazt_posts.catidpath2, qtoazt_posts.catidpath3, qtoazt_posts.categoryid) AS `categoryids`, qtoazt_posts.userid, qtoazt_posts.cookieid, qtoazt_posts.createip AS `createip`, qtoazt_userpoints.points, qtoazt_users.flags, qtoazt_users.level, qtoazt_users.email AS `email`, qtoazt_users.handle AS `handle`, BINARY qtoazt_users.avatarblobid AS `avatarblobid`, qtoazt_users.avatarwidth, qtoazt_users.avatarheight, score FROM qtoazt_posts LEFT JOIN qtoazt_categories ON qtoazt_categories.categoryid=qtoazt_posts.categoryid LEFT JOIN qtoazt_users ON qtoazt_posts.userid=qtoazt_users.userid LEFT JOIN qtoazt_userpoints ON qtoazt_posts.userid=qtoazt_userpoints.userid JOIN (SELECT postid, SUM(score)+LOG(postid)/1000000 AS score FROM ((SELECT qtoazt_titlewords.postid, LOG(10000/titlecount) AS score FROM qtoazt_titlewords JOIN qtoazt_words ON qtoazt_titlewords.wordid=qtoazt_words.wordid JOIN qtoazt_titlewords AS source ON qtoazt_titlewords.wordid=source.wordid WHERE source.postid=9857 AND titlecount<10000) UNION ALL (SELECT qtoazt_posttags.postid, 2*LOG(10000/tagcount) AS score FROM qtoazt_posttags JOIN qtoazt_words ON qtoazt_posttags.wordid=qtoazt_words.wordid JOIN qtoazt_posttags AS source ON qtoazt_posttags.wordid=source.wordid WHERE source.postid=9857 AND tagcount<10000) UNION ALL (SELECT qtoazt_posts.postid, LOG(10000/qtoazt_categories.qcount) FROM qtoazt_posts JOIN qtoazt_categories ON qtoazt_posts.categoryid=qtoazt_categories.categoryid AND qtoazt_posts.type='Q' WHERE qtoazt_categories.categoryid=(SELECT categoryid FROM qtoazt_posts WHERE postid=9857) AND qtoazt_categories.qcount<10000)) x WHERE postid!=9857 GROUP BY postid ORDER BY score DESC LIMIT 5) y ON qtoazt_posts.postid=y.postid

7.96 ms - 5 rows - 35 columns

SELECT postid, content, format FROM qtoazt_posts WHERE postid IN (9858,6246,9523,8990,8776)

0.60 ms - 5 rows - 3 columns

SELECT qtoazt_userpoints.userid, qtoazt_userpoints.points - COALESCE(qtoazt_userscores.points,0) AS mpoints 
								FROM `qtoazt_userpoints`
								LEFT JOIN `qtoazt_userscores` on qtoazt_userpoints.userid=qtoazt_userscores.userid
									AND DATE_FORMAT(qtoazt_userscores.date,'%Y') like '2025' 
                                                                        AND DATE_FORMAT(qtoazt_userscores.date,'%m') like '11'  
			
								WHERE 
								 qtoazt_userpoints.userid not in (select userid from qtoazt_users where flags & 2 = 1) ORDER BY mpoints DESC, qtoazt_userpoints.userid DESC limit 10;

39.67 ms - 10 rows - 2 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='528'

0.60 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='460'

0.57 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='3'

0.53 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='1'

0.32 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='169'

0.82 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='29'

1.27 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='2292'

0.30 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='42'

0.27 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='1548'

0.30 ms - 1 row - 21 columns

SELECT qtoazt_users.userid, passsalt, HEX(passcheck) AS `passcheck`, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS `created`, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS `loggedin`, loginip, UNIX_TIMESTAMP(written) AS `written`, writeip, BINARY avatarblobid AS `avatarblobid`, avatarwidth, avatarheight, points, wallposts FROM qtoazt_users LEFT JOIN qtoazt_userpoints ON qtoazt_userpoints.userid=qtoazt_users.userid WHERE qtoazt_users.userid='252'

0.52 ms - 1 row - 21 columns

SELECT word, tagcount FROM qtoazt_words JOIN (SELECT wordid FROM qtoazt_words WHERE tagcount>0 ORDER BY tagcount DESC LIMIT 0,100) y ON qtoazt_words.wordid=y.wordid

1.87 ms - 100 rows - 2 columns

UPDATE qtoazt_posts SET views=views+1, lastviewip=UNHEX('d849d82f') WHERE postid=9857 AND (lastviewip IS NULL OR lastviewip!=UNHEX('d849d82f'))

1.04 ms