Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.place_id AS place_id_2,
  t0.rating AS rating_3,
  t0.user_rating_count AS user_rating_count_4,
  t0.last_fetched_at AS last_fetched_at_5,
  t0.no_place_id_detected_at AS no_place_id_detected_at_6,
  t0.open_hours_weekday_descriptions AS open_hours_weekday_descriptions_7,
  t0.nearby_transit AS nearby_transit_8,
  t0.place_id_last_refresh_at AS place_id_last_refresh_at_9,
  t0.store_id AS store_id_10
FROM
  store_place_data t0
WHERE
  t0.store_id = ?

SELECT t0.id AS id_1, t0.place_id AS place_id_2, t0.rating AS rating_3, t0.user_rating_count AS user_rating_count_4, t0.last_fetched_at AS last_fetched_at_5, t0.no_place_id_detected_at AS no_place_id_detected_at_6, t0.open_hours_weekday_descriptions AS open_hours_weekday_descriptions_7, t0.nearby_transit AS nearby_transit_8, t0.place_id_last_refresh_at AS place_id_last_refresh_at_9, t0.store_id AS store_id_10 FROM store_place_data t0 WHERE t0.store_id = 8901;

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.nb_credit AS nb_credit_34,
  t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_35,
  t0.qualification_enabled AS qualification_enabled_36,
  t0.excluded_from_unreachable_delivery AS excluded_from_unreachable_delivery_37,
  t0.success_message AS success_message_38
FROM
  administrator t0
WHERE
  t0.id = ?
  AND t0.dtype IN ('freelancer', 'partner')

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.nb_credit AS nb_credit_34, t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_35, t0.qualification_enabled AS qualification_enabled_36, t0.excluded_from_unreachable_delivery AS excluded_from_unreachable_delivery_37, t0.success_message AS success_message_38 FROM administrator t0 WHERE t0.id = 24 AND t0.dtype IN ('freelancer', 'partner');

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

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;

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 = ?

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 = 1;

SELECT
  s0_.id AS id_0,
  s0_.state AS state_1,
  s0_.name AS name_2,
  s0_.address AS address_3,
  s0_.address_detail AS address_detail_4,
  s0_.zip_code AS zip_code_5,
  s0_.city AS city_6,
  s0_.phone_number AS phone_number_7,
  s0_.fax AS fax_8,
  s0_.latitude AS latitude_9,
  s0_.longitude AS longitude_10,
  s0_.deleted_at AS deleted_at_11,
  s0_.acquisition_enabled AS acquisition_enabled_12,
  s0_.reach AS reach_13,
  s0_.priority AS priority_14,
  s0_.logo_path AS logo_path_15,
  s0_.siret_number AS siret_number_16,
  s0_.updated_at AS updated_at_17,
  s0_.email_notification AS email_notification_18,
  s0_.is_email_notification AS is_email_notification_19,
  s0_.slug AS slug_20,
  s0_.teaser AS teaser_21,
  s0_.handicap_access AS handicap_access_22,
  s0_.qualification_enabled AS qualification_enabled_23,
  s0_.hearing_brand_id AS hearing_brand_id_24,
  s0_.administrator_id AS administrator_id_25,
  s0_.estimated_reach_id AS estimated_reach_id_26,
  s0_.store_page_id AS store_page_id_27,
  s0_.payment_method_id AS payment_method_id_28
FROM
  store s0_
WHERE
  (s0_.store_page_id IS NOT NULL)
  AND (s0_.deleted_at IS NULL)
ORDER BY
  s0_.zip_code ASC

SELECT s0_.id AS id_0, s0_.state AS state_1, s0_.name AS name_2, s0_.address AS address_3, s0_.address_detail AS address_detail_4, s0_.zip_code AS zip_code_5, s0_.city AS city_6, s0_.phone_number AS phone_number_7, s0_.fax AS fax_8, s0_.latitude AS latitude_9, s0_.longitude AS longitude_10, s0_.deleted_at AS deleted_at_11, s0_.acquisition_enabled AS acquisition_enabled_12, s0_.reach AS reach_13, s0_.priority AS priority_14, s0_.logo_path AS logo_path_15, s0_.siret_number AS siret_number_16, s0_.updated_at AS updated_at_17, s0_.email_notification AS email_notification_18, s0_.is_email_notification AS is_email_notification_19, s0_.slug AS slug_20, s0_.teaser AS teaser_21, s0_.handicap_access AS handicap_access_22, s0_.qualification_enabled AS qualification_enabled_23, s0_.hearing_brand_id AS hearing_brand_id_24, s0_.administrator_id AS administrator_id_25, s0_.estimated_reach_id AS estimated_reach_id_26, s0_.store_page_id AS store_page_id_27, s0_.payment_method_id AS payment_method_id_28 FROM store s0_ WHERE (s0_.store_page_id IS NOT NULL) AND (s0_.deleted_at IS NULL) ORDER BY s0_.zip_code ASC;

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

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;