GET https://careconcept-n2a.myn2a.online/prospection/create?campaignId=2

Query Metrics

8 Database Queries
7 Different statements
4.92 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 1.18 ms
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
  "maintenance_mode"
]
2 0.33 ms
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
  "maintenance_resume_at"
]
3 0.72 ms
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = ?
Parameters:
[
  "c3e7bd9e-da51-4d2e-b58e-fe3a133c1ad4"
]
4 0.78 ms
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = ? LIMIT 1
Parameters:
[
  "c_abou@n2a.online"
]
5 0.44 ms
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_26 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "c3e7bd9e-da51-4d2e-b58e-fe3a133c1ad4"
]
6 0.33 ms
SELECT t0.id AS id_1, t0.role_in_unit AS role_in_unit_2, t0.is_manager AS is_manager_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.assigned_at AS assigned_at_6, t0.user_uuid AS user_uuid_7, t0.unit_id AS unit_id_8 FROM hr_user_unit t0 WHERE t0.user_uuid = ?
Parameters:
[
  "c3e7bd9e-da51-4d2e-b58e-fe3a133c1ad4"
]
7 0.89 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.status AS status_5, c0_.is_active AS is_active_6, c0_.season_id AS season_id_7, c0_.enseigne_id AS enseigne_id_8, c0_.owner_unit_id AS owner_unit_id_9 FROM campaign c0_ INNER JOIN campaign_unit_assignment c1_ ON c0_.id = c1_.campaign_id INNER JOIN hr_organizational_unit h2_ ON c1_.organizational_unit_id = h2_.id WHERE c0_.is_active = ? AND h2_.id IN (?) ORDER BY c0_.name ASC
Parameters:
[
  1
  "69a7c20a-0fa5-4ac5-acb7-7af46b574d86"
]
8 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.weight AS weight_3, t0.color AS color_4, t0.description AS description_5 FROM temperature t0 ORDER BY t0.weight ASC
Parameters:
[]

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\CRM\Temperature 7
App\Entity\AppConfig 2
App\Entity\Users 1
App\Entity\HR\UserOrganizationalUnit 1
App\Entity\HR\OrganizationalUnit 1
App\Entity\Marketing\Campaign 1
App\Entity\Marketing\Season 1
App\Entity\Enseigne 1