GET https://preprod.reseauglass.fr/cession/19911/new

Query Metrics

8 Database Queries
7 Different statements
17.04 ms Query time
0 Invalid entities
16 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 1.69 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.service_id AS service_id_15, t0.notif_configuration_id AS notif_configuration_id_16, t0.mail_configuration_id AS mail_configuration_id_17 FROM admin t0 WHERE t0.id = ?
Parameters:
[
  617
]
2 2.39 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.terms_and_conditions_file AS terms_and_conditions_file_70, t0.apply_terms_for_invoice AS apply_terms_for_invoice_71, t0.apply_terms_for_quote AS apply_terms_for_quote_72, t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_73, t0.supplier_id AS supplier_id_74, t0.commercial_id AS commercial_id_75, t0.category_id AS category_id_76, t0.configuration_id AS configuration_id_77, t0.bridge_user_id AS bridge_user_id_78, t0.franchise_id AS franchise_id_79, t0.franchise_supplier_id AS franchise_supplier_id_80, t81.id AS id_82, t81.provider AS provider_83, t81.email AS email_84, t81.access_token AS access_token_85, t81.refresh_token AS refresh_token_86, t81.token_expires_at AS token_expires_at_87, t81.company_id AS company_id_88 FROM companie t0 LEFT JOIN email_credential t81 ON t81.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  844
]
3 2.09 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.companie_id AS companie_id_92, t0.customer_id AS customer_id_93, t0.gestionnaire_id AS gestionnaire_id_94, t0.created_by AS created_by_95, t0.updated_by AS updated_by_96, t0.technician_id AS technician_id_97, t0.service_client_id AS service_client_id_98, t0.agent_id AS agent_id_99, t0.relanceur_id AS relanceur_id_100, t0.recouvreur_id AS recouvreur_id_101, t0.status_folder_id AS status_folder_id_102, t0.insurance_name_new_id AS insurance_name_new_id_103, t0.recovery_id AS recovery_id_104, t0.known_id AS known_id_105, t106.id AS id_107, t106.folder_id AS folder_id_108 FROM folder t0 LEFT JOIN repair_order_product t106 ON t106.folder_id = t0.id WHERE t0.id = ?
Parameters:
[
  "19911"
]
4 0.63 ms
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.referent AS referent_3, t0.company_id AS company_id_4, t0.user_id AS user_id_5, t0.known_id AS known_id_6 FROM user_company t0 WHERE t0.user_id = ?
Parameters:
[
  617
]
5 1.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.email AS email_4, t0.address AS address_5, t0.phone AS phone_6, t0.postal_code AS postal_code_7, t0.town AS town_8 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  22588
]
6 1.12 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.terms_and_conditions_file AS terms_and_conditions_file_70, t0.apply_terms_for_invoice AS apply_terms_for_invoice_71, t0.apply_terms_for_quote AS apply_terms_for_quote_72, t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_73, t0.supplier_id AS supplier_id_74, t0.commercial_id AS commercial_id_75, t0.category_id AS category_id_76, t0.configuration_id AS configuration_id_77, t0.bridge_user_id AS bridge_user_id_78, t0.franchise_id AS franchise_id_79, t0.franchise_supplier_id AS franchise_supplier_id_80, t81.id AS id_82, t81.provider AS provider_83, t81.email AS email_84, t81.access_token AS access_token_85, t81.refresh_token AS refresh_token_86, t81.token_expires_at AS token_expires_at_87, t81.company_id AS company_id_88 FROM companie t0 LEFT JOIN email_credential t81 ON t81.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  331
]
7 0.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.country AS country_6, t0.is_for_invoice AS is_for_invoice_7, t0.is_for_delivery AS is_for_delivery_8, t0.is_for_quotation AS is_for_quotation_9, t0.companie_id AS companie_id_10 FROM address t0 WHERE t0.companie_id = ?
Parameters:
[
  844
]
8 7.09 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.title AS title_3, t0.details AS details_4, t0.unit AS unit_5, t0.tax_amount AS tax_amount_6, t0.pre_tax_amount AS pre_tax_amount_7, t0.total_amount AS total_amount_8, t0.margin AS margin_9, t0.chapter AS chapter_10, t0.remise AS remise_11, t0.position AS position_12, t0.checked_ttc AS checked_ttc_13, t0.tva_id AS tva_id_14, t0.product_id AS product_id_15, t0.quotation_id AS quotation_id_16, t0.purchase_order_id AS purchase_order_id_17, t0.invoice_id AS invoice_id_18, t0.repair_order_product_id AS repair_order_product_id_19 FROM line t0 WHERE t0.repair_order_product_id = ?
Parameters:
[
  20
]

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\Company 3
App\Entity\Admin 2
App\Entity\Configuration 2
App\Entity\UserCompany 2
App\Entity\Address 2
App\Entity\Folder 1
App\Entity\Customer 1
App\Entity\RepairOrderProduct 1
App\Entity\Category 1
App\Entity\Line 1