Symfony Profiler

GET https://gobeletapi.devazapp.fr/api/thematique/eco300/Mariage

Response: 200 OK
: Browse referrer URL
IP: 88.184.85.40
Profiled on: Thu, 12 Feb 2026 19:13:23 +0100
Token: 575aa7

Query Metrics

4 Database Queries

4 Different statements

19.85 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.36 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.color AS color_4 FROM theme_categorie t0 WHERE t0.nom = ? LIMIT 1 Parameters: [`"Mariage"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.color AS color_4 FROM theme_categorie t0 WHERE t0.nom = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.color AS color_4 FROM theme_categorie t0 WHERE t0.nom = 'Mariage' LIMIT 1;
2	0.39 ms	SELECT count(DISTINCT t0_.id) AS sclr_0 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT count(DISTINCT t0_.id) AS sclr_0 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = ? SELECT count(DISTINCT t0_.id) AS sclr_0 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = 12;
3	0.31 ms	SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = ? ORDER BY t0_.id ASC LIMIT 1000 Parameters: [`12`] View formatted query View runnable query Explain query SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = ? ORDER BY t0_.id ASC LIMIT 1000 SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = 12 ORDER BY t0_.id ASC LIMIT 1000;
4	18.79 ms	SELECT t0_.text_data AS text_data_0, t0_.image_data AS image_data_1, t0_.eco300 AS eco300_2, t0_.ref AS ref_3 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = ? AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0_.id ASC Parameters: [12 272 273 274 275 276 277 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 335 336 337 339 340 341 342 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 375 376 377 378 379 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 416 417 418 419 420 421 422 424 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 449 450 451 452 453 454 455 456 457 458 459 460 461 462 464 465 466 467 468 469 470 471 472 473 475 476 477 479 480 481 486 487 490 527 533 587 589 590 599 601 608 612 613 615 631 632 638 643 644 645 653 655 657 665 668 670 678 680 682 705 707 709 713 715 717 750 751 752 757 758 759 765 766 768 796 797 798 799 801 802 1093 1095 1098 1578 1579 1580 1641 1642 1643 1681 1685 1689 1694 1713 1714 1718 1719 1726 1792 1793 1794 1875 1880 1884 1970 1980 1981 1994 1995 1996 2054 2055 2056 2057 2058 2059 2082 2083 2084 2128 2131 2132 2140 2143 2145 2147 2148 2149 2153 2154 2155 2188 2189 2190 2194 2195 2196 2238 2239 2240 2373 2376 2380 2385 2389 2390 2462 2463 2465 2466 2468 2469 2600 2965 2966 2967 2968 2971 3018 3070 3080 3576 3682 4279] View formatted query View runnable query Explain query SELECT t0_.text_data AS text_data_0, t0_.image_data AS image_data_1, t0_.eco300 AS eco300_2, t0_.ref AS ref_3 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = ? AND t0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY t0_.id ASC SELECT t0_.text_data AS text_data_0, t0_.image_data AS image_data_1, t0_.eco300 AS eco300_2, t0_.ref AS ref_3 FROM theme t0_ INNER JOIN theme_sous_categorie t1_ ON t0_.souss_categorie_id = t1_.id INNER JOIN theme_categorie t2_ ON t1_.category_id = t2_.id WHERE t2_.id = 12 AND t0_.id IN (272, 273, 274, 275, 276, 277, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 335, 336, 337, 339, 340, 341, 342, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 375, 376, 377, 378, 379, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 416, 417, 418, 419, 420, 421, 422, 424, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 475, 476, 477, 479, 480, 481, 486, 487, 490, 527, 533, 587, 589, 590, 599, 601, 608, 612, 613, 615, 631, 632, 638, 643, 644, 645, 653, 655, 657, 665, 668, 670, 678, 680, 682, 705, 707, 709, 713, 715, 717, 750, 751, 752, 757, 758, 759, 765, 766, 768, 796, 797, 798, 799, 801, 802, 1093, 1095, 1098, 1578, 1579, 1580, 1641, 1642, 1643, 1681, 1685, 1689, 1694, 1713, 1714, 1718, 1719, 1726, 1792, 1793, 1794, 1875, 1880, 1884, 1970, 1980, 1981, 1994, 1995, 1996, 2054, 2055, 2056, 2057, 2058, 2059, 2082, 2083, 2084, 2128, 2131, 2132, 2140, 2143, 2145, 2147, 2148, 2149, 2153, 2154, 2155, 2188, 2189, 2190, 2194, 2195, 2196, 2238, 2239, 2240, 2373, 2376, 2380, 2385, 2389, 2390, 2462, 2463, 2465, 2466, 2468, 2469, 2600, 2965, 2966, 2967, 2968, 2971, 3018, 3070, 3080, 3576, 3682, 4279) ORDER BY t0_.id ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\ThemeCategorie	No errors.
App\Entity\ThemeSousCategorie	No errors.
App\Entity\Theme	No errors.