Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.31 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

4.99 ms

SELECT q0_.id AS id_0, q0_.doc_type AS doc_type_1, q0_.number_prefix AS number_prefix_2, q0_.sequence AS sequence_3, q0_.number_year AS number_year_4, q0_.number AS number_5, q0_.date AS date_6, q0_.validity_days AS validity_days_7, q0_.currency AS currency_8, q0_.conditions AS conditions_9, q0_.discount_pct AS discount_pct_10, q0_.status AS status_11, q0_.sub_total_ht AS sub_total_ht_12, q0_.discount_ht AS discount_ht_13, q0_.sub_total_ht_net AS sub_total_ht_net_14, q0_.vat_total AS vat_total_15, q0_.total_ttc AS total_ttc_16, q0_.discount_mode AS discount_mode_17, q0_.client_company AS client_company_18, q0_.client_contact AS client_contact_19, q0_.client_email AS client_email_20, q0_.client_phone AS client_phone_21, q0_.client_address AS client_address_22, q0_.client_first_name AS client_first_name_23, q0_.client_last_name AS client_last_name_24, q0_.created_at AS created_at_25, q0_.updated_at AS updated_at_26, c1_.id AS id_27, c1_.company_name AS company_name_28, c1_.contact_name AS contact_name_29, c1_.first_name AS first_name_30, c1_.last_name AS last_name_31, c1_.email AS email_32, c1_.phone AS phone_33, c1_.address AS address_34, c1_.created_at AS created_at_35, c1_.updated_at AS updated_at_36, q0_.owner_id AS owner_id_37, q0_.customer_id AS customer_id_38, q0_.doc_template_id AS doc_template_id_39, c1_.owner_id AS owner_id_40 FROM quote q0_ LEFT JOIN customer c1_ ON q0_.customer_id = c1_.id WHERE q0_.owner_id = ? AND q0_.doc_type = ? ORDER BY q0_.date DESC, q0_.id DESC LIMIT 20

Parameters:

[
  null
  "EINVOICE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  q0_.id AS id_0,
  q0_.doc_type AS doc_type_1,
  q0_.number_prefix AS number_prefix_2,
  q0_.sequence AS sequence_3,
  q0_.number_year AS number_year_4,
  q0_.number AS number_5,
  q0_.date AS date_6,
  q0_.validity_days AS validity_days_7,
  q0_.currency AS currency_8,
  q0_.conditions AS conditions_9,
  q0_.discount_pct AS discount_pct_10,
  q0_.status AS status_11,
  q0_.sub_total_ht AS sub_total_ht_12,
  q0_.discount_ht AS discount_ht_13,
  q0_.sub_total_ht_net AS sub_total_ht_net_14,
  q0_.vat_total AS vat_total_15,
  q0_.total_ttc AS total_ttc_16,
  q0_.discount_mode AS discount_mode_17,
  q0_.client_company AS client_company_18,
  q0_.client_contact AS client_contact_19,
  q0_.client_email AS client_email_20,
  q0_.client_phone AS client_phone_21,
  q0_.client_address AS client_address_22,
  q0_.client_first_name AS client_first_name_23,
  q0_.client_last_name AS client_last_name_24,
  q0_.created_at AS created_at_25,
  q0_.updated_at AS updated_at_26,
  c1_.id AS id_27,
  c1_.company_name AS company_name_28,
  c1_.contact_name AS contact_name_29,
  c1_.first_name AS first_name_30,
  c1_.last_name AS last_name_31,
  c1_.email AS email_32,
  c1_.phone AS phone_33,
  c1_.address AS address_34,
  c1_.created_at AS created_at_35,
  c1_.updated_at AS updated_at_36,
  q0_.owner_id AS owner_id_37,
  q0_.customer_id AS customer_id_38,
  q0_.doc_template_id AS doc_template_id_39,
  c1_.owner_id AS owner_id_40
FROM
  quote q0_
  LEFT JOIN customer c1_ ON q0_.customer_id = c1_.id
WHERE
  q0_.owner_id = ?
  AND q0_.doc_type = ?
ORDER BY
  q0_.date DESC,
  q0_.id DESC
LIMIT
  20

SELECT q0_.id AS id_0, q0_.doc_type AS doc_type_1, q0_.number_prefix AS number_prefix_2, q0_.sequence AS sequence_3, q0_.number_year AS number_year_4, q0_.number AS number_5, q0_.date AS date_6, q0_.validity_days AS validity_days_7, q0_.currency AS currency_8, q0_.conditions AS conditions_9, q0_.discount_pct AS discount_pct_10, q0_.status AS status_11, q0_.sub_total_ht AS sub_total_ht_12, q0_.discount_ht AS discount_ht_13, q0_.sub_total_ht_net AS sub_total_ht_net_14, q0_.vat_total AS vat_total_15, q0_.total_ttc AS total_ttc_16, q0_.discount_mode AS discount_mode_17, q0_.client_company AS client_company_18, q0_.client_contact AS client_contact_19, q0_.client_email AS client_email_20, q0_.client_phone AS client_phone_21, q0_.client_address AS client_address_22, q0_.client_first_name AS client_first_name_23, q0_.client_last_name AS client_last_name_24, q0_.created_at AS created_at_25, q0_.updated_at AS updated_at_26, c1_.id AS id_27, c1_.company_name AS company_name_28, c1_.contact_name AS contact_name_29, c1_.first_name AS first_name_30, c1_.last_name AS last_name_31, c1_.email AS email_32, c1_.phone AS phone_33, c1_.address AS address_34, c1_.created_at AS created_at_35, c1_.updated_at AS updated_at_36, q0_.owner_id AS owner_id_37, q0_.customer_id AS customer_id_38, q0_.doc_template_id AS doc_template_id_39, c1_.owner_id AS owner_id_40 FROM quote q0_ LEFT JOIN customer c1_ ON q0_.customer_id = c1_.id WHERE q0_.owner_id = NULL AND q0_.doc_type = 'EINVOICE' ORDER BY q0_.date DESC, q0_.id DESC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 528)
7	App\Controller\QuoteController->facture (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.32 ms

SELECT COUNT(q0_.id) AS sclr_0 FROM quote q0_ WHERE q0_.owner_id = ? AND q0_.doc_type = ?

Parameters:

[
  null
  "EINVOICE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(q0_.id) AS sclr_0
FROM
  quote q0_
WHERE
  q0_.owner_id = ?
  AND q0_.doc_type = ?

SELECT COUNT(q0_.id) AS sclr_0 FROM quote q0_ WHERE q0_.owner_id = NULL AND q0_.doc_type = 'EINVOICE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 541)
8	App\Controller\QuoteController->facture (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\Quote	No errors.
App\Entity\Customer	No errors.
App\Entity\User	The field 'App\Entity\User#photoFile' has the property type 'App\Entity\UploadedFile' that differs from the metadata field type 'string' returned by the 'string' DBAL type. The association App\Entity\User#school refers to the inverse side field App\Entity\School#lessons which does not exist. The association App\Entity\User#currentSchool refers to the inverse side field App\Entity\School#lessons which does not exist. The field App\Entity\User#quotes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Quote#owner does not contain the required 'inversedBy="quotes"' attribute.
App\Entity\DocTemplate	No errors.

Symfony Profiler

GET https://maisonfacture.com/facture

Configuration Settings

Theme