Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

9.87 ms Query time

0 Invalid entities

5 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

4.31 ms
(43.61%)

SELECT t0.id AS id_1, t0.siret AS siret_2, t0.name AS name_3, t0.trade_name AS trade_name_4, t0.iban AS iban_5, t0.tva_number AS tva_number_6, t0.created_at AS created_at_7, t0.email AS email_8, t0.logo AS logo_9, t0.phone AS phone_10, t0.bic AS bic_11, t0.price AS price_12, t0.price_no_decla AS price_no_decla_13, t0.stripe_id AS stripe_id_14, t0.jeton AS jeton_15, t0.is_supplier AS is_supplier_16, t0.is_prospect AS is_prospect_17, t0.is_active AS is_active_18, t0.comment AS comment_19, t0.invoice_number_prefix AS invoice_number_prefix_20, t0.invoice_number_start_counter AS invoice_number_start_counter_21, t0.invoice_number_reset_counter AS invoice_number_reset_counter_22, t0.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23, t0.quotation_number_prefix AS quotation_number_prefix_24, t0.quotation_number_start_counter AS quotation_number_start_counter_25, t0.quotation_number_reset_counter AS quotation_number_reset_counter_26, t0.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27, t0.is_no_same_number AS is_no_same_number_28, t0.credit_number_prefix AS credit_number_prefix_29, t0.lat AS lat_30, t0.lng AS lng_31, t0.identite_recto AS identite_recto_32, t0.identite_verso AS identite_verso_33, t0.kbis AS kbis_34, t0.rib AS rib_35, t0.unsubmit_tva AS unsubmit_tva_36, t0.supplier_hello_glass AS supplier_hello_glass_37, t0.ape AS ape_38, t0.difficulty AS difficulty_39, t0.stripe_tax_rate_id AS stripe_tax_rate_id_40, t0.tax_rate AS tax_rate_41, t0.clearbus AS clearbus_42, t0.morning_start AS morning_start_43, t0.morning_end AS morning_end_44, t0.afternoon_start AS afternoon_start_45, t0.afternoon_end AS afternoon_end_46, t0.morning_saturday_start AS morning_saturday_start_47, t0.morning_saturday_end AS morning_saturday_end_48, t0.afternoon_saturday_start AS afternoon_saturday_start_49, t0.afternoon_saturday_end AS afternoon_saturday_end_50, t0.prime AS prime_51, t0.verso_invoice AS verso_invoice_52, t0.charge_folder AS charge_folder_53, t0.comment_update AS comment_update_54, t0.known_name AS known_name_55, t0.gifts AS gifts_56, t0.customer_authorisation AS customer_authorisation_57, t0.garage_type AS garage_type_58, t0.contractual_franchise AS contractual_franchise_59, t0.other_authorisation AS other_authorisation_60, t0.other_gifts AS other_gifts_61, t0.blocked AS blocked_62, t0.id_garage AS id_garage_63, t0.email_api AS email_api_64, t0.paid_date_day AS paid_date_day_65, t0.payment_method AS payment_method_66, t0.acquisition_source AS acquisition_source_67, t0.acquisition_source_detail AS acquisition_source_detail_68, t0.is_premium AS is_premium_69, t0.legal_form AS legal_form_70, t0.tax_regime AS tax_regime_71, t0.share_capital AS share_capital_72, t0.rcs AS rcs_73, t0.terms_and_conditions_file AS terms_and_conditions_file_74, t0.apply_terms_for_invoice AS apply_terms_for_invoice_75, t0.apply_terms_for_quote AS apply_terms_for_quote_76, t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_77, t0.hubspot_id AS hubspot_id_78, t0.supplier_id AS supplier_id_79, t0.commercial_id AS commercial_id_80, t0.category_id AS category_id_81, t0.configuration_id AS configuration_id_82, t0.bridge_user_id AS bridge_user_id_83, t0.franchise_id AS franchise_id_84, t0.franchise_supplier_id AS franchise_supplier_id_85, t86.id AS id_87, t86.provider AS provider_88, t86.email AS email_89, t86.access_token AS access_token_90, t86.refresh_token AS refresh_token_91, t86.token_expires_at AS token_expires_at_92, t86.company_id AS company_id_93 FROM companie t0 LEFT JOIN email_credential t86 ON t86.company_id = t0.id WHERE t0.id = ?

Parameters:

[
  864
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.siret AS siret_2,
  t0.name AS name_3,
  t0.trade_name AS trade_name_4,
  t0.iban AS iban_5,
  t0.tva_number AS tva_number_6,
  t0.created_at AS created_at_7,
  t0.email AS email_8,
  t0.logo AS logo_9,
  t0.phone AS phone_10,
  t0.bic AS bic_11,
  t0.price AS price_12,
  t0.price_no_decla AS price_no_decla_13,
  t0.stripe_id AS stripe_id_14,
  t0.jeton AS jeton_15,
  t0.is_supplier AS is_supplier_16,
  t0.is_prospect AS is_prospect_17,
  t0.is_active AS is_active_18,
  t0.comment AS comment_19,
  t0.invoice_number_prefix AS invoice_number_prefix_20,
  t0.invoice_number_start_counter AS invoice_number_start_counter_21,
  t0.invoice_number_reset_counter AS invoice_number_reset_counter_22,
  t0.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23,
  t0.quotation_number_prefix AS quotation_number_prefix_24,
  t0.quotation_number_start_counter AS quotation_number_start_counter_25,
  t0.quotation_number_reset_counter AS quotation_number_reset_counter_26,
  t0.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27,
  t0.is_no_same_number AS is_no_same_number_28,
  t0.credit_number_prefix AS credit_number_prefix_29,
  t0.lat AS lat_30,
  t0.lng AS lng_31,
  t0.identite_recto AS identite_recto_32,
  t0.identite_verso AS identite_verso_33,
  t0.kbis AS kbis_34,
  t0.rib AS rib_35,
  t0.unsubmit_tva AS unsubmit_tva_36,
  t0.supplier_hello_glass AS supplier_hello_glass_37,
  t0.ape AS ape_38,
  t0.difficulty AS difficulty_39,
  t0.stripe_tax_rate_id AS stripe_tax_rate_id_40,
  t0.tax_rate AS tax_rate_41,
  t0.clearbus AS clearbus_42,
  t0.morning_start AS morning_start_43,
  t0.morning_end AS morning_end_44,
  t0.afternoon_start AS afternoon_start_45,
  t0.afternoon_end AS afternoon_end_46,
  t0.morning_saturday_start AS morning_saturday_start_47,
  t0.morning_saturday_end AS morning_saturday_end_48,
  t0.afternoon_saturday_start AS afternoon_saturday_start_49,
  t0.afternoon_saturday_end AS afternoon_saturday_end_50,
  t0.prime AS prime_51,
  t0.verso_invoice AS verso_invoice_52,
  t0.charge_folder AS charge_folder_53,
  t0.comment_update AS comment_update_54,
  t0.known_name AS known_name_55,
  t0.gifts AS gifts_56,
  t0.customer_authorisation AS customer_authorisation_57,
  t0.garage_type AS garage_type_58,
  t0.contractual_franchise AS contractual_franchise_59,
  t0.other_authorisation AS other_authorisation_60,
  t0.other_gifts AS other_gifts_61,
  t0.blocked AS blocked_62,
  t0.id_garage AS id_garage_63,
  t0.email_api AS email_api_64,
  t0.paid_date_day AS paid_date_day_65,
  t0.payment_method AS payment_method_66,
  t0.acquisition_source AS acquisition_source_67,
  t0.acquisition_source_detail AS acquisition_source_detail_68,
  t0.is_premium AS is_premium_69,
  t0.legal_form AS legal_form_70,
  t0.tax_regime AS tax_regime_71,
  t0.share_capital AS share_capital_72,
  t0.rcs AS rcs_73,
  t0.terms_and_conditions_file AS terms_and_conditions_file_74,
  t0.apply_terms_for_invoice AS apply_terms_for_invoice_75,
  t0.apply_terms_for_quote AS apply_terms_for_quote_76,
  t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_77,
  t0.hubspot_id AS hubspot_id_78,
  t0.supplier_id AS supplier_id_79,
  t0.commercial_id AS commercial_id_80,
  t0.category_id AS category_id_81,
  t0.configuration_id AS configuration_id_82,
  t0.bridge_user_id AS bridge_user_id_83,
  t0.franchise_id AS franchise_id_84,
  t0.franchise_supplier_id AS franchise_supplier_id_85,
  t86.id AS id_87,
  t86.provider AS provider_88,
  t86.email AS email_89,
  t86.access_token AS access_token_90,
  t86.refresh_token AS refresh_token_91,
  t86.token_expires_at AS token_expires_at_92,
  t86.company_id AS company_id_93
FROM
  companie t0
  LEFT JOIN email_credential t86 ON t86.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.siret AS siret_2, t0.name AS name_3, t0.trade_name AS trade_name_4, t0.iban AS iban_5, t0.tva_number AS tva_number_6, t0.created_at AS created_at_7, t0.email AS email_8, t0.logo AS logo_9, t0.phone AS phone_10, t0.bic AS bic_11, t0.price AS price_12, t0.price_no_decla AS price_no_decla_13, t0.stripe_id AS stripe_id_14, t0.jeton AS jeton_15, t0.is_supplier AS is_supplier_16, t0.is_prospect AS is_prospect_17, t0.is_active AS is_active_18, t0.comment AS comment_19, t0.invoice_number_prefix AS invoice_number_prefix_20, t0.invoice_number_start_counter AS invoice_number_start_counter_21, t0.invoice_number_reset_counter AS invoice_number_reset_counter_22, t0.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23, t0.quotation_number_prefix AS quotation_number_prefix_24, t0.quotation_number_start_counter AS quotation_number_start_counter_25, t0.quotation_number_reset_counter AS quotation_number_reset_counter_26, t0.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27, t0.is_no_same_number AS is_no_same_number_28, t0.credit_number_prefix AS credit_number_prefix_29, t0.lat AS lat_30, t0.lng AS lng_31, t0.identite_recto AS identite_recto_32, t0.identite_verso AS identite_verso_33, t0.kbis AS kbis_34, t0.rib AS rib_35, t0.unsubmit_tva AS unsubmit_tva_36, t0.supplier_hello_glass AS supplier_hello_glass_37, t0.ape AS ape_38, t0.difficulty AS difficulty_39, t0.stripe_tax_rate_id AS stripe_tax_rate_id_40, t0.tax_rate AS tax_rate_41, t0.clearbus AS clearbus_42, t0.morning_start AS morning_start_43, t0.morning_end AS morning_end_44, t0.afternoon_start AS afternoon_start_45, t0.afternoon_end AS afternoon_end_46, t0.morning_saturday_start AS morning_saturday_start_47, t0.morning_saturday_end AS morning_saturday_end_48, t0.afternoon_saturday_start AS afternoon_saturday_start_49, t0.afternoon_saturday_end AS afternoon_saturday_end_50, t0.prime AS prime_51, t0.verso_invoice AS verso_invoice_52, t0.charge_folder AS charge_folder_53, t0.comment_update AS comment_update_54, t0.known_name AS known_name_55, t0.gifts AS gifts_56, t0.customer_authorisation AS customer_authorisation_57, t0.garage_type AS garage_type_58, t0.contractual_franchise AS contractual_franchise_59, t0.other_authorisation AS other_authorisation_60, t0.other_gifts AS other_gifts_61, t0.blocked AS blocked_62, t0.id_garage AS id_garage_63, t0.email_api AS email_api_64, t0.paid_date_day AS paid_date_day_65, t0.payment_method AS payment_method_66, t0.acquisition_source AS acquisition_source_67, t0.acquisition_source_detail AS acquisition_source_detail_68, t0.is_premium AS is_premium_69, t0.legal_form AS legal_form_70, t0.tax_regime AS tax_regime_71, t0.share_capital AS share_capital_72, t0.rcs AS rcs_73, t0.terms_and_conditions_file AS terms_and_conditions_file_74, t0.apply_terms_for_invoice AS apply_terms_for_invoice_75, t0.apply_terms_for_quote AS apply_terms_for_quote_76, t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_77, t0.hubspot_id AS hubspot_id_78, t0.supplier_id AS supplier_id_79, t0.commercial_id AS commercial_id_80, t0.category_id AS category_id_81, t0.configuration_id AS configuration_id_82, t0.bridge_user_id AS bridge_user_id_83, t0.franchise_id AS franchise_id_84, t0.franchise_supplier_id AS franchise_supplier_id_85, t86.id AS id_87, t86.provider AS provider_88, t86.email AS email_89, t86.access_token AS access_token_90, t86.refresh_token AS refresh_token_91, t86.token_expires_at AS token_expires_at_92, t86.company_id AS company_id_93 FROM companie t0 LEFT JOIN email_credential t86 ON t86.company_id = t0.id WHERE t0.id = 864;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\EventSubscriber\CompanyIdSubscriber->onKernelRequest (line 66)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

4.27 ms
(43.30%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "poseuradmin@reseauglass.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.firstname AS firstname_6,
  t0.name AS name_7,
  t0.is_active AS is_active_8,
  t0.partenaire AS partenaire_9,
  t0.last_login AS last_login_10,
  t0.is_ready AS is_ready_11,
  t0.referent AS referent_12,
  t0.difficulty AS difficulty_13,
  t0.is_premium AS is_premium_14,
  t0.is_gold AS is_gold_15,
  t0.tokens_invalidated_at AS tokens_invalidated_at_16,
  t0.hubspot_id AS hubspot_id_17,
  t0.service_id AS service_id_18,
  t0.notif_configuration_id AS notif_configuration_id_19,
  t0.mail_configuration_id AS mail_configuration_id_20
FROM
  admin t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.email = 'poseuradmin@reseauglass.fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	App\Security\CookieJwtAuthenticator->{closure:App\Security\CookieJwtAuthenticator::authenticate():53} (line 55)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.29 ms
(13.09%)

SELECT p0_.name AS name_0, p0_.id AS id_1, p0_.price AS price_2, p0_.product_code AS product_code_3 FROM product p0_ WHERE p0_.disabled = ? AND p0_.companie_id IN (?) AND LOWER(p0_.name) LIKE ?

Parameters:

[
  0
  864
  "%p%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.name AS name_0,
  p0_.id AS id_1,
  p0_.price AS price_2,
  p0_.product_code AS product_code_3
FROM
  product p0_
WHERE
  p0_.disabled = ?
  AND p0_.companie_id IN (?)
  AND LOWER(p0_.name) LIKE ?

SELECT p0_.name AS name_0, p0_.id AS id_1, p0_.price AS price_2, p0_.product_code AS product_code_3 FROM product p0_ WHERE p0_.disabled = 0 AND p0_.companie_id IN (864) AND LOWER(p0_.name) LIKE '%p%';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\API\ProductController->searchProduct (line 319)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Admin	2
App\Entity\Company	1
App\Entity\Configuration	1
App\Entity\BridgeUser	1

Entities Mapping

Class	Mapping errors
App\Entity\Admin	No errors.
App\Entity\AgentService	No errors.
App\Entity\Configuration	No errors.
App\Entity\Folder	No errors.
App\Entity\Jeton	No errors.
App\Entity\Task	No errors.
App\Entity\Stock	No errors.
App\Entity\Recovery	No errors.
App\Entity\Company	No errors.
App\Entity\HistoryActionAgent	No errors.
App\Entity\Message	No errors.
App\Entity\ContactAccessLog	No errors.
App\Entity\Technician	No errors.
App\Entity\UserCompany	No errors.
App\Entity\InfoGlobalRead	No errors.
App\Entity\InfoGLobalHistory	No errors.
App\Entity\Category	No errors.
App\Entity\BridgeUser	No errors.
App\Entity\Franchise	No errors.
App\Entity\EmailCredential	No errors.
App\Entity\Address	No errors.
App\Entity\Payment	No errors.
App\Entity\Expense	No errors.
App\Entity\MessageTemplate	No errors.
App\Entity\Invoice	No errors.
App\Entity\Quotation	No errors.
App\Entity\PurchaseOrder	No errors.
App\Entity\Product	No errors.
App\Entity\Status	No errors.
App\Entity\Contact	No errors.
App\Entity\Department	No errors.
App\Entity\Known	No errors.

Symfony Profiler

POST https://preprod.reseauglass.fr/api/product/search

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping