ff lache
Idee
Een eenvoudige puzzel om een aantal FTF-zoekers voor een andere cache te plagen die de locatie van deze cache in de week ervoor uitvoerig vergeefs hadden onderzocht. Om deze cache te vinden moesten ze er dus weer naar toe.
Oplossing
Kwestie van tellen.
ha = graden
hi = hele minuten
ho = aantal duizendste minuten (achter de komma dus)
Hoofdletters staan voor 100.
| Joomla! Version | 4.2.3 |
| PHP Version | 7.4.9 |
| Identity | guest |
| Response | 200 |
| Template | cassiopeia |
| Database |
|
| 1 x afterRenderRawModule mod_menu (Hoofdmenu) (16.5MB) (72.59%) | 555.62ms |
| 1 x afterLoad (4.33MB) (8.33%) | 63.77ms |
| 1 x afterInitialise (5.7MB) (6.22%) | 47.60ms |
| 1 x afterRenderComponent com_content (1.33MB) (3.1%) | 23.72ms |
| 1 x afterRoute (5.94MB) (2.43%) | 18.63ms |
| 1 x afterRender (1.13MB) (1.47%) | 11.24ms |
| 1 x beforeRenderComponent com_content (1023.31KB) (0.85%) | 6.48ms |
| 1 x beforeRenderRawModule mod_menu (Hoofdmenu) (1.26MB) (0.66%) | 5.04ms |
| 1 x After Access::preloadPermissions (com_content) (1.92MB) (0.51%) | 3.91ms |
| 1 x Before Access::preloadComponents (all components) (684.27KB) (0.47%) | 3.62ms |
| 1 x beforeRenderModule mod_menu (Hoofdmenu) (19.32KB) (0.36%) | 2.79ms |
| 1 x afterRenderRawModule mod_menu (Top Menu) (40.27KB) (0.29%) | 2.22ms |
| 1 x After Access::preloadComponents (all components) (108.1KB) (0.09%) | 654μs |
| 1 x afterRenderModule mod_menu (Hoofdmenu) (304.74KB) (0.04%) | 344μs |
| 1 x After Access::getAssetRules (id:1609 name:com_content.article.1359) (26.37KB) (0.02%) | 191μs |
| 1 x afterRenderModule mod_menu (Top Menu) (43.3KB) (0.02%) | 180μs |
| 1 x afterDispatch (3.09KB) (0.02%) | 179μs |
| 1 x beforeRenderRawModule mod_menu (Top Menu) (1.05KB) (0.01%) | 104μs |
| 1 x Before Access::getAssetRules (id:1609 name:com_content.article.1359) (131.17KB) (0.01%) | 72μs |
| 1 x beforeRenderModule mod_menu (Top Menu) (48B) (0.01%) | 50μs |
| 1 x Before Access::preloadPermissions (com_content) (4.55KB) (0%) | 14μs |
SELECT @@SESSION.sql_mode;59μs1.59KB\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php:293CopySELECT `data`
FROM `mmp_jos_session`
WHERE `session_id` = ?159μs1.61KBParams\libraries\vendor\joomla\session\src\Handler\DatabaseHandler.php:261CopySELECT `session_id`
FROM `mmp_jos_session`
WHERE `session_id` = :session_id LIMIT 1109μs1.61KBParams\libraries\src\Session\MetadataManager.php:187CopyINSERT INTO `mmp_jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)996μs944BParams\libraries\src\Session\MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mmp_jos_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1281μs4.73KB\libraries\src\Component\ComponentHelper.php:393CopySELECT `id`,`rules`
FROM `mmp_jos_viewlevels`123μs1.02KB\libraries\src\Access\Access.php:955CopySELECT `b`.`id`
FROM `mmp_jos_usergroups` AS `a`
LEFT JOIN `mmp_jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest161μs1.64KBParams\libraries\src\Access\Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `mmp_jos_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1)
ORDER BY `ordering`413μs11.52KBParams\libraries\src\Plugin\PluginHelper.php:283CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `mmp_jos_menu` AS `m`
LEFT JOIN `mmp_jos_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`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`8.29ms2.48MBParams\libraries\src\Menu\SiteMenu.php:166CopySELECT *
FROM `mmp_jos_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC162μs2.44KB\libraries\src\Language\LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `mmp_jos_template_styles` AS `s`
LEFT JOIN `mmp_jos_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` = 1212μs1.22KB\administrator\components\com_templates\src\Model\StyleModel.php:771CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `mmp_jos_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39)348μs10.25KBParams\libraries\src\Access\Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `mmp_jos_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.66ms461.8KBParams\libraries\src\Access\Access.php:301CopySHOW FULL COLUMNS FROM `mmp_jos_content`2.45ms10.39KB\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php:584CopyUPDATE mmp_jos_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1359'710μs48B\libraries\src\Table\Table.php:1319CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`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`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `mmp_jos_content` AS `a`
INNER JOIN `mmp_jos_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `mmp_jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `mmp_jos_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `mmp_jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `mmp_jos_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)222μs9.38KBParams\components\com_content\src\Model\ArticleModel.php:215CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `mmp_jos_categories` AS `s`
INNER JOIN `mmp_jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`415μs9.16KBParams\libraries\src\Categories\Categories.php:360CopySELECT `m`.`tag_id`,`t`.*
FROM `mmp_jos_contentitem_tag_map` AS `m`
INNER JOIN `mmp_jos_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1)198μs5.2KBParams\libraries\src\Helper\TagsHelper.php:364CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `mmp_jos_modules` AS `m`
LEFT JOIN `mmp_jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `mmp_jos_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`363μs2.52KBParams\libraries\src\Cache\Controller\CallbackController.php:52CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `mmp_jos_scheduler_tasks` AS `a`
LEFT JOIN `mmp_jos_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc208μs4.45KBParams\administrator\components\com_scheduler\src\Model\TasksModel.php:391CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `mmp_jos_scheduler_tasks` AS `a`
LEFT JOIN `mmp_jos_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc196μs4.43KBParams\administrator\components\com_scheduler\src\Model\TasksModel.php:391Copy