Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Tools & Knowledge For Speeding Up Site


sukarya

Recommended Posts

Hi,

 

I really need help with this one, my site loading has become very slow, i cant point why. I have made the changes written in the

Speed Up thread, but after a while it has be come very slow, again.

 

 

My site is this: www.jJudaica.com

Any tools, recommendations, comments and remarks are welcome.

 

Need it urgently, thanks!

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

Well, there seem to be a couple of issues. One is that your main page is 235KB in size, which is enormous. Second issue is that your webserver takes about 1.5 seconds before it starts sending data, so I would suggest contacting your web host and asking them about it. If that doesn't help, you should switch web hosts.

Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Link to comment
Share on other sites

Well, there seem to be a couple of issues. One is that your main page is 235KB in size, which is enormous. Second issue is that your webserver takes about 1.5 seconds before it starts sending data, so I would suggest contacting your web host and asking them about it. If that doesn't help, you should switch web hosts.

 

Thanks!

 

I have also started checking Queries etc.

I have Chemo's Query Debug contribution for this matter (a GREAT ONE): it seems that i have 121(!!!) db queries running.

 

I must reduce them....

 

May I ask what tool did you use to check the webserver sending data time?

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

also, i have conducted a check with this tool and this one.

 

You are definitely right regarding the hosting issue...

 

Regarding the weight issue: its quite a lot: around 100kb (according to this tool) its not very low, bit its not unusual.

 

I'm contacting the hosting com (1and1) as we speak...

 

Would love to read more thoughts,

 

Thanks!

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

You could try the Optimize categories box contribution because the query time is rather high so cutting down on the number of queries in that box should help.

 

Thanks, did it already. I think that the problem is with the categories: In the left box and on the tabs/subtabs.

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

This is defiantly a host issue. Their is absolutely nothing wrong with your site. It takes a good 2-3 seconds for the sever to answer the page request for each page, but once it does, it loads instantly. No load time issues at all, it is just server lag which is nothing you can do about that. I recommend switching to Bluehost.com

Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.

Link to comment
Share on other sites

Thanks, did it already. I think that the problem is with the categories: In the left box and on the tabs/subtabs.

I couldn't see any longer if the object CountProductsStore is loaded because you would see as one of the first queries (like number 2):

[2] => select c.categories_id, c.parent_id from categories c order by c.parent_id

You could check if it is loaded by adding something in application bottom (after the queries debug stuff you added):

// BOF queries_debug-v1.6
include(DIR_WS_INCLUDES . 'performance.php');
// EOF queries_debug-v1.6
echo '<pre>CountProductsStore: ';
print_r($countproducts);

That should display something like this at the bottom of the page:

CountProductsStore: countproductsstore Object
(
[category_tree] => Array
	(
		[1] => 0
		[2] => 0
		[3] => 0
		[17] => 1
		[9] => 1
		[8] => 1
		[7] => 1
		[6] => 1
		[5] => 1
		[4] => 1
		[16] => 1
		[19] => 2
		[18] => 2
		[20] => 2
		[14] => 3
		[15] => 3
		[13] => 3
		[12] => 3
		[10] => 3
		[11] => 3
	)

)

Having all those queries could only mean two things IMO: either that object is not loaded or the shopping cart you use (an osC fork or a template) uses it own code to make the categories box and doesn't use the functions that Optimize Categories Box makes so efficient.

Link to comment
Share on other sites

Hi,

 

I really need help with this one, my site loading has become very slow, i cant point why. I have made the changes written in the

Speed Up thread, but after a while it has be come very slow, again.

My site is this: www.jJudaica.com

Any tools, recommendations, comments and remarks are welcome.

 

Need it urgently, thanks!

 

I don't think it's your host...

 

eg:

www.jjudaica.com/images/kippot/judaica_kippah_370ajt.jpg

www.jjudaica.com/index.html

I see them flying...

 

if you want to test it you could create a folder place a simple php script in it and run it with your browser. To me it points perhaps to some code in .htaccess which is incorrect when it filters php files perhaps???

 

PS: changing hosts for this, may not be a good idea.

Link to comment
Share on other sites

I don't think it's your host...

 

eg:

www.jjudaica.com/images/kippot/judaica_kippah_370ajt.jpg

www.jjudaica.com/index.html

I see them flying...

Actually, the queries (visible when the debug info was still echo'ed on the site) took each around 0.04 second or above and at more than 100 queries...

Link to comment
Share on other sites

Actually, the queries (visible when the debug info was still echo'ed on the site) took each around 0.04 second or above and at more than 100 queries...

 

 

Thanks a lot all. i think its both the hosting and the queries issue...

Below is my queries (120) i have reduced them for a bit less, I'm almost sure that its possible to reach around 20-30.

 

What do you think? can give me a hint or a query sample (I learn as a go, not a programmer... :blush: )?

 

this is the Index file, followed by the product info file (I'm embarrassed to show the amount...) :

Current Parse Time: 6.700 s with 121 queries

QUERY DEBUG:

 

Array

(

[QUERIES] => Array

(

[0] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '0') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority

[1] => select value from sessions where sesskey = '45d80d3ad91679ecc165632082c818e9' and expiry > '1183502261'

[2] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

[3] => delete from whos_online where time_last_click < '1183501362'

[4] => select count(*) as count from whos_online where session_id = '45d80d3ad91679ecc165632082c818e9'

[5] => update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '89.138.190.26', time_last_click = '1183502262', last_page_url = '/' where session_id = '45d80d3ad91679ecc165632082c818e9'

[6] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

[7] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0

[8] => select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1'

[9] => select c.categories_id,

cd.categories_name, cd.categories_htc_description,

c.parent_id

from categories c,

categories_description cd

where c.parent_id = '0' and

c.categories_id = cd.categories_id and

cd.language_id='1'

 

order by sort_order, cd.categories_name

[10] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[11] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '60' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[12] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '53' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[13] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '105' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[14] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '101' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[15] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '92' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[16] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '104' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[17] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '41' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[18] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '50' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[19] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '45' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[20] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '47' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[21] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '115' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[22] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '114' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[23] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '48' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[24] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '56' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[25] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '113' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[26] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '32' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[27] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '35' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[28] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '79' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[29] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[30] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '69' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[31] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '68' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[32] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '83' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[33] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '63' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[34] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '72' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[35] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '67' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[36] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '37' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[37] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[38] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '65' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[39] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '78' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[40] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '74' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[41] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '75' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[42] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '77' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[43] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '88' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[44] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '76' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[45] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '73' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[46] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '91' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[47] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '102' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[48] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[49] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '93' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[50] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '46' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[51] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '28' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[52] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '29' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[53] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '99' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[54] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '30' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[55] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '25' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[56] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '66' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[57] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '27' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[58] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '70' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[59] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '26' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[60] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '57' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[61] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '54' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[62] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '55' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[63] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '51' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[64] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '49' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[65] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '52' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[66] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '116' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[67] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '117' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[68] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '82' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[69] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '59' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[70] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '89' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[71] => describe categories status

[72] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[73] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[74] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[75] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[76] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[77] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[78] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[79] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[80] => select c.categories_id, cd.categories_name, c.parent_id, c.categories_image, cd.categories_htc_description

from categories c, categories_description cd

where c.categories_id = cd.categories_id and cd.language_id='1'

order by sort_order, cd.categories_name

[81] => select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

[82] => select categories_name from categories_description where categories_id = '' limit 1

[83] => select p.products_id, p.products_image_sm_1, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price, pd.products_description from products p left join products_description pd on p.products_id = pd.products_id left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(1937561462) DESC limit 15

[84] => select products_name from products_description where products_id = '453' and language_id = '1'

[85] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '104') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority

[86] => select products_name from products_description where products_id = '496' and language_id = '1'

[87] => select products_name from products_description where products_id = '480' and language_id = '1'

[88] => select products_name from products_description where products_id = '524' and language_id = '1'

[89] => select products_name from products_description where products_id = '522' and language_id = '1'

[90] => select products_name from products_description where products_id = '484' and language_id = '1'

[91] => select products_name from products_description where products_id = '491' and language_id = '1'

[92] => select products_name from products_description where products_id = '449' and language_id = '1'

[93] => select products_name from products_description where products_id = '539' and language_id = '1'

[94] => select products_name from products_description where products_id = '445' and language_id = '1'

[95] => select products_name from products_description where products_id = '443' and language_id = '1'

[96] => select products_name from products_description where products_id = '478' and language_id = '1'

[97] => select products_name from products_description where products_id = '498' and language_id = '1'

[98] => select products_name from products_description where products_id = '513' and language_id = '1'

[99] => select products_name from products_description where products_id = '475' and language_id = '1'

[100] => select p.products_id, p.products_image_sm_1, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit 3

[101] => select products_name from products_description where products_id = '556' and language_id = '1'

[102] => select products_name from products_description where products_id = '544' and language_id = '1'

[103] => select products_name from products_description where products_id = '543' and language_id = '1'

[104] => select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 0

[105] => select distinct p.products_id, p.products_image_sm_1, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 9

[106] => select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image_sm_1, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 20

[107] => select p.products_id, p.products_image_sm_1, p.products_price, p.products_tax_class_id, s.specials_new_products_price, specials_new_products_price, p.products_date_added from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 15

[108] => select products_name from products_description where products_id = '524' and language_id = '1'

[109] => select specials_new_products_price from specials where products_id = '524' and status

[110] => select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name

[111] => SELECT COUNT(*) as count from topics where parent_id = '5'

[112] => SELECT COUNT(*) as count from topics where parent_id = '2'

[113] => SELECT COUNT(*) as count from topics where parent_id = '11'

[114] => SELECT COUNT(*) as count from topics where parent_id = '9'

[115] => SELECT COUNT(*) as count from topics where parent_id = '10'

[116] => SELECT COUNT(*) as count from topics where parent_id = '6'

[117] => select startdate, counter from counter

[118] => update counter set counter = '176812'

[119] => select count(*) as total from sessions where sesskey = '45d80d3ad91679ecc165632082c818e9'

[120] => update sessions set expiry = '1183503708', value = 'cart|O:12:\"shoppingcart\":6:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;s:9:\"shiptotal\";s:0:\"\";}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}' where sesskey = '45d80d3ad91679ecc165632082c818e9'

)

 

This is the Product info:

Current Parse Time: 6.107 s with 111 queries

QUERY DEBUG:

 

Array

(

[QUERIES] => Array

(

[0] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '0') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority

[1] => select value from sessions where sesskey = '45d80d3ad91679ecc165632082c818e9' and expiry > '1183502380'

[2] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

[3] => delete from whos_online where time_last_click < '1183501481'

[4] => select count(*) as count from whos_online where session_id = '45d80d3ad91679ecc165632082c818e9'

[5] => update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '89.138.190.26', time_last_click = '1183502381', last_page_url = '/925-silver-home-blessing-p-484.html' where session_id = '45d80d3ad91679ecc165632082c818e9'

[6] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

[7] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0

[8] => select p2c.categories_id from products p, products_to_categories p2c where p.products_id = '484' and p.products_status = '1' and p.products_id = p2c.products_id limit 1

[9] => select parent_id from categories where categories_id = '105'

[10] => select parent_id from categories where categories_id = '53'

[11] => select parent_id from categories where categories_id = '60'

[12] => select categories_name from categories_description where categories_id = '60' and language_id = '1'

[13] => select categories_name from categories_description where categories_id = '53' and language_id = '1'

[14] => select categories_name from categories_description where categories_id = '105' and language_id = '1'

[15] => select products_name from products_description where products_id = '484'

[16] => select count(*) as total from products p, products_description pd where (p.products_status = '1' or (p.products_status='0' and p.products_bundle_status='1')) and p.products_id = '484' and pd.products_id = p.products_id and pd.language_id = '1'

[17] => select pd.language_id, p.products_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_keywords_tag, pd.products_head_desc_tag, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_id = '484' and pd.products_id = '484' and pd.language_id ='1'

[18] => select c.categories_name as cat_name from categories_description c, products_to_categories p2c where c.categories_id = p2c.categories_id and p2c.products_id = '484' and language_id = '1'

[19] => select c.categories_id,

cd.categories_name, cd.categories_htc_description,

c.parent_id

from categories c,

categories_description cd

where c.parent_id = '0' and

c.categories_id = cd.categories_id and

cd.language_id='1'

 

order by sort_order, cd.categories_name

[20] => select c.categories_id, cd.categories_name, cd.categories_htc_description, c.parent_id from categories c, categories_description cd where c.parent_id = '60' and c.categories_id = cd.categories_id and cd.language_id='1' and c.sort_order =0 order by sort_order, cd.categories_name

[21] => select c.categories_id, cd.categories_name, cd.categories_htc_description, c.parent_id from categories c, categories_description cd where c.parent_id = '53' and c.categories_id = cd.categories_id and cd.language_id='1' and c.sort_order =0 order by sort_order, cd.categories_name

[22] => select c.categories_id, cd.categories_name, cd.categories_htc_description, c.parent_id from categories c, categories_description cd where c.parent_id = '105' and c.categories_id = cd.categories_id and cd.language_id='1' and c.sort_order =0 order by sort_order, cd.categories_name

[23] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[24] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '60' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[25] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '53' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[26] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '105' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[27] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '101' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[28] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '92' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[29] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '104' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[30] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '41' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[31] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '50' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[32] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '45' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[33] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '47' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[34] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '115' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[35] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '114' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[36] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '48' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[37] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '56' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[38] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '113' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[39] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '32' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[40] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '35' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[41] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '79' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[42] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[43] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '69' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[44] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '68' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[45] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '83' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[46] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '63' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[47] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '72' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[48] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '67' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[49] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '37' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[50] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[51] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '65' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[52] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '78' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[53] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '74' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[54] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '75' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[55] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '77' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[56] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '88' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[57] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '76' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[58] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '73' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[59] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '91' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[60] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '102' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[61] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[62] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '93' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[63] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '46' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[64] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '28' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[65] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '29' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[66] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '99' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[67] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '30' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[68] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '25' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[69] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '66' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[70] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '27' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[71] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '70' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[72] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '26' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[73] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '57' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[74] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '54' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[75] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '55' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[76] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '51' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[77] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '49' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[78] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '52' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[79] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '116' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[80] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '117' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[81] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '82' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[82] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '59' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[83] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '89' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[84] => select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '484' and pd.products_id = p.products_id and pd.language_id = '1'

[85] => update products_description set products_viewed = products_viewed+1 where products_id = '484' and language_id = '1'

[86] => select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity, p.products_price1, p.products_price2, p.products_price3,p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where (p.products_status = '1' or (p.products_status='0' and p.products_bundle_status='1')) and pd.products_id = p.products_id and p.products_id = '484' and pd.language_id = '1'

[87] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '104') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority

[88] => select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='484' and patrib.options_id = popt.products_options_id and popt.language_id = '1'

[89] => select count(*) as count from reviews where products_id = '484'

[90] => select distinct p.products_id,

p.products_image,

pd.products_name

from products_xsell xp,

products p,

products_description pd

where xp.products_id = '484' and

xp.xsell_id = p.products_id and

p.products_id = pd.products_id and

pd.language_id = '1' and

p.products_status = '1'

order by xp.products_id asc

limit 3

[91] => select categories_id

from products_to_categories

where products_id = '484'

[92] => select distinct p.products_id,

p.products_image,

pd.products_name

from products p,

products_to_categories pc,

products_description pd

where pc.categories_id = '105' and

pc.products_id = p.products_id and

p.products_id != '484' and

p.products_id = pd.products_id and

pd.language_id = '1' and

p.products_status = '1'

order by rand(349826723) desc

limit 3

[93] => select products_name from products_description where products_id = '485' and language_id = '1'

[94] => select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '484' and opa.orders_id = opb.orders_id and opb.products_id != '484' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 3

[95] => select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from manufacturers m left join manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1'), products p where p.products_id = '484' and p.manufacturers_id = m.manufacturers_id

[96] => select products_name from products_description where products_id = '484' and language_id = '1'

[97] => select p.products_id, p.products_image_sm_1, p.products_price, p.products_tax_class_id, s.specials_new_products_price, specials_new_products_price, p.products_date_added from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 15

[98] => select products_name from products_description where products_id = '522' and language_id = '1'

[99] => select specials_new_products_price from specials where products_id = '522' and status

[100] => select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name

[101] => SELECT COUNT(*) as count from topics where parent_id = '5'

[102] => SELECT COUNT(*) as count from topics where parent_id = '2'

[103] => SELECT COUNT(*) as count from topics where parent_id = '11'

[104] => SELECT COUNT(*) as count from topics where parent_id = '9'

[105] => SELECT COUNT(*) as count from topics where parent_id = '10'

[106] => SELECT COUNT(*) as count from topics where parent_id = '6'

[107] => select startdate, counter from counter

[108] => update counter set counter = '176814'

[109] => select count(*) as total from sessions where sesskey = '45d80d3ad91679ecc165632082c818e9'

[110] => update sessions set expiry = '1183503826', value = 'cart|O:12:\"shoppingcart\":6:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;s:9:\"shiptotal\";s:0:\"\";}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:2:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:11:\"products_id\";s:3:\"484\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}' where sesskey = '45d80d3ad91679ecc165632082c818e9'

)

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

I ran your site through the same analyzer's we run our severs through here. For the time it took your page to accept the request: 9.66 seconds, the time your page loaded after it accepted the request: 0.26. You page loads instantly once the page request is accepted. Trust me Bro, it's your host.

 

 

It doesn't really matter how many queries you run if you server can't handle the load.

 

This is your page 6.107 s with 111 queries

 

My forum has 32 less queries and look how fast it loads. It is considerably faster.

 

Page generation time: .7088s (PHP: 100% - SQL: 0%) - SQL queries: 79

 

You can try to condense all you want with code, if you server can't handle the load it's not going to mater. Remember, PHP is a server side engine.

Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works.

Link to comment
Share on other sites

I think its both the hosting and the queries issue...

Below is my queries (120) i have reduced them for a bit less, I'm almost sure that its possible to reach around 20-30.

 

What do you think?

It looks like you haven't added that line to application_top.php that loads the CountProductsStore object.

From the top of my head something like:

$countproducts = new CountProductsStore.php;

Still, IMHO that server is slow as molasses in the winter. Over 6 seconds for 121 queries....

Link to comment
Share on other sites

It looks like you haven't added that line to application_top.php that loads the CountProductsStore object.

From the top of my head something like:

$countproducts = new CountProductsStore.php;

Still, IMHO that server is slow as molasses in the winter. Over 6 seconds for 121 queries....

 

 

Would love to add it... : ) looked for it (with google here, and in the contrib. section) didn't find it, can you pls refer to it?

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

Would love to add it... : ) looked for it (with google here, and in the contrib. section) didn't find it, can you pls refer to it?

In post #5 I gave the name of that contribtion together with a link to it. In post 6 you said you already added that contribution....

Link to comment
Share on other sites

In post #5 I gave the name of that contribtion together with a link to it. In post 6 you said you already added that contribution....

 

I thought it was similar to Chemos, sorry. ill install it now - Thanks J

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...