Slow and fast queries

slick-queries.sql

# Generated by Slick (select terms optimized for clarity)
# Takes 47034 ms
SELECT *
FROM (
	SELECT x281.id
	FROM `comp_proposal_raw_batch_comp_proposal_raw` x282, `comp_proposal_raw` x281
	WHERE (x282.`comp_proposal_raw_batch_proposals_id` = 4936) AND (x281.`id` = x282.`comp_proposal_raw_id`)
) x187
INNER JOIN (
	SELECT *
	FROM `comp_proposal_raw` x283
) x280 ON x187.id = x280.`original_id`
ORDER BY x280.`id`
LIMIT 2

# Hand-changed
# Takes 16 ms
SELECT *
FROM (
	SELECT x281.id
	FROM `comp_proposal_raw_batch_comp_proposal_raw` x282, `comp_proposal_raw` x281
	WHERE (x282.`comp_proposal_raw_batch_proposals_id` = 4936) AND (x281.`id` = x282.`comp_proposal_raw_id`)
) x187
INNER JOIN `comp_proposal_raw` x280 ON x187.id = x280.`original_id`
ORDER BY x280.`id`
LIMIT 2