Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ra_id AS ra_id_3,
  t0.abbreviation AS abbreviation_4,
  t0.external_link AS external_link_5,
  t0.start_date AS start_date_6,
  t0.start_date_accuracy AS start_date_accuracy_7,
  t0.end_date AS end_date_8,
  t0.end_date_accuracy AS end_date_accuracy_9,
  t0.description AS description_10,
  t0.research_notes AS research_notes_11,
  t0.status AS status_12,
  t0.updated_at AS updated_at_13,
  t0.series_id AS series_id_14,
  t0.author_id AS author_id_15,
  t0.updated_by_id AS updated_by_id_16
FROM
  volumes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ra_id AS ra_id_3, t0.abbreviation AS abbreviation_4, t0.external_link AS external_link_5, t0.start_date AS start_date_6, t0.start_date_accuracy AS start_date_accuracy_7, t0.end_date AS end_date_8, t0.end_date_accuracy AS end_date_accuracy_9, t0.description AS description_10, t0.research_notes AS research_notes_11, t0.status AS status_12, t0.updated_at AS updated_at_13, t0.series_id AS series_id_14, t0.author_id AS author_id_15, t0.updated_by_id AS updated_by_id_16 FROM volumes t0 WHERE t0.id = '863';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ra_id AS ra_id_3,
  t0.abbreviation AS abbreviation_4,
  t0.external_link AS external_link_5,
  t0.start_date AS start_date_6,
  t0.start_date_accuracy AS start_date_accuracy_7,
  t0.end_date AS end_date_8,
  t0.end_date_accuracy AS end_date_accuracy_9,
  t0.description AS description_10,
  t0.research_notes AS research_notes_11,
  t0.status AS status_12,
  t0.updated_at AS updated_at_13,
  t0.series_id AS series_id_14,
  t0.author_id AS author_id_15,
  t0.updated_by_id AS updated_by_id_16
FROM
  volumes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ra_id AS ra_id_3, t0.abbreviation AS abbreviation_4, t0.external_link AS external_link_5, t0.start_date AS start_date_6, t0.start_date_accuracy AS start_date_accuracy_7, t0.end_date AS end_date_8, t0.end_date_accuracy AS end_date_accuracy_9, t0.description AS description_10, t0.research_notes AS research_notes_11, t0.status AS status_12, t0.updated_at AS updated_at_13, t0.series_id AS series_id_14, t0.author_id AS author_id_15, t0.updated_by_id AS updated_by_id_16 FROM volumes t0 WHERE t0.id = '863';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ra_id AS ra_id_3,
  t0.abbreviation AS abbreviation_4,
  t0.external_link AS external_link_5,
  t0.start_date AS start_date_6,
  t0.start_date_accuracy AS start_date_accuracy_7,
  t0.end_date AS end_date_8,
  t0.end_date_accuracy AS end_date_accuracy_9,
  t0.description AS description_10,
  t0.research_notes AS research_notes_11,
  t0.status AS status_12,
  t0.updated_at AS updated_at_13,
  t0.series_id AS series_id_14,
  t0.author_id AS author_id_15,
  t0.updated_by_id AS updated_by_id_16
FROM
  volumes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ra_id AS ra_id_3, t0.abbreviation AS abbreviation_4, t0.external_link AS external_link_5, t0.start_date AS start_date_6, t0.start_date_accuracy AS start_date_accuracy_7, t0.end_date AS end_date_8, t0.end_date_accuracy AS end_date_accuracy_9, t0.description AS description_10, t0.research_notes AS research_notes_11, t0.status AS status_12, t0.updated_at AS updated_at_13, t0.series_id AS series_id_14, t0.author_id AS author_id_15, t0.updated_by_id AS updated_by_id_16 FROM volumes t0 WHERE t0.id = '7';

SELECT
  m0_.id AS id_0,
  m0_.date AS date_1,
  m0_.date_accuracy AS date_accuracy_2,
  m0_.description AS description_3,
  m0_.text_equiv AS text_equiv_4,
  m0_.context_window AS context_window_5,
  m0_.start_page AS start_page_6,
  m0_.end_page AS end_page_7,
  m0_.start_pos AS start_pos_8,
  m0_.end_pos AS end_pos_9,
  m0_.time AS time_10,
  m0_.verb AS verb_11,
  m0_.paragraph AS paragraph_12,
  m0_.continued AS continued_13,
  m0_.entity_text AS entity_text_14,
  m0_.mention_type AS mention_type_15,
  m0_.start_text_line_id AS start_text_line_id_16,
  m0_.end_text_line_id AS end_text_line_id_17,
  m0_.actor_id AS actor_id_18,
  m0_.institution_id AS institution_id_19,
  m0_.place_id AS place_id_20,
  m0_.volume_id AS volume_id_21,
  m0_.page_id AS page_id_22,
  m0_.action_id AS action_id_23,
  m0_.mentioned_source_id AS mentioned_source_id_24,
  m0_.info_source_id AS info_source_id_25,
  m0_.event_place_id AS event_place_id_26,
  m0_.secondary_mention_id AS secondary_mention_id_27,
  m0_.secondary_actor_id AS secondary_actor_id_28
FROM
  mentions m0_
  INNER JOIN places p1_ ON m0_.place_id = p1_.id
WHERE
  m0_.volume_id = ?
  AND m0_.place_id IS NOT NULL
  AND p1_.type <> ?
  AND p1_.type <> ?

SELECT m0_.id AS id_0, m0_.date AS date_1, m0_.date_accuracy AS date_accuracy_2, m0_.description AS description_3, m0_.text_equiv AS text_equiv_4, m0_.context_window AS context_window_5, m0_.start_page AS start_page_6, m0_.end_page AS end_page_7, m0_.start_pos AS start_pos_8, m0_.end_pos AS end_pos_9, m0_.time AS time_10, m0_.verb AS verb_11, m0_.paragraph AS paragraph_12, m0_.continued AS continued_13, m0_.entity_text AS entity_text_14, m0_.mention_type AS mention_type_15, m0_.start_text_line_id AS start_text_line_id_16, m0_.end_text_line_id AS end_text_line_id_17, m0_.actor_id AS actor_id_18, m0_.institution_id AS institution_id_19, m0_.place_id AS place_id_20, m0_.volume_id AS volume_id_21, m0_.page_id AS page_id_22, m0_.action_id AS action_id_23, m0_.mentioned_source_id AS mentioned_source_id_24, m0_.info_source_id AS info_source_id_25, m0_.event_place_id AS event_place_id_26, m0_.secondary_mention_id AS secondary_mention_id_27, m0_.secondary_actor_id AS secondary_actor_id_28 FROM mentions m0_ INNER JOIN places p1_ ON m0_.place_id = p1_.id WHERE m0_.volume_id = 7 AND m0_.place_id IS NOT NULL AND p1_.type <> 1 AND p1_.type <> 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lat AS lat_3,
  t0.lng AS lng_4,
  t0.alt_names AS alt_names_5,
  t0.alvin_id AS alvin_id_6,
  t0.type AS type_7,
  t0.approximate_location AS approximate_location_8,
  t0.location_precision AS location_precision_9,
  t0.description AS description_10,
  t0.wikidata_id AS wikidata_id_11,
  t0.mindat_id AS mindat_id_12,
  t0.updated_at AS updated_at_13,
  t0.parent_id AS parent_id_14
FROM
  places t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14618;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14623;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14625;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14630;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14631;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14632;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14635;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14638;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14655;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14657;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14658;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14659;

SELECT
  t0.id AS id_1,
  t0.ra_id AS ra_id_2,
  t0.thumbnail AS thumbnail_3,
  t0.updated_at AS updated_at_4,
  t0.reading_order AS reading_order_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.text_equiv AS text_equiv_8,
  t0.volume_id AS volume_id_9
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = 14663;