www.entrenadoresdeporteros.com

Profile Information

Memory Usage

12 queries logged

1. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 209)
     ORDER BY menuid DESC
     LIMIT 0, 1
2. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
     FROM jos_content AS a
     LEFT JOIN jos_categories AS cc
     ON cc.id = a.catid
     LEFT JOIN jos_sections AS s
     ON s.id = cc.SECTION
     AND s.scope = "content"
     LEFT JOIN jos_users AS u
     ON u.id = a.created_by
     LEFT JOIN jos_groups AS g
     ON a.access = g.id
     LEFT JOIN jos_content_rating AS v
     ON a.id = v.content_id
     WHERE a.id = 219
     AND (  ( a.created_by = 0 )    OR  ( a.state = 1
     AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 06:44:20' )
     AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 06:44:20' )   )    OR  ( a.state = -1 )  )
3. 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=1
          
     AND jf_content.published=1
      
     AND jf_content.reference_id IN(219)
      
     AND jf_content.reference_table='content'
4. 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=1
          
     AND jf_content.published=1
      
     AND jf_content.reference_id IN(219)
      
     AND jf_content.reference_table='users'
5. 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=1
          
     AND jf_content.published=1
      
     AND jf_content.reference_id IN(39)
      
     AND jf_content.reference_table='categories'
6. 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=1
          
     AND jf_content.published=1
      
     AND jf_content.reference_id IN(29)
      
     AND jf_content.reference_table='sections'
7. UPDATE jos_content
     SET hits = ( hits + 1 )
     WHERE id='219'
8. SELECT *
     FROM jos_chrono_comments
     WHERE component = 'com_content'
     AND pageid= '219'
     AND parentid='0'
     AND published='1'
     AND verify='1'
     ORDER BY datetime ASC
9. SELECT a.id, 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_categories AS cc
     ON cc.id = a.catid
     WHERE a.catid = 39
     AND a.state = 1
     AND a.access <= 0
     AND ( a.state = 1 OR a.state = -1 )
     AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-05-20 06:44:20' )
     AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-05-20 06:44:20' )
     ORDER BY a.ordering
10. 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=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(347,219,207,181)
       
      AND jf_content.reference_table='content'
11. 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 = 209 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
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=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(83,33,1,103,75,16,113,101,27,95,25,29)
       
      AND jf_content.reference_table='modules'

Language Files Loaded

• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.ini 1
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.plg_system_vvisit_counter.ini
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.plg_system_debug.ini 1
• /srv/www.entrenadoresdeporteros.com/administrator/language/en-GB/en-GB.plg_system_osolcaptcha.ini 1
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.com_content.ini 1
• /srv/www.entrenadoresdeporteros.com/administrator/language/en-GB/en-GB.plg_joomfish_missing_translation.ini 1
• /srv/www.entrenadoresdeporteros.com/administrator/language/en-GB/en-GB.plg_jfalternative.ini
• administrator/language/en-GB/en-GB.plg_content_jw_allvideos.ini 1
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.com_chronocomments.ini 1
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.plg_content_pagebreak.ini 1
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.plg_content_vote.ini 1
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.tpl_1columnastemplateedu02.ini
• /srv/www.entrenadoresdeporteros.com/language/en-GB/en-GB.mod_mainmenu.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None