GET https://www.devz5.com/api/leaflet/63/98785

Response
200 OK
Browse referrer URL
IP
2a01:cb0a:9004:2322:a41e:c6be:d93f:7e19
Profiled on
Token
aba1c5

Query Metrics

8 Database Queries
8 Different statements
56.54 ms Query time
1 Invalid entities
164 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
54.41 ms
(96.24%) 		1 
SELECT cluster.id, get_distance_metres('50.5980066', '3.0602934', cluster.latitude, cluster.longitude) AS proximite  FROM cluster WHERE cluster.operation_id = 8 and cluster.type_id = 5 HAVING proximite < 500
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.95 ms
(1.67%) 		1 
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.total AS total_4, t0.nom AS nom_5, t0.nom_affiche AS nom_affiche_6, t0.total_rv AS total_rv_7, t0.compteur_accessible AS compteur_accessible_8, t0.complet AS complet_9, t0.distance AS distance_10, t0.mission_id AS mission_id_11, t0.type_id AS type_id_12, t0.operation_id AS operation_id_13 FROM cluster t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  93107
  217.97781734589
  93108
  199.90146325265
  93109
  256.41516734779
  93110
  275.35956066146
  93115
  459.64728256731
  93116
  247.41538512065
  93117
  250.71782920087
  93118
  258.22088726907
  93120
  319.94930736483
  93186
  245.24813320896
  93187
  234.36775642496
  93188
  237.13787932903
  93189
  223.38500941163
  93190
  187.66759023725
  93192
  213.81970813478
  93253
  231.95345253554
  93254
  223.42552989655
  93255
  220.32498413666
  93256
  223.03738262097
  93257
  218.65746312918
  93259
  256.9548405372
  93391
  378.57840728953
  93392
  379.90952154306
  93393
  383.90462598076
  93394
  391.55447111557
  93395
  395.40415107168
  93396
  365.13908705797
  93397
  399.88890190427
  93398
  403.26305262023
  93399
  408.06495699282
  93400
  411.91726989182
  93401
  417.17076803818
  93402
  372.43946786279
  93403
  372.94045879001
  93479
  497.51263589372
  93508
  440.53207070038
  93509
  346.81324108274
  93510
  401.07838864932
  93511
  414.66170217866
  93512
  370.53892841679
  93513
  424.23442100096
  93514
  391.93935237882
  93515
  413.03110010743
  93516
  410.47700638122
  93517
  454.86662000716
  93518
  332.22176963384
  93519
  446.85515972034
  93520
  359.7308953214
  93521
  355.92497624691
  93522
  354.37585337624
  93523
  336.5483528006
  93524
  388.33356845434
  93546
  460.9199361783
  93547
  455.99372746611
  93548
  449.58187071955
  93549
  398.41561540321
  93550
  439.3215351608
  93551
  431.94973922282
  93552
  388.54358022971
  93553
  428.68058175421
  93554
  383.91110070467
  93555
  424.14981035643
  93556
  377.87842163638
  93557
  420.32311441375
  93558
  373.91008621632
  93559
  368.11125621251
  93560
  409.39825942884
  93561
  361.8793786659
  93562
  406.22332019758
  93563
  357.60251387958
  93564
  400.66488297064
  93565
  353.27443547521
  93566
  396.1087644458
  93567
  348.40044945673
  93568
  391.70605192414
  93569
  343.62809680606
  93570
  386.77215903308
  93571
  339.36936201574
  93572
  382.25111236486
  93573
  377.15601032102
  93574
  372.10601990147
  93575
  372.86896201804
  93576
  366.57904493131
  93578
  496.64317925554
  93579
  486.69849246519
  93581
  479.7413511998
  93582
  495.49092124594
  93583
  475.88538905787
  93584
  469.16219855094
  93585
  466.29856296026
  93586
  453.40616957059
  93587
  453.1759869354
  93588
  458.10328263228
  93589
  467.57379674531
  98785
  0.0
  98786
  51.860898693666
  98787
  25.628402636012
  98788
  34.549145762608
  98789
  39.324744430155
  98790
  43.929425395512
  98791
  32.287456221162
  98868
  328.34477408894
  98869
  311.81518461247
  98870
  298.55380379721
  98871
  289.7457589603
  98872
  287.41027216586
  98873
  267.93629462498
  98874
  262.88414748611
  98875
  254.31271196809
  98876
  233.04084870178
  98877
  212.80058414408
  98878
  185.68303229355
  98879
  177.74881710211
  98880
  164.20940416928
  98881
  152.28807439286
  98882
  139.64429027762
  98883
  133.13864782967
  98884
  123.10900365579
  98885
  116.40625945048
  98888
  485.44266087206
  98889
  492.26307031071
  98890
  473.93403495677
  98891
  485.00895600754
  98892
  449.75474539795
  98893
  480.56622730297
  98894
  475.20186456278
  98896
  472.06508698238
  98897
  456.78781924485
  98898
  447.66105764886
  98900
  429.72752776443
  98903
  192.73993559082
  98904
  198.48678583134
  98905
  205.20838205816
  98906
  210.52629136338
  98907
  213.58384358148
  98909
  175.15529011619
  98910
  117.72212628385
  98911
  166.16803795454
  98912
  137.18490437288
  98913
  120.22804090791
  98914
  493.60266394602
  98915
  104.72297826513
  98916
  92.404390430231
  98917
  177.44646043079
  98918
  80.343419464855
  98919
  169.6249845987
  98920
  156.08095707601
  98922
  137.54015109396
  98923
  127.79361385241
  98924
  107.4172879658
  98925
  93.036618362012
  98926
  84.061934778505
  98930
  484.15867964613
  98931
  476.4286619773
  98934
  494.19621039948
  98967
  435.5720888494
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.76%) 		1 
SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.35%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.total AS total_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.operation_id AS operation_id_6 FROM mission t0 WHERE t0.id = ?
Parameters: 
[
  "63"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.27%) 		1 
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.total AS total_4, t0.nom AS nom_5, t0.nom_affiche AS nom_affiche_6, t0.total_rv AS total_rv_7, t0.compteur_accessible AS compteur_accessible_8, t0.complet AS complet_9, t0.distance AS distance_10, t0.mission_id AS mission_id_11, t0.type_id AS type_id_12, t0.operation_id AS operation_id_13 FROM cluster t0 WHERE t0.id = ?
Parameters: 
[
  "98785"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.25%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.zoom AS zoom_3 FROM cluster_type t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.24%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.max_creneau AS max_creneau_5, t0.distance AS distance_6, t0.nombremission AS nombremission_7, t0.total AS total_8, t0.nb_creneau AS nb_creneau_9, t0.googlesheets AS googlesheets_10, t0.logo AS logo_11, t0.image AS image_12 FROM operation t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.22%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.zoom AS zoom_3 FROM cluster_type t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Cluster 156
App\Entity\ClusterType 5
App\Entity\User 1
App\Entity\Mission 1
App\Entity\Operation 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Logpoint No errors.
App\Entity\Logetat No errors.
App\Entity\Mission No errors.
App\Entity\Operation No errors.
App\Entity\Cluster
  • The association App\Entity\Cluster#type refers to the inverse side field App\Entity\ClusterType#clusters which does not exist.
App\Entity\Point No errors.
App\Entity\ClusterType No errors.
App\Entity\SMS No errors.
App\Entity\Mail No errors.
App\Entity\Agent No errors.
App\Entity\Creneau No errors.
App\Entity\Creneauhoraire No errors.