| 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 'ɗ%') OR (`ShikomoriWord`.`word` LIKE '-ɗ%')) AND `ShikomoriWord`.`active` = '1' ORDER BY `ShikomoriWord`.`word` ASC | 133 | 133 | 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 (4750, 1391, 2851, 6254, 1896, 5328, 6800, 4987, 1897, 5825, 7358, 2965, 4415, 5756, 1899, 3244, 1900, 1901, 5824, 1902, 1903, 1904, 5823, 1905, 3326, 1906, 1907, 4881, 1908, 4880, 3209, 1909, 4416, 1910, 1911, 1912, 7394, 4442, 7038, 1301, 5841, 1913, 1914, 3661, 1915, 1916, 5494, 1917, 3181, 8308, 7359, 6061, 1918, 3373, 7396, 6347, 8109, 1919, 2728, 1920, 3474, 5828, 1922, 1923, 1924, 3287, 1925, 1926, 1927, 7401, 5568, 1928, 7402, 1929, 6683, 5829, 5941, 1931, 1932, 3042, 1933, 1934, 1935, 7066, 1936, 8102, 7068, 7067, 5871, 1937, 1938, 4421, 5434, 1940, 1941, 1942, 7158, 6131, 1944, 4833, 1945, 4766, 3329, 4986, 1946, 1948, 1947, 3379, 4417, 1949, 3288, 1950, 3237, 1951, 4418, 1952, 8090, 6869, 2505, 8179, 1954, 6953, 4419, 1956, 1957, 5140, 5260, 1958, 4420, 1959, 7130, 5704, 3693) AND `ShikomoriFrWord`.`french_id` = `FrenchWord`.`id`) ORDER BY `ShikomoriFrWord`.`position` ASC | 185 | 185 | 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 (4750, 1391, 2851, 6254, 1896, 5328, 6800, 4987, 1897, 5825, 7358, 2965, 4415, 5756, 1899, 3244, 1900, 1901, 5824, 1902, 1903, 1904, 5823, 1905, 3326, 1906, 1907, 4881, 1908, 4880, 3209, 1909, 4416, 1910, 1911, 1912, 7394, 4442, 7038, 1301, 5841, 1913, 1914, 3661, 1915, 1916, 5494, 1917, 3181, 8308, 7359, 6061, 1918, 3373, 7396, 6347, 8109, 1919, 2728, 1920, 3474, 5828, 1922, 1923, 1924, 3287, 1925, 1926, 1927, 7401, 5568, 1928, 7402, 1929, 6683, 5829, 5941, 1931, 1932, 3042, 1933, 1934, 1935, 7066, 1936, 8102, 7068, 7067, 5871, 1937, 1938, 4421, 5434, 1940, 1941, 1942, 7158, 6131, 1944, 4833, 1945, 4766, 3329, 4986, 1946, 1948, 1947, 3379, 4417, 1949, 3288, 1950, 3237, 1951, 4418, 1952, 8090, 6869, 2505, 8179, 1954, 6953, 4419, 1956, 1957, 5140, 5260, 1958, 4420, 1959, 7130, 5704, 3693) AND `ShikomoriEnWord`.`english_id` = `EnglishWord`.`id`) | 90 | 90 | 1 | |
| 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 (4750, 1391, 2851, 6254, 1896, 5328, 6800, 4987, 1897, 5825, 7358, 2965, 4415, 5756, 1899, 3244, 1900, 1901, 5824, 1902, 1903, 1904, 5823, 1905, 3326, 1906, 1907, 4881, 1908, 4880, 3209, 1909, 4416, 1910, 1911, 1912, 7394, 4442, 7038, 1301, 5841, 1913, 1914, 3661, 1915, 1916, 5494, 1917, 3181, 8308, 7359, 6061, 1918, 3373, 7396, 6347, 8109, 1919, 2728, 1920, 3474, 5828, 1922, 1923, 1924, 3287, 1925, 1926, 1927, 7401, 5568, 1928, 7402, 1929, 6683, 5829, 5941, 1931, 1932, 3042, 1933, 1934, 1935, 7066, 1936, 8102, 7068, 7067, 5871, 1937, 1938, 4421, 5434, 1940, 1941, 1942, 7158, 6131, 1944, 4833, 1945, 4766, 3329, 4986, 1946, 1948, 1947, 3379, 4417, 1949, 3288, 1950, 3237, 1951, 4418, 1952, 8090, 6869, 2505, 8179, 1954, 6953, 4419, 1956, 1957, 5140, 5260, 1958, 4420, 1959, 7130, 5704, 3693) 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 (4750, 1391, 2851, 6254, 1896, 5328, 6800, 4987, 1897, 5825, 7358, 2965, 4415, 5756, 1899, 3244, 1900, 1901, 5824, 1902, 1903, 1904, 5823, 1905, 3326, 1906, 1907, 4881, 1908, 4880, 3209, 1909, 4416, 1910, 1911, 1912, 7394, 4442, 7038, 1301, 5841, 1913, 1914, 3661, 1915, 1916, 5494, 1917, 3181, 8308, 7359, 6061, 1918, 3373, 7396, 6347, 8109, 1919, 2728, 1920, 3474, 5828, 1922, 1923, 1924, 3287, 1925, 1926, 1927, 7401, 5568, 1928, 7402, 1929, 6683, 5829, 5941, 1931, 1932, 3042, 1933, 1934, 1935, 7066, 1936, 8102, 7068, 7067, 5871, 1937, 1938, 4421, 5434, 1940, 1941, 1942, 7158, 6131, 1944, 4833, 1945, 4766, 3329, 4986, 1946, 1948, 1947, 3379, 4417, 1949, 3288, 1950, 3237, 1951, 4418, 1952, 8090, 6869, 2505, 8179, 1954, 6953, 4419, 1956, 1957, 5140, 5260, 1958, 4420, 1959, 7130, 5704, 3693) AND `ShikomoriPlWord`.`plural_id` = `ShikomoriPlural`.`id`) | 56 | 56 | 1 | |