PROCESO DE ADMISIÓN EN CENTROS PÚBLICOS DE EXTREMADURA CURSO 2012/13

Perfíl de la información

Memoria usada

96 queries identificadas

1. SELECT *
     FROM jos15_session
     WHERE session_id = '63e9ac957a46b982b2c7322245cd4977'
2. DELETE
     FROM jos15_session
     WHERE ( TIME < '1337435994' )
3. SELECT *
     FROM jos15_session
     WHERE session_id = '63e9ac957a46b982b2c7322245cd4977'
4. INSERT INTO `jos15_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '63e9ac957a46b982b2c7322245cd4977','1337436894','','0','1','0' )
5. SELECT *
     FROM jos15_components
     WHERE parent = 0
6. SELECT folder AS TYPE, element AS name, params
     FROM jos15_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT name,player_id,ripper_id,postreplace
     FROM jos15_avr_tags
8. SELECT name,player_id,ripper_id,postreplace
     FROM jos15_avr_tags
9. SELECT m.*, c.`option` AS component
     FROM jos15_menu AS m
     LEFT JOIN jos15_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
10. SELECT template
      FROM jos15_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 79)
      ORDER BY menuid DESC
      LIMIT 0, 1
11. 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 jos15_content AS a
      INNER JOIN jos15_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos15_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos15_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos15_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos15_groups AS g
      ON a.access = g.id
      WHERE 1
      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-19 14:14:55' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 14:14:55' )
      ORDER BY  f.ordering
      LIMIT 0, 9
12. 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 jos15_content AS a
      INNER JOIN jos15_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos15_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos15_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos15_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos15_groups AS g
      ON a.access = g.id
      WHERE 1
      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-19 14:14:55' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 14:14:55' )
      ORDER BY  f.ordering
13. SELECT id
      FROM jos15_components
      WHERE `option`='com_phocagallery'
      AND parent = 0
      LIMIT 0, 1
14. SELECT *
      FROM jos15_components
      WHERE id = '67'
15. SELECT id
      FROM jos15_components
      WHERE `option`='com_phocagallery'
      AND parent = 0
      LIMIT 0, 1
16. SELECT *
      FROM jos15_components
      WHERE id = '67'
17. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos15_modules AS m
      LEFT JOIN jos15_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 = 79 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
18. SELECT id
      FROM jos15_components
      WHERE `option`='com_phocagallery'
      AND parent = 0
      LIMIT 0, 1
19. SELECT *
      FROM jos15_components
      WHERE id = '67'
20. SELECT cc.title AS text, cc.id AS id, cc.parent_id AS parentid, cc.alias AS alias, cc.access AS access, cc.accessuserid AS accessuserid
      FROM jos15_phocagallery_categories AS cc
      WHERE cc.published = 1
      AND cc.access <= 0
      ORDER BY cc.ordering
21. SELECT cc.id AS idcat, a.id AS idimage
      FROM jos15_phocagallery_categories AS cc
      LEFT JOIN jos15_phocagallery AS a
      ON a.catid = cc.id
      WHERE a.published = 1
      AND cc.published = 1
      AND cc.id IN (4)
      ORDER BY a.ordering DESC
      LIMIT 0,5
22. SELECT cc.id, a.id, a.catid, a.title, a.alias, a.filename, a.description, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END AS catslug,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
      FROM jos15_phocagallery_categories AS cc
      LEFT JOIN jos15_phocagallery AS a
      ON a.catid = cc.id
      WHERE a.id IN (32,31,30,29,28)
      ORDER BY a.ordering DESC
23. SELECT bid,imageurl,custombannercode,description,impmade,imptotal
      FROM jos15_banner
      WHERE showBanner=1
      AND (imptotal = 0 OR impmade < imptotal)
      AND (catid IN (12) OR cid IN (18))
      ORDER BY bid
24. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 15
25. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 16
26. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 17
27. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 18
28. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 19
29. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 20
30. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 21
31. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 22
32. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 23
33. UPDATE jos15_banner
      SET impmade=impmade+1
      WHERE bid = 24
34. SELECT *
      FROM jos15_jcalpro2_config
35. SELECT unix_timestamp( '2012-05-19 14:14:55');
36. SELECT name
      FROM jos15_jcalpro2_themes
      WHERE published= '1'
37. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'registered'
38. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 4
      AND g1.lft <11
      GROUP BY g1.name
      ORDER BY g1.lft
39. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
40. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
41. SELECT id, name
      FROM jos15_core_acl_aro_groups;
42. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'manager'
43. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
44. SELECT id, name
      FROM jos15_core_acl_aro_groups;
45. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'manager'
46. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
47. SELECT id, name
      FROM jos15_core_acl_aro_groups;
48. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'manager'
49. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
50. SELECT id, name
      FROM jos15_core_acl_aro_groups;
51. SELECT
            cat_id, level
     
      FROM
            jos15_jcalpro2_categories
52. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
53. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
54. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
55. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
56. SELECT id, name
      FROM jos15_core_acl_aro_groups;
57. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
58. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
59. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
60. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
61. SELECT id, name
      FROM jos15_core_acl_aro_groups;
62. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
63. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
64. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
65. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
66. SELECT id, name
      FROM jos15_core_acl_aro_groups;
67. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
68. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
69. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
70. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
71. SELECT id, name
      FROM jos15_core_acl_aro_groups;
72. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
73. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
74. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
75. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
76. SELECT id, name
      FROM jos15_core_acl_aro_groups;
77. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
78. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
79. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
80. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
81. SELECT id, name
      FROM jos15_core_acl_aro_groups;
82. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
83. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
84. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
85. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
86. SELECT id, name
      FROM jos15_core_acl_aro_groups;
87. SELECT
            cal_id, level
     
      FROM
            jos15_jcalpro2_calendars
88. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public frontend'
89. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
90. SELECT lft, rgt
      FROM jos15_core_acl_aro_groups
      WHERE name = 'public backend'
91. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos15_core_acl_aro_groups AS g1
      INNER JOIN jos15_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
92. SELECT id, name
      FROM jos15_core_acl_aro_groups;
93. SELECT cat_id
      FROM jos15_jcalpro2_categories
      WHERE `published`='1'
94. SELECT e.*, c.cat_id, c.cat_name, c.color, c.description AS cat_desc
      FROM jos15_jcalpro2_events AS e
      LEFT JOIN jos15_jcalpro2_categories AS c
      ON e.cat=c.cat_id  
      LEFT JOIN jos15_jcalpro2_calendars AS cal
      ON e.cal_id=cal.cal_id
      WHERE (    ( e.start_date <= '2012-05-19 00:00:00'
      AND e.end_date >= '2012-05-31 23:59:59' )   OR ( e.start_date > '2012-05-19 00:00:00'
      AND e.start_date <= '2012-05-31 23:59:59')  OR ( e.end_date > '2012-05-19 00:00:00'
      AND e.end_date <= '2012-05-31 23:59:59' ) )
      AND c.published = '1'
      AND e.published = '1'
      AND cal.published='1'
      AND approved = '1'
      AND e.cat IN (2, 4, 6, 7)
      AND e.cal_id IN (1)
      AND (e.private IN ('0', '2') OR (e.owner_id = '0'
      AND e.private = '1'))
      ORDER BY start_date,title ASC
95. SELECT guest, usertype, client_id
      FROM jos15_session
      WHERE client_id = 0
96. SELECT DISTINCT a.username
      FROM jos15_session AS a
      WHERE client_id = 0
      AND a.guest = 0

2 legado de las queries identificadas

1. SELECT m.*, SUM(CASE WHEN p.published=1 THEN 1 ELSE 0 END) AS cnt
   
     FROM jos15_menu AS m
   
     LEFT JOIN jos15_menu AS p
     ON p.parent = m.id
   
     WHERE m.menutype='mainmenu'
     AND m.published='1'
     AND m.access <= '0'
   
     GROUP BY m.id
     ORDER BY m.parent, m.ordering
2. SELECT m.*
     FROM jos15_menu AS m
   
     WHERE menutype='mainmenu'
     AND m.published='1'

Archivos de idioma cargados

• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.ini 1
• /var/www/iesdrfdezsantana/http/administrator/language/es-ES/es-ES.plg_content_avreloaded.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.plg_system_debug.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.com_content.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.com_pollxt.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.plg_content_pagebreak.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.tpl_2i_secundaria1.ini
• /var/www/iesdrfdezsantana/http/language/en-GB/en-GB.tpl_2i_secundaria1.ini
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.mod_mainmenu.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.mod_phocagallery_image.ini
• /var/www/iesdrfdezsantana/http/language/en-GB/en-GB.mod_phocagallery_image.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.mod_bannerslider.ini
• /var/www/iesdrfdezsantana/http/language/en-GB/en-GB.mod_bannerslider.ini
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.mod_jcalpro_minical_J15.ini
• /var/www/iesdrfdezsantana/http/language/en-GB/en-GB.mod_jcalpro_minical_J15.ini
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.mod_whosonline.ini 1
• /var/www/iesdrfdezsantana/http/language/es-ES/es-ES.mod_search.ini 1

Sin traducir las cadenas de diagnóstico

Ninguno

Sin traducir las cadenas de diseñador

Ninguno