| 11:15:28.093 | info | http.request | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "bj"
},
"clientAddress": "216.73.216.18",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "jE6x3mBXvtI_NSOVTKAG",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "GOAFRICA_NEXT_SESSION_ID=OckeJVerEt2WWdD9I0U1Ic3Qb6GcFoLTvTYcqhIf; PHPSESSID=feb2b8145d0c2dce3e0e4e7b21798c30; goafrica-ad-id=68907a214cbb29.68244812",
"host": "www.goa.goafrica.syazen.cloud",
"user-agent": "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)",
"x-forwarded-for": "216.73.216.18",
"x-real-ip": "216.73.216.18",
"x-scheme": "https"
}
}
},
"user_agent": {
"original": "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
},
"url": {
"full": "https://www.goa.goafrica.syazen.cloud/bj",
"original": "https://www.goa.goafrica.syazen.cloud/bj",
"path": "/bj",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 235548672,
"memoryUsageHuman": "224.6 MiB"
}
}
|
|---|
| 11:15:28.100 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"BJ",
true
],
"durationInMs": 0.28823299997020513
}
}
|
|---|
| 11:15:28.103 | debug | kysely.query | {
"kysely": {
"sql": "select `id` from `cms_post` where `cms_post`.`slug` = ? limit ?",
"parameters": [
"questions-go-africa",
1
],
"durationInMs": 3.561676000012085
}
}
|
|---|
| 11:15:28.104 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?)",
"parameters": [
36
],
"durationInMs": 0.3310320000164211
}
}
|
|---|
| 11:15:28.109 | debug | kysely.query | {
"kysely": {
"sql": "select `o`.`id` from `cms_post` as `o` where `o`.`online` = ? and `on_africa` = ? order by `o`.`updated_at` desc limit ?",
"parameters": [
1,
1,
4
],
"durationInMs": 0.5402790000080131
}
}
|
|---|
| 11:15:28.109 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `user` where `enabled` = ?",
"parameters": [
1
],
"durationInMs": 0.7773070000112057
}
}
|
|---|
| 11:15:28.110 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `company` where `valid` = ? and `online` = ?",
"parameters": [
1,
1
],
"durationInMs": 0.9040019999956712
}
}
|
|---|
| 11:15:28.110 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ? order by `weight` desc limit ?",
"parameters": [
0,
"bj",
1,
13
],
"durationInMs": 1.0756300000357442
}
}
|
|---|
| 11:15:28.114 | debug | kysely.query | {
"kysely": {
"sql": "select `feed_post`.`id` from `feed_post` left join `user` as `user_author` on `user_author`.`id` = `feed_post`.`user_author_id` left join `company` as `company_author` on `company_author`.`id` = `feed_post`.`company_author_id` where (`company_author`.`country` != ? or `company_author`.`country` is null or `user_author`.`country` != ? or `user_author`.`country` is null) order by `feed_post`.`id` desc limit ?",
"parameters": [
"bj",
"bj",
3
],
"durationInMs": 4.264997000049334
}
}
|
|---|
| 11:15:28.114 | debug | kysely.query | {
"kysely": {
"sql": "select `feed_post`.`id` from `feed_post` left join `user` as `user_author` on `user_author`.`id` = `feed_post`.`user_author_id` left join `company` as `company_author` on `company_author`.`id` = `feed_post`.`company_author_id` where (`company_author`.`country` = ? or `user_author`.`country` = ?) order by `feed_post`.`id` desc limit ?",
"parameters": [
"bj",
"bj",
3
],
"durationInMs": 4.825172000040766
}
}
|
|---|
| 11:15:28.115 | debug | kysely.query | {
"kysely": {
"sql": "select `ad`.`id` from `company_static_ad` as `ad` inner join `company` on `company`.`id` = `ad`.`company_id` where `company`.`country` = ? and `ad`.`enabled` = ? and `ad`.`slot` = ? and `ad`.`start_date` >= ? and `ad`.`end_date` <= ? limit ?",
"parameters": [
"bj",
1,
"background",
"2025-08-04T09:15:28.108Z",
"2025-08-04T09:15:28.108Z",
1
],
"durationInMs": 5.343491000006907
}
}
|
|---|
| 11:15:28.121 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"BJ",
true
],
"durationInMs": 11.00516100000823
}
}
|
|---|
| 11:15:28.121 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ?",
"parameters": [
0,
"bj",
0
],
"durationInMs": 7.505139000015333
}
}
|
|---|
| 11:15:28.121 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
996
],
"durationInMs": 6.809010999975726
}
}
|
|---|
| 11:15:28.122 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
996
],
"durationInMs": 1.1267030000453815
}
}
|
|---|
| 11:15:28.122 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ? and `c`.`parent_id` is null",
"parameters": [
996
],
"durationInMs": 1.0622549999970943
}
}
|
|---|
| 11:15:28.122 | debug | kysely.query | {
"kysely": {
"sql": "select `o`.`id` from `cms_post` as `o` where `o`.`online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ? and `id` not in (?, ?, ?, ?) order by `o`.`updated_at` desc limit ?",
"parameters": [
1,
"BJ",
true,
588,
592,
594,
595,
4
],
"durationInMs": 12.020447999995667
}
}
|
|---|
| 11:15:28.122 | debug | kysely.query | {
"kysely": {
"sql": "with `nb_following`(`user_id`, `nb_following`) as (select `target_user_id` as `user_id`, count(*) as `nb_following` from `following` group by `target_user_id`) select `user`.`id`, `nb_following`.`nb_following` from `user` inner join `nb_following` on `nb_following`.`user_id` = `user`.`id` where `enabled` = ? and `profile_photo_status` = ? and `user`.`country` != ? order by `nb_following` desc limit ?",
"parameters": [
1,
"valid",
"bj",
30
],
"durationInMs": 13.661733000015374
}
}
|
|---|
| 11:15:28.126 | debug | kysely.query | {
"kysely": {
"sql": "select `r`.`type`, count(`r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ? group by `r`.`type`",
"parameters": [
996
],
"durationInMs": 4.953610000025947
}
}
|
|---|
| 11:15:28.127 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
994
],
"durationInMs": 5.117062999983318
}
}
|
|---|
| 11:15:28.127 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
994
],
"durationInMs": 5.17850699997507
}
}
|
|---|
| 11:15:28.127 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ? and `c`.`parent_id` is null",
"parameters": [
994
],
"durationInMs": 5.216346000030171
}
}
|
|---|
| 11:15:28.127 | debug | kysely.query | {
"kysely": {
"sql": "select `r`.`type`, count(`r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ? group by `r`.`type`",
"parameters": [
994
],
"durationInMs": 5.045619999989867
}
}
|
|---|
| 11:15:28.127 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
992
],
"durationInMs": 4.9022149999509566
}
}
|
|---|
| 11:15:28.128 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
992
],
"durationInMs": 1.1185580000164919
}
}
|
|---|
| 11:15:28.128 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ? and `c`.`parent_id` is null",
"parameters": [
992
],
"durationInMs": 1.0647989999852143
}
}
|
|---|
| 11:15:28.128 | debug | kysely.query | {
"kysely": {
"sql": "select `r`.`type`, count(`r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ? group by `r`.`type`",
"parameters": [
992
],
"durationInMs": 1.0729550000396557
}
}
|
|---|
| 11:15:28.128 | debug | kysely.query | {
"kysely": {
"sql": "select * from `feed_post` where `id` in (?, ?, ?)",
"parameters": [
996,
994,
992
],
"durationInMs": 1.1719270000467077
}
}
|
|---|
| 11:15:28.131 | debug | kysely.query | {
"kysely": {
"sql": "select `feed_media`.`media_id`, `feed_media`.`feed_post_id` from `feed_media` where `feed_media`.`feed_post_id` in (?, ?, ?)",
"parameters": [
996,
994,
992
],
"durationInMs": 4.011368000006769
}
}
|
|---|
| 11:15:28.135 | debug | kysely.query | {
"kysely": {
"sql": "select `pl`.`feed_post_id`, `l`.`related_feed_post_id` from `feed_post_link_meta_data` as `pl` inner join `link_meta_data` as `l` on `l`.`id` = `pl`.`link_meta_data_id` where `pl`.`feed_post_id` in (?, ?, ?) and `l`.`related_feed_post_id` is not null group by `pl`.`feed_post_id`",
"parameters": [
996,
994,
992
],
"durationInMs": 7.639006999961566
}
}
|
|---|
| 11:15:28.136 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `all_countries` = ? and `visible_force` = ? order by `weight` desc limit ?",
"parameters": [
0,
1,
1,
3
],
"durationInMs": 7.678338999976404
}
}
|
|---|
| 11:15:28.136 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?, ?, ?, ?)",
"parameters": [
590,
569,
572,
578
],
"durationInMs": 8.152395000040997
}
}
|
|---|
| 11:15:28.137 | debug | kysely.query | {
"kysely": {
"sql": "select `bi`.`target_feed_post_id`, `bi`.`id` from `bookmark_item` as `bi` inner join `bookmark` as `b` on `b`.`id` = `bi`.`bookmark_id` where `bi`.`target_feed_post_id` in (?, ?, ?) and (? is not null and `b`.`user_id` = ?) group by `bi`.`target_feed_post_id`",
"parameters": [
996,
994,
992,
null,
null
],
"durationInMs": 7.018778999976348
}
}
|
|---|
| 11:15:28.138 | debug | kysely.query | {
"kysely": {
"sql": "select `r`.`target_feed_post_id`, `r`.`id` from `reaction` as `r` where `r`.`target_feed_post_id` in (?, ?, ?) and (? is not null and `r`.`user_author_id` = ?) group by `r`.`target_feed_post_id`",
"parameters": [
996,
994,
992,
null,
null
],
"durationInMs": 5.952608000021428
}
}
|
|---|
| 11:15:28.138 | debug | kysely.query | {
"kysely": {
"sql": "select `pl`.`feed_post_id`, `pl`.`link_meta_data_id` from `feed_post_link_meta_data` as `pl` where `pl`.`feed_post_id` in (?, ?, ?)",
"parameters": [
996,
994,
992
],
"durationInMs": 10.286702999961562
}
}
|
|---|
| 11:15:28.143 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?)",
"parameters": [
416160,
261518
],
"durationInMs": 7.666466999973636
}
}
|
|---|
| 11:15:28.144 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?) group by `author_id`",
"parameters": [
416160,
261518
],
"durationInMs": 7.974907000025269
}
}
|
|---|
| 11:15:28.144 | debug | kysely.query | {
"kysely": {
"sql": "select `target_user_id`, count(`id`) as `count` from `following` where (`target_company_id` is null and `target_user_id` in (?, ?)) group by `target_user_id`",
"parameters": [
416160,
261518
],
"durationInMs": 7.073661000002176
}
}
|
|---|
| 11:15:28.144 | debug | kysely.query | {
"kysely": {
"sql": "select `user_author_id`, count(`id`) as `count` from `feed_post` where (`company_author_id` is null and `user_author_id` in (?, ?)) group by `user_author_id`",
"parameters": [
416160,
261518
],
"durationInMs": 6.94894099998055
}
}
|
|---|
| 11:15:28.146 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?)",
"parameters": [
837442
],
"durationInMs": 7.881764999998268
}
}
|
|---|
| 11:15:28.146 | debug | kysely.query | {
"kysely": {
"sql": "select `target_company_id`, count(`id`) as `count` from `following` where (`target_company_id` in (?) and `target_user_id` is null) group by `target_company_id`",
"parameters": [
837442
],
"durationInMs": 8.243374000012409
}
}
|
|---|
| 11:15:28.147 | debug | kysely.query | {
"kysely": {
"sql": "select `company_author_id`, count(`id`) as `count` from `feed_post` where (`company_author_id` in (?) and `user_author_id` is null) group by `company_author_id`",
"parameters": [
837442
],
"durationInMs": 2.676610000024084
}
}
|
|---|
| 11:15:28.147 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
287782,
287783,
287784,
287785,
287424
],
"durationInMs": 2.7781980000436306
}
}
|
|---|
| 11:15:28.147 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `reference`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
"parameters": [
36,
59,
58,
40,
38,
39,
60,
41,
42,
56,
29,
10,
16
],
"durationInMs": 3.2098149999510497
}
}
|
|---|
| 11:15:28.148 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?)",
"parameters": [
284150,
276720,
278113,
278487
],
"durationInMs": 3.84893799998099
}
}
|
|---|
| 11:15:28.150 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
389,
"fr",
273,
"fr"
],
"durationInMs": 4.236134000006132
}
}
|
|---|
| 11:15:28.154 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?)",
"parameters": [
163418
],
"durationInMs": 7.416173999954481
}
}
|
|---|
| 11:15:28.154 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?)",
"parameters": [
190,
"fr"
],
"durationInMs": 7.218078000005335
}
}
|
|---|
| 11:15:28.155 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?)",
"parameters": [
190
],
"durationInMs": 6.516319999995176
}
}
|
|---|
| 11:15:28.155 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
"parameters": [
174999,
235022,
235018,
90390,
90387,
90388,
235024,
76298,
90395,
136562,
90397,
90399,
90286
],
"durationInMs": 4.975090000021737
}
}
|
|---|
| 11:15:28.159 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?)",
"parameters": [
389,
273
],
"durationInMs": 12.694784999999683
}
}
|
|---|
| 11:15:28.159 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
"parameters": [
334,
238
],
"durationInMs": 5.279893999977503
}
}
|
|---|
| 11:15:28.160 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?)",
"parameters": [
170
],
"durationInMs": 5.144642999977805
}
}
|
|---|
| 11:15:28.160 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?)",
"parameters": [
183,
"fr"
],
"durationInMs": 5.050508999964222
}
}
|
|---|
| 11:15:28.160 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
"parameters": [
558963,
597362,
13500,
391521,
13536,
11602,
392868,
13554,
390578,
12463,
41,
2231,
62079
],
"durationInMs": 10.069281000003684
}
}
|
|---|
| 11:15:28.162 | debug | kysely.query | {
"kysely": {
"sql": "select `user`.`id` from `user` where `enabled` = ? and `sex` = ? and `profile_photo_status` = ? and `user`.`country` = ? order by `id` desc limit ?",
"parameters": [
1,
"H",
"valid",
"bj",
2
],
"durationInMs": 52.88438599999063
}
}
|
|---|
| 11:15:28.162 | debug | kysely.query | {
"kysely": {
"sql": "select `user`.`id` from `user` where `enabled` = ? and `sex` = ? and `profile_photo_status` = ? and `user`.`country` = ? order by `id` desc limit ?",
"parameters": [
1,
"F",
"valid",
"bj",
3
],
"durationInMs": 53.096567999979015
}
}
|
|---|
| 11:15:28.163 | debug | kysely.query | {
"kysely": {
"sql": "with `nb_following`(`user_id`, `nb_following`) as (select `target_user_id` as `user_id`, count(*) as `nb_following` from `following` group by `target_user_id`) select `user`.`id`, `nb_following`.`nb_following` from `user` inner join `nb_following` on `nb_following`.`user_id` = `user`.`id` where `enabled` = ? and `profile_photo_status` = ? and `user`.`country` = ? order by `nb_following` desc limit ?",
"parameters": [
1,
"valid",
"bj",
30
],
"durationInMs": 54.047896999982186
}
}
|
|---|
| 11:15:28.164 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
281529,
172942,
367838,
189859,
372347
],
"durationInMs": 0.22859299997799098
}
}
|
|---|
| 11:15:28.164 | debug | kysely.query | {
"kysely": {
"sql": "select `user_author_id`, count(`id`) as `count` from `feed_post` where (`company_author_id` is null and `user_author_id` in (?, ?, ?, ?, ?)) group by `user_author_id`",
"parameters": [
415443,
415440,
415198,
414310,
414290
],
"durationInMs": 1.5968729999731295
}
}
|
|---|
| 11:15:28.164 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?)",
"parameters": [
165
],
"durationInMs": 4.458473999984562
}
}
|
|---|
| 11:15:28.165 | debug | kysely.query | {
"kysely": {
"sql": "select `target_user_id`, count(`id`) as `count` from `following` where (`target_company_id` is null and `target_user_id` in (?, ?, ?, ?, ?)) group by `target_user_id`",
"parameters": [
415443,
415440,
415198,
414310,
414290
],
"durationInMs": 2.038699999975506
}
}
|
|---|
| 11:15:28.165 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
415443,
415440,
415198,
414310,
414290
],
"durationInMs": 2.267242999980226
}
}
|
|---|
| 11:15:28.165 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
415443,
415440,
415198,
414310,
414290
],
"durationInMs": 2.773397999990266
}
}
|
|---|
| 11:15:28.168 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
281529,
172942,
367838,
189859,
372347
],
"durationInMs": 3.8901740000001155
}
}
|
|---|
| 11:15:28.174 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
18,
"fr",
265,
"fr"
],
"durationInMs": 14.29639800003497
}
}
|
|---|
| 11:15:28.175 | debug | kysely.query | {
"kysely": {
"sql": "select `user_author_id`, count(`id`) as `count` from `feed_post` where (`company_author_id` is null and `user_author_id` in (?, ?, ?, ?, ?)) group by `user_author_id`",
"parameters": [
281529,
172942,
367838,
189859,
372347
],
"durationInMs": 10.789642999996431
}
}
|
|---|
| 11:15:28.175 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
284,
140,
597,
483,
369
],
"durationInMs": 6.8885279999813065
}
}
|
|---|
| 11:15:28.176 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
284,
"fr",
140,
"fr",
597,
"fr",
483,
"fr",
369,
"fr"
],
"durationInMs": 7.551083999976981
}
}
|
|---|
| 11:15:28.176 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
485,
37,
687,
101,
360
],
"durationInMs": 8.973815000033937
}
}
|
|---|
| 11:15:28.177 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
485,
"fr",
37,
"fr",
687,
"fr",
101,
"fr",
360,
"fr"
],
"durationInMs": 9.525054000027012
}
}
|
|---|
| 11:15:28.177 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
285855,
287404,
285719,
285355,
284848
],
"durationInMs": 10.077766000002157
}
}
|
|---|
| 11:15:28.178 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
177960,
122834,
243913,
129564,
264259
],
"durationInMs": 9.856216999993194
}
}
|
|---|
| 11:15:28.178 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
"parameters": [
16,
231
],
"durationInMs": 4.790228999976534
}
}
|
|---|
| 11:15:28.179 | debug | kysely.query | {
"kysely": {
"sql": "select `target_user_id`, count(`id`) as `count` from `following` where (`target_company_id` is null and `target_user_id` in (?, ?, ?, ?, ?)) group by `target_user_id`",
"parameters": [
281529,
172942,
367838,
189859,
372347
],
"durationInMs": 14.957599999965169
}
}
|
|---|
| 11:15:28.179 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
283,
"fr",
138,
"fr",
85,
"fr",
197,
"fr",
3,
"fr"
],
"durationInMs": 3.4943419999908656
}
}
|
|---|
| 11:15:28.179 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
249,
129,
477,
396,
319
],
"durationInMs": 3.4520339999580756
}
}
|
|---|
| 11:15:28.180 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
694,
"fr",
308,
"fr"
],
"durationInMs": 3.244900999998208
}
}
|
|---|
| 11:15:28.180 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
398,
35,
1080,
92,
312
],
"durationInMs": 3.1913109999732114
}
}
|
|---|
| 11:15:28.180 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
248,
127,
77,
177,
1
],
"durationInMs": 1.1944990000338294
}
}
|
|---|
| 11:15:28.181 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
"parameters": [
1099,
269
],
"durationInMs": 0.854049000015948
}
}
|
|---|
| 11:15:28.272 | debug | kysely.query | {
"kysely": {
"sql": "with `nb_following`(`company_id`, `nb_following`) as (select `target_company_id` as `company_id`, count(*) as `nb_following` from `following` group by `target_company_id`) select `id`, `nb_following`.`nb_following` from `company` inner join `nb_following` on `nb_following`.`company_id` = `company`.`id` where `valid` = ? and `online` = ? and `square_photo_id` is not null and `company`.`country` = ? order by `nb_following`.`nb_following` desc limit ?",
"parameters": [
1,
1,
"bj",
30
],
"durationInMs": 162.70116299996153
}
}
|
|---|
| 11:15:28.274 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
39725,
825584,
9679,
394109,
586937
],
"durationInMs": 1.837087000021711
}
}
|
|---|
| 11:15:28.275 | debug | kysely.query | {
"kysely": {
"sql": "select `target_company_id`, count(`id`) as `count` from `following` where (`target_company_id` in (?, ?, ?, ?, ?) and `target_user_id` is null) group by `target_company_id`",
"parameters": [
39725,
825584,
9679,
394109,
586937
],
"durationInMs": 2.4928100000252016
}
}
|
|---|
| 11:15:28.275 | debug | kysely.query | {
"kysely": {
"sql": "select `company_author_id`, count(`id`) as `count` from `feed_post` where (`company_author_id` in (?, ?, ?, ?, ?) and `user_author_id` is null) group by `company_author_id`",
"parameters": [
39725,
825584,
9679,
394109,
586937
],
"durationInMs": 2.579009000037331
}
}
|
|---|
| 11:15:28.275 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?)",
"parameters": [
191,
195,
488,
157
],
"durationInMs": 0.4193059999961406
}
}
|
|---|
| 11:15:28.276 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
272811,
267235,
155711,
40166,
231628
],
"durationInMs": 0.7134889999870211
}
}
|
|---|
| 11:15:28.276 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
194,
"fr",
156,
"fr"
],
"durationInMs": 0.4439610000117682
}
}
|
|---|
| 11:15:28.276 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
"parameters": [
191,
"fr",
195,
"fr",
488,
"fr",
157,
"fr"
],
"durationInMs": 1.3794510000152513
}
}
|
|---|
| 11:15:28.277 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
"parameters": [
174,
144
],
"durationInMs": 0.45374899997841567
}
}
|
|---|
| 11:15:28.277 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?)",
"parameters": [
171,
175,
400,
145
],
"durationInMs": 0.3093419999931939
}
}
|
|---|
| 11:15:28.353 | info | http.response | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "bj"
},
"clientAddress": "216.73.216.18",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "jE6x3mBXvtI_NSOVTKAG",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "GOAFRICA_NEXT_SESSION_ID=OckeJVerEt2WWdD9I0U1Ic3Qb6GcFoLTvTYcqhIf; PHPSESSID=feb2b8145d0c2dce3e0e4e7b21798c30; goafrica-ad-id=68907a214cbb29.68244812",
"host": "www.goa.goafrica.syazen.cloud",
"user-agent": "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)",
"x-forwarded-for": "216.73.216.18",
"x-real-ip": "216.73.216.18",
"x-scheme": "https"
}
},
"response": {
"bytes": 308449,
"mime_type": "text/html",
"status_code": 200,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "GOAFRICA_NEXT_SESSION_ID=OckeJVerEt2WWdD9I0U1Ic3Qb6GcFoLTvTYcqhIf; PHPSESSID=feb2b8145d0c2dce3e0e4e7b21798c30; goafrica-ad-id=68907a214cbb29.68244812",
"host": "www.goa.goafrica.syazen.cloud",
"user-agent": "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)",
"x-forwarded-for": "216.73.216.18",
"x-real-ip": "216.73.216.18",
"x-scheme": "https"
}
}
},
"user_agent": {
"original": "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
},
"url": {
"full": "https://www.goa.goafrica.syazen.cloud/bj",
"original": "https://www.goa.goafrica.syazen.cloud/bj",
"path": "/bj",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 262316032,
"memoryUsageHuman": "250.2 MiB",
"requestTimeInMs": 260
}
}
|
|---|
