baner3 baner4 baner5 baner6 b7 b8 b9 b10
No events

About us

The Forum of Dialogue and Partnership for Development is an civil developmental Foundation, not meant for profit and neutral but positively as an institution. Work in diversity, pluralism and accoptance of others and interact with him supporting to human rights, citizenship and work to bring about institutional changes needed to establish dialogue and participation for the Development of Egyptian society to overcome the absence of dialogue and the weaknesses of participation mechanisms.

read more »

Follow us on

   

Address: 11 El-Tobgy Street - Dokki - Giza : Fax: +202 333 728 92 : Tel: +202 374 829 23 : E-mail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it. / This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

Profile Information

Application 0.001 seconds (+0.001); 0.35 MB (+0.352) - afterLoad
Application 0.122 seconds (+0.122); 2.21 MB (+1.862) - afterInitialise
Application 0.138 seconds (+0.016); 2.71 MB (+0.497) - afterRoute
Application 0.230 seconds (+0.092); 3.92 MB (+1.206) - afterDispatch
Application 0.247 seconds (+0.016); 4.03 MB (+0.116) - beforeRenderModule mod_custom (English Footer Links and Copyright)
Application 0.256 seconds (+0.009); 4.05 MB (+0.017) - afterRenderModule mod_custom (English Footer Links and Copyright)
Application 0.256 seconds (+0.000); 4.05 MB (-0.001) - beforeRenderModule mod_custom (English Contact Info)
Application 0.263 seconds (+0.007); 4.06 MB (+0.013) - afterRenderModule mod_custom (English Contact Info)
Application 0.263 seconds (+0.000); 4.06 MB (-0.000) - beforeRenderModule mod_custom (English Follow Us)
Application 0.267 seconds (+0.003); 4.07 MB (+0.003) - afterRenderModule mod_custom (English Follow Us)
Application 0.267 seconds (+0.000); 4.06 MB (-0.002) - beforeRenderModule mod_custom (English Intro Home Text)
Application 0.270 seconds (+0.003); 4.07 MB (+0.003) - afterRenderModule mod_custom (English Intro Home Text)
Application 0.271 seconds (+0.000); 4.07 MB (-0.001) - beforeRenderModule mod_articles_latest (Latest News)
Application 0.303 seconds (+0.033); 4.28 MB (+0.219) - afterRenderModule mod_articles_latest (Latest News)
Application 0.304 seconds (+0.000); 4.22 MB (-0.064) - beforeRenderModule mod_jevents_latest (English Latest Events)
Application 0.422 seconds (+0.118); 5.56 MB (+1.344) - afterRenderModule mod_jevents_latest (English Latest Events)
Application 0.422 seconds (+0.000); 5.56 MB (-0.006) - beforeRenderModule mod_phocagallery_slideshow_nivo (Home Banner)
Application 0.440 seconds (+0.018); 5.69 MB (+0.131) - afterRenderModule mod_phocagallery_slideshow_nivo (Home Banner)
Application 0.440 seconds (+0.000); 5.68 MB (-0.009) - beforeRenderModule mod_exmenu (English Home Banner Links)
Application 0.507 seconds (+0.067); 6.54 MB (+0.860) - afterRenderModule mod_exmenu (English Home Banner Links)
Application 0.507 seconds (+0.000); 6.53 MB (-0.005) - beforeRenderModule mod_exmenu (English Left Menu)
Application 0.524 seconds (+0.017); 6.59 MB (+0.055) - afterRenderModule mod_exmenu (English Left Menu)
Application 0.525 seconds (+0.000); 6.58 MB (-0.005) - beforeRenderModule mod_exmenu (English Top Tabs)
Application 0.541 seconds (+0.017); 6.64 MB (+0.058) - afterRenderModule mod_exmenu (English Top Tabs)
Application 0.542 seconds (+0.000); 6.64 MB (-0.006) - beforeRenderModule mod_exmenu (English Menu)
Application 0.603 seconds (+0.062); 6.80 MB (+0.166) - afterRenderModule mod_exmenu (English Menu)
Application 0.603 seconds (+0.000); 6.80 MB (-0.006) - beforeRenderModule mod_languages (lang)
Application 0.625 seconds (+0.022); 6.88 MB (+0.088) - afterRenderModule mod_languages (lang)
Application 0.631 seconds (+0.005); 6.91 MB (+0.029) - afterRender

Memory Usage

6.91 MB (7,248,720 Bytes)

38 Queries Logged

  1. SELECT `data`
      FROM `xnygc_session`
      WHERE `session_id` = 'gt3aqs0cjr3mnuh831ud27jcl7'
  2. DELETE
      FROM `xnygc_session`
      WHERE `time` < 1685756585
  3. SELECT `session_id`
      FROM `xnygc_session`
      WHERE `session_id` = 'gt3aqs0cjr3mnuh831ud27jcl7'
      LIMIT 0, 1
  4. INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`)
      VALUES ('gt3aqs0cjr3mnuh831ud27jcl7', 0, 1685757485)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `xnygc_viewlevels`
  7. SELECT folder AS type, element AS name, params
      FROM xnygc_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  8. SELECT *
      FROM xnygc_languages
      WHERE published=1
      ORDER BY ordering ASC
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  10. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM xnygc_menu AS m
      LEFT JOIN xnygc_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  11. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  12. SELECT id, home, template, s.params
      FROM xnygc_template_styles as s
      LEFT JOIN xnygc_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 xnygc_assets AS a
      WHERE a.id = 1
  14. SELECT b.rules
      FROM xnygc_assets AS a
      LEFT JOIN xnygc_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 xnygc_content AS a
      LEFT JOIN xnygc_categories AS c
      on c.id = a.catid
      LEFT JOIN xnygc_users AS u
      on u.id = a.created_by
      LEFT JOIN xnygc_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN xnygc_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN xnygc_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_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 <= '2023-06-03 01:58:06')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-03 01:58:06')
      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 xnygc_categories as c
      LEFT JOIN xnygc_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 xnygc_categories AS cat JOIN xnygc_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
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  17. UPDATE xnygc_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 xnygc_modules AS m
      LEFT JOIN xnygc_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN xnygc_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 <= '2023-06-03 01:58:06')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-03 01:58:06')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 102 OR mm.menuid <= 0)
      AND m.language IN ('en-GB','*')
      ORDER BY m.position, m.ordering
  19. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,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 xnygc_content AS a
      LEFT JOIN xnygc_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN xnygc_categories AS c
      ON c.id = a.catid
      LEFT JOIN xnygc_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN xnygc_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN xnygc_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN xnygc_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN xnygc_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_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 (32)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-03 01:58:06')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-03 01:58:06')
      AND a.language in ('en-GB','*')
      AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
      GROUP BY a.id
      ORDER BY a.publish_up DESC
      LIMIT 0, 3
  20. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM xnygc_categories as c
      LEFT JOIN xnygc_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 xnygc_categories AS cat JOIN xnygc_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=32
      AND badcats.id is null
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  21. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_jevents'
  22. SHOW FULL COLUMNS
      FROM `xnygc_jev_users`
  23. SELECT b.rules
      FROM xnygc_assets AS a
      LEFT JOIN xnygc_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_jevents'
      ORDER BY b.lft
  24. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM xnygc_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_jevents'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_jevents' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND badcats.id is null
      AND (c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  25. SELECT c.id
      FROM xnygc_categories AS c
      WHERE c.access IN (1,1)
      AND c.published = 1
      AND c.language in ('en-GB','*')
      AND c.extension = 'com_jevents'
      AND ((c.lft>=73
      AND c.rgt<=74 ))
  26. SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , 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 xnygc_jevents_repetition as rpt
      LEFT JOIN xnygc_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      LEFT JOIN xnygc_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      LEFT JOIN xnygc_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN xnygc_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
      WHERE ev.catid IN(-1,37)
      AND rpt.endrepeat >= '2023-06-03 04:58:06'
      AND rpt.startrepeat <= '2023-06-10 23:59:59'
      AND (rpt.startrepeat >= '2023-05-28 00:00:00' OR det.multiday=1)
      AND ev.state=1
      AND ev.access IN (1,1)
      AND icsf.state=1
      AND icsf.access IN (1,1)
      AND rpt.startrepeat=( SELECT MIN(startrepeat)
      FROM xnygc_jevents_repetition as rpt2
      WHERE rpt2.eventid=rpt.eventid
      AND ( (rpt2.startrepeat >= '2023-06-03 04:58:06'
      AND rpt2.startrepeat <= '2023-06-10 23:59:59') OR (rpt2.startrepeat <= '2023-06-03 04:58:06'
      AND rpt2.endrepeat > '2023-06-03 04:58:06'
      AND det.multiday=1) ) )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  27. SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , 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 xnygc_jevents_repetition as rpt
      LEFT JOIN xnygc_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      LEFT JOIN xnygc_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      LEFT JOIN xnygc_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN xnygc_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
      WHERE ev.catid IN(-1,37)
      AND rpt.endrepeat >= '2023-05-28 00:00:00'
      AND rpt.startrepeat <= '2023-06-03 04:58:06'
      AND (rpt.startrepeat >= '2023-05-28 00:00:00' OR det.multiday=1)
      AND ev.state=1
      AND ev.access IN (1,1)
      AND icsf.state=1
      AND icsf.access IN (1,1)
      AND rpt.startrepeat=( SELECT MAX(startrepeat)
      FROM xnygc_jevents_repetition as rpt2
      WHERE rpt2.eventid=rpt.eventid
      AND rpt2.startrepeat <= '2023-06-03 04:58:06'
      AND rpt2.startrepeat >= '2023-05-28 00:00:00' )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat desc
      LIMIT 5
  28. SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , 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 xnygc_jevents_repetition as rpt
      LEFT JOIN xnygc_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      LEFT JOIN xnygc_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      LEFT JOIN xnygc_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN xnygc_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
      WHERE ev.catid IN(-1,37)
      AND rpt.endrepeat >= '2023-05-28 00:00:00'
      AND rpt.startrepeat <= '2023-06-03 04:58:06'
      AND (rpt.startrepeat <= '2023-05-28 00:00:00'OR det.multiday=1)
      AND ev.state=1
      AND ev.access IN (1,1)
      AND icsf.state=1
      AND icsf.access IN (1,1)
      AND rpt.startrepeat <= '2023-06-03 04:58:06'
      AND rpt.endrepeat >= '2023-06-03 04:58:06'
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  29. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_phocagallery'
  30. SELECT a.id, a.title, a.description, a.filename, a.extl
      FROM xnygc_phocagallery_categories AS cc
      LEFT JOIN xnygc_phocagallery AS a
      ON a.catid = cc.id
      WHERE a.published = 1
      AND a.catid = 1
      ORDER BY a.ordering
      LIMIT 100
  31. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  32. SELECT catid
      FROM xnygc_content
      WHERE id = 1
  33. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='homeleftmenu-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  34. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='toptabs-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  35. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  36. SELECT id,language
      FROM `xnygc_menu`
      WHERE home=1
  37. SELECT m2.language, m2.id
      FROM xnygc_menu as m
      LEFT JOIN xnygc_associations as a
      ON a.id=m.id
      AND a.context='com_menus.item'
      LEFT JOIN xnygc_associations as a2
      ON a.key=a2.key
      LEFT JOIN xnygc_menu as m2
      ON a2.id=m2.id
      WHERE m.id=102
  38. UPDATE `xnygc_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685757485;s:18:\"session.timer.last\";i:1685757485;s:17:\"session.timer.now\";i:1685757485;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://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;}}', `time` = 1685757486
      WHERE `session_id` = 'gt3aqs0cjr3mnuh831ud27jcl7'

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 5 × SELECT extension_id AS "id", element AS "option", params, enabled FROM xnygc_extensions
  2. 4 × SELECT m.* FROM xnygc_menu AS m
  3. 3 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , 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 xnygc_jevents_repetition as rpt LEFT JOIN xnygc_jevents_vevent as ev ON rpt.eventid = ev.ev_id LEFT JOIN xnygc_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid LEFT JOIN xnygc_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN xnygc_jevents_rrule as rr ON rr.eventid = rpt.eventid
  4. 2 × SELECT b.rules FROM xnygc_assets AS a LEFT JOIN xnygc_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  5. 2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM xnygc_categories as c LEFT JOIN xnygc_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 xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  6. 1 × SELECT c.id FROM xnygc_categories AS c
  7. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM xnygc_categories as c LEFT JOIN (SELECT cat.id as id FROM xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  8. 1 × SELECT a.id, a.title, a.description, a.filename, a.extl FROM xnygc_phocagallery_categories AS cc LEFT JOIN xnygc_phocagallery AS a ON a.catid = cc.id
  9. 1 × SELECT id,language FROM `xnygc_menu`
  10. 1 × SELECT catid FROM xnygc_content
  11. 1 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,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 xnygc_content AS a LEFT JOIN xnygc_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN xnygc_categories AS c ON c.id = a.catid LEFT JOIN xnygc_users AS ua ON ua.id = a.created_by LEFT JOIN xnygc_users AS uam ON uam.id = a.modified_by LEFT JOIN xnygc_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN xnygc_categories as parent ON parent.id = c.parent_id LEFT JOIN xnygc_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  12. 1 × SELECT m2.language, m2.id FROM xnygc_menu as m LEFT JOIN xnygc_associations as a ON a.id=m.id AND a.context='com_menus.item' LEFT JOIN xnygc_associations as a2 ON a.key=a2.key LEFT JOIN xnygc_menu as m2 ON a2.id=m2.id
  13. 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 xnygc_content AS a LEFT JOIN xnygc_categories AS c on c.id = a.catid LEFT JOIN xnygc_users AS u on u.id = a.created_by LEFT JOIN xnygc_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN xnygc_categories as parent ON parent.id = c.parent_id LEFT JOIN xnygc_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  14. 1 × SELECT folder AS type, element AS name, params FROM xnygc_extensions
  15. 1 × SELECT id, rules FROM `xnygc_viewlevels
  16. 1 × SELECT `session_id` FROM `xnygc_session`
  17. 1 × SELECT * FROM xnygc_languages
  18. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM xnygc_menu AS m LEFT JOIN xnygc_extensions AS e ON m.component_id = e.extension_id
  19. 1 × SELECT `data` FROM `xnygc_session`
  20. 1 × SELECT a.rules FROM xnygc_assets AS a
  21. 1 × SELECT id, home, template, s.params FROM xnygc_template_styles as s LEFT JOIN xnygc_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  22. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM xnygc_modules AS m LEFT JOIN xnygc_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN xnygc_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
OTHER Tables:
  1. 1 × UPDATE `xnygc_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685757485;s:18:\"session.timer.last\";i:1685757485;s:17:\"session.timer.now\";i:1685757485;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://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;}}', `time` = 1685757486
  2. 1 × SHOW FULL COLUMNS FROM `xnygc_jev_users
  3. 1 × UPDATE xnygc_content SET hits = hits + 1
  4. 1 × INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`) VALUES ('gt3aqs0cjr3mnuh831ud27jcl7', 0, 1685757485
  5. 1 × DELETE FROM `xnygc_session`