Pansion Antonia

Profile Information

Memory Usage

29 Queries Logged

1. SELECT `data`
     FROM `xibe7_session`
     WHERE `session_id` = 'ded217fd8513ff0ecfd01ffa8425df5d'
2. SELECT folder AS type, element AS name, params
     FROM xibe7_extensions
     WHERE enabled >= 1
     AND type ='plugin'
     AND state >= 0
     AND access IN (1,1)
     ORDER BY ordering
3. SELECT *
     FROM xibe7_languages
     WHERE published=1
     ORDER BY ordering ASC
4. SELECT extension_id AS "id", element AS "option", params, enabled
     FROM xibe7_extensions
     WHERE `type` = 'component'
     AND `element` = 'com_languages'
5. 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 xibe7_menu AS m
     LEFT JOIN xibe7_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
6. SELECT extension_id AS "id", element AS "option", params, enabled
     FROM xibe7_extensions
     WHERE `type` = 'component'
     AND `element` = 'com_content'
7. SELECT id, home, template, s.params
     FROM xibe7_template_styles as s
     LEFT JOIN xibe7_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
8. SELECT extension_id AS "id", element AS "option", params, enabled
     FROM xibe7_extensions
     WHERE `type` = 'component'
     AND `element` = 'com_users'
9. SELECT a.rules
     FROM xibe7_assets AS a
     WHERE a.id = 1
10. SELECT b.rules
      FROM xibe7_assets AS a
      LEFT JOIN xibe7_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
11. 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 xibe7_content AS a
      LEFT JOIN xibe7_categories AS c
      on c.id = a.catid
      LEFT JOIN xibe7_users AS u
      on u.id = a.created_by
      LEFT JOIN xibe7_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN xibe7_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN xibe7_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM xibe7_categories AS cat JOIN xibe7_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 = 10
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 22:26:58')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 22:26:58')
      AND (a.state = 1 OR a.state =2)
12. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM xibe7_categories as c
      LEFT JOIN xibe7_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 xibe7_categories AS cat JOIN xibe7_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
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
13. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM xibe7_modules AS m
      LEFT JOIN xibe7_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN xibe7_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 <= '2012-05-20 22:26:58')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-20 22:26:58')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 133 OR mm.menuid <= 0)
      AND m.language IN ('en-GB','*')
      ORDER BY m.position, m.ordering
14. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xibe7_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_phocagallery'
15. 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 xibe7_phocagallery_categories AS cc
      WHERE cc.published = 1
      AND cc.access <= 0
      ORDER BY cc.ordering
16. SELECT cc.id AS idcat, a.id AS idimage
      FROM xibe7_phocagallery_categories AS cc
      LEFT JOIN xibe7_phocagallery AS a
      ON a.catid = cc.id
      WHERE a.published = 1
      AND a.approved = 1
      AND cc.published = 1
      AND cc.id IN (1)
      ORDER BY a.ordering ASC
      LIMIT 0,50
17. SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid, 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 xibe7_phocagallery_categories AS cc
      LEFT JOIN xibe7_phocagallery AS a
      ON a.catid = cc.id
      WHERE a.id in (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27)
      ORDER BY a.ordering ASC
18. UPDATE xibe7_content
      SET hits = hits + 1
      WHERE id = 10
19. SELECT *
      FROM xibe7_jstats_configuration
20. SELECT *
      FROM xibe7_jstats_ipaddresses AS a
      WHERE a.ip = '644592591'
21. SELECT c.*
      FROM xibe7_jstats_clients AS c
      LEFT
      OUTER JOIN xibe7_jstats_visits AS v
      ON c.client_id = v.client_id
      WHERE v.ip = '644592591'
      AND (c.visitor_id = 0 OR c.visitor_id IS NULL);
22. select *
      from `xibe7_jstats_configuration`
      where description like 'ext_%'
      and value = '1'
23. SELECT v.visit_id
      FROM xibe7_jstats_visits as v
      WHERE v.client_id = 514
      AND v.ip = 644592591
      AND v.changed_at >= 1337524018
24. INSERT INTO xibe7_jstats_visits (client_id, joomla_userid, changed_at, ip)
      VALUES ( 514, 0, 1337552818, 644592591 )
25. SELECT page_id, page_title
      FROM xibe7_jstats_pages
      WHERE page = '/index.php'
      LIMIT 1
26. INSERT INTO `xibe7_jstats_impressions` (`page_id`, `visit_id`, `timestamp`)
      VALUES (1,3380,1337552818)
27. SELECT id,language
      FROM `xibe7_menu`
      WHERE home=1
28. 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 xibe7_phocagallery_categories AS cc
      WHERE cc.published = 1
      AND cc.approved = 1
      AND cc.id != 0
      ORDER BY cc.ordering
29. UPDATE `xibe7_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1337552817;s:18:\"session.timer.last\";i:1337552817;s:17:\"session.timer.now\";i:1337552818;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";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:16:\"com_mailto.links\";a:1:{s:40:\"a2f4df4cd815dd45563d6289bbbd48f07a48a57c\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"http://www.pansion-antonia.info/index.php?option=com_content&view=article&id=10:home-en&catid=7&Itemid=133&lang=en\";s:6:\"expiry\";i:1337552818;}}}', `time` = 1337552818
      WHERE `session_id` = 'ded217fd8513ff0ecfd01ffa8425df5d'

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM xibe7_extensions
2. 2 × 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 xibe7_phocagallery_categories AS cc
3. 1 × SELECT * FROM xibe7_jstats_configuratio
4. 1 × SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid, 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 xibe7_phocagallery_categories AS cc LEFT JOIN xibe7_phocagallery AS a ON a.catid = cc.id
5. 1 × SELECT cc.id AS idcat, a.id AS idimage FROM xibe7_phocagallery_categories AS cc LEFT JOIN xibe7_phocagallery AS a ON a.catid = cc.id
6. 1 × SELECT * FROM xibe7_jstats_ipaddresses AS a
7. 1 × select * from `xibe7_jstats_configuration`
8. 1 × SELECT id,language FROM `xibe7_menu`
9. 1 × SELECT page_id, page_title FROM xibe7_jstats_pages
10. 1 × SELECT v.visit_id FROM xibe7_jstats_visits as v
11. 1 × SELECT c.* FROM xibe7_jstats_clients AS c LEFT OUTER JOIN xibe7_jstats_visits AS v ON c.client_id = v.client_id
12. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM xibe7_modules AS m LEFT JOIN xibe7_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN xibe7_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
13. 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 xibe7_menu AS m LEFT JOIN xibe7_extensions AS e ON m.component_id = e.extension_id
14. 1 × SELECT * FROM xibe7_languages
15. 1 × SELECT folder AS type, element AS name, params FROM xibe7_extensions
16. 1 × SELECT id, home, template, s.params FROM xibe7_template_styles as s LEFT JOIN xibe7_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
17. 1 × SELECT a.rules FROM xibe7_assets AS a
18. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM xibe7_categories as c LEFT JOIN xibe7_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 xibe7_categories AS cat JOIN xibe7_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
19. 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 xibe7_content AS a LEFT JOIN xibe7_categories AS c on c.id = a.catid LEFT JOIN xibe7_users AS u on u.id = a.created_by LEFT JOIN xibe7_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN xibe7_categories as parent ON parent.id = c.parent_id LEFT JOIN xibe7_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM xibe7_categories AS cat JOIN xibe7_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
20. 1 × SELECT b.rules FROM xibe7_assets AS a LEFT JOIN xibe7_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
21. 1 × SELECT `data` FROM `xibe7_session`

OTHER Tables:

1. 1 × UPDATE `xibe7_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1337552817;s:18:\"session.timer.last\";i:1337552817;s:17:\"session.timer.now\";i:1337552818;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";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:16:\"com_mailto.links\";a:1:{s:40:\"a2f4df4cd815dd45563d6289bbbd48f07a48a57c\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"http://www.pansion-antonia.info/index.php?option=com_content&view=article&id=10:home-en&catid=7&Itemid=133&lang=en\";s:6:\"expiry\";i:1337552818;}}}', `time` = 1337552818
2. 1 × INSERT INTO `xibe7_jstats_impressions` (`page_id`, `visit_id`, `timestamp`) VALUES (1,3380,1337552818
3. 1 × INSERT INTO xibe7_jstats_visits (client_id, joomla_userid, changed_at, ip) VALUES ( 514, 0, 1337552818, 644592591
4. 1 × UPDATE xibe7_content SET hits = hits + 1