https://mca.qa.wits-media.com/stat/event/display Return to referer URL

Query Metrics

13 Database Queries
5 Different statements
6.43 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 ms
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.id IN (?, ?, ?, ?, ?, ?) AND ((t0.deleted_at IS NULL))
Parameters:
[
  "3315"
  "10173"
  "10122"
  "5532"
  "3291"
  "5040"
]
2 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.daily_capping AS daily_capping_3, t0.monthly_capping AS monthly_capping_4, t0.lead_cost AS lead_cost_5, t0.is_customer AS is_customer_6, t0.number_of_lead_monthly AS number_of_lead_monthly_7, t0.registration_date AS registration_date_8, t0.business_model AS business_model_9, t0.business_model_since AS business_model_since_10, t0.business_model_deadline AS business_model_deadline_11, t0.age_capping AS age_capping_12, t0.user_id AS user_id_13, t0.dtype, t0.vat_number AS vat_number_14, t0.siret_number AS siret_number_15, t0.phone_number_sms_notification AS phone_number_sms_notification_16, t0.email_notification AS email_notification_17, t0.is_sms_notification AS is_sms_notification_18, t0.is_email_notification AS is_email_notification_19, t0.has_been_premium AS has_been_premium_20, t0.sold_out_at AS sold_out_at_21, t0.is_enabled AS is_enabled_22, t0.updated_at AS updated_at_23, t0.picture_path AS picture_path_24, t0.logo_path AS logo_path_25, t0.nb_pending_lead AS nb_pending_lead_26, t0.nb_credit_sms AS nb_credit_sms_27, t0.business_software AS business_software_28, t0.pay_as_you_go_capping AS pay_as_you_go_capping_29, t0.onboarding_status AS onboarding_status_30, t0.stat_nb_credit_purchased AS stat_nb_credit_purchased_31, t0.stat_nb_lead_delivered AS stat_nb_lead_delivered_32, t0.stat_nb_sales AS stat_nb_sales_33, t0.scheduling_appointment AS scheduling_appointment_34, t0.nb_credit AS nb_credit_35, t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_36, t0.qualification_enabled AS qualification_enabled_37, t0.excluded_from_unreachable_delivery AS excluded_from_unreachable_delivery_38, t0.success_message AS success_message_39, t0.welcome_sms_message AS welcome_sms_message_40 FROM administrator t0 WHERE t0.id = ? AND t0.dtype IN ('freelancer', 'partner')
Parameters:
[
  12
]
3 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.daily_capping AS daily_capping_3, t0.monthly_capping AS monthly_capping_4, t0.lead_cost AS lead_cost_5, t0.is_customer AS is_customer_6, t0.number_of_lead_monthly AS number_of_lead_monthly_7, t0.registration_date AS registration_date_8, t0.business_model AS business_model_9, t0.business_model_since AS business_model_since_10, t0.business_model_deadline AS business_model_deadline_11, t0.age_capping AS age_capping_12, t0.user_id AS user_id_13, t0.dtype, t0.vat_number AS vat_number_14, t0.siret_number AS siret_number_15, t0.phone_number_sms_notification AS phone_number_sms_notification_16, t0.email_notification AS email_notification_17, t0.is_sms_notification AS is_sms_notification_18, t0.is_email_notification AS is_email_notification_19, t0.has_been_premium AS has_been_premium_20, t0.sold_out_at AS sold_out_at_21, t0.is_enabled AS is_enabled_22, t0.updated_at AS updated_at_23, t0.picture_path AS picture_path_24, t0.logo_path AS logo_path_25, t0.nb_pending_lead AS nb_pending_lead_26, t0.nb_credit_sms AS nb_credit_sms_27, t0.business_software AS business_software_28, t0.pay_as_you_go_capping AS pay_as_you_go_capping_29, t0.onboarding_status AS onboarding_status_30, t0.stat_nb_credit_purchased AS stat_nb_credit_purchased_31, t0.stat_nb_lead_delivered AS stat_nb_lead_delivered_32, t0.stat_nb_sales AS stat_nb_sales_33, t0.scheduling_appointment AS scheduling_appointment_34, t0.nb_credit AS nb_credit_35, t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_36, t0.qualification_enabled AS qualification_enabled_37, t0.excluded_from_unreachable_delivery AS excluded_from_unreachable_delivery_38, t0.success_message AS success_message_39, t0.welcome_sms_message AS welcome_sms_message_40 FROM administrator t0 WHERE t0.id = ? AND t0.dtype IN ('freelancer', 'partner')
Parameters:
[
  16
]
4 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.daily_capping AS daily_capping_3, t0.monthly_capping AS monthly_capping_4, t0.lead_cost AS lead_cost_5, t0.is_customer AS is_customer_6, t0.number_of_lead_monthly AS number_of_lead_monthly_7, t0.registration_date AS registration_date_8, t0.business_model AS business_model_9, t0.business_model_since AS business_model_since_10, t0.business_model_deadline AS business_model_deadline_11, t0.age_capping AS age_capping_12, t0.user_id AS user_id_13, t0.dtype, t0.vat_number AS vat_number_14, t0.siret_number AS siret_number_15, t0.phone_number_sms_notification AS phone_number_sms_notification_16, t0.email_notification AS email_notification_17, t0.is_sms_notification AS is_sms_notification_18, t0.is_email_notification AS is_email_notification_19, t0.has_been_premium AS has_been_premium_20, t0.sold_out_at AS sold_out_at_21, t0.is_enabled AS is_enabled_22, t0.updated_at AS updated_at_23, t0.picture_path AS picture_path_24, t0.logo_path AS logo_path_25, t0.nb_pending_lead AS nb_pending_lead_26, t0.nb_credit_sms AS nb_credit_sms_27, t0.business_software AS business_software_28, t0.pay_as_you_go_capping AS pay_as_you_go_capping_29, t0.onboarding_status AS onboarding_status_30, t0.stat_nb_credit_purchased AS stat_nb_credit_purchased_31, t0.stat_nb_lead_delivered AS stat_nb_lead_delivered_32, t0.stat_nb_sales AS stat_nb_sales_33, t0.scheduling_appointment AS scheduling_appointment_34, t0.nb_credit AS nb_credit_35, t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_36, t0.qualification_enabled AS qualification_enabled_37, t0.excluded_from_unreachable_delivery AS excluded_from_unreachable_delivery_38, t0.success_message AS success_message_39, t0.welcome_sms_message AS welcome_sms_message_40 FROM administrator t0 WHERE t0.id = ? AND t0.dtype IN ('freelancer', 'partner')
Parameters:
[
  432
]
5 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.daily_capping AS daily_capping_3, t0.monthly_capping AS monthly_capping_4, t0.lead_cost AS lead_cost_5, t0.is_customer AS is_customer_6, t0.number_of_lead_monthly AS number_of_lead_monthly_7, t0.registration_date AS registration_date_8, t0.business_model AS business_model_9, t0.business_model_since AS business_model_since_10, t0.business_model_deadline AS business_model_deadline_11, t0.age_capping AS age_capping_12, t0.user_id AS user_id_13, t0.dtype, t0.vat_number AS vat_number_14, t0.siret_number AS siret_number_15, t0.phone_number_sms_notification AS phone_number_sms_notification_16, t0.email_notification AS email_notification_17, t0.is_sms_notification AS is_sms_notification_18, t0.is_email_notification AS is_email_notification_19, t0.has_been_premium AS has_been_premium_20, t0.sold_out_at AS sold_out_at_21, t0.is_enabled AS is_enabled_22, t0.updated_at AS updated_at_23, t0.picture_path AS picture_path_24, t0.logo_path AS logo_path_25, t0.nb_pending_lead AS nb_pending_lead_26, t0.nb_credit_sms AS nb_credit_sms_27, t0.business_software AS business_software_28, t0.pay_as_you_go_capping AS pay_as_you_go_capping_29, t0.onboarding_status AS onboarding_status_30, t0.stat_nb_credit_purchased AS stat_nb_credit_purchased_31, t0.stat_nb_lead_delivered AS stat_nb_lead_delivered_32, t0.stat_nb_sales AS stat_nb_sales_33, t0.scheduling_appointment AS scheduling_appointment_34, t0.nb_credit AS nb_credit_35, t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_36, t0.qualification_enabled AS qualification_enabled_37, t0.excluded_from_unreachable_delivery AS excluded_from_unreachable_delivery_38, t0.success_message AS success_message_39, t0.welcome_sms_message AS welcome_sms_message_40 FROM administrator t0 WHERE t0.id = ? AND t0.dtype IN ('freelancer', 'partner')
Parameters:
[
  455
]
6 0.36 ms
"START TRANSACTION"
Parameters:
[]
7 0.62 ms
INSERT INTO stat_event (date, type, value, acquisition_mode, acquisition_base, acquisition_url, acquisition_keyword, store_id, prospect_id, prospect_on_store_id, prospect_on_hearing_aid_id, prospect_duplicate_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-07-11 01:09:46"
  "store_display"
  5
  null
  null
  null
  null
  3291
  null
  null
  null
  null
]
8 0.24 ms
INSERT INTO stat_event (date, type, value, acquisition_mode, acquisition_base, acquisition_url, acquisition_keyword, store_id, prospect_id, prospect_on_store_id, prospect_on_hearing_aid_id, prospect_duplicate_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-07-11 01:09:46"
  "store_display"
  1
  null
  null
  null
  null
  3315
  null
  null
  null
  null
]
9 0.27 ms
INSERT INTO stat_event (date, type, value, acquisition_mode, acquisition_base, acquisition_url, acquisition_keyword, store_id, prospect_id, prospect_on_store_id, prospect_on_hearing_aid_id, prospect_duplicate_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-07-11 01:09:46"
  "store_display"
  6
  null
  null
  null
  null
  5040
  null
  null
  null
  null
]
10 0.23 ms
INSERT INTO stat_event (date, type, value, acquisition_mode, acquisition_base, acquisition_url, acquisition_keyword, store_id, prospect_id, prospect_on_store_id, prospect_on_hearing_aid_id, prospect_duplicate_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-07-11 01:09:46"
  "store_display"
  4
  null
  null
  null
  null
  5532
  null
  null
  null
  null
]
11 0.26 ms
INSERT INTO stat_event (date, type, value, acquisition_mode, acquisition_base, acquisition_url, acquisition_keyword, store_id, prospect_id, prospect_on_store_id, prospect_on_hearing_aid_id, prospect_duplicate_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-07-11 01:09:46"
  "store_display"
  3
  null
  null
  null
  null
  10122
  null
  null
  null
  null
]
12 0.24 ms
INSERT INTO stat_event (date, type, value, acquisition_mode, acquisition_base, acquisition_url, acquisition_keyword, store_id, prospect_id, prospect_on_store_id, prospect_on_hearing_aid_id, prospect_duplicate_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-07-11 01:09:46"
  "store_display"
  2
  null
  null
  null
  null
  10173
  null
  null
  null
  null
]
13 1.07 ms
"COMMIT"
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\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\Stat\Event No errors.
App\Entity\ProspectOnStore No errors.
App\Entity\Stat\Report 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\ProspectOnStoreQualification No errors.
App\Entity\Owner No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
App\Entity\Partner No errors.
App\Entity\StoreManagementRequest No errors.
App\Entity\StoreCentralPurchasingRelation No errors.
App\Entity\StoreIndexation No errors.
App\Entity\FreelancerComment No errors.
App\Entity\CreditCost No errors.
App\Entity\ProspectOnHearingAid No errors.
App\Entity\ProspectDuplicate No errors.
App\Entity\PhoneValidation No errors.
App\Entity\HearingAid 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\UserTrackingDuration No errors.
App\Entity\CentralPurchasing No errors.
App\Entity\CreditPack No errors.
App\Entity\CreditPackGeneric No errors.
App\Entity\CreditPackCustom No errors.
App\Entity\SmsCreditPackGeneric No errors.
App\Entity\SmsCreditPackCustom No errors.
Wits\PaymentBundle\Entity\Payment No errors.
App\Entity\Invoice No errors.
App\Entity\ProspectQualification No errors.