Query Metrics
14
Database Queries
11
Different statements
6.27 ms
Query time
0
Invalid entities
14
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.22 ms |
SET TIME ZONE 'Europe/Paris'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 2 | 1.02 ms |
SELECT t0.display_name AS display_name_1, t0.slug AS slug_2, t0.bio AS bio_3, t0.company_name AS company_name_4, t0.city AS city_5, t0.status AS status_6, t0.facebook_url AS facebook_url_7, t0.instagram_url AS instagram_url_8, t0.linkedin_url AS linkedin_url_9, t0.website_url AS website_url_10, t0.address AS address_11, t0.cover_path AS cover_path_12, t0.intervention_zone AS intervention_zone_13, t0.youtube_url AS youtube_url_14, t0.timezone AS timezone_15, t0.availability_label AS availability_label_16, t0.payment_link_url AS payment_link_url_17, t0.payment_paypal AS payment_paypal_18, t0.payment_iban AS payment_iban_19, t0.payment_iban_holder AS payment_iban_holder_20, t0.payment_on_site AS payment_on_site_21, t0.payment_instructions AS payment_instructions_22, t0.online_payment_enabled AS online_payment_enabled_23, t0.accepts_stripe AS accepts_stripe_24, t0.accepts_paypal AS accepts_paypal_25, t0.accepts_cash AS accepts_cash_26, t0.stripe_account_id AS stripe_account_id_27, t0.stripe_charges_enabled AS stripe_charges_enabled_28, t0.paypal_merchant_id AS paypal_merchant_id_29, t0.paypal_tracking_id AS paypal_tracking_id_30, t0.paypal_payments_enabled AS paypal_payments_enabled_31, t0.id AS id_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.deleted_at AS deleted_at_35, t0.user_id AS user_id_36, t0.main_category_id AS main_category_id_37 FROM provider_profile t0 WHERE t0.slug = ? AND t0.status = ? LIMIT 1
Parameters:
[ "atelier-des-saveurs" "verified" ]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.50 ms |
SELECT t0.rating AS rating_1, t0.comment AS comment_2, t0.status AS status_3, t0.provider_reply AS provider_reply_4, t0.replied_at AS replied_at_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.author_id AS author_id_9, t0.provider_id AS provider_id_10, t0.quote_id AS quote_id_11, t0.booking_id AS booking_id_12, t0.service_id AS service_id_13 FROM review t0 WHERE t0.provider_id = ? ORDER BY t0.created_at DESC
Parameters:
[
"01a1679a-9bfe-ea13-c788-e4ef235da2a9"
]
|
||||||||||||||||||||||||||||||||||
| 4 | 1.51 ms |
SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.booking_type AS booking_type_3, s0_.status AS status_4, s0_.currency AS currency_5, s0_.short_description AS short_description_6, s0_.duration_minutes AS duration_minutes_7, s0_.place_label AS place_label_8, s0_.duration_label AS duration_label_9, s0_.badge AS badge_10, s0_.search_text AS search_text_11, s0_.search_place AS search_place_12, s0_.position AS position_13, s0_.rating_average AS rating_average_14, s0_.reviews_count AS reviews_count_15, s0_.views_count AS views_count_16, s0_.capacity AS capacity_17, s0_.level AS level_18, s0_.languages AS languages_19, s0_.included AS included_20, s0_.subtitle AS subtitle_21, s0_.activity_type AS activity_type_22, s0_.minimum_age AS minimum_age_23, s0_.programme AS programme_24, s0_.meeting_point AS meeting_point_25, s0_.opening_period AS opening_period_26, s0_.audience AS audience_27, s0_.cancellation_policy AS cancellation_policy_28, s0_.address AS address_29, s0_.city AS city_30, s0_.postal_code AS postal_code_31, s0_.country AS country_32, s0_.latitude AS latitude_33, s0_.longitude AS longitude_34, s0_.id AS id_35, s0_.created_at AS created_at_36, s0_.updated_at AS updated_at_37, s0_.deleted_at AS deleted_at_38, c1_.name AS name_39, c1_.slug AS slug_40, c1_.position AS position_41, c1_.id AS id_42, c1_.created_at AS created_at_43, c1_.updated_at AS updated_at_44, m2_.path AS path_45, m2_.type AS type_46, m2_.position AS position_47, m2_.id AS id_48, m2_.created_at AS created_at_49, m2_.updated_at AS updated_at_50, s3_.name AS name_51, s3_.description AS description_52, s3_.price AS price_53, s3_.currency AS currency_54, s3_.pricing_unit AS pricing_unit_55, s3_.delivery_days AS delivery_days_56, s3_.id AS id_57, s3_.created_at AS created_at_58, s3_.updated_at AS updated_at_59, s0_.provider_id AS provider_id_60, s0_.category_id AS category_id_61, s0_.category_suggestion_id AS category_suggestion_id_62, s0_.destination_id AS destination_id_63, c1_.parent_id AS parent_id_64, m2_.service_id AS service_id_65, s3_.service_id AS service_id_66 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id LEFT JOIN media m2_ ON s0_.id = m2_.service_id LEFT JOIN service_package s3_ ON s0_.id = s3_.service_id WHERE s0_.provider_id = ? AND s0_.deleted_at IS NULL ORDER BY s0_.created_at DESC
Parameters:
[
"01a1679a-9bfe-ea13-c788-e4ef235da2a9"
]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.28 ms |
SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9c01-0a19-6cfb-e2309e29f1a2"
]
|
||||||||||||||||||||||||||||||||||
| 6 | 0.19 ms |
SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9c05-a041-6935-c6015bccaf84"
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.31 ms |
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.status AS status_7, t0.reset_code_hash AS reset_code_hash_8, t0.reset_code_expires_at AS reset_code_expires_at_9, t0.reset_code_attempts AS reset_code_attempts_10, t0.email_verification_code_hash AS email_verification_code_hash_11, t0.email_verification_expires_at AS email_verification_expires_at_12, t0.email_verification_attempts AS email_verification_attempts_13, t0.avatar_path AS avatar_path_14, t0.birth_date AS birth_date_15, t0.gender AS gender_16, t0.preferred_locale AS preferred_locale_17, t0.country AS country_18, t0.bio AS bio_19, t0.city AS city_20, t0.interests AS interests_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
"01a1679a-9bfd-6f40-3297-93c1baa68925"
]
|
||||||||||||||||||||||||||||||||||
| 8 | 0.62 ms |
SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.booking_type AS booking_type_3, s0_.status AS status_4, s0_.currency AS currency_5, s0_.short_description AS short_description_6, s0_.duration_minutes AS duration_minutes_7, s0_.place_label AS place_label_8, s0_.duration_label AS duration_label_9, s0_.badge AS badge_10, s0_.search_text AS search_text_11, s0_.search_place AS search_place_12, s0_.position AS position_13, s0_.rating_average AS rating_average_14, s0_.reviews_count AS reviews_count_15, s0_.views_count AS views_count_16, s0_.capacity AS capacity_17, s0_.level AS level_18, s0_.languages AS languages_19, s0_.included AS included_20, s0_.subtitle AS subtitle_21, s0_.activity_type AS activity_type_22, s0_.minimum_age AS minimum_age_23, s0_.programme AS programme_24, s0_.meeting_point AS meeting_point_25, s0_.opening_period AS opening_period_26, s0_.audience AS audience_27, s0_.cancellation_policy AS cancellation_policy_28, s0_.address AS address_29, s0_.city AS city_30, s0_.postal_code AS postal_code_31, s0_.country AS country_32, s0_.latitude AS latitude_33, s0_.longitude AS longitude_34, s0_.id AS id_35, s0_.created_at AS created_at_36, s0_.updated_at AS updated_at_37, s0_.deleted_at AS deleted_at_38, c1_.name AS name_39, c1_.slug AS slug_40, c1_.position AS position_41, c1_.id AS id_42, c1_.created_at AS created_at_43, c1_.updated_at AS updated_at_44, m2_.path AS path_45, m2_.type AS type_46, m2_.position AS position_47, m2_.id AS id_48, m2_.created_at AS created_at_49, m2_.updated_at AS updated_at_50, s3_.name AS name_51, s3_.description AS description_52, s3_.price AS price_53, s3_.currency AS currency_54, s3_.pricing_unit AS pricing_unit_55, s3_.delivery_days AS delivery_days_56, s3_.id AS id_57, s3_.created_at AS created_at_58, s3_.updated_at AS updated_at_59, s0_.provider_id AS provider_id_60, s0_.category_id AS category_id_61, s0_.category_suggestion_id AS category_suggestion_id_62, s0_.destination_id AS destination_id_63, c1_.parent_id AS parent_id_64, m2_.service_id AS service_id_65, s3_.service_id AS service_id_66 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id LEFT JOIN media m2_ ON s0_.id = m2_.service_id LEFT JOIN service_package s3_ ON s0_.id = s3_.service_id WHERE s0_.provider_id = ? AND s0_.deleted_at IS NULL ORDER BY s0_.created_at DESC
Parameters:
[
"01a1679a-9bfe-ea13-c788-e4ef235da2a9"
]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.17 ms |
SELECT t0.rating AS rating_1, t0.comment AS comment_2, t0.status AS status_3, t0.provider_reply AS provider_reply_4, t0.replied_at AS replied_at_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.author_id AS author_id_9, t0.provider_id AS provider_id_10, t0.quote_id AS quote_id_11, t0.booking_id AS booking_id_12, t0.service_id AS service_id_13 FROM review t0 WHERE t0.provider_id = ? ORDER BY t0.created_at DESC
Parameters:
[
"01a1679a-9bfe-ea13-c788-e4ef235da2a9"
]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.34 ms |
SELECT t0.title AS title_1, t0.description AS description_2, t0.scheduled_at AS scheduled_at_3, t0.city AS city_4, t0.location AS location_5, t0.show_exact_address AS show_exact_address_6, t0.ends_at AS ends_at_7, t0.postal_code AS postal_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.meeting_point AS meeting_point_11, t0.to_bring AS to_bring_12, t0.cover_image AS cover_image_13, t0.visibility AS visibility_14, t0.participation_mode AS participation_mode_15, t0.status AS status_16, t0.level AS level_17, t0.min_participants AS min_participants_18, t0.max_participants AS max_participants_19, t0.views_count AS views_count_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organizer_id AS organizer_id_24, t0.category_id AS category_id_25, t0.category_suggestion_id AS category_suggestion_id_26, t0.service_id AS service_id_27 FROM private_activity t0 WHERE t0.organizer_id = ? ORDER BY t0.created_at DESC
Parameters:
[
"01a1679a-9bfd-6f40-3297-93c1baa68925"
]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.23 ms |
SELECT t0.status AS status_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.private_activity_id AS private_activity_id_5, t0.participant_id AS participant_id_6 FROM participation t0 WHERE t0.participant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
"01a1679a-9bfd-6f40-3297-93c1baa68925"
]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.26 ms |
SELECT m0_.rating AS rating_0, m0_.conviviality AS conviviality_1, m0_.organisation AS organisation_2, m0_.punctuality AS punctuality_3, m0_.communication AS communication_4, m0_.comment AS comment_5, m0_.id AS id_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.private_activity_id AS private_activity_id_9, m0_.author_id AS author_id_10, m0_.organizer_id AS organizer_id_11 FROM member_review m0_ WHERE m0_.organizer_id = ? ORDER BY m0_.created_at DESC
Parameters:
[
"01a1679a-9bfd-6f40-3297-93c1baa68925"
]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.41 ms |
SELECT c0_.archived_by_provider AS archived_by_provider_0, c0_.id AS id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, p1_.display_name AS display_name_4, p1_.slug AS slug_5, p1_.bio AS bio_6, p1_.company_name AS company_name_7, p1_.city AS city_8, p1_.status AS status_9, p1_.facebook_url AS facebook_url_10, p1_.instagram_url AS instagram_url_11, p1_.linkedin_url AS linkedin_url_12, p1_.website_url AS website_url_13, p1_.address AS address_14, p1_.cover_path AS cover_path_15, p1_.intervention_zone AS intervention_zone_16, p1_.youtube_url AS youtube_url_17, p1_.timezone AS timezone_18, p1_.availability_label AS availability_label_19, p1_.payment_link_url AS payment_link_url_20, p1_.payment_paypal AS payment_paypal_21, p1_.payment_iban AS payment_iban_22, p1_.payment_iban_holder AS payment_iban_holder_23, p1_.payment_on_site AS payment_on_site_24, p1_.payment_instructions AS payment_instructions_25, p1_.online_payment_enabled AS online_payment_enabled_26, p1_.accepts_stripe AS accepts_stripe_27, p1_.accepts_paypal AS accepts_paypal_28, p1_.accepts_cash AS accepts_cash_29, p1_.stripe_account_id AS stripe_account_id_30, p1_.stripe_charges_enabled AS stripe_charges_enabled_31, p1_.paypal_merchant_id AS paypal_merchant_id_32, p1_.paypal_tracking_id AS paypal_tracking_id_33, p1_.paypal_payments_enabled AS paypal_payments_enabled_34, p1_.id AS id_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.deleted_at AS deleted_at_38, c0_.client_id AS client_id_39, c0_.provider_id AS provider_id_40, c0_.member_id AS member_id_41, c0_.service_id AS service_id_42, p1_.user_id AS user_id_43, p1_.main_category_id AS main_category_id_44 FROM conversation c0_ LEFT JOIN provider_profile p1_ ON c0_.provider_id = p1_.id WHERE c0_.client_id = ? OR p1_.user_id = ? OR c0_.member_id = ?
Parameters:
[ "01a1679a-9bfd-6f40-3297-93c1baa68925" "01a1679a-9bfd-6f40-3297-93c1baa68925" "01a1679a-9bfd-6f40-3297-93c1baa68925" ]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.20 ms |
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.provider_id = ? AND r0_.status = ?
Parameters:
[ "01a1679a-9bfe-ea13-c788-e4ef235da2a9" "published" ]
|
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\Catalog\Entity\Media | 4 |
| App\Catalog\Entity\Category | 2 |
| App\Catalog\Entity\Service | 2 |
| App\Catalog\Entity\ServiceDetail | 2 |
| App\Catalog\Entity\ServicePackage | 2 |
| App\Provider\Entity\ProviderProfile | 1 |
| App\User\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Provider\Entity\ProviderProfile | No errors. |
| App\User\Entity\User | No errors. |
| App\Catalog\Entity\Category | No errors. |
| App\Review\Entity\Review | No errors. |
| App\Quote\Entity\Quote | No errors. |
| App\Booking\Entity\Booking | No errors. |
| App\Catalog\Entity\Service | No errors. |
| App\Catalog\Entity\Media | No errors. |
| App\Catalog\Entity\ServicePackage | No errors. |
| App\Catalog\Entity\CategorySuggestion | No errors. |
| App\Catalog\Entity\Destination | No errors. |
| App\Catalog\Entity\ServiceDetail | No errors. |
| App\Catalog\Entity\ServiceOption | No errors. |
| App\User\Entity\Address | No errors. |
| App\PrivateActivity\Entity\PrivateActivity | No errors. |
| App\PrivateActivity\Entity\Participation | No errors. |
| App\PrivateActivity\Entity\MemberReview | No errors. |
| App\Messaging\Entity\Conversation | No errors. |