GET https://toncmtestsymfony.avinconcept.fr/admin/social-account

Query Metrics

17 Database Queries
8 Different statements
36.36 ms Query time
0 Invalid entities
42 Managed entities

Queries

Group similar statements

# Time Info
1 11.84 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.role AS role_7, t0.is_active AS is_active_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12 FROM "user" t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "admin@toncm.fr"
]
2 0.64 ms
"START TRANSACTION"
Parameters:
[]
3 2.39 ms
UPDATE "user" SET last_login_at = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-04-17 13:54:11"
  "2026-04-17 13:54:11"
  1
]
4 1.84 ms
"COMMIT"
Parameters:
[]
5 1.76 ms
SELECT DISTINCT s0_.id AS id_0, s0_.created_at AS created_at_1 FROM social_account s0_ ORDER BY s0_.created_at DESC LIMIT 25
Parameters:
[]
6 1.35 ms
SELECT s0_.id AS id_0, s0_.platform AS platform_1, s0_.account_name AS account_name_2, s0_.late_account_id AS late_account_id_3, s0_.late_profile_id AS late_profile_id_4, s0_.is_active AS is_active_5, s0_.last_checked_at AS last_checked_at_6, s0_.metadata AS metadata_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.organization_id AS organization_id_10, s0_.zernio_account_id AS zernio_account_id_11 FROM social_account s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.created_at DESC
Parameters:
[
  43
  42
  41
  40
  39
  38
  37
  36
  35
  34
  33
  32
  31
  30
  29
  28
  27
  26
  25
  24
  23
  22
  21
  20
  19
]
7 2.33 ms
SELECT count(*) AS sclr_0 FROM social_account s0_
Parameters:
[]
8 1.69 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  14
]
9 1.09 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  13
]
10 1.49 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  12
]
11 1.83 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  6
]
12 1.15 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  10
]
13 1.07 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  9
]
14 1.81 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  7
]
15 1.03 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  2
]
16 1.89 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  3
]
17 1.18 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.website AS website_5, t0.status AS status_6, t0.pack_type AS pack_type_7, t0.validation_mode AS validation_mode_8, t0.custom_posts_per_month AS custom_posts_per_month_9, t0.custom_max_networks AS custom_max_networks_10, t0.custom_price_ht AS custom_price_ht_11, t0.dolibarr_third_party_id AS dolibarr_third_party_id_12, t0.brand_brief AS brand_brief_13, t0.content_strategy AS content_strategy_14, t0.visual_identity AS visual_identity_15, t0.calendar_preferences AS calendar_preferences_16, t0.compliance_rules AS compliance_rules_17, t0.platform_policies AS platform_policies_18, t0.compiled_brand_core AS compiled_brand_core_19, t0.compiled_platform_policies AS compiled_platform_policies_20, t0.compiled_brief_version AS compiled_brief_version_21, t0.onboarding_step AS onboarding_step_22, t0.brief_completeness_score AS brief_completeness_score_23, t0.completed_onboarding_steps AS completed_onboarding_steps_24, t0.onboarding_part_completed_at AS onboarding_part_completed_at_25, t0.zernio_profile_id AS zernio_profile_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.assigned_cm_id AS assigned_cm_id_29 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  8
]

Database Connections

Name Service
default doctrine.dbal.default_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\Entity\SocialAccount 25
App\Entity\Organization 10
App\Entity\ZernioAccount 4
App\Entity\User 3

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Organization No errors.
App\Entity\Message No errors.
App\Entity\SocialAccount No errors.
App\Entity\ZernioAccount No errors.
App\Entity\Post No errors.
App\Entity\Asset No errors.
App\Entity\Offer No errors.
App\Entity\ContentCalendar No errors.
App\Entity\BrandBriefHistory No errors.