Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.90 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.27 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.deleted_at AS deleted_at_7, t0.expired_at AS expired_at_8, t0.certification_type AS certification_type_9, t0.source AS source_10, t0.birthday AS birthday_11, t0.city AS city_12, t0.province AS province_13, t0.address AS address_14, t0.intro AS intro_15, t0.visit_count AS visit_count_16, t0.last_time AS last_time_17, t0.last_ip AS last_ip_18, t0.identify_code AS identify_code_19, t0.mobile AS mobile_20, t0.start_agent AS start_agent_21, t0.end_agent AS end_agent_22, t0.balance AS balance_23, t0.realname AS realname_24, t0.avatar AS avatar_25, t0.wxopenid AS wxopenid_26, t0.wxsession AS wxsession_27, t0.token AS token_28, t0.is_poper AS is_poper_29, t0.idno AS idno_30, t0.give_balance AS give_balance_31, t0.enterprise_name AS enterprise_name_32, t0.subs AS subs_33, t0.company_identify AS company_identify_34, t0.tui_balance AS tui_balance_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.status AS status_38, t0.level_id AS level_id_39, t0.pid_id AS pid_id_40, t0.belong_id AS belong_id_41, t0.charge_grade_id AS charge_grade_id_42, t0.organ_id AS organ_id_43, t0.area_id AS area_id_44, t0.id_front_id AS id_front_id_45, t0.id_back_id AS id_back_id_46, t0.mccimage_id AS mccimage_id_47 FROM user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "18221760346"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.is_verified AS is_verified_6,
  t0.deleted_at AS deleted_at_7,
  t0.expired_at AS expired_at_8,
  t0.certification_type AS certification_type_9,
  t0.source AS source_10,
  t0.birthday AS birthday_11,
  t0.city AS city_12,
  t0.province AS province_13,
  t0.address AS address_14,
  t0.intro AS intro_15,
  t0.visit_count AS visit_count_16,
  t0.last_time AS last_time_17,
  t0.last_ip AS last_ip_18,
  t0.identify_code AS identify_code_19,
  t0.mobile AS mobile_20,
  t0.start_agent AS start_agent_21,
  t0.end_agent AS end_agent_22,
  t0.balance AS balance_23,
  t0.realname AS realname_24,
  t0.avatar AS avatar_25,
  t0.wxopenid AS wxopenid_26,
  t0.wxsession AS wxsession_27,
  t0.token AS token_28,
  t0.is_poper AS is_poper_29,
  t0.idno AS idno_30,
  t0.give_balance AS give_balance_31,
  t0.enterprise_name AS enterprise_name_32,
  t0.subs AS subs_33,
  t0.company_identify AS company_identify_34,
  t0.tui_balance AS tui_balance_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.status AS status_38,
  t0.level_id AS level_id_39,
  t0.pid_id AS pid_id_40,
  t0.belong_id AS belong_id_41,
  t0.charge_grade_id AS charge_grade_id_42,
  t0.organ_id AS organ_id_43,
  t0.area_id AS area_id_44,
  t0.id_front_id AS id_front_id_45,
  t0.id_back_id AS id_back_id_46,
  t0.mccimage_id AS mccimage_id_47
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.deleted_at AS deleted_at_7, t0.expired_at AS expired_at_8, t0.certification_type AS certification_type_9, t0.source AS source_10, t0.birthday AS birthday_11, t0.city AS city_12, t0.province AS province_13, t0.address AS address_14, t0.intro AS intro_15, t0.visit_count AS visit_count_16, t0.last_time AS last_time_17, t0.last_ip AS last_ip_18, t0.identify_code AS identify_code_19, t0.mobile AS mobile_20, t0.start_agent AS start_agent_21, t0.end_agent AS end_agent_22, t0.balance AS balance_23, t0.realname AS realname_24, t0.avatar AS avatar_25, t0.wxopenid AS wxopenid_26, t0.wxsession AS wxsession_27, t0.token AS token_28, t0.is_poper AS is_poper_29, t0.idno AS idno_30, t0.give_balance AS give_balance_31, t0.enterprise_name AS enterprise_name_32, t0.subs AS subs_33, t0.company_identify AS company_identify_34, t0.tui_balance AS tui_balance_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.status AS status_38, t0.level_id AS level_id_39, t0.pid_id AS pid_id_40, t0.belong_id AS belong_id_41, t0.charge_grade_id AS charge_grade_id_42, t0.organ_id AS organ_id_43, t0.area_id AS area_id_44, t0.id_front_id AS id_front_id_45, t0.id_back_id AS id_back_id_46, t0.mccimage_id AS mccimage_id_47 FROM user t0 WHERE t0.username = '18221760346' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 251)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 132)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.63 ms

SELECT u0_.id AS id_0, u0_.user_type AS user_type_1, u0_.withdraw_no AS withdraw_no_2, u0_.batch_no AS batch_no_3, u0_.realname AS realname_4, u0_.mobile AS mobile_5, u0_.account_number AS account_number_6, u0_.account_type AS account_type_7, u0_.account_type_name AS account_type_name_8, u0_.bank_name AS bank_name_9, u0_.bank_branch AS bank_branch_10, u0_.identity_card AS identity_card_11, u0_.identity_card_front AS identity_card_front_12, u0_.identity_card_back AS identity_card_back_13, u0_.cash AS cash_14, u0_.memo AS memo_15, u0_.transfer_type AS transfer_type_16, u0_.transfer_name AS transfer_name_17, u0_.transfer_money AS transfer_money_18, u0_.transfer_remark AS transfer_remark_19, u0_.transfer_no AS transfer_no_20, u0_.transfer_account_no AS transfer_account_no_21, u0_.transfer_result AS transfer_result_22, u0_.transfer_time AS transfer_time_23, u0_.transfer_status AS transfer_status_24, u0_.payment_time AS payment_time_25, u0_.audit_time AS audit_time_26, u0_.service_charge AS service_charge_27, u0_.service_charge_rate AS service_charge_rate_28, u0_.service_charge_single AS service_charge_single_29, u0_.service_charge_total AS service_charge_total_30, u0_.refusal_cause AS refusal_cause_31, u0_.notify_url AS notify_url_32, u0_.resp AS resp_33, u0_.created_at AS created_at_34, u0_.updated_at AS updated_at_35, u0_.status AS status_36, u0_.user_id AS user_id_37, u0_.transfer_file_id AS transfer_file_id_38 FROM user_withdraw u0_ WHERE u0_.user_id = ? ORDER BY u0_.id ASC LIMIT 10

Parameters:

[
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.user_type AS user_type_1,
  u0_.withdraw_no AS withdraw_no_2,
  u0_.batch_no AS batch_no_3,
  u0_.realname AS realname_4,
  u0_.mobile AS mobile_5,
  u0_.account_number AS account_number_6,
  u0_.account_type AS account_type_7,
  u0_.account_type_name AS account_type_name_8,
  u0_.bank_name AS bank_name_9,
  u0_.bank_branch AS bank_branch_10,
  u0_.identity_card AS identity_card_11,
  u0_.identity_card_front AS identity_card_front_12,
  u0_.identity_card_back AS identity_card_back_13,
  u0_.cash AS cash_14,
  u0_.memo AS memo_15,
  u0_.transfer_type AS transfer_type_16,
  u0_.transfer_name AS transfer_name_17,
  u0_.transfer_money AS transfer_money_18,
  u0_.transfer_remark AS transfer_remark_19,
  u0_.transfer_no AS transfer_no_20,
  u0_.transfer_account_no AS transfer_account_no_21,
  u0_.transfer_result AS transfer_result_22,
  u0_.transfer_time AS transfer_time_23,
  u0_.transfer_status AS transfer_status_24,
  u0_.payment_time AS payment_time_25,
  u0_.audit_time AS audit_time_26,
  u0_.service_charge AS service_charge_27,
  u0_.service_charge_rate AS service_charge_rate_28,
  u0_.service_charge_single AS service_charge_single_29,
  u0_.service_charge_total AS service_charge_total_30,
  u0_.refusal_cause AS refusal_cause_31,
  u0_.notify_url AS notify_url_32,
  u0_.resp AS resp_33,
  u0_.created_at AS created_at_34,
  u0_.updated_at AS updated_at_35,
  u0_.status AS status_36,
  u0_.user_id AS user_id_37,
  u0_.transfer_file_id AS transfer_file_id_38
FROM
  user_withdraw u0_
WHERE
  u0_.user_id = ?
ORDER BY
  u0_.id ASC
LIMIT
  10

SELECT u0_.id AS id_0, u0_.user_type AS user_type_1, u0_.withdraw_no AS withdraw_no_2, u0_.batch_no AS batch_no_3, u0_.realname AS realname_4, u0_.mobile AS mobile_5, u0_.account_number AS account_number_6, u0_.account_type AS account_type_7, u0_.account_type_name AS account_type_name_8, u0_.bank_name AS bank_name_9, u0_.bank_branch AS bank_branch_10, u0_.identity_card AS identity_card_11, u0_.identity_card_front AS identity_card_front_12, u0_.identity_card_back AS identity_card_back_13, u0_.cash AS cash_14, u0_.memo AS memo_15, u0_.transfer_type AS transfer_type_16, u0_.transfer_name AS transfer_name_17, u0_.transfer_money AS transfer_money_18, u0_.transfer_remark AS transfer_remark_19, u0_.transfer_no AS transfer_no_20, u0_.transfer_account_no AS transfer_account_no_21, u0_.transfer_result AS transfer_result_22, u0_.transfer_time AS transfer_time_23, u0_.transfer_status AS transfer_status_24, u0_.payment_time AS payment_time_25, u0_.audit_time AS audit_time_26, u0_.service_charge AS service_charge_27, u0_.service_charge_rate AS service_charge_rate_28, u0_.service_charge_single AS service_charge_single_29, u0_.service_charge_total AS service_charge_total_30, u0_.refusal_cause AS refusal_cause_31, u0_.notify_url AS notify_url_32, u0_.resp AS resp_33, u0_.created_at AS created_at_34, u0_.updated_at AS updated_at_35, u0_.status AS status_36, u0_.user_id AS user_id_37, u0_.transfer_file_id AS transfer_file_id_38 FROM user_withdraw u0_ WHERE u0_.user_id = 91 ORDER BY u0_.id ASC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 57)
7	App\Repository\UserWithdrawRepository->findLogsByUser (line 363)
8	App\Controller\Apin\ApinController->getPersonalTixianLog (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)

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\User	The association App\Entity\User#userBankcards refers to the owning side field App\Entity\UserBankcard#Owner which does not exist.
App\Entity\UserLevel	No errors.
App\Entity\Belong	No errors.
App\Entity\ChargeGrade	No errors.
App\Entity\Area	No errors.
App\Entity\FileManaged	No errors.
App\Entity\UserAddress	No errors.
App\Entity\Comment	No errors.
App\Entity\Node	No errors.
App\Entity\Invest	No errors.
App\Entity\UserBankcard	The mappings App\Entity\UserBankcard#owner and App\Entity\User#userBankcards are inconsistent with each other.
App\Entity\UserWithdraw	No errors.

Symfony Profiler

GET https://www.ctidca.com/api/personalTixianLog?month=12

Configuration Settings

Theme