https://my-audio-api.server-preprod.ovh/articles/publish

Query Metrics

204 Database Queries
6 Different statements
240.38 ms Query time
9 Invalid entities

Grouped Statements

Show all queries

Time Count Info
185.50 ms
(77.17%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.creation_date AS creation_date_4, t0.publication_date AS publication_date_5, t0.source AS source_6, t0.img_url AS img_url_7, t0.texte AS texte_8, t0.extrait AS extrait_9, t0.is_pro AS is_pro_10, t0.etat AS etat_11, t0.slug AS slug_12, t0.is_public AS is_public_13, t0.external_link AS external_link_14, t0.external_id AS external_id_15, t0.id_admin_id AS id_admin_id_16, t0.user_id AS user_id_17 FROM article t0 WHERE t0.etat = ?
Parameters:
[
  0
]
18.39 ms
(7.65%)
64
SELECT t0.id AS id_1, t0.id_article_id AS id_article_id_2, t0.id_categorie_id AS id_categorie_id_3 FROM article_categorie t0 WHERE t0.id_article_id = ?
Parameters:
[
  222
]
16.96 ms
(7.06%)
64
SELECT t0.id AS id_1, t0.id_article_id AS id_article_id_2, t0.id_tag_id AS id_tag_id_3 FROM article_tag t0 WHERE t0.id_article_id = ?
Parameters:
[
  222
]
16.21 ms
(6.74%)
63
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.pin AS pin_7, t0.id_profil_id AS id_profil_id_8 FROM administrateur t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4
]
3.07 ms
(1.28%)
11
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.25 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.pin AS pin_7, t0.id_profil_id AS id_profil_id_8 FROM administrateur t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[]

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\Article No errors.
App\Entity\Administrateur No errors.
App\Entity\AccessControl\AccessUser No errors.
App\Entity\ArticleCategorie No errors.
App\Entity\ArticleTag No errors.
App\Entity\Categorie No errors.
App\Entity\PageCategorie No errors.
App\Entity\Tag No errors.
App\Entity\Profil No errors.
App\Entity\FAQ No errors.
App\Entity\Token No errors.
App\Entity\Page No errors.
App\Entity\PageTag 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\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\PageInfoCategorie 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.
  • The field App\Entity\Centre#specificSubscription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SpecificSubscription#center does not contain the required 'inversedBy="specificSubscription"' attribute.
  • The association App\Entity\Centre#atoLauditionPartner refers to the inverse side field App\Entity\AtoLauditionPartner#centres which does not exist.
App\Entity\TrustedUser No errors.
App\Entity\Proches No errors.
App\Entity\Reminder No errors.
App\Entity\TestClient No errors.
App\Entity\ClientDocument No errors.
App\Entity\RoadType No errors.
App\Entity\ClientAnamnese No errors.
App\Entity\ClientStatus No errors.
App\Entity\Rdv No errors.
App\Entity\LeadRdv No errors.
App\Entity\Commission No errors.
App\Entity\LogRelance No errors.
App\Entity\Client\SanteAmo No errors.
App\Entity\Client\SanteAmc No errors.
App\Entity\Client\AssureCivility No errors.
App\Entity\Device\ClientDevice 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\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\SynchronisationSetting No errors.
App\Entity\GoogleAgenda No errors.
App\Entity\ImportHistory No errors.
App\Entity\OrderPatientDatatable No errors.
App\Entity\Diplome No errors.
App\Entity\AudioSpecialite No errors.
App\Entity\Partner\PartnerSubscription No errors.
App\Entity\Audio\Role No errors.
App\Entity\Payment\Subscription No errors.
App\Entity\Synchronisation\CosiumCategorie No errors.
App\Entity\Notification\CentreStaff No errors.
App\Entity\InfoCategorie No errors.
App\Entity\SynchronisationLog No errors.
App\Entity\Client\BirthOrder No errors.
App\Entity\Client\QualityAmo No errors.
App\Entity\Client\RelationAmc No errors.
App\Entity\RdvEvent No errors.
App\Entity\LieuTier No errors.
App\Entity\CentreMutuelle No errors.
App\Entity\CallLog No errors.
App\Entity\CancellationRecord No errors.
App\Entity\AudioMotif No errors.
App\Entity\CenterImported No errors.
App\Entity\Holiday No errors.
App\Entity\Permission No errors.
App\Entity\Ville No errors.
App\Entity\AccessControl\AccessRole No errors.
App\Entity\AccessControl\AccessPermission No errors.
App\Entity\CentrePrestation No errors.
App\Entity\Station No errors.
App\Entity\Anamnese No errors.
App\Entity\Specialite No errors.
App\Entity\AudioCommentaire No errors.
App\Entity\CentreTemp No errors.
App\Entity\Device\Device No errors.
App\Entity\Device\SettingDevice No errors.
App\Entity\AudioDiplome No errors.
App\Entity\ProfilPermission No errors.
App\Entity\Assistant No errors.
App\Entity\Document 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\AudioLibrePartner No errors.
App\Entity\Partner\AudioPartner No errors.
App\Entity\Partner\BillingCda No errors.
App\Entity\Partner\BillingFile No errors.
App\Entity\HelpQuestions No errors.
App\Entity\Audiometrie\SessionTonaleAnswer No errors.
App\Entity\Audiometrie\SessionVocalAnswer No errors.
App\Entity\Audiometrie\Setting No errors.
App\Entity\Audiometrie\TonaleSession No errors.
App\Entity\Audiometrie\VocalSession No errors.
App\Entity\Motif No errors.
App\Entity\OrderDatatable No errors.
App\Entity\Referral No errors.
App\Entity\AudioHelpQuestions No errors.
App\Entity\ClientBlocked No errors.
App\Entity\SpecificSubscription No errors.
App\Entity\Contact No errors.
App\Entity\Mutuelle No errors.
App\Entity\OpticalInvoice 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\PaymentMethod No errors.
App\Entity\AccessCentre No errors.
App\Entity\Prestation No errors.
App\Entity\LieuMutuelle No errors.
App\Entity\LeadStatus No errors.
App\Entity\AtoLauditionPartner No errors.
App\Entity\ImportCenter No errors.
App\Entity\LieuPrestation No errors.
App\Entity\TestQuestion No errors.
App\Entity\Legal No errors.
App\Entity\CentreDocument No errors.
App\Entity\CenterImage No errors.
App\Entity\StatusRdv No errors.
App\Entity\Factures No errors.
App\Entity\Plan No errors.
App\Entity\DeletionRequest No errors.
App\Entity\PaymentParrain No errors.
App\Entity\Tier No errors.
App\Entity\NotificationRdvSms No errors.
App\Entity\FailedPaymentNotification No errors.
App\Entity\Status No errors.
App\Entity\EmailCampaignRecipient No errors.
App\Entity\EtatRdv No errors.
App\Entity\CentreTier No errors.
App\Entity\Lieu No errors.
App\Entity\TestAppareil No errors.
App\Entity\CallInteraction No errors.
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\RemplacantSpecialite No errors.
App\Entity\RegionDepartment No errors.
App\Entity\EmailCampaign No errors.
App\Entity\AudioByPartner No errors.
App\Entity\TokenAdminSwitcher No errors.
App\Entity\Departement No errors.
App\Entity\Assistante No errors.
Vich\UploaderBundle\Entity\File No errors.