mysql zapytania

**Lukasz** · Liczba postów: 1 615 Dołączył: 12.07.2009 Reputacja: 54

(26.10.2010 19:01)szymekszymek napisał(a): Jak sprawdzić jakie zapytania wysyła forum do mysql przy odświeżaniu strony ?

Na dole forum wyświetla się (o ile nie skasowałeś tego ze stylu lub nie wyłączyłeś) "Generated in...". Kliknij "advanced details", zobaczysz wszystkie zapytania.

Wtyczka Google Seo lubi wiele zapytań.

szymekszymek · Liczba postów: 30 Dołączył: 02.10.2010 Reputacja: 0

no wyłączyłem prawie wszystko oprócz google seo

Generated in 0.0686271 seconds (75.94% PHP / 24.06% MySQL)
SQL Queries: 53 / Global Parsing Time: 0.0291049 / Memory Usage: 7.5 MB
PHP version: 5.2.13 / Server Load: 4.44 / GZip Compression: Disabled

po wyłączeniu wszystkich modów

No. DB Queries: 27

Tidusek · 26.10.2010, 21:43

Przez wtyczki masz dwa razy więcej zapytań. Dobrze +/- obliczyłem ilości zapytań generowane przez pluginy. Wniosek: jeżeli chcesz mieć mało zapytań i chcesz aby Twoje forum zżerało mniej zasobów to musisz po prostu pozbyć się kilku wtyczek ;}

szymekszymek · 26.10.2010, 21:44

ale nie uwazasz ze 27 zapytan do mysQl przy wyłączonych wtyczkach to za duzo ?

Tidusek · 26.10.2010, 21:47

No dużo ale jak na MyBB to mało. MyBB jest jeszcze nie zoptymalizowany i dlatego tyle zapytań robi. Poczekaj do wersji 2.0 to wtedy to poprawią :}

szymekszymek · 26.10.2010, 21:58

Rozumiem. No to jakoś się przemęcze i postaram się to zoptymalizować jak najbardziej. Dzieki za poświęcony czas :]

**Lukasz** · 27.10.2010, 12:28

Ale 27 zapytań gdzie masz? Na stronie głównej? Zainteresuj się cachowanie danych.

szymekszymek · 28.10.2010, 18:27

Łukaszu aktualnie mam

No. DB Queries: 39

na stronie głównej oczywiscie.

Cache mam ustawione na files

, nie wiem dlaczego tak sie dzieje, po wyłączeniu modów zyskuje nie wiele..

A czy moge zapytać w tym temacie o transfer ? czy założyć nowy temat ?

**Lukasz** · 29.10.2010, 16:22

(28.10.2010 18:27)szymekszymek napisał(a): Łukaszu aktualnie mam

No. DB Queries: 39

na stronie głównej oczywiscie.

Cache mam ustawione na files

, nie wiem dlaczego tak sie dzieje, po wyłączeniu modów zyskuje nie wiele..

Podaj pełne statystyki (od "generated..." do końca).

(28.10.2010 18:27)szymekszymek napisał(a): A czy moge zapytać w tym temacie o transfer ? czy założyć nowy temat ?

Załóż lepiej nowy.

szymekszymek · Liczba postów: 30 Dołączył: 02.10.2010 Reputacja: 0

Prosze bardzo. ale ja i tak nic z tego nie rozumiem.

Kod:

MyBB Debug Information

Page Generation

Page Generation Statistics

Page Generation Time:     0.0874030590057 seconds     No. DB Queries:     39

PHP Processing Time:     0.0769165 seconds (88.00%)     DB Processing Time:     0.0104866 seconds (12.00%)

Extensions Used:     mysqli, xml     Global.php Processing Time:     0.0459650 seconds

PHP Version:     5.2.13     Server Load:     3.7

GZip Encoding Status:     Disabled     No. Templates Used:     62 (70 Cached / 0 Manually Loaded)

Memory Usage:     9.25 MB (9699328 bytes)     Memory Limit:     32M

Database Connections (1 Total)

[READ] [email protected] (Connected in 0s)



Database Queries (39 Total)

#1 - Write Query

SET NAMES 'utf8'

Query Time: 8.29696655273E-5



#2 - Select Query

SELECT * FROM mybb_sessions WHERE sid='033bb30ab09024a7aeed5b86ebc0e3a8' AND ip='195.150.61.242' LIMIT 1

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_sessions     const     PRIMARY,ip     PRIMARY     98     const     1     

Query Time: 0.000169038772583



#3 - Select Query

SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1

table     type     possible_keys     key     key_len     ref     rows     Extra

u     const     PRIMARY     PRIMARY     4     const     1     

f     const     PRIMARY     PRIMARY     4     const     1     

Query Time: 0.000411033630371



#4 - Write Query

UPDATE mybb_sessions SET `uid`='1', `time`='1288386569', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='033bb30ab09024a7aeed5b86ebc0e3a8' LIMIT 1

Query Time: 0.00182509422302



#5 - Select Query

SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='16' LIMIT 1

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_themes     const     PRIMARY     PRIMARY     2     const     1     

Query Time: 0.000203847885132



#6 - Select Query

SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'prostats' ,'prostats_readstate_icon' ,'prostats_newmembers' ,'prostats_newmembers_row' ,'prostats_topposters' ,'prostats_topposters_row' ,'prostats_topreferrers' ,'prostats_topreferrers_row' ,'prostats_mostthanks' ,'prostats_mostthanks_row' ,'prostats_newthreads' ,'prostats_newthreads_row' ,'prostats_newthreads_specialchar' ,'prostats_mostreplies' ,'prostats_mostreplies_row' ,'prostats_mostviews' ,'prostats_mostviews_row' ,'prostats_newposts' ,'prostats_newposts_row' ,'prostats_topdownloads' ,'prostats_topdownloads_row' ,'prostats_message' ,'prostats_onerowextra' ,'prostats_tworowextra' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','15') ORDER BY sid ASC

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_templates     ALL                     730     Using where; Using filesort

Query Time: 0.000143051147461



(Plugin Hook: index_start)

#7 - Select Query

SELECT t.subject,t.username,t.uid,t.tid,t.fid,t.lastpost,t.lastposter,t.lastposteruid,t.replies,tr.uid AS truid,tr.dateline,f.name FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0,7

table     type     possible_keys     key     key_len     ref     rows     Extra

t     index         lastpost     10         364     Using where

tr     eq_ref     tid     tid     8     studiopo_forum.t.tid,const     1     

f     eq_ref     PRIMARY     PRIMARY     2     studiopo_forum.t.fid     1     

Query Time: 0.000847101211548



(Plugin Hook: index_start)

#8 - Select Query

SELECT uid FROM mybb_sessions WHERE uid != '0' AND time > '1288385669'

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_sessions     range     time,uid     time     8         9     Using where

Query Time: 0.000173091888428



(Plugin Hook: index_start)

#9 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (567)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 0.000114917755127



(Plugin Hook: index_start)

#10 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (177,2,107,155,112,1)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     range     idtype,active     active     7         5     Using where

Query Time: 0.000201940536499



(Plugin Hook: index_start)

#11 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (31)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.6968460083E-5



(Plugin Hook: index_start)

#12 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (402)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.79221343994E-5



(Plugin Hook: index_start)

#13 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (21)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.6968460083E-5



(Plugin Hook: index_start)

#14 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (493)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.6968460083E-5



(Plugin Hook: index_start)

#15 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (49)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.6968460083E-5



(Plugin Hook: index_start)

#16 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (367)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 6.29425048828E-5



(Plugin Hook: index_start)

#17 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (176)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.6968460083E-5



(Plugin Hook: index_start)

#18 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (57)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.41074371338E-5



(Plugin Hook: index_start)

#19 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (564)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 6.41345977783E-5



(Plugin Hook: index_start)

#20 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (62)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.91142272949E-5



(Plugin Hook: index_start)

#21 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (508)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.79221343994E-5



(Plugin Hook: index_start)

#22 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (9)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.6968460083E-5



(Plugin Hook: index_start)

#23 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (565)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.81605529785E-5



(Plugin Hook: index_start)

#24 - Select Query

SELECT t.subject,t.tid,t.lastpost,t.views,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.views DESC LIMIT 0,8

table     type     possible_keys     key     key_len     ref     rows     Extra

t     ALL                     364     Using where; Using filesort

tr     eq_ref     tid     tid     8     studiopo_forum.t.tid,const     1     

f     eq_ref     PRIMARY     PRIMARY     2     studiopo_forum.t.fid     1     Using index

Query Time: 0.000736951828003



(Plugin Hook: index_start)

#25 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (295)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.79221343994E-5



(Plugin Hook: index_start)

#26 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (232)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.91142272949E-5



(Plugin Hook: index_start)

#27 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (391)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 6.00814819336E-5



(Plugin Hook: index_start)

#28 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (99)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.60147857666E-5



(Plugin Hook: index_start)

#29 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (161)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 4.6968460083E-5



(Plugin Hook: index_start)

#30 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (317)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 6.19888305664E-5



(Plugin Hook: index_start)

#31 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (95)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 0.000112056732178



(Plugin Hook: index_start)

#32 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (200)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 0.000107049942017



(Plugin Hook: index_start)

#33 - Select Query

SELECT t.subject,t.tid,t.replies,t.lastpost,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.replies DESC LIMIT 0,8

table     type     possible_keys     key     key_len     ref     rows     Extra

t     ALL                     364     Using where; Using filesort

tr     eq_ref     tid     tid     8     studiopo_forum.t.tid,const     1     

f     eq_ref     PRIMARY     PRIMARY     2     studiopo_forum.t.fid     1     Using index

Query Time: 0.000895977020264



(Plugin Hook: index_start)

#34 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (433)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     const     idtype,active     active     7     const,const,const     1     

Query Time: 6.91413879395E-5



#35 - Select Query

SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1288385669' ORDER BY u.username ASC, s.time DESC

table     type     possible_keys     key     key_len     ref     rows     Extra

s     range     time     time     8         9     Using where; Using temporary; Using filesort

u     eq_ref     PRIMARY     PRIMARY     4     studiopo_forum.s.uid     1     

Query Time: 0.000412940979004



#36 - Select Query

SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder

table     type     possible_keys     key     key_len     ref     rows     Extra

f     ALL                     43     Using where; Using filesort

fr     eq_ref     fid     fid     8     studiopo_forum.f.fid,const     1     

Query Time: 0.000130891799927



#37 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (1,18,20,65,30,54,23,63,62,24,52,59,49,25,9,10,44,47,19,32,34,8,50,42,21,36,26,27,28,45,46,33,57,29,31,43,51,61,60,64,66,67,68)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     ref     idtype,active     active     3     const,const     15     Using where

Query Time: 8.01086425781E-5



#38 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (480,503,564,498,446,317,493,563,508,456,93,224,542,101,511,391,239,199,402,370,343,57,270,141,418,313,367,303,567,193,352,512,465,543,549,522)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     range     idtype,active     active     7         36     Using where

Query Time: 7.91549682617E-5



#39 - Select Query

SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (1,176,155,154,49,2,85,144,68,66,160,10,50,34,124,3)

table     type     possible_keys     key     key_len     ref     rows     Extra

mybb_google_seo     range     idtype,active     active     7         16     Using where

Query Time: 7.10487365723E-5



Template Statistics

Templates Used (Loaded for this Page) - 62 Total

global_pm_alert, index, header_welcomeblock_member, header_welcomeblock_member_moderator, header_welcomeblock_member_admin, redirect, gobutton, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, global_unreadreports, global_pending_joinrequests, index_loginform, index_whosonline, index_stats, index_birthdays_birthday, forumbit_moderators, index_birthdays, index_logoutlink, error, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost, prostats, prostats_readstate_icon, prostats_newmembers, prostats_newmembers_row, prostats_topposters, prostats_topposters_row, prostats_topreferrers, prostats_topreferrers_row, prostats_mostthanks, prostats_mostthanks_row, prostats_newthreads, prostats_newthreads_row, prostats_newthreads_specialchar, prostats_mostreplies, prostats_mostreplies_row, prostats_mostviews, prostats_mostviews_row, prostats_newposts, prostats_newposts_row, prostats_topdownloads, prostats_topdownloads_row, prostats_message, prostats_onerowextra, prostats_tworowextra



Templates Requiring Additional Calls (Not Cached at Startup) - 0 Total