Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

15.34 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.36 ms

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 45)
4	App\Service\Cron\DdeDevisService->addDdeDevis (line 23)
5	App\Controller\Cron\DdeDevisController->cronAddDdeDevis (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)

1.92 ms

INSERT INTO demande_devis (old_id, country, id_client, old_id_client, prenom, nom, adresse, adresse_facturation, id_ville, old_id_ville, ville, cp, ville_client, cp_client, type_client, solution, service, detail_service, id_service, old_id_service, id_detail_service, old_id_detail_service, surface, frequence, email, tel, nbr_update_tel, ind_treat_tel_inter, mobile_token, mobile_send_token, mobile_validated, client_token, description, nbr_artisans_potentiel, note, commission_initiale_ht, commission_speciale, commission_reduite, sans_commission, token, token_sms_client, cgus, newsletter, validated, creation_date, relancee, date_initiale, token_relance, source, tc, published, date_publication, service_plus, en_attente, nouvelle_pj, archived, classified, relancee_a, relancee_de, m_devis, prospection_automatique, nbr_prospections, nbr_prosp_total, nbr_prosp_ouvert, nbr_connexions, nbr_sms_envoy, nbr_sms_ouvert, ind_nbr_prop_conn_sms, ind_edit_vd) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  23704
  "france"
  0
  19694
  ""
  ""
  "37 avenue du Grand Clos"
  ""
  0
  611
  ""
  ""
  "105"
  ""
  "particulier"
  "nettoyage"
  "maison_appartement"
  ""
  0
  8
  0
  0
  "146"
  "une_seule_fois"
  ""
  "+33687924203"
  0
  0
  "721356"
  1
  1
  "zuRYuaF4dgJvlY8VL37ChOzY2Vwen_qr"
  """
    Suite à des travaux dans la maison \r\n
     8 pièces : 5 chambres, 1 cuisine, 1 salon séjour, 1 salle d'eau, 1 wc.\r\n
    1 escalier intérieur\r\n
    Nature des travaux demandés: Nettoyage des vitres, aspiration et lavages des sols, nettoyage et désinfection des sanitaires et salle d'eau, cirage du parquet dans le salon séjour et dans une chambre 
    """
  35
  ""
  14.4
  0.0
  0.0
  0
  ""
  "iywCPS"
  0
  0
  0
  "2023-06-26 10:18:34"
  0
  "2023-06-26 10:18:34"
  null
  "relancee"
  0
  1
  null
  0
  1
  0
  0
  0
  0
  23630
  "730.00"
  1
  50
  52
  16
  7
  0
  0
  1
  0
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO demande_devis (
  old_id, country, id_client, old_id_client,
  prenom, nom, adresse, adresse_facturation,
  id_ville, old_id_ville, ville, cp,
  ville_client, cp_client, type_client,
  solution, service, detail_service,
  id_service, old_id_service, id_detail_service,
  old_id_detail_service, surface,
  frequence, email, tel, nbr_update_tel,
  ind_treat_tel_inter, mobile_token,
  mobile_send_token, mobile_validated,
  client_token, description, nbr_artisans_potentiel,
  note, commission_initiale_ht, commission_speciale,
  commission_reduite, sans_commission,
  token, token_sms_client, cgus, newsletter,
  validated, creation_date, relancee,
  date_initiale, token_relance, source,
  tc, published, date_publication,
  service_plus, en_attente, nouvelle_pj,
  archived, classified, relancee_a,
  relancee_de, m_devis, prospection_automatique,
  nbr_prospections, nbr_prosp_total,
  nbr_prosp_ouvert, nbr_connexions,
  nbr_sms_envoy, nbr_sms_ouvert, ind_nbr_prop_conn_sms,
  ind_edit_vd
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO demande_devis (old_id, country, id_client, old_id_client, prenom, nom, adresse, adresse_facturation, id_ville, old_id_ville, ville, cp, ville_client, cp_client, type_client, solution, service, detail_service, id_service, old_id_service, id_detail_service, old_id_detail_service, surface, frequence, email, tel, nbr_update_tel, ind_treat_tel_inter, mobile_token, mobile_send_token, mobile_validated, client_token, description, nbr_artisans_potentiel, note, commission_initiale_ht, commission_speciale, commission_reduite, sans_commission, token, token_sms_client, cgus, newsletter, validated, creation_date, relancee, date_initiale, token_relance, source, tc, published, date_publication, service_plus, en_attente, nouvelle_pj, archived, classified, relancee_a, relancee_de, m_devis, prospection_automatique, nbr_prospections, nbr_prosp_total, nbr_prosp_ouvert, nbr_connexions, nbr_sms_envoy, nbr_sms_ouvert, ind_nbr_prop_conn_sms, ind_edit_vd) VALUES (23704, 'france', 0, 19694, '', '', '37 avenue du Grand Clos', '', 0, 611, '', '', '105', '', 'particulier', 'nettoyage', 'maison_appartement', '', 0, 8, 0, 0, '146', 'une_seule_fois', '', '+33687924203', 0, 0, '721356', 1, 1, 'zuRYuaF4dgJvlY8VL37ChOzY2Vwen_qr', 'Suite à des travaux dans la maison 
 8 pièces : 5 chambres, 1 cuisine, 1 salon séjour, 1 salle d\'eau, 1 wc.
1 escalier intérieur
Nature des travaux demandés: Nettoyage des vitres, aspiration et lavages des sols, nettoyage et désinfection des sanitaires et salle d\'eau, cirage du parquet dans le salon séjour et dans une chambre ', 35, '', 14.4, 0, 0, 0, '', 'iywCPS', 0, 0, 0, '2023-06-26 10:18:34', 0, '2023-06-26 10:18:34', NULL, 'relancee', 0, 1, NULL, 0, 1, 0, 0, 0, 0, 23630, '730.00', 1, 50, 52, 16, 7, 0, 0, 1, 0);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 45)
7	App\Service\Cron\DdeDevisService->addDdeDevis (line 23)
8	App\Controller\Cron\DdeDevisController->cronAddDdeDevis (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

12.26 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 45)
5	App\Service\Cron\DdeDevisService->addDdeDevis (line 23)
6	App\Controller\Cron\DdeDevisController->cronAddDdeDevis (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.79 ms

SELECT * FROM demande_devis WHERE id = 27071

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  demande_devis
WHERE
  id = 27071

SELECT * FROM demande_devis WHERE id = 27071;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 25)
3	App\Service\Cron\DdeDevisService->getDdeDevis (line 24)
4	App\Controller\Cron\DdeDevisController->cronAddDdeDevis (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\DemandeDevis	No errors.

Symfony Profiler

POST https://api.cleanolia.fr/cron/add-dde-devis

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping