Symfony Profiler

Query Metrics

224 Database Queries

199 Different statements

178.69 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.10 ms
(3.97%)

SELECT t0.id AS id_1, t0.communeb AS communeb_2, t0.cout AS cout_3, t0.secteurb AS secteurb_4, t0.libelle AS libelle_5, t0.demarrage AS demarrage_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.geolocalisation AS geolocalisation_9, t0.georeferencement AS georeferencement_10, t0.cl_id AS cl_id_11, t0.generique_id AS generique_id_12, t0.convention_id AS convention_id_13, t0.secteur_id AS secteur_id_14 FROM realisations t0 WHERE t0.secteur_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.communeb AS communeb_2,
  t0.cout AS cout_3,
  t0.secteurb AS secteurb_4,
  t0.libelle AS libelle_5,
  t0.demarrage AS demarrage_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.geolocalisation AS geolocalisation_9,
  t0.georeferencement AS georeferencement_10,
  t0.cl_id AS cl_id_11,
  t0.generique_id AS generique_id_12,
  t0.convention_id AS convention_id_13,
  t0.secteur_id AS secteur_id_14
FROM
  realisations t0
WHERE
  t0.secteur_id = ?

SELECT t0.id AS id_1, t0.communeb AS communeb_2, t0.cout AS cout_3, t0.secteurb AS secteurb_4, t0.libelle AS libelle_5, t0.demarrage AS demarrage_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.geolocalisation AS geolocalisation_9, t0.georeferencement AS georeferencement_10, t0.cl_id AS cl_id_11, t0.generique_id AS generique_id_12, t0.convention_id AS convention_id_13, t0.secteur_id AS secteur_id_14 FROM realisations t0 WHERE t0.secteur_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 832)
10	__TwigTemplate_fa5bba86df56feb4812f2bba57bd28c1->block_body (line 432)
11	Twig\Template->yieldBlock (line 399)
12	__TwigTemplate_d8bc7ef512065ac7444ae71414abf76c->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_fa5bba86df56feb4812f2bba57bd28c1->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 227)
23	App\Controller\DefaultController->indexAction (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

2.16 ms
(1.21%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

2.12 ms
(1.18%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.87 ms
(1.05%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.86 ms
(1.04%)

select COALESCE(COUNT(commune),0) AS total,pole from dbo.realisations_pole group by pole order by pole ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    COUNT(commune),
    0
  ) AS total,
  pole
from
  dbo.realisations_pole
group by
  pole
order by
  pole ASC

select COALESCE(COUNT(commune),0) AS total,pole from dbo.realisations_pole group by pole order by pole ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 174)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.84 ms
(1.03%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.59 ms
(0.89%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.52 ms
(0.85%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.48 ms
(0.83%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.47 ms
(0.82%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.44 ms
(0.81%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.41 ms
(0.79%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.38 ms
(0.77%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.36 ms
(0.76%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.36 ms
(0.76%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.35 ms
(0.76%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.35 ms
(0.75%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.34 ms
(0.75%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.34 ms
(0.75%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.33 ms
(0.75%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.33 ms
(0.75%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.33 ms
(0.74%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.32 ms
(0.74%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.32 ms
(0.74%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.31 ms
(0.73%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.31 ms
(0.73%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.31 ms
(0.73%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.30 ms
(0.73%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.29 ms
(0.72%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.29 ms
(0.72%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.28 ms
(0.72%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.28 ms
(0.72%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Sud'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Sud'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Sud';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.28 ms
(0.72%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.28 ms
(0.72%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.27 ms
(0.71%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.26 ms
(0.71%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.26 ms
(0.70%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.26 ms
(0.70%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.25 ms
(0.70%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.25 ms
(0.70%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.25 ms
(0.70%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.24 ms
(0.69%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Diourbel-Louga'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Diourbel-Louga'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Diourbel-Louga';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.23 ms
(0.69%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.22 ms
(0.68%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.22 ms
(0.68%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.21 ms
(0.68%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.21 ms
(0.68%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.21 ms
(0.67%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Sud-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Sud-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Sud-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.20 ms
(0.67%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2024'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.20 ms
(0.67%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.19 ms
(0.67%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.19 ms
(0.67%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.19 ms
(0.66%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DAKAR'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.18 ms
(0.66%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.17 ms
(0.66%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Centre'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Centre'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Centre';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.16 ms
(0.65%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.16 ms
(0.65%)

select secteur,COALESCE(SUM(CAST(cout AS BIGINT)),0) AS total,couleur from dbo.realisations_secteur  group by secteur,couleur

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  secteur,
  COALESCE(
    SUM(
      CAST(cout AS BIGINT)
    ),
    0
  ) AS total,
  couleur
from
  dbo.realisations_secteur
group by
  secteur,
  couleur

select secteur,COALESCE(SUM(CAST(cout AS BIGINT)),0) AS total,couleur from dbo.realisations_secteur  group by secteur,couleur ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 221)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.15 ms
(0.64%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.13 ms
(0.63%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.13 ms
(0.63%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.12 ms
(0.63%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.12 ms
(0.63%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.10 ms
(0.61%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.08 ms
(0.60%)

SELECT t0.id AS id_1, t0.pole AS pole_2 FROM pole t0 ORDER BY t0.pole ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pole AS pole_2
FROM
  pole t0
ORDER BY
  t0.pole ASC

SELECT t0.id AS id_1, t0.pole AS pole_2 FROM pole t0 ORDER BY t0.pole ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 56)
5	App\Controller\DefaultController->indexAction (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.07 ms
(0.60%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.07 ms
(0.60%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.06 ms
(0.60%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.06 ms
(0.59%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.06 ms
(0.59%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.06 ms
(0.59%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.05 ms
(0.59%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Thiès'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Thiès'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Thiès';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.04 ms
(0.58%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.04 ms
(0.58%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.03 ms
(0.57%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.03 ms
(0.57%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.02 ms
(0.57%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.02 ms
(0.57%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'HYDRAULIQUE'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='HYDRAULIQUE' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.02 ms
(0.57%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Dakar'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'SANTE'
  and pole = 'Pole Territoire Dakar'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='SANTE' and pole='Pole Territoire Dakar';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.02 ms
(0.57%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'FATICK'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.02 ms
(0.57%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'FATICK'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.01 ms
(0.57%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENERGIE'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENERGIE' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.01 ms
(0.56%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'AGRICULTURE , ELEVAGE ET PECHE'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='AGRICULTURE , ELEVAGE ET PECHE' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.01 ms
(0.56%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ENVIRONNEMENT ET ASSANISSEMENT'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ENVIRONNEMENT ET ASSANISSEMENT' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.00 ms
(0.56%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'JEUNESSE, SPORT, CULTURE ET LOISIRS'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='JEUNESSE, SPORT, CULTURE ET LOISIRS' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.99 ms
(0.55%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2023'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.99 ms
(0.55%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Nord'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'ROUTE'
  and pole = 'Pole Territoire Nord'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='ROUTE' and pole='Pole Territoire Nord';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.99 ms
(0.55%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'COMMERCE ET ARTISANAT'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='COMMERCE ET ARTISANAT' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.98 ms
(0.55%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'EDUCATION ET FORMATION'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='EDUCATION ET FORMATION' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.98 ms
(0.55%)

select SUM(CAST(montant AS BIGINT)) AS total,year(signature) as annee from dbo.seydifdl group by year(signature) order by annee desc

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(montant AS BIGINT)
  ) AS total,
  year(signature) as annee
from
  dbo.seydifdl
group by
  year(signature)
order by
  annee desc

select SUM(CAST(montant AS BIGINT)) AS total,year(signature) as annee from dbo.seydifdl group by year(signature) order by annee desc;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 125)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.97 ms
(0.54%)

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Nord-Est'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(cout),
    0
  ) as montant
from
  dbo.microprojet_secteur_pole
where
  secteur = 'URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF'
  and pole = 'Pole Territoire Nord-Est'

select COALESCE(sum(cout), 0) as montant from dbo.microprojet_secteur_pole where secteur='URBANISME,HABITAT ET EQUIPEMENT ADMINISTRATIF' and pole='Pole Territoire Nord-Est';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 71)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.95 ms
(0.53%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DAKAR'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.95 ms
(0.53%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2025'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.94 ms
(0.53%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2021'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2021'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2021';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.94 ms
(0.52%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'THIES'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.88 ms
(0.49%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2022'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2022'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2022';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.88 ms
(0.49%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2020'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2020'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2020';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.88 ms
(0.49%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KEDOUGOU'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.87 ms
(0.49%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'LOUGA'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.87 ms
(0.49%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'TAMBACOUNDA'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.87 ms
(0.48%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2018'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2018'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2018';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.87 ms
(0.48%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DIOURBEL'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.86 ms
(0.48%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KOLDA'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.84 ms
(0.47%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'MATAM'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.84 ms
(0.47%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2019'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2019'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2019';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 142)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.83 ms
(0.47%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAFFRINE'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.83 ms
(0.47%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SAINT-LOUIS'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.82 ms
(0.46%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'ZIGUINCHOR'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.82 ms
(0.46%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAOLACK'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.82 ms
(0.46%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2023'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SEDHIOU'
  and YEAR(date_signature)= '2023'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2023';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.80 ms
(0.45%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAFFRINE'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.75 ms
(0.42%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'ZIGUINCHOR'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.75 ms
(0.42%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'FATICK'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.75 ms
(0.42%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DAKAR'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.75 ms
(0.42%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'THIES'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.75 ms
(0.42%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'THIES'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.74 ms
(0.42%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'TAMBACOUNDA'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.74 ms
(0.41%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DIOURBEL'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.74 ms
(0.41%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KOLDA'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.74 ms
(0.41%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'ZIGUINCHOR'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.73 ms
(0.41%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'LOUGA'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.73 ms
(0.41%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'LOUGA'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.73 ms
(0.41%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAOLACK'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.73 ms
(0.41%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SAINT-LOUIS'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'THIES'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='THIES' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SAINT-LOUIS'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'MATAM'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KOLDA'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SAINT-LOUIS'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SAINT-LOUIS' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'TAMBACOUNDA'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SEDHIOU'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DIOURBEL'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.72 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'FATICK'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='FATICK' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.71 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DAKAR'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DAKAR' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.71 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KOLDA'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KOLDA' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.71 ms
(0.40%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'DIOURBEL'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='DIOURBEL' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.71 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAFFRINE'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.70 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAOLACK'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.70 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAFFRINE'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAFFRINE' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.70 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'TAMBACOUNDA'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='TAMBACOUNDA' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.70 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KEDOUGOU'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.70 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'LOUGA'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='LOUGA' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KAOLACK'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KAOLACK' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'MATAM'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'ZIGUINCHOR'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='ZIGUINCHOR' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KEDOUGOU'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2024'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SEDHIOU'
  and YEAR(date_signature)= '2024'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2024';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'MATAM'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='MATAM' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.39%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2026'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'SEDHIOU'
  and YEAR(date_signature)= '2026'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='SEDHIOU' and YEAR(date_signature)='2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.69 ms
(0.38%)

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2025'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    sum(montant),
    0
  ) as montant
from
  dbo.convention_pole
where
  region = 'KEDOUGOU'
  and YEAR(date_signature)= '2025'

select COALESCE(sum(montant), 0) as montant from dbo.convention_pole where region='KEDOUGOU' and YEAR(date_signature)='2025';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 88)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.63 ms
(0.35%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='TAMBACOUNDA'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'TAMBACOUNDA'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='TAMBACOUNDA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.59 ms
(0.33%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='LOUGA'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'LOUGA'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='LOUGA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.54 ms
(0.30%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='THIES'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'THIES'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='THIES';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.53 ms
(0.29%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='DIOURBEL'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'DIOURBEL'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='DIOURBEL';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.52 ms
(0.29%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KOLDA'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'KOLDA'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KOLDA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.50 ms
(0.28%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='SAINT-LOUIS'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'SAINT-LOUIS'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='SAINT-LOUIS';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.48 ms
(0.27%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KAOLACK'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'KAOLACK'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KAOLACK';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.48 ms
(0.27%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2007'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2007'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2007';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.48 ms
(0.27%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='DAKAR'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'DAKAR'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='DAKAR';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.48 ms
(0.27%)

select SUM(CAST(montant AS BIGINT)) AS total from dbo.seydifdl

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(montant AS BIGINT)
  ) AS total
from
  dbo.seydifdl

select SUM(CAST(montant AS BIGINT)) AS total from dbo.seydifdl;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 131)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.46 ms
(0.26%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2011'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2011'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2011';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.45 ms
(0.25%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2010'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2010'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2010';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.45 ms
(0.25%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='FATICK'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'FATICK'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='FATICK';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.43 ms
(0.24%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='ZIGUINCHOR'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'ZIGUINCHOR'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='ZIGUINCHOR';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.43 ms
(0.24%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2015'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2015'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2015';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.43 ms
(0.24%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2013'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2013'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2013';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.42 ms
(0.24%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2012'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2012'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2012';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.42 ms
(0.24%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2008'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2008'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2008';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.42 ms
(0.24%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KAFFRINE'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'KAFFRINE'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KAFFRINE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.42 ms
(0.23%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='SEDHIOU'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'SEDHIOU'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='SEDHIOU';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.41 ms
(0.23%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2009'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2009'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2009';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.41 ms
(0.23%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2017'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2017'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2017';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.41 ms
(0.23%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2016'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2016'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2016';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.41 ms
(0.23%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2014'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.seydifdl
where
  YEAR(signature)= '2014'

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.seydifdl where YEAR(signature)='2014';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 192)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.39 ms
(0.22%)

SELECT t0.id AS id_1, t0.communeb AS communeb_2, t0.cout AS cout_3, t0.secteurb AS secteurb_4, t0.libelle AS libelle_5, t0.demarrage AS demarrage_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.geolocalisation AS geolocalisation_9, t0.georeferencement AS georeferencement_10, t0.cl_id AS cl_id_11, t0.generique_id AS generique_id_12, t0.convention_id AS convention_id_13, t0.secteur_id AS secteur_id_14 FROM realisations t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.communeb AS communeb_2,
  t0.cout AS cout_3,
  t0.secteurb AS secteurb_4,
  t0.libelle AS libelle_5,
  t0.demarrage AS demarrage_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.geolocalisation AS geolocalisation_9,
  t0.georeferencement AS georeferencement_10,
  t0.cl_id AS cl_id_11,
  t0.generique_id AS generique_id_12,
  t0.convention_id AS convention_id_13,
  t0.secteur_id AS secteur_id_14
FROM
  realisations t0

SELECT t0.id AS id_1, t0.communeb AS communeb_2, t0.cout AS cout_3, t0.secteurb AS secteurb_4, t0.libelle AS libelle_5, t0.demarrage AS demarrage_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.geolocalisation AS geolocalisation_9, t0.georeferencement AS georeferencement_10, t0.cl_id AS cl_id_11, t0.generique_id AS generique_id_12, t0.convention_id AS convention_id_13, t0.secteur_id AS secteur_id_14 FROM realisations t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 241)
6	App\Controller\DefaultController->indexAction (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.35 ms
(0.20%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KEDOUGOU'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'KEDOUGOU'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='KEDOUGOU';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.34 ms
(0.19%)

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='MATAM'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  SUM(
    CAST(Montant AS BIGINT)
  ) AS TotalMontant,
  count(region) as nombre
from
  dbo.convention_region
where
  region = 'MATAM'

select SUM(CAST(Montant AS BIGINT)) AS TotalMontant,count(region)as nombre from dbo.convention_region where region='MATAM';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 102)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.33 ms
(0.19%)

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 ORDER BY t0.secteur ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.secteur AS secteur_2,
  t0.couleur AS couleur_3,
  t0.icone AS icone_4,
  t0.image AS image_5
FROM
  sectoriel t0
ORDER BY
  t0.secteur ASC

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 ORDER BY t0.secteur ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 57)
5	App\Controller\DefaultController->indexAction (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.31 ms
(0.17%)

SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 ORDER BY t0.region ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.pole_id AS pole_id_5
FROM
  region t0
ORDER BY
  t0.region ASC

SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 ORDER BY t0.region ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 58)
5	App\Controller\DefaultController->indexAction (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.23 ms
(0.13%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2023

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2023

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2023;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.23 ms
(0.13%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2022

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2022

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2022;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.22 ms
(0.12%)

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.signature AS signature_3, t0.fichier AS fichier_4, t0.montant AS montant_5, t0.notification AS notification_6, t0.datenotification AS datenotification_7, t0.code AS code_8, t0.reference AS reference_9, t0.ct_id AS ct_id_10, t0.projet_id AS projet_id_11 FROM conventions t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.signature AS signature_3,
  t0.fichier AS fichier_4,
  t0.montant AS montant_5,
  t0.notification AS notification_6,
  t0.datenotification AS datenotification_7,
  t0.code AS code_8,
  t0.reference AS reference_9,
  t0.ct_id AS ct_id_10,
  t0.projet_id AS projet_id_11
FROM
  conventions t0

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.signature AS signature_3, t0.fichier AS fichier_4, t0.montant AS montant_5, t0.notification AS notification_6, t0.datenotification AS datenotification_7, t0.code AS code_8, t0.reference AS reference_9, t0.ct_id AS ct_id_10, t0.projet_id AS projet_id_11 FROM conventions t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 240)
6	App\Controller\DefaultController->indexAction (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.22 ms
(0.12%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2021

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2021

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2021;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.21 ms
(0.12%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2024

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2024

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2024;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.20 ms
(0.11%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2020

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2020

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2020;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.20 ms
(0.11%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2025

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2025

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2025;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.19 ms
(0.11%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2019

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2019

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2019;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.19 ms
(0.11%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2018

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2018

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2018;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 163)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.12 ms
(0.07%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2007

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2007

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2007;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.11 ms
(0.06%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2008

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2008

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2008;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.11 ms
(0.06%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2013

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2013

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2013;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.11 ms
(0.06%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2017

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2017

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2017;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.11 ms
(0.06%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2012

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2012

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2012;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.11 ms
(0.06%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 154)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.10 ms
(0.06%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2014

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2014

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2014;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.10 ms
(0.06%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2016

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2016

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2016;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.10 ms
(0.05%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2011

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2011

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2011;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.09 ms
(0.05%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2009

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2009

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2009;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.09 ms
(0.05%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2010

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2010

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2010;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

0.09 ms
(0.05%)

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2015

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  COALESCE(
    SUM(
      CAST(montant AS BIGINT)
    ),
    0
  ) AS total
from
  dbo.engagements
where
  annee = 2015

select COALESCE(SUM(CAST(montant AS BIGINT)),0) AS total from dbo.engagements where annee=2015;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 184)
2	App\Controller\DefaultController->indexAction (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

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\Pole	No errors.
App\Entity\Region	No errors.
App\Entity\Sectoriel	No errors.
App\Entity\Libellemicroprojet	No errors.
App\Entity\Georeferencement	No errors.
App\Entity\Realisations	No errors.
App\Entity\Commune	No errors.
App\Entity\Departement	No errors.
App\Entity\Conventions	No errors.
App\Entity\Projet	No errors.
App\Entity\Seydifdl	No errors.

Symfony Profiler

GET http://162.19.233.34:9000/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping