EXPLAIN SELECT `t`.`recipe_id` AS `t0_c0`, `ingredients`.`ingredients_id` AS `t2_c0`, `ingredients`.`recipe_id` AS `t2_c1`, `ingredients`.`product_id` AS `t2_c2`, `ingredients`.`quantity` AS `t2_c3`, `ingredients`.`option` AS `t2_c4`, `ingredients`.`priority` AS `t2_c5`, `ingredients`.`common` AS `t2_c6`, `ingredients`.`cup_conversion` AS `t2_c7`, `ingredients`.`alternate_name` AS `t2_c8` FROM `recipes` `t` LEFT OUTER JOIN `recipeIngredients` `ingredients` ON (`ingredients`.`recipe_id`=`t`.`recipe_id`) WHERE (`t`.`recipe_id` IN (385, 433, 426, 403, 332, 331, 366, 388, 375, 391, 414, 382, 325, 513, 520, 368, 507, 453, 460, 501, 455, 341, 514, 457, 400, 491, 291, 458, 522, 235, 413, 423, 365, 386, 480, 390, 469, 373, 528, 335, 78, 393, 415, 328, 399, 529, 273, 482, 483, 359, 358, 497, 346, 494, 498, 495, 496, 347, 350, 353, 352, 349, 407, 475, 84, 383, 256, 77, 479, 340, 509, 463, 323, 83, 342, 506, 405, 477, 392, 523, 369, 526, 450, 362, 419, 478, 344, 336, 439, 402, 456, 521, 527, 406, 436, 334, 364, 517, 500, 504, 459, 337, 508, 363, 467, 468, 516, 443, 228, 481, 408, 511, 360, 387, 448, 395, 409, 427, 489, 380, 492, 416, 462, 343, 499, 401, 404, 422, 441, 452, 464, 429, 371, 370, 476, 449, 377, 466, 389, 338, 438, 473, 461, 134, 447, 267, 396, 488, 339, 411, 487, 372, 329, 502, 525, 322, 424, 510, 345, 505, 418, 428, 431, 470, 333, 327, 512, 421, 515, 379, 321, 398, 374, 493, 425, 490, 378)) ORDER BY `ingredients`.priority ASC, `ingredients`.option ASC