入荷したはずの客注品がない! 約束の時間まであと5分、大量の箱から本を探そうとすると…/まちの本屋の御書山さん⑧
公開日:2024/1/20
公開日:2024/1/20
1 x Application (99.15%) | 1.86s |
1 x Booting (0.85%) | 15.92ms |
Backtrace |
|
select * from `cms_old_articles` where `cms_old_articles`.`id` = 1240594 and `cms_old_articles`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select `cms_nodes`.*, `cms_node_articles`.`old_article_id` as `pivot_old_article_id`, `cms_node_articles`.`node_id` as `pivot_node_id` from `cms_nodes` inner join `cms_node_articles` on `cms_nodes`.`id` = `cms_node_articles`.`node_id` where `cms_nodes`.`node_type_id` = 3 and `cms_node_articles`.`deleted_at` is null and `cms_node_articles`.`old_article_id` in (1240594) and `cms_nodes`.`deleted_at` is null order by `id` asc
Bindings |
|
Backtrace |
|
select * from `cms_node_articles` where `cms_node_articles`.`node_id` in (3565) and `cms_node_articles`.`deleted_at` is null
Backtrace |
|
select `cms_nodes`.*, `cms_node_articles`.`old_article_id` as `pivot_old_article_id`, `cms_node_articles`.`node_id` as `pivot_node_id` from `cms_nodes` inner join `cms_node_articles` on `cms_nodes`.`id` = `cms_node_articles`.`node_id` where `cms_nodes`.`node_type_id` = 4 and `cms_node_articles`.`deleted_at` is null and `cms_node_articles`.`old_article_id` in (1240594) and `cms_nodes`.`deleted_at` is null order by `id` asc
Bindings |
|
Backtrace |
|
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` inner join `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` = 1 and `cms_old_article_terms`.`deleted_at` is null and `cms_old_article_terms`.`old_article_id` in (1240594) and `cms_terms`.`deleted_at` is null order by `id` asc
Bindings |
|
Backtrace |
|
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` inner join `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` = 2 and `cms_old_article_terms`.`deleted_at` is null and `cms_old_article_terms`.`old_article_id` in (1240594) and `cms_terms`.`deleted_at` is null order by `id` asc
Bindings |
|
Backtrace |
|
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` inner join `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` = 3 and `cms_old_article_terms`.`deleted_at` is null and `cms_old_article_terms`.`old_article_id` in (1240594) and `cms_terms`.`deleted_at` is null order by `id` asc
Bindings |
|
Backtrace |
|
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` inner join `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` = 4 and `cms_old_article_terms`.`deleted_at` is null and `cms_old_article_terms`.`old_article_id` in (1240594) and `cms_terms`.`deleted_at` is null order by `id` asc
Bindings |
|
Backtrace |
|
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` inner join `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` = 5 and `cms_old_article_terms`.`deleted_at` is null and `cms_old_article_terms`.`old_article_id` in (1240594) and `cms_terms`.`deleted_at` is null order by `id` asc
Bindings |
|
Backtrace |
|
select `cms_medias`.*, `cms_old_article_medias`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_medias`.`media_id` as `pivot_media_id` from `cms_medias` inner join `cms_old_article_medias` on `cms_medias`.`id` = `cms_old_article_medias`.`media_id` where `cms_old_article_medias`.`old_article_id` in (1240594) and `cms_medias`.`deleted_at` is null
Backtrace |
|
select * from `cms_node_articles` where `cms_node_articles`.`old_article_id` = 1240594 and `cms_node_articles`.`old_article_id` is not null and `cms_node_articles`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `cms_old_article_links` where `cms_old_article_links`.`old_article_id` = 1240594 and `cms_old_article_links`.`old_article_id` is not null and exists (select * from `cms_old_articles` where `cms_old_article_links`.`old_article_id` = `cms_old_articles`.`id` and `deleted_at` is null and `cms_old_articles`.`deleted_at` is null) order by `sort_order` asc
Bindings |
|
Backtrace |
|
select * from `cms_old_article_medias` where `cms_old_article_medias`.`old_article_id` = 1240594 and `cms_old_article_medias`.`old_article_id` is not null and (exists (select * from `cms_medias` where `cms_old_article_medias`.`media_id` = `cms_medias`.`id` and `deleted_at` is null and `old_article_id` = 1240594 and `cms_medias`.`deleted_at` is null)) or (exists (select * from `cms_old_articles` where `cms_old_article_medias`.`old_media_id` = `cms_old_articles`.`id` and `deleted_at` is null and `old_article_id` = 1240594 and `cms_old_articles`.`deleted_at` is null)) order by `sort_order` asc
Bindings |
|
Backtrace |
|
select * from `cms_old_article_books` where `cms_old_article_books`.`old_article_id` = 1240594 and `cms_old_article_books`.`old_article_id` is not null order by `sort_order` asc
Bindings |
|
Backtrace |
|
select * from `pb_kobobooks` where `pb_kobobooks`.`kobo_id` = '4335190200310' and `pb_kobobooks`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 1 and `news_cms_id` = 77 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_serials` where `node_id` = 3565 and `cms_node_serials`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_nodes` where `cms_nodes`.`id` in (3565) and `cms_nodes`.`deleted_at` is null
Backtrace |
|
select count(*) as aggregate from `cms_node_articles` where `node_id` = 3565 and `status` = 'publish' and `published_at` <= (select `published_at` from `cms_node_articles` where `node_id` = 3565 and `old_article_id` = '1240594' and `deleted_at` is null) and `deleted_at` is null and `cms_node_articles`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 209 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 815 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_articles` where `node_id` = 3565 and `old_article_id` = '1240594' and `cms_node_articles`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_articles` where (`node_id` = 3565 and `status` = 'publish') and `cms_node_articles`.`deleted_at` is null order by `published_at` asc limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_articles` where (`node_id` = 3565 and `status` = 'publish') and `published_at` > '2024-01-20 15:00:16' and `cms_node_articles`.`deleted_at` is null order by `published_at` asc limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_articles` where (`node_id` = 3565 and `status` = 'publish') and `published_at` < '2024-01-20 15:00:16' and `cms_node_articles`.`deleted_at` is null order by `published_at` desc limit 1
Bindings |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = 'B0CLKZC3NS' limit 1
Bindings |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4046828781' limit 1
Bindings |
|
Backtrace |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = 'B0CLKZC3NS' limit 1
Bindings |
|
Backtrace |
|
update `pb_book_m` set `pb_book_m`.`update_at` = '2024-12-23 11:46:17' where `id` = 1242623
Bindings |
|
Backtrace |
|
select * from `pb_book_genre_t` where `pb_book_genre_t`.`book_id` = 1242623
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1242623 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` = 1242623
Bindings |
|
Backtrace |
|
update `pb_book_name_person_t` set `sort_order` = 0, `del_flg` = 0 where `pb_book_name_person_t`.`book_id` = 1242623 and `name_person_id` in (112823)
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` = 1242623 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` = 1242623 and `g`.`del_flg` != 0
Bindings |
|
Backtrace |
|
select * from `pb_book_index_m` where `pb_book_index_m`.`book_id` = 1242623 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-23 11:46:17' where `book_id` = 1242623
Bindings |
|
Backtrace |
|
Backtrace |
|
Backtrace |
|
select * from `pb_book_m` where `asin` = '4046828781' limit 1
Bindings |
|
Backtrace |
|
update `pb_book_m` set `pb_book_m`.`update_at` = '2024-12-23 11:46:17' where `id` = 1248207
Bindings |
|
Backtrace |
|
select * from `pb_book_genre_t` where `pb_book_genre_t`.`book_id` = 1248207
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1248207 and `genre_id` in (2278488051)
Bindings |
|
Backtrace |
|
update `pb_book_genre_t` set `del_flg` = 0 where `pb_book_genre_t`.`book_id` = 1248207 and `genre_id` in (466280)
Bindings |
|
Backtrace |
|
select * from `pb_book_name_person_t` where `pb_book_name_person_t`.`book_id` = 1248207
Bindings |
|
Backtrace |
|
update `pb_book_name_person_t` set `sort_order` = 0, `del_flg` = 0 where `pb_book_name_person_t`.`book_id` = 1248207 and `name_person_id` in (112823)
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` = 1248207 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` = 1248207 and `g`.`del_flg` != 0
Bindings |
|
Backtrace |
|
select * from `pb_book_index_m` where `pb_book_index_m`.`book_id` = 1248207 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-23 11:46:17' where `book_id` = 1248207
Bindings |
|
Backtrace |
|
Backtrace |
|
select `id` from `pb_book_m` where `asin` in ('B0CLKZC3NS', '4046828781') and `pb_book_m`.`del_flg` = 0
Bindings |
|
Backtrace |
|
select * from `cms_old_article_metas` where `cms_old_article_metas`.`old_article_id` = 1240594 and `cms_old_article_metas`.`old_article_id` is not null
Bindings |
|
Backtrace |
|
select * from `cms_node_serials` inner join `cms_nodes` on `cms_nodes`.`id` = `cms_node_serials`.`node_id` where `slug` = 'goshoyamasan' and `cms_node_serials`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_nodes` where `cms_nodes`.`id` in (3565) and `cms_nodes`.`deleted_at` is null
Backtrace |
|
select `cms_terms`.*, `cms_node_relation_terms`.`node_id` as `pivot_node_id`, `cms_node_relation_terms`.`term_id` as `pivot_term_id`, `cms_node_relation_terms`.`tab_name` as `pivot_tab_name`, `cms_node_relation_terms`.`tag_sort_order` as `pivot_tag_sort_order` from `cms_terms` inner join `cms_node_relation_terms` on `cms_terms`.`id` = `cms_node_relation_terms`.`term_id` where `cms_node_relation_terms`.`deleted_at` is null and `cms_terms`.`deleted_at` is null and `cms_node_relation_terms`.`node_id` in (3565) and `cms_terms`.`deleted_at` is null order by `tag_sort_order` asc
Backtrace |
|
select * from `cms_node_books` where `cms_node_books`.`node_id` in (3565) order by `sort_order` asc
Backtrace |
|
select * from `cms_medias` where `cms_medias`.`id` in (366853) and `cms_medias`.`deleted_at` is null
Backtrace |
|
select * from `cms_node_books` where `cms_node_books`.`node_id` = 3565 and `cms_node_books`.`node_id` is not null order by `sort_order` asc, `sort_order` asc
Bindings |
|
Backtrace |
|
select * from `pb_kobobooks` where `pb_kobobooks`.`kobo_id` in ('4046828781', '4335190200310', 'B0CLKZC3NS') and `pb_kobobooks`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `pb_book_m` where `pb_book_m`.`asin` in ('4046828781', '4335190200310', 'B0CLKZC3NS') and `pb_book_m`.`del_flg` = 0
Bindings |
|
Backtrace |
|
select * from `cms_node_articles` where `cms_node_articles`.`node_id` = 3565 and `cms_node_articles`.`node_id` is not null and `status` = 'publish' and (`article_id` <> '1240594' or `old_article_id` <> '1240594') and `cms_node_articles`.`deleted_at` is null order by `published_at` desc limit 4
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 1 and `news_cms_id` = 77 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 2 and `cms_terms`.`id` = 39 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 209 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 815 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_serials` where `status` = 'publish' and `node_id` = 3565 and `cms_node_serials`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_nodes` where `cms_nodes`.`id` in (3565) and `cms_nodes`.`deleted_at` is null
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 1 and `news_cms_id` = 77 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 2 and `cms_terms`.`id` = 39 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 209 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 815 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_serials` where `status` = 'publish' and `node_id` = 3565 and `cms_node_serials`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_nodes` where `cms_nodes`.`id` in (3565) and `cms_nodes`.`deleted_at` is null
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 1 and `news_cms_id` = 77 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 2 and `cms_terms`.`id` = 39 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 209 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 815 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_serials` where `status` = 'publish' and `node_id` = 3565 and `cms_node_serials`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_nodes` where `cms_nodes`.`id` in (3565) and `cms_nodes`.`deleted_at` is null
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 1 and `news_cms_id` = 77 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 2 and `cms_terms`.`id` = 39 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 209 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `taxonomy_id` = 3 and `cms_terms`.`id` = 815 and `cms_terms`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_node_serials` where `status` = 'publish' and `node_id` = 3565 and `cms_node_serials`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_nodes` where `cms_nodes`.`id` in (3565) and `cms_nodes`.`deleted_at` is null
Backtrace |
|
select * from `cms_nodes` where `node_type_id` = 2 and `slug` = 'issue_top_page' and exists (select * from `cms_node_versions` where `cms_nodes`.`id` = `cms_node_versions`.`node_id` and `published_at` < '2024-12-23 11:46:18') and `cms_nodes`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `cms_terms` where `slug` = 'mainichigahakken' and `cms_terms`.`deleted_at` is null
Bindings |
|
Backtrace |
|
select * from `sessions` where `id` = 'Ys2yxLxS8ARURlHn8rAFxrmUlCDDZTuw0qxDGdia' 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 a5d336173547b6dd7fc78ab1ca70f12a.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 => "HUmXl-IIxV1ySbwrXXaCoRPqhUF_KNUa5KjMWFtkhuk6Fh55Uq5wvQ==" ] "user-agent" => array:1 [▶ 0 => "Amazon CloudFront" ] "x-amzn-trace-id" => array:1 [▶ 0 => "Root=1-6768cef8-1940a51a5b4de91e05bc4cb7" ] "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.191.77.138, 64.252.74.70" ] ]
[]
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 => "Mon, 23 Dec 2024 02:46:17 GMT" ] "etag" => array:1 [▶ 0 => ""3cdd83abcdedbd930933da280c1569c3"" ] ]
0 of 0array:2 [▼ "_token" => "b98WVnVg9jHfmMCJ4JMyohTHyZo7t9QFASNBOKxK" "PHPDEBUGBAR_STACK_DATA" => [] ]