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

Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
112.10 ms
(0.00%)
1
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-05-01"
  "end_at" => "2025-05-31"
]
0.56 ms
(0.00%)
1
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"
]

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.