https://mca.qa.wits-media.com/espace-professionnels

Method
GET
HTTP Status
200
IP
216.73.216.170
Profiled on
Token
52a0c5

Query Metrics

10 Database Queries
4 Different statements
4.34 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.34 ms
(30.81%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.logo_path AS logo_path_5, t0.logo_variation_path AS logo_variation_path_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.opening_hours AS opening_hours_10, t0.presentable AS presentable_11, t0.wording AS wording_12, t0.indexable AS indexable_13 FROM hearing_brand t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.14 ms
(26.14%) 		3 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.logo_path AS logo_path_5, t0.logo_variation_path AS logo_variation_path_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.opening_hours AS opening_hours_10, t0.presentable AS presentable_11, t0.wording AS wording_12, t0.indexable AS indexable_13 FROM hearing_brand t0 WHERE t0.indexable = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
1.01 ms
(23.16%) 		3 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.zipcode AS zipcode_4, t0.wording AS wording_5, t0.banner_path AS banner_path_6, t0.updated_at AS updated_at_7 FROM city_post t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.86 ms
(19.89%) 		3 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_path AS logo_path_4, t0.updated_at AS updated_at_5, t0.phone_number AS phone_number_6, t0.address AS address_7, t0.wording AS wording_8, t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_9 FROM hearing_maker t0
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\ThirdPartyEntity No errors.
App\Entity\Prospect No errors.
App\Entity\Store No errors.
App\Entity\ProspectOnStoreStatus No errors.
App\Entity\DeviceSale No errors.
App\Entity\CityPost No errors.
App\Entity\HearingBrand No errors.
App\Entity\HearingMaker No errors.
App\Entity\Notification No errors.
App\Entity\Administrator No errors.
App\Entity\Freelancer No errors.
App\Entity\FreelancerAssistant No errors.
App\Entity\Sponsorship No errors.
App\Entity\Order No errors.
App\Entity\AcquisitionMode No errors.
App\Entity\ProspectOnStore No errors.
App\Entity\Stat\Report No errors.
App\Entity\PhoneValidation No errors.
App\Entity\MediaoptinDelivery No errors.
App\Entity\ProspectDuplicate No errors.
App\Entity\ProspectQualification No errors.
App\Entity\Owner No errors.
App\Entity\StoreManagementRequest No errors.
App\Entity\EstimatedReach No errors.
App\Entity\StoreCentralPurchasingRelation No errors.
App\Entity\StorePage No errors.
Wits\PaymentBundle\Entity\PaymentMethod No errors.
App\Entity\StoreIndexation No errors.
App\Entity\StorePlaceData No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
Wits\PaymentBundle\Entity\Payment No errors.
App\Entity\Invoice No errors.
App\Entity\HearingAid No errors.
App\Entity\FreelancerComment No errors.
App\Entity\CreditCost No errors.
App\Entity\CreditPack No errors.
App\Entity\CentralPurchasing No errors.
App\Entity\ProspectOnStoreFeedback No errors.
App\Entity\Claim No errors.
App\Entity\ProspectOnStoreQualification No errors.
App\Entity\Prescriber\Prescriber
  • The mappings App\Entity\Prescriber\Prescriber#remunerations and App\Entity\Prescriber\PrescriberRemuneration#prescriber are inconsistent with each other.
App\Entity\Prescriber\PrescriberRemuneration
  • The association App\Entity\Prescriber\PrescriberRemuneration#prescriber refers to the inverse side field App\Entity\Prescriber\Prescriber#prescriberRemunerations which does not exist.
App\Entity\Partner No errors.
App\Entity\LogEntry No errors.
App\Entity\ProspectOnHearingAid No errors.
App\Entity\StoreEmployee No errors.
App\Entity\StoreImage No errors.
App\Entity\CareNetwork No errors.
App\Entity\StoreSpeciality No errors.
App\Entity\StoreService No errors.
App\Entity\UserTracking No errors.
App\Entity\UserTrackingDuration No errors.
App\Entity\CreditPackGeneric No errors.
App\Entity\CreditPackCustom No errors.
App\Entity\SmsCreditPackGeneric No errors.
App\Entity\SmsCreditPackCustom No errors.
App\Entity\StoreFinderData No errors.
App\Entity\CoregistrationCampaign No errors.
App\Entity\OrlProspectOnOrlOffice No errors.
App\Entity\ProspectDropped No errors.
App\Entity\Stat\Event No errors.
App\Entity\UserTrackingDetail No errors.
App\Entity\BlogAuthor No errors.
App\Entity\SmsBroadcast No errors.
App\Entity\Contact No errors.
App\Entity\BlogPost No errors.
App\Entity\ShortUrl No errors.
App\Entity\OrlOffice No errors.
App\Entity\ProspectReporting No errors.
App\Entity\OrlProspect No errors.
App\Entity\NewsLetter No errors.
App\Entity\FinancialParameter No errors.
App\Entity\ProspectFeedback No errors.
App\Entity\BlogCategory No errors.
App\Entity\Parameter No errors.
Vich\UploaderBundle\Entity\File No errors.