Profile Information

Memory Usage

9 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'ful9ekf6m7fm0ihjtu34db46q0'
2. DELETE
     FROM jos_session
     WHERE ( time < '1284014071' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'ful9ekf6m7fm0ihjtu34db46q0'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'ful9ekf6m7fm0ihjtu34db46q0','1284014971','','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 = 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=85
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 (85,98,97,96,95,94,93,92,86,87,88,89,90,91)
     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 (85,98,97,96,95,94,93,92,86,87,88,89,90,91)
     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