Symfony Profiler

Query Metrics

19 Database Queries

7 Different statements

9.82 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.99 ms
(40.62%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.date AS date_3, t0.fr AS fr_4, t0.de AS de_5, t0.en AS en_6, t0.html AS html_7, t0.image AS image_8, t0.note AS note_9, t0.variables AS variables_10, t0.date_debut AS date_debut_11, t0.date_fin AS date_fin_12, t0.favori AS favori_13, t0.site_id AS site_id_14 FROM www_textes t0 WHERE t0.id = ?

Parameters:

[
  7438
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.date AS date_3,
  t0.fr AS fr_4,
  t0.de AS de_5,
  t0.en AS en_6,
  t0.html AS html_7,
  t0.image AS image_8,
  t0.note AS note_9,
  t0.variables AS variables_10,
  t0.date_debut AS date_debut_11,
  t0.date_fin AS date_fin_12,
  t0.favori AS favori_13,
  t0.site_id AS site_id_14
FROM
  www_textes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.date AS date_3, t0.fr AS fr_4, t0.de AS de_5, t0.en AS en_6, t0.html AS html_7, t0.image AS image_8, t0.note AS note_9, t0.variables AS variables_10, t0.date_debut AS date_debut_11, t0.date_fin AS date_fin_12, t0.favori AS favori_13, t0.site_id AS site_id_14 FROM www_textes t0 WHERE t0.id = 7438;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Www\Textes::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Www\Textes->__get (line 186)
8	App\Entity\Www\Textes->getFr (line 132)
9	App\Entity\Www\Textes->__toString (line 178)
10	Symfony\Component\Routing\Generator\UrlGenerator->doGenerate (line 67)
11	Symfony\Component\Routing\Generator\CompiledUrlGenerator->generate (line 221)
12	Symfony\Component\Routing\Router->generate (line 45)
13	Symfony\Bridge\Twig\Extension\RoutingExtension->getPath (line 50)
14	__TwigTemplate_471c0754087afb4741f48c85c69b046b->doDisplay (line 388)
15	Twig\Template->yield (line 89)
16	__TwigTemplate_04e789750d0d81f858ac67dfb22ecdd9->doDisplay (line 388)
17	Twig\Template->yield (line 140)
18	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->block_content (line 432)
19	Twig\Template->yieldBlock (line 293)
20	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->block_body (line 432)
21	Twig\Template->yieldBlock (line 122)
22	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->doDisplay (line 388)
23	Twig\Template->yield (line 55)
24	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->doDisplay (line 388)
25	Twig\Template->yield (line 344)
26	Twig\Template->display (line 359)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 334)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 80)
33	App\Controller\Site\SiteController->appliGps (line 50)
34	App\Controller\Site\SiteController->index (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

1.61 ms
(16.43%)

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.nom_url AS nom_url_3, t0.tva_intracomm AS tva_intracomm_4, t0.siret AS siret_5, t0.num_compta AS num_compta_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.civilite AS civilite_9, t0.fonction AS fonction_10, t0.date_naissance AS date_naissance_11, t0.adresse AS adresse_12, t0.adresse2 AS adresse2_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.telephone AS telephone_17, t0.mobile AS mobile_18, t0.fax AS fax_19, t0.email AS email_20, t0.email_relance AS email_relance_21, t0.pass AS pass_22, t0.newsletter AS newsletter_23, t0.groupe_newsletter AS groupe_newsletter_24, t0.date AS date_25, t0.connecte AS connecte_26, t0.remise AS remise_27, t0.solde AS solde_28, t0.hors_taxes AS hors_taxes_29, t0.site_web AS site_web_30, t0.id_parrain AS id_parrain_31, t0.code AS code_32, t0.actif AS actif_33, t0.note AS note_34, t0.envoi_auto AS envoi_auto_35, t0.source AS source_36, t0.cle AS cle_37, t0.spe AS spe_38, t0.paiement AS paiement_39, t0.sexe AS sexe_40, t0.roles AS roles_41, t0.mdp_oublie AS mdp_oublie_42, t0.forward AS forward_43, t0.logo AS logo_44, t0.token_connexion AS token_connexion_45, t0.autorisation_contact_entreprise AS autorisation_contact_entreprise_46, t0.bob AS bob_47, t0.autoconnect_token AS autoconnect_token_48, t0.latitude AS latitude_49, t0.longitude AS longitude_50, t0.old_id AS old_id_51, t0.date_creation AS date_creation_52, t0.date_modification AS date_modification_53, t0.date_deletion AS date_deletion_54, t0.password_requested_at AS password_requested_at_55, t0.token AS token_56, t0.type AS type_57, t0.categorie AS categorie_58, t0.text_id AS text_id_59, t0.short_text_id AS short_text_id_60, t0.establishment_name_id AS establishment_name_id_61, t0.langue_id AS langue_id_62 FROM clients t0 WHERE t0.id = ?

Parameters:

[
  275
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.nom_url AS nom_url_3,
  t0.tva_intracomm AS tva_intracomm_4,
  t0.siret AS siret_5,
  t0.num_compta AS num_compta_6,
  t0.nom AS nom_7,
  t0.prenom AS prenom_8,
  t0.civilite AS civilite_9,
  t0.fonction AS fonction_10,
  t0.date_naissance AS date_naissance_11,
  t0.adresse AS adresse_12,
  t0.adresse2 AS adresse2_13,
  t0.code_postal AS code_postal_14,
  t0.ville AS ville_15,
  t0.pays AS pays_16,
  t0.telephone AS telephone_17,
  t0.mobile AS mobile_18,
  t0.fax AS fax_19,
  t0.email AS email_20,
  t0.email_relance AS email_relance_21,
  t0.pass AS pass_22,
  t0.newsletter AS newsletter_23,
  t0.groupe_newsletter AS groupe_newsletter_24,
  t0.date AS date_25,
  t0.connecte AS connecte_26,
  t0.remise AS remise_27,
  t0.solde AS solde_28,
  t0.hors_taxes AS hors_taxes_29,
  t0.site_web AS site_web_30,
  t0.id_parrain AS id_parrain_31,
  t0.code AS code_32,
  t0.actif AS actif_33,
  t0.note AS note_34,
  t0.envoi_auto AS envoi_auto_35,
  t0.source AS source_36,
  t0.cle AS cle_37,
  t0.spe AS spe_38,
  t0.paiement AS paiement_39,
  t0.sexe AS sexe_40,
  t0.roles AS roles_41,
  t0.mdp_oublie AS mdp_oublie_42,
  t0.forward AS forward_43,
  t0.logo AS logo_44,
  t0.token_connexion AS token_connexion_45,
  t0.autorisation_contact_entreprise AS autorisation_contact_entreprise_46,
  t0.bob AS bob_47,
  t0.autoconnect_token AS autoconnect_token_48,
  t0.latitude AS latitude_49,
  t0.longitude AS longitude_50,
  t0.old_id AS old_id_51,
  t0.date_creation AS date_creation_52,
  t0.date_modification AS date_modification_53,
  t0.date_deletion AS date_deletion_54,
  t0.password_requested_at AS password_requested_at_55,
  t0.token AS token_56,
  t0.type AS type_57,
  t0.categorie AS categorie_58,
  t0.text_id AS text_id_59,
  t0.short_text_id AS short_text_id_60,
  t0.establishment_name_id AS establishment_name_id_61,
  t0.langue_id AS langue_id_62
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.nom_url AS nom_url_3, t0.tva_intracomm AS tva_intracomm_4, t0.siret AS siret_5, t0.num_compta AS num_compta_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.civilite AS civilite_9, t0.fonction AS fonction_10, t0.date_naissance AS date_naissance_11, t0.adresse AS adresse_12, t0.adresse2 AS adresse2_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.telephone AS telephone_17, t0.mobile AS mobile_18, t0.fax AS fax_19, t0.email AS email_20, t0.email_relance AS email_relance_21, t0.pass AS pass_22, t0.newsletter AS newsletter_23, t0.groupe_newsletter AS groupe_newsletter_24, t0.date AS date_25, t0.connecte AS connecte_26, t0.remise AS remise_27, t0.solde AS solde_28, t0.hors_taxes AS hors_taxes_29, t0.site_web AS site_web_30, t0.id_parrain AS id_parrain_31, t0.code AS code_32, t0.actif AS actif_33, t0.note AS note_34, t0.envoi_auto AS envoi_auto_35, t0.source AS source_36, t0.cle AS cle_37, t0.spe AS spe_38, t0.paiement AS paiement_39, t0.sexe AS sexe_40, t0.roles AS roles_41, t0.mdp_oublie AS mdp_oublie_42, t0.forward AS forward_43, t0.logo AS logo_44, t0.token_connexion AS token_connexion_45, t0.autorisation_contact_entreprise AS autorisation_contact_entreprise_46, t0.bob AS bob_47, t0.autoconnect_token AS autoconnect_token_48, t0.latitude AS latitude_49, t0.longitude AS longitude_50, t0.old_id AS old_id_51, t0.date_creation AS date_creation_52, t0.date_modification AS date_modification_53, t0.date_deletion AS date_deletion_54, t0.password_requested_at AS password_requested_at_55, t0.token AS token_56, t0.type AS type_57, t0.categorie AS categorie_58, t0.text_id AS text_id_59, t0.short_text_id AS short_text_id_60, t0.establishment_name_id AS establishment_name_id_61, t0.langue_id AS langue_id_62 FROM clients t0 WHERE t0.id = 275;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Clients\Clients::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Clients\Clients->__get (line 497)
8	App\Entity\Clients\Clients->getVille (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 70)
10	__TwigTemplate_471c0754087afb4741f48c85c69b046b->doDisplay (line 388)
11	Twig\Template->yield (line 89)
12	__TwigTemplate_04e789750d0d81f858ac67dfb22ecdd9->doDisplay (line 388)
13	Twig\Template->yield (line 140)
14	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->block_content (line 432)
15	Twig\Template->yieldBlock (line 293)
16	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->block_body (line 432)
17	Twig\Template->yieldBlock (line 122)
18	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->doDisplay (line 388)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 80)
29	App\Controller\Site\SiteController->appliGps (line 50)
30	App\Controller\Site\SiteController->index (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.50 ms
(15.30%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre AS titre_4, t0.meta_titre AS meta_titre_5, t0.mots_cles AS mots_cles_6, t0.meta_description AS meta_description_7, t0.h1 AS h1_8, t0.texte_court AS texte_court_9, t0.texte AS texte_10, t0.langue AS langue_11, t0.ordre AS ordre_12, t0.type AS type_13, t0.deroulant AS deroulant_14, t0.lien_page AS lien_page_15, t0.page AS page_16, t0.filtre AS filtre_17, t0.actif AS actif_18, t0.cle AS cle_19, t0.photo_menu AS photo_menu_20, t0.photo_banniere AS photo_banniere_21, t0.photo_extra1 AS photo_extra1_22, t0.photo_extra2 AS photo_extra2_23, t0.photo_extra3 AS photo_extra3_24, t0.parent_page_id AS parent_page_id_25, t0.site_id AS site_id_26 FROM www_contenu t0 WHERE t0.cle = ? LIMIT 1

Parameters:

[
  "gps"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.titre_url AS titre_url_3,
  t0.titre AS titre_4,
  t0.meta_titre AS meta_titre_5,
  t0.mots_cles AS mots_cles_6,
  t0.meta_description AS meta_description_7,
  t0.h1 AS h1_8,
  t0.texte_court AS texte_court_9,
  t0.texte AS texte_10,
  t0.langue AS langue_11,
  t0.ordre AS ordre_12,
  t0.type AS type_13,
  t0.deroulant AS deroulant_14,
  t0.lien_page AS lien_page_15,
  t0.page AS page_16,
  t0.filtre AS filtre_17,
  t0.actif AS actif_18,
  t0.cle AS cle_19,
  t0.photo_menu AS photo_menu_20,
  t0.photo_banniere AS photo_banniere_21,
  t0.photo_extra1 AS photo_extra1_22,
  t0.photo_extra2 AS photo_extra2_23,
  t0.photo_extra3 AS photo_extra3_24,
  t0.parent_page_id AS parent_page_id_25,
  t0.site_id AS site_id_26
FROM
  www_contenu t0
WHERE
  t0.cle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre AS titre_4, t0.meta_titre AS meta_titre_5, t0.mots_cles AS mots_cles_6, t0.meta_description AS meta_description_7, t0.h1 AS h1_8, t0.texte_court AS texte_court_9, t0.texte AS texte_10, t0.langue AS langue_11, t0.ordre AS ordre_12, t0.type AS type_13, t0.deroulant AS deroulant_14, t0.lien_page AS lien_page_15, t0.page AS page_16, t0.filtre AS filtre_17, t0.actif AS actif_18, t0.cle AS cle_19, t0.photo_menu AS photo_menu_20, t0.photo_banniere AS photo_banniere_21, t0.photo_extra1 AS photo_extra1_22, t0.photo_extra2 AS photo_extra2_23, t0.photo_extra3 AS photo_extra3_24, t0.parent_page_id AS parent_page_id_25, t0.site_id AS site_id_26 FROM www_contenu t0 WHERE t0.cle = 'gps' 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 70)
5	App\Controller\Site\SiteController->appliGps (line 50)
6	App\Controller\Site\SiteController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.80 ms
(8.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.sorting AS sorting_4 FROM offer_contract t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.sorting AS sorting_4
FROM
  offer_contract t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.sorting AS sorting_4 FROM offer_contract t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Offer\OfferContract::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Offer\OfferContract->__get (line 42)
8	App\Entity\Offer\OfferContract->getName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 63)
10	__TwigTemplate_471c0754087afb4741f48c85c69b046b->doDisplay (line 388)
11	Twig\Template->yield (line 89)
12	__TwigTemplate_04e789750d0d81f858ac67dfb22ecdd9->doDisplay (line 388)
13	Twig\Template->yield (line 140)
14	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->block_content (line 432)
15	Twig\Template->yieldBlock (line 293)
16	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->block_body (line 432)
17	Twig\Template->yieldBlock (line 122)
18	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->doDisplay (line 388)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 80)
29	App\Controller\Site\SiteController->appliGps (line 50)
30	App\Controller\Site\SiteController->index (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.66 ms
(6.73%)

SELECT o0_.id AS id_0, o0_.spotlight AS spotlight_1, o0_.approved AS approved_2, o0_.approved_date AS approved_date_3, o0_.picture AS picture_4, o0_.active AS active_5, o0_.date_creation AS date_creation_6, o0_.date_modification AS date_modification_7, o0_.date_deletion AS date_deletion_8, o0_.name AS name_9, o0_.text AS text_10, o0_.short_text_id AS short_text_id_11, o0_.company_id AS company_id_12, o0_.contract_id AS contract_id_13, o0_.nameUrl AS nameUrl_14 FROM offer o0_ LEFT JOIN offer_contract o1_ ON o0_.contract_id = o1_.id LEFT JOIN clients c2_ ON o0_.company_id = c2_.id WHERE o0_.spotlight = ? AND o0_.approved = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.spotlight AS spotlight_1,
  o0_.approved AS approved_2,
  o0_.approved_date AS approved_date_3,
  o0_.picture AS picture_4,
  o0_.active AS active_5,
  o0_.date_creation AS date_creation_6,
  o0_.date_modification AS date_modification_7,
  o0_.date_deletion AS date_deletion_8,
  o0_.name AS name_9,
  o0_.text AS text_10,
  o0_.short_text_id AS short_text_id_11,
  o0_.company_id AS company_id_12,
  o0_.contract_id AS contract_id_13,
  o0_.nameUrl AS nameUrl_14
FROM
  offer o0_
  LEFT JOIN offer_contract o1_ ON o0_.contract_id = o1_.id
  LEFT JOIN clients c2_ ON o0_.company_id = c2_.id
WHERE
  o0_.spotlight = ?
  AND o0_.approved = ?

SELECT o0_.id AS id_0, o0_.spotlight AS spotlight_1, o0_.approved AS approved_2, o0_.approved_date AS approved_date_3, o0_.picture AS picture_4, o0_.active AS active_5, o0_.date_creation AS date_creation_6, o0_.date_modification AS date_modification_7, o0_.date_deletion AS date_deletion_8, o0_.name AS name_9, o0_.text AS text_10, o0_.short_text_id AS short_text_id_11, o0_.company_id AS company_id_12, o0_.contract_id AS contract_id_13, o0_.nameUrl AS nameUrl_14 FROM offer o0_ LEFT JOIN offer_contract o1_ ON o0_.contract_id = o1_.id LEFT JOIN clients c2_ ON o0_.company_id = c2_.id WHERE o0_.spotlight = 1 AND o0_.approved = 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 125)
7	App\Repository\Offer\OfferRepository->findBy (line 78)
8	App\Controller\Site\SiteController->appliGps (line 50)
9	App\Controller\Site\SiteController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.64 ms
(6.53%)

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.author AS author_2, t0_.text AS text_3, t0_.link AS link_4, t0_.active AS active_5 FROM testimonial t0_ WHERE t0_.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.author AS author_2,
  t0_.text AS text_3,
  t0_.link AS link_4,
  t0_.active AS active_5
FROM
  testimonial t0_
WHERE
  t0_.active = ?

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.author AS author_2, t0_.text AS text_3, t0_.link AS link_4, t0_.active AS active_5 FROM testimonial t0_ WHERE t0_.active = 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 56)
7	App\Repository\Testimonial\TestimonialRepository->findBy (line 72)
8	App\Controller\Site\SiteController->appliGps (line 50)
9	App\Controller\Site\SiteController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.61 ms
(6.24%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre AS titre_4, t0.meta_titre AS meta_titre_5, t0.mots_cles AS mots_cles_6, t0.meta_description AS meta_description_7, t0.h1 AS h1_8, t0.texte_court AS texte_court_9, t0.texte AS texte_10, t0.langue AS langue_11, t0.ordre AS ordre_12, t0.type AS type_13, t0.deroulant AS deroulant_14, t0.lien_page AS lien_page_15, t0.page AS page_16, t0.filtre AS filtre_17, t0.actif AS actif_18, t0.cle AS cle_19, t0.photo_menu AS photo_menu_20, t0.photo_banniere AS photo_banniere_21, t0.photo_extra1 AS photo_extra1_22, t0.photo_extra2 AS photo_extra2_23, t0.photo_extra3 AS photo_extra3_24, t0.parent_page_id AS parent_page_id_25, t0.site_id AS site_id_26 FROM www_contenu t0 WHERE t0.parent_page_id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.titre_url AS titre_url_3,
  t0.titre AS titre_4,
  t0.meta_titre AS meta_titre_5,
  t0.mots_cles AS mots_cles_6,
  t0.meta_description AS meta_description_7,
  t0.h1 AS h1_8,
  t0.texte_court AS texte_court_9,
  t0.texte AS texte_10,
  t0.langue AS langue_11,
  t0.ordre AS ordre_12,
  t0.type AS type_13,
  t0.deroulant AS deroulant_14,
  t0.lien_page AS lien_page_15,
  t0.page AS page_16,
  t0.filtre AS filtre_17,
  t0.actif AS actif_18,
  t0.cle AS cle_19,
  t0.photo_menu AS photo_menu_20,
  t0.photo_banniere AS photo_banniere_21,
  t0.photo_extra1 AS photo_extra1_22,
  t0.photo_extra2 AS photo_extra2_23,
  t0.photo_extra3 AS photo_extra3_24,
  t0.parent_page_id AS parent_page_id_25,
  t0.site_id AS site_id_26
FROM
  www_contenu t0
WHERE
  t0.parent_page_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre AS titre_4, t0.meta_titre AS meta_titre_5, t0.mots_cles AS mots_cles_6, t0.meta_description AS meta_description_7, t0.h1 AS h1_8, t0.texte_court AS texte_court_9, t0.texte AS texte_10, t0.langue AS langue_11, t0.ordre AS ordre_12, t0.type AS type_13, t0.deroulant AS deroulant_14, t0.lien_page AS lien_page_15, t0.page AS page_16, t0.filtre AS filtre_17, t0.actif AS actif_18, t0.cle AS cle_19, t0.photo_menu AS photo_menu_20, t0.photo_banniere AS photo_banniere_21, t0.photo_extra1 AS photo_extra1_22, t0.photo_extra2 AS photo_extra2_23, t0.photo_extra3 AS photo_extra3_24, t0.parent_page_id AS parent_page_id_25, t0.site_id AS site_id_26 FROM www_contenu t0 WHERE t0.parent_page_id = 19;

#	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 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1671)
10	Twig\Extension\CoreExtension::getAttribute (line 55)
11	__TwigTemplate_144c41784c9271430d8059fffa7fabb6->doDisplay (line 388)
12	Twig\Template->yield (line 128)
13	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->block_content (line 432)
14	Twig\Template->yieldBlock (line 293)
15	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->block_body (line 432)
16	Twig\Template->yieldBlock (line 122)
17	__TwigTemplate_b193b8e72f3f3aa4a650cde3da97ee92->doDisplay (line 388)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_24e5c5bb1ca898d625171e0ca6165e91->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 80)
28	App\Controller\Site\SiteController->appliGps (line 50)
29	App\Controller\Site\SiteController->index (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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\Www\Contenu	No errors.
App\Entity\Www\Sites	No errors.
App\Entity\Testimonial\Testimonial	No errors.
App\Entity\Training\Training	No errors.
App\Entity\Offer\Offer	No errors.
App\Entity\Offer\OfferContract	No errors.
App\Entity\Clients\Clients	No errors.
App\Entity\Www\Textes	No errors.
App\Entity\Offer\OfferCandidacy	No errors.
App\Entity\Clients\ClientsTypes	No errors.
App\Entity\Clients\ClientsCategories	No errors.
App\Entity\Www\Langues	No errors.
App\Entity\Clients\ClientsAdresses	No errors.
App\Entity\Clients\ClientsContacts	No errors.
App\Entity\Clients\ClientsHistorique	No errors.
App\Entity\Clients\ClientsIp	No errors.
App\Entity\Clients\ClientsParrainage	No errors.
App\Entity\Clients\ClientsPhotos	No errors.
App\Entity\Event\EventRegistration	No errors.
App\Entity\Platform\PlatformRegistration	No errors.
App\Entity\Project\ProjectRegistration	No errors.
App\Entity\Idea\Idea	No errors.
App\Entity\Project\ProjectResponsible	No errors.
App\Entity\Platform\Platform	No errors.
App\Entity\Journeys\JourneyClientTraining	No errors.
App\Entity\Journeys\Journey	No errors.
App\Entity\Journeys\Domains	No errors.

Symfony Profiler

GET https://bob-dev.cmq3e.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping