mersad
11-23-2009, 04:53 PM
سلام
من وارد پی اچ پی مای ادمین شدم و تمام جداول رو انتخاب کردم همه رو بهینه سازی کردم
بعد از بهینه سازی زیر قالب با یه سری ارر مواجه شدم
مشکل از کجاست ؟ و چه جوری پیش امد و چه جوری بر طرف کنم ؟
اطلاعات پروفايل
Application afterLoad: 0.000 seconds, 0.23 MB
Application afterInitialise: 0.050 seconds, 2.77 MB
Application afterRoute: 0.056 seconds, 3.23 MB
Application afterDispatch: 0.079 seconds, 4.39 MB
Application afterRender: 0.814 seconds, 6.33 MB
حافظه مصرف شده
6730144
18 پرس و جوهاي ثبت شده
1.
SELECT *
FROM jos_session
WHERE session_id = '82d895ed094beaa89083a3560e10b5a1'
2.
DELETE
FROM jos_session
WHERE ( time < '1258993795' )
3.
SELECT *
FROM jos_session
WHERE session_id = '82d895ed094beaa89083a3560e10b5a1'
4.
UPDATE `jos_session`
SET `time`='1258994695',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1',`client_id`='0',` data`='__default|a:8:{s:15:\"session.counter\";i:1 ;s:19:\"session.timer.start\";i:1258994481;s:18:\" session.timer.last\";i:1258994481;s:17:\"session.t imer.now\";i:1258994481;s:22:\"session.client.brow ser\";s:88:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17 :\"_defaultNameSpace\";s:7:\"session\";s:9:\"_regi stry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8: \"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"us er\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\" ;N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"passwo rd\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"user type\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3 :\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvi sitDate\";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:\"_element Path\";a:1:{i:0;s:65:\"/home/moshkel/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_defau lt\";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:\"81b9fd91c7463566ac ce3347a7652f4d\";}'
WHERE session_id='82d895ed094beaa89083a3560e10b5a1'
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 template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
8.
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 = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
9.
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 1
LIMIT 1
10.
SELECT count(*)
FROM jos_menu AS m
WHERE menutype='mainmenu'
AND published='1'
AND access <= '0'
AND parent=0
AND ordering < 33
11.
SELECT a.id AS id, a.title AS title, COUNT(b.id) AS cnt
FROM jos_sections AS a
LEFT JOIN jos_content AS b
ON a.id = b.sectionid
AND b.access <= 0
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2009-11-23 23:44:55' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2009-11-23 23:44:55' )
WHERE a.scope = "content"
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
LIMIT 0, 5
12.
SELECT *
FROM jos_shoutbox
ORDER BY id DESC
LIMIT 0, 10
13.
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
14.
SELECT DISTINCT a.username
FROM jos_session AS a
WHERE client_id = 0
AND a.guest = 0
15.
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE ip='91.99.160.44'
AND (tm + '600') > '1258994696'
16.
SELECT MAX(id)
FROM jos_vvisitcounter
17.
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm >= '1258921800'
18.
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm >= '1258993496'
فايل هاي زبان بارگزاري شدند
* /home/moshkel/public_html/language/fa-IR/fa-IR.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.plg_system_debug.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.com_content.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.tpl_ja_barite_farsi.ini
* /home/moshkel/public_html/language/en-GB/en-GB.tpl_ja_barite_farsi.ini
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_sections.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_shoutbox.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_adsscroller.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_adsscroller.ini
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_whosonline.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_woodychat.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_woodychat.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_vvisit_counter.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_vvisit_counter.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_AddThis.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_AddThis.ini
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_login.ini 1
Untranslated Strings Diagnostic
هيچ
Untranslated Strings Designer
هيچ
PLZ HELP کمک !!!!! :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'(
من وارد پی اچ پی مای ادمین شدم و تمام جداول رو انتخاب کردم همه رو بهینه سازی کردم
بعد از بهینه سازی زیر قالب با یه سری ارر مواجه شدم
مشکل از کجاست ؟ و چه جوری پیش امد و چه جوری بر طرف کنم ؟
اطلاعات پروفايل
Application afterLoad: 0.000 seconds, 0.23 MB
Application afterInitialise: 0.050 seconds, 2.77 MB
Application afterRoute: 0.056 seconds, 3.23 MB
Application afterDispatch: 0.079 seconds, 4.39 MB
Application afterRender: 0.814 seconds, 6.33 MB
حافظه مصرف شده
6730144
18 پرس و جوهاي ثبت شده
1.
SELECT *
FROM jos_session
WHERE session_id = '82d895ed094beaa89083a3560e10b5a1'
2.
DELETE
FROM jos_session
WHERE ( time < '1258993795' )
3.
SELECT *
FROM jos_session
WHERE session_id = '82d895ed094beaa89083a3560e10b5a1'
4.
UPDATE `jos_session`
SET `time`='1258994695',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1',`client_id`='0',` data`='__default|a:8:{s:15:\"session.counter\";i:1 ;s:19:\"session.timer.start\";i:1258994481;s:18:\" session.timer.last\";i:1258994481;s:17:\"session.t imer.now\";i:1258994481;s:22:\"session.client.brow ser\";s:88:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17 :\"_defaultNameSpace\";s:7:\"session\";s:9:\"_regi stry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8: \"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"us er\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\" ;N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"passwo rd\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"user type\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3 :\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvi sitDate\";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:\"_element Path\";a:1:{i:0;s:65:\"/home/moshkel/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_defau lt\";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:\"81b9fd91c7463566ac ce3347a7652f4d\";}'
WHERE session_id='82d895ed094beaa89083a3560e10b5a1'
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 template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
8.
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 = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
9.
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 1
LIMIT 1
10.
SELECT count(*)
FROM jos_menu AS m
WHERE menutype='mainmenu'
AND published='1'
AND access <= '0'
AND parent=0
AND ordering < 33
11.
SELECT a.id AS id, a.title AS title, COUNT(b.id) AS cnt
FROM jos_sections AS a
LEFT JOIN jos_content AS b
ON a.id = b.sectionid
AND b.access <= 0
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2009-11-23 23:44:55' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2009-11-23 23:44:55' )
WHERE a.scope = "content"
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
LIMIT 0, 5
12.
SELECT *
FROM jos_shoutbox
ORDER BY id DESC
LIMIT 0, 10
13.
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
14.
SELECT DISTINCT a.username
FROM jos_session AS a
WHERE client_id = 0
AND a.guest = 0
15.
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE ip='91.99.160.44'
AND (tm + '600') > '1258994696'
16.
SELECT MAX(id)
FROM jos_vvisitcounter
17.
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm >= '1258921800'
18.
SELECT COUNT(*)
FROM jos_vvisitcounter
WHERE tm >= '1258993496'
فايل هاي زبان بارگزاري شدند
* /home/moshkel/public_html/language/fa-IR/fa-IR.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.plg_system_debug.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.com_content.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.tpl_ja_barite_farsi.ini
* /home/moshkel/public_html/language/en-GB/en-GB.tpl_ja_barite_farsi.ini
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_sections.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_shoutbox.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_adsscroller.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_adsscroller.ini
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_whosonline.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_woodychat.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_woodychat.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_vvisit_counter.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_vvisit_counter.ini 1
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_AddThis.ini
* /home/moshkel/public_html/language/en-GB/en-GB.mod_AddThis.ini
* /home/moshkel/public_html/language/fa-IR/fa-IR.mod_login.ini 1
Untranslated Strings Diagnostic
هيچ
Untranslated Strings Designer
هيچ
PLZ HELP کمک !!!!! :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'( :'(