人気の本・小説ランキング
1 x Application (99.2%) | 2.05s |
1 x Booting (0.8%) | 16.44ms |
Backtrace |
|
select * from `pb_book_m` where `asin` = '4815626081' limit 1
Bindings |
|
Backtrace |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4815626081' limit 1
Bindings |
|
Backtrace |
|
update `pb_book_m` set `pb_book_m`.`update_at` = '2024-12-25 23:52:42' where `id` = 1215351
Bindings |
|
Backtrace |
|
select * from `pb_book_genre_t` where `pb_book_genre_t`.`book_id` = 1215351
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1215351 and `genre_id` in (554270)
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1215351 and `genre_id` in (492152)
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1215351 and `genre_id` in (492054)
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` = 1215351
Bindings |
|
Backtrace |
|
update `pb_book_name_person_t` set `sort_order` = 0, `del_flg` = 0 where `pb_book_name_person_t`.`book_id` = 1215351 and `name_person_id` in (4711)
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` = 1215351 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` = 1215351 and `g`.`del_flg` != 0
Bindings |
|
Backtrace |
|
select * from `pb_book_index_m` where `pb_book_index_m`.`book_id` = 1215351 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` = 0, `updated_at` = '2024-12-25 23:52:42' where `book_id` = 1215351
Bindings |
|
Backtrace |
|
Backtrace |
|
select `id` from `pb_book_m` where `asin` in ('4815626081') 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` = '4815626081' 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` = '4815626081' and `pb_genre_m`.`del_flg` = 0 group by `id`
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `slug` = 'review' and `taxonomy_id` = 1 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `pb_book_index_m` left join `pb_book_name_person_t` on `pb_book_index_m`.`book_id` = `pb_book_name_person_t`.`book_id` left join `pb_person_name_t` on `pb_book_name_person_t`.`name_person_id` = `pb_person_name_t`.`name_person_id` where `pb_person_name_t`.`person_id` = 4711 and `pb_book_index_m`.`genre_del_flg` != 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `pb_book_index_m` left join `pb_book_name_person_t` on `pb_book_index_m`.`book_id` = `pb_book_name_person_t`.`book_id` left join `pb_person_name_t` on `pb_book_name_person_t`.`name_person_id` = `pb_person_name_t`.`name_person_id` where `pb_person_name_t`.`person_id` = 4711 and `pb_book_index_m`.`genre_del_flg` != 1
Bindings |
|
Backtrace |
|
select `pb_book_index_m`.`book_id`, `pb_book_index_m`.`asin` from `pb_book_index_m` left join `pb_book_name_person_t` on `pb_book_index_m`.`book_id` = `pb_book_name_person_t`.`book_id` left join `pb_person_name_t` on `pb_book_name_person_t`.`name_person_id` = `pb_person_name_t`.`name_person_id` where `pb_person_name_t`.`person_id` = 4711 and `pb_book_index_m`.`genre_del_flg` != 1 order by `publish_date` desc limit 2 offset 0
Bindings |
|
Backtrace |
|
select
id, asin, title, image, link, publisher, publish_date, summary, summary_org,
(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,
update_at, del_flg
from `pb_book_m` where `del_flg` != 1 and `pb_book_m`.`id` = 1215351 limit 1
Bindings |
|
Backtrace |
|
select `pb_name_person_m`.*, `pb_book_name_person_t`.`book_id` as `pivot_book_id`, `pb_book_name_person_t`.`name_person_id` as `pivot_name_person_id` from `pb_name_person_m` inner join `pb_book_name_person_t` on `pb_name_person_m`.`id` = `pb_book_name_person_t`.`name_person_id` where `pb_book_name_person_t`.`del_flg` = 0 and `pb_book_name_person_t`.`book_id` in (1215351) and `pb_name_person_m`.`del_flg` = 0 order by `pb_book_name_person_t`.`sort_order` asc
Bindings |
|
Backtrace |
|
select `pb_person_m`.*, `pb_person_name_t`.`name_person_id` as `pivot_name_person_id`, `pb_person_name_t`.`person_id` as `pivot_person_id` from `pb_person_m` inner join `pb_person_name_t` on `pb_person_m`.`id` = `pb_person_name_t`.`person_id` where `pb_person_name_t`.`del_flg` = 0 and `pb_person_name_t`.`name_person_id` in (4711) and `pb_person_m`.`del_flg` = 0
Bindings |
|
Backtrace |
|
select
id, asin, title, image, link, publisher, publish_date, summary, summary_org,
(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,
update_at, del_flg
from `pb_book_m` where `del_flg` != 1 and `pb_book_m`.`id` = 16053 limit 1
Bindings |
|
Backtrace |
|
select `pb_name_person_m`.*, `pb_book_name_person_t`.`book_id` as `pivot_book_id`, `pb_book_name_person_t`.`name_person_id` as `pivot_name_person_id` from `pb_name_person_m` inner join `pb_book_name_person_t` on `pb_name_person_m`.`id` = `pb_book_name_person_t`.`name_person_id` where `pb_book_name_person_t`.`del_flg` = 0 and `pb_book_name_person_t`.`book_id` in (16053) and `pb_name_person_m`.`del_flg` = 0 order by `pb_book_name_person_t`.`sort_order` asc
Bindings |
|
Backtrace |
|
select `pb_person_m`.*, `pb_person_name_t`.`name_person_id` as `pivot_name_person_id`, `pb_person_name_t`.`person_id` as `pivot_person_id` from `pb_person_m` inner join `pb_person_name_t` on `pb_person_m`.`id` = `pb_person_name_t`.`person_id` where `pb_person_name_t`.`del_flg` = 0 and `pb_person_name_t`.`name_person_id` in (4711) and `pb_person_m`.`del_flg` = 0
Bindings |
|
Backtrace |
|
insert into `jobs` (`queue`, `attempts`, `reserved_at`, `available_at`, `created_at`, `payload`) values ('default', 0, '', 1735138363, 1735138363, '{\"uuid\":\"577f20ad-3285-4ba5-afeb-5627e66b1137\",\"displayName\":\"App\\Jobs\\UpdateBookJob\",\"job\":\"Illuminate\\Queue\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\Jobs\\UpdateBookJob\",\"command\":\"O:22:\\"App\\Jobs\\UpdateBookJob\\":2:{s:14:\\"\u0000*\u0000updateBooks\\";a:1:{i:4047316571;a:2:{s:4:\\"book\\";a:15:{s:4:\\"asin\\";s:10:\\"4047316571\\";s:4:\\"link\\";s:77:\\"https:\/\/www.amazon.co.jp\/dp\/4047316571?tag=dddev02-22&linkCode=ogi&th=1&psc=1\\";s:5:\\"title\\";s:43:\\"老い駆けろ!人生 (角川新書 K- 27)\\";s:7:\\"binding\\";s:6:\\"新書\\";s:6:\\"isbn13\\";s:13:\\"9784047316577\\";s:6:\\"isbn10\\";N;s:12:\\"publish_date\\";s:10:\\"2015-05-12\\";s:9:\\"adult_flg\\";i:0;s:8:\\"genre_id\\";a:7:{i:0;s:6:\\"466284\\";i:1;s:6:\\"500074\\";i:2;s:6:\\"492116\\";i:3;s:6:\\"571582\\";i:4;s:6:\\"554164\\";i:5;s:6:\\"554120\\";i:6;s:6:\\"492152\\";}s:9:\\"publisher\\";s:30:\\"KADOKAWA\/角川マガジンズ\\";s:5:\\"price\\";d:858;s:5:\\"image\\";s:59:\\"https:\/\/m.media-amazon.com\/images\/I\/31jIkBzOJDL._SL500_.jpg\\";s:7:\\"summary\\";N;s:13:\\"adult_flg_org\\";i:0;s:7:\\"del_flg\\";i:0;}s:7:\\"authors\\";a:1:{i:0;a:2:{s:4:\\"name\\";s:10:\\"草野 仁\\";s:4:\\"role\\";s:3:\\"著\\";}}}}s:11:\\"\u0000*\u0000cacheKey\\";s:46:\\"UpdateBookJob_d751713988987e9331980363e24189ce\\";}\"}}')
Bindings |
|
Backtrace |
|
select * from `sessions` where `id` = 'xc71LoUWqtCnT6awS9Iza2P35So75Px97e0sS0HW' 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 ff5c2826d5a2f8583802a5c36e2a8060.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 => "p2mGmdK0EXq8C7eE9BQZdT926tB3wh_1W2aC8qZRXSsFS1FJKUr57g==" ] "user-agent" => array:1 [▶ 0 => "Amazon CloudFront" ] "x-amzn-trace-id" => array:1 [▶ 0 => "Root=1-676c1c39-34170ef855d90b122a883cc2" ] "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.117.102.186, 64.252.74.111" ] ]
[]
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 => "Wed, 25 Dec 2024 14:52:43 GMT" ] "etag" => array:1 [▶ 0 => ""832ed2380d61a0cf06838d70539603a2"" ] ]
0 of 0array:2 [▼ "_token" => "a7q5NVMWspDIUx3Gk8j77ESc8DQ4WYIOa7fFIIlW" "PHPDEBUGBAR_STACK_DATA" => [] ]