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

...

	Total		PHP			MySQL			Other		RAM
	Time (ms)	%	Time (ms)	%	File count	Time (ms)	%	Query count	Time (ms)	%	Amount	%
Setup	70.5	35%	69.1	34%	46	1.1	0%	2	0.4	0%	243k	29%
Control	30.3	15%	24.5	12%	10	6.8	3%	12	0.0	0%	112k	13%
View	42.2	21%	42.1	21%	24	0.0	0%	0	0.1	0%	96k	11%
Theme	52.9	26%	18.1	9%	4	35.8	18%	14	0.0	0%	359k	44%
Stats	2.8	1%	0.2	0%	0	2.6	1%	2	0.0	0%	0k	0%
Total	198.7	100%	154.0	77%	84	46.3	23%	30	0.0	0%	813k	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.92 ms - 816 rows - 2 columns

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

0.15 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=15942

1.38 ms - 1 row - 44 columns

0.53 ms - 0 rows - 44 columns

0.48 ms - 0 rows - 44 columns

0.47 ms - 0 rows - 34 columns

0.35 ms - 0 rows - 44 columns

0.43 ms - 0 rows - 44 columns

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

0.29 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=15942) 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=15942) UNION SELECT parentid FROM qtoazt_categories WHERE categoryid=(SELECT categoryid FROM qtoazt_posts WHERE postid=15942) UNION SELECT categoryid FROM qtoazt_categories WHERE categoryid=(SELECT categoryid FROM qtoazt_posts WHERE postid=15942)) 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.89 ms - 51 rows - 9 columns

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

0.38 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.23 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.23 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=15942 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=15942 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=15942) AND qtoazt_categories.qcount<10000)) x WHERE postid!=15942 GROUP BY postid ORDER BY score DESC LIMIT 5) y ON qtoazt_posts.postid=y.postid

4.07 ms - 5 rows - 35 columns

SELECT postid, content, format FROM qtoazt_posts WHERE postid IN (3838,13967,13386,11876,6986)

0.38 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;

28.36 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.47 ms - 1 row - 21 columns

0.28 ms - 1 row - 21 columns

0.20 ms - 1 row - 21 columns

0.30 ms - 1 row - 21 columns

0.25 ms - 1 row - 21 columns

0.20 ms - 1 row - 21 columns

0.16 ms - 1 row - 21 columns

0.15 ms - 1 row - 21 columns

0.23 ms - 1 row - 21 columns

0.16 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

0.60 ms - 100 rows - 2 columns

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

1.26 ms

UPDATE qtoazt_posts AS x, (SELECT parents.postid, MAX(parents.created) AS qcreated, COALESCE(MAX(children.created), MAX(parents.created)) as acreated, COUNT(children.postid) AS acount, MAX(parents.netvotes) AS netvotes, MAX(parents.views) AS views FROM qtoazt_posts AS parents LEFT JOIN qtoazt_posts AS children ON parents.postid=children.parentid AND children.type='A' WHERE parents.postid BETWEEN 15942 AND 15942 GROUP BY postid) AS a SET x.hotness=(((TO_DAYS(a.qcreated)-734138)*86400.0+TIME_TO_SEC(a.qcreated))*100 + ((TO_DAYS(a.acreated)-734138)*86400.0+TIME_TO_SEC(a.acreated))*100 + (a.acount+0.0)*16000000 + (a.netvotes+0.0)*16000000 + (a.views+0.0)*400000) WHERE x.postid=a.postid

1.36 ms

মানুষ কেন নামাজ পড়ে না?

এই প্রশ্নটির উত্তর দিতে দয়া করে প্রবেশ কিংবা নিবন্ধন করুন ।

0 উত্তর

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

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

বিভাগসমূহ

সবচেয়ে জনপ্রিয় ট্যাগসমূহ