GET https://uniski.mikowsky.com/

Response
200 OK
IP
216.73.217.116
Profiled on
Token
a7b539

Query Metrics

29 Database Queries
8 Different statements
24.61 ms Query time
1 Invalid entities
75 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.76 ms 
SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.teaser AS teaser_2, o0_.description AS description_3, o0_.period AS period_4, o0_.seo AS seo_5, o0_.slug AS slug_6, o0_.price AS price_7, o0_.frontpage AS frontpage_8, o0_.link AS link_9, o0_.created AS created_10, o0_.updated AS updated_11, o0_.webform AS webform_12, o0_.priority AS priority_13, o0_.image_id AS image_id_14, o0_.header_image_id AS header_image_id_15, o0_.tag_id AS tag_id_16, o0_.page_id AS page_id_17, o0_.menu_id AS menu_id_18 FROM offer o0_ WHERE o0_.frontpage IS NOT NULL ORDER BY o0_.priority DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 1.15 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.seo AS seo_5, t0.stick AS stick_6, t0.created AS created_7, t0.updated AS updated_8, t0.image_id AS image_id_9 FROM post t0 WHERE t0.stick = ? ORDER BY t0.created DESC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 0.68 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.seo AS seo_5, t0.stick AS stick_6, t0.created AS created_7, t0.updated AS updated_8, t0.image_id AS image_id_9 FROM post t0 WHERE t0.stick = ? ORDER BY t0.created DESC LIMIT 8
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
4 0.53 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.config_key AS config_key_3, t0.settings AS settings_4 FROM configuration t0 WHERE t0.config_key = ? LIMIT 1
Parameters: 
[
  "homepage"
]
View formatted query    View runnable query    Explain query
5 0.77 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.config_key AS config_key_3, t0.settings AS settings_4 FROM configuration t0 WHERE t0.config_key = ? LIMIT 1
Parameters: 
[
  "homepage"
]
View formatted query    View runnable query    Explain query
6 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  8176
]
View formatted query    View runnable query    Explain query
7 0.93 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  77916
]
View formatted query    View runnable query    Explain query
8 1.39 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
Parameters: 
[
  284
]
View formatted query    View runnable query    Explain query
9 0.40 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  41569
]
View formatted query    View runnable query    Explain query
10 1.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
Parameters: 
[
  243
]
View formatted query    View runnable query    Explain query
11 0.96 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  41746
]
View formatted query    View runnable query    Explain query
12 1.05 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
Parameters: 
[
  252
]
View formatted query    View runnable query    Explain query
13 0.52 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  41951
]
View formatted query    View runnable query    Explain query
14 0.68 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
Parameters: 
[
  263
]
View formatted query    View runnable query    Explain query
15 0.80 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  41969
]
View formatted query    View runnable query    Explain query
16 1.43 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
Parameters: 
[
  269
]
View formatted query    View runnable query    Explain query
17 2.12 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  8144
]
View formatted query    View runnable query    Explain query
18 0.76 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
Parameters: 
[
  93
]
View formatted query    View runnable query    Explain query
19 0.75 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  8331
]
View formatted query    View runnable query    Explain query
20 0.94 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
Parameters: 
[
  170
]
View formatted query    View runnable query    Explain query
21 0.84 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  7957
]
View formatted query    View runnable query    Explain query
22 0.73 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  7960
]
View formatted query    View runnable query    Explain query
23 0.48 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  7968
]
View formatted query    View runnable query    Explain query
24 0.52 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  42143
]
View formatted query    View runnable query    Explain query
25 0.47 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  42163
]
View formatted query    View runnable query    Explain query
26 0.36 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  8096
]
View formatted query    View runnable query    Explain query
27 0.41 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  8143
]
View formatted query    View runnable query    Explain query
28 0.82 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM menu t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
29 0.77 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.teaser AS teaser_3, t0.description AS description_4, t0.period AS period_5, t0.seo AS seo_6, t0.slug AS slug_7, t0.price AS price_8, t0.frontpage AS frontpage_9, t0.link AS link_10, t0.created AS created_11, t0.updated AS updated_12, t0.webform AS webform_13, t0.priority AS priority_14, t0.image_id AS image_id_15, t0.header_image_id AS header_image_id_16, t0.tag_id AS tag_id_17, t0.page_id AS page_id_18, t0.menu_id AS menu_id_19 FROM offer t0 WHERE t0.menu_id = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query

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
Uniski\ResourceBundle\Entity\Image 33
Uniski\CMSBundle\Entity\Offer 21
Uniski\CMSBundle\Entity\Post 12
Uniski\CMSBundle\Entity\Page 4
Uniski\CMSBundle\Entity\Menu 2
Uniski\ConfigBundle\Entity\Configuration 1
Uniski\ResourceBundle\Entity\Product 1
Uniski\ResourceBundle\Entity\Destination 1

Entities Mapping

Class Mapping errors
Uniski\ResourceBundle\Entity\PriceRate No errors.
Uniski\ResourceBundle\Entity\HotelRate No errors.
Uniski\ResourceBundle\Entity\Hotel No errors.
Uniski\CMSBundle\Entity\Offer No errors.
Uniski\ResourceBundle\Entity\Image No errors.
Uniski\ConfigBundle\Entity\Category No errors.
Uniski\CMSBundle\Entity\Page No errors.
Uniski\CMSBundle\Entity\Menu No errors.
Uniski\ResourceBundle\Entity\Product No errors.
Uniski\CMSBundle\Entity\Post No errors.
Uniski\ConfigBundle\Entity\Configuration No errors.
Uniski\ResourceBundle\Entity\Shop No errors.
Uniski\ResourceBundle\Entity\Address No errors.
Uniski\ResourceBundle\Entity\RoomStock No errors.
Uniski\ResourceBundle\Entity\RoomRestriction No errors.
Uniski\ResourceBundle\Entity\Extra No errors.
Uniski\ResourceBundle\Entity\Insurance No errors.
Uniski\ResourceBundle\Entity\ValueObject\SkiStation No errors.
Uniski\ResourceBundle\Entity\ValueObject\GeoLocation No errors.
Uniski\ResourceBundle\Entity\Destination No errors.
Uniski\CommerceBundle\Entity\PaymentPlan
  • The field 'Uniski\CommerceBundle\Entity\PaymentPlan#depositPercentage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'Uniski\CommerceBundle\Entity\PaymentPlan#minInstallmentAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'Uniski\CommerceBundle\Entity\PaymentPlan#minBookingTotal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Uniski\ResourceBundle\Entity\Ski No errors.
Uniski\ResourceBundle\Entity\Activity No errors.
Uniski\ResourceBundle\Entity\Pack No errors.
Uniski\ResourceBundle\Entity\RentingRate No errors.
Uniski\ResourceBundle\Entity\Document No errors.
Uniski\ResourceBundle\Entity\InsuranceRate No errors.