Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.83 ms Query time

9 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.83 ms	SELECT t0.id AS id_1, t0.stripe_customer AS stripe_customer_2, t0.stripe_product AS stripe_product_3, t0.payment_method AS payment_method_4, t0.payment_intent AS payment_intent_5, t0.plan_interval AS plan_interval_6, t0.paid_amount AS paid_amount_7, t0.status AS status_8, t0.created AS created_9, t0.plan_period_start AS plan_period_start_10, t0.plan_period_end AS plan_period_end_11, t0.quantity AS quantity_12, t0.plan_id AS plan_id_13, t0.center_id AS center_id_14, t0.audio_id AS audio_id_15, t0.contract_category_id AS contract_category_id_16 FROM specific_subscription t0 WHERE t0.stripe_customer = ? LIMIT 1 Parameters: [`"cus_ScN1JBfXJj5fpM"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.stripe_customer AS stripe_customer_2, t0.stripe_product AS stripe_product_3, t0.payment_method AS payment_method_4, t0.payment_intent AS payment_intent_5, t0.plan_interval AS plan_interval_6, t0.paid_amount AS paid_amount_7, t0.status AS status_8, t0.created AS created_9, t0.plan_period_start AS plan_period_start_10, t0.plan_period_end AS plan_period_end_11, t0.quantity AS quantity_12, t0.plan_id AS plan_id_13, t0.center_id AS center_id_14, t0.audio_id AS audio_id_15, t0.contract_category_id AS contract_category_id_16 FROM specific_subscription t0 WHERE t0.stripe_customer = ? LIMIT 1 SELECT t0.id AS id_1, t0.stripe_customer AS stripe_customer_2, t0.stripe_product AS stripe_product_3, t0.payment_method AS payment_method_4, t0.payment_intent AS payment_intent_5, t0.plan_interval AS plan_interval_6, t0.paid_amount AS paid_amount_7, t0.status AS status_8, t0.created AS created_9, t0.plan_period_start AS plan_period_start_10, t0.plan_period_end AS plan_period_end_11, t0.quantity AS quantity_12, t0.plan_id AS plan_id_13, t0.center_id AS center_id_14, t0.audio_id AS audio_id_15, t0.contract_category_id AS contract_category_id_16 FROM specific_subscription t0 WHERE t0.stripe_customer = 'cus_ScN1JBfXJj5fpM' LIMIT 1;

#▲

Time

Info

0.83 ms

SELECT t0.id AS id_1, t0.stripe_customer AS stripe_customer_2, t0.stripe_product AS stripe_product_3, t0.payment_method AS payment_method_4, t0.payment_intent AS payment_intent_5, t0.plan_interval AS plan_interval_6, t0.paid_amount AS paid_amount_7, t0.status AS status_8, t0.created AS created_9, t0.plan_period_start AS plan_period_start_10, t0.plan_period_end AS plan_period_end_11, t0.quantity AS quantity_12, t0.plan_id AS plan_id_13, t0.center_id AS center_id_14, t0.audio_id AS audio_id_15, t0.contract_category_id AS contract_category_id_16 FROM specific_subscription t0 WHERE t0.stripe_customer = ? LIMIT 1

Parameters:

[
  "cus_ScN1JBfXJj5fpM"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.stripe_customer AS stripe_customer_2,
  t0.stripe_product AS stripe_product_3,
  t0.payment_method AS payment_method_4,
  t0.payment_intent AS payment_intent_5,
  t0.plan_interval AS plan_interval_6,
  t0.paid_amount AS paid_amount_7,
  t0.status AS status_8,
  t0.created AS created_9,
  t0.plan_period_start AS plan_period_start_10,
  t0.plan_period_end AS plan_period_end_11,
  t0.quantity AS quantity_12,
  t0.plan_id AS plan_id_13,
  t0.center_id AS center_id_14,
  t0.audio_id AS audio_id_15,
  t0.contract_category_id AS contract_category_id_16
FROM
  specific_subscription t0
WHERE
  t0.stripe_customer = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.stripe_customer AS stripe_customer_2, t0.stripe_product AS stripe_product_3, t0.payment_method AS payment_method_4, t0.payment_intent AS payment_intent_5, t0.plan_interval AS plan_interval_6, t0.paid_amount AS paid_amount_7, t0.status AS status_8, t0.created AS created_9, t0.plan_period_start AS plan_period_start_10, t0.plan_period_end AS plan_period_end_11, t0.quantity AS quantity_12, t0.plan_id AS plan_id_13, t0.center_id AS center_id_14, t0.audio_id AS audio_id_15, t0.contract_category_id AS contract_category_id_16 FROM specific_subscription t0 WHERE t0.stripe_customer = 'cus_ScN1JBfXJj5fpM' LIMIT 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.

Entities Mapping

Class	Mapping errors
App\Entity\SpecificSubscription	No errors.
App\Entity\Plan	No errors.
App\Entity\Centre	The mappings App\Entity\Centre#audioCentre and App\Entity\AudioCentre#id_centre are inconsistent with each other. The field App\Entity\Centre#centrePrestations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CentrePrestation#id_centre does not contain the required 'inversedBy="centrePrestations"' attribute. The field App\Entity\Centre#centreMutuelles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CentreMutuelle#id_centre does not contain the required 'inversedBy="centreMutuelles"' attribute. The association App\Entity\Centre#accessUsers refers to the owning side field App\Entity\AccessControl\AccessUser#center which does not exist. The field App\Entity\Centre#partnerSubscription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Partner\PartnerSubscription#centre does not contain the required 'inversedBy="partnerSubscription"' attribute.
App\Entity\Audio	The mappings App\Entity\Audio#audioCentre and App\Entity\AudioCentre#id_audio are inconsistent with each other. The field App\Entity\Audio#audioSpecialites is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AudioSpecialite#id_audio does not contain the required 'inversedBy="audioSpecialites"' attribute. The field App\Entity\Audio#partnerSubscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Partner\PartnerSubscription#audio does not contain the required 'inversedBy="partnerSubscriptions"' attribute.
App\Entity\ContractCategory	The field 'App\Entity\ContractCategory#abonnementPriceHT' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ContractCategory#abonnementPriceTtc' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ContractCategory#comissionPriceHt' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ContractCategory#commissionPriceTtc' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PaymentMethod	No errors.
App\Entity\Payment\Subscription	No errors.
App\Entity\Partner\PartnerSubscription	No errors.
App\Entity\Assistante	No errors.
App\Entity\AudioCentre	The association App\Entity\AudioCentre#id_audio refers to the inverse side field App\Entity\Audio#audioCentres which does not exist. The association App\Entity\AudioCentre#id_centre refers to the inverse side field App\Entity\Centre#audioCentres which does not exist.
App\Entity\AccessCentre	No errors.
App\Entity\CentrePrestation	No errors.
App\Entity\CentreMutuelle	No errors.
App\Entity\Reminder	No errors.
App\Entity\Factures	No errors.
App\Entity\Audiometrie\Setting	No errors.
App\Entity\Audiometrie\TonaleSession	No errors.
App\Entity\Audiometrie\VocalSession	No errors.
App\Entity\CenterImage	No errors.
App\Entity\AccessControl\AccessRole	No errors.
App\Entity\AccessControl\AccessUser	No errors.
App\Entity\ImportHistory	No errors.
App\Entity\CentreDocument	No errors.
App\Entity\Notification\CentreStaff	No errors.
App\Entity\Device\ClientDevice	No errors.
App\Entity\Commission	No errors.
App\Entity\CancellationRecord	No errors.
App\Entity\FailedPaymentNotification	No errors.
App\Entity\Partner\AudioLibrePartner	No errors.
App\Entity\Remplacant	No errors.
App\Entity\ExperiencePro	No errors.
App\Entity\Note	No errors.
App\Entity\ClientTemp	The field App\Entity\ClientTemp#santeAmc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\SanteAmc#clientTemp does not contain the required 'inversedBy="santeAmc"' attribute. The field App\Entity\ClientTemp#rdvs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Rdv#id_client_temp does not contain the required 'inversedBy="rdvs"' attribute.
App\Entity\Token	No errors.
App\Entity\Audio\Role	No errors.
App\Entity\SynchronisationSetting	No errors.
App\Entity\GoogleAgenda	No errors.
App\Entity\OrderPatientDatatable	No errors.
App\Entity\Diplome	No errors.
App\Entity\Synchronisation\CosiumCategorie	No errors.
App\Entity\AudioSpecialite	No errors.
App\Entity\Partner\AudioPartner	No errors.
App\Entity\Permission	No errors.
App\Entity\Lieu	No errors.
App\Entity\Prestation	No errors.
App\Entity\Mutuelle	No errors.
App\Entity\Client	The field App\Entity\Client#santeAmc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\SanteAmc#client does not contain the required 'inversedBy="santeAmc"' attribute. The field App\Entity\Client#rdvs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Rdv#id_client does not contain the required 'inversedBy="rdvs"' attribute. The field App\Entity\Client#leadRdvs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LeadRdv#client does not contain the required 'inversedBy="leadRdvs"' attribute.
App\Entity\Audiometrie\SessionTonaleAnswer	No errors.
App\Entity\Audiometrie\SessionVocalAnswer	No errors.
App\Entity\AccessControl\AccessPermission	No errors.
App\Entity\Document	No errors.
App\Entity\Device\Device	No errors.
App\Entity\Rdv	No errors.
App\Entity\Device\SettingDevice	No errors.
App\Entity\RemplacantSpecialite	No errors.
App\Entity\Client\AssureCivility	No errors.
App\Entity\RoadType	No errors.
App\Entity\Client\BirthOrder	No errors.
App\Entity\Client\SanteAmo	No errors.
App\Entity\Client\SanteAmc	No errors.
App\Entity\ClientAnamnese	No errors.
App\Entity\ClientDocument	No errors.
App\Entity\ClientStatus	No errors.
App\Entity\Administrateur	No errors.
App\Entity\RdvEvent	No errors.
App\Entity\Motif	No errors.
App\Entity\Specialite	No errors.
App\Entity\PageInfoCategorie	No errors.
App\Entity\Client\QualityAmo	No errors.
App\Entity\Client\RelationAmc	No errors.
App\Entity\LieuTier	No errors.
App\Entity\CallLog	No errors.
App\Entity\AudioMotif	No errors.
App\Entity\CenterImported	No errors.
App\Entity\PageTag	No errors.
App\Entity\Holiday	No errors.
App\Entity\Ville	No errors.
App\Entity\Station	No errors.
App\Entity\Anamnese	No errors.
App\Entity\AudioCommentaire	No errors.
App\Entity\CentreTemp	No errors.
App\Entity\AudioDiplome	No errors.
App\Entity\ProfilPermission	No errors.
App\Entity\TrustedUser	No errors.
App\Entity\Page	No errors.
App\Entity\Partner\BillingAudioLibre	The association App\Entity\Partner\BillingAudioLibre#billingFile refers to the inverse side field App\Entity\Partner\BillingFile#billingAudioLibres which does not exist. The association App\Entity\Partner\BillingAudioLibre#audioLibrePartner refers to the inverse side field App\Entity\Partner\AudioLibrePartner#billingAudioLibres which does not exist.
App\Entity\Partner\BillingCda	No errors.
App\Entity\Partner\BillingFile	No errors.
App\Entity\HelpQuestions	No errors.
App\Entity\Article	No errors.
App\Entity\OrderDatatable	No errors.
App\Entity\AudioHelpQuestions	No errors.
App\Entity\ClientBlocked	No errors.
App\Entity\Contact	No errors.
App\Entity\Notification\RdvSms	No errors.
App\Entity\Synchronisation\CosiumRdv	No errors.
App\Entity\Synchronisation\CosiumEvent	The mappings App\Entity\Synchronisation\CosiumEvent#synchronisationCosium and App\Entity\Synchronisation\SynchronisationCosium#cosiumEvents are inconsistent with each other.
App\Entity\Synchronisation\CosiumCenter	No errors.
App\Entity\Synchronisation\SynchronisationCosium	The association App\Entity\Synchronisation\SynchronisationCosium#cosiumEvents refers to the owning side field App\Entity\Synchronisation\CosiumEvent#sunchronisationCosium which does not exist.
App\Entity\LieuMutuelle	No errors.
App\Entity\LeadStatus	No errors.
App\Entity\ArticleTag	No errors.
App\Entity\LieuPrestation	No errors.
App\Entity\TestQuestion	No errors.
App\Entity\Legal	No errors.
App\Entity\StatusRdv	No errors.
App\Entity\PageCategorie	No errors.
App\Entity\Profil	No errors.
App\Entity\DeletionRequest	No errors.
App\Entity\FAQ	No errors.
App\Entity\ArticleCategorie	No errors.
App\Entity\LogRelance	No errors.
App\Entity\Categorie	No errors.
App\Entity\Tier	No errors.
App\Entity\NotificationRdvSms	No errors.
App\Entity\Status	No errors.
App\Entity\EtatRdv	No errors.
App\Entity\CentreTier	No errors.
App\Entity\Tag	No errors.
App\Entity\TestClient	No errors.
App\Entity\TestAppareil	No errors.
App\Entity\CallInteraction	No errors.
App\Entity\RegionDepartment	No errors.
App\Entity\AudioByPartner	No errors.
App\Entity\TokenAdminSwitcher	No errors.
App\Entity\LeadRdv	No errors.
App\Entity\InfoCategorie	No errors.
App\Entity\Departement	No errors.
App\Entity\Proches	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

https://my-audio-api.server-preprod.ovh/stripe/webhook

Configuration Settings

Theme