Symfony Profiler

Query Metrics

35 Database Queries

33 Different statements

182.52 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

150.25 ms
(82.32%)

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 644)
16	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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)

9.63 ms
(5.28%)

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 644)
18	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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)

2.63 ms
(1.44%)

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 o1_, offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 0

Parameters:

[
  "arnas-69400"
]

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 o1_,
  offres o0_
WHERE
  o0_.slug_ville_cp = ?
  AND o0_.nature_id = 1
  AND o0_.type_id = 3
  AND o0_.directe = 0

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 o1_, offres o0_ WHERE o0_.slug_ville_cp = 'arnas-69400' AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 0;

#	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 624)
7	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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)

2.48 ms
(1.36%)

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_.slug_ville_cp = ? AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16

Parameters:

[
  "arnas-69400"
]

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_.slug_ville_cp = ?
  AND o0_.nature_id = 1
  AND o0_.type_id = 3
  AND o0_.directe = 1
ORDER BY
  o0_.date_modif ASC
LIMIT
  16

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_.slug_ville_cp = 'arnas-69400' AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16;

#	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 623)
7	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.71 ms
(0.94%)

SELECT o0_.slug_ville_cp AS slug_ville_cp_0, o0_.ville AS ville_1, o0_.cp AS cp_2, o0_.departement_slug AS departement_slug_3, COUNT(o0_.id) AS sclr_4 FROM offres o0_ WHERE o0_.slug_ville_cp <> ? AND o0_.cp LIKE ? AND o0_.nature_id = 1 AND o0_.type_id = 3 GROUP BY o0_.slug_ville_cp ORDER BY o0_.ville ASC

Parameters:

[
  "arnas-69400"
  "69%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.slug_ville_cp AS slug_ville_cp_0,
  o0_.ville AS ville_1,
  o0_.cp AS cp_2,
  o0_.departement_slug AS departement_slug_3,
  COUNT(o0_.id) AS sclr_4
FROM
  offres o0_
WHERE
  o0_.slug_ville_cp <> ?
  AND o0_.cp LIKE ?
  AND o0_.nature_id = 1
  AND o0_.type_id = 3
GROUP BY
  o0_.slug_ville_cp
ORDER BY
  o0_.ville ASC

SELECT o0_.slug_ville_cp AS slug_ville_cp_0, o0_.ville AS ville_1, o0_.cp AS cp_2, o0_.departement_slug AS departement_slug_3, COUNT(o0_.id) AS sclr_4 FROM offres o0_ WHERE o0_.slug_ville_cp <> 'arnas-69400' AND o0_.cp LIKE '69%' AND o0_.nature_id = 1 AND o0_.type_id = 3 GROUP BY o0_.slug_ville_cp ORDER BY o0_.ville ASC;

#	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 594)
7	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.58 ms
(0.87%)

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 1

Parameters:

[
  "arnas-69400"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  offres o0_
WHERE
  o0_.slug_ville_cp = ?
  AND o0_.nature_id = 1
  AND o0_.type_id = 3
  AND o0_.directe = 1

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offres o0_ WHERE o0_.slug_ville_cp = 'arnas-69400' AND o0_.nature_id = 1 AND o0_.type_id = 3 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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerIueNYr2\PaginatorProxyBa079e5->paginate (line 535)
16	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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)

1.46 ms
(0.80%)

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)

1.43 ms
(0.78%)

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 644)
18	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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)

1.32 ms
(0.72%)

SELECT DISTINCT o0_.id AS id_0, o0_.date_modif AS date_modif_1 FROM offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16

Parameters:

[
  "arnas-69400"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date_modif AS date_modif_1
FROM
  offres o0_
WHERE
  o0_.slug_ville_cp = ?
  AND o0_.nature_id = 1
  AND o0_.type_id = 3
  AND o0_.directe = 1
ORDER BY
  o0_.date_modif ASC
LIMIT
  16

SELECT DISTINCT o0_.id AS id_0, o0_.date_modif AS date_modif_1 FROM offres o0_ WHERE o0_.slug_ville_cp = 'arnas-69400' AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerIueNYr2\PaginatorProxyBa079e5->paginate (line 535)
16	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.72 ms
(0.40%)

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.70 ms
(0.38%)

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 644)
17	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.65 ms
(0.35%)

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 56)
14	__TwigTemplate_1a23150955061838451f44f420732df3->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 644)
23	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.62 ms
(0.34%)

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_.slug_ville_cp = ? AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 1 AND o0_.id IN (?, ?, ?, ?) ORDER BY o0_.date_modif ASC

Parameters:

[
  "arnas-69400"
  1329
  1453
  1887
  1570
]

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_.slug_ville_cp = ?
  AND o0_.nature_id = 1
  AND o0_.type_id = 3
  AND o0_.directe = 1
  AND o0_.id IN (?, ?, ?, ?)
ORDER BY
  o0_.date_modif ASC

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_.slug_ville_cp = 'arnas-69400' AND o0_.nature_id = 1 AND o0_.type_id = 3 AND o0_.directe = 1 AND o0_.id IN (1329, 1453, 1887, 1570) ORDER BY o0_.date_modif ASC;

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerIueNYr2\PaginatorProxyBa079e5->paginate (line 535)
16	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.61 ms
(0.33%)

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 644)
16	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.52 ms
(0.28%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.image AS image_3, t0.url AS url_4, t0.title AS title_5, t0.alt AS alt_6, t0.date_maj AS date_maj_7, t0.actif AS actif_8, t0.description AS description_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.og_title AS og_title_12, t0.og_desc AS og_desc_13, t0.og_image AS og_image_14, t0.home AS home_15, t0.agence_id AS agence_id_16 FROM secteur t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "/offres-immobilier/location/entrepots-locaux-d-activites/arnas-69400/"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.image AS image_3,
  t0.url AS url_4,
  t0.title AS title_5,
  t0.alt AS alt_6,
  t0.date_maj AS date_maj_7,
  t0.actif AS actif_8,
  t0.description AS description_9,
  t0.seo_title AS seo_title_10,
  t0.seo_desc AS seo_desc_11,
  t0.og_title AS og_title_12,
  t0.og_desc AS og_desc_13,
  t0.og_image AS og_image_14,
  t0.home AS home_15,
  t0.agence_id AS agence_id_16
FROM
  secteur t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.image AS image_3, t0.url AS url_4, t0.title AS title_5, t0.alt AS alt_6, t0.date_maj AS date_maj_7, t0.actif AS actif_8, t0.description AS description_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.og_title AS og_title_12, t0.og_desc AS og_desc_13, t0.og_image AS og_image_14, t0.home AS home_15, t0.agence_id AS agence_id_16 FROM secteur t0 WHERE t0.url = '/offres-immobilier/location/entrepots-locaux-d-activites/arnas-69400/' 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 514)
7	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.52 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_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 56)
14	__TwigTemplate_1a23150955061838451f44f420732df3->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 644)
23	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.24%)

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 56)
16	__TwigTemplate_1a23150955061838451f44f420732df3->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 644)
25	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.39 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.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 56)
14	__TwigTemplate_1a23150955061838451f44f420732df3->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 644)
23	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.38 ms
(0.21%)

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.slug = ? LIMIT 1

Parameters:

[
  "location"
]

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.slug = ?
LIMIT
  1

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.slug = 'location' 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 512)
7	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.36 ms
(0.20%)

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 56)
16	__TwigTemplate_1a23150955061838451f44f420732df3->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 644)
25	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.36 ms
(0.20%)

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 644)
16	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.36 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 644)
18	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.19%)

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 644)
16	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.34 ms
(0.19%)

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 644)
18	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.34 ms
(0.18%)

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 644)
17	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.33 ms
(0.18%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.afficher AS afficher_3 FROM tri_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.afficher AS afficher_3
FROM
  tri_config t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.afficher AS afficher_3 FROM tri_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 516)
6	App\Controller\Front\OffresController->listeOffreNatureTypeVille (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.32 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 644)
18	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.32 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.slug = ? LIMIT 1

Parameters:

[
  "entrepots-locaux-d-activites"
]

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.slug = ?
LIMIT
  1

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.slug = 'entrepots-locaux-d-activites' 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 513)
7	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.30 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 644)
17	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.29 ms
(0.16%)

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 644)
18	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.16%)

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 644)
17	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.16%)

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 644)
18	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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.25 ms
(0.14%)

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 644)
17	App\Controller\Front\OffresController->listeOffreNatureTypeVille (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\AlerteMail	No errors.
App\Entity\PageIndex	No errors.
App\Entity\Surfaces	No errors.
App\Entity\Renseignements	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\Equipe	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/entrepots-locaux-d-activites/arnas-69400/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping