POST https://preprod.reseauglass.fr/_components/Message:Form

Response
200 OK
Browse referrer URL
IP
196.206.89.0
Profiled on
Token
c6b2ec

Query Metrics

14 Database Queries
5 Different statements
20.28 ms Query time
0 Invalid entities
18 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 3.03 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.id = ?
Parameters: 
[
  637
]
View formatted query    View runnable query    Explain query    View query backtrace
2 5.92 ms 
SELECT t0.id AS id_1, t0.siret AS siret_2, t0.name AS name_3, t0.trade_name AS trade_name_4, t0.iban AS iban_5, t0.tva_number AS tva_number_6, t0.created_at AS created_at_7, t0.email AS email_8, t0.logo AS logo_9, t0.phone AS phone_10, t0.bic AS bic_11, t0.price AS price_12, t0.price_no_decla AS price_no_decla_13, t0.stripe_id AS stripe_id_14, t0.jeton AS jeton_15, t0.is_supplier AS is_supplier_16, t0.is_prospect AS is_prospect_17, t0.is_active AS is_active_18, t0.comment AS comment_19, t0.invoice_number_prefix AS invoice_number_prefix_20, t0.invoice_number_start_counter AS invoice_number_start_counter_21, t0.invoice_number_reset_counter AS invoice_number_reset_counter_22, t0.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23, t0.quotation_number_prefix AS quotation_number_prefix_24, t0.quotation_number_start_counter AS quotation_number_start_counter_25, t0.quotation_number_reset_counter AS quotation_number_reset_counter_26, t0.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27, t0.is_no_same_number AS is_no_same_number_28, t0.credit_number_prefix AS credit_number_prefix_29, t0.lat AS lat_30, t0.lng AS lng_31, t0.identite_recto AS identite_recto_32, t0.identite_verso AS identite_verso_33, t0.kbis AS kbis_34, t0.rib AS rib_35, t0.unsubmit_tva AS unsubmit_tva_36, t0.supplier_hello_glass AS supplier_hello_glass_37, t0.ape AS ape_38, t0.difficulty AS difficulty_39, t0.stripe_tax_rate_id AS stripe_tax_rate_id_40, t0.tax_rate AS tax_rate_41, t0.clearbus AS clearbus_42, t0.morning_start AS morning_start_43, t0.morning_end AS morning_end_44, t0.afternoon_start AS afternoon_start_45, t0.afternoon_end AS afternoon_end_46, t0.morning_saturday_start AS morning_saturday_start_47, t0.morning_saturday_end AS morning_saturday_end_48, t0.afternoon_saturday_start AS afternoon_saturday_start_49, t0.afternoon_saturday_end AS afternoon_saturday_end_50, t0.prime AS prime_51, t0.verso_invoice AS verso_invoice_52, t0.charge_folder AS charge_folder_53, t0.comment_update AS comment_update_54, t0.known_name AS known_name_55, t0.gifts AS gifts_56, t0.customer_authorisation AS customer_authorisation_57, t0.garage_type AS garage_type_58, t0.contractual_franchise AS contractual_franchise_59, t0.other_authorisation AS other_authorisation_60, t0.other_gifts AS other_gifts_61, t0.blocked AS blocked_62, t0.id_garage AS id_garage_63, t0.email_api AS email_api_64, t0.paid_date_day AS paid_date_day_65, t0.payment_method AS payment_method_66, t0.acquisition_source AS acquisition_source_67, t0.acquisition_source_detail AS acquisition_source_detail_68, t0.is_premium AS is_premium_69, t0.legal_form AS legal_form_70, t0.tax_regime AS tax_regime_71, t0.share_capital AS share_capital_72, t0.rcs AS rcs_73, t0.terms_and_conditions_file AS terms_and_conditions_file_74, t0.apply_terms_for_invoice AS apply_terms_for_invoice_75, t0.apply_terms_for_quote AS apply_terms_for_quote_76, t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_77, t0.hubspot_id AS hubspot_id_78, t0.supplier_id AS supplier_id_79, t0.commercial_id AS commercial_id_80, t0.category_id AS category_id_81, t0.configuration_id AS configuration_id_82, t0.bridge_user_id AS bridge_user_id_83, t0.franchise_id AS franchise_id_84, t0.franchise_supplier_id AS franchise_supplier_id_85, t86.id AS id_87, t86.provider AS provider_88, t86.email AS email_89, t86.access_token AS access_token_90, t86.refresh_token AS refresh_token_91, t86.token_expires_at AS token_expires_at_92, t86.company_id AS company_id_93 FROM companie t0 LEFT JOIN email_credential t86 ON t86.company_id = t0.id WHERE t0.id = ?
Parameters: 
[
  864
]
View formatted query    View runnable query    Explain query    View query backtrace
3 5.48 ms 
SELECT t0.id AS id_1, t0.registration AS registration_2, t0.registration_normalized AS registration_normalized_3, t0.vehicle_model AS vehicle_model_4, t0.insurance_name AS insurance_name_5, t0.appointment AS appointment_6, t0.appointment_end AS appointment_end_7, t0.status AS status_8, t0.windscreen AS windscreen_9, t0.insurance_card AS insurance_card_10, t0.vehicle_card AS vehicle_card_11, t0.created_at AS created_at_12, t0.professional AS professional_13, t0.tva_subject AS tva_subject_14, t0.sensor AS sensor_15, t0.athermal AS athermal_16, t0.camera AS camera_17, t0.glass AS glass_18, t0.sinister_date AS sinister_date_19, t0.declare_date AS declare_date_20, t0.sinister_reason AS sinister_reason_21, t0.sinister_circ AS sinister_circ_22, t0.sinister_location AS sinister_location_23, t0.travel_reason AS travel_reason_24, t0.invoice_due AS invoice_due_25, t0.deductible_amount AS deductible_amount_26, t0.verified_deductible AS verified_deductible_27, t0.insurance_number AS insurance_number_28, t0.cca AS cca_29, t0.procedure AS procedure_30, t0.signed AS signed_31, t0.signed_date AS signed_date_32, t0.file AS file_33, t0.known_by AS known_by_34, t0.gift AS gift_35, t0.adresse_pose AS adresse_pose_36, t0.task AS task_37, t0.updated_at AS updated_at_38, t0.relance_at AS relance_at_39, t0.is_paid AS is_paid_40, t0.sinister_number AS sinister_number_41, t0.is_assured AS is_assured_42, t0.is_send_folder AS is_send_folder_43, t0.is_send_invoice AS is_send_invoice_44, t0.cancellation_reason AS cancellation_reason_45, t0.cover AS cover_46, t0.status_command AS status_command_47, t0.ref AS ref_48, t0.ref_client AS ref_client_49, t0.km AS km_50, t0.member_client AS member_client_51, t0.member_garage AS member_garage_52, t0.is_gift_send AS is_gift_send_53, t0.status_updated AS status_updated_54, t0.pattern_cover AS pattern_cover_55, t0.judicial AS judicial_56, t0.relance_updated_at AS relance_updated_at_57, t0.relance_created_at AS relance_created_at_58, t0.relance_after_at AS relance_after_at_59, t0.sms_balance AS sms_balance_60, t0.brand AS brand_61, t0.mine_type AS mine_type_62, t0.serial_number AS serial_number_63, t0.wan_code AS wan_code_64, t0.audatex_code AS audatex_code_65, t0.euro_code AS euro_code_66, t0.vin_identified AS vin_identified_67, t0.sidexa_state AS sidexa_state_68, t0.sidexa_vehicle_model AS sidexa_vehicle_model_69, t0.data_updated AS data_updated_70, t0.category AS category_71, t0.department AS department_72, t0.complexity AS complexity_73, t0.repar AS repar_74, t0.marge AS marge_75, t0.appointment_update_reason AS appointment_update_reason_76, t0.closing_date AS closing_date_77, t0.planif_date AS planif_date_78, t0.gap AS gap_79, t0.offset_pose AS offset_pose_80, t0.duplicate AS duplicate_81, t0.couriers_parent_number AS couriers_parent_number_82, t0.state AS state_83, t0.quiz_sent_folder_submited AS quiz_sent_folder_submited_84, t0.prime_date AS prime_date_85, t0.insurance_card_added_at AS insurance_card_added_at_86, t0.vehicle_card_added_at AS vehicle_card_added_at_87, t0.windscreen_added_at AS windscreen_added_at_88, t0.last_agent_update_at AS last_agent_update_at_89, t0.openai_thread_id AS openai_thread_id_90, t0.vehicle_description AS vehicle_description_91, t0.has_partial_payment AS has_partial_payment_92, t0.paid_gap_amount AS paid_gap_amount_93, t0.gap_declarate_date AS gap_declarate_date_94, t0.hubspot_id AS hubspot_id_95, t0.ht_repair_order AS ht_repair_order_96, t0.task_verif_closed_date AS task_verif_closed_date_97, t0.first_signature_date AS first_signature_date_98, t0.companie_id AS companie_id_99, t0.customer_id AS customer_id_100, t0.gestionnaire_id AS gestionnaire_id_101, t0.created_by AS created_by_102, t0.updated_by AS updated_by_103, t0.technician_id AS technician_id_104, t0.service_client_id AS service_client_id_105, t0.agent_id AS agent_id_106, t0.relanceur_id AS relanceur_id_107, t0.recouvreur_id AS recouvreur_id_108, t0.status_folder_id AS status_folder_id_109, t0.insurance_name_new_id AS insurance_name_new_id_110, t0.recovery_id AS recovery_id_111, t0.known_id AS known_id_112 FROM folder t0 WHERE t0.id = ?
Parameters: 
[
  20445
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.87 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  2272
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  1852
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  1849
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  1850
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.27 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  1851
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  1929
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.29 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  1987
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  1988
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  2270
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.27 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.id = ?
Parameters: 
[
  2271
]
View formatted query    View runnable query    Explain query    View query backtrace
14 2.38 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.recipient_email AS recipient_email_3, t0.subject AS subject_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.notification_read AS notification_read_7, t0.link AS link_8, t0.archived AS archived_9, t0.couriers_parent_number AS couriers_parent_number_10, t0.type_folder AS type_folder_11, t0.sms_count AS sms_count_12, t0.external_id AS external_id_13, t0.last_update AS last_update_14, t0.sent_at AS sent_at_15, t0.delivered_at AS delivered_at_16, t0.opened_at AS opened_at_17, t0.status AS status_18, t0.folder_id AS folder_id_19, t0.recovery_id AS recovery_id_20, t0.created_by_id AS created_by_id_21, t0.registered_recipient_id AS registered_recipient_id_22 FROM message t0 WHERE t0.folder_id = ? ORDER BY t0.created_at DESC
Parameters: 
[
  20445
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MessageTemplate 10
App\Entity\Admin 2
App\Entity\Company 2
App\Entity\Configuration 1
App\Entity\BridgeUser 1
App\Entity\Folder 1
App\Entity\Customer 1

Entities Mapping

Class Mapping errors
App\Entity\Admin No errors.
App\Entity\AgentService No errors.
App\Entity\Configuration No errors.
App\Entity\Folder No errors.
App\Entity\Jeton No errors.
App\Entity\Task No errors.
App\Entity\Stock No errors.
App\Entity\Recovery No errors.
App\Entity\Company No errors.
App\Entity\HistoryActionAgent No errors.
App\Entity\Message No errors.
App\Entity\ContactAccessLog No errors.
App\Entity\Technician No errors.
App\Entity\UserCompany No errors.
App\Entity\InfoGlobalRead No errors.
App\Entity\InfoGLobalHistory No errors.
App\Entity\Category No errors.
App\Entity\BridgeUser No errors.
App\Entity\Franchise No errors.
App\Entity\EmailCredential No errors.
App\Entity\Address No errors.
App\Entity\Payment No errors.
App\Entity\Expense No errors.
App\Entity\MessageTemplate No errors.
App\Entity\Invoice No errors.
App\Entity\Quotation No errors.
App\Entity\PurchaseOrder No errors.
App\Entity\Product No errors.
App\Entity\Status No errors.
App\Entity\Contact No errors.
App\Entity\Department No errors.
App\Entity\Known No errors.
App\Entity\Customer No errors.
App\Entity\Comment No errors.
App\Entity\Relance No errors.
App\Entity\Document No errors.
App\Entity\FolderUploadLink No errors.
App\Entity\RepairOrderProduct No errors.
App\Entity\MissedDocument No errors.