Query Metrics
5
Database Queries
5
Different statements
27.55 ms
Query time
15
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 6.57 ms |
SELECT t0.id AS id_1, t0.stripe_subscription_id AS stripe_subscription_id_2, t0.status AS status_3, t0.current_period_start AS current_period_start_4, t0.current_period_end AS current_period_end_5, t0.cancel_at_period_end AS cancel_at_period_end_6, t0.cancellation_reason AS cancellation_reason_7, t0.canceled_at AS canceled_at_8, t0.plan_id AS plan_id_9, t0.user_id AS user_id_10 FROM plan_subscription t0 WHERE t0.stripe_subscription_id = ? LIMIT 1
Parameters:
[
"sub_1TetOLHb1D2L5bgx46h4cOpE"
]
|
| 2 | 1.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 10.47 ms |
INSERT INTO invoice (stripe_invoice_id, amount, STATUS, paid_at, created, updated, subscription_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "in_1Tplh8Hb1D2L5bgxMf9tDsFe" 2 => "100" 3 => "payment_failed" 4 => null 5 => "2026-07-17 21:02:40" 6 => "2026-07-17 21:02:40" 7 => 397 ] |
| 4 | 1.71 ms |
"COMMIT"
Parameters:
[] |
| 5 | 7.70 ms |
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.two_factor_code AS two_factor_code_6, t0.two_factor_code_expires_at AS two_factor_code_expires_at_7, t0.two_factor_temp_token AS two_factor_temp_token_8, t0.name AS name_9, t0.firstname AS firstname_10, t0.telephone AS telephone_11, t0.address AS address_12, t0.status AS status_13, t0.resettoken AS resettoken_14, t0.tradingname AS tradingname_15, t0.sir AS sir_16, t0.tva AS tva_17, t0.dispomon AS dispomon_18, t0.dispotue AS dispotue_19, t0.dispowed AS dispowed_20, t0.dispothu AS dispothu_21, t0.dispofri AS dispofri_22, t0.disposat AS disposat_23, t0.disposun AS disposun_24, t0.stripe_customer_id AS stripe_customer_id_25, t0.mgp_user_id AS mgp_user_id_26, t0.mgp_wallet_id AS mgp_wallet_id_27, t0.mgp_card_id AS mgp_card_id_28, t0.logo AS logo_29, t0.gender AS gender_30, t0.num_national_register AS num_national_register_31, t0.iban AS iban_32, t0.longitude AS longitude_33, t0.latitude AS latitude_34, t0.client_sales_agreement_discussions AS client_sales_agreement_discussions_35, t0.client_deed_of_sale_discussions AS client_deed_of_sale_discussions_36, t0.committee_avatar AS committee_avatar_37, t0.committee_surname AS committee_surname_38, t0.is_admin AS is_admin_39, t0.admin_id AS admin_id_40, t0.house_number AS house_number_41, t0.house_addition AS house_addition_42, t0.last_notification AS last_notification_43, t0.device_token AS device_token_44, t0.region AS region_45, t0.municipality AS municipality_46, t0.country AS country_47, t0.imported AS imported_48, t0.is_moving_company AS is_moving_company_49, t0.mail_id AS mail_id_50, t0.mail_mini AS mail_mini_51, t0.check_sum AS check_sum_52, t0.personnal_abonnement AS personnal_abonnement_53, t0.certification_area AS certification_area_54, t0.inbox_id AS inbox_id_55, t0.inbox_email AS inbox_email_56, t0.supplier_id AS supplier_id_57, t0.code_client AS code_client_58, t0.username AS username_59, t0.pseudonym AS pseudonym_60, t0.referral_token AS referral_token_61, t0.created AS created_62, t0.updated AS updated_63, t64.id AS id_65, t64.created AS created_66, t64.updated AS updated_67, t64.syndic_id AS syndic_id_68, t69.id AS id_70, t69.study AS study_71, t69.associate_name AS associate_name_72, t69.associate_firstname AS associate_firstname_73, t69.associate_email AS associate_email_74, t69.address AS address_75, t69.fax AS fax_76, t69.site AS site_77, t69.telephone AS telephone_78, t69.bce AS bce_79, t69.check_sum AS check_sum_80, t69.name AS name_81, t69.firstname AS firstname_82, t69.email AS email_83, t69.postal_code AS postal_code_84, t69.municipality AS municipality_85, t69.street AS street_86, t69.country AS country_87, t69.latitude AS latitude_88, t69.longitude AS longitude_89, t69.region AS region_90, t69.user_id AS user_id_91 FROM user t0 LEFT JOIN co_ownership t64 ON t64.syndic_id = t0.id LEFT JOIN notary t69 ON t69.user_id = t0.id WHERE t0.id = ?
Parameters:
[
22
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| import | doctrine.orm.import_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Municipality | No errors. |
| App\Entity\BankSimulation | No errors. |
| App\Entity\ProviderSibelga | No errors. |
| App\Entity\ProviderSibelgaWork | No errors. |
| App\Entity\ProviderSociety | No errors. |
| App\Entity\TheProperty |
|
| App\Entity\ProviderSolar | No errors. |
| App\Entity\ProviderSolarDeclarationCadastre | No errors. |
| App\Entity\TimelineEvent | No errors. |
| App\Entity\Theservice | No errors. |
| App\Entity\AppointmentRequest | No errors. |
| App\Entity\ClientDeedOfSale | No errors. |
| App\Entity\Solicitation | No errors. |
| App\Entity\UserServicePromo |
|
| App\Entity\User |
|
| App\Entity\LeaseContract | No errors. |
| App\Entity\Plan\FeatureUsage | No errors. |
| App\Entity\Plan\PlanSubscription | No errors. |
| App\Entity\Offer |
|
| App\Entity\DomiciliationFiles | No errors. |
| App\Entity\Typeofwork |
|
| App\Entity\Subsection | No errors. |
| App\Entity\Choicecategory | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\PdfMailLocation | No errors. |
| App\Entity\ThePropertyWork |
|
| App\Entity\Plan\Plan | No errors. |
| App\Entity\Plan\Invoice | No errors. |
| App\Entity\CoOwnership | No errors. |
| App\Entity\Notary | No errors. |
| App\Entity\Lastvisit | No errors. |
| App\Entity\Alert |
|
| App\Entity\Save | No errors. |
| App\Entity\Visitproperty | No errors. |
| App\Entity\Announcement |
|
| App\Entity\Subscription | No errors. |
| App\Entity\Orders | No errors. |
| App\Entity\ServiceOffer |
|
| App\Entity\ThepropertyOfferInterested | No errors. |
| App\Entity\ThepropertyOfferChat |
|
| App\Entity\KycDocument | No errors. |
| App\Entity\UboDocument | No errors. |
| App\Entity\SyndicGroup | No errors. |
| App\Entity\SyndicChat | No errors. |
| App\Entity\SyndicDocumentComment |
|
| App\Entity\ThePropertyExteriorComment | No errors. |
| App\Entity\Purchase | No errors. |
| App\Entity\ResultEngie | No errors. |
| App\Entity\EnergyBelgique | No errors. |
| App\Entity\ThepropertyOffer | No errors. |
| App\Entity\PurchasePartnerRequest | No errors. |
| App\Entity\CommunityPost | No errors. |
| App\Entity\CommunityPostComment | No errors. |
| App\Entity\CommunityPostLike | No errors. |
| App\Entity\Committee | No errors. |
| App\Entity\CommunityServiceResponse | No errors. |
| App\Entity\CommunityPlpVote | No errors. |
| App\Entity\CommunityPurchase | No errors. |
| App\Entity\CommunityVoteConsultation | No errors. |
| App\Entity\CommunityCoordinate | No errors. |
| App\Entity\AlertNewProjectImmo | No errors. |
| App\Entity\CommunitySolicitationVote | No errors. |
| App\Entity\CommunityWorkVote | No errors. |
| App\Entity\UrbanPermit | No errors. |
| App\Entity\ColectiveGarden | No errors. |
| App\Entity\Society | No errors. |
| App\Entity\SocietyUse | No errors. |
| App\Entity\CounterOffer | No errors. |
| App\Entity\Education |
|
| App\Entity\OfferLease |
|
| App\Entity\CarpoolAnnouncement | No errors. |
| App\Entity\Bankdetails | No errors. |
| App\Entity\IdentityDocument | No errors. |
| App\Entity\StarRatings | No errors. |
| App\Entity\CoOwnershipAgenda | No errors. |
| App\Entity\ThepropertyLot | No errors. |
| App\Entity\RelookingSave |
|
| App\Entity\CoOwnershipTheProperty | No errors. |
| App\Entity\CoOwnershipProposition | No errors. |
| App\Entity\Portfolio | No errors. |
| App\Entity\GardenProjectActionsLot | No errors. |
| App\Entity\WorkArt | No errors. |
| App\Entity\RentalManagement | No errors. |
| App\Entity\RentalManagementLeave | No errors. |
| App\Entity\UserPurchasePartnerRequest | No errors. |
| App\Entity\PublicityUser | No errors. |
| App\Entity\ClientSalesAgreement | No errors. |
| App\Entity\UserRating\UserRating | No errors. |
| App\Entity\MarkofInterest | No errors. |
| App\Entity\Referral | No errors. |
| App\Entity\EditRegisters | No errors. |
| App\Entity\Registers |
|
| App\Entity\PermitProperty | No errors. |
| App\Entity\AnnexPermitProperty | No errors. |
import entity manager
No loaded entities.