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

Query Metrics

2 Database Queries
2 Different statements
84.91 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 84.30 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-07-01"
  "end_at" => "2025-07-31"
]

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\SavedRequest No errors.
App\V4\Entity\PreconfiguredExport No errors.
App\V4\Webhook\Entity\WebhookLog No errors.

legacy entity manager

No loaded entities.