Our directory of information about different kinds of fruit.

We love fruit and want the world to know more about all of its many varieties.

Although it is small now, we work on it whenever we have a chance.

All of the images can be found in Wikimedia Commons.

Apples

This encyclopedia is implemented using the contact component, each fruit a separate contact and a category for each letter. A CSS style is used to create the horizontal layout of the alphabet headings.

If you wanted to, you could allow some users (such as your growers) to have access to just this category in the contact component and let them help you to create new content for the encyclopedia.

 

Profile Information

Application 0.001 seconds (+0.001); 0.94 MB (+0.94) - afterLoad
Application 0.081 seconds (+0.080); 5.01 MB (+4.06) - afterInitialise
Application 0.128 seconds (+0.047); 7.60 MB (+2.60) - afterRoute
Application 0.307 seconds (+0.179); 10.53 MB (+2.92) - afterDispatch
Application 0.407 seconds (+0.099); 12.10 MB (+1.57) - afterRender

Memory Usage

12.11 MB (12,697,328 Bytes)

14 Queries Logged

  1. SELECT `data`
      FROM `lor2_session`
      WHERE `session_id` = 'db2702218512da762a4468174642c5c6'
  2. SELECT folder AS type, element AS name, params
      FROM lor2_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  3. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM lor2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  4. 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 lor2_menu AS m
      LEFT JOIN lor2_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
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM lor2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  6. SELECT *
      FROM lor2_languages
      WHERE published=1
      ORDER BY lang_id ASC
  7. SELECT id, home, template, params
      FROM lor2_template_styles
      WHERE client_id = 0
  8. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM lor2_categories as c
      LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_contact'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN `lor2_contact_details` AS i
      ON i.`catid` = c.id
      AND i.published = 1
      WHERE (c.extension='com_contact' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=37
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  9. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM lor2_categories as c
      LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_contact'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_contact' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=38
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  10. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM lor2_categories as c
      LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_contact'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_contact' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=39
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  11. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM lor2_categories as c
      LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_contact'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_contact' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=57
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  12. SELECT id, title, module, position, content, showtitle, params, mm.menuid
      FROM lor2_modules AS m
      LEFT JOIN lor2_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-05-21 02:27:10')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-21 02:27:10')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 427 OR mm.menuid <= 0)
      ORDER BY position, ordering
  13. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM lor2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  14. UPDATE `lor2_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1337567101;s:18:\"session.timer.last\";i:1337567205;s:17:\"session.timer.now\";i:1337567230;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:13:\"session.token\";s:32:\"4237c2c960208ce672e017197a2e77e6\";s:16:\"com_mailto.links\";a:1:{s:40:\"bccf484ce085d0f83b0d0e25c0b0bd0b7d7c461e\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.villalorena.eu/index.php/directions\";s:6:\"expiry\";i:1337567206;}}}', `time` = 1337567230
      WHERE `session_id` = 'db2702218512da762a4468174642c5c6'

10 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 3 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM lor2_categories as c LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_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 lor2_extensions
  3. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM lor2_categories as c LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  4. 1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM lor2_modules AS m LEFT JOIN lor2_modules_menu AS mm ON mm.moduleid = m.id
  5. 1 × SELECT id, home, template, params FROM lor2_template_styles
  6. 1 × SELECT * FROM lor2_languages
  7. 1 × SELECT folder AS type, element AS name, params FROM lor2_extensions
  8. 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 lor2_menu AS m LEFT JOIN lor2_extensions AS e ON m.component_id = e.extension_id
  9. 1 × SELECT `data` FROM `lor2_session`
OTHER Tables:
  1. 1 × UPDATE `lor2_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1337567101;s:18:\"session.timer.last\";i:1337567205;s:17:\"session.timer.now\";i:1337567230;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:13:\"session.token\";s:32:\"4237c2c960208ce672e017197a2e77e6\";s:16:\"com_mailto.links\";a:1:{s:40:\"bccf484ce085d0f83b0d0e25c0b0bd0b7d7c461e\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.villalorena.eu/index.php/directions\";s:6:\"expiry\";i:1337567206;}}}', `time` = 1337567230