Query Metrics
5
Database Queries
5
Different statements
18.21 ms
Query time
2
Invalid entities
43
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.06 ms (38.75%) |
1 |
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.glazings_order AS glazings_order_79, t0.glazings_supplier_token_created_at AS glazings_supplier_token_created_at_80, t0.glazings_supplier_token AS glazings_supplier_token_81, t0.glazings_supplier_ship_code AS glazings_supplier_ship_code_82, t0.glace_order_option AS glace_order_option_83, t0.pilkington_id AS pilkington_id_84, t0.pilkington_password AS pilkington_password_85, t0.rf_organisation_id AS rf_organisation_id_86, t0.use_reseau_facture AS use_reseau_facture_87, t0.account_pilkington_id AS account_pilkington_id_88, t0.is_subscribed AS is_subscribed_89, t0.is_pre_subscription AS is_pre_subscription_90, t0.supplier_id AS supplier_id_91, t0.commercial_id AS commercial_id_92, t0.csm_id AS csm_id_93, t0.category_id AS category_id_94, t0.configuration_id AS configuration_id_95, t0.bridge_user_id AS bridge_user_id_96, t0.franchise_id AS franchise_id_97, t0.franchise_supplier_id AS franchise_supplier_id_98, t0.email_credential_id AS email_credential_id_99, t100.id AS id_101, t100.provider AS provider_102, t100.email AS email_103, t100.access_token AS access_token_104, t100.refresh_token AS refresh_token_105, t100.token_expires_at AS token_expires_at_106, t0.glace_order_adresse_id AS glace_order_adresse_id_107, t0.pilkington_account_request_id AS pilkington_account_request_id_108, t109.id AS id_110, t109.status AS status_111, t109.payment_method AS payment_method_112, t109.trial_start_date AS trial_start_date_113, t109.trial_end_date AS trial_end_date_114, t109.billing_mode AS billing_mode_115, t109.monthly_amount AS monthly_amount_116, t109.tax_rate AS tax_rate_117, t109.stripe_customer_id AS stripe_customer_id_118, t109.stripe_subscription_id AS stripe_subscription_id_119, t109.stripe_price_id AS stripe_price_id_120, t109.sepa_iban AS sepa_iban_121, t109.sepa_bic AS sepa_bic_122, t109.mandate_reference AS mandate_reference_123, t109.mandate_signature_date AS mandate_signature_date_124, t109.current_period_start AS current_period_start_125, t109.current_period_end AS current_period_end_126, t109.renewal_date AS renewal_date_127, t109.last_renewal_attempt AS last_renewal_attempt_128, t109.last_renewal_error AS last_renewal_error_129, t109.first_invoice_id AS first_invoice_id_130, t109.created_at AS created_at_131, t109.updated_at AS updated_at_132, t109.company_id AS company_id_133, t109.created_by_id AS created_by_id_134, t135.id AS id_136, t135.created_at AS created_at_137, t135.company_id AS company_id_138, t135.validated_by_id AS validated_by_id_139 FROM companie t0 LEFT JOIN email_credential t100 ON t0.email_credential_id = t100.id LEFT JOIN subscription t109 ON t109.company_id = t0.id LEFT JOIN company_validation t135 ON t135.company_id = t0.id WHERE t0.id = ?
Parameters:
[
864
]
|
||||||||||||||||||||||||||||
|
4.83 ms (26.51%) |
1 |
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:
[
"20804"
]
|
||||||||||||||||||||||||||||
|
4.10 ms (22.50%) |
1 |
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.rf_access_token AS rf_access_token_18, t0.rf_refresh_token AS rf_refresh_token_19, t0.service_id AS service_id_20, t0.notif_configuration_id AS notif_configuration_id_21, t0.mail_configuration_id AS mail_configuration_id_22 FROM admin t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"poseuradmin@reseauglass.fr"
]
|
||||||||||||||||||||||||||||
|
1.14 ms (6.24%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.referent AS referent_3, t0.hubspot_id AS hubspot_id_4, t0.company_id AS company_id_5, t0.user_id AS user_id_6, t0.known_id AS known_id_7 FROM user_company t0 WHERE t0.user_id = ?
Parameters:
[
637
]
|
||||||||||||||||||||||||||||
|
1.09 ms (6.00%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.name AS name_3, t0.color AS color_4, t0.email AS email_5, t0.phone AS phone_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.is_active AS is_active_9, t0.info AS info_10, t0.department AS department_11, t0.companie_id AS companie_id_12, t0.technician_id AS technician_id_13, t0.address_id AS address_id_14 FROM technician t0 WHERE t0.companie_id = ? AND t0.is_active = ?
Parameters:
[ 864 1 ]
|
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\Admin | 11 |
| App\Entity\Address | 11 |
| App\Entity\Technician | 10 |
| App\Entity\Company | 2 |
| App\Entity\Configuration | 1 |
| App\Entity\BridgeUser | 1 |
| App\Entity\Franchise | 1 |
| App\Entity\PilkingtonAccountRequest | 1 |
| App\Entity\Subscription | 1 |
| App\Entity\Folder | 1 |
| App\Entity\Customer | 1 |
| App\Entity\Status | 1 |
| App\Entity\UserCompany | 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 |
|
| 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\PilkingtonAccountRequest | No errors. |
| App\Entity\Subscription |
|
| App\Entity\CompanyValidation | 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\GlazingsOrder | No errors. |
| App\Entity\SEPAMandate | 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. |
| App\Entity\NotAvailable | No errors. |