Profilovacie informácie

Využitie pamäte

10 zalogovaných dotazov

1. SELECT *
     FROM jos_session
     WHERE session_id = 'aa9ae0d25a6d8327ef2b13d5467ff432'
2. DELETE
     FROM jos_session
     WHERE ( time < '1332356810' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'aa9ae0d25a6d8327ef2b13d5467ff432'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'aa9ae0d25a6d8327ef2b13d5467ff432','1332357710','','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 template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 112)
     ORDER BY menuid DESC
     LIMIT 0, 1
8. 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 = 112 OR mm.menuid = 0 )
     ORDER BY position, ordering
9. 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.section = 2 )
                                  
     AND
                                   c.published = 1
                                  
     AND
                                   c.access <= 0;
10. SELECT DISTINCT
                                    cats.title AS cat,
                                    users.username AS author,
                                    cats.section AS SID,
                                    content.title AS title,
                                    content.introtext AS text,
                                    content.created AS date,
                                    content.publish_up AS date_publish,
                                content.images AS images,
                                    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_content_frontpage AS frontpage
                                           
      ON content.id = frontpage.content_id       
                                   
      LEFT JOIN
                                            jos_categories AS cats
                                           
      ON content.catid = cats.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-03-21 19:21:51' )
                                           
      AND ( content.publish_down = '0000-00-00 00:00:00'
                                            OR content.publish_down >= '2012-03-21 19:21:51' )
                                   
      AND (  content.catid = 9 OR content.catid = 10 OR content.catid = 11 OR content.catid = 12 OR content.catid = 13 OR content.catid = 14 OR content.catid = 15 OR content.catid = 16 OR content.catid = 17 OR content.catid = 18 OR content.catid = 28 OR content.catid = 30 OR content.catid = 37 )
                                    
                           
      ORDER BY
                                     content.created DESC
                           
      LIMIT
                                    0,5;

8 zalogovaných starších dotazov

1. SELECT *
     FROM jos_joomleague
     WHERE id = '20'
2. SELECT pp.id
     FROM jos_joomleague_predictiongame_project AS pp
                
     LEFT JOIN jos_joomleague_predictiongame AS p
     ON p.id = pp.prediction_id
                
     WHERE pp.project_id = 20
     AND p.published = 1
3. SELECT params
     FROM jos_joomleague_template_config
     WHERE template = 'overall.tpl'
                                                          
     AND project_id = 20
4. SELECT params
     FROM jos_joomleague_template_config
     WHERE template = 'show_club.tpl'
                                                          
     AND project_id = 20
5. SELECT *
     FROM jos_joomleague_clubs
     WHERE id = '157'
6. SELECT id, name AS team_name, short_name AS team_shortcut, description AS team_description
                        
     FROM jos_joomleague_teams
                        
     WHERE club_id = 157
7. SELECT DISTINCT(standard_playground)
     FROM jos_joomleague_team_joomleague
                                   
     WHERE team_id = 188
                    
     AND standard_playground > 0
8. SELECT m.match_id, m.match_date,
                         m.alt_decision,
                         m.matchpart1_result, m.matchpart2_result,
                         m.matchpart1_result_decision, m.matchpart2_result_decision,
                         t1.id AS homeId, t1.name AS homeName,
                         t2.id AS awayId, t2.name AS awayName,
                         pg.name AS playgroundName,
                         p.name AS projectName , ref.id AS refereeId, CONCAT( ref.firstname, ' ', ref.lastname ) AS refereeName 
     FROM jos_joomleague_matches AS m
                  
     INNER JOIN jos_joomleague_teams AS t1
     ON t1.id = m.matchpart1
                  
     INNER JOIN jos_joomleague_teams AS t2
     ON t2.id = m.matchpart2
                  
     LEFT  JOIN jos_joomleague_playgrounds AS pg
     ON pg.id = m.playground_id
                  
     INNER JOIN jos_joomleague AS p
     ON p.id = m.project_id
                  
     INNER JOIN jos_joomleague_seasons AS s
     ON s.id = p.season_id
     LEFT JOIN jos_joomleague_referees AS ref
     ON ref.id = m.referee_id 
     WHERE p.published = 1
                  
     AND ( t1.club_id = 157 OR t2.club_id = 157 ) 
     AND s.id = 2
     ORDER BY m.match_date ASC

Načítané jazykové súbory

• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.ini 1
• /home/html/futbalvregione.sk/public_html/administrator/language/sk-SK/sk-SK.com_j2xml.ini
• /home/html/futbalvregione.sk/public_html/administrator/language/en-GB/en-GB.com_j2xml.ini 1
• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.plg_system_debug.ini 1
• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.com_joomleague.ini
• /home/html/futbalvregione.sk/public_html/language/en-GB/en-GB.com_joomleague.ini
• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.com_k2.ini
• /home/html/futbalvregione.sk/public_html/language/en-GB/en-GB.com_k2.ini 1
• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.tpl_fvr.ini
• /home/html/futbalvregione.sk/public_html/language/en-GB/en-GB.tpl_fvr.ini
• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.mod_mainmenu.ini 1
• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.mod_gk_news_highlighter.ini
• /home/html/futbalvregione.sk/public_html/language/en-GB/en-GB.mod_gk_news_highlighter.ini 1
• /home/html/futbalvregione.sk/public_html/language/sk-SK/sk-SK.mod_login.ini 1

Nepreložené reťazce diagnostiky

Nič

Nepreložené reťazce návrhára

Nič