Query Metrics
2
Database Queries
2
Different statements
53.67 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.61 ms |
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.entity AS entity_3, t0.tab_id AS tab_id_4, t0.label AS label_5, t0.content AS content_6, t0.is_async AS is_async_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_at AS deleted_at_12 FROM preconfigured_export t0 WHERE t0.id = ? AND ((t0.customer_id = '0662705af65c48908b017d8fb0724bac'))
Parameters:
[
"TESTRSACTIONSCOLLECTIVES"
]
|
2 | 53.06 ms |
SELECT COUNT( CASE WHEN t.is_closed = 1 THEN t.id END ) AS count, COUNT(t.id) AS secondary_number_stat, CONCAT(tt.name, '#', u.id) AS 'Origine' FROM task t INNER JOIN prospect p ON t.prospect_id = p.id INNER JOIN task_type tt ON t.task_type_id = tt.id INNER JOIN user u ON t.managed_by = u.id WHERE t.customer_id = '0662705af65c48908b017d8fb0724bac' AND t.begin_at BETWEEN :begin_at AND :end_at AND p.prospect_type_id = '929e121c9d794c22a6866029e2ba4fbc' AND t.deleted_at IS NULL AND p.deleted_at IS NULL GROUP BY t.task_type_id, u.id;
Parameters:
[ "begin_at" => "2025-02-01" "end_at" => "2025-02-28" ] |
legacy connection
No database queries were performed.
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
legacy | doctrine.dbal.legacy_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
legacy | doctrine.orm.legacy_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\V4\Entity\PreconfiguredExport | No errors. |
App\V4\Webhook\Entity\WebhookLog | No errors. |
legacy entity manager
No loaded entities.