Query Metrics
1
Database Queries
1
Different statements
1.55 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.55 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_.capacity AS capacity_16, s0_.level AS level_17, s0_.languages AS languages_18, s0_.included AS included_19, s0_.subtitle AS subtitle_20, s0_.activity_type AS activity_type_21, s0_.minimum_age AS minimum_age_22, s0_.programme AS programme_23, s0_.meeting_point AS meeting_point_24, s0_.opening_period AS opening_period_25, s0_.audience AS audience_26, s0_.cancellation_policy AS cancellation_policy_27, s0_.address AS address_28, s0_.city AS city_29, s0_.postal_code AS postal_code_30, s0_.country AS country_31, s0_.latitude AS latitude_32, s0_.longitude AS longitude_33, s0_.id AS id_34, s0_.created_at AS created_at_35, s0_.updated_at AS updated_at_36, s0_.deleted_at AS deleted_at_37, s1_.name AS name_38, s1_.description AS description_39, s1_.price AS price_40, s1_.currency AS currency_41, s1_.pricing_unit AS pricing_unit_42, s1_.delivery_days AS delivery_days_43, s1_.id AS id_44, s1_.created_at AS created_at_45, s1_.updated_at AS updated_at_46, m2_.path AS path_47, m2_.type AS type_48, m2_.position AS position_49, m2_.id AS id_50, m2_.created_at AS created_at_51, m2_.updated_at AS updated_at_52, c3_.name AS name_53, c3_.slug AS slug_54, c3_.position AS position_55, c3_.id AS id_56, c3_.created_at AS created_at_57, c3_.updated_at AS updated_at_58, s0_.provider_id AS provider_id_59, s0_.category_id AS category_id_60, s0_.destination_id AS destination_id_61, s1_.service_id AS service_id_62, m2_.service_id AS service_id_63, c3_.parent_id AS parent_id_64 FROM service s0_ LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id LEFT JOIN media m2_ ON s0_.id = m2_.service_id LEFT JOIN category c3_ ON s0_.category_id = c3_.id WHERE s0_.slug = ? AND s0_.status = ? AND s0_.deleted_at IS NULL
Parameters:
[ "visite-guidee-de-labyrinthe" "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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Catalog\Entity\Service | No errors. |
| App\Catalog\Entity\ServicePackage | No errors. |
| App\Catalog\Entity\Media | No errors. |
| App\Catalog\Entity\Category | No errors. |
| App\Provider\Entity\ProviderProfile | No errors. |
| App\Catalog\Entity\Destination | No errors. |