Profile Information

Memory Usage

Queries logged

1. SELECT MAX(TIME)  
     FROM jos_vvcounter_logs
2. SELECT *
     FROM jos_languages
     WHERE active=1
     ORDER BY ordering
3. SELECT *
     FROM jos_rsfirewall_hashes
     WHERE `type`='1.5.25'
4. SELECT *
     FROM jos_rsfirewall_hashes
     WHERE `type`='1.5.25'
5. SELECT *
     FROM jos_rsfirewall_hashes
     WHERE `type`='protect'
6. SELECT *
     FROM jos_rsfirewall_hashes
     WHERE `type`='protect'
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 jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
   
     FROM jos_jf_content AS jf_content
   
     WHERE jf_content.language_id=2
          
     AND jf_content.published=1
      
     AND jf_content.reference_id IN(196,197,236,237,44,173,188,195,230,249,20,166,45,169,222,231,171,46,134,227,232,47,56,175,235,24,130,181,192,194,233,145,210,234,212,215,1,205,63,96,61,161,64,183,163,178,179,58,167,225,18,228,186,189,28,211,214,220,226,250,252,254,251,247,248)
      
     AND jf_content.reference_table='menu'
9. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 1)
     ORDER BY menuid DESC
     LIMIT 0, 1
10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-16 22:10:45' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-16 22:10:45' )
      ORDER BY  f.ordering
      LIMIT 0, 8
11. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(749,748,747,746,745,744,724,723)
       
      AND jf_content.reference_table='content'
12. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(749,748,747,746,745,744,724,723)
       
      AND jf_content.reference_table='users'
13. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(69,57,68)
       
      AND jf_content.reference_table='categories'
14. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(14,10,1)
       
      AND jf_content.reference_table='sections'
15. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-16 22:10:45' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-16 22:10:45' )
      ORDER BY  f.ordering
16. SELECT created_by, sectionid, catid
      FROM jos_content
      WHERE id='749'
17. SELECT COUNT(*)
      FROM jos_attachments
      WHERE parent_id='749'
      AND published='1'
      AND parent_type='com_content'
18. SELECT a.*, u.name AS uploader_name
      FROM jos_attachments AS a
      LEFT JOIN jos_users AS u
      ON u.id = a.uploader_id
      WHERE a.parent_id='749'
      AND a.published='1'
      AND a.parent_type='com_content'
      AND a.parent_entity='ARTICLE'
      ORDER BY filename
19. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(42)
       
      AND jf_content.reference_table='users'
20. SELECT id
      FROM jos_content
      WHERE id='749'
      LIMIT 1
21. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(749)
       
      AND jf_content.reference_table='content'
22. SELECT title
      FROM jos_content
      WHERE id='749'
23. SELECT created_by, sectionid, catid
      FROM jos_content
      WHERE id='748'
24. SELECT COUNT(*)
      FROM jos_attachments
      WHERE parent_id='748'
      AND published='1'
      AND parent_type='com_content'
25. SELECT a.*, u.name AS uploader_name
      FROM jos_attachments AS a
      LEFT JOIN jos_users AS u
      ON u.id = a.uploader_id
      WHERE a.parent_id='748'
      AND a.published='1'
      AND a.parent_type='com_content'
      AND a.parent_entity='ARTICLE'
      ORDER BY filename
26. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(40,36,38,37,39)
       
      AND jf_content.reference_table='users'
27. SELECT id
      FROM jos_content
      WHERE id='748'
      LIMIT 1
28. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(748)
       
      AND jf_content.reference_table='content'
29. SELECT title
      FROM jos_content
      WHERE id='748'
30. SELECT created_by, sectionid, catid
      FROM jos_content
      WHERE id='747'
31. SELECT COUNT(*)
      FROM jos_attachments
      WHERE parent_id='747'
      AND published='1'
      AND parent_type='com_content'
32. SELECT a.*, u.name AS uploader_name
      FROM jos_attachments AS a
      LEFT JOIN jos_users AS u
      ON u.id = a.uploader_id
      WHERE a.parent_id='747'
      AND a.published='1'
      AND a.parent_type='com_content'
      AND a.parent_entity='ARTICLE'
      ORDER BY filename
33. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(35,41)
       
      AND jf_content.reference_table='users'
34. SELECT id
      FROM jos_content
      WHERE id='747'
      LIMIT 1
35. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(747)
       
      AND jf_content.reference_table='content'
36. SELECT title
      FROM jos_content
      WHERE id='747'
37. SELECT created_by, sectionid, catid
      FROM jos_content
      WHERE id='746'
38. SELECT COUNT(*)
      FROM jos_attachments
      WHERE parent_id='746'
      AND published='1'
      AND parent_type='com_content'
39. SELECT id,params
      FROM jos_plugins
      WHERE element='seftitleprefixsuffix'
40. 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
41. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(35,209,112,93,203,258,146,1,74,73,40,228,16,168,153,183,243,36,31,221,19,22,29,27,191)
       
      AND jf_content.reference_table='modules'
42. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-16 22:10:45' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-16 22:10:45' )
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 5
43. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(749,748,747,746,745)
       
      AND jf_content.reference_table='content'
44. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE ( a.state = 1
      AND s.id > 0 )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-16 22:10:45' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-16 22:10:45' )
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.hits DESC
      LIMIT 0, 5
45. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(192,204,157,270,278)
       
      AND jf_content.reference_table='content'
46. SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug  
      FROM jos_polls
      WHERE id = 14
      AND published = 1
47. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(14)
       
      AND jf_content.reference_table='polls'
48. SELECT id, text
      FROM jos_poll_data
      WHERE pollid = 14
      AND text <> ""
      ORDER BY id
49. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1,2,3,4,5)
       
      AND jf_content.reference_table='poll_data'
50. SELECT a.id,a.dates, a.times, a.enddates,a.title,c.id AS mcatid,c.catname,l.id AS mlocid,l.venue, DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month
      FROM jos_eventlist_events AS a
      LEFT JOIN jos_eventlist_categories AS c
      ON c.id = a.catsid
      LEFT JOIN jos_eventlist_venues AS l
      ON l.id = a.locid
      WHERE a.published = 1
      AND c.access <= 0
51. SELECT *
      FROM jos_languages
      WHERE active=1
      ORDER BY ordering
52. 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
53. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=3
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(196,197,236,237,44,173,188,195,230,249,20,166,45,169,222,231,171,46,134,227,232,47,56,175,235,24,130,181,192,194,233,145,210,234,212,215,1,205,63,96,61,161,64,183,163,178,179,58,167,225,18,228,186,189,28,211,214,220,226,250,252,254,251,247,248)
       
      AND jf_content.reference_table='menu'
54. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=3
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1)
       
      AND jf_content.reference_table='menu'
55. SELECT DISTINCT
                                    c.id AS ID,
                                    c.SECTION AS SID,
                                    c.title AS name,
                                    m.id AS MID
                           
      FROM
                                    jos_categories AS c
                           
      LEFT JOIN
                                    jos_menu AS m
                                   
      ON
                                    c.id = m.componentid
                           
      LEFT JOIN
                                    jos_content AS content
                                   
      ON
                                    c.id = content.catid    
                           
      WHERE
                                    (  c.id = 46 )
                                   
      AND
                                    c.published = 1
                                   
      AND
                                    c.access <= 0;
56. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(46)
       
      AND jf_content.reference_table='categories'
57. SELECT DISTINCT
                            cats.SECTION AS SID,
                            content.title AS title,
                            content.introtext AS text,
                            content.id AS IID,
                            CASE WHEN CHAR_LENGTH(content.alias)
                                    THEN CONCAT_WS(":", content.id, content.alias)
                                            ELSE content.id END AS ID,
                            CASE WHEN CHAR_LENGTH(cats.alias)
                                    THEN CONCAT_WS(":", cats.id, cats.alias)
                                            ELSE cats.id END AS CID                        
                   
      FROM
                            jos_content AS content
                           
      LEFT JOIN
                                    jos_categories AS categories
                                   
      ON categories.id = content.catid
                           
      LEFT JOIN
                                    jos_sections AS sections
                                   
      ON sections.id = content.sectionid
                           
      LEFT JOIN
                                    jos_menu AS menu
                                   
      ON menu.componentid = content.id
                           
      LEFT JOIN
                                    jos_users AS users
                                   
      ON users.id = content.created_by
                           
      LEFT JOIN
                                    jos_categories AS cats
                                   
      ON content.catid = cats.id
                           
      LEFT JOIN
                                    jos_content_frontpage AS frontpage
                                   
      ON content.id = frontpage.content_id
                   
      WHERE
                            content.state = 1
                                   
      AND categories.access <= 0
                                   
      AND content.access <= 0
                           
      AND categories.published = 1  
                           
      AND ( content.publish_up = '0000-00-00 00:00:00'
                                    OR content.publish_up <= '2012-05-17 12:10:46' )
                                   
      AND ( content.publish_down = '0000-00-00 00:00:00'
                                    OR content.publish_down >= '2012-05-17 12:10:46' )
                           
      AND (  content.catid = 46 )  
                   
      ORDER BY
                             content.created DESC
                   
      LIMIT
                            0,10;
58. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
    
      FROM jos_jf_content AS jf_content
    
      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(716,714,710,702,701,698,696,695,694,693)
       
      AND jf_content.reference_table='content'
59. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE ip='38.107.179.228'
      AND (tm + '600') > '1337206246'
60. INSERT INTO jos_vvisitcounter (id, tm, ip)  
      VALUES ('', '1337206246', '38.107.179.228')
61. SELECT MAX(id)
      FROM jos_vvisitcounter
62. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE tm >= '1337187600'
63. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE tm >= '1337101200'
      AND tm < '1337187600'
64. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE tm >= '1336755600'
      AND tm < '1337187600'
65. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE tm >= '1336150800'
      AND tm < '1336755600'
66. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE tm >= '1335805200'
      AND tm < '1337187600'
67. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE tm >= '1333213200'
      AND tm < '1335805200'
68. SELECT COUNT(*)
      FROM jos_vvisitcounter  
      WHERE tm >= '1337205046'

Legacy Queries logged

Language Files Loaded

• /home/web/fic.ifrpd.ku.ac.th/html/fic/language/en-GB/en-GB.ini 1
• /home/web/fic.ifrpd.ku.ac.th/html/fic/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/web/fic.ifrpd.ku.ac.th/html/fic/language/en-GB/en-GB.mod_vvisit_counter.ini 1
• /home/web/fic.ifrpd.ku.ac.th/html/fic/language/en-GB/en-GB.mod_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None