| 0.0010 |
INSERT INTO `kmh_log_bot` (`bot_info`, `bot_name`, `bot_url`) VALUES ('216.73.217.140 : Mozilla/5.0 AppleWebKit/537.36 (KHTML, LIKE Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'Bot', '/tab/view/41') |
| 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` = '41'
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.0006 |
SELECT *
FROM `kmh_tab_link`
WHERE `link_tab_id` = '41'Speed: 0.0006 - 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` = 'GUITAR'
GROUP BY `chord_name`Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using temporary; Using filesort |
| 0.0008 |
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.0008 - 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.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
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.0005 - 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.0006 |
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.0006 - 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.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
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.0006 - 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.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
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.0006 - 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.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
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.0006 - 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.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'D'
OR `chord_name_alt` = 'D'
OR `chord_family` = 'D'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'D' asc, chord_name_alt != 'D' 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` = '5'
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` = '26'
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` = '116'
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` = '161'
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` = '213'
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` = '67'
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` = '23'
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` = '24'
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` = '25'
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` = '48'
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` = '249'
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.0007 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '49'
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.0005 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '251'
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` = '250'
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` = '45'
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` = '113'
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` = '211'
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` = 'Em'
OR `chord_name_alt` = 'Em'
OR `chord_family` = 'Em'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'Em' asc, chord_name_alt != 'Em' 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` = '35'
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` = '224'
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` = '46'
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` = '109'
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` = '78'
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` = '82'
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` = '173'
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` = '110'
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` = '79'
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.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.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
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.0005 - 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.0005 |
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.0005 - 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.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
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.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
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.0005 - 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.0005 |
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.0005 - 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.0006 |
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.0006 - 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.0006 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'D7'
OR `chord_name_alt` = 'D7'
OR `chord_family` = 'D'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'D7' asc, chord_name_alt != 'D7' 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.0005 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '24'
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` = '5'
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` = '26'
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` = '116'
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` = '161'
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` = '213'
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` = '67'
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` = '23'
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` = '25'
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` = '48'
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` = '249'
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` = '49'
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` = '251'
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` = '250'
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` = '45'
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` = '113'
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` = '211'
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` = 'Bm'
OR `chord_name_alt` = 'Bm'
OR `chord_family` = 'Bm'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'Bm' asc, chord_name_alt != 'Bm' 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` = '38'
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` = '234'
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` = '44'
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` = '39'
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` = '52'
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` = '190'
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` = '68'
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.0007 |
SELECT *
FROM `kmh_popup`
WHERE `pu_start` <= '2026-09-20'
and `pu_end` >= '2026-09-20'Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
| 0.0546 |
Total Query Execution Time |
Comments