Hello to everyone!
My website perform very slow. Not sure where to start. Had this problem for a while. Please give me some points to start
.
Here's report when I run Joomla in debug mode:
Profile Information
Application afterLoad: 0.001 seconds, 0.39 MB
Application afterInitialise: 0.484 seconds, 8.32 MB
Application afterRoute: 0.558 seconds, 11.48 MB
Application afterDispatch: 0.650 seconds, 13.43 MB
Application afterRender: 2.915 seconds, 25.00 MB
Memory Usage
26279832
153 queries logged
1.
SELECT *
FROM jos_session
WHERE session_id = 'cd3bc0bddc85812ed64edc6bce0471fc'
2.
DELETE
FROM jos_session
WHERE ( time < '1241809817' )
3.
SELECT *
FROM jos_session
WHERE session_id = 'cd3bc0bddc85812ed64edc6bce0471fc'
4.
UPDATE `jos_session`
SET `time`='1241813417',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
,`data`='__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1241813252;s:18:"
session.timer.last";i:1241813252;s:17:"session.timer.now";i:1241813252;s:22:"session.client.browser"
;s:92:"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"
_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";
O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"
password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"
registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";
i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"
_elementPath";a:1:{i:0;s:66:"/home/aromacup/public_html/libraries/joomla/html/parameter/element";}s:
17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"
stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:
32:"4a127dbfbcee3f18bfdb8d54bfc625b7";}'
WHERE session_id='cd3bc0bddc85812ed64edc6bce0471fc'
5.
SELECT *
FROM jos_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
7.
SELECT *
FROM jos_sef_config
WHERE id = '1'
8.
SELECT *
FROM jos_sef_alias
WHERE published='1'
9.
SELECT id, name
FROM jos_jlord_rss
WHERE published = 1
AND feeded = 1
ORDER BY ordering
10.
SELECT id
FROM jos_components
WHERE link='option=com_'
ORDER BY id DESC
11.
SELECT id, link
FROM jos_menu
WHERE home=1
AND published=1
12.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_content&view=frontpage'
AND published=1
AND home=1
13.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_content&view=frontpage'
AND published=1
AND home=1
14.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_content&view=frontpage'
AND published=1
AND home=1
15.
SELECT name AS title, home
FROM jos_menu
WHERE link='index.php?option=com_content&view=frontpage'
AND published=1
16.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
17.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 177)
ORDER BY menuid DESC
LIMIT 0, 1
18.
SELECT *
FROM jos_rokcandy
WHERE published=1
19.
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-05-08 20:10:18' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-05-08 20:10:18' )
ORDER BY f.ordering
LIMIT 0, 10
20.
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-05-08 20:10:18' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-05-08 20:10:18' )
ORDER BY f.ordering
21.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 177 OR mm.menuid = 0 )
ORDER BY position, ordering
22.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=319
23.
SELECT c.title AS category, s.title AS section
FROM jos_categories AS c
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE c.id=141
24.
SELECT link
FROM jos_menu
WHERE id=14
25.
SELECT link
FROM jos_menu
WHERE id=14
26.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=13
27.
SELECT link
FROM jos_menu
WHERE id=15
28.
SELECT link
FROM jos_menu
WHERE id=15
29.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=12
30.
SELECT link
FROM jos_menu
WHERE id=16
31.
SELECT link
FROM jos_menu
WHERE id=16
32.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=98
33.
SELECT link
FROM jos_menu
WHERE id=17
34.
SELECT link
FROM jos_menu
WHERE id=17
35.
SELECT count(id)
FROM jos_menu
WHERE link LIKE 'index.php?option=com_contact&view=contact&id=%'
AND published = 1
36.
SELECT link
FROM jos_menu
WHERE id=153
37.
SELECT link
FROM jos_menu
WHERE id=153
38.
SELECT c.title AS category, s.title AS section
FROM jos_categories AS c
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE c.id=181
39.
SELECT link
FROM jos_menu
WHERE id=243
40.
SELECT link
FROM jos_menu
WHERE id=243
41.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=265
42.
SELECT link
FROM jos_menu
WHERE id=182
43.
SELECT link
FROM jos_menu
WHERE id=182
44.
SELECT c.title AS category, s.title AS section
FROM jos_categories AS c
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE c.id=182
45.
SELECT link
FROM jos_menu
WHERE id=55
46.
SELECT link
FROM jos_menu
WHERE id=55
47.
SELECT c.title AS category, s.title AS section
FROM jos_categories AS c
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE c.id=162
48.
SELECT link
FROM jos_menu
WHERE id=56
49.
SELECT link
FROM jos_menu
WHERE id=56
50.
SELECT c.title AS category, s.title AS section
FROM jos_categories AS c
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE c.id=161
51.
SELECT link
FROM jos_menu
WHERE id=252
52.
SELECT link
FROM jos_menu
WHERE id=252
53.
SELECT *
FROM `jos_jlord_rss`
WHERE
`published`=1
AND
`display_feed_module`=1
ORDER BY `ordering`
54.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
55.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
56.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='182'
57.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='182'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:18' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
58.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='182'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:18' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
59.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '1'
60.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=3
AND banner_id=1
AND `type`='impressions'
LIMIT 1
61.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=3, banner_id=1, `type`='impressions', `how_many`='1'
62.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
63.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
64.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='184'
65.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='184'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:18' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
66.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='184'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:18' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
67.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '2'
68.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=3
AND banner_id=2
AND `type`='impressions'
LIMIT 1
69.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=3, banner_id=2, `type`='impressions', `how_many`='1'
70.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
71.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
72.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='186'
73.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='186'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:18' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
74.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='186'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:18' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
75.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '5'
76.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=3
AND banner_id=5
AND `type`='impressions'
LIMIT 1
77.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=3, banner_id=5, `type`='impressions', `how_many`='1'
78.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
79.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
80.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='187'
81.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='187'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
82.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='187'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
83.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '4'
84.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=3
AND banner_id=4
AND `type`='impressions'
LIMIT 1
85.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=3, banner_id=4, `type`='impressions', `how_many`='1'
86.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
87.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
88.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='185'
89.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='185'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
90.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='185'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
91.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '3'
92.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=3
AND banner_id=3
AND `type`='impressions'
LIMIT 1
93.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=3, banner_id=3, `type`='impressions', `how_many`='1'
94.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=319
95.
SELECT c.title AS category, s.title AS section
FROM jos_categories AS c
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE c.id=141
96.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
97.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
98.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='192'
99.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='192'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
100.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='192'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
101.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '16'
102.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=5
AND banner_id=16
AND `type`='impressions'
LIMIT 1
103.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=5, banner_id=16, `type`='impressions', `how_many`='1'
104.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
105.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
106.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='190'
107.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='190'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
108.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='190'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
109.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '20'
110.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=5
AND banner_id=20
AND `type`='impressions'
LIMIT 1
111.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=5, banner_id=20, `type`='impressions', `how_many`='1'
112.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
113.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
114.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='193'
115.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='193'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
116.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='193'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:19' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
117.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '22'
118.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=6
AND banner_id=22
AND `type`='impressions'
LIMIT 1
119.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=6, banner_id=22, `type`='impressions', `how_many`='1'
120.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-05-08 20:10:18' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-05-08 20:10:18' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
121.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=632
122.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=631
123.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=630
124.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=629
125.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=627
126.
SELECT a.*, a.introtext AS text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-05-08 20:10:18' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-05-08 20:10:18' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=107)
AND s.published = 1
AND cc.published = 1
ORDER BY a.modified DESC, a.created DESC
LIMIT 0, 15
127.
SELECT published,params
FROM jos_plugins
WHERE element = 'jreviews'
AND folder = 'content'
LIMIT 1
128.
SELECT `id`,`parameters`,`styleid`,published
FROM jos_sidebar_sidebars
WHERE `parameters` LIKE '%107%'
AND published = 1
129.
SELECT *
FROM jos_sidebar_sidebars
WHERE `parameters` LIKE '%107%'
AND published = 1
130.
SELECT id,name,link AS menu_type,link,componentid,params,access,published
FROM jos_menu
WHERE published = 1
ORDER BY link DESC
131.
SELECT JreviewsSection.tmpl AS `Section.tmpl_list`,JreviewsSection.tmpl_suffix AS `Section.tmpl_suffix`,JreviewsCategory.tmpl AS `Category.tmpl_list`,JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`
FROM jos_categories AS Category
LEFT JOIN jos_jreviews_categories AS JreviewsCategory
ON Category.id = JreviewsCategory.id
LEFT JOIN jos_sections AS Section
ON Category.section = Section.id
LEFT JOIN jos_jreviews_sections AS JreviewsSection
ON Section.id = JreviewsSection.sectionid
WHERE JreviewsCategory.OPTION = 'com_content'
AND Category.id = 107
132.
SELECT id,name,link AS menu_type,link,componentid,params,access,published
FROM jos_menu
WHERE published = 1
ORDER BY link DESC
133.
SELECT JreviewCategory.id
FROM jos_jreviews_categories AS JreviewCategory
WHERE JreviewCategory.`option` = 'com_content'
AND JreviewCategory.id = 107
134.
SELECT *
FROM jos_content
WHERE id = '586'
135.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=586
136.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=586
137.
SELECT name AS title, home
FROM jos_menu
WHERE link='index.php?option=com_content&view=frontpage'
AND published=1
138.
SELECT `lastsend`
FROM jos_ad_agency_settings
LIMIT 1
139.
SELECT id
FROM jos_ad_agency_banners
WHERE media_type='Transition' OR media_type='Floating'
140.
SELECT banners
FROM jos_ad_agency_zone
WHERE zoneid='189'
141.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='189'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:20' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
142.
SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) AS rw
FROM jos_ad_agency_campaign_banner
LEFT
OUTER JOIN jos_ad_agency_banners AS b
ON b.id=banner_id
LEFT JOIN jos_ad_agency_campaign AS t0
ON campaign_id=t0.id
WHERE b.zone='189'
AND b.approved='Y'
AND ((t0.approved='Y')
AND (t0.approved='Y'
AND ('2009-05-08 15:10:20' > t0.start_date)
AND ((t0.type IN ('cpm','pc')
AND t0.quantity>0) OR (t0.type='fr'
AND NOW() < t0.validity))))
AND t0.STATUS='1'
AND banner_id NOT IN (0)
ORDER BY rw DESC
LIMIT 1
143.
SELECT *
FROM jos_ad_agency_banners
WHERE id = '11'
144.
SELECT how_many
FROM jos_ad_agency_stat
WHERE substring(entry_date,1,10)='2009-05-08'
AND ip_address=3468735774
AND campaign_id=4
AND banner_id=11
AND `type`='impressions'
LIMIT 1
145.
INSERT INTO jos_ad_agency_stat
SET entry_date=NOW(), ip_address=3468735774, user_agent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', advertiser_id=2, campaign_id=4, banner_id=11, `type`='impressions', `how_many`='1'
146.
SELECT params
FROM jos_menu
WHERE id = '177'
147.
SELECT id, meta_name, meta_default, default_setting
FROM jos_jre_sefpatch_metadef
WHERE published='1'
ORDER BY ordering
148.
SELECT *
FROM jos_jre_sefpatch_urlrepository
WHERE url = 'index.php?option=com_content&view=frontpage&Itemid=177'
AND is_published = '1'
149.
SELECT meta_name, meta_default
FROM jos_jre_sefpatch_metadef
WHERE (default_setting = '0' OR default_setting = '2')
AND meta_name NOT IN ( 'description','keywords','robots','author' )
150.
SELECT i.title AS article, c.title AS category, s.title AS section
FROM jos_content AS i
LEFT JOIN jos_categories AS c
ON i.catid=c.id
LEFT JOIN jos_sections AS s
ON c.section=s.id
WHERE i.id=265
151.
SELECT count(id)
FROM jos_menu
WHERE link LIKE 'index.php?option=com_contact&view=contact&id=%'
AND published = 1
152.
SELECT title
FROM jos_categories
WHERE id=164
153.
SELECT name
FROM jos_contact_details
WHERE id=2
0 legacy queries logged
Language Files Loaded
* /home/aromacup/public_html/language/en-GB/en-GB.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.com_content.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.tpl_rt_mynxx_j15.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.mod_roknavmenu.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.mod_analytics.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.mod_jlord_rss.ini
* /home/aromacup/public_html/language/en-GB/en-GB.mod_adagency_zone.ini
* /home/aromacup/public_html/language/en-GB/en-GB.mod_rokajaxsearch.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.mod_latestnews.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.mod_roktabs.ini
* /home/aromacup/public_html/language/en-GB/en-GB.plg_content_pagebreak.ini 1
* /home/aromacup/public_html/language/en-GB/en-GB.mod_login.ini 1
Untranslated Strings Diagnostic
