GET https://prestataire.trouvemoi.pro/bons-plans?page=2

Response
200 OK
IP
216.73.217.34
Profiled on
Token
1a0221

Query Metrics

19 Database Queries
7 Different statements
7.23 ms Query time
0 Invalid entities
52 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.25 ms
(31.20%) 		1 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.title AS title_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.pricing_type AS pricing_type_5, p0_.price_from AS price_from_6, p0_.price_to AS price_to_7, p0_.price_unit AS price_unit_8, p0_.additional_info AS additional_info_9, p0_.position AS position_10, p0_.prix_catalogue AS prix_catalogue_11, p0_.taux_reduction AS taux_reduction_12, p0_.promotion_created_at AS promotion_created_at_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.slug AS slug_16, p1_.id AS id_17, p1_.company_name AS company_name_18, p1_.slug AS slug_19, p1_.legal_name AS legal_name_20, p1_.structure_type AS structure_type_21, p1_.siren AS siren_22, p1_.siret AS siret_23, p1_.vat_number AS vat_number_24, p1_.address AS address_25, p1_.address_complement AS address_complement_26, p1_.postal_code AS postal_code_27, p1_.city AS city_28, p1_.country AS country_29, p1_.latitude AS latitude_30, p1_.longitude AS longitude_31, p1_.geohash AS geohash_32, p1_.phone_public AS phone_public_33, p1_.phone_private AS phone_private_34, p1_.website AS website_35, p1_.facebook_url AS facebook_url_36, p1_.instagram_url AS instagram_url_37, p1_.linkedin_url AS linkedin_url_38, p1_.short_description AS short_description_39, p1_.long_description AS long_description_40, p1_.logo AS logo_41, p1_.cover_image AS cover_image_42, p1_.signature_image AS signature_image_43, p1_.profile_status AS profile_status_44, p1_.verification_status AS verification_status_45, p1_.completion_score AS completion_score_46, p1_.average_rating AS average_rating_47, p1_.reviews_count AS reviews_count_48, p1_.response_time_minutes AS response_time_minutes_49, p1_.is_featured AS is_featured_50, p1_.featured_until AS featured_until_51, p1_.search_visibility AS search_visibility_52, p1_.verified_at AS verified_at_53, p1_.created_at AS created_at_54, p1_.updated_at AS updated_at_55, p1_.deleted_at AS deleted_at_56, p1_.description AS description_57, p1_.metier AS metier_58, p1_.experience AS experience_59, p1_.document_verification_status AS document_verification_status_60, p1_.company_last_verification_at AS company_last_verification_at_61, p1_.company_verification_source AS company_verification_source_62, p1_.company_verification_note AS company_verification_note_63, p1_.is_on_vacation AS is_on_vacation_64, p1_.vacation_return_date AS vacation_return_date_65, s2_.id AS id_66, s2_.name AS name_67, s2_.slug AS slug_68, s2_.description AS description_69, s2_.icon AS icon_70, s2_.average_price_min AS average_price_min_71, s2_.average_price_max AS average_price_max_72, s2_.position AS position_73, s2_.is_active AS is_active_74, s2_.created_at AS created_at_75, s2_.updated_at AS updated_at_76, u3_.id AS id_77, u3_.email AS email_78, u3_.roles AS roles_79, u3_.password AS password_80, u3_.first_name AS first_name_81, u3_.last_name AS last_name_82, u3_.phone_number AS phone_number_83, u3_.phone_verified_at AS phone_verified_at_84, u3_.email_verified_at AS email_verified_at_85, u3_.is_verified AS is_verified_86, u3_.avatar AS avatar_87, u3_.locale AS locale_88, u3_.timezone AS timezone_89, u3_.status AS status_90, u3_.last_login_at AS last_login_at_91, u3_.login_count AS login_count_92, u3_.reset_token AS reset_token_93, u3_.reset_token_expires_at AS reset_token_expires_at_94, u3_.created_at AS created_at_95, u3_.updated_at AS updated_at_96, u3_.deleted_at AS deleted_at_97, u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98, u3_.notify_on_message_received AS notify_on_message_received_99, u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100, u3_.notify_on_review_received AS notify_on_review_received_101, s4_.id AS id_102, s4_.name AS name_103, s4_.slug AS slug_104, s4_.description AS description_105, s4_.icon AS icon_106, s4_.image AS image_107, s4_.position AS position_108, s4_.color AS color_109, s4_.seo_title AS seo_title_110, s4_.seo_description AS seo_description_111, s4_.created_at AS created_at_112, s4_.updated_at AS updated_at_113, s4_.is_active AS is_active_114, s5_.id AS id_115, s5_.name AS name_116, s5_.slug AS slug_117, s5_.description AS description_118, s5_.icon AS icon_119, s5_.image AS image_120, s5_.position AS position_121, s5_.color AS color_122, s5_.seo_title AS seo_title_123, s5_.seo_description AS seo_description_124, s5_.created_at AS created_at_125, s5_.updated_at AS updated_at_126, s5_.is_active AS is_active_127 FROM prestataire_profile_service p0_ INNER JOIN prestataire_profile p1_ ON p0_.prestataire_profile_id = p1_.id INNER JOIN service s2_ ON p0_.service_id = s2_.id LEFT JOIN "user" u3_ ON p1_.user_id = u3_.id LEFT JOIN service_category s4_ ON s2_.category_id = s4_.id LEFT JOIN service_category s5_ ON s4_.parent_id = s5_.id WHERE p1_.profile_status = ? AND p0_.is_active = ? AND p0_.taux_reduction IS NOT NULL AND p0_.taux_reduction > 0 ORDER BY p0_.taux_reduction DESC, p0_.id DESC) dctrn_result) dctrn_table
Parameters: 
[
  "ACTIVE"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(14.78%) 		1 
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.title AS title_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.pricing_type AS pricing_type_5, p0_.price_from AS price_from_6, p0_.price_to AS price_to_7, p0_.price_unit AS price_unit_8, p0_.additional_info AS additional_info_9, p0_.position AS position_10, p0_.prix_catalogue AS prix_catalogue_11, p0_.taux_reduction AS taux_reduction_12, p0_.promotion_created_at AS promotion_created_at_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.slug AS slug_16, p1_.id AS id_17, p1_.company_name AS company_name_18, p1_.slug AS slug_19, p1_.legal_name AS legal_name_20, p1_.structure_type AS structure_type_21, p1_.siren AS siren_22, p1_.siret AS siret_23, p1_.vat_number AS vat_number_24, p1_.address AS address_25, p1_.address_complement AS address_complement_26, p1_.postal_code AS postal_code_27, p1_.city AS city_28, p1_.country AS country_29, p1_.latitude AS latitude_30, p1_.longitude AS longitude_31, p1_.geohash AS geohash_32, p1_.phone_public AS phone_public_33, p1_.phone_private AS phone_private_34, p1_.website AS website_35, p1_.facebook_url AS facebook_url_36, p1_.instagram_url AS instagram_url_37, p1_.linkedin_url AS linkedin_url_38, p1_.short_description AS short_description_39, p1_.long_description AS long_description_40, p1_.logo AS logo_41, p1_.cover_image AS cover_image_42, p1_.signature_image AS signature_image_43, p1_.profile_status AS profile_status_44, p1_.verification_status AS verification_status_45, p1_.completion_score AS completion_score_46, p1_.average_rating AS average_rating_47, p1_.reviews_count AS reviews_count_48, p1_.response_time_minutes AS response_time_minutes_49, p1_.is_featured AS is_featured_50, p1_.featured_until AS featured_until_51, p1_.search_visibility AS search_visibility_52, p1_.verified_at AS verified_at_53, p1_.created_at AS created_at_54, p1_.updated_at AS updated_at_55, p1_.deleted_at AS deleted_at_56, p1_.description AS description_57, p1_.metier AS metier_58, p1_.experience AS experience_59, p1_.document_verification_status AS document_verification_status_60, p1_.company_last_verification_at AS company_last_verification_at_61, p1_.company_verification_source AS company_verification_source_62, p1_.company_verification_note AS company_verification_note_63, p1_.is_on_vacation AS is_on_vacation_64, p1_.vacation_return_date AS vacation_return_date_65, s2_.id AS id_66, s2_.name AS name_67, s2_.slug AS slug_68, s2_.description AS description_69, s2_.icon AS icon_70, s2_.average_price_min AS average_price_min_71, s2_.average_price_max AS average_price_max_72, s2_.position AS position_73, s2_.is_active AS is_active_74, s2_.created_at AS created_at_75, s2_.updated_at AS updated_at_76, u3_.id AS id_77, u3_.email AS email_78, u3_.roles AS roles_79, u3_.password AS password_80, u3_.first_name AS first_name_81, u3_.last_name AS last_name_82, u3_.phone_number AS phone_number_83, u3_.phone_verified_at AS phone_verified_at_84, u3_.email_verified_at AS email_verified_at_85, u3_.is_verified AS is_verified_86, u3_.avatar AS avatar_87, u3_.locale AS locale_88, u3_.timezone AS timezone_89, u3_.status AS status_90, u3_.last_login_at AS last_login_at_91, u3_.login_count AS login_count_92, u3_.reset_token AS reset_token_93, u3_.reset_token_expires_at AS reset_token_expires_at_94, u3_.created_at AS created_at_95, u3_.updated_at AS updated_at_96, u3_.deleted_at AS deleted_at_97, u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98, u3_.notify_on_message_received AS notify_on_message_received_99, u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100, u3_.notify_on_review_received AS notify_on_review_received_101, s4_.id AS id_102, s4_.name AS name_103, s4_.slug AS slug_104, s4_.description AS description_105, s4_.icon AS icon_106, s4_.image AS image_107, s4_.position AS position_108, s4_.color AS color_109, s4_.seo_title AS seo_title_110, s4_.seo_description AS seo_description_111, s4_.created_at AS created_at_112, s4_.updated_at AS updated_at_113, s4_.is_active AS is_active_114, s5_.id AS id_115, s5_.name AS name_116, s5_.slug AS slug_117, s5_.description AS description_118, s5_.icon AS icon_119, s5_.image AS image_120, s5_.position AS position_121, s5_.color AS color_122, s5_.seo_title AS seo_title_123, s5_.seo_description AS seo_description_124, s5_.created_at AS created_at_125, s5_.updated_at AS updated_at_126, s5_.is_active AS is_active_127, p0_.prestataire_profile_id AS prestataire_profile_id_128, p0_.service_id AS service_id_129, p1_.user_id AS user_id_130, s2_.category_id AS category_id_131, s4_.parent_id AS parent_id_132, s5_.parent_id AS parent_id_133 FROM prestataire_profile_service p0_ INNER JOIN prestataire_profile p1_ ON p0_.prestataire_profile_id = p1_.id INNER JOIN service s2_ ON p0_.service_id = s2_.id LEFT JOIN "user" u3_ ON p1_.user_id = u3_.id LEFT JOIN service_category s4_ ON s2_.category_id = s4_.id LEFT JOIN service_category s5_ ON s4_.parent_id = s5_.id WHERE p1_.profile_status = ? AND p0_.is_active = ? AND p0_.taux_reduction IS NOT NULL AND p0_.taux_reduction > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.taux_reduction DESC, p0_.id DESC
Parameters: 
[
  "ACTIVE"
  1
  31
  36
  21
  42
  22
  7
  37
  34
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
1.01 ms
(13.96%) 		7 
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters: 
[
  "22"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.98 ms
(13.63%) 		7 
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters: 
[
  "11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(11.24%) 		1 
SELECT DISTINCT id_0, MIN(sclr_128) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.title AS title_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.pricing_type AS pricing_type_5, p0_.price_from AS price_from_6, p0_.price_to AS price_to_7, p0_.price_unit AS price_unit_8, p0_.additional_info AS additional_info_9, p0_.position AS position_10, p0_.prix_catalogue AS prix_catalogue_11, p0_.taux_reduction AS taux_reduction_12, p0_.promotion_created_at AS promotion_created_at_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.slug AS slug_16, p1_.id AS id_17, p1_.company_name AS company_name_18, p1_.slug AS slug_19, p1_.legal_name AS legal_name_20, p1_.structure_type AS structure_type_21, p1_.siren AS siren_22, p1_.siret AS siret_23, p1_.vat_number AS vat_number_24, p1_.address AS address_25, p1_.address_complement AS address_complement_26, p1_.postal_code AS postal_code_27, p1_.city AS city_28, p1_.country AS country_29, p1_.latitude AS latitude_30, p1_.longitude AS longitude_31, p1_.geohash AS geohash_32, p1_.phone_public AS phone_public_33, p1_.phone_private AS phone_private_34, p1_.website AS website_35, p1_.facebook_url AS facebook_url_36, p1_.instagram_url AS instagram_url_37, p1_.linkedin_url AS linkedin_url_38, p1_.short_description AS short_description_39, p1_.long_description AS long_description_40, p1_.logo AS logo_41, p1_.cover_image AS cover_image_42, p1_.signature_image AS signature_image_43, p1_.profile_status AS profile_status_44, p1_.verification_status AS verification_status_45, p1_.completion_score AS completion_score_46, p1_.average_rating AS average_rating_47, p1_.reviews_count AS reviews_count_48, p1_.response_time_minutes AS response_time_minutes_49, p1_.is_featured AS is_featured_50, p1_.featured_until AS featured_until_51, p1_.search_visibility AS search_visibility_52, p1_.verified_at AS verified_at_53, p1_.created_at AS created_at_54, p1_.updated_at AS updated_at_55, p1_.deleted_at AS deleted_at_56, p1_.description AS description_57, p1_.metier AS metier_58, p1_.experience AS experience_59, p1_.document_verification_status AS document_verification_status_60, p1_.company_last_verification_at AS company_last_verification_at_61, p1_.company_verification_source AS company_verification_source_62, p1_.company_verification_note AS company_verification_note_63, p1_.is_on_vacation AS is_on_vacation_64, p1_.vacation_return_date AS vacation_return_date_65, s2_.id AS id_66, s2_.name AS name_67, s2_.slug AS slug_68, s2_.description AS description_69, s2_.icon AS icon_70, s2_.average_price_min AS average_price_min_71, s2_.average_price_max AS average_price_max_72, s2_.position AS position_73, s2_.is_active AS is_active_74, s2_.created_at AS created_at_75, s2_.updated_at AS updated_at_76, u3_.id AS id_77, u3_.email AS email_78, u3_.roles AS roles_79, u3_.password AS password_80, u3_.first_name AS first_name_81, u3_.last_name AS last_name_82, u3_.phone_number AS phone_number_83, u3_.phone_verified_at AS phone_verified_at_84, u3_.email_verified_at AS email_verified_at_85, u3_.is_verified AS is_verified_86, u3_.avatar AS avatar_87, u3_.locale AS locale_88, u3_.timezone AS timezone_89, u3_.status AS status_90, u3_.last_login_at AS last_login_at_91, u3_.login_count AS login_count_92, u3_.reset_token AS reset_token_93, u3_.reset_token_expires_at AS reset_token_expires_at_94, u3_.created_at AS created_at_95, u3_.updated_at AS updated_at_96, u3_.deleted_at AS deleted_at_97, u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98, u3_.notify_on_message_received AS notify_on_message_received_99, u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100, u3_.notify_on_review_received AS notify_on_review_received_101, s4_.id AS id_102, s4_.name AS name_103, s4_.slug AS slug_104, s4_.description AS description_105, s4_.icon AS icon_106, s4_.image AS image_107, s4_.position AS position_108, s4_.color AS color_109, s4_.seo_title AS seo_title_110, s4_.seo_description AS seo_description_111, s4_.created_at AS created_at_112, s4_.updated_at AS updated_at_113, s4_.is_active AS is_active_114, s5_.id AS id_115, s5_.name AS name_116, s5_.slug AS slug_117, s5_.description AS description_118, s5_.icon AS icon_119, s5_.image AS image_120, s5_.position AS position_121, s5_.color AS color_122, s5_.seo_title AS seo_title_123, s5_.seo_description AS seo_description_124, s5_.created_at AS created_at_125, s5_.updated_at AS updated_at_126, s5_.is_active AS is_active_127, ROW_NUMBER() OVER(ORDER BY p0_.taux_reduction DESC, p0_.id DESC) AS sclr_128 FROM prestataire_profile_service p0_ INNER JOIN prestataire_profile p1_ ON p0_.prestataire_profile_id = p1_.id INNER JOIN service s2_ ON p0_.service_id = s2_.id LEFT JOIN "user" u3_ ON p1_.user_id = u3_.id LEFT JOIN service_category s4_ ON s2_.category_id = s4_.id LEFT JOIN service_category s5_ ON s4_.parent_id = s5_.id WHERE p1_.profile_status = ? AND p0_.is_active = ? AND p0_.taux_reduction IS NOT NULL AND p0_.taux_reduction > 0) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 9 OFFSET 9
Parameters: 
[
  "ACTIVE"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(10.99%) 		1 
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.position AS position_7, t0.color AS color_8, t0.seo_title AS seo_title_9, t0.seo_description AS seo_description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.parent_id AS parent_id_14 FROM service_category t0 WHERE t0.parent_id IS NULL AND t0.is_active = ? ORDER BY t0.position ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(4.21%) 		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
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ServiceCategory 15
App\Entity\PrestataireService 9
App\Entity\PrestataireProfile 7
App\Entity\Subscription\SubscriptionCustomer 7
App\Entity\Service 7
App\Entity\User 7

Entities Mapping

Class Mapping errors
App\Entity\ServiceCategory No errors.
App\Entity\Service No errors.
App\Entity\PrestataireService No errors.
App\Entity\PrestataireProfile No errors.
App\Entity\User No errors.
App\Entity\PrestationMedia No errors.
App\Entity\QuoteRequest No errors.
App\Entity\PrestataireInterventionZone No errors.
App\Entity\PrestataireAppointment No errors.
App\Entity\PrestataireDocument No errors.
App\Entity\Subscription\SubscriptionCustomer No errors.
App\Entity\Subscription\PrestataireSubscription No errors.
App\Entity\Subscription\SubscriptionCreditMovement No errors.
App\Entity\PrestataireAvailability No errors.
App\Entity\Favorite No errors.
App\Entity\ClientProfile No errors.
App\Entity\Notification No errors.