Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 20
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.paid AS paid_4, t0.created AS created_5, t0.client_id AS client_id_6, t7.city AS city_8, t7.street AS street_9, t7.house AS house_10, t7.apartment AS apartment_11, t7.contract_id AS contract_id_12, t0.commutator_id AS commutator_id_13 FROM contract t0 LEFT JOIN contract_location t7 ON t7.contract_id = t0.id WHERE t0.number = ? LIMIT 1

[
  "02290"
]

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.paid AS paid_4,
  t0.created AS created_5,
  t0.client_id AS client_id_6,
  t7.city AS city_8,
  t7.street AS street_9,
  t7.house AS house_10,
  t7.apartment AS apartment_11,
  t7.contract_id AS contract_id_12,
  t0.commutator_id AS commutator_id_13
FROM
  contract t0
  LEFT JOIN contract_location t7 ON t7.contract_id = t0.id
WHERE
  t0.number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.paid AS paid_4, t0.created AS created_5, t0.client_id AS client_id_6, t7.city AS city_8, t7.street AS street_9, t7.house AS house_10, t7.apartment AS apartment_11, t7.contract_id AS contract_id_12, t0.commutator_id AS commutator_id_13 FROM contract t0 LEFT JOIN contract_location t7 ON t7.contract_id = t0.id WHERE t0.number = '02290' LIMIT 1;

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.amount AS amount_6, t7.name AS name_8, t7.surname AS surname_9, t7.patronymic AS patronymic_10, t7.value AS value_11, t7.number AS number_12, t7.issued AS issued_13, t7.department AS department_14, t7.client_id AS client_id_15 FROM client t0 LEFT JOIN client_identification t7 ON t7.client_id = t0.id WHERE t0.id = ?

[
  b"\x01ˆ\x0ECmy½7ŽÅ«>¬<ï\x01"
]

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.amount AS amount_6,
  t7.name AS name_8,
  t7.surname AS surname_9,
  t7.patronymic AS patronymic_10,
  t7.value AS value_11,
  t7.number AS number_12,
  t7.issued AS issued_13,
  t7.department AS department_14,
  t7.client_id AS client_id_15
FROM
  client t0
  LEFT JOIN client_identification t7 ON t7.client_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.amount AS amount_6, t7.name AS name_8, t7.surname AS surname_9, t7.patronymic AS patronymic_10, t7.value AS value_11, t7.number AS number_12, t7.issued AS issued_13, t7.department AS department_14, t7.client_id AS client_id_15 FROM client t0 LEFT JOIN client_identification t7 ON t7.client_id = t0.id WHERE t0.id = 0x01880E436D79BD378EC5AB3EAC3CEF01;

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created AS created_3, t0.manual AS manual_4, t0.comment AS comment_5, t0.client_id AS client_id_6, t7.id AS id_8, t7.accrued AS accrued_9, t7.created AS created_10, t7.manual AS manual_11, t7.comment AS comment_12, t7.transaction_id AS transaction_id_13, t7.contract_id AS contract_id_14 FROM client_balance_transaction t0 LEFT JOIN contract_invoice t7 ON t7.transaction_id = t0.id WHERE t0.comment = ? LIMIT 1

[
  "Пополнение баланса Kaspi (221188663654)"
]

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created AS created_3,
  t0.manual AS manual_4,
  t0.comment AS comment_5,
  t0.client_id AS client_id_6,
  t7.id AS id_8,
  t7.accrued AS accrued_9,
  t7.created AS created_10,
  t7.manual AS manual_11,
  t7.comment AS comment_12,
  t7.transaction_id AS transaction_id_13,
  t7.contract_id AS contract_id_14
FROM
  client_balance_transaction t0
  LEFT JOIN contract_invoice t7 ON t7.transaction_id = t0.id
WHERE
  t0.comment = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created AS created_3, t0.manual AS manual_4, t0.comment AS comment_5, t0.client_id AS client_id_6, t7.id AS id_8, t7.accrued AS accrued_9, t7.created AS created_10, t7.manual AS manual_11, t7.comment AS comment_12, t7.transaction_id AS transaction_id_13, t7.contract_id AS contract_id_14 FROM client_balance_transaction t0 LEFT JOIN contract_invoice t7 ON t7.transaction_id = t0.id WHERE t0.comment = 'Пополнение баланса Kaspi (221188663654)' LIMIT 1;

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.paid AS paid_4, t0.created AS created_5, t0.client_id AS client_id_6, t7.city AS city_8, t7.street AS street_9, t7.house AS house_10, t7.apartment AS apartment_11, t7.contract_id AS contract_id_12, t0.commutator_id AS commutator_id_13 FROM contract t0 LEFT JOIN contract_location t7 ON t7.contract_id = t0.id WHERE t0.client_id = ?

[
  b"\x01ˆ\x0ECmy½7ŽÅ«>¬<ï\x01"
]

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.paid AS paid_4,
  t0.created AS created_5,
  t0.client_id AS client_id_6,
  t7.city AS city_8,
  t7.street AS street_9,
  t7.house AS house_10,
  t7.apartment AS apartment_11,
  t7.contract_id AS contract_id_12,
  t0.commutator_id AS commutator_id_13
FROM
  contract t0
  LEFT JOIN contract_location t7 ON t7.contract_id = t0.id
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.paid AS paid_4, t0.created AS created_5, t0.client_id AS client_id_6, t7.city AS city_8, t7.street AS street_9, t7.house AS house_10, t7.apartment AS apartment_11, t7.contract_id AS contract_id_12, t0.commutator_id AS commutator_id_13 FROM contract t0 LEFT JOIN contract_location t7 ON t7.contract_id = t0.id WHERE t0.client_id = 0x01880E436D79BD378EC5AB3EAC3CEF01;

SELECT t0.contract_id AS contract_id_1, t0.equipment_id AS equipment_id_2 FROM contract_equipment t0 WHERE t0.contract_id = ?

[
  b"\x01ê\x0EEÅ;æ|æƒ"Üe·n╦"
]

SELECT
  t0.contract_id AS contract_id_1,
  t0.equipment_id AS equipment_id_2
FROM
  contract_equipment t0
WHERE
  t0.contract_id = ?

SELECT t0.contract_id AS contract_id_1, t0.equipment_id AS equipment_id_2 FROM contract_equipment t0 WHERE t0.contract_id = 0x01880E458F3B917C919F229A65FA6ECB;

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.model AS model_4, t0.serial AS serial_5, t0.address AS address_6, t0.port AS port_7, t0.price AS price_8 FROM equipment t0 WHERE t0.id = ?

[
  b"\x01ˆ\x0EDwb¦½“)Ý©€•¾š"
]

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.model AS model_4,
  t0.serial AS serial_5,
  t0.address AS address_6,
  t0.port AS port_7,
  t0.price AS price_8
FROM
  equipment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.model AS model_4, t0.serial AS serial_5, t0.address AS address_6, t0.port AS port_7, t0.price AS price_8 FROM equipment t0 WHERE t0.id = 0x01880E447762A6BD9329DDA98095BE9A;

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.login AS login_4, t0.password AS password_5, t0.script AS script_6 FROM commutator t0 WHERE t0.id = ?

[
  b"\x01Å‗├2┐Èò¼sÕ®╬\x13\x14´"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.login AS login_4,
  t0.password AS password_5,
  t0.script AS script_6
FROM
  commutator t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.login AS login_4, t0.password AS password_5, t0.script AS script_6 FROM commutator t0 WHERE t0.id = 0x018FF2C332BFD495AC73E5A9CE1314EF;

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.model AS model_4, t0.serial AS serial_5, t0.address AS address_6, t0.port AS port_7, t0.price AS price_8 FROM equipment t0 WHERE t0.id = ?

[
  b"\x01ê\x0EDÈ$Ý ê┐Ï?ëü\x07É"
]

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.model AS model_4,
  t0.serial AS serial_5,
  t0.address AS address_6,
  t0.port AS port_7,
  t0.price AS price_8
FROM
  equipment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.model AS model_4, t0.serial AS serial_5, t0.address AS address_6, t0.port AS port_7, t0.price AS price_8 FROM equipment t0 WHERE t0.id = 0x01880E44D424EDFF88BFD83F89810790;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO client_balance_transaction (id, amount, created, manual, COMMENT, client_id) VALUES (?, ?, ?, ?, ?, ?)

[
  b"\x01“ïIjg\x0FüØ\x17»¨S_õ¯"
  6500.0
  "2024-12-22 21:53:06"
  0
  "Пополнение баланса Kaspi (221188663654)"
  b"\x01ˆ\x0ECmy½7ŽÅ«>¬<ï\x01"
]

INSERT INTO client_balance_transaction (
  id, amount, created, manual, COMMENT,
  client_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO client_balance_transaction (id, amount, created, manual, COMMENT, client_id) VALUES (0x0193EF496A670FFCD817BBA8535FF5AF, 6500, '2024-12-22 21:53:06', 0, 'Пополнение баланса Kaspi (221188663654)', 0x01880E436D79BD378EC5AB3EAC3CEF01);

UPDATE client SET amount = ? WHERE id = ?

[
  6800.0
  b"\x01ˆ\x0ECmy½7ŽÅ«>¬<ï\x01"
]

UPDATE
  client
SET
  amount = ?
WHERE
  id = ?

UPDATE client SET amount = 6800 WHERE id = 0x01880E436D79BD378EC5AB3EAC3CEF01;

"COMMIT"

[]

"COMMIT"

"COMMIT";