RAPPEL changements  2015

  • Mise en place d'une allocation de rentrée scolaire pour les étudiants en alternance
  • Cumul possible des colonies de vacances pour les enfants reconnus handicapés
  • Suppression de la notion de rétroactivité pour les allocations nourrice et logement
  • Mise en place de chèques CESU pour une aide ménagère aux retraités à partir de 80 ans

PERMANENCES SUR SITES


 

 

 

 

 




FLASHINFOS

  • 1
  • 2
  • 3

Prochaines Commissions d'Entraide :

- Mardi 20/09/2016 à 14h

- Jeudi 17/11/2016 à 14h






Catalogues colonies HIVER et PRINTEMPS 2017 disponibles !!!

ALLASSO :

Une Mutuelle aux prestations diversifiées

Allasso s’attache à répondre aux attentes de ses membres quelles que soient leurs situations personnelles, familiales et professionnelles.

La Mutuelle Allasso est présente à tous les moments de la vie : prime de mariage ou de pacs, prime de naissance, allocation d’obsèques ;

La Mutuelle Allasso vous accompagne au quotidien : prêts à taux zéro, allocation logement, aide à domicile, CESU cofinancé assistance dépannage et petits travaux ;

La Mutuelle Allasso contribue à l’épanouissement de vos enfants :
  • avant leur scolarité : allocation nourrice,
  • dans leur scolarité : allocation de rentrée scolaire et universitaire, garde d'enfant et
     sortie d'école, soutien scolaire, classes transplantées, séjours linguistiques,
     bonification de prêt,
  • dans leurs vacances : colonies de vacances, séjours en France et à l’étranger,
  • dans leurs loisirs : centres aérés, allocation d’activités sportives et culturelles ;

La Mutuelle Allasso soutient les personnes en difficulté : fonds d’entraide accordant prêts et prestations spécifiques, assistance juridique par des avocats spécialisés, CESU cofinancés pour une aide ménagère en cas d’accident de la vie, d’affectation longue durée, d’invalidité, de handicap — CESU cofinancés pour la garde d’enfant malade, aide à la garde d’une personne dépendante ;

La Mutuelle Allasso encourage la prévention : "prévention santé" ;

La Mutuelle Allasso agit en faveur du lien social :
  • avec les retraités : allocation en faveur des retraités, "soutien du Club des Anciens",
  • avec les enfants malades : Allasso partenaire de l’association "le Rire Médecin".

Profil d'information

Application 0.001 seconds (+0.001); 0.28 MB (+0.283) - afterLoad
Application 0.069 seconds (+0.068); 3.39 MB (+3.106) - afterInitialise
Application 0.081 seconds (+0.012); 3.69 MB (+0.297) - afterRoute
Application 0.150 seconds (+0.069); 5.93 MB (+2.245) - afterDispatch
Application 0.161 seconds (+0.011); 6.10 MB (+0.169) - beforeRenderModule mod_menu (Footer)
Application 0.169 seconds (+0.007); 6.19 MB (+0.086) - afterRenderModule mod_menu (Footer)
Application 0.169 seconds (+0.000); 6.18 MB (-0.003) - beforeRenderModule mod_menu (Nos prestations)
Application 0.180 seconds (+0.011); 6.20 MB (+0.015) - afterRenderModule mod_menu (Nos prestations)
Application 0.180 seconds (+0.000); 6.20 MB (-0.003) - beforeRenderModule mod_menu (Fonctionnement de la mutuelle)
Application 0.181 seconds (+0.001); 6.20 MB (+0.004) - afterRenderModule mod_menu (Fonctionnement de la mutuelle)
Application 0.181 seconds (+0.000); 6.20 MB (-0.003) - beforeRenderModule mod_custom (Vos interlocuteurs)
Application 0.185 seconds (+0.004); 6.21 MB (+0.011) - afterRenderModule mod_custom (Vos interlocuteurs)
Application 0.186 seconds (+0.000); 6.21 MB (-0.002) - beforeRenderModule mod_custom (Flash infos titre)
Application 0.187 seconds (+0.001); 6.21 MB (+0.003) - afterRenderModule mod_custom (Flash infos titre)
Application 0.188 seconds (+0.001); 6.27 MB (+0.058) - beforeRenderModule mod_news_pro_gk4 (Flashinfos)
Application 0.214 seconds (+0.026); 6.88 MB (+0.617) - afterRenderModule mod_news_pro_gk4 (Flashinfos)
Application 0.214 seconds (+0.000); 6.84 MB (-0.038) - beforeRenderModule mod_custom (Permanences sur site)
Application 0.216 seconds (+0.001); 6.85 MB (+0.003) - afterRenderModule mod_custom (Permanences sur site)
Application 0.216 seconds (+0.000); 6.85 MB (-0.000) - beforeRenderModule mod_articles_news (Nouveautés)
Application 0.230 seconds (+0.014); 7.08 MB (+0.231) - afterRenderModule mod_articles_news (Nouveautés)
Application 0.230 seconds (+0.000); 7.06 MB (-0.020) - beforeRenderModule mod_custom (Bandeau home)
Application 0.232 seconds (+0.001); 7.06 MB (+0.003) - afterRenderModule mod_custom (Bandeau home)
Application 0.232 seconds (+0.000); 7.06 MB (-0.001) - beforeRenderModule mod_menu (Main Menu)
Application 0.247 seconds (+0.015); 7.07 MB (+0.015) - afterRenderModule mod_menu (Main Menu)
Application 0.247 seconds (+0.000); 7.07 MB (-0.003) - beforeRenderModule mod_login (Login)
Application 0.253 seconds (+0.006); 7.10 MB (+0.026) - afterRenderModule mod_login (Login)
Application 0.258 seconds (+0.004); 7.16 MB (+0.059) - afterRender

Occupation de la mémoire

7.17 MB (7,517,724 Bytes)

25 requêtes exécutées

  1. SELECT `data`
      FROM `all_session`
      WHERE `session_id` = '260a59404d049912b48f75a329e719dd'
  2. SELECT `session_id`
      FROM `all_session`
      WHERE `session_id` = '260a59404d049912b48f75a329e719dd'
      LIMIT 0, 1
  3. INSERT INTO `all_session` (`session_id`, `client_id`, `time`)
      VALUES ('260a59404d049912b48f75a329e719dd', 0, 1481456824)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM all_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `all_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM all_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM all_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. select id, title, alias
      from all_jumi
      where published = 1
  9. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
      FROM all_menu AS m
      LEFT JOIN all_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      AND m.access IN (1,1)
      ORDER BY m.lft
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM all_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT *
      FROM all_languages
      WHERE published=1
      ORDER BY ordering ASC
  12. SELECT id, home, template, s.params
      FROM all_template_styles as s
      LEFT JOIN all_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
  13. SELECT a.rules
      FROM all_assets AS a
      WHERE a.id = 1
  14. SELECT b.rules
      FROM all_assets AS a
      LEFT JOIN all_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  15. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM all_content AS a
      LEFT JOIN all_categories AS c
      on c.id = a.catid
      LEFT JOIN all_users AS u
      on u.id = a.created_by
      LEFT JOIN all_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN all_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN all_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM all_categories AS cat JOIN all_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-12-11 11:47:04')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-12-11 11:47:04')
      AND (a.state = 1 OR a.state =2)
  16. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM all_categories as c
      LEFT JOIN all_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM all_categories AS cat JOIN all_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=2
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  17. UPDATE all_content
      SET hits = hits + 1
      WHERE id = 1
  18. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM all_modules AS m
      LEFT JOIN all_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN all_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2016-12-11 11:47:04')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2016-12-11 11:47:04')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  19. SELECT DISTINCT c.id AS CID
      FROM all_categories AS c
      LEFT JOIN all_content AS content
      ON c.id = content.catid
      WHERE ( c.id = 7 )
      AND c.extension = 'com_content'
      AND c.published = 1
  20. SELECT DISTINCT categories.title AS cat, users.name AS author, users.email AS author_email, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS IID, content.hits AS hits, content.access AS access, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as ID, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as CID
      FROM all_content AS content
      LEFT JOIN all_categories AS categories
      ON categories.id = content.catid
      LEFT JOIN all_users AS users
      ON users.id = content.created_by
      LEFT JOIN all_content_frontpage AS frontpage
      ON content.id = frontpage.content_id
      LEFT JOIN all_content_rating AS content_rating
      ON content_rating.content_id = content.id
      WHERE content.state = 1
      AND content.access IN (1,1)
      AND categories.published = 1
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2016-12-11 11:47:04' )
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2016-12-11 11:47:04' )
      AND ( content.catid = 7 )
      ORDER BY content.created DESC
      LIMIT 0,12;
  21. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM all_categories as c
      LEFT JOIN all_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM all_categories AS cat JOIN all_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=7
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  22. SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM all_content AS a
      LEFT JOIN all_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN all_categories AS c
      ON c.id = a.catid
      LEFT JOIN all_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN all_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN all_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN all_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN all_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM all_categories AS cat JOIN all_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (8)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-12-11 11:47:04')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-12-11 11:47:04')
      ORDER BY a.publish_up DESC
      LIMIT 0, 1
  23. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM all_categories as c
      LEFT JOIN all_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM all_categories AS cat JOIN all_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=8
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  24. select id, title, alias
      from all_jumi
      where published = 1
  25. UPDATE `all_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1481456824;s:18:\"session.timer.last\";i:1481456824;s:17:\"session.timer.now\";i:1481456824;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ca989df5f3f34db07b59e79c619748a9\";}', `time` = 1481456824
      WHERE `session_id` = '260a59404d049912b48f75a329e719dd'

20 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :
  1. 3 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM all_categories as c LEFT JOIN all_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM all_categories AS cat JOIN all_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  2. 3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM all_extensions
  3. 2 × select id, title, alias from all_jumi
  4. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM all_modules AS m LEFT JOIN all_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN all_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  5. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM all_content AS a LEFT JOIN all_categories AS c on c.id = a.catid LEFT JOIN all_users AS u on u.id = a.created_by LEFT JOIN all_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN all_categories as parent ON parent.id = c.parent_id LEFT JOIN all_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM all_categories AS cat JOIN all_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  6. 1 × SELECT DISTINCT c.id AS CID FROM all_categories AS c LEFT JOIN all_content AS content ON c.id = content.catid
  7. 1 × SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM all_content AS a LEFT JOIN all_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN all_categories AS c ON c.id = a.catid LEFT JOIN all_users AS ua ON ua.id = a.created_by LEFT JOIN all_users AS uam ON uam.id = a.modified_by LEFT JOIN all_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN all_categories as parent ON parent.id = c.parent_id LEFT JOIN all_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM all_categories AS cat JOIN all_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  8. 1 × SELECT DISTINCT categories.title AS cat, users.name AS author, users.email AS author_email, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS IID, content.hits AS hits, content.access AS access, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as ID, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as CID FROM all_content AS content LEFT JOIN all_categories AS categories ON categories.id = content.catid LEFT JOIN all_users AS users ON users.id = content.created_by LEFT JOIN all_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN all_content_rating AS content_rating ON content_rating.content_id = content.id
  9. 1 × SELECT b.rules FROM all_assets AS a LEFT JOIN all_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  10. 1 × SELECT id, home, template, s.params FROM all_template_styles as s LEFT JOIN all_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  11. 1 × SELECT id, rules FROM `all_viewlevels
  12. 1 × SELECT `session_id` FROM `all_session`
  13. 1 × SELECT folder AS type, element AS name, params FROM all_extensions
  14. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM all_menu AS m LEFT JOIN all_extensions AS e ON m.component_id = e.extension_id
  15. 1 × SELECT `data` FROM `all_session`
  16. 1 × SELECT * FROM all_languages
  17. 1 × SELECT a.rules FROM all_assets AS a
Autres tables :
  1. 1 × UPDATE `all_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1481456824;s:18:\"session.timer.last\";i:1481456824;s:17:\"session.timer.now\";i:1481456824;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ca989df5f3f34db07b59e79c619748a9\";}', `time` = 1481456824
  2. 1 × UPDATE all_content SET hits = hits + 1
  3. 1 × INSERT INTO `all_session` (`session_id`, `client_id`, `time`) VALUES ('260a59404d049912b48f75a329e719dd', 0, 1481456824