Redirect 302 redirect from POST @prospection_create_request (8f9ce7)

GET https://careconcept-n2a.myn2a.online/mes-prospections

Query Metrics

10 Database Queries
6 Different statements
4.62 ms Query time
0 Invalid entities
18 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.11 ms
(24.11%)
4
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 WHERE t0.id = ?
Parameters:
[
  2
]
1.11 ms
(23.97%)
2
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
  "maintenance_mode"
]
0.85 ms
(18.44%)
1
SELECT p0_.id AS id_0, p0_.type_tiers AS type_tiers_1, p0_.enseigne_prospect AS enseigne_prospect_2, p0_.nom AS nom_3, p0_.prenom AS prenom_4, p0_.email AS email_5, p0_.phone AS phone_6, p0_.created_at AS created_at_7, p0_.status AS status_8, p0_.score AS score_9, p0_.pipeline_status AS pipeline_status_10, AsBinary(p0_.location) AS location_11, p0_.latitude AS latitude_12, p0_.longitude AS longitude_13, p0_.adresse_prospect AS adresse_prospect_14, p0_.code_enseigne AS code_enseigne_15, p0_.code_agent AS code_agent_16, p0_.ifu_prospect AS ifu_prospect_17, p0_.civilite_prospect AS civilite_prospect_18, p0_.agent_nom AS agent_nom_19, p0_.agent_prenom AS agent_prenom_20, p0_.agent_photo AS agent_photo_21, p0_.tva_assuj AS tva_assuj_22, p0_.code_prospect AS code_prospect_23, p0_.barcode AS barcode_24, p0_.selected_pack_id AS selected_pack_id_25, p0_.estimated_revenue AS estimated_revenue_26, p0_.note_publique AS note_publique_27, p0_.note_privee AS note_privee_28, p0_.is_converted AS is_converted_29, p0_.conversion_pack_id AS conversion_pack_id_30, p0_.converted_at AS converted_at_31, p0_.agent_uuid AS agent_uuid_32, p0_.enseigne_id AS enseigne_id_33, p0_.campaign_id AS campaign_id_34, p0_.temperature_id AS temperature_id_35, p0_.converted_by_id AS converted_by_id_36 FROM prospections p0_ WHERE (p0_.agent_uuid = ?) AND (p0_.code_enseigne = 'YLWE') ORDER BY p0_.created_at DESC
Parameters:
[
  "b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd"
]
0.64 ms
(13.85%)
1
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:
[
  "b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd"
]
0.53 ms
(11.56%)
1
SELECT p0_.id AS id_0, p0_.score_total AS score_total_1, p0_.created_at AS created_at_2, p0_.prospection_id AS prospection_id_3, p0_.questionnaire_id AS questionnaire_id_4, p0_.commercial_uuid AS commercial_uuid_5 FROM prospect_discovery p0_ INNER JOIN prospections p1_ ON p0_.prospection_id = p1_.id AND (p1_.code_enseigne = 'YLWE') WHERE p1_.agent_uuid = ? ORDER BY p0_.created_at DESC
Parameters:
[
  "b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd"
]
0.37 ms
(8.07%)
1
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:
[
  "r_dossou@n2a.online"
]

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\Prospection 9
App\Entity\CRM\Temperature 4
App\Entity\AppConfig 2
App\Entity\Users 1
App\Entity\Enseigne 1
App\Entity\Marketing\Campaign 1