Symfony Profiler

SELECT
  i0_.id AS id_0
FROM
  illustration i0_
  INNER JOIN card_face c1_ ON i0_.preferred_card_face_id = c1_.id
  INNER JOIN card_print c2_ ON c1_.card_print_id = c2_.id
  INNER JOIN card_concept c3_ ON c2_.card_concept_id = c3_.id
WHERE
  c2_.retired_at IS NULL
GROUP BY
  i0_.id
ORDER BY
  RAND() ASC
LIMIT
  1

SELECT i0_.id AS id_0 FROM illustration i0_ INNER JOIN card_face c1_ ON i0_.preferred_card_face_id = c1_.id INNER JOIN card_print c2_ ON c1_.card_print_id = c2_.id INNER JOIN card_concept c3_ ON c2_.card_concept_id = c3_.id WHERE c2_.retired_at IS NULL GROUP BY i0_.id ORDER BY RAND() ASC LIMIT 1;

SELECT
  DISTINCT i0_.id AS id_0,
  i0_.code AS code_1,
  i0_.preferred_card_face_reviewed_at AS preferred_card_face_reviewed_at_2,
  i0_.scryfall_illustration_id AS scryfall_illustration_id_3,
  i0_.is_available AS is_available_4,
  i0_.created_at AS created_at_5,
  i0_.updated_at AS updated_at_6,
  c1_.id AS id_7,
  c1_.face_index AS face_index_8,
  c1_.flavor_text AS flavor_text_9,
  c1_.type_line AS type_line_10,
  c1_.mana_cost AS mana_cost_11,
  c1_.colors_mask AS colors_mask_12,
  c1_.image_uris AS image_uris_13,
  c1_.image_source AS image_source_14,
  c1_.image_status AS image_status_15,
  c1_.val_hash AS val_hash_16,
  c1_.created_at AS created_at_17,
  c1_.updated_at AS updated_at_18,
  c2_.id AS id_19,
  c2_.code AS code_20,
  c2_.collector_number AS collector_number_21,
  c2_.rarity AS rarity_22,
  c2_.scryfall_card_id AS scryfall_card_id_23,
  c2_.content_warning AS content_warning_24,
  c2_.full_art AS full_art_25,
  c2_.textless AS textless_26,
  c2_.uris AS uris_27,
  c2_.released_at AS released_at_28,
  c2_.retired_at AS retired_at_29,
  c2_.val_hash AS val_hash_30,
  c2_.created_at AS created_at_31,
  c2_.updated_at AS updated_at_32,
  c3_.id AS id_33,
  c3_.code AS code_34,
  c3_.scryfall_oracle_id AS scryfall_oracle_id_35,
  c3_.name AS name_36,
  c3_.name_search AS name_search_37,
  c3_.layout AS layout_38,
  c3_.type_line AS type_line_39,
  c3_.color_identity_mask AS color_identity_mask_40,
  c3_.val_hash AS val_hash_41,
  c3_.created_at AS created_at_42,
  c3_.updated_at AS updated_at_43,
  i0_.preferred_card_face_id AS preferred_card_face_id_44,
  c1_.card_print_id AS card_print_id_45,
  c2_.card_concept_id AS card_concept_id_46,
  c2_.expansion_set_id AS expansion_set_id_47
FROM
  illustration i0_
  INNER JOIN card_face c1_ ON i0_.preferred_card_face_id = c1_.id
  INNER JOIN card_print c2_ ON c1_.card_print_id = c2_.id
  INNER JOIN card_concept c3_ ON c2_.card_concept_id = c3_.id
WHERE
  c2_.retired_at IS NULL
  AND i0_.id IN (?)

SELECT DISTINCT i0_.id AS id_0, i0_.code AS code_1, i0_.preferred_card_face_reviewed_at AS preferred_card_face_reviewed_at_2, i0_.scryfall_illustration_id AS scryfall_illustration_id_3, i0_.is_available AS is_available_4, i0_.created_at AS created_at_5, i0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.face_index AS face_index_8, c1_.flavor_text AS flavor_text_9, c1_.type_line AS type_line_10, c1_.mana_cost AS mana_cost_11, c1_.colors_mask AS colors_mask_12, c1_.image_uris AS image_uris_13, c1_.image_source AS image_source_14, c1_.image_status AS image_status_15, c1_.val_hash AS val_hash_16, c1_.created_at AS created_at_17, c1_.updated_at AS updated_at_18, c2_.id AS id_19, c2_.code AS code_20, c2_.collector_number AS collector_number_21, c2_.rarity AS rarity_22, c2_.scryfall_card_id AS scryfall_card_id_23, c2_.content_warning AS content_warning_24, c2_.full_art AS full_art_25, c2_.textless AS textless_26, c2_.uris AS uris_27, c2_.released_at AS released_at_28, c2_.retired_at AS retired_at_29, c2_.val_hash AS val_hash_30, c2_.created_at AS created_at_31, c2_.updated_at AS updated_at_32, c3_.id AS id_33, c3_.code AS code_34, c3_.scryfall_oracle_id AS scryfall_oracle_id_35, c3_.name AS name_36, c3_.name_search AS name_search_37, c3_.layout AS layout_38, c3_.type_line AS type_line_39, c3_.color_identity_mask AS color_identity_mask_40, c3_.val_hash AS val_hash_41, c3_.created_at AS created_at_42, c3_.updated_at AS updated_at_43, i0_.preferred_card_face_id AS preferred_card_face_id_44, c1_.card_print_id AS card_print_id_45, c2_.card_concept_id AS card_concept_id_46, c2_.expansion_set_id AS expansion_set_id_47 FROM illustration i0_ INNER JOIN card_face c1_ ON i0_.preferred_card_face_id = c1_.id INNER JOIN card_print c2_ ON c1_.card_print_id = c2_.id INNER JOIN card_concept c3_ ON c2_.card_concept_id = c3_.id WHERE c2_.retired_at IS NULL AND i0_.id IN (44704);

SELECT
  i0_.credited_name AS credited_name_0
FROM
  illustration_artist i0_
WHERE
  i0_.illustration_id = ?
ORDER BY
  i0_.credit_order ASC
LIMIT
  1

SELECT i0_.credited_name AS credited_name_0 FROM illustration_artist i0_ WHERE i0_.illustration_id = 44704 ORDER BY i0_.credit_order ASC LIMIT 1;