| 22:40:42.005 | info | http.request | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "ne"
},
"clientAddress": "216.73.216.18",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "0hPgwBEed_FKI-SODYUP",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "goafrica-ad-id=68911a9d3c4474.48974478; PHPSESSID=6ab6677e4423159a06985268ddac1eb0; GOAFRICA_NEXT_SESSION_ID=kyYSWNiGVgfI5JZb6CdYjCVESTcOixFMic5mwtsB",
"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/ne",
"original": "https://www.goa.goafrica.syazen.cloud/ne",
"path": "/ne",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 252297216,
"memoryUsageHuman": "240.6 MiB"
}
}
|
|---|
| 22:40:42.011 | debug | kysely.query | {
"kysely": {
"sql": "select `id` from `cms_post` where `cms_post`.`slug` = ? limit ?",
"parameters": [
"questions-go-africa",
1
],
"durationInMs": 0.30839999997988343
}
}
|
|---|
| 22:40:42.014 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?)",
"parameters": [
36
],
"durationInMs": 2.5994669999927282
}
}
|
|---|
| 22:40:42.014 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"NE",
true
],
"durationInMs": 3.2237209999002516
}
}
|
|---|
| 22:40:42.018 | 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.5356310000643134
}
}
|
|---|
| 22:40:42.018 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `user` where `enabled` = ?",
"parameters": [
1
],
"durationInMs": 0.7484139995649457
}
}
|
|---|
| 22:40:42.018 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `company` where `valid` = ? and `online` = ?",
"parameters": [
1,
1
],
"durationInMs": 0.9053950002416968
}
}
|
|---|
| 22:40:42.019 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ? order by `weight` desc limit ?",
"parameters": [
0,
"ne",
1,
13
],
"durationInMs": 0.9967930000275373
}
}
|
|---|
| 22:40:42.019 | 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": [
"ne",
1,
"background",
"2025-08-04T20:40:42.017Z",
"2025-08-04T20:40:42.017Z",
1
],
"durationInMs": 1.1120360000059009
}
}
|
|---|
| 22:40:42.020 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"NE",
true
],
"durationInMs": 1.8284700000658631
}
}
|
|---|
| 22:40:42.020 | 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",
"ne",
2
],
"durationInMs": 2.8543479996733367
}
}
|
|---|
| 22:40:42.022 | 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": [
"ne",
"ne",
3
],
"durationInMs": 4.057281999848783
}
}
|
|---|
| 22:40:42.022 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ?",
"parameters": [
0,
"ne",
0
],
"durationInMs": 2.0551999998278916
}
}
|
|---|
| 22:40:42.022 | 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,
"NE",
true,
588,
592,
594,
595,
4
],
"durationInMs": 3.735698000062257
}
}
|
|---|
| 22:40:42.023 | 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,
13
],
"durationInMs": 0.44023399986326694
}
}
|
|---|
| 22:40:42.024 | 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",
"ne",
30
],
"durationInMs": 5.936557000037283
}
}
|
|---|
| 22:40:42.024 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `all_countries` = ? and `visible_force` = ?",
"parameters": [
0,
1,
0
],
"durationInMs": 0.855411000084132
}
}
|
|---|
| 22:40:42.024 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?, ?, ?, ?)",
"parameters": [
590,
518,
517,
516
],
"durationInMs": 1.4905260000377893
}
}
|
|---|
| 22:40:42.025 | 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": [
"ne",
"ne",
3
],
"durationInMs": 7.046368999872357
}
}
|
|---|
| 22:40:42.026 | 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",
"ne",
30
],
"durationInMs": 8.667045999784023
}
}
|
|---|
| 22:40:42.027 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `reference`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
29,
10,
16,
59,
8
],
"durationInMs": 2.9769049999304116
}
}
|
|---|
| 22:40:42.027 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?)",
"parameters": [
284150,
273900,
273898,
273768
],
"durationInMs": 2.7690999996848404
}
}
|
|---|
| 22:40:42.028 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
498
],
"durationInMs": 1.804636999964714
}
}
|
|---|
| 22:40:42.029 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
498
],
"durationInMs": 3.241884000133723
}
}
|
|---|
| 22:40:42.029 | 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": [
498
],
"durationInMs": 3.359292000066489
}
}
|
|---|
| 22:40:42.030 | 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": [
498
],
"durationInMs": 3.466960999649018
}
}
|
|---|
| 22:40:42.030 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
412
],
"durationInMs": 3.572534999810159
}
}
|
|---|
| 22:40:42.030 | 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": [
412
],
"durationInMs": 2.639309999998659
}
}
|
|---|
| 22:40:42.030 | 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": [
412
],
"durationInMs": 2.299261999782175
}
}
|
|---|
| 22:40:42.030 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
1026
],
"durationInMs": 2.254648999776691
}
}
|
|---|
| 22:40:42.030 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
1026
],
"durationInMs": 0.9214439997449517
}
}
|
|---|
| 22:40:42.030 | 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": [
1026
],
"durationInMs": 0.9613769999705255
}
}
|
|---|
| 22:40:42.031 | 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": [
1026
],
"durationInMs": 0.9737409995868802
}
}
|
|---|
| 22:40:42.031 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
412
],
"durationInMs": 4.078099999576807
}
}
|
|---|
| 22:40:42.034 | 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",
"ne",
3
],
"durationInMs": 16.70848499983549
}
}
|
|---|
| 22:40:42.035 | 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": [
498,
412,
1026
],
"durationInMs": 5.352425999939442
}
}
|
|---|
| 22:40:42.036 | 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": [
498,
412,
1026
],
"durationInMs": 5.515889000147581
}
}
|
|---|
| 22:40:42.036 | 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": [
498,
412,
1026
],
"durationInMs": 5.5804479997605085
}
}
|
|---|
| 22:40:42.036 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
319210,
219705,
237121,
196865,
334304
],
"durationInMs": 5.800936000421643
}
}
|
|---|
| 22:40:42.037 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
319210,
219705,
237121,
196865,
334304
],
"durationInMs": 6.941846000030637
}
}
|
|---|
| 22:40:42.038 | 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": [
319210,
219705,
237121,
196865,
334304
],
"durationInMs": 6.970679000020027
}
}
|
|---|
| 22:40:42.038 | 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": [
319210,
219705,
237121,
196865,
334304
],
"durationInMs": 6.983423000201583
}
}
|
|---|
| 22:40:42.038 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
90397,
90399,
90286,
235022,
156604
],
"durationInMs": 3.267502000089735
}
}
|
|---|
| 22:40:42.038 | debug | kysely.query | {
"kysely": {
"sql": "select * from `feed_post` where `id` in (?, ?, ?)",
"parameters": [
498,
412,
1026
],
"durationInMs": 8.618987000081688
}
}
|
|---|
| 22:40:42.040 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
41,
2231,
62079,
597362,
394
],
"durationInMs": 4.588363999966532
}
}
|
|---|
| 22:40:42.040 | 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": [
498,
412,
1026,
null,
null
],
"durationInMs": 4.679572999943048
}
}
|
|---|
| 22:40:42.041 | 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": [
498,
412,
1026,
null,
null
],
"durationInMs": 4.775420000310987
}
}
|
|---|
| 22:40:42.041 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
292172,
280665,
254757,
406409,
406396
],
"durationInMs": 3.7319399998523295
}
}
|
|---|
| 22:40:42.042 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
292172,
280665,
254757,
406409,
406396
],
"durationInMs": 4.394636000040919
}
}
|
|---|
| 22:40:42.042 | 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": [
292172,
280665,
254757,
406409,
406396
],
"durationInMs": 4.419912999961525
}
}
|
|---|
| 22:40:42.043 | 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": [
292172,
280665,
254757,
406409,
406396
],
"durationInMs": 5.427044999785721
}
}
|
|---|
| 22:40:42.044 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
"parameters": [
279451,
279452,
279453,
279454,
279455,
279456,
279457,
279458,
279459,
279460,
279461,
279462,
279463,
279464,
279465,
279466,
279467,
279475,
279489,
279478,
279474,
279485,
279472,
279479,
279482,
279488,
279490,
279477,
279470,
279473,
279476,
279480,
279481,
279484,
279487,
279469,
279491,
279483,
279486,
279468,
279471
],
"durationInMs": 5.44774299999699
}
}
|
|---|
| 22:40:42.045 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
207842,
143625,
151833,
132965,
218314
],
"durationInMs": 6.094920000061393
}
}
|
|---|
| 22:40:42.051 | 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": [
12,
"fr",
123,
"fr",
485,
"fr",
59,
"fr"
],
"durationInMs": 10.384392000269145
}
}
|
|---|
| 22:40:42.051 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?)",
"parameters": [
12,
123,
485,
59
],
"durationInMs": 10.406272000167519
}
}
|
|---|
| 22:40:42.051 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?)",
"parameters": [
410018,
189172,
1967
],
"durationInMs": 10.561728999949992
}
}
|
|---|
| 22:40:42.052 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?) group by `author_id`",
"parameters": [
410018,
189172,
1967
],
"durationInMs": 10.161789000034332
}
}
|
|---|
| 22:40:42.052 | 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": [
410018,
189172,
1967
],
"durationInMs": 10.142343000043184
}
}
|
|---|
| 22:40:42.052 | 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": [
410018,
189172,
1967
],
"durationInMs": 10.10122699989006
}
}
|
|---|
| 22:40:42.053 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
286744,
178052,
160586,
276896,
277447
],
"durationInMs": 9.191274999640882
}
}
|
|---|
| 22:40:42.053 | 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` = ?))",
"parameters": [
380,
"fr",
169,
"fr",
254,
"fr"
],
"durationInMs": 8.610650999937207
}
}
|
|---|
| 22:40:42.053 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?)",
"parameters": [
380,
169,
254
],
"durationInMs": 7.860964999999851
}
}
|
|---|
| 22:40:42.054 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?)",
"parameters": [
113,
10,
398,
55
],
"durationInMs": 2.963168999645859
}
}
|
|---|
| 22:40:42.054 | 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": [
3,
"fr",
122,
"fr",
85,
"fr",
49,
"fr"
],
"durationInMs": 2.9239870002493262
}
}
|
|---|
| 22:40:42.054 | 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": [
610,
"fr",
277,
"fr"
],
"durationInMs": 2.4570439998060465
}
}
|
|---|
| 22:40:42.055 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?)",
"parameters": [
610,
277
],
"durationInMs": 2.4758480000309646
}
}
|
|---|
| 22:40:42.055 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?)",
"parameters": [
325,
153,
223
],
"durationInMs": 1.584549999795854
}
}
|
|---|
| 22:40:42.058 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?)",
"parameters": [
1,
112,
77,
46
],
"durationInMs": 4.162436000071466
}
}
|
|---|
| 22:40:42.059 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
"parameters": [
490,
242
],
"durationInMs": 4.142169000115246
}
}
|
|---|
| 22:40:42.059 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?)",
"parameters": [
265,
"fr"
],
"durationInMs": 4.04187300009653
}
}
|
|---|
| 22:40:42.059 | 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": [
160,
"fr",
252,
"fr"
],
"durationInMs": 5.4228170001879334
}
}
|
|---|
| 22:40:42.060 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?)",
"parameters": [
231
],
"durationInMs": 1.4230010001920164
}
}
|
|---|
| 22:40:42.061 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
"parameters": [
147,
221
],
"durationInMs": 1.3051430000923574
}
}
|
|---|
| 22:40:42.125 | 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,
"ne",
30
],
"durationInMs": 107.52826499985531
}
}
|
|---|
| 22:40:42.128 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
82856,
29403,
481736,
360596,
505136
],
"durationInMs": 1.814083999954164
}
}
|
|---|
| 22:40:42.129 | 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": [
82856,
29403,
481736,
360596,
505136
],
"durationInMs": 2.438940000254661
}
}
|
|---|
| 22:40:42.129 | 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": [
82856,
29403,
481736,
360596,
505136
],
"durationInMs": 2.660209000110626
}
}
|
|---|
| 22:40:42.129 | 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": [
175,
"fr",
126,
"fr",
154,
"fr",
540,
"fr",
191,
"fr"
],
"durationInMs": 0.5326950000599027
}
}
|
|---|
| 22:40:42.129 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
175,
126,
154,
540,
191
],
"durationInMs": 0.7575909998267889
}
}
|
|---|
| 22:40:42.130 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
4487,
2034,
34762,
17847,
5387
],
"durationInMs": 1.0877910000272095
}
}
|
|---|
| 22:40:42.130 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
1063,
116,
142,
438,
171
],
"durationInMs": 0.921072999946773
}
}
|
|---|
| 22:40:42.130 | 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` = ?))",
"parameters": [
172,
"fr",
138,
"fr",
183,
"fr"
],
"durationInMs": 0.8637769999913871
}
}
|
|---|
| 22:40:42.131 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?)",
"parameters": [
155,
127,
165
],
"durationInMs": 0.28087899973616004
}
}
|
|---|
| 22:40:42.184 | info | http.response | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "ne"
},
"clientAddress": "216.73.216.18",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "0hPgwBEed_FKI-SODYUP",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "goafrica-ad-id=68911a9d3c4474.48974478; PHPSESSID=6ab6677e4423159a06985268ddac1eb0; GOAFRICA_NEXT_SESSION_ID=kyYSWNiGVgfI5JZb6CdYjCVESTcOixFMic5mwtsB",
"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": 315295,
"mime_type": "text/html",
"status_code": 200,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "goafrica-ad-id=68911a9d3c4474.48974478; PHPSESSID=6ab6677e4423159a06985268ddac1eb0; GOAFRICA_NEXT_SESSION_ID=kyYSWNiGVgfI5JZb6CdYjCVESTcOixFMic5mwtsB",
"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/ne",
"original": "https://www.goa.goafrica.syazen.cloud/ne",
"path": "/ne",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 272486400,
"memoryUsageHuman": "259.9 MiB",
"requestTimeInMs": 179
}
}
|
|---|
