dns_get_record - [internal], line ??
AppController::recordActivity() - APP/Controller/AppController.php, line 571
AppController::beforeFilter() - APP/Controller/AppController.php, line 293
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Invalid argument supplied for foreach() [APP/Controller/AppController.php, line 573]
AppController::recordActivity() - APP/Controller/AppController.php, line 573
AppController::beforeFilter() - APP/Controller/AppController.php, line 293
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [APP/Controller/Component/CrawlerDetectComponent.php, line 199]
$cookieExpiry = time() + (86400 * 365); //86400 is 1 day (this cookie vindo is set for 2 years
if(!isset($_COOKIE[$cookieName])) {
setcookie($cookieName, $cookieValue, $cookieExpiry, "/");
setcookie - [internal], line ??
CrawlerDetectComponent::mkuidCookie() - APP/Controller/Component/CrawlerDetectComponent.php, line 199
CrawlerDetectComponent::start() - APP/Controller/Component/CrawlerDetectComponent.php, line 224
CrawlerDetectComponent::full() - APP/Controller/Component/CrawlerDetectComponent.php, line 297
CrawlerDetectComponent::crawlerDetect() - APP/Controller/Component/CrawlerDetectComponent.php, line 371
AppController::recordActivity() - APP/Controller/AppController.php, line 583
AppController::beforeFilter() - APP/Controller/AppController.php, line 293
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
Warning (2): Cannot modify header information - headers already sent by (output started at /home/mrkochar/web/mrkochar.stage3.demo321.com/public_html/lib/Cake/Utility/Debugger.php:804) [CORE/Cake/Network/CakeResponse.php, line 444]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 444
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 414
AppController::invalid_url() - APP/Controller/AppController.php, line 1163
AppController::beforeFilter() - APP/Controller/AppController.php, line 445
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 156
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 94
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 121
[main] - [internal], line ??
SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`symbol`, `Currency`.`code`, `Currency`.`value`, `Currency`.`symbol_postions`, `Currency`.`display_on_front`, `Currency`.`is_default`, `Currency`.`is_base`, `Currency`.`is_active`, `Currency`.`created`, `Currency`.`modified` FROM `mrkochar`.`currencies` AS `Currency` WHERE `Currency`.`is_active` = 1 AND `Currency`.`is_default` = 1 LIMIT 1
1
1
0
SELECT `Language`.`id`, `Language`.`title`, `Language`.`title_front`, `Language`.`lang_code`, `Language`.`folder_code`, `Language`.`charset`, `Language`.`direction`, `Language`.`is_active`, `Language`.`is_default`, `Language`.`created`, `Language`.`modified`, ((select field_value from language_contents where language_id=`Language`.`id` AND localization_id = `Language`.`id`)) AS `Language__new_name` FROM `mrkochar`.`languages` AS `Language` WHERE `folder_code` = 'eng' AND `is_active` = '1' LIMIT 1
1
1
0
SELECT `LanguageContent`.`id`, `LanguageContent`.`language_id`, `LanguageContent`.`localization_id`, `LanguageContent`.`field_name`, `LanguageContent`.`field_value`, `LanguageContent`.`created`, `LanguageContent`.`modified` FROM `mrkochar`.`language_contents` AS `LanguageContent` WHERE `LanguageContent`.`language_id` = (1)
24
24
0
SELECT `Language`.`id`, `Language`.`title`, `Language`.`title_front`, `Language`.`lang_code`, `Language`.`folder_code`, `Language`.`charset`, `Language`.`direction`, `Language`.`is_active`, `Language`.`is_default`, `Language`.`created`, `Language`.`modified`, ((select field_value from language_contents where language_id=`Language`.`id` AND localization_id = `Language`.`id`)) AS `Language__new_name` FROM `mrkochar`.`languages` AS `Language` WHERE `id` = 5 LIMIT 1
1
1
0
SELECT `LanguageContent`.`id`, `LanguageContent`.`language_id`, `LanguageContent`.`localization_id`, `LanguageContent`.`field_name`, `LanguageContent`.`field_value`, `LanguageContent`.`created`, `LanguageContent`.`modified` FROM `mrkochar`.`language_contents` AS `LanguageContent` WHERE `LanguageContent`.`language_id` = (5)
24
24
0
SELECT `Language`.`id`, `Language`.`title`, `Language`.`title_front`, `Language`.`lang_code`, `Language`.`folder_code`, `Language`.`charset`, `Language`.`direction`, `Language`.`is_active`, `Language`.`is_default`, `Language`.`created`, `Language`.`modified`, ((select field_value from language_contents where language_id=`Language`.`id` AND localization_id = `Language`.`id`)) AS `Language__new_name` FROM `mrkochar`.`languages` AS `Language` WHERE `is_default` = '1' AND `is_active` = '1' LIMIT 1
1
1
0
SELECT `LanguageContent`.`id`, `LanguageContent`.`language_id`, `LanguageContent`.`localization_id`, `LanguageContent`.`field_name`, `LanguageContent`.`field_value`, `LanguageContent`.`created`, `LanguageContent`.`modified` FROM `mrkochar`.`language_contents` AS `LanguageContent` WHERE `LanguageContent`.`language_id` = (1)
SELECT `CountryContent`.`id`, `CountryContent`.`resource_country_id`, `CountryContent`.`language_id`, `CountryContent`.`field_name`, `CountryContent`.`field_value`, `CountryContent`.`created`, `CountryContent`.`modified` FROM `mrkochar`.`country_contents` AS `CountryContent` WHERE `CountryContent`.`language_id` = 5 AND `CountryContent`.`resource_country_id` = (226)
1
1
0
SELECT `Language`.`id`, `Language`.`title`, `Language`.`title_front`, `Language`.`lang_code`, `Language`.`folder_code`, `Language`.`charset`, `Language`.`direction`, `Language`.`is_active`, `Language`.`is_default`, `Language`.`created`, `Language`.`modified`, ((select field_value from language_contents where language_id=`Language`.`id` AND localization_id = `Language`.`id`)) AS `Language__new_name` FROM `mrkochar`.`languages` AS `Language` WHERE `Language`.`id` = 5 LIMIT 1
1
1
0
SELECT `LanguageContent`.`id`, `LanguageContent`.`language_id`, `LanguageContent`.`localization_id`, `LanguageContent`.`field_name`, `LanguageContent`.`field_value`, `LanguageContent`.`created`, `LanguageContent`.`modified` FROM `mrkochar`.`language_contents` AS `LanguageContent` WHERE `LanguageContent`.`language_id` = (5)
24
24
1
SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`symbol`, `Currency`.`code`, `Currency`.`value`, `Currency`.`symbol_postions`, `Currency`.`display_on_front`, `Currency`.`is_default`, `Currency`.`is_base`, `Currency`.`is_active`, `Currency`.`created`, `Currency`.`modified` FROM `mrkochar`.`currencies` AS `Currency` WHERE `Currency`.`id` = 51 LIMIT 1
SELECT `Language`.`id`, `Language`.`title`, `Language`.`title_front`, `Language`.`lang_code`, `Language`.`folder_code`, `Language`.`charset`, `Language`.`direction`, `Language`.`is_active`, `Language`.`is_default`, `Language`.`created`, `Language`.`modified`, ((select field_value from language_contents where language_id=`Language`.`id` AND localization_id = `Language`.`id`)) AS `Language__new_name` FROM `mrkochar`.`languages` AS `Language` WHERE `id` = 5 LIMIT 1
1
1
1
SELECT `LanguageContent`.`id`, `LanguageContent`.`language_id`, `LanguageContent`.`localization_id`, `LanguageContent`.`field_name`, `LanguageContent`.`field_value`, `LanguageContent`.`created`, `LanguageContent`.`modified` FROM `mrkochar`.`language_contents` AS `LanguageContent` WHERE `LanguageContent`.`language_id` = (5)
24
24
0
SELECT `Language`.`id`, `Language`.`title`, `Language`.`title_front`, `Language`.`lang_code`, `Language`.`folder_code`, `Language`.`charset`, `Language`.`direction`, `Language`.`is_active`, `Language`.`is_default`, `Language`.`created`, `Language`.`modified`, ((select field_value from language_contents where language_id=`Language`.`id` AND localization_id = `Language`.`id`)) AS `Language__new_name` FROM `mrkochar`.`languages` AS `Language` WHERE `is_default` = '1' AND `is_active` = '1' LIMIT 1
1
1
0
SELECT `LanguageContent`.`id`, `LanguageContent`.`language_id`, `LanguageContent`.`localization_id`, `LanguageContent`.`field_name`, `LanguageContent`.`field_value`, `LanguageContent`.`created`, `LanguageContent`.`modified` FROM `mrkochar`.`language_contents` AS `LanguageContent` WHERE `LanguageContent`.`language_id` = (1)
24
24
0
SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`symbol`, `Currency`.`code` FROM `mrkochar`.`currencies` AS `Currency` WHERE `Currency`.`display_on_front` = 1 ORDER BY `Currency`.`name` asc
SELECT `CountryContent`.`id`, `CountryContent`.`resource_country_id`, `CountryContent`.`language_id`, `CountryContent`.`field_name`, `CountryContent`.`field_value`, `CountryContent`.`created`, `CountryContent`.`modified` FROM `mrkochar`.`country_contents` AS `CountryContent` WHERE `CountryContent`.`language_id` = 5 AND `CountryContent`.`resource_country_id` = (226)
1
1
0
SELECT `ResourceCountry`.`id`, `ResourceCountry`.`currency_id`, `ResourceCountry`.`language_id`, `ResourceCountry`.`name`, `ResourceCountry`.`iso3166_1`, `ResourceCountry`.`flag`, `ResourceCountry`.`country_name`, `ResourceCountry`.`ISO3166-1_Alpha2`, `ResourceCountry`.`ISO3166-1_Alpha3`, `ResourceCountry`.`M49`, `ResourceCountry`.`MARC`, `ResourceCountry`.`dial_code`, `ResourceCountry`.`FIPS`, `ResourceCountry`.`ISO4217_currency_code`, `ResourceCountry`.`ISO4217_currency_name`, `ResourceCountry`.`ISO4217_currency_numeric_code`, `ResourceCountry`.`capital`, `ResourceCountry`.`continent`, `ResourceCountry`.`TLD`, `ResourceCountry`.`languages` FROM `mrkochar`.`resource_countries` AS `ResourceCountry` WHERE 1 = 1
SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`symbol`, `Currency`.`code` FROM `mrkochar`.`currencies` AS `Currency` WHERE `Currency`.`display_on_front` = 1 ORDER BY `Currency`.`name` asc
112
112
1
SELECT `Language`.`id`, `Language`.`title`, `Language`.`title_front`, `Language`.`lang_code`, `Language`.`folder_code`, `Language`.`charset`, `Language`.`direction`, `Language`.`is_active`, `Language`.`is_default`, `Language`.`created`, `Language`.`modified`, ((select field_value from language_contents where language_id=`Language`.`id` AND localization_id = `Language`.`id`)) AS `Language__new_name` FROM `mrkochar`.`languages` AS `Language` WHERE `is_active` = '1' ORDER BY `title` ASC
25
25
1
SELECT `LanguageContent`.`id`, `LanguageContent`.`language_id`, `LanguageContent`.`localization_id`, `LanguageContent`.`field_name`, `LanguageContent`.`field_value`, `LanguageContent`.`created`, `LanguageContent`.`modified` FROM `mrkochar`.`language_contents` AS `LanguageContent` WHERE `LanguageContent`.`language_id` IN (18, 15, 22, 23, 1, 2, 5, 6, 7, 20, 11, 10, 21, 3, 9, 13, 16, 24, 25, 12, 14, 4, 19, 17, 26)
575
575
1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`popshops_type_id`, `Category`.`category_type`, `Category`.`google_id`, `Category`.`category_name`, `Category`.`slug`, `Category`.`image`, `Category`.`small_banner`, `Category`.`category_position`, `Category`.`verticals`, `Category`.`status`, `Category`.`deleted`, `Category`.`created_by`, `Category`.`rght`, `Category`.`lft`, `Category`.`status_update`, `Category`.`created`, `Category`.`modified`, `Category`.`is_imported` FROM `mrkochar`.`categories` AS `Category` WHERE `parent_id` = 0 AND `verticals` = 1 AND `deleted` = 0 AND `status` = 1 ORDER BY `category_position` asc
5
5
1
maybe slow
SELECT `CategoryContent`.`id`, `CategoryContent`.`category_id`, `CategoryContent`.`language_id`, `CategoryContent`.`field_name`, `CategoryContent`.`field_value`, `CategoryContent`.`created`, `CategoryContent`.`modified` FROM `mrkochar`.`category_contents` AS `CategoryContent` WHERE `CategoryContent`.`language_id` = 5 AND `CategoryContent`.`category_id` IN (3171, 3488, 5693, 1395, 7573)
8
8
0
SELECT COUNT(*) AS `count` FROM `mrkochar`.`categories` AS `Category` WHERE `Category`.`parent_id` = 3171 AND `Category`.`deleted` = 0 AND `Category`.`status` = 1
1
1
1
SELECT COUNT(*) AS `count` FROM `mrkochar`.`categories` AS `Category` WHERE `Category`.`parent_id` = 3488 AND `Category`.`deleted` = 0 AND `Category`.`status` = 1
1
1
0
SELECT COUNT(*) AS `count` FROM `mrkochar`.`categories` AS `Category` WHERE `Category`.`parent_id` = 5693 AND `Category`.`deleted` = 0 AND `Category`.`status` = 1
1
1
0
SELECT COUNT(*) AS `count` FROM `mrkochar`.`categories` AS `Category` WHERE `Category`.`parent_id` = 1395 AND `Category`.`deleted` = 0 AND `Category`.`status` = 1
1
1
0
SELECT COUNT(*) AS `count` FROM `mrkochar`.`categories` AS `Category` WHERE `Category`.`parent_id` = 7573 AND `Category`.`deleted` = 0 AND `Category`.`status` = 1
1
1
0
SELECT `StaticPage`.`id`, `StaticPage`.`name`, `StaticPage`.`slug`, `StaticPage`.`url`, `StaticPage`.`meta_keywords`, `StaticPage`.`meta_description`, `StaticPage`.`is_active`, `StaticPage`.`created`, `StaticPage`.`modified` FROM `mrkochar`.`static_pages` AS `StaticPage` WHERE `StaticPage`.`slug` = 'size-guide' LIMIT 1
1
1
1
SELECT `StaticPageContent`.`id`, `StaticPageContent`.`static_page_id`, `StaticPageContent`.`language_id`, `StaticPageContent`.`field_name`, `StaticPageContent`.`field_description`, `StaticPageContent`.`created`, `StaticPageContent`.`modified` FROM `mrkochar`.`static_page_contents` AS `StaticPageContent` WHERE `StaticPageContent`.`language_id` IN (5, 1) AND `StaticPageContent`.`static_page_id` = (9)
4
4
6
maybe slow
SELECT `StaticPage`.`id`, `StaticPage`.`name`, `StaticPage`.`slug`, `StaticPage`.`url`, `StaticPage`.`meta_keywords`, `StaticPage`.`meta_description`, `StaticPage`.`is_active`, `StaticPage`.`created`, `StaticPage`.`modified` FROM `mrkochar`.`static_pages` AS `StaticPage` WHERE `StaticPage`.`slug` = 'terms-conditions' LIMIT 1
1
1
1
SELECT `StaticPageContent`.`id`, `StaticPageContent`.`static_page_id`, `StaticPageContent`.`language_id`, `StaticPageContent`.`field_name`, `StaticPageContent`.`field_description`, `StaticPageContent`.`created`, `StaticPageContent`.`modified` FROM `mrkochar`.`static_page_contents` AS `StaticPageContent` WHERE `StaticPageContent`.`language_id` IN (5, 1) AND `StaticPageContent`.`static_page_id` = (5)
4
4
1
maybe slow
SELECT `StaticPage`.`id`, `StaticPage`.`name`, `StaticPage`.`slug`, `StaticPage`.`url`, `StaticPage`.`meta_keywords`, `StaticPage`.`meta_description`, `StaticPage`.`is_active`, `StaticPage`.`created`, `StaticPage`.`modified` FROM `mrkochar`.`static_pages` AS `StaticPage` WHERE `StaticPage`.`slug` = 'privacy-policy' LIMIT 1
1
1
0
SELECT `StaticPageContent`.`id`, `StaticPageContent`.`static_page_id`, `StaticPageContent`.`language_id`, `StaticPageContent`.`field_name`, `StaticPageContent`.`field_description`, `StaticPageContent`.`created`, `StaticPageContent`.`modified` FROM `mrkochar`.`static_page_contents` AS `StaticPageContent` WHERE `StaticPageContent`.`language_id` IN (5, 1) AND `StaticPageContent`.`static_page_id` = (6)
SELECT `CountryContent`.`id`, `CountryContent`.`resource_country_id`, `CountryContent`.`language_id`, `CountryContent`.`field_name`, `CountryContent`.`field_value`, `CountryContent`.`created`, `CountryContent`.`modified` FROM `mrkochar`.`country_contents` AS `CountryContent` WHERE `CountryContent`.`language_id` = 5 AND `CountryContent`.`resource_country_id` = (226)
1
1
4
maybe slow
SELECT `Store`.`id`, `Store`.`network_id`, `Store`.`merchant_account_no`, `Store`.`store_name`, `Store`.`slug`, (SELECT name FROM networks WHERE id = network_id) AS `Store__network_name` FROM `mrkochar`.`stores` AS `Store` WHERE FIND_IN_SET('226',`Store`.`deliver_to_countries`) AND `Store`.`status` = '1' ORDER BY `Store`.`store_name` asc
26
26
1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`popshops_type_id`, `Category`.`category_type`, `Category`.`google_id`, `Category`.`category_name`, `Category`.`slug`, `Category`.`image`, `Category`.`small_banner`, `Category`.`category_position`, `Category`.`verticals`, `Category`.`status`, `Category`.`deleted`, `Category`.`created_by`, `Category`.`rght`, `Category`.`lft`, `Category`.`status_update`, `Category`.`created`, `Category`.`modified`, `Category`.`is_imported` FROM `mrkochar`.`categories` AS `Category` WHERE `parent_id` IN (0, 7573) AND `status` = 1 AND `category_type` = 'product' AND `deleted` = 0 AND `id` != 7573 ORDER BY `category_name` asc
21
21
1
SELECT `CategoryContent`.`id`, `CategoryContent`.`category_id`, `CategoryContent`.`language_id`, `CategoryContent`.`field_name`, `CategoryContent`.`field_value`, `CategoryContent`.`created`, `CategoryContent`.`modified` FROM `mrkochar`.`category_contents` AS `CategoryContent` WHERE `CategoryContent`.`language_id` = 5 AND `CategoryContent`.`category_id` IN (1, 114, 502, 1030, 1107, 1292, 1395, 6221, 1932, 6218, 2598, 3171, 3488, 6223, 4560, 4619, 4850, 4932, 5693, 6222, 5878)
75
75
1
Query Explain:
Click an "Explain" link above, to see the query explanation.