Symfony Profiler

SELECT
  t0_.departure_city AS departure_city_0,
  t0_.arrival_city AS arrival_city_1,
  t0_.arrival_country AS arrival_country_2,
  MIN(t0_.price_per_kg) AS sclr_3,
  COUNT(DISTINCT t0_.gp_id) AS sclr_4,
  COUNT(t0_.id) AS sclr_5,
  AVG(g1_.rating) AS sclr_6
FROM
  trip t0_
  LEFT JOIN gp g1_ ON t0_.gp_id = g1_.id
WHERE
  t0_.is_active = ?
  AND t0_.status = ?
  AND g1_.is_suspended = ?
  AND g1_.is_verified = ?
GROUP BY
  t0_.departure_city,
  t0_.arrival_city,
  t0_.arrival_country
ORDER BY
  sclr_5 DESC
LIMIT
  12

SELECT t0_.departure_city AS departure_city_0, t0_.arrival_city AS arrival_city_1, t0_.arrival_country AS arrival_country_2, MIN(t0_.price_per_kg) AS sclr_3, COUNT(DISTINCT t0_.gp_id) AS sclr_4, COUNT(t0_.id) AS sclr_5, AVG(g1_.rating) AS sclr_6 FROM trip t0_ LEFT JOIN gp g1_ ON t0_.gp_id = g1_.id WHERE t0_.is_active = 1 AND t0_.status = 'active' AND g1_.is_suspended = 0 AND g1_.is_verified = 1 GROUP BY t0_.departure_city, t0_.arrival_city, t0_.arrival_country ORDER BY sclr_5 DESC LIMIT 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.phone_france AS phone_france_5,
  t0.phone_destination AS phone_destination_6,
  t0.email AS email_7,
  t0.address_france AS address_france_8,
  t0.postal_code_france AS postal_code_france_9,
  t0.city_france AS city_france_10,
  t0.country_france AS country_france_11,
  t0.address_destination AS address_destination_12,
  t0.destination_country AS destination_country_13,
  t0.company_name AS company_name_14,
  t0.siret AS siret_15,
  t0.creation_year AS creation_year_16,
  t0.manager_first_name AS manager_first_name_17,
  t0.manager_last_name AS manager_last_name_18,
  t0.kbis_file AS kbis_file_19,
  t0.rib_file AS rib_file_20,
  t0.cni_file AS cni_file_21,
  t0.document_type AS document_type_22,
  t0.sejour_verso_file AS sejour_verso_file_23,
  t0.plan AS plan_24,
  t0.destinations AS destinations_25,
  t0.payment_methods AS payment_methods_26,
  t0.gallery AS gallery_27,
  t0.rating AS rating_28,
  t0.review_count AS review_count_29,
  t0.is_verified AS is_verified_30,
  t0.is_suspended AS is_suspended_31,
  t0.home_delivery AS home_delivery_32,
  t0.packaging_service AS packaging_service_33,
  t0.online_payment AS online_payment_34,
  t0.sms_tracking AS sms_tracking_35,
  t0.insurance AS insurance_36,
  t0.accepts_bankily AS accepts_bankily_37,
  t0.accepts_wave AS accepts_wave_38,
  t0.accepts_orange_money AS accepts_orange_money_39,
  t0.max_weight AS max_weight_40,
  t0.insurance_percentage AS insurance_percentage_41,
  t0.home_delivery_fee AS home_delivery_fee_42,
  t0.packaging_fee AS packaging_fee_43,
  t0.insurance_rate AS insurance_rate_44,
  t0.photo_service AS photo_service_45,
  t0.average_delivery_time AS average_delivery_time_46,
  t0.slogan AS slogan_47,
  t0.website AS website_48,
  t0.facebook AS facebook_49,
  t0.whatsapp AS whatsapp_50,
  t0.notification_preferences AS notification_preferences_51,
  t0.notification_channels AS notification_channels_52,
  t0.next_billing_date AS next_billing_date_53,
  t0.payment_method AS payment_method_54,
  t0.stripe_customer_id AS stripe_customer_id_55,
  t0.is_public_profile AS is_public_profile_56,
  t0.accept_new_reservations AS accept_new_reservations_57,
  t0.auto_boost AS auto_boost_58,
  t0.two_factor_enabled AS two_factor_enabled_59,
  t0.integrations AS integrations_60,
  t0.created_at AS created_at_61,
  t0.updated_at AS updated_at_62,
  t0.profile_slug AS profile_slug_63,
  t0.user_id AS user_id_64
FROM
  gp t0
WHERE
  t0.is_verified = ?
  AND t0.is_suspended = ?
ORDER BY
  t0.rating DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.phone_france AS phone_france_5, t0.phone_destination AS phone_destination_6, t0.email AS email_7, t0.address_france AS address_france_8, t0.postal_code_france AS postal_code_france_9, t0.city_france AS city_france_10, t0.country_france AS country_france_11, t0.address_destination AS address_destination_12, t0.destination_country AS destination_country_13, t0.company_name AS company_name_14, t0.siret AS siret_15, t0.creation_year AS creation_year_16, t0.manager_first_name AS manager_first_name_17, t0.manager_last_name AS manager_last_name_18, t0.kbis_file AS kbis_file_19, t0.rib_file AS rib_file_20, t0.cni_file AS cni_file_21, t0.document_type AS document_type_22, t0.sejour_verso_file AS sejour_verso_file_23, t0.plan AS plan_24, t0.destinations AS destinations_25, t0.payment_methods AS payment_methods_26, t0.gallery AS gallery_27, t0.rating AS rating_28, t0.review_count AS review_count_29, t0.is_verified AS is_verified_30, t0.is_suspended AS is_suspended_31, t0.home_delivery AS home_delivery_32, t0.packaging_service AS packaging_service_33, t0.online_payment AS online_payment_34, t0.sms_tracking AS sms_tracking_35, t0.insurance AS insurance_36, t0.accepts_bankily AS accepts_bankily_37, t0.accepts_wave AS accepts_wave_38, t0.accepts_orange_money AS accepts_orange_money_39, t0.max_weight AS max_weight_40, t0.insurance_percentage AS insurance_percentage_41, t0.home_delivery_fee AS home_delivery_fee_42, t0.packaging_fee AS packaging_fee_43, t0.insurance_rate AS insurance_rate_44, t0.photo_service AS photo_service_45, t0.average_delivery_time AS average_delivery_time_46, t0.slogan AS slogan_47, t0.website AS website_48, t0.facebook AS facebook_49, t0.whatsapp AS whatsapp_50, t0.notification_preferences AS notification_preferences_51, t0.notification_channels AS notification_channels_52, t0.next_billing_date AS next_billing_date_53, t0.payment_method AS payment_method_54, t0.stripe_customer_id AS stripe_customer_id_55, t0.is_public_profile AS is_public_profile_56, t0.accept_new_reservations AS accept_new_reservations_57, t0.auto_boost AS auto_boost_58, t0.two_factor_enabled AS two_factor_enabled_59, t0.integrations AS integrations_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.profile_slug AS profile_slug_63, t0.user_id AS user_id_64 FROM gp t0 WHERE t0.is_verified = 1 AND t0.is_suspended = 0 ORDER BY t0.rating DESC LIMIT 8;

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.code AS code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.monthly_price AS monthly_price_5,
  t0.yearly_price AS yearly_price_6,
  t0.commission_rate AS commission_rate_7,
  t0.max_trips_per_month AS max_trips_per_month_8,
  t0.max_photos AS max_photos_9,
  t0.priority_support AS priority_support_10,
  t0.featured_listing AS featured_listing_11,
  t0.analytics_access AS analytics_access_12,
  t0.custom_branding AS custom_branding_13,
  t0.api_access AS api_access_14,
  t0.trial_days AS trial_days_15,
  t0.features AS features_16,
  t0.requires_payment_setup AS requires_payment_setup_17,
  t0.is_active AS is_active_18,
  t0.is_popular AS is_popular_19,
  t0.sort_order AS sort_order_20,
  t0.stripe_monthly_price_id AS stripe_monthly_price_id_21,
  t0.stripe_yearly_price_id AS stripe_yearly_price_id_22,
  t0.badge_color AS badge_color_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25
FROM
  subscription_plan t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.monthly_price AS monthly_price_5, t0.yearly_price AS yearly_price_6, t0.commission_rate AS commission_rate_7, t0.max_trips_per_month AS max_trips_per_month_8, t0.max_photos AS max_photos_9, t0.priority_support AS priority_support_10, t0.featured_listing AS featured_listing_11, t0.analytics_access AS analytics_access_12, t0.custom_branding AS custom_branding_13, t0.api_access AS api_access_14, t0.trial_days AS trial_days_15, t0.features AS features_16, t0.requires_payment_setup AS requires_payment_setup_17, t0.is_active AS is_active_18, t0.is_popular AS is_popular_19, t0.sort_order AS sort_order_20, t0.stripe_monthly_price_id AS stripe_monthly_price_id_21, t0.stripe_yearly_price_id AS stripe_yearly_price_id_22, t0.badge_color AS badge_color_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25 FROM subscription_plan t0 WHERE t0.is_active = 1 ORDER BY t0.sort_order ASC;

SELECT
  COUNT(*)
FROM
  gp t0
WHERE
  t0.is_verified = ?
  AND t0.is_suspended = ?

SELECT COUNT(*) FROM gp t0 WHERE t0.is_verified = 1 AND t0.is_suspended = 0;

SELECT
  COUNT(*)
FROM
  trip t0
WHERE
  t0.is_active = ?
  AND t0.status = ?

SELECT COUNT(*) FROM trip t0 WHERE t0.is_active = 1 AND t0.status = 'active';

SELECT
  AVG(g0_.rating) AS sclr_0
FROM
  gp g0_
WHERE
  g0_.is_verified = ?
  AND g0_.is_suspended = ?
  AND g0_.rating > 0

SELECT AVG(g0_.rating) AS sclr_0 FROM gp g0_ WHERE g0_.is_verified = 1 AND g0_.is_suspended = 0 AND g0_.rating > 0;

SELECT
  COUNT(DISTINCT t0_.arrival_country) AS sclr_0
FROM
  trip t0_
WHERE
  t0_.is_active = ?

SELECT COUNT(DISTINCT t0_.arrival_country) AS sclr_0 FROM trip t0_ WHERE t0_.is_active = 1;