Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.55 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.28 ms
(50.28%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.idno AS idno_4, t0.type AS type_5, t0.resp AS resp_6, t0.order_no AS order_no_7, t0.pay_no AS pay_no_8, t0.payment_state AS payment_state_9, t0.payment_type AS payment_type_10, t0.order_money AS order_money_11, t0.pay_time AS pay_time_12, t0.refund_order AS refund_order_13, t0.minites AS minites_14, t0.resin AS resin_15, t0.payres AS payres_16, t0.organ_order_money AS organ_order_money_17, t0.is_jie AS is_jie_18, t0.inter_fee_cost AS inter_fee_cost_19, t0.organ_inter_fee_cost AS organ_inter_fee_cost_20, t0.inter_fee_price AS inter_fee_price_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.status AS status_24, t0.owner_id AS owner_id_25, t0.inter_fee_id AS inter_fee_id_26, t0.invite_user_id AS invite_user_id_27, t0.organ_inter_fee_id AS organ_inter_fee_id_28 FROM invest t0 WHERE t0.id = ?

Parameters:

[
  "222"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.idno AS idno_4,
  t0.type AS type_5,
  t0.resp AS resp_6,
  t0.order_no AS order_no_7,
  t0.pay_no AS pay_no_8,
  t0.payment_state AS payment_state_9,
  t0.payment_type AS payment_type_10,
  t0.order_money AS order_money_11,
  t0.pay_time AS pay_time_12,
  t0.refund_order AS refund_order_13,
  t0.minites AS minites_14,
  t0.resin AS resin_15,
  t0.payres AS payres_16,
  t0.organ_order_money AS organ_order_money_17,
  t0.is_jie AS is_jie_18,
  t0.inter_fee_cost AS inter_fee_cost_19,
  t0.organ_inter_fee_cost AS organ_inter_fee_cost_20,
  t0.inter_fee_price AS inter_fee_price_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.status AS status_24,
  t0.owner_id AS owner_id_25,
  t0.inter_fee_id AS inter_fee_id_26,
  t0.invite_user_id AS invite_user_id_27,
  t0.organ_inter_fee_id AS organ_inter_fee_id_28
FROM
  invest t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.idno AS idno_4, t0.type AS type_5, t0.resp AS resp_6, t0.order_no AS order_no_7, t0.pay_no AS pay_no_8, t0.payment_state AS payment_state_9, t0.payment_type AS payment_type_10, t0.order_money AS order_money_11, t0.pay_time AS pay_time_12, t0.refund_order AS refund_order_13, t0.minites AS minites_14, t0.resin AS resin_15, t0.payres AS payres_16, t0.organ_order_money AS organ_order_money_17, t0.is_jie AS is_jie_18, t0.inter_fee_cost AS inter_fee_cost_19, t0.organ_inter_fee_cost AS organ_inter_fee_cost_20, t0.inter_fee_price AS inter_fee_price_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.status AS status_24, t0.owner_id AS owner_id_25, t0.inter_fee_id AS inter_fee_id_26, t0.invite_user_id AS invite_user_id_27, t0.organ_inter_fee_id AS organ_inter_fee_id_28 FROM invest t0 WHERE t0.id = '222';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 191)
6	App\Service\InvestService->getInvestPreviewData (line 296)
7	App\Service\InvestService->getInvestStandardItems (line 333)
8	App\Controller\Apo\ApoController->getServerInvest (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)

0.27 ms
(49.72%)

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.id = ?

Parameters:

[
  121
]

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.id = ?

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.id = 121;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\User->__get (line 616)
8	App\Entity\User->getIdentifyCode (line 360)
9	App\Entity\Invest->getFields (line 299)
10	App\Service\InvestService->getInvestStandardItems (line 333)
11	App\Controller\Apo\ApoController->getServerInvest (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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\Invest	No 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\InterFee	No errors.
App\Entity\WalletLog	No errors.
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\UserBankcard	The mappings App\Entity\UserBankcard#owner and App\Entity\User#userBankcards are inconsistent with each other.

Symfony Profiler

GET https://www.ctidca.com/apo/s2/getInvestInfo?id=222

Configuration Settings

Theme