Profile Information

Memory Usage

9 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '7o58mot1o3pg36jhedh40s50u4'
2. DELETE
     FROM jos_session
     WHERE ( time < '1283555957' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '7o58mot1o3pg36jhedh40s50u4'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '7o58mot1o3pg36jhedh40s50u4','1283556857','','0','1','0' )
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 = 53)
     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 = 53 OR mm.menuid = 0 )
     ORDER BY position, ordering

15 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=100
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 (100,108,107,106,105,104,103,102,101,109)
     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 (100,108,107,106,105,104,103,102,101,109)
     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

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_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_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