Query Metrics
12
Database Queries
4
Different statements
7.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.96 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[] |
| 3 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[] |
| 4 | 0.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_order_delivery_info"
]
|
| 5 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_sales_lead"
]
|
| 6 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_ticket"
]
|
| 7 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_chatbot"
]
|
| 8 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_shopify"
]
|
| 9 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_delivery_capacity"
]
|
| 10 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_addresscheck"
]
|
| 11 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"module_transport_calculation"
]
|
| 12 | 1.22 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM sales_lead s0_ LEFT JOIN sales_lead_log s1_ ON s0_.id = s1_.sales_lead_id LEFT JOIN sales_lead_log s2_ ON s0_.id = s2_.sales_lead_id AND (s0_.id = s2_.sales_lead_id AND s1_.id < s2_.id AND s2_.is_deleted = 0) WHERE s2_.id IS NULL AND s0_.is_deleted = 0 AND s0_.lead_responsible_id = ? AND ((s1_.is_deleted = 0 AND s1_.is_finished = 0) OR s1_.id IS NULL)
Parameters:
[
1
]
|
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\User | No errors. |
| App\Entity\UserGroup | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\TaskTemplate | No errors. |
| App\Entity\TaskLog | No errors. |
| App\Entity\ManualProductMoveHistory | No errors. |
| App\Entity\OrderAction | No errors. |
| App\Entity\AppointmentTemplate | No errors. |
| App\Entity\AppointmentLog | No errors. |
| App\Entity\Proposal | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Shortcut | No errors. |
| App\Entity\UserTablePreference | No errors. |
| App\Entity\EnvironmentParameter | No errors. |
| App\Entity\SalesLead | No errors. |
| App\Entity\SalesLeadLog | No errors. |