| 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 | 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` = 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 | 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` = 51 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') <= 109 AND FROM_UNIXTIME(end_date,'%c%d') >= 109 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `UserGroup`.`slug` FROM `mrkochar`.`user_groups` AS `UserGroup` WHERE `UserGroup`.`allow_on_front` = 1 | 3 | 3 | 1 | 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 | 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`.`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 | 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 | 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` = '5a434cba3177e1398589153ca3dd50a3' AND `Visitor`.`visitor_api` = 'visitor' LIMIT 1 | 0 | 0 | 47 | 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:23:21 UTC\",\n \"cookieEnabled\": \"Disabled\",\n \"Cookie\": \"mkuid=69610f5b783498.18984332;timestamp=2026-01-09 14:23:21 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\",\"HTTP_COOKIE\":\"user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29; handl_url_base=https%3A%2F%2Ffreedompointefl.com%2Frobots.txt; handl_url=https%3A%2F%2Ffreedompointefl.com%2Frobots.txt; HandLtestDomainNameServer=HandLtestDomainValueServer; handl_landing_page=https%3A%2F%2Ffreedompointefl.com%2Frobots.txt; handl_ip=216.73.216.111\",\"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\":\"52334\",\"REDIRECT_URL\":\"\\/index.php\",\"GATEWAY_INTERFACE\":\"CGI\\/1.1\",\"SERVER_PROTOCOL\":\"HTTP\\/1.0\",\"REQUEST_METHOD\":\"GET\",\"QUERY_STRING\":\"\",\"REQUEST_URI\":\"\\/gb\\/brands\\/brand-listing\",\"SCRIPT_NAME\":\"\\/app\\/webroot\\/index.php\",\"PHP_SELF\":\"\\/app\\/webroot\\/index.php\",\"REQUEST_TIME_FLOAT\":1767968601.5411,\"REQUEST_TIME\":1767968601,\"REVERSE_DNS\":\"216.73.216.111\",\"RDNS\":[]}', 'Mozilla', '5.0', '216.73.216.111', 'GB', 1767968603, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/', '5a434cba3177e1398589153ca3dd50a3', 'Desktop', '', 0, 'Anonymous', 'Anonymous', 'https://mrkochar.stage3.demo321.com/=1767802007,https://mrkochar.stage3.demo321.com/gb/brands/brand-listing=1767968603', 'bots', 1767968603, 1767968603) | 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 | 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` = (5) | 1 | 1 | 1 | |
| SELECT `Language`.`id`, `Language`.`title` FROM `mrkochar`.`languages` AS `Language` WHERE `is_active` = '1' ORDER BY `is_default` DESC, `title` ASC | 25 | 25 | 0 | |
| SELECT `Brand`.`brand_name`, `Brand`.`slug`, `Brand`.`id` FROM `mrkochar`.`brands` AS `Brand` WHERE `status` = 1 AND `deleted` = 0 ORDER BY `brand_name` ASC | 2863 | 2863 | 83 | |
| SELECT `BrandContent`.`id`, `BrandContent`.`brand_id`, `BrandContent`.`language_id`, `BrandContent`.`field_name`, `BrandContent`.`field_value`, `BrandContent`.`created`, `BrandContent`.`modified` FROM `mrkochar`.`brand_contents` AS `BrandContent` WHERE `BrandContent`.`brand_id` IN (10096, 10163, 10175, 12825, 11182, 488, 174, 11018, 2115, 127, 9758, 430, 9392, 8663, 13005, 115, 9467, 12115, 9981, 204, 2167, 10538, 317, 332, 256, 1607, 7650, 9116, 205, 810, 9337, 347, 9969, 510, 847, 7344, 1985, 1977, 11815, 590, 200, 2194, 2233, 1912, 633, 10170, 422, 3664, 778, 10089, 7045, 9115, 412, 13052, 3457, 9407, 8759, 177, 777, 12412, 12675, 10176, 342, 2008, 381, 147, 2353, 10099, 10329, 3504, 321, 9452, 9533, 2211, 2307, 13512, 9384, 9944, 10134, 12757, 853, 9428, 9367, 12749, 7728, 97, 11102, 194, 568, 871, 9945, 10177, 110, 12699, 639, 9266, 8039, 223, 8036, 2901, 11235, 1579, 757, 10823, 13643, 1535, 11821, 10792, 206, 8776, 10550, 703, 1931, 2058, 343, 2244, 13261, 1866, 12989, 10751, 9476, 12559, 9113, 1641, 894, 9756, 2354, 13511, 12940, 2352, 9258, 569, 10846, 13706, 13711, 971, 252, 1987, 9775, 8040, 12728, 462, 9486, 13263, 9805, 7776, 6423, 1638, 11646, 1774, 1567, 10087, 1602, 8934, 7072, 10689, 783, 2309, 2357, 12894, 10563, 9463, 11206, 895, 11053, 619, 668, 10910, 9040, 1887, 7683, 138, 575, 1014, 1643, 7578, 1776, 1902, 1707, 5823, 149, 10699, 2247, 12528, 1671, 10562, 833, 9911, 9786, 592, 9043, 9368, 108, 643, 12815, 9957, 153, 10835, 324, 12281, 10595, 4148, 2311, 10366, 9813, 8941, 9764, 11285, 12972, 2853, 12936, 11228, 10613, 2260, 12021, 2312, 2308, 13548, 2567, 11309, 11127, 8481, 2355, 11316, 11187, 2198, 2015, 10611, 7997, 2035, 56, 360, 11341, 10252, 11402, 2289, 11154, 31, 11153, 2087, 549, 11447, 9594, 11751, 107, 329, 45, 10103, 602, 7804, 7689, 8020, 8171, 402, 8025, 7968, 7970, 7966, 8002, 1963, 8877, 11502, 9434, 242, 8110, 10826, 9497, 551, 8107, 13819, 2243, 11418, 374, 13308, 1809, 1682, 13100, 1886, 716, 8983, 9747, 10230, 9010, 339, 10171, 11287, 11516, 5192, 8408, 9250, 11193, 356, 8054, 10372, 9297, 11395, 12474, 181, 8050, 10629, 9675, 1844, 2249, 8912, 11420, 2263, 1584, 10798, 9123, 12968, 9542, 1972, 9345, 2534, 10146, 10247, 9765, 10090, 3916, 8907, 202, 2302, 536, 11515, 1544, 1061, 9139, 8081, 10466, 442, 548, 2030, 1997, 10722, 2320, 10903, 9934, 113, 12884, 12411, 214, 9749, 10619, 1969, 11644, 11626, 11253, 96, 546, 1665, 11354, 10841, 1960, 1491, 2010, 8667, 7673, 10141, 8924, 8677, 1801, 9468, 8956, 12306, 10729, 563, 10359, 8676, 12613, 9433, 12616, 768, 244, 265, 268, 12604, 9918, 7019, 10855, 2564, 2299, 12468, 103, 1509, 890, 1516, 603, 102, 2717, 220, 11567, 13015, 10753, 7763, 9281, 12649, 2202, 233, 1782, 10815, 1007, 1713, 576, 9948, 1658, 1642, 9256, 12750, 7292, 10050, 12695, 178, 10370, 10168, 1971, 10956, 7714, 143, 9534, 2129, 9748, 11539, 9050, 260, 9132, 7821, 8532, 10708, 10696, 10762, 50, 3762, 3207, 10297, 11185, 295, 2125, 562, 7687, 802, 9003, 1900, 1047, 13446, 9372, 12705, 4517, 10074, 13116, 9165, 838, 1651, 1837, 355, 8321, 9112, 11112, 10392, 1978, 1603, 11267, 3, 285, 169, 9808, 2011, 10720, 12781, 6699, 8962, 12556, 13550, 7992, 10492, 9, 10181, 8689, 7792, 10308, 1874, 9339, 349, 11560, 12454, 559, 12753, 1623, 700, 9371, 207, 8994, 577, 10360, 10675, 596, 7079, 930, 10999, 13540, 13822, 287, 11664, 11343, 10222, 85, 8961, 8533, 822, 1087, 636, 880, 761, 508, 745, 1790, 10091, 11148, 1736, 9794, 10590, 588, 1908, 189, 294, 12350, 11388, 8314, 1728, 6936, 8883, 585, 2264, 933, 1582, 908, 327, 1872, 10587, 7056, 2313, 1791, 842, 573, 12643, 9294, 1593, 832, 1002, 925, 8418, 7649, 11570, 734, 2134, 11274, 1048, 9487, 10160, 11290, 10932, 9313, 9972, 784, 10698, 1037, 11120, 9119, 798, 9777, 2145, 8221, 2286, 12654, 10262, 793, 815, 11788, 10430, 123, 12328, 11653, 8703, 137, 11592, 10834, 8965, 9964, 8973, 8366, 512, 409, 936, 437, 935, 9505, 7748, 12469, 11385, 55, 2214, 11263, 673, 483, 7835, 1920, 433, 10848, 172, 13852, 2275, 498, 11408, 183, 479, 942, 1648, 8679, 13374, 8527, 2140, 781, 9390, 1714, 9525, 987, 11387, 10604, 729, 9141, 7749, 9129, 258, 1861, 10462, 88, 11451, 9885, 554, 1552, 10182, 8986, 12769, 9849, 10552, 2181, 10245, 11126, 8100, 9438, 11663, 678, 1652, 7054, 1794, 11036, 1060, 709, 11366, 10197, 635, 12702, 10157, 10603, 9303, 7678, 663, 648, 11215, 7684, 8949, 10828, 2332, 1029, 694, 11719, 1719, 1751, 11435, 8589, 9417, 382, 370, 9255, 9432, 185, 7697, 13016, 10917, 8177, 10596, 10778, 10069, 749, 11161, 10484, 813, 14, 12659, 9514, 164, 391, 7775, 2339, 561, 553, 786, 7350, 11694, 13385, 8968, 11211, 2757, 276, 10944, 1965, 274, 9188, 8095, 11002, 7592, 11226, 257, 12622, 717, 13054, 10107, 9328, 354, 13734, 9282, 9403, 11179, 9521, 13701, 7825, 7141, 9500, 11237, 8198, 11443, 8411, 9405, 10651, 398, 2294, 159, 9098, 11786, 9842, 8001, 1944, 13552, 12704, 8170, 457, 9424, 10927, 9057, 2126, 11960, 501, 10821, 1769, 10862, 613, 9427, 9523, 8010, 672, 8981, 8881, 404, 32, 1513, 11111, 10, 11240, 7626, 10432, 9870, 13338, 267, 623, 9550, 2020, 8084, 964, 348, 82, 193, 8417, 11310, 215, 7051, 7816, 9236, 128, 277, 11365, 3071, 7978, 235, 11566, 12748, 1731, 37, 472, 11298, 11540, 9052, 10775, 9472, 1609, 469, 12694, 874, 303, 10609, 618, 9331, 12460, 13275, 10813, 9370, 157, 7219, 39, 13507, 1726, 12655, 11353, 769, 7128, 1523, 11532, 10518, 474, 10427, 133, 541, 7632, 2356, 7067, 10773, 1136, 814, 792, 11292, 9133, 11778, 8181, 12485, 1744, 403, 11265, 10367, 10916, 519, 10594, 1557, 12527, 8045, 8932, 803, 7345, 9336, 525, 756, 7696, 7870, 9459, 8876, 2292, 9409, 9554, 156, 9030, 10331, 10623, 10867, 7675, 10697, 428, 8005, 9247, 9986, 11305, 11022, 8343, 11236, 5293, 10769, 1681, 2059, 10078, 8738, 11525, 10749, 9248, 503, 11594, 11138, 9187, 269, 7920, 2019, 9898, 11438, 518, 2207, 2266, 10921, 463, 9454, 9253, 7879, 7795, 7700, 10925, 9411, 9333, 2216, 2334, 1901, 11303, 11132, 1906, 10045, 148, 8041, 1533, 11192, 10730, 945, 10095, 1691, 2232, 2231, 1617, 441, 13867, 7975, 591, 1498, 11314, 17, 9787, 1893, 7995, 10977, 841, 1656, 13866, 175, 628, 7090, 3963, 11521, 982, 7980, 431, 10837, 11792, 10482, 11334, 9443, 9978, 7890, 11436, 11794, 12599, 11008, 12480, 12052, 2083, 9767, 1884, 2071, 8814, 12681, 8173, 340, 1027, 10516, 10085, 7593, 2706, 87, 191, 2287, 6916, 2267, 2268, 7716, 9946, 13271, 9752, 302, 2269, 9332, 8161, 10650, 1045, 1576, 12827, 33, 651, 683, 7642, 12911, 11382, 152, 7918, 9354, 9916, 104, 154, 7159, 11295, 12988, 423, 12761, 5014, 11693, 8911, 11720, 9471, 8057, 10067, 11031, 8784, 12249, 13364, 2127, 1897, 12647, 1914, 66, 8659, 13248, 721, 2702, 5134, 1743, 2149, 10909, 9204, 13115, 98, 774, 8320, 13359, 8374, 9231, 240, 631, 10253, 8086, 10939, 2179, 10869, 8003, 460, 2293, 390, 11809, 919, 10249, 10190, 2755, 7354, 3068, 7651, 707, 826, 13538, 11421, 365, 509, 12869, 13334, 497, 2094, 11661, 7559, 529, 11726, 13114, 2158, 10040, 1610, 238, 8940, 2016, 1583, 9122, 7655, 667, 10186, 11175, 8982, 22, 13321, 7796, 9070, 1919, 3451, 109, 11024, 2099, 10824, 8004, 10452, 11045, 1604, 771, 5996, 2110, 10581, 7846, 1548, 16, 7919, 528, 11374, 8313, 13461, 11166, 2219, 2217, 10281, 8415, 10556, 8890, 8684, 11199, 12996, 11732, 726, 11789, 11029, 1076, 12477, 7681, 1812, 9327, 46, 10968, 9309, 1982, 10597, 3012, 121, 9042, 12696, 9548, 927, 8402, 9177, 9464, 12247, 13547, 2296, 9778, 3674, 12739, 1600, 173, 10047, 9854, 13258, 680, 564, 1770, 9860, 10868, 980, 522, 11258, 2335, 9193, 9865, 4248, 1052, 10535, 1910, 9754, 823, 724, 629, 12459, 10734, 7743, 352, 10305, 1871, 7803, 12782, 11320, 10756, 9968, 291, 9326, 9320, 11505, 124, 8032, 406, 998, 2159, 1539, 3197, 105, 1507, 11317, 11641, 493, 1077, 11198, 13612, 486, 10076, 9143, 8048, 923, 11346, 9224, 571, 943, 2076, 8055, 9473, 656, 2709, 2021, 225, 1804, 13527, 10035, 10583, 11467, 396, 735, 9124, 1618, 10172, 12519, 10240, 1042, 2786, 878, 9493, 249, 959, 692, 9423, 228, 13713, 7935, 2221, 9285, 9093, 2162, 383, 100, 13579, 1596, 10068, 773, 10377, 10346, 13774, 1016, 9199, 2045, 10997, 11068, 447, 2341, 531, 9524, 2716, 765, 8612, 464, 12561, 10958, 407, 10987, 2186, 21, 40, 353, 10187, 1030, 9369, 3182, 10598, 9453, 2040, 1640, 598, 1024, 377, 11538, 9067, 9956, 345, 11586, 948, 9064, 11242, 12632, 669, 610, 650, 2252, 2046, 70, 2241, 10185, 1645, 731, 8504, 11604, 1959, 371, 322, 9169, 13632, 8114, 13179, 10061, 2037, 10907, 675, 1716, 11150, 8043, 849, 9352, 11113, 11468, 899, 1063, 9288, 68, 866, 7613, 1677, 9235, 9547, 264, 10781, 593, 1051, 12969, 10435, 1546, 1495, 10919, 846, 10106, 79, 1877, 2160, 9383, 2631, 645, 9017, 9412, 10259, 222, 12697, 1831, 10086, 2165, 10745, 779, 13845, 1690, 759, 12475, 11289, 873, 9225, 696, 13848, 681, 239, 1738, 452, 11531, 11548, 145, 10668, 674, 8637, 196, 10147, 1620, 7664, 13309, 916, 13627, 13428, 11225, 653, 708, 1957, 557, 132, 10093, 2229, 44, 1489, 533, 2271, 9448, 11190, 81, 10842, 8957, 741, 10568, 818, 24, 797, 344, 9283, 12630, 10951, 293, 7991, 161, 51, 844, 1497, 1720, 1869, 1629, 10261, 12813, 1499, 763, 2343, 2272, 7102, 9621, 144, 9402, 308, 10739, 2239, 764, 9293, 11140, 13699, 10785, 7880, 730, 776, 10219, 12710, 526, 2265, 9520, 1943, 11431, 13825, 10863, 13112, 1706, 1683, 61, 10586, 10584, 10898, 1573, 12621, 2270, 817, 13380, 9896, 10546, 10661, 9815, 612, 626, 9839, 491, 8767, 7662, 1527, 1065, 280, 91, 250, 7824, 7726, 2273, 9344, 10158, 1847, 13256, 1023, 1979, 10747, 284, 1976, 9466, 1815, 2223, 671, 691, 8109, 12738, 2345, 9286, 572, 607, 12360, 10727, 954, 10605, 11627, 9391, 4045, 10782, 10431, 13180, 11697, 2224, 9172, 7957, 1028, 9289, 11311, 13059, 928, 10312, 473, 8616, 10140, 387, 13383, 1624, 7799, 926, 614, 9831, 11100, 10228, 1049, 10406, 9047, 11359, 1608, 10717, 7969, 8093, 889, 10388, 2648, 158, 13778, 1680, 10606, 7760, 167, 12269, 12512, 12973, 7858, 8028, 7693, 11204, 11110, 11327, 134, 2274, 8021, 11377, 11372, 397, 862, 12656, 247, 972, 12600, 11528, 477, 9356, 410, 1821, 1951, 11038, 13170, 11331, 11276, 1710, 10059, 9881, 10100, 739, 11503, 9418, 119, 7989, 1543, 1149, 10339, 11577, 647, 9546, 9456, 12763, 7063, 13561, 6597, 8538, 13628, 12893, 1981, 11793, 565, 8536, 10313, 1526, 34, 170, 10119, 10820, 11144, 369, 10827, 10714, 9162, 11312, 10155, 11131, 415, 989, 1612, 386, 654, 12627, 9410, 10680, 9429, 527, 12522, 11596, 8799, 12648, 10585, 10889, 740, 13246, 7647, 10497, 695, 2258, 10625, 30, 820, 1698, 1667, 608, 9114, 11337, 638, 10964, 208, 11078, 8514, 7972, 733, 9272, 12607, 7258, 310, 8058, 2303, 992, 11803, 9833, 10051, 12677, 8017, 1578, 1553, 10286, 1936, 854, 8530, 7738, 58, 12628, 10970, 10174, 9967, 25, 12463, 2060, 378, 9851, 10856, 1702, 676, 8666, 10525, 10718, 1530, 1041, 595, 1980, 13, 9164, 11424, 7657, 7698, 2151, 4471, 1755, 8921, 10822, 10626, 10599, 171, 7973, 902, 2333, 659, 92, 12574, 125, 62, 76, 11122, 10200, 8668, 932, 11360, 1876, 699, 2969, 1670, 10901, 1354, 1654, 670, 11493, 2240, 7752, 10026, 53, 246, 517, 13113, 388, 292, 1995, 2981, 8312, 8636, 8052, 8963, 12999, 47, 10934, 10657, 1064, 13362, 8452, 11470, 10290, 10817, 7987, 168, 835, 15, 1781, 570, 1657, 657, 1364, 898, 8500, 2226, 1854, 8894, 760, 8670, 12975, 210, 9397, 9966, 10306, 641, 10631, 305, 231, 10980, 114, 10789, 875, 2109, 401, 2225, 600, 7735, 10677, 59, 2864, 1686, 454, 427, 385, 1581, 9484, 701, 9846, 13025, 11760, 9819, 234, 12461, 9232, 8175, 9770, 719, 11466, 12856, 10487, 13023, 604, 2227, 11471, 8196, 11549, 1888, 373, 524, 1574, 8361, 2259, 601, 10895, 325, 10746, 13476, 8014, 338, 791, 11213, 11568, 11601, 2006, 1008, 1718, 500, 7068, 12511, 834, 12971, 720, 2346, 10879, 13559, 1057, 12691, 11747, 12780, 630, 969, 9242, 2024, 13346, 7817, 9457, 11203, 11114, 9364, 11479, 11602, 8119, 304, 578, 11345, 10946, 947, 10804, 1352, 11630, 7828, 12924, 2574, 689, 867, 9506, 8230, 13111, 13830, 705, 7679, 10131, 10489, 361, 9018, 10941, 7676, 13389, 7823, 7108, 7674, 9357, 6, 7712, 2337, 12458, 12882, 7705, 1838, 11742, 6737, 8120, 9252, 10897, 12819, 13375, 11801, 10610, 7998, 253, 795, 10403, 10929, 8966, 8007, 2064, 11037, 1070, 1889, 9531, 12490, 9785, 723, 2228, 11296, 8695, 556, 10602, 13856, 10670, 1693, 870, 13046, 7950, 11189, 9082, 18, 911, 507, 11580, 9477, 67, 11169, 12876, 7905, 11042, 2359, 2114, 459, 12900, 7049, 7653, 2323, 7033, 69, 1575, 7734, 346, 860, 1015, 1071, 1570, 7652, 8345, 1440, 3238, 8674, 1953, 10844, 10053, 2230, 476, 8879, 11108, 2715, 458, 362, 9400, 13339, 12535, 9532, 10555, 8117, 9416, 12641, 11397, 2147, 1633, 11302, 9830, 11456, 9499, 236, 359, 9347, 9329, 8870, 12514, 8737, 12457, 2310, 8012, 574, 10852, 12703, 106, 241, 617, 685, 9970, 10654, 10334, 1773, 586, 1999, 2370, 10723, 1725, 5543, 9031, 780, 10153, 10715, 2371, 7046, 5263, 555, 380, 375, 852, 11496, 266, 9035, 9422, 2347, 2218, 1586, 10643, 1864, 646, 1009, 9358, 1044, 299, 1660, 1756, 12684, 2277, 582, 9959, 8458, 288, 13563, 2248, 10622, 2222, 7646, 2002, 2288, 11281, 9375, 9772, 7729, 3698, 367, 11328, 11416, 9254, 9058, 9108, 6058, 9549, 11212, 180, 421, 7680, 697, 2367, 1637, 545, 9436, 984, 900, 8884, 333, 120, 8078, 13252, 2246, 10761, 7952, 10269, 8030, 11248, 11569, 203, 9264, 11286, 11280, 7822, 10424, 9161, 341, 859, 424, 7984, 2138, 8069, 12992, 9200, 10777, 1779, 229, 111, 9176, 11123, 3977, 13846, 11807, 10543, 1947, 3322, 2004, 831, 9021, 57, 8655, 11324, 892, 8035, 1490, 10702, 9761, 11162, 12751, 11386, 162, 10237, 6981, 444, 416, 7842, 12903, 10713, 112, 9100, 10728, 116, 9269, 11690, 12562, 335, 1857, 977, 10731, 552, 2348, 858, 10244, 10738, 10957, 2326, 420, 306, 8274, 11239, 12709, 974, 320, 9526, 13377, 1967, 941, 10839, 5116, 1788, 29, 12426, 1541, 9341, 580, 10649, 5117, 11472, 7270, 1589, 9868, 1700, 12828, 118, 9431, 495, 10438, 1636, 9325, 8855, 12737, 9097, 2153, 13817, 2278, 9189, 581, 453, 13048, 9234, 10215, 11044, 5, 642, 9491, 12742, 11494, 9537, 2279, 8389, 38, 10857, 762, 12389, 13026, 1661, 8188, 10455, 323, 857, 2325, 1058, 652, 12912, 10220, 7788, 9311, 13618, 1625, 1580, 1053, 9951, 8690, 8683, 2049, 10763, 11739, 2825, 237, 1601, 1619, 7530, 1709, 7862, 9271, 129, 10972, 13414, 13249, 10345, 7290, 9056, 10123, 13220, 93, 9755, 10779, 328, 419, 851, 1839, 9342, 131, 1, 8960, 99, 8952, 11783, 9316, 1983, 10996, 130, 11007, 9401, 11433, 1564, 1033, 12651, 1650, 11529, 1708, 13800, 1924, 9278, 7558, 10621, 2080, 8869, 184, 12567, 973, 10607, 10672, 1561, 1988, 13416, 12644, 9529, 286, 11779, 9346, 1664, 12740, 1740, 1644, 738, 1733, 583, 7580, 2117, 12626, 9971, 8398, 9268, 12329, 12978, 8113, 221, 1515, 10922, 10982, 7725, 12239, 9469, 1942, 7575, 594, 13435, 13370, 5022, 9762, 10104, 843, 27, 599, 11230, 1950, 2178, 163, 804, 2328, 43, 1606, 1054, 8701, 9515, 9261, 8015, 11795, 9535, 12624, 1615, 11137, 139, 12636, 1649, 11344, 9941, 800, 13551, 8101, 1075, 821, 1895, 7713, 10224, 502, 13341, 10992, 7658, 1753, 9145, 9084, 11619, 10933, 8704, 7793, 492, 11750, 11064, 8, 12548, 9470, 7645, 912, 13702, 13803, 11348, 1563, 9214, 8238, 10991, 2123, 439, 1630, 587, 12467, 1521, 12767, 230, 414, 11500, 13102, 10567, 589, 1984, 9085, 389, 1903, 11012, 10399, 1993, 13829, 11032, 516, 1758, 2018, 2899, 2304, 11074, 199, 12756, 2009, 9110, 141, 10265, 7137, 8046, 2183, 9121, 624, 5694, 4827, 1568, 484, 10445, 1662, 12918, 2327, 732, 10162, 9475, 351, 789, 13371, 8772, 2708, 2014, 2102, 9300, 9952, 10558, 54, 262, 2201, 7967, 1565, 255, 9551, 408, 830, 566, 12680, 9746, 2122, 48, 11432, 877, 10812, 11564, 9458, 11257, 467, 11279, 451, 12657, 1020, 11291, 2090, 12964, 11867, 558, 539, 2106, 2047, 825, 5380, 532, 11488, 1818, 11335, 192, 1080, 10374, 2143, 632, 10887, 212, 10156, 929, 9243, 597, 300, 1759, 10701, 9365, 9378, 11323, 2033, 1672, 368, 2000, 10780, 827, 366, 1512, 261, 10126, 10408, 706, 10711, 2369, 9818, 10188, 11186, 11155, 11722, 7659, 9273, 2317, 9249, 10981, 13367, 682, 10364, 279, 931, 326, 8257, 938, 2203, 2280, 9260, 13862, 8331, 9938, 10854, 187, 9363, 12486, 5903, 9861, 400, 11205, 775, 2062, 8016, 13831, 12926, 135, 11805, 5668, 8325, 13382, 312, 318, 891, 11358, 1067, 9425, 12465, 8603, 13704, 11517, 9208, 41, 9975, 232, 7971, 2350, 13865, 7711, 1502, 1786, 151, 146, 2068, 13698, 10293, 9685, 863, 772, 13343, 393, 3305, 4396, 10936, 11054, 1536, 9451, 8061, 11507, 12558, 11723, 2306, 28, 7913, 1881, 1659, 1595, 4765, 13455, 11351, 12455, 10521, 13196, 9807, 1723, 2130, 12517, 13700, 11376, 330, 11163, 805, 13330, 1669, 77, 11060, 1970, 2116, 11001, 2349, 1701, 126, 13126, 10289, 8885, 9312, 11208, 11717, 9107, 584, 10088, 13344, 9980, 8899, 9783, 7671, 11135, 281, 1371, 1885, 8294, 11355, 270, 4046, 9340, 616, 1998, 8882, 136, 1004, 190, 13855, 10079, 7902, 819, 11129, 9814, 999, 10928, 1540, 13301, 2128, 198, 693, 12617, 13466, 2119, 10302, 990, 718, 2209, 211, 7753, 8388, 155, 160, 392, 2351, 4078, 2630, 2171, 9450, 684, 8887, 9498, 1566, 606, 2282, 9797, 480, 1622, 727, 10291, 812, 271, 2257, 7755, 1569, 197, 78, 7283, 1062, 9205, 1966, 1789, 9804, 13253, 10858, 2301, 13615, 9853, 13465, 11224, 11768, 7692, 7773, 9763, 2242, 8053, 8183, 11201, 12, 12708, 12890, 11634, 2330, 1628, 7694, 1822, 520, 455, 1587, 11368, 9791, 140, 11448, 934, 770, 11282, 13536, 10989, 9051, 2254, 1572, 399, 8031, 1697, 7808, 949, 9153, 12453, 1524, 10572, 11575, 9696, 2023, 7667, 994, 10912, 1036, 7787, 10183, 478, 1013, 2088, 704, 1696, 514, 2187, 405, 9962, 10542, 12722, 7921, 2101, 856, 11541, 13109, 10257, 11318, 188, 2298, 13820, 10659, 12615, 11600, 9221, 10024, 882, 1081, 9036, 13710, 10178, 11191, 1699, 790, 924, 417, 150, 893, 485, 2250, 9216, 8187, 481, 10893, 13011, 2173, 379, 1059, 10888, 11491, 282, 662, 11748, 9478, 9973, 2001, 1585) | 0 | 0 | 33 | 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 `parent_id` = 0 AND `verticals` = 1 AND `deleted` = 0 AND `status` = 1 ORDER BY `category_position` asc | 5 | 5 | 4 | 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 | 1 | maybe slow |
| SELECT `Brand`.`id`, `Brand`.`brand_name`, `Brand`.`store_id`, `Brand`.`image`, `Brand`.`slug`, `Brand`.`meta_keywords`, `Brand`.`meta_description`, `Brand`.`status`, `Brand`.`deleted`, `Brand`.`created_by`, `Brand`.`created_via`, `Brand`.`status_update`, `Brand`.`created`, `Brand`.`modified` FROM `mrkochar`.`brands` AS `Brand` WHERE `Brand`.`status` = 1 AND `Brand`.`deleted` = 0 | 2863 | 2863 | 41 | |
| SELECT `BrandContent`.`id`, `BrandContent`.`brand_id`, `BrandContent`.`language_id`, `BrandContent`.`field_name`, `BrandContent`.`field_value`, `BrandContent`.`created`, `BrandContent`.`modified` FROM `mrkochar`.`brand_contents` AS `BrandContent` WHERE `BrandContent`.`brand_id` IN (1, 3, 5, 6, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 21, 22, 24, 25, 27, 28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 41, 43, 44, 45, 46, 47, 48, 50, 51, 53, 54, 55, 56, 57, 58, 59, 61, 62, 66, 67, 68, 69, 70, 76, 77, 78, 79, 81, 82, 85, 87, 88, 91, 92, 93, 96, 97, 98, 99, 100, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 118, 119, 120, 121, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 167, 168, 169, 170, 171, 172, 173, 174, 175, 177, 178, 180, 181, 183, 184, 185, 187, 188, 189, 190, 191, 192, 193, 194, 196, 197, 198, 199, 200, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 214, 215, 220, 221, 222, 223, 225, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 244, 246, 247, 249, 250, 252, 253, 255, 256, 257, 258, 260, 261, 262, 264, 265, 266, 267, 268, 269, 270, 271, 274, 276, 277, 279, 280, 281, 282, 284, 285, 286, 287, 288, 291, 292, 293, 294, 295, 299, 300, 302, 303, 304, 305, 306, 308, 310, 312, 317, 318, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 332, 333, 335, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 351, 352, 353, 354, 355, 356, 359, 360, 361, 362, 365, 366, 367, 368, 369, 370, 371, 373, 374, 375, 377, 378, 379, 380, 381, 382, 383, 385, 386, 387, 388, 389, 390, 391, 392, 393, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 412, 414, 415, 416, 417, 419, 420, 421, 422, 423, 424, 427, 428, 430, 431, 433, 437, 439, 441, 442, 444, 447, 451, 452, 453, 454, 455, 457, 458, 459, 460, 462, 463, 464, 467, 469, 472, 473, 474, 476, 477, 478, 479, 480, 481, 483, 484, 485, 486, 488, 491, 492, 493, 495, 497, 498, 500, 501, 502, 503, 507, 508, 509, 510, 512, 514, 516, 517, 518, 519, 520, 522, 524, 525, 526, 527, 528, 529, 531, 532, 533, 536, 539, 541, 545, 546, 548, 549, 551, 552, 553, 554, 555, 556, 557, 558, 559, 561, 562, 563, 564, 565, 566, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 606, 607, 608, 610, 612, 613, 614, 616, 617, 618, 619, 623, 624, 626, 628, 629, 630, 631, 632, 633, 635, 636, 638, 639, 641, 642, 643, 645, 646, 647, 648, 650, 651, 652, 653, 654, 656, 657, 659, 662, 663, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 678, 680, 681, 682, 683, 684, 685, 689, 691, 692, 693, 694, 695, 696, 697, 699, 700, 701, 703, 704, 705, 706, 707, 708, 709, 716, 717, 718, 719, 720, 721, 723, 724, 726, 727, 729, 730, 731, 732, 733, 734, 735, 738, 739, 740, 741, 745, 749, 756, 757, 759, 760, 761, 762, 763, 764, 765, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 783, 784, 786, 789, 790, 791, 792, 793, 795, 797, 798, 800, 802, 803, 804, 805, 810, 812, 813, 814, 815, 817, 818, 819, 820, 821, 822, 823, 825, 826, 827, 830, 831, 832, 833, 834, 835, 838, 841, 842, 843, 844, 846, 847, 849, 851, 852, 853, 854, 856, 857, 858, 859, 860, 862, 863, 866, 867, 870, 871, 873, 874, 875, 877, 878, 880, 882, 889, 890, 891, 892, 893, 894, 895, 898, 899, 900, 902, 908, 911, 912, 916, 919, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 938, 941, 942, 943, 945, 947, 948, 949, 954, 959, 964, 969, 971, 972, 973, 974, 977, 980, 982, 984, 987, 989, 990, 992, 994, 998, 999, 1002, 1004, 1007, 1008, 1009, 1013, 1014, 1015, 1016, 1020, 1023, 1024, 1027, 1028, 1029, 1030, 1033, 1036, 1037, 1041, 1042, 1044, 1045, 1047, 1048, 1049, 1051, 1052, 1053, 1054, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1067, 1070, 1071, 1075, 1076, 1077, 1080, 1081, 1087, 1136, 1149, 1352, 1354, 1364, 1371, 1440, 1489, 1490, 1491, 1495, 1497, 1498, 1499, 1502, 1507, 1509, 1512, 1513, 1515, 1516, 1521, 1523, 1524, 1526, 1527, 1530, 1533, 1535, 1536, 1539, 1540, 1541, 1543, 1544, 1546, 1548, 1552, 1553, 1557, 1561, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1572, 1573, 1574, 1575, 1576, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1587, 1589, 1593, 1595, 1596, 1600, 1601, 1602, 1603, 1604, 1606, 1607, 1608, 1609, 1610, 1612, 1615, 1617, 1618, 1619, 1620, 1622, 1623, 1624, 1625, 1628, 1629, 1630, 1633, 1636, 1637, 1638, 1640, 1641, 1642, 1643, 1644, 1645, 1648, 1649, 1650, 1651, 1652, 1654, 1656, 1657, 1658, 1659, 1660, 1661, 1662, 1664, 1665, 1667, 1669, 1670, 1671, 1672, 1677, 1680, 1681, 1682, 1683, 1686, 1690, 1691, 1693, 1696, 1697, 1698, 1699, 1700, 1701, 1702, 1706, 1707, 1708, 1709, 1710, 1713, 1714, 1716, 1718, 1719, 1720, 1723, 1725, 1726, 1728, 1731, 1733, 1736, 1738, 1740, 1743, 1744, 1751, 1753, 1755, 1756, 1758, 1759, 1769, 1770, 1773, 1774, 1776, 1779, 1781, 1782, 1786, 1788, 1789, 1790, 1791, 1794, 1801, 1804, 1809, 1812, 1815, 1818, 1821, 1822, 1831, 1837, 1838, 1839, 1844, 1847, 1854, 1857, 1861, 1864, 1866, 1869, 1871, 1872, 1874, 1876, 1877, 1881, 1884, 1885, 1886, 1887, 1888, 1889, 1893, 1895, 1897, 1900, 1901, 1902, 1903, 1906, 1908, 1910, 1912, 1914, 1919, 1920, 1924, 1931, 1936, 1942, 1943, 1944, 1947, 1950, 1951, 1953, 1957, 1959, 1960, 1963, 1965, 1966, 1967, 1969, 1970, 1971, 1972, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1987, 1988, 1993, 1995, 1997, 1998, 1999, 2000, 2001, 2002, 2004, 2006, 2008, 2009, 2010, 2011, 2014, 2015, 2016, 2018, 2019, 2020, 2021, 2023, 2024, 2030, 2033, 2035, 2037, 2040, 2045, 2046, 2047, 2049, 2058, 2059, 2060, 2062, 2064, 2068, 2071, 2076, 2080, 2083, 2087, 2088, 2090, 2094, 2099, 2101, 2102, 2106, 2109, 2110, 2114, 2115, 2116, 2117, 2119, 2122, 2123, 2125, 2126, 2127, 2128, 2129, 2130, 2134, 2138, 2140, 2143, 2145, 2147, 2149, 2151, 2153, 2158, 2159, 2160, 2162, 2165, 2167, 2171, 2173, 2178, 2179, 2181, 2183, 2186, 2187, 2194, 2198, 2201, 2202, 2203, 2207, 2209, 2211, 2214, 2216, 2217, 2218, 2219, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2239, 2240, 2241, 2242, 2243, 2244, 2246, 2247, 2248, 2249, 2250, 2252, 2254, 2257, 2258, 2259, 2260, 2263, 2264, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2277, 2278, 2279, 2280, 2282, 2286, 2287, 2288, 2289, 2292, 2293, 2294, 2296, 2298, 2299, 2301, 2302, 2303, 2304, 2306, 2307, 2308, 2309, 2310, 2311, 2312, 2313, 2317, 2320, 2323, 2325, 2326, 2327, 2328, 2330, 2332, 2333, 2334, 2335, 2337, 2339, 2341, 2343, 2345, 2346, 2347, 2348, 2349, 2350, 2351, 2352, 2353, 2354, 2355, 2356, 2357, 2359, 2367, 2369, 2370, 2371, 2534, 2564, 2567, 2574, 2630, 2631, 2648, 2702, 2706, 2708, 2709, 2715, 2716, 2717, 2755, 2757, 2786, 2825, 2853, 2864, 2899, 2901, 2969, 2981, 3012, 3068, 3071, 3182, 3197, 3207, 3238, 3305, 3322, 3451, 3457, 3504, 3664, 3674, 3698, 3762, 3916, 3963, 3977, 4045, 4046, 4078, 4148, 4248, 4396, 4471, 4517, 4765, 4827, 5014, 5022, 5116, 5117, 5134, 5192, 5263, 5293, 5380, 5543, 5668, 5694, 5823, 5903, 5996, 6058, 6423, 6597, 6699, 6737, 6916, 6936, 6981, 7019, 7033, 7045, 7046, 7049, 7051, 7054, 7056, 7063, 7067, 7068, 7072, 7079, 7090, 7102, 7108, 7128, 7137, 7141, 7159, 7219, 7258, 7270, 7283, 7290, 7292, 7344, 7345, 7350, 7354, 7530, 7558, 7559, 7575, 7578, 7580, 7592, 7593, 7613, 7626, 7632, 7642, 7645, 7646, 7647, 7649, 7650, 7651, 7652, 7653, 7655, 7657, 7658, 7659, 7662, 7664, 7667, 7671, 7673, 7674, 7675, 7676, 7678, 7679, 7680, 7681, 7683, 7684, 7687, 7689, 7692, 7693, 7694, 7696, 7697, 7698, 7700, 7705, 7711, 7712, 7713, 7714, 7716, 7725, 7726, 7728, 7729, 7734, 7735, 7738, 7743, 7748, 7749, 7752, 7753, 7755, 7760, 7763, 7773, 7775, 7776, 7787, 7788, 7792, 7793, 7795, 7796, 7799, 7803, 7804, 7808, 7816, 7817, 7821, 7822, 7823, 7824, 7825, 7828, 7835, 7842, 7846, 7858, 7862, 7870, 7879, 7880, 7890, 7902, 7905, 7913, 7918, 7919, 7920, 7921, 7935, 7950, 7952, 7957, 7966, 7967, 7968, 7969, 7970, 7971, 7972, 7973, 7975, 7978, 7980, 7984, 7987, 7989, 7991, 7992, 7995, 7997, 7998, 8001, 8002, 8003, 8004, 8005, 8007, 8010, 8012, 8014, 8015, 8016, 8017, 8020, 8021, 8025, 8028, 8030, 8031, 8032, 8035, 8036, 8039, 8040, 8041, 8043, 8045, 8046, 8048, 8050, 8052, 8053, 8054, 8055, 8057, 8058, 8061, 8069, 8078, 8081, 8084, 8086, 8093, 8095, 8100, 8101, 8107, 8109, 8110, 8113, 8114, 8117, 8119, 8120, 8161, 8170, 8171, 8173, 8175, 8177, 8181, 8183, 8187, 8188, 8196, 8198, 8221, 8230, 8238, 8257, 8274, 8294, 8312, 8313, 8314, 8320, 8321, 8325, 8331, 8343, 8345, 8361, 8366, 8374, 8388, 8389, 8398, 8402, 8408, 8411, 8415, 8417, 8418, 8452, 8458, 8481, 8500, 8504, 8514, 8527, 8530, 8532, 8533, 8536, 8538, 8589, 8603, 8612, 8616, 8636, 8637, 8655, 8659, 8663, 8666, 8667, 8668, 8670, 8674, 8676, 8677, 8679, 8683, 8684, 8689, 8690, 8695, 8701, 8703, 8704, 8737, 8738, 8759, 8767, 8772, 8776, 8784, 8799, 8814, 8855, 8869, 8870, 8876, 8877, 8879, 8881, 8882, 8883, 8884, 8885, 8887, 8890, 8894, 8899, 8907, 8911, 8912, 8921, 8924, 8932, 8934, 8940, 8941, 8949, 8952, 8956, 8957, 8960, 8961, 8962, 8963, 8965, 8966, 8968, 8973, 8981, 8982, 8983, 8986, 8994, 9003, 9010, 9017, 9018, 9021, 9030, 9031, 9035, 9036, 9040, 9042, 9043, 9047, 9050, 9051, 9052, 9056, 9057, 9058, 9064, 9067, 9070, 9082, 9084, 9085, 9093, 9097, 9098, 9100, 9107, 9108, 9110, 9112, 9113, 9114, 9115, 9116, 9119, 9121, 9122, 9123, 9124, 9129, 9132, 9133, 9139, 9141, 9143, 9145, 9153, 9161, 9162, 9164, 9165, 9169, 9172, 9176, 9177, 9187, 9188, 9189, 9193, 9199, 9200, 9204, 9205, 9208, 9214, 9216, 9221, 9224, 9225, 9231, 9232, 9234, 9235, 9236, 9242, 9243, 9247, 9248, 9249, 9250, 9252, 9253, 9254, 9255, 9256, 9258, 9260, 9261, 9264, 9266, 9268, 9269, 9271, 9272, 9273, 9278, 9281, 9282, 9283, 9285, 9286, 9288, 9289, 9293, 9294, 9297, 9300, 9303, 9309, 9311, 9312, 9313, 9316, 9320, 9325, 9326, 9327, 9328, 9329, 9331, 9332, 9333, 9336, 9337, 9339, 9340, 9341, 9342, 9344, 9345, 9346, 9347, 9352, 9354, 9356, 9357, 9358, 9363, 9364, 9365, 9367, 9368, 9369, 9370, 9371, 9372, 9375, 9378, 9383, 9384, 9390, 9391, 9392, 9397, 9400, 9401, 9402, 9403, 9405, 9407, 9409, 9410, 9411, 9412, 9416, 9417, 9418, 9422, 9423, 9424, 9425, 9427, 9428, 9429, 9431, 9432, 9433, 9434, 9436, 9438, 9443, 9448, 9450, 9451, 9452, 9453, 9454, 9456, 9457, 9458, 9459, 9463, 9464, 9466, 9467, 9468, 9469, 9470, 9471, 9472, 9473, 9475, 9476, 9477, 9478, 9484, 9486, 9487, 9491, 9493, 9497, 9498, 9499, 9500, 9505, 9506, 9514, 9515, 9520, 9521, 9523, 9524, 9525, 9526, 9529, 9531, 9532, 9533, 9534, 9535, 9537, 9542, 9546, 9547, 9548, 9549, 9550, 9551, 9554, 9594, 9621, 9675, 9685, 9696, 9746, 9747, 9748, 9749, 9752, 9754, 9755, 9756, 9758, 9761, 9762, 9763, 9764, 9765, 9767, 9770, 9772, 9775, 9777, 9778, 9783, 9785, 9786, 9787, 9791, 9794, 9797, 9804, 9805, 9807, 9808, 9813, 9814, 9815, 9818, 9819, 9830, 9831, 9833, 9839, 9842, 9846, 9849, 9851, 9853, 9854, 9860, 9861, 9865, 9868, 9870, 9881, 9885, 9896, 9898, 9911, 9916, 9918, 9934, 9938, 9941, 9944, 9945, 9946, 9948, 9951, 9952, 9956, 9957, 9959, 9962, 9964, 9966, 9967, 9968, 9969, 9970, 9971, 9972, 9973, 9975, 9978, 9980, 9981, 9986, 10024, 10026, 10035, 10040, 10045, 10047, 10050, 10051, 10053, 10059, 10061, 10067, 10068, 10069, 10074, 10076, 10078, 10079, 10085, 10086, 10087, 10088, 10089, 10090, 10091, 10093, 10095, 10096, 10099, 10100, 10103, 10104, 10106, 10107, 10119, 10123, 10126, 10131, 10134, 10140, 10141, 10146, 10147, 10153, 10155, 10156, 10157, 10158, 10160, 10162, 10163, 10168, 10170, 10171, 10172, 10174, 10175, 10176, 10177, 10178, 10181, 10182, 10183, 10185, 10186, 10187, 10188, 10190, 10197, 10200, 10215, 10219, 10220, 10222, 10224, 10228, 10230, 10237, 10240, 10244, 10245, 10247, 10249, 10252, 10253, 10257, 10259, 10261, 10262, 10265, 10269, 10281, 10286, 10289, 10290, 10291, 10293, 10297, 10302, 10305, 10306, 10308, 10312, 10313, 10329, 10331, 10334, 10339, 10345, 10346, 10359, 10360, 10364, 10366, 10367, 10370, 10372, 10374, 10377, 10388, 10392, 10399, 10403, 10406, 10408, 10424, 10427, 10430, 10431, 10432, 10435, 10438, 10445, 10452, 10455, 10462, 10466, 10482, 10484, 10487, 10489, 10492, 10497, 10516, 10518, 10521, 10525, 10535, 10538, 10542, 10543, 10546, 10550, 10552, 10555, 10556, 10558, 10562, 10563, 10567, 10568, 10572, 10581, 10583, 10584, 10585, 10586, 10587, 10590, 10594, 10595, 10596, 10597, 10598, 10599, 10602, 10603, 10604, 10605, 10606, 10607, 10609, 10610, 10611, 10613, 10619, 10621, 10622, 10623, 10625, 10626, 10629, 10631, 10643, 10649, 10650, 10651, 10654, 10657, 10659, 10661, 10668, 10670, 10672, 10675, 10677, 10680, 10689, 10696, 10697, 10698, 10699, 10701, 10702, 10708, 10711, 10713, 10714, 10715, 10717, 10718, 10720, 10722, 10723, 10727, 10728, 10729, 10730, 10731, 10734, 10738, 10739, 10745, 10746, 10747, 10749, 10751, 10753, 10756, 10761, 10762, 10763, 10769, 10773, 10775, 10777, 10778, 10779, 10780, 10781, 10782, 10785, 10789, 10792, 10798, 10804, 10812, 10813, 10815, 10817, 10820, 10821, 10822, 10823, 10824, 10826, 10827, 10828, 10834, 10835, 10837, 10839, 10841, 10842, 10844, 10846, 10848, 10852, 10854, 10855, 10856, 10857, 10858, 10862, 10863, 10867, 10868, 10869, 10879, 10887, 10888, 10889, 10893, 10895, 10897, 10898, 10901, 10903, 10907, 10909, 10910, 10912, 10916, 10917, 10919, 10921, 10922, 10925, 10927, 10928, 10929, 10932, 10933, 10934, 10936, 10939, 10941, 10944, 10946, 10951, 10956, 10957, 10958, 10964, 10968, 10970, 10972, 10977, 10980, 10981, 10982, 10987, 10989, 10991, 10992, 10996, 10997, 10999, 11001, 11002, 11007, 11008, 11012, 11018, 11022, 11024, 11029, 11031, 11032, 11036, 11037, 11038, 11042, 11044, 11045, 11053, 11054, 11060, 11064, 11068, 11074, 11078, 11100, 11102, 11108, 11110, 11111, 11112, 11113, 11114, 11120, 11122, 11123, 11126, 11127, 11129, 11131, 11132, 11135, 11137, 11138, 11140, 11144, 11148, 11150, 11153, 11154, 11155, 11161, 11162, 11163, 11166, 11169, 11175, 11179, 11182, 11185, 11186, 11187, 11189, 11190, 11191, 11192, 11193, 11198, 11199, 11201, 11203, 11204, 11205, 11206, 11208, 11211, 11212, 11213, 11215, 11224, 11225, 11226, 11228, 11230, 11235, 11236, 11237, 11239, 11240, 11242, 11248, 11253, 11257, 11258, 11263, 11265, 11267, 11274, 11276, 11279, 11280, 11281, 11282, 11285, 11286, 11287, 11289, 11290, 11291, 11292, 11295, 11296, 11298, 11302, 11303, 11305, 11309, 11310, 11311, 11312, 11314, 11316, 11317, 11318, 11320, 11323, 11324, 11327, 11328, 11331, 11334, 11335, 11337, 11341, 11343, 11344, 11345, 11346, 11348, 11351, 11353, 11354, 11355, 11358, 11359, 11360, 11365, 11366, 11368, 11372, 11374, 11376, 11377, 11382, 11385, 11386, 11387, 11388, 11395, 11397, 11402, 11408, 11416, 11418, 11420, 11421, 11424, 11431, 11432, 11433, 11435, 11436, 11438, 11443, 11447, 11448, 11451, 11456, 11466, 11467, 11468, 11470, 11471, 11472, 11479, 11488, 11491, 11493, 11494, 11496, 11500, 11502, 11503, 11505, 11507, 11515, 11516, 11517, 11521, 11525, 11528, 11529, 11531, 11532, 11538, 11539, 11540, 11541, 11548, 11549, 11560, 11564, 11566, 11567, 11568, 11569, 11570, 11575, 11577, 11580, 11586, 11592, 11594, 11596, 11600, 11601, 11602, 11604, 11619, 11626, 11627, 11630, 11634, 11641, 11644, 11646, 11653, 11661, 11663, 11664, 11690, 11693, 11694, 11697, 11717, 11719, 11720, 11722, 11723, 11726, 11732, 11739, 11742, 11747, 11748, 11750, 11751, 11760, 11768, 11778, 11779, 11783, 11786, 11788, 11789, 11792, 11793, 11794, 11795, 11801, 11803, 11805, 11807, 11809, 11815, 11821, 11867, 11960, 12021, 12052, 12115, 12239, 12247, 12249, 12269, 12281, 12306, 12328, 12329, 12350, 12360, 12389, 12411, 12412, 12426, 12453, 12454, 12455, 12457, 12458, 12459, 12460, 12461, 12463, 12465, 12467, 12468, 12469, 12474, 12475, 12477, 12480, 12485, 12486, 12490, 12511, 12512, 12514, 12517, 12519, 12522, 12527, 12528, 12535, 12548, 12556, 12558, 12559, 12561, 12562, 12567, 12574, 12599, 12600, 12604, 12607, 12613, 12615, 12616, 12617, 12621, 12622, 12624, 12626, 12627, 12628, 12630, 12632, 12636, 12641, 12643, 12644, 12647, 12648, 12649, 12651, 12654, 12655, 12656, 12657, 12659, 12675, 12677, 12680, 12681, 12684, 12691, 12694, 12695, 12696, 12697, 12699, 12702, 12703, 12704, 12705, 12708, 12709, 12710, 12722, 12728, 12737, 12738, 12739, 12740, 12742, 12748, 12749, 12750, 12751, 12753, 12756, 12757, 12761, 12763, 12767, 12769, 12780, 12781, 12782, 12813, 12815, 12819, 12825, 12827, 12828, 12856, 12869, 12876, 12882, 12884, 12890, 12893, 12894, 12900, 12903, 12911, 12912, 12918, 12924, 12926, 12936, 12940, 12964, 12968, 12969, 12971, 12972, 12973, 12975, 12978, 12988, 12989, 12992, 12996, 12999, 13005, 13011, 13015, 13016, 13023, 13025, 13026, 13046, 13048, 13052, 13054, 13059, 13100, 13102, 13109, 13111, 13112, 13113, 13114, 13115, 13116, 13126, 13170, 13179, 13180, 13196, 13220, 13246, 13248, 13249, 13252, 13253, 13256, 13258, 13261, 13263, 13271, 13275, 13301, 13308, 13309, 13321, 13330, 13334, 13338, 13339, 13341, 13343, 13344, 13346, 13359, 13362, 13364, 13367, 13370, 13371, 13374, 13375, 13377, 13380, 13382, 13383, 13385, 13389, 13414, 13416, 13428, 13435, 13446, 13455, 13461, 13465, 13466, 13476, 13507, 13511, 13512, 13527, 13536, 13538, 13540, 13547, 13548, 13550, 13551, 13552, 13559, 13561, 13563, 13579, 13612, 13615, 13618, 13627, 13628, 13632, 13643, 13698, 13699, 13700, 13701, 13702, 13704, 13706, 13710, 13711, 13713, 13734, 13774, 13778, 13800, 13803, 13817, 13819, 13820, 13822, 13825, 13829, 13830, 13831, 13845, 13846, 13848, 13852, 13855, 13856, 13862, 13865, 13866, 13867) | 0 | 0 | 7 | 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 | 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`.`status` = '1' AND FIND_IN_SET('226',`Store`.`deliver_to_countries`) LIMIT 10 | 10 | 10 | 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` = 226 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` = 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 | 252 | 252 | 2 | |
| 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 | 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` 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 | 2 | 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 | 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 | 1 | |
| SELECT COUNT(*) AS `count` FROM `mrkochar`.`categories` AS `Category` WHERE `Category`.`parent_id` = 5693 AND `Category`.`deleted` = 0 AND `Category`.`status` = 1 | 1 | 1 | 1 | |
| 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 | 1 | |
| 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 | 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 | 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) | 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 | 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` = 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 | 1 | |