Query Metrics
8
Database Queries
4
Different statements
10.16 ms
Query time
0
Invalid entities
Queries
master connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.32 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.email AS email_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.vat_country AS vat_country_7, t0.phone_administration AS phone_administration_8, t0.phone_support_customer AS phone_support_customer_9, t0.phone_support_technician AS phone_support_technician_10, t0.phone_logistic AS phone_logistic_11, t0.email_administration AS email_administration_12, t0.email_support_customer AS email_support_customer_13, t0.email_support_technician AS email_support_technician_14, t0.email_logistic AS email_logistic_15, t0.directory_path AS directory_path_16, t0.logo_path AS logo_path_17, t0.db_name AS db_name_18, t0.admin_access AS admin_access_19, t0.admin_active AS admin_active_20 FROM eposm_m_company t0
Parameters:
[] |
| 2 | 0.26 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.email AS email_4, t0.fiscal_code AS fiscal_code_5, t0.vat AS vat_6, t0.vat_country AS vat_country_7, t0.phone_administration AS phone_administration_8, t0.phone_support_customer AS phone_support_customer_9, t0.phone_support_technician AS phone_support_technician_10, t0.phone_logistic AS phone_logistic_11, t0.email_administration AS email_administration_12, t0.email_support_customer AS email_support_customer_13, t0.email_support_technician AS email_support_technician_14, t0.email_logistic AS email_logistic_15, t0.directory_path AS directory_path_16, t0.logo_path AS logo_path_17, t0.db_name AS db_name_18, t0.admin_access AS admin_access_19, t0.admin_active AS admin_active_20 FROM eposm_m_company t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"23"
]
|
slave connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.36 ms |
SELECT e0_.id AS id_0, e0_.datetime_from AS datetime_from_1, e0_.datetime_to AS datetime_to_2, e0_.is_approved AS is_approved_3, e0_.is_managed AS is_managed_4, e0_.is_unlocked AS is_unlocked_5, e0_.unlock_causal AS unlock_causal_6, e0_.refuse_motivation AS refuse_motivation_7, e0_.intervention_id AS intervention_id_8, e0_.ticket_id AS ticket_id_9 FROM eposm_s_ticket_suspension e0_ LEFT JOIN eposm_s_ticket e1_ ON e0_.ticket_id = e1_.id LEFT JOIN eposm_s_ticket_status e2_ ON e1_.status_id = e2_.id WHERE e2_.slug = ? AND e0_.is_approved = 1 AND e0_.is_unlocked <> 1 AND e0_.datetime_to IS NOT NULL AND e0_.datetime_to <= ?
Parameters:
[ "suspended" "2025-07-06 19:30:01" ] |
| 2 | 0.93 ms |
SELECT e0_.id AS id_0, e0_.datetime_from AS datetime_from_1, e0_.datetime_to AS datetime_to_2, e0_.is_approved AS is_approved_3, e0_.is_managed AS is_managed_4, e0_.is_unlocked AS is_unlocked_5, e0_.unlock_causal AS unlock_causal_6, e0_.refuse_motivation AS refuse_motivation_7, e0_.intervention_id AS intervention_id_8, e0_.ticket_id AS ticket_id_9 FROM eposm_s_ticket_suspension e0_ LEFT JOIN eposm_s_ticket e1_ ON e0_.ticket_id = e1_.id LEFT JOIN eposm_s_ticket_status e2_ ON e1_.status_id = e2_.id WHERE e2_.slug = ? AND e0_.is_approved = 1 AND e0_.is_unlocked <> 1 AND e0_.datetime_to IS NOT NULL AND e0_.datetime_to <= ?
Parameters:
[ "suspended" "2025-07-06 19:30:01" ] |
| 3 | 1.43 ms |
SELECT e0_.id AS id_0, e0_.datetime_from AS datetime_from_1, e0_.datetime_to AS datetime_to_2, e0_.is_approved AS is_approved_3, e0_.is_managed AS is_managed_4, e0_.is_unlocked AS is_unlocked_5, e0_.unlock_causal AS unlock_causal_6, e0_.refuse_motivation AS refuse_motivation_7, e0_.intervention_id AS intervention_id_8, e0_.ticket_id AS ticket_id_9 FROM eposm_s_ticket_suspension e0_ LEFT JOIN eposm_s_ticket e1_ ON e0_.ticket_id = e1_.id LEFT JOIN eposm_s_ticket_status e2_ ON e1_.status_id = e2_.id WHERE e2_.slug = ? AND e0_.is_approved = 1 AND e0_.is_unlocked <> 1 AND e0_.datetime_to IS NOT NULL AND e0_.datetime_to <= ?
Parameters:
[ "suspended" "2025-07-06 19:30:01" ] |
| 4 | 1.32 ms |
SELECT e0_.id AS id_0, e0_.datetime_from AS datetime_from_1, e0_.datetime_to AS datetime_to_2, e0_.is_approved AS is_approved_3, e0_.is_managed AS is_managed_4, e0_.is_unlocked AS is_unlocked_5, e0_.unlock_causal AS unlock_causal_6, e0_.refuse_motivation AS refuse_motivation_7, e0_.intervention_id AS intervention_id_8, e0_.ticket_id AS ticket_id_9 FROM eposm_s_ticket_suspension e0_ LEFT JOIN eposm_s_ticket e1_ ON e0_.ticket_id = e1_.id LEFT JOIN eposm_s_ticket_status e2_ ON e1_.status_id = e2_.id WHERE e2_.slug = ? AND e0_.is_approved = 1 AND e0_.is_unlocked <> 1 AND e0_.datetime_to IS NOT NULL AND e0_.datetime_to <= ?
Parameters:
[ "suspended" "2025-07-06 19:30:01" ] |
| 5 | 1.11 ms |
SELECT e0_.id AS id_0, e0_.datetime_from AS datetime_from_1, e0_.datetime_to AS datetime_to_2, e0_.is_approved AS is_approved_3, e0_.is_managed AS is_managed_4, e0_.is_unlocked AS is_unlocked_5, e0_.unlock_causal AS unlock_causal_6, e0_.refuse_motivation AS refuse_motivation_7, e0_.intervention_id AS intervention_id_8, e0_.ticket_id AS ticket_id_9 FROM eposm_s_ticket_suspension e0_ LEFT JOIN eposm_s_ticket e1_ ON e0_.ticket_id = e1_.id LEFT JOIN eposm_s_ticket_status e2_ ON e1_.status_id = e2_.id WHERE e2_.slug = ? AND e0_.is_approved = 1 AND e0_.is_unlocked <> 1 AND e0_.datetime_to IS NOT NULL AND e0_.datetime_to <= ?
Parameters:
[ "suspended" "2025-07-06 19:30:01" ] |
| 6 | 1.43 ms |
SELECT e0_.id AS id_0, e0_.nickname AS nickname_1, e0_.address AS address_2, e0_.is_movable AS is_movable_3, e0_.is_headquarter AS is_headquarter_4, e0_.is_active AS is_active_5, e0_.client_id AS client_id_6, e0_.destination_id AS destination_id_7 FROM eposm_s_warehouse e0_ WHERE e0_.is_headquarter = 1 AND e0_.client_id IS NULL AND e0_.destination_id IS NULL
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| master | doctrine.dbal.master_connection |
| slave | doctrine.dbal.slave_connection |
Entity Managers
| Name | Service |
|---|---|
| master | doctrine.orm.master_entity_manager |
| slave | doctrine.orm.slave_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
master entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Master\Company | No errors. |
| App\Entity\Master\CompanyMailer | No errors. |
| App\Entity\Master\JoinTableCompanySupplier | No errors. |
| App\Entity\Master\Address | No errors. |
| App\Entity\Master\Contact | No errors. |
| App\Entity\Master\License | No errors. |
| App\Entity\Master\Order | No errors. |
| App\Entity\Master\JoinTableCompanyFeature | No errors. |
| App\Entity\Master\Region | No errors. |
slave entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Slave\TicketSuspension | No errors. |
| App\Entity\Slave\Ticket | No errors. |
| App\Entity\Slave\TicketStatus | No errors. |
| App\Entity\Slave\Intervention | No errors. |
| App\Entity\Slave\Warehouse | No errors. |
| App\Entity\Slave\Client | No errors. |
| App\Entity\Slave\Destination | No errors. |
| App\Entity\Slave\JoinTableUserWarehouse | No errors. |
| App\Entity\Slave\Product | No errors. |
| App\Entity\Slave\ProductTransfer | No errors. |
| App\Entity\Slave\ProductRequest | No errors. |