Symfony Profiler

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 2
  or id = 8

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=2 or id=8;

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 7
  or id = 11
  or id = 14

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=7 or id=11 or id=14;

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 6
  or id = 12

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=6 or id=12;

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 9

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=9;

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 10

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=10;

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 3
  or id = 4
  or id = 5

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=3 or id=4 or id=5;

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 1

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=1;

select
  COALESCE(
    count(cout),
    0
  ) as nombre
from
  dbo.realisations_pole
where
  id = 13

select COALESCE(count(cout), 0)  as nombre from dbo.realisations_pole where id=13;

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

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;

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.commune AS commune_3,
  t0.shape AS shape_4,
  t0.localisation AS localisation_5,
  t0.com_id AS com_id_6,
  t0.communeb_id AS communeb_id_7
FROM
  shape_commune t0

SELECT t0.id AS id_1, t0.region AS region_2, t0.commune AS commune_3, t0.shape AS shape_4, t0.localisation AS localisation_5, t0.com_id AS com_id_6, t0.communeb_id AS communeb_id_7 FROM shape_commune t0;

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.departement AS departement_3,
  t0.commune AS commune_4,
  t0.village AS village_5,
  t0.reference AS reference_6,
  t0.secteur AS secteur_7,
  t0.libelle AS libelle_8,
  t0.photo AS photo_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.lat AS lat_12,
  t0.long AS long_13,
  t0.fonctionnalite AS fonctionnalite_14,
  t0.generique_id AS generique_id_15,
  t0.categorie_id AS categorie_id_16,
  t0.ct_id AS ct_id_17
FROM
  georeferencement t0

SELECT t0.id AS id_1, t0.region AS region_2, t0.departement AS departement_3, t0.commune AS commune_4, t0.village AS village_5, t0.reference AS reference_6, t0.secteur AS secteur_7, t0.libelle AS libelle_8, t0.photo AS photo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.lat AS lat_12, t0.long AS long_13, t0.fonctionnalite AS fonctionnalite_14, t0.generique_id AS generique_id_15, t0.categorie_id AS categorie_id_16, t0.ct_id AS ct_id_17 FROM georeferencement t0;

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;

SELECT
  t0.id AS id_1,
  t0.commune AS commune_2,
  t0.type AS type_3,
  t0.region_id AS region_id_4,
  t0.departement_id AS departement_id_5
FROM
  commune t0
ORDER BY
  t0.commune ASC

SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 ORDER BY t0.commune ASC;

SELECT
  t0.id AS id_1,
  t0.pole AS pole_2
FROM
  pole t0
WHERE
  t0.id = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.pole AS pole_2 FROM pole t0 WHERE t0.id = 7 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT
  t0.id AS id_1,
  t0.pole AS pole_2
FROM
  pole t0
WHERE
  t0.id = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.pole AS pole_2 FROM pole t0 WHERE t0.id = 8 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT
  t0.id AS id_1,
  t0.pole AS pole_2
FROM
  pole t0
WHERE
  t0.id = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.pole AS pole_2 FROM pole t0 WHERE t0.id = 5 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT
  t0.id AS id_1,
  t0.pole AS pole_2
FROM
  pole t0
WHERE
  t0.id = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.pole AS pole_2 FROM pole t0 WHERE t0.id = 6 ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT
  t0.id AS id_1,
  t0.village AS village_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.population AS population_5
FROM
  village t0

SELECT t0.id AS id_1, t0.village AS village_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.population AS population_5 FROM village t0;

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
WHERE
  t0.pole_id = ?

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 WHERE t0.pole_id = 7;

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
WHERE
  t0.pole_id = ?

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 WHERE t0.pole_id = 5;

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
WHERE
  t0.pole_id = ?

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 WHERE t0.pole_id = 6;

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
WHERE
  t0.pole_id = ?

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 WHERE t0.pole_id = 8;