CMS Made Simple Forums

Posted: **Tue May 06, 2008 5:38 pm**

I was tring to lower this by following all the sugguestion that i've been finding in here, yet i have not gotten it that much better from where is was... I was wondering if someone could lend a hand on this... I can't cut out the style sheets they need to be editable in the CMS as it is... um... after that I don't know how else to cut back... an ideas would be great... thanks

Stats:
CMS v 1.2.3
php4
mysql5

Where it is at
first load

refresh

the template

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<__html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
{* Change lang="en" to the language of your site *}
{metadata}
{* Don't remove this! Metadata is entered in Site Admin/Global settings. *}
{style_switcher action="css_head" template="business_design"}
{stylesheet}
{* This is how all the stylesheets attached to this template are linked to *}
{cms_selflink dir="start" rellink=1}
{cms_selflink dir="prev" rellink=1}
{cms_selflink dir="next" rellink=1}


<head>
<title>{sitename} - {title}</title>
{* The sitename is changed in Site Admin/Global settings. {title} is the name of each page *}
{* Relational links for interconnections between pages, good for accessibility and Search Engine Optmization *}
<!--[if IE]>
<__script__ type="text/javascript" src="modules/MenuManager/CSSMenu.js"></__script>
<![endif]-->

</head>
</__body>
<table id="maintable" cellspacing="0" cellpadding="0">
  <tr>
    <td id="leftGRD"></td>
    <td id="pagewrapper">
<div id="pagewrapper2">
    {* start accessibility skip links *}
    <ul class="accessibility">
      <li>{anchor anchor='menu_vert' title='Skip to navigation' accesskey='n' text='Skip to navigation'}</li>
      <li>{anchor anchor='main' title='Skip to content' accesskey='s' text='Skip to content'}</li>
    </ul>
    {* end accessibility skip links *}

    <hr class="accessibility" />
    {* Horizontal ruler that is hidden for visual browsers by CSS *}

   {* Start Header, with logo image that links to the default start page. Logo image is changed in the stylesheet  "For template: Left menu + 1 column" *}
   <div id="header">
           <h1>{cms_selflink dir="start" text="$sitename"}</h1>
   <hr class="accessibility" />
   </div>
   {* End Header *}

<div id="midHeader" style="z-index: -1000">
  <div id="hideMe4" style="
	z-index: -1000;
	display: '';
"><__script__ type="text/javascript">
AC_FL_RunContent( 'codebase', 'https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0','width','775','height','197','title','Header','src','/Core_images/elements/Test resize','quality','high','pluginspage', 'https://www.macromedia.com/go/getflashplayer','movie','/Core_images/elements/Test resize' );
 //end AC code
</__script><noscript><object type="application/x-shockwave-flash"
data="c.swf?path=/Core_images/elements/Test resize.swf" 
width="775" height="197">
<param name="movie" 
value="c.swf?path=/Core_images/elements/Test resize.swf" />
</object></noscript></div> 
</div>
   {* Start Search *}
   <div id="search">
          {search}
   </div>
   {* End Search *}

   {* Start Breadcrumbs *}
   <div class="breadcrumbs">
        {breadcrumbs starttext='You are here' root='Home' delimiter='»'}
   <hr class="accessibility" />
   </div>
   {* End Breadcrumbs *}

   {* Start Content (Navigation and Content columns) *}
   <div id="content">
      {* Start Sidebar *}
      <div id="sidebar">
      {* Start Navigation *}
      <div id="menu_vert">
{cms_module module='menumanager' template='tempCSS'}
         <h2 class="accessibility">Navigation</h2>
      </div>
      {* End Navigation *}
      {* Start News *}
      <div id="news">
         <h2>News</h2>
          {news number='1' detailpage='news'}
      </div>


<div style="text-align:left;" >

<a href="../pacs.html" onclick="return popup(this,'bigwindow')" ><img border="0" width="204" src="../pacs.png" height="38" alt="PACS Link"/></a>
</div>
<div style="text-align:right;" >
<br/><br/>
<a target="_self" href="/St_Joe_Core/services/CHERC/"><img border="0" width="180" src="/St_Joe_Core/images/cherc_DB_flat.gif" alt="Community Health Education Resource Center" height="63" /></a>
<br/>
<br/>
<a target="_self" href="/St_Joe_Core/foundation/" onmousedown="javascript:toggleDiv('hideMe3')"><img border="0" width="180" src="/St_Joe_Core/images/logo_foundation.gif" alt="St. Joseph Regional Medical Center Foundation" height="50" /></a>
<br/>
<a target="_blank" href="http://www.ascensionhealth.org/"><img border="0" width="160" src="../images/logo_ascension_health.gif" alt="Ascension Health" height="73" /></a>
<br/><br/>
</div>



      {* End News *}
      </div>
      {* End Sidebar *}
      {* Start Content Area *}
      <div id="main">
         <div style="float: right;">
{print showbutton=true script=true}</div>
         <h2>{title}</h2> 
         {content} <br />
         {* Start relational links *}
	 <div class="hr"><table width="100%" border="0" cellspacing="0" cellpadding="0" summary="Qiuck Contact List">
  <tr>
    <td align="right"><span style="color:#00194d;font-weight: bold;"><a href="about-st-joseph/contact-st-joseph/" target="_self" onMouseDown="javascript:toggleDiv('hideMe3')">Contact Us</a> • <a href="find-a-doctor/" target="_self" onMouseDown="javascript:toggleDiv('hideMe3')">Find A Doctor</a> • <a href="services/CHERC/" target="_self" onMouseDown="javascript:toggleDiv('hideMe3')">Join A Class</a></span></td>
  </tr>
</table></div>

         <div>
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="9px"><img src="images/Aceess_Link_left.gif" width="9" height="51" alt=" "></td>
    <td class="AccessLink"><span class="AccessLinktitle" >Accessibility  links</span><br/><span class="AccessLinks" >{cms_selflink dir="previous" label="Previous page: "}<br/> 
{cms_selflink dir="next"}</span>
</td>
    <td width="41px"><img src="images/Aceess_Link_right.gif" width="41" height="51" alt=" "></td>
  </tr>
</table>

         </div>
         {* The label parameter doesn't need to be there if you're using English, but is here to show how it's used if you don't want the English text "Previous page" *}
	 {* End relational links *}

      <hr class="accessibility" />
      </div>
	  {* End Content Area *}

   </div>
   {* End Content *}

   {* Start Footer. Edit the footer in the Global Content Block called "footer" *}
   <div id="footer">

<br/>This site was Created by <a href="http://digitalbarn.tv/"><font color="#ffffff"><font color="#ff0000">d</font>igital <font color="#ff0000">b</font>arn productions</font></a><br/>
Managed by {emailPROTECT mailbox="dbjeremy" domain="cableone.net" name="Jeremy Bass" subject="From St joe" color="color:#ffffff"}<br/><br/>



   </div> 

   {* End Footer  *}

</div>
{* end pagewrapper *}</td>
    <td id="rightGRD">
{if $ccuser->loggedin() && $ccuser->memberof('Staff')}
<br /><br /><br /><__script__ type="text/javascript">    AC_FL_RunContent('codebase', 'https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0','width','188','height','350','id','video_player','align','middle','src','/Core_images/elements/Flash/video_player','quality','best','wmode','transparent','bgcolor','#ffffff','name','video_player','allowscriptaccess','sameDomain','pluginspage', 'https://www.macromedia.com/go/getflashplayer','movie','/Core_images/elements/Flash/video_player' );
 //end AC code</script><noscript></noscript>
{else}

{/if}

</td>
  </tr>
</table>
<div id="hideMe3" style="
display: none;
position: fixed;
bottom: 0;
left: 0;
z-index: 100;
">

<__script__ type="text/javascript"> 
AC_FL_RunContent( 'codebase', 'https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0','width','362','height','35','title','Header','src','/Core_images/elements/Flash/pageLoading','wmode', 'transparent','quality','high','pluginspage', 'https://www.macromedia.com/go/getflashplayer','movie','/Core_images/elements/Flash/pageLoading' ); 
//end AC code
</__script><noscript><object type="application/x-shockwave-flash"
data="c.swf?path=/Core_images/elements/Flash/pageLoading.swf" 
width="362" height="35">
<param name="wmode" value="transparent" />
<param name="movie" 
value="c.swf?path=/Core_images/elements/Flash/pageLoading.swf" />
</object></noscript></div> 
<__body>
</__html>

Posted: **Tue May 06, 2008 5:41 pm**

Here is that output... in the text file

Here is the link
https://www.sjrmc.org/St_Joe_Core/test_area/

Posted: **Tue May 06, 2008 7:32 pm**

Ok then so i took out the stylesheets and hard coded them in to test... and the queries only went down 2... why is there so many, there has to be a way to cut that down... or cut down the prase time ... um something... heck i don't understand why i'm geting the album css when i'm not even viewing that... I'm thinking at that are many un-needed call to the DB... please any ideas would be great.. thanks....

Posted: **Wed May 07, 2008 3:42 am**

I'm thinking at that are many un-needed call to the DB

IMHO you are right...

Maybe this can help you too:
http://dev.cmsmadesimple.org/tracker/in ... 6&atid=103

Posted: **Wed May 07, 2008 4:29 pm**

:)What do i do what that?

Posted: **Sat May 10, 2008 8:58 pm**

How many modules do you have installed that you don't use, sometimes it queries all the modules whether they are used or not...

Deleting unused modules may help...

Posted: **Sun May 11, 2008 4:24 pm**

I've fixed a problem with the cms_selflink tag that resulted in an abnormally large number of queries

Posted: **Mon May 12, 2008 2:09 am**

Is it available in the forge?...

Posted: **Mon May 12, 2008 3:35 pm**

@calguy1000 ... So what it the fix for that? Is it something I have to do or download?

@mark ... well I have a lot installed but the only queries that I see that are being done when the mod is not in use is the album... any ideas on how to get that one to stop?

Thank you two for the help... hope your weekend was swell... and have a great day.

jeremyBass

Posted: **Mon May 12, 2008 3:39 pm**

the cms_sefllink plugin is committed to SVN and will be out with 1.3

if you're in a hurry you can download the file from svn.

Posted: **Mon May 12, 2008 3:43 pm**

if you're in a hurry you can download the file from svn.

Well is it not always the client that is in the hurry lol... is there in risk of problem if I down load it from the svn? I have not looking at it and don't know of the top of my head... thanks again calguy

Posted: **Mon May 12, 2008 3:51 pm**

JeremyBASS wrote::)What do i do what that?

I have provided a patch in standard diff format for this issue. Just apply the patch.

JeremyBASS wrote:is there in risk of problem if I down load it from the svn?

But if you are not familar with diff/patch, it could be easier, to just download the file from svn (which have the same change applied):
--> http://svn.cmsmadesimple.org/svn/cmsmad ... lflink.php

Posted: **Mon May 12, 2008 4:16 pm**

Ok... this was odd... so I downloaded the file... then uploaded... and well this is what I got

That is an increase of 4 queries... um... I thought it was going to go down... any ideas?

Posted: **Mon May 12, 2008 5:05 pm**

That is an increase of 4 queries... um... I thought it was going to go down... any ideas?

Well, for me this is a increase of ~50 queries (in my current project).

For a test you can enable debug mode in config.php and look which queries are executed in detail. (e.g. the statistics module needs a lot queries).

Posted: **Mon May 12, 2008 5:26 pm**

Here is the debug output... i have to work out the login Emergency in the last post... but thought i'd throw this up...
any idea why this would be so many?... looks like some are copy of them self...

Generated in 2.953547 seconds by CMS Made Simple using 78 SQL queries and n/a bytes of memory

Debug: (0.036076) loading smarty

Debug: (0.041283) loading adodb

Debug: (0.046824) loading page functions

Debug: (0.049906) loading content functions

Debug: (0.053357) loading pageinfo functions

Debug: (0.056397) loading translation functions

Debug: (0.058848) loading events functions

Debug: (0.06276) done loading files

Debug: (0.088755)
(mysql): SELECT sitepref_name, sitepref_value from StJoe_CMS_siteprefs
Error (0):

Debug: (0.105716)
(mysql): SELECT * FROM StJoe_CMS_userplugins
Error (0):

Debug: (0.131509)
(mysql): SELECT * FROM StJoe_CMS_modules WHERE admin_only = 0 ORDER BY module_name
Error (0):

Debug display of 'End of include':(1.180898)

Debug display of 'Load Content Operations':(1.181226)

Debug display of 'End Load Content Operations':(1.188596)

Debug: (1.189046)
(mysql): SELECT content_id FROM StJoe_CMS_content WHERE default_content = 1
Error (0):

Debug: (1.190408)
(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 StJoe_CMS_templates t INNER JOIN StJoe_CMS_content c ON c.template_id = t.template_id WHERE (c.content_alias = '52' OR c.content_id = '52') AND c.active = 1
Error (0):

Debug: (1.190934)
(mysql): SELECT MAX(modified_date) AS thedate FROM StJoe_CMS_content c
Error (0):

Debug: (1.229454)
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM StJoe_CMS_templates WHERE template_id = '17'
Error (0):

Debug: (1.244892)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.245343)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.246152)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):

Debug: (1.246653)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.247041)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.251478)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):

Debug: (1.254281)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.254923)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.257168)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):

Debug: (1.258127)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_belongs WHERE userid=0
Error (0):

Debug: (1.259153)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.25953)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):

Debug: (1.264853)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):

Debug: (1.266585)
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM StJoe_CMS_event_handlers eh
INNER JOIN StJoe_CMS_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC
Error (0):

Debug: (1.54931)
(mysql): SELECT DISTINCT media_type FROM StJoe_CMS_css c, StJoe_CMS_css_assoc
WHERE css_id = assoc_css_id
AND assoc_type = 'template'
AND assoc_to_id = '17'
Error (0):

Debug display of 'Start Loading Hierarchy Manager':(1.549508)

Debug display of 'starting tree':(1.549549)

Debug: (1.552143) file needs loading

Debug: (1.556479)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = -1 ORDER BY hierarchy
Error (0):

Debug display of 'ending tree':(1.560942)

Debug display of 'End Loading Hierarchy Manager':(1.561018)

Debug: (1.562817)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):

Debug: (1.56354)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '52'
Error (0):

Debug: (1.56578)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):

Debug: (1.568712)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):

Debug: (1.569468)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '53'
Error (0):

Debug: (1.57202)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):

Debug: (1.57378) start global_content_get_template

Debug: (1.579495)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'HeaderFLASH'
Error (0):

Debug: (1.581007) end global_content_get_template

Debug: (1.581077) start global_content_get_timestamp

Debug: (1.581134) end global_content_get_timestamp

Debug: (1.674847)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'
Error (0):

Debug: (1.675595)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'
Error (0):

Debug: (1.866484)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611124
Error (0):

Debug: (1.868502)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611124
Error (0):

Debug: (1.870235)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):

Debug: (1.871143)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_alias = '\'\'login\'\''
Error (0):

Debug: (1.871392) start findNodeByTag

Debug: (1.871452) end findNodeByTag

Debug: (1.872083)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_alias = 'Home'
Error (0):

Debug display of 'Start of Menu Manager Display':(1.874599)

Debug: (1.876274)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '53' ORDER BY hierarchy
Error (0):

Debug: (1.88142)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '87' ORDER BY hierarchy
Error (0):

Debug: (1.884402) load properties called

Debug: (1.885012)
(mysql): SELECT * FROM StJoe_CMS_content_props WHERE content_id = '143'
Error (0):

Debug: (1.886205)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '66'
Error (0):

Debug: (1.88818)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '66' ORDER BY hierarchy
Error (0):

Debug: (1.889885)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '69' ORDER BY hierarchy
Error (0):

Debug: (1.892692)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '67'
Error (0):

Debug: (1.893828)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '67' ORDER BY hierarchy
Error (0):

Debug: (1.895037)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '56'
Error (0):

Debug: (1.899987)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '56' ORDER BY hierarchy
Error (0):

Debug: (1.902269)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '58'
Error (0):

Debug: (1.903514)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '58' ORDER BY hierarchy
Error (0):

Debug: (1.905692)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '64'
Error (0):

Debug: (1.920967)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '65'
Error (0):

Debug: (1.922513)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '65' ORDER BY hierarchy
Error (0):

Debug: (1.923735)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '75'
Error (0):

Debug: (1.925297)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '76'
Error (0):

Debug: (1.926331)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '88'
Error (0):

Debug: (1.941455)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '103'
Error (0):

Debug: (1.953902)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '104'
Error (0):

Debug: (1.955041)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '107'
Error (0):

Debug: (1.974353)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'MenuManager' and template_name = 'tempCSS'
Error (0):

Debug: (1.97837)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'MenuManager' and template_name = 'tempCSS'
Error (0):

Debug display of 'End of Menu Manager Display':(2.181296)

Debug: (2.188419)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_alias = 'news'
Error (0):

Debug: (2.188567) start findNodeByTag

Debug: (2.188899) end findNodeByTag

Debug: (2.190438)
(mysql):
SELECT count(mn.news_id) as count
FROM StJoe_CMS_module_news mn
LEFT OUTER JOIN StJoe_CMS_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN StJoe_CMS_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
( IFNULL(start_time, '1969-12-31 19:00:01') < '2008-05-12 13:22:04') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2008-05-12 13:22:04'))
Error (0):

Debug: (2.221576)
(mysql):
SELECT
mn.*,
mnc.news_category_name,
mnc.long_name,
u.username,
u.first_name,
u.last_name
FROM StJoe_CMS_module_news mn
LEFT OUTER JOIN StJoe_CMS_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN StJoe_CMS_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
( IFNULL(start_time, '1969-12-31 19:00:01') < '2008-05-12 13:22:04') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2008-05-12 13:22:04')) ORDER BY news_date desc LIMIT 0, 1
Error (0):

Debug: (2.224338)
(mysql): SELECT A.value,B.id,B.name,B.type FROM StJoe_CMS_module_news_fieldvals A, StJoe_CMS_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '2' ORDER BY B.item_order
Error (0):

Debug: (2.254742)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'News' and template_name = 'summarySample'
Error (0):

Debug: (2.255324)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'News' and template_name = 'summarySample'
Error (0):

Debug: (2.326863) start global_content_get_template

Debug: (2.32748)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'Side_Bar_Links'
Error (0):

Debug: (2.32766) end global_content_get_template

Debug: (2.327708) start global_content_get_timestamp

Debug: (2.327756) end global_content_get_timestamp

Debug: (2.349542)
(mysql): SELECT * from StJoe_CMS_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'
Error (0):

Debug: (2.351593)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'
Error (0):

Debug: (2.352131)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'
Error (0):

Debug: (2.402253) start findNodeByTag

Debug: (2.402322) end findNodeByTag

Debug: (2.4025) load properties called

Debug: (2.403913)
(mysql): SELECT * FROM StJoe_CMS_content_props WHERE content_id = '52'
Error (0):

Debug: (2.404088) load properties called

Debug: (2.404932)
(mysql): SELECT * FROM StJoe_CMS_content_props WHERE content_id = '52'
Error (0):

Debug: (2.443617) start global_content_get_template

Debug: (2.444172)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'Qikcon'
Error (0):

Debug: (2.44436) end global_content_get_template

Debug: (2.44441) start global_content_get_timestamp

Debug: (2.444459) end global_content_get_timestamp

Debug: (2.476832)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):

Debug: (2.47863)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):

Debug: (2.481276) start global_content_get_template

Debug: (2.481757)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'footer'
Error (0):

Debug: (2.481933) end global_content_get_template

Debug: (2.481982) start global_content_get_timestamp

Debug: (2.48203) end global_content_get_timestamp

Debug: (2.651366) start global_content_get_template

Debug: (2.652789)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'Loading'
Error (0):

Debug: (2.652971) end global_content_get_template

Debug: (2.65302) start global_content_get_timestamp

Debug: (2.653068) end global_content_get_timestamp

Debug: (2.687986) start global_content_get_template

Debug: (2.688874)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'QuickLink'
Error (0):

Debug: (2.68907) end global_content_get_template

Debug: (2.689122) start global_content_get_timestamp

Debug: (2.689173) end global_content_get_timestamp

CMS Made Simple Forums

Too many SQL queries, why?

Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?

Re: Too many SQL queries, why?