Symfony Profiler

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.description AS description_2,
  g0_.logo AS logo_3,
  g0_.phone_france AS phone_france_4,
  g0_.phone_destination AS phone_destination_5,
  g0_.email AS email_6,
  g0_.address_france AS address_france_7,
  g0_.postal_code_france AS postal_code_france_8,
  g0_.city_france AS city_france_9,
  g0_.country_france AS country_france_10,
  g0_.address_destination AS address_destination_11,
  g0_.destination_country AS destination_country_12,
  g0_.company_name AS company_name_13,
  g0_.siret AS siret_14,
  g0_.creation_year AS creation_year_15,
  g0_.manager_first_name AS manager_first_name_16,
  g0_.manager_last_name AS manager_last_name_17,
  g0_.kbis_file AS kbis_file_18,
  g0_.rib_file AS rib_file_19,
  g0_.cni_file AS cni_file_20,
  g0_.document_type AS document_type_21,
  g0_.sejour_verso_file AS sejour_verso_file_22,
  g0_.plan AS plan_23,
  g0_.destinations AS destinations_24,
  g0_.payment_methods AS payment_methods_25,
  g0_.gallery AS gallery_26,
  g0_.rating AS rating_27,
  g0_.review_count AS review_count_28,
  g0_.is_verified AS is_verified_29,
  g0_.is_suspended AS is_suspended_30,
  g0_.home_delivery AS home_delivery_31,
  g0_.packaging_service AS packaging_service_32,
  g0_.online_payment AS online_payment_33,
  g0_.sms_tracking AS sms_tracking_34,
  g0_.insurance AS insurance_35,
  g0_.accepts_bankily AS accepts_bankily_36,
  g0_.accepts_wave AS accepts_wave_37,
  g0_.accepts_orange_money AS accepts_orange_money_38,
  g0_.max_weight AS max_weight_39,
  g0_.insurance_percentage AS insurance_percentage_40,
  g0_.home_delivery_fee AS home_delivery_fee_41,
  g0_.packaging_fee AS packaging_fee_42,
  g0_.insurance_rate AS insurance_rate_43,
  g0_.photo_service AS photo_service_44,
  g0_.average_delivery_time AS average_delivery_time_45,
  g0_.slogan AS slogan_46,
  g0_.website AS website_47,
  g0_.facebook AS facebook_48,
  g0_.whatsapp AS whatsapp_49,
  g0_.notification_preferences AS notification_preferences_50,
  g0_.notification_channels AS notification_channels_51,
  g0_.next_billing_date AS next_billing_date_52,
  g0_.payment_method AS payment_method_53,
  g0_.stripe_customer_id AS stripe_customer_id_54,
  g0_.is_public_profile AS is_public_profile_55,
  g0_.accept_new_reservations AS accept_new_reservations_56,
  g0_.auto_boost AS auto_boost_57,
  g0_.two_factor_enabled AS two_factor_enabled_58,
  g0_.integrations AS integrations_59,
  g0_.created_at AS created_at_60,
  g0_.updated_at AS updated_at_61,
  g0_.profile_slug AS profile_slug_62,
  g0_.user_id AS user_id_63
FROM
  gp g0_
WHERE
  g0_.is_verified = ?
  AND g0_.is_suspended = ?
  AND g0_.is_public_profile = ?
ORDER BY
  g0_.rating DESC,
  g0_.review_count DESC
LIMIT
  12

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.logo AS logo_3, g0_.phone_france AS phone_france_4, g0_.phone_destination AS phone_destination_5, g0_.email AS email_6, g0_.address_france AS address_france_7, g0_.postal_code_france AS postal_code_france_8, g0_.city_france AS city_france_9, g0_.country_france AS country_france_10, g0_.address_destination AS address_destination_11, g0_.destination_country AS destination_country_12, g0_.company_name AS company_name_13, g0_.siret AS siret_14, g0_.creation_year AS creation_year_15, g0_.manager_first_name AS manager_first_name_16, g0_.manager_last_name AS manager_last_name_17, g0_.kbis_file AS kbis_file_18, g0_.rib_file AS rib_file_19, g0_.cni_file AS cni_file_20, g0_.document_type AS document_type_21, g0_.sejour_verso_file AS sejour_verso_file_22, g0_.plan AS plan_23, g0_.destinations AS destinations_24, g0_.payment_methods AS payment_methods_25, g0_.gallery AS gallery_26, g0_.rating AS rating_27, g0_.review_count AS review_count_28, g0_.is_verified AS is_verified_29, g0_.is_suspended AS is_suspended_30, g0_.home_delivery AS home_delivery_31, g0_.packaging_service AS packaging_service_32, g0_.online_payment AS online_payment_33, g0_.sms_tracking AS sms_tracking_34, g0_.insurance AS insurance_35, g0_.accepts_bankily AS accepts_bankily_36, g0_.accepts_wave AS accepts_wave_37, g0_.accepts_orange_money AS accepts_orange_money_38, g0_.max_weight AS max_weight_39, g0_.insurance_percentage AS insurance_percentage_40, g0_.home_delivery_fee AS home_delivery_fee_41, g0_.packaging_fee AS packaging_fee_42, g0_.insurance_rate AS insurance_rate_43, g0_.photo_service AS photo_service_44, g0_.average_delivery_time AS average_delivery_time_45, g0_.slogan AS slogan_46, g0_.website AS website_47, g0_.facebook AS facebook_48, g0_.whatsapp AS whatsapp_49, g0_.notification_preferences AS notification_preferences_50, g0_.notification_channels AS notification_channels_51, g0_.next_billing_date AS next_billing_date_52, g0_.payment_method AS payment_method_53, g0_.stripe_customer_id AS stripe_customer_id_54, g0_.is_public_profile AS is_public_profile_55, g0_.accept_new_reservations AS accept_new_reservations_56, g0_.auto_boost AS auto_boost_57, g0_.two_factor_enabled AS two_factor_enabled_58, g0_.integrations AS integrations_59, g0_.created_at AS created_at_60, g0_.updated_at AS updated_at_61, g0_.profile_slug AS profile_slug_62, g0_.user_id AS user_id_63 FROM gp g0_ WHERE g0_.is_verified = 1 AND g0_.is_suspended = 0 AND g0_.is_public_profile = 1 ORDER BY g0_.rating DESC, g0_.review_count DESC LIMIT 12;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gp g0_
WHERE
  g0_.is_verified = ?
  AND g0_.is_suspended = ?
  AND g0_.is_public_profile = ?

SELECT COUNT(g0_.id) AS sclr_0 FROM gp g0_ WHERE g0_.is_verified = 1 AND g0_.is_suspended = 0 AND g0_.is_public_profile = 1;

SELECT
  g0_.destinations AS destinations_0
FROM
  gp g0_
WHERE
  g0_.is_verified = 1
  AND g0_.is_suspended = 0
  AND g0_.destinations IS NOT NULL

SELECT g0_.destinations AS destinations_0 FROM gp g0_ WHERE g0_.is_verified = 1 AND g0_.is_suspended = 0 AND g0_.destinations IS NOT NULL;

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  review r0_
  INNER JOIN gp g1_ ON r0_.gp_id = g1_.id
WHERE
  r0_.is_approved = ?
  AND g1_.is_verified = ?
  AND g1_.is_suspended = ?

SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ INNER JOIN gp g1_ ON r0_.gp_id = g1_.id WHERE r0_.is_approved = 1 AND g1_.is_verified = 1 AND g1_.is_suspended = 0;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  trip t0_
  INNER JOIN gp g1_ ON t0_.gp_id = g1_.id
WHERE
  t0_.is_active = ?
  AND t0_.status = ?
  AND t0_.departure_date >= ?
  AND g1_.is_suspended = ?

SELECT COUNT(t0_.id) AS sclr_0 FROM trip t0_ INNER JOIN gp g1_ ON t0_.gp_id = g1_.id WHERE t0_.is_active = 1 AND t0_.status = 'active' AND t0_.departure_date >= '2026-06-14 07:41:23' AND g1_.is_suspended = 0;

SELECT
  t0.id AS id_1,
  t0.site_logo AS site_logo_2,
  t0.contact_email AS contact_email_3,
  t0.contact_phone AS contact_phone_4,
  t0.updated_at AS updated_at_5,
  t0.stripe_test_secret_key AS stripe_test_secret_key_6,
  t0.stripe_test_publishable_key AS stripe_test_publishable_key_7,
  t0.stripe_live_secret_key AS stripe_live_secret_key_8,
  t0.stripe_live_publishable_key AS stripe_live_publishable_key_9,
  t0.stripe_webhook_secret AS stripe_webhook_secret_10,
  t0.stripe_mode AS stripe_mode_11,
  t0.smtp_host AS smtp_host_12,
  t0.smtp_port AS smtp_port_13,
  t0.smtp_username AS smtp_username_14,
  t0.smtp_password AS smtp_password_15,
  t0.smtp_encryption AS smtp_encryption_16,
  t0.smtp_sender_email AS smtp_sender_email_17,
  t0.smtp_sender_name AS smtp_sender_name_18,
  t0.footer_tagline AS footer_tagline_19,
  t0.footer_description AS footer_description_20,
  t0.social_facebook AS social_facebook_21,
  t0.social_twitter AS social_twitter_22,
  t0.social_instagram AS social_instagram_23,
  t0.social_whatsapp AS social_whatsapp_24,
  t0.social_linkedin AS social_linkedin_25,
  t0.footer_whatsapp AS footer_whatsapp_26,
  t0.footer_hours AS footer_hours_27,
  t0.footer_stat_packages AS footer_stat_packages_28,
  t0.footer_stat_gps AS footer_stat_gps_29,
  t0.footer_stat_destinations AS footer_stat_destinations_30,
  t0.footer_stat_rating AS footer_stat_rating_31,
  t0.app_store_url AS app_store_url_32,
  t0.google_play_url AS google_play_url_33
FROM
  settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_logo AS site_logo_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4, t0.updated_at AS updated_at_5, t0.stripe_test_secret_key AS stripe_test_secret_key_6, t0.stripe_test_publishable_key AS stripe_test_publishable_key_7, t0.stripe_live_secret_key AS stripe_live_secret_key_8, t0.stripe_live_publishable_key AS stripe_live_publishable_key_9, t0.stripe_webhook_secret AS stripe_webhook_secret_10, t0.stripe_mode AS stripe_mode_11, t0.smtp_host AS smtp_host_12, t0.smtp_port AS smtp_port_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.smtp_encryption AS smtp_encryption_16, t0.smtp_sender_email AS smtp_sender_email_17, t0.smtp_sender_name AS smtp_sender_name_18, t0.footer_tagline AS footer_tagline_19, t0.footer_description AS footer_description_20, t0.social_facebook AS social_facebook_21, t0.social_twitter AS social_twitter_22, t0.social_instagram AS social_instagram_23, t0.social_whatsapp AS social_whatsapp_24, t0.social_linkedin AS social_linkedin_25, t0.footer_whatsapp AS footer_whatsapp_26, t0.footer_hours AS footer_hours_27, t0.footer_stat_packages AS footer_stat_packages_28, t0.footer_stat_gps AS footer_stat_gps_29, t0.footer_stat_destinations AS footer_stat_destinations_30, t0.footer_stat_rating AS footer_stat_rating_31, t0.app_store_url AS app_store_url_32, t0.google_play_url AS google_play_url_33 FROM settings t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_logo AS site_logo_2,
  t0.contact_email AS contact_email_3,
  t0.contact_phone AS contact_phone_4,
  t0.updated_at AS updated_at_5,
  t0.stripe_test_secret_key AS stripe_test_secret_key_6,
  t0.stripe_test_publishable_key AS stripe_test_publishable_key_7,
  t0.stripe_live_secret_key AS stripe_live_secret_key_8,
  t0.stripe_live_publishable_key AS stripe_live_publishable_key_9,
  t0.stripe_webhook_secret AS stripe_webhook_secret_10,
  t0.stripe_mode AS stripe_mode_11,
  t0.smtp_host AS smtp_host_12,
  t0.smtp_port AS smtp_port_13,
  t0.smtp_username AS smtp_username_14,
  t0.smtp_password AS smtp_password_15,
  t0.smtp_encryption AS smtp_encryption_16,
  t0.smtp_sender_email AS smtp_sender_email_17,
  t0.smtp_sender_name AS smtp_sender_name_18,
  t0.footer_tagline AS footer_tagline_19,
  t0.footer_description AS footer_description_20,
  t0.social_facebook AS social_facebook_21,
  t0.social_twitter AS social_twitter_22,
  t0.social_instagram AS social_instagram_23,
  t0.social_whatsapp AS social_whatsapp_24,
  t0.social_linkedin AS social_linkedin_25,
  t0.footer_whatsapp AS footer_whatsapp_26,
  t0.footer_hours AS footer_hours_27,
  t0.footer_stat_packages AS footer_stat_packages_28,
  t0.footer_stat_gps AS footer_stat_gps_29,
  t0.footer_stat_destinations AS footer_stat_destinations_30,
  t0.footer_stat_rating AS footer_stat_rating_31,
  t0.app_store_url AS app_store_url_32,
  t0.google_play_url AS google_play_url_33
FROM
  settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_logo AS site_logo_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4, t0.updated_at AS updated_at_5, t0.stripe_test_secret_key AS stripe_test_secret_key_6, t0.stripe_test_publishable_key AS stripe_test_publishable_key_7, t0.stripe_live_secret_key AS stripe_live_secret_key_8, t0.stripe_live_publishable_key AS stripe_live_publishable_key_9, t0.stripe_webhook_secret AS stripe_webhook_secret_10, t0.stripe_mode AS stripe_mode_11, t0.smtp_host AS smtp_host_12, t0.smtp_port AS smtp_port_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.smtp_encryption AS smtp_encryption_16, t0.smtp_sender_email AS smtp_sender_email_17, t0.smtp_sender_name AS smtp_sender_name_18, t0.footer_tagline AS footer_tagline_19, t0.footer_description AS footer_description_20, t0.social_facebook AS social_facebook_21, t0.social_twitter AS social_twitter_22, t0.social_instagram AS social_instagram_23, t0.social_whatsapp AS social_whatsapp_24, t0.social_linkedin AS social_linkedin_25, t0.footer_whatsapp AS footer_whatsapp_26, t0.footer_hours AS footer_hours_27, t0.footer_stat_packages AS footer_stat_packages_28, t0.footer_stat_gps AS footer_stat_gps_29, t0.footer_stat_destinations AS footer_stat_destinations_30, t0.footer_stat_rating AS footer_stat_rating_31, t0.app_store_url AS app_store_url_32, t0.google_play_url AS google_play_url_33 FROM settings t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_logo AS site_logo_2,
  t0.contact_email AS contact_email_3,
  t0.contact_phone AS contact_phone_4,
  t0.updated_at AS updated_at_5,
  t0.stripe_test_secret_key AS stripe_test_secret_key_6,
  t0.stripe_test_publishable_key AS stripe_test_publishable_key_7,
  t0.stripe_live_secret_key AS stripe_live_secret_key_8,
  t0.stripe_live_publishable_key AS stripe_live_publishable_key_9,
  t0.stripe_webhook_secret AS stripe_webhook_secret_10,
  t0.stripe_mode AS stripe_mode_11,
  t0.smtp_host AS smtp_host_12,
  t0.smtp_port AS smtp_port_13,
  t0.smtp_username AS smtp_username_14,
  t0.smtp_password AS smtp_password_15,
  t0.smtp_encryption AS smtp_encryption_16,
  t0.smtp_sender_email AS smtp_sender_email_17,
  t0.smtp_sender_name AS smtp_sender_name_18,
  t0.footer_tagline AS footer_tagline_19,
  t0.footer_description AS footer_description_20,
  t0.social_facebook AS social_facebook_21,
  t0.social_twitter AS social_twitter_22,
  t0.social_instagram AS social_instagram_23,
  t0.social_whatsapp AS social_whatsapp_24,
  t0.social_linkedin AS social_linkedin_25,
  t0.footer_whatsapp AS footer_whatsapp_26,
  t0.footer_hours AS footer_hours_27,
  t0.footer_stat_packages AS footer_stat_packages_28,
  t0.footer_stat_gps AS footer_stat_gps_29,
  t0.footer_stat_destinations AS footer_stat_destinations_30,
  t0.footer_stat_rating AS footer_stat_rating_31,
  t0.app_store_url AS app_store_url_32,
  t0.google_play_url AS google_play_url_33
FROM
  settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_logo AS site_logo_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4, t0.updated_at AS updated_at_5, t0.stripe_test_secret_key AS stripe_test_secret_key_6, t0.stripe_test_publishable_key AS stripe_test_publishable_key_7, t0.stripe_live_secret_key AS stripe_live_secret_key_8, t0.stripe_live_publishable_key AS stripe_live_publishable_key_9, t0.stripe_webhook_secret AS stripe_webhook_secret_10, t0.stripe_mode AS stripe_mode_11, t0.smtp_host AS smtp_host_12, t0.smtp_port AS smtp_port_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.smtp_encryption AS smtp_encryption_16, t0.smtp_sender_email AS smtp_sender_email_17, t0.smtp_sender_name AS smtp_sender_name_18, t0.footer_tagline AS footer_tagline_19, t0.footer_description AS footer_description_20, t0.social_facebook AS social_facebook_21, t0.social_twitter AS social_twitter_22, t0.social_instagram AS social_instagram_23, t0.social_whatsapp AS social_whatsapp_24, t0.social_linkedin AS social_linkedin_25, t0.footer_whatsapp AS footer_whatsapp_26, t0.footer_hours AS footer_hours_27, t0.footer_stat_packages AS footer_stat_packages_28, t0.footer_stat_gps AS footer_stat_gps_29, t0.footer_stat_destinations AS footer_stat_destinations_30, t0.footer_stat_rating AS footer_stat_rating_31, t0.app_store_url AS app_store_url_32, t0.google_play_url AS google_play_url_33 FROM settings t0 LIMIT 1;