| 1 |
1.53 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM mentions m0_ INNER JOIN volumes v1_ ON m0_.volume_id = v1_.id WHERE m0_.volume_id IS NOT NULL AND m0_.text_equiv LIKE ?
Parameters: [
"%S:t seba%"
]
SELECT COUNT(m0_.id) AS sclr_0 FROM mentions m0_ INNER JOIN volumes v1_ ON m0_.volume_id = v1_.id WHERE m0_.volume_id IS NOT NULL AND m0_.text_equiv LIKE '%S:t seba%';
|
| 2 |
3.70 ms |
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 volumes v1_ ON m0_.volume_id = v1_.id WHERE m0_.volume_id IS NOT NULL AND m0_.text_equiv LIKE ? ORDER BY m0_.text_equiv ASC LIMIT 50
Parameters: [
"%S:t seba%"
]
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 volumes v1_ ON m0_.volume_id = v1_.id WHERE m0_.volume_id IS NOT NULL AND m0_.text_equiv LIKE '%S:t seba%' ORDER BY m0_.text_equiv ASC LIMIT 50;
|
| 3 |
0.13 ms |
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 = 12418;
|
| 4 |
0.11 ms |
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 = 2;
|
| 5 |
0.10 ms |
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 = 12410;
|
| 6 |
0.09 ms |
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 = 12422;
|
| 7 |
0.08 ms |
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 = 12340;
|
| 8 |
0.08 ms |
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 = 12341;
|
| 9 |
0.08 ms |
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 = 14816;
|
| 10 |
0.08 ms |
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;
|
| 11 |
0.08 ms |
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 = 14673;
|