Query Metrics
18
Database Queries
7
Different statements
4.98 ms
Query time
0
Invalid entities
48
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.22 ms |
SET TIME ZONE 'Europe/Paris'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT p0_.title AS title_0, p0_.subtitle AS subtitle_1, p0_.kind AS kind_2, p0_.discount_percent AS discount_percent_3, p0_.starts_at AS starts_at_4, p0_.ends_at AS ends_at_5, p0_.paused AS paused_6, p0_.views_count AS views_count_7, p0_.clicks_count AS clicks_count_8, p0_.id AS id_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.deleted_at AS deleted_at_12, s1_.title AS title_13, s1_.slug AS slug_14, s1_.description AS description_15, s1_.booking_type AS booking_type_16, s1_.status AS status_17, s1_.currency AS currency_18, s1_.short_description AS short_description_19, s1_.duration_minutes AS duration_minutes_20, s1_.place_label AS place_label_21, s1_.duration_label AS duration_label_22, s1_.badge AS badge_23, s1_.search_text AS search_text_24, s1_.search_place AS search_place_25, s1_.position AS position_26, s1_.rating_average AS rating_average_27, s1_.reviews_count AS reviews_count_28, s1_.views_count AS views_count_29, s1_.capacity AS capacity_30, s1_.level AS level_31, s1_.languages AS languages_32, s1_.included AS included_33, s1_.subtitle AS subtitle_34, s1_.activity_type AS activity_type_35, s1_.minimum_age AS minimum_age_36, s1_.programme AS programme_37, s1_.meeting_point AS meeting_point_38, s1_.opening_period AS opening_period_39, s1_.audience AS audience_40, s1_.cancellation_policy AS cancellation_policy_41, s1_.address AS address_42, s1_.city AS city_43, s1_.postal_code AS postal_code_44, s1_.country AS country_45, s1_.latitude AS latitude_46, s1_.longitude AS longitude_47, s1_.id AS id_48, s1_.created_at AS created_at_49, s1_.updated_at AS updated_at_50, s1_.deleted_at AS deleted_at_51, p2_.display_name AS display_name_52, p2_.slug AS slug_53, p2_.bio AS bio_54, p2_.company_name AS company_name_55, p2_.city AS city_56, p2_.status AS status_57, p2_.facebook_url AS facebook_url_58, p2_.instagram_url AS instagram_url_59, p2_.linkedin_url AS linkedin_url_60, p2_.website_url AS website_url_61, p2_.address AS address_62, p2_.cover_path AS cover_path_63, p2_.intervention_zone AS intervention_zone_64, p2_.youtube_url AS youtube_url_65, p2_.timezone AS timezone_66, p2_.availability_label AS availability_label_67, p2_.payment_link_url AS payment_link_url_68, p2_.payment_paypal AS payment_paypal_69, p2_.payment_iban AS payment_iban_70, p2_.payment_iban_holder AS payment_iban_holder_71, p2_.payment_on_site AS payment_on_site_72, p2_.payment_instructions AS payment_instructions_73, p2_.online_payment_enabled AS online_payment_enabled_74, p2_.accepts_stripe AS accepts_stripe_75, p2_.accepts_paypal AS accepts_paypal_76, p2_.accepts_cash AS accepts_cash_77, p2_.stripe_account_id AS stripe_account_id_78, p2_.stripe_charges_enabled AS stripe_charges_enabled_79, p2_.paypal_merchant_id AS paypal_merchant_id_80, p2_.paypal_tracking_id AS paypal_tracking_id_81, p2_.paypal_payments_enabled AS paypal_payments_enabled_82, p2_.id AS id_83, p2_.created_at AS created_at_84, p2_.updated_at AS updated_at_85, p2_.deleted_at AS deleted_at_86, p0_.provider_id AS provider_id_87, p0_.service_id AS service_id_88, s1_.provider_id AS provider_id_89, s1_.category_id AS category_id_90, s1_.category_suggestion_id AS category_suggestion_id_91, s1_.destination_id AS destination_id_92, p2_.user_id AS user_id_93, p2_.main_category_id AS main_category_id_94 FROM promotion p0_ LEFT JOIN service s1_ ON p0_.service_id = s1_.id INNER JOIN provider_profile p2_ ON p0_.provider_id = p2_.id WHERE p0_.deleted_at IS NULL AND p0_.paused = false AND (p0_.starts_at <= ? AND p0_.ends_at >= ?) AND (s1_.id IS NULL OR (s1_.status = ? AND s1_.deleted_at IS NULL)) ORDER BY p0_.ends_at ASC
Parameters:
[ "2026-11-06 20:19:43" "2026-11-06 20:19:43" "published" ]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.37 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-9a2b-1f06-ef0a-1b6b19516601"
]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.20 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-9bf4-a186-c882-ab89c781c3de"
]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.17 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-9a2c-bb8f-f4ab-91fec93ac2a4"
]
|
||||||||||||||||||||||||||||||||||
| 6 | 0.16 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-9a2d-9300-6a93-e585b628d8f5"
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.22 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9a2b-1f06-ef0a-1b6b19516601"
]
|
||||||||||||||||||||||||||||||||||
| 8 | 0.21 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9a2b-1f06-ef0a-1b6b19516601"
]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.21 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?
Parameters:
[
"01a1679a-9a26-e705-f90b-e668fabbc853"
]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.13 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9bf4-a186-c882-ab89c781c3de"
]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.12 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9bf4-a186-c882-ab89c781c3de"
]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.11 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?
Parameters:
[
"01a1679a-9a26-e705-f90b-e668fabbc859"
]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.12 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9a2c-bb8f-f4ab-91fec93ac2a4"
]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.12 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9a2c-bb8f-f4ab-91fec93ac2a4"
]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.11 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?
Parameters:
[
"01a1679a-9a26-e705-f90b-e668fabbc854"
]
|
||||||||||||||||||||||||||||||||||
| 16 | 0.11 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9a2d-9300-6a93-e585b628d8f5"
]
|
||||||||||||||||||||||||||||||||||
| 17 | 0.11 ms |
SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?
Parameters:
[
"01a1679a-9a2d-9300-6a93-e585b628d8f5"
]
|
||||||||||||||||||||||||||||||||||
| 18 | 0.26 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC
Parameters:
[]
|
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 | 20 |
| App\Catalog\Entity\Category | 8 |
| App\Catalog\Entity\Promotion | 4 |
| App\Catalog\Entity\Service | 4 |
| App\Catalog\Entity\ServiceDetail | 4 |
| App\Catalog\Entity\ServicePackage | 4 |
| App\Provider\Entity\ProviderProfile | 2 |
| App\User\Entity\User | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Catalog\Entity\Promotion | No errors. |
| App\Catalog\Entity\Service | No errors. |
| App\Provider\Entity\ProviderProfile | No errors. |
| App\Catalog\Entity\Category | No errors. |
| App\Catalog\Entity\CategorySuggestion | No errors. |
| App\Catalog\Entity\Destination | No errors. |
| App\User\Entity\User | No errors. |
| App\Catalog\Entity\ServiceDetail | No errors. |
| App\Catalog\Entity\ServicePackage | No errors. |
| App\Catalog\Entity\Media | No errors. |
| App\Catalog\Entity\ServiceOption | No errors. |