「北原里英」の本・小説【新作・新刊順】
-
ランキング
-
新作・新刊順
人気の本・小説ランキング
1 x Application (98.97%) | 1.09s |
1 x Booting (1.02%) | 11.33ms |
Backtrace |
|
select
pb_person_m.id,
np.name AS name,
np.name_kana AS name_kana,
(
SELECT occupation_id
FROM pb_person_occupation_t
WHERE person_id = pb_person_m.id
AND del_flg = 0
ORDER BY sort_order
LIMIT 1
) AS occupation_id,
GROUP_CONCAT(oc.name SEPARATOR "、") AS occupation_name,
me.path AS path,
pb_person_m.publish_flg,
pb_person_m.adult_flg
from `pb_person_m` left join `pb_person_name_t` as `pn` on `pb_person_m`.`id` = `pn`.`person_id` and `main_flg` = 1 left join `pb_name_person_m` as `np` on `name_person_id` = `np`.`id` left join `pb_person_occupation_t` as `po` on `pb_person_m`.`id` = `po`.`person_id` left join `pb_occupation_m` as `oc` on `po`.`occupation_id` = `oc`.`id` left join `cms_medias` as `me` on `pb_person_m`.`media_id` = `me`.`id` where `pb_person_m`.`id` = 9892 and `pb_person_m`.`del_flg` = 0 order by `po`.`sort_order` asc 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` = 9892 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` = 9892 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` = 9892 and `pb_book_index_m`.`genre_del_flg` != 1 order by `publish_date` desc limit 10 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` = 1194487 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 (1194487) 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 (7575) 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` = 1240991 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 (1240991) 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 (7575) and `pb_person_m`.`del_flg` = 0
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 (1240991) 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 (7575) 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` = 1194488 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 (1194488) 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 (7575) 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` = 161711 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 (161711) 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 (152, 1129, 2133, 2419, 4240, 5551, 6840, 7562, 7567, 7568, 7572, 7573, 7574, 7575, 76589) and `pb_person_m`.`del_flg` = 0
Bindings |
|
Backtrace |
|
insert into `jobs` (`queue`, `attempts`, `reserved_at`, `available_at`, `created_at`, `payload`) values ('default', 0, '', 1735113148, 1735113148, '{\"uuid\":\"b8f19575-181d-44c1-b6c8-5143c7d4aa30\",\"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:3:{i:4041123585;a:2:{s:4:\\"book\\";a:15:{s:4:\\"asin\\";s:10:\\"4041123585\\";s:4:\\"link\\";s:77:\\"https:\/\/www.amazon.co.jp\/dp\/4041123585?tag=dddev02-22&linkCode=ogi&th=1&psc=1\\";s:5:\\"title\\";s:27:\\"おかえり、めだか荘\\";s:7:\\"binding\\";s:33:\\"単行本(ソフトカバー)\\";s:6:\\"isbn13\\";s:13:\\"9784041123584\\";s:6:\\"isbn10\\";N;s:12:\\"publish_date\\";s:10:\\"2023-08-30\\";s:9:\\"adult_flg\\";i:0;s:8:\\"genre_id\\";a:3:{i:0;s:6:\\"467250\\";i:1;s:6:\\"548206\\";i:2;s:6:\\"466284\\";}s:9:\\"publisher\\";s:8:\\"KADOKAWA\\";s:5:\\"price\\";d:1549;s:5:\\"image\\";s:59:\\"https:\/\/m.media-amazon.com\/images\/I\/41S0a6GWL6L._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:12:\\"北原里英\\";s:4:\\"role\\";s:3:\\"著\\";}}}s:10:\\"B0CF9KMX8H\\";a:2:{s:4:\\"book\\";a:13:{s:4:\\"asin\\";s:10:\\"B0CF9KMX8H\\";s:4:\\"link\\";s:77:\\"https:\/\/www.amazon.co.jp\/dp\/B0CF9KMX8H?tag=dddev02-22&linkCode=ogi&th=1&psc=1\\";s:5:\\"title\\";s:75:\\"おかえり、めだか荘【電子特典付き】 (角川書店単行本)\\";s:7:\\"binding\\";s:9:\\"Kindle版\\";s:12:\\"publish_date\\";s:10:\\"2023-08-30\\";s:9:\\"adult_flg\\";i:0;s:8:\\"genre_id\\";a:0:{}s:9:\\"publisher\\";s:8:\\"KADOKAWA\\";s:5:\\"price\\";d:1725;s:5:\\"image\\";s:59:\\"https:\/\/m.media-amazon.com\/images\/I\/41SaJgP2R2L._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:13:\\"北原 里英\\";s:4:\\"role\\";s:3:\\"著\\";}}}s:10:\\"477831185X\\";a:2:{s:4:\\"book\\";a:15:{s:4:\\"asin\\";s:10:\\"477831185X\\";s:4:\\"link\\";s:77:\\"https:\/\/www.amazon.co.jp\/dp\/477831185X?tag=dddev02-22&linkCode=ogi&th=1&psc=1\\";s:5:\\"title\\";s:27:\\"コンティニューvol.46\\";s:7:\\"binding\\";s:9:\\"単行本\\";s:6:\\"isbn13\\";s:13:\\"9784778311858\\";s:6:\\"isbn10\\";N;s:12:\\"publish_date\\";s:10:\\"2009-06-16\\";s:9:\\"adult_flg\\";i:0;s:8:\\"genre_id\\";a:3:{i:0;s:6:\\"466284\\";i:1;s:6:\\"492264\\";i:2;s:6:\\"466296\\";}s:9:\\"publisher\\";s:12:\\"太田出版\\";s:5:\\"price\\";d:324;s:5:\\"image\\";s:59:\\"https:\/\/m.media-amazon.com\/images\/I\/516NtHZlfBL._SL500_.jpg\\";s:7:\\"summary\\";N;s:13:\\"adult_flg_org\\";i:0;s:7:\\"del_flg\\";i:0;}s:7:\\"authors\\";a:15:{i:0;a:2:{s:4:\\"name\\";s:40:\\"ヱヴァンゲリヲン新劇場版:破\\";s:4:\\"role\\";s:3:\\"著\\";}i:1;a:2:{s:4:\\"name\\";s:16:\\"菅野 よう子\\";s:4:\\"role\\";s:3:\\"著\\";}i:2;a:2:{s:4:\\"name\\";s:13:\\"京田 知己\\";s:4:\\"role\\";s:3:\\"著\\";}i:3;a:2:{s:4:\\"name\\";s:7:\\"Perfume\\";s:4:\\"role\\";s:3:\\"著\\";}i:4;a:2:{s:4:\\"name\\";s:13:\\"仲村 みう\\";s:4:\\"role\\";s:3:\\"著\\";}i:5;a:2:{s:4:\\"name\\";s:25:\\"白井 ヴィンセント\\";s:4:\\"role\\";s:3:\\"著\\";}i:6;a:2:{s:4:\\"name\\";s:19:\\"みうら じゅん\\";s:4:\\"role\\";s:3:\\"著\\";}i:7;a:2:{s:4:\\"name\\";s:10:\\"吉田 豪\\";s:4:\\"role\\";s:3:\\"著\\";}i:8;a:2:{s:4:\\"name\\";s:16:\\"掟 ポルシェ\\";s:4:\\"role\\";s:3:\\"著\\";}i:9;a:2:{s:4:\\"name\\";s:10:\\"川島 明\\";s:4:\\"role\\";s:3:\\"著\\";}i:10;a:2:{s:4:\\"name\\";s:13:\\"栗山 千明\\";s:4:\\"role\\";s:3:\\"著\\";}i:11;a:2:{s:4:\\"name\\";s:16:\\"小野 恵令奈\\";s:4:\\"role\\";s:3:\\"著\\";}i:12;a:2:{s:4:\\"name\\";s:13:\\"渡辺 麻友\\";s:4:\\"role\\";s:3:\\"著\\";}i:13;a:2:{s:4:\\"name\\";s:13:\\"北原 里英\\";s:4:\\"role\\";s:3:\\"著\\";}i:14;a:2:{s:4:\\"name\\";s:9:\\"マリエ\\";s:4:\\"role\\";s:3:\\"著\\";}}}}s:11:\\"\u0000*\u0000cacheKey\\";s:46:\\"UpdateBookJob_d751713988987e9331980363e24189ce\\";}\"}}')
Bindings |
|
Backtrace |
|
select * from `sessions` where `id` = 'AszGYTKS0Qob2OG9cYRZ6bWTyIJWoIHCpWfUwQgh' 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 54268fe6e541dab14321b978d08b8fc4.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 => "iGziD_wyH9-7xGHT8ypJfDaXXv_O73PafcRouo5Pr-drJxB9f__cSw==" ] "user-agent" => array:1 [▶ 0 => "Amazon CloudFront" ] "x-amzn-trace-id" => array:1 [▶ 0 => "Root=1-676bb9bb-1e0aa7466e36a0bd20d0c54b" ] "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 => "3.146.35.50, 64.252.75.120" ] ]
[]
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 07:52:28 GMT" ] "etag" => array:1 [▶ 0 => ""47f134baee20ec6501d5a98e40034383"" ] ]
0 of 0array:2 [▼ "_token" => "7pBiqJWLnrPHMBwy3EynCY88Kjy6E3IKWUhTm8ld" "PHPDEBUGBAR_STACK_DATA" => [] ]