BETA

Milí stávající či potenciální OI Klubáci,

  • OI Klub je neformální organizace, která vznikla v září roku 2010,
  • členem OI Klubu se může stát (zdarma) každý student, učitel a příznivce programu OI – stačí se zaregistrovat (viz níže),
  • cílem Klubu je organizovat rozmanité akce, které napomohou setkávání a poznávání se lidem v rámci OI komunity i na jiné než akademické půdě. Zde na webu se akce (obvykle) nejprve proberou s Vámi v diskuzích a na základě Vašich podnětů se poté naplánují a zrealizují,
  • po Vaší registraci napište prosím na email kluboi@fel.cvut.cz a uveďte, zda jste studentem („bakalář“ nebo „magistr“) nebo učitelem, či příznivcem OI. Na základě tohoto emailu budete adminem umístěn/a do jedné ze skupin. Většina akcí je sice určena všem, ale mohou být výjimky, proto toto rozdělování… děkujeme za pochopení!,
  • pakliže chcete skutečně aktivně pomáhat s plánováním akcí (rezervace hotelů/jízdenek atp.), napište nám prosím také na adresu kluboi@fel.cvut.cz,  
  • pokud ještě váháte, zda se připojit, podívejte se na fotky z již proběhlých akcí https://picasaweb.google.com/otevrenainformatika.

Těšíme se na mnoho společných prima zážitků!
Tým OI Klubu

Session | Request | SQL Log | Variables
 

History

Session

Request

Cake Params

$_GET

$_POST

$_FILES

Cookie

Cookie not initialized.

Current Route

SQL Log

(default) 26 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `articles`31311
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `accounts`14141
4SHOW FULL COLUMNS FROM `profiles`881
5SHOW FULL COLUMNS FROM `groups`440
6SHOW FULL COLUMNS FROM `roles`330
7SHOW FULL COLUMNS FROM `permitions`330
8SHOW FULL COLUMNS FROM `passphrases`440
9SHOW FULL COLUMNS FROM `actions`440
10SHOW FULL COLUMNS FROM `comments`991
11SHOW FULL COLUMNS FROM `histories`550
12SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';110
13SHOW FULL COLUMNS FROM `members`330
14SHOW FULL COLUMNS FROM `participants`330
15SHOW FULL COLUMNS FROM `discussions`220
16SHOW FULL COLUMNS FROM `email_histories`771
17SELECT `Role`.`id`, `Role`.`name`, `Role`.`description` FROM `roles` AS `Role` WHERE 1 = 1 43430
18SELECT `Groups`.`id`, `Groups`.`name`, `Groups`.`type`, `Groups`.`created`, `Permition`.`id`, `Permition`.`role_id`, `Permition`.`group_id` FROM `groups` AS `Groups` JOIN `permitions` AS `Permition` ON (`Permition`.`role_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 30, 31, 29, 32, 33, 34, 35, 36, 37, 38, 39, 40, 1000, 1001, 1002) AND `Permition`.`group_id` = `Groups`.`id`) 32320
19SELECT `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `actions` AS `Action` LEFT JOIN `articles` AS `Article` ON (`Action`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND `Action`.`end` >= '2012-05-16 00:00:00' AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Action`.`begin` desc LIMIT 10110
20SELECT `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `actions` AS `Action` LEFT JOIN `articles` AS `Article` ON (`Action`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND `Action`.`end` < '2012-05-16 00:00:00' AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Action`.`begin` desc LIMIT 2222
21SELECT `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `actions` AS `Action` LEFT JOIN `articles` AS `Article` ON (`Action`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Action`.`begin` desc 25252
22SELECT `Discussion`.`id`, `Discussion`.`article_id`, `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author` FROM `discussions` AS `Discussion` LEFT JOIN `articles` AS `Article` ON (`Discussion`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Article`.`created` desc LIMIT 10441
23SELECT `Discussion`.*, `Article`.*, COUNT(`Comment`.id) `comments` FROM `discussions` AS `Discussion` LEFT JOIN `articles` AS `Article` ON (`Discussion`.`article_id` = `Article`.`id`) JOIN `comments` AS `Comment` ON (`Article`.`id` = `Comment`.`article_id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND ((`Article`.`group_id` IS NULL)) AND `Comment`.`created` > '2012-03-17 00:00:00' GROUP BY Discussion.id ORDER BY `comments` DESC LIMIT 10001
24SELECT `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author`, `Account`.`id`, `Account`.`login`, `Account`.`email`, `Account`.`crypted_password`, `Account`.`salt`, `Account`.`password_reset_code`, `Account`.`remember_token`, `Account`.`remember_token_expires`, `Account`.`activation_code`, `Account`.`activated`, `Account`.`state`, `Account`.`deleted`, `Account`.`created`, `Account`.`updated`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS display FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Account`.`id`) AS `Account__display`, `Group`.`id`, `Group`.`name`, `Group`.`type`, `Group`.`created`, `Passphrase`.`id`, `Passphrase`.`used`, `Passphrase`.`value`, `Passphrase`.`tryes`, `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Discussion`.`id`, `Discussion`.`article_id` FROM `articles` AS `Article` LEFT JOIN `accounts` AS `Account` ON (`Article`.`account_id` = `Account`.`id`) LEFT JOIN `groups` AS `Group` ON (`Article`.`group_id` = `Group`.`id`) LEFT JOIN `passphrases` AS `Passphrase` ON (`Article`.`passphrase_id` = `Passphrase`.`id`) LEFT JOIN `actions` AS `Action` ON (`Action`.`article_id` = `Article`.`id`) LEFT JOIN `discussions` AS `Discussion` ON (`Discussion`.`article_id` = `Article`.`id`) WHERE `Article`.`deleted` IS NULL AND `Article`.`published` IS NOT NULL AND `Article`.`in_list` = 1 AND `Article`.`visible` = 1 AND ((`Article`.`group_id` IS NULL) OR (`Article`.`group_id` IS NULL)) ORDER BY `Article`.`created` desc LIMIT 10331
25SELECT `Article`.`id`, `Article`.`title`, `Article`.`intro`, `Article`.`content`, `Article`.`permalink`, `Article`.`markup`, `Article`.`weight`, `Article`.`icon_pdf`, `Article`.`icon_print`, `Article`.`icon_email`, `Article`.`hits`, `Article`.`revised`, `Article`.`frontpage`, `Article`.`layout`, `Article`.`class_suffix`, `Article`.`commented`, `Article`.`guest_comments`, `Article`.`visible`, `Article`.`in_list`, `Article`.`rating_value`, `Article`.`rating_count`, `Article`.`rating_show`, `Article`.`group_id`, `Article`.`account_id`, `Article`.`passphrase_id`, `Article`.`published`, `Article`.`unpublished`, `Article`.`created`, `Article`.`updated`, `Article`.`deleted`, `Article`.`title_show`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Article`.`account_id`) AS `Article__author`, `Account`.`id`, `Account`.`login`, `Account`.`email`, `Account`.`crypted_password`, `Account`.`salt`, `Account`.`password_reset_code`, `Account`.`remember_token`, `Account`.`remember_token_expires`, `Account`.`activation_code`, `Account`.`activated`, `Account`.`state`, `Account`.`deleted`, `Account`.`created`, `Account`.`updated`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS display FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Account`.`id`) AS `Account__display`, `Group`.`id`, `Group`.`name`, `Group`.`type`, `Group`.`created`, `Passphrase`.`id`, `Passphrase`.`used`, `Passphrase`.`value`, `Passphrase`.`tryes`, `Action`.`id`, `Action`.`article_id`, `Action`.`begin`, `Action`.`end`, `Discussion`.`id`, `Discussion`.`article_id` FROM `articles` AS `Article` LEFT JOIN `accounts` AS `Account` ON (`Article`.`account_id` = `Account`.`id`) LEFT JOIN `groups` AS `Group` ON (`Article`.`group_id` = `Group`.`id`) LEFT JOIN `passphrases` AS `Passphrase` ON (`Article`.`passphrase_id` = `Passphrase`.`id`) LEFT JOIN `actions` AS `Action` ON (`Action`.`article_id` = `Article`.`id`) LEFT JOIN `discussions` AS `Discussion` ON (`Discussion`.`article_id` = `Article`.`id`) WHERE `Article`.`frontpage` = 1 LIMIT 1110
26SELECT `Comments`.`id`, `Comments`.`parent_id`, `Comments`.`lft`, `Comments`.`rght`, `Comments`.`article_id`, `Comments`.`account_id`, `Comments`.`message`, `Comments`.`created`, `Comments`.`deleted`, (SELECT COALESCE( CONCAT(`profiles`.`name`,' ',`profiles`.`lastname`), `profiles`.`lastname`, `profiles`.`name`, `accounts`.`login` ) AS author FROM accounts LEFT JOIN profiles ON (`accounts`.`id` = `profiles`.`account_id`) WHERE `accounts`.`id`=`Comments`.`account_id`) AS `Comments__author`, (SELECT count(*) FROM comments WHERE deleted IS NULL AND parent_id=`Comments`.`id`) AS `Comments__children_count` FROM `comments` AS `Comments` WHERE `Comments`.`article_id` = (154) ORDER BY `Comments`.`lft` ASC 000

Timer

Memory

Peak Memory Use 15.52 MB
Message Memory use
Component intitailization 11.29 MB
Controller action start 12.10 MB
Controller render start 12.12 MB

Log

View Variables