GET https://preprod.reseauglass.fr/api/folder/20804/technicians

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

Queries

Group similar statements

# Time Info
1 4.10 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.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"
]
2 7.06 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.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
]
3 4.83 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:
[
  "20804"
]
4 1.14 ms
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
]
5 1.09 ms
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
  • The field App\Entity\Company#subscription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Subscription#company does not contain the required 'inversedBy: "subscription"' attribute.
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
  • The field App\Entity\Subscription#sepaMandates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEPAMandate#subscription does not contain the required 'inversedBy: "sepaMandates"' attribute.
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.