| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `ShikomoriWord`.`id`, `ShikomoriWord`.`parent_id`, `ShikomoriWord`.`num_class`, `ShikomoriWord`.`word`, `ShikomoriWord`.`various_forms`, `ShikomoriWord`.`from_verb_id`, `ShikomoriWord`.`origin`, `ShikomoriWord`.`origin_history`, `ShikomoriWord`.`category`, `ShikomoriWord`.`category2`, `ShikomoriWord`.`category3`, `ShikomoriWord`.`is_shingazidja`, `ShikomoriWord`.`is_shindzuani`, `ShikomoriWord`.`is_shimaore`, `ShikomoriWord`.`is_shimwali`, `ShikomoriWord`.`is_standard`, `ShikomoriWord`.`is_neology`, `ShikomoriWord`.`is_transparent`, `ShikomoriWord`.`has_definition`, `ShikomoriWord`.`has_infinitive`, `ShikomoriWord`.`has_plural`, `ShikomoriWord`.`in_front`, `ShikomoriWord`.`generated_word`, `ShikomoriWord`.`active`, `ShikomoriWord`.`closed`, `ShikomoriWord`.`in_error`, `ShikomoriWord`.`date_created`, `ShikomoriWord`.`date_updated`, `ShikomoriWord`.`date_day_word`, `ShikomoriWord`.`used_in_word_of_day`, `ShikomoriWord`.`is_collective`, `ShikomoriWord`.`creator_id`, `ShikomoriWord`.`editor_id`, `ShikomoriWord`.`reserved_by_editor`, `ShikomoriWord`.`finished_by_editor` FROM `noniseshorelc`.`shikomori_words` AS `ShikomoriWord` WHERE ((`ShikomoriWord`.`word` LIKE 'i%') OR (`ShikomoriWord`.`word` LIKE '-i%')) AND `ShikomoriWord`.`active` = '1' ORDER BY `ShikomoriWord`.`word` ASC | 213 | 213 | 1 | |
| SELECT `FrenchWord`.`id`, `FrenchWord`.`word`, `FrenchWord`.`kind`, `FrenchWord`.`category`, `FrenchWord`.`employ`, `FrenchWord`.`category2`, `FrenchWord`.`category3`, `FrenchWord`.`has_definition`, `FrenchWord`.`active`, `FrenchWord`.`closed`, `FrenchWord`.`date_created`, `FrenchWord`.`date_updated`, `FrenchWord`.`is_collective`, `FrenchWord`.`creator_id`, `FrenchWord`.`editor_id`, `ShikomoriFrWord`.`id`, `ShikomoriFrWord`.`shikomori_id`, `ShikomoriFrWord`.`french_id`, `ShikomoriFrWord`.`language_registers`, `ShikomoriFrWord`.`for_dialects`, `ShikomoriFrWord`.`position` FROM `noniseshorelc`.`french_words` AS `FrenchWord` JOIN `noniseshorelc`.`shikomori_fr_words` AS `ShikomoriFrWord` ON (`ShikomoriFrWord`.`shikomori_id` IN (7570, 5551, 4091, 2524, 8348, 2542, 4319, 4320, 4321, 8129, 1675, 4586, 7571, 1676, 1677, 5855, 6604, 6666, 5767, 1678, 1679, 7134, 7572, 1680, 8180, 6461, 2583, 1683, 5671, 1684, 1685, 1686, 1687, 8071, 1688, 6684, 2669, 6053, 1681, 1682, 8082, 7573, 6037, 1689, 1690, 6822, 1691, 8268, 1692, 8064, 5857, 1693, 1694, 5949, 1695, 1696, 1697, 1698, 7201, 2518, 7012, 6890, 8148, 6975, 1699, 1076, 1700, 7574, 8209, 4711, 1701, 5802, 5717, 4954, 6827, 2927, 1702, 1703, 1704, 1705, 6994, 8351, 3492, 1706, 1707, 4326, 2825, 1708, 1709, 6969, 1710, 1711, 1712, 6613, 1713, 2832, 5176, 7575, 2283, 1714, 5083, 1715, 1716, 8154, 6228, 1717, 1718, 3125, 8252, 1719, 4322, 1720, 7299, 1721, 7010, 1722, 1723, 2909, 8152, 8065, 1724, 7103, 5515, 1725, 7576, 1726, 5267, 1727, 5461, 7577, 2519, 1728, 1729, 2709, 1730, 1731, 6640, 1732, 7007, 5096, 3236, 1733, 1734, 1735, 1736, 3425, 1737, 1738, 5076, 2900, 4323, 4324, 1739, 3945, 6160, 5899, 1740, 1741, 5440, 1742, 2285, 4475, 6991, 6115, 1743, 1744, 1745, 1746, 8062, 1747, 1748, 1749, 1750, 1751, 1752, 2718, 4633, 1753, 5750, 1754, 4657, 7000, 2702, 1755, 1756, 5042, 6464, 1757, 1758, 5305, 6063, 7049, 6592, 1759, 5157, 8302, 1760, 2597, 8285, 6277, 1761, 7675, 7096, 2896, 1762, 1763, 2282, 1764, 5178, 8069, 6481, 1765, 2286) AND `ShikomoriFrWord`.`french_id` = `FrenchWord`.`id`) ORDER BY `ShikomoriFrWord`.`position` ASC | 292 | 292 | 2 | |
| SELECT `EnglishWord`.`id`, `EnglishWord`.`word`, `EnglishWord`.`kind`, `EnglishWord`.`category`, `EnglishWord`.`employ`, `EnglishWord`.`category2`, `EnglishWord`.`category3`, `EnglishWord`.`has_definition`, `EnglishWord`.`active`, `EnglishWord`.`closed`, `EnglishWord`.`date_created`, `EnglishWord`.`date_updated`, `EnglishWord`.`is_collective`, `EnglishWord`.`creator_id`, `EnglishWord`.`editor_id`, `ShikomoriEnWord`.`id`, `ShikomoriEnWord`.`shikomori_id`, `ShikomoriEnWord`.`english_id`, `ShikomoriEnWord`.`language_registers`, `ShikomoriEnWord`.`for_dialects`, `ShikomoriEnWord`.`position` FROM `noniseshorelc`.`english_words` AS `EnglishWord` JOIN `noniseshorelc`.`shikomori_en_words` AS `ShikomoriEnWord` ON (`ShikomoriEnWord`.`shikomori_id` IN (7570, 5551, 4091, 2524, 8348, 2542, 4319, 4320, 4321, 8129, 1675, 4586, 7571, 1676, 1677, 5855, 6604, 6666, 5767, 1678, 1679, 7134, 7572, 1680, 8180, 6461, 2583, 1683, 5671, 1684, 1685, 1686, 1687, 8071, 1688, 6684, 2669, 6053, 1681, 1682, 8082, 7573, 6037, 1689, 1690, 6822, 1691, 8268, 1692, 8064, 5857, 1693, 1694, 5949, 1695, 1696, 1697, 1698, 7201, 2518, 7012, 6890, 8148, 6975, 1699, 1076, 1700, 7574, 8209, 4711, 1701, 5802, 5717, 4954, 6827, 2927, 1702, 1703, 1704, 1705, 6994, 8351, 3492, 1706, 1707, 4326, 2825, 1708, 1709, 6969, 1710, 1711, 1712, 6613, 1713, 2832, 5176, 7575, 2283, 1714, 5083, 1715, 1716, 8154, 6228, 1717, 1718, 3125, 8252, 1719, 4322, 1720, 7299, 1721, 7010, 1722, 1723, 2909, 8152, 8065, 1724, 7103, 5515, 1725, 7576, 1726, 5267, 1727, 5461, 7577, 2519, 1728, 1729, 2709, 1730, 1731, 6640, 1732, 7007, 5096, 3236, 1733, 1734, 1735, 1736, 3425, 1737, 1738, 5076, 2900, 4323, 4324, 1739, 3945, 6160, 5899, 1740, 1741, 5440, 1742, 2285, 4475, 6991, 6115, 1743, 1744, 1745, 1746, 8062, 1747, 1748, 1749, 1750, 1751, 1752, 2718, 4633, 1753, 5750, 1754, 4657, 7000, 2702, 1755, 1756, 5042, 6464, 1757, 1758, 5305, 6063, 7049, 6592, 1759, 5157, 8302, 1760, 2597, 8285, 6277, 1761, 7675, 7096, 2896, 1762, 1763, 2282, 1764, 5178, 8069, 6481, 1765, 2286) AND `ShikomoriEnWord`.`english_id` = `EnglishWord`.`id`) | 9 | 9 | 1 | maybe slow |
| SELECT `ArabicWord`.`id`, `ArabicWord`.`word`, `ArabicWord`.`kind`, `ArabicWord`.`category`, `ArabicWord`.`employ`, `ArabicWord`.`category2`, `ArabicWord`.`category3`, `ArabicWord`.`has_definition`, `ArabicWord`.`active`, `ArabicWord`.`closed`, `ArabicWord`.`date_created`, `ArabicWord`.`date_updated`, `ArabicWord`.`is_collective`, `ArabicWord`.`creator_id`, `ArabicWord`.`editor_id`, `ShikomoriArWord`.`id`, `ShikomoriArWord`.`shikomori_id`, `ShikomoriArWord`.`arabic_id`, `ShikomoriArWord`.`language_registers`, `ShikomoriArWord`.`for_dialects`, `ShikomoriArWord`.`position` FROM `noniseshorelc`.`arabic_words` AS `ArabicWord` JOIN `noniseshorelc`.`shikomori_ar_words` AS `ShikomoriArWord` ON (`ShikomoriArWord`.`shikomori_id` IN (7570, 5551, 4091, 2524, 8348, 2542, 4319, 4320, 4321, 8129, 1675, 4586, 7571, 1676, 1677, 5855, 6604, 6666, 5767, 1678, 1679, 7134, 7572, 1680, 8180, 6461, 2583, 1683, 5671, 1684, 1685, 1686, 1687, 8071, 1688, 6684, 2669, 6053, 1681, 1682, 8082, 7573, 6037, 1689, 1690, 6822, 1691, 8268, 1692, 8064, 5857, 1693, 1694, 5949, 1695, 1696, 1697, 1698, 7201, 2518, 7012, 6890, 8148, 6975, 1699, 1076, 1700, 7574, 8209, 4711, 1701, 5802, 5717, 4954, 6827, 2927, 1702, 1703, 1704, 1705, 6994, 8351, 3492, 1706, 1707, 4326, 2825, 1708, 1709, 6969, 1710, 1711, 1712, 6613, 1713, 2832, 5176, 7575, 2283, 1714, 5083, 1715, 1716, 8154, 6228, 1717, 1718, 3125, 8252, 1719, 4322, 1720, 7299, 1721, 7010, 1722, 1723, 2909, 8152, 8065, 1724, 7103, 5515, 1725, 7576, 1726, 5267, 1727, 5461, 7577, 2519, 1728, 1729, 2709, 1730, 1731, 6640, 1732, 7007, 5096, 3236, 1733, 1734, 1735, 1736, 3425, 1737, 1738, 5076, 2900, 4323, 4324, 1739, 3945, 6160, 5899, 1740, 1741, 5440, 1742, 2285, 4475, 6991, 6115, 1743, 1744, 1745, 1746, 8062, 1747, 1748, 1749, 1750, 1751, 1752, 2718, 4633, 1753, 5750, 1754, 4657, 7000, 2702, 1755, 1756, 5042, 6464, 1757, 1758, 5305, 6063, 7049, 6592, 1759, 5157, 8302, 1760, 2597, 8285, 6277, 1761, 7675, 7096, 2896, 1762, 1763, 2282, 1764, 5178, 8069, 6481, 1765, 2286) AND `ShikomoriArWord`.`arabic_id` = `ArabicWord`.`id`) | 0 | 0 | 1 | maybe slow |
| SELECT `ShikomoriPlural`.`id`, `ShikomoriPlural`.`num_class`, `ShikomoriPlural`.`word`, `ShikomoriPlural`.`active`, `ShikomoriPlural`.`closed`, `ShikomoriPlural`.`date_created`, `ShikomoriPlural`.`date_updated`, `ShikomoriPlural`.`is_collective`, `ShikomoriPlural`.`creator_id`, `ShikomoriPlural`.`editor_id`, `ShikomoriPlWord`.`id`, `ShikomoriPlWord`.`plural_id`, `ShikomoriPlWord`.`shikomori_id`, `ShikomoriPlWord`.`language_registers`, `ShikomoriPlWord`.`for_dialects`, `ShikomoriPlWord`.`position` FROM `noniseshorelc`.`shikomori_plurals` AS `ShikomoriPlural` JOIN `noniseshorelc`.`shikomori_pl_words` AS `ShikomoriPlWord` ON (`ShikomoriPlWord`.`shikomori_id` IN (7570, 5551, 4091, 2524, 8348, 2542, 4319, 4320, 4321, 8129, 1675, 4586, 7571, 1676, 1677, 5855, 6604, 6666, 5767, 1678, 1679, 7134, 7572, 1680, 8180, 6461, 2583, 1683, 5671, 1684, 1685, 1686, 1687, 8071, 1688, 6684, 2669, 6053, 1681, 1682, 8082, 7573, 6037, 1689, 1690, 6822, 1691, 8268, 1692, 8064, 5857, 1693, 1694, 5949, 1695, 1696, 1697, 1698, 7201, 2518, 7012, 6890, 8148, 6975, 1699, 1076, 1700, 7574, 8209, 4711, 1701, 5802, 5717, 4954, 6827, 2927, 1702, 1703, 1704, 1705, 6994, 8351, 3492, 1706, 1707, 4326, 2825, 1708, 1709, 6969, 1710, 1711, 1712, 6613, 1713, 2832, 5176, 7575, 2283, 1714, 5083, 1715, 1716, 8154, 6228, 1717, 1718, 3125, 8252, 1719, 4322, 1720, 7299, 1721, 7010, 1722, 1723, 2909, 8152, 8065, 1724, 7103, 5515, 1725, 7576, 1726, 5267, 1727, 5461, 7577, 2519, 1728, 1729, 2709, 1730, 1731, 6640, 1732, 7007, 5096, 3236, 1733, 1734, 1735, 1736, 3425, 1737, 1738, 5076, 2900, 4323, 4324, 1739, 3945, 6160, 5899, 1740, 1741, 5440, 1742, 2285, 4475, 6991, 6115, 1743, 1744, 1745, 1746, 8062, 1747, 1748, 1749, 1750, 1751, 1752, 2718, 4633, 1753, 5750, 1754, 4657, 7000, 2702, 1755, 1756, 5042, 6464, 1757, 1758, 5305, 6063, 7049, 6592, 1759, 5157, 8302, 1760, 2597, 8285, 6277, 1761, 7675, 7096, 2896, 1762, 1763, 2282, 1764, 5178, 8069, 6481, 1765, 2286) AND `ShikomoriPlWord`.`plural_id` = `ShikomoriPlural`.`id`) | 150 | 150 | 2 | |