Виктор Сигалов пишет морфоскрипты — интерактивные сны, заменившие людям игры, кино и книги. Как все авторы, он считает себя гением и втайне мечтает создать виртуальную реальность, равную реальному миру. Неожиданно Виктор получает новый заказ: корпорация, о которой он прежде не слышал, просит его протестировать сложный морфоскрипт.
Изучив чужой сценарий, Сигалов обнаруживает, что неизвестный автор сумел воплотить его мечту – интерактивный сон показывает настоящую жизнь, опережающую реальный мир на несколько дней и предсказывает, что Земле грозит какая-то глобальная катастрофа. Чтобы предотвратить беду Виктору нужно разыскать настоящего автора.
Но как это сделать, если в реальном мире он не существует?
Чтобы оставить свою оценку и/или комментарий, Вам нужно войти под своей учетной записью или зарегистрироваться
Пока никто не оставил впечатление о книге...
Пока никто не оставил цитат из этой книги...
Автор | Евгений Прошкин |
Жанр | Боевая фантастика, Фантастика |
Автор | Олег Овчинников, Евгений Прошкин |
Жанр | Боевая фантастика, Фантастика |
Год | 2011 |
Автор | Олег Овчинников, Евгений Прошкин |
Жанр | Боевая фантастика, Фантастика |
Год | 2011 |
Автор | Олег Овчинников, Евгений Прошкин |
Жанр | Боевая фантастика, Фантастика |
Год | 2011 |
Автор | Олег Овчинников, Евгений Прошкин |
Жанр | Боевая фантастика, Фантастика |
Автор | Олег Овчинников, Евгений Прошкин |
Жанр | Боевая фантастика, Фантастика |
Год | 2011 |
Автор | Альбер Робида |
Жанр | Научная Фантастика, Фантастика |
Год | 1894 |
Автор | Бет Рэвис |
Жанр | Научная Фантастика, Фантастика |
Год | 2013 |
Автор | Георгий Попов |
Жанр | Научная Фантастика, Фантастика |
Год | 1976 |
Автор | Аркадий Стругацкий, Борис Стругацкий, Андрей Измайлов, Вячеслав Рыбаков, Александр Тюрин, Александр Щёголев, Михаил Гаёхо |
Жанр | Научная Фантастика, Фантастика |
Год | 1991 |
Автор | Орсон Кард |
Жанр | Научная Фантастика, Фантастика |
Год | 2005 |
Автор | Орсон Кард |
Жанр | Научная Фантастика, Фантастика |
Год | 2005 |
1 x Application (97.87%) | 2.68s |
1 x Booting (2.12%) | 58.02ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
select * from `books` where `public` = 1 and `title` = 'В режиме бога' and MATCH (author) AGAINST ('\"Прошкин Евгений\"') order by `num_downloads` desc limit 1
181ms/app/Traits/HasCanonical.php:17paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `books` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | books |
partitions | null |
type | fulltext |
possible_keys | public,public_date,public_year,title,title_2,author |
key | author |
key_len | 0 |
ref | const |
rows | 1 |
filtered | 5 |
Extra | Using where; Ft_hints: no_ranking; Using filesort |
select `blocked` from `books` where `id` = 340098 limit 1
4.82ms/app/Http/Controllers/BooksController.php:84paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `books` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | books |
partitions | null |
type | const |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 340098 and `is_duplicate` = 0
7.61ms/app/Http/Controllers/BooksController.php:207paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select count(*) as aggregate from `books` inner join `book_genre` on `books`.`id` = `book_genre`.`book_id` where `book_genre`.`genre_id` = 12113
868ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23paraknigMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
686121Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | genre_id_book_id |
key_len | 4 |
ref | const |
rows | 68612 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `books` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | books |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.book_id |
rows | 1 |
filtered | 100 |
Extra | Using index |
select `books`.*, `book_genre`.`genre_id` as `pivot_genre_id`, `book_genre`.`book_id` as `pivot_book_id` from `books` inner join `book_genre` on `books`.`id` = `book_genre`.`book_id` where `book_genre`.`genre_id` = 12113 and `public` = 1 and `num_downloads` > 100 and `id` = '245675' limit 1
42.74ms/app/Http/Controllers/BooksController.php:216paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `` (SIMPLE)
1Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | null |
partitions | null |
type | null |
possible_keys | null |
key | null |
key_len | null |
ref | null |
rows | null |
filtered | null |
Extra | no matching row in const table |
select * from `guest_impressions` where `book_id` = 340098 limit 3
12.47ms/app/Http/Controllers/BooksController.php:222paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `guest_impressions` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | guest_impressions |
partitions | null |
type | ref |
possible_keys | book_id_idx |
key | book_id_idx |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 340098 and `is_duplicate` = 0
14.66ms/app/Book.php:163paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select * from `liters` where `liters`.`id` = 340098 and `liters`.`id` is not null limit 1
15.95msview::books.view:113paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `liters` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | liters |
partitions | null |
type | const |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select * from `book_files` where `book_files`.`book_id` = 340098 and `book_files`.`book_id` is not null and `is_downloadable` = 1
13.08ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `related_coollib_book_id` from `coollib_book_import` where `local_book_id` = 340098 limit 1
26.2ms/app/Book.php:716paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `coollib_book_import` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | coollib_book_import |
partitions | null |
type | ref |
possible_keys | local_book_id |
key | local_book_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select count(*) as aggregate from `books` inner join `author_book` on `books`.`id` = `author_book`.`book_id` where `author_book`.`author_id` = 10943
17.16ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23paraknigMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
451Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | author_id_book_id |
key_len | 4 |
ref | const |
rows | 45 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `books` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | books |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.book_id |
rows | 1 |
filtered | 100 |
Extra | Using where; Using index |
select `books`.*, `author_book`.`author_id` as `pivot_author_id`, `author_book`.`book_id` as `pivot_book_id` from `books` inner join `author_book` on `books`.`id` = `author_book`.`book_id` where `author_book`.`author_id` = 10943 and `public` = 1 and `books`.`id` <> 340098 limit 6
13.88ms/app/Author.php:195paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
451Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | author_id_book_id |
key_len | 4 |
ref | const |
rows | 45 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `books` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | books |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,public,public_date,public_year |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.book_id |
rows | 1 |
filtered | 49.99995422363281 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 165877 and `is_duplicate` = 0
13.36msview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 165877 and `book_files`.`book_id` is not null and `is_downloadable` = 1
11.56ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 165877 and `is_duplicate` = 0
16.49ms/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 168295 and `is_duplicate` = 0
18.84msview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 168295 and `book_files`.`book_id` is not null and `is_downloadable` = 1
3.65ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 168295 and `is_duplicate` = 0
3.66ms/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 170286 and `is_duplicate` = 0
9.3msview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 170286 and `book_files`.`book_id` is not null and `is_downloadable` = 1
4.45ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 170286 and `is_duplicate` = 0
13.55ms/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 172741 and `is_duplicate` = 0
25.99msview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 172741 and `book_files`.`book_id` is not null and `is_downloadable` = 1
23.32ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 172741 and `is_duplicate` = 0
7.02ms/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 193806 and `is_duplicate` = 0
20.32msview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 193806 and `book_files`.`book_id` is not null and `is_downloadable` = 1
11.84ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 193806 and `is_duplicate` = 0
13.53ms/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 195507 and `is_duplicate` = 0
22.27msview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 195507 and `book_files`.`book_id` is not null and `is_downloadable` = 1
11.82ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 195507 and `is_duplicate` = 0
24.01ms/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select count(*) as aggregate from `books` inner join `book_genre` on `books`.`id` = `book_genre`.`book_id` where `book_genre`.`genre_id` = 12113
463ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23paraknigMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
686121Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | genre_id_book_id |
key_len | 4 |
ref | const |
rows | 68612 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `books` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | books |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.book_id |
rows | 1 |
filtered | 100 |
Extra | Using index |
select `books`.*, `book_genre`.`genre_id` as `pivot_genre_id`, `book_genre`.`book_id` as `pivot_book_id` from `books` inner join `book_genre` on `books`.`id` = `book_genre`.`book_id` where `book_genre`.`genre_id` = 12113 and `public` = 1 and `books`.`id` <> 340098 limit 6
24.26ms/app/Genre.php:112paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
693381Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | range |
possible_keys | genre_id_book_id,book_id_genre_id |
key | genre_id_book_id |
key_len | 8 |
ref | null |
rows | 69338 |
filtered | 100 |
Extra | Using where; Using index |
- EXPLAIN #1: `books` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | books |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,public,public_date,public_year |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.book_id |
rows | 1 |
filtered | 49.99995422363281 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 147125 and `is_duplicate` = 0
10.72msview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 147125 and `book_files`.`book_id` is not null and `is_downloadable` = 1
380μs/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 147125 and `is_duplicate` = 0
640μs/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 147175 and `is_duplicate` = 0
930μsview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 147175 and `book_files`.`book_id` is not null and `is_downloadable` = 1
2.27ms/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 147175 and `is_duplicate` = 0
450μs/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 147194 and `is_duplicate` = 0
790μsview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 147194 and `is_duplicate` = 0
700μs/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 147259 and `is_duplicate` = 0
680μsview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 147259 and `book_files`.`book_id` is not null and `is_downloadable` = 1
710μs/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 147259 and `is_duplicate` = 0
540μs/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
71Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 7 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 147308 and `is_duplicate` = 0
950μsview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 147308 and `book_files`.`book_id` is not null and `is_downloadable` = 1
540μs/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 147308 and `is_duplicate` = 0
430μs/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
select `genres`.*, `book_genre`.`book_id` as `pivot_book_id`, `book_genre`.`genre_id` as `pivot_genre_id` from `genres` inner join `book_genre` on `genres`.`id` = `book_genre`.`genre_id` where `book_genre`.`book_id` = 147313 and `is_duplicate` = 0
810μsview::books.book:14paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_genre` (SIMPLE)
21Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_genre |
partitions | null |
type | ref |
possible_keys | genre_id_book_id,book_id_genre_id |
key | book_id_genre_id |
key_len | 4 |
ref | const |
rows | 2 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `genres` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | genres |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY |
key | PRIMARY |
key_len | 4 |
ref | paraknig.book_genre.genre_id |
rows | 1 |
filtered | 10 |
Extra | Using where |
select * from `book_files` where `book_files`.`book_id` = 147313 and `book_files`.`book_id` is not null and `is_downloadable` = 1
350μs/app/Book.php:1206paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `book_files` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | book_files |
partitions | null |
type | ref |
possible_keys | book_files_book_id_index,book_files_is_downloadable_index |
key | book_files_book_id_index |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 50 |
Extra | Using where |
select `authors`.*, `author_book`.`book_id` as `pivot_book_id`, `author_book`.`author_id` as `pivot_author_id` from `authors` inner join `author_book` on `authors`.`id` = `author_book`.`author_id` where `author_book`.`book_id` = 147313 and `is_duplicate` = 0
410μs/app/Book.php:235paraknigMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN #1: `author_book` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | author_book |
partitions | null |
type | ref |
possible_keys | book_id_author_id,author_id_book_id |
key | book_id_author_id |
key_len | 4 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | Using index |
- EXPLAIN #1: `authors` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | authors |
partitions | null |
type | eq_ref |
possible_keys | PRIMARY,is_duplicate |
key | PRIMARY |
key_len | 4 |
ref | paraknig.author_book.author_id |
rows | 1 |
filtered | 49.99987030029297 |
Extra | Using where |
200
[]
[]
0 of 0array:25 [▶ "host" => array:1 [▶ 0 => "paraknig.me" ] "x-forwarded-for" => array:1 [▶ 0 => "3.16.212.250" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "connection" => array:1 [▶ 0 => "close" ] "cf-ray" => array:1 [▶ 0 => "8f48ce3cbde1acac-ORD" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "cf-connecting-ip" => array:1 [▶ 0 => "3.16.212.250" ] "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImhDeWNxYUJMOVlob1Z4NWY5V1FMTVE9PSIsInZhbHVlIjoieGVlSFVsc0Q5WlNYNDRISWxBd3ZZdlMxdXZyNCs2dFZHbVwva0J2dmZlUzNCTDY4TCtybkozak91UzFYc2N0V2kiLCJtYWMiOiJhMjYwNDYxY2I2NjAyZmVlY2FjYmEwYTQ0MThkOTljNmJmZWRmZTg4ZjQ3YTNkOTQ5ZWM0Yjc1OGNiNmJhOTE5In0%3D; laravel_session=eyJpdiI6IkxwQjJkbzI4dTUxUG5NZm1sMTFtMmc9PSIsInZhbHVlIjoiTTAyRFwvUGJXK0FwMHV4M1ZtekQrN1VUQnkrQnNEcm5LVzQwVHcxK2tJY3NKK0NiTG55dmRuTFpwSXN5M0NFVHkiLCJtYWMiOiJiNTAxMjAzMDk5ZDRhY2Q0Mjk0MTdlNzM3NjQ3OTA2MDgyNjIyY2M3ODNiYjFhZmNiZjIxYTliMzhjN2Y5Y2NjIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImhDeWNxYUJMOVlob1Z4NWY5V1FMTVE9PSIsInZhbHVlIjoieGVlSFVsc0Q5WlNYNDRISWxBd3ZZdlMxdXZyNCs2dFZHbVwva0J2dmZlUzNCTDY4TCtybkozak91UzFYc2N0V2kiLCJtY ▶" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] ]
0 of 0array:52 [▶ "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "HTTP_HOST" => "paraknig.me" "HTTP_X_FORWARDED_FOR" => "3.16.212.250" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_CONNECTION" => "close" "HTTP_CF_RAY" => "8f48ce3cbde1acac-ORD" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_CF_CONNECTING_IP" => "3.16.212.250" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6ImhDeWNxYUJMOVlob1Z4NWY5V1FMTVE9PSIsInZhbHVlIjoieGVlSFVsc0Q5WlNYNDRISWxBd3ZZdlMxdXZyNCs2dFZHbVwva0J2dmZlUzNCTDY4TCtybkozak91UzFYc2N0V2kiLCJtYWMiOiJhMjYwNDYxY2I2NjAyZmVlY2FjYmEwYTQ0MThkOTljNmJmZWRmZTg4ZjQ3YTNkOTQ5ZWM0Yjc1OGNiNmJhOTE5In0%3D; laravel_session=eyJpdiI6IkxwQjJkbzI4dTUxUG5NZm1sMTFtMmc9PSIsInZhbHVlIjoiTTAyRFwvUGJXK0FwMHV4M1ZtekQrN1VUQnkrQnNEcm5LVzQwVHcxK2tJY3NKK0NiTG55dmRuTFpwSXN5M0NFVHkiLCJtYWMiOiJiNTAxMjAzMDk5ZDRhY2Q0Mjk0MTdlNzM3NjQ3OTA2MDgyNjIyY2M3ODNiYjFhZmNiZjIxYTliMzhjN2Y5Y2NjIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImhDeWNxYUJMOVlob1Z4NWY5V1FMTVE9PSIsInZhbHVlIjoieGVlSFVsc0Q5WlNYNDRISWxBd3ZZdlMxdXZyNCs2dFZHbVwva0J2dmZlUzNCTDY4TCtybkozak91UzFYc2N0V2kiLCJtY ▶" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.41 (Ubuntu) Server at paraknig.me Port 80</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.41 (Ubuntu)" "SERVER_NAME" => "paraknig.me" "SERVER_ADDR" => "127.0.0.1" "SERVER_PORT" => "80" "REMOTE_ADDR" => "108.162.216.73" "DOCUMENT_ROOT" => "/var/www/paraknig/data/www/paraknig.me/public" "REQUEST_SCHEME" => "http" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/paraknig/data/www/paraknig.me/public" "SERVER_ADMIN" => "webmaster@paraknig.me" "SCRIPT_FILENAME" => "/var/www/paraknig/data/www/paraknig.me/public/index.php" "REMOTE_PORT" => "44574" "REDIRECT_URL" => "/view/340098" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.0" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/view/340098" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1734626124.3601 "REQUEST_TIME" => 1734626124 ]
0 of 0array:2 [▶ "XSRF-TOKEN" => "SnwuLyJ5o4CngA7U9EWjyXdnmOApjfOo0oE9pBuS" "laravel_session" => "K6Kxv7t9NCaVPesag2aWDgmmVoWlHFYx84idYb60" ]
0 of 0array:7 [▶ "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Thu, 19 Dec 2024 16:35:25 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => -1 ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkRYOWZVdFZmc2pGTEl2b2JOeXBtVkE9PSIsInZhbHVlIjoiY1BqVmF4d3F3WGxzbE0wZlRJQjNReHdpekRnVDdDdVRpTkRnRDhFalpIbmF6OTU5NUoxaEhlT3gzc1JRZDZMVSIsIm1hYyI6IjkzOGVlNTc2NjE3YWE5ZjE0NjFlMDQwMTZkOGM4NzI0MDE5Mjc5ZTMwZTgxZGE1Yjc2NjZiNDc0ODRlZWE3NDYifQ%3D%3D; expires=Thu, 19-Dec-2024 18:35:27 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkRYOWZVdFZmc2pGTEl2b2JOeXBtVkE9PSIsInZhbHVlIjoiY1BqVmF4d3F3WGxzbE0wZlRJQjNReHdpekRnVDdDdVRpTkRnRDhFalpIbmF6OTU5NUoxaEhlT3gzc1JRZDZMVSIsIm1hY ▶" 1 => "laravel_session=eyJpdiI6IlwvYkRlZlpVS0tIcUkzWDNVUUJPcGNnPT0iLCJ2YWx1ZSI6IlRvdm95QWRVY1h4aVQ3Q29iZ2xxTTFMdFhzVGxJZTVCdWxVWUtSQys5bEVCS0R6ZEIyQ2Zrc01SNHlmOXVwcDEiLCJtYWMiOiIyZDliZjM5ZTljMDY2ZGYzN2Q1M2IxNjk3NTFiOWVmMmQwZDFlMDEwNmU0ZTdiZDJhZWJhOTc5OTA5ZmIyNWYzIn0%3D; expires=Thu, 19-Dec-2024 18:35:27 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IlwvYkRlZlpVS0tIcUkzWDNVUUJPcGNnPT0iLCJ2YWx1ZSI6IlRvdm95QWRVY1h4aVQ3Q29iZ2xxTTFMdFhzVGxJZTVCdWxVWUtSQys5bEVCS0R6ZEIyQ2Zrc01SNHlmOXVwcDEi ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkRYOWZVdFZmc2pGTEl2b2JOeXBtVkE9PSIsInZhbHVlIjoiY1BqVmF4d3F3WGxzbE0wZlRJQjNReHdpekRnVDdDdVRpTkRnRDhFalpIbmF6OTU5NUoxaEhlT3gzc1JRZDZMVSIsIm1hYyI6IjkzOGVlNTc2NjE3YWE5ZjE0NjFlMDQwMTZkOGM4NzI0MDE5Mjc5ZTMwZTgxZGE1Yjc2NjZiNDc0ODRlZWE3NDYifQ%3D%3D; expires=Thu, 19-Dec-2024 18:35:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkRYOWZVdFZmc2pGTEl2b2JOeXBtVkE9PSIsInZhbHVlIjoiY1BqVmF4d3F3WGxzbE0wZlRJQjNReHdpekRnVDdDdVRpTkRnRDhFalpIbmF6OTU5NUoxaEhlT3gzc1JRZDZMVSIsIm1hY ▶" 1 => "laravel_session=eyJpdiI6IlwvYkRlZlpVS0tIcUkzWDNVUUJPcGNnPT0iLCJ2YWx1ZSI6IlRvdm95QWRVY1h4aVQ3Q29iZ2xxTTFMdFhzVGxJZTVCdWxVWUtSQys5bEVCS0R6ZEIyQ2Zrc01SNHlmOXVwcDEiLCJtYWMiOiIyZDliZjM5ZTljMDY2ZGYzN2Q1M2IxNjk3NTFiOWVmMmQwZDFlMDEwNmU0ZTdiZDJhZWJhOTc5OTA5ZmIyNWYzIn0%3D; expires=Thu, 19-Dec-2024 18:35:27 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlwvYkRlZlpVS0tIcUkzWDNVUUJPcGNnPT0iLCJ2YWx1ZSI6IlRvdm95QWRVY1h4aVQ3Q29iZ2xxTTFMdFhzVGxJZTVCdWxVWUtSQys5bEVCS0R6ZEIyQ2Zrc01SNHlmOXVwcDEi ▶" ] ]
0 of 0array:4 [▶ "_token" => "SnwuLyJ5o4CngA7U9EWjyXdnmOApjfOo0oE9pBuS" "_previous" => array:1 [▶ "url" => "https://paraknig.me/view/340098" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]