Symfony Profiler

Query Metrics

31 Database Queries

29 Different statements

156.96 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

84.46 ms
(53.81%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.recherche AS recherche_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5 FROM localisations t0 ORDER BY t0.libelle ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.recherche AS recherche_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5
FROM
  localisations t0
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.recherche AS recherche_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5 FROM localisations t0 ORDER BY t0.libelle 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 126)
5	App\Twig\AppExtension->getGlobals (line 340)
6	Twig\ExtensionSet->getGlobals (line 892)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
16	App\Controller\Front\OffresController->detailOffre (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

58.01 ms
(36.96%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.actif AS actif_5, t0.date_maj AS date_maj_6, t0.nb AS nb_7 FROM secteur_config t0 WHERE t0.actif = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.actif AS actif_5,
  t0.date_maj AS date_maj_6,
  t0.nb AS nb_7
FROM
  secteur_config t0
WHERE
  t0.actif = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.actif AS actif_5, t0.date_maj AS date_maj_6, t0.nb AS nb_7 FROM secteur_config t0 WHERE t0.actif = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 154)
5	App\Twig\AppExtension->getGlobals (line 340)
6	Twig\ExtensionSet->getGlobals (line 892)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
16	App\Controller\Front\OffresController->detailOffre (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

2.44 ms
(1.56%)

SELECT o0_.id AS id_0, o0_.ref_interne AS ref_interne_1, o0_.adresse AS adresse_2, o0_.cp AS cp_3, o0_.ville AS ville_4, o0_.photo1 AS photo1_5, o0_.descriptif AS descriptif_6, o0_.accroche AS accroche_7, o0_.condifi AS condifi_8, o0_.prestimm AS prestimm_9, o0_.equipement AS equipement_10, o0_.dispo AS dispo_11, o0_.desserte AS desserte_12, o0_.nom_consultant AS nom_consultant_13, o0_.tel_consultant AS tel_consultant_14, o0_.tel_port_consultant AS tel_port_consultant_15, o0_.mail_consultant AS mail_consultant_16, o0_.divisible AS divisible_17, o0_.date_modif AS date_modif_18, o0_.url_virtuelle AS url_virtuelle_19, o0_.dpe_chiffre AS dpe_chiffre_20, o0_.dpe_lettre AS dpe_lettre_21, o0_.ges_chiffre AS ges_chiffre_22, o0_.ges_lettre AS ges_lettre_23, o0_.surface_div AS surface_div_24, o0_.surface_totale AS surface_totale_25, o0_.latitude AS latitude_26, o0_.longitude AS longitude_27, o0_.prix_vente_global AS prix_vente_global_28, o0_.loyer_global AS loyer_global_29, o0_.honos_pourcent AS honos_pourcent_30, o0_.honos_montant AS honos_montant_31, o0_.photo2 AS photo2_32, o0_.photo3 AS photo3_33, o0_.photo4 AS photo4_34, o0_.photo5 AS photo5_35, o0_.photo6 AS photo6_36, o0_.photo7 AS photo7_37, o0_.photo8 AS photo8_38, o0_.photo9 AS photo9_39, o0_.photo10 AS photo10_40, o0_.photo11 AS photo11_41, o0_.photo12 AS photo12_42, o0_.photo13 AS photo13_43, o0_.photo14 AS photo14_44, o0_.photo15 AS photo15_45, o0_.plan1 AS plan1_46, o0_.plan2 AS plan2_47, o0_.plan3 AS plan3_48, o0_.plan4 AS plan4_49, o0_.plan5 AS plan5_50, o0_.plan6 AS plan6_51, o0_.plan7 AS plan7_52, o0_.plan8 AS plan8_53, o0_.plan9 AS plan9_54, o0_.plan10 AS plan10_55, o0_.plan11 AS plan11_56, o0_.plan12 AS plan12_57, o0_.plan13 AS plan13_58, o0_.plan14 AS plan14_59, o0_.plan15 AS plan15_60, o0_.slug_ville_cp AS slug_ville_cp_61, o0_.slug_ville AS slug_ville_62, o0_.slug_type AS slug_type_63, o0_.slug_nature AS slug_nature_64, o0_.slug_nature_second AS slug_nature_second_65, o0_.slug_detail_url AS slug_detail_url_66, o0_.directe AS directe_67, o0_.archive AS archive_68, o0_.loyer_mcarre AS loyer_mcarre_69, o0_.prix_mcarre AS prix_mcarre_70, o0_.detail_surfaces AS detail_surfaces_71, o0_.departement AS departement_72, o0_.departement_slug AS departement_slug_73, o0_.departement_libelle AS departement_libelle_74, o0_.import AS import_75, o0_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o0_ WHERE o0_.nature_id = ? AND o0_.type_id = ? AND ((o0_.surface_totale >= ? AND o0_.surface_totale <= ?) OR (o0_.surface_div >= ? AND o0_.surface_div <= ?) AND o0_.directe = 1) AND ((o0_.loyer_global >= ? AND o0_.loyer_global <= ?)) AND o0_.cp LIKE ? AND o0_.directe = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.ref_interne AS ref_interne_1,
  o0_.adresse AS adresse_2,
  o0_.cp AS cp_3,
  o0_.ville AS ville_4,
  o0_.photo1 AS photo1_5,
  o0_.descriptif AS descriptif_6,
  o0_.accroche AS accroche_7,
  o0_.condifi AS condifi_8,
  o0_.prestimm AS prestimm_9,
  o0_.equipement AS equipement_10,
  o0_.dispo AS dispo_11,
  o0_.desserte AS desserte_12,
  o0_.nom_consultant AS nom_consultant_13,
  o0_.tel_consultant AS tel_consultant_14,
  o0_.tel_port_consultant AS tel_port_consultant_15,
  o0_.mail_consultant AS mail_consultant_16,
  o0_.divisible AS divisible_17,
  o0_.date_modif AS date_modif_18,
  o0_.url_virtuelle AS url_virtuelle_19,
  o0_.dpe_chiffre AS dpe_chiffre_20,
  o0_.dpe_lettre AS dpe_lettre_21,
  o0_.ges_chiffre AS ges_chiffre_22,
  o0_.ges_lettre AS ges_lettre_23,
  o0_.surface_div AS surface_div_24,
  o0_.surface_totale AS surface_totale_25,
  o0_.latitude AS latitude_26,
  o0_.longitude AS longitude_27,
  o0_.prix_vente_global AS prix_vente_global_28,
  o0_.loyer_global AS loyer_global_29,
  o0_.honos_pourcent AS honos_pourcent_30,
  o0_.honos_montant AS honos_montant_31,
  o0_.photo2 AS photo2_32,
  o0_.photo3 AS photo3_33,
  o0_.photo4 AS photo4_34,
  o0_.photo5 AS photo5_35,
  o0_.photo6 AS photo6_36,
  o0_.photo7 AS photo7_37,
  o0_.photo8 AS photo8_38,
  o0_.photo9 AS photo9_39,
  o0_.photo10 AS photo10_40,
  o0_.photo11 AS photo11_41,
  o0_.photo12 AS photo12_42,
  o0_.photo13 AS photo13_43,
  o0_.photo14 AS photo14_44,
  o0_.photo15 AS photo15_45,
  o0_.plan1 AS plan1_46,
  o0_.plan2 AS plan2_47,
  o0_.plan3 AS plan3_48,
  o0_.plan4 AS plan4_49,
  o0_.plan5 AS plan5_50,
  o0_.plan6 AS plan6_51,
  o0_.plan7 AS plan7_52,
  o0_.plan8 AS plan8_53,
  o0_.plan9 AS plan9_54,
  o0_.plan10 AS plan10_55,
  o0_.plan11 AS plan11_56,
  o0_.plan12 AS plan12_57,
  o0_.plan13 AS plan13_58,
  o0_.plan14 AS plan14_59,
  o0_.plan15 AS plan15_60,
  o0_.slug_ville_cp AS slug_ville_cp_61,
  o0_.slug_ville AS slug_ville_62,
  o0_.slug_type AS slug_type_63,
  o0_.slug_nature AS slug_nature_64,
  o0_.slug_nature_second AS slug_nature_second_65,
  o0_.slug_detail_url AS slug_detail_url_66,
  o0_.directe AS directe_67,
  o0_.archive AS archive_68,
  o0_.loyer_mcarre AS loyer_mcarre_69,
  o0_.prix_mcarre AS prix_mcarre_70,
  o0_.detail_surfaces AS detail_surfaces_71,
  o0_.departement AS departement_72,
  o0_.departement_slug AS departement_slug_73,
  o0_.departement_libelle AS departement_libelle_74,
  o0_.import AS import_75,
  o0_.price_min AS price_min_76,
  o0_.price_max AS price_max_77,
  o0_.price_max_uom AS price_max_uom_78,
  o0_.price_average AS price_average_79,
  o0_.price_uom_text AS price_uom_text_80,
  o0_.price_gross_rent_price AS price_gross_rent_price_81,
  o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82,
  o0_.nature_id AS nature_id_83,
  o0_.type_id AS type_id_84,
  o0_.agence_id AS agence_id_85,
  o0_.page_index_id AS page_index_id_86
FROM
  offres o0_
WHERE
  o0_.nature_id = ?
  AND o0_.type_id = ?
  AND (
    (
      o0_.surface_totale >= ?
      AND o0_.surface_totale <= ?
    )
    OR (
      o0_.surface_div >= ?
      AND o0_.surface_div <= ?
    )
    AND o0_.directe = 1
  )
  AND (
    (
      o0_.loyer_global >= ?
      AND o0_.loyer_global <= ?
    )
  )
  AND o0_.cp LIKE ?
  AND o0_.directe = ?

SELECT o0_.id AS id_0, o0_.ref_interne AS ref_interne_1, o0_.adresse AS adresse_2, o0_.cp AS cp_3, o0_.ville AS ville_4, o0_.photo1 AS photo1_5, o0_.descriptif AS descriptif_6, o0_.accroche AS accroche_7, o0_.condifi AS condifi_8, o0_.prestimm AS prestimm_9, o0_.equipement AS equipement_10, o0_.dispo AS dispo_11, o0_.desserte AS desserte_12, o0_.nom_consultant AS nom_consultant_13, o0_.tel_consultant AS tel_consultant_14, o0_.tel_port_consultant AS tel_port_consultant_15, o0_.mail_consultant AS mail_consultant_16, o0_.divisible AS divisible_17, o0_.date_modif AS date_modif_18, o0_.url_virtuelle AS url_virtuelle_19, o0_.dpe_chiffre AS dpe_chiffre_20, o0_.dpe_lettre AS dpe_lettre_21, o0_.ges_chiffre AS ges_chiffre_22, o0_.ges_lettre AS ges_lettre_23, o0_.surface_div AS surface_div_24, o0_.surface_totale AS surface_totale_25, o0_.latitude AS latitude_26, o0_.longitude AS longitude_27, o0_.prix_vente_global AS prix_vente_global_28, o0_.loyer_global AS loyer_global_29, o0_.honos_pourcent AS honos_pourcent_30, o0_.honos_montant AS honos_montant_31, o0_.photo2 AS photo2_32, o0_.photo3 AS photo3_33, o0_.photo4 AS photo4_34, o0_.photo5 AS photo5_35, o0_.photo6 AS photo6_36, o0_.photo7 AS photo7_37, o0_.photo8 AS photo8_38, o0_.photo9 AS photo9_39, o0_.photo10 AS photo10_40, o0_.photo11 AS photo11_41, o0_.photo12 AS photo12_42, o0_.photo13 AS photo13_43, o0_.photo14 AS photo14_44, o0_.photo15 AS photo15_45, o0_.plan1 AS plan1_46, o0_.plan2 AS plan2_47, o0_.plan3 AS plan3_48, o0_.plan4 AS plan4_49, o0_.plan5 AS plan5_50, o0_.plan6 AS plan6_51, o0_.plan7 AS plan7_52, o0_.plan8 AS plan8_53, o0_.plan9 AS plan9_54, o0_.plan10 AS plan10_55, o0_.plan11 AS plan11_56, o0_.plan12 AS plan12_57, o0_.plan13 AS plan13_58, o0_.plan14 AS plan14_59, o0_.plan15 AS plan15_60, o0_.slug_ville_cp AS slug_ville_cp_61, o0_.slug_ville AS slug_ville_62, o0_.slug_type AS slug_type_63, o0_.slug_nature AS slug_nature_64, o0_.slug_nature_second AS slug_nature_second_65, o0_.slug_detail_url AS slug_detail_url_66, o0_.directe AS directe_67, o0_.archive AS archive_68, o0_.loyer_mcarre AS loyer_mcarre_69, o0_.prix_mcarre AS prix_mcarre_70, o0_.detail_surfaces AS detail_surfaces_71, o0_.departement AS departement_72, o0_.departement_slug AS departement_slug_73, o0_.departement_libelle AS departement_libelle_74, o0_.import AS import_75, o0_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o0_ WHERE o0_.nature_id = 1 AND o0_.type_id = 1 AND ((o0_.surface_totale >= 2492 AND o0_.surface_totale <= 4049.5) OR (o0_.surface_div >= 2492 AND o0_.surface_div <= 4049.5) AND o0_.directe = 1) AND ((o0_.loyer_global >= 0 AND o0_.loyer_global <= 100000000)) AND o0_.cp LIKE '91%' AND o0_.directe = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 225)
7	App\Controller\Front\OffresController->detailOffre (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.75 ms
(1.12%)

SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.photo1 AS photo1_6, t0.descriptif AS descriptif_7, t0.accroche AS accroche_8, t0.condifi AS condifi_9, t0.prestimm AS prestimm_10, t0.equipement AS equipement_11, t0.dispo AS dispo_12, t0.desserte AS desserte_13, t0.nom_consultant AS nom_consultant_14, t0.tel_consultant AS tel_consultant_15, t0.tel_port_consultant AS tel_port_consultant_16, t0.mail_consultant AS mail_consultant_17, t0.divisible AS divisible_18, t0.date_modif AS date_modif_19, t0.url_virtuelle AS url_virtuelle_20, t0.dpe_chiffre AS dpe_chiffre_21, t0.dpe_lettre AS dpe_lettre_22, t0.ges_chiffre AS ges_chiffre_23, t0.ges_lettre AS ges_lettre_24, t0.surface_div AS surface_div_25, t0.surface_totale AS surface_totale_26, t0.latitude AS latitude_27, t0.longitude AS longitude_28, t0.prix_vente_global AS prix_vente_global_29, t0.loyer_global AS loyer_global_30, t0.honos_pourcent AS honos_pourcent_31, t0.honos_montant AS honos_montant_32, t0.photo2 AS photo2_33, t0.photo3 AS photo3_34, t0.photo4 AS photo4_35, t0.photo5 AS photo5_36, t0.photo6 AS photo6_37, t0.photo7 AS photo7_38, t0.photo8 AS photo8_39, t0.photo9 AS photo9_40, t0.photo10 AS photo10_41, t0.photo11 AS photo11_42, t0.photo12 AS photo12_43, t0.photo13 AS photo13_44, t0.photo14 AS photo14_45, t0.photo15 AS photo15_46, t0.plan1 AS plan1_47, t0.plan2 AS plan2_48, t0.plan3 AS plan3_49, t0.plan4 AS plan4_50, t0.plan5 AS plan5_51, t0.plan6 AS plan6_52, t0.plan7 AS plan7_53, t0.plan8 AS plan8_54, t0.plan9 AS plan9_55, t0.plan10 AS plan10_56, t0.plan11 AS plan11_57, t0.plan12 AS plan12_58, t0.plan13 AS plan13_59, t0.plan14 AS plan14_60, t0.plan15 AS plan15_61, t0.slug_ville_cp AS slug_ville_cp_62, t0.slug_ville AS slug_ville_63, t0.slug_type AS slug_type_64, t0.slug_nature AS slug_nature_65, t0.slug_nature_second AS slug_nature_second_66, t0.slug_detail_url AS slug_detail_url_67, t0.directe AS directe_68, t0.archive AS archive_69, t0.loyer_mcarre AS loyer_mcarre_70, t0.prix_mcarre AS prix_mcarre_71, t0.detail_surfaces AS detail_surfaces_72, t0.departement AS departement_73, t0.departement_slug AS departement_slug_74, t0.departement_libelle AS departement_libelle_75, t0.import AS import_76, t0.price_min AS price_min_77, t0.price_max AS price_max_78, t0.price_max_uom AS price_max_uom_79, t0.price_average AS price_average_80, t0.price_uom_text AS price_uom_text_81, t0.price_gross_rent_price AS price_gross_rent_price_82, t0.price_gross_rent_price_text AS price_gross_rent_price_text_83, t0.nature_id AS nature_id_84, t0.type_id AS type_id_85, t0.agence_id AS agence_id_86, t0.page_index_id AS page_index_id_87 FROM offres t0 WHERE t0.slug_detail_url = ? LIMIT 1

Parameters:

[
  "bureaux-a-louer-verrieres-le-buisson-91370-1382948-0lb"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ref_interne AS ref_interne_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.ville AS ville_5,
  t0.photo1 AS photo1_6,
  t0.descriptif AS descriptif_7,
  t0.accroche AS accroche_8,
  t0.condifi AS condifi_9,
  t0.prestimm AS prestimm_10,
  t0.equipement AS equipement_11,
  t0.dispo AS dispo_12,
  t0.desserte AS desserte_13,
  t0.nom_consultant AS nom_consultant_14,
  t0.tel_consultant AS tel_consultant_15,
  t0.tel_port_consultant AS tel_port_consultant_16,
  t0.mail_consultant AS mail_consultant_17,
  t0.divisible AS divisible_18,
  t0.date_modif AS date_modif_19,
  t0.url_virtuelle AS url_virtuelle_20,
  t0.dpe_chiffre AS dpe_chiffre_21,
  t0.dpe_lettre AS dpe_lettre_22,
  t0.ges_chiffre AS ges_chiffre_23,
  t0.ges_lettre AS ges_lettre_24,
  t0.surface_div AS surface_div_25,
  t0.surface_totale AS surface_totale_26,
  t0.latitude AS latitude_27,
  t0.longitude AS longitude_28,
  t0.prix_vente_global AS prix_vente_global_29,
  t0.loyer_global AS loyer_global_30,
  t0.honos_pourcent AS honos_pourcent_31,
  t0.honos_montant AS honos_montant_32,
  t0.photo2 AS photo2_33,
  t0.photo3 AS photo3_34,
  t0.photo4 AS photo4_35,
  t0.photo5 AS photo5_36,
  t0.photo6 AS photo6_37,
  t0.photo7 AS photo7_38,
  t0.photo8 AS photo8_39,
  t0.photo9 AS photo9_40,
  t0.photo10 AS photo10_41,
  t0.photo11 AS photo11_42,
  t0.photo12 AS photo12_43,
  t0.photo13 AS photo13_44,
  t0.photo14 AS photo14_45,
  t0.photo15 AS photo15_46,
  t0.plan1 AS plan1_47,
  t0.plan2 AS plan2_48,
  t0.plan3 AS plan3_49,
  t0.plan4 AS plan4_50,
  t0.plan5 AS plan5_51,
  t0.plan6 AS plan6_52,
  t0.plan7 AS plan7_53,
  t0.plan8 AS plan8_54,
  t0.plan9 AS plan9_55,
  t0.plan10 AS plan10_56,
  t0.plan11 AS plan11_57,
  t0.plan12 AS plan12_58,
  t0.plan13 AS plan13_59,
  t0.plan14 AS plan14_60,
  t0.plan15 AS plan15_61,
  t0.slug_ville_cp AS slug_ville_cp_62,
  t0.slug_ville AS slug_ville_63,
  t0.slug_type AS slug_type_64,
  t0.slug_nature AS slug_nature_65,
  t0.slug_nature_second AS slug_nature_second_66,
  t0.slug_detail_url AS slug_detail_url_67,
  t0.directe AS directe_68,
  t0.archive AS archive_69,
  t0.loyer_mcarre AS loyer_mcarre_70,
  t0.prix_mcarre AS prix_mcarre_71,
  t0.detail_surfaces AS detail_surfaces_72,
  t0.departement AS departement_73,
  t0.departement_slug AS departement_slug_74,
  t0.departement_libelle AS departement_libelle_75,
  t0.import AS import_76,
  t0.price_min AS price_min_77,
  t0.price_max AS price_max_78,
  t0.price_max_uom AS price_max_uom_79,
  t0.price_average AS price_average_80,
  t0.price_uom_text AS price_uom_text_81,
  t0.price_gross_rent_price AS price_gross_rent_price_82,
  t0.price_gross_rent_price_text AS price_gross_rent_price_text_83,
  t0.nature_id AS nature_id_84,
  t0.type_id AS type_id_85,
  t0.agence_id AS agence_id_86,
  t0.page_index_id AS page_index_id_87
FROM
  offres t0
WHERE
  t0.slug_detail_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.photo1 AS photo1_6, t0.descriptif AS descriptif_7, t0.accroche AS accroche_8, t0.condifi AS condifi_9, t0.prestimm AS prestimm_10, t0.equipement AS equipement_11, t0.dispo AS dispo_12, t0.desserte AS desserte_13, t0.nom_consultant AS nom_consultant_14, t0.tel_consultant AS tel_consultant_15, t0.tel_port_consultant AS tel_port_consultant_16, t0.mail_consultant AS mail_consultant_17, t0.divisible AS divisible_18, t0.date_modif AS date_modif_19, t0.url_virtuelle AS url_virtuelle_20, t0.dpe_chiffre AS dpe_chiffre_21, t0.dpe_lettre AS dpe_lettre_22, t0.ges_chiffre AS ges_chiffre_23, t0.ges_lettre AS ges_lettre_24, t0.surface_div AS surface_div_25, t0.surface_totale AS surface_totale_26, t0.latitude AS latitude_27, t0.longitude AS longitude_28, t0.prix_vente_global AS prix_vente_global_29, t0.loyer_global AS loyer_global_30, t0.honos_pourcent AS honos_pourcent_31, t0.honos_montant AS honos_montant_32, t0.photo2 AS photo2_33, t0.photo3 AS photo3_34, t0.photo4 AS photo4_35, t0.photo5 AS photo5_36, t0.photo6 AS photo6_37, t0.photo7 AS photo7_38, t0.photo8 AS photo8_39, t0.photo9 AS photo9_40, t0.photo10 AS photo10_41, t0.photo11 AS photo11_42, t0.photo12 AS photo12_43, t0.photo13 AS photo13_44, t0.photo14 AS photo14_45, t0.photo15 AS photo15_46, t0.plan1 AS plan1_47, t0.plan2 AS plan2_48, t0.plan3 AS plan3_49, t0.plan4 AS plan4_50, t0.plan5 AS plan5_51, t0.plan6 AS plan6_52, t0.plan7 AS plan7_53, t0.plan8 AS plan8_54, t0.plan9 AS plan9_55, t0.plan10 AS plan10_56, t0.plan11 AS plan11_57, t0.plan12 AS plan12_58, t0.plan13 AS plan13_59, t0.plan14 AS plan14_60, t0.plan15 AS plan15_61, t0.slug_ville_cp AS slug_ville_cp_62, t0.slug_ville AS slug_ville_63, t0.slug_type AS slug_type_64, t0.slug_nature AS slug_nature_65, t0.slug_nature_second AS slug_nature_second_66, t0.slug_detail_url AS slug_detail_url_67, t0.directe AS directe_68, t0.archive AS archive_69, t0.loyer_mcarre AS loyer_mcarre_70, t0.prix_mcarre AS prix_mcarre_71, t0.detail_surfaces AS detail_surfaces_72, t0.departement AS departement_73, t0.departement_slug AS departement_slug_74, t0.departement_libelle AS departement_libelle_75, t0.import AS import_76, t0.price_min AS price_min_77, t0.price_max AS price_max_78, t0.price_max_uom AS price_max_uom_79, t0.price_average AS price_average_80, t0.price_uom_text AS price_uom_text_81, t0.price_gross_rent_price AS price_gross_rent_price_82, t0.price_gross_rent_price_text AS price_gross_rent_price_text_83, t0.nature_id AS nature_id_84, t0.type_id AS type_id_85, t0.agence_id AS agence_id_86, t0.page_index_id AS page_index_id_87 FROM offres t0 WHERE t0.slug_detail_url = 'bureaux-a-louer-verrieres-le-buisson-91370-1382948-0lb' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 212)
7	App\Controller\Front\OffresController->detailOffre (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.05 ms
(0.67%)

SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.libelle AS libelle_1,
  t0_.description AS description_2,
  t0_.image AS image_3,
  t0_.courant AS courant_4,
  t0_.dirname AS dirname_5,
  t0_.color_prime AS color_prime_6,
  t0_.color_second AS color_second_7,
  t0_.color_third AS color_third_8,
  t0_.date_maj AS date_maj_9,
  t0_.text_color_prime AS text_color_prime_10,
  t0_.text_color_second AS text_color_second_11,
  t0_.color_seperateur AS color_seperateur_12
FROM
  template t0_
WHERE
  t0_.courant = ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\TemplateRepository->findActif (line 38)
8	App\Controller\Front\OffresController->__construct (line 24)
9	ContainerIueNYr2\getOffresControllerService::do (line 697)
10	ContainerIueNYr2\App_KernelDevDebugContainer->load (line 221)
11	Symfony\Component\DependencyInjection\Container::make (line 203)
12	Symfony\Component\DependencyInjection\Container->get (line 38)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.91 ms
(0.58%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.seo_url AS seo_url_3,
  t0.seo_titre AS seo_titre_4,
  t0.seo_desc AS seo_desc_5,
  t0.titre AS titre_6,
  t0.contenu_un AS contenu_un_7,
  t0.contenu_deux AS contenu_deux_8,
  t0.date_maj AS date_maj_9,
  t0.image AS image_10,
  t0.citation AS citation_11,
  t0.image_citation AS image_citation_12,
  t0.afficher_bloc_contact AS afficher_bloc_contact_13,
  t0.nature_offre AS nature_offre_14,
  t0.type_offre AS type_offre_15,
  t0.smin_offre AS smin_offre_16,
  t0.smax_offre AS smax_offre_17,
  t0.afficher_carrousel_offre AS afficher_carrousel_offre_18,
  t0.afficher_carrousel_crit AS afficher_carrousel_crit_19,
  t0.titre_offre AS titre_offre_20,
  t0.afficher_bouton_offre AS afficher_bouton_offre_21,
  t0.libelle_bouton_offre AS libelle_bouton_offre_22,
  t0.title_bouton_offre AS title_bouton_offre_23,
  t0.url_offre AS url_offre_24,
  t0.afficher_bloc_actus AS afficher_bloc_actus_25,
  t0.og_title AS og_title_26,
  t0.og_desc AS og_desc_27,
  t0.og_image AS og_image_28,
  t0.page_mere_id AS page_mere_id_29
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 140)
7	App\Twig\AppExtension->getGlobals (line 340)
8	Twig\ExtensionSet->getGlobals (line 892)
9	Twig\Environment->getGlobals (line 384)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
18	App\Controller\Front\OffresController->detailOffre (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.57 ms
(0.36%)

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.secteur AS secteur_6, t0.picto AS picto_7, t0.date_maj AS date_maj_8, t0.email AS email_9, t0.tel AS tel_10, t0.ordre AS ordre_11, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 ORDER BY t0.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.ville AS ville_5,
  t0.secteur AS secteur_6,
  t0.picto AS picto_7,
  t0.date_maj AS date_maj_8,
  t0.email AS email_9,
  t0.tel AS tel_10,
  t0.ordre AS ordre_11,
  t0.presentation AS presentation_12,
  t0.logiciel_type AS logiciel_type_13,
  t0.logiciel_id AS logiciel_id_14,
  t0.email_demande AS email_demande_15,
  t0.slug AS slug_16,
  t0.titre AS titre_17,
  t0.image AS image_18,
  t0.title AS title_19,
  t0.meta_desc AS meta_desc_20,
  t0.titre_og AS titre_og_21,
  t0.desc_og AS desc_og_22,
  t0.image_og AS image_og_23,
  t0.calendy AS calendy_24
FROM
  agence t0
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.secteur AS secteur_6, t0.picto AS picto_7, t0.date_maj AS date_maj_8, t0.email AS email_9, t0.tel AS tel_10, t0.ordre AS ordre_11, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 ORDER BY t0.ordre 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 120)
5	App\Twig\AppExtension->getGlobals (line 340)
6	Twig\ExtensionSet->getGlobals (line 892)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
16	App\Controller\Front\OffresController->detailOffre (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.53 ms
(0.34%)

SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.lib_etage AS lib_etage_3, t0.num AS num_4, t0.surface AS surface_5, t0.loyer AS loyer_6, t0.prix AS prix_7, t0.charge AS charge_8, t0.batiment AS batiment_9, t0.lot AS lot_10, t0.escalier AS escalier_11, t0.dispo AS dispo_12, t0.import AS import_13, t0.price_uom AS price_uom_14, t0.offre_id AS offre_id_15 FROM surfaces t0 WHERE t0.offre_id = ?

Parameters:

[
  1325
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ref_interne AS ref_interne_2,
  t0.lib_etage AS lib_etage_3,
  t0.num AS num_4,
  t0.surface AS surface_5,
  t0.loyer AS loyer_6,
  t0.prix AS prix_7,
  t0.charge AS charge_8,
  t0.batiment AS batiment_9,
  t0.lot AS lot_10,
  t0.escalier AS escalier_11,
  t0.dispo AS dispo_12,
  t0.import AS import_13,
  t0.price_uom AS price_uom_14,
  t0.offre_id AS offre_id_15
FROM
  surfaces t0
WHERE
  t0.offre_id = ?

SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.lib_etage AS lib_etage_3, t0.num AS num_4, t0.surface AS surface_5, t0.loyer AS loyer_6, t0.prix AS prix_7, t0.charge AS charge_8, t0.batiment AS batiment_9, t0.lot AS lot_10, t0.escalier AS escalier_11, t0.dispo AS dispo_12, t0.import AS import_13, t0.price_uom AS price_uom_14, t0.offre_id AS offre_id_15 FROM surfaces t0 WHERE t0.offre_id = 1325;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 604)
8	__TwigTemplate_a2f2aee1d894d242dc2d57bf952cfa76->block_main (line 432)
9	Twig\Template->yieldBlock (line 195)
10	__TwigTemplate_06da3caa33842066172bfaddfca64464->doDisplay (line 388)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_a2f2aee1d894d242dc2d57bf952cfa76->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
21	App\Controller\Front\OffresController->detailOffre (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.46 ms
(0.29%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.svg AS svg_6, t0.svg_header AS svg_header_7, t0.template_id AS template_id_8 FROM favoris_config t0 WHERE t0.actif = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.actif AS actif_3,
  t0.image AS image_4,
  t0.updated_at AS updated_at_5,
  t0.svg AS svg_6,
  t0.svg_header AS svg_header_7,
  t0.template_id AS template_id_8
FROM
  favoris_config t0
WHERE
  t0.actif = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.svg AS svg_6, t0.svg_header AS svg_header_7, t0.template_id AS template_id_8 FROM favoris_config t0 WHERE t0.actif = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 155)
5	App\Twig\AppExtension->getGlobals (line 340)
6	Twig\ExtensionSet->getGlobals (line 892)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
16	App\Controller\Front\OffresController->detailOffre (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.45 ms
(0.29%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.tel AS tel_5, t0.fax AS fax_6, t0.image AS image_7, t0.update_at AS update_at_8, t0.lien1 AS lien1_9, t0.lien2 AS lien2_10, t0.fonction AS fonction_11, t0.equipe_id AS equipe_id_12 FROM collaborateurs t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "cindy.gaurier@evolis-ie.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.tel AS tel_5,
  t0.fax AS fax_6,
  t0.image AS image_7,
  t0.update_at AS update_at_8,
  t0.lien1 AS lien1_9,
  t0.lien2 AS lien2_10,
  t0.fonction AS fonction_11,
  t0.equipe_id AS equipe_id_12
FROM
  collaborateurs t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.tel AS tel_5, t0.fax AS fax_6, t0.image AS image_7, t0.update_at AS update_at_8, t0.lien1 AS lien1_9, t0.lien2 AS lien2_10, t0.fonction AS fonction_11, t0.equipe_id AS equipe_id_12 FROM collaborateurs t0 WHERE t0.email = 'cindy.gaurier@evolis-ie.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 213)
7	App\Controller\Front\OffresController->detailOffre (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.45 ms
(0.29%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_deux_id = ? ORDER BY t0.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.target AS target_4,
  t0.libelle AS libelle_5,
  t0.ordre AS ordre_6,
  t0.type AS type_7,
  t0.footer_id AS footer_id_8,
  t0.footer_deux_id AS footer_deux_id_9,
  t0.footer_trois_id AS footer_trois_id_10,
  t0.footer_big_id AS footer_big_id_11,
  t0.footer_big_deux_id AS footer_big_deux_id_12,
  t0.footer_big_trois_id AS footer_big_trois_id_13
FROM
  footer_link t0
WHERE
  t0.footer_deux_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_deux_id = 1 ORDER BY t0.ordre ASC;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 184)
8	__TwigTemplate_358555c6ff04271eee5d7c2ba721dacd->doDisplay (line 388)
9	Twig\Template->yield (line 432)
10	__TwigTemplate_06da3caa33842066172bfaddfca64464->block_footer (line 432)
11	Twig\Template->yieldBlock (line 202)
12	__TwigTemplate_06da3caa33842066172bfaddfca64464->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_a2f2aee1d894d242dc2d57bf952cfa76->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 230)
23	App\Controller\Front\OffresController->detailOffre (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)

0.44 ms
(0.28%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_id = ? ORDER BY t0.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.target AS target_4,
  t0.libelle AS libelle_5,
  t0.ordre AS ordre_6,
  t0.type AS type_7,
  t0.footer_id AS footer_id_8,
  t0.footer_deux_id AS footer_deux_id_9,
  t0.footer_trois_id AS footer_trois_id_10,
  t0.footer_big_id AS footer_big_id_11,
  t0.footer_big_deux_id AS footer_big_deux_id_12,
  t0.footer_big_trois_id AS footer_big_trois_id_13
FROM
  footer_link t0
WHERE
  t0.footer_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_id = 1 ORDER BY t0.ordre ASC;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 155)
8	__TwigTemplate_358555c6ff04271eee5d7c2ba721dacd->doDisplay (line 388)
9	Twig\Template->yield (line 432)
10	__TwigTemplate_06da3caa33842066172bfaddfca64464->block_footer (line 432)
11	Twig\Template->yieldBlock (line 202)
12	__TwigTemplate_06da3caa33842066172bfaddfca64464->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_a2f2aee1d894d242dc2d57bf952cfa76->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 230)
23	App\Controller\Front\OffresController->detailOffre (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)

0.41 ms
(0.26%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_id = ? ORDER BY t0.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.target AS target_4,
  t0.ordre AS ordre_5,
  t0.libelle AS libelle_6,
  t0.type AS type_7,
  t0.menu_mega_deux_id AS menu_mega_deux_id_8,
  t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9,
  t0.menu_mega_id AS menu_mega_id_10,
  t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11,
  t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12
FROM
  menu_link t0
WHERE
  t0.menu_mega_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_id = 1 ORDER BY t0.ordre ASC;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 392)
8	__TwigTemplate_1450d1a91bcca55cc0a8a65fc982ce5c->doDisplay (line 388)
9	Twig\Template->yield (line 231)
10	__TwigTemplate_088dcfe976bdddad9e53dff91425b794->doDisplay (line 388)
11	Twig\Template->yield (line 380)
12	__TwigTemplate_06da3caa33842066172bfaddfca64464->block_header (line 432)
13	Twig\Template->yieldBlock (line 188)
14	__TwigTemplate_06da3caa33842066172bfaddfca64464->doDisplay (line 388)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_a2f2aee1d894d242dc2d57bf952cfa76->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
25	App\Controller\Front\OffresController->detailOffre (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.41 ms
(0.26%)

SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.url_liste AS url_liste_5, t0.url_detail AS url_detail_6, t0.h1_liste AS h1_liste_7, t0.afficher_bloc_contact AS afficher_bloc_contact_8, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.image_bg AS image_bg_12, t0.date_maj AS date_maj_13, t0.afficher_unite_loyer AS afficher_unite_loyer_14, t0.afficher_loyer AS afficher_loyer_15, t0.afficher_prix AS afficher_prix_16, t0.afficher_unite_prix AS afficher_unite_prix_17, t0.slider_surface_max AS slider_surface_max_18, t0.afficher_tri AS afficher_tri_19, t0.afficher_favoris AS afficher_favoris_20, t0.button_contact AS button_contact_21 FROM offres_config t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nb_lignes AS nb_lignes_2,
  t0.libelle AS libelle_3,
  t0.afficher_pagination AS afficher_pagination_4,
  t0.url_liste AS url_liste_5,
  t0.url_detail AS url_detail_6,
  t0.h1_liste AS h1_liste_7,
  t0.afficher_bloc_contact AS afficher_bloc_contact_8,
  t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9,
  t0.seo_title AS seo_title_10,
  t0.seo_desc AS seo_desc_11,
  t0.image_bg AS image_bg_12,
  t0.date_maj AS date_maj_13,
  t0.afficher_unite_loyer AS afficher_unite_loyer_14,
  t0.afficher_loyer AS afficher_loyer_15,
  t0.afficher_prix AS afficher_prix_16,
  t0.afficher_unite_prix AS afficher_unite_prix_17,
  t0.slider_surface_max AS slider_surface_max_18,
  t0.afficher_tri AS afficher_tri_19,
  t0.afficher_favoris AS afficher_favoris_20,
  t0.button_contact AS button_contact_21
FROM
  offres_config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.url_liste AS url_liste_5, t0.url_detail AS url_detail_6, t0.h1_liste AS h1_liste_7, t0.afficher_bloc_contact AS afficher_bloc_contact_8, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.image_bg AS image_bg_12, t0.date_maj AS date_maj_13, t0.afficher_unite_loyer AS afficher_unite_loyer_14, t0.afficher_loyer AS afficher_loyer_15, t0.afficher_prix AS afficher_prix_16, t0.afficher_unite_prix AS afficher_unite_prix_17, t0.slider_surface_max AS slider_surface_max_18, t0.afficher_tri AS afficher_tri_19, t0.afficher_favoris AS afficher_favoris_20, t0.button_contact AS button_contact_21 FROM offres_config t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 39)
7	App\Controller\Front\OffresController->__construct (line 24)
8	ContainerIueNYr2\getOffresControllerService::do (line 697)
9	ContainerIueNYr2\App_KernelDevDebugContainer->load (line 221)
10	Symfony\Component\DependencyInjection\Container::make (line 203)
11	Symfony\Component\DependencyInjection\Container->get (line 38)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.39 ms
(0.25%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_trois_id = ? ORDER BY t0.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.target AS target_4,
  t0.libelle AS libelle_5,
  t0.ordre AS ordre_6,
  t0.type AS type_7,
  t0.footer_id AS footer_id_8,
  t0.footer_deux_id AS footer_deux_id_9,
  t0.footer_trois_id AS footer_trois_id_10,
  t0.footer_big_id AS footer_big_id_11,
  t0.footer_big_deux_id AS footer_big_deux_id_12,
  t0.footer_big_trois_id AS footer_big_trois_id_13
FROM
  footer_link t0
WHERE
  t0.footer_trois_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_trois_id = 1 ORDER BY t0.ordre ASC;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 211)
8	__TwigTemplate_358555c6ff04271eee5d7c2ba721dacd->doDisplay (line 388)
9	Twig\Template->yield (line 432)
10	__TwigTemplate_06da3caa33842066172bfaddfca64464->block_footer (line 432)
11	Twig\Template->yieldBlock (line 202)
12	__TwigTemplate_06da3caa33842066172bfaddfca64464->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_a2f2aee1d894d242dc2d57bf952cfa76->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 230)
23	App\Controller\Front\OffresController->detailOffre (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)

0.37 ms
(0.24%)

SELECT t0.id AS id_1, t0.bloc_un_nom AS bloc_un_nom_2, t0.bloc_deux_nom AS bloc_deux_nom_3, t0.bloc_trois_nom AS bloc_trois_nom_4 FROM footer t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.bloc_un_nom AS bloc_un_nom_2,
  t0.bloc_deux_nom AS bloc_deux_nom_3,
  t0.bloc_trois_nom AS bloc_trois_nom_4
FROM
  footer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.bloc_un_nom AS bloc_un_nom_2, t0.bloc_deux_nom AS bloc_deux_nom_3, t0.bloc_trois_nom AS bloc_trois_nom_4 FROM footer t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 148)
7	App\Twig\AppExtension->getGlobals (line 340)
8	Twig\ExtensionSet->getGlobals (line 892)
9	Twig\Environment->getGlobals (line 384)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
18	App\Controller\Front\OffresController->detailOffre (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.36 ms
(0.23%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3 FROM partage_config t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.actif AS actif_3
FROM
  partage_config t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3 FROM partage_config 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 156)
6	App\Twig\AppExtension->getGlobals (line 340)
7	Twig\ExtensionSet->getGlobals (line 892)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
17	App\Controller\Front\OffresController->detailOffre (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.35 ms
(0.22%)

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.email AS email_6, t0.tel AS tel_7, t0.fax AS fax_8, t0.description AS description_9, t0.image AS image_10, t0.date_maj AS date_maj_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.facebook AS facebook_14, t0.contact_titre AS contact_titre_15, t0.contact_span AS contact_span_16, t0.contact_texte AS contact_texte_17, t0.favico AS favico_18, t0.cle_google_map AS cle_google_map_19, t0.puce_google_map AS puce_google_map_20, t0.contact_fond AS contact_fond_21, t0.google_analytics AS google_analytics_22, t0.insta AS insta_23 FROM infos t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.ville AS ville_5,
  t0.email AS email_6,
  t0.tel AS tel_7,
  t0.fax AS fax_8,
  t0.description AS description_9,
  t0.image AS image_10,
  t0.date_maj AS date_maj_11,
  t0.twitter AS twitter_12,
  t0.linkedin AS linkedin_13,
  t0.facebook AS facebook_14,
  t0.contact_titre AS contact_titre_15,
  t0.contact_span AS contact_span_16,
  t0.contact_texte AS contact_texte_17,
  t0.favico AS favico_18,
  t0.cle_google_map AS cle_google_map_19,
  t0.puce_google_map AS puce_google_map_20,
  t0.contact_fond AS contact_fond_21,
  t0.google_analytics AS google_analytics_22,
  t0.insta AS insta_23
FROM
  infos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.email AS email_6, t0.tel AS tel_7, t0.fax AS fax_8, t0.description AS description_9, t0.image AS image_10, t0.date_maj AS date_maj_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.facebook AS facebook_14, t0.contact_titre AS contact_titre_15, t0.contact_span AS contact_span_16, t0.contact_texte AS contact_texte_17, t0.favico AS favico_18, t0.cle_google_map AS cle_google_map_19, t0.puce_google_map AS puce_google_map_20, t0.contact_fond AS contact_fond_21, t0.google_analytics AS google_analytics_22, t0.insta AS insta_23 FROM infos t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	App\Twig\AppExtension->getGlobals (line 340)
8	Twig\ExtensionSet->getGlobals (line 892)
9	Twig\Environment->getGlobals (line 384)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
18	App\Controller\Front\OffresController->detailOffre (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.35 ms
(0.22%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_menu_deux_id = ? ORDER BY t0.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.target AS target_4,
  t0.ordre AS ordre_5,
  t0.libelle AS libelle_6,
  t0.type AS type_7,
  t0.menu_mega_deux_id AS menu_mega_deux_id_8,
  t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9,
  t0.menu_mega_id AS menu_mega_id_10,
  t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11,
  t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12
FROM
  menu_link t0
WHERE
  t0.menu_mega_menu_deux_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_menu_deux_id = 1 ORDER BY t0.ordre ASC;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 415)
8	__TwigTemplate_1450d1a91bcca55cc0a8a65fc982ce5c->doDisplay (line 388)
9	Twig\Template->yield (line 231)
10	__TwigTemplate_088dcfe976bdddad9e53dff91425b794->doDisplay (line 388)
11	Twig\Template->yield (line 380)
12	__TwigTemplate_06da3caa33842066172bfaddfca64464->block_header (line 432)
13	Twig\Template->yieldBlock (line 188)
14	__TwigTemplate_06da3caa33842066172bfaddfca64464->doDisplay (line 388)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_a2f2aee1d894d242dc2d57bf952cfa76->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
25	App\Controller\Front\OffresController->detailOffre (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.31 ms
(0.20%)

SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.afficher_actus_similaires AS afficher_actus_similaires_5, t0.url_liste AS url_liste_6, t0.url_detail AS url_detail_7, t0.h1_liste AS h1_liste_8, t0.afficher_bloc_contact AS afficher_bloc_contact_9, t0.titre_actu_similaire AS titre_actu_similaire_10, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11, t0.seo_title AS seo_title_12, t0.seo_desc AS seo_desc_13, t0.image_bg AS image_bg_14, t0.date_maj AS date_maj_15 FROM actus_config t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nb_lignes AS nb_lignes_2,
  t0.libelle AS libelle_3,
  t0.afficher_pagination AS afficher_pagination_4,
  t0.afficher_actus_similaires AS afficher_actus_similaires_5,
  t0.url_liste AS url_liste_6,
  t0.url_detail AS url_detail_7,
  t0.h1_liste AS h1_liste_8,
  t0.afficher_bloc_contact AS afficher_bloc_contact_9,
  t0.titre_actu_similaire AS titre_actu_similaire_10,
  t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11,
  t0.seo_title AS seo_title_12,
  t0.seo_desc AS seo_desc_13,
  t0.image_bg AS image_bg_14,
  t0.date_maj AS date_maj_15
FROM
  actus_config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.afficher_actus_similaires AS afficher_actus_similaires_5, t0.url_liste AS url_liste_6, t0.url_detail AS url_detail_7, t0.h1_liste AS h1_liste_8, t0.afficher_bloc_contact AS afficher_bloc_contact_9, t0.titre_actu_similaire AS titre_actu_similaire_10, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11, t0.seo_title AS seo_title_12, t0.seo_desc AS seo_desc_13, t0.image_bg AS image_bg_14, t0.date_maj AS date_maj_15 FROM actus_config t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 121)
7	App\Twig\AppExtension->getGlobals (line 340)
8	Twig\ExtensionSet->getGlobals (line 892)
9	Twig\Environment->getGlobals (line 384)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
18	App\Controller\Front\OffresController->detailOffre (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.31 ms
(0.20%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.date_maj AS date_maj_4, t0.actif AS actif_5, t0.cle_api AS cle_api_6, t0.puce_map AS puce_map_7, t0.styles AS styles_8 FROM maps t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.date_maj AS date_maj_4,
  t0.actif AS actif_5,
  t0.cle_api AS cle_api_6,
  t0.puce_map AS puce_map_7,
  t0.styles AS styles_8
FROM
  maps t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.date_maj AS date_maj_4, t0.actif AS actif_5, t0.cle_api AS cle_api_6, t0.puce_map AS puce_map_7, t0.styles AS styles_8 FROM maps t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 157)
7	App\Twig\AppExtension->getGlobals (line 340)
8	Twig\ExtensionSet->getGlobals (line 892)
9	Twig\Environment->getGlobals (line 384)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
18	App\Controller\Front\OffresController->detailOffre (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.29 ms
(0.18%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.accroche AS accroche_3, t0.btn_libelle AS btn_libelle_4, t0.btn_lien AS btn_lien_5, t0.btn_title AS btn_title_6, t0.bloc_un_nom AS bloc_un_nom_7, t0.bloc_un_lien AS bloc_un_lien_8, t0.bloc_un_title AS bloc_un_title_9, t0.bloc_deux_nom AS bloc_deux_nom_10, t0.bloc_deux_lien AS bloc_deux_lien_11, t0.bloc_deux_title AS bloc_deux_title_12, t0.bloc_trois_nom AS bloc_trois_nom_13, t0.bloc_trois_lien AS bloc_trois_lien_14, t0.bloc_trois_title AS bloc_trois_title_15 FROM menu_mega t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.accroche AS accroche_3,
  t0.btn_libelle AS btn_libelle_4,
  t0.btn_lien AS btn_lien_5,
  t0.btn_title AS btn_title_6,
  t0.bloc_un_nom AS bloc_un_nom_7,
  t0.bloc_un_lien AS bloc_un_lien_8,
  t0.bloc_un_title AS bloc_un_title_9,
  t0.bloc_deux_nom AS bloc_deux_nom_10,
  t0.bloc_deux_lien AS bloc_deux_lien_11,
  t0.bloc_deux_title AS bloc_deux_title_12,
  t0.bloc_trois_nom AS bloc_trois_nom_13,
  t0.bloc_trois_lien AS bloc_trois_lien_14,
  t0.bloc_trois_title AS bloc_trois_title_15
FROM
  menu_mega t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.accroche AS accroche_3, t0.btn_libelle AS btn_libelle_4, t0.btn_lien AS btn_lien_5, t0.btn_title AS btn_title_6, t0.bloc_un_nom AS bloc_un_nom_7, t0.bloc_un_lien AS bloc_un_lien_8, t0.bloc_un_title AS bloc_un_title_9, t0.bloc_deux_nom AS bloc_deux_nom_10, t0.bloc_deux_lien AS bloc_deux_lien_11, t0.bloc_deux_title AS bloc_deux_title_12, t0.bloc_trois_nom AS bloc_trois_nom_13, t0.bloc_trois_lien AS bloc_trois_lien_14, t0.bloc_trois_title AS bloc_trois_title_15 FROM menu_mega t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	App\Twig\AppExtension->getGlobals (line 340)
8	Twig\ExtensionSet->getGlobals (line 892)
9	Twig\Environment->getGlobals (line 384)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
18	App\Controller\Front\OffresController->detailOffre (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.28 ms
(0.18%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.title AS title_4, t0.url AS url_5, t0.targert AS targert_6, t0.type AS type_7 FROM menu t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.ordre AS ordre_3,
  t0.title AS title_4,
  t0.url AS url_5,
  t0.targert AS targert_6,
  t0.type AS type_7
FROM
  menu t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.title AS title_4, t0.url AS url_5, t0.targert AS targert_6, t0.type AS type_7 FROM menu 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 145)
6	App\Twig\AppExtension->getGlobals (line 340)
7	Twig\ExtensionSet->getGlobals (line 892)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
17	App\Controller\Front\OffresController->detailOffre (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.28 ms
(0.18%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_second AS libelle_second_3,
  t0.libelle_third AS libelle_third_4,
  t0.slug AS slug_5,
  t0.slug_second AS slug_second_6,
  t0.slug_third AS slug_third_7
FROM
  offres_nature t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\OffresNature::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\OffresNature->__get (line 70)
8	App\Entity\OffresNature->getLibelleSecond (line 215)
9	App\Controller\Front\OffresController->detailOffre (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.28 ms
(0.18%)

SELECT t0.id AS id_1, t0.affichage AS affichage_2, t0.choix_affichage_carte AS choix_affichage_carte_3, t0.choix_affichage_mixte AS choix_affichage_mixte_4, t0.choix_affichage_liste AS choix_affichage_liste_5 FROM type_affichage t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.affichage AS affichage_2,
  t0.choix_affichage_carte AS choix_affichage_carte_3,
  t0.choix_affichage_mixte AS choix_affichage_mixte_4,
  t0.choix_affichage_liste AS choix_affichage_liste_5
FROM
  type_affichage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.affichage AS affichage_2, t0.choix_affichage_carte AS choix_affichage_carte_3, t0.choix_affichage_mixte AS choix_affichage_mixte_4, t0.choix_affichage_liste AS choix_affichage_liste_5 FROM type_affichage t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 159)
7	App\Twig\AppExtension->getGlobals (line 340)
8	Twig\ExtensionSet->getGlobals (line 892)
9	Twig\Environment->getGlobals (line 384)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
18	App\Controller\Front\OffresController->detailOffre (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.27 ms
(0.17%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_second AS libelle_second_3,
  t0.slug AS slug_4,
  t0.slug_second AS slug_second_5
FROM
  offres_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\OffresType::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\OffresType->__get (line 63)
8	App\Entity\OffresType->getLibelle (line 215)
9	App\Controller\Front\OffresController->detailOffre (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.26 ms
(0.17%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.photo AS photo_3, t0.update_at AS update_at_4, t0.type_offre_id AS type_offre_id_5 FROM offres_photos t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.photo AS photo_3,
  t0.update_at AS update_at_4,
  t0.type_offre_id AS type_offre_id_5
FROM
  offres_photos t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.photo AS photo_3, t0.update_at AS update_at_4, t0.type_offre_id AS type_offre_id_5 FROM offres_photos 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 123)
6	App\Twig\AppExtension->getGlobals (line 340)
7	Twig\ExtensionSet->getGlobals (line 892)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
17	App\Controller\Front\OffresController->detailOffre (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.25 ms
(0.16%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_second AS libelle_second_3,
  t0.libelle_third AS libelle_third_4,
  t0.slug AS slug_5,
  t0.slug_second AS slug_second_6,
  t0.slug_third AS slug_third_7
FROM
  offres_nature t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature 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 124)
6	App\Twig\AppExtension->getGlobals (line 340)
7	Twig\ExtensionSet->getGlobals (line 892)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
17	App\Controller\Front\OffresController->detailOffre (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.24 ms
(0.15%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_second AS libelle_second_3,
  t0.slug AS slug_4,
  t0.slug_second AS slug_second_5
FROM
  offres_type t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type 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 125)
6	App\Twig\AppExtension->getGlobals (line 340)
7	Twig\ExtensionSet->getGlobals (line 892)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
17	App\Controller\Front\OffresController->detailOffre (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Infos	No errors.
App\Entity\Agence	No errors.
App\Entity\ActusConfig	No errors.
App\Entity\OffresConfig	No errors.
App\Entity\OffresPhotos	No errors.
App\Entity\OffresNature	No errors.
App\Entity\OffresType	No errors.
App\Entity\Localisations	No errors.
App\Entity\Pages	The association App\Entity\Pages#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Template	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuMega	No errors.
App\Entity\Footer	No errors.
App\Entity\SecteurConfig	No errors.
App\Entity\FavorisConfig	No errors.
App\Entity\PartageConfig	No errors.
App\Entity\Maps	No errors.
App\Entity\TypeAffichage	No errors.
App\Entity\Offres	No errors.
App\Entity\TriConfig	No errors.
App\Entity\Collaborateurs	No errors.
App\Entity\Secteur	No errors.
App\Entity\BlocNoResult	No errors.
App\Entity\PageIndex	No errors.
App\Entity\Surfaces	No errors.
App\Entity\Renseignements	No errors.
App\Entity\Equipe	No errors.
App\Entity\AlerteMail	No errors.
App\Entity\Actus	The association App\Entity\Actus#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Carriere	No errors.
App\Entity\MenuLink	No errors.
App\Entity\FooterLink	No errors.
App\Entity\MenuMegaDeux	No errors.
App\Entity\FooterBig	No errors.

Symfony Profiler

GET https://preprod.evolis-ie.com/offres-immobilier/location/bureaux/verrieres-le-buisson-91370/bureaux-a-louer-verrieres-le-buisson-91370-1382948-0lb

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping