GET http://www.hotels-search.net/api/website/hotel/hotel-du-golf-rotana-palmeraie/it

Response
200 OK
IP
79.137.100.252
Profiled on
Token
6485ec

Query Metrics

356 Database Queries
24 Different statements
39.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
5.48 ms
(13.73%) 		36 
SELECT t0.id AS id_1, t0.base64 AS base64_2, t0.path AS path_3, t0.extension AS extension_4, t0.size AS size_5, t0.public_id AS public_id_6, t0.local_path AS local_path_7, t0.hotel_id AS hotel_id_8, t9.id AS id_10, t9.name AS name_11, t9.code AS code_12, t9.logo_id AS logo_id_13, t14.id AS id_15, t14.code AS code_16, t14.name AS name_17, t14.logo_id AS logo_id_18, t19.id AS id_20, t19.domain_name AS domain_name_21, t19.ipv4 AS ipv4_22, t19.name AS name_23, t19.city AS city_24, t19.google_analitycs AS google_analitycs_25, t19.booking_affliate_id AS booking_affliate_id_26, t19.secret AS secret_27, t19.created_at AS created_at_28, t19.updated_at AS updated_at_29, t19.keywords AS keywords_30, t19.mail AS mail_31, t19.page_size AS page_size_32, t19.meta_group AS meta_group_33, t19.scripts AS scripts_34, t19.cookieyes AS cookieyes_35, t19.under_maintenance AS under_maintenance_36, t19.blog_url AS blog_url_37, t19.preferred_blog_url AS preferred_blog_url_38, t19.ads_client AS ads_client_39, t19.ads_slot AS ads_slot_40, t19.logo_id AS logo_id_41, t19.default_language_id AS default_language_id_42, t19.hotels_reformulation_prompt_id AS hotels_reformulation_prompt_id_43, t19.hotels_translation_prompt_id AS hotels_translation_prompt_id_44, t19.page_reformulation_prompt_id AS page_reformulation_prompt_id_45, t19.page_translation_prompt_id AS page_translation_prompt_id_46, t19.event_reformulation_prompt_id AS event_reformulation_prompt_id_47, t19.event_translation_prompt_id AS event_translation_prompt_id_48, t19.page_hotel_reformulation_prompt_id AS page_hotel_reformulation_prompt_id_49, t19.page_hotel_translation_prompt_id AS page_hotel_translation_prompt_id_50, t19.event_hotel_reformulation_prompt_id AS event_hotel_reformulation_prompt_id_51, t19.event_hotel_translation_prompt_id AS event_hotel_translation_prompt_id_52, t19.icon_id AS icon_id_53 FROM media t0 LEFT JOIN language t9 ON t9.logo_id = t0.id LEFT JOIN currency t14 ON t14.logo_id = t0.id LEFT JOIN website t19 ON t19.logo_id = t0.id WHERE t0.id = ?
Parameters: 
[
  333264154
]
View formatted query    View runnable query    Explain query
4.24 ms
(10.64%) 		20 
SELECT t0.id AS id_1, t0.base64 AS base64_2, t0.path AS path_3, t0.extension AS extension_4, t0.size AS size_5, t0.public_id AS public_id_6, t0.local_path AS local_path_7, t0.hotel_id AS hotel_id_8, t9.id AS id_10, t9.name AS name_11, t9.code AS code_12, t9.logo_id AS logo_id_13, t14.id AS id_15, t14.code AS code_16, t14.name AS name_17, t14.logo_id AS logo_id_18, t19.id AS id_20, t19.domain_name AS domain_name_21, t19.ipv4 AS ipv4_22, t19.name AS name_23, t19.city AS city_24, t19.google_analitycs AS google_analitycs_25, t19.booking_affliate_id AS booking_affliate_id_26, t19.secret AS secret_27, t19.created_at AS created_at_28, t19.updated_at AS updated_at_29, t19.keywords AS keywords_30, t19.mail AS mail_31, t19.page_size AS page_size_32, t19.meta_group AS meta_group_33, t19.scripts AS scripts_34, t19.cookieyes AS cookieyes_35, t19.under_maintenance AS under_maintenance_36, t19.blog_url AS blog_url_37, t19.preferred_blog_url AS preferred_blog_url_38, t19.ads_client AS ads_client_39, t19.ads_slot AS ads_slot_40, t19.logo_id AS logo_id_41, t19.default_language_id AS default_language_id_42, t19.hotels_reformulation_prompt_id AS hotels_reformulation_prompt_id_43, t19.hotels_translation_prompt_id AS hotels_translation_prompt_id_44, t19.page_reformulation_prompt_id AS page_reformulation_prompt_id_45, t19.page_translation_prompt_id AS page_translation_prompt_id_46, t19.event_reformulation_prompt_id AS event_reformulation_prompt_id_47, t19.event_translation_prompt_id AS event_translation_prompt_id_48, t19.page_hotel_reformulation_prompt_id AS page_hotel_reformulation_prompt_id_49, t19.page_hotel_translation_prompt_id AS page_hotel_translation_prompt_id_50, t19.event_hotel_reformulation_prompt_id AS event_hotel_reformulation_prompt_id_51, t19.event_hotel_translation_prompt_id AS event_hotel_translation_prompt_id_52, t19.icon_id AS icon_id_53 FROM media t0 LEFT JOIN language t9 ON t9.logo_id = t0.id LEFT JOIN currency t14 ON t14.logo_id = t0.id LEFT JOIN website t19 ON t19.logo_id = t0.id WHERE t0.hotel_id = ?
Parameters: 
[
  348751
]
View formatted query    View runnable query    Explain query
4.11 ms
(10.30%) 		31 
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.keywords AS keywords_5, t0.is_engines_search_allowed AS is_engines_search_allowed_6, t0.type AS type_7, t0.h1 AS h1_8, t0.description AS description_9, t0.name AS name_10, t0.is_base AS is_base_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.page_size AS page_size_14, t0.snippet_tags AS snippet_tags_15, t0.draft AS draft_16, t0.page_order AS page_order_17, t0.ai_input AS ai_input_18, t0.waiting_generation AS waiting_generation_19, t0.waiting_translation AS waiting_translation_20, t0.reformulated AS reformulated_21, t0.translated AS translated_22, t0.task_on_going AS task_on_going_23, t0.accept_translation AS accept_translation_24, t0.accept_generation AS accept_generation_25, t0.event_start_date AS event_start_date_26, t0.event_end_date AS event_end_date_27, t0.location_name AS location_name_28, t0.street_address AS street_address_29, t0.address_locality AS address_locality_30, t0.postal_code AS postal_code_31, t0.address_region AS address_region_32, t0.address_country AS address_country_33, t0.organizer_name AS organizer_name_34, t0.organizer_url AS organizer_url_35, t0.latitude AS latitude_36, t0.longitude AS longitude_37, t0.thematique_id AS thematique_id_38, t0.website_id AS website_id_39, t0.parent_id AS parent_id_40, t0.language_id AS language_id_41, t0.base_page_id AS base_page_id_42, t0.photo_id AS photo_id_43, t0.author_id AS author_id_44 FROM page t0 WHERE t0.base_page_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3.79 ms
(9.51%) 		57 
SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.value AS value_7, t0.is_variant AS is_variant_8, t0.created_by_id AS created_by_id_9, t0.variant_id AS variant_id_10, t0.language_id AS language_id_11, t0.website_id AS website_id_12 FROM variable t0 WHERE t0.variant_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3.69 ms
(9.25%) 		31 
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.keywords AS keywords_5, t0.is_engines_search_allowed AS is_engines_search_allowed_6, t0.type AS type_7, t0.h1 AS h1_8, t0.description AS description_9, t0.name AS name_10, t0.is_base AS is_base_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.page_size AS page_size_14, t0.snippet_tags AS snippet_tags_15, t0.draft AS draft_16, t0.page_order AS page_order_17, t0.ai_input AS ai_input_18, t0.waiting_generation AS waiting_generation_19, t0.waiting_translation AS waiting_translation_20, t0.reformulated AS reformulated_21, t0.translated AS translated_22, t0.task_on_going AS task_on_going_23, t0.accept_translation AS accept_translation_24, t0.accept_generation AS accept_generation_25, t0.event_start_date AS event_start_date_26, t0.event_end_date AS event_end_date_27, t0.location_name AS location_name_28, t0.street_address AS street_address_29, t0.address_locality AS address_locality_30, t0.postal_code AS postal_code_31, t0.address_region AS address_region_32, t0.address_country AS address_country_33, t0.organizer_name AS organizer_name_34, t0.organizer_url AS organizer_url_35, t0.latitude AS latitude_36, t0.longitude AS longitude_37, t0.thematique_id AS thematique_id_38, t0.website_id AS website_id_39, t0.parent_id AS parent_id_40, t0.language_id AS language_id_41, t0.base_page_id AS base_page_id_42, t0.photo_id AS photo_id_43, t0.author_id AS author_id_44 FROM page t0 WHERE t0.parent_id = ?
Parameters: 
[
  177
]
View formatted query    View runnable query    Explain query
2.80 ms
(7.03%) 		31 
SELECT t0.id AS id_1, t0.description AS description_2, t0.snippet AS snippet_3, t0.hotel_order AS hotel_order_4, t0.ai_input AS ai_input_5, t0.distance_in_minutes AS distance_in_minutes_6, t0.waiting_reformulation AS waiting_reformulation_7, t0.waiting_translation AS waiting_translation_8, t0.reformulated AS reformulated_9, t0.translated AS translated_10, t0.page_id AS page_id_11, t0.hotel_id AS hotel_id_12, t0.author_id AS author_id_13 FROM page_hotel t0 WHERE t0.page_id = ?
Parameters: 
[
  177
]
View formatted query    View runnable query    Explain query
2.56 ms
(6.41%) 		25 
SELECT t0.id AS id_1, t0.description_translated AS description_translated_2, t0.snippet_translated AS snippet_translated_3, t0.thematique_name AS thematique_name_4, t0.thematique_slug AS thematique_slug_5, t0.title AS title_6, t0.meta_description AS meta_description_7, t0.is_engines_search_allowed AS is_engines_search_allowed_8, t0.small_text AS small_text_9, t0.snippet_shown AS snippet_shown_10, t0.question AS question_11, t0.answer AS answer_12, t0.task_on_going AS task_on_going_13, t0.accept_translation AS accept_translation_14, t0.accept_reformulation AS accept_reformulation_15, t0.h1 AS h1_16, t0.language_id AS language_id_17, t0.page_hotel_id AS page_hotel_id_18, t0.thematique_id AS thematique_id_19, t0.website_hotel_id AS website_hotel_id_20, t0.author_id AS author_id_21, t0.faq_id AS faq_id_22 FROM translateddata t0 WHERE t0.thematique_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
2.44 ms
(6.11%) 		19 
SELECT t0.id AS id_1, t0.hotel_name AS hotel_name_2, t0.city_name_en AS city_name_en_3, t0.accommodation_type_name AS accommodation_type_name_4, t0.unit_configuration_label AS unit_configuration_label_5, t0.city_trans AS city_trans_6, t0.ufi AS ufi_7, t0.review_score AS review_score_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.district_id AS district_id_11, t0.is_genius_deal AS is_genius_deal_12, t0.address AS address_13, t0.is_free_cancellable AS is_free_cancellable_14, t0.is_city_center AS is_city_center_15, t0.country AS country_16, t0.hotel_id AS hotel_id_17, t0.district AS district_18, t0.zip AS zip_19, t0.currencycode AS currencycode_20, t0.min_total_price AS min_total_price_21, t0.city AS city_22, t0.gross_price AS gross_price_23, t0.countrycode AS countrycode_24, t0.url AS url_25, t0.distance_to_cc AS distance_to_cc_26, t0.timezone AS timezone_27, t0.preferred AS preferred_28, t0.review_score_word AS review_score_word_29, t0.max_photo_url AS max_photo_url_30, t0.description AS description_31, t0.is_mobile_deal AS is_mobile_deal_32, t0.ribbon_text AS ribbon_text_33, t0.children_not_allowed AS children_not_allowed_34, t0.native_ads_cpc AS native_ads_cpc_35, t0.cc_required AS cc_required_36, t0.is_wholesaler_candidate AS is_wholesaler_candidate_37, t0.is_beach_front AS is_beach_front_38, t0.soldout AS soldout_39, t0.is_geo_rate AS is_geo_rate_40, t0.default_language AS default_language_41, t0.is_smart_deal AS is_smart_deal_42, t0.hotel_has_vb_boost AS hotel_has_vb_boost_43, t0.class AS class_44, t0.genius_discount_percentage AS genius_discount_percentage_45, t0.extended AS extended_46, t0.in_best_district AS in_best_district_47, t0.is_no_prepayment_block AS is_no_prepayment_block_48, t0.gross_amount_per_night AS gross_amount_per_night_49, t0.review_nr AS review_nr_50, t0.country_trans AS country_trans_51, t0.default_wishlist_name AS default_wishlist_name_52, t0.cant_book AS cant_book_53, t0.class_is_estimated AS class_is_estimated_54, t0.max_photo_base64 AS max_photo_base64_55, t0.slug AS slug_56 FROM hotel t0 WHERE t0.id = ?
Parameters: 
[
  98208
]
View formatted query    View runnable query    Explain query
2.14 ms
(5.35%) 		31 
SELECT t0.id AS id_1 FROM faq t0 INNER JOIN faq_page ON t0.id = faq_page.faq_id WHERE faq_page.page_id = ?
Parameters: 
[
  177
]
View formatted query    View runnable query    Explain query
2.13 ms
(5.35%) 		31 
SELECT t0.id AS id_1, t0.name AS name_2 FROM thematique t0 INNER JOIN page_thematique ON t0.id = page_thematique.thematique_id WHERE page_thematique.page_id = ?
Parameters: 
[
  177
]
View formatted query    View runnable query    Explain query
1.52 ms
(3.81%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.keywords AS keywords_5, t0.is_engines_search_allowed AS is_engines_search_allowed_6, t0.type AS type_7, t0.h1 AS h1_8, t0.description AS description_9, t0.name AS name_10, t0.is_base AS is_base_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.page_size AS page_size_14, t0.snippet_tags AS snippet_tags_15, t0.draft AS draft_16, t0.page_order AS page_order_17, t0.ai_input AS ai_input_18, t0.waiting_generation AS waiting_generation_19, t0.waiting_translation AS waiting_translation_20, t0.reformulated AS reformulated_21, t0.translated AS translated_22, t0.task_on_going AS task_on_going_23, t0.accept_translation AS accept_translation_24, t0.accept_generation AS accept_generation_25, t0.event_start_date AS event_start_date_26, t0.event_end_date AS event_end_date_27, t0.location_name AS location_name_28, t0.street_address AS street_address_29, t0.address_locality AS address_locality_30, t0.postal_code AS postal_code_31, t0.address_region AS address_region_32, t0.address_country AS address_country_33, t0.organizer_name AS organizer_name_34, t0.organizer_url AS organizer_url_35, t0.latitude AS latitude_36, t0.longitude AS longitude_37, t0.thematique_id AS thematique_id_38, t0.website_id AS website_id_39, t0.parent_id AS parent_id_40, t0.language_id AS language_id_41, t0.base_page_id AS base_page_id_42, t0.photo_id AS photo_id_43, t0.author_id AS author_id_44 FROM page t0 WHERE t0.website_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
1.48 ms
(3.71%) 		25 
SELECT t0.id AS id_1, t0.name AS name_2 FROM thematique t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
1.18 ms
(2.95%) 		1 
SELECT t0.id AS id_1, t0.hotel_name AS hotel_name_2, t0.city_name_en AS city_name_en_3, t0.accommodation_type_name AS accommodation_type_name_4, t0.unit_configuration_label AS unit_configuration_label_5, t0.city_trans AS city_trans_6, t0.ufi AS ufi_7, t0.review_score AS review_score_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.district_id AS district_id_11, t0.is_genius_deal AS is_genius_deal_12, t0.address AS address_13, t0.is_free_cancellable AS is_free_cancellable_14, t0.is_city_center AS is_city_center_15, t0.country AS country_16, t0.hotel_id AS hotel_id_17, t0.district AS district_18, t0.zip AS zip_19, t0.currencycode AS currencycode_20, t0.min_total_price AS min_total_price_21, t0.city AS city_22, t0.gross_price AS gross_price_23, t0.countrycode AS countrycode_24, t0.url AS url_25, t0.distance_to_cc AS distance_to_cc_26, t0.timezone AS timezone_27, t0.preferred AS preferred_28, t0.review_score_word AS review_score_word_29, t0.max_photo_url AS max_photo_url_30, t0.description AS description_31, t0.is_mobile_deal AS is_mobile_deal_32, t0.ribbon_text AS ribbon_text_33, t0.children_not_allowed AS children_not_allowed_34, t0.native_ads_cpc AS native_ads_cpc_35, t0.cc_required AS cc_required_36, t0.is_wholesaler_candidate AS is_wholesaler_candidate_37, t0.is_beach_front AS is_beach_front_38, t0.soldout AS soldout_39, t0.is_geo_rate AS is_geo_rate_40, t0.default_language AS default_language_41, t0.is_smart_deal AS is_smart_deal_42, t0.hotel_has_vb_boost AS hotel_has_vb_boost_43, t0.class AS class_44, t0.genius_discount_percentage AS genius_discount_percentage_45, t0.extended AS extended_46, t0.in_best_district AS in_best_district_47, t0.is_no_prepayment_block AS is_no_prepayment_block_48, t0.gross_amount_per_night AS gross_amount_per_night_49, t0.review_nr AS review_nr_50, t0.country_trans AS country_trans_51, t0.default_wishlist_name AS default_wishlist_name_52, t0.cant_book AS cant_book_53, t0.class_is_estimated AS class_is_estimated_54, t0.max_photo_base64 AS max_photo_base64_55, t0.slug AS slug_56 FROM hotel t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "hotel-du-golf-rotana-palmeraie"
]
View formatted query    View runnable query    Explain query
0.82 ms
(2.06%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.value AS value_7, t0.is_variant AS is_variant_8, t0.created_by_id AS created_by_id_9, t0.variant_id AS variant_id_10, t0.language_id AS language_id_11, t0.website_id AS website_id_12 FROM variable t0 WHERE t0.website_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.31 ms
(0.78%) 		6 
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.logo_id AS logo_id_4 FROM language t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
0.24 ms
(0.61%) 		2 
SELECT t0.id AS id_1, t0.description_translated AS description_translated_2, t0.snippet_translated AS snippet_translated_3, t0.thematique_name AS thematique_name_4, t0.thematique_slug AS thematique_slug_5, t0.title AS title_6, t0.meta_description AS meta_description_7, t0.is_engines_search_allowed AS is_engines_search_allowed_8, t0.small_text AS small_text_9, t0.snippet_shown AS snippet_shown_10, t0.question AS question_11, t0.answer AS answer_12, t0.task_on_going AS task_on_going_13, t0.accept_translation AS accept_translation_14, t0.accept_reformulation AS accept_reformulation_15, t0.h1 AS h1_16, t0.language_id AS language_id_17, t0.page_hotel_id AS page_hotel_id_18, t0.thematique_id AS thematique_id_19, t0.website_hotel_id AS website_hotel_id_20, t0.author_id AS author_id_21, t0.faq_id AS faq_id_22 FROM translateddata t0 WHERE t0.author_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.17 ms
(0.43%) 		1 
SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.ipv4 AS ipv4_3, t0.name AS name_4, t0.city AS city_5, t0.google_analitycs AS google_analitycs_6, t0.booking_affliate_id AS booking_affliate_id_7, t0.secret AS secret_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.keywords AS keywords_11, t0.mail AS mail_12, t0.page_size AS page_size_13, t0.meta_group AS meta_group_14, t0.scripts AS scripts_15, t0.cookieyes AS cookieyes_16, t0.under_maintenance AS under_maintenance_17, t0.blog_url AS blog_url_18, t0.preferred_blog_url AS preferred_blog_url_19, t0.ads_client AS ads_client_20, t0.ads_slot AS ads_slot_21, t0.logo_id AS logo_id_22, t0.default_language_id AS default_language_id_23, t0.hotels_reformulation_prompt_id AS hotels_reformulation_prompt_id_24, t0.hotels_translation_prompt_id AS hotels_translation_prompt_id_25, t0.page_reformulation_prompt_id AS page_reformulation_prompt_id_26, t0.page_translation_prompt_id AS page_translation_prompt_id_27, t0.event_reformulation_prompt_id AS event_reformulation_prompt_id_28, t0.event_translation_prompt_id AS event_translation_prompt_id_29, t0.page_hotel_reformulation_prompt_id AS page_hotel_reformulation_prompt_id_30, t0.page_hotel_translation_prompt_id AS page_hotel_translation_prompt_id_31, t0.event_hotel_reformulation_prompt_id AS event_hotel_reformulation_prompt_id_32, t0.event_hotel_translation_prompt_id AS event_hotel_translation_prompt_id_33, t0.icon_id AS icon_id_34 FROM website t0 WHERE t0.secret = ? LIMIT 1
Parameters: 
[
  "ea3eb152c4ab5ced22082a984f463f50"
]
View formatted query    View runnable query    Explain query
0.14 ms
(0.36%) 		1 
SELECT t0.id AS id_1, t0.description_translated AS description_translated_2, t0.snippet_translated AS snippet_translated_3, t0.thematique_name AS thematique_name_4, t0.thematique_slug AS thematique_slug_5, t0.title AS title_6, t0.meta_description AS meta_description_7, t0.is_engines_search_allowed AS is_engines_search_allowed_8, t0.small_text AS small_text_9, t0.snippet_shown AS snippet_shown_10, t0.question AS question_11, t0.answer AS answer_12, t0.task_on_going AS task_on_going_13, t0.accept_translation AS accept_translation_14, t0.accept_reformulation AS accept_reformulation_15, t0.h1 AS h1_16, t0.language_id AS language_id_17, t0.page_hotel_id AS page_hotel_id_18, t0.thematique_id AS thematique_id_19, t0.website_hotel_id AS website_hotel_id_20, t0.author_id AS author_id_21, t0.faq_id AS faq_id_22 FROM translateddata t0 WHERE t0.website_hotel_id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.33%) 		1 
SELECT t0.id AS id_1, t0.hotel_order AS hotel_order_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.waiting_reformulation AS waiting_reformulation_5, t0.waiting_translation AS waiting_translation_6, t0.reformulated AS reformulated_7, t0.translated AS translated_8, t0.website_id AS website_id_9, t0.hotel_id AS hotel_id_10, t0.author_id AS author_id_11 FROM website_hotel t0 WHERE t0.website_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.12 ms
(0.31%) 		1 
SELECT t0.id AS id_1, t0.hotel_order AS hotel_order_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.waiting_reformulation AS waiting_reformulation_5, t0.waiting_translation AS waiting_translation_6, t0.reformulated AS reformulated_7, t0.translated AS translated_8, t0.website_id AS website_id_9, t0.hotel_id AS hotel_id_10, t0.author_id AS author_id_11 FROM website_hotel t0 WHERE t0.hotel_id = ? AND t0.website_id = ? LIMIT 1
Parameters: 
[
  348751
  1
]
View formatted query    View runnable query    Explain query
0.12 ms
(0.29%) 		1 
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.default_description AS default_description_5, t0.photo_id AS photo_id_6 FROM virtual_author t0 INNER JOIN virtual_author_website ON t0.id = virtual_author_website.virtual_author_id WHERE virtual_author_website.website_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.11 ms
(0.28%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.logo_id AS logo_id_4 FROM language t0 INNER JOIN website_language ON t0.id = website_language.language_id WHERE website_language.website_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.22%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.logo_id AS logo_id_4 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "it"
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.18%) 		1 
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.default_description AS default_description_5, t0.photo_id AS photo_id_6 FROM virtual_author t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Hotel No errors.
App\Entity\Media No errors.
App\Entity\HotelPrice No errors.
App\Entity\PageHotel No errors.
App\Entity\WebsiteHotel No errors.
App\Entity\AffiliateRedirection No errors.
App\Entity\Website No errors.
App\Entity\Language No errors.
App\Entity\AIPrompt No errors.
App\Entity\Page No errors.
App\Entity\VirtualAuthor No errors.
App\Entity\Variable No errors.
App\Entity\NewsletterRequest No errors.
App\Entity\Faq No errors.
App\Entity\Translateddata No errors.
App\Entity\Thematique No errors.
App\Entity\Currency No errors.
App\Entity\User No errors.