Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.30 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.70 ms	SELECT t0.id AS id_1, t0.operator AS operator_2, t0.amount AS amount_3, t0.number AS number_4, t0.reason AS reason_5, t0.operation_type AS operation_type_6, t0.date_created AS date_created_7, t0.api_response AS api_response_8, t0.comment AS comment_9, t0.application_id AS application_id_10 FROM payment t0 WHERE t0.id = ? Parameters: [`"53"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.operator AS operator_2, t0.amount AS amount_3, t0.number AS number_4, t0.reason AS reason_5, t0.operation_type AS operation_type_6, t0.date_created AS date_created_7, t0.api_response AS api_response_8, t0.comment AS comment_9, t0.application_id AS application_id_10 FROM payment t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.operator AS operator_2, t0.amount AS amount_3, t0.number AS number_4, t0.reason AS reason_5, t0.operation_type AS operation_type_6, t0.date_created AS date_created_7, t0.api_response AS api_response_8, t0.comment AS comment_9, t0.application_id AS application_id_10 FROM payment t0 WHERE t0.id = '53';
2	0.60 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.abbreviation AS abbreviation_2, a0_.date_created AS date_created_3, a0_.application_pass AS application_pass_4, a0_.http_link AS http_link_5, a0_.logo AS logo_6, a0_.api_link AS api_link_7, a0_.api_back_link AS api_back_link_8, a0_.max_cash_out AS max_cash_out_9, a0_.cash_out_cumul AS cash_out_cumul_10, a0_.is_validated AS is_validated_11, a0_.status AS status_12, a0_.validation_delay AS validation_delay_13, a0_.session_delay AS session_delay_14, a0_.is_monday_block AS is_monday_block_15, a0_.is_tuesday_block AS is_tuesday_block_16, a0_.is_wednesday_block AS is_wednesday_block_17, a0_.is_thursday_block AS is_thursday_block_18, a0_.is_friday_block AS is_friday_block_19, a0_.is_saturday_block AS is_saturday_block_20, a0_.is_sunday_block AS is_sunday_block_21, a0_.monday_start AS monday_start_22, a0_.monday_end AS monday_end_23, a0_.tuesday_start AS tuesday_start_24, a0_.tuesday_end AS tuesday_end_25, a0_.wednesday_start AS wednesday_start_26, a0_.wednesday_end AS wednesday_end_27, a0_.thursday_start AS thursday_start_28, a0_.thursday_end AS thursday_end_29, a0_.friday_start AS friday_start_30, a0_.friday_end AS friday_end_31, a0_.saturday_start AS saturday_start_32, a0_.saturday_end AS saturday_end_33, a0_.sunday_start AS sunday_start_34, a0_.sunday_end AS sunday_end_35, a0_.application_holder_ido_id AS application_holder_ido_id_36, a0_.check_qr_id AS check_qr_id_37 FROM application a0_ Parameters: [] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.abbreviation AS abbreviation_2, a0_.date_created AS date_created_3, a0_.application_pass AS application_pass_4, a0_.http_link AS http_link_5, a0_.logo AS logo_6, a0_.api_link AS api_link_7, a0_.api_back_link AS api_back_link_8, a0_.max_cash_out AS max_cash_out_9, a0_.cash_out_cumul AS cash_out_cumul_10, a0_.is_validated AS is_validated_11, a0_.status AS status_12, a0_.validation_delay AS validation_delay_13, a0_.session_delay AS session_delay_14, a0_.is_monday_block AS is_monday_block_15, a0_.is_tuesday_block AS is_tuesday_block_16, a0_.is_wednesday_block AS is_wednesday_block_17, a0_.is_thursday_block AS is_thursday_block_18, a0_.is_friday_block AS is_friday_block_19, a0_.is_saturday_block AS is_saturday_block_20, a0_.is_sunday_block AS is_sunday_block_21, a0_.monday_start AS monday_start_22, a0_.monday_end AS monday_end_23, a0_.tuesday_start AS tuesday_start_24, a0_.tuesday_end AS tuesday_end_25, a0_.wednesday_start AS wednesday_start_26, a0_.wednesday_end AS wednesday_end_27, a0_.thursday_start AS thursday_start_28, a0_.thursday_end AS thursday_end_29, a0_.friday_start AS friday_start_30, a0_.friday_end AS friday_end_31, a0_.saturday_start AS saturday_start_32, a0_.saturday_end AS saturday_end_33, a0_.sunday_start AS sunday_start_34, a0_.sunday_end AS sunday_end_35, a0_.application_holder_ido_id AS application_holder_ido_id_36, a0_.check_qr_id AS check_qr_id_37 FROM application a0_ SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.abbreviation AS abbreviation_2, a0_.date_created AS date_created_3, a0_.application_pass AS application_pass_4, a0_.http_link AS http_link_5, a0_.logo AS logo_6, a0_.api_link AS api_link_7, a0_.api_back_link AS api_back_link_8, a0_.max_cash_out AS max_cash_out_9, a0_.cash_out_cumul AS cash_out_cumul_10, a0_.is_validated AS is_validated_11, a0_.status AS status_12, a0_.validation_delay AS validation_delay_13, a0_.session_delay AS session_delay_14, a0_.is_monday_block AS is_monday_block_15, a0_.is_tuesday_block AS is_tuesday_block_16, a0_.is_wednesday_block AS is_wednesday_block_17, a0_.is_thursday_block AS is_thursday_block_18, a0_.is_friday_block AS is_friday_block_19, a0_.is_saturday_block AS is_saturday_block_20, a0_.is_sunday_block AS is_sunday_block_21, a0_.monday_start AS monday_start_22, a0_.monday_end AS monday_end_23, a0_.tuesday_start AS tuesday_start_24, a0_.tuesday_end AS tuesday_end_25, a0_.wednesday_start AS wednesday_start_26, a0_.wednesday_end AS wednesday_end_27, a0_.thursday_start AS thursday_start_28, a0_.thursday_end AS thursday_end_29, a0_.friday_start AS friday_start_30, a0_.friday_end AS friday_end_31, a0_.saturday_start AS saturday_start_32, a0_.saturday_end AS saturday_end_33, a0_.sunday_start AS sunday_start_34, a0_.sunday_end AS sunday_end_35, a0_.application_holder_ido_id AS application_holder_ido_id_36, a0_.check_qr_id AS check_qr_id_37 FROM application a0_;

#▲

Time

Info

0.70 ms

SELECT t0.id AS id_1, t0.operator AS operator_2, t0.amount AS amount_3, t0.number AS number_4, t0.reason AS reason_5, t0.operation_type AS operation_type_6, t0.date_created AS date_created_7, t0.api_response AS api_response_8, t0.comment AS comment_9, t0.application_id AS application_id_10 FROM payment t0 WHERE t0.id = ?

Parameters:

[
  "53"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.operator AS operator_2,
  t0.amount AS amount_3,
  t0.number AS number_4,
  t0.reason AS reason_5,
  t0.operation_type AS operation_type_6,
  t0.date_created AS date_created_7,
  t0.api_response AS api_response_8,
  t0.comment AS comment_9,
  t0.application_id AS application_id_10
FROM
  payment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.operator AS operator_2, t0.amount AS amount_3, t0.number AS number_4, t0.reason AS reason_5, t0.operation_type AS operation_type_6, t0.date_created AS date_created_7, t0.api_response AS api_response_8, t0.comment AS comment_9, t0.application_id AS application_id_10 FROM payment t0 WHERE t0.id = '53';

0.60 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.abbreviation AS abbreviation_2, a0_.date_created AS date_created_3, a0_.application_pass AS application_pass_4, a0_.http_link AS http_link_5, a0_.logo AS logo_6, a0_.api_link AS api_link_7, a0_.api_back_link AS api_back_link_8, a0_.max_cash_out AS max_cash_out_9, a0_.cash_out_cumul AS cash_out_cumul_10, a0_.is_validated AS is_validated_11, a0_.status AS status_12, a0_.validation_delay AS validation_delay_13, a0_.session_delay AS session_delay_14, a0_.is_monday_block AS is_monday_block_15, a0_.is_tuesday_block AS is_tuesday_block_16, a0_.is_wednesday_block AS is_wednesday_block_17, a0_.is_thursday_block AS is_thursday_block_18, a0_.is_friday_block AS is_friday_block_19, a0_.is_saturday_block AS is_saturday_block_20, a0_.is_sunday_block AS is_sunday_block_21, a0_.monday_start AS monday_start_22, a0_.monday_end AS monday_end_23, a0_.tuesday_start AS tuesday_start_24, a0_.tuesday_end AS tuesday_end_25, a0_.wednesday_start AS wednesday_start_26, a0_.wednesday_end AS wednesday_end_27, a0_.thursday_start AS thursday_start_28, a0_.thursday_end AS thursday_end_29, a0_.friday_start AS friday_start_30, a0_.friday_end AS friday_end_31, a0_.saturday_start AS saturday_start_32, a0_.saturday_end AS saturday_end_33, a0_.sunday_start AS sunday_start_34, a0_.sunday_end AS sunday_end_35, a0_.application_holder_ido_id AS application_holder_ido_id_36, a0_.check_qr_id AS check_qr_id_37 FROM application a0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.abbreviation AS abbreviation_2,
  a0_.date_created AS date_created_3,
  a0_.application_pass AS application_pass_4,
  a0_.http_link AS http_link_5,
  a0_.logo AS logo_6,
  a0_.api_link AS api_link_7,
  a0_.api_back_link AS api_back_link_8,
  a0_.max_cash_out AS max_cash_out_9,
  a0_.cash_out_cumul AS cash_out_cumul_10,
  a0_.is_validated AS is_validated_11,
  a0_.status AS status_12,
  a0_.validation_delay AS validation_delay_13,
  a0_.session_delay AS session_delay_14,
  a0_.is_monday_block AS is_monday_block_15,
  a0_.is_tuesday_block AS is_tuesday_block_16,
  a0_.is_wednesday_block AS is_wednesday_block_17,
  a0_.is_thursday_block AS is_thursday_block_18,
  a0_.is_friday_block AS is_friday_block_19,
  a0_.is_saturday_block AS is_saturday_block_20,
  a0_.is_sunday_block AS is_sunday_block_21,
  a0_.monday_start AS monday_start_22,
  a0_.monday_end AS monday_end_23,
  a0_.tuesday_start AS tuesday_start_24,
  a0_.tuesday_end AS tuesday_end_25,
  a0_.wednesday_start AS wednesday_start_26,
  a0_.wednesday_end AS wednesday_end_27,
  a0_.thursday_start AS thursday_start_28,
  a0_.thursday_end AS thursday_end_29,
  a0_.friday_start AS friday_start_30,
  a0_.friday_end AS friday_end_31,
  a0_.saturday_start AS saturday_start_32,
  a0_.saturday_end AS saturday_end_33,
  a0_.sunday_start AS sunday_start_34,
  a0_.sunday_end AS sunday_end_35,
  a0_.application_holder_ido_id AS application_holder_ido_id_36,
  a0_.check_qr_id AS check_qr_id_37
FROM
  application a0_

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.abbreviation AS abbreviation_2, a0_.date_created AS date_created_3, a0_.application_pass AS application_pass_4, a0_.http_link AS http_link_5, a0_.logo AS logo_6, a0_.api_link AS api_link_7, a0_.api_back_link AS api_back_link_8, a0_.max_cash_out AS max_cash_out_9, a0_.cash_out_cumul AS cash_out_cumul_10, a0_.is_validated AS is_validated_11, a0_.status AS status_12, a0_.validation_delay AS validation_delay_13, a0_.session_delay AS session_delay_14, a0_.is_monday_block AS is_monday_block_15, a0_.is_tuesday_block AS is_tuesday_block_16, a0_.is_wednesday_block AS is_wednesday_block_17, a0_.is_thursday_block AS is_thursday_block_18, a0_.is_friday_block AS is_friday_block_19, a0_.is_saturday_block AS is_saturday_block_20, a0_.is_sunday_block AS is_sunday_block_21, a0_.monday_start AS monday_start_22, a0_.monday_end AS monday_end_23, a0_.tuesday_start AS tuesday_start_24, a0_.tuesday_end AS tuesday_end_25, a0_.wednesday_start AS wednesday_start_26, a0_.wednesday_end AS wednesday_end_27, a0_.thursday_start AS thursday_start_28, a0_.thursday_end AS thursday_end_29, a0_.friday_start AS friday_start_30, a0_.friday_end AS friday_end_31, a0_.saturday_start AS saturday_start_32, a0_.saturday_end AS saturday_end_33, a0_.sunday_start AS sunday_start_34, a0_.sunday_end AS sunday_end_35, a0_.application_holder_ido_id AS application_holder_ido_id_36, a0_.check_qr_id AS check_qr_id_37 FROM application a0_;

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\Payment	No errors.
App\Entity\Application	No errors.
App\Entity\CheckQr	The mappings App\Entity\CheckQr#personcivil and App\Entity\PersonCivil#checkQr are inconsistent with each other.
App\Entity\ApplicationRequirement	No errors.
App\Entity\ApplicationSubscription	No errors.
App\Entity\BioAuth	No errors.
App\Entity\Notification	No errors.
App\Entity\Fichier	No errors.
App\Entity\PersonAppIdentity	No errors.
App\Entity\PersonBioVerification	No errors.
App\Entity\Person	The association App\Entity\Person#bioAuthHistories refers to the owning side field App\Entity\BioAuthHistory#person which does not exist. The association App\Entity\Person#personAuthHistories refers to the owning side field App\Entity\PersonAuthHistory#person which does not exist. The mappings App\Entity\Person#identifications and App\Entity\Identification#toBeIdentified are inconsistent with each other.
App\Entity\Transaction	No errors.
App\Entity\PersonAuthHistory	The association App\Entity\PersonAuthHistory#device refers to the inverse side field App\Entity\Device#personAuthHistory which does not exist.
App\Entity\Identification	No errors.
App\Entity\Appointment	No errors.
App\Entity\PersonBiometrics	No errors.
App\Entity\PersonCivil	No errors.
App\Entity\BioAuthHistory	No errors.
App\Entity\PersonAppAvatar	The association App\Entity\PersonAppAvatar#identificationAvatar refers to the owning side field App\Entity\PersonAppIdentity#avatar which does not exist.
App\Entity\PersonMeeting	No errors.
App\Entity\PersonMeetingMember	No errors.
App\Entity\Cryptographe	No errors.
App\Entity\PersonSignature	No errors.
App\Entity\PersonMeetingReportComment	No errors.
App\Entity\PersonMeetingReport	No errors.
App\Entity\ApplicationSubscriptionDetail	No errors.
App\Entity\Device	The mappings App\Entity\Device#personAuthHistories and App\Entity\PersonAuthHistory#device are inconsistent with each other.

Symfony Profiler

https://my.kyvala.com/payment/53/edit

Configuration Settings

Theme