Symfony Profiler

Query Metrics

29 Database Queries

9 Different statements

52.26 ms Query time

1 Invalid entities

63 Managed entities

Queries


SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ?
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1
SELECT DISTINCT d0_.id AS id_0, d0_.priority AS priority_1, d0_.id AS id_2 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 ORDER BY d0_.priority DESC, d0_.id DESC LIMIT 10 OFFSET 40
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.location AS location_2, d0_.description AS description_3, d0_.seo AS seo_4, d0_.slug AS slug_5, d0_.created AS created_6, d0_.updated AS updated_7, d0_.priority AS priority_8, d0_.active AS active_9, d0_.ski_max_height AS ski_max_height_10, d0_.ski_min_height AS ski_min_height_11, d0_.ski_kms AS ski_kms_12, d0_.ski_slopes AS ski_slopes_13, d0_.ski_greens AS ski_greens_14, d0_.ski_blues AS ski_blues_15, d0_.ski_reds AS ski_reds_16, d0_.ski_blacks AS ski_blacks_17, d0_.ski_facilities AS ski_facilities_18, d0_.ski_services AS ski_services_19, d0_.ski_forecast AS ski_forecast_20, d0_.geo_location_latitude AS geo_location_latitude_21, d0_.geo_location_longitude AS geo_location_longitude_22, d0_.main_image_id AS main_image_id_23, d0_.zone_id AS zone_id_24, d0_.category_id AS category_id_25 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.priority DESC, d0_.id DESC
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
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 = ?
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
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 = ?
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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack')
SELECT t0.id AS id_1, t0.title AS title_2 FROM menu t0
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 = ?

#▲	Time	Info
1	0.76 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ? Parameters: [`"Tipos de destino"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ? SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = 'Tipos de destino';
2	1.11 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ? Parameters: [`"Tipos de destino"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ? SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = 'Tipos de destino';
3	2.80 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ? Parameters: [`"Zonas"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ? SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = 'Zonas';
4	0.76 ms	SELECT count(DISTINCT d0_.id) AS sclr_0 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 Parameters: [`2563`] View formatted query View runnable query Explain query SELECT count(DISTINCT d0_.id) AS sclr_0 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 SELECT count(DISTINCT d0_.id) AS sclr_0 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = 2563 AND d0_.active = 1;
5	0.42 ms	SELECT DISTINCT d0_.id AS id_0, d0_.priority AS priority_1, d0_.id AS id_2 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 ORDER BY d0_.priority DESC, d0_.id DESC LIMIT 10 OFFSET 40 Parameters: [`2563`] View formatted query View runnable query Explain query SELECT DISTINCT d0_.id AS id_0, d0_.priority AS priority_1, d0_.id AS id_2 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 ORDER BY d0_.priority DESC, d0_.id DESC LIMIT 10 OFFSET 40 SELECT DISTINCT d0_.id AS id_0, d0_.priority AS priority_1, d0_.id AS id_2 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = 2563 AND d0_.active = 1 ORDER BY d0_.priority DESC, d0_.id DESC LIMIT 10 OFFSET 40;
6	12.50 ms	SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.location AS location_2, d0_.description AS description_3, d0_.seo AS seo_4, d0_.slug AS slug_5, d0_.created AS created_6, d0_.updated AS updated_7, d0_.priority AS priority_8, d0_.active AS active_9, d0_.ski_max_height AS ski_max_height_10, d0_.ski_min_height AS ski_min_height_11, d0_.ski_kms AS ski_kms_12, d0_.ski_slopes AS ski_slopes_13, d0_.ski_greens AS ski_greens_14, d0_.ski_blues AS ski_blues_15, d0_.ski_reds AS ski_reds_16, d0_.ski_blacks AS ski_blacks_17, d0_.ski_facilities AS ski_facilities_18, d0_.ski_services AS ski_services_19, d0_.ski_forecast AS ski_forecast_20, d0_.geo_location_latitude AS geo_location_latitude_21, d0_.geo_location_longitude AS geo_location_longitude_22, d0_.main_image_id AS main_image_id_23, d0_.zone_id AS zone_id_24, d0_.category_id AS category_id_25 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.priority DESC, d0_.id DESC Parameters: [`2563 26 23 22 21 20 19 18 17 16 15`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.location AS location_2, d0_.description AS description_3, d0_.seo AS seo_4, d0_.slug AS slug_5, d0_.created AS created_6, d0_.updated AS updated_7, d0_.priority AS priority_8, d0_.active AS active_9, d0_.ski_max_height AS ski_max_height_10, d0_.ski_min_height AS ski_min_height_11, d0_.ski_kms AS ski_kms_12, d0_.ski_slopes AS ski_slopes_13, d0_.ski_greens AS ski_greens_14, d0_.ski_blues AS ski_blues_15, d0_.ski_reds AS ski_reds_16, d0_.ski_blacks AS ski_blacks_17, d0_.ski_facilities AS ski_facilities_18, d0_.ski_services AS ski_services_19, d0_.ski_forecast AS ski_forecast_20, d0_.geo_location_latitude AS geo_location_latitude_21, d0_.geo_location_longitude AS geo_location_longitude_22, d0_.main_image_id AS main_image_id_23, d0_.zone_id AS zone_id_24, d0_.category_id AS category_id_25 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.priority DESC, d0_.id DESC SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.location AS location_2, d0_.description AS description_3, d0_.seo AS seo_4, d0_.slug AS slug_5, d0_.created AS created_6, d0_.updated AS updated_7, d0_.priority AS priority_8, d0_.active AS active_9, d0_.ski_max_height AS ski_max_height_10, d0_.ski_min_height AS ski_min_height_11, d0_.ski_kms AS ski_kms_12, d0_.ski_slopes AS ski_slopes_13, d0_.ski_greens AS ski_greens_14, d0_.ski_blues AS ski_blues_15, d0_.ski_reds AS ski_reds_16, d0_.ski_blacks AS ski_blacks_17, d0_.ski_facilities AS ski_facilities_18, d0_.ski_services AS ski_services_19, d0_.ski_forecast AS ski_forecast_20, d0_.geo_location_latitude AS geo_location_latitude_21, d0_.geo_location_longitude AS geo_location_longitude_22, d0_.main_image_id AS main_image_id_23, d0_.zone_id AS zone_id_24, d0_.category_id AS category_id_25 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = 2563 AND d0_.active = 1 AND d0_.id IN (26, 23, 22, 21, 20, 19, 18, 17, 16, 15) ORDER BY d0_.priority DESC, d0_.id DESC;
7	1.11 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 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 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 = 'homepage' LIMIT 1;
8	1.68 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 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 = ? 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 = 8176;
9	1.17 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: [`6287`] View formatted query View runnable query Explain query 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 = ? 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 = 6287;
10	0.90 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`26`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 26 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
11	0.87 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`23`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 23 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
12	1.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: [`6263`] View formatted query View runnable query Explain query 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 = ? 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 = 6263;
13	1.00 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`22`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 22 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
14	0.98 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: [`6261`] View formatted query View runnable query Explain query 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 = ? 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 = 6261;
15	0.59 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`21`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 21 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
16	0.50 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: [`6257`] View formatted query View runnable query Explain query 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 = ? 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 = 6257;
17	3.28 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`20`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 20 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
18	1.72 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: [`6253`] View formatted query View runnable query Explain query 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 = ? 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 = 6253;
19	0.77 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`19`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 19 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
20	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: [`6250`] View formatted query View runnable query Explain query 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 = ? 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 = 6250;
21	1.25 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`18`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 18 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
22	8.24 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: [`6244`] View formatted query View runnable query Explain query 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 = ? 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 = 6244;
23	0.93 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`17`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 17 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
24	0.81 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: [`6238`] View formatted query View runnable query Explain query 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 = ? 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 = 6238;
25	3.84 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`16`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 16 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
26	0.49 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: [`6234`] View formatted query View runnable query Explain query 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 = ? 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 = 6234;
27	0.53 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 WHERE t0.destination_id = ? AND t0.product_type IN ('product', 'ski', 'activity', 'pack') Parameters: [`15`] View formatted query View runnable query Explain query 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 WHERE t0.destination_id = ? AND t0.product_type IN ( 'product', 'ski', 'activity', 'pack' ) 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 WHERE t0.destination_id = 15 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');
28	0.63 ms	SELECT t0.id AS id_1, t0.title AS title_2 FROM menu t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2 FROM menu t0 SELECT t0.id AS id_1, t0.title AS title_2 FROM menu t0;
29	0.60 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 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 = ? 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 = 33;

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\Product	18
Uniski\ConfigBundle\Entity\Category	15
Uniski\ResourceBundle\Entity\Image	12
Uniski\ResourceBundle\Entity\Destination	10
Uniski\CMSBundle\Entity\Offer	5
Uniski\CMSBundle\Entity\Menu	2
Uniski\ConfigBundle\Entity\Configuration	1

Entities Mapping

Class	Mapping errors
Uniski\ResourceBundle\Entity\Hotel	No errors.
Uniski\ConfigBundle\Entity\Category	No errors.
Uniski\ResourceBundle\Entity\ValueObject\SkiStation	No errors.
Uniski\ResourceBundle\Entity\ValueObject\GeoLocation	No errors.
Uniski\ResourceBundle\Entity\Destination	No errors.
Uniski\ResourceBundle\Entity\Image	No errors.
Uniski\ResourceBundle\Entity\Product	No errors.
Uniski\ConfigBundle\Entity\Configuration	No errors.
Uniski\ResourceBundle\Entity\Shop	No errors.
Uniski\ResourceBundle\Entity\PriceRate	No errors.
Uniski\ResourceBundle\Entity\HotelRate	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\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\CMSBundle\Entity\Menu	No errors.
Uniski\CMSBundle\Entity\Offer	No errors.
Uniski\CMSBundle\Entity\Page	No errors.
Uniski\ResourceBundle\Entity\RentingRate	No errors.
Uniski\ResourceBundle\Entity\Document	No errors.
Uniski\ResourceBundle\Entity\InsuranceRate	No errors.
Uniski\UserBundle\Entity\User	No errors.

Symfony Profiler

GET https://uniski.mikowsky.com/destinos?estacion=sierra-nevada&page=5

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping