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

Query Metrics

12 Database Queries
6 Different statements
7.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.53 ms
(21.40%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.daily_capping AS daily_capping_2, a0_.monthly_capping AS monthly_capping_3, a0_.lead_cost AS lead_cost_4, a0_.is_customer AS is_customer_5, a0_.number_of_lead_monthly AS number_of_lead_monthly_6, a0_.registration_date AS registration_date_7, a0_.business_model AS business_model_8, a0_.business_model_since AS business_model_since_9, a0_.business_model_deadline AS business_model_deadline_10, a0_.age_capping AS age_capping_11, a0_.vat_number AS vat_number_12, a0_.siret_number AS siret_number_13, a0_.phone_number_sms_notification AS phone_number_sms_notification_14, a0_.email_notification AS email_notification_15, a0_.is_sms_notification AS is_sms_notification_16, a0_.is_email_notification AS is_email_notification_17, a0_.has_been_premium AS has_been_premium_18, a0_.sold_out_at AS sold_out_at_19, a0_.is_enabled AS is_enabled_20, a0_.updated_at AS updated_at_21, a0_.picture_path AS picture_path_22, a0_.logo_path AS logo_path_23, a0_.nb_pending_lead AS nb_pending_lead_24, a0_.nb_credit_sms AS nb_credit_sms_25, a0_.business_software AS business_software_26, a0_.pay_as_you_go_capping AS pay_as_you_go_capping_27, a0_.onboarding_status AS onboarding_status_28, a0_.stat_nb_credit_purchased AS stat_nb_credit_purchased_29, a0_.stat_nb_lead_delivered AS stat_nb_lead_delivered_30, a0_.stat_nb_sales AS stat_nb_sales_31, a0_.nb_credit AS nb_credit_32, a0_.dtype AS dtype_33, a0_.user_id AS user_id_34 FROM administrator a0_ WHERE (a0_.logo_path IS NOT NULL) AND a0_.dtype IN ('freelancer')
Parameters:
[]
1.34 ms
(18.65%)
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:
[]
1.33 ms
(18.53%)
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
]
1.19 ms
(16.60%)
1
SELECT b0_.id AS id_0, b0_.filename AS filename_1, b0_.title AS title_2, b0_.slug AS slug_3, b0_.description AS description_4, b0_.body AS body_5, b0_.body_second AS body_second_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.meta_custom AS meta_custom_9, b0_.meta_schema AS meta_schema_10, b0_.cta_link_path AS cta_link_path_11, b0_.keyword AS keyword_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.reading_time AS reading_time_15, b0_.is_pillar_page AS is_pillar_page_16, b0_.blog_author_id AS blog_author_id_17, b0_.blog_category_id AS blog_category_id_18 FROM blog_post b0_ ORDER BY b0_.created_at DESC LIMIT 3
Parameters:
[]
1.06 ms
(14.72%)
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:
[]
0.72 ms
(10.10%)
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:
[]

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.