GET

https://www.goa.goafrica.syazen.cloud/ch/annuaire

{
    "svelte": {
        "route": {
            "id": "/(frontend)/[[_country]]/annuaire"
        },
        "params": {
            "_country": "ch"
        },
        "clientAddress": "216.73.216.18",
        "isDataRequest": false,
        "isSubRequest": false
    },
    "http": {
        "request": {
            "id": "lhyGgdQK-6vfDOIXXFEH",
            "method": "GET",
            "bytes": null,
            "mime_type": null,
            "referrer": null,
            "headers": {
                "accept": "*/*",
                "accept-encoding": "gzip, br, zstd, deflate",
                "connection": "close",
                "cookie": "PHPSESSID=76f6db3ca981a72f643d50506cfa4bf5; goafrica-ad-id=6894067b8d15c4.53087005; GOAFRICA_NEXT_SESSION_ID=76DtEoYWqvhjA5ChtPmHQXXDCoBi3u1Kg5ecqvz3",
                "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/ch/annuaire",
        "original": "https://www.goa.goafrica.syazen.cloud/ch/annuaire",
        "path": "/ch/annuaire",
        "domain": "www.goa.goafrica.syazen.cloud",
        "port": null,
        "username": null,
        "query": null,
        "scheme": "https"
    },
    "profiling": {
        "memoryUsage": 288927744,
        "memoryUsageHuman": "275.5 MiB"
    }
}

{
    "kysely": {
        "sql": "select * from `annuaire_societe_variant` where `country` = ? limit ?",
        "parameters": [
            "ch",
            1
        ],
        "durationInMs": 0.4721929999650456
    }
}

{
    "kysely": {
        "sql": "select * from `annuaire_societe_variant` where `country` = ? limit ?",
        "parameters": [
            "ch",
            1
        ],
        "durationInMs": 0.6981110000051558
    }
}

{
    "kysely": {
        "sql": "select * from `annuaire_societe_variant` where `country` = ? limit ?",
        "parameters": [
            "ch",
            1
        ],
        "durationInMs": 0.847927000024356
    }
}

{
    "kysely": {
        "sql": "select * from `annuaire_societe_variant` where `country` = ? limit ?",
        "parameters": [
            "ch",
            1
        ],
        "durationInMs": 0.9900200000265613
    }
}

{
    "kysely": {
        "sql": "select * from `annuaire_societe_variant` where `country` = ? limit ?",
        "parameters": [
            "ch",
            1
        ],
        "durationInMs": 1.05272600002354
    }
}

{
    "kysely": {
        "sql": "select `c`.`id` from `category` as `c` inner join `category_variant` as `v` on `c`.`id` = `v`.`category_id` where `c`.`parent_id` is null and `v`.`country` is null and `v`.`city_id` is null and `v`.`lang` = ? order by `c`.`rank` desc, `v`.`name` asc",
        "parameters": [
            "fr"
        ],
        "durationInMs": 1.1688410000060685
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            49,
            2
        ],
        "durationInMs": 0.7126370000187308
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            122,
            2
        ],
        "durationInMs": 1.0655089999781922
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            172,
            2
        ],
        "durationInMs": 1.2789440000196919
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            85,
            2
        ],
        "durationInMs": 1.4889519999851473
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            38,
            2
        ],
        "durationInMs": 1.7350469999946654
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            265,
            2
        ],
        "durationInMs": 1.9766640000161715
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            194,
            2
        ],
        "durationInMs": 2.17668400000548
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            138,
            2
        ],
        "durationInMs": 2.4010589999961667
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            283,
            2
        ],
        "durationInMs": 2.625142999982927
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            220,
            2
        ],
        "durationInMs": 3.775519000017084
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            3,
            2
        ],
        "durationInMs": 3.358286999980919
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            695,
            2
        ],
        "durationInMs": 3.2948409999953583
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            694,
            2
        ],
        "durationInMs": 3.2703549999860115
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            701,
            2
        ],
        "durationInMs": 3.22181499999715
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            698,
            2
        ],
        "durationInMs": 3.1784359999583103
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            260,
            2
        ],
        "durationInMs": 3.177323999989312
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            18,
            2
        ],
        "durationInMs": 3.1579079999937676
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            14,
            2
        ],
        "durationInMs": 3.122001999989152
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            332,
            2
        ],
        "durationInMs": 2.1512469999725
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            156,
            2
        ],
        "durationInMs": 3.8536139999632724
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            160,
            2
        ],
        "durationInMs": 3.9033159999526106
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            183,
            2
        ],
        "durationInMs": 3.942808999971021
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            615,
            2
        ],
        "durationInMs": 4.011435000051279
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            117,
            2
        ],
        "durationInMs": 3.989114999945741
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            197,
            2
        ],
        "durationInMs": 3.9874110000091605
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            252,
            2
        ],
        "durationInMs": 4.012728000001516
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            575,
            2
        ],
        "durationInMs": 4.041331000044011
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            257,
            2
        ],
        "durationInMs": 4.07201800000621
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            651,
            2
        ],
        "durationInMs": 6.351161000027787
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            308,
            2
        ],
        "durationInMs": 2.328464999969583
    }
}

{
    "kysely": {
        "sql": "select `id` from `category` where `parent_id` = ? limit ?",
        "parameters": [
            328,
            2
        ],
        "durationInMs": 2.2738740000058897
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            122,
            "ch",
            "fr",
            122,
            "fr",
            49,
            "ch",
            "fr",
            49,
            "fr",
            172,
            "ch",
            "fr",
            172,
            "fr",
            85,
            "ch",
            "fr",
            85,
            "fr",
            38,
            "ch",
            "fr",
            38,
            "fr",
            265,
            "ch",
            "fr",
            265,
            "fr",
            194,
            "ch",
            "fr",
            194,
            "fr",
            138,
            "ch",
            "fr",
            138,
            "fr",
            283,
            "ch",
            "fr",
            283,
            "fr",
            220,
            "ch",
            "fr",
            220,
            "fr",
            3,
            "ch",
            "fr",
            3,
            "fr",
            695,
            "ch",
            "fr",
            695,
            "fr",
            694,
            "ch",
            "fr",
            694,
            "fr",
            701,
            "ch",
            "fr",
            701,
            "fr",
            698,
            "ch",
            "fr",
            698,
            "fr",
            260,
            "ch",
            "fr",
            260,
            "fr",
            18,
            "ch",
            "fr",
            18,
            "fr",
            14,
            "ch",
            "fr",
            14,
            "fr",
            332,
            "ch",
            "fr",
            332,
            "fr",
            651,
            "ch",
            "fr",
            651,
            "fr",
            156,
            "ch",
            "fr",
            156,
            "fr",
            160,
            "ch",
            "fr",
            160,
            "fr",
            183,
            "ch",
            "fr",
            183,
            "fr",
            615,
            "ch",
            "fr",
            615,
            "fr",
            117,
            "ch",
            "fr",
            117,
            "fr",
            197,
            "ch",
            "fr",
            197,
            "fr",
            252,
            "ch",
            "fr",
            252,
            "fr",
            575,
            "ch",
            "fr",
            575,
            "fr",
            257,
            "ch",
            "fr",
            257,
            "fr",
            308,
            "ch",
            "fr",
            308,
            "fr",
            328,
            "ch",
            "fr",
            328,
            "fr"
        ],
        "durationInMs": 2.4688939999905415
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            50,
            "ch",
            "fr",
            50,
            "fr",
            52,
            "ch",
            "fr",
            52,
            "fr"
        ],
        "durationInMs": 3.1373599999933504
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            123,
            "ch",
            "fr",
            123,
            "fr",
            124,
            "ch",
            "fr",
            124,
            "fr"
        ],
        "durationInMs": 3.1874929999466985
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            173,
            "ch",
            "fr",
            173,
            "fr",
            174,
            "ch",
            "fr",
            174,
            "fr"
        ],
        "durationInMs": 3.211557000002358
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            35,
            "ch",
            "fr",
            35,
            "fr",
            77,
            "ch",
            "fr",
            77,
            "fr"
        ],
        "durationInMs": 3.683949999976903
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            39,
            "ch",
            "fr",
            39,
            "fr",
            40,
            "ch",
            "fr",
            40,
            "fr"
        ],
        "durationInMs": 3.697836000006646
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            266,
            "ch",
            "fr",
            266,
            "fr",
            267,
            "ch",
            "fr",
            267,
            "fr"
        ],
        "durationInMs": 3.7222509999992326
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            139,
            "ch",
            "fr",
            139,
            "fr",
            140,
            "ch",
            "fr",
            140,
            "fr"
        ],
        "durationInMs": 4.947877000027802
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            284,
            "ch",
            "fr",
            284,
            "fr",
            286,
            "ch",
            "fr",
            286,
            "fr"
        ],
        "durationInMs": 5.0043709999881685
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            221,
            "ch",
            "fr",
            221,
            "fr",
            222,
            "ch",
            "fr",
            222,
            "fr"
        ],
        "durationInMs": 4.144251000019722
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            4,
            "ch",
            "fr",
            4,
            "fr",
            5,
            "ch",
            "fr",
            5,
            "fr"
        ],
        "durationInMs": 4.1059799999929965
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            29,
            "ch",
            "fr",
            29,
            "fr",
            33,
            "ch",
            "fr",
            33,
            "fr"
        ],
        "durationInMs": 4.1011709999875166
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            56,
            "ch",
            "fr",
            56,
            "fr",
            74,
            "ch",
            "fr",
            74,
            "fr"
        ],
        "durationInMs": 3.6484249999630265
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            86,
            "ch",
            "fr",
            86,
            "fr",
            99,
            "ch",
            "fr",
            99,
            "fr"
        ],
        "durationInMs": 3.6195609999704175
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            113,
            "ch",
            "fr",
            113,
            "fr",
            116,
            "ch",
            "fr",
            116,
            "fr"
        ],
        "durationInMs": 3.6099640000029467
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            263,
            "ch",
            "fr",
            263,
            "fr",
            280,
            "ch",
            "fr",
            280,
            "fr"
        ],
        "durationInMs": 3.620411999989301
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            195,
            "ch",
            "fr",
            195,
            "fr",
            196,
            "ch",
            "fr",
            196,
            "fr"
        ],
        "durationInMs": 7.474287000019103
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            19,
            "ch",
            "fr",
            19,
            "fr",
            20,
            "ch",
            "fr",
            20,
            "fr"
        ],
        "durationInMs": 3.1238650000304915
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            15,
            "ch",
            "fr",
            15,
            "fr",
            16,
            "ch",
            "fr",
            16,
            "fr"
        ],
        "durationInMs": 3.136599000019487
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            336,
            "ch",
            "fr",
            336,
            "fr",
            349,
            "ch",
            "fr",
            349,
            "fr"
        ],
        "durationInMs": 3.141286999976728
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            157,
            "ch",
            "fr",
            157,
            "fr",
            159,
            "ch",
            "fr",
            159,
            "fr"
        ],
        "durationInMs": 3.131539000023622
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            165,
            "ch",
            "fr",
            165,
            "fr",
            166,
            "ch",
            "fr",
            166,
            "fr"
        ],
        "durationInMs": 3.137068999989424
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            184,
            "ch",
            "fr",
            184,
            "fr",
            186,
            "ch",
            "fr",
            186,
            "fr"
        ],
        "durationInMs": 3.119886999949813
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            617,
            "ch",
            "fr",
            617,
            "fr",
            618,
            "ch",
            "fr",
            618,
            "fr"
        ],
        "durationInMs": 3.0970150000066496
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            119,
            "ch",
            "fr",
            119,
            "fr",
            120,
            "ch",
            "fr",
            120,
            "fr"
        ],
        "durationInMs": 3.0700959999812767
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            199,
            "ch",
            "fr",
            199,
            "fr",
            200,
            "ch",
            "fr",
            200,
            "fr"
        ],
        "durationInMs": 3.0633729999535717
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            253,
            "ch",
            "fr",
            253,
            "fr",
            254,
            "ch",
            "fr",
            254,
            "fr"
        ],
        "durationInMs": 3.078360999992583
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            216,
            "ch",
            "fr",
            216,
            "fr",
            274,
            "ch",
            "fr",
            274,
            "fr"
        ],
        "durationInMs": 2.7957380000152625
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            258,
            "ch",
            "fr",
            258,
            "fr",
            259,
            "ch",
            "fr",
            259,
            "fr"
        ],
        "durationInMs": 2.778595999989193
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            96,
            "ch",
            "fr",
            96,
            "fr",
            652,
            "ch",
            "fr",
            652,
            "fr"
        ],
        "durationInMs": 2.740285000007134
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            309,
            "ch",
            "fr",
            309,
            "fr",
            310,
            "ch",
            "fr",
            310,
            "fr"
        ],
        "durationInMs": 2.750705000013113
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` as `v` where ((`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` = ? and `v`.`lang` = ?) or (`v`.`category_id` = ? and `v`.`country` is null and `v`.`lang` = ?))",
        "parameters": [
            329,
            "ch",
            "fr",
            329,
            "fr",
            330,
            "ch",
            "fr",
            330,
            "fr"
        ],
        "durationInMs": 2.740435999992769
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            47,
            49
        ],
        "durationInMs": 2.666338999988511
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            113,
            114
        ],
        "durationInMs": 2.6736829999717884
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            1060,
            157
        ],
        "durationInMs": 2.6684430000022985
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            33,
            69
        ],
        "durationInMs": 2.6140620000078343
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            37,
            38
        ],
        "durationInMs": 2.0734429999720305
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            232,
            233
        ],
        "durationInMs": 2.034550999989733
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            128,
            129
        ],
        "durationInMs": 1.9923230000422336
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            249,
            250
        ],
        "durationInMs": 1.947900999977719
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            197,
            198
        ],
        "durationInMs": 1.9036989999585785
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
        "parameters": [
            112,
            46,
            155,
            77,
            36,
            231,
            174,
            127,
            248,
            196,
            1,
            1100,
            1099,
            1401,
            1208,
            229,
            16,
            12,
            290,
            531,
            144,
            147,
            165,
            495,
            108,
            177,
            221,
            455,
            226,
            269,
            287
        ],
        "durationInMs": 4.855776000011247
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            2,
            3
        ],
        "durationInMs": 3.3814910000073723
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            27,
            31
        ],
        "durationInMs": 3.398904000001494
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            52,
            67
        ],
        "durationInMs": 3.401306999963708
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            104,
            107
        ],
        "durationInMs": 3.809553000028245
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            230,
            245
        ],
        "durationInMs": 3.8673890000209212
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            175,
            176
        ],
        "durationInMs": 3.921479000011459
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            17,
            18
        ],
        "durationInMs": 3.978024000010919
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            13,
            14
        ],
        "durationInMs": 4.0305609999923036
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            294,
            304
        ],
        "durationInMs": 2.6093230000115
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            145,
            146
        ],
        "durationInMs": 2.610945999971591
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            149,
            150
        ],
        "durationInMs": 2.632856999989599
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            166,
            167
        ],
        "durationInMs": 2.6753260000259615
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            78,
            90
        ],
        "durationInMs": 6.226890999998432
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            497,
            498
        ],
        "durationInMs": 2.348210999974981
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            109,
            110
        ],
        "durationInMs": 2.3493329999619164
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            178,
            179
        ],
        "durationInMs": 2.334165000007488
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            222,
            223
        ],
        "durationInMs": 2.2883400000282563
    }
}

{
    "kysely": {
        "sql": "select `id` from `cms_post` where `cms_post`.`slug` = ? limit ?",
        "parameters": [
            "questions-go-africa",
            1
        ],
        "durationInMs": 2.195469000027515
    }
}

{
    "kysely": {
        "sql": "select count(*) as `count` from `cms_post` where `online` = ? and JSON_CONTAINS(`countries`, JSON_ARRAY(?)) = ?",
        "parameters": [
            1,
            "CH",
            true
        ],
        "durationInMs": 2.20781100000022
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            193,
            239
        ],
        "durationInMs": 2.4737830000231043
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            227,
            228
        ],
        "durationInMs": 2.4363439999870025
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            87,
            532
        ],
        "durationInMs": 2.3938649999909103
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            288,
            289
        ],
        "durationInMs": 2.0821690000011586
    }
}

{
    "kysely": {
        "sql": "select * from `media__media` as `m` where `m`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
        "parameters": [
            225615,
            277,
            297,
            255,
            278,
            295,
            292,
            293,
            294,
            296,
            243,
            199661,
            199659,
            284106,
            239625,
            279,
            291,
            298,
            299,
            76728,
            300,
            301,
            302,
            303,
            304,
            305,
            306,
            308,
            309,
            310,
            311
        ],
        "durationInMs": 2.219684000010602
    }
}

{
    "kysely": {
        "sql": "select * from `cms_post` as `o` where `o`.`id` in (?)",
        "parameters": [
            36
        ],
        "durationInMs": 3.0294799999683164
    }
}

{
    "kysely": {
        "sql": "select * from `category_variant` where `category_variant`.`id` in (?, ?)",
        "parameters": [
            270,
            271
        ],
        "durationInMs": 4.534823000023607
    }
}

{
    "svelte": {
        "route": {
            "id": "/(frontend)/[[_country]]/annuaire"
        },
        "params": {
            "_country": "ch"
        },
        "clientAddress": "216.73.216.18",
        "isDataRequest": false,
        "isSubRequest": false
    },
    "http": {
        "request": {
            "id": "lhyGgdQK-6vfDOIXXFEH",
            "method": "GET",
            "bytes": null,
            "mime_type": null,
            "referrer": null,
            "headers": {
                "accept": "*/*",
                "accept-encoding": "gzip, br, zstd, deflate",
                "connection": "close",
                "cookie": "PHPSESSID=76f6db3ca981a72f643d50506cfa4bf5; goafrica-ad-id=6894067b8d15c4.53087005; GOAFRICA_NEXT_SESSION_ID=76DtEoYWqvhjA5ChtPmHQXXDCoBi3u1Kg5ecqvz3",
                "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": 183256,
            "mime_type": "text/html",
            "status_code": 200,
            "headers": {
                "accept": "*/*",
                "accept-encoding": "gzip, br, zstd, deflate",
                "connection": "close",
                "cookie": "PHPSESSID=76f6db3ca981a72f643d50506cfa4bf5; goafrica-ad-id=6894067b8d15c4.53087005; GOAFRICA_NEXT_SESSION_ID=76DtEoYWqvhjA5ChtPmHQXXDCoBi3u1Kg5ecqvz3",
                "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/ch/annuaire",
        "original": "https://www.goa.goafrica.syazen.cloud/ch/annuaire",
        "path": "/ch/annuaire",
        "domain": "www.goa.goafrica.syazen.cloud",
        "port": null,
        "username": null,
        "query": null,
        "scheme": "https"
    },
    "profiling": {
        "memoryUsage": 295469056,
        "memoryUsageHuman": "281.8 MiB",
        "requestTimeInMs": 115
    }
}