Symfony Profiler

Query Metrics

37 Database Queries

6 Different statements

6.75 ms Query time

0 Invalid entities

54 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.15 ms
(61.57%)

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.message AS message_7, t0.datecrea AS datecrea_8, t0.fromsagim AS fromsagim_9, t0.usermaj AS usermaj_10, t0.datemajutc AS datemajutc_11, t0.supprime AS supprime_12, t0.typeticketmessage_id AS typeticketmessage_id_13, t0.ticket_id AS ticket_id_14 FROM ticketmessage t0 WHERE t0.ticket_id = ? ORDER BY t0.id ASC

Parameters:

[
  168
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idexterne AS idexterne_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.email AS email_5,
  t0.telephone AS telephone_6,
  t0.message AS message_7,
  t0.datecrea AS datecrea_8,
  t0.fromsagim AS fromsagim_9,
  t0.usermaj AS usermaj_10,
  t0.datemajutc AS datemajutc_11,
  t0.supprime AS supprime_12,
  t0.typeticketmessage_id AS typeticketmessage_id_13,
  t0.ticket_id AS ticket_id_14
FROM
  ticketmessage t0
WHERE
  t0.ticket_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.message AS message_7, t0.datecrea AS datecrea_8, t0.fromsagim AS fromsagim_9, t0.usermaj AS usermaj_10, t0.datemajutc AS datemajutc_11, t0.supprime AS supprime_12, t0.typeticketmessage_id AS typeticketmessage_id_13, t0.ticket_id AS ticket_id_14 FROM ticketmessage t0 WHERE t0.ticket_id = 168 ORDER BY t0.id 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 140)
4	Gestion\Controller\TicketController->getTicketsByGenerateur (line 169)
5	Gestion\Controller\ApiTicketController->getTickets (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.73 ms
(10.78%)

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.64 ms
(9.51%)

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.53 ms
(7.81%)

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.objet AS objet_3, t0.datecrea AS datecrea_4, t0.datederniermessage AS datederniermessage_5, t0.datemaj AS datemaj_6, t0.datecloture AS datecloture_7, t0.cloture AS cloture_8, t0.usermaj AS usermaj_9, t0.datemajutc AS datemajutc_10, t0.supprime AS supprime_11, t0.typeticket_id AS typeticket_id_12, t0.utilisateurmaj_id AS utilisateurmaj_id_13, t0.utilisateurcloture_id AS utilisateurcloture_id_14, t0.generateur_id AS generateur_id_15 FROM ticket t0 WHERE t0.generateur_id = ? AND t0.cloture = ? ORDER BY t0.datemaj DESC

Parameters:

[
  102
  "0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idexterne AS idexterne_2,
  t0.objet AS objet_3,
  t0.datecrea AS datecrea_4,
  t0.datederniermessage AS datederniermessage_5,
  t0.datemaj AS datemaj_6,
  t0.datecloture AS datecloture_7,
  t0.cloture AS cloture_8,
  t0.usermaj AS usermaj_9,
  t0.datemajutc AS datemajutc_10,
  t0.supprime AS supprime_11,
  t0.typeticket_id AS typeticket_id_12,
  t0.utilisateurmaj_id AS utilisateurmaj_id_13,
  t0.utilisateurcloture_id AS utilisateurcloture_id_14,
  t0.generateur_id AS generateur_id_15
FROM
  ticket t0
WHERE
  t0.generateur_id = ?
  AND t0.cloture = ?
ORDER BY
  t0.datemaj DESC

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.objet AS objet_3, t0.datecrea AS datecrea_4, t0.datederniermessage AS datederniermessage_5, t0.datemaj AS datemaj_6, t0.datecloture AS datecloture_7, t0.cloture AS cloture_8, t0.usermaj AS usermaj_9, t0.datemajutc AS datemajutc_10, t0.supprime AS supprime_11, t0.typeticket_id AS typeticket_id_12, t0.utilisateurmaj_id AS utilisateurmaj_id_13, t0.utilisateurcloture_id AS utilisateurcloture_id_14, t0.generateur_id AS generateur_id_15 FROM ticket t0 WHERE t0.generateur_id = 102 AND t0.cloture = '0' ORDER BY t0.datemaj DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 124)
4	Gestion\Controller\TicketController->getTicketsByGenerateur (line 169)
5	Gestion\Controller\ApiTicketController->getTickets (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.51 ms
(7.59%)

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:

[
  "102"
]

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 = '102';

#	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.19 ms
(2.74%)

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\Ticket	28
App\Entity\Ticketmessage	17
App\Entity\Typeticket	3
App\Entity\User	2
App\Entity\Generateur	1
App\Entity\Modelegenerateur	1
App\Entity\Typemodulecomgenerateur	1
App\Entity\Client	1

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\Ticket	No errors.
App\Entity\User	No errors.
App\Entity\Ticketmessage	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping