https://dev.app.pol-crm.com/api/v4/sync-preconfigured-export/TESTRSACTIONSCOLLECTIVES/export?params%5Bbegin_at%5D=2025-04-01&params%5Bend_at%5D=2025-04-30

Query Metrics

2 Database Queries
2 Different statements
86.40 ms Query time
0 Invalid entities

Queries

Group similar statements

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 85.79 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-04-01"
  "end_at" => "2025-04-30"
]

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.