| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| 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 `ResourceCountry`.`iso3166_1` = 'gb' LIMIT 1 | 1 | 1 | 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` IS NULL AND `CountryContent`.`resource_country_id` = (226) | 0 | 0 | 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`.`localization_id` IS NULL AND `LanguageContent`.`language_id` = (5) | 0 | 0 | 0 | |
| 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 | 1 | 1 | 0 | |
| SELECT `Theme`.`id`, `Theme`.`title`, `Theme`.`slug`, `Theme`.`start_date`, `Theme`.`end_date`, `Theme`.`status`, `Theme`.`is_default`, `Theme`.`created`, `Theme`.`modified` FROM `mrkochar`.`themes` AS `Theme` WHERE FROM_UNIXTIME(start_date,'%c%d') <= 109 AND FROM_UNIXTIME(end_date,'%c%d') >= 109 LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `UserGroup`.`slug` FROM `mrkochar`.`user_groups` AS `UserGroup` WHERE `UserGroup`.`allow_on_front` = 1 | 3 | 3 | 2 | maybe slow |
| SELECT `Setting`.`id`, `Setting`.`page_limit`, `Setting`.`front_page_limit`, `Setting`.`staff_email`, `Setting`.`from_name`, `Setting`.`fromemail`, `Setting`.`email_signature`, `Setting`.`reply_to_email`, `Setting`.`copyright`, `Setting`.`meta_description`, `Setting`.`meta_keywords`, `Setting`.`site_title`, `Setting`.`site_on_maintenance`, `Setting`.`site_emergency_note`, `Setting`.`phone`, `Setting`.`currency`, `Setting`.`allowed_image_type`, `Setting`.`allowed_image_mime_type`, `Setting`.`allowed_doc_type`, `Setting`.`allowed_doc_mime_type`, `Setting`.`allowed_max_filesize`, `Setting`.`fax`, `Setting`.`facebook_lnk`, `Setting`.`twitter_lnk`, `Setting`.`pintrest_lnk`, `Setting`.`youtube_lnk`, `Setting`.`linkedin_lnk`, `Setting`.`googleplus_link`, `Setting`.`facebook_api`, `Setting`.`facebook_secret_key`, `Setting`.`facebook_access_token`, `Setting`.`twitter_consumer_key`, `Setting`.`twitter_consumer_secret_key`, `Setting`.`twitter_oauth_token`, `Setting`.`twitter_oauth_token_secret`, `Setting`.`open_exchange_rate_app_id`, `Setting`.`popshop_account_key`, `Setting`.`popshop_catalog_key`, `Setting`.`blacklist_ip`, `Setting`.`bots_ip`, `Setting`.`bots_list`, `Setting`.`site_extra_meta`, `Setting`.`created`, `Setting`.`modified` FROM `mrkochar`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 4 | maybe slow |
| 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`.`localization_id` IS NULL AND `LanguageContent`.`language_id` = (5) | 0 | 0 | 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`.`localization_id` = 5 AND `LanguageContent`.`language_id` = (1) | 1 | 1 | 1 | |
| SELECT `Visitor`.`id`, `Visitor`.`session_id`, `Visitor`.`visitor_id`, `Visitor`.`visitor_type`, `Visitor`.`visitor_name`, `Visitor`.`visit_time`, `Visitor`.`visitor_ip`, `Visitor`.`country`, `Visitor`.`browser_name`, `Visitor`.`browser_version`, `Visitor`.`view_pages`, `Visitor`.`user_browser`, `Visitor`.`user_browser_device`, `Visitor`.`clicked_from`, `Visitor`.`visitor_api`, `Visitor`.`server_data`, `Visitor`.`other_data`, `Visitor`.`crawler_data`, `Visitor`.`CrawlerURL`, `Visitor`.`CrawlerEmail`, `Visitor`.`accessType`, `Visitor`.`crawlerName`, `Visitor`.`deviceModel`, `Visitor`.`layoutType`, `Visitor`.`browserName`, `Visitor`.`platform`, `Visitor`.`version`, `Visitor`.`isMobile`, `Visitor`.`isTablet`, `Visitor`.`isCrawler`, `Visitor`.`created`, `Visitor`.`modified` FROM `mrkochar`.`visitors` AS `Visitor` WHERE `Visitor`.`session_id` = '7f88df2e87eac778370c8e152d73d881' AND `Visitor`.`visitor_api` = 'visitor' LIMIT 1 | 0 | 0 | 57 | maybe slow |
| SELECT `Visitor`.`id`, `Visitor`.`session_id`, `Visitor`.`visitor_id`, `Visitor`.`visitor_type`, `Visitor`.`visitor_name`, `Visitor`.`visit_time`, `Visitor`.`visitor_ip`, `Visitor`.`country`, `Visitor`.`browser_name`, `Visitor`.`browser_version`, `Visitor`.`view_pages`, `Visitor`.`user_browser`, `Visitor`.`user_browser_device`, `Visitor`.`clicked_from`, `Visitor`.`visitor_api`, `Visitor`.`server_data`, `Visitor`.`other_data`, `Visitor`.`crawler_data`, `Visitor`.`CrawlerURL`, `Visitor`.`CrawlerEmail`, `Visitor`.`accessType`, `Visitor`.`crawlerName`, `Visitor`.`deviceModel`, `Visitor`.`layoutType`, `Visitor`.`browserName`, `Visitor`.`platform`, `Visitor`.`version`, `Visitor`.`isMobile`, `Visitor`.`isTablet`, `Visitor`.`isCrawler`, `Visitor`.`created`, `Visitor`.`modified` FROM `mrkochar`.`visitors` AS `Visitor` WHERE `Visitor`.`visitor_ip` = '216.73.216.111' AND `Visitor`.`visitor_api` = 'bots' LIMIT 1 | 1 | 1 | 1 | |
| INSERT INTO `mrkochar`.`visitors` (`crawler_data`, `server_data`, `browser_name`, `browser_version`, `visitor_ip`, `country`, `visit_time`, `user_browser`, `clicked_from`, `session_id`, `user_browser_device`, `other_data`, `visitor_id`, `visitor_type`, `visitor_name`, `view_pages`, `visitor_api`, `modified`, `created`) VALUES ('{\n \"accessType\": \"Crawler\",\n \"layoutType\": \"Desktop\",\n \"crawlerProperty\": {\n \"accessType\": \"Crawler\",\n \"layoutType\": \"Desktop\",\n \"isCrawler\": 1,\n \"crawlerName\": \" compatible\",\n \"crawlerURL\": \"\",\n \"crawlerEmail\": \"+claudebot@anthropic.com\"\n },\n \"browserProperty\": {\n \"browserName\": \" compatible\",\n \"browserIP\": \"216.73.216.111\",\n \"browserUA\": \"Mozilla\\/5.0 AppleWebKit\\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\\/1.0; +claudebot@anthropic.com)\",\n \"browserVersion\": \"5.0\",\n \"browserRefererURL\": \"\",\n \"browserAccessURL\": \"mrkochar.stage3.demo321.com\\/app\\/webroot\\/index.php\"\n },\n \"deviceProperty\": {\n \"deviceName\": \"\",\n \"deviceModel\": \"\",\n \"deviceOS\": \"\",\n \"deviceProperty\": \"\",\n \"deviceUtilities\": \"\",\n \"deviceType\": \"Computer\",\n \"platform\": \"\"\n },\n \"otherDetails\": {\n \"accessTime\": \"2026-01-09 14:33:29 UTC\",\n \"cookieEnabled\": \"Disabled\",\n \"Cookie\": \"mkuid=696111ba3d1ed4.68105870;timestamp=2026-01-09 14:33:29 UTC\"\n }\n}', '{\"TEMP\":\"\\/home\\/mrkochar\\/tmp\",\"TMPDIR\":\"\\/home\\/mrkochar\\/tmp\",\"TMP\":\"\\/home\\/mrkochar\\/tmp\",\"PATH\":\"\\/usr\\/local\\/sbin:\\/usr\\/local\\/bin:\\/usr\\/sbin:\\/usr\\/bin:\\/sbin:\\/bin:\\/snap\\/bin\",\"USER\":\"mrkochar\",\"HOME\":\"\\/home\\/mrkochar\",\"FCGI_ROLE\":\"RESPONDER\",\"REDIRECT_REDIRECT_REDIRECT_HTTPS\":\"on\",\"REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI\":\"mrkochar.stage3.demo321.com\",\"REDIRECT_REDIRECT_REDIRECT_STATUS\":\"200\",\"REDIRECT_REDIRECT_HTTPS\":\"on\",\"REDIRECT_REDIRECT_SSL_TLS_SNI\":\"mrkochar.stage3.demo321.com\",\"REDIRECT_REDIRECT_STATUS\":\"200\",\"REDIRECT_HTTPS\":\"on\",\"REDIRECT_SSL_TLS_SNI\":\"mrkochar.stage3.demo321.com\",\"REDIRECT_STATUS\":\"200\",\"HTTPS\":\"on\",\"SSL_TLS_SNI\":\"mrkochar.stage3.demo321.com\",\"proxy-nokeepalive\":\"1\",\"HTTP_HOST\":\"mrkochar.stage3.demo321.com\",\"HTTP_X_FORWARDED_FOR\":\"216.73.216.111\",\"HTTP_CONNECTION\":\"close\",\"HTTP_ACCEPT\":\"*\\/*\",\"HTTP_USER_AGENT\":\"Mozilla\\/5.0 AppleWebKit\\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\\/1.0; +claudebot@anthropic.com)\",\"HTTP_ACCEPT_ENCODING\":\"gzip, br, zstd, deflate\",\"SERVER_SIGNATURE\":\"\",\"SERVER_SOFTWARE\":\"Apache\\/2.4.54 (Ubuntu) mod_fcgid\\/2.3.9 OpenSSL\\/3.0.2\",\"SERVER_NAME\":\"mrkochar.stage3.demo321.com\",\"SERVER_ADDR\":\"192.168.11.207\",\"SERVER_PORT\":\"443\",\"REMOTE_ADDR\":\"216.73.216.111\",\"DOCUMENT_ROOT\":\"\\/home\\/mrkochar\\/web\\/mrkochar.stage3.demo321.com\\/public_html\",\"REQUEST_SCHEME\":\"https\",\"CONTEXT_PREFIX\":\"\",\"CONTEXT_DOCUMENT_ROOT\":\"\\/home\\/mrkochar\\/web\\/mrkochar.stage3.demo321.com\\/public_html\",\"SERVER_ADMIN\":\"info@mrkochar.stage3.demo321.com\",\"SCRIPT_FILENAME\":\"\\/home\\/mrkochar\\/web\\/mrkochar.stage3.demo321.com\\/public_html\\/app\\/webroot\\/index.php\",\"REMOTE_PORT\":\"44894\",\"REDIRECT_URL\":\"\\/index.php\",\"GATEWAY_INTERFACE\":\"CGI\\/1.1\",\"SERVER_PROTOCOL\":\"HTTP\\/1.0\",\"REQUEST_METHOD\":\"GET\",\"QUERY_STRING\":\"\",\"REQUEST_URI\":\"\\/gb\\/detail\\/kendall-kylie-decoltee-10038\",\"SCRIPT_NAME\":\"\\/app\\/webroot\\/index.php\",\"PHP_SELF\":\"\\/app\\/webroot\\/index.php\",\"REQUEST_TIME_FLOAT\":1767969209.9213,\"REQUEST_TIME\":1767969209,\"REVERSE_DNS\":\"216.73.216.111\",\"RDNS\":[]}', 'Mozilla', '5.0', '216.73.216.111', 'GB', 1767969210, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/', '7f88df2e87eac778370c8e152d73d881', 'Desktop', '', 0, 'Anonymous', 'Anonymous', 'https://mrkochar.stage3.demo321.com/=1767802007,https://mrkochar.stage3.demo321.com/gb/detail/kendall-kylie-decoltee-10038=1767969210', 'bots', 1767969210, 1767969210) | 1 | 1 | 2 | maybe slow |
| SELECT `Language`.`id`, `Language`.`title` FROM `mrkochar`.`languages` AS `Language` WHERE `is_active` = '1' | 25 | 25 | 0 | |
| SELECT `Language`.`folder_code`, `Language`.`id` FROM `mrkochar`.`languages` AS `Language` WHERE `is_active` = '1' AND `folder_code` = 'en_gb' 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`.`localization_id` = 5 AND `LanguageContent`.`language_id` = (5) | 1 | 1 | 0 | |
| SELECT `Language`.`folder_code`, `Language`.`title` FROM `mrkochar`.`languages` AS `Language` WHERE `is_active` = '1' ORDER BY `title` ASC | 25 | 25 | 0 | |
| SELECT `Store`.`deliver_to_countries` FROM `mrkochar`.`stores` AS `Store` WHERE `id` = 10038 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ResourceCountry`.`iso3166_1`, (select lang_code from languages where id = `ResourceCountry`.`language_id`) AS `ResourceCountry__lang_code`, `ResourceCountry`.`id` FROM `mrkochar`.`resource_countries` AS `ResourceCountry` WHERE `ResourceCountry`.`id` IN (15, 22, 34, 55, 57, 58, 59, 69, 74, 75, 82, 85, 98, 104, 106, 118, 124, 125, 133, 151, 172, 173, 177, 194, 195, 200, 206, 226) | 28 | 28 | 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` IN (15, 22, 34, 55, 57, 58, 59, 69, 74, 75, 82, 85, 98, 104, 106, 118, 124, 125, 133, 151, 172, 173, 177, 194, 195, 200, 206, 226) | 28 | 28 | 2 | maybe slow |
| 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`, (select lang_code from languages where id = `ResourceCountry`.`language_id`) AS `ResourceCountry__lang_code` FROM `mrkochar`.`resource_countries` AS `ResourceCountry` WHERE `ResourceCountry`.`iso3166_1` = 'gb' LIMIT 1 | 1 | 1 | 3 | maybe slow |
| 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 | 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 `Language`.`id` = 5 LIMIT 1 | 1 | 1 | 7 | maybe slow |
| 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`.`localization_id` = 5 AND `LanguageContent`.`language_id` = (5) | 1 | 1 | 28 | maybe slow |
| 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 | 1 | 1 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`page_limit`, `Setting`.`front_page_limit`, `Setting`.`staff_email`, `Setting`.`from_name`, `Setting`.`fromemail`, `Setting`.`email_signature`, `Setting`.`reply_to_email`, `Setting`.`copyright`, `Setting`.`meta_description`, `Setting`.`meta_keywords`, `Setting`.`site_title`, `Setting`.`site_on_maintenance`, `Setting`.`site_emergency_note`, `Setting`.`phone`, `Setting`.`currency`, `Setting`.`allowed_image_type`, `Setting`.`allowed_image_mime_type`, `Setting`.`allowed_doc_type`, `Setting`.`allowed_doc_mime_type`, `Setting`.`allowed_max_filesize`, `Setting`.`fax`, `Setting`.`facebook_lnk`, `Setting`.`twitter_lnk`, `Setting`.`pintrest_lnk`, `Setting`.`youtube_lnk`, `Setting`.`linkedin_lnk`, `Setting`.`googleplus_link`, `Setting`.`facebook_api`, `Setting`.`facebook_secret_key`, `Setting`.`facebook_access_token`, `Setting`.`twitter_consumer_key`, `Setting`.`twitter_consumer_secret_key`, `Setting`.`twitter_oauth_token`, `Setting`.`twitter_oauth_token_secret`, `Setting`.`open_exchange_rate_app_id`, `Setting`.`popshop_account_key`, `Setting`.`popshop_catalog_key`, `Setting`.`blacklist_ip`, `Setting`.`bots_ip`, `Setting`.`bots_list`, `Setting`.`site_extra_meta`, `Setting`.`created`, `Setting`.`modified` FROM `mrkochar`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 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 | 4 | maybe slow |
| 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`.`localization_id` = 5 AND `LanguageContent`.`language_id` = (5) | 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 `is_default` = '1' AND `is_active` = '1' 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`.`localization_id` = 5 AND `LanguageContent`.`language_id` = (1) | 1 | 1 | 9 | maybe slow |
| 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 `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 `ResourceCountry`.`id` = 226 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| 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 | 1 | |
| 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 | 252 | 252 | 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` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253) | 252 | 252 | 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 | 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`.`localization_id` = 5 AND `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) | 24 | 24 | 0 | |
| 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 | 0 | |
| 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 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `mrkochar`.`categories` AS `Category` WHERE `Category`.`parent_id` = 3171 AND `Category`.`deleted` = 0 AND `Category`.`status` = 1 | 1 | 1 | 0 | |
| 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 | 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` = (9) | 4 | 4 | 5 | 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 | 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` = (5) | 4 | 4 | 2 | 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) | 4 | 4 | 1 | maybe slow |
| 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 `ResourceCountry`.`name` = 'United Kingdom' LIMIT 1 | 1 | 1 | 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 `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 | 0 | |
| 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 | 0 | |