faster.sql

SELECT 'music' AS 'type', ms.`title` as title, ms.`slug` as slug, ms.`id` as id, ma.`name` as artist, ms.`like_count` as like_count
FROM (`music_songs` ms,`music_artists` ma)
WHERE (ma.name LIKE ? OR ms.title LIKE ?)
AND ms.status = 1
AND ms.artist_id = ma.id
ORDER BY ms.`like_count` DESC

slow.sql

SELECT 'music' AS 'type', ms.`title` as title, ms.`slug` as slug, ms.`id` as id, ma.`name` as artist, ms.`like_count` as like_count
FROM `music_songs` ms JOIN `music_artists` ma ON ms.artist_id = ma.id
WHERE (ma.name LIKE ? OR ms.title LIKE ?)
AND ms.status = 1
ORDER BY ms.`like_count` DESC;