Query Metrics
5
Database Queries
5
Different statements
15.31 ms
Query time
17
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.24 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_1SZtTmHb1D2L5bgxSWH5ROHR"
]
|
| 2 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 4.23 ms |
INSERT INTO invoice (stripe_invoice_id, amount, STATUS, paid_at, created, updated, subscription_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "in_1Sl8GeHb1D2L5bgxAvcU4K3D" 2 => "100" 3 => "payment_failed" 4 => null 5 => "2026-01-02 17:18:31" 6 => "2026-01-02 17:18:31" 7 => 282 ] |
| 4 | 1.13 ms |
"COMMIT"
Parameters:
[] |
| 5 | 5.51 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.name AS name_6, t0.firstname AS firstname_7, t0.telephone AS telephone_8, t0.address AS address_9, t0.status AS status_10, t0.resettoken AS resettoken_11, t0.tradingname AS tradingname_12, t0.sir AS sir_13, t0.tva AS tva_14, t0.dispomon AS dispomon_15, t0.dispotue AS dispotue_16, t0.dispowed AS dispowed_17, t0.dispothu AS dispothu_18, t0.dispofri AS dispofri_19, t0.disposat AS disposat_20, t0.disposun AS disposun_21, t0.stripe_customer_id AS stripe_customer_id_22, t0.mgp_user_id AS mgp_user_id_23, t0.mgp_wallet_id AS mgp_wallet_id_24, t0.mgp_card_id AS mgp_card_id_25, t0.logo AS logo_26, t0.gender AS gender_27, t0.num_national_register AS num_national_register_28, t0.iban AS iban_29, t0.longitude AS longitude_30, t0.latitude AS latitude_31, t0.client_sales_agreement_discussions AS client_sales_agreement_discussions_32, t0.client_deed_of_sale_discussions AS client_deed_of_sale_discussions_33, t0.committee_avatar AS committee_avatar_34, t0.committee_surname AS committee_surname_35, t0.is_admin AS is_admin_36, t0.admin_id AS admin_id_37, t0.house_number AS house_number_38, t0.house_addition AS house_addition_39, t0.last_notification AS last_notification_40, t0.device_token AS device_token_41, t0.region AS region_42, t0.municipality AS municipality_43, t0.country AS country_44, t0.imported AS imported_45, t0.is_moving_company AS is_moving_company_46, t0.mail_id AS mail_id_47, t0.mail_mini AS mail_mini_48, t0.check_sum AS check_sum_49, t0.personnal_abonnement AS personnal_abonnement_50, t0.certification_area AS certification_area_51, t0.inbox_id AS inbox_id_52, t0.inbox_email AS inbox_email_53, t0.supplier_id AS supplier_id_54, t0.code_client AS code_client_55, t0.created AS created_56, t0.updated AS updated_57, t58.id AS id_59, t58.created AS created_60, t58.updated AS updated_61, t58.syndic_id AS syndic_id_62, t63.id AS id_64, t63.study AS study_65, t63.associate_name AS associate_name_66, t63.associate_firstname AS associate_firstname_67, t63.associate_email AS associate_email_68, t63.address AS address_69, t63.fax AS fax_70, t63.site AS site_71, t63.telephone AS telephone_72, t63.bce AS bce_73, t63.check_sum AS check_sum_74, t63.name AS name_75, t63.firstname AS firstname_76, t63.email AS email_77, t63.postal_code AS postal_code_78, t63.municipality AS municipality_79, t63.street AS street_80, t63.country AS country_81, t63.latitude AS latitude_82, t63.longitude AS longitude_83, t63.region AS region_84, t63.user_id AS user_id_85 FROM user t0 LEFT JOIN co_ownership t58 ON t58.syndic_id = t0.id LEFT JOIN notary t63 ON t63.user_id = t0.id WHERE t0.id = ?
Parameters:
[
28
]
|
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\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\Alert |
|
| App\Entity\CoOwnership | No errors. |
| App\Entity\Notary | No errors. |
| App\Entity\Lastvisit | No errors. |
| 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 |
|
| 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 |
|
| 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\T3dDemands | No errors. |
| App\Entity\ImoAgent\ImoAgentSolicitation | No errors. |
| App\Entity\ClientSalesAgreement | No errors. |
| App\Entity\UserRating\UserRating | No errors. |
| App\Entity\MarkofInterest | No errors. |
| App\Entity\EditRegisters | No errors. |
| App\Entity\Registers |
|
| App\Entity\PermitProperty | No errors. |
| App\Entity\AnnexPermitProperty | No errors. |
| App\Entity\Plan\FeatureUsage | No errors. |
import entity manager
No loaded entities.