Symfony Profiler

Query Metrics

47 Database Queries

39 Different statements

2489.09 ms Query time

1 Invalid entities

105 Cache hits

15 Cache misses

51 Cache puts

Grouped Statements

Show all queries

Time▼	Count	Info
731.15 ms (29.37%)	1	SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, COUNT(v1_.id) AS sclr_23, v0_.redirect_location_id AS redirect_location_id_24, v0_.destination_id AS destination_id_25 FROM v4_location v0_ INNER JOIN v4_location v2_ ON (v2_.id = ? AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') LEFT JOIN villa v1_ ON (v1_.is_indexable = 1 AND ST_CONTAINS(v0_.geo_shape, v1_.geo_point) > 0 AND v1_.is_active = 1) WHERE v0_.is_active = 1 GROUP BY v0_.id ORDER BY ST_AREA(v0_.geo_shape) DESC Parameters: [`9`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, CAST( ST_AsGeoJSON(v0_.geo_shape) AS CHAR ) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, COUNT(v1_.id) AS sclr_23, v0_.redirect_location_id AS redirect_location_id_24, v0_.destination_id AS destination_id_25 FROM v4_location v0_ INNER JOIN v4_location v2_ ON ( v2_.id = ? AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0 ) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') LEFT JOIN villa v1_ ON ( v1_.is_indexable = 1 AND ST_CONTAINS(v0_.geo_shape, v1_.geo_point) > 0 AND v1_.is_active = 1 ) WHERE v0_.is_active = 1 GROUP BY v0_.id ORDER BY ST_AREA(v0_.geo_shape) DESC SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, COUNT(v1_.id) AS sclr_23, v0_.redirect_location_id AS redirect_location_id_24, v0_.destination_id AS destination_id_25 FROM v4_location v0_ INNER JOIN v4_location v2_ ON (v2_.id = 9 AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') LEFT JOIN villa v1_ ON (v1_.is_indexable = 1 AND ST_CONTAINS(v0_.geo_shape, v1_.geo_point) > 0 AND v1_.is_active = 1) WHERE v0_.is_active = 1 GROUP BY v0_.id ORDER BY ST_AREA(v0_.geo_shape) DESC;
643.96 ms (25.87%)	1	SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, COUNT(v1_.id) AS sclr_23, v0_.redirect_location_id AS redirect_location_id_24, v0_.destination_id AS destination_id_25 FROM v4_location v0_ INNER JOIN villa v1_ ON (v1_.is_indexable = 1 AND ST_CONTAINS(v0_.geo_shape, v1_.geo_point) > 0) INNER JOIN villa_configuration v2_ ON v1_.id = v2_.villa_id AND (v2_.rooms = ?) WHERE v0_.id = ? GROUP BY v0_.id Parameters: [`2 9`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, CAST( ST_AsGeoJSON(v0_.geo_shape) AS CHAR ) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, COUNT(v1_.id) AS sclr_23, v0_.redirect_location_id AS redirect_location_id_24, v0_.destination_id AS destination_id_25 FROM v4_location v0_ INNER JOIN villa v1_ ON ( v1_.is_indexable = 1 AND ST_CONTAINS(v0_.geo_shape, v1_.geo_point) > 0 ) INNER JOIN villa_configuration v2_ ON v1_.id = v2_.villa_id AND (v2_.rooms = ?) WHERE v0_.id = ? GROUP BY v0_.id SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, COUNT(v1_.id) AS sclr_23, v0_.redirect_location_id AS redirect_location_id_24, v0_.destination_id AS destination_id_25 FROM v4_location v0_ INNER JOIN villa v1_ ON (v1_.is_indexable = 1 AND ST_CONTAINS(v0_.geo_shape, v1_.geo_point) > 0) INNER JOIN villa_configuration v2_ ON v1_.id = v2_.villa_id AND (v2_.rooms = 2) WHERE v0_.id = 9 GROUP BY v0_.id;
629.40 ms (25.29%)	1	SELECT f0_.firstname AS firstname_0, v1_.picture AS picture_1 FROM v4_user v1_ INNER JOIN fox_sales_client f0_ ON v1_.client_id = f0_.id INNER JOIN user_has_tc_location u3_ ON v1_.id = u3_.user_id INNER JOIN v4_location v2_ ON v2_.id = u3_.location_id AND (ST_CONTAINS(v2_.geo_shape, ST_GeomFromGeoJSON(?, 1, 4326)) > 0) WHERE v1_.picture IS NOT NULL AND v1_.roles LIKE ? AND v1_.enabled = 1 ORDER BY RAND() ASC LIMIT 1 Parameters: ["{"type": "Polygon", "coordinates": [[[115.02344965816332, -8.371568498407115], [115.11075386781232, -8.466018633016247], [115.17924089653924, -8.557754925625119], [115.19273394968302, -8.579890661291437], [115.21055835334924, -8.590605360279781], [115.26930769679308, -8.596331381169989], [115.2913128302535, -8.581334596700316], [115.3104303966996, -8.56633810047937], [115.33723131976996, -8.53778766642742], [115.35478767488952, -8.402341810234958], [115.32026019573276, -8.323020307858343], [115.21236112962195, -8.305502250458062], [115.14783910911632, -8.303583483588412], [115.10912666243644, -8.315355064949514], [115.0726053833704, -8.331117215761466], [115.0527198171634, -8.346343246775199], [115.02344965816332, -8.371568498407115]]]}" "%ROLE_CONSULTANT%"] View formatted query View runnable query Explain query SELECT f0_.firstname AS firstname_0, v1_.picture AS picture_1 FROM v4_user v1_ INNER JOIN fox_sales_client f0_ ON v1_.client_id = f0_.id INNER JOIN user_has_tc_location u3_ ON v1_.id = u3_.user_id INNER JOIN v4_location v2_ ON v2_.id = u3_.location_id AND ( ST_CONTAINS( v2_.geo_shape, ST_GeomFromGeoJSON(?, 1, 4326) ) > 0 ) WHERE v1_.picture IS NOT NULL AND v1_.roles LIKE ? AND v1_.enabled = 1 ORDER BY RAND() ASC LIMIT 1 SELECT f0_.firstname AS firstname_0, v1_.picture AS picture_1 FROM v4_user v1_ INNER JOIN fox_sales_client f0_ ON v1_.client_id = f0_.id INNER JOIN user_has_tc_location u3_ ON v1_.id = u3_.user_id INNER JOIN v4_location v2_ ON v2_.id = u3_.location_id AND (ST_CONTAINS(v2_.geo_shape, ST_GeomFromGeoJSON('{\"type\": \"Polygon\", \"coordinates\": [[[115.02344965816332, -8.371568498407115], [115.11075386781232, -8.466018633016247], [115.17924089653924, -8.557754925625119], [115.19273394968302, -8.579890661291437], [115.21055835334924, -8.590605360279781], [115.26930769679308, -8.596331381169989], [115.2913128302535, -8.581334596700316], [115.3104303966996, -8.56633810047937], [115.33723131976996, -8.53778766642742], [115.35478767488952, -8.402341810234958], [115.32026019573276, -8.323020307858343], [115.21236112962195, -8.305502250458062], [115.14783910911632, -8.303583483588412], [115.10912666243644, -8.315355064949514], [115.0726053833704, -8.331117215761466], [115.0527198171634, -8.346343246775199], [115.02344965816332, -8.371568498407115]]]}', 1, 4326)) > 0) WHERE v1_.picture IS NOT NULL AND v1_.roles LIKE '%ROLE_CONSULTANT%' AND v1_.enabled = 1 ORDER BY RAND() ASC LIMIT 1;
169.76 ms (6.82%)	1	SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, v0_.redirect_location_id AS redirect_location_id_23, v0_.destination_id AS destination_id_24 FROM v4_location v0_ INNER JOIN v4_location v1_ ON (v1_.id = ? AND ST_CONTAINS(v0_.geo_shape, v1_.geo_shape) > 0) WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) DESC LIMIT 1 Parameters: [`65`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, CAST( ST_AsGeoJSON(v0_.geo_shape) AS CHAR ) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, v0_.redirect_location_id AS redirect_location_id_23, v0_.destination_id AS destination_id_24 FROM v4_location v0_ INNER JOIN v4_location v1_ ON ( v1_.id = ? AND ST_CONTAINS(v0_.geo_shape, v1_.geo_shape) > 0 ) WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) DESC LIMIT 1 SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, v0_.redirect_location_id AS redirect_location_id_23, v0_.destination_id AS destination_id_24 FROM v4_location v0_ INNER JOIN v4_location v1_ ON (v1_.id = 65 AND ST_CONTAINS(v0_.geo_shape, v1_.geo_shape) > 0) WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) DESC LIMIT 1;
141.21 ms (5.67%)	1	SELECT v0_.id AS id_0, v0_.priority AS priority_1, v0_.id_str AS id_str_2, v0_.name AS name_3, v0_.indexed_at AS indexed_at_4, v0_.planning_updated_at AS planning_updated_at_5, v0_.is_active AS is_active_6, v0_.is_indexable AS is_indexable_7, v0_.is_daily_rated AS is_daily_rated_8, v0_.surface AS surface_9, v0_.surface_ext AS surface_ext_10, v0_.max_capacity_without_extra_guest AS max_capacity_without_extra_guest_11, v0_.max_capacity_with_extra_guest AS max_capacity_with_extra_guest_12, v0_.rooms_conf AS rooms_conf_13, v0_.address AS address_14, v0_.address2 AS address2_15, v0_.zip_code AS zip_code_16, v0_.rates_updated_at AS rates_updated_at_17, v0_.availability_updated_at AS availability_updated_at_18, v0_.staff_number AS staff_number_19, v0_.video AS video_20, v0_.floor_plan_link AS floor_plan_link_21, v0_.check_in_hour AS check_in_hour_22, v0_.check_out_hour AS check_out_hour_23, v0_.late_check_out_hour AS late_check_out_hour_24, v0_.late_check_out_rate AS late_check_out_rate_25, v0_.security_deposit_mod AS security_deposit_mod_26, v0_.security_deposit_var AS security_deposit_var_27, v0_.airport_pickup_mod AS airport_pickup_mod_28, v0_.airport_pickup_var AS airport_pickup_var_29, v0_.extra_bed_price AS extra_bed_price_30, v0_.extra_bed_pax AS extra_bed_pax_31, v0_.babycot_price AS babycot_price_32, v0_.lunch_mod AS lunch_mod_33, v0_.lunch_var AS lunch_var_34, v0_.dinner_mod AS dinner_mod_35, v0_.dinner_var AS dinner_var_36, v0_.breakfast_mod AS breakfast_mod_37, v0_.breakfast_var AS breakfast_var_38, v0_.sync_method AS sync_method_39, v0_.sync_reference AS sync_reference_40, v0_.emergency_phone AS emergency_phone_41, v0_.reference AS reference_42, v0_.hash AS hash_43, v0_.untrusted AS untrusted_44, v0_.owner_editable AS owner_editable_45, v0_.show_distribution AS show_distribution_46, v0_.property_type AS property_type_47, v0_.rates_valid_until AS rates_valid_until_48, v0_.rank_total AS rank_total_49, v0_.rank_review AS rank_review_50, v0_.rank_review_count AS rank_review_count_51, v0_.rank_minstay AS rank_minstay_52, v0_.rank_availability AS rank_availability_53, v0_.rank_conversion AS rank_conversion_54, v0_.rank_views AS rank_views_55, v0_.rank_owner AS rank_owner_56, v0_.rank_bebop_feature AS rank_bebop_feature_57, v0_.rank_bebop_picture AS rank_bebop_picture_58, v0_.rank_bebop_content AS rank_bebop_content_59, v0_.rank_bebop_place AS rank_bebop_place_60, v0_.number_views AS number_views_61, v0_.review_average AS review_average_62, v0_.review_number AS review_number_63, v0_.min_price AS min_price_64, v0_.min_price_usd AS min_price_usd_65, v0_.bedroom_number AS bedroom_number_66, v0_.bathroom_number AS bathroom_number_67, v0_.pool_number AS pool_number_68, v0_.premium AS premium_69, v0_.on_request AS on_request_70, v0_.exclusive AS exclusive_71, v0_.new AS new_72, v0_.vicinity_distance AS vicinity_distance_73, v0_.expected_commission AS expected_commission_74, v0_.commission_tax_included AS commission_tax_included_75, v0_.hide_location AS hide_location_76, v0_.license_number AS license_number_77, v0_.changeover_days AS changeover_days_78, v0_.strict_min_stay AS strict_min_stay_79, v0_.rental_agreement AS rental_agreement_80, v0_.activated_at AS activated_at_81, v0_.policy_deposit_percentage AS policy_deposit_percentage_82, v0_.policy_balance_days AS policy_balance_days_83, v0_.policy_cancellation_terms AS policy_cancellation_terms_84, v0_.sustainability_certified_url AS sustainability_certified_url_85, v0_.created_at AS created_at_86, v0_.updated_at AS updated_at_87, v0_.longitude AS longitude_88, v0_.latitude AS latitude_89, CAST(ST_AsGeoJSON(v0_.geo_point) AS CHAR) AS geo_point_90, v0_.api_auth AS api_auth_91, v0_.api_name AS api_name_92, v0_.api_push_auth AS api_push_auth_93, v0_.api_push_name AS api_push_name_94, v1_.id AS id_95, v1_.description AS description_96, v1_.inspection AS inspection_97, v1_.highlights AS highlights_98, v1_.intro AS intro_99, v1_.map AS map_100, v1_.short_description AS short_description_101, v1_.locale AS locale_102, v2_.id AS id_103, CAST(ST_AsGeoJSON(v2_.geo_shape) AS CHAR) AS geo_shape_104, v2_.name AS name_105, v2_.slug AS slug_106, v2_.image_url AS image_url_107, v2_.is_active AS is_active_108, v2_.is_area_landing_page AS is_area_landing_page_109, v2_.is_seo_active AS is_seo_active_110, v2_.hash AS hash_111, v2_.popularity AS popularity_112, v2_.homepage_position AS homepage_position_113, v2_.is_homepage_card AS is_homepage_card_114, v2_.homepage_card_image_url AS homepage_card_image_url_115, v2_.concierge_image_url AS concierge_image_url_116, v2_.property_type AS property_type_117, v2_.property_vicinity AS property_vicinity_118, v2_.alternate_names AS alternate_names_119, v2_.hint_start AS hint_start_120, v2_.hint_end AS hint_end_121, v2_.hint_message AS hint_message_122, v2_.number_of_dash AS number_of_dash_123, v2_.created_at AS created_at_124, v2_.updated_at AS updated_at_125, v3_.id AS id_126, v3_.rates AS rates_127, v3_.type AS type_128, v4_.id AS id_129, v4_.name AS name_130, v4_.code AS code_131, v4_.created_at AS created_at_132, v4_.updated_at AS updated_at_133, v4_.longitude AS longitude_134, v4_.latitude AS latitude_135, CAST(ST_AsGeoJSON(v4_.geo_point) AS CHAR) AS geo_point_136, v5_.id AS id_137, v5_.hard_files AS hard_files_138, v5_.nb_files AS nb_files_139, v5_.created_at AS created_at_140, v5_.updated_at AS updated_at_141, v6_.id AS id_142, v6_.hard_files AS hard_files_143, v6_.nb_files AS nb_files_144, v6_.created_at AS created_at_145, v6_.updated_at AS updated_at_146, v0_.master_website_id AS master_website_id_147, v0_.media_gallery_id AS media_gallery_id_148, v0_.gallery_slider_id AS gallery_slider_id_149, v0_.gallery_main_id AS gallery_main_id_150, v0_.gallery_thumb_id AS gallery_thumb_id_151, v0_.owner_id AS owner_id_152, v0_.manager_id AS manager_id_153, v0_.pmc_id AS pmc_id_154, v0_.airport_id AS airport_id_155, v0_.currency_id AS currency_id_156, v0_.tax_id AS tax_id_157, v0_.main_location_id AS main_location_id_158, v0_.country_id AS country_id_159, v0_.next_promotion_id AS next_promotion_id_160, v0_.tc_details_id AS tc_details_id_161, v0_.rates_id AS rates_id_162, v0_.distribution_id AS distribution_id_163, v0_.inspector_id AS inspector_id_164, v0_.estate_villa_id AS estate_villa_id_165, v1_.translatable_id AS translatable_id_166, v2_.redirect_location_id AS redirect_location_id_167, v2_.destination_id AS destination_id_168 FROM villa v0_ LEFT JOIN villa_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale = 'de') INNER JOIN v4_website_villa v8_ ON v0_.id = v8_.villa_id INNER JOIN v4_website v7_ ON v7_.id = v8_.website_id AND (v7_.id = '1') LEFT JOIN v4_location v2_ ON v0_.main_location_id = v2_.id LEFT JOIN villa_rate v3_ ON v0_.rates_id = v3_.id LEFT JOIN v4_airport v4_ ON v0_.airport_id = v4_.id LEFT JOIN villa_media_gallery v5_ ON v0_.media_gallery_id = v5_.id LEFT JOIN villa_media_gallery v6_ ON v0_.gallery_slider_id = v6_.id WHERE v0_.id_str = ? Parameters: [`"leona-valley-view-2br"`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.priority AS priority_1, v0_.id_str AS id_str_2, v0_.name AS name_3, v0_.indexed_at AS indexed_at_4, v0_.planning_updated_at AS planning_updated_at_5, v0_.is_active AS is_active_6, v0_.is_indexable AS is_indexable_7, v0_.is_daily_rated AS is_daily_rated_8, v0_.surface AS surface_9, v0_.surface_ext AS surface_ext_10, v0_.max_capacity_without_extra_guest AS max_capacity_without_extra_guest_11, v0_.max_capacity_with_extra_guest AS max_capacity_with_extra_guest_12, v0_.rooms_conf AS rooms_conf_13, v0_.address AS address_14, v0_.address2 AS address2_15, v0_.zip_code AS zip_code_16, v0_.rates_updated_at AS rates_updated_at_17, v0_.availability_updated_at AS availability_updated_at_18, v0_.staff_number AS staff_number_19, v0_.video AS video_20, v0_.floor_plan_link AS floor_plan_link_21, v0_.check_in_hour AS check_in_hour_22, v0_.check_out_hour AS check_out_hour_23, v0_.late_check_out_hour AS late_check_out_hour_24, v0_.late_check_out_rate AS late_check_out_rate_25, v0_.security_deposit_mod AS security_deposit_mod_26, v0_.security_deposit_var AS security_deposit_var_27, v0_.airport_pickup_mod AS airport_pickup_mod_28, v0_.airport_pickup_var AS airport_pickup_var_29, v0_.extra_bed_price AS extra_bed_price_30, v0_.extra_bed_pax AS extra_bed_pax_31, v0_.babycot_price AS babycot_price_32, v0_.lunch_mod AS lunch_mod_33, v0_.lunch_var AS lunch_var_34, v0_.dinner_mod AS dinner_mod_35, v0_.dinner_var AS dinner_var_36, v0_.breakfast_mod AS breakfast_mod_37, v0_.breakfast_var AS breakfast_var_38, v0_.sync_method AS sync_method_39, v0_.sync_reference AS sync_reference_40, v0_.emergency_phone AS emergency_phone_41, v0_.reference AS reference_42, v0_.hash AS hash_43, v0_.untrusted AS untrusted_44, v0_.owner_editable AS owner_editable_45, v0_.show_distribution AS show_distribution_46, v0_.property_type AS property_type_47, v0_.rates_valid_until AS rates_valid_until_48, v0_.rank_total AS rank_total_49, v0_.rank_review AS rank_review_50, v0_.rank_review_count AS rank_review_count_51, v0_.rank_minstay AS rank_minstay_52, v0_.rank_availability AS rank_availability_53, v0_.rank_conversion AS rank_conversion_54, v0_.rank_views AS rank_views_55, v0_.rank_owner AS rank_owner_56, v0_.rank_bebop_feature AS rank_bebop_feature_57, v0_.rank_bebop_picture AS rank_bebop_picture_58, v0_.rank_bebop_content AS rank_bebop_content_59, v0_.rank_bebop_place AS rank_bebop_place_60, v0_.number_views AS number_views_61, v0_.review_average AS review_average_62, v0_.review_number AS review_number_63, v0_.min_price AS min_price_64, v0_.min_price_usd AS min_price_usd_65, v0_.bedroom_number AS bedroom_number_66, v0_.bathroom_number AS bathroom_number_67, v0_.pool_number AS pool_number_68, v0_.premium AS premium_69, v0_.on_request AS on_request_70, v0_.exclusive AS exclusive_71, v0_.new AS new_72, v0_.vicinity_distance AS vicinity_distance_73, v0_.expected_commission AS expected_commission_74, v0_.commission_tax_included AS commission_tax_included_75, v0_.hide_location AS hide_location_76, v0_.license_number AS license_number_77, v0_.changeover_days AS changeover_days_78, v0_.strict_min_stay AS strict_min_stay_79, v0_.rental_agreement AS rental_agreement_80, v0_.activated_at AS activated_at_81, v0_.policy_deposit_percentage AS policy_deposit_percentage_82, v0_.policy_balance_days AS policy_balance_days_83, v0_.policy_cancellation_terms AS policy_cancellation_terms_84, v0_.sustainability_certified_url AS sustainability_certified_url_85, v0_.created_at AS created_at_86, v0_.updated_at AS updated_at_87, v0_.longitude AS longitude_88, v0_.latitude AS latitude_89, CAST( ST_AsGeoJSON(v0_.geo_point) AS CHAR ) AS geo_point_90, v0_.api_auth AS api_auth_91, v0_.api_name AS api_name_92, v0_.api_push_auth AS api_push_auth_93, v0_.api_push_name AS api_push_name_94, v1_.id AS id_95, v1_.description AS description_96, v1_.inspection AS inspection_97, v1_.highlights AS highlights_98, v1_.intro AS intro_99, v1_.map AS map_100, v1_.short_description AS short_description_101, v1_.locale AS locale_102, v2_.id AS id_103, CAST( ST_AsGeoJSON(v2_.geo_shape) AS CHAR ) AS geo_shape_104, v2_.name AS name_105, v2_.slug AS slug_106, v2_.image_url AS image_url_107, v2_.is_active AS is_active_108, v2_.is_area_landing_page AS is_area_landing_page_109, v2_.is_seo_active AS is_seo_active_110, v2_.hash AS hash_111, v2_.popularity AS popularity_112, v2_.homepage_position AS homepage_position_113, v2_.is_homepage_card AS is_homepage_card_114, v2_.homepage_card_image_url AS homepage_card_image_url_115, v2_.concierge_image_url AS concierge_image_url_116, v2_.property_type AS property_type_117, v2_.property_vicinity AS property_vicinity_118, v2_.alternate_names AS alternate_names_119, v2_.hint_start AS hint_start_120, v2_.hint_end AS hint_end_121, v2_.hint_message AS hint_message_122, v2_.number_of_dash AS number_of_dash_123, v2_.created_at AS created_at_124, v2_.updated_at AS updated_at_125, v3_.id AS id_126, v3_.rates AS rates_127, v3_.type AS type_128, v4_.id AS id_129, v4_.name AS name_130, v4_.code AS code_131, v4_.created_at AS created_at_132, v4_.updated_at AS updated_at_133, v4_.longitude AS longitude_134, v4_.latitude AS latitude_135, CAST( ST_AsGeoJSON(v4_.geo_point) AS CHAR ) AS geo_point_136, v5_.id AS id_137, v5_.hard_files AS hard_files_138, v5_.nb_files AS nb_files_139, v5_.created_at AS created_at_140, v5_.updated_at AS updated_at_141, v6_.id AS id_142, v6_.hard_files AS hard_files_143, v6_.nb_files AS nb_files_144, v6_.created_at AS created_at_145, v6_.updated_at AS updated_at_146, v0_.master_website_id AS master_website_id_147, v0_.media_gallery_id AS media_gallery_id_148, v0_.gallery_slider_id AS gallery_slider_id_149, v0_.gallery_main_id AS gallery_main_id_150, v0_.gallery_thumb_id AS gallery_thumb_id_151, v0_.owner_id AS owner_id_152, v0_.manager_id AS manager_id_153, v0_.pmc_id AS pmc_id_154, v0_.airport_id AS airport_id_155, v0_.currency_id AS currency_id_156, v0_.tax_id AS tax_id_157, v0_.main_location_id AS main_location_id_158, v0_.country_id AS country_id_159, v0_.next_promotion_id AS next_promotion_id_160, v0_.tc_details_id AS tc_details_id_161, v0_.rates_id AS rates_id_162, v0_.distribution_id AS distribution_id_163, v0_.inspector_id AS inspector_id_164, v0_.estate_villa_id AS estate_villa_id_165, v1_.translatable_id AS translatable_id_166, v2_.redirect_location_id AS redirect_location_id_167, v2_.destination_id AS destination_id_168 FROM villa v0_ LEFT JOIN villa_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale = 'de') INNER JOIN v4_website_villa v8_ ON v0_.id = v8_.villa_id INNER JOIN v4_website v7_ ON v7_.id = v8_.website_id AND (v7_.id = '1') LEFT JOIN v4_location v2_ ON v0_.main_location_id = v2_.id LEFT JOIN villa_rate v3_ ON v0_.rates_id = v3_.id LEFT JOIN v4_airport v4_ ON v0_.airport_id = v4_.id LEFT JOIN villa_media_gallery v5_ ON v0_.media_gallery_id = v5_.id LEFT JOIN villa_media_gallery v6_ ON v0_.gallery_slider_id = v6_.id WHERE v0_.id_str = ? SELECT v0_.id AS id_0, v0_.priority AS priority_1, v0_.id_str AS id_str_2, v0_.name AS name_3, v0_.indexed_at AS indexed_at_4, v0_.planning_updated_at AS planning_updated_at_5, v0_.is_active AS is_active_6, v0_.is_indexable AS is_indexable_7, v0_.is_daily_rated AS is_daily_rated_8, v0_.surface AS surface_9, v0_.surface_ext AS surface_ext_10, v0_.max_capacity_without_extra_guest AS max_capacity_without_extra_guest_11, v0_.max_capacity_with_extra_guest AS max_capacity_with_extra_guest_12, v0_.rooms_conf AS rooms_conf_13, v0_.address AS address_14, v0_.address2 AS address2_15, v0_.zip_code AS zip_code_16, v0_.rates_updated_at AS rates_updated_at_17, v0_.availability_updated_at AS availability_updated_at_18, v0_.staff_number AS staff_number_19, v0_.video AS video_20, v0_.floor_plan_link AS floor_plan_link_21, v0_.check_in_hour AS check_in_hour_22, v0_.check_out_hour AS check_out_hour_23, v0_.late_check_out_hour AS late_check_out_hour_24, v0_.late_check_out_rate AS late_check_out_rate_25, v0_.security_deposit_mod AS security_deposit_mod_26, v0_.security_deposit_var AS security_deposit_var_27, v0_.airport_pickup_mod AS airport_pickup_mod_28, v0_.airport_pickup_var AS airport_pickup_var_29, v0_.extra_bed_price AS extra_bed_price_30, v0_.extra_bed_pax AS extra_bed_pax_31, v0_.babycot_price AS babycot_price_32, v0_.lunch_mod AS lunch_mod_33, v0_.lunch_var AS lunch_var_34, v0_.dinner_mod AS dinner_mod_35, v0_.dinner_var AS dinner_var_36, v0_.breakfast_mod AS breakfast_mod_37, v0_.breakfast_var AS breakfast_var_38, v0_.sync_method AS sync_method_39, v0_.sync_reference AS sync_reference_40, v0_.emergency_phone AS emergency_phone_41, v0_.reference AS reference_42, v0_.hash AS hash_43, v0_.untrusted AS untrusted_44, v0_.owner_editable AS owner_editable_45, v0_.show_distribution AS show_distribution_46, v0_.property_type AS property_type_47, v0_.rates_valid_until AS rates_valid_until_48, v0_.rank_total AS rank_total_49, v0_.rank_review AS rank_review_50, v0_.rank_review_count AS rank_review_count_51, v0_.rank_minstay AS rank_minstay_52, v0_.rank_availability AS rank_availability_53, v0_.rank_conversion AS rank_conversion_54, v0_.rank_views AS rank_views_55, v0_.rank_owner AS rank_owner_56, v0_.rank_bebop_feature AS rank_bebop_feature_57, v0_.rank_bebop_picture AS rank_bebop_picture_58, v0_.rank_bebop_content AS rank_bebop_content_59, v0_.rank_bebop_place AS rank_bebop_place_60, v0_.number_views AS number_views_61, v0_.review_average AS review_average_62, v0_.review_number AS review_number_63, v0_.min_price AS min_price_64, v0_.min_price_usd AS min_price_usd_65, v0_.bedroom_number AS bedroom_number_66, v0_.bathroom_number AS bathroom_number_67, v0_.pool_number AS pool_number_68, v0_.premium AS premium_69, v0_.on_request AS on_request_70, v0_.exclusive AS exclusive_71, v0_.new AS new_72, v0_.vicinity_distance AS vicinity_distance_73, v0_.expected_commission AS expected_commission_74, v0_.commission_tax_included AS commission_tax_included_75, v0_.hide_location AS hide_location_76, v0_.license_number AS license_number_77, v0_.changeover_days AS changeover_days_78, v0_.strict_min_stay AS strict_min_stay_79, v0_.rental_agreement AS rental_agreement_80, v0_.activated_at AS activated_at_81, v0_.policy_deposit_percentage AS policy_deposit_percentage_82, v0_.policy_balance_days AS policy_balance_days_83, v0_.policy_cancellation_terms AS policy_cancellation_terms_84, v0_.sustainability_certified_url AS sustainability_certified_url_85, v0_.created_at AS created_at_86, v0_.updated_at AS updated_at_87, v0_.longitude AS longitude_88, v0_.latitude AS latitude_89, CAST(ST_AsGeoJSON(v0_.geo_point) AS CHAR) AS geo_point_90, v0_.api_auth AS api_auth_91, v0_.api_name AS api_name_92, v0_.api_push_auth AS api_push_auth_93, v0_.api_push_name AS api_push_name_94, v1_.id AS id_95, v1_.description AS description_96, v1_.inspection AS inspection_97, v1_.highlights AS highlights_98, v1_.intro AS intro_99, v1_.map AS map_100, v1_.short_description AS short_description_101, v1_.locale AS locale_102, v2_.id AS id_103, CAST(ST_AsGeoJSON(v2_.geo_shape) AS CHAR) AS geo_shape_104, v2_.name AS name_105, v2_.slug AS slug_106, v2_.image_url AS image_url_107, v2_.is_active AS is_active_108, v2_.is_area_landing_page AS is_area_landing_page_109, v2_.is_seo_active AS is_seo_active_110, v2_.hash AS hash_111, v2_.popularity AS popularity_112, v2_.homepage_position AS homepage_position_113, v2_.is_homepage_card AS is_homepage_card_114, v2_.homepage_card_image_url AS homepage_card_image_url_115, v2_.concierge_image_url AS concierge_image_url_116, v2_.property_type AS property_type_117, v2_.property_vicinity AS property_vicinity_118, v2_.alternate_names AS alternate_names_119, v2_.hint_start AS hint_start_120, v2_.hint_end AS hint_end_121, v2_.hint_message AS hint_message_122, v2_.number_of_dash AS number_of_dash_123, v2_.created_at AS created_at_124, v2_.updated_at AS updated_at_125, v3_.id AS id_126, v3_.rates AS rates_127, v3_.type AS type_128, v4_.id AS id_129, v4_.name AS name_130, v4_.code AS code_131, v4_.created_at AS created_at_132, v4_.updated_at AS updated_at_133, v4_.longitude AS longitude_134, v4_.latitude AS latitude_135, CAST(ST_AsGeoJSON(v4_.geo_point) AS CHAR) AS geo_point_136, v5_.id AS id_137, v5_.hard_files AS hard_files_138, v5_.nb_files AS nb_files_139, v5_.created_at AS created_at_140, v5_.updated_at AS updated_at_141, v6_.id AS id_142, v6_.hard_files AS hard_files_143, v6_.nb_files AS nb_files_144, v6_.created_at AS created_at_145, v6_.updated_at AS updated_at_146, v0_.master_website_id AS master_website_id_147, v0_.media_gallery_id AS media_gallery_id_148, v0_.gallery_slider_id AS gallery_slider_id_149, v0_.gallery_main_id AS gallery_main_id_150, v0_.gallery_thumb_id AS gallery_thumb_id_151, v0_.owner_id AS owner_id_152, v0_.manager_id AS manager_id_153, v0_.pmc_id AS pmc_id_154, v0_.airport_id AS airport_id_155, v0_.currency_id AS currency_id_156, v0_.tax_id AS tax_id_157, v0_.main_location_id AS main_location_id_158, v0_.country_id AS country_id_159, v0_.next_promotion_id AS next_promotion_id_160, v0_.tc_details_id AS tc_details_id_161, v0_.rates_id AS rates_id_162, v0_.distribution_id AS distribution_id_163, v0_.inspector_id AS inspector_id_164, v0_.estate_villa_id AS estate_villa_id_165, v1_.translatable_id AS translatable_id_166, v2_.redirect_location_id AS redirect_location_id_167, v2_.destination_id AS destination_id_168 FROM villa v0_ LEFT JOIN villa_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale = 'de') INNER JOIN v4_website_villa v8_ ON v0_.id = v8_.villa_id INNER JOIN v4_website v7_ ON v7_.id = v8_.website_id AND (v7_.id = '1') LEFT JOIN v4_location v2_ ON v0_.main_location_id = v2_.id LEFT JOIN villa_rate v3_ ON v0_.rates_id = v3_.id LEFT JOIN v4_airport v4_ ON v0_.airport_id = v4_.id LEFT JOIN villa_media_gallery v5_ ON v0_.media_gallery_id = v5_.id LEFT JOIN villa_media_gallery v6_ ON v0_.gallery_slider_id = v6_.id WHERE v0_.id_str = 'leona-valley-view-2br';
60.74 ms (2.44%)	1	SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.og_region AS og_region_4, t0.label_header AS label_header_5, t0.localized_label AS localized_label_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.currency_id AS currency_id_9, t0.country_id AS country_id_10, t0.root_locale_id AS root_locale_id_11 FROM v4_locale t0 INNER JOIN v4_website_locale ON t0.id = v4_website_locale.locale_id WHERE v4_website_locale.website_id = ? ORDER BY t0.code ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.og_region AS og_region_4, t0.label_header AS label_header_5, t0.localized_label AS localized_label_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.currency_id AS currency_id_9, t0.country_id AS country_id_10, t0.root_locale_id AS root_locale_id_11 FROM v4_locale t0 INNER JOIN v4_website_locale ON t0.id = v4_website_locale.locale_id WHERE v4_website_locale.website_id = ? ORDER BY t0.code ASC SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.og_region AS og_region_4, t0.label_header AS label_header_5, t0.localized_label AS localized_label_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.currency_id AS currency_id_9, t0.country_id AS country_id_10, t0.root_locale_id AS root_locale_id_11 FROM v4_locale t0 INNER JOIN v4_website_locale ON t0.id = v4_website_locale.locale_id WHERE v4_website_locale.website_id = 1 ORDER BY t0.code ASC;
58.13 ms (2.34%)	1	SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.host AS host_2, v0_.meta AS meta_3, v0_.email AS email_4, v0_.initials AS initials_5, v0_.country AS country_6, v0_.cdn_asset AS cdn_asset_7, v0_.active AS active_8, v0_.master AS master_9, v0_.prefix_translation AS prefix_translation_10, v0_.galaxite AS galaxite_11, v0_.location_id AS location_id_12, v0_.currency_id AS currency_id_13 FROM v4_website v0_ WHERE v0_.galaxite = 0 AND v0_.name = ? Parameters: [`"vf"`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.host AS host_2, v0_.meta AS meta_3, v0_.email AS email_4, v0_.initials AS initials_5, v0_.country AS country_6, v0_.cdn_asset AS cdn_asset_7, v0_.active AS active_8, v0_.master AS master_9, v0_.prefix_translation AS prefix_translation_10, v0_.galaxite AS galaxite_11, v0_.location_id AS location_id_12, v0_.currency_id AS currency_id_13 FROM v4_website v0_ WHERE v0_.galaxite = 0 AND v0_.name = ? SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.host AS host_2, v0_.meta AS meta_3, v0_.email AS email_4, v0_.initials AS initials_5, v0_.country AS country_6, v0_.cdn_asset AS cdn_asset_7, v0_.active AS active_8, v0_.master AS master_9, v0_.prefix_translation AS prefix_translation_10, v0_.galaxite AS galaxite_11, v0_.location_id AS location_id_12, v0_.currency_id AS currency_id_13 FROM v4_website v0_ WHERE v0_.galaxite = 0 AND v0_.name = 'vf';
6.39 ms (0.26%)	1	SELECT ST_DISTANCE(ST_GeomFromGeoJSON(?, 1, 4326), v0_.geo_point) AS sclr_0, v0_.id AS id_1, v0_.priority AS priority_2, v0_.id_str AS id_str_3, v0_.name AS name_4, v0_.indexed_at AS indexed_at_5, v0_.planning_updated_at AS planning_updated_at_6, v0_.is_active AS is_active_7, v0_.is_indexable AS is_indexable_8, v0_.is_daily_rated AS is_daily_rated_9, v0_.surface AS surface_10, v0_.surface_ext AS surface_ext_11, v0_.max_capacity_without_extra_guest AS max_capacity_without_extra_guest_12, v0_.max_capacity_with_extra_guest AS max_capacity_with_extra_guest_13, v0_.rooms_conf AS rooms_conf_14, v0_.address AS address_15, v0_.address2 AS address2_16, v0_.zip_code AS zip_code_17, v0_.rates_updated_at AS rates_updated_at_18, v0_.availability_updated_at AS availability_updated_at_19, v0_.staff_number AS staff_number_20, v0_.video AS video_21, v0_.floor_plan_link AS floor_plan_link_22, v0_.check_in_hour AS check_in_hour_23, v0_.check_out_hour AS check_out_hour_24, v0_.late_check_out_hour AS late_check_out_hour_25, v0_.late_check_out_rate AS late_check_out_rate_26, v0_.security_deposit_mod AS security_deposit_mod_27, v0_.security_deposit_var AS security_deposit_var_28, v0_.airport_pickup_mod AS airport_pickup_mod_29, v0_.airport_pickup_var AS airport_pickup_var_30, v0_.extra_bed_price AS extra_bed_price_31, v0_.extra_bed_pax AS extra_bed_pax_32, v0_.babycot_price AS babycot_price_33, v0_.lunch_mod AS lunch_mod_34, v0_.lunch_var AS lunch_var_35, v0_.dinner_mod AS dinner_mod_36, v0_.dinner_var AS dinner_var_37, v0_.breakfast_mod AS breakfast_mod_38, v0_.breakfast_var AS breakfast_var_39, v0_.sync_method AS sync_method_40, v0_.sync_reference AS sync_reference_41, v0_.emergency_phone AS emergency_phone_42, v0_.reference AS reference_43, v0_.hash AS hash_44, v0_.untrusted AS untrusted_45, v0_.owner_editable AS owner_editable_46, v0_.show_distribution AS show_distribution_47, v0_.property_type AS property_type_48, v0_.rates_valid_until AS rates_valid_until_49, v0_.rank_total AS rank_total_50, v0_.rank_review AS rank_review_51, v0_.rank_review_count AS rank_review_count_52, v0_.rank_minstay AS rank_minstay_53, v0_.rank_availability AS rank_availability_54, v0_.rank_conversion AS rank_conversion_55, v0_.rank_views AS rank_views_56, v0_.rank_owner AS rank_owner_57, v0_.rank_bebop_feature AS rank_bebop_feature_58, v0_.rank_bebop_picture AS rank_bebop_picture_59, v0_.rank_bebop_content AS rank_bebop_content_60, v0_.rank_bebop_place AS rank_bebop_place_61, v0_.number_views AS number_views_62, v0_.review_average AS review_average_63, v0_.review_number AS review_number_64, v0_.min_price AS min_price_65, v0_.min_price_usd AS min_price_usd_66, v0_.bedroom_number AS bedroom_number_67, v0_.bathroom_number AS bathroom_number_68, v0_.pool_number AS pool_number_69, v0_.premium AS premium_70, v0_.on_request AS on_request_71, v0_.exclusive AS exclusive_72, v0_.new AS new_73, v0_.vicinity_distance AS vicinity_distance_74, v0_.expected_commission AS expected_commission_75, v0_.commission_tax_included AS commission_tax_included_76, v0_.hide_location AS hide_location_77, v0_.license_number AS license_number_78, v0_.changeover_days AS changeover_days_79, v0_.strict_min_stay AS strict_min_stay_80, v0_.rental_agreement AS rental_agreement_81, v0_.activated_at AS activated_at_82, v0_.policy_deposit_percentage AS policy_deposit_percentage_83, v0_.policy_balance_days AS policy_balance_days_84, v0_.policy_cancellation_terms AS policy_cancellation_terms_85, v0_.sustainability_certified_url AS sustainability_certified_url_86, v0_.created_at AS created_at_87, v0_.updated_at AS updated_at_88, v0_.longitude AS longitude_89, v0_.latitude AS latitude_90, CAST(ST_AsGeoJSON(v0_.geo_point) AS CHAR) AS geo_point_91, v0_.api_auth AS api_auth_92, v0_.api_name AS api_name_93, v0_.api_push_auth AS api_push_auth_94, v0_.api_push_name AS api_push_name_95, v1_.id AS id_96, CAST(ST_AsGeoJSON(v1_.geo_shape) AS CHAR) AS geo_shape_97, v1_.name AS name_98, v1_.slug AS slug_99, v1_.image_url AS image_url_100, v1_.is_active AS is_active_101, v1_.is_area_landing_page AS is_area_landing_page_102, v1_.is_seo_active AS is_seo_active_103, v1_.hash AS hash_104, v1_.popularity AS popularity_105, v1_.homepage_position AS homepage_position_106, v1_.is_homepage_card AS is_homepage_card_107, v1_.homepage_card_image_url AS homepage_card_image_url_108, v1_.concierge_image_url AS concierge_image_url_109, v1_.property_type AS property_type_110, v1_.property_vicinity AS property_vicinity_111, v1_.alternate_names AS alternate_names_112, v1_.hint_start AS hint_start_113, v1_.hint_end AS hint_end_114, v1_.hint_message AS hint_message_115, v1_.number_of_dash AS number_of_dash_116, v1_.created_at AS created_at_117, v1_.updated_at AS updated_at_118, f2_.code AS code_119, f2_.name AS name_120, f2_.description AS description_121, f2_.priority AS priority_122, f2_.exclusive AS exclusive_123, f2_.usage_limit AS usage_limit_124, f2_.used AS used_125, f2_.coupon_based AS coupon_based_126, f2_.starts_at AS starts_at_127, f2_.ends_at AS ends_at_128, f2_.applies_to_discounted AS applies_to_discounted_129, f2_.archived_at AS archived_at_130, f2_.created_at AS created_at_131, f2_.updated_at AS updated_at_132, f2_.id AS id_133, f2_.begins AS begins_134, f2_.ends AS ends_135, f2_.discount AS discount_136, f2_.days_before AS days_before_137, v3_.id AS id_138, v3_.hard_files AS hard_files_139, v3_.nb_files AS nb_files_140, v3_.created_at AS created_at_141, v3_.updated_at AS updated_at_142, v0_.master_website_id AS master_website_id_143, v0_.media_gallery_id AS media_gallery_id_144, v0_.gallery_slider_id AS gallery_slider_id_145, v0_.gallery_main_id AS gallery_main_id_146, v0_.gallery_thumb_id AS gallery_thumb_id_147, v0_.owner_id AS owner_id_148, v0_.manager_id AS manager_id_149, v0_.pmc_id AS pmc_id_150, v0_.airport_id AS airport_id_151, v0_.currency_id AS currency_id_152, v0_.tax_id AS tax_id_153, v0_.main_location_id AS main_location_id_154, v0_.country_id AS country_id_155, v0_.next_promotion_id AS next_promotion_id_156, v0_.tc_details_id AS tc_details_id_157, v0_.rates_id AS rates_id_158, v0_.distribution_id AS distribution_id_159, v0_.inspector_id AS inspector_id_160, v0_.estate_villa_id AS estate_villa_id_161, v1_.redirect_location_id AS redirect_location_id_162, v1_.destination_id AS destination_id_163, f2_.villa_id AS villa_id_164 FROM villa v0_ INNER JOIN v4_website_villa v5_ ON v0_.id = v5_.villa_id INNER JOIN v4_website v4_ ON v4_.id = v5_.website_id AND (v4_.id = '1') LEFT JOIN v4_location v1_ ON v0_.main_location_id = v1_.id LEFT JOIN fox_promotion f2_ ON v0_.next_promotion_id = f2_.id LEFT JOIN villa_media_gallery v3_ ON v0_.gallery_main_id = v3_.id WHERE v0_.is_active = 1 AND v0_.is_indexable = 1 AND (v0_.latitude BETWEEN ? AND ?) AND (v0_.longitude BETWEEN ? AND ?) AND v0_.id <> ? ORDER BY sclr_0 ASC LIMIT 3 Parameters: [`"{"type": "Point", "coordinates": [115.28389, -8.48565]}" -8.5757400900901 -8.3955599099099 115.19379990991 115.37398009009 11002`] View formatted query View runnable query Explain query SELECT ST_DISTANCE( ST_GeomFromGeoJSON(?, 1, 4326), v0_.geo_point ) AS sclr_0, v0_.id AS id_1, v0_.priority AS priority_2, v0_.id_str AS id_str_3, v0_.name AS name_4, v0_.indexed_at AS indexed_at_5, v0_.planning_updated_at AS planning_updated_at_6, v0_.is_active AS is_active_7, v0_.is_indexable AS is_indexable_8, v0_.is_daily_rated AS is_daily_rated_9, v0_.surface AS surface_10, v0_.surface_ext AS surface_ext_11, v0_.max_capacity_without_extra_guest AS max_capacity_without_extra_guest_12, v0_.max_capacity_with_extra_guest AS max_capacity_with_extra_guest_13, v0_.rooms_conf AS rooms_conf_14, v0_.address AS address_15, v0_.address2 AS address2_16, v0_.zip_code AS zip_code_17, v0_.rates_updated_at AS rates_updated_at_18, v0_.availability_updated_at AS availability_updated_at_19, v0_.staff_number AS staff_number_20, v0_.video AS video_21, v0_.floor_plan_link AS floor_plan_link_22, v0_.check_in_hour AS check_in_hour_23, v0_.check_out_hour AS check_out_hour_24, v0_.late_check_out_hour AS late_check_out_hour_25, v0_.late_check_out_rate AS late_check_out_rate_26, v0_.security_deposit_mod AS security_deposit_mod_27, v0_.security_deposit_var AS security_deposit_var_28, v0_.airport_pickup_mod AS airport_pickup_mod_29, v0_.airport_pickup_var AS airport_pickup_var_30, v0_.extra_bed_price AS extra_bed_price_31, v0_.extra_bed_pax AS extra_bed_pax_32, v0_.babycot_price AS babycot_price_33, v0_.lunch_mod AS lunch_mod_34, v0_.lunch_var AS lunch_var_35, v0_.dinner_mod AS dinner_mod_36, v0_.dinner_var AS dinner_var_37, v0_.breakfast_mod AS breakfast_mod_38, v0_.breakfast_var AS breakfast_var_39, v0_.sync_method AS sync_method_40, v0_.sync_reference AS sync_reference_41, v0_.emergency_phone AS emergency_phone_42, v0_.reference AS reference_43, v0_.hash AS hash_44, v0_.untrusted AS untrusted_45, v0_.owner_editable AS owner_editable_46, v0_.show_distribution AS show_distribution_47, v0_.property_type AS property_type_48, v0_.rates_valid_until AS rates_valid_until_49, v0_.rank_total AS rank_total_50, v0_.rank_review AS rank_review_51, v0_.rank_review_count AS rank_review_count_52, v0_.rank_minstay AS rank_minstay_53, v0_.rank_availability AS rank_availability_54, v0_.rank_conversion AS rank_conversion_55, v0_.rank_views AS rank_views_56, v0_.rank_owner AS rank_owner_57, v0_.rank_bebop_feature AS rank_bebop_feature_58, v0_.rank_bebop_picture AS rank_bebop_picture_59, v0_.rank_bebop_content AS rank_bebop_content_60, v0_.rank_bebop_place AS rank_bebop_place_61, v0_.number_views AS number_views_62, v0_.review_average AS review_average_63, v0_.review_number AS review_number_64, v0_.min_price AS min_price_65, v0_.min_price_usd AS min_price_usd_66, v0_.bedroom_number AS bedroom_number_67, v0_.bathroom_number AS bathroom_number_68, v0_.pool_number AS pool_number_69, v0_.premium AS premium_70, v0_.on_request AS on_request_71, v0_.exclusive AS exclusive_72, v0_.new AS new_73, v0_.vicinity_distance AS vicinity_distance_74, v0_.expected_commission AS expected_commission_75, v0_.commission_tax_included AS commission_tax_included_76, v0_.hide_location AS hide_location_77, v0_.license_number AS license_number_78, v0_.changeover_days AS changeover_days_79, v0_.strict_min_stay AS strict_min_stay_80, v0_.rental_agreement AS rental_agreement_81, v0_.activated_at AS activated_at_82, v0_.policy_deposit_percentage AS policy_deposit_percentage_83, v0_.policy_balance_days AS policy_balance_days_84, v0_.policy_cancellation_terms AS policy_cancellation_terms_85, v0_.sustainability_certified_url AS sustainability_certified_url_86, v0_.created_at AS created_at_87, v0_.updated_at AS updated_at_88, v0_.longitude AS longitude_89, v0_.latitude AS latitude_90, CAST( ST_AsGeoJSON(v0_.geo_point) AS CHAR ) AS geo_point_91, v0_.api_auth AS api_auth_92, v0_.api_name AS api_name_93, v0_.api_push_auth AS api_push_auth_94, v0_.api_push_name AS api_push_name_95, v1_.id AS id_96, CAST( ST_AsGeoJSON(v1_.geo_shape) AS CHAR ) AS geo_shape_97, v1_.name AS name_98, v1_.slug AS slug_99, v1_.image_url AS image_url_100, v1_.is_active AS is_active_101, v1_.is_area_landing_page AS is_area_landing_page_102, v1_.is_seo_active AS is_seo_active_103, v1_.hash AS hash_104, v1_.popularity AS popularity_105, v1_.homepage_position AS homepage_position_106, v1_.is_homepage_card AS is_homepage_card_107, v1_.homepage_card_image_url AS homepage_card_image_url_108, v1_.concierge_image_url AS concierge_image_url_109, v1_.property_type AS property_type_110, v1_.property_vicinity AS property_vicinity_111, v1_.alternate_names AS alternate_names_112, v1_.hint_start AS hint_start_113, v1_.hint_end AS hint_end_114, v1_.hint_message AS hint_message_115, v1_.number_of_dash AS number_of_dash_116, v1_.created_at AS created_at_117, v1_.updated_at AS updated_at_118, f2_.code AS code_119, f2_.name AS name_120, f2_.description AS description_121, f2_.priority AS priority_122, f2_.exclusive AS exclusive_123, f2_.usage_limit AS usage_limit_124, f2_.used AS used_125, f2_.coupon_based AS coupon_based_126, f2_.starts_at AS starts_at_127, f2_.ends_at AS ends_at_128, f2_.applies_to_discounted AS applies_to_discounted_129, f2_.archived_at AS archived_at_130, f2_.created_at AS created_at_131, f2_.updated_at AS updated_at_132, f2_.id AS id_133, f2_.begins AS begins_134, f2_.ends AS ends_135, f2_.discount AS discount_136, f2_.days_before AS days_before_137, v3_.id AS id_138, v3_.hard_files AS hard_files_139, v3_.nb_files AS nb_files_140, v3_.created_at AS created_at_141, v3_.updated_at AS updated_at_142, v0_.master_website_id AS master_website_id_143, v0_.media_gallery_id AS media_gallery_id_144, v0_.gallery_slider_id AS gallery_slider_id_145, v0_.gallery_main_id AS gallery_main_id_146, v0_.gallery_thumb_id AS gallery_thumb_id_147, v0_.owner_id AS owner_id_148, v0_.manager_id AS manager_id_149, v0_.pmc_id AS pmc_id_150, v0_.airport_id AS airport_id_151, v0_.currency_id AS currency_id_152, v0_.tax_id AS tax_id_153, v0_.main_location_id AS main_location_id_154, v0_.country_id AS country_id_155, v0_.next_promotion_id AS next_promotion_id_156, v0_.tc_details_id AS tc_details_id_157, v0_.rates_id AS rates_id_158, v0_.distribution_id AS distribution_id_159, v0_.inspector_id AS inspector_id_160, v0_.estate_villa_id AS estate_villa_id_161, v1_.redirect_location_id AS redirect_location_id_162, v1_.destination_id AS destination_id_163, f2_.villa_id AS villa_id_164 FROM villa v0_ INNER JOIN v4_website_villa v5_ ON v0_.id = v5_.villa_id INNER JOIN v4_website v4_ ON v4_.id = v5_.website_id AND (v4_.id = '1') LEFT JOIN v4_location v1_ ON v0_.main_location_id = v1_.id LEFT JOIN fox_promotion f2_ ON v0_.next_promotion_id = f2_.id LEFT JOIN villa_media_gallery v3_ ON v0_.gallery_main_id = v3_.id WHERE v0_.is_active = 1 AND v0_.is_indexable = 1 AND ( v0_.latitude BETWEEN ? AND ? ) AND ( v0_.longitude BETWEEN ? AND ? ) AND v0_.id <> ? ORDER BY sclr_0 ASC LIMIT 3 SELECT ST_DISTANCE(ST_GeomFromGeoJSON('{\"type\": \"Point\", \"coordinates\": [115.28389, -8.48565]}', 1, 4326), v0_.geo_point) AS sclr_0, v0_.id AS id_1, v0_.priority AS priority_2, v0_.id_str AS id_str_3, v0_.name AS name_4, v0_.indexed_at AS indexed_at_5, v0_.planning_updated_at AS planning_updated_at_6, v0_.is_active AS is_active_7, v0_.is_indexable AS is_indexable_8, v0_.is_daily_rated AS is_daily_rated_9, v0_.surface AS surface_10, v0_.surface_ext AS surface_ext_11, v0_.max_capacity_without_extra_guest AS max_capacity_without_extra_guest_12, v0_.max_capacity_with_extra_guest AS max_capacity_with_extra_guest_13, v0_.rooms_conf AS rooms_conf_14, v0_.address AS address_15, v0_.address2 AS address2_16, v0_.zip_code AS zip_code_17, v0_.rates_updated_at AS rates_updated_at_18, v0_.availability_updated_at AS availability_updated_at_19, v0_.staff_number AS staff_number_20, v0_.video AS video_21, v0_.floor_plan_link AS floor_plan_link_22, v0_.check_in_hour AS check_in_hour_23, v0_.check_out_hour AS check_out_hour_24, v0_.late_check_out_hour AS late_check_out_hour_25, v0_.late_check_out_rate AS late_check_out_rate_26, v0_.security_deposit_mod AS security_deposit_mod_27, v0_.security_deposit_var AS security_deposit_var_28, v0_.airport_pickup_mod AS airport_pickup_mod_29, v0_.airport_pickup_var AS airport_pickup_var_30, v0_.extra_bed_price AS extra_bed_price_31, v0_.extra_bed_pax AS extra_bed_pax_32, v0_.babycot_price AS babycot_price_33, v0_.lunch_mod AS lunch_mod_34, v0_.lunch_var AS lunch_var_35, v0_.dinner_mod AS dinner_mod_36, v0_.dinner_var AS dinner_var_37, v0_.breakfast_mod AS breakfast_mod_38, v0_.breakfast_var AS breakfast_var_39, v0_.sync_method AS sync_method_40, v0_.sync_reference AS sync_reference_41, v0_.emergency_phone AS emergency_phone_42, v0_.reference AS reference_43, v0_.hash AS hash_44, v0_.untrusted AS untrusted_45, v0_.owner_editable AS owner_editable_46, v0_.show_distribution AS show_distribution_47, v0_.property_type AS property_type_48, v0_.rates_valid_until AS rates_valid_until_49, v0_.rank_total AS rank_total_50, v0_.rank_review AS rank_review_51, v0_.rank_review_count AS rank_review_count_52, v0_.rank_minstay AS rank_minstay_53, v0_.rank_availability AS rank_availability_54, v0_.rank_conversion AS rank_conversion_55, v0_.rank_views AS rank_views_56, v0_.rank_owner AS rank_owner_57, v0_.rank_bebop_feature AS rank_bebop_feature_58, v0_.rank_bebop_picture AS rank_bebop_picture_59, v0_.rank_bebop_content AS rank_bebop_content_60, v0_.rank_bebop_place AS rank_bebop_place_61, v0_.number_views AS number_views_62, v0_.review_average AS review_average_63, v0_.review_number AS review_number_64, v0_.min_price AS min_price_65, v0_.min_price_usd AS min_price_usd_66, v0_.bedroom_number AS bedroom_number_67, v0_.bathroom_number AS bathroom_number_68, v0_.pool_number AS pool_number_69, v0_.premium AS premium_70, v0_.on_request AS on_request_71, v0_.exclusive AS exclusive_72, v0_.new AS new_73, v0_.vicinity_distance AS vicinity_distance_74, v0_.expected_commission AS expected_commission_75, v0_.commission_tax_included AS commission_tax_included_76, v0_.hide_location AS hide_location_77, v0_.license_number AS license_number_78, v0_.changeover_days AS changeover_days_79, v0_.strict_min_stay AS strict_min_stay_80, v0_.rental_agreement AS rental_agreement_81, v0_.activated_at AS activated_at_82, v0_.policy_deposit_percentage AS policy_deposit_percentage_83, v0_.policy_balance_days AS policy_balance_days_84, v0_.policy_cancellation_terms AS policy_cancellation_terms_85, v0_.sustainability_certified_url AS sustainability_certified_url_86, v0_.created_at AS created_at_87, v0_.updated_at AS updated_at_88, v0_.longitude AS longitude_89, v0_.latitude AS latitude_90, CAST(ST_AsGeoJSON(v0_.geo_point) AS CHAR) AS geo_point_91, v0_.api_auth AS api_auth_92, v0_.api_name AS api_name_93, v0_.api_push_auth AS api_push_auth_94, v0_.api_push_name AS api_push_name_95, v1_.id AS id_96, CAST(ST_AsGeoJSON(v1_.geo_shape) AS CHAR) AS geo_shape_97, v1_.name AS name_98, v1_.slug AS slug_99, v1_.image_url AS image_url_100, v1_.is_active AS is_active_101, v1_.is_area_landing_page AS is_area_landing_page_102, v1_.is_seo_active AS is_seo_active_103, v1_.hash AS hash_104, v1_.popularity AS popularity_105, v1_.homepage_position AS homepage_position_106, v1_.is_homepage_card AS is_homepage_card_107, v1_.homepage_card_image_url AS homepage_card_image_url_108, v1_.concierge_image_url AS concierge_image_url_109, v1_.property_type AS property_type_110, v1_.property_vicinity AS property_vicinity_111, v1_.alternate_names AS alternate_names_112, v1_.hint_start AS hint_start_113, v1_.hint_end AS hint_end_114, v1_.hint_message AS hint_message_115, v1_.number_of_dash AS number_of_dash_116, v1_.created_at AS created_at_117, v1_.updated_at AS updated_at_118, f2_.code AS code_119, f2_.name AS name_120, f2_.description AS description_121, f2_.priority AS priority_122, f2_.exclusive AS exclusive_123, f2_.usage_limit AS usage_limit_124, f2_.used AS used_125, f2_.coupon_based AS coupon_based_126, f2_.starts_at AS starts_at_127, f2_.ends_at AS ends_at_128, f2_.applies_to_discounted AS applies_to_discounted_129, f2_.archived_at AS archived_at_130, f2_.created_at AS created_at_131, f2_.updated_at AS updated_at_132, f2_.id AS id_133, f2_.begins AS begins_134, f2_.ends AS ends_135, f2_.discount AS discount_136, f2_.days_before AS days_before_137, v3_.id AS id_138, v3_.hard_files AS hard_files_139, v3_.nb_files AS nb_files_140, v3_.created_at AS created_at_141, v3_.updated_at AS updated_at_142, v0_.master_website_id AS master_website_id_143, v0_.media_gallery_id AS media_gallery_id_144, v0_.gallery_slider_id AS gallery_slider_id_145, v0_.gallery_main_id AS gallery_main_id_146, v0_.gallery_thumb_id AS gallery_thumb_id_147, v0_.owner_id AS owner_id_148, v0_.manager_id AS manager_id_149, v0_.pmc_id AS pmc_id_150, v0_.airport_id AS airport_id_151, v0_.currency_id AS currency_id_152, v0_.tax_id AS tax_id_153, v0_.main_location_id AS main_location_id_154, v0_.country_id AS country_id_155, v0_.next_promotion_id AS next_promotion_id_156, v0_.tc_details_id AS tc_details_id_157, v0_.rates_id AS rates_id_158, v0_.distribution_id AS distribution_id_159, v0_.inspector_id AS inspector_id_160, v0_.estate_villa_id AS estate_villa_id_161, v1_.redirect_location_id AS redirect_location_id_162, v1_.destination_id AS destination_id_163, f2_.villa_id AS villa_id_164 FROM villa v0_ INNER JOIN v4_website_villa v5_ ON v0_.id = v5_.villa_id INNER JOIN v4_website v4_ ON v4_.id = v5_.website_id AND (v4_.id = '1') LEFT JOIN v4_location v1_ ON v0_.main_location_id = v1_.id LEFT JOIN fox_promotion f2_ ON v0_.next_promotion_id = f2_.id LEFT JOIN villa_media_gallery v3_ ON v0_.gallery_main_id = v3_.id WHERE v0_.is_active = 1 AND v0_.is_indexable = 1 AND (v0_.latitude BETWEEN -8.5757400900901 AND -8.3955599099099) AND (v0_.longitude BETWEEN 115.19379990991 AND 115.37398009009) AND v0_.id <> 11002 ORDER BY sclr_0 ASC LIMIT 3;
5.28 ms (0.21%)	1	SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, v1_.id AS id_23, v1_.count AS count_24, v0_.redirect_location_id AS redirect_location_id_25, v0_.destination_id AS destination_id_26, v1_.location_id AS location_id_27, v1_.poi_category_id AS poi_category_id_28 FROM v4_location v0_ INNER JOIN v4_location v2_ ON (v2_.id = ? AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') INNER JOIN v4_location_poi_count v1_ ON v0_.id = v1_.location_id WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) ASC Parameters: [`9`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, CAST( ST_AsGeoJSON(v0_.geo_shape) AS CHAR ) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, v1_.id AS id_23, v1_.count AS count_24, v0_.redirect_location_id AS redirect_location_id_25, v0_.destination_id AS destination_id_26, v1_.location_id AS location_id_27, v1_.poi_category_id AS poi_category_id_28 FROM v4_location v0_ INNER JOIN v4_location v2_ ON ( v2_.id = ? AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0 ) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') INNER JOIN v4_location_poi_count v1_ ON v0_.id = v1_.location_id WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) ASC SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, v1_.id AS id_23, v1_.count AS count_24, v0_.redirect_location_id AS redirect_location_id_25, v0_.destination_id AS destination_id_26, v1_.location_id AS location_id_27, v1_.poi_category_id AS poi_category_id_28 FROM v4_location v0_ INNER JOIN v4_location v2_ ON (v2_.id = 9 AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') INNER JOIN v4_location_poi_count v1_ ON v0_.id = v1_.location_id WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) ASC;
5.19 ms (0.21%)	1	SELECT t0.id AS id_1, t0.begins AS begins_2, t0.ends AS ends_3, t0.type AS type_4, t0.source AS source_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.villa_id AS villa_id_8 FROM villa_unavailability t0 WHERE (((t0.ends >= ? AND t0.begins < ?) AND t0.type = ?) AND t0.villa_id = ?) Parameters: [`"2025-08-05" "2027-08-05" "unavailable" 11002`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.begins AS begins_2, t0.ends AS ends_3, t0.type AS type_4, t0.source AS source_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.villa_id AS villa_id_8 FROM villa_unavailability t0 WHERE ( ( ( t0.ends >= ? AND t0.begins < ? ) AND t0.type = ? ) AND t0.villa_id = ? ) SELECT t0.id AS id_1, t0.begins AS begins_2, t0.ends AS ends_3, t0.type AS type_4, t0.source AS source_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.villa_id AS villa_id_8 FROM villa_unavailability t0 WHERE (((t0.ends >= '2025-08-05' AND t0.begins < '2027-08-05') AND t0.type = 'unavailable') AND t0.villa_id = 11002);
4.01 ms (0.16%)	1	SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, p1_.id AS id_23, p1_.id_str AS id_str_24, p1_.name AS name_25, p1_.osm_id AS osm_id_26, p1_.excluded AS excluded_27, p1_.created_at AS created_at_28, p1_.updated_at AS updated_at_29, p1_.longitude AS longitude_30, p1_.latitude AS latitude_31, CAST(ST_AsGeoJSON(p1_.geo_point) AS CHAR) AS geo_point_32, v0_.redirect_location_id AS redirect_location_id_33, v0_.destination_id AS destination_id_34, p1_.category_id AS category_id_35 FROM v4_location v0_ INNER JOIN v4_location v2_ ON (v2_.id = ? AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') INNER JOIN v4_location_has_poi v5_ ON v0_.id = v5_.location_id INNER JOIN poi p1_ ON p1_.id = v5_.poi_id AND (p1_.excluded = 0) WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) ASC Parameters: [`9`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, CAST( ST_AsGeoJSON(v0_.geo_shape) AS CHAR ) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, p1_.id AS id_23, p1_.id_str AS id_str_24, p1_.name AS name_25, p1_.osm_id AS osm_id_26, p1_.excluded AS excluded_27, p1_.created_at AS created_at_28, p1_.updated_at AS updated_at_29, p1_.longitude AS longitude_30, p1_.latitude AS latitude_31, CAST( ST_AsGeoJSON(p1_.geo_point) AS CHAR ) AS geo_point_32, v0_.redirect_location_id AS redirect_location_id_33, v0_.destination_id AS destination_id_34, p1_.category_id AS category_id_35 FROM v4_location v0_ INNER JOIN v4_location v2_ ON ( v2_.id = ? AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0 ) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') INNER JOIN v4_location_has_poi v5_ ON v0_.id = v5_.location_id INNER JOIN poi p1_ ON p1_.id = v5_.poi_id AND (p1_.excluded = 0) WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) ASC SELECT v0_.id AS id_0, CAST(ST_AsGeoJSON(v0_.geo_shape) AS CHAR) AS geo_shape_1, v0_.name AS name_2, v0_.slug AS slug_3, v0_.image_url AS image_url_4, v0_.is_active AS is_active_5, v0_.is_area_landing_page AS is_area_landing_page_6, v0_.is_seo_active AS is_seo_active_7, v0_.hash AS hash_8, v0_.popularity AS popularity_9, v0_.homepage_position AS homepage_position_10, v0_.is_homepage_card AS is_homepage_card_11, v0_.homepage_card_image_url AS homepage_card_image_url_12, v0_.concierge_image_url AS concierge_image_url_13, v0_.property_type AS property_type_14, v0_.property_vicinity AS property_vicinity_15, v0_.alternate_names AS alternate_names_16, v0_.hint_start AS hint_start_17, v0_.hint_end AS hint_end_18, v0_.hint_message AS hint_message_19, v0_.number_of_dash AS number_of_dash_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, p1_.id AS id_23, p1_.id_str AS id_str_24, p1_.name AS name_25, p1_.osm_id AS osm_id_26, p1_.excluded AS excluded_27, p1_.created_at AS created_at_28, p1_.updated_at AS updated_at_29, p1_.longitude AS longitude_30, p1_.latitude AS latitude_31, CAST(ST_AsGeoJSON(p1_.geo_point) AS CHAR) AS geo_point_32, v0_.redirect_location_id AS redirect_location_id_33, v0_.destination_id AS destination_id_34, p1_.category_id AS category_id_35 FROM v4_location v0_ INNER JOIN v4_location v2_ ON (v2_.id = 9 AND ST_CONTAINS(v0_.geo_shape, v2_.geo_shape) > 0) INNER JOIN v4_website_location v4_ ON v0_.id = v4_.location_id INNER JOIN v4_website v3_ ON v3_.id = v4_.website_id AND (v3_.id = '1') INNER JOIN v4_location_has_poi v5_ ON v0_.id = v5_.location_id INNER JOIN poi p1_ ON p1_.id = v5_.poi_id AND (p1_.excluded = 0) WHERE v0_.is_active = 1 ORDER BY ST_AREA(v0_.geo_shape) ASC;
3.28 ms (0.13%)	8	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.icon AS icon_3, t0.osm_value AS osm_value_4, t0.selectable_on_map_menu AS selectable_on_map_menu_5, t0.checked_by_default AS checked_by_default_6 FROM poi_category t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.icon AS icon_3, t0.osm_value AS osm_value_4, t0.selectable_on_map_menu AS selectable_on_map_menu_5, t0.checked_by_default AS checked_by_default_6 FROM poi_category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.slug AS slug_2, t0.icon AS icon_3, t0.osm_value AS osm_value_4, t0.selectable_on_map_menu AS selectable_on_map_menu_5, t0.checked_by_default AS checked_by_default_6 FROM poi_category t0 WHERE t0.id = 1;
2.97 ms (0.12%)	1	SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ WHERE v0_.code = ? Parameters: [`"usd"`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ WHERE v0_.code = ? SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ WHERE v0_.code = 'usd';
2.89 ms (0.12%)	1	SELECT v0_.id AS id_0, c1_.id AS id_1, c1_.type AS type_2, c1_.parameters AS parameters_3, c2_.id AS id_4, c2_.content AS content_5, c2_.locale AS locale_6, v0_.master_website_id AS master_website_id_7, v0_.media_gallery_id AS media_gallery_id_8, v0_.gallery_slider_id AS gallery_slider_id_9, v0_.gallery_main_id AS gallery_main_id_10, v0_.gallery_thumb_id AS gallery_thumb_id_11, v0_.owner_id AS owner_id_12, v0_.manager_id AS manager_id_13, v0_.pmc_id AS pmc_id_14, v0_.airport_id AS airport_id_15, v0_.currency_id AS currency_id_16, v0_.tax_id AS tax_id_17, v0_.main_location_id AS main_location_id_18, v0_.country_id AS country_id_19, v0_.next_promotion_id AS next_promotion_id_20, v0_.tc_details_id AS tc_details_id_21, v0_.rates_id AS rates_id_22, v0_.distribution_id AS distribution_id_23, v0_.inspector_id AS inspector_id_24, v0_.estate_villa_id AS estate_villa_id_25, c2_.translatable_id AS translatable_id_26 FROM villa v0_ LEFT JOIN villa_has_content v3_ ON v0_.id = v3_.villa_id LEFT JOIN content c1_ ON c1_.id = v3_.content_id LEFT JOIN content_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale = 'de') WHERE v0_.id = ? Parameters: [`11002`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, c1_.id AS id_1, c1_.type AS type_2, c1_.parameters AS parameters_3, c2_.id AS id_4, c2_.content AS content_5, c2_.locale AS locale_6, v0_.master_website_id AS master_website_id_7, v0_.media_gallery_id AS media_gallery_id_8, v0_.gallery_slider_id AS gallery_slider_id_9, v0_.gallery_main_id AS gallery_main_id_10, v0_.gallery_thumb_id AS gallery_thumb_id_11, v0_.owner_id AS owner_id_12, v0_.manager_id AS manager_id_13, v0_.pmc_id AS pmc_id_14, v0_.airport_id AS airport_id_15, v0_.currency_id AS currency_id_16, v0_.tax_id AS tax_id_17, v0_.main_location_id AS main_location_id_18, v0_.country_id AS country_id_19, v0_.next_promotion_id AS next_promotion_id_20, v0_.tc_details_id AS tc_details_id_21, v0_.rates_id AS rates_id_22, v0_.distribution_id AS distribution_id_23, v0_.inspector_id AS inspector_id_24, v0_.estate_villa_id AS estate_villa_id_25, c2_.translatable_id AS translatable_id_26 FROM villa v0_ LEFT JOIN villa_has_content v3_ ON v0_.id = v3_.villa_id LEFT JOIN content c1_ ON c1_.id = v3_.content_id LEFT JOIN content_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale = 'de') WHERE v0_.id = ? SELECT v0_.id AS id_0, c1_.id AS id_1, c1_.type AS type_2, c1_.parameters AS parameters_3, c2_.id AS id_4, c2_.content AS content_5, c2_.locale AS locale_6, v0_.master_website_id AS master_website_id_7, v0_.media_gallery_id AS media_gallery_id_8, v0_.gallery_slider_id AS gallery_slider_id_9, v0_.gallery_main_id AS gallery_main_id_10, v0_.gallery_thumb_id AS gallery_thumb_id_11, v0_.owner_id AS owner_id_12, v0_.manager_id AS manager_id_13, v0_.pmc_id AS pmc_id_14, v0_.airport_id AS airport_id_15, v0_.currency_id AS currency_id_16, v0_.tax_id AS tax_id_17, v0_.main_location_id AS main_location_id_18, v0_.country_id AS country_id_19, v0_.next_promotion_id AS next_promotion_id_20, v0_.tc_details_id AS tc_details_id_21, v0_.rates_id AS rates_id_22, v0_.distribution_id AS distribution_id_23, v0_.inspector_id AS inspector_id_24, v0_.estate_villa_id AS estate_villa_id_25, c2_.translatable_id AS translatable_id_26 FROM villa v0_ LEFT JOIN villa_has_content v3_ ON v0_.id = v3_.villa_id LEFT JOIN content c1_ ON c1_.id = v3_.content_id LEFT JOIN content_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale = 'de') WHERE v0_.id = 11002;
2.70 ms (0.11%)	1	SELECT t0.id AS id_1, t0.refreshed_at AS refreshed_at_2, t0.code AS code_3, t0.exchange_rate AS exchange_rate_4, t0.enabled AS enabled_5, t0.base AS base_6, t0.symbol AS symbol_7, t0.label AS label_8, t0.round AS round_9, t0.apply_ecb AS apply_ecb_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM v4_currency t0 WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.refreshed_at AS refreshed_at_2, t0.code AS code_3, t0.exchange_rate AS exchange_rate_4, t0.enabled AS enabled_5, t0.base AS base_6, t0.symbol AS symbol_7, t0.label AS label_8, t0.round AS round_9, t0.apply_ecb AS apply_ecb_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM v4_currency t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.refreshed_at AS refreshed_at_2, t0.code AS code_3, t0.exchange_rate AS exchange_rate_4, t0.enabled AS enabled_5, t0.base AS base_6, t0.symbol AS symbol_7, t0.label AS label_8, t0.round AS round_9, t0.apply_ecb AS apply_ecb_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM v4_currency t0 WHERE t0.id = 7;
2.50 ms (0.10%)	1	SELECT p0_.id AS id_0, p0_.id_str AS id_str_1, p0_.name AS name_2, p0_.osm_id AS osm_id_3, p0_.excluded AS excluded_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.longitude AS longitude_7, p0_.latitude AS latitude_8, CAST(ST_AsGeoJSON(p0_.geo_point) AS CHAR) AS geo_point_9, ST_DISTANCE(p0_.geo_point, ST_GeomFromGeoJSON(?, 1, 4326)) AS sclr_10, p0_.category_id AS category_id_11 FROM poi p0_ LEFT JOIN poi_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN('de', 'en', 'en')) LEFT JOIN poi_category p2_ ON p0_.category_id = p2_.id WHERE p0_.excluded = 0 AND ST_DISTANCE(p0_.geo_point, ST_GeomFromGeoJSON(?, 1, 4326)) <= ? ORDER BY sclr_10 ASC LIMIT 30 Parameters: [`"{"type": "Point", "coordinates": [115.28389, -8.48565]}" "{"type": "Point", "coordinates": [115.28389, -8.48565]}" 5000`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.id_str AS id_str_1, p0_.name AS name_2, p0_.osm_id AS osm_id_3, p0_.excluded AS excluded_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.longitude AS longitude_7, p0_.latitude AS latitude_8, CAST( ST_AsGeoJSON(p0_.geo_point) AS CHAR ) AS geo_point_9, ST_DISTANCE( p0_.geo_point, ST_GeomFromGeoJSON(?, 1, 4326) ) AS sclr_10, p0_.category_id AS category_id_11 FROM poi p0_ LEFT JOIN poi_translation p1_ ON p0_.id = p1_.translatable_id AND ( p1_.locale IN('de', 'en', 'en') ) LEFT JOIN poi_category p2_ ON p0_.category_id = p2_.id WHERE p0_.excluded = 0 AND ST_DISTANCE( p0_.geo_point, ST_GeomFromGeoJSON(?, 1, 4326) ) <= ? ORDER BY sclr_10 ASC LIMIT 30 SELECT p0_.id AS id_0, p0_.id_str AS id_str_1, p0_.name AS name_2, p0_.osm_id AS osm_id_3, p0_.excluded AS excluded_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.longitude AS longitude_7, p0_.latitude AS latitude_8, CAST(ST_AsGeoJSON(p0_.geo_point) AS CHAR) AS geo_point_9, ST_DISTANCE(p0_.geo_point, ST_GeomFromGeoJSON('{\"type\": \"Point\", \"coordinates\": [115.28389, -8.48565]}', 1, 4326)) AS sclr_10, p0_.category_id AS category_id_11 FROM poi p0_ LEFT JOIN poi_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN('de', 'en', 'en')) LEFT JOIN poi_category p2_ ON p0_.category_id = p2_.id WHERE p0_.excluded = 0 AND ST_DISTANCE(p0_.geo_point, ST_GeomFromGeoJSON('{\"type\": \"Point\", \"coordinates\": [115.28389, -8.48565]}', 1, 4326)) <= 5000 ORDER BY sclr_10 ASC LIMIT 30;
1.94 ms (0.08%)	1	SELECT v0_.id AS id_0, v1_.id AS id_1, v1_.is_extra_cost AS is_extra_cost_2, v1_.price AS price_3, v1_.parameters AS parameters_4, v1_.option_value AS option_value_5, v1_.adjustment AS adjustment_6, v1_.included_in_promotion AS included_in_promotion_7, v1_.owner_conditions AS owner_conditions_8, f2_.id AS id_9, f2_.in_email AS in_email_10, f2_.in_email_extra_cost AS in_email_extra_cost_11, f2_.is_strong AS is_strong_12, f2_.extra_cost_for_agent AS extra_cost_for_agent_13, f2_.order_display AS order_display_14, f2_.slug AS slug_15, f2_.created_at AS created_at_16, f2_.updated_at AS updated_at_17, f3_.id AS id_18, f3_.name AS name_19, f3_.options_transkey AS options_transkey_20, f3_.locale AS locale_21, f4_.id AS id_22, f4_.icon AS icon_23, f4_.order_display AS order_display_24, f4_.slug AS slug_25, f4_.scope AS scope_26, f5_.id AS id_27, f5_.name AS name_28, f5_.locale AS locale_29, v0_.master_website_id AS master_website_id_30, v0_.media_gallery_id AS media_gallery_id_31, v0_.gallery_slider_id AS gallery_slider_id_32, v0_.gallery_main_id AS gallery_main_id_33, v0_.gallery_thumb_id AS gallery_thumb_id_34, v0_.owner_id AS owner_id_35, v0_.manager_id AS manager_id_36, v0_.pmc_id AS pmc_id_37, v0_.airport_id AS airport_id_38, v0_.currency_id AS currency_id_39, v0_.tax_id AS tax_id_40, v0_.main_location_id AS main_location_id_41, v0_.country_id AS country_id_42, v0_.next_promotion_id AS next_promotion_id_43, v0_.tc_details_id AS tc_details_id_44, v0_.rates_id AS rates_id_45, v0_.distribution_id AS distribution_id_46, v0_.inspector_id AS inspector_id_47, v0_.estate_villa_id AS estate_villa_id_48, v1_.villa_id AS villa_id_49, v1_.feature_id AS feature_id_50, f2_.category_id AS category_id_51, f3_.translatable_id AS translatable_id_52, f5_.translatable_id AS translatable_id_53 FROM villa v0_ LEFT JOIN villa_feature v1_ ON v0_.id = v1_.villa_id LEFT JOIN feature f2_ ON v1_.feature_id = f2_.id LEFT JOIN feature_translation f3_ ON f2_.id = f3_.translatable_id AND (f3_.locale IN('de', 'en', 'en')) LEFT JOIN feature_category f4_ ON f2_.category_id = f4_.id LEFT JOIN feature_category_translation f5_ ON f4_.id = f5_.translatable_id AND (f5_.locale IN('de', 'en', 'en')) WHERE v0_.id = ? ORDER BY f3_.name ASC Parameters: [`11002`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v1_.id AS id_1, v1_.is_extra_cost AS is_extra_cost_2, v1_.price AS price_3, v1_.parameters AS parameters_4, v1_.option_value AS option_value_5, v1_.adjustment AS adjustment_6, v1_.included_in_promotion AS included_in_promotion_7, v1_.owner_conditions AS owner_conditions_8, f2_.id AS id_9, f2_.in_email AS in_email_10, f2_.in_email_extra_cost AS in_email_extra_cost_11, f2_.is_strong AS is_strong_12, f2_.extra_cost_for_agent AS extra_cost_for_agent_13, f2_.order_display AS order_display_14, f2_.slug AS slug_15, f2_.created_at AS created_at_16, f2_.updated_at AS updated_at_17, f3_.id AS id_18, f3_.name AS name_19, f3_.options_transkey AS options_transkey_20, f3_.locale AS locale_21, f4_.id AS id_22, f4_.icon AS icon_23, f4_.order_display AS order_display_24, f4_.slug AS slug_25, f4_.scope AS scope_26, f5_.id AS id_27, f5_.name AS name_28, f5_.locale AS locale_29, v0_.master_website_id AS master_website_id_30, v0_.media_gallery_id AS media_gallery_id_31, v0_.gallery_slider_id AS gallery_slider_id_32, v0_.gallery_main_id AS gallery_main_id_33, v0_.gallery_thumb_id AS gallery_thumb_id_34, v0_.owner_id AS owner_id_35, v0_.manager_id AS manager_id_36, v0_.pmc_id AS pmc_id_37, v0_.airport_id AS airport_id_38, v0_.currency_id AS currency_id_39, v0_.tax_id AS tax_id_40, v0_.main_location_id AS main_location_id_41, v0_.country_id AS country_id_42, v0_.next_promotion_id AS next_promotion_id_43, v0_.tc_details_id AS tc_details_id_44, v0_.rates_id AS rates_id_45, v0_.distribution_id AS distribution_id_46, v0_.inspector_id AS inspector_id_47, v0_.estate_villa_id AS estate_villa_id_48, v1_.villa_id AS villa_id_49, v1_.feature_id AS feature_id_50, f2_.category_id AS category_id_51, f3_.translatable_id AS translatable_id_52, f5_.translatable_id AS translatable_id_53 FROM villa v0_ LEFT JOIN villa_feature v1_ ON v0_.id = v1_.villa_id LEFT JOIN feature f2_ ON v1_.feature_id = f2_.id LEFT JOIN feature_translation f3_ ON f2_.id = f3_.translatable_id AND ( f3_.locale IN('de', 'en', 'en') ) LEFT JOIN feature_category f4_ ON f2_.category_id = f4_.id LEFT JOIN feature_category_translation f5_ ON f4_.id = f5_.translatable_id AND ( f5_.locale IN('de', 'en', 'en') ) WHERE v0_.id = ? ORDER BY f3_.name ASC SELECT v0_.id AS id_0, v1_.id AS id_1, v1_.is_extra_cost AS is_extra_cost_2, v1_.price AS price_3, v1_.parameters AS parameters_4, v1_.option_value AS option_value_5, v1_.adjustment AS adjustment_6, v1_.included_in_promotion AS included_in_promotion_7, v1_.owner_conditions AS owner_conditions_8, f2_.id AS id_9, f2_.in_email AS in_email_10, f2_.in_email_extra_cost AS in_email_extra_cost_11, f2_.is_strong AS is_strong_12, f2_.extra_cost_for_agent AS extra_cost_for_agent_13, f2_.order_display AS order_display_14, f2_.slug AS slug_15, f2_.created_at AS created_at_16, f2_.updated_at AS updated_at_17, f3_.id AS id_18, f3_.name AS name_19, f3_.options_transkey AS options_transkey_20, f3_.locale AS locale_21, f4_.id AS id_22, f4_.icon AS icon_23, f4_.order_display AS order_display_24, f4_.slug AS slug_25, f4_.scope AS scope_26, f5_.id AS id_27, f5_.name AS name_28, f5_.locale AS locale_29, v0_.master_website_id AS master_website_id_30, v0_.media_gallery_id AS media_gallery_id_31, v0_.gallery_slider_id AS gallery_slider_id_32, v0_.gallery_main_id AS gallery_main_id_33, v0_.gallery_thumb_id AS gallery_thumb_id_34, v0_.owner_id AS owner_id_35, v0_.manager_id AS manager_id_36, v0_.pmc_id AS pmc_id_37, v0_.airport_id AS airport_id_38, v0_.currency_id AS currency_id_39, v0_.tax_id AS tax_id_40, v0_.main_location_id AS main_location_id_41, v0_.country_id AS country_id_42, v0_.next_promotion_id AS next_promotion_id_43, v0_.tc_details_id AS tc_details_id_44, v0_.rates_id AS rates_id_45, v0_.distribution_id AS distribution_id_46, v0_.inspector_id AS inspector_id_47, v0_.estate_villa_id AS estate_villa_id_48, v1_.villa_id AS villa_id_49, v1_.feature_id AS feature_id_50, f2_.category_id AS category_id_51, f3_.translatable_id AS translatable_id_52, f5_.translatable_id AS translatable_id_53 FROM villa v0_ LEFT JOIN villa_feature v1_ ON v0_.id = v1_.villa_id LEFT JOIN feature f2_ ON v1_.feature_id = f2_.id LEFT JOIN feature_translation f3_ ON f2_.id = f3_.translatable_id AND (f3_.locale IN('de', 'en', 'en')) LEFT JOIN feature_category f4_ ON f2_.category_id = f4_.id LEFT JOIN feature_category_translation f5_ ON f4_.id = f5_.translatable_id AND (f5_.locale IN('de', 'en', 'en')) WHERE v0_.id = 11002 ORDER BY f3_.name ASC;
1.69 ms (0.07%)	1	SELECT v0_.id AS id_0, v1_.id AS id_1, v1_.type_area AS type_area_2, v1_.type AS type_3, v1_.name AS name_4, v1_.features AS features_5, v1_.specification AS specification_6, v1_.index_place AS index_place_7, v1_.is_optionnal AS is_optionnal_8, v1_.created_at AS created_at_9, v1_.updated_at AS updated_at_10, v2_.id AS id_11, v2_.hard_files AS hard_files_12, v2_.nb_files AS nb_files_13, v2_.created_at AS created_at_14, v2_.updated_at AS updated_at_15, v0_.master_website_id AS master_website_id_16, v0_.media_gallery_id AS media_gallery_id_17, v0_.gallery_slider_id AS gallery_slider_id_18, v0_.gallery_main_id AS gallery_main_id_19, v0_.gallery_thumb_id AS gallery_thumb_id_20, v0_.owner_id AS owner_id_21, v0_.manager_id AS manager_id_22, v0_.pmc_id AS pmc_id_23, v0_.airport_id AS airport_id_24, v0_.currency_id AS currency_id_25, v0_.tax_id AS tax_id_26, v0_.main_location_id AS main_location_id_27, v0_.country_id AS country_id_28, v0_.next_promotion_id AS next_promotion_id_29, v0_.tc_details_id AS tc_details_id_30, v0_.rates_id AS rates_id_31, v0_.distribution_id AS distribution_id_32, v0_.inspector_id AS inspector_id_33, v0_.estate_villa_id AS estate_villa_id_34, v1_.villa_id AS villa_id_35, v1_.media_gallery_id AS media_gallery_id_36 FROM villa v0_ LEFT JOIN villa_place v1_ ON v0_.id = v1_.villa_id LEFT JOIN villa_media_gallery v2_ ON v1_.media_gallery_id = v2_.id WHERE v0_.id = ? ORDER BY v1_.type_area ASC, v1_.id ASC Parameters: [`11002`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v1_.id AS id_1, v1_.type_area AS type_area_2, v1_.type AS type_3, v1_.name AS name_4, v1_.features AS features_5, v1_.specification AS specification_6, v1_.index_place AS index_place_7, v1_.is_optionnal AS is_optionnal_8, v1_.created_at AS created_at_9, v1_.updated_at AS updated_at_10, v2_.id AS id_11, v2_.hard_files AS hard_files_12, v2_.nb_files AS nb_files_13, v2_.created_at AS created_at_14, v2_.updated_at AS updated_at_15, v0_.master_website_id AS master_website_id_16, v0_.media_gallery_id AS media_gallery_id_17, v0_.gallery_slider_id AS gallery_slider_id_18, v0_.gallery_main_id AS gallery_main_id_19, v0_.gallery_thumb_id AS gallery_thumb_id_20, v0_.owner_id AS owner_id_21, v0_.manager_id AS manager_id_22, v0_.pmc_id AS pmc_id_23, v0_.airport_id AS airport_id_24, v0_.currency_id AS currency_id_25, v0_.tax_id AS tax_id_26, v0_.main_location_id AS main_location_id_27, v0_.country_id AS country_id_28, v0_.next_promotion_id AS next_promotion_id_29, v0_.tc_details_id AS tc_details_id_30, v0_.rates_id AS rates_id_31, v0_.distribution_id AS distribution_id_32, v0_.inspector_id AS inspector_id_33, v0_.estate_villa_id AS estate_villa_id_34, v1_.villa_id AS villa_id_35, v1_.media_gallery_id AS media_gallery_id_36 FROM villa v0_ LEFT JOIN villa_place v1_ ON v0_.id = v1_.villa_id LEFT JOIN villa_media_gallery v2_ ON v1_.media_gallery_id = v2_.id WHERE v0_.id = ? ORDER BY v1_.type_area ASC, v1_.id ASC SELECT v0_.id AS id_0, v1_.id AS id_1, v1_.type_area AS type_area_2, v1_.type AS type_3, v1_.name AS name_4, v1_.features AS features_5, v1_.specification AS specification_6, v1_.index_place AS index_place_7, v1_.is_optionnal AS is_optionnal_8, v1_.created_at AS created_at_9, v1_.updated_at AS updated_at_10, v2_.id AS id_11, v2_.hard_files AS hard_files_12, v2_.nb_files AS nb_files_13, v2_.created_at AS created_at_14, v2_.updated_at AS updated_at_15, v0_.master_website_id AS master_website_id_16, v0_.media_gallery_id AS media_gallery_id_17, v0_.gallery_slider_id AS gallery_slider_id_18, v0_.gallery_main_id AS gallery_main_id_19, v0_.gallery_thumb_id AS gallery_thumb_id_20, v0_.owner_id AS owner_id_21, v0_.manager_id AS manager_id_22, v0_.pmc_id AS pmc_id_23, v0_.airport_id AS airport_id_24, v0_.currency_id AS currency_id_25, v0_.tax_id AS tax_id_26, v0_.main_location_id AS main_location_id_27, v0_.country_id AS country_id_28, v0_.next_promotion_id AS next_promotion_id_29, v0_.tc_details_id AS tc_details_id_30, v0_.rates_id AS rates_id_31, v0_.distribution_id AS distribution_id_32, v0_.inspector_id AS inspector_id_33, v0_.estate_villa_id AS estate_villa_id_34, v1_.villa_id AS villa_id_35, v1_.media_gallery_id AS media_gallery_id_36 FROM villa v0_ LEFT JOIN villa_place v1_ ON v0_.id = v1_.villa_id LEFT JOIN villa_media_gallery v2_ ON v1_.media_gallery_id = v2_.id WHERE v0_.id = 11002 ORDER BY v1_.type_area ASC, v1_.id ASC;
1.32 ms (0.05%)	1	SELECT v0_.id AS id_0, v0_.bedrooms AS bedrooms_1, v0_.guests AS guests_2, v0_.promotion AS promotion_3, v0_.sort AS sort_4, v0_.tags AS tags_5, v0_.tc_filters AS tc_filters_6, v1_.host AS host_7, v1_.schemes AS schemes_8, v1_.methods AS methods_9, v1_.defaults AS defaults_10, v1_.requirements AS requirements_11, v1_.options AS options_12, v1_.`condition` AS condition_13, v1_.variable_pattern AS variable_pattern_14, v1_.staticPrefix AS staticPrefix_15, v1_.id AS id_16, v1_.name AS name_17, v1_.position AS position_18, v0_.location_id AS location_id_19, v1_.locale_id AS locale_id_20, v1_.root_id AS root_id_21 FROM v4_search v0_ INNER JOIN v4_search_route v2_ ON v0_.id = v2_.search_id INNER JOIN v4_route v1_ ON v1_.id = v2_.route_id WHERE v1_.host = '' OR v1_.requirements LIKE ? ORDER BY v1_.position ASC Parameters: [`"%choco.villa-bali.com%"`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.bedrooms AS bedrooms_1, v0_.guests AS guests_2, v0_.promotion AS promotion_3, v0_.sort AS sort_4, v0_.tags AS tags_5, v0_.tc_filters AS tc_filters_6, v1_.host AS host_7, v1_.schemes AS schemes_8, v1_.methods AS methods_9, v1_.defaults AS defaults_10, v1_.requirements AS requirements_11, v1_.options AS options_12, v1_.`condition` AS condition_13, v1_.variable_pattern AS variable_pattern_14, v1_.staticPrefix AS staticPrefix_15, v1_.id AS id_16, v1_.name AS name_17, v1_.position AS position_18, v0_.location_id AS location_id_19, v1_.locale_id AS locale_id_20, v1_.root_id AS root_id_21 FROM v4_search v0_ INNER JOIN v4_search_route v2_ ON v0_.id = v2_.search_id INNER JOIN v4_route v1_ ON v1_.id = v2_.route_id WHERE v1_.host = '' OR v1_.requirements LIKE ? ORDER BY v1_.position ASC SELECT v0_.id AS id_0, v0_.bedrooms AS bedrooms_1, v0_.guests AS guests_2, v0_.promotion AS promotion_3, v0_.sort AS sort_4, v0_.tags AS tags_5, v0_.tc_filters AS tc_filters_6, v1_.host AS host_7, v1_.schemes AS schemes_8, v1_.methods AS methods_9, v1_.defaults AS defaults_10, v1_.requirements AS requirements_11, v1_.options AS options_12, v1_.`condition` AS condition_13, v1_.variable_pattern AS variable_pattern_14, v1_.staticPrefix AS staticPrefix_15, v1_.id AS id_16, v1_.name AS name_17, v1_.position AS position_18, v0_.location_id AS location_id_19, v1_.locale_id AS locale_id_20, v1_.root_id AS root_id_21 FROM v4_search v0_ INNER JOIN v4_search_route v2_ ON v0_.id = v2_.search_id INNER JOIN v4_route v1_ ON v1_.id = v2_.route_id WHERE v1_.host = '' OR v1_.requirements LIKE '%choco.villa-bali.com%' ORDER BY v1_.position ASC;
1.29 ms (0.05%)	1	SELECT t0.id AS id_1, t0.rooms AS rooms_2, t0.person AS person_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.villa_id AS villa_id_6 FROM villa_configuration t0 WHERE t0.villa_id = ? ORDER BY t0.rooms ASC Parameters: [`11002`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.rooms AS rooms_2, t0.person AS person_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.villa_id AS villa_id_6 FROM villa_configuration t0 WHERE t0.villa_id = ? ORDER BY t0.rooms ASC SELECT t0.id AS id_1, t0.rooms AS rooms_2, t0.person AS person_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.villa_id AS villa_id_6 FROM villa_configuration t0 WHERE t0.villa_id = 11002 ORDER BY t0.rooms ASC;
1.29 ms (0.05%)	1	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.iso_code_2 AS iso_code_2_2, f0_.iso_code_3 AS iso_code_3_3, f0_.call_code AS call_code_4, f0_.is_famous AS is_famous_5, f0_.time_diff_singapore AS time_diff_singapore_6, f0_.continent AS continent_7, f0_.specify_airport AS specify_airport_8, f0_.created_at AS created_at_9, f0_.updated_at AS updated_at_10, f0_.phone_office_id AS phone_office_id_11, f0_.whatsapp_phone_office_id AS whatsapp_phone_office_id_12, f0_.transfer_detail_id AS transfer_detail_id_13 FROM front_country f0_ WHERE f0_.iso_code_2 = ? Parameters: [`"US"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.iso_code_2 AS iso_code_2_2, f0_.iso_code_3 AS iso_code_3_3, f0_.call_code AS call_code_4, f0_.is_famous AS is_famous_5, f0_.time_diff_singapore AS time_diff_singapore_6, f0_.continent AS continent_7, f0_.specify_airport AS specify_airport_8, f0_.created_at AS created_at_9, f0_.updated_at AS updated_at_10, f0_.phone_office_id AS phone_office_id_11, f0_.whatsapp_phone_office_id AS whatsapp_phone_office_id_12, f0_.transfer_detail_id AS transfer_detail_id_13 FROM front_country f0_ WHERE f0_.iso_code_2 = ? SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.iso_code_2 AS iso_code_2_2, f0_.iso_code_3 AS iso_code_3_3, f0_.call_code AS call_code_4, f0_.is_famous AS is_famous_5, f0_.time_diff_singapore AS time_diff_singapore_6, f0_.continent AS continent_7, f0_.specify_airport AS specify_airport_8, f0_.created_at AS created_at_9, f0_.updated_at AS updated_at_10, f0_.phone_office_id AS phone_office_id_11, f0_.whatsapp_phone_office_id AS whatsapp_phone_office_id_12, f0_.transfer_detail_id AS transfer_detail_id_13 FROM front_country f0_ WHERE f0_.iso_code_2 = 'US';
1.29 ms (0.05%)	1	SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.popularity AS popularity_3, v1_.id AS id_4, v1_.homepage_label AS homepage_label_5, v1_.locale AS locale_6, v0_.redirect_location_id AS redirect_location_id_7, v0_.destination_id AS destination_id_8, v1_.translatable_id AS translatable_id_9 FROM v4_location v0_ LEFT JOIN v4_location_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale = 'de') WHERE v0_.is_active = 1 AND v0_.slug IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.name ASC Parameters: [`"canggu" "legian" "kerobokan" "kuta" "sanur" "seminyak" "outer-seminyak" "umalas" "south-bali" "ubud" "jimbaran" "nusa-dua" "uluwatu" "bukit-peninsula" "amed" "candidasa" "east-bali" "lovina" "pemuteran" "north-bali" "tabanan" "west-bali" "gili" "lombok" "nusa-lembongan" "gili-lombok-nusa-lembongan"`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.popularity AS popularity_3, v1_.id AS id_4, v1_.homepage_label AS homepage_label_5, v1_.locale AS locale_6, v0_.redirect_location_id AS redirect_location_id_7, v0_.destination_id AS destination_id_8, v1_.translatable_id AS translatable_id_9 FROM v4_location v0_ LEFT JOIN v4_location_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale = 'de') WHERE v0_.is_active = 1 AND v0_.slug IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY v0_.name ASC SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.popularity AS popularity_3, v1_.id AS id_4, v1_.homepage_label AS homepage_label_5, v1_.locale AS locale_6, v0_.redirect_location_id AS redirect_location_id_7, v0_.destination_id AS destination_id_8, v1_.translatable_id AS translatable_id_9 FROM v4_location v0_ LEFT JOIN v4_location_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale = 'de') WHERE v0_.is_active = 1 AND v0_.slug IN ('canggu', 'legian', 'kerobokan', 'kuta', 'sanur', 'seminyak', 'outer-seminyak', 'umalas', 'south-bali', 'ubud', 'jimbaran', 'nusa-dua', 'uluwatu', 'bukit-peninsula', 'amed', 'candidasa', 'east-bali', 'lovina', 'pemuteran', 'north-bali', 'tabanan', 'west-bali', 'gili', 'lombok', 'nusa-lembongan', 'gili-lombok-nusa-lembongan') ORDER BY v0_.name ASC;
1.21 ms (0.05%)	1	SELECT t0.id AS id_1, t0.owner AS owner_2, t0.manager AS manager_3, t0.pmc AS pmc_4, t0.name AS name_5, t0.phone AS phone_6, t0.send_email AS send_email_7, t0.filter_multiple_email AS filter_multiple_email_8, t0.tax_included AS tax_included_9, t0.trust_score AS trust_score_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.supplier_id AS supplier_id_14 FROM villa_personincharge t0 WHERE t0.id = ? Parameters: [`1149`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.owner AS owner_2, t0.manager AS manager_3, t0.pmc AS pmc_4, t0.name AS name_5, t0.phone AS phone_6, t0.send_email AS send_email_7, t0.filter_multiple_email AS filter_multiple_email_8, t0.tax_included AS tax_included_9, t0.trust_score AS trust_score_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.supplier_id AS supplier_id_14 FROM villa_personincharge t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.owner AS owner_2, t0.manager AS manager_3, t0.pmc AS pmc_4, t0.name AS name_5, t0.phone AS phone_6, t0.send_email AS send_email_7, t0.filter_multiple_email AS filter_multiple_email_8, t0.tax_included AS tax_included_9, t0.trust_score AS trust_score_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.supplier_id AS supplier_id_14 FROM villa_personincharge t0 WHERE t0.id = 1149;
1.09 ms (0.04%)	1	SELECT p0_.osm_id AS osm_id_0 FROM poi p0_ LEFT JOIN poi_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN('de', 'en', 'en')) LEFT JOIN poi_category p2_ ON p0_.category_id = p2_.id WHERE p0_.excluded = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT p0_.osm_id AS osm_id_0 FROM poi p0_ LEFT JOIN poi_translation p1_ ON p0_.id = p1_.translatable_id AND ( p1_.locale IN('de', 'en', 'en') ) LEFT JOIN poi_category p2_ ON p0_.category_id = p2_.id WHERE p0_.excluded = ? SELECT p0_.osm_id AS osm_id_0 FROM poi p0_ LEFT JOIN poi_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN('de', 'en', 'en')) LEFT JOIN poi_category p2_ ON p0_.category_id = p2_.id WHERE p0_.excluded = 1;
0.95 ms (0.04%)	1	SELECT v0_.mark AS mark_0, v0_.nickname AS nickname_1, v0_.created_at AS created_at_2, v0_.how AS how_3, v1_.name AS name_4, v1_.review_number AS review_number_5, v1_.id_str AS id_str_6, v2_.slug AS slug_7, COALESCE(v3_.code, v4_.code) AS sclr_8, JSON_UNQUOTE(JSON_EXTRACT(v5_.hard_files, '$[0]')) AS sclr_9, f6_.iso_code_2 AS iso_code_2_10, f6_.name AS name_11, v7_.comment AS comment_12, COALESCE(f8_.checkin, v0_.check_in) AS sclr_13, COALESCE(f8_.checkout, v0_.check_out) AS sclr_14 FROM villa_review v0_ INNER JOIN villa v1_ ON v0_.villa_id = v1_.id INNER JOIN v4_location v2_ ON v1_.main_location_id = v2_.id INNER JOIN v4_locale v4_ ON v0_.source_locale_id = v4_.id LEFT JOIN v4_locale v3_ ON v4_.root_locale_id = v3_.id LEFT JOIN villa_media_gallery v5_ ON v1_.gallery_main_id = v5_.id LEFT JOIN front_country f6_ ON v0_.country_id = f6_.id INNER JOIN villa_review_translation v7_ ON v0_.id = v7_.translatable_id AND (v7_.locale IN('de', 'en', 'en')) LEFT JOIN fox_folder_inquiry_request f8_ ON v0_.request_id = f8_.id WHERE v0_.published_date IS NOT NULL AND v0_.archived_date IS NULL AND v1_.id_str = ? ORDER BY v0_.id DESC LIMIT 20 Parameters: [`"leona-valley-view-2br"`] View formatted query View runnable query Explain query SELECT v0_.mark AS mark_0, v0_.nickname AS nickname_1, v0_.created_at AS created_at_2, v0_.how AS how_3, v1_.name AS name_4, v1_.review_number AS review_number_5, v1_.id_str AS id_str_6, v2_.slug AS slug_7, COALESCE(v3_.code, v4_.code) AS sclr_8, JSON_UNQUOTE( JSON_EXTRACT(v5_.hard_files, '$[0]') ) AS sclr_9, f6_.iso_code_2 AS iso_code_2_10, f6_.name AS name_11, v7_.comment AS comment_12, COALESCE(f8_.checkin, v0_.check_in) AS sclr_13, COALESCE(f8_.checkout, v0_.check_out) AS sclr_14 FROM villa_review v0_ INNER JOIN villa v1_ ON v0_.villa_id = v1_.id INNER JOIN v4_location v2_ ON v1_.main_location_id = v2_.id INNER JOIN v4_locale v4_ ON v0_.source_locale_id = v4_.id LEFT JOIN v4_locale v3_ ON v4_.root_locale_id = v3_.id LEFT JOIN villa_media_gallery v5_ ON v1_.gallery_main_id = v5_.id LEFT JOIN front_country f6_ ON v0_.country_id = f6_.id INNER JOIN villa_review_translation v7_ ON v0_.id = v7_.translatable_id AND ( v7_.locale IN('de', 'en', 'en') ) LEFT JOIN fox_folder_inquiry_request f8_ ON v0_.request_id = f8_.id WHERE v0_.published_date IS NOT NULL AND v0_.archived_date IS NULL AND v1_.id_str = ? ORDER BY v0_.id DESC LIMIT 20 SELECT v0_.mark AS mark_0, v0_.nickname AS nickname_1, v0_.created_at AS created_at_2, v0_.how AS how_3, v1_.name AS name_4, v1_.review_number AS review_number_5, v1_.id_str AS id_str_6, v2_.slug AS slug_7, COALESCE(v3_.code, v4_.code) AS sclr_8, JSON_UNQUOTE(JSON_EXTRACT(v5_.hard_files, '$[0]')) AS sclr_9, f6_.iso_code_2 AS iso_code_2_10, f6_.name AS name_11, v7_.comment AS comment_12, COALESCE(f8_.checkin, v0_.check_in) AS sclr_13, COALESCE(f8_.checkout, v0_.check_out) AS sclr_14 FROM villa_review v0_ INNER JOIN villa v1_ ON v0_.villa_id = v1_.id INNER JOIN v4_location v2_ ON v1_.main_location_id = v2_.id INNER JOIN v4_locale v4_ ON v0_.source_locale_id = v4_.id LEFT JOIN v4_locale v3_ ON v4_.root_locale_id = v3_.id LEFT JOIN villa_media_gallery v5_ ON v1_.gallery_main_id = v5_.id LEFT JOIN front_country f6_ ON v0_.country_id = f6_.id INNER JOIN villa_review_translation v7_ ON v0_.id = v7_.translatable_id AND (v7_.locale IN('de', 'en', 'en')) LEFT JOIN fox_folder_inquiry_request f8_ ON v0_.request_id = f8_.id WHERE v0_.published_date IS NOT NULL AND v0_.archived_date IS NULL AND v1_.id_str = 'leona-valley-view-2br' ORDER BY v0_.id DESC LIMIT 20;
0.92 ms (0.04%)	1	SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.host AS host_2, v0_.meta AS meta_3, v0_.email AS email_4, v0_.initials AS initials_5, v0_.country AS country_6, v0_.cdn_asset AS cdn_asset_7, v0_.active AS active_8, v0_.master AS master_9, v0_.prefix_translation AS prefix_translation_10, v0_.galaxite AS galaxite_11, v0_.location_id AS location_id_12, v0_.currency_id AS currency_id_13 FROM v4_website v0_ WHERE v0_.host = ? Parameters: [`"choco.villa-bali.com"`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.host AS host_2, v0_.meta AS meta_3, v0_.email AS email_4, v0_.initials AS initials_5, v0_.country AS country_6, v0_.cdn_asset AS cdn_asset_7, v0_.active AS active_8, v0_.master AS master_9, v0_.prefix_translation AS prefix_translation_10, v0_.galaxite AS galaxite_11, v0_.location_id AS location_id_12, v0_.currency_id AS currency_id_13 FROM v4_website v0_ WHERE v0_.host = ? SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.host AS host_2, v0_.meta AS meta_3, v0_.email AS email_4, v0_.initials AS initials_5, v0_.country AS country_6, v0_.cdn_asset AS cdn_asset_7, v0_.active AS active_8, v0_.master AS master_9, v0_.prefix_translation AS prefix_translation_10, v0_.galaxite AS galaxite_11, v0_.location_id AS location_id_12, v0_.currency_id AS currency_id_13 FROM v4_website v0_ WHERE v0_.host = 'choco.villa-bali.com';
0.91 ms (0.04%)	1	SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.icon AS icon_2, v0_.category AS category_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v1_.id AS id_6, v1_.label AS label_7, v1_.locale AS locale_8, v1_.translatable_id AS translatable_id_9 FROM v4_concierge_service v0_ LEFT JOIN v4_concierge_service_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale IN('de', 'en', 'en')) INNER JOIN v4_location_has_concierge_service v3_ ON v0_.id = v3_.concierge_service_id INNER JOIN v4_location v2_ ON v2_.id = v3_.location_id AND (v2_.id = ?) ORDER BY v0_.category ASC, v1_.label ASC, v0_.name ASC LIMIT 12 Parameters: [`65`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.icon AS icon_2, v0_.category AS category_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v1_.id AS id_6, v1_.label AS label_7, v1_.locale AS locale_8, v1_.translatable_id AS translatable_id_9 FROM v4_concierge_service v0_ LEFT JOIN v4_concierge_service_translation v1_ ON v0_.id = v1_.translatable_id AND ( v1_.locale IN('de', 'en', 'en') ) INNER JOIN v4_location_has_concierge_service v3_ ON v0_.id = v3_.concierge_service_id INNER JOIN v4_location v2_ ON v2_.id = v3_.location_id AND (v2_.id = ?) ORDER BY v0_.category ASC, v1_.label ASC, v0_.name ASC LIMIT 12 SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.icon AS icon_2, v0_.category AS category_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v1_.id AS id_6, v1_.label AS label_7, v1_.locale AS locale_8, v1_.translatable_id AS translatable_id_9 FROM v4_concierge_service v0_ LEFT JOIN v4_concierge_service_translation v1_ ON v0_.id = v1_.translatable_id AND (v1_.locale IN('de', 'en', 'en')) INNER JOIN v4_location_has_concierge_service v3_ ON v0_.id = v3_.concierge_service_id INNER JOIN v4_location v2_ ON v2_.id = v3_.location_id AND (v2_.id = 65) ORDER BY v0_.category ASC, v1_.label ASC, v0_.name ASC LIMIT 12;
0.72 ms (0.03%)	2	SELECT t0.id AS id_1, t0.homepage_label AS homepage_label_2, t0.title AS title_3, t0.description AS description_4, t0.homepage_card_content AS homepage_card_content_5, t0.expert_review AS expert_review_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM v4_location_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? AND ((t0.locale = 'de')) LIMIT 1 Parameters: [`65 "de"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.homepage_label AS homepage_label_2, t0.title AS title_3, t0.description AS description_4, t0.homepage_card_content AS homepage_card_content_5, t0.expert_review AS expert_review_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM v4_location_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? AND ( (t0.locale = 'de') ) LIMIT 1 SELECT t0.id AS id_1, t0.homepage_label AS homepage_label_2, t0.title AS title_3, t0.description AS description_4, t0.homepage_card_content AS homepage_card_content_5, t0.expert_review AS expert_review_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM v4_location_translation t0 WHERE t0.translatable_id = 65 AND t0.locale = 'de' AND ((t0.locale = 'de')) LIMIT 1;
0.64 ms (0.03%)	1	SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM v4_locale v0_ INNER JOIN v4_website_locale v2_ ON v0_.id = v2_.locale_id INNER JOIN v4_website v1_ ON v1_.id = v2_.website_id AND (v1_.id = '1') WHERE v0_.enabled = ? ORDER BY v0_.localized_label ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM v4_locale v0_ INNER JOIN v4_website_locale v2_ ON v0_.id = v2_.locale_id INNER JOIN v4_website v1_ ON v1_.id = v2_.website_id AND (v1_.id = '1') WHERE v0_.enabled = ? ORDER BY v0_.localized_label ASC SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM v4_locale v0_ INNER JOIN v4_website_locale v2_ ON v0_.id = v2_.locale_id INNER JOIN v4_website v1_ ON v1_.id = v2_.website_id AND (v1_.id = '1') WHERE v0_.enabled = 1 ORDER BY v0_.localized_label ASC;
0.64 ms (0.03%)	1	SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ INNER JOIN v4_website_currency v2_ ON v0_.id = v2_.currency_id INNER JOIN v4_website v1_ ON v1_.id = v2_.website_id AND (v1_.id = '1') WHERE v0_.enabled = ? ORDER BY v0_.code ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ INNER JOIN v4_website_currency v2_ ON v0_.id = v2_.currency_id INNER JOIN v4_website v1_ ON v1_.id = v2_.website_id AND (v1_.id = '1') WHERE v0_.enabled = ? ORDER BY v0_.code ASC SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ INNER JOIN v4_website_currency v2_ ON v0_.id = v2_.currency_id INNER JOIN v4_website v1_ ON v1_.id = v2_.website_id AND (v1_.id = '1') WHERE v0_.enabled = 1 ORDER BY v0_.code ASC;
0.50 ms (0.02%)	1	SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM front_country f1_ INNER JOIN v4_locale v0_ ON (v0_.country_id = f1_.id AND f1_.id = ?) Parameters: [`565`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM front_country f1_ INNER JOIN v4_locale v0_ ON ( v0_.country_id = f1_.id AND f1_.id = ? ) SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM front_country f1_ INNER JOIN v4_locale v0_ ON (v0_.country_id = f1_.id AND f1_.id = 565);
0.47 ms (0.02%)	1	SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.icon AS icon_2, p0_.osm_value AS osm_value_3, p0_.selectable_on_map_menu AS selectable_on_map_menu_4, p0_.checked_by_default AS checked_by_default_5, p1_.id AS id_6, p1_.name AS name_7, p1_.locale AS locale_8, p1_.translatable_id AS translatable_id_9 FROM poi_category p0_ LEFT JOIN poi_category_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN('de', 'en', 'en')) WHERE p0_.slug = ? Parameters: [`"beach"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.icon AS icon_2, p0_.osm_value AS osm_value_3, p0_.selectable_on_map_menu AS selectable_on_map_menu_4, p0_.checked_by_default AS checked_by_default_5, p1_.id AS id_6, p1_.name AS name_7, p1_.locale AS locale_8, p1_.translatable_id AS translatable_id_9 FROM poi_category p0_ LEFT JOIN poi_category_translation p1_ ON p0_.id = p1_.translatable_id AND ( p1_.locale IN('de', 'en', 'en') ) WHERE p0_.slug = ? SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.icon AS icon_2, p0_.osm_value AS osm_value_3, p0_.selectable_on_map_menu AS selectable_on_map_menu_4, p0_.checked_by_default AS checked_by_default_5, p1_.id AS id_6, p1_.name AS name_7, p1_.locale AS locale_8, p1_.translatable_id AS translatable_id_9 FROM poi_category p0_ LEFT JOIN poi_category_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale IN('de', 'en', 'en')) WHERE p0_.slug = 'beach';
0.47 ms (0.02%)	1	SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.number AS number_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4 FROM v4_phone_office v0_ INNER JOIN front_country f1_ ON (f1_.phone_office_id = v0_.id AND f1_.id = ?) LIMIT 1 Parameters: [`565`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.number AS number_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4 FROM v4_phone_office v0_ INNER JOIN front_country f1_ ON ( f1_.phone_office_id = v0_.id AND f1_.id = ? ) LIMIT 1 SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.number AS number_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4 FROM v4_phone_office v0_ INNER JOIN front_country f1_ ON (f1_.phone_office_id = v0_.id AND f1_.id = 565) LIMIT 1;
0.46 ms (0.02%)	1	SELECT t0.id AS id_1, t0.max_seating AS max_seating_2, t0.max_standing AS max_standing_3, t0.event_fee AS event_fee_4, t0.banjar_fee AS banjar_fee_5, t0.curfew AS curfew_6, t0.note AS note_7, t0.last_revised_at AS last_revised_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.villa_id AS villa_id_11 FROM villa_event t0 WHERE t0.villa_id = ? Parameters: [`11002`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.max_seating AS max_seating_2, t0.max_standing AS max_standing_3, t0.event_fee AS event_fee_4, t0.banjar_fee AS banjar_fee_5, t0.curfew AS curfew_6, t0.note AS note_7, t0.last_revised_at AS last_revised_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.villa_id AS villa_id_11 FROM villa_event t0 WHERE t0.villa_id = ? SELECT t0.id AS id_1, t0.max_seating AS max_seating_2, t0.max_standing AS max_standing_3, t0.event_fee AS event_fee_4, t0.banjar_fee AS banjar_fee_5, t0.curfew AS curfew_6, t0.note AS note_7, t0.last_revised_at AS last_revised_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.villa_id AS villa_id_11 FROM villa_event t0 WHERE t0.villa_id = 11002;
0.41 ms (0.02%)	1	SELECT v0_.host AS host_0, v0_.schemes AS schemes_1, v0_.methods AS methods_2, v0_.defaults AS defaults_3, v0_.requirements AS requirements_4, v0_.options AS options_5, v0_.`condition` AS condition_6, v0_.variable_pattern AS variable_pattern_7, v0_.staticPrefix AS staticPrefix_8, v0_.id AS id_9, v0_.name AS name_10, v0_.position AS position_11, v0_.locale_id AS locale_id_12, v0_.root_id AS root_id_13 FROM v4_route v0_ WHERE v0_.name = ? Parameters: [`"_cmf_press"`] View formatted query View runnable query Explain query SELECT v0_.host AS host_0, v0_.schemes AS schemes_1, v0_.methods AS methods_2, v0_.defaults AS defaults_3, v0_.requirements AS requirements_4, v0_.options AS options_5, v0_.`condition` AS condition_6, v0_.variable_pattern AS variable_pattern_7, v0_.staticPrefix AS staticPrefix_8, v0_.id AS id_9, v0_.name AS name_10, v0_.position AS position_11, v0_.locale_id AS locale_id_12, v0_.root_id AS root_id_13 FROM v4_route v0_ WHERE v0_.name = ? SELECT v0_.host AS host_0, v0_.schemes AS schemes_1, v0_.methods AS methods_2, v0_.defaults AS defaults_3, v0_.requirements AS requirements_4, v0_.options AS options_5, v0_.`condition` AS condition_6, v0_.variable_pattern AS variable_pattern_7, v0_.staticPrefix AS staticPrefix_8, v0_.id AS id_9, v0_.name AS name_10, v0_.position AS position_11, v0_.locale_id AS locale_id_12, v0_.root_id AS root_id_13 FROM v4_route v0_ WHERE v0_.name = '_cmf_press';
0.38 ms (0.02%)	1	SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ WHERE v0_.code IS NULL Parameters: [] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ WHERE v0_.code IS NULL SELECT v0_.id AS id_0, v0_.refreshed_at AS refreshed_at_1, v0_.code AS code_2, v0_.exchange_rate AS exchange_rate_3, v0_.enabled AS enabled_4, v0_.base AS base_5, v0_.symbol AS symbol_6, v0_.label AS label_7, v0_.round AS round_8, v0_.apply_ecb AS apply_ecb_9, v0_.created_at AS created_at_10, v0_.updated_at AS updated_at_11 FROM v4_currency v0_ WHERE v0_.code IS NULL;
0.37 ms (0.01%)	1	SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM v4_locale v0_ WHERE v0_.code = ? Parameters: [`"de"`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM v4_locale v0_ WHERE v0_.code = ? SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM v4_locale v0_ WHERE v0_.code = 'de';
0.29 ms (0.01%)	1	SELECT p0_.osm_value AS osm_value_0 FROM poi_category p0_ WHERE p0_.osm_value IS NOT NULL Parameters: [] View formatted query View runnable query Explain query SELECT p0_.osm_value AS osm_value_0 FROM poi_category p0_ WHERE p0_.osm_value IS NOT NULL SELECT p0_.osm_value AS osm_value_0 FROM poi_category p0_ WHERE p0_.osm_value IS NOT NULL;
0.29 ms (0.01%)	1	SELECT t0.id AS id_1, t0.price AS price_2, t0.included_in_promotion AS included_in_promotion_3, t0.fee_id AS fee_id_4, t0.villa_id AS villa_id_5, t0.currency_id AS currency_id_6 FROM v4_villa_fee t0 WHERE t0.villa_id = ? Parameters: [`11002`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price AS price_2, t0.included_in_promotion AS included_in_promotion_3, t0.fee_id AS fee_id_4, t0.villa_id AS villa_id_5, t0.currency_id AS currency_id_6 FROM v4_villa_fee t0 WHERE t0.villa_id = ? SELECT t0.id AS id_1, t0.price AS price_2, t0.included_in_promotion AS included_in_promotion_3, t0.fee_id AS fee_id_4, t0.villa_id AS villa_id_5, t0.currency_id AS currency_id_6 FROM v4_villa_fee t0 WHERE t0.villa_id = 11002;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

105 Hits

15 Misses

51 Puts

Number of cache hits

Region	Hits
barely_updated	53
query_cache_region	52

Number of cache misses

Region	Misses
query_cache_region	6
barely_updated	9

Number of cache puts

Region	Puts
query_cache_region	6
barely_updated	45

Entities Mapping

Class	Mapping errors
FrontBundle\Entity\Website	No errors.
CommonBundle\Entity\Currency	No errors.
CommonBundle\Entity\Locale	No errors.
FrontBundle\Entity\Country	No errors.
FrontBundle\Entity\Location	No errors.
UserBundle\Entity\User	No errors.
FoxBundle\Entity\Client	No errors.
FoxBundle\Entity\CurrencyDay	No errors.
FoxBundle\Entity\PhoneOffice	No errors.
FoxBundle\Entity\TransferDetail	No errors.
FoxBundle\Entity\CurrencyRate	No errors.
FrontBundle\Entity\Search	No errors.
FoxBundle\Entity\Request	No errors.
Sylius\Component\Promotion\Model\Promotion	No errors.
FoxBundle\Entity\Promotion	No errors.
VillaBundle\Entity\Villa	The field 'VillaBundle\Entity\Villa#rankBebopPlace' has the property type 'int' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
FrontBundle\Entity\LocationTag	No errors.
FrontBundle\Entity\ConciergeService	No errors.
VillaBundle\Entity\Poi	No errors.
VillaBundle\Entity\PoiCategory	No errors.
VillaBundle\Entity\Review	No errors.
VillaBundle\Entity\VillaTag	No errors.
VillaBundle\Entity\VillaTranslation	No errors.
VillaBundle\Entity\VillaRate	No errors.
VillaBundle\Entity\Airport	No errors.
CommonBundle\Entity\MediaGallery	No errors.
VillaBundle\Entity\PersonInCharge	No errors.
FoxBundle\Entity\Tax	No errors.
VillaBundle\Entity\VillaTc	No errors.
VillaBundle\Entity\VillaDistribution	No errors.
FrontBundle\Entity\Destination	No errors.
VillaBundle\Entity\Unavailability	No errors.
VillaBundle\Entity\VillaFeature	No errors.
VillaBundle\Entity\VillaFee	No errors.
VillaBundle\Entity\Place	No errors.
VillaBundle\Entity\VillaConfiguration	No errors.
FoxBundle\Entity\VillaEvent	No errors.
FoxBundle\Entity\VillaInspection	No errors.
VillaBundle\Entity\Content	No errors.
VillaBundle\Entity\OfferBase	No errors.
VillaBundle\Entity\VillaLink	No errors.
VillaBundle\Entity\VillaMention	No errors.
FrontBundle\Entity\LocationPoiCount	No errors.
FrontBundle\Entity\LocationTranslation	No errors.
CommonBundle\Entity\MediaGalleryFile	No errors.
VillaBundle\Entity\ContentTranslation	No errors.
VillaBundle\Entity\Feature	No errors.
VillaBundle\Entity\FeatureTranslation	No errors.
VillaBundle\Entity\FeatureCategory	No errors.
VillaBundle\Entity\FeatureCategoryTranslation	No errors.
VillaBundle\Entity\OfferConfiguration	No errors.
CommonBundle\Entity\MediaFile	No errors.
FoxBundle\Entity\Message	No errors.
FoxBundle\Entity\WishTask	No errors.
FrontBundle\Entity\LandingPage	No errors.
FoxBundle\Entity\Folder	No errors.
VillaBundle\Entity\ReviewTranslation	No errors.
VillaBundle\Entity\PoiTranslation	No errors.
VillaBundle\Entity\PoiCategoryTranslation	No errors.
FrontBundle\Entity\ConciergeServiceTranslation	No errors.
Symfony\Component\Routing\Route	No errors.
Symfony\Cmf\Bundle\RoutingBundle\Model\Route	No errors.
FrontBundle\Entity\Route	No errors.
VillaBundle\Entity\Fee	No errors.
FoxBundle\Entity\Supplier	No errors.

Symfony Profiler

GET https://choco.villa-bali.com/de/villa/ubud/leona-valley-view-2br

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Number of cache misses

Number of cache puts

Entities Mapping