0.0046 |
INSERT INTO `kmh_log_bot` (`bot_info`, `bot_name`, `bot_url`) VALUES ('44.197.111.121 : CCBot/2.0 (https://commoncrawl.org/faq/)', 'Bot', '/tab/view/111') |
0.0025 |
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` = '111'
and `tab_public` = 1Speed: 0.0025 - 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.0020 |
SELECT *
FROM `kmh_tab_link`
WHERE `link_tab_id` = '111'Speed: 0.0020 - Possible keys: link_tab_id - Key Used: link_tab_id - Type: ref - Rows: 1 - Extra: |
0.0021 |
SELECT `chord_name`, `chord_name_alt`
FROM `kmh_tab_chord`
WHERE `chord_type` = 'GUITAR'
GROUP BY `chord_name`Speed: 0.0021 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using temporary; Using filesort |
0.0027 |
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.0027 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0016 |
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.0016 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0016 |
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.0016 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0016 |
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.0016 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0022 |
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.0022 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0022 |
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.0022 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
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.0020 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0025 |
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.0025 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0024 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'Am7'
OR `chord_name_alt` = 'Am7'
OR `chord_family` = 'Am'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'Am7' asc, chord_name_alt != 'Am7' 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.0024 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0022 |
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.0022 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0020 |
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0022 |
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.0022 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0022 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'Dm7'
OR `chord_name_alt` = 'Dm7'
OR `chord_family` = 'Dm'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'Dm7' asc, chord_name_alt != 'Dm7' 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.0022 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0020 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '47'
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '34'
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '223'
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0016 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '221'
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.0016 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0016 |
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.0016 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0032 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'C7'
OR `chord_name_alt` = 'C7'
OR `chord_family` = 'C'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'C7' asc, chord_name_alt != 'C7' 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.0032 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0025 |
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.0025 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0026 |
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.0026 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0024 |
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.0024 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0024 |
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.0024 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0024 |
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.0024 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0022 |
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.0022 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0025 |
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.0025 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0043 |
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.0043 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0024 |
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.0024 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0019 |
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.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0017 |
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.0017 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0024 |
SELECT *
FROM `kmh_tab_chord`
WHERE (
`chord_name` = 'Dm'
OR `chord_name_alt` = 'Dm'
OR `chord_family` = 'Dm'
)
and `chord_type` = 'GUITAR'
ORDER BY chord_name != 'Dm' asc, chord_name_alt != 'Dm' 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.0024 - Possible keys: - Key Used: - Type: ALL - Rows: 230 - Extra: Using WHERE; Using filesort |
0.0020 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '34'
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.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0021 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '47'
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0023 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '223'
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.0023 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0018 |
SELECT *
FROM `kmh_tab_chord`
WHERE `chord_id` = '221'
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.0018 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0029 |
SELECT *
FROM `kmh_popup`
WHERE `pu_start` <= '2023-09-29'
and `pu_end` >= '2023-09-29'Speed: 0.0029 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
0.2315 |
Total Query Execution Time |
Comments