Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

2.10 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.86 ms
(41.07%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.usermaj AS usermaj_3, t0.datemajutc AS datemajutc_4, t0.supprime AS supprime_5, t0.idgestion AS idgestion_6, t0.idmaitre AS idmaitre_7, t0.idrelay AS idrelay_8 FROM typeticket t0 WHERE t0.libelle = ? LIMIT 1

Parameters:

[
  "WhatsApp"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.usermaj AS usermaj_3,
  t0.datemajutc AS datemajutc_4,
  t0.supprime AS supprime_5,
  t0.idgestion AS idgestion_6,
  t0.idmaitre AS idmaitre_7,
  t0.idrelay AS idrelay_8
FROM
  typeticket t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.usermaj AS usermaj_3, t0.datemajutc AS datemajutc_4, t0.supprime AS supprime_5, t0.idgestion AS idgestion_6, t0.idmaitre AS idmaitre_7, t0.idrelay AS idrelay_8 FROM typeticket t0 WHERE t0.libelle = 'WhatsApp' 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 59)
4	Gestion\Controller\WhatsAppController->__construct (line 26)
5	Container8rgGi2Y\getWhatsAppControllerService::do (line 547)
6	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 31)
7	Container8rgGi2Y\getTicketControllerService::do (line 547)
8	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 26)
9	Container8rgGi2Y\getApiTicketControllerService::do (line 547)
10	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 229)
11	Symfony\Component\DependencyInjection\Container::make (line 211)
12	Symfony\Component\DependencyInjection\Container->get (line 40)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.63 ms
(30.06%)

SELECT id, code FROM langue WHERE actif = 1 and (supprime = 0 or supprime IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  code
FROM
  langue
WHERE
  actif = 1
  and (
    supprime = 0
    or supprime IS NULL
  )

SELECT id, code FROM langue WHERE actif = 1 and (supprime = 0 or supprime IS NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 195)
3	App\Controller\DefaultController->__construct (line 24)
4	Container8rgGi2Y\getDefaultControllerService::do (line 547)
5	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 26)
6	Container8rgGi2Y\getApiTicketControllerService::do (line 547)
7	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 229)
8	Symfony\Component\DependencyInjection\Container::make (line 211)
9	Symfony\Component\DependencyInjection\Container->get (line 40)
10	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
11	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
14	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.36 ms
(17.00%)

SELECT t0.id AS id_1, t0.numserie AS numserie_2, t0.type AS type_3, t0.numwhatsapp AS numwhatsapp_4, t0.pays AS pays_5, t0.site AS site_6, t0.numsim AS numsim_7, t0.datederniereinfo AS datederniereinfo_8, t0.datemiseenservice AS datemiseenservice_9, t0.alive AS alive_10, t0.o2h2 AS o2h2_11, t0.h2r AS h2r_12, t0.comp AS comp_13, t0.nivelec AS nivelec_14, t0.power AS power_15, t0.ximg AS ximg_16, t0.yimg AS yimg_17, t0.datesendalive AS datesendalive_18, t0.nivdiw AS nivdiw_19, t0.codeassociation AS codeassociation_20, t0.versiongensrelay AS versiongensrelay_21, t0.typemodule AS typemodule_22, t0.datederniereinfoip AS datederniereinfoip_23, t0.datederniereinfosms AS datederniereinfosms_24, t0.clepublique AS clepublique_25, t0.aliveip AS aliveip_26, t0.alivesms AS alivesms_27, t0.datesendaliveip AS datesendaliveip_28, t0.datesendalivesms AS datesendalivesms_29, t0.visuel AS visuel_30, t0.tempvisuel AS tempvisuel_31, t0.dateconf AS dateconf_32, t0.usermaj AS usermaj_33, t0.datemajutc AS datemajutc_34, t0.supprime AS supprime_35, t0.connexiongestion AS connexiongestion_36, t0.idgestion AS idgestion_37, t0.idmaitre AS idmaitre_38, t0.idrelay AS idrelay_39, t0.modelegenerateur_id AS modelegenerateur_id_40, t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41, t0.client_id AS client_id_42 FROM generateur t0 WHERE t0.id = ?

Parameters:

[
  "254"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numserie AS numserie_2,
  t0.type AS type_3,
  t0.numwhatsapp AS numwhatsapp_4,
  t0.pays AS pays_5,
  t0.site AS site_6,
  t0.numsim AS numsim_7,
  t0.datederniereinfo AS datederniereinfo_8,
  t0.datemiseenservice AS datemiseenservice_9,
  t0.alive AS alive_10,
  t0.o2h2 AS o2h2_11,
  t0.h2r AS h2r_12,
  t0.comp AS comp_13,
  t0.nivelec AS nivelec_14,
  t0.power AS power_15,
  t0.ximg AS ximg_16,
  t0.yimg AS yimg_17,
  t0.datesendalive AS datesendalive_18,
  t0.nivdiw AS nivdiw_19,
  t0.codeassociation AS codeassociation_20,
  t0.versiongensrelay AS versiongensrelay_21,
  t0.typemodule AS typemodule_22,
  t0.datederniereinfoip AS datederniereinfoip_23,
  t0.datederniereinfosms AS datederniereinfosms_24,
  t0.clepublique AS clepublique_25,
  t0.aliveip AS aliveip_26,
  t0.alivesms AS alivesms_27,
  t0.datesendaliveip AS datesendaliveip_28,
  t0.datesendalivesms AS datesendalivesms_29,
  t0.visuel AS visuel_30,
  t0.tempvisuel AS tempvisuel_31,
  t0.dateconf AS dateconf_32,
  t0.usermaj AS usermaj_33,
  t0.datemajutc AS datemajutc_34,
  t0.supprime AS supprime_35,
  t0.connexiongestion AS connexiongestion_36,
  t0.idgestion AS idgestion_37,
  t0.idmaitre AS idmaitre_38,
  t0.idrelay AS idrelay_39,
  t0.modelegenerateur_id AS modelegenerateur_id_40,
  t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41,
  t0.client_id AS client_id_42
FROM
  generateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numserie AS numserie_2, t0.type AS type_3, t0.numwhatsapp AS numwhatsapp_4, t0.pays AS pays_5, t0.site AS site_6, t0.numsim AS numsim_7, t0.datederniereinfo AS datederniereinfo_8, t0.datemiseenservice AS datemiseenservice_9, t0.alive AS alive_10, t0.o2h2 AS o2h2_11, t0.h2r AS h2r_12, t0.comp AS comp_13, t0.nivelec AS nivelec_14, t0.power AS power_15, t0.ximg AS ximg_16, t0.yimg AS yimg_17, t0.datesendalive AS datesendalive_18, t0.nivdiw AS nivdiw_19, t0.codeassociation AS codeassociation_20, t0.versiongensrelay AS versiongensrelay_21, t0.typemodule AS typemodule_22, t0.datederniereinfoip AS datederniereinfoip_23, t0.datederniereinfosms AS datederniereinfosms_24, t0.clepublique AS clepublique_25, t0.aliveip AS aliveip_26, t0.alivesms AS alivesms_27, t0.datesendaliveip AS datesendaliveip_28, t0.datesendalivesms AS datesendalivesms_29, t0.visuel AS visuel_30, t0.tempvisuel AS tempvisuel_31, t0.dateconf AS dateconf_32, t0.usermaj AS usermaj_33, t0.datemajutc AS datemajutc_34, t0.supprime AS supprime_35, t0.connexiongestion AS connexiongestion_36, t0.idgestion AS idgestion_37, t0.idmaitre AS idmaitre_38, t0.idrelay AS idrelay_39, t0.modelegenerateur_id AS modelegenerateur_id_40, t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41, t0.client_id AS client_id_42 FROM generateur t0 WHERE t0.id = '254';

#	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 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.25 ms
(11.87%)

SELECT versionapp, DATE_FORMAT(datemajversion, '%d/%m/%Y %H:%i') AS datemajversion FROM parametre WHERE (supprime = 0 or supprime IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  versionapp,
  DATE_FORMAT(
    datemajversion, '%d/%m/%Y %H:%i'
  ) AS datemajversion
FROM
  parametre
WHERE
  (
    supprime = 0
    or supprime IS NULL
  )

SELECT versionapp, DATE_FORMAT(datemajversion, '%d/%m/%Y %H:%i') AS datemajversion FROM parametre WHERE (supprime = 0 or supprime IS NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 226)
3	App\Controller\DefaultController->__construct (line 24)
4	Container8rgGi2Y\getDefaultControllerService::do (line 547)
5	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 26)
6	Container8rgGi2Y\getApiTicketControllerService::do (line 547)
7	Container8rgGi2Y\App_KernelDevDebugContainer->load (line 229)
8	Symfony\Component\DependencyInjection\Container::make (line 211)
9	Symfony\Component\DependencyInjection\Container->get (line 40)
10	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
11	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
14	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Typeticket	3

Entities Mapping

Class	Mapping errors
App\Entity\Typeticket	No errors.
App\Entity\Generateur	No errors.
App\Entity\Modelegenerateur	No errors.
App\Entity\Typemodulecomgenerateur	No errors.
App\Entity\Client	No errors.
App\Entity\Typeenvoisms	No errors.

Symfony Profiler

POST http://gipv3-gestion.qosinus.com/gestion/ticket/api/get-tickets/254

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping