Work Package 2.2 Leader: UNI Fribourg

This work package will produce algorithms that can support the formation of cooperative and efficient social structures.

Deliverables : D2.2.1

 
 
 

Profile Information

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.029 seconds, 0.99 MB
Application afterRoute: 0.031 seconds, 1.44 MB
Application afterDispatch: 0.047 seconds, 2.27 MB
Application afterRender: 0.078 seconds, 2.99 MB

Memory Usage

3168816

15 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'qovdoioqaruhvojhhetd4vaom3'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1435973007' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'qovdoioqaruhvojhhetd4vaom3'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'qovdoioqaruhvojhhetd4vaom3','1435973907','','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 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 template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. 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 
      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
      WHERE a.id = 19
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-04 01:38:27' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-04 01:38:27' )   )    OR  ( a.state = -1 )  )
  10. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='19'
  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 = 8 OR mm.menuid = 0 )
      ORDER BY position, ordering
  12. SELECT c.id
     
      FROM jos_categories AS c
      LEFT JOIN jos_categories AS p
      ON p.id=c.parent_id
      LEFT JOIN jos_categories AS gp
      ON gp.id=p.parent_id 
      LEFT JOIN jos_categories AS ggp
      ON ggp.id=gp.parent_id
     
      WHERE c.access <= 0
     
      AND c.published = 1
     
      AND c.section = 'com_jevents'
  13. SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published
     , YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
     , YEAR(rpt.endrepeat  ) AS ydn, MONTH(rpt.endrepeat   ) AS mdn, DAYOFMONTH(rpt.endrepeat   ) AS ddn
     , HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
     , HOUR(rpt.endrepeat  ) AS hdn, MINUTE(rpt.endrepeat   ) AS mindn, SECOND(rpt.endrepeat   ) AS sdn
     
      FROM jos_jevents_repetition AS rpt
     
      LEFT JOIN jos_jevents_vevent AS ev
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN jos_jevents_icsfile AS icsf
      ON icsf.ics_id=ev.icsid
     
      LEFT JOIN jos_jevents_vevdetail AS det
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN jos_jevents_rrule AS rr
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,6,7,8,9)
     
      AND rpt.endrepeat >= '2015-07-01 00:00:00'
      AND rpt.startrepeat <= '2015-07-31 23:59:59'
      AND ev.state=1
     
      AND ev.access <= 0 
      AND icsf.state=1
      AND icsf.access <= 0
  14. SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published
     , YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
     , YEAR(rpt.endrepeat  ) AS ydn, MONTH(rpt.endrepeat   ) AS mdn, DAYOFMONTH(rpt.endrepeat   ) AS ddn
     , HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
     , HOUR(rpt.endrepeat  ) AS hdn, MINUTE(rpt.endrepeat   ) AS mindn, SECOND(rpt.endrepeat   ) AS sdn
     
      FROM jos_jevents_repetition AS rpt
     
      LEFT JOIN jos_jevents_vevent AS ev
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN jos_jevents_icsfile AS icsf
      ON icsf.ics_id=ev.icsid
     
      LEFT JOIN jos_jevents_vevdetail AS det
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN jos_jevents_rrule AS rr
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,6,7,8,9)
     
      AND rpt.endrepeat >= '2014-07-04'
      AND rpt.startrepeat <= '2016-07-03'
      AND ev.state=1
     
      AND ev.access <= 0 
      AND icsf.state=1
      AND icsf.access <= 0
  15. SELECT  cat.id, cat.title AS name, cat.description, cat.access, evcat.color, cat.parent_id
     
      FROM jos_jevents_categories AS evcat
     
      LEFT JOIN jos_categories AS cat
      ON evcat.id = cat.id
     
      WHERE cat.section = 'com_jevents'
     
      AND cat.access <= 0
     
      AND cat.published = 1
      ORDER BY cat.parent_id, cat.ordering ASC

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None