Query Metrics
6
Database Queries
5
Different statements
6.64 ms
Query time
3
Invalid entities
76
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.04 ms |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.user_type AS user_type_5, t0.is_admin AS is_admin_6, t0.email AS email_7, t0.password AS password_8, t0.image AS image_9, t0.statut AS statut_10, t0.fonction AS fonction_11, t0.adresse AS adresse_12, t0.code_postal AS code_postal_13, t0.ville AS ville_14, t0.pays AS pays_15, t0.telephone AS telephone_16, t0.token AS token_17, t0.contact_principal AS contact_principal_18, t0.deleted AS deleted_19, t0.archive AS archive_20, t0.telephone_fixe AS telephone_fixe_21, t0.entreprise AS entreprise_22, t0.linkedin AS linkedin_23, t0.siteweb AS siteweb_24, t0.idtoken AS idtoken_25, t0.role_id AS role_id_26, t0.client_id AS client_id_27, t0.source_id AS source_id_28, t0.soc_id AS soc_id_29 FROM user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||
| 2 | 0.95 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.forme_juridique AS forme_juridique_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.site AS site_10, t0.siren AS siren_11, t0.siret AS siret_12, t0.tva AS tva_13, t0.rcs AS rcs_14, t0.numero_rcs AS numero_rcs_15, t0.capital AS capital_16, t0.numero_tva AS numero_tva_17, t0.logo AS logo_18, t0.logo_crop AS logo_crop_19, t0.token AS token_20, t0.deleted AS deleted_21, t0.dossier AS dossier_22 FROM societe t0 WHERE t0.id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||||
| 3 | 1.35 ms |
SELECT b0_.id AS id_0, b0_.idtoken AS idtoken_1, b0_.type AS type_2, b0_.status AS status_3, b0_.number AS number_4, b0_.bank_label_snapshot AS bank_label_snapshot_5, b0_.bank_holder_snapshot AS bank_holder_snapshot_6, b0_.bank_iban_snapshot AS bank_iban_snapshot_7, b0_.bank_bic_snapshot AS bank_bic_snapshot_8, b0_.bank_currency_snapshot AS bank_currency_snapshot_9, b0_.issue_date AS issue_date_10, b0_.due_date AS due_date_11, b0_.sent_at AS sent_at_12, b0_.last_sent_to AS last_sent_to_13, b0_.send_count AS send_count_14, b0_.last_email_message_id AS last_email_message_id_15, b0_.viewed_at AS viewed_at_16, b0_.accepted_at AS accepted_at_17, b0_.paid_at AS paid_at_18, b0_.currency AS currency_19, b0_.subtotal_ht AS subtotal_ht_20, b0_.total_discount_ht AS total_discount_ht_21, b0_.total_vat AS total_vat_22, b0_.total_ttc AS total_ttc_23, b0_.total_paid AS total_paid_24, b0_.balance_due AS balance_due_25, b0_.payment_terms AS payment_terms_26, b0_.validity_days AS validity_days_27, b0_.intro_text AS intro_text_28, b0_.footer_notes AS footer_notes_29, b0_.internal_notes AS internal_notes_30, b0_.source_document_type_snapshot AS source_document_type_snapshot_31, b0_.source_document_number_snapshot AS source_document_number_snapshot_32, b0_.source_template_name_snapshot AS source_template_name_snapshot_33, b0_.customer_name_snapshot AS customer_name_snapshot_34, b0_.customer_address_snapshot AS customer_address_snapshot_35, b0_.customer_postal_code_snapshot AS customer_postal_code_snapshot_36, b0_.customer_city_snapshot AS customer_city_snapshot_37, b0_.customer_country_snapshot AS customer_country_snapshot_38, b0_.customer_vat_number_snapshot AS customer_vat_number_snapshot_39, b0_.customer_siret_snapshot AS customer_siret_snapshot_40, b0_.is_locked AS is_locked_41, b0_.locked_at AS locked_at_42, b0_.pdf_path AS pdf_path_43, b0_.created_at AS created_at_44, b0_.updated_at AS updated_at_45, b0_.deleted_at AS deleted_at_46, b0_.legacy_source_type AS legacy_source_type_47, b0_.legacy_source_id AS legacy_source_id_48, b0_.company_id AS company_id_49, b0_.customer_id AS customer_id_50, b0_.project_id AS project_id_51, b0_.bank_account_id AS bank_account_id_52, b0_.sent_by_id AS sent_by_id_53, b0_.source_document_id AS source_document_id_54 FROM billing_document b0_ WHERE b0_.company_id = ? AND b0_.deleted_at IS NULL AND b0_.type IN (?, ?, ?, ?) AND b0_.issue_date >= ? AND b0_.issue_date <= ? ORDER BY b0_.issue_date DESC, b0_.id DESC
Parameters:
[ 10 "invoice" "deposit_invoice" "balance_invoice" "credit_note" "2026-02-01 00:00:00" "2026-02-28 00:00:00" ]
|
||||||||||||||||||||||||||||||
| 4 | 1.45 ms |
SELECT c0_.id AS id_0, c0_.fundup_societe_id AS fundup_societe_id_1, c0_.nom AS nom_2, c0_.type AS type_3, c0_.siret AS siret_4, c0_.siren AS siren_5, c0_.code_naf AS code_naf_6, c0_.adresse AS adresse_7, c0_.code_postal AS code_postal_8, c0_.ville AS ville_9, c0_.departement AS departement_10, c0_.pays AS pays_11, c0_.site_web AS site_web_12, c0_.telephone AS telephone_13, c0_.created_at AS created_at_14, c0_.isdelete AS isdelete_15, c0_.email AS email_16, c0_.logo AS logo_17, c0_.notes_commerciales AS notes_commerciales_18, c0_.prospect_status AS prospect_status_19, c0_.prospect_source AS prospect_source_20, c0_.prospect_estimated_value AS prospect_estimated_value_21, c0_.converted_at AS converted_at_22, c0_.archive AS archive_23, c0_.entite AS entite_24, c0_.idtoken AS idtoken_25, c0_.forme_juridique_id AS forme_juridique_id_26, c0_.prospect_owner_id AS prospect_owner_id_27, c0_.converted_by_id AS converted_by_id_28, c0_.societe_id AS societe_id_29, c0_.banque_id AS banque_id_30, c0_.categorie_id AS categorie_id_31 FROM client c0_ WHERE c0_.archive = ? AND c0_.isdelete = ? AND c0_.entite = ? AND c0_.societe_id = ? ORDER BY c0_.nom ASC
Parameters:
[ 0 0 "Client" 10 ]
|
||||||||||||||||||||||||||||||
| 5 | 0.99 ms |
SELECT t0.id AS id_1, t0.bundle_name AS bundle_name_2, t0.active AS active_3, t0.societe_id AS societe_id_4 FROM subscription t0 WHERE t0.societe_id = ? AND t0.active = ?
Parameters:
[ 10 1 ] |
||||||||||||||||||||||||||||||
| 6 | 0.87 ms |
SELECT t0.id AS id_1, t0.bundle_name AS bundle_name_2, t0.active AS active_3, t0.societe_id AS societe_id_4 FROM subscription t0 WHERE t0.societe_id = ? AND t0.active = ?
Parameters:
[ 10 1 ] |
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\Bundle\CommercialBundle\Entity\Client | 38 |
| App\Bundle\AdminBundle\Entity\Subscription | 19 |
| App\Bundle\CommercialBundle\Entity\BillingDocument | 5 |
| App\Bundle\ProjetBundle\Entity\Projet | 5 |
| App\Bundle\CommercialBundle\Entity\FormeJuridique | 2 |
| App\Bundle\CommercialBundle\Entity\CategorieClient | 2 |
| App\Bundle\CommercialBundle\Entity\Banque | 2 |
| App\Bundle\AdminBundle\Entity\User | 1 |
| App\Bundle\AdminBundle\Entity\Role | 1 |
| App\Bundle\AdminBundle\Entity\Societe | 1 |