Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

142.29 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
142.29 ms (100.00%)	1	SELECT wkb_geometry, st_area(st_transform(wkb_geometry, 3857)) FROM public.parcelles p WHERE st_contains(p.wkb_geometry, ST_SetSRID(ST_MakePoint(4.3683072924614, 50.842326170012), 4326)); Parameters: [] View formatted query View runnable query Explain query SELECT wkb_geometry, st_area( st_transform(wkb_geometry, 3857) ) FROM public.parcelles p WHERE st_contains( p.wkb_geometry, ST_SetSRID( ST_MakePoint( 4.3683072924614, 50.842326170012 ), 4326 ) ); SELECT wkb_geometry, st_area(st_transform(wkb_geometry, 3857)) FROM public.parcelles p WHERE st_contains(p.wkb_geometry, ST_SetSRID(ST_MakePoint(4.3683072924614, 50.842326170012), 4326));;

Time▼

Count

Info

142.29 ms
(100.00%)

SELECT wkb_geometry, st_area(st_transform(wkb_geometry, 3857)) FROM public.parcelles p WHERE st_contains(p.wkb_geometry, ST_SetSRID(ST_MakePoint(4.3683072924614, 50.842326170012), 4326));

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  wkb_geometry,
  st_area(
    st_transform(wkb_geometry, 3857)
  )
FROM
  public.parcelles p
WHERE
  st_contains(
    p.wkb_geometry,
    ST_SetSRID(
      ST_MakePoint(
        4.3683072924614, 50.842326170012
      ),
      4326
    )
  );

SELECT wkb_geometry, st_area(st_transform(wkb_geometry, 3857)) FROM public.parcelles p WHERE st_contains(p.wkb_geometry, ST_SetSRID(ST_MakePoint(4.3683072924614, 50.842326170012), 4326));;

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\Polygons	No errors.

Symfony Profiler

https://immo-data.my-preprod.space/api/cadastre/parcelles/list/gps?dist=5&lat=50.842326170012306&long=4.368307292461396

Configuration Settings

Theme