| 1 | db | 0.15 ms | SELECT `battle_pass`.`id`, `battle_pass`.`end_date` FROM `battle_pass` WHERE `battle_pass`.`end_date` >= NOW() ORDER BY `battle_pass`.`end_date` ASC LIMIT :APL0 {"APL0":1} app/controllers/CommonController.php:153 Model::findFirstapp/controllers/public/BaseController.php:113 CommonController->initialize app/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 2 | db | 0.11 ms | SELECT `battle_pass`.`id`, `battle_pass`.`end_date` FROM `battle_pass` WHERE `battle_pass`.`end_date` >= NOW() ORDER BY `battle_pass`.`end_date` ASC LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:528 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 3 | db | 0.06 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE (`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17' OR `events`.`date3` >= :currentDate) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 3 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:554 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 4 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE (`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17' OR `events`.`date3` >= :currentDate) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 4 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:579 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 5 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE (`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17' OR `events`.`date3` >= :currentDate) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 5 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:597 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 6 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE ((`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17') OR (`events`.`date3` >= :currentDate)) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 7 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:615 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 7 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE ((`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17') OR (`events`.`date3` >= :currentDate)) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 8 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:634 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 8 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE ((`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17') OR (`events`.`date3` >= :currentDate)) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 9 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:653 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 9 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE ((`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17') OR (`events`.`date3` >= :currentDate)) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 10 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:669 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 10 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE ((`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17') OR (`events`.`date3` >= :currentDate)) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 11 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:696 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 11 | db | 0.05 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE ((`events`.`date3` IS NULL AND `events`.`date2` >= '2026-06-05 23:06:17') OR (`events`.`date3` >= :currentDate)) AND `events`.`date1` <= :currentDate AND `events`.`event_id` = 13 LIMIT 1 {"currentDate":"2026-06-05 23:06:17","APL0":1} app/controllers/public/BaseController.php:714 Model::findFirstapp/controllers/public/IndexController.php:50 BaseController->initialize public/public.php:47 Application->handle |
| 12 | db | 0.17 ms | SELECT `events`.`id`, `events`.`event_id`, `events`.`name`, `events`.`value1`, `events`.`value2`, `events`.`value3`, `events`.`date1`, `events`.`date2`, `events`.`date3`, `events`.`data1`, `events`.`created_at`, `events`.`media_id`, `events`.`media2_id` FROM `events` WHERE `events`.`date1` <= '2026-06-05 23:06:17' AND (`events`.`date3` >= :currentDate OR `events`.`date3` IS NULL) AND `events`.`event_id` = 14 LIMIT 1 {"status":1} app/controllers/public/IndexController.php:143 Model::findpublic/public.php:47 Application->handle |
| 13 | db | 0.05 ms | SELECT `landing_page`.`id`, `landing_page`.`hits`, `landing_page`.`conversions`, `landing_page`.`status` FROM `landing_page` WHERE `landing_page`.`status` = 1 ORDER BY `landing_page`.`id` DESC {"status":1} app/controllers/public/IndexController.php:151 Model::countpublic/public.php:47 Application->handle |
| 14 | db | 1.58 ms | SELECT COUNT(*) AS `rowcount` FROM `landing_page` WHERE `landing_page`.`status` = 1 AND `landing_page`.`hits` < 10000 app/models/LandingPage.php:55 AbstractPdo->queryapp/controllers/public/IndexController.php:210 LandingPage->addHits public/public.php:47 Application->handle |
| 15 | db | 0.08 ms | UPDATE landing_page SET hits = hits + 1 WHERE id = 5 {"APL0":5} app/models/AbstractCacheable.php:36 Model::findapp/controllers/public/IndexController.php:217 AbstractCacheable::find public/public.php:47 Application->handle |
| 16 | db | 0.13 ms | SELECT `countries`.`id`, `countries`.`name`, `countries`.`iso`, `countries`.`media_id`, `countries`.`currency_id`, `countries`.`storage`, `countries`.`available`, `countries`.`allowed_to_build`, `countries`.`color` FROM `countries` LIMIT 5x2 {"APL0":5} app/controllers/public/IndexController.php:236 Model::findpublic/public.php:47 Application->handle |
| 17 | db | 0.19 ms | SELECT `accounts`.`id`, `accounts`.`username`, `accounts`.`password`, `accounts`.`password_reset_token`, `accounts`.`email`, `accounts`.`pending_email`, `accounts`.`email_change_token`, `accounts`.`email_change_token_expires`, `accounts`.`phone`, `accounts`.`language`, `accounts`.`media_id`, `accounts`.`level`, `accounts`.`exp`, `accounts`.`health`, `accounts`.`cash`, `accounts`.`piggy_bank`, `accounts`.`food_limit`, `accounts`.`gift_limit`, `accounts`.`military_skill`, `accounts`.`region_id`, `accounts`.`nationality_id`, `accounts`.`blog_id`, `accounts`.`squad_id`, `accounts`.`last_squad_change_at`, `accounts`.`business_id`, `accounts`.`business_wage`, `accounts`.`business_wage_currency_id`, `accounts`.`business_joined_at`, `accounts`.`economic_skill`, `accounts`.`storage`, `accounts`.`biography`, `accounts`.`status`, `accounts`.`last_login`, `accounts`.`creation_date`, `accounts`.`skipped_phone_validation`, `accounts`.`phone_code`, `accounts`.`phone_validated`, `accounts`.`already_gave_referal_bonus`, `accounts`.`facebook_id`, `accounts`.`dark_mode_status`, `accounts`.`audio_status`, `accounts`.`show_war_emoticons`, `accounts`.`guides_status`, `accounts`.`map_light_mode_status`, `accounts`.`chat_audio_status`, `accounts`.`profile_banner_id`, `accounts`.`profile_background_id`, `accounts`.`avatar_border_id`, `accounts`.`build_presets_limit`, `accounts`.`page_background_id`, `accounts`.`trust_factor`, `accounts`.`antibot_valid_until`, `accounts`.`antibot_valid_level`, `accounts`.`total_damage`, `accounts`.`total_builder_progress`, `accounts`.`total_mined_gold`, `accounts`.`deleted`, `accounts`.`bonus_military_rank_progression`, `accounts`.`bonus_builder_rank_progression`, `accounts`.`referral_preference`, `accounts`.`next_mining_region_id`, `accounts`.`utm_campaign`, `accounts`.`utm_source`, `accounts`.`utm_medium`, `accounts`.`utm_term`, `accounts`.`utm_content`, `accounts`.`tutorial_step`, `accounts`.`legacy_mobile_layout`, `accounts`.`disable_campaigns_view`, `accounts`.`main_id` FROM `accounts` LIMIT 5x2 {"APL0":5} app/controllers/public/IndexController.php:254 Model::findpublic/public.php:47 Application->handle |