|
I checked them but do not understand them well, tried to open them with various log analyzers but only a bunch of bots and spiders there? how to eliminate what is using the CPU?
and the debug I have turned now on and it gives me this: [code]Profile Information
Application afterLoad: 0.001 seconds, 1.00 MB
Application afterInitialise: 0.046 seconds, 6.46 MB
Application afterRoute: 0.100 seconds, 8.73 MB
Application afterDispatch: 0.154 seconds, 12.00 MB
Application afterRender: 0.786 seconds, 18.24 MB
Memory Usage
19165632
46 queries logged.
SELECT *
FROM jos_session
WHERE session_id = '99198517e773fcecb8b0feafc8e7c8bd'
DELETE
FROM jos_session
WHERE ( TIME < '1329491941' )
SELECT *
FROM jos_session
WHERE session_id = '99198517e773fcecb8b0feafc8e7c8bd'
UPDATE `jos_session`
WHERE session_id='99198517e773fcecb8b0feafc8e7c8bd'
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT `value`
FROM `jos_admintools_storage`
WHERE `key` = 'cparams'
SELECT *
FROM `jos_rsfirewall_configuration`
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='1.5.25'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='1.5.25'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='protect'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='protect'
SELECT *
FROM jos_components
WHERE parent = 0
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 <= 2
AND m.client_id = 1
ORDER BY POSITION, ordering
SELECT i.*, v.name AS author
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
LEFT JOIN jos_users AS v
ON v.id = i.created_by
WHERE i.trash = 0
AND c.trash = 0
ORDER BY i.created DESC
LIMIT 0, 10
SELECT i.*, v.name AS author
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
LEFT JOIN jos_users AS v
ON v.id = i.created_by
WHERE i.trash = 0
AND c.trash = 0
ORDER BY i.hits DESC
LIMIT 0, 10
SELECT i.*, v.name AS author, COUNT(comments.id) AS numOfComments
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
LEFT JOIN jos_users AS v
ON v.id = i.created_by
LEFT JOIN jos_k2_comments comments
ON comments.itemID = i.id
WHERE i.trash = 0
AND c.trash = 0
GROUP BY i.id
ORDER BY numOfComments DESC
LIMIT 0, 10
SELECT *
FROM jos_k2_comments
ORDER BY commentDate DESC
LIMIT 0, 10
SELECT COUNT(*)
FROM jos_k2_items
SELECT COUNT(*)
FROM jos_k2_items
WHERE trash=1
SELECT COUNT(*)
FROM jos_k2_items
WHERE featured=1
SELECT COUNT(*)
FROM jos_k2_comments
SELECT COUNT(*)
FROM jos_k2_categories
SELECT COUNT(*)
FROM jos_k2_categories
WHERE trash=1
SELECT COUNT(*)
FROM jos_k2_users
SELECT COUNT(*)
FROM jos_k2_user_groups
SELECT COUNT(*)
FROM jos_k2_tags
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
SELECT *
FROM `jos_rsfirewall_configuration`
SELECT *
FROM jos_rsfirewall_logs
ORDER BY `date` DESC
LIMIT 5
SELECT COUNT(*)
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username
SELECT username, TIME, userid, usertype, client_id
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username
SELECT a.hits, a.id, a.sectionid, a.title, a.created, u.name
FROM jos_content AS a
LEFT JOIN jos_users AS u
ON u.id=a.created_by
WHERE a.state <> -2
ORDER BY hits DESC
LIMIT 0, 10
SELECT a.id, a.sectionid, a.title, a.created, a.modified, u.name, a.created_by_alias, a.created_by
FROM jos_content AS a
LEFT JOIN jos_users AS u
ON u.id = a.created_by
WHERE a.state <> -2
ORDER BY created DESC
LIMIT 0, 10
SELECT menutype, COUNT(id) AS numitems
FROM jos_menu
WHERE published = 1
GROUP BY menutype
SELECT `configuration`
FROM `jos_ak_profiles`
WHERE `id` = ''
SELECT `params`
FROM `jos_components`
WHERE (`link` = 'option=com_akeeba')
AND (`parent` = '0')
UPDATE `jos_ak_profiles`
WHERE `id` = ''
SELECT *
FROM `jos_ak_stats`
WHERE (`tag` <> 'restorepoint')
ORDER BY `backupstart` DESC
LIMIT 0, 20
SELECT `id`
FROM `jos_ak_stats`
WHERE `filesexist` = 1
AND`id` IN (SELECT MAX(`id`) AS `id`
FROM `jos_ak_stats`
WHERE `status` = 'complete'
GROUP BY `absolute_path`)
AND NOT (`absolute_path` = '')
ORDER BY `id` DESC
SELECT `value`
FROM `jos_admintools_storage`
WHERE `key` = 'cparams'
SELECT a.*, SUM(b.home) AS home
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
GROUP BY a.id
SELECT *
FROM jos_components
WHERE `option` <> "com_frontpage"
AND `option` <> "com_media"
AND enabled = 1
ORDER BY ordering, name
SELECT joomlatablename,tablepkID
FROM `jos_jf_tableinfo`
SELECT `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`metakey` AS `metakey`,`l`.`metadesc` AS `metadesc`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering`
FROM (`jos_languages` `l`
LEFT JOIN `jos_jf_languages_ext` `lext`
ON((`l`.`lang_id` = `lext`.`lang_id`)))
ORDER BY `lext`.`ordering`
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 63
SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1
Last edited by johnniek2 on Sat Feb 18, 2012 7:53 am, edited 1 time in total.
|
