| 13:33:00.548 | info | http.request | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "mg"
},
"clientAddress": "82.97.199.249",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "njjtMBuBlDGfqLz2PTGB",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept-language": "en-US,en;q=0.9",
"connection": "close",
"host": "www.goa.goafrica.syazen.cloud",
"user-agent": "Brightbot 1.0",
"x-forwarded-for": "82.97.199.249",
"x-real-ip": "82.97.199.249",
"x-scheme": "https"
}
}
},
"user_agent": {
"original": "Brightbot 1.0"
},
"url": {
"full": "https://www.goa.goafrica.syazen.cloud/mg",
"original": "https://www.goa.goafrica.syazen.cloud/mg",
"path": "/mg",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 255295488,
"memoryUsageHuman": "243.5 MiB"
}
}
|
|---|
| 13:33:00.586 | debug | kysely.query | {
"kysely": {
"sql": "select `id` from `cms_post` where `cms_post`.`slug` = ? limit ?",
"parameters": [
"questions-go-africa",
1
],
"durationInMs": 0.21910499990917742
}
}
|
|---|
| 13:33:00.589 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?)",
"parameters": [
36
],
"durationInMs": 2.18429800006561
}
}
|
|---|
| 13:33:00.589 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"MG",
true
],
"durationInMs": 2.6904549999162555
}
}
|
|---|
| 13:33:00.592 | 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.4839550000615418
}
}
|
|---|
| 13:33:00.593 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `user` where `enabled` = ?",
"parameters": [
1
],
"durationInMs": 0.6808889999520034
}
}
|
|---|
| 13:33:00.593 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `company` where `valid` = ? and `online` = ?",
"parameters": [
1,
1
],
"durationInMs": 0.8231819998472929
}
}
|
|---|
| 13:33:00.593 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ? order by `weight` desc limit ?",
"parameters": [
0,
"mg",
1,
13
],
"durationInMs": 0.9075880001764745
}
}
|
|---|
| 13:33:00.593 | 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",
"mg",
2
],
"durationInMs": 1.133244999917224
}
}
|
|---|
| 13:33:00.593 | 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",
"mg",
3
],
"durationInMs": 1.3365710000507534
}
}
|
|---|
| 13:33:00.594 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
408830,
404332,
398575,
414851,
413665
],
"durationInMs": 0.545858999947086
}
}
|
|---|
| 13:33:00.595 | 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": [
"mg",
1,
"background",
"2025-08-24T11:33:00.592Z",
"2025-08-24T11:33:00.592Z",
1
],
"durationInMs": 2.558911999920383
}
}
|
|---|
| 13:33:00.601 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
408830,
404332,
398575,
414851,
413665
],
"durationInMs": 5.621813999954611
}
}
|
|---|
| 13:33:00.602 | debug | kysely.query | {
"kysely": {
"sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
"parameters": [
1,
"MG",
true
],
"durationInMs": 9.042278999928385
}
}
|
|---|
| 13:33:00.603 | 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": [
"mg",
"mg",
3
],
"durationInMs": 10.162521000020206
}
}
|
|---|
| 13:33:00.603 | 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",
"mg",
30
],
"durationInMs": 10.7422230001539
}
}
|
|---|
| 13:33:00.603 | 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",
"mg",
30
],
"durationInMs": 11.026317999931052
}
}
|
|---|
| 13:33:00.604 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `country` = ? and `visible_force` = ?",
"parameters": [
0,
"mg",
0
],
"durationInMs": 10.411762000061572
}
}
|
|---|
| 13:33:00.604 | 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,
"MG",
true,
588,
592,
594,
595,
4
],
"durationInMs": 10.800801000092179
}
}
|
|---|
| 13:33:00.604 | 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": [
"mg",
"mg",
3
],
"durationInMs": 11.926701999967918
}
}
|
|---|
| 13:33:00.606 | 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": [
408830,
404332,
398575,
414851,
413665
],
"durationInMs": 5.096473000012338
}
}
|
|---|
| 13:33:00.606 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
279234,
275037,
269436,
285721,
284763
],
"durationInMs": 4.264674999983981
}
}
|
|---|
| 13:33:00.607 | 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": [
12,
"fr",
369,
"fr",
125,
"fr",
363,
"fr",
123,
"fr"
],
"durationInMs": 4.081768000032753
}
}
|
|---|
| 13:33:00.607 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
12,
369,
125,
363,
123
],
"durationInMs": 4.158518999814987
}
}
|
|---|
| 13:33:00.608 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
335452,
220713,
351720,
396927,
201845
],
"durationInMs": 4.071007000049576
}
}
|
|---|
| 13:33:00.608 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?, ?, ?, ?) group by `author_id`",
"parameters": [
335452,
220713,
351720,
396927,
201845
],
"durationInMs": 4.464614999946207
}
}
|
|---|
| 13:33:00.608 | 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": [
335452,
220713,
351720,
396927,
201845
],
"durationInMs": 4.3738170000724494
}
}
|
|---|
| 13:33:00.609 | 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": [
335452,
220713,
351720,
396927,
201845
],
"durationInMs": 3.7173429999966174
}
}
|
|---|
| 13:33:00.609 | 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": [
408830,
404332,
398575,
414851,
413665
],
"durationInMs": 8.134511000011116
}
}
|
|---|
| 13:33:00.610 | 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": 3.4822790001053363
}
}
|
|---|
| 13:33:00.610 | debug | kysely.query | {
"kysely": {
"sql": "select * from `cms_post` as `o` where `o`.`id` in (?, ?, ?, ?)",
"parameters": [
165,
588,
592,
594
],
"durationInMs": 3.267180999973789
}
}
|
|---|
| 13:33:00.611 | 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": 3.9748700000345707
}
}
|
|---|
| 13:33:00.611 | 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": 3.8505700000096112
}
}
|
|---|
| 13:33:00.611 | 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": 3.2265659999102354
}
}
|
|---|
| 13:33:00.612 | 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": 3.2458619999233633
}
}
|
|---|
| 13:33:00.612 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
1025
],
"durationInMs": 3.243987999856472
}
}
|
|---|
| 13:33:00.612 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
1025
],
"durationInMs": 3.248916999902576
}
}
|
|---|
| 13:33:00.612 | 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": [
1025
],
"durationInMs": 3.254778000060469
}
}
|
|---|
| 13:33:00.621 | 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": [
1025
],
"durationInMs": 11.121263999957591
}
}
|
|---|
| 13:33:00.621 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `r`.`id`) as `count` from `reaction` as `r` where `r`.`target_feed_post_id` = ?",
"parameters": [
1024
],
"durationInMs": 10.177718000020832
}
}
|
|---|
| 13:33:00.621 | debug | kysely.query | {
"kysely": {
"sql": "select count(distinct `c`.`id`) as `count` from `feed_comment` as `c` where `c`.`feed_post_id` = ?",
"parameters": [
1024
],
"durationInMs": 10.192866999888793
}
}
|
|---|
| 13:33:00.621 | 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": [
1024
],
"durationInMs": 10.227229999843985
}
}
|
|---|
| 13:33:00.622 | 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": [
1024
],
"durationInMs": 10.226258999900892
}
}
|
|---|
| 13:33:00.622 | debug | kysely.query | {
"kysely": {
"sql": "select * from `feed_post` where `id` in (?, ?, ?)",
"parameters": [
1026,
1025,
1024
],
"durationInMs": 10.292211000109091
}
}
|
|---|
| 13:33:00.624 | 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": [
1026,
1025,
1024
],
"durationInMs": 12.03953199996613
}
}
|
|---|
| 13:33:00.624 | 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": [
1026,
1025,
1024
],
"durationInMs": 12.137321999995038
}
}
|
|---|
| 13:33:00.628 | 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": [
1026,
1025,
1024
],
"durationInMs": 16.206095000030473
}
}
|
|---|
| 13:33:00.629 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
10,
319,
115,
314,
113
],
"durationInMs": 8.22860400006175
}
}
|
|---|
| 13:33:00.630 | 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": [
3,
"fr",
122,
"fr",
283,
"fr"
],
"durationInMs": 8.571309000020847
}
}
|
|---|
| 13:33:00.630 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
219086,
144079,
229229,
266801,
135692
],
"durationInMs": 8.840897000161931
}
}
|
|---|
| 13:33:00.631 | 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": [
608,
"fr",
282,
"fr",
460,
"fr",
634,
"fr"
],
"durationInMs": 9.216982000041753
}
}
|
|---|
| 13:33:00.631 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?, ?, ?, ?)",
"parameters": [
608,
282,
460,
634
],
"durationInMs": 9.424726999830455
}
}
|
|---|
| 13:33:00.632 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `weight` > ? and `all_countries` = ? and `visible_force` = ?",
"parameters": [
0,
1,
0
],
"durationInMs": 8.374114000005648
}
}
|
|---|
| 13:33:00.632 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?)",
"parameters": [
204105,
284081,
284544,
285208
],
"durationInMs": 8.16602999996394
}
}
|
|---|
| 13:33:00.633 | 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": [
1026,
1025,
1024,
null,
null
],
"durationInMs": 4.443556000012904
}
}
|
|---|
| 13:33:00.633 | 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": [
1026,
1025,
1024,
null,
null
],
"durationInMs": 4.53982499986887
}
}
|
|---|
| 13:33:00.634 | debug | kysely.query | {
"kysely": {
"sql": "select * from `user` where `user`.`id` in (?, ?)",
"parameters": [
1967,
2575
],
"durationInMs": 4.267539999913424
}
}
|
|---|
| 13:33:00.638 | debug | kysely.query | {
"kysely": {
"sql": "select `author_id`, count(`id`) as `count` from `following` where `author_id` in (?, ?) group by `author_id`",
"parameters": [
1967,
2575
],
"durationInMs": 7.921847000019625
}
}
|
|---|
| 13:33:00.638 | 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": [
1967,
2575
],
"durationInMs": 7.488986999960616
}
}
|
|---|
| 13:33:00.638 | 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": [
1967,
2575
],
"durationInMs": 7.235418000025675
}
}
|
|---|
| 13:33:00.639 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?)",
"parameters": [
1,
112,
248
],
"durationInMs": 6.999452000018209
}
}
|
|---|
| 13:33:00.639 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?)",
"parameters": [
488,
247,
379,
514
],
"durationInMs": 6.859072000021115
}
}
|
|---|
| 13:33:00.639 | 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": [
18,
"fr",
265,
"fr",
49,
"fr",
197,
"fr"
],
"durationInMs": 6.523061000043526
}
}
|
|---|
| 13:33:00.639 | debug | kysely.query | {
"kysely": {
"sql": "select * from `reference` where `reference`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
29,
10,
16,
59,
8
],
"durationInMs": 6.506189999869093
}
}
|
|---|
| 13:33:00.647 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?)",
"parameters": [
277,
"fr"
],
"durationInMs": 8.980184999993071
}
}
|
|---|
| 13:33:00.647 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?)",
"parameters": [
114975,
275015
],
"durationInMs": 9.08194199996069
}
}
|
|---|
| 13:33:00.648 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
41,
2231,
62079,
597362,
394
],
"durationInMs": 7.878647999837995
}
}
|
|---|
| 13:33:00.648 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?)",
"parameters": [
16,
231,
46,
177
],
"durationInMs": 9.068857999984175
}
}
|
|---|
| 13:33:00.649 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?)",
"parameters": [
90397,
90399,
90286,
235022,
156604
],
"durationInMs": 8.794892000034451
}
}
|
|---|
| 13:33:00.657 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?)",
"parameters": [
277
],
"durationInMs": 19.60393900005147
}
}
|
|---|
| 13:33:00.658 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?)",
"parameters": [
242
],
"durationInMs": 10.94704100000672
}
}
|
|---|
| 13:33:00.707 | 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,
"mg",
30
],
"durationInMs": 114.71717499988154
}
}
|
|---|
| 13:33:00.709 | debug | kysely.query | {
"kysely": {
"sql": "select * from `company` where `company`.`id` in (?, ?)",
"parameters": [
70536,
70538
],
"durationInMs": 1.1242390000261366
}
}
|
|---|
| 13:33:00.709 | 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": [
70536,
70538
],
"durationInMs": 1.7756630000658333
}
}
|
|---|
| 13:33:00.710 | 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": [
70536,
70538
],
"durationInMs": 1.8608500000555068
}
}
|
|---|
| 13:33:00.710 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` as `v` where (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?)",
"parameters": [
126,
"fr"
],
"durationInMs": 0.4942340000998229
}
}
|
|---|
| 13:33:00.711 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category_variant` where `category_variant`.`id` in (?)",
"parameters": [
116
],
"durationInMs": 1.395120000001043
}
}
|
|---|
| 13:33:00.711 | debug | kysely.query | {
"kysely": {
"sql": "select * from `category` where `category`.`id` in (?)",
"parameters": [
126
],
"durationInMs": 2.153772999998182
}
}
|
|---|
| 13:33:00.712 | debug | kysely.query | {
"kysely": {
"sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?)",
"parameters": [
3911,
3917
],
"durationInMs": 2.3147199999075383
}
}
|
|---|
| 13:33:00.754 | info | http.response | {
"svelte": {
"route": {
"id": "/(frontend)/[[_country]]"
},
"params": {
"_country": "mg"
},
"clientAddress": "82.97.199.249",
"isDataRequest": false,
"isSubRequest": false
},
"http": {
"request": {
"id": "njjtMBuBlDGfqLz2PTGB",
"method": "GET",
"bytes": null,
"mime_type": null,
"referrer": null,
"headers": {
"accept-language": "en-US,en;q=0.9",
"connection": "close",
"host": "www.goa.goafrica.syazen.cloud",
"user-agent": "Brightbot 1.0",
"x-forwarded-for": "82.97.199.249",
"x-real-ip": "82.97.199.249",
"x-scheme": "https"
}
},
"response": {
"bytes": 279688,
"mime_type": "text/html",
"status_code": 200,
"headers": {
"accept-language": "en-US,en;q=0.9",
"connection": "close",
"host": "www.goa.goafrica.syazen.cloud",
"user-agent": "Brightbot 1.0",
"x-forwarded-for": "82.97.199.249",
"x-real-ip": "82.97.199.249",
"x-scheme": "https"
}
}
},
"user_agent": {
"original": "Brightbot 1.0"
},
"url": {
"full": "https://www.goa.goafrica.syazen.cloud/mg",
"original": "https://www.goa.goafrica.syazen.cloud/mg",
"path": "/mg",
"domain": "www.goa.goafrica.syazen.cloud",
"port": null,
"username": null,
"query": null,
"scheme": "https"
},
"profiling": {
"memoryUsage": 276717568,
"memoryUsageHuman": "263.9 MiB",
"requestTimeInMs": 206
}
}
|
|---|
