| 0.0010 |
INSERT INTO `kmh_log_bot` (`bot_info`, `bot_name`, `bot_url`) VALUES ('216.73.217.31 : Mozilla/5.0 AppleWebKit/537.36 (KHTML, LIKE Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'Bot', '/tab/view/37') |
| 0.0007 |
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` = '37'
and `tab_public` = 1Speed: 0.0007 - 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` = '37'Speed: 0.0005 - Possible keys: link_tab_id - Key Used: link_tab_id - Type: ref - Rows: 1 - Extra: |
| 0.0006 |
SELECT `chord_name`, `chord_name_alt`
FROM `kmh_tab_chord`
WHERE `chord_type` = 'GUITAR'
GROUP BY `chord_name`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using temporary; Using filesort |
| 0.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'C'
OR `chord_name_alt` = 'C'
OR `chord_family` = 'C'
)
and `chord_type` = 'GUITAR'
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.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0005 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '1'
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` = '2'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '22'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '176'
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` = '37'
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` = '108'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '14'
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` = '15'
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.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '16'
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` = '256'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '170'
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` = '17'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '162'
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` = '158'
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` = '198'
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` = '255'
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` = '19'
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` = '107'
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` = '18'
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` = '159'
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.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'G'
OR `chord_name_alt` = 'G'
OR `chord_family` = 'G'
)
and `chord_type` = 'GUITAR'
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.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '8'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '66'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '40'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '90'
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` = '185'
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` = '225'
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` = '195'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '81'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '80'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '240'
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` = '41'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '61'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '265'
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` = '252'
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` = '51'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '222'
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` = '100'
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` = '226'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'Am'
OR `chord_name_alt` = 'Am'
OR `chord_family` = 'Am'
)
and `chord_type` = 'GUITAR'
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.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '28'
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` = '183'
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` = '227'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '71'
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` = '33'
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` = '104'
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` = '32'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'F'
OR `chord_name_alt` = 'F'
OR `chord_family` = 'F'
)
and `chord_type` = 'GUITAR'
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.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
| 0.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '3'
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` = '193'
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` = '118'
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` = '72'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '253'
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` = '76'
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` = '266'
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` = '192'
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` = '77'
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` = '238'
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` = '228'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '194'
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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '59'
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_popup`
WHERE `pu_start` <= '2026-09-20'
and `pu_end` >= '2026-09-20'Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
| 0.0376 |
Total Query Execution Time |
Comments