Joomla 2.5.4 consumes a lot of cpu

[ervik]

Hi,

After running Joomla 1.7.5, I decided to upgrade to Joomla 2.5.4 via the admin gui.
I took the site offline, cleaned the cache and closed all current connections to it.
Now, after doing that the mysql service uses about 50-75% of the cpu.
I'm running Turnkeylinux with Ubuntu 10.04.4 LTS
MySql version
PHP Version 5.3.2-1ubuntu4.14
with Rockettheme Tachyon v1.6.5 version and Gantry v3.2.19

The site will live for about 20 min to 1 hour, and then it just become unresponsive. I've also seen the error: Database connection error (2): Could not connect to MySQL

I'm stuck please help out!

[aaanativearts]

Are you using sh404SEF? My 2.5.4 site was doing the same as yours and the culprit was sh404SEF. I had a lot of rewrites from the old site to the new because I upgraded from an old phpNuke site to 2.5.3 and the url structure is different now and I had a lot of articles to redirect. When I disabled it and switched to AceSEF or the built in Joomla Standard SEF, it went back to running normal. At least it was until I upgraded from 2.5.3 to 2.5.4.

But since upgrading to 2.5.4, I can't see my site in IE9, but other people can see it in that browser. I've purged cache in joomla, deleted cache in my IE browser, and rebooted several times. It works fine for me in all the other major browsers. Anyone have an idea what is going on with that?

[ervik]

No sh404SEF only regular built in Joomla SEF

[ervik]

Oh, and I can see from my mysql db that it says under database connections:
SELECT b.rules FROM j17_assets AS a LEFT JOIN j17_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.article.3701' OR a.parent_id=0) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft

Whatever this means!

[ervik]

Oh and I found this in phpmyadmin->processes
988 root localhost xxxxdb Query 4 Copying to tmp table SELECT b.rules
FROM j17_assets AS a
LEFT JOIN j17_assets AS b ON b.lft <= a.lft
AND b.rgt >= a.rgtW

[ervik]

I have a lot of these:

SELECT b.rules FROM j17_assets AS a LEFT JOIN j17_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content' OR a.parent_id=0) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft

What does this mean?

[shwaran]

same problem for me i have applied some of the solution that what the joomla forums said. (such as enable cache plugin some of other fixes)

but no improvement on the server. sqlserver is running now but slowly increasing the RAM mem usage

Joomla! 2.5.4
J2XML Importer 1.6.0.72
JA Extension Manager 2.5.1
obRSS 1.8.12
Akeeba Backup Notification Module 3.4.3
1Pixelout Audio Player 2.3
JA News Pro Module
JA T3 Framework
Lof ArticlesSlideShow Module
obRSS module 1.6.2

server details
CENTOS 5.8 x86_64 xenpv
vps note
CPU 6GHz
RAM 3760MB
Disk space100GB

[ervik]

Where are these fixes? I can't enable native joomla cache plugin because of the RocketThemes template, it uses Gantry Cache instead... but where are these other fixes? Joomla Devs should be intressted in fixing this as I have read a ton of people haveing these issues after upgrading from 1.6x or 1.7.x!
And no, reinstalling is not a good solution to try, takes a while, but I don't believe that works!

[ervik]

I'm also seeing these in phpmyadmin:

Kill 1732 root localhost ervikasdb Query 46 Copying to tmp table SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.cati
Kill 1733 root localhost ervikasdb Query 119 Copying to tmp table SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.cati
Kill 1734 root localhost ervikasdb Query 72 Copying to tmp table SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.cati
Kill 1737 root localhost ervikasdb Query 92 Copying to tmp table SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.cati
Kill 1740 root localhost ervikasdb Query 100 Creating tmp table SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.cati
Kill 1741 root localhost ervikasdb Query 92 Copying to tmp table SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.cati

Kill 1759 root localhost nameofdb Query 600 removing tmp table SELECT b.rules
FROM j17_assets AS a
LEFT JOIN j17_assets AS b ON b.lft <= a.lft
AND b.rgt >= a.rgtW

[bradm]

Hi ervik,

The site will live for about 20 min to 1 hour, and then it just become unresponsive. I've also seen the error: Database connection error (2): Could not connect to MySQL

If Joomla is using a lot of server resources regarding MySQL, what I recommend is trying to figure out if Joomla is either:

1. Running LOTS of MySQL queries
2. Running a few queries that take A LOT of time to run

Most queries take just a second or two at most to run. The problem could be that Joomla is simply running tons of queries, or, you have a few queries that for a long time, such as a minute +

When looking at some of the database in phpMyAdmin, it may be hard to find what you need because like I said the queries run so quickly by the time you refresh the page they're gone (unless they are the long running queries).

If you have root access to your server, you can run the following:

Code: Select all

root@vps801 [~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 231697
Server version: 5.0.92-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show processlist;
+--------+---------+-----------+-----------+----------------+------+--------------------+------------------+
| Id     | User    | Host      | db        | Command        | Time | State              | Info             |
+--------+---------+-----------+-----------+----------------+------+--------------------+------------------+
| 231685 | DELAYED | localhost | brad_elgg | Delayed insert |  136 | Waiting for INSERT |                  | 
| 231697 | root    | localhost | NULL      | Query          |    0 | NULL               | show processlist | 
+--------+---------+-----------+-----------+----------------+------+--------------------+------------------+
2 rows in set (0.00 sec)

As you can see above, there is a Time column. You'll want to run that command when your Joomla site is slow, and look for any queries that are taking long to run.

You can also run

Code: Select all

mysqladmin version

to see data, such as how many queries your server is running and how often:

Code: Select all

root@vps801 [~]# mysqladmin version
mysqladmin  Ver 8.41 Distrib 5.0.92, for pc-linux-gnu on i686
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version		5.0.92-community
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/lib/mysql/mysql.sock
Uptime:			125 days 19 hours 13 min 15 sec

Threads: 2  Questions: 5079542  Slow queries: 6  Opens: 98954  Flush tables: 1  Open tables: 64  Queries per second avg: 0.467

I would recommend restarting MySQL, clicking around on your site, and then running the above command and checking the Queries per second avg value.

[shwaran]

here is mine

Code: Select all

mysql> show processlist
    -> ;
+-------+--------------+-----------+--------------+---------+------+-------+------------------+
| Id    | User         | Host      | db           | Command | Time | State | Info             |
+-------+--------------+-----------+--------------+---------+------+-------+------------------+
|  3856 | eximstats    | localhost | eximstats    | Sleep   |  567 |       | NULL             |
| 70103 | leechprotect | localhost | leechprotect | Sleep   | 3114 |       | NULL             |
| 73538 | root         | localhost | NULL         | Query   |    0 | NULL  | show processlist |
+-------+--------------+-----------+--------------+---------+------+-------+------------------+
3 rows in set (0.00 sec)

and

Code: Select all

root@admin [~]# mysqladmin version
mysqladmin  Ver 8.41 Distrib 5.0.95, for unknown-linux-gnu on x86_64
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version          5.0.95-community-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 23 hours 17 min 44 sec

Threads: 3  Questions: 1946247  Slow queries: 0  Opens: 554  Flush tables: 1  Open tables: 342  Queries per second avg: 23.207

Code: Select all

root@admin [~]# mysqlreport
MySQL 5.0.95-community-  uptime 0 23:18:23      Tue Apr 17 04:02:04 2012

__ Key ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****_____
Buffer used     1.39M of  64.00M  %Used:   2.17
  Current      12.66M            %Usage:  19.79
Write hit      90.51%
Read hit      100.00%

__ Questions ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****___
Total           1.50M    17.8/s
  Com_        859.88k    10.2/s  %Total:  57.47
  -Unknown    675.83k     8.1/s           45.17
  QC Hits     621.26k     7.4/s           41.52
  DMS         617.34k     7.4/s           41.26
  COM_QUIT     73.60k     0.9/s            4.92
Slow 10 s           0       0/s            0.00  %DMS:   0.00  Log:  ON
DMS           617.34k     7.4/s           41.26
  SELECT      459.51k     5.5/s           30.71         74.43
  DELETE       87.32k     1.0/s            5.84         14.15
  UPDATE       38.74k     0.5/s            2.59          6.28
  INSERT       31.76k     0.4/s            2.12          5.14
  REPLACE           4     0.0/s            0.00          0.00
Com_          859.88k    10.2/s           57.47
  stmt_close  225.29k     2.7/s           15.06
  stmt_prepar 225.29k     2.7/s           15.06
  stmt_execut 225.29k     2.7/s           15.06

__ SELECT and Sort ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****_____
Scan           36.45k     0.4/s %SELECT:   7.93
Range          74.35k     0.9/s           16.18
Full join      87.44k     1.0/s           19.03
Range check    59.01k     0.7/s           12.84
Full rng join       0       0/s            0.00
Sort scan     165.45k     2.0/s
Sort range    113.64k     1.4/s
Sort mrg pass      96     0.0/s

__ Query Cache ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****_
Memory usage   34.47M of  64.00M  %Used:  53.86
Block Fragmnt  24.25%
Hits          621.26k     7.4/s
Inserts       293.67k     3.5/s
Insrt:Prune   14.06:1     3.3/s
Hit:Insert     2.12:1

__ Table Locks ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****_
Waited            447     0.0/s  %Total:   0.03
Immediate       1.48M    17.7/s

__ Tables ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****__
Open              342 of  512    %Cache:  66.80
Opened            554     0.0/s

__ Connections ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****_
Max used           11 of 1000      %Max:   1.10
Total          73.61k     0.9/s

__ Created Temp ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****
Disk table     47.71k     0.6/s
Table         272.67k     3.2/s    Size:  16.0M
File              192     0.0/s

__ Threads ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****_
Running             1 of    3
Cached              7 of    8      %Hit:  99.98
Created            14     0.0/s
Slow                0       0/s

__ Aborted ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****_
Clients            12     0.0/s
Connects           30     0.0/s

__ Bytes ***** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed ********** Manual signatures are NOT allowed *****___
Sent            5.07G   60.4k/s
Received      416.64M    5.0k/s

Code: Select all

root@admin [~]# ps aux

mysql    23727  CPU - 2.4  Mem - 2.6 323412 100184 ?       Sl   Apr16  38:51 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql

server support team increase the buffer cache and ask me to check with developer, the template team says the errors is on the server and suggest to find a good hosting service,

how ever i still Love Joomla, so what should i do now? and where can i start to check the problem? any Joomla expert help me on this please

[bradm]

Hi shwaran,

In my opinion, I think we're still on the first step, which is identifying the actual problem. I'm not an expert in MySQL by any means, but I didn't see any major problems in the data you provided.

Your

Code: Select all

show processlist

data didn't seem to show any long running queries. It showed a few sleeping queries that were sleeping for a while, but I wouldn't say that is a problem.

Did you run that command at the very same time that your server was running slowly? If your server was running slowly and you ran that query, I would assume it would show some queries running. Sometimes you have to run that command a few times to get the timing just right, as I said queries do run many times in under a split second so you can't always see them.

Your

Code: Select all

mysqladmin version

command shows almost 2 million MySQL queries (1,946,247) being ran in 23 hours, which equates to 23 queries per second. You can't really judge performance based on this alone, however. Even if you have 100 queries per second, as long as those queries run VERY quickly you shouldn't have a problem.

I forgot to mention this in my last response, but you should be able to setup slow query logging, in which MySQL will log for your queries that take more than XX seconds to run. If you do this, you can get a better idea of which queries (and how many) are taking a very long time to run. After you know the long queries, you can then begin to investigate what is calling them. For example, you may have a component installed that is running queries taking 10+ seconds to run.

There is quite a bit of work that can go into figuring out what exactly is causing your Joomla site to load slowly. You can try switching hosting providers, but if the problem is not with your server and instead with something within your site, you'll experience the same issue on other servers as well.

[ervik]

Hi,

This is what I see when it just rebooted check the attached file!

mysqllog.txt

[bradm]

Hi ervik,

I took a look at the file you attached, and it does seem to be a problem. You have quite a few queries taking 300+ seconds to run.

I did some further searching, and I actually found this thread, Slow queries on large website - #_assets is NOT the problem, in which garyjaybrooks is trying to help you.

I think we've identified the problem, however I'm not familiar enough with the assets table to be able to help with any time of solution.

[puneetjain87]

@Bradm
Garyjaybrooks is saying only one thing since the beginning, however there are people who are facing the trouble, even though there asset table is fine. I am one of them.

Please have a look at this as well https://groups.google.com/forum/#!topic ... -9HOB7zEN4
I am not sure, if Joomla developers are aware about it or not, but if they are they should not ignore it.

In case you want to read about my issue you can read it here http://forum.joomla.org/viewtopic.php?f=616&t=708415

[ervik]

I am In dialog with Gary in another forum, and he has the full dump of my website in his hands. He said he knows what's wrong, so I'm crossing my fingers and hoping it can be fixed! It was not like this before I upgraded to Joomla 2.5.4 from 1.7.5, and there has not been a lot of new content after that! So, I guess it's a Joomla 2.5.x related issue!

[puneetjain87]

Ervik,
Whenever you get the solution, please share. I am waiting eagerly.
PS: Asset table is not the issue for me.

[shwaran]

these are the errors that i am seeing in php admin status

Code: Select all

Handler_read_rndDocumentation 	5.8 M 	The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly. 

Code: Select all

Handler_read_rnd_nextDocumentation 	1.1 G 	The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have. 

Code: Select all

Qcache_lowmem_prunesDocumentation 	37.8 k 	The number of queries that have been removed from the cache to free up memory for caching new queries. This information can help you tune the query cache size. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache. 

Code: Select all

Created_tmp_disk_tablesDocumentation 	114.3 k 	The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based. 

Code: Select all

Select_full_joinDocumentation 	212.3 k 	The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables. 

Code: Select all

Select_range_checkDocumentation 	141.7 k 	The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.) 

Code: Select all

Sort_merge_passesDocumentation 	283 	The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable. 

Code: Select all

Opened_tablesDocumentation 	706 	The number of tables that have been opened. If opened tables is big, your table cache value is probably too small. 

Code: Select all

Table_locks_waitedDocumentation 	1.3 k 	The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication. 

[puneetjain87]

I disabled "Recent Articles" Module and Voila, it worked.
Try it and let me know.
If it didn't work also try disable related articles and popular article module.

PS: My _asset table was perfect but still I was having this issue since I moved to 1.7 and then to 2.5.

[shwaran]

@puneetjain87

i have done what whole forum post suggest to solve the problem. (disabled "Recent Articles" Module, remove old articles, run asset script)

but still i faced the problem with slow queries ,

Code: Select all

/usr/sbin/mysqld, Version: 5.0.95-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.0.95-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.0.95-community-log (MySQL Community Edition (GPL)). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
# Time: 120422  8:30:03
# User@Host: root[root] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 10  Rows_examined: 288
use mysql;
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 120423  7:36:02
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use medcom_newsdb;
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('c0edb6454c3c61615ae68122d03d0867', 0, '1335180960');
# Time: 120430  4:02:39
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use tamilmed_4tamiltvdb;
INSERT INTO `z6xk9_session`
(`session_id`, `client_id`, `time`) VALUES 
('05cdb1983d30b638b8f76a3370905ef5', 0, '1335772957');
# Time: 120507 22:25:14
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use medcom_newsdb;
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('03f6aaae4d5b29362f31a967103ffde9', 0, '1336443912');
# Time: 120508  3:00:58
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 8  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE anj_assets
SET rgt = rgt + 2
WHERE rgt >= 979;
# Time: 120508  5:16:30
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('50395598caf2b6fbc4eb1dbb313acb7b', 0, '1336468588');
# Time: 120508  5:39:37
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE 
FROM `anj_session`
WHERE `time` < '1336468175';
# Time: 120508  5:50:00
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use tamilmed_4tamiltvdb;
INSERT INTO `z6xk9_session`
(`session_id`, `client_id`, `time`) VALUES 
('42d75bd00819176626b10eaa34180b78', 0, '1336470598');
# Time: 120508  6:18:13
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 7  Rows_examined: 19965
use medcom_newsdb;
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 7  Rows_examined: 19965
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 7  Rows_examined: 19965
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 7  Rows_examined: 19965
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM anj_content AS a
LEFT JOIN anj_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN anj_categories AS c ON c.id = a.catid
LEFT JOIN anj_users AS ua ON ua.id = a.created_by
LEFT JOIN anj_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (0,149,150,151,152,153,155,156,185,158,159,160,161,202,203,204,205,162,163,164,165,170,171,172,173,174,175,176,177,166,167,168,169,178,179,186,192,180,181,182,183,184) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:18:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:18:10')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created desc LIMIT 0, 7;
# Time: 120508  6:54:44
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 28
SELECT `value` FROM `anj_obrss_config` WHERE `name` = 'view_feedburner';
# Time: 120508  6:55:03
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('383965714268c29e255a880c50051d92', 0, '1336474501');
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE anj_content SET hits = hits + 1 WHERE id = 5094;
# Time: 120508  6:55:12
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('a70dc07018c65381df185e69fdbb42ae', 0, '1336474509');
# Time: 120508  6:55:14
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use tamilmed_4tamiltvdb;
UPDATE z6xk9_phocagallery_categories
SET `hits` = (`hits` + 1)
WHERE id = '617';
# Time: 120508  6:55:15
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 4  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
use medcom_newsdb;
DELETE 
FROM `anj_session`
WHERE `time` < '1336472711';
# Time: 120508  6:55:24
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('d15e560406fbd015c5096eb22c812e6a', 0, '1336474522');
# Time: 120508  6:55:26
# User@Host: tamilmed_dbusert[tamilmed_dbusert] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use tamilmed_4tamiltvdb;
INSERT INTO `z6xk9_session`
(`session_id`, `client_id`, `time`) VALUES 
('106730645ec33557b12ebd8ed34104a4', 0, '1336474523');
# Time: 120508  6:55:33
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use medcom_newsdb;
UPDATE anj_content SET hits = hits + 1 WHERE id = 4957;

i have pm the site address to you.

[shwaran]

Code: Select all

# Time: 120508  6:55:39
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE anj_content SET hits = hits + 1 WHERE id = 5069;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 6  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
UPDATE anj_content SET hits = hits + 1 WHERE id = 4983;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 6  Lock_time: 1  Rows_sent: 0  Rows_examined: 0
UPDATE anj_content SET hits = hits + 1 WHERE id = 5062;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 6  Lock_time: 1  Rows_sent: 1  Rows_examined: 15
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM anj_content AS a
LEFT JOIN anj_categories AS c on c.id = a.catid
LEFT JOIN anj_users AS u on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN  (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE a.id = 4937 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:55:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:55:33') AND (a.state = 1 OR a.state =2);
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 5  Lock_time: 0  Rows_sent: 1  Rows_examined: 15
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM anj_content AS a
LEFT JOIN anj_categories AS c on c.id = a.catid
LEFT JOIN anj_users AS u on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN  (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE a.id = 5013 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:55:34') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:55:34') AND (a.state = 1 OR a.state =2);
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 5  Lock_time: 0  Rows_sent: 1  Rows_examined: 15
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM anj_content AS a
LEFT JOIN anj_categories AS c on c.id = a.catid
LEFT JOIN anj_users AS u on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN  (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE a.id = 4912 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:55:34') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:55:34') AND (a.state = 1 OR a.state =2);
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 6  Lock_time: 1  Rows_sent: 1  Rows_examined: 15
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM anj_content AS a
LEFT JOIN anj_categories AS c on c.id = a.catid
LEFT JOIN anj_users AS u on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM anj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN anj_categories as parent ON parent.id = c.parent_id
LEFT JOIN anj_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN  (SELECT cat.id as id FROM anj_categories AS cat JOIN anj_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE a.id = 5064 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-08 10:55:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-08 10:55:33') AND (a.state = 1 OR a.state =2);
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 6  Lock_time: 1  Rows_sent: 1  Rows_examined: 2575
SELECT `created` FROM anj_content a ORDER BY `created` DESC LIMIT 1;
# Time: 120508  6:55:40
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 7  Lock_time: 1  Rows_sent: 1  Rows_examined: 2575
SELECT `created` FROM anj_content a ORDER BY `created` DESC LIMIT 1;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 7  Lock_time: 1  Rows_sent: 1  Rows_examined: 2575
SELECT `created` FROM anj_content a ORDER BY `created` DESC LIMIT 1;
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 6  Lock_time: 1  Rows_sent: 23  Rows_examined: 1332
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM anj_modules AS m
LEFT JOIN anj_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN anj_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-05-08 10:55:34') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-08 10:55:34') AND m.access IN (1) AND m.client_id = 0 AND (mm.menuid = 589 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering;
# Time: 120508 11:50:03
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('a0ee554ce80ca581e1fde73d2a2112ea', 0, '1336492201');
# Time: 120508 11:50:25
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 4  Lock_time: 0  Rows_sent: 330  Rows_examined: 8581
SELECT * FROM `anj_redirect_links` LIMIT 8251, 330;
# Time: 120508 11:51:42
# User@Host: medcom_newsdbuse[medcom_newsdbuse] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
INSERT INTO `anj_session`
(`session_id`, `client_id`, `time`) VALUES 
('7e4fa705507b1420dd1be7747d10e1f4', 0, '1336492300');

[HDsportsAT]

have anyone found a solution to these problem?