8sstudiotop কোন প্রশ্ন করেন নি - বাংলাহাব Answers - বাংলায় প্রশ্ন উত্তর সাইট

8sstudiotop কোন প্রশ্ন করেন নি

×

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

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	68.8	45%	67.7	44%	46	0.8	0%	2	0.3	0%	243k	36%
Control	7.2	4%	5.3	3%	3	2.2	1%	6	0.0	0%	24k	3%
View	26.4	17%	26.1	17%	18	0.4	0%	1	0.0	0%	67k	10%
Theme	49.1	32%	22.2	14%	10	27.8	18%	12	0.0	0%	325k	49%
Total	151.4	100%	121.3	80%	77	31.2	20%	21	0.0	0%	661k	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/user.php
qa-include/pages/user-questions.php
qa-include/util/sort.php
qa-include/lang/qa-lang-main.php
qa-lang/bn/qa-lang-main.php
qa-include/app/updates.php
qa-include/app/limits.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-include/util/string.php
qa-plugin/q2a-open-login-master/qa-open-lang-default.php
qa-include/lang/qa-lang-profile.php
qa-lang/bn/qa-lang-profile.php
qa-include/lang/qa-lang-misc.php
qa-lang/bn/qa-lang-misc.php
public/qa-include/qa-theme-base.php
qa-theme/SnowFlat/qa-theme.php
qa-include/lang/qa-lang-users.php
qa-lang/bn/qa-lang-users.php
qa-plugin/q2a-facebook-like-box-master/qa-facebook-like-box-admin.php
Q2A/Storage/CacheFactory.php
Q2A/Storage/FileCacheDriver.php
Q2A/Storage/CacheDriver.php
qa-plugin/q2a-topusers-per-month-master/qa-tupm-lang.php
qa-include/util/image.php

SELECT title, content FROM qtoazt_options

0.63 ms - 816 rows - 2 columns

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

0.16 ms - 1 row - 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.handle='8sstudiotop'

0.73 ms - 1 row - 21 columns

SELECT points, qposts, aposts, cposts, aselects, aselecteds, qupvotes, qdownvotes, aupvotes, adownvotes, qvoteds, avoteds, upvoteds, downvoteds, bonus FROM qtoazt_userpoints WHERE userid=(SELECT userid FROM qtoazt_users WHERE handle='8sstudiotop' LIMIT 1)

0.23 ms - 1 row - 15 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.userid=(SELECT userid FROM qtoazt_users WHERE handle='8sstudiotop' LIMIT 1) AND type='Q' ORDER BY qtoazt_posts.created DESC LIMIT 0,50

0.61 ms - 0 rows - 34 columns

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

0.25 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.20 ms - 2 rows - 8 columns

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

0.16 ms - 11 rows - 5 columns

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

0.43 ms - 0 rows - 3 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=NULL UNION SELECT parent.parentid FROM qtoazt_categories JOIN qtoazt_categories AS parent ON qtoazt_categories.parentid=parent.categoryid WHERE qtoazt_categories.categoryid=NULL UNION SELECT parentid FROM qtoazt_categories WHERE categoryid=NULL UNION SELECT categoryid FROM qtoazt_categories WHERE categoryid=NULL) 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.62 ms - 51 rows - 9 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;

23.79 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.52 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.36 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.20 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.20 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.19 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'

0.22 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.21 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.16 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.15 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.14 ms - 1 row - 21 columns