Missing Controller

Error: Article-list.phpsController could not be found.

Error: Create the class Article-list.phpsController below in file: app/controllers/article-list.phps_controller.php

<?php
class Article-list.phpsController extends AppController {

	var $name = 'Article-list.phps';
}
?>

Notice: If you want to customize this error message, create app/views/errors/missing_controller.ctp

Notice (8): Undefined index: State [APP/controllers/states_controller.php, line 64]
top of the page
47 queries took 152 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `settings`999
2DESCRIBE `setting_categories`440
3SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`ORDER` FROM `settings` AS `Setting`   WHERE 1 = 1  1671670
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLESettingALL167100.00
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`setting`.`id` AS `id`,`phonlinemysql`.`setting`.`setting_category_id` AS `setting_category_id`,`phonlinemysql`.`setting`.`name` AS `name`,`phonlinemysql`.`setting`.`value` AS `value`,`phonlinemysql`.`setting`.`description` AS `description`,`phonlinemysql`.`setting`.`type` AS `type`,`phonlinemysql`.`setting`.`options` AS `options`,`phonlinemysql`.`setting`.`label` AS `label`,`phonlinemysql`.`setting`.`ORDER` AS `ORDER` FROM `phonlinemysql`.`settings` `setting` WHERE 1
4DESCRIBE `translations`888
5DESCRIBE `languages`771
6SELECT `Translation`.`key`, `Translation`.`lang_text`, `Language`.`iso2`, `Language`.`id` FROM `translations` AS `Translation` LEFT JOIN `languages` AS `Language` ON (`Translation`.`language_id` = `Language`.`id`)  WHERE 1 = 1  000
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEImpossible WHERE noticed after reading const tables
LevelCodeMessage
Note1003SELECT NULL AS `key`,NULL AS `lang_text`,`phonlinemysql`.`language`.`iso2` AS `iso2`,`phonlinemysql`.`language`.`id` AS `id` FROM `phonlinemysql`.`translations` `translation` LEFT JOIN `phonlinemysql`.`languages` `language` on((`phonlinemysql`.`language`.`id` = NULL)) WHERE 0
7SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'opv9u4lgqb81a6t7qlp23j7fp0'000
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'track|a:6:{s:6:"ip_lat";s:8:"37.45243";s:7:"ip_lang";s:9:"-76.41686";s:7:"ip_city";s:5:"North";s:8:"ip_state";s:8:"Virginia";s:10:"ip_country";s:13:"United States";s:21:"ip_country_short_name";s:2:"US";}layout_page|i:1;country_id|s:1:"2";_Token|s:179:"a:5:{s:3:"key";s:40:"bea56544267712d7883588ae7b209a3833b8cbd8";s:7:"expires";i:1711659882;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
8SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`ORDER` FROM `settings` AS `Setting`   WHERE 1 = 1  1671674
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLESettingALL167100.00
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`setting`.`id` AS `id`,`phonlinemysql`.`setting`.`setting_category_id` AS `setting_category_id`,`phonlinemysql`.`setting`.`name` AS `name`,`phonlinemysql`.`setting`.`value` AS `value`,`phonlinemysql`.`setting`.`description` AS `description`,`phonlinemysql`.`setting`.`type` AS `type`,`phonlinemysql`.`setting`.`options` AS `options`,`phonlinemysql`.`setting`.`label` AS `label`,`phonlinemysql`.`setting`.`ORDER` AS `ORDER` FROM `phonlinemysql`.`settings` `setting` WHERE 1
9SELECT `Translation`.`key`, `Translation`.`lang_text`, `Language`.`iso2`, `Language`.`id` FROM `translations` AS `Translation` LEFT JOIN `languages` AS `Language` ON (`Translation`.`language_id` = `Language`.`id`)  WHERE 1 = 1  0023
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEImpossible WHERE noticed after reading const tables
LevelCodeMessage
Note1003SELECT NULL AS `key`,NULL AS `lang_text`,`phonlinemysql`.`language`.`iso2` AS `iso2`,`phonlinemysql`.`language`.`id` AS `id` FROM `phonlinemysql`.`translations` `translation` LEFT JOIN `phonlinemysql`.`languages` `language` on((`phonlinemysql`.`language`.`id` = NULL)) WHERE 0
10DESCRIBE `countries`551
11DESCRIBE `states`550
12SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'opv9u4lgqb81a6t7qlp23j7fp0'114
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('opv9u4lgqb81a6t7qlp23j7fp0') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
13INSERT INTO `cake_sessions` (`data`,`expires`,`id`,`user_id`) VALUES ('', 1711665880, 'opv9u4lgqb81a6t7qlp23j7fp0', 0)10
14SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'opv9u4lgqb81a6t7qlp23j7fp0'113
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'track|a:6:{s:6:"ip_lat";s:8:"37.45243";s:7:"ip_lang";s:9:"-76.41686";s:7:"ip_city";s:5:"North";s:8:"ip_state";s:8:"Virginia";s:10:"ip_country";s:13:"United States";s:21:"ip_country_short_name";s:2:"US";}layout_page|i:1;country_id|s:1:"2";_Token|s:179:"a:5:{s:3:"key";s:40:"bea56544267712d7883588ae7b209a3833b8cbd8";s:7:"expires";i:1711659882;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
15SELECT `Country`.`id`, `Country`.`name`, `Country`.`slug`, `Country`.`flag`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`flag` = 'US'    LIMIT 1110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryALL21100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`country`.`id` AS `id`,`phonlinemysql`.`country`.`name` AS `name`,`phonlinemysql`.`country`.`slug` AS `slug`,`phonlinemysql`.`country`.`flag` AS `flag`,`phonlinemysql`.`country`.`is_active` AS `is_active` FROM `phonlinemysql`.`countries` `country` WHERE (`phonlinemysql`.`country`.`flag` = 'US') LIMIT 1
16SELECT `Country`.`id`, `Country`.`flag` FROM `countries` AS `Country`   WHERE `Country`.`id` = 2    LIMIT 1110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 2 AS `id`,'US' AS `flag` FROM `phonlinemysql`.`countries` `country` WHERE 1 LIMIT 1
17SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`ORDER` FROM `settings` AS `Setting`   WHERE 1 = 1  16716711
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLESettingALL167100.00
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`setting`.`id` AS `id`,`phonlinemysql`.`setting`.`setting_category_id` AS `setting_category_id`,`phonlinemysql`.`setting`.`name` AS `name`,`phonlinemysql`.`setting`.`value` AS `value`,`phonlinemysql`.`setting`.`description` AS `description`,`phonlinemysql`.`setting`.`type` AS `type`,`phonlinemysql`.`setting`.`options` AS `options`,`phonlinemysql`.`setting`.`label` AS `label`,`phonlinemysql`.`setting`.`ORDER` AS `ORDER` FROM `phonlinemysql`.`settings` `setting` WHERE 1
18SELECT `Translation`.`key`, `Translation`.`lang_text`, `Language`.`iso2`, `Language`.`id` FROM `translations` AS `Translation` LEFT JOIN `languages` AS `Language` ON (`Translation`.`language_id` = `Language`.`id`)  WHERE 1 = 1  000
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEImpossible WHERE noticed after reading const tables
LevelCodeMessage
Note1003SELECT NULL AS `key`,NULL AS `lang_text`,`phonlinemysql`.`language`.`iso2` AS `iso2`,`phonlinemysql`.`language`.`id` AS `id` FROM `phonlinemysql`.`translations` `translation` LEFT JOIN `phonlinemysql`.`languages` `language` on((`phonlinemysql`.`language`.`id` = NULL)) WHERE 0
19DESCRIBE `attachments`13135
20SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'opv9u4lgqb81a6t7qlp23j7fp0'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('opv9u4lgqb81a6t7qlp23j7fp0') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
21UPDATE `cake_sessions` SET `data` = 'track|a:6:{s:6:\"ip_lat\";s:8:\"37.45243\";s:7:\"ip_lang\";s:9:\"-76.41686\";s:7:\"ip_city\";s:5:\"North\";s:8:\"ip_state\";s:8:\"Virginia\";s:10:\"ip_country\";s:13:\"United States\";s:21:\"ip_country_short_name\";s:2:\"US\";}layout_page|i:1;country_id|s:1:\"2\";_Token|s:179:\"a:5:{s:3:\"key\";s:40:\"bea56544267712d7883588ae7b209a3833b8cbd8\";s:7:\"expires\";i:1711659881;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665881, `user_id` = 0 WHERE `id` = 'opv9u4lgqb81a6t7qlp23j7fp0'11
22SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'opv9u4lgqb81a6t7qlp23j7fp0'118
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'track|a:6:{s:6:"ip_lat";s:8:"37.45243";s:7:"ip_lang";s:9:"-76.41686";s:7:"ip_city";s:5:"North";s:8:"ip_state";s:8:"Virginia";s:10:"ip_country";s:13:"United States";s:21:"ip_country_short_name";s:2:"US";}layout_page|i:1;country_id|s:1:"2";_Token|s:179:"a:5:{s:3:"key";s:40:"bea56544267712d7883588ae7b209a3833b8cbd8";s:7:"expires";i:1711659882;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
23SELECT COUNT(*) AS `count` FROM `banners` AS `Banner` LEFT JOIN `countries` AS `Country` ON (`Banner`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Banner`.`state_id` = `State`.`id`) LEFT JOIN `attachments` AS `BannerAvatar` ON (`BannerAvatar`.`foreign_id` = `Banner`.`id` AND `BannerAvatar`.`class` = 'BannerAvatar')  WHERE `Banner`.`is_active` = 1 AND `Banner`.`country_id` IN (1, 2)  1117
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEBannerALLcountry_id6762.69Using where
1SIMPLEBannerAvatarrefforeign_idforeign_id8phonlinemysql.Banner.id2100.00Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`banners` `banner` LEFT JOIN `phonlinemysql`.`attachments` `banneravatar` on(((`phonlinemysql`.`banneravatar`.`foreign_id` = `phonlinemysql`.`banner`.`id`) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))) WHERE ((`phonlinemysql`.`banner`.`is_active` = 1) AND (`phonlinemysql`.`banner`.`country_id` IN (1,2)))
24SELECT `Banner`.`id`, `Banner`.`created`, `Banner`.`modified`, `Banner`.`country_id`, `Banner`.`website`, `Banner`.`INTERVAL`, `Banner`.`is_active`, `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active`, `State`.`id`, `State`.`name`, `State`.`is_approved` FROM `banners` AS `Banner` LEFT JOIN `countries` AS `Country` ON (`Banner`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Banner`.`state_id` = `State`.`id`) LEFT JOIN `attachments` AS `BannerAvatar` ON (`BannerAvatar`.`foreign_id` = `Banner`.`id` AND `BannerAvatar`.`class` = 'BannerAvatar')  WHERE `Banner`.`is_active` = 1 AND `Banner`.`country_id` IN (1, 2)   ORDER BY `last_updated_on` desc  LIMIT 20552
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEBannerrangecountry_idcountry_id842100.00Using index condition; Using where; Using filesort
1SIMPLECountryeq_refPRIMARYPRIMARY8phonlinemysql.Banner.country_id1100.00Using where
1SIMPLEStateeq_refPRIMARYPRIMARY8phonlinemysql.Banner.state_id1100.00Using where
1SIMPLEBannerAvatarrefforeign_idforeign_id8phonlinemysql.Banner.id2100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`banner`.`id` AS `id`,`phonlinemysql`.`banner`.`created` AS `created`,`phonlinemysql`.`banner`.`modified` AS `modified`,`phonlinemysql`.`banner`.`country_id` AS `country_id`,`phonlinemysql`.`banner`.`website` AS `website`,`phonlinemysql`.`banner`.`INTERVAL` AS `INTERVAL`,`phonlinemysql`.`banner`.`is_active` AS `is_active`,`phonlinemysql`.`country`.`id` AS `id`,`phonlinemysql`.`country`.`name` AS `name`,`phonlinemysql`.`country`.`flag` AS `flag`,`phonlinemysql`.`country`.`slug` AS `slug`,`phonlinemysql`.`country`.`is_active` AS `is_active`,`phonlinemysql`.`state`.`id` AS `id`,`phonlinemysql`.`state`.`name` AS `name`,`phonlinemysql`.`state`.`is_approved` AS `is_approved` FROM `phonlinemysql`.`banners` `banner` LEFT JOIN `phonlinemysql`.`countries` `country` on((`phonlinemysql`.`banner`.`country_id` = `phonlinemysql`.`country`.`id`)) LEFT JOIN `phonlinemysql`.`states` `state` on(((`phonlinemysql`.`state`.`id` = `phonlinemysql`.`banner`.`state_id`) AND (`phonlinemysql`.`banner`.`state_id` IS NOT NULL))) LEFT JOIN `phonlinemysql`.`attachments` `banneravatar` on(((`phonlinemysql`.`banneravatar`.`foreign_id` = `phonlinemysql`.`banner`.`id`) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))) WHERE ((`phonlinemysql`.`banner`.`is_active` = 1) AND (`phonlinemysql`.`banner`.`country_id` IN (1,2))) ORDER BY `phonlinemysql`.`banner`.`last_updated_on` desc LIMIT 20
25SELECT `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`id` = 1  114
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 1 AS `id`,'All Country' AS `name`,'' AS `flag`,'all-country' AS `slug`,1 AS `is_active` FROM `phonlinemysql`.`countries` `country` WHERE 1
26SELECT `State`.`id`, `State`.`country_id`, `State`.`name`, `State`.`iso_code`, `State`.`is_approved` FROM `states` AS `State`   WHERE `State`.`country_id` = (1)  0017
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEStateALL103100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`state`.`id` AS `id`,`phonlinemysql`.`state`.`country_id` AS `country_id`,`phonlinemysql`.`state`.`name` AS `name`,`phonlinemysql`.`state`.`iso_code` AS `iso_code`,`phonlinemysql`.`state`.`is_approved` AS `is_approved` FROM `phonlinemysql`.`states` `state` WHERE (`phonlinemysql`.`state`.`country_id` = 1)
27SELECT `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`id` = 1  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 1 AS `id`,'All Country' AS `name`,'' AS `flag`,'all-country' AS `slug`,1 AS `is_active` FROM `phonlinemysql`.`countries` `country` WHERE 1
28SELECT `State`.`id`, `State`.`country_id`, `State`.`name`, `State`.`iso_code`, `State`.`is_approved` FROM `states` AS `State`   WHERE `State`.`country_id` = (1)  000
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEStateALL103100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`state`.`id` AS `id`,`phonlinemysql`.`state`.`country_id` AS `country_id`,`phonlinemysql`.`state`.`name` AS `name`,`phonlinemysql`.`state`.`iso_code` AS `iso_code`,`phonlinemysql`.`state`.`is_approved` AS `is_approved` FROM `phonlinemysql`.`states` `state` WHERE (`phonlinemysql`.`state`.`country_id` = 1)
29SELECT `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`id` = 1  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 1 AS `id`,'All Country' AS `name`,'' AS `flag`,'all-country' AS `slug`,1 AS `is_active` FROM `phonlinemysql`.`countries` `country` WHERE 1
30SELECT `State`.`id`, `State`.`country_id`, `State`.`name`, `State`.`iso_code`, `State`.`is_approved` FROM `states` AS `State`   WHERE `State`.`country_id` = (1)  004
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEStateALL103100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`state`.`id` AS `id`,`phonlinemysql`.`state`.`country_id` AS `country_id`,`phonlinemysql`.`state`.`name` AS `name`,`phonlinemysql`.`state`.`iso_code` AS `iso_code`,`phonlinemysql`.`state`.`is_approved` AS `is_approved` FROM `phonlinemysql`.`states` `state` WHERE (`phonlinemysql`.`state`.`country_id` = 1)
31SELECT `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`id` = 1  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 1 AS `id`,'All Country' AS `name`,'' AS `flag`,'all-country' AS `slug`,1 AS `is_active` FROM `phonlinemysql`.`countries` `country` WHERE 1
32SELECT `State`.`id`, `State`.`country_id`, `State`.`name`, `State`.`iso_code`, `State`.`is_approved` FROM `states` AS `State`   WHERE `State`.`country_id` = (1)  0017
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEStateALL103100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`state`.`id` AS `id`,`phonlinemysql`.`state`.`country_id` AS `country_id`,`phonlinemysql`.`state`.`name` AS `name`,`phonlinemysql`.`state`.`iso_code` AS `iso_code`,`phonlinemysql`.`state`.`is_approved` AS `is_approved` FROM `phonlinemysql`.`states` `state` WHERE (`phonlinemysql`.`state`.`country_id` = 1)
33SELECT `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`id` = 1  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 1 AS `id`,'All Country' AS `name`,'' AS `flag`,'all-country' AS `slug`,1 AS `is_active` FROM `phonlinemysql`.`countries` `country` WHERE 1
34SELECT `State`.`id`, `State`.`country_id`, `State`.`name`, `State`.`iso_code`, `State`.`is_approved` FROM `states` AS `State`   WHERE `State`.`country_id` = (1)  000
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEStateALL103100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`state`.`id` AS `id`,`phonlinemysql`.`state`.`country_id` AS `country_id`,`phonlinemysql`.`state`.`name` AS `name`,`phonlinemysql`.`state`.`iso_code` AS `iso_code`,`phonlinemysql`.`state`.`is_approved` AS `is_approved` FROM `phonlinemysql`.`states` `state` WHERE (`phonlinemysql`.`state`.`country_id` = 1)
35SELECT `BannerAvatar`.`id`, `BannerAvatar`.`created`, `BannerAvatar`.`modified`, `BannerAvatar`.`class`, `BannerAvatar`.`foreign_id`, `BannerAvatar`.`filename`, `BannerAvatar`.`dir`, `BannerAvatar`.`mimetype`, `BannerAvatar`.`filesize`, `BannerAvatar`.`height`, `BannerAvatar`.`width`, `BannerAvatar`.`thumb`, `BannerAvatar`.`description` FROM `attachments` AS `BannerAvatar`   WHERE `BannerAvatar`.`foreign_id` = 108 AND `BannerAvatar`.`class` = 'BannerAvatar'  111
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEBannerAvatarrefforeign_idforeign_id8const9100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`banneravatar`.`id` AS `id`,`phonlinemysql`.`banneravatar`.`created` AS `created`,`phonlinemysql`.`banneravatar`.`modified` AS `modified`,`phonlinemysql`.`banneravatar`.`class` AS `class`,`phonlinemysql`.`banneravatar`.`foreign_id` AS `foreign_id`,`phonlinemysql`.`banneravatar`.`filename` AS `filename`,`phonlinemysql`.`banneravatar`.`dir` AS `dir`,`phonlinemysql`.`banneravatar`.`mimetype` AS `mimetype`,`phonlinemysql`.`banneravatar`.`filesize` AS `filesize`,`phonlinemysql`.`banneravatar`.`height` AS `height`,`phonlinemysql`.`banneravatar`.`width` AS `width`,`phonlinemysql`.`banneravatar`.`thumb` AS `thumb`,`phonlinemysql`.`banneravatar`.`description` AS `description` FROM `phonlinemysql`.`attachments` `banneravatar` WHERE ((`phonlinemysql`.`banneravatar`.`foreign_id` = 108) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))
36SELECT `BannerAvatar`.`id`, `BannerAvatar`.`created`, `BannerAvatar`.`modified`, `BannerAvatar`.`class`, `BannerAvatar`.`foreign_id`, `BannerAvatar`.`filename`, `BannerAvatar`.`dir`, `BannerAvatar`.`mimetype`, `BannerAvatar`.`filesize`, `BannerAvatar`.`height`, `BannerAvatar`.`width`, `BannerAvatar`.`thumb`, `BannerAvatar`.`description` FROM `attachments` AS `BannerAvatar`   WHERE `BannerAvatar`.`foreign_id` = 66 AND `BannerAvatar`.`class` = 'BannerAvatar'  112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEBannerAvatarrefforeign_idforeign_id8const7100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`banneravatar`.`id` AS `id`,`phonlinemysql`.`banneravatar`.`created` AS `created`,`phonlinemysql`.`banneravatar`.`modified` AS `modified`,`phonlinemysql`.`banneravatar`.`class` AS `class`,`phonlinemysql`.`banneravatar`.`foreign_id` AS `foreign_id`,`phonlinemysql`.`banneravatar`.`filename` AS `filename`,`phonlinemysql`.`banneravatar`.`dir` AS `dir`,`phonlinemysql`.`banneravatar`.`mimetype` AS `mimetype`,`phonlinemysql`.`banneravatar`.`filesize` AS `filesize`,`phonlinemysql`.`banneravatar`.`height` AS `height`,`phonlinemysql`.`banneravatar`.`width` AS `width`,`phonlinemysql`.`banneravatar`.`thumb` AS `thumb`,`phonlinemysql`.`banneravatar`.`description` AS `description` FROM `phonlinemysql`.`attachments` `banneravatar` WHERE ((`phonlinemysql`.`banneravatar`.`foreign_id` = 66) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))
37SELECT `BannerAvatar`.`id`, `BannerAvatar`.`created`, `BannerAvatar`.`modified`, `BannerAvatar`.`class`, `BannerAvatar`.`foreign_id`, `BannerAvatar`.`filename`, `BannerAvatar`.`dir`, `BannerAvatar`.`mimetype`, `BannerAvatar`.`filesize`, `BannerAvatar`.`height`, `BannerAvatar`.`width`, `BannerAvatar`.`thumb`, `BannerAvatar`.`description` FROM `attachments` AS `BannerAvatar`   WHERE `BannerAvatar`.`foreign_id` = 114 AND `BannerAvatar`.`class` = 'BannerAvatar'  114
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEBannerAvatarrefforeign_idforeign_id8const9100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`banneravatar`.`id` AS `id`,`phonlinemysql`.`banneravatar`.`created` AS `created`,`phonlinemysql`.`banneravatar`.`modified` AS `modified`,`phonlinemysql`.`banneravatar`.`class` AS `class`,`phonlinemysql`.`banneravatar`.`foreign_id` AS `foreign_id`,`phonlinemysql`.`banneravatar`.`filename` AS `filename`,`phonlinemysql`.`banneravatar`.`dir` AS `dir`,`phonlinemysql`.`banneravatar`.`mimetype` AS `mimetype`,`phonlinemysql`.`banneravatar`.`filesize` AS `filesize`,`phonlinemysql`.`banneravatar`.`height` AS `height`,`phonlinemysql`.`banneravatar`.`width` AS `width`,`phonlinemysql`.`banneravatar`.`thumb` AS `thumb`,`phonlinemysql`.`banneravatar`.`description` AS `description` FROM `phonlinemysql`.`attachments` `banneravatar` WHERE ((`phonlinemysql`.`banneravatar`.`foreign_id` = 114) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))
38SELECT `BannerAvatar`.`id`, `BannerAvatar`.`created`, `BannerAvatar`.`modified`, `BannerAvatar`.`class`, `BannerAvatar`.`foreign_id`, `BannerAvatar`.`filename`, `BannerAvatar`.`dir`, `BannerAvatar`.`mimetype`, `BannerAvatar`.`filesize`, `BannerAvatar`.`height`, `BannerAvatar`.`width`, `BannerAvatar`.`thumb`, `BannerAvatar`.`description` FROM `attachments` AS `BannerAvatar`   WHERE `BannerAvatar`.`foreign_id` = 86 AND `BannerAvatar`.`class` = 'BannerAvatar'  112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEBannerAvatarrefforeign_idforeign_id8const8100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`banneravatar`.`id` AS `id`,`phonlinemysql`.`banneravatar`.`created` AS `created`,`phonlinemysql`.`banneravatar`.`modified` AS `modified`,`phonlinemysql`.`banneravatar`.`class` AS `class`,`phonlinemysql`.`banneravatar`.`foreign_id` AS `foreign_id`,`phonlinemysql`.`banneravatar`.`filename` AS `filename`,`phonlinemysql`.`banneravatar`.`dir` AS `dir`,`phonlinemysql`.`banneravatar`.`mimetype` AS `mimetype`,`phonlinemysql`.`banneravatar`.`filesize` AS `filesize`,`phonlinemysql`.`banneravatar`.`height` AS `height`,`phonlinemysql`.`banneravatar`.`width` AS `width`,`phonlinemysql`.`banneravatar`.`thumb` AS `thumb`,`phonlinemysql`.`banneravatar`.`description` AS `description` FROM `phonlinemysql`.`attachments` `banneravatar` WHERE ((`phonlinemysql`.`banneravatar`.`foreign_id` = 86) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))
39SELECT `BannerAvatar`.`id`, `BannerAvatar`.`created`, `BannerAvatar`.`modified`, `BannerAvatar`.`class`, `BannerAvatar`.`foreign_id`, `BannerAvatar`.`filename`, `BannerAvatar`.`dir`, `BannerAvatar`.`mimetype`, `BannerAvatar`.`filesize`, `BannerAvatar`.`height`, `BannerAvatar`.`width`, `BannerAvatar`.`thumb`, `BannerAvatar`.`description` FROM `attachments` AS `BannerAvatar`   WHERE `BannerAvatar`.`foreign_id` = 57 AND `BannerAvatar`.`class` = 'BannerAvatar'  112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEBannerAvatarrefforeign_idforeign_id8const5100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`banneravatar`.`id` AS `id`,`phonlinemysql`.`banneravatar`.`created` AS `created`,`phonlinemysql`.`banneravatar`.`modified` AS `modified`,`phonlinemysql`.`banneravatar`.`class` AS `class`,`phonlinemysql`.`banneravatar`.`foreign_id` AS `foreign_id`,`phonlinemysql`.`banneravatar`.`filename` AS `filename`,`phonlinemysql`.`banneravatar`.`dir` AS `dir`,`phonlinemysql`.`banneravatar`.`mimetype` AS `mimetype`,`phonlinemysql`.`banneravatar`.`filesize` AS `filesize`,`phonlinemysql`.`banneravatar`.`height` AS `height`,`phonlinemysql`.`banneravatar`.`width` AS `width`,`phonlinemysql`.`banneravatar`.`thumb` AS `thumb`,`phonlinemysql`.`banneravatar`.`description` AS `description` FROM `phonlinemysql`.`attachments` `banneravatar` WHERE ((`phonlinemysql`.`banneravatar`.`foreign_id` = 57) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))
40SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`ORDER` FROM `settings` AS `Setting`   WHERE 1 = 1  1671670
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLESettingALL167100.00
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`setting`.`id` AS `id`,`phonlinemysql`.`setting`.`setting_category_id` AS `setting_category_id`,`phonlinemysql`.`setting`.`name` AS `name`,`phonlinemysql`.`setting`.`value` AS `value`,`phonlinemysql`.`setting`.`description` AS `description`,`phonlinemysql`.`setting`.`type` AS `type`,`phonlinemysql`.`setting`.`options` AS `options`,`phonlinemysql`.`setting`.`label` AS `label`,`phonlinemysql`.`setting`.`ORDER` AS `ORDER` FROM `phonlinemysql`.`settings` `setting` WHERE 1
41SELECT `Translation`.`key`, `Translation`.`lang_text`, `Language`.`iso2`, `Language`.`id` FROM `translations` AS `Translation` LEFT JOIN `languages` AS `Language` ON (`Translation`.`language_id` = `Language`.`id`)  WHERE 1 = 1  000
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEImpossible WHERE noticed after reading const tables
LevelCodeMessage
Note1003SELECT NULL AS `key`,NULL AS `lang_text`,`phonlinemysql`.`language`.`iso2` AS `iso2`,`phonlinemysql`.`language`.`id` AS `id` FROM `phonlinemysql`.`translations` `translation` LEFT JOIN `phonlinemysql`.`languages` `language` on((`phonlinemysql`.`language`.`id` = NULL)) WHERE 0
42SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'opv9u4lgqb81a6t7qlp23j7fp0'112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('opv9u4lgqb81a6t7qlp23j7fp0') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
43UPDATE `cake_sessions` SET `data` = 'track|a:6:{s:6:\"ip_lat\";s:8:\"37.45243\";s:7:\"ip_lang\";s:9:\"-76.41686\";s:7:\"ip_city\";s:5:\"North\";s:8:\"ip_state\";s:8:\"Virginia\";s:10:\"ip_country\";s:13:\"United States\";s:21:\"ip_country_short_name\";s:2:\"US\";}layout_page|i:1;country_id|s:1:\"2\";_Token|s:179:\"a:5:{s:3:\"key\";s:40:\"bea56544267712d7883588ae7b209a3833b8cbd8\";s:7:\"expires\";i:1711659881;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665881, `user_id` = 0 WHERE `id` = 'opv9u4lgqb81a6t7qlp23j7fp0'00
44SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'opv9u4lgqb81a6t7qlp23j7fp0'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'track|a:6:{s:6:"ip_lat";s:8:"37.45243";s:7:"ip_lang";s:9:"-76.41686";s:7:"ip_city";s:5:"North";s:8:"ip_state";s:8:"Virginia";s:10:"ip_country";s:13:"United States";s:21:"ip_country_short_name";s:2:"US";}layout_page|i:1;country_id|s:1:"2";_Token|s:179:"a:5:{s:3:"key";s:40:"bea56544267712d7883588ae7b209a3833b8cbd8";s:7:"expires";i:1711659882;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
45SELECT `State`.`id`, `State`.`name` FROM `states` AS `State`   WHERE `State`.`country_id` = 2  53530
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEStateALL103100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`state`.`id` AS `id`,`phonlinemysql`.`state`.`name` AS `name` FROM `phonlinemysql`.`states` `state` WHERE (`phonlinemysql`.`state`.`country_id` = 2)
46SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'opv9u4lgqb81a6t7qlp23j7fp0'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('opv9u4lgqb81a6t7qlp23j7fp0') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
47UPDATE `cake_sessions` SET `data` = 'track|a:6:{s:6:\"ip_lat\";s:8:\"37.45243\";s:7:\"ip_lang\";s:9:\"-76.41686\";s:7:\"ip_city\";s:5:\"North\";s:8:\"ip_state\";s:8:\"Virginia\";s:10:\"ip_country\";s:13:\"United States\";s:21:\"ip_country_short_name\";s:2:\"US\";}layout_page|i:1;country_id|s:1:\"2\";_Token|s:179:\"a:5:{s:3:\"key\";s:40:\"bea56544267712d7883588ae7b209a3833b8cbd8\";s:7:\"expires\";i:1711659882;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665882, `user_id` = 0 WHERE `id` = 'opv9u4lgqb81a6t7qlp23j7fp0'10