Query Metrics
6
Database Queries
6
Different statements
19.11 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.93 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.connected_at AS connected_at_6 FROM ksante_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"api@ksante.fr"
]
|
| 2 | 1.73 ms |
SELECT t0.id AS id_1, t0.api_id AS api_id_2, t0.code AS code_3, t0.name AS name_4, t0.url AS url_5, t0.local_name AS local_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM ksante_channel t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"KITCHENDIET_FR"
]
|
| 3 | 10.78 ms |
SELECT k0_.id AS id_0, k0_.external_id AS external_id_1, k0_.first_name AS first_name_2, k0_.last_name AS last_name_3, k0_.email AS email_4, k0_.phone_number AS phone_number_5, k0_.activity AS activity_6, k0_.appointment_credit AS appointment_credit_7, k0_.past_appointments AS past_appointments_8, k0_.cancelled_appointments AS cancelled_appointments_9, k0_.created_at AS created_at_10, k0_.updated_at AS updated_at_11, k0_.diet_id AS diet_id_12, k0_.channel_id AS channel_id_13 FROM ksante_customer k0_ WHERE k0_.channel_id = ? AND ? = k0_.external_id
Parameters:
[ 4 "e5fbf7e4-e20d-42bf-b7f6-844135a5848e" ] |
| 4 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.90 ms |
UPDATE ksante_customer SET appointment_credit = ?, updated_at = ? WHERE id = ?
Parameters:
[ 101 "2026-04-16 18:04:41" 4433 ] |
| 6 | 4.29 ms |
"COMMIT"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| magento_kd | doctrine.dbal.magento_kd_connection |
| magento_db | doctrine.dbal.magento_db_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 |
|---|---|
| Ksante\SsoBundle\Entity\User | No errors. |
| Ksante\CoreBundle\Entity\Channel | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Diet | No errors. |
| App\Entity\AppointmentResume | No errors. |
| App\Entity\Appointment | No errors. |