Герои книг
(c) Redwall.Ru, 2025
| 1 x Booting (55.48%) | 55.76ms |
| 1 x Application (44.51%) | 44.74ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
select `books`.*, (select count(*) from `heroes` inner join `hero_book_appears` on `heroes`.`id` = `hero_book_appears`.`hero_id` where `books`.`id` = `hero_book_appears`.`book_id` and `heroes`.`deleted_at` is null) as `heroes_count`, (select count(*) from `heroes` inner join `hero_book_mentioned` on `heroes`.`id` = `hero_book_mentioned`.`hero_id` where `books`.`id` = `hero_book_mentioned`.`book_id` and not exists (select * from `books` inner join `hero_book_appears` on `books`.`id` = `hero_book_appears`.`book_id` where `heroes`.`id` = `hero_book_appears`.`hero_id`) and `heroes`.`deleted_at` is null) as `heroes_only_mentioned_count`, (select count(*) from `hero_aliases` inner join `hero_alias_book_appears` on `hero_aliases`.`id` = `hero_alias_book_appears`.`hero_alias_id` where `books`.`id` = `hero_alias_book_appears`.`book_id` and (not exists (select * from `hero_book_appears` where hero_book_appears.hero_id = hero_aliases.hero_id) or exists (select * from `hero_book_appears` where hero_book_appears.book_id = hero_alias_book_appears.book_id and hero_book_appears.hero_id = hero_aliases.hero_id))) as `heroes_alias_appears_count`, (select count(*) from `hero_aliases` inner join `hero_alias_book_mentioned` on `hero_aliases`.`id` = `hero_alias_book_mentioned`.`hero_alias_id` where `books`.`id` = `hero_alias_book_mentioned`.`book_id` and not exists (select * from `hero_book_appears` where hero_book_appears.hero_id = hero_aliases.hero_id)) as `heroes_alias_mentioned_count` from `books` where `book_type_id` = 122.25mslararedwall| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
200
[]
[]
0 of 0array:15 [▼ "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "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" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "lara.redwall.ru" ] ]
0 of 0array:41 [▼ "USER" => "nginx" "HOME" => "/nonexistent" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "lara.redwall.ru" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "lara.redwall.ru" "SERVER_PORT" => "443" "SERVER_ADDR" => "195.35.29.180" "REMOTE_PORT" => "29436" "REMOTE_ADDR" => "18.219.59.223" "SERVER_SOFTWARE" => "nginx/1.24.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/var/www/lara.redwall.ru/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/heroes/books" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "SCRIPT_FILENAME" => "/var/www/lara.redwall.ru/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744037719.4251 "REQUEST_TIME" => 1744037719 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 07 Apr 2025 14:55:19 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkFVdXhhc1FUSnlzZ3Rveis0UnM3MFE9PSIsInZhbHVlIjoiN3lYd0NkREdiVHpXL1ZrRTh5Z0p0cVBPVzhmT1ZTVHV4R1VKcEhCbmNHNHZIY0VWd3FIK2pTV3JsOGRmaXczNGdsemNMS294d1pmUzVMR3pFR1JzcThqeDFoNXgrU2NqNlZSM3BKV2oxK0xXcjhQcmtQcWs2YTRwT1RFRy9QbEsiLCJtYWMiOiI4MTgyOWVhOWUwMzI5NzRkNGY5MzRiYzdiMTA3M2JhZjMwOTM3ZTU0NmZjY2VjMjUyZGQxYjE4NjdiMzBmNGYyIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:55:19 GMT; Max-Age=72000; path=/; domain=lara.redwall.ru; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkFVdXhhc1FUSnlzZ3Rveis0UnM3MFE9PSIsInZhbHVlIjoiN3lYd0NkREdiVHpXL1ZrRTh5Z0p0cVBPVzhmT1ZTVHV4R1VKcEhCbmNHNHZIY0VWd3FIK2pTV3JsOGRmaXczNGdsemNMS ▶" 1 => "laravel_session=eyJpdiI6Im5rcHRvSnNkWHp3ODhMcXZBMnE4d0E9PSIsInZhbHVlIjoiQmN6UUNOQzg3bDZKMk5GTDJPcENjek5VQVdGYnkrZFdYU0lsQWRCL2tQZnIxSzRaa0o3azl6c3pkWjdBOVM2SVVETXZhcmNQaktsM2szOWRYZGZwSnNhaUFWQ1Btbjg5ako0d21zYmk4TEJvZjdab0ZPdngySEhsU0FROVdHamkiLCJtYWMiOiJhOTYyNGYwMDdkOWM2NDJlMTFmY2NkZWUzODgzNTU2YjI2MmE2ZjY3OWI1MWNjYmIyZDRjMTVhOTA3NDBiMDcyIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:55:19 GMT; Max-Age=72000; path=/; domain=lara.redwall.ru; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6Im5rcHRvSnNkWHp3ODhMcXZBMnE4d0E9PSIsInZhbHVlIjoiQmN6UUNOQzg3bDZKMk5GTDJPcENjek5VQVdGYnkrZFdYU0lsQWRCL2tQZnIxSzRaa0o3azl6c3pkWjdBOVM2SVVE ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkFVdXhhc1FUSnlzZ3Rveis0UnM3MFE9PSIsInZhbHVlIjoiN3lYd0NkREdiVHpXL1ZrRTh5Z0p0cVBPVzhmT1ZTVHV4R1VKcEhCbmNHNHZIY0VWd3FIK2pTV3JsOGRmaXczNGdsemNMS294d1pmUzVMR3pFR1JzcThqeDFoNXgrU2NqNlZSM3BKV2oxK0xXcjhQcmtQcWs2YTRwT1RFRy9QbEsiLCJtYWMiOiI4MTgyOWVhOWUwMzI5NzRkNGY5MzRiYzdiMTA3M2JhZjMwOTM3ZTU0NmZjY2VjMjUyZGQxYjE4NjdiMzBmNGYyIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:55:19 GMT; domain=lara.redwall.ru; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkFVdXhhc1FUSnlzZ3Rveis0UnM3MFE9PSIsInZhbHVlIjoiN3lYd0NkREdiVHpXL1ZrRTh5Z0p0cVBPVzhmT1ZTVHV4R1VKcEhCbmNHNHZIY0VWd3FIK2pTV3JsOGRmaXczNGdsemNMS ▶" 1 => "laravel_session=eyJpdiI6Im5rcHRvSnNkWHp3ODhMcXZBMnE4d0E9PSIsInZhbHVlIjoiQmN6UUNOQzg3bDZKMk5GTDJPcENjek5VQVdGYnkrZFdYU0lsQWRCL2tQZnIxSzRaa0o3azl6c3pkWjdBOVM2SVVETXZhcmNQaktsM2szOWRYZGZwSnNhaUFWQ1Btbjg5ako0d21zYmk4TEJvZjdab0ZPdngySEhsU0FROVdHamkiLCJtYWMiOiJhOTYyNGYwMDdkOWM2NDJlMTFmY2NkZWUzODgzNTU2YjI2MmE2ZjY3OWI1MWNjYmIyZDRjMTVhOTA3NDBiMDcyIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:55:19 GMT; domain=lara.redwall.ru; path=/; secure; httponly ◀laravel_session=eyJpdiI6Im5rcHRvSnNkWHp3ODhMcXZBMnE4d0E9PSIsInZhbHVlIjoiQmN6UUNOQzg3bDZKMk5GTDJPcENjek5VQVdGYnkrZFdYU0lsQWRCL2tQZnIxSzRaa0o3azl6c3pkWjdBOVM2SVVE ▶" ] ]
0 of 0array:4 [▼ "_token" => "75rMXaxZZQDNjsRFl4vseycvJ9S1He1DUSwzkV3P" "_previous" => array:1 [▶ "url" => "https://lara.redwall.ru/heroes/books" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]