| 0.0013 |
INSERT INTO `kmh_log_bot` (`bot_info`, `bot_name`, `bot_url`) VALUES ('216.73.217.84 : Mozilla/5.0 AppleWebKit/537.36 (KHTML, LIKE Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'Bot', '/tab/view/60?chord_type=UKULELE') |
| 0.0010 |
SELECT *
FROM `kmh_tab`
JOIN `kmh_tab_song` ON `song_id` = `tab_song_id`
JOIN `kmh_tab_artist` ON `artist_id` = `song_artist_id`
JOIN `kmh_member` ON `mb_id` = `tab_mb_id`
WHERE `tab_id` = '60'
and `tab_public` = 1Speed: 0.0010 - Possible keys: PRIMARY,fk_kmh_tab_kmh_tab_song1_idx,fk_kmh_tab_kmh_member1_idx - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT *
FROM `kmh_tab_link`
WHERE `link_tab_id` = '60'Speed: 0.0005 - Possible keys: link_tab_id - Key Used: link_tab_id - Type: ref - Rows: 1 - Extra: |
| 0.0007 |
SELECT `chord_name`, `chord_name_alt`
FROM `kmh_tab_chord`
WHERE `chord_type` = 'UKULELE'
GROUP BY `chord_name`Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using temporary; Using filesort |
| 0.0012 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'Am'
OR `chord_name_alt` = 'Am'
OR `chord_family` = 'Am'
)
and `chord_type` = 'UKULELE'
ORDER BY chord_name != 'Am' asc, chord_name_alt != 'Am' asc, FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0012 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0011 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '147'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0011 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0013 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '149'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0013 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0009 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'F'
OR `chord_name_alt` = 'F'
OR `chord_family` = 'F'
)
and `chord_type` = 'UKULELE'
ORDER BY chord_name != 'F' asc, chord_name_alt != 'F' asc, FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0008 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '136'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0008 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '138'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0007 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '140'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0006 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0008 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'C'
OR `chord_name_alt` = 'C'
OR `chord_family` = 'C'
)
and `chord_type` = 'UKULELE'
ORDER BY chord_name != 'C' asc, chord_name_alt != 'C' asc, FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '21'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0006 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '122'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '124'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0009 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'G'
OR `chord_name_alt` = 'G'
OR `chord_family` = 'G'
)
and `chord_type` = 'UKULELE'
ORDER BY chord_name != 'G' asc, chord_name_alt != 'G' asc, FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0012 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '141'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0012 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0010 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '143'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0010 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0010 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '145'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0010 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'Bb'
OR `chord_name_alt` = 'Bb'
OR `chord_family` = 'A#'
)
and `chord_type` = 'UKULELE'
ORDER BY chord_name != 'Bb' asc, chord_name_alt != 'Bb' asc, FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '209'
ORDER BY FIELD(chord_family, 'C', 'Cm', 'C#', 'C#m', 'D', 'Dm', 'D#', 'D#m', 'E', 'Em', 'F', 'Fm', 'F#', 'F#m', 'G', 'Gm', 'G#', 'G#m', 'A', 'Am', 'A#', 'A#m', 'B', 'Bm'), `chord_name` ASC, `chord_order` ASC, `chord_start_fret` ASC, `chord_id` ASCSpeed: 0.0007 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0009 |
SELECT *
FROM `kmh_popup`
WHERE `pu_start` <= '2026-09-27'
and `pu_end` >= '2026-09-27'Speed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
| 0.0190 |
Total Query Execution Time |
Comments