Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.slug AS slug_3,
  t0.legal_name AS legal_name_4,
  t0.structure_type AS structure_type_5,
  t0.siren AS siren_6,
  t0.siret AS siret_7,
  t0.naf_code AS naf_code_8,
  t0.vat_number AS vat_number_9,
  t0.address AS address_10,
  t0.address_complement AS address_complement_11,
  t0.postal_code AS postal_code_12,
  t0.city AS city_13,
  t0.country AS country_14,
  t0.latitude AS latitude_15,
  t0.longitude AS longitude_16,
  t0.geohash AS geohash_17,
  t0.phone_public AS phone_public_18,
  t0.phone_private AS phone_private_19,
  t0.website AS website_20,
  t0.facebook_url AS facebook_url_21,
  t0.instagram_url AS instagram_url_22,
  t0.linkedin_url AS linkedin_url_23,
  t0.short_description AS short_description_24,
  t0.long_description AS long_description_25,
  t0.logo AS logo_26,
  t0.cover_image AS cover_image_27,
  t0.signature_image AS signature_image_28,
  t0.profile_status AS profile_status_29,
  t0.verification_status AS verification_status_30,
  t0.completion_score AS completion_score_31,
  t0.average_rating AS average_rating_32,
  t0.reviews_count AS reviews_count_33,
  t0.response_time_minutes AS response_time_minutes_34,
  t0.is_featured AS is_featured_35,
  t0.featured_until AS featured_until_36,
  t0.search_visibility AS search_visibility_37,
  t0.verified_at AS verified_at_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41,
  t0.description AS description_42,
  t0.metier AS metier_43,
  t0.experience AS experience_44,
  t0.document_verification_status AS document_verification_status_45,
  t0.company_last_verification_at AS company_last_verification_at_46,
  t0.company_verification_source AS company_verification_source_47,
  t0.company_verification_note AS company_verification_note_48,
  t0.is_on_vacation AS is_on_vacation_49,
  t0.vacation_return_date AS vacation_return_date_50,
  t0.user_id AS user_id_51,
  t52.id AS id_53,
  t52.stripe_customer_id AS stripe_customer_id_54,
  t52.stripe_default_payment_method_id AS stripe_default_payment_method_id_55,
  t52.default_payment_method_type AS default_payment_method_type_56,
  t52.billing_email AS billing_email_57,
  t52.created_at AS created_at_58,
  t52.updated_at AS updated_at_59,
  t52.prestataire_profile_id AS prestataire_profile_id_60
FROM
  prestataire_profile t0
  LEFT JOIN subscription_customer t52 ON t52.prestataire_profile_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.slug AS slug_3, t0.legal_name AS legal_name_4, t0.structure_type AS structure_type_5, t0.siren AS siren_6, t0.siret AS siret_7, t0.naf_code AS naf_code_8, t0.vat_number AS vat_number_9, t0.address AS address_10, t0.address_complement AS address_complement_11, t0.postal_code AS postal_code_12, t0.city AS city_13, t0.country AS country_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.geohash AS geohash_17, t0.phone_public AS phone_public_18, t0.phone_private AS phone_private_19, t0.website AS website_20, t0.facebook_url AS facebook_url_21, t0.instagram_url AS instagram_url_22, t0.linkedin_url AS linkedin_url_23, t0.short_description AS short_description_24, t0.long_description AS long_description_25, t0.logo AS logo_26, t0.cover_image AS cover_image_27, t0.signature_image AS signature_image_28, t0.profile_status AS profile_status_29, t0.verification_status AS verification_status_30, t0.completion_score AS completion_score_31, t0.average_rating AS average_rating_32, t0.reviews_count AS reviews_count_33, t0.response_time_minutes AS response_time_minutes_34, t0.is_featured AS is_featured_35, t0.featured_until AS featured_until_36, t0.search_visibility AS search_visibility_37, t0.verified_at AS verified_at_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41, t0.description AS description_42, t0.metier AS metier_43, t0.experience AS experience_44, t0.document_verification_status AS document_verification_status_45, t0.company_last_verification_at AS company_last_verification_at_46, t0.company_verification_source AS company_verification_source_47, t0.company_verification_note AS company_verification_note_48, t0.is_on_vacation AS is_on_vacation_49, t0.vacation_return_date AS vacation_return_date_50, t0.user_id AS user_id_51, t52.id AS id_53, t52.stripe_customer_id AS stripe_customer_id_54, t52.stripe_default_payment_method_id AS stripe_default_payment_method_id_55, t52.default_payment_method_type AS default_payment_method_type_56, t52.billing_email AS billing_email_57, t52.created_at AS created_at_58, t52.updated_at AS updated_at_59, t52.prestataire_profile_id AS prestataire_profile_id_60 FROM prestataire_profile t0 LEFT JOIN subscription_customer t52 ON t52.prestataire_profile_id = t0.id WHERE t0.id = 117;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.title AS title_3,
  t0.short_description AS short_description_4,
  t0.description AS description_5,
  t0.pricing_type AS pricing_type_6,
  t0.price_from AS price_from_7,
  t0.price_to AS price_to_8,
  t0.price_unit AS price_unit_9,
  t0.additional_info AS additional_info_10,
  t0.position AS position_11,
  t0.prix_catalogue AS prix_catalogue_12,
  t0.taux_reduction AS taux_reduction_13,
  t0.promotion_created_at AS promotion_created_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.slug AS slug_17,
  t0.prestataire_profile_id AS prestataire_profile_id_18,
  t0.service_id AS service_id_19
FROM
  prestataire_profile_service t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.title AS title_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.pricing_type AS pricing_type_6, t0.price_from AS price_from_7, t0.price_to AS price_to_8, t0.price_unit AS price_unit_9, t0.additional_info AS additional_info_10, t0.position AS position_11, t0.prix_catalogue AS prix_catalogue_12, t0.taux_reduction AS taux_reduction_13, t0.promotion_created_at AS promotion_created_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.prestataire_profile_id AS prestataire_profile_id_18, t0.service_id AS service_id_19 FROM prestataire_profile_service t0 WHERE t0.slug = 'terrasse-nature-elagage-securise-3' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.description AS description_3,
  s0_.icon AS icon_4,
  s0_.image AS image_5,
  s0_.position AS position_6,
  s0_.color AS color_7,
  s0_.seo_title AS seo_title_8,
  s0_.seo_description AS seo_description_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.is_active AS is_active_12,
  s1_.id AS id_13,
  s1_.name AS name_14,
  s1_.slug AS slug_15,
  s1_.description AS description_16,
  s1_.icon AS icon_17,
  s1_.image AS image_18,
  s1_.position AS position_19,
  s1_.color AS color_20,
  s1_.seo_title AS seo_title_21,
  s1_.seo_description AS seo_description_22,
  s1_.created_at AS created_at_23,
  s1_.updated_at AS updated_at_24,
  s1_.is_active AS is_active_25,
  s0_.parent_id AS parent_id_26,
  s1_.parent_id AS parent_id_27
FROM
  service_category s0_
  LEFT JOIN service_category s1_ ON s0_.id = s1_.parent_id
WHERE
  s0_.parent_id IS NULL
  AND s0_.is_active = ?
  AND (
    s1_.id IS NULL
    OR s1_.is_active = ?
  )
ORDER BY
  s0_.position ASC,
  s1_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.icon AS icon_4, s0_.image AS image_5, s0_.position AS position_6, s0_.color AS color_7, s0_.seo_title AS seo_title_8, s0_.seo_description AS seo_description_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_active AS is_active_12, s1_.id AS id_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.icon AS icon_17, s1_.image AS image_18, s1_.position AS position_19, s1_.color AS color_20, s1_.seo_title AS seo_title_21, s1_.seo_description AS seo_description_22, s1_.created_at AS created_at_23, s1_.updated_at AS updated_at_24, s1_.is_active AS is_active_25, s0_.parent_id AS parent_id_26, s1_.parent_id AS parent_id_27 FROM service_category s0_ LEFT JOIN service_category s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.is_active = 1 AND (s1_.id IS NULL OR s1_.is_active = 1) ORDER BY s0_.position ASC, s1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.position AS position_3,
  t0.title AS title_4,
  t0.alt_text AS alt_text_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.prestation_id AS prestation_id_8
FROM
  prestation_media t0
WHERE
  t0.prestation_id = ?
ORDER BY
  t0.position ASC,
  t0.created_at ASC

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.position AS position_3, t0.title AS title_4, t0.alt_text AS alt_text_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestation_id AS prestation_id_8 FROM prestation_media t0 WHERE t0.prestation_id = 349 ORDER BY t0.position ASC, t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.day_of_week AS day_of_week_2,
  t0.morning_enabled AS morning_enabled_3,
  t0.morning_start AS morning_start_4,
  t0.morning_end AS morning_end_5,
  t0.afternoon_enabled AS afternoon_enabled_6,
  t0.afternoon_start AS afternoon_start_7,
  t0.afternoon_end AS afternoon_end_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.prestataire_profile_id AS prestataire_profile_id_11
FROM
  prestataire_availability t0
WHERE
  t0.prestataire_profile_id = ?
ORDER BY
  t0.day_of_week ASC

SELECT t0.id AS id_1, t0.day_of_week AS day_of_week_2, t0.morning_enabled AS morning_enabled_3, t0.morning_start AS morning_start_4, t0.morning_end AS morning_end_5, t0.afternoon_enabled AS afternoon_enabled_6, t0.afternoon_start AS afternoon_start_7, t0.afternoon_end AS afternoon_end_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.prestataire_profile_id AS prestataire_profile_id_11 FROM prestataire_availability t0 WHERE t0.prestataire_profile_id = '117' ORDER BY t0.day_of_week ASC;

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.postal_code AS postal_code_3,
  t0.department AS department_4,
  t0.region AS region_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.radius_km AS radius_km_8,
  t0.is_main_zone AS is_main_zone_9,
  t0.is_active AS is_active_10,
  t0.prestataire_profile_id AS prestataire_profile_id_11
FROM
  prestataire_intervention_zone t0
WHERE
  t0.prestataire_profile_id = ?

SELECT t0.id AS id_1, t0.city AS city_2, t0.postal_code AS postal_code_3, t0.department AS department_4, t0.region AS region_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.radius_km AS radius_km_8, t0.is_main_zone AS is_main_zone_9, t0.is_active AS is_active_10, t0.prestataire_profile_id AS prestataire_profile_id_11 FROM prestataire_intervention_zone t0 WHERE t0.prestataire_profile_id = '117';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.image AS image_6,
  t0.average_price_min AS average_price_min_7,
  t0.average_price_max AS average_price_max_8,
  t0.position AS position_9,
  t0.is_active AS is_active_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.category_id AS category_id_13
FROM
  service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.image AS image_6, t0.average_price_min AS average_price_min_7, t0.average_price_max AS average_price_max_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13 FROM service t0 WHERE t0.id = 249;