Redirect 302 redirect from GET @app_collaborator_show (e9ccab)

GET https://vision.novanea.fr/collaborators/43/history/

Query Metrics

30 Database Queries
13 Different statements
9.32 ms Query time
0 Invalid entities
90 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.83 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.avatar_name AS avatar_name_6, t0.avatar_size AS avatar_size_7, t0.lastname AS lastname_8, t0.civility AS civility_9, t0.birthdate AS birthdate_10, t0.birth_city AS birth_city_11, t0.phone AS phone_12, t0.business_phone AS business_phone_13, t0.personal_email AS personal_email_14, t0.origin_recruitment AS origin_recruitment_15, t0.temp_password AS temp_password_16, t0.google_access_token AS google_access_token_17, t0.google_refresh_token AS google_refresh_token_18, t0.google_token_expires AS google_token_expires_19, t0.external_calendar_provider AS external_calendar_provider_20, t0.baikal_password AS baikal_password_21, t0.baikal_calendar_ctag AS baikal_calendar_ctag_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.40 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.type AS type_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.associated_user_id AS associated_user_id_7, t0.organization_id AS organization_id_8 FROM collaborator t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "43"
]
3 0.31 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.type AS type_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.associated_user_id AS associated_user_id_7, t0.organization_id AS organization_id_8 FROM collaborator t0 WHERE t0.organization_id = ? AND t0.associated_user_id = ? LIMIT 1
Parameters:
[
  1
  1
]
4 0.52 ms
SELECT p0_.id AS id_0, p0_.action_type AS action_type_1, p0_.lived AS lived_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.project_task_id AS project_task_id_5, p0_.next_project_task_id AS next_project_task_id_6, p0_.collaborator_id AS collaborator_id_7, p0_.scenario_action_reason_id AS scenario_action_reason_id_8, p0_.team_id AS team_id_9, p0_.next_scenario_status_id AS next_scenario_status_id_10 FROM project_task_action p0_ WHERE (p0_.created_at BETWEEN ? AND ?) AND p0_.collaborator_id = ?
Parameters:
[
  "2025-08-18 23:41:05"
  "2025-08-24 23:41:05"
  43
]
5 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.avatar_name AS avatar_name_6, t0.avatar_size AS avatar_size_7, t0.lastname AS lastname_8, t0.civility AS civility_9, t0.birthdate AS birthdate_10, t0.birth_city AS birth_city_11, t0.phone AS phone_12, t0.business_phone AS business_phone_13, t0.personal_email AS personal_email_14, t0.origin_recruitment AS origin_recruitment_15, t0.temp_password AS temp_password_16, t0.google_access_token AS google_access_token_17, t0.google_refresh_token AS google_refresh_token_18, t0.google_token_expires AS google_token_expires_19, t0.external_calendar_provider AS external_calendar_provider_20, t0.baikal_password AS baikal_password_21, t0.baikal_calendar_ctag AS baikal_calendar_ctag_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  43
]
6 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo_name AS logo_name_3, t0.logo_size AS logo_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.address_id AS address_id_7, t0.owner_id AS owner_id_8, t0.default_scenario_id AS default_scenario_id_9 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.organization_id AS organization_id_4 FROM role t0 INNER JOIN collaborator_role ON t0.id = collaborator_role.role_id WHERE collaborator_role.collaborator_id = ?
Parameters:
[
  43
]
8 0.43 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.collaborator_id AS collaborator_id_5, t0.scenario_workflow_id AS scenario_workflow_id_6, t0.project_id AS project_id_7 FROM project_workflow t0 WHERE t0.collaborator_id = ?
Parameters:
[
  43
]
9 0.48 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.place AS place_5, t0.confirmation AS confirmation_6, t0.contact_mode AS contact_mode_7, t0.is_displayed_on_calendar AS is_displayed_on_calendar_8, t0.external_calendar_id AS external_calendar_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.scenario_task_id AS scenario_task_id_12, t0.project_workflow_id AS project_workflow_id_13, t0.address_id AS address_id_14, t0.scenario_action_reason_id AS scenario_action_reason_id_15, t0.previous_task_id AS previous_task_id_16, t0.sprint_id AS sprint_id_17 FROM project_task t0 WHERE t0.id = ?
Parameters:
[
  16088
]
10 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_scheduled AS is_scheduled_3, t0.scheduling_delay_in_days AS scheduling_delay_in_days_4, t0.due_delay_in_days AS due_delay_in_days_5, t0.color AS color_6, t0.contact_modes AS contact_modes_7, t0.position AS position_8, t0.is_sales_targetable AS is_sales_targetable_9, t0.is_confirmable AS is_confirmable_10, t0.is_highlighted AS is_highlighted_11, t0.statistic_aggregation_name AS statistic_aggregation_name_12, t0.scenario_workflow_id AS scenario_workflow_id_13 FROM scenario_task t0 WHERE t0.id = ?
Parameters:
[
  2
]
11 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.organization_id AS organization_id_7, t0.customer_id AS customer_id_8, t0.scenario_status_id AS scenario_status_id_9, t0.scenario_id AS scenario_id_10, t0.collaborator_id AS collaborator_id_11, t0.campaign_id AS campaign_id_12, t0.source_id AS source_id_13 FROM project t0 WHERE t0.id = ?
Parameters:
[
  9555
]
12 0.42 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.secondary_phone AS secondary_phone_6, t0.birth_date AS birth_date_7, t0.family_situation AS family_situation_8, t0.gender AS gender_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12, t0.status_id AS status_id_13, t0.created_by_id AS created_by_id_14, t0.address_id AS address_id_15 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  9475
]
13 0.27 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.place AS place_5, t0.confirmation AS confirmation_6, t0.contact_mode AS contact_mode_7, t0.is_displayed_on_calendar AS is_displayed_on_calendar_8, t0.external_calendar_id AS external_calendar_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.scenario_task_id AS scenario_task_id_12, t0.project_workflow_id AS project_workflow_id_13, t0.address_id AS address_id_14, t0.scenario_action_reason_id AS scenario_action_reason_id_15, t0.previous_task_id AS previous_task_id_16, t0.sprint_id AS sprint_id_17 FROM project_task t0 WHERE t0.id = ?
Parameters:
[
  24860
]
14 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_scheduled AS is_scheduled_3, t0.scheduling_delay_in_days AS scheduling_delay_in_days_4, t0.due_delay_in_days AS due_delay_in_days_5, t0.color AS color_6, t0.contact_modes AS contact_modes_7, t0.position AS position_8, t0.is_sales_targetable AS is_sales_targetable_9, t0.is_confirmable AS is_confirmable_10, t0.is_highlighted AS is_highlighted_11, t0.statistic_aggregation_name AS statistic_aggregation_name_12, t0.scenario_workflow_id AS scenario_workflow_id_13 FROM scenario_task t0 WHERE t0.id = ?
Parameters:
[
  4
]
15 0.25 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.place AS place_5, t0.confirmation AS confirmation_6, t0.contact_mode AS contact_mode_7, t0.is_displayed_on_calendar AS is_displayed_on_calendar_8, t0.external_calendar_id AS external_calendar_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.scenario_task_id AS scenario_task_id_12, t0.project_workflow_id AS project_workflow_id_13, t0.address_id AS address_id_14, t0.scenario_action_reason_id AS scenario_action_reason_id_15, t0.previous_task_id AS previous_task_id_16, t0.sprint_id AS sprint_id_17 FROM project_task t0 WHERE t0.id = ?
Parameters:
[
  24807
]
16 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_scheduled AS is_scheduled_3, t0.scheduling_delay_in_days AS scheduling_delay_in_days_4, t0.due_delay_in_days AS due_delay_in_days_5, t0.color AS color_6, t0.contact_modes AS contact_modes_7, t0.position AS position_8, t0.is_sales_targetable AS is_sales_targetable_9, t0.is_confirmable AS is_confirmable_10, t0.is_highlighted AS is_highlighted_11, t0.statistic_aggregation_name AS statistic_aggregation_name_12, t0.scenario_workflow_id AS scenario_workflow_id_13 FROM scenario_task t0 WHERE t0.id = ?
Parameters:
[
  1
]
17 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.organization_id AS organization_id_7, t0.customer_id AS customer_id_8, t0.scenario_status_id AS scenario_status_id_9, t0.scenario_id AS scenario_id_10, t0.collaborator_id AS collaborator_id_11, t0.campaign_id AS campaign_id_12, t0.source_id AS source_id_13 FROM project t0 WHERE t0.id = ?
Parameters:
[
  14182
]
18 0.24 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.secondary_phone AS secondary_phone_6, t0.birth_date AS birth_date_7, t0.family_situation AS family_situation_8, t0.gender AS gender_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12, t0.status_id AS status_id_13, t0.created_by_id AS created_by_id_14, t0.address_id AS address_id_15 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  14089
]
19 0.20 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.place AS place_5, t0.confirmation AS confirmation_6, t0.contact_mode AS contact_mode_7, t0.is_displayed_on_calendar AS is_displayed_on_calendar_8, t0.external_calendar_id AS external_calendar_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.scenario_task_id AS scenario_task_id_12, t0.project_workflow_id AS project_workflow_id_13, t0.address_id AS address_id_14, t0.scenario_action_reason_id AS scenario_action_reason_id_15, t0.previous_task_id AS previous_task_id_16, t0.sprint_id AS sprint_id_17 FROM project_task t0 WHERE t0.id = ?
Parameters:
[
  24862
]
20 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_scheduled AS is_scheduled_3, t0.scheduling_delay_in_days AS scheduling_delay_in_days_4, t0.due_delay_in_days AS due_delay_in_days_5, t0.color AS color_6, t0.contact_modes AS contact_modes_7, t0.position AS position_8, t0.is_sales_targetable AS is_sales_targetable_9, t0.is_confirmable AS is_confirmable_10, t0.is_highlighted AS is_highlighted_11, t0.statistic_aggregation_name AS statistic_aggregation_name_12, t0.scenario_workflow_id AS scenario_workflow_id_13 FROM scenario_task t0 WHERE t0.id = ?
Parameters:
[
  15
]
21 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.scenario_id AS scenario_id_3 FROM scenario_action_reason t0 WHERE t0.id = ?
Parameters:
[
  1
]
22 0.20 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.place AS place_5, t0.confirmation AS confirmation_6, t0.contact_mode AS contact_mode_7, t0.is_displayed_on_calendar AS is_displayed_on_calendar_8, t0.external_calendar_id AS external_calendar_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.scenario_task_id AS scenario_task_id_12, t0.project_workflow_id AS project_workflow_id_13, t0.address_id AS address_id_14, t0.scenario_action_reason_id AS scenario_action_reason_id_15, t0.previous_task_id AS previous_task_id_16, t0.sprint_id AS sprint_id_17 FROM project_task t0 WHERE t0.id = ?
Parameters:
[
  16053
]
23 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.organization_id AS organization_id_7, t0.customer_id AS customer_id_8, t0.scenario_status_id AS scenario_status_id_9, t0.scenario_id AS scenario_id_10, t0.collaborator_id AS collaborator_id_11, t0.campaign_id AS campaign_id_12, t0.source_id AS source_id_13 FROM project t0 WHERE t0.id = ?
Parameters:
[
  9552
]
24 0.19 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.secondary_phone AS secondary_phone_6, t0.birth_date AS birth_date_7, t0.family_situation AS family_situation_8, t0.gender AS gender_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12, t0.status_id AS status_id_13, t0.created_by_id AS created_by_id_14, t0.address_id AS address_id_15 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  5451
]
25 0.18 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.place AS place_5, t0.confirmation AS confirmation_6, t0.contact_mode AS contact_mode_7, t0.is_displayed_on_calendar AS is_displayed_on_calendar_8, t0.external_calendar_id AS external_calendar_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.scenario_task_id AS scenario_task_id_12, t0.project_workflow_id AS project_workflow_id_13, t0.address_id AS address_id_14, t0.scenario_action_reason_id AS scenario_action_reason_id_15, t0.previous_task_id AS previous_task_id_16, t0.sprint_id AS sprint_id_17 FROM project_task t0 WHERE t0.id = ?
Parameters:
[
  24865
]
26 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_scheduled AS is_scheduled_3, t0.scheduling_delay_in_days AS scheduling_delay_in_days_4, t0.due_delay_in_days AS due_delay_in_days_5, t0.color AS color_6, t0.contact_modes AS contact_modes_7, t0.position AS position_8, t0.is_sales_targetable AS is_sales_targetable_9, t0.is_confirmable AS is_confirmable_10, t0.is_highlighted AS is_highlighted_11, t0.statistic_aggregation_name AS statistic_aggregation_name_12, t0.scenario_workflow_id AS scenario_workflow_id_13 FROM scenario_task t0 WHERE t0.id = ?
Parameters:
[
  8
]
27 0.18 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.place AS place_5, t0.confirmation AS confirmation_6, t0.contact_mode AS contact_mode_7, t0.is_displayed_on_calendar AS is_displayed_on_calendar_8, t0.external_calendar_id AS external_calendar_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.scenario_task_id AS scenario_task_id_12, t0.project_workflow_id AS project_workflow_id_13, t0.address_id AS address_id_14, t0.scenario_action_reason_id AS scenario_action_reason_id_15, t0.previous_task_id AS previous_task_id_16, t0.sprint_id AS sprint_id_17 FROM project_task t0 WHERE t0.id = ?
Parameters:
[
  24928
]
28 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_scheduled AS is_scheduled_3, t0.scheduling_delay_in_days AS scheduling_delay_in_days_4, t0.due_delay_in_days AS due_delay_in_days_5, t0.color AS color_6, t0.contact_modes AS contact_modes_7, t0.position AS position_8, t0.is_sales_targetable AS is_sales_targetable_9, t0.is_confirmable AS is_confirmable_10, t0.is_highlighted AS is_highlighted_11, t0.statistic_aggregation_name AS statistic_aggregation_name_12, t0.scenario_workflow_id AS scenario_workflow_id_13 FROM scenario_task t0 WHERE t0.id = ?
Parameters:
[
  9
]
29 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.scenario_id AS scenario_id_3 FROM scenario_action_reason t0 WHERE t0.id = ?
Parameters:
[
  18
]
30 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.project_state AS project_state_4, t0.is_project_successfully_completed AS is_project_successfully_completed_5, t0.is_sales_targetable AS is_sales_targetable_6, t0.is_highlighted AS is_highlighted_7, t0.scenario_id AS scenario_id_8 FROM scenario_status t0 WHERE t0.id = ?
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection
baikal doctrine.dbal.baikal_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Vision\Pipeline\Project\Entity\ProjectWorkflow 26
App\Vision\Pipeline\Project\Entity\Project 24
App\Vision\Pipeline\Project\Entity\ProjectTask 7
App\Vision\Pipeline\Scenario\Entity\ScenarioTask 6
App\Vision\Pipeline\Project\Entity\ProjectTaskAction 5
App\Vision\Common\Address\Entity\Address 4
App\Vision\Crm\Customer\Entity\Customer 3
App\Vision\Security\Entity\User 2
App\Vision\Employee\Collaborator\Entity\Collaborator 2
App\Vision\Pipeline\Scenario\Entity\ScenarioActionReason 2
App\Vision\Pipeline\Scenario\Entity\ScenarioStatus 2
App\Vision\Pipeline\Scenario\Entity\ScenarioWorkflow 2
App\Vision\Company\Organization\Entity\Organization 1
App\Vision\Pipeline\Scenario\Entity\Scenario 1
App\Vision\Security\Entity\Role 1
App\Vision\Marketing\Campaign\Entity\Campaign 1
App\Vision\Marketing\Campaign\Entity\Source 1

Entities Mapping

Class Mapping errors
App\Vision\Security\Entity\User No errors.
App\Vision\Employee\Collaborator\Entity\Collaborator No errors.
App\Vision\Company\Organization\Entity\OrganizationInvitation No errors.
App\Vision\Company\Organization\Entity\Organization No errors.
App\Vision\Common\Subscription\Entity\Subscription No errors.
App\Vision\Security\Entity\Role No errors.
App\Vision\Company\Agency\Entity\Agency No errors.
App\Vision\Employee\Team\Entity\Team No errors.
App\Vision\Pipeline\Project\Entity\ProjectWorkflow No errors.
App\Vision\Company\Agency\Entity\Directorate No errors.
App\Vision\Employee\Team\Entity\TeamMember No errors.
App\Vision\Common\Comment\Entity\Comment No errors.
App\Vision\Pipeline\Scenario\Entity\ScenarioWorkflowAssignment No errors.
App\Vision\Crm\Customer\Entity\Customer No errors.
App\Vision\Employee\Collaborator\Entity\CollaboratorCampaign No errors.
App\Vision\Pipeline\Project\Entity\ProjectTaskAction No errors.
App\Vision\Crm\Customer\Entity\CustomerActionHistory No errors.
App\Vision\Pipeline\SaleTarget\Entity\SaleTarget No errors.
App\Vision\Employee\Collaborator\Entity\CollaboratorUnavailability No errors.
App\Vision\Common\Event\Entity\Event No errors.
App\Vision\Employee\Chat\Entity\Chat No errors.
App\Vision\Pipeline\Project\Entity\Project No errors.
App\Vision\Pipeline\Sprint\Entity\Sprint No errors.
App\Vision\Common\Notification\Entity\Notification No errors.
App\Vision\Pipeline\Project\Entity\ProjectTask No errors.
App\Vision\Pipeline\Scenario\Entity\ScenarioActionReason No errors.
App\Vision\Pipeline\Scenario\Entity\ScenarioStatus No errors.
App\Vision\Common\Address\Entity\Address No errors.
App\Vision\Pipeline\Scenario\Entity\Scenario No errors.
App\Vision\Company\Organization\Entity\Partnership No errors.
App\Vision\Marketing\Campaign\Entity\Campaign No errors.
App\Vision\Common\KnowledgeBase\Entity\KnowledgeBaseCategory No errors.
App\Vision\Marketing\Campaign\Entity\Source No errors.
App\Vision\Pipeline\Scenario\Entity\ScenarioWorkflow No errors.
App\Vision\Security\Entity\Permission No errors.
App\Vision\Pipeline\Scenario\Entity\ScenarioTask No errors.
App\Vision\Pipeline\Scenario\Entity\ScenarioTaskAggregation No errors.
App\Vision\Pipeline\SaleTarget\Entity\SaleTargetReferenceScenarioTask No errors.
App\Vision\Pipeline\Scenario\Entity\ScenarioStatusActionReason No errors.
App\Vision\Pipeline\SaleTarget\Entity\SaleTargetReferenceScenarioTaskPlaced No errors.
App\Vision\Crm\Lead\Entity\Lead No errors.
App\Vision\Crm\Customer\Entity\CustomerStatus No errors.
App\Vision\Pipeline\SaleTarget\Entity\SaleTargetReferenceScenarioStatus No errors.