1 x Application (99.27%) | 2.10s |
1 x Booting (0.73%) | 15.39ms |
Backtrace |
|
select * from `pb_book_m` where `asin` = '4086192225' limit 1
Bindings |
|
Backtrace |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4086192225' limit 1
Bindings |
|
Backtrace |
|
update `pb_book_m` set `pb_book_m`.`update_at` = '2024-12-13 04:26:11' where `id` = 46996
Bindings |
|
Backtrace |
|
select * from `pb_book_genre_t` where `pb_book_genre_t`.`book_id` = 46996
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 46996 and `genre_id` in (2278488051)
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 46996 and `genre_id` in (466280)
Bindings |
|
Backtrace |
|
select * from `pb_name_person_m` where `search_name` = '宮川匡代' and `del_flg` = 0 and `pb_name_person_m`.`del_flg` = 0 limit 1
Bindings |
|
Backtrace |
|
select * from `pb_book_name_person_t` where `pb_book_name_person_t`.`book_id` = 46996
Bindings |
|
Backtrace |
|
update `pb_book_name_person_t` set `sort_order` = 0, `del_flg` = 0 where `pb_book_name_person_t`.`book_id` = 46996 and `name_person_id` in (2229)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `book_id`, `genre_id` from `pb_book_genre_t` where `book_id` not in (select `book_id` from `pb_book_genre_t` where `genre_id` in (467278, 492042, 12075891))) as bg where `bg`.`book_id` = 46996 and `bg`.`genre_id` in (2278488051, 12075851)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `pb_book_genre_t` as `bg` left join `pb_genre_m` as `g` on `g`.`id` = `bg`.`genre_id` where `bg`.`book_id` = 46996 and `g`.`del_flg` != 0
Bindings |
|
Backtrace |
|
select * from `pb_book_index_m` where `pb_book_index_m`.`book_id` = 46996 and `pb_book_index_m`.`book_id` is not null limit 1
Bindings |
|
Backtrace |
|
update `pb_book_index_m` set `genre_del_flg` = 0, `comic_flg` = 1, `updated_at` = '2024-12-13 04:26:11' where `book_id` = 46996
Bindings |
|
Backtrace |
|
Backtrace |
|
select `id` from `pb_book_m` where `asin` in ('4086192225') and `pb_book_m`.`del_flg` = 0
Bindings |
|
Backtrace |
|
select `pn`.`person_id`, `np`.`name`, `np`.`name_kana`, `p`.`publish_flg` from `pb_book_name_person_t` left join `pb_book_index_m` as `bi` on `pb_book_name_person_t`.`book_id` = `bi`.`book_id` left join `pb_name_person_m` as `np` on `pb_book_name_person_t`.`name_person_id` = `np`.`id` left join `pb_person_name_t` as `pn` on `pb_book_name_person_t`.`name_person_id` = `pn`.`name_person_id` left join `pb_person_m` as `p` on `pn`.`person_id` = `p`.`id` where `bi`.`asin` = '4086192225' and `pb_book_name_person_t`.`del_flg` = 0 order by `pb_book_name_person_t`.`sort_order` asc
Bindings |
|
Backtrace |
|
select `pb_genre_m`.* from `pb_genre_m` left join `pb_book_genre_t` as `bg` on `pb_genre_m`.`id` = `bg`.`genre_id` left join `pb_book_m` as `b` on `bg`.`book_id` = `b`.`id` where `b`.`asin` = '4086192225' and `pb_genre_m`.`del_flg` = 0 group by `id`
Bindings |
|
Backtrace |
|
select
pb_book_m.id,
asin,
title,
publish_date,
pb_book_m.del_flg,
( CASE WHEN isbn13 IS NOT null THEN isbn13 ELSE isbn10 END ) AS isbn,
( CASE WHEN adult_flg_org <> 0 THEN adult_flg_org ELSE adult_flg END ) AS adult,
(SELECT GROUP_CONCAT(g.name SEPARATOR ' / ') FROM pb_genre_m g LEFT JOIN pb_book_genre_t t ON g.id=t.genre_id WHERE t.book_id=pb_book_m.id) genre
, `bnp`.`sort_order` from `pb_book_m` inner join `pb_book_name_person_t` as `bnp` on `pb_book_m`.`id` = `bnp`.`book_id` and `bnp`.`del_flg` = 0 inner join `pb_name_person_m` as `np` on `bnp`.`name_person_id` = `np`.`id` and `np`.`del_flg` = 0 inner join `pb_person_name_t` as `pn` on `np`.`id` = `pn`.`name_person_id` and `pn`.`del_flg` = 0 where `pn`.`person_id` = 2229 and `asin` != '4086192225' and `binding` NOT LIKE 'Kindle版' and `pb_book_m`.`del_flg` = 0 order by `publish_date` desc limit 2
Bindings |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4420154578' limit 1
Bindings |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4088447778' limit 1
Bindings |
|
Backtrace |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4420154578' limit 1
Bindings |
|
Backtrace |
|
update `pb_book_m` set `pb_book_m`.`update_at` = '2024-12-13 04:26:12' where `id` = 1189531
Bindings |
|
Backtrace |
|
select * from `pb_book_genre_t` where `pb_book_genre_t`.`book_id` = 1189531
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1189531 and `genre_id` in (2278488051)
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1189531 and `genre_id` in (466280)
Bindings |
|
Backtrace |
|
select * from `pb_book_name_person_t` where `pb_book_name_person_t`.`book_id` = 1189531
Bindings |
|
Backtrace |
|
update `pb_book_name_person_t` set `sort_order` = 0, `del_flg` = 0 where `pb_book_name_person_t`.`book_id` = 1189531 and `name_person_id` in (2229)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `book_id`, `genre_id` from `pb_book_genre_t` where `book_id` not in (select `book_id` from `pb_book_genre_t` where `genre_id` in (467278, 492042, 12075891))) as bg where `bg`.`book_id` = 1189531 and `bg`.`genre_id` in (2278488051, 12075851)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `pb_book_genre_t` as `bg` left join `pb_genre_m` as `g` on `g`.`id` = `bg`.`genre_id` where `bg`.`book_id` = 1189531 and `g`.`del_flg` != 0
Bindings |
|
Backtrace |
|
select * from `pb_book_index_m` where `pb_book_index_m`.`book_id` = 1189531 and `pb_book_index_m`.`book_id` is not null limit 1
Bindings |
|
Backtrace |
|
update `pb_book_index_m` set `genre_del_flg` = 0, `comic_flg` = 1, `updated_at` = '2024-12-13 04:26:12' where `book_id` = 1189531
Bindings |
|
Backtrace |
|
Backtrace |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4088447778' limit 1
Bindings |
|
Backtrace |
|
update `pb_book_m` set `pb_book_m`.`update_at` = '2024-12-13 04:26:12' where `id` = 1188745
Bindings |
|
Backtrace |
|
select * from `pb_book_genre_t` where `pb_book_genre_t`.`book_id` = 1188745
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1188745 and `genre_id` in (2278488051)
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1188745 and `genre_id` in (466280)
Bindings |
|
Backtrace |
|
select * from `pb_book_name_person_t` where `pb_book_name_person_t`.`book_id` = 1188745
Bindings |
|
Backtrace |
|
update `pb_book_name_person_t` set `sort_order` = 0, `del_flg` = 0 where `pb_book_name_person_t`.`book_id` = 1188745 and `name_person_id` in (2229)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `book_id`, `genre_id` from `pb_book_genre_t` where `book_id` not in (select `book_id` from `pb_book_genre_t` where `genre_id` in (467278, 492042, 12075891))) as bg where `bg`.`book_id` = 1188745 and `bg`.`genre_id` in (2278488051, 12075851)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `pb_book_genre_t` as `bg` left join `pb_genre_m` as `g` on `g`.`id` = `bg`.`genre_id` where `bg`.`book_id` = 1188745 and `g`.`del_flg` != 0
Bindings |
|
Backtrace |
|
select * from `pb_book_index_m` where `pb_book_index_m`.`book_id` = 1188745 and `pb_book_index_m`.`book_id` is not null limit 1
Bindings |
|
Backtrace |
|
update `pb_book_index_m` set `genre_del_flg` = 0, `comic_flg` = 1, `updated_at` = '2024-12-13 04:26:12' where `book_id` = 1188745
Bindings |
|
Backtrace |
|
Backtrace |
|
select `id` from `pb_book_m` where `asin` in ('4420154578', '4088447778') and `pb_book_m`.`del_flg` = 0
Bindings |
|
Backtrace |
|
select `pn`.`person_id`, `np`.`name`, `np`.`name_kana`, `p`.`publish_flg` from `pb_book_name_person_t` left join `pb_book_index_m` as `bi` on `pb_book_name_person_t`.`book_id` = `bi`.`book_id` left join `pb_name_person_m` as `np` on `pb_book_name_person_t`.`name_person_id` = `np`.`id` left join `pb_person_name_t` as `pn` on `pb_book_name_person_t`.`name_person_id` = `pn`.`name_person_id` left join `pb_person_m` as `p` on `pn`.`person_id` = `p`.`id` where `bi`.`asin` = '4420154578' and `pb_book_name_person_t`.`del_flg` = 0 order by `pb_book_name_person_t`.`sort_order` asc
Bindings |
|
Backtrace |
|
select `pn`.`person_id`, `np`.`name`, `np`.`name_kana`, `p`.`publish_flg` from `pb_book_name_person_t` left join `pb_book_index_m` as `bi` on `pb_book_name_person_t`.`book_id` = `bi`.`book_id` left join `pb_name_person_m` as `np` on `pb_book_name_person_t`.`name_person_id` = `np`.`id` left join `pb_person_name_t` as `pn` on `pb_book_name_person_t`.`name_person_id` = `pn`.`name_person_id` left join `pb_person_m` as `p` on `pn`.`person_id` = `p`.`id` where `bi`.`asin` = '4088447778' and `pb_book_name_person_t`.`del_flg` = 0 order by `pb_book_name_person_t`.`sort_order` asc
Bindings |
|
Backtrace |
|
select * from `sessions` where `id` = 'YRtxeULQmhMFwVO5MKxV3XxjbqsxjUv7JobWABnw' limit 1
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:16 [▼ "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "accept-encoding" => array:1 [▶ 0 => "br,gzip" ] "via" => array:1 [▶ 0 => "1.1 6e0534026c8ccca1223c4e9932ce0e6e.cloudfront.net (CloudFront)" ] "cloudfront-forwarded-proto" => array:1 [▶ 0 => "https" ] "cloudfront-is-desktop-viewer" => array:1 [▶ 0 => "true" ] "cloudfront-is-smarttv-viewer" => array:1 [▶ 0 => "false" ] "cloudfront-is-tablet-viewer" => array:1 [▶ 0 => "false" ] "cloudfront-is-mobile-viewer" => array:1 [▶ 0 => "false" ] "x-amz-cf-id" => array:1 [▶ 0 => "h96NfZojbiM7irvMoc0nQ9FCx0ZFPVr2_gHvKsX8H2eqFU0OM3ST5Q==" ] "user-agent" => array:1 [▶ 0 => "Amazon CloudFront" ] "x-amzn-trace-id" => array:1 [▶ 0 => "Root=1-675b38d2-4115a55139db14662f69aa81" ] "host" => array:1 [▶ 0 => "d302np9o9me8i5.cloudfront.net" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-for" => array:1 [▶ 0 => "18.225.56.221, 64.252.66.3" ] ]
[]
0 of 0array:4 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "max-age=60, public" ] "date" => array:1 [▶ 0 => "Thu, 12 Dec 2024 19:26:12 GMT" ] "etag" => array:1 [▶ 0 => ""cfb89420d1650b3edf7b283f545e5488"" ] ]
0 of 0array:2 [▼ "_token" => "bPQ3mCeciMFpONJdm9hujqkzBksxHWCNttW2Gkgy" "PHPDEBUGBAR_STACK_DATA" => [] ]