Resources

Selected Country:
 
Notice (8): Array to string conversion [CORE/cake/libs/router.php, line 1009]
Section
« Prev Next »
Notice (8): Undefined index: State [APP/controllers/states_controller.php, line 64]
top of the page
85 queries took 96 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  1671673
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
3DESCRIBE `health_links`771
4DESCRIBE `health_link_categories`880
5DESCRIBE `health_links_countries`330
6SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '2holev4r8o5d1jrh1tcfce0tr7'002
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'Config|a:4:{s:9:"userAgent";s:32:"f3f6b503b1bbe29c6a8c29b3962ca7d7";s:4:"time";i:1711665790;s:4:"rand";i:906704686;s:7:"timeout";i:10;}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:"fae22c2303ed072f32b0953ca6ab424682c7a898";s:7:"expires";i:1711659791;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
7SELECT `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
8SELECT `Country`.`id` FROM `countries` AS `Country`   WHERE `Country`.`slug` = 'denmark'    LIMIT 1111
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryALL21100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`country`.`id` AS `id` FROM `phonlinemysql`.`countries` `country` WHERE (`phonlinemysql`.`country`.`slug` = 'denmark') LIMIT 1
9SELECT `HealthLinksCountry`.`health_link_id` FROM `health_links_countries` AS `HealthLinksCountry`   WHERE `HealthLinksCountry`.`country_id` IN (26, 1)  555
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinksCountryALL62100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`healthlinkscountry`.`health_link_id` AS `health_link_id` FROM `phonlinemysql`.`health_links_countries` `healthlinkscountry` WHERE (`phonlinemysql`.`healthlinkscountry`.`country_id` IN (26,1))
10SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink` LEFT JOIN `health_link_categories` AS `HealthLinkCategory` ON (`HealthLink`.`health_link_category_id` = `HealthLinkCategory`.`id`)  WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1  111
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
11SELECT `HealthLink`.*, `HealthLinkCategory`.`name`, `HealthLinkCategory`.`id` FROM `health_links` AS `HealthLink` LEFT JOIN `health_link_categories` AS `HealthLinkCategory` ON (`HealthLink`.`health_link_category_id` = `HealthLinkCategory`.`id`)  WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1   ORDER BY `HealthLink`.`modified` desc  LIMIT 20557
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where; Using filesort
1SIMPLEHealthLinkCategoryeq_refPRIMARYPRIMARY4phonlinemysql.HealthLink.health_link_category_id1100.00
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`healthlink`.`id` AS `id`,`phonlinemysql`.`healthlink`.`image` AS `image`,`phonlinemysql`.`healthlink`.`link` AS `link`,`phonlinemysql`.`healthlink`.`health_link_category_id` AS `health_link_category_id`,`phonlinemysql`.`healthlink`.`is_active` AS `is_active`,`phonlinemysql`.`healthlink`.`created` AS `created`,`phonlinemysql`.`healthlink`.`modified` AS `modified`,`phonlinemysql`.`healthlinkcategory`.`name` AS `name`,`phonlinemysql`.`healthlinkcategory`.`id` AS `id` FROM `phonlinemysql`.`health_links` `healthlink` LEFT JOIN `phonlinemysql`.`health_link_categories` `healthlinkcategory` on((`phonlinemysql`.`healthlinkcategory`.`id` = `phonlinemysql`.`healthlink`.`health_link_category_id`)) WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8))) ORDER BY `phonlinemysql`.`healthlink`.`modified` desc LIMIT 20
12SELECT `HealthLinkCategory`.`name`, `HealthLinkCategory`.`id`, `HealthLinkCategory`.`slug` FROM `health_link_categories` AS `HealthLinkCategory`   WHERE `HealthLinkCategory`.`parent_id` = 1 AND `HealthLinkCategory`.`is_active` = 1   ORDER BY `HealthLinkCategory`.`name` asc770
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkCategoryALL35100.00Using where; Using filesort
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`healthlinkcategory`.`name` AS `name`,`phonlinemysql`.`healthlinkcategory`.`id` AS `id`,`phonlinemysql`.`healthlinkcategory`.`slug` AS `slug` FROM `phonlinemysql`.`health_link_categories` `healthlinkcategory` WHERE ((`phonlinemysql`.`healthlinkcategory`.`parent_id` = 1) AND (`phonlinemysql`.`healthlinkcategory`.`is_active` = 1)) ORDER BY `phonlinemysql`.`healthlinkcategory`.`name`
13SELECT `ChildHealthLinkCategory`.`id`, `ChildHealthLinkCategory`.`name`, `ChildHealthLinkCategory`.`slug`, `ChildHealthLinkCategory`.`parent_id` FROM `health_link_categories` AS `ChildHealthLinkCategory`   WHERE `ChildHealthLinkCategory`.`parent_id` IN (24, 48, 16, 14, 22, 56, 34)   ORDER BY `ChildHealthLinkCategory`.`name` ASC27275
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEChildHealthLinkCategoryALL35100.00Using where; Using filesort
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`childhealthlinkcategory`.`id` AS `id`,`phonlinemysql`.`childhealthlinkcategory`.`name` AS `name`,`phonlinemysql`.`childhealthlinkcategory`.`slug` AS `slug`,`phonlinemysql`.`childhealthlinkcategory`.`parent_id` AS `parent_id` FROM `phonlinemysql`.`health_link_categories` `childhealthlinkcategory` WHERE (`phonlinemysql`.`childhealthlinkcategory`.`parent_id` IN (24,48,16,14,22,56,34)) ORDER BY `phonlinemysql`.`childhealthlinkcategory`.`name`
14SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 40  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 40) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
15SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 32  114
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 32) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
16SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 42  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 42) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
17SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 50  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 50) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
18SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 46  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 46) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
19SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 18  115
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 18) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
20SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 20  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 20) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
21SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 78  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 78) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
22SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 38  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 38) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
23SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 52  112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 52) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
24SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 80  112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 80) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
25SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 44  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 44) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
26SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 28  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 28) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
27SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 84  111
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 84) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
28SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 82  112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 82) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
29SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 68  111
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 68) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
30SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 74  113
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 74) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
31SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 64  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 64) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
32SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 66  112
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 66) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
33SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 62  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 62) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
34SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 70  113
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 70) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
35SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 30  113
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 30) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
36SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 26  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 26) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
37SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 54  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 54) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
38SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 60  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 60) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
39SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 58  110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 58) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
40SELECT COUNT(*) AS `count` FROM `health_links` AS `HealthLink`   WHERE `HealthLink`.`id` IN (34, 32, 22, 14, 8) AND `HealthLink`.`is_active` = 1 AND `HealthLink`.`health_link_category_id` = 36  113
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEHealthLinkrangePRIMARYPRIMARY45100.00Using index condition; Using where
LevelCodeMessage
Note1003SELECT count(0) AS `count` FROM `phonlinemysql`.`health_links` `healthlink` WHERE ((`phonlinemysql`.`healthlink`.`is_active` = 1) AND (`phonlinemysql`.`healthlink`.`health_link_category_id` = 36) AND (`phonlinemysql`.`healthlink`.`id` IN (34,32,22,14,8)))
41SELECT `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`is_active` = 1 AND `Country`.`id` <> 1   ORDER BY `Country`.`id` asc19190
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryALLPRIMARY21100.00Using where; Using filesort
LevelCodeMessage
Note1003SELECT `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` FROM `phonlinemysql`.`countries` `country` WHERE ((`phonlinemysql`.`country`.`is_active` = 1) AND (`phonlinemysql`.`country`.`id` <> 1)) ORDER BY `phonlinemysql`.`country`.`id`
42SELECT `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
43SELECT `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  002
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
44SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'111
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('2holev4r8o5d1jrh1tcfce0tr7') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
45INSERT INTO `cake_sessions` (`data`,`expires`,`id`,`user_id`) VALUES ('Config|a:4:{s:9:\"userAgent\";s:32:\"f3f6b503b1bbe29c6a8c29b3962ca7d7\";s:4:\"time\";i:1711665790;s:4:\"rand\";i:906704686;s:7:\"timeout\";i:10;}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:\"fae22c2303ed072f32b0953ca6ab424682c7a898\";s:7:\"expires\";i:1711659790;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', 1711665791, '2holev4r8o5d1jrh1tcfce0tr7', 0)10
46SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '2holev4r8o5d1jrh1tcfce0tr7'113
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'Config|a:4:{s:9:"userAgent";s:32:"f3f6b503b1bbe29c6a8c29b3962ca7d7";s:4:"time";i:1711665790;s:4:"rand";i:906704686;s:7:"timeout";i:10;}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:"fae22c2303ed072f32b0953ca6ab424682c7a898";s:7:"expires";i:1711659791;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
47SELECT `Country`.`id`, `Country`.`flag` FROM `countries` AS `Country`   WHERE `Country`.`id` = 2    LIMIT 1114
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryconstPRIMARYPRIMARY8const1100.00
LevelCodeMessage
Note1003SELECT 2 AS `id`,'US' AS `flag` FROM `phonlinemysql`.`countries` `country` WHERE 1 LIMIT 1
48SELECT `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  1671673
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
49SELECT `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  003
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
50DESCRIBE `banners`11111
51SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('2holev4r8o5d1jrh1tcfce0tr7') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
52UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"f3f6b503b1bbe29c6a8c29b3962ca7d7\";s:4:\"time\";i:1711665790;s:4:\"rand\";i:906704686;s:7:\"timeout\";i:10;}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:\"fae22c2303ed072f32b0953ca6ab424682c7a898\";s:7:\"expires\";i:1711659791;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665791, `user_id` = 0 WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'10
53SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '2holev4r8o5d1jrh1tcfce0tr7'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'Config|a:4:{s:9:"userAgent";s:32:"f3f6b503b1bbe29c6a8c29b3962ca7d7";s:4:"time";i:1711665790;s:4:"rand";i:906704686;s:7:"timeout";i:10;}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:"fae22c2303ed072f32b0953ca6ab424682c7a898";s:7:"expires";i:1711659791;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
54SELECT 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)))
55SELECT `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 20550
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
56SELECT `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
57SELECT `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)
58SELECT `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
59SELECT `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)
60SELECT `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
61SELECT `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)
62SELECT `Country`.`id`, `Country`.`name`, `Country`.`flag`, `Country`.`slug`, `Country`.`is_active` FROM `countries` AS `Country`   WHERE `Country`.`id` = 1  112
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
63SELECT `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)
64SELECT `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
65SELECT `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)
66SELECT `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'  115
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'))
67SELECT `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'))
68SELECT `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'  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` = 114) AND (`phonlinemysql`.`banneravatar`.`class` = 'BannerAvatar'))
69SELECT `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'  110
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'))
70SELECT `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'))
71SELECT `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
72SELECT `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
73SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('2holev4r8o5d1jrh1tcfce0tr7') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
74UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"f3f6b503b1bbe29c6a8c29b3962ca7d7\";s:4:\"time\";i:1711665790;s:4:\"rand\";i:906704686;s:7:\"timeout\";i:10;}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:\"fae22c2303ed072f32b0953ca6ab424682c7a898\";s:7:\"expires\";i:1711659791;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665791, `user_id` = 0 WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'00
75SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '2holev4r8o5d1jrh1tcfce0tr7'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'Config|a:4:{s:9:"userAgent";s:32:"f3f6b503b1bbe29c6a8c29b3962ca7d7";s:4:"time";i:1711665790;s:4:"rand";i:906704686;s:7:"timeout";i:10;}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:"fae22c2303ed072f32b0953ca6ab424682c7a898";s:7:"expires";i:1711659791;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
76SELECT `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)
77SELECT `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
78SELECT `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
79DESCRIBE `health_link_notes`882
80SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('2holev4r8o5d1jrh1tcfce0tr7') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
81UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"f3f6b503b1bbe29c6a8c29b3962ca7d7\";s:4:\"time\";i:1711665790;s:4:\"rand\";i:906704686;s:7:\"timeout\";i:10;}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:\"fae22c2303ed072f32b0953ca6ab424682c7a898\";s:7:\"expires\";i:1711659791;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665791, `user_id` = 0 WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'00
82SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '2holev4r8o5d1jrh1tcfce0tr7'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00
LevelCodeMessage
Note1003SELECT 'Config|a:4:{s:9:"userAgent";s:32:"f3f6b503b1bbe29c6a8c29b3962ca7d7";s:4:"time";i:1711665790;s:4:"rand";i:906704686;s:7:"timeout";i:10;}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:"fae22c2303ed072f32b0953ca6ab424682c7a898";s:7:"expires";i:1711659791;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` FROM `phonlinemysql`.`cake_sessions` WHERE 1
83SELECT `Country`.`id` FROM `countries` AS `Country`   WHERE `Country`.`slug` = 'denmark'    LIMIT 1110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLECountryALL21100.00Using where
LevelCodeMessage
Note1003SELECT `phonlinemysql`.`country`.`id` AS `id` FROM `phonlinemysql`.`countries` `country` WHERE (`phonlinemysql`.`country`.`slug` = 'denmark') LIMIT 1
84SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'110
EXPLAIN
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcake_sessionsconstPRIMARYPRIMARY767const1100.00Using index
LevelCodeMessage
Note1003SELECT count('2holev4r8o5d1jrh1tcfce0tr7') AS `count` FROM `phonlinemysql`.`cake_sessions` WHERE 1
85UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"f3f6b503b1bbe29c6a8c29b3962ca7d7\";s:4:\"time\";i:1711665790;s:4:\"rand\";i:906704686;s:7:\"timeout\";i:10;}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:\"fae22c2303ed072f32b0953ca6ab424682c7a898\";s:7:\"expires\";i:1711659791;s:18:\"allowedControllers\";a:0:{}s:14:\"allowedActions\";a:0:{}s:14:\"disabledFields\";a:0:{}}\";', `expires` = 1711665791, `user_id` = 0 WHERE `id` = '2holev4r8o5d1jrh1tcfce0tr7'00