| 1 |
3.40 ms |
SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result LIMIT 10
SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result LIMIT 10;
|
| 2 |
0.23 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7, b0_.editor_id AS editor_id_8, b0_.created_by_id AS created_by_id_9 FROM book b0_ WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
1
103
109
113
125
131
2
112
114
117
]
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7, b0_.editor_id AS editor_id_8, b0_.created_by_id AS created_by_id_9 FROM book b0_ WHERE b0_.id IN (1, 103, 109, 113, 125, 131, 2, 112, 114, 117);
|
| 3 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 1;
|
| 4 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 1;
|
| 5 |
0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 2;
|
| 6 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 2;
|
| 7 |
0.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 103;
|
| 8 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 103;
|
| 9 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 109;
|
| 10 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 109;
|
| 11 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 112;
|
| 12 |
0.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 112;
|
| 13 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 113;
|
| 14 |
0.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 113;
|
| 15 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 114;
|
| 16 |
0.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 114;
|
| 17 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 117;
|
| 18 |
0.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 117;
|
| 19 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 125;
|
| 20 |
0.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 125;
|
| 21 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_birth AS date_of_birth_3, t0.date_of_death AS date_of_death_4, t0.nationality AS nationality_5 FROM author t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = 131;
|
| 22 |
0.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.published_at AS published_at_5, t0.content AS content_6, t0.status AS status_7, t0.book_id AS book_id_8 FROM comment t0 WHERE t0.book_id = 131;
|
| 23 |
0.13 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.cover AS cover_3, b0_.edited_at AS edited_at_4, b0_.plot AS plot_5, b0_.status AS status_6, b0_.page_number AS page_number_7 FROM book b0_) dctrn_result) dctrn_table;
|