Symfony Profiler

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

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 = 'amplifon-saint-gely-du-fesc-34980' AND ((t0.deleted_at IS NULL)) LIMIT 1;

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 = 16 AND t0.dtype IN ('freelancer', 'partner');

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.address AS address_2,
  o0_.zip_code AS zip_code_3,
  o0_.city AS city_4,
  o0_.phone_number AS phone_number_5,
  o0_.latitude AS latitude_6,
  o0_.longitude AS longitude_7,
  o0_.state AS state_8,
  o0_.acquisition_enabled AS acquisition_enabled_9,
  o0_.reach AS reach_10,
  o0_.is_priority AS is_priority_11,
  o0_.siret_number AS siret_number_12,
  o0_.updated_at AS updated_at_13,
  o0_.deleted_at AS deleted_at_14,
  o0_.id AS id_15,
  o0_.name AS name_16,
  o0_.address AS address_17,
  o0_.zip_code AS zip_code_18,
  o0_.city AS city_19,
  o0_.phone_number AS phone_number_20,
  o0_.latitude AS latitude_21,
  o0_.longitude AS longitude_22,
  o0_.state AS state_23,
  o0_.acquisition_enabled AS acquisition_enabled_24,
  o0_.reach AS reach_25,
  o0_.is_priority AS is_priority_26,
  o0_.siret_number AS siret_number_27,
  o0_.updated_at AS updated_at_28,
  o0_.deleted_at AS deleted_at_29,
  6371 * ACOS(
    COS(
      RADIANS(43.6956836)
    ) * COS(
      RADIANS(o0_.latitude)
    ) * COS(
      RADIANS(o0_.longitude) - RADIANS(3.8069523)
    ) + SIN(
      RADIANS(43.6956836)
    ) * SIN(
      RADIANS(o0_.latitude)
    )
  ) AS sclr_30
FROM
  orl_office o0_
WHERE
  o0_.state = ?
  AND o0_.deleted_at IS NULL
  AND o0_.latitude IS NOT NULL
  AND o0_.longitude IS NOT NULL
  AND (
    o0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    o0_.latitude BETWEEN ?
    AND ?
  )
HAVING
  sclr_30 < ?
  OR sclr_30 IS NULL
ORDER BY
  sclr_30 ASC
LIMIT
  3

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.address AS address_2, o0_.zip_code AS zip_code_3, o0_.city AS city_4, o0_.phone_number AS phone_number_5, o0_.latitude AS latitude_6, o0_.longitude AS longitude_7, o0_.state AS state_8, o0_.acquisition_enabled AS acquisition_enabled_9, o0_.reach AS reach_10, o0_.is_priority AS is_priority_11, o0_.siret_number AS siret_number_12, o0_.updated_at AS updated_at_13, o0_.deleted_at AS deleted_at_14, o0_.id AS id_15, o0_.name AS name_16, o0_.address AS address_17, o0_.zip_code AS zip_code_18, o0_.city AS city_19, o0_.phone_number AS phone_number_20, o0_.latitude AS latitude_21, o0_.longitude AS longitude_22, o0_.state AS state_23, o0_.acquisition_enabled AS acquisition_enabled_24, o0_.reach AS reach_25, o0_.is_priority AS is_priority_26, o0_.siret_number AS siret_number_27, o0_.updated_at AS updated_at_28, o0_.deleted_at AS deleted_at_29, 6371 * ACOS(COS(RADIANS(43.6956836)) * COS(RADIANS(o0_.latitude)) * COS(RADIANS(o0_.longitude) - RADIANS(3.8069523)) + SIN(RADIANS(43.6956836)) * SIN(RADIANS(o0_.latitude))) AS sclr_30 FROM orl_office o0_ WHERE o0_.state = 'valid' AND o0_.deleted_at IS NULL AND o0_.latitude IS NOT NULL AND o0_.longitude IS NOT NULL AND (o0_.longitude BETWEEN 3.5577470475878 AND 4.0561575524122) AND (o0_.latitude BETWEEN 43.405828527536 AND 43.985538672464) HAVING sclr_30 < 20 OR sclr_30 IS NULL ORDER BY sclr_30 ASC LIMIT 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.id = ?

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.id = 2;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.website_url AS website_url_3,
  t0.updated_at AS updated_at_4,
  t0.highlighted_staff_name AS highlighted_staff_name_5,
  t0.highlighted_staff_picture_path AS highlighted_staff_picture_path_6,
  t0.highlighted_staff_job AS highlighted_staff_job_7,
  t0.highlighted_staff_description AS highlighted_staff_description_8,
  t0.highlited_staff_speciality AS highlited_staff_speciality_9,
  t10.id AS id_11,
  t10.state AS state_12,
  t10.name AS name_13,
  t10.address AS address_14,
  t10.address_detail AS address_detail_15,
  t10.zip_code AS zip_code_16,
  t10.city AS city_17,
  t10.phone_number AS phone_number_18,
  t10.fax AS fax_19,
  t10.latitude AS latitude_20,
  t10.longitude AS longitude_21,
  t10.deleted_at AS deleted_at_22,
  t10.acquisition_enabled AS acquisition_enabled_23,
  t10.reach AS reach_24,
  t10.priority AS priority_25,
  t10.logo_path AS logo_path_26,
  t10.siret_number AS siret_number_27,
  t10.updated_at AS updated_at_28,
  t10.email_notification AS email_notification_29,
  t10.is_email_notification AS is_email_notification_30,
  t10.slug AS slug_31,
  t10.teaser AS teaser_32,
  t10.handicap_access AS handicap_access_33,
  t10.qualification_enabled AS qualification_enabled_34,
  t10.hearing_brand_id AS hearing_brand_id_35,
  t10.administrator_id AS administrator_id_36,
  t10.estimated_reach_id AS estimated_reach_id_37,
  t10.store_page_id AS store_page_id_38,
  t10.payment_method_id AS payment_method_id_39
FROM
  store_page t0
  LEFT JOIN store t10 ON t10.store_page_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.website_url AS website_url_3, t0.updated_at AS updated_at_4, t0.highlighted_staff_name AS highlighted_staff_name_5, t0.highlighted_staff_picture_path AS highlighted_staff_picture_path_6, t0.highlighted_staff_job AS highlighted_staff_job_7, t0.highlighted_staff_description AS highlighted_staff_description_8, t0.highlited_staff_speciality AS highlited_staff_speciality_9, t10.id AS id_11, t10.state AS state_12, t10.name AS name_13, t10.address AS address_14, t10.address_detail AS address_detail_15, t10.zip_code AS zip_code_16, t10.city AS city_17, t10.phone_number AS phone_number_18, t10.fax AS fax_19, t10.latitude AS latitude_20, t10.longitude AS longitude_21, t10.deleted_at AS deleted_at_22, t10.acquisition_enabled AS acquisition_enabled_23, t10.reach AS reach_24, t10.priority AS priority_25, t10.logo_path AS logo_path_26, t10.siret_number AS siret_number_27, t10.updated_at AS updated_at_28, t10.email_notification AS email_notification_29, t10.is_email_notification AS is_email_notification_30, t10.slug AS slug_31, t10.teaser AS teaser_32, t10.handicap_access AS handicap_access_33, t10.qualification_enabled AS qualification_enabled_34, t10.hearing_brand_id AS hearing_brand_id_35, t10.administrator_id AS administrator_id_36, t10.estimated_reach_id AS estimated_reach_id_37, t10.store_page_id AS store_page_id_38, t10.payment_method_id AS payment_method_id_39 FROM store_page t0 LEFT JOIN store t10 ON t10.store_page_id = t0.id WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  store_speciality t0
  INNER JOIN store_page_store_speciality ON t0.id = store_page_store_speciality.store_speciality_id
WHERE
  store_page_store_speciality.store_page_id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM store_speciality t0 INNER JOIN store_page_store_speciality ON t0.id = store_page_store_speciality.store_speciality_id WHERE store_page_store_speciality.store_page_id = 18;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.icon_name AS icon_name_3
FROM
  store_service t0
  INNER JOIN store_page_store_service ON t0.id = store_page_store_service.store_service_id
WHERE
  store_page_store_service.store_page_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.icon_name AS icon_name_3 FROM store_service t0 INNER JOIN store_page_store_service ON t0.id = store_page_store_service.store_service_id WHERE store_page_store_service.store_page_id = 18;

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.updated_at AS updated_at_3,
  t0.store_page_id AS store_page_id_4
FROM
  store_image t0
WHERE
  t0.store_page_id = ?

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.updated_at AS updated_at_3, t0.store_page_id AS store_page_id_4 FROM store_image t0 WHERE t0.store_page_id = 18;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.speciality AS speciality_4,
  t0.picture_path AS picture_path_5,
  t0.updated_at AS updated_at_6,
  t0.store_page_id AS store_page_id_7
FROM
  store_employee t0
WHERE
  t0.store_page_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.speciality AS speciality_4, t0.picture_path AS picture_path_5, t0.updated_at AS updated_at_6, t0.store_page_id AS store_page_id_7 FROM store_employee t0 WHERE t0.store_page_id = 18;

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
  INNER JOIN store_page_hearing_maker ON t0.id = store_page_hearing_maker.hearing_maker_id
WHERE
  store_page_hearing_maker.store_page_id = ?

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 INNER JOIN store_page_hearing_maker ON t0.id = store_page_hearing_maker.hearing_maker_id WHERE store_page_hearing_maker.store_page_id = 18;

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.wording AS wording_6
FROM
  care_network t0
  INNER JOIN store_page_care_network ON t0.id = store_page_care_network.care_network_id
WHERE
  store_page_care_network.store_page_id = ?

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.wording AS wording_6 FROM care_network t0 INNER JOIN store_page_care_network ON t0.id = store_page_care_network.care_network_id WHERE store_page_care_network.store_page_id = 18;

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

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

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