Profile Information

Memory Usage

9 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'ful9ekf6m7fm0ihjtu34db46q0'
2. DELETE
     FROM jos_session
     WHERE ( time < '1284014770' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'ful9ekf6m7fm0ihjtu34db46q0'
4. UPDATE `jos_session`
     SET `time`='1284015670',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1284014971;s:18:\"session.timer.last\";i:1284015470;s:17:\"session.timer.now\";i:1284015582;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";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:82:\"/hsphere/local/home/premjit/makemydeal.com/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:{}}}'
     WHERE session_id='ful9ekf6m7fm0ihjtu34db46q0'
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 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
8. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 1)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. 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

17 legacy queries logged

1. SELECT c.id, c.name, c.description, c.parent 
     FROM jos_adsmanager_categories AS c
     WHERE c.published='1'
     AND c.id=30
2. SELECT c.id, c.name,c.parent 
     FROM jos_adsmanager_categories AS c
     WHERE c.published = 1
     ORDER BY c.parent,c.ordering
3. SELECT f.*
     FROM jos_adsmanager_fields AS f
     WHERE f.searchable = 1
     AND f.published = 1
     ORDER BY f.ordering
4. SELECT DISTINCT a.id
     FROM jos_adsmanager_ads AS a
     LEFT JOIN jos_adsmanager_adcat AS adcat
     ON a.id = adcat.adid
     WHERE adcat.catid IN (30,40,39,38,31,32,33,34,35,36,37)
     AND a.published = 1
5. SELECT *
     FROM jos_adsmanager_config
6. SELECT f.*
     FROM jos_adsmanager_fields AS f
     WHERE f.published = 1
7. SELECT f.title,f.fieldid,f.catsid
     FROM jos_adsmanager_fields AS f
     WHERE f.sort = 1
     AND f.published = 1
8. SELECT a.*, p.name AS parent, p.id AS parentid, c.name AS cat, c.id AS catid, u.name AS user
     FROM jos_adsmanager_ads AS a
     LEFT JOIN jos_adsmanager_adcat AS adcat
     ON adcat.adid = a.id
     LEFT JOIN jos_users AS u
     ON a.userid = u.id
     LEFT JOIN jos_adsmanager_categories AS c
     ON adcat.catid = c.id
     LEFT JOIN jos_adsmanager_categories AS p
     ON c.parent = p.id
     WHERE adcat.catid IN (30,40,39,38,31,32,33,34,35,36,37)
     AND a.published = 1
     AND c.published = 1
     GROUP BY a.id
     ORDER BY a.date_created DESC ,a.id DESC
     LIMIT 0, 40
9. SELECT c.*
     FROM jos_adsmanager_columns AS c
     ORDER BY c.ordering
10. SELECT c.*
      FROM jos_adsmanager_fields AS c
      WHERE c.columnid != -1
      AND c.published = 1
      ORDER BY c.columnorder,c.fieldid
11. SELECT *
      FROM jos_adsmanager_positions
      WHERE 1
12. SELECT f.*
      FROM jos_adsmanager_fields AS f
      WHERE f.pos != -1
      AND f.published = 1
      ORDER BY f.posorder
13. SELECT *
      FROM jos_adsmanager_field_values
      ORDER BY ordering
14. SELECT c.*
      FROM jos_adsmanager_categories AS c
      WHERE c.published = 1
      ORDER BY c.parent,c.ordering
15. SELECT c.*,  (SELECT count(*)   
      FROM jos_adsmanager_ads a   
      LEFT JOIN jos_adsmanager_adcat AS adcat
      ON adcat.adid = a.id   
      WHERE adcat.catid = c.id     
      AND a.published = 1  ) AS num_ads
      FROM jos_adsmanager_categories AS c
      WHERE c.published = 1
      ORDER BY c.parent,c.ordering
16. SELECT a.id,a.views, a.ad_headline, a.category, a.date_created,p.id AS parentid,p.name AS parent,c.id AS catid, c.name AS cat
      FROM jos_adsmanager_ads AS a
      LEFT JOIN jos_adsmanager_adcat AS adcat
      ON adcat.adid = a.id
      LEFT JOIN jos_users AS u
      ON a.userid = u.id
      LEFT JOIN jos_adsmanager_categories AS c
      ON adcat.catid = c.id
      LEFT JOIN jos_adsmanager_categories AS p
      ON c.parent = p.id
      WHERE  c.published = 1
      AND a.published = 1
      GROUP BY a.id
      ORDER BY a.date_created DESC ,a.id DESC 
      LIMIT 0, 10
17. SELECT *
      FROM jos_adsmanager_config

Language Files Loaded

• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.ini 1
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.plg_system_debug.ini 1
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.com_adsmanager.ini
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.tpl_ja_raite.ini 1
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_breadcrumbs.ini 1
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_adsmanager_search.ini
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_cblogin.ini
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_login.ini 1
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_adsmanager_menu.ini
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_uddeim.ini
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_adsmanager_ads.ini
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_anything.ini
• /hsphere/local/home/premjit/makemydeal.com/language/en-GB/en-GB.mod_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None