Query Metrics
9
Database Queries
7
Different statements
12652.96 ms
Query time
0
Invalid entities
77376
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.15 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 0.73 ms |
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "dashboard" "[]" "2026-07-12 20:09:06" "https://osm-commerces.cipherbliss.com/admin/delete/1958341" null ]
|
||||||||||||||||||||||||||||
| 3 | 1255.29 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 4.75 ms |
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 5 | 3965.61 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.name IN (?, ?) ORDER BY s1_.id ASC, c0_.date ASC
Parameters:
[ 5081 5551 10863 10876 11070 23214 23315 23579 23687 23857 24006 24011 24091 24110 24181 24216 24434 24441 24495 24536 24549 24551 24596 24606 24618 24644 24651 24658 24679 24687 24701 24702 24741 24753 24760 24768 24775 24782 24790 24823 24870 24913 24914 24925 24929 24945 24965 24977 25007 25051 25053 25065 25068 25070 25093 25130 25131 25132 25137 25142 25155 25189 25194 25222 25247 25256 25281 25337 25359 25363 25375 25383 25417 25428 25492 25498 25502 25511 25515 25531 25533 25535 25542 25547 25581 25582 25589 25597 25643 25645 25646 25654 25688 25690 25692 25704 25711 25712 25714 25717 25729 25732 25736 25737 25738 25740 25743 25762 25770 25777 25785 25823 25832 25839 25840 25863 25867 25868 25875 25877 25880 25881 25909 25950 25964 25968 25972 25978 25979 25987 26006 26011 26022 26024 26025 26033 26035 26036 26037 26039 26040 26055 26059 26065 26067 26072 26098 26108 26110 26111 26115 26118 26122 26129 26132 26139 26141 26148 26180 26181 26184 26185 26186 26187 26189 26190 26192 26193 26195 26196 26198 26201 26204 26205 26206 26207 26222 26224 26229 26230 26233 26248 26256 26257 26258 26262 26263 26275 26298 26299 26300 26302 26303 26322 26332 26354 26361 26362 26371 26379 26387 26394 26395 26397 26400 26401 26402 26403 26404 26405 26407 26409 26411 26412 26417 26420 26421 26422 26423 26424 26425 26426 26427 26428 26429 26430 26431 26438 26439 26440 26441 26442 26443 26446 26447 26448 26452 26453 26454 26455 26457 26458 26459 26460 26462 26463 26467 26468 26471 26472 26473 26475 26476 26477 26479 26480 26483 26484 26486 26489 26490 26491 26492 26494 26495 26497 26500 26501 26503 26504 26505 26507 26508 26509 26510 26511 26512 26514 26515 26516 26517 26518 26519 26520 26522 26523 26524 26525 26526 26527 26528 26529 26530 26531 26532 26534 26536 26537 26538 26540 26541 26543 26544 26545 26547 26548 26549 26550 26552 26554 26555 26557 26558 26559 26560 26562 26563 26564 26565 26566 26569 26570 26572 26573 26574 26577 26578 26579 26580 26581 26583 26585 26587 26588 26589 26590 26591 26592 26593 26594 26596 26597 26598 26600 26601 26602 26604 26606 26608 26609 26610 26612 26614 26617 26619 26620 26621 26623 26624 26625 26626 26627 26628 26631 26632 26633 26634 26635 26637 26638 26640 26641 26642 26643 26644 26645 26646 26647 26649 26650 26651 26652 26653 26654 26655 26659 26660 26661 26662 26663 26664 26667 26669 26670 26671 26673 26674 26675 26676 26677 "places_completion" "places_freshness_days" ]
|
||||||||||||||||||||||||||||
| 6 | 3685.06 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.name IN (?, ?) ORDER BY s1_.id ASC, c0_.date ASC
Parameters:
[ 26681 26683 26684 26685 26688 26689 26690 26691 26692 26696 26697 26698 26699 26700 26701 26702 26704 26705 26706 26707 26709 26711 26712 26714 26715 26716 26718 26720 26722 26724 26725 26727 26728 26729 26730 26731 26732 26733 26734 26736 26738 26740 26741 26742 26743 26745 26747 26749 26750 26751 26752 26753 26756 26757 26759 26760 26761 26762 26763 26764 26765 26766 26768 26769 26771 26773 26776 26777 26778 26779 26781 26782 26783 26784 26785 26786 26787 26788 26789 26790 26791 26794 26795 26796 26797 26798 26799 26800 26801 26803 26806 26807 26808 26810 26811 26813 26814 26817 26818 26820 26821 26822 26823 26824 26825 26826 26828 26829 26831 26832 26836 26837 26840 26841 26843 26844 26845 26846 26847 26848 26849 26850 26851 26852 26853 26855 26856 26858 26859 26860 26861 26862 26864 26865 26866 26867 26870 26872 26873 26874 26875 26876 26877 26878 26879 26880 26881 26882 26883 26884 26886 26887 26890 26893 26894 26895 26896 26897 26898 26899 26900 26901 26902 26904 26905 26906 26907 26908 26909 26910 26911 26912 26913 26914 26915 26916 26917 26918 26919 26921 26922 26923 26924 26926 26927 26928 26929 26930 26932 26935 26936 26938 26939 26940 26941 26942 26943 26944 26945 26948 26949 26951 26952 26953 26954 26956 26957 26958 26959 26960 26961 26962 26963 26964 26965 26967 26968 26969 26971 26972 26973 26974 26975 26976 26977 26979 26980 26982 26983 26985 26986 26987 26988 26989 26990 26991 26992 26993 26994 26995 26996 26998 26999 27001 27002 27003 27005 27007 27008 27011 27012 27013 27014 27015 27018 27019 27022 27023 27025 27026 27027 27029 27030 27031 27034 27035 27036 27037 27038 27039 27040 27041 27042 27045 27046 27047 27050 27051 27052 27053 27054 27057 27058 27059 27060 27061 27062 27065 27066 27067 27068 27069 27070 27071 27072 27073 27074 27075 27076 27077 27078 27079 27080 27081 27082 27083 27084 27085 27086 27087 27088 27090 27091 27092 27094 27095 27096 27097 27098 27099 27100 27101 27102 27103 27104 27105 27108 27109 27110 27111 27112 27113 27114 27115 27116 27117 27118 27119 27120 27122 27123 27124 27125 27126 27127 27128 27129 27130 27132 27133 27134 27135 27136 27138 27139 27140 27141 27142 27143 27145 27146 27147 27148 27149 27150 27152 27153 27154 27155 27156 27157 27159 27160 27161 27162 27163 27164 27165 27166 27167 27168 27170 27171 27172 27173 27175 27176 27177 27179 27180 27181 27182 27183 27184 27185 27186 27187 27188 27189 27190 "places_completion" "places_freshness_days" ]
|
||||||||||||||||||||||||||||
| 7 | 3603.53 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.name IN (?, ?) ORDER BY s1_.id ASC, c0_.date ASC
Parameters:
[ 27191 27192 27193 27194 27195 27196 27197 27199 27201 27203 27206 27209 27210 27211 27212 27213 27214 27215 27216 27217 27218 27219 27220 27221 27222 27223 27224 27225 27227 27228 27230 27231 27232 27235 27236 27237 27240 27242 27244 27245 27246 27248 27252 27258 27259 27261 27262 27263 27264 27266 27267 27268 27271 27273 27274 27276 27279 27280 27281 27282 27283 27284 27285 27286 27287 27288 27291 27297 27298 27301 27302 27303 27306 27307 27308 27309 27310 27311 27312 27313 27314 27315 27316 27317 27319 27321 27322 27323 27324 27325 27326 27327 27329 27330 27331 27332 27333 27334 27338 27340 27341 27342 27343 27344 27345 27347 27348 27349 27350 27352 27353 27354 27355 27356 27357 27358 27359 27360 27361 27362 27363 27366 27367 27369 27370 27371 27372 27373 27374 27375 27376 27377 27379 27380 27381 27382 27383 27384 27385 27386 27387 27388 27389 27390 27391 27392 27394 27395 27396 27397 27398 27399 27400 27401 27402 27403 27405 27406 27408 27409 27410 27411 27412 27413 27414 27415 27416 27417 27418 27419 27420 27421 27422 27423 27424 27425 27426 27428 27429 27430 27431 27432 27433 27434 27435 27436 27437 27438 27439 27440 27441 27442 27443 27444 27445 27446 27447 27448 27449 27450 27451 27452 27453 27454 27455 27456 27457 27458 27459 27460 27461 27462 27463 27464 27465 27467 27468 27469 27470 27471 27472 27473 27474 27475 27476 27477 27478 27479 27480 27481 27482 27483 27484 27485 27486 27487 27488 27489 27490 27491 27492 27493 27494 27495 27496 27498 27499 27500 27501 27502 27503 27504 27505 27506 27507 27508 27509 27510 27511 27512 27513 27514 27515 27516 27517 27518 27519 27520 27521 27522 27523 27524 27525 27526 27527 27528 27529 27530 27531 27532 27533 27534 27535 27536 27537 27538 27539 27540 27541 27542 27543 27544 27545 27546 27547 27548 27549 27550 27551 27552 27553 27554 27555 27556 27557 27558 27559 27560 27563 27564 27565 27566 27567 27568 27569 27570 27571 27572 27573 27574 27575 27576 27577 27578 27579 27580 27581 27582 27583 27584 27585 27586 27587 27588 27589 27590 27591 27592 27593 27594 27595 27596 27597 27598 27599 27600 27601 27602 27603 27604 27605 27606 27607 27608 27609 27610 27611 27612 27613 27614 27615 27616 27617 27618 27619 27620 27621 27622 27623 27624 27625 27626 27627 27628 27630 27631 27632 27633 27634 27635 27636 27637 27638 27640 27641 27642 27643 27644 27646 27647 27648 27649 27650 27651 27652 27653 27654 27655 27656 27657 "places_completion" "places_freshness_days" ]
|
||||||||||||||||||||||||||||
| 8 | 117.39 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.name IN (?, ?) ORDER BY s1_.id ASC, c0_.date ASC
Parameters:
[ 27658 27659 27660 27661 27662 27664 27665 27666 27667 27668 27669 27670 27671 27672 27673 27675 27676 27677 27678 27679 27680 27682 27683 27684 27686 27687 27688 27689 27690 27691 27692 27693 27694 27695 "places_completion" "places_freshness_days" ]
|
||||||||||||||||||||||||||||
| 9 | 20.47 ms |
SELECT COUNT(*) FROM place t0
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| osm | doctrine.dbal.osm_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\CityFollowUp | 76116 |
| App\Entity\Stats | 1259 |
| App\Entity\ActionLog | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ActionLog | No errors. |
| App\Entity\Stats | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\StatsHistory | No errors. |
| App\Entity\CityFollowUp | No errors. |
| App\Entity\ZonePlaces | No errors. |
| App\Entity\SireneEntreprise | No errors. |