Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `Category`.`id`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `ReportsReportcategory`.`report_id` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 1 | 349 | 349 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE 1 = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 2 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 3 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 4 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 5 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 7 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 8 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 6 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 11 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 12 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 9 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 10 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `reportcategory_id` = 13 | 1 | 1 | 0 | |
SELECT `Report`.`id`, `Report`.`title`, `Report`.`content`, `Report`.`created`, `Report`.`seitekiurl`, `Report`.`summary`, `Report`.`modified` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` IN (44, 74, 75, 77, 84, 85, 87, 88, 91, 95, 96, 98, 103, 104, 107, 108, 109, 110, 111, 118, 119, 125, 128, 138, 141, 143, 145, 146, 147, 148, 158, 159, 160, 162, 164, 165, 167, 169, 170, 171, 172, 175, 182, 184, 186, 196, 201, 203, 205, 208, 212, 213, 219, 225, 237, 240, 268, 271, 272, 285, 289, 291, 294, 295, 307, 308, 312, 315, 318, 320, 321, 322, 327, 331, 339, 341, 345, 346, 352, 356, 363, 367, 371, 372, 375, 382, 389, 395, 427, 431, 441, 482, 484, 495, 512, 526, 559, 601, 607, 625, 645, 661, 665, 716, 734, 744, 745, 746, 751, 761, 773, 793, 803, 805, 872, 906, 914, 932, 938, 939, 975, 976, 1018, 1045, 1051, 1053, 1059, 1068, 1093, 1096, 1099, 1158, 1168, 1169, 1170, 1209, 1225, 1250, 1256, 1296, 1301, 1324, 1339, 1357, 1361, 1369, 1383, 1410, 1420, 1431, 1432, 1442, 1455, 1472, 1504, 1512, 1520, 1534, 1581, 1586, 1594, 1602, 1613, 1629, 1634, 1646, 1658, 1667, 1668, 1678, 1681, 1683, 1693, 1702, 1722, 1730, 1731, 1745, 1770, 1782, 1787, 1792, 1810, 1813, 1814, 1830, 1833, 1842, 1856, 1861, 1867, 1868, 1901, 1926, 1942, 1946, 1951, 1972, 2005, 2010, 2013, 2020, 2028, 2031, 2032, 2034, 2037, 2038, 2040, 2042, 2043, 2044, 2045, 2046, 2048, 2051, 2052, 2053, 2055, 2056, 2058, 2059, 2061, 2062, 2063, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2074, 2075, 2076, 2077, 2078, 2079, 2080, 2081, 2082, 2084, 2085, 2086, 2087, 2088, 2090, 2091, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2106, 2107, 2108, 2110, 2111, 2116, 2117, 2119, 2122, 2125, 2126, 2128, 2131, 2132, 2133, 2137, 2140, 2143, 2144, 2146, 2147, 2148, 2150, 2151, 2156, 2157, 2160, 2161, 2165, 2168, 2171, 2174, 2176, 2177, 2179, 2180, 2182, 2183, 2184, 2186, 2190, 2192, 2193, 2199, 2202, 2203, 2206, 2207, 2210, 2213, 2216, 2219, 2221, 2222, 2224, 2225, 2228, 2230, 2232, 2233, 2234, 2235, 2243, 2244, 2248, 2250, 2251, 2255, 2258, 2259, 2262, 2263, 2264, 2266, 2271, 2272, 2273, 2276, 2279, 2282, 2283, 2284, 2286, 2288, 2289, 2292, 2293, 2297, 2300, 2301) ORDER BY `Report`.`created` desc LIMIT 60, 30 | 30 | 30 | 2 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` IN (44, 74, 75, 77, 84, 85, 87, 88, 91, 95, 96, 98, 103, 104, 107, 108, 109, 110, 111, 118, 119, 125, 128, 138, 141, 143, 145, 146, 147, 148, 158, 159, 160, 162, 164, 165, 167, 169, 170, 171, 172, 175, 182, 184, 186, 196, 201, 203, 205, 208, 212, 213, 219, 225, 237, 240, 268, 271, 272, 285, 289, 291, 294, 295, 307, 308, 312, 315, 318, 320, 321, 322, 327, 331, 339, 341, 345, 346, 352, 356, 363, 367, 371, 372, 375, 382, 389, 395, 427, 431, 441, 482, 484, 495, 512, 526, 559, 601, 607, 625, 645, 661, 665, 716, 734, 744, 745, 746, 751, 761, 773, 793, 803, 805, 872, 906, 914, 932, 938, 939, 975, 976, 1018, 1045, 1051, 1053, 1059, 1068, 1093, 1096, 1099, 1158, 1168, 1169, 1170, 1209, 1225, 1250, 1256, 1296, 1301, 1324, 1339, 1357, 1361, 1369, 1383, 1410, 1420, 1431, 1432, 1442, 1455, 1472, 1504, 1512, 1520, 1534, 1581, 1586, 1594, 1602, 1613, 1629, 1634, 1646, 1658, 1667, 1668, 1678, 1681, 1683, 1693, 1702, 1722, 1730, 1731, 1745, 1770, 1782, 1787, 1792, 1810, 1813, 1814, 1830, 1833, 1842, 1856, 1861, 1867, 1868, 1901, 1926, 1942, 1946, 1951, 1972, 2005, 2010, 2013, 2020, 2028, 2031, 2032, 2034, 2037, 2038, 2040, 2042, 2043, 2044, 2045, 2046, 2048, 2051, 2052, 2053, 2055, 2056, 2058, 2059, 2061, 2062, 2063, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2074, 2075, 2076, 2077, 2078, 2079, 2080, 2081, 2082, 2084, 2085, 2086, 2087, 2088, 2090, 2091, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2106, 2107, 2108, 2110, 2111, 2116, 2117, 2119, 2122, 2125, 2126, 2128, 2131, 2132, 2133, 2137, 2140, 2143, 2144, 2146, 2147, 2148, 2150, 2151, 2156, 2157, 2160, 2161, 2165, 2168, 2171, 2174, 2176, 2177, 2179, 2180, 2182, 2183, 2184, 2186, 2190, 2192, 2193, 2199, 2202, 2203, 2206, 2207, 2210, 2213, 2216, 2219, 2221, 2222, 2224, 2225, 2228, 2230, 2232, 2233, 2234, 2235, 2243, 2244, 2248, 2250, 2251, 2255, 2258, 2259, 2262, 2263, 2264, 2266, 2271, 2272, 2273, 2276, 2279, 2282, 2283, 2284, 2286, 2288, 2289, 2292, 2293, 2297, 2300, 2301) | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2165 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2161 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2160 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2157 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2156 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2151 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2150 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2148 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2147 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2146 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2144 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2143 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2140 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2137 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2133 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2132 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2131 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2128 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2126 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2125 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2122 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2119 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2117 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2116 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2111 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2110 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2108 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2107 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2106 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ReportsReportcategory`.`id`, `ReportsReportcategory`.`report_id`, `ReportsReportcategory`.`reportcategory_id`, `ReportsReportcategory`.`created`, `ReportsReportcategory`.`modified` FROM `witinc_pqnavi_test`.`md_reports_reportcategories` AS `ReportsReportcategory` WHERE `ReportsReportcategory`.`report_id` = 2102 LIMIT 1 | 1 | 1 | 0 | |