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` = 13 | 117 | 117 | 1 | |
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 (657, 674, 718, 725, 741, 782, 818, 835, 891, 927, 1005, 1103, 1124, 1194, 1231, 1252, 1258, 1259, 1262, 1265, 1266, 1271, 1276, 1277, 1281, 1282, 1287, 1294, 1298, 1299, 1303, 1310, 1321, 1327, 1332, 1337, 1340, 1346, 1355, 1356, 1362, 1378, 1382, 1391, 1400, 1404, 1411, 1416, 1422, 1425, 1433, 1438, 1441, 1450, 1451, 1456, 1466, 1470, 1478, 1480, 1483, 1489, 1499, 1501, 1509, 1522, 1533, 1540, 1553, 1558, 1568, 1573, 1574, 1577, 1579, 1582, 1593, 1599, 1601, 1603, 1610, 1619, 1645, 1648, 1656, 1657, 1675, 1682, 1694, 1705, 1706, 1715, 1734, 1746, 1748, 1751, 1761, 1768, 1784, 1797, 1805, 1811, 1822, 1832, 1834, 1845, 1851, 1862, 1864, 1866, 1871, 1874, 1881, 1889, 1899, 1910, 1936) ORDER BY `Report`.`created` desc LIMIT 30 | 30 | 30 | 6 | maybe slow |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_reports` AS `Report` WHERE `Report`.`id` IN (657, 674, 718, 725, 741, 782, 818, 835, 891, 927, 1005, 1103, 1124, 1194, 1231, 1252, 1258, 1259, 1262, 1265, 1266, 1271, 1276, 1277, 1281, 1282, 1287, 1294, 1298, 1299, 1303, 1310, 1321, 1327, 1332, 1337, 1340, 1346, 1355, 1356, 1362, 1378, 1382, 1391, 1400, 1404, 1411, 1416, 1422, 1425, 1433, 1438, 1441, 1450, 1451, 1456, 1466, 1470, 1478, 1480, 1483, 1489, 1499, 1501, 1509, 1522, 1533, 1540, 1553, 1558, 1568, 1573, 1574, 1577, 1579, 1582, 1593, 1599, 1601, 1603, 1610, 1619, 1645, 1648, 1656, 1657, 1675, 1682, 1694, 1705, 1706, 1715, 1734, 1746, 1748, 1751, 1761, 1768, 1784, 1797, 1805, 1811, 1822, 1832, 1834, 1845, 1851, 1862, 1864, 1866, 1871, 1874, 1881, 1889, 1899, 1910, 1936) | 1 | 1 | 1 | |
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` = 1936 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` = 1910 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` = 1899 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` = 1889 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` = 1881 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` = 1874 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` = 1871 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` = 1866 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` = 1864 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` = 1862 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` = 1851 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` = 1845 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` = 1834 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` = 1832 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` = 1822 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` = 1811 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` = 1805 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` = 1797 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` = 1784 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` = 1768 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` = 1761 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` = 1751 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` = 1748 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` = 1746 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` = 1734 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` = 1715 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` = 1706 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` = 1705 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` = 1694 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` = 1682 LIMIT 1 | 1 | 1 | 0 | |