Page 1 of 1
show mysql queries
Posted: Fri May 11, 2007 11:25 am
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
Re: show mysql queries
Posted: Fri May 11, 2007 11:35 am
by pishkus
Yes. Turn the debug mode ON in config.php file.
Re: show mysql queries
Posted: Fri May 11, 2007 11:37 am
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.
Re: show mysql queries
Posted: Fri May 11, 2007 12:44 pm
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.
Re: show mysql queries
Posted: Fri May 11, 2007 4:33 pm
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.
Re: show mysql queries
Posted: Mon May 14, 2007 8:41 am
by pishkus
what bothers me most, why the hell query "SELECT * FROM cms_content WHERE default_content = 1" is repeated for over 30 times???
Re: show mysql queries
Posted: Mon May 14, 2007 10:47 am
by KO
Do you have CSM selflink call in your template? Try to replace that with static link.
br,
K
Re: show mysql queries
Posted: Mon May 14, 2007 10:53 am
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.
Re: show mysql queries
Posted: Tue Aug 07, 2007 11:39 am
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
Re: show mysql queries
Posted: Tue Aug 07, 2007 11:59 am
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
Re: show mysql queries
Posted: Tue Aug 07, 2007 12:56 pm
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.