14:40:04.226 | info | http.request | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "ci"
},
"clientAddress": "216.73.216.18",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "ACYpHRTvb4S-2S8-MaGm",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "GOAFRICA_NEXT_SESSION_ID=JECmpPVjWXKoQ84vkS8z0JwGLHcN2HVInifnv0Ga; goafrica-ad-id=6890aa23269535.56984410; PHPSESSID=ffa6b139449563bbe7f8248bc976906f",
"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/ci",
"original": "https://www.goa.goafrica.syazen.cloud/ci",
"path": "/ci",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 242454528,
"memoryUsageHuman": "231.2 MiB"
}
} |
---|
14:40:04.231 | debug | kysely.query | {
"kysely": {
"sql": "select `id` from `cms_post` where `cms_post`.`slug` = ? limit ?",
"parameters": [
"questions-go-africa",
1
],
"durationInMs": 0.19859699998050928
}
} |
---|
14:40:04.233 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"CI",
true
],
"durationInMs": 2.5873650000430644
}
} |
---|
14:40:04.234 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?)",
"parameters": [
36
],
"durationInMs": 2.6979090000968426
}
} |
---|
14:40:04.237 | 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.4659020002000034
}
} |
---|
14:40:04.238 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `user` where `enabled` = ?",
"parameters": [
1
],
"durationInMs": 0.6870810000691563
}
} |
---|
14:40:04.238 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `company` where `valid` = ? and `online` = ?",
"parameters": [
1,
1
],
"durationInMs": 0.8328800001181662
}
} |
---|
14:40:04.238 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ? order by `weight` desc limit ?",
"parameters": [
0,
"ci",
1,
13
],
"durationInMs": 1.350376999936998
}
} |
---|
14:40:04.241 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"CI",
true
],
"durationInMs": 2.868013999890536
}
} |
---|
14:40:04.241 | 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": [
"ci",
"ci",
3
],
"durationInMs": 3.406228000065312
}
} |
---|
14:40:04.241 | 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",
"ci",
30
],
"durationInMs": 3.907175000058487
}
} |
---|
14:40:04.241 | 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": [
"ci",
"ci",
3
],
"durationInMs": 3.9228839999996126
}
} |
---|
14:40:04.242 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
1002
],
"durationInMs": 0.19745499989949167
}
} |
---|
14:40:04.242 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ?",
"parameters": [
0,
"ci",
0
],
"durationInMs": 1.4820609998423606
}
} |
---|
14:40:04.242 | 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": [
"ci",
1,
"background",
"2025-08-04T12:40:04.237Z",
"2025-08-04T12:40:04.237Z",
1
],
"durationInMs": 4.835411999840289
}
} |
---|
14:40:04.249 | 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",
"ci",
30
],
"durationInMs": 11.784821999957785
}
} |
---|
14:40:04.249 | 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,
"CI",
true,
588,
592,
594,
595,
4
],
"durationInMs": 10.951220999937505
}
} |
---|
14:40:04.250 | 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": [
1002
],
"durationInMs": 8.352855999954045
}
} |
---|
14:40:04.251 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
1000
],
"durationInMs": 8.301229999866337
}
} |
---|
14:40:04.251 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
1000
],
"durationInMs": 2.136259999824688
}
} |
---|
14:40:04.251 | 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": [
1000
],
"durationInMs": 1.6591989998705685
}
} |
---|
14:40:04.254 | 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": [
1002
],
"durationInMs": 11.885077999904752
}
} |
---|
14:40:04.254 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
1002
],
"durationInMs": 12.077925000106916
}
} |
---|
14:40:04.255 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
998
],
"durationInMs": 4.5095989999827
}
} |
---|
14:40:04.255 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
998
],
"durationInMs": 4.508266000077128
}
} |
---|
14:40:04.255 | 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": [
998
],
"durationInMs": 4.5159310000017285
}
} |
---|
14:40:04.256 | 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": [
998
],
"durationInMs": 4.521800999995321
}
} |
---|
14:40:04.256 | debug | kysely.query | {
"kysely": {
"sql": "select * from `feed_post` where `id` in (?, ?, ?)",
"parameters": [
1002,
1000,
998
],
"durationInMs": 1.9436939998995513
}
} |
---|
14:40:04.257 | 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": [
1002,
1000,
998
],
"durationInMs": 3.0510919999796897
}
} |
---|
14:40:04.257 | 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": [
1000
],
"durationInMs": 7.7749779999721795
}
} |
---|
14:40:04.258 | 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": [
1002,
1000,
998
],
"durationInMs": 3.2245030000340194
}
} |
---|
14:40:04.259 | 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": [
1002,
1000,
998
],
"durationInMs": 3.535326999844983
}
} |
---|
14:40:04.259 | 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,
4
],
"durationInMs": 3.82227799994871
}
} |
---|
14:40:04.260 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
980,
242117,
286072,
372054,
408976
],
"durationInMs": 4.008412000024691
}
} |
---|
14:40:04.260 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
980,
242117,
286072,
372054,
408976
],
"durationInMs": 3.697728000115603
}
} |
---|
14:40:04.261 | 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": [
980,
242117,
286072,
372054,
408976
],
"durationInMs": 3.403363000135869
}
} |
---|
14:40:04.261 | 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": [
980,
242117,
286072,
372054,
408976
],
"durationInMs": 3.4210660001263022
}
} |
---|
14:40:04.264 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?, ?, ?, ?)",
"parameters": [
590,
587,
584,
583
],
"durationInMs": 5.605635999934748
}
} |
---|
14:40:04.265 | 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": [
1002,
1000,
998,
null,
null
],
"durationInMs": 6.085563000058755
}
} |
---|
14:40:04.265 | 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": [
1002,
1000,
998,
null,
null
],
"durationInMs": 5.994694999884814
}
} |
---|
14:40:04.266 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?)",
"parameters": [
843498
],
"durationInMs": 5.659375000046566
}
} |
---|
14:40:04.266 | 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": [
843498
],
"durationInMs": 5.915218000067398
}
} |
---|
14:40:04.267 | 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": [
843498
],
"durationInMs": 5.895631999941543
}
} |
---|
14:40:04.267 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?)",
"parameters": [
416181
],
"durationInMs": 6.0172079999465495
}
} |
---|
14:40:04.272 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?) group by `author_id`",
"parameters": [
416181
],
"durationInMs": 6.828708000015467
}
} |
---|
14:40:04.272 | 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": [
416181
],
"durationInMs": 6.679742000065744
}
} |
---|
14:40:04.272 | 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": [
416181
],
"durationInMs": 6.555713000008836
}
} |
---|
14:40:04.272 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?, ?)",
"parameters": [
287898,
287900,
287901,
287902,
287903,
287810
],
"durationInMs": 6.015154000138864
}
} |
---|
14:40:04.275 | debug | kysely.query | {
"kysely": {
"sql": "select * from `link_meta_data` where `id` in (?)",
"parameters": [
440
],
"durationInMs": 8.424037999939173
}
} |
---|
14:40:04.275 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `all_countries` = ? and `visible_force` = ?",
"parameters": [
0,
1,
0
],
"durationInMs": 8.580316999927163
}
} |
---|
14:40:04.276 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
96742,
154001,
178038,
247179,
279510
],
"durationInMs": 8.249684999929741
}
} |
---|
14:40:04.277 | 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,
"ci",
30
],
"durationInMs": 39.91691399994306
}
} |
---|
14:40:04.278 | 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": [
126,
"fr",
129,
"fr",
190,
"fr",
581,
"fr",
195,
"fr"
],
"durationInMs": 5.822205999866128
}
} |
---|
14:40:04.278 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
126,
129,
190,
581,
195
],
"durationInMs": 5.918663999997079
}
} |
---|
14:40:04.278 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?)",
"parameters": [
284150,
283220,
282445,
282441
],
"durationInMs": 6.107713999925181
}
} |
---|
14:40:04.279 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?)",
"parameters": [
684,
"fr"
],
"durationInMs": 4.226305000018328
}
} |
---|
14:40:04.279 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?)",
"parameters": [
684
],
"durationInMs": 3.6633640001527965
}
} |
---|
14:40:04.279 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `reference`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
"parameters": [
20,
19,
18,
17,
16,
15,
14,
52,
53,
29,
10,
59
],
"durationInMs": 3.56184700015001
}
} |
---|
14:40:04.286 | 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": [
577705,
36197,
49068,
42580,
360911
],
"durationInMs": 8.205884999828413
}
} |
---|
14:40:04.286 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
116,
119,
170,
461,
175
],
"durationInMs": 8.264803000027314
}
} |
---|
14:40:04.287 | 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": [
122,
"fr",
183,
"fr",
575,
"fr",
194,
"fr"
],
"durationInMs": 8.156031999969855
}
} |
---|
14:40:04.287 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?)",
"parameters": [
1064
],
"durationInMs": 8.314294999931008
}
} |
---|
14:40:04.287 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?)",
"parameters": [
85,
"fr"
],
"durationInMs": 8.322239000117406
}
} |
---|
14:40:04.288 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
"parameters": [
90281,
90283,
90284,
90285,
90286,
90290,
90291,
90334,
90345,
90397,
90399,
235022
],
"durationInMs": 8.130635000066832
}
} |
---|
14:40:04.293 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
577705,
36197,
49068,
42580,
360911
],
"durationInMs": 15.439431000035256
}
} |
---|
14:40:04.294 | 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": [
577705,
36197,
49068,
42580,
360911
],
"durationInMs": 16.676146999932826
}
} |
---|
14:40:04.294 | 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",
"ci",
2
],
"durationInMs": 57.44971599988639
}
} |
---|
14:40:04.295 | 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",
"ci",
3
],
"durationInMs": 57.64340399997309
}
} |
---|
14:40:04.297 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
"parameters": [
438698,
61599,
437108,
62079,
64434,
111909,
60301,
52904,
41,
2231,
597362
],
"durationInMs": 10.565206999890506
}
} |
---|
14:40:04.297 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?)",
"parameters": [
112,
165,
455,
174
],
"durationInMs": 10.370216999901459
}
} |
---|
14:40:04.298 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
132801,
39112,
3209,
26284,
28209
],
"durationInMs": 3.5468290001153946
}
} |
---|
14:40:04.298 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?)",
"parameters": [
77
],
"durationInMs": 10.624225999927148
}
} |
---|
14:40:04.298 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
157,
304,
59,
522,
175
],
"durationInMs": 4.269876000005752
}
} |
---|
14:40:04.299 | 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": [
157,
"fr",
304,
"fr",
59,
"fr",
522,
"fr",
175,
"fr"
],
"durationInMs": 4.861399000044912
}
} |
---|
14:40:04.299 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
414442,
414396,
414299,
416177,
415983
],
"durationInMs": 3.859086000127718
}
} |
---|
14:40:04.300 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
414442,
414396,
414299,
416177,
415983
],
"durationInMs": 4.352268000133336
}
} |
---|
14:40:04.302 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?)",
"parameters": [
173,
345,
41
],
"durationInMs": 0.9885379998013377
}
} |
---|
14:40:04.302 | 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": [
156,
"fr",
49,
"fr",
160,
"fr",
172,
"fr"
],
"durationInMs": 3.8263260000385344
}
} |
---|
14:40:04.303 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
145,
265,
55,
425,
1063
],
"durationInMs": 3.7675570000428706
}
} |
---|
14:40:04.303 | 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": [
173,
"fr",
345,
"fr",
41,
"fr"
],
"durationInMs": 2.3181070000864565
}
} |
---|
14:40:04.304 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
285352,
285366,
284847,
287792,
287209
],
"durationInMs": 2.8083029999397695
}
} |
---|
14:40:04.304 | 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": [
414442,
414396,
414299,
416177,
415983
],
"durationInMs": 8.71463599987328
}
} |
---|
14:40:04.310 | 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": [
414442,
414396,
414299,
416177,
415983
],
"durationInMs": 14.718447999795899
}
} |
---|
14:40:04.311 | 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": [
3,
"fr",
38,
"fr"
],
"durationInMs": 8.261327000102028
}
} |
---|
14:40:04.311 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?)",
"parameters": [
144,
46,
147,
155
],
"durationInMs": 8.232292999979109
}
} |
---|
14:40:04.311 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?)",
"parameters": [
1060,
302,
39
],
"durationInMs": 7.862298999913037
}
} |
---|
14:40:04.312 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
"parameters": [
1,
36
],
"durationInMs": 1.2824620001483709
}
} |
---|
14:40:04.391 | info | http.response | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "ci"
},
"clientAddress": "216.73.216.18",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "ACYpHRTvb4S-2S8-MaGm",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "GOAFRICA_NEXT_SESSION_ID=JECmpPVjWXKoQ84vkS8z0JwGLHcN2HVInifnv0Ga; goafrica-ad-id=6890aa23269535.56984410; PHPSESSID=ffa6b139449563bbe7f8248bc976906f",
"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": 314688,
"mime_type": "text/html",
"status_code": 200,
"headers": {
"accept": "*/*",
"accept-encoding": "gzip, br, zstd, deflate",
"connection": "close",
"cookie": "GOAFRICA_NEXT_SESSION_ID=JECmpPVjWXKoQ84vkS8z0JwGLHcN2HVInifnv0Ga; goafrica-ad-id=6890aa23269535.56984410; PHPSESSID=ffa6b139449563bbe7f8248bc976906f",
"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/ci",
"original": "https://www.goa.goafrica.syazen.cloud/ci",
"path": "/ci",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 287621120,
"memoryUsageHuman": "274.3 MiB",
"requestTimeInMs": 165
}
} |
---|