show mysql queries

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Locked
crisb

show mysql queries

Post by crisb »

hi there,

is there a way to show the querries that are made to the database?
because right now i have 80querries+/page. since im on a blazingly fast machine it is not that important. but 80 queries seems a little bit to much.

thanks,
chris
Top
pishkus

Re: show mysql queries

Post by pishkus »

Yes. Turn the debug mode ON in config.php file.
Top
pishkus

Re: show mysql queries

Post by pishkus »

BTW: try to disable all modules you are not using, also, if you display all the content tree as a menu, this might be the problem, because all the content is loaded, and the information of one node is selected from DB with one query. So if you have 80 page and all in menu as links - this is the reason.
Top
crisb

Re: show mysql queries

Post by crisb »

seems as if there are several queries that are made more than one time.
but to be honest, i dont know why.

here is the debug output:

Code: Select all

Generated in 0.306873 seconds by CMS Made Simple using 87 SQL queries and 4799032 bytes of memory
Debug: (0.009863) - (527088)

loading smarty

Debug: (0.015567) - (764472)

loading adodb

Debug: (0.017176) - (816960)

loading page functions

Debug: (0.021137) - (975240)

loading content functions

Debug: (0.024651) - (1130032)

loading pageinfo functions

Debug: (0.025498) - (1155616)

loading translation functions

Debug: (0.026109) - (1170120)

loading events functions

Debug: (0.028067) - (1249208)

done loading files

Debug: (0.042662) - (1813944)

<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
 Error (0): <br>

Debug: (0.046125) - (1856680)

<br>
(mysql): SELECT * FROM cms_userplugins<br>

 Error (0): <br>

Debug: (0.054592) - (2187792)

<br>
(mysql): SELECT * FROM cms_modules WHERE admin_only = 0 ORDER BY module_name<br>
 Error (0): <br>

Debug display of 'End of include':(0.085357) - (2642016)

Debug: (0.086059) - (2604904)

<br>
(mysql): SELECT c.content_id, c.content_name, c.content_alias, c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by,t.template_id, t.encoding, t.modified_date AS t_date FROM cms_templates t INNER JOIN cms_content c ON c.template_id = t.template_id WHERE c.content_alias = 'horoscope-elle' AND c.active = 1<br>
 Error (0): <br>

Debug: (0.08648) - (2603640)

<br>
(mysql): SELECT MAX(modified_date) AS thedate FROM cms_content c<br>
 Error (0): <br>

Debug display of 'Load Content Operations':(0.08698) - (2603568)

Debug display of 'End Load Content Operations':(0.095686) - (2984328)

Debug: (0.098834) - (3117024)

<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '20'<br>
 Error (0): <br>

Debug: (0.112786) - (3855992)

<br>
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
        INNER JOIN cms_events e ON e.event_id = eh.event_id
        ORDER BY eh.handler_order ASC<br>

 Error (0): <br>

Debug: (0.15639) - (4080856)

<br>
(mysql): SELECT DISTINCT media_type FROM cms_css c, cms_css_assoc
      WHERE  css_id    = assoc_css_id
      AND    assoc_type  = 'template'
      AND    assoc_to_id = '20'<br>
 Error (0): <br>

Debug display of 'Start Loading Hierarchy Manager':(0.156772) - (4080800)

Debug display of 'starting tree':(0.156864) - (4080984)

Debug: (0.159711) - (4186736)

file needs loading

Debug: (0.16224) - (4311184)

<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = -1 ORDER BY hierarchy<br>

 Error (0): <br>

Debug display of 'ending tree':(0.168424) - (4504136)

Debug display of 'End Loading Hierarchy Manager':(0.168564) - (4476888)

Debug: (0.170692) - (4490128)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.17116) - (4490528)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.171611) - (4490848)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.172047) - (4491144)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.17249) - (4491440)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.172925) - (4491736)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.173356) - (4492032)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.173785) - (4492328)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.174219) - (4492752)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.174651) - (4493048)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.175081) - (4493344)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.175511) - (4493640)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.17595) - (4493936)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.176381) - (4494232)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.176822) - (4494528)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.17725) - (4494824)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.177676) - (4495120)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.178105) - (4495416)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.178529) - (4495712)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.178953) - (4496008)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.179378) - (4496304)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.179816) - (4496600)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.180242) - (4496896)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.180683) - (4497192)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.18112) - (4497488)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.181594) - (4497784)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.182041) - (4498080)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.182472) - (4498376)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.1829) - (4498664)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.183327) - (4498968)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
 Error (0): <br>

Debug: (0.18376) - (4499264)

<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>

 Error (0): <br>

Debug: (0.184271) - (4499696)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '59'<br>
 Error (0): <br>

Debug: (0.186938) - (4505232)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '168'<br>
 Error (0): <br>

Debug: (0.18771) - (4507736)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '183'<br>

 Error (0): <br>

Debug: (0.188464) - (4511304)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '167'<br>
 Error (0): <br>

Debug: (0.188924) - (4514600)

load properties called

Debug: (0.189297) - (4515000)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '167'<br>
 Error (0): <br>

Debug: (0.191839) - (4519432)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '170'<br>
 Error (0): <br>

Debug: (0.192611) - (4522944)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '171'<br>

 Error (0): <br>

Debug: (0.193365) - (4526528)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '172'<br>
 Error (0): <br>

Debug: (0.194131) - (4530320)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '173'<br>
 Error (0): <br>

Debug: (0.194878) - (4533856)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '174'<br>

 Error (0): <br>

Debug: (0.19711) - (4616200)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_head'<br>
 Error (0): <br>

Debug: (0.202157) - (4674008)

start global_content_get_template

Debug: (0.204241) - (4741904)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'right_content'<br>
 Error (0): <br>

Debug: (0.204617) - (4743632)

end global_content_get_template

Debug: (0.204731) - (4743848)

start global_content_get_timestamp

Debug: (0.204831) - (4744064)

end global_content_get_timestamp

Debug display of 'Start of Menu Manager Display':(0.208479) - (4783512)

Debug: (0.2091) - (4784216)

<br>

(mysql): SELECT * FROM cms_content WHERE content_id = '166'<br>
 Error (0): <br>

Debug: (0.209584) - (4786792)

load properties called

Debug: (0.210022) - (4787064)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '166'<br>

 Error (0): <br>

Debug: (0.211445) - (4800080)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '169'<br>
 Error (0): <br>

Debug: (0.212269) - (4803552)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '182'<br>
 Error (0): <br>

Debug: (0.213068) - (4806352)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '53'<br>

 Error (0): <br>

Debug: (0.213509) - (4807856)

load properties called

Debug: (0.213851) - (4808248)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '53'<br>
 Error (0): <br>

Debug: (0.214731) - (4809168)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '54'<br>
 Error (0): <br>

Debug: (0.215174) - (4812224)

load properties called

Debug: (0.215517) - (4812616)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '54'<br>
 Error (0): <br>

Debug: (0.2164) - (4813480)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '55'<br>

 Error (0): <br>

Debug: (0.216884) - (4817616)

load properties called

Debug: (0.217233) - (4818088)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '55'<br>
 Error (0): <br>

Debug: (0.218127) - (4819080)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '113'<br>
 Error (0): <br>

Debug: (0.218587) - (4823152)

load properties called

Debug: (0.218935) - (4824352)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '113'<br>
 Error (0): <br>

Debug: (0.219844) - (4828632)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '56'<br>

 Error (0): <br>

Debug: (0.220304) - (4832616)

load properties called

Debug: (0.22066) - (4833808)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '56'<br>
 Error (0): <br>

Debug: (0.221544) - (4834880)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '57'<br>
 Error (0): <br>

Debug: (0.221997) - (4838792)

load properties called

Debug: (0.222333) - (4839984)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '57'<br>
 Error (0): <br>

Debug: (0.22321) - (4841072)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '157'<br>

 Error (0): <br>

Debug: (0.223979) - (4845616)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '158'<br>
 Error (0): <br>

Debug: (0.224727) - (4849608)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '159'<br>
 Error (0): <br>

Debug: (0.225476) - (4853552)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '162'<br>

 Error (0): <br>

Debug: (0.227926) - (4949320)

<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'question_nav'<br>
 Error (0): <br>

Debug: (0.228423) - (4952000)

<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'question_nav'<br>
 Error (0): <br>

Debug: (0.270045) - (5057328)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_nav'<br>

 Error (0): <br>

Debug: (0.27187) - (5057872)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.273552) - (5058320)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.275797) - (5058776)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_nav'<br>

 Error (0): <br>

Debug: (0.278444) - (5059248)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.280585) - (5059632)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.282258) - (5060072)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText WHERE name = 'fink_nav'<br>

 Error (0): <br>

Debug display of 'End of Menu Manager Display':(0.283029) - (4938392)

Debug: (0.283601) - (4903944)

start findNodeByTag

Debug: (0.283784) - (4904008)

end findNodeByTag

Debug: (0.284003) - (4904104)

load properties called

Debug: (0.28437) - (4904256)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '169'<br>
 Error (0): <br>

Debug: (0.284618) - (4905016)

load properties called

Debug: (0.284935) - (4905176)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '169'<br>
 Error (0): <br>

Debug: (0.286038) - (4975152)

<br>
(mysql): SELECT * FROM cms_module_TruetypeText_replacements<br>

 Error (0): <br>

Debug: (0.288334) - (4905544)

start global_content_get_template

Debug: (0.288758) - (4906312)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'icons'<br>
 Error (0): <br>

Debug: (0.289065) - (4906232)

end global_content_get_template

Debug: (0.289169) - (4906392)

start global_content_get_timestamp

Debug: (0.289266) - (4906552)

end global_content_get_timestamp

Debug: (0.295206) - (4907280)

start global_content_get_template

Debug: (0.295617) - (4907872)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'girl'<br>
 Error (0): <br>

Debug: (0.295924) - (4907784)

end global_content_get_template

Debug: (0.29603) - (4907944)

start global_content_get_timestamp

Debug: (0.296128) - (4908104)

end global_content_get_timestamp

Debug: (0.303128) - (4908888)

start global_content_get_template

Debug: (0.303555) - (4909992)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'footer'<br>

 Error (0): <br>

Debug: (0.303884) - (4910760)

end global_content_get_template

Debug: (0.30399) - (4910920)

start global_content_get_timestamp

Debug: (0.304088) - (4911080)

end global_content_get_timestamp
sorry, it is a little bit long. didnt found a appropriate tag for it.
Top
Pierre M.

Re: show mysql queries

Post by Pierre M. »

Hello chris,
crisb wrote: ...80 queries seems a little bit to much.
I'd have said : it is awfull too much !-)
Beware it may not run on a shared hosting. You should try cyberman's cache module for this.

Pierre M.
Top
pishkus

Re: show mysql queries

Post by pishkus »

what bothers me most, why the hell query "SELECT * FROM cms_content WHERE default_content = 1" is repeated for over 30 times???
Top
KO
Power Poster
Power Poster
Posts: 562
Joined: Mon Nov 06, 2006 7:55 pm

Re: show mysql queries

Post by KO »

Do you have CSM selflink call in your template? Try to replace that with static link.

br,

K
Top
Pierre M.

Re: show mysql queries

Post by Pierre M. »

Hello,
pishkus wrote: what bothers me most, why the hell query "SELECT * FROM cms_content WHERE default_content = 1" is repeated for over 30 times???
Yes, this is sub optimal for sure. May be from selflink.
In another thread (I don't remember which one), Cyberman has stated there is a config option in the PHP-SQL link to cache SQL queries. May be this could speed up 29 of these 30 calls.
Pierre M.
Top
crisb

Re: show mysql queries

Post by crisb »

it's been a while, but i recently found the time to update my project.
i deleted the selflink stuff and the querries decreased by ~30.

is there a way of getting rid of more querries?

Code: Select all

Generated in 0.299583 seconds by CMS Made Simple using 50 SQL queries and 5162296 bytes of memory
Debug: (0.010023) - (595376)

loading smarty

Debug: (0.015286) - (832552)

loading adodb

Debug: (0.01733) - (905296)

loading page functions

Debug: (0.020575) - (1053232)

loading content functions

Debug: (0.023636) - (1210456)

loading pageinfo functions

Debug: (0.024414) - (1236720)

loading translation functions

Debug: (0.025036) - (1254432)

loading events functions

Debug: (0.02673) - (1335640)

done loading files

Debug: (0.038088) - (1911144)

<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
 Error (0): <br>

Debug: (0.042201) - (1959304)

<br>
(mysql): SELECT * FROM cms_userplugins<br>
 Error (0): <br>

Debug: (0.050307) - (2310744)

<br>
(mysql): SELECT * FROM cms_modules WHERE admin_only = 0 ORDER BY module_name<br>
 Error (0): <br>

Debug display of 'End of include':(0.107889) - (3063736)
Debug: (0.108473) - (3032368)

<br>
(mysql): SELECT c.content_id, c.content_name, c.content_alias, c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by,t.template_id, t.encoding, t.modified_date AS t_date FROM cms_templates t INNER JOIN cms_content c ON c.template_id = t.template_id WHERE c.content_alias = 'etre-amoureuse' AND c.active = 1<br>
 Error (0): <br>

Debug: (0.108915) - (3032848)

<br>
(mysql): SELECT MAX(modified_date) AS thedate FROM cms_content c<br>
 Error (0): <br>

Debug display of 'Load Content Operations':(0.109333) - (3032776)
Debug display of 'End Load Content Operations':(0.116927) - (3420176)
Debug: (0.120297) - (3554080)

<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '20'<br>
 Error (0): <br>

Debug: (0.132603) - (4291352)

<br>
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
        INNER JOIN cms_events e ON e.event_id = eh.event_id
        ORDER BY eh.handler_order ASC<br>
 Error (0): <br>

Debug: (0.163345) - (4411568)

<br>
(mysql): SELECT DISTINCT media_type FROM cms_css c, cms_css_assoc
      WHERE  css_id    = assoc_css_id
      AND    assoc_type  = 'template'
      AND    assoc_to_id = '20'<br>
 Error (0): <br>

Debug: (0.164044) - (4452640)

start global_content_get_template

Debug: (0.166381) - (4521832)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'right_content'<br>
 Error (0): <br>

Debug: (0.166743) - (4523456)

end global_content_get_template

Debug: (0.166859) - (4523616)

start global_content_get_timestamp

Debug: (0.166958) - (4523776)

end global_content_get_timestamp

Debug display of 'Start of Menu Manager Display':(0.171282) - (4562528)
Debug display of 'Start Loading Hierarchy Manager':(0.171386) - (4562712)
Debug display of 'starting tree':(0.171463) - (4562936)
Debug: (0.174208) - (4668304)

file needs loading

Debug: (0.177045) - (4805376)

<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = -1 ORDER BY hierarchy<br>
 Error (0): <br>

Debug display of 'ending tree':(0.183661) - (5021864)
Debug display of 'End Loading Hierarchy Manager':(0.183788) - (4992624)
Debug: (0.184387) - (4994408)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '166'<br>
 Error (0): <br>

Debug: (0.184869) - (4998208)

load properties called

Debug: (0.185311) - (4999776)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '166'<br>
 Error (0): <br>

Debug: (0.186292) - (5011264)

<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '166' ORDER BY hierarchy<br>
 Error (0): <br>

Debug: (0.186828) - (5016352)

load properties called

Debug: (0.187223) - (5017552)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '167'<br>
 Error (0): <br>

Debug: (0.188369) - (5019728)

<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '167' ORDER BY hierarchy<br>
 Error (0): <br>

Debug: (0.190578) - (5037328)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '59'<br>
 Error (0): <br>

Debug: (0.19138) - (5039912)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '196'<br>
 Error (0): <br>

Debug: (0.191831) - (5043176)

load properties called

Debug: (0.192204) - (5044392)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '196'<br>
 Error (0): <br>

Debug: (0.193173) - (5046072)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '53'<br>
 Error (0): <br>

Debug: (0.193643) - (5050088)

load properties called

Debug: (0.194044) - (5051296)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '53'<br>
 Error (0): <br>

Debug: (0.194976) - (5052336)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '54'<br>
 Error (0): <br>

Debug: (0.195428) - (5056256)

load properties called

Debug: (0.195815) - (5057464)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '54'<br>
 Error (0): <br>

Debug: (0.196739) - (5058456)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '55'<br>
 Error (0): <br>

Debug: (0.197203) - (5062568)

load properties called

Debug: (0.197581) - (5063776)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '55'<br>
 Error (0): <br>

Debug: (0.198505) - (5064816)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '113'<br>
 Error (0): <br>

Debug: (0.198964) - (5068824)

load properties called

Debug: (0.199354) - (5070040)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '113'<br>
 Error (0): <br>

Debug: (0.200268) - (5074352)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '56'<br>
 Error (0): <br>

Debug: (0.200739) - (5078256)

load properties called

Debug: (0.201124) - (5079464)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '56'<br>
 Error (0): <br>

Debug: (0.202065) - (5080536)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '57'<br>
 Error (0): <br>

Debug: (0.20252) - (5084432)

load properties called

Debug: (0.202903) - (5085640)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '57'<br>
 Error (0): <br>

Debug: (0.20381) - (5086728)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '157'<br>
 Error (0): <br>

Debug: (0.205077) - (5091272)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '158'<br>
 Error (0): <br>

Debug: (0.205898) - (5095264)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '159'<br>
 Error (0): <br>

Debug: (0.206855) - (5099272)

<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '162'<br>
 Error (0): <br>

Debug: (0.20943) - (5199520)

<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'question_nav'<br>
 Error (0): <br>

Debug: (0.209975) - (5202456)

<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'question_nav'<br>
 Error (0): <br>

Debug: (0.256799) - (5376032)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.258903) - (5377112)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.26077) - (5377792)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.262644) - (5378504)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.264494) - (5379160)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.266345) - (5379784)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.268175) - (5380464)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug: (0.270006) - (5381216)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_styles WHERE name = 'fink_nav'<br>
 Error (0): <br>

Debug display of 'End of Menu Manager Display':(0.270668) - (5268440)
Debug: (0.271208) - (5234816)

start findNodeByTag

Debug: (0.271347) - (5234880)

end findNodeByTag

Debug: (0.271567) - (5234976)

load properties called

Debug: (0.272319) - (5235120)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '183'<br>
 Error (0): <br>

Debug: (0.272583) - (5239576)

load properties called

Debug: (0.273354) - (5239736)

<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '183'<br>
 Error (0): <br>

Debug: (0.277688) - (5365056)

<br>
(mysql): SELECT * FROM cms_module_truetypetext_replacements<br>
 Error (0): <br>

Debug: (0.279512) - (5260680)

start global_content_get_template

Debug: (0.279943) - (5261448)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'icons'<br>
 Error (0): <br>

Debug: (0.280254) - (5261368)

end global_content_get_template

Debug: (0.28036) - (5261528)

start global_content_get_timestamp

Debug: (0.280485) - (5261688)

end global_content_get_timestamp

Debug: (0.287367) - (5262272)

start global_content_get_template

Debug: (0.287795) - (5262864)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'girl'<br>
 Error (0): <br>

Debug: (0.288099) - (5262776)

end global_content_get_template

Debug: (0.288205) - (5262936)

start global_content_get_timestamp

Debug: (0.288309) - (5263096)

end global_content_get_timestamp

Debug: (0.29552) - (5263656)

start global_content_get_template

Debug: (0.295954) - (5264248)

<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'footer'<br>
 Error (0): <br>

Debug: (0.296269) - (5265016)

end global_content_get_template

Debug: (0.29638) - (5265176)

start global_content_get_timestamp

Debug: (0.296499) - (5265336)

end global_content_get_timestamp
Last edited by crisb on Tue Aug 07, 2007 11:45 am, edited 1 time in total.
Top
cyberman

Re: show mysql queries

Post by cyberman »

@Pierre M:
Pierre M. wrote: In another thread (I don't remember which one), Cyberman has stated there is a config option in the PHP-SQL link to cache SQL queries.
Do you meant this?

http://forum.cmsmadesimple.org/index.ph ... l#msg57157
Top
Pierre M.

Re: show mysql queries

Post by Pierre M. »

Yes, thank you Cyberman.
This may lower the number of SQL queries in one page generation.

@crisb : remember the goal should be to lower the total number of SQL queries, not just those for one page view. Try this tip, or Cyberman's cache module, or an Apache's mod_cache reverse proxy. 100 SQL queries is nothing for 10000 page views.

Pierre M.
Top
Locked

Return to “CMSMS Core”