Missing Controller

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

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

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

	var $name = 'Article-view.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
41 queries took 55 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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  1671675
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
2SELECT `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
3SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'phnehfod24an4p4fn7kfjf3cm5'006
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:"a3bc55edd12d82923a10aaab9d6f413f2a518111";s:7:"expires";i:1711659810;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
4SELECT `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
5SELECT `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
6SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'phnehfod24an4p4fn7kfjf3cm5'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('phnehfod24an4p4fn7kfjf3cm5') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
7INSERT INTO `cake_sessions` (`data`,`expires`,`id`,`user_id`) VALUES ('', 1711665810, 'phnehfod24an4p4fn7kfjf3cm5', 0)10
8SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'phnehfod24an4p4fn7kfjf3cm5'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:"a3bc55edd12d82923a10aaab9d6f413f2a518111";s:7:"expires";i:1711659810;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
9SELECT `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
10SELECT `Country`.`id`, `Country`.`flag` FROM `countries` AS `Country`   WHERE `Country`.`id` = 2    LIMIT 1112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 2 AS `id`,'US' AS `flag` FROM `phonlinemysql`.`countries` `country` WHERE 1 LIMIT 1
11SELECT `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  1671672
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
12SELECT `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  005
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
13DESCRIBE `banners`11115
14SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'phnehfod24an4p4fn7kfjf3cm5'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('phnehfod24an4p4fn7kfjf3cm5') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
15UPDATE `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:\"a3bc55edd12d82923a10aaab9d6f413f2a518111\";s:7:\"expires\";i:1711659810;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665810, `user_id` = 0 WHERE `id` = 'phnehfod24an4p4fn7kfjf3cm5'10
16SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'phnehfod24an4p4fn7kfjf3cm5'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:"a3bc55edd12d82923a10aaab9d6f413f2a518111";s:7:"expires";i:1711659810;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
17SELECT 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)  110
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)))
18SELECT `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 20555
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
19SELECT `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
20SELECT `State`.`id`, `State`.`country_id`, `State`.`name`, `State`.`iso_code`, `State`.`is_approved` FROM `states` AS `State`   WHERE `State`.`country_id` = (1)  003
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)
21SELECT `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
22SELECT `State`.`id`, `State`.`country_id`, `State`.`name`, `State`.`iso_code`, `State`.`is_approved` FROM `states` AS `State`   WHERE `State`.`country_id` = (1)  002
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)
23SELECT `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
24SELECT `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)
25SELECT `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
26SELECT `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)
27SELECT `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
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 `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'  110
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'))
30SELECT `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'  110
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'))
31SELECT `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'  112
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'))
32SELECT `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'))
33SELECT `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'  110
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'))
34SELECT `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
35SELECT `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  004
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
36SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'phnehfod24an4p4fn7kfjf3cm5'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('phnehfod24an4p4fn7kfjf3cm5') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
37UPDATE `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:\"a3bc55edd12d82923a10aaab9d6f413f2a518111\";s:7:\"expires\";i:1711659810;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665810, `user_id` = 0 WHERE `id` = 'phnehfod24an4p4fn7kfjf3cm5'00
38SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'phnehfod24an4p4fn7kfjf3cm5'112
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:"a3bc55edd12d82923a10aaab9d6f413f2a518111";s:7:"expires";i:1711659810;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
39SELECT `State`.`id`, `State`.`name` FROM `states` AS `State`   WHERE `State`.`country_id` = 2  53532
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)
40SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'phnehfod24an4p4fn7kfjf3cm5'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('phnehfod24an4p4fn7kfjf3cm5') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
41UPDATE `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:\"a3bc55edd12d82923a10aaab9d6f413f2a518111\";s:7:\"expires\";i:1711659810;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665810, `user_id` = 0 WHERE `id` = 'phnehfod24an4p4fn7kfjf3cm5'00