Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `StaticPage`.`slug` FROM `demoe3_getezquotes`.`static_pages` AS `StaticPage` WHERE 1 = 1 | 30 | 30 | 0 | |
SELECT `Country`.`slug` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE 1 = 1 | 15 | 15 | 0 | |
SELECT `Country`.`slug`, `Country`.`name`, `Country`.`id`, `Country`.`timezone` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `is_default` = 1 ORDER BY `country_order` ASC, `name` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `CurrencyCountry`.`currency_id`, `Currency`.`exchange_rate`, `Currency`.`code`, `Currency`.`symbol_postions` FROM `demoe3_getezquotes`.`currency_countries` AS `CurrencyCountry` LEFT JOIN `demoe3_getezquotes`.`currencies` AS `Currency` ON (`CurrencyCountry`.`currency_id` = `Currency`.`id`) WHERE `CurrencyCountry`.`country_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `CategoryCountry`.`id`, `CategoryCountry`.`category_id` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` WHERE `CategoryCountry`.`country_id` = 2 AND `CategoryCountry`.`parent_id` = 0 | 219 | 219 | 3 | |
SELECT `Category`.`id`, `Category`.`name` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`id` IN (9, 10, 11, 12, 16, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 40, 51, 63, 67, 78, 107, 129, 134, 160, 248, 280, 292, 360, 401, 407, 449, 461, 484, 504, 571, 582, 597, 617, 625, 652, 698, 738, 744, 768, 799, 811, 817, 826, 832, 838, 844, 850, 872, 885, 897, 935, 981, 982, 1094, 1194, 1197, 1225, 1302, 1309, 1355, 1431, 1460, 1442, 1269, 1218, 1081, 1074, 1036, 958, 944, 927, 822, 805, 770, 750, 721, 704, 692, 631, 591, 585, 531, 509, 490, 476, 414, 349, 286, 242, 192, 142, 80, 14, 13, 1476, 106, 1489, 1500, 915, 15, 1535, 1537, 168, 213, 671, 454, 1321, 1175, 495, 1233, 420, 150, 1406, 427, 548, 1391, 1259, 17, 1492, 612, 564, 576, 513, 37, 1200, 756, 710, 1511, 1515, 878, 1386, 272, 717, 325, 854, 866, 1206, 1361, 537, 466, 1228, 1539, 1548, 1152, 1559, 69, 910, 675, 261, 298, 520, 733, 556, 1138, 608, 1567, 1574, 667, 255, 1270, 637, 941, 921, 1509, 764, 443, 1576, 1582, 1589, 1595, 1606, 1588, 904, 1, 894, 54, 8, 306, 1426, 1190, 389, 727, 1630, 1631, 1632, 437, 220, 683, 336, 250, 999, 429, 1633, 1252, 857, 1371, 1379, 1641, 1647, 1648, 1655, 1676, 642, 1682) AND `Category`.`type` = 'support' AND `deleted` = 0 AND `is_active` = 1 | 4 | 4 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`parent_id` = 63 AND `Category`.`type` = 'support' AND `deleted` = 0 AND `is_active` = 1 | 3 | 3 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 64 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 10 | maybe slow |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (1) | 12 | 12 | 15 | maybe slow |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 65 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (2) | 12 | 12 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 66 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (3) | 12 | 12 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`parent_id` = 67 AND `Category`.`type` = 'support' AND `deleted` = 0 AND `is_active` = 1 | 3 | 3 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 74 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (6) | 10 | 10 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 75 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (5) | 10 | 10 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 76 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (4) | 10 | 10 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`parent_id` = 106 AND `Category`.`type` = 'support' AND `deleted` = 0 AND `is_active` = 1 | 3 | 3 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 108 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 2 | 2 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` IN (15, 16) | 20 | 20 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 110 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 0 | 0 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 111 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 2 | 2 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` IN (11, 14) | 20 | 20 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `demoe3_getezquotes`.`categories` AS `Category` WHERE `Category`.`parent_id` = 107 AND `Category`.`type` = 'support' AND `deleted` = 0 AND `is_active` = 1 | 2 | 2 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 109 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (13) | 10 | 10 | 0 | |
SELECT `SupportCategoryArticle`.`id`, `SupportCategoryArticle`.`category_id`, `SupportCategoryArticle`.`title`, `SupportCategoryArticle`.`slug`, `SupportCategoryArticle`.`meta_keywords`, `SupportCategoryArticle`.`meta_description`, `SupportCategoryArticle`.`is_active`, `SupportCategoryArticle`.`is_deleted`, `SupportCategoryArticle`.`created`, `SupportCategoryArticle`.`modified` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 112 AND `is_active` = 1 AND `is_deleted` = 0 LIMIT 5 | 1 | 1 | 0 | |
SELECT `SupportCategoryArticleContent`.`id`, `SupportCategoryArticleContent`.`support_category_article_id`, `SupportCategoryArticleContent`.`country_id`, `SupportCategoryArticleContent`.`description`, `SupportCategoryArticleContent`.`short_description`, `SupportCategoryArticleContent`.`created`, `SupportCategoryArticleContent`.`modified` FROM `demoe3_getezquotes`.`support_category_article_contents` AS `SupportCategoryArticleContent` WHERE `SupportCategoryArticleContent`.`support_category_article_id` = (17) | 12 | 12 | 0 | |
SELECT `Block`.`page_name`, `Block`.`page_slug`, `Block`.`block_name`, `Block`.`block_slug`, `Block`.`description` FROM `demoe3_getezquotes`.`blocks` AS `Block` WHERE `Block`.`page_slug` = 'support-page' | 3 | 3 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 64 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 65 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 66 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 74 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 75 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 76 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 108 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 110 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 111 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 109 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`support_category_articles` AS `SupportCategoryArticle` WHERE `SupportCategoryArticle`.`category_id` = 112 AND `is_active` = 1 AND `is_deleted` = 0 | 1 | 1 | 0 | |
SELECT `Country`.`id`, `Country`.`slug`, `Country`.`name`, `Country`.`country_code`, `Country`.`is_default`, `Country`.`country_flag` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `Country`.`show_in_menu` = 1 AND `Country`.`status` = 1 ORDER BY `country_order` ASC, `name` ASC | 3 | 3 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` LEFT JOIN `demoe3_getezquotes`.`user_groups` AS `UserGroup` ON (`User`.`user_group_id` = `UserGroup`.`id`) WHERE `user_type` = 'service-provider' AND ((`is_blocked` = 0) AND (`is_deleted` = 0) AND (`is_apporoved` = 1) AND (`status` = 1) AND (`activation_key` = '')) | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` LEFT JOIN `demoe3_getezquotes`.`user_groups` AS `UserGroup` ON (`User`.`user_group_id` = `UserGroup`.`id`) WHERE `user_type` = 'user' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`projects` AS `Projects` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`Projects`.`user_id` = `User`.`id`) WHERE `Projects`.`status` = 1 AND `Projects`.`is_admin_approved` = 1 AND `Projects`.`is_posted` = 1 AND `Projects`.`is_deleted` = 0 AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0 | 1 | 1 | 0 | |