CF 215 | The Daily Workout

Profile Information

Memory Usage

103 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 't9isoeeogvpb1kplijgbeod046'
2. DELETE
     FROM jos_session
     WHERE ( time < '1268274739' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 't9isoeeogvpb1kplijgbeod046'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 't9isoeeogvpb1kplijgbeod046','1268278339','','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 = 1)
     ORDER BY menuid DESC
     LIMIT 0, 1
8. SELECT *
     FROM jos_sections
     WHERE id = 8
     LIMIT 0, 1
9. 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.attribs, a.hits, a.images, a.urls, a.ordering, 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, cc.title AS category, g.name AS groups, u.email AS author_email
     FROM jos_content AS a
     INNER 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 a.access <= 0
     AND s.id = 8
     AND s.access <= 0
     AND cc.access <= 0
     AND s.published = 1
     AND cc.published = 1
     AND a.state = 1
     AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-03-11 03:32:19' )
     AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-03-11 03:32:19' )
     ORDER BY  a.created DESC
     LIMIT 0, 16
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.attribs, a.hits, a.images, a.urls, a.ordering, 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, cc.title AS category, g.name AS groups, u.email AS author_email
      FROM jos_content AS a
      INNER 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 a.access <= 0
      AND s.id = 8
      AND s.access <= 0
      AND cc.access <= 0
      AND s.published = 1
      AND cc.published = 1
      AND a.state = 1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-03-11 03:32:19' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-03-11 03:32:19' )
      ORDER BY  a.created DESC
11. SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
      FROM jos_categories AS a
      LEFT JOIN jos_content AS b
      ON b.catid = a.id
      AND b.state = 1
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2010-03-11 03:32' )
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2010-03-11 03:32' )
      AND b.access <= 0
      WHERE a.section = 8
      AND a.published = 1
      AND a.access <= 0
      GROUP BY a.id
      HAVING numitems > 0
      ORDER BY a.ordering
12. SELECT *
      FROM jos_content
      WHERE id = '431'
13. SELECT *
      FROM jos_sections
      WHERE id = '8'
14. SELECT *
      FROM jos_categories
      WHERE id = '54'
15. SELECT *
      FROM jos_content_rating
      WHERE content_id = 431
16. SELECT *
      FROM jos_content
      WHERE id = '431'
17. SELECT *
      FROM jos_sections
      WHERE id = '8'
18. SELECT *
      FROM jos_categories
      WHERE id = '54'
19. SELECT *
      FROM jos_content_rating
      WHERE content_id = 431
20. SELECT *
      FROM jos_content
      WHERE id = '428'
21. SELECT *
      FROM jos_sections
      WHERE id = '8'
22. SELECT *
      FROM jos_categories
      WHERE id = '53'
23. SELECT *
      FROM jos_content_rating
      WHERE content_id = 428
24. SELECT *
      FROM jos_content
      WHERE id = '428'
25. SELECT *
      FROM jos_sections
      WHERE id = '8'
26. SELECT *
      FROM jos_categories
      WHERE id = '53'
27. SELECT *
      FROM jos_content_rating
      WHERE content_id = 428
28. SELECT *
      FROM jos_content
      WHERE id = '427'
29. SELECT *
      FROM jos_sections
      WHERE id = '8'
30. SELECT *
      FROM jos_categories
      WHERE id = '53'
31. SELECT *
      FROM jos_content_rating
      WHERE content_id = 427
32. SELECT *
      FROM jos_content
      WHERE id = '427'
33. SELECT *
      FROM jos_sections
      WHERE id = '8'
34. SELECT *
      FROM jos_categories
      WHERE id = '53'
35. SELECT *
      FROM jos_content_rating
      WHERE content_id = 427
36. SELECT *
      FROM jos_content
      WHERE id = '426'
37. SELECT *
      FROM jos_sections
      WHERE id = '8'
38. SELECT *
      FROM jos_categories
      WHERE id = '53'
39. SELECT *
      FROM jos_content_rating
      WHERE content_id = 426
40. SELECT *
      FROM jos_content
      WHERE id = '426'
41. SELECT *
      FROM jos_sections
      WHERE id = '8'
42. SELECT *
      FROM jos_categories
      WHERE id = '53'
43. SELECT *
      FROM jos_content_rating
      WHERE content_id = 426
44. SELECT *
      FROM jos_content
      WHERE id = '425'
45. SELECT *
      FROM jos_sections
      WHERE id = '8'
46. SELECT *
      FROM jos_categories
      WHERE id = '55'
47. SELECT *
      FROM jos_content_rating
      WHERE content_id = 425
48. SELECT *
      FROM jos_content
      WHERE id = '425'
49. SELECT *
      FROM jos_sections
      WHERE id = '8'
50. SELECT *
      FROM jos_categories
      WHERE id = '55'
51. SELECT *
      FROM jos_content_rating
      WHERE content_id = 425
52. SELECT *
      FROM jos_content
      WHERE id = '424'
53. SELECT *
      FROM jos_sections
      WHERE id = '8'
54. SELECT *
      FROM jos_categories
      WHERE id = '57'
55. SELECT *
      FROM jos_content_rating
      WHERE content_id = 424
56. SELECT *
      FROM jos_content
      WHERE id = '424'
57. SELECT *
      FROM jos_sections
      WHERE id = '8'
58. SELECT *
      FROM jos_categories
      WHERE id = '57'
59. SELECT *
      FROM jos_content_rating
      WHERE content_id = 424
60. SELECT *
      FROM jos_content
      WHERE id = '423'
61. SELECT *
      FROM jos_sections
      WHERE id = '8'
62. SELECT *
      FROM jos_categories
      WHERE id = '53'
63. SELECT *
      FROM jos_content_rating
      WHERE content_id = 423
64. SELECT *
      FROM jos_content
      WHERE id = '423'
65. SELECT *
      FROM jos_sections
      WHERE id = '8'
66. SELECT *
      FROM jos_categories
      WHERE id = '53'
67. SELECT *
      FROM jos_content_rating
      WHERE content_id = 423
68. SELECT *
      FROM jos_content
      WHERE id = '422'
69. SELECT *
      FROM jos_sections
      WHERE id = '8'
70. SELECT *
      FROM jos_categories
      WHERE id = '53'
71. SELECT *
      FROM jos_content_rating
      WHERE content_id = 422
72. SELECT *
      FROM jos_content
      WHERE id = '422'
73. SELECT *
      FROM jos_sections
      WHERE id = '8'
74. SELECT *
      FROM jos_categories
      WHERE id = '53'
75. SELECT *
      FROM jos_content_rating
      WHERE content_id = 422
76. SELECT *
      FROM jos_content
      WHERE id = '421'
77. SELECT *
      FROM jos_sections
      WHERE id = '8'
78. SELECT *
      FROM jos_categories
      WHERE id = '53'
79. SELECT *
      FROM jos_content_rating
      WHERE content_id = 421
80. SELECT *
      FROM jos_content
      WHERE id = '421'
81. SELECT *
      FROM jos_sections
      WHERE id = '8'
82. SELECT *
      FROM jos_categories
      WHERE id = '53'
83. SELECT *
      FROM jos_content_rating
      WHERE content_id = 421
84. SELECT *
      FROM jos_content
      WHERE id = '420'
85. SELECT *
      FROM jos_sections
      WHERE id = '8'
86. SELECT *
      FROM jos_categories
      WHERE id = '55'
87. SELECT *
      FROM jos_content_rating
      WHERE content_id = 420
88. SELECT *
      FROM jos_content
      WHERE id = '420'
89. SELECT *
      FROM jos_sections
      WHERE id = '8'
90. SELECT *
      FROM jos_categories
      WHERE id = '55'
91. SELECT *
      FROM jos_content_rating
      WHERE content_id = 420
92. SELECT *
      FROM jos_content
      WHERE id = '419'
93. SELECT *
      FROM jos_sections
      WHERE id = '8'
94. SELECT *
      FROM jos_categories
      WHERE id = '53'
95. SELECT *
      FROM jos_content_rating
      WHERE content_id = 419
96. SELECT *
      FROM jos_content
      WHERE id = '419'
97. SELECT *
      FROM jos_sections
      WHERE id = '8'
98. SELECT *
      FROM jos_categories
      WHERE id = '53'
99. SELECT *
      FROM jos_content_rating
      WHERE content_id = 419
100. 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
101. 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 <= '2010-03-11 03:32:19' )
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 03:32:19' )
       AND s.id > 0
       AND a.access <= 0
       AND cc.access <= 0
       AND s.access <= 0
       AND (cc.id=54)
       AND (s.id=8)
       AND s.published = 1
       AND cc.published = 1
       ORDER BY a.created DESC
       LIMIT 0, 5
102. SELECT count(a.id) 
       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 <= '2010-03-11 03:32:19' )
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 03:32:19' )
       AND s.id > 0
       AND a.access <= 0
       AND cc.access <= 0
       AND s.access <= 0
       AND (cc.id=54)
       AND (s.id=8)
       AND s.published = 1
       AND cc.published = 1
103. 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 ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-10 19:32:20' )
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-10 19:32:20' )
       AND s.id > 0
       AND a.access <= 0
       AND cc.access <= 0
       AND s.access <= 0
       AND (cc.id=58)
       AND (s.id=8)
       AND f.content_id IS NULL 
       AND s.published = 1
       AND cc.published = 1
       ORDER BY a.created DESC
       LIMIT 0, 20

Language Files Loaded

• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.com_content.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.plg_content_pagebreak.ini 1
• administrator/language/en-GB/en-GB.plg_content_jw_superblogger.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.tpl_rt_refraction_j15.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.mod_roknavmenu.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.mod_rokajaxsearch.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.mod_roktwittie.ini 1
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.mod_roknewspager.ini
• /home/m_hirsch/cf215.qrown.com/language/en-GB/en-GB.mod_roknewsflash.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None