Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

204.28 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	204.28 ms	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.3770965, 50.8208042), 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.3770965, 50.8208042), 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.3770965, 50.8208042), 4326));;

#▲

Time

Info

204.28 ms

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.3770965, 50.8208042), 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.3770965, 50.8208042),
      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.3770965, 50.8208042), 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.8208042&long=4.3770965

Configuration Settings

Theme