| 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` = 'kr' 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` IS NULL AND `CountryContent`.`resource_country_id` = (114) | 0 | 0 | 1 | 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 `Language`.`id` = 13 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` = (13) | 0 | 0 | 1 | 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` = 80 LIMIT 1 | 1 | 1 | 1 | |
| 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') <= 117 AND FROM_UNIXTIME(end_date,'%c%d') >= 117 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `UserGroup`.`slug` FROM `mrkochar`.`user_groups` AS `UserGroup` WHERE `UserGroup`.`allow_on_front` = 1 | 3 | 3 | 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` = 13 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` = (13) | 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` = 13 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` = '93f562363284bcb7008224b2876609e4' AND `Visitor`.`visitor_api` = 'visitor' LIMIT 1 | 0 | 0 | 1 | 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.113' AND `Visitor`.`visitor_api` = 'bots' LIMIT 1 | 1 | 1 | 1330 | maybe slow |
| 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.113\",\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-17 18:26:15 UTC\",\n \"cookieEnabled\": \"Disabled\",\n \"Cookie\": \"mkuid=696bd449cdc323.98564825;timestamp=2026-01-17 18:26:15 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.113\",\"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\",\"HTTP_COOKIE\":\"CAKEPHP=93f562363284bcb7008224b2876609e4\",\"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.113\",\"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\":\"59890\",\"REDIRECT_URL\":\"\\/index.php\",\"GATEWAY_INTERFACE\":\"CGI\\/1.1\",\"SERVER_PROTOCOL\":\"HTTP\\/1.0\",\"REQUEST_METHOD\":\"GET\",\"QUERY_STRING\":\"\",\"REQUEST_URI\":\"\\/kr\\/coupon-stores\\/free-shipping\",\"SCRIPT_NAME\":\"\\/app\\/webroot\\/index.php\",\"PHP_SELF\":\"\\/app\\/webroot\\/index.php\",\"REQUEST_TIME_FLOAT\":1768674375.8076,\"REQUEST_TIME\":1768674375,\"REVERSE_DNS\":\"216.73.216.113\",\"RDNS\":[]}', 'Mozilla', '5.0', '216.73.216.113', 'KR', 1768674377, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/', '93f562363284bcb7008224b2876609e4', 'Desktop', '', 0, 'Anonymous', 'Anonymous', 'https://mrkochar.stage3.demo321.com/na/brand/elena-ghisellini=1768531416,https://mrkochar.stage3.demo321.com/kr/coupon-stores/free-shipping=1768674377', 'bots', 1768674379, 1768674379) | 1 | 1 | 3 | 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` = 'kor' 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` = 13 AND `LanguageContent`.`language_id` = (13) | 1 | 1 | 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 `Category`.`category_type` = 'coupon' AND `Category`.`status` = 1 AND `Category`.`deleted` = 0 AND `Category`.`slug` = 'free-shipping' LIMIT 1 | 1 | 1 | 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` = 13 AND `CategoryContent`.`category_id` = (7570) | 4 | 4 | 9 | maybe slow |
| 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 `Category`.`category_type` = 'coupon' AND `Category`.`status` = 1 AND `Category`.`deleted` = 0 | 7 | 7 | 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` = 13 AND `CategoryContent`.`category_id` IN (7566, 7567, 7568, 7569, 7570, 7571, 7572) | 28 | 28 | 3 | 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`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Store`.`id` FROM `mrkochar`.`stores` AS `Store` WHERE `Store`.`status` = '1' ORDER BY `id` ASC | 32 | 32 | 0 | |
| SELECT COUNT(*) AS `count` FROM `mrkochar`.`stores` AS `Store` WHERE `Store`.`id` IS NULL AND `Store`.`status` = '1' | 1 | 1 | 1 | |
| SELECT `Store`.`id`, `Store`.`network_id`, `Store`.`user_id`, `Store`.`vertical_id`, `Store`.`popshops_type_id`, `Store`.`merchant_account_no`, `Store`.`store_name`, `Store`.`slug`, `Store`.`store_logo`, `Store`.`coupon_logo`, `Store`.`store_description`, `Store`.`shipping_information`, `Store`.`website_url`, `Store`.`store_email`, `Store`.`business_address`, `Store`.`business_country`, `Store`.`deliver_to_countries`, `Store`.`commission_rate`, `Store`.`product_feed`, `Store`.`coupon_feed`, `Store`.`contact_title`, `Store`.`phone_number`, `Store`.`feed`, `Store`.`meta_keywords`, `Store`.`meta_description`, `Store`.`cron_last_checked`, `Store`.`has_active_deal`, `Store`.`score`, `Store`.`status`, `Store`.`created`, `Store`.`modified` FROM `mrkochar`.`stores` AS `Store` WHERE `Store`.`id` IS NULL AND `Store`.`status` = '1' LIMIT 100 | 0 | 0 | 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` = 'Korea, South' 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` = 13 AND `CountryContent`.`resource_country_id` = (114) | 1 | 1 | 2 | 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('114',`Store`.`deliver_to_countries`) AND `Store`.`status` = '1' ORDER BY `Store`.`store_name` asc | 18 | 18 | 2 | 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` = 114 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` = 13 AND `CountryContent`.`resource_country_id` = (114) | 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 | 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` = 13 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) | 188 | 188 | 4 | |
| 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`.`localization_id` = 13 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 | 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` = 13 AND `CategoryContent`.`category_id` IN (3171, 3488, 5693, 1395, 7573) | 8 | 8 | 2 | 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 | 1 | |
| 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 (13, 1) AND `StaticPageContent`.`static_page_id` = (9) | 4 | 4 | 19 | 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 (13, 1) AND `StaticPageContent`.`static_page_id` = (5) | 4 | 4 | 4 | |
| 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 (13, 1) AND `StaticPageContent`.`static_page_id` = (6) | 4 | 4 | 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` FROM `mrkochar`.`resource_countries` AS `ResourceCountry` WHERE `ResourceCountry`.`name` = 'Korea, South' LIMIT 1 | 1 | 1 | 0 | |
| 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` = 13 AND `CountryContent`.`resource_country_id` = (114) | 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('114',`Store`.`deliver_to_countries`) AND `Store`.`status` = '1' ORDER BY `Store`.`store_name` asc | 18 | 18 | 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` = 13 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 | 9 | maybe slow |
₩ Won
한국어 / 조선말 (Korean) 
뉴스 레터 우리의 뉴스 레터에 가입하고 Sales & Offers를 절대 놓치지 마십시오! 
