| 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 'h%') OR (`ShikomoriWord`.`word` LIKE '-h%')) AND `ShikomoriWord`.`active` = '1' ORDER BY `ShikomoriWord`.`word` ASC | 331 | 331 | 2 | |
| 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 (5912, 2522, 4556, 2523, 2866, 1537, 1538, 1539, 1540, 1541, 1542, 7495, 1543, 8321, 5947, 2742, 2656, 1544, 1545, 1546, 1547, 8177, 8236, 2667, 1548, 5725, 2567, 8099, 5348, 1549, 1553, 1555, 5195, 7387, 7179, 2576, 1550, 1551, 1552, 8012, 2740, 1554, 5347, 1557, 1558, 4794, 2775, 1559, 7490, 4332, 4333, 2761, 6274, 8329, 1560, 5890, 1561, 1562, 1563, 4334, 1564, 1565, 7156, 6637, 4587, 1566, 2868, 8369, 1567, 4335, 6289, 1568, 1569, 1571, 8046, 1572, 1573, 2586, 2613, 1574, 1575, 1576, 8000, 5598, 5196, 7240, 2821, 1577, 7496, 1578, 1579, 1580, 4336, 7437, 7497, 1581, 4751, 1582, 4589, 5898, 5777, 5869, 5774, 7511, 1584, 1583, 2771, 5197, 1585, 4337, 5984, 6430, 6775, 1586, 6686, 6687, 4545, 6543, 6542, 5646, 4338, 4339, 7514, 1589, 7042, 1590, 2730, 1591, 7515, 1592, 1593, 1594, 1595, 5266, 1596, 1521, 3479, 6824, 2620, 1597, 6459, 1598, 6263, 2996, 3535, 8335, 4340, 8187, 5961, 4343, 7143, 3305, 3118, 1600, 4344, 6836, 8332, 4345, 3073, 7518, 4532, 1602, 1603, 7608, 4346, 1604, 4347, 1605, 4358, 1606, 1607, 4348, 5198, 1608, 1609, 4352, 5261, 4349, 7519, 7522, 8018, 5200, 1611, 1612, 5718, 1613, 1614, 1615, 5205, 4753, 4350, 4351, 7526, 4701, 1616, 7528, 2574, 2598, 7529, 1617, 4786, 5051, 1620, 1618, 1619, 7094, 1556, 6618, 1621, 1622, 4353, 1623, 4354, 5142, 1624, 1625, 2831, 7021, 1626, 7298, 1627, 2575, 5020, 5064, 4355, 2651, 8219, 1628, 4356, 1629, 4357, 7098, 1630, 1631, 1632, 7533, 1633, 1634, 6871, 7035, 6783, 1635, 6654, 2863, 4359, 1636, 1637, 7165, 4360, 1638, 1639, 5206, 1640, 7245, 6000, 201, 2913, 3283, 1641, 1643, 1642, 203, 4361, 2724, 1644, 7536, 1645, 1646, 8156, 1647, 6797, 7538, 1649, 1650, 1651, 5970, 1652, 1653, 5207, 7911, 2845, 1654, 1655, 1656, 6111, 1657, 1658, 1659, 7567, 1660, 1661, 5208, 1662, 1663, 8275, 8299, 2971, 2777, 8004, 1664, 4362, 1665, 7568, 7138, 1666, 3059, 1667, 2578, 1668, 8110, 8250, 1669, 1670, 5610, 1671, 1672, 8053, 2892, 1648, 1673, 7223, 3355, 2714, 2616, 5231, 7569, 2888, 1674, 5546, 3442, 5558) AND `ShikomoriFrWord`.`french_id` = `FrenchWord`.`id`) ORDER BY `ShikomoriFrWord`.`position` ASC | 524 | 524 | 3 | |
| 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 (5912, 2522, 4556, 2523, 2866, 1537, 1538, 1539, 1540, 1541, 1542, 7495, 1543, 8321, 5947, 2742, 2656, 1544, 1545, 1546, 1547, 8177, 8236, 2667, 1548, 5725, 2567, 8099, 5348, 1549, 1553, 1555, 5195, 7387, 7179, 2576, 1550, 1551, 1552, 8012, 2740, 1554, 5347, 1557, 1558, 4794, 2775, 1559, 7490, 4332, 4333, 2761, 6274, 8329, 1560, 5890, 1561, 1562, 1563, 4334, 1564, 1565, 7156, 6637, 4587, 1566, 2868, 8369, 1567, 4335, 6289, 1568, 1569, 1571, 8046, 1572, 1573, 2586, 2613, 1574, 1575, 1576, 8000, 5598, 5196, 7240, 2821, 1577, 7496, 1578, 1579, 1580, 4336, 7437, 7497, 1581, 4751, 1582, 4589, 5898, 5777, 5869, 5774, 7511, 1584, 1583, 2771, 5197, 1585, 4337, 5984, 6430, 6775, 1586, 6686, 6687, 4545, 6543, 6542, 5646, 4338, 4339, 7514, 1589, 7042, 1590, 2730, 1591, 7515, 1592, 1593, 1594, 1595, 5266, 1596, 1521, 3479, 6824, 2620, 1597, 6459, 1598, 6263, 2996, 3535, 8335, 4340, 8187, 5961, 4343, 7143, 3305, 3118, 1600, 4344, 6836, 8332, 4345, 3073, 7518, 4532, 1602, 1603, 7608, 4346, 1604, 4347, 1605, 4358, 1606, 1607, 4348, 5198, 1608, 1609, 4352, 5261, 4349, 7519, 7522, 8018, 5200, 1611, 1612, 5718, 1613, 1614, 1615, 5205, 4753, 4350, 4351, 7526, 4701, 1616, 7528, 2574, 2598, 7529, 1617, 4786, 5051, 1620, 1618, 1619, 7094, 1556, 6618, 1621, 1622, 4353, 1623, 4354, 5142, 1624, 1625, 2831, 7021, 1626, 7298, 1627, 2575, 5020, 5064, 4355, 2651, 8219, 1628, 4356, 1629, 4357, 7098, 1630, 1631, 1632, 7533, 1633, 1634, 6871, 7035, 6783, 1635, 6654, 2863, 4359, 1636, 1637, 7165, 4360, 1638, 1639, 5206, 1640, 7245, 6000, 201, 2913, 3283, 1641, 1643, 1642, 203, 4361, 2724, 1644, 7536, 1645, 1646, 8156, 1647, 6797, 7538, 1649, 1650, 1651, 5970, 1652, 1653, 5207, 7911, 2845, 1654, 1655, 1656, 6111, 1657, 1658, 1659, 7567, 1660, 1661, 5208, 1662, 1663, 8275, 8299, 2971, 2777, 8004, 1664, 4362, 1665, 7568, 7138, 1666, 3059, 1667, 2578, 1668, 8110, 8250, 1669, 1670, 5610, 1671, 1672, 8053, 2892, 1648, 1673, 7223, 3355, 2714, 2616, 5231, 7569, 2888, 1674, 5546, 3442, 5558) AND `ShikomoriEnWord`.`english_id` = `EnglishWord`.`id`) | 208 | 208 | 2 | |
| 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 (5912, 2522, 4556, 2523, 2866, 1537, 1538, 1539, 1540, 1541, 1542, 7495, 1543, 8321, 5947, 2742, 2656, 1544, 1545, 1546, 1547, 8177, 8236, 2667, 1548, 5725, 2567, 8099, 5348, 1549, 1553, 1555, 5195, 7387, 7179, 2576, 1550, 1551, 1552, 8012, 2740, 1554, 5347, 1557, 1558, 4794, 2775, 1559, 7490, 4332, 4333, 2761, 6274, 8329, 1560, 5890, 1561, 1562, 1563, 4334, 1564, 1565, 7156, 6637, 4587, 1566, 2868, 8369, 1567, 4335, 6289, 1568, 1569, 1571, 8046, 1572, 1573, 2586, 2613, 1574, 1575, 1576, 8000, 5598, 5196, 7240, 2821, 1577, 7496, 1578, 1579, 1580, 4336, 7437, 7497, 1581, 4751, 1582, 4589, 5898, 5777, 5869, 5774, 7511, 1584, 1583, 2771, 5197, 1585, 4337, 5984, 6430, 6775, 1586, 6686, 6687, 4545, 6543, 6542, 5646, 4338, 4339, 7514, 1589, 7042, 1590, 2730, 1591, 7515, 1592, 1593, 1594, 1595, 5266, 1596, 1521, 3479, 6824, 2620, 1597, 6459, 1598, 6263, 2996, 3535, 8335, 4340, 8187, 5961, 4343, 7143, 3305, 3118, 1600, 4344, 6836, 8332, 4345, 3073, 7518, 4532, 1602, 1603, 7608, 4346, 1604, 4347, 1605, 4358, 1606, 1607, 4348, 5198, 1608, 1609, 4352, 5261, 4349, 7519, 7522, 8018, 5200, 1611, 1612, 5718, 1613, 1614, 1615, 5205, 4753, 4350, 4351, 7526, 4701, 1616, 7528, 2574, 2598, 7529, 1617, 4786, 5051, 1620, 1618, 1619, 7094, 1556, 6618, 1621, 1622, 4353, 1623, 4354, 5142, 1624, 1625, 2831, 7021, 1626, 7298, 1627, 2575, 5020, 5064, 4355, 2651, 8219, 1628, 4356, 1629, 4357, 7098, 1630, 1631, 1632, 7533, 1633, 1634, 6871, 7035, 6783, 1635, 6654, 2863, 4359, 1636, 1637, 7165, 4360, 1638, 1639, 5206, 1640, 7245, 6000, 201, 2913, 3283, 1641, 1643, 1642, 203, 4361, 2724, 1644, 7536, 1645, 1646, 8156, 1647, 6797, 7538, 1649, 1650, 1651, 5970, 1652, 1653, 5207, 7911, 2845, 1654, 1655, 1656, 6111, 1657, 1658, 1659, 7567, 1660, 1661, 5208, 1662, 1663, 8275, 8299, 2971, 2777, 8004, 1664, 4362, 1665, 7568, 7138, 1666, 3059, 1667, 2578, 1668, 8110, 8250, 1669, 1670, 5610, 1671, 1672, 8053, 2892, 1648, 1673, 7223, 3355, 2714, 2616, 5231, 7569, 2888, 1674, 5546, 3442, 5558) 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 (5912, 2522, 4556, 2523, 2866, 1537, 1538, 1539, 1540, 1541, 1542, 7495, 1543, 8321, 5947, 2742, 2656, 1544, 1545, 1546, 1547, 8177, 8236, 2667, 1548, 5725, 2567, 8099, 5348, 1549, 1553, 1555, 5195, 7387, 7179, 2576, 1550, 1551, 1552, 8012, 2740, 1554, 5347, 1557, 1558, 4794, 2775, 1559, 7490, 4332, 4333, 2761, 6274, 8329, 1560, 5890, 1561, 1562, 1563, 4334, 1564, 1565, 7156, 6637, 4587, 1566, 2868, 8369, 1567, 4335, 6289, 1568, 1569, 1571, 8046, 1572, 1573, 2586, 2613, 1574, 1575, 1576, 8000, 5598, 5196, 7240, 2821, 1577, 7496, 1578, 1579, 1580, 4336, 7437, 7497, 1581, 4751, 1582, 4589, 5898, 5777, 5869, 5774, 7511, 1584, 1583, 2771, 5197, 1585, 4337, 5984, 6430, 6775, 1586, 6686, 6687, 4545, 6543, 6542, 5646, 4338, 4339, 7514, 1589, 7042, 1590, 2730, 1591, 7515, 1592, 1593, 1594, 1595, 5266, 1596, 1521, 3479, 6824, 2620, 1597, 6459, 1598, 6263, 2996, 3535, 8335, 4340, 8187, 5961, 4343, 7143, 3305, 3118, 1600, 4344, 6836, 8332, 4345, 3073, 7518, 4532, 1602, 1603, 7608, 4346, 1604, 4347, 1605, 4358, 1606, 1607, 4348, 5198, 1608, 1609, 4352, 5261, 4349, 7519, 7522, 8018, 5200, 1611, 1612, 5718, 1613, 1614, 1615, 5205, 4753, 4350, 4351, 7526, 4701, 1616, 7528, 2574, 2598, 7529, 1617, 4786, 5051, 1620, 1618, 1619, 7094, 1556, 6618, 1621, 1622, 4353, 1623, 4354, 5142, 1624, 1625, 2831, 7021, 1626, 7298, 1627, 2575, 5020, 5064, 4355, 2651, 8219, 1628, 4356, 1629, 4357, 7098, 1630, 1631, 1632, 7533, 1633, 1634, 6871, 7035, 6783, 1635, 6654, 2863, 4359, 1636, 1637, 7165, 4360, 1638, 1639, 5206, 1640, 7245, 6000, 201, 2913, 3283, 1641, 1643, 1642, 203, 4361, 2724, 1644, 7536, 1645, 1646, 8156, 1647, 6797, 7538, 1649, 1650, 1651, 5970, 1652, 1653, 5207, 7911, 2845, 1654, 1655, 1656, 6111, 1657, 1658, 1659, 7567, 1660, 1661, 5208, 1662, 1663, 8275, 8299, 2971, 2777, 8004, 1664, 4362, 1665, 7568, 7138, 1666, 3059, 1667, 2578, 1668, 8110, 8250, 1669, 1670, 5610, 1671, 1672, 8053, 2892, 1648, 1673, 7223, 3355, 2714, 2616, 5231, 7569, 2888, 1674, 5546, 3442, 5558) AND `ShikomoriPlWord`.`plural_id` = `ShikomoriPlural`.`id`) | 16 | 16 | 1 | maybe slow |