https://mca.qa.wits-media.com/centre-auditif/null

Forwarded to
ErrorController (92721a)
Method
GET
HTTP Status
404
IP
57.141.0.59
Profiled on
Token
da6eff

Query Metrics

1 Database Queries
1 Different statements
11.08 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
11.08 ms
(100.00%) 		1 
SELECT t0.id AS id_1, t0.state AS state_2, t0.name AS name_3, t0.address AS address_4, t0.address_detail AS address_detail_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.phone_number AS phone_number_8, t0.fax AS fax_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.deleted_at AS deleted_at_12, t0.acquisition_enabled AS acquisition_enabled_13, t0.reach AS reach_14, t0.priority AS priority_15, t0.logo_path AS logo_path_16, t0.siret_number AS siret_number_17, t0.updated_at AS updated_at_18, t0.email_notification AS email_notification_19, t0.is_email_notification AS is_email_notification_20, t0.slug AS slug_21, t0.teaser AS teaser_22, t0.handicap_access AS handicap_access_23, t0.qualification_enabled AS qualification_enabled_24, t0.hearing_brand_id AS hearing_brand_id_25, t0.administrator_id AS administrator_id_26, t0.estimated_reach_id AS estimated_reach_id_27, t0.store_page_id AS store_page_id_28, t0.payment_method_id AS payment_method_id_29, t30.id AS id_31, t30.place_id AS place_id_32, t30.rating AS rating_33, t30.user_rating_count AS user_rating_count_34, t30.last_fetched_at AS last_fetched_at_35, t30.no_place_id_detected_at AS no_place_id_detected_at_36, t30.open_hours_weekday_descriptions AS open_hours_weekday_descriptions_37, t30.nearby_transit AS nearby_transit_38, t30.place_id_last_refresh_at AS place_id_last_refresh_at_39, t30.store_id AS store_id_40 FROM store t0 LEFT JOIN store_place_data t30 ON t30.store_id = t0.id WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters: 
[
  "null"
]
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\EstimatedReach No errors.
App\Entity\StorePage No errors.
Wits\PaymentBundle\Entity\PaymentMethod No errors.
App\Entity\StorePlaceData No errors.
App\Entity\AcquisitionMode No errors.
App\Entity\ProspectOnStore No errors.
App\Entity\ProspectOnStoreQualification 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\StoreCentralPurchasingRelation No errors.
App\Entity\StoreIndexation 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\Stat\Report 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\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\ProspectOnStoreFeedback No errors.
App\Entity\Claim 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\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.