Hotel del Coronado #5170
-
Price per person
- Adult
- £1,663
From super chic urban retreats in the Big Apple to spacious suites in the City of Angels full of Tinseltown glamour, the US have much to offer the luxury holidaymaker. With the Kenwood Travel US team as your guide, America’s most iconic and luxurious hotels are waiting to transform your holiday into the trip of a lifetime. Our dedicated team are on hand to ensure you get the deluxe dream package you deserve at a competitive price. We've listed out top luxury hotels in the US below.
Forty years of experience makes us a well-travelled, experienced team of destination specialists, and we have handpicked the most exquisite accommodation the country has to offer. Take a look below and find the right hotel for you. Alternatively, talk to our experts direct on 0203 868 1341 and enjoy the friendly and personalised service our repeat bookers come back for time and again. Because of its endless diversity, the USA lends itself to multi-centre holidays. Or why not join the American road trip tradition and discover the country's luxury hotels on your own schedule? Or see more on a hosted tour? If that sounds like you, check out the tours we have on offer in famous destinations like Las Vegas.
We’re on hand seven days a week here in Moorgate - City of London, call today
Reservations | |
Monday - Friday | 09:00 - 20:00 |
Saturday | 09:00 - 16:00 |
Sunday | 10:00 - 17:00 |
Bank Holidays | 10:00 - 16:00 |
Customer Service | |
Monday - Friday | 09:00 - 17:30 |
Saturday | 09:00 - 16:00 |
Bank Holidays | 10:00 - 16:00 |
There is some important information we would like to share with you as you continue your booking.
0 of 0App\Models\Travel\Destination {#5609 ▼ #connection: "mysql" #table: "pages" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:22 [▶ "id" => 144 "_lft" => 3447 "_rgt" => 4028 "parent_id" => null "layout_id" => 17 "name" => "USA" "slug" => "usa-holidays" "identifier" => null "metadata" => "{"image": "2023/09/7/Hero-Slider_002.jpg", "links": [{"url": "/usa-holidays/self-drives", "name": "USA Self Drives", "group": null}, {"url": "/usa-holidays/multi-centre-holidays", "name": "Multi Centre Holidays", "group": null}, {"url": "/cruiseholiday/north-america/usa", "name": "USA Cruises", "group": null}, {"url": "/florida-holidays", "name": "Florida Holidays", "group": null}, {"url": "/usa-holidays/luxury", "name": "Luxury Holidays", "group": null}, {"url": "/hawaii-holidays", "name": "Hawaii Holidays", "group": null}], "theme": null, "title": "USA Holidays", "search": {"popup": {"title": null, "enable": null, "message": null, "rolling_days": {"to": null, "from": null}}, "flight": {"legs": null, "connecting": null, "direct_tba": null, "cutoff_time": null, "exact_match": "y", "max_results": null, "widen_search": "n", "flights_arrive": ["1"], "search_classes": ["1"], "widen_search_tba": null, "search_all_classes": "n", "search_mixed_classes": "n"}, "keywords": null, "property": {"search_by": "ResortID", "alternative_room": null}, "region_id": null, "search_by": null, "cutoff_date": {"to": null, "from": null}, "loading_text": null, "loading_image": "2024/10/11/USA.jpg", "max_child_age": "17", "allow_0_adults": null, "loading_image_id": null, "departure_airports": ["G10", "A151", "A11"]}, "content": "<h2>Luxury Holidays to the USA</h2>\r\n<p>At Kenwood Travel we offer you an extensive range of luxury holidays to the USA, tailor made to suit all of your travelling needs. From romantic breaks, weddings and honeymoons to holidays that cater for families or adults only, our advisors are waiting to create your dream holiday package. Give them a call so you can start looking forward to that holiday of a lifetime. </p>\r\n<h2>Our Top Pick Hotels in the USA</h2>\r\n<p>Take advantage of our range of spectacular USA hotels and call us now. We deal with some of the biggest names in the USA, located in New York including <a href=\"/usa-holidays/east/new-york/the-langham-new-york-fifth-avenue-hotel\">The Langham, New York, Fifth Avenue</a>, and <a href=\"/usa-holidays/east/new-york/the-plaza-hotel-hotel\">The Plaza Hotel</a>.<br /><br />In the 'City of Angels', Los Angeles, we would suggest looking at the iconic <a href=\"/usa-holidays/california/los-angeles/beverly-hills/beverly-wilshire-a-four-seasons-hotel-hotel\">Beverly Wilshire, A Four Seasons Hotel</a> or the sun-kissed <a href=\"/usa-holidays/california/los-angeles/santa-monica/shutters-on-the-beach-hotel\">Shutters on the Beach</a>. Just a short distance to Nevada the choice of hotels in Las Vegas is vast, on our pick we recommend the <a href=\"/usa-holidays/west/las-vegas/bellagio-hotel\">Bellagio</a> and the world-famous <a href=\"/usa-holidays/west/las-vegas/mgm-grand-hotel-casino-hotel\">MGM Grand Hotel & Casino</a> where the world's major boxing events are held.</p>\r\n<p>There are of course many, many more fabulous hotels throughout the USA and our experts are here to offer our advice.</p>\r\n<h2>Things To Do</h2>\r\n<p>Get your kicks on Route 66, shop ‘til you drop on Rodeo Drive, gaze across the bay from Golden Gate Bridge or simply bask in the sun on Malibu Beach. The names of America’s streets and buildings are synonymous with the glamorous image we have of the place. Its larger-than-life landmarks seem to have been burned onto our collective cultural retina from an early age, trickling into our consciousness by way of rock ‘n’ roll songs and Hollywood movies, Coca Cola and Coney Island. Watching and listening from afar is one thing, being there in person is something else entirely. Become the protagonist in your very own American story and discover amazing things to do around every corner of this famous landscape.</p>\r\n<h2>Main Events</h2>\r\n<p>Super Bowl Sunday (1st Sunday in February) – Superbowl parties with friends are the way to go when tickets are hard to come by. Get out the chips and dips, crack a beer and cheer on your team. </p>\r\n<p>Saint Patrick's Day (17th March) – Commemorating the patron saint of Ireland is a major celebration in the US. Many cities have a strong Irish-American population but few go as far as the windy city: The Chicago River is dyed green in honour of the festivities. </p>\r\n<p>Thanksgiving (November 27th) – The quintessential American ‘holiday’. Families and friends gather to give thanks while Macy's department store in New York hosts one of the largest and most colourful parades in the annual calendar. Not to be missed.</p>\r\n<h2>Weather</h2>\r\n<p>Due to its rather massive size the climate of the USA is quite varied. The northwest of the country, for instance, can get quite cold in the winter and sees rain all year round. The northeast gets quite warm in the summer but can see heavy snowfall during the winter months.<br /><br />The southeast and southwest, on the other hand, tend to be much warmer with milder winters and hotter summers. The southwest region, encompassing the likes of Texas, Arizona and Louisiana is the hotter part of the country although will see the occasional tornado and thunderstorms.</p>\r\n<h2>USA Holidays 2025 & 2026</h2>\r\n<p>We have some fantastic USA holidays available for 2025 / 2026. Please search our deals using our onsite search facility or call one of the Kenwood team now on <strong>0203 868 1341 </strong> to snap up your very own Stateside discount. We can also tailor-make your holiday with a <a href=\"/caribbean-holidays/jamaica/\">Jamaican</a> or <a href=\"/caribbean-holidays/\">Caribbean</a> destination, so give us a call and see where that phone call can take you!</p>\r\n<h2>Visas</h2>\r\n<p>All British passport holders must have a full 10-year British Passport that is valid for at least six months after their return to the UK. A USA visa or waiver form/ESTA MUST be obtained prior to your visit. <a href=\"https://esta.cbp.dhs.gov/esta/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Apply online</a> for your ESTA at least 72 hours before travelling. If you have a passport showing you are a UK citizen then you are able to obtain a US visa, or ESTA, under the Visa Waiver Scheme. However, for clients travelling to the States after 1st April 2016 you will need to hold a passport with an integrated chip. For security reasons this holds all of your personal information, as stated on the passport, but in digital format. If your passport does not have this feature then you will need to renew the passport before your departure date. The Passport Office will add up to 9 months of any unexpired time and you can recognise the chip by a gold symbol, resembling a camera, on the bottom of the front cover of the passport.</p>", "deposit": null, "image_id": null, "subtitle": "All-American, all within your reach", "gallery_id": "7134", "switch_off": {"rooms": "1", "venues": "1"}, "destination": {"type": "hotel", "experts": {"title": null, "sub_title": null}, "weather": null, "pod_name": null, "documents": {"visa_upload": null, "visa_upload_id": null, "visa_information": "<p><strong>Entry Requirements:</strong></p>\r\n<p>Please <a title=\"Entry Requirements\" href=\"https://www.gov.uk/foreign-travel-advice/usa/entry-requirements\">click here</a> for full information on visa and passport information for USA. You will be required to apply for an ESTA before travel. Please note Kenwood Travel hold no responsibility if you are denied travel due to not meeting requirement of travel.</p>\r\n<p><strong>Resort Fee</strong></p>\r\n<p>Please note that most hotels in the USA will charge a per night resort fee and rate is variable from hotel to hotel. Please speak to a member of our team who can find out the specific charge for your hotel.</p>\r\n<p><strong>Travel Insurance</strong></p>\r\n<p>It is a condition of your contract with us that you have adequate travel insurance in place to cover you and your party against the cost of cancellation by you, the cost of assistance (including your repatriation) in the event of delays, accident, illness, death, loss of baggage and possessions. It is your responsibility to ensure that you have adequate travel insurance in place, we will not be responsible for any losses howsoever arising, in respect of which insurance cover would otherwise have been available</p>\r\n<p><strong>Important Information</strong></p>\r\n<p>Our Prices Please note as a UK Tour Operator some of our packaged and non packaged rates may not be available to NON UK citizens, or expatriates living abroad. Failure to advise Kenwood Travel of your status may result in additional costs or cancel charges, for which you would be liable.</p>\r\n<p> </p>", "visa_information_title": "USA Information"}, "map_block": {"title": null, "subtitle": null}, "hotels_tab": {"title": null, "sub_title": null}, "venues_list": {"title": null, "subtitle": null}, "contact_email": "usa@kenwoodtravel.co.uk", "contact_phone": "0203 868 1341", "multi_centres": {"link": null, "title": null, "see_all": null, "sub_title": null}, "children_block": {"image": "2020/12/9/Yellow cabs in Manhattan, NYC. The taxicabs of New York City at night Time Square.jpg", "title": "Top USA Destinations", "image_id": null, "subtitle": null}, "siblings_block": {"title": null, "subtitle": null}, "short_description": "From Tinseltown to the Big Apple - our Stateside guide", "useful_information": {"clock": null, "currency": null, "language": null, "location": null, "passport": null, "telephone": null, "flying-time": null}, "top_properties_block": {"title": "Top Picks", "subtitle": null, "more_button_page": null, "more_button_title": null}}, "button_title": null, "hero_content": "<p>Whether you’re looking to take a bite of the ‘Big Apple’ with a city break to New York, experience the bright neon lights and lavish lifestyle of Las Vegas, embark on a fun-filled family adventure to Florida or simply kick back on a chilled-out San Diego beach, our team of USA Specialists can help create your very own American Dream.</p>", "mobile_image": null, "flight_markup": null, "hide_on_search": "0", "button_page_url": null, "cruise_packages": {"page": null, "title": null}, "hide_search_bar": null, "mobile_image_id": null} ◀{"image": "2023/09/7/Hero-Slider_002.jpg", "links": [{"url": "/usa-holidays/self-drives", "name": "USA Self Drives", "group": null}, {"url": "/usa-holidays/mult ▶" "canonical" => null "active" => 1 "cruise_active" => 1 "fly_drive_active" => 1 "type" => 3 "created_at" => "2019-12-09 13:14:02" "updated_at" => "2025-04-01 10:37:59" "deleted_at" => null "drafted_at" => null "expects_approval" => 0 "meta_content" => """ <h2>Luxury Holidays to the USA</h2>\r\n <p>At Kenwood Travel we offer you an extensive range of luxury holidays to the USA, tailor made to suit all of your travelling needs. From romantic breaks, weddings and honeymoons to holidays that cater for families or adults only, our advisors are waiting to create your dream holiday package. Give them a call so you can start looking forward to that holiday of a lifetime. </p>\r\n ◀<p>At Kenwood Travel we offer you an extensive range of luxury holidays to the USA, tailor made to suit all of your travelling needs. From romantic breaks, wedd ▶ <h2>Our Top Pick Hotels in the USA</h2>\r\n <p>Take advantage of our range of spectacular USA hotels and call us now. We deal with some of the biggest names in the USA, located in New York including <a href="/usa-holidays/east/new-york/the-langham-new-york-fifth-avenue-hotel">The Langham, New York, Fifth Avenue</a>, and <a href="/usa-holidays/east/new-york/the-plaza-hotel-hotel">The Plaza Hotel</a>.<br /><br />In the 'City of Angels', Los Angeles, we would suggest looking at the iconic <a href="/usa-holidays/california/los-angeles/beverly-hills/beverly-wilshire-a-four-seasons-hotel-hotel">Beverly Wilshire, A Four Seasons Hotel</a> or the sun-kissed <a href="/usa-holidays/california/los-angeles/santa-monica/shutters-on-the-beach-hotel">Shutters on the Beach</a>. Just a short distance to Nevada the choice of hotels in Las Vegas is vast, on our pick we recommend the <a href="/usa-holidays/west/las-vegas/bellagio-hotel">Bellagio</a> and the world-famous <a href="/usa-holidays/west/las-vegas/mgm-grand-hotel-casino-hotel">MGM Grand Hotel & Casino</a> where the world's major boxing events are held.</p>\r\n ◀<p>Take advantage of our range of spectacular USA hotels and call us now. We deal with some of the biggest names in the USA, located in New York including <a hr ▶ <p>There are of course many, many more fabulous hotels throughout the USA and our experts are here to offer our advice.</p>\r\n <h2>Things To Do</h2>\r\n <p>Get your kicks on Route 66, shop ‘til you drop on Rodeo Drive, gaze across the bay from Golden Gate Bridge or simply bask in the sun on Malibu Beach. The names of America’s streets and buildings are synonymous with the glamorous image we have of the place. Its larger-than-life landmarks seem to have been burned onto our collective cultural retina from an early age, trickling into our consciousness by way of rock ‘n’ roll songs and Hollywood movies, Coca Cola and Coney Island. Watching and listening from afar is one thing, being there in person is something else entirely. Become the protagonist in your very own American story and discover amazing things to do around every corner of this famous landscape.</p>\r\n ◀<p>Get your kicks on Route 66, shop ‘til you drop on Rodeo Drive, gaze across the bay from Golden Gate Bridge or simply bask in the sun on Malibu Beach. T ▶ <h2>Main Events</h2>\r\n <p>Super Bowl Sunday (1st Sunday in February) – Superbowl parties with friends are the way to go when tickets are hard to come by. Get out the chips and dips, crack a beer and cheer on your team. </p>\r\n ◀<p>Super Bowl Sunday (1st Sunday in February) – Superbowl parties with friends are the way to go when tickets are hard to come by. Get out the chips and d ▶ <p>Saint Patrick's Day (17th March) – Commemorating the patron saint of Ireland is a major celebration in the US. Many cities have a strong Irish-American population but few go as far as the windy city: The Chicago River is dyed green in honour of the festivities. </p>\r\n ◀<p>Saint Patrick's Day (17th March) – Commemorating the patron saint of Ireland is a major celebration in the US. Many cities have a strong Irish-American ▶ <p>Thanksgiving (November 27th) – The quintessential American ‘holiday’. Families and friends gather to give thanks while Macy's department store in New York hosts one of the largest and most colourful parades in the annual calendar. Not to be missed.</p>\r\n ◀<p>Thanksgiving (November 27th) – The quintessential American ‘holiday’. Families and friends gather to give thanks while Macy's department st ▶ <h2>Weather</h2>\r\n <p>Due to its rather massive size the climate of the USA is quite varied. The northwest of the country, for instance, can get quite cold in the winter and sees rain all year round. The northeast gets quite warm in the summer but can see heavy snowfall during the winter months.<br /><br />The southeast and southwest, on the other hand, tend to be much warmer with milder winters and hotter summers. The southwest region, encompassing the likes of Texas, Arizona and Louisiana is the hotter part of the country although will see the occasional tornado and thunderstorms.</p>\r\n ◀<p>Due to its rather massive size the climate of the USA is quite varied. The northwest of the country, for instance, can get quite cold in the winter and sees ▶ <h2>USA Holidays 2025 & 2026</h2>\r\n <p>We have some fantastic USA holidays available for 2025 / 2026. Please search our deals using our onsite search facility or call one of the Kenwood team now on <strong>0203 868 1341 </strong> to snap up your very own Stateside discount. We can also tailor-make your holiday with a <a href="/caribbean-holidays/jamaica/">Jamaican</a> or <a href="/caribbean-holidays/">Caribbean</a> destination, so give us a call and see where that phone call can take you!</p>\r\n ◀<p>We have some fantastic USA holidays available for 2025 / 2026. Please search our deals using our onsite search facility or call one of the Kenwood team now o ▶ <h2>Visas</h2>\r\n <p>All British passport holders must have a full 10-year British Passport that is valid for at least six months after their return to the UK. A USA visa or waiver form/ESTA MUST be obtained prior to your visit. <a href="https://esta.cbp.dhs.gov/esta/" target="_blank" rel="nofollow noopener noreferrer">Apply online</a> for your ESTA at least 72 hours before travelling. If you have a passport showing you are a UK citizen then you are able to obtain a US visa, or ESTA, under the Visa Waiver Scheme. However, for clients travelling to the States after 1st April 2016 you will need to hold a passport with an integrated chip. For security reasons this holds all of your personal information, as stated on the passport, but in digital format. If your passport does not have this feature then you will need to renew the passport before your departure date. The Passport Office will add up to 9 months of any unexpired time and you can recognise the chip by a gold symbol, resembling a camera, on the bottom of the front cover of the passport.</p> ◀<p>All British passport holders must have a full 10-year British Passport that is valid for at least six months after their return to the UK. A USA visa or waiv ▶ """ "meta_flight_markup" => 0.0 "is_cache" => 0 ] #original: array:22 [▶ "id" => 144 "_lft" => 3447 "_rgt" => 4028 "parent_id" => null "layout_id" => 17 "name" => "USA" "slug" => "usa-holidays" "identifier" => null "metadata" => "{"image": "2023/09/7/Hero-Slider_002.jpg", "links": [{"url": "/usa-holidays/self-drives", "name": "USA Self Drives", "group": null}, {"url": "/usa-holidays/multi-centre-holidays", "name": "Multi Centre Holidays", "group": null}, {"url": "/cruiseholiday/north-america/usa", "name": "USA Cruises", "group": null}, {"url": "/florida-holidays", "name": "Florida Holidays", "group": null}, {"url": "/usa-holidays/luxury", "name": "Luxury Holidays", "group": null}, {"url": "/hawaii-holidays", "name": "Hawaii Holidays", "group": null}], "theme": null, "title": "USA Holidays", "search": {"popup": {"title": null, "enable": null, "message": null, "rolling_days": {"to": null, "from": null}}, "flight": {"legs": null, "connecting": null, "direct_tba": null, "cutoff_time": null, "exact_match": "y", "max_results": null, "widen_search": "n", "flights_arrive": ["1"], "search_classes": ["1"], "widen_search_tba": null, "search_all_classes": "n", "search_mixed_classes": "n"}, "keywords": null, "property": {"search_by": "ResortID", "alternative_room": null}, "region_id": null, "search_by": null, "cutoff_date": {"to": null, "from": null}, "loading_text": null, "loading_image": "2024/10/11/USA.jpg", "max_child_age": "17", "allow_0_adults": null, "loading_image_id": null, "departure_airports": ["G10", "A151", "A11"]}, "content": "<h2>Luxury Holidays to the USA</h2>\r\n<p>At Kenwood Travel we offer you an extensive range of luxury holidays to the USA, tailor made to suit all of your travelling needs. From romantic breaks, weddings and honeymoons to holidays that cater for families or adults only, our advisors are waiting to create your dream holiday package. Give them a call so you can start looking forward to that holiday of a lifetime. </p>\r\n<h2>Our Top Pick Hotels in the USA</h2>\r\n<p>Take advantage of our range of spectacular USA hotels and call us now. We deal with some of the biggest names in the USA, located in New York including <a href=\"/usa-holidays/east/new-york/the-langham-new-york-fifth-avenue-hotel\">The Langham, New York, Fifth Avenue</a>, and <a href=\"/usa-holidays/east/new-york/the-plaza-hotel-hotel\">The Plaza Hotel</a>.<br /><br />In the 'City of Angels', Los Angeles, we would suggest looking at the iconic <a href=\"/usa-holidays/california/los-angeles/beverly-hills/beverly-wilshire-a-four-seasons-hotel-hotel\">Beverly Wilshire, A Four Seasons Hotel</a> or the sun-kissed <a href=\"/usa-holidays/california/los-angeles/santa-monica/shutters-on-the-beach-hotel\">Shutters on the Beach</a>. Just a short distance to Nevada the choice of hotels in Las Vegas is vast, on our pick we recommend the <a href=\"/usa-holidays/west/las-vegas/bellagio-hotel\">Bellagio</a> and the world-famous <a href=\"/usa-holidays/west/las-vegas/mgm-grand-hotel-casino-hotel\">MGM Grand Hotel & Casino</a> where the world's major boxing events are held.</p>\r\n<p>There are of course many, many more fabulous hotels throughout the USA and our experts are here to offer our advice.</p>\r\n<h2>Things To Do</h2>\r\n<p>Get your kicks on Route 66, shop ‘til you drop on Rodeo Drive, gaze across the bay from Golden Gate Bridge or simply bask in the sun on Malibu Beach. The names of America’s streets and buildings are synonymous with the glamorous image we have of the place. Its larger-than-life landmarks seem to have been burned onto our collective cultural retina from an early age, trickling into our consciousness by way of rock ‘n’ roll songs and Hollywood movies, Coca Cola and Coney Island. Watching and listening from afar is one thing, being there in person is something else entirely. Become the protagonist in your very own American story and discover amazing things to do around every corner of this famous landscape.</p>\r\n<h2>Main Events</h2>\r\n<p>Super Bowl Sunday (1st Sunday in February) – Superbowl parties with friends are the way to go when tickets are hard to come by. Get out the chips and dips, crack a beer and cheer on your team. </p>\r\n<p>Saint Patrick's Day (17th March) – Commemorating the patron saint of Ireland is a major celebration in the US. Many cities have a strong Irish-American population but few go as far as the windy city: The Chicago River is dyed green in honour of the festivities. </p>\r\n<p>Thanksgiving (November 27th) – The quintessential American ‘holiday’. Families and friends gather to give thanks while Macy's department store in New York hosts one of the largest and most colourful parades in the annual calendar. Not to be missed.</p>\r\n<h2>Weather</h2>\r\n<p>Due to its rather massive size the climate of the USA is quite varied. The northwest of the country, for instance, can get quite cold in the winter and sees rain all year round. The northeast gets quite warm in the summer but can see heavy snowfall during the winter months.<br /><br />The southeast and southwest, on the other hand, tend to be much warmer with milder winters and hotter summers. The southwest region, encompassing the likes of Texas, Arizona and Louisiana is the hotter part of the country although will see the occasional tornado and thunderstorms.</p>\r\n<h2>USA Holidays 2025 & 2026</h2>\r\n<p>We have some fantastic USA holidays available for 2025 / 2026. Please search our deals using our onsite search facility or call one of the Kenwood team now on <strong>0203 868 1341 </strong> to snap up your very own Stateside discount. We can also tailor-make your holiday with a <a href=\"/caribbean-holidays/jamaica/\">Jamaican</a> or <a href=\"/caribbean-holidays/\">Caribbean</a> destination, so give us a call and see where that phone call can take you!</p>\r\n<h2>Visas</h2>\r\n<p>All British passport holders must have a full 10-year British Passport that is valid for at least six months after their return to the UK. A USA visa or waiver form/ESTA MUST be obtained prior to your visit. <a href=\"https://esta.cbp.dhs.gov/esta/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Apply online</a> for your ESTA at least 72 hours before travelling. If you have a passport showing you are a UK citizen then you are able to obtain a US visa, or ESTA, under the Visa Waiver Scheme. However, for clients travelling to the States after 1st April 2016 you will need to hold a passport with an integrated chip. For security reasons this holds all of your personal information, as stated on the passport, but in digital format. If your passport does not have this feature then you will need to renew the passport before your departure date. The Passport Office will add up to 9 months of any unexpired time and you can recognise the chip by a gold symbol, resembling a camera, on the bottom of the front cover of the passport.</p>", "deposit": null, "image_id": null, "subtitle": "All-American, all within your reach", "gallery_id": "7134", "switch_off": {"rooms": "1", "venues": "1"}, "destination": {"type": "hotel", "experts": {"title": null, "sub_title": null}, "weather": null, "pod_name": null, "documents": {"visa_upload": null, "visa_upload_id": null, "visa_information": "<p><strong>Entry Requirements:</strong></p>\r\n<p>Please <a title=\"Entry Requirements\" href=\"https://www.gov.uk/foreign-travel-advice/usa/entry-requirements\">click here</a> for full information on visa and passport information for USA. You will be required to apply for an ESTA before travel. Please note Kenwood Travel hold no responsibility if you are denied travel due to not meeting requirement of travel.</p>\r\n<p><strong>Resort Fee</strong></p>\r\n<p>Please note that most hotels in the USA will charge a per night resort fee and rate is variable from hotel to hotel. Please speak to a member of our team who can find out the specific charge for your hotel.</p>\r\n<p><strong>Travel Insurance</strong></p>\r\n<p>It is a condition of your contract with us that you have adequate travel insurance in place to cover you and your party against the cost of cancellation by you, the cost of assistance (including your repatriation) in the event of delays, accident, illness, death, loss of baggage and possessions. It is your responsibility to ensure that you have adequate travel insurance in place, we will not be responsible for any losses howsoever arising, in respect of which insurance cover would otherwise have been available</p>\r\n<p><strong>Important Information</strong></p>\r\n<p>Our Prices Please note as a UK Tour Operator some of our packaged and non packaged rates may not be available to NON UK citizens, or expatriates living abroad. Failure to advise Kenwood Travel of your status may result in additional costs or cancel charges, for which you would be liable.</p>\r\n<p> </p>", "visa_information_title": "USA Information"}, "map_block": {"title": null, "subtitle": null}, "hotels_tab": {"title": null, "sub_title": null}, "venues_list": {"title": null, "subtitle": null}, "contact_email": "usa@kenwoodtravel.co.uk", "contact_phone": "0203 868 1341", "multi_centres": {"link": null, "title": null, "see_all": null, "sub_title": null}, "children_block": {"image": "2020/12/9/Yellow cabs in Manhattan, NYC. The taxicabs of New York City at night Time Square.jpg", "title": "Top USA Destinations", "image_id": null, "subtitle": null}, "siblings_block": {"title": null, "subtitle": null}, "short_description": "From Tinseltown to the Big Apple - our Stateside guide", "useful_information": {"clock": null, "currency": null, "language": null, "location": null, "passport": null, "telephone": null, "flying-time": null}, "top_properties_block": {"title": "Top Picks", "subtitle": null, "more_button_page": null, "more_button_title": null}}, "button_title": null, "hero_content": "<p>Whether you’re looking to take a bite of the ‘Big Apple’ with a city break to New York, experience the bright neon lights and lavish lifestyle of Las Vegas, embark on a fun-filled family adventure to Florida or simply kick back on a chilled-out San Diego beach, our team of USA Specialists can help create your very own American Dream.</p>", "mobile_image": null, "flight_markup": null, "hide_on_search": "0", "button_page_url": null, "cruise_packages": {"page": null, "title": null}, "hide_search_bar": null, "mobile_image_id": null} ◀{"image": "2023/09/7/Hero-Slider_002.jpg", "links": [{"url": "/usa-holidays/self-drives", "name": "USA Self Drives", "group": null}, {"url": "/usa-holidays/mult ▶" "canonical" => null "active" => 1 "cruise_active" => 1 "fly_drive_active" => 1 "type" => 3 "created_at" => "2019-12-09 13:14:02" "updated_at" => "2025-04-01 10:37:59" "deleted_at" => null "drafted_at" => null "expects_approval" => 0 "meta_content" => """ <h2>Luxury Holidays to the USA</h2>\r\n <p>At Kenwood Travel we offer you an extensive range of luxury holidays to the USA, tailor made to suit all of your travelling needs. From romantic breaks, weddings and honeymoons to holidays that cater for families or adults only, our advisors are waiting to create your dream holiday package. Give them a call so you can start looking forward to that holiday of a lifetime. </p>\r\n ◀<p>At Kenwood Travel we offer you an extensive range of luxury holidays to the USA, tailor made to suit all of your travelling needs. From romantic breaks, wedd ▶ <h2>Our Top Pick Hotels in the USA</h2>\r\n <p>Take advantage of our range of spectacular USA hotels and call us now. We deal with some of the biggest names in the USA, located in New York including <a href="/usa-holidays/east/new-york/the-langham-new-york-fifth-avenue-hotel">The Langham, New York, Fifth Avenue</a>, and <a href="/usa-holidays/east/new-york/the-plaza-hotel-hotel">The Plaza Hotel</a>.<br /><br />In the 'City of Angels', Los Angeles, we would suggest looking at the iconic <a href="/usa-holidays/california/los-angeles/beverly-hills/beverly-wilshire-a-four-seasons-hotel-hotel">Beverly Wilshire, A Four Seasons Hotel</a> or the sun-kissed <a href="/usa-holidays/california/los-angeles/santa-monica/shutters-on-the-beach-hotel">Shutters on the Beach</a>. Just a short distance to Nevada the choice of hotels in Las Vegas is vast, on our pick we recommend the <a href="/usa-holidays/west/las-vegas/bellagio-hotel">Bellagio</a> and the world-famous <a href="/usa-holidays/west/las-vegas/mgm-grand-hotel-casino-hotel">MGM Grand Hotel & Casino</a> where the world's major boxing events are held.</p>\r\n ◀<p>Take advantage of our range of spectacular USA hotels and call us now. We deal with some of the biggest names in the USA, located in New York including <a hr ▶ <p>There are of course many, many more fabulous hotels throughout the USA and our experts are here to offer our advice.</p>\r\n <h2>Things To Do</h2>\r\n <p>Get your kicks on Route 66, shop ‘til you drop on Rodeo Drive, gaze across the bay from Golden Gate Bridge or simply bask in the sun on Malibu Beach. The names of America’s streets and buildings are synonymous with the glamorous image we have of the place. Its larger-than-life landmarks seem to have been burned onto our collective cultural retina from an early age, trickling into our consciousness by way of rock ‘n’ roll songs and Hollywood movies, Coca Cola and Coney Island. Watching and listening from afar is one thing, being there in person is something else entirely. Become the protagonist in your very own American story and discover amazing things to do around every corner of this famous landscape.</p>\r\n ◀<p>Get your kicks on Route 66, shop ‘til you drop on Rodeo Drive, gaze across the bay from Golden Gate Bridge or simply bask in the sun on Malibu Beach. T ▶ <h2>Main Events</h2>\r\n <p>Super Bowl Sunday (1st Sunday in February) – Superbowl parties with friends are the way to go when tickets are hard to come by. Get out the chips and dips, crack a beer and cheer on your team. </p>\r\n ◀<p>Super Bowl Sunday (1st Sunday in February) – Superbowl parties with friends are the way to go when tickets are hard to come by. Get out the chips and d ▶ <p>Saint Patrick's Day (17th March) – Commemorating the patron saint of Ireland is a major celebration in the US. Many cities have a strong Irish-American population but few go as far as the windy city: The Chicago River is dyed green in honour of the festivities. </p>\r\n ◀<p>Saint Patrick's Day (17th March) – Commemorating the patron saint of Ireland is a major celebration in the US. Many cities have a strong Irish-American ▶ <p>Thanksgiving (November 27th) – The quintessential American ‘holiday’. Families and friends gather to give thanks while Macy's department store in New York hosts one of the largest and most colourful parades in the annual calendar. Not to be missed.</p>\r\n ◀<p>Thanksgiving (November 27th) – The quintessential American ‘holiday’. Families and friends gather to give thanks while Macy's department st ▶ <h2>Weather</h2>\r\n <p>Due to its rather massive size the climate of the USA is quite varied. The northwest of the country, for instance, can get quite cold in the winter and sees rain all year round. The northeast gets quite warm in the summer but can see heavy snowfall during the winter months.<br /><br />The southeast and southwest, on the other hand, tend to be much warmer with milder winters and hotter summers. The southwest region, encompassing the likes of Texas, Arizona and Louisiana is the hotter part of the country although will see the occasional tornado and thunderstorms.</p>\r\n ◀<p>Due to its rather massive size the climate of the USA is quite varied. The northwest of the country, for instance, can get quite cold in the winter and sees ▶ <h2>USA Holidays 2025 & 2026</h2>\r\n <p>We have some fantastic USA holidays available for 2025 / 2026. Please search our deals using our onsite search facility or call one of the Kenwood team now on <strong>0203 868 1341 </strong> to snap up your very own Stateside discount. We can also tailor-make your holiday with a <a href="/caribbean-holidays/jamaica/">Jamaican</a> or <a href="/caribbean-holidays/">Caribbean</a> destination, so give us a call and see where that phone call can take you!</p>\r\n ◀<p>We have some fantastic USA holidays available for 2025 / 2026. Please search our deals using our onsite search facility or call one of the Kenwood team now o ▶ <h2>Visas</h2>\r\n <p>All British passport holders must have a full 10-year British Passport that is valid for at least six months after their return to the UK. A USA visa or waiver form/ESTA MUST be obtained prior to your visit. <a href="https://esta.cbp.dhs.gov/esta/" target="_blank" rel="nofollow noopener noreferrer">Apply online</a> for your ESTA at least 72 hours before travelling. If you have a passport showing you are a UK citizen then you are able to obtain a US visa, or ESTA, under the Visa Waiver Scheme. However, for clients travelling to the States after 1st April 2016 you will need to hold a passport with an integrated chip. For security reasons this holds all of your personal information, as stated on the passport, but in digital format. If your passport does not have this feature then you will need to renew the passport before your departure date. The Passport Office will add up to 9 months of any unexpired time and you can recognise the chip by a gold symbol, resembling a camera, on the bottom of the front cover of the passport.</p> ◀<p>All British passport holders must have a full 10-year British Passport that is valid for at least six months after their return to the UK. A USA visa or waiv ▶ """ "meta_flight_markup" => 0.0 "is_cache" => 0 ] #changes: [] #casts: array:3 [▶ "drafted_at" => "datetime" "active" => "boolean" "deleted_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: array:1 [▶ "url" => App\Models\Cms\Url {#5597 ▶ #connection: "mysql" #table: "urls" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:6 [▶ "id" => 144 "url" => "usa-holidays" "urlable_id" => 144 "urlable_type" => "App\Models\Cms\Page" "created_at" => "2019-12-09 13:14:02" "updated_at" => "2025-01-29 12:29:29" ] #original: array:6 [▶ "id" => 144 "url" => "usa-holidays" "urlable_id" => 144 "urlable_type" => "App\Models\Cms\Page" "created_at" => "2019-12-09 13:14:02" "updated_at" => "2025-01-29 12:29:29" ] #changes: [] #casts: [] #classCastCache: [] #attributeCastCache: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true +usesUniqueIds: false #hidden: [] #visible: [] #fillable: array:3 [▶ 0 => "url" 1 => "urlable_id" 2 => "urlable_type" ] #guarded: array:1 [▶ 0 => "*" ] } ] #touches: [] +timestamps: true +usesUniqueIds: false #hidden: [] #visible: [] #fillable: array:9 [▶ 0 => "layout_id" 1 => "name" 2 => "slug" 3 => "identifier" 4 => "metadata" 5 => "active" 6 => "cruise_active" 7 => "fly_drive_active" 8 => "type" ] #guarded: array:1 [▶ 0 => "*" ] #pending: null #moved: false #filter: array:11 [▶ "query" => null "instance" => null "request" => null "morph" => null "method" => null "having" => null "field" => null "value" => null "operator" => null "condition" => null "columns" => null ] #sort: array:5 [▶ "query" => null "request" => null "instance" => null "field" => "sort" "direction" => "dir" ] #forceDeleting: false }
0 of 0array:2 [▼ "hash" => "" "metadata" => [] ]
1 x Application (96.91%) | 1.27s |
1 x Booting (3.08%) | 40.23ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
select exists(select * from `blocked_ips` where `ip` = '216.73.216.145') as `exists`
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `redirects` where `old_url` = 'usa-holidays/luxury' and `new_url` is not null and `status` in (302, 301, 307) limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `urls` where BINARY `url` = 'usa-holidays/luxury' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 721 and `pages`.`drafted_at` is null and `pages`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (721) and `urls`.`urlable_type` = 'App\Models\Cms\Page'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where (3451 between `pages`.`_lft` and `pages`.`_rgt` and `pages`.`id` <> 721) order by `_lft` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `layouts` where `layouts`.`id` in (14)
Metadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `seo_settings` where `seo_settings`.`seoable_type` = 'App\Models\Cms\Page' and `seo_settings`.`seoable_id` = 721 and `seo_settings`.`seoable_id` is not null and `seo_settings`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 721 and `blockables`.`blockable_type` = 'App\Models\Cms\Page' and `location` = 'hero' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 14 and `blockables`.`blockable_type` = 'App\Models\Cms\Layout' and `location` = 'hero' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2022/04/11/Hero-Image_017.jpg' and `full_path_hash` = '2774703189' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where (3451 between `pages`.`_lft` and `pages`.`_rgt` and `pages`.`id` <> 721) and `active` = 1 and `pages`.`drafted_at` is null and `pages`.`deleted_at` is null order by `_lft` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (144) and `urls`.`urlable_type` = 'App\Models\Cms\Page'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 144 and `pages`.`drafted_at` is null and `pages`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 144 and `blockables`.`blockable_type` = 'App\Models\Cms\Page' and `location` = 'content' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`parent_id` = 144 and `pages`.`parent_id` is not null and (`slug` = 'hotels' or `slug` = 'villas') and `active` = 1 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 721 and `blockables`.`blockable_type` = 'App\Models\Cms\Page' and `location` = 'content' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 14 and `blockables`.`blockable_type` = 'App\Models\Cms\Layout' and `location` = 'content' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `lists_filters` where `slug` = 'luxury' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `pages` where `active` = 1 and `type` = '3' and `_lft` between 3447 and 4028
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `travel_properties` left join (select * from `has_promoted_filters` where (`model_type` = 'App\Models\Travel\Property' and `filter_id` = 10) and (`start_date` <= "2025-07-07" OR `start_date` IS NULL) and (`end_date` >= "2025-07-07" OR `end_date` IS NULL)) AS `temp_promoted` on `temp_promoted`.`model_id` = `travel_properties`.`id` left join `pages` on `pages`.`id` = `travel_properties`.`location_id` left join `ivector_cache_min_price` on `ivector_cache_min_price`.`iv_ref_id` = `travel_properties`.`iv_reference_id` left join `ivector_cache_flights` on `ivector_cache_flights`.`id` = `ivector_cache_min_price`.`flight_id` left join `ivector_cache_properties` on `ivector_cache_properties`.`id` = `ivector_cache_min_price`.`cache_id` left join `ivector_meal_bases` on `ivector_cache_properties`.`metadata`->>'$.meal_basis_id' = `ivector_meal_bases`.`id` left join `ivector_airlines` on `ivector_cache_flights`.`metadata`->>'$.airline' = `ivector_airlines`.`metadata`->>'$.code' left join `lists_ratings` on `lists_ratings`.`id` = `travel_properties`.`rating_id` where `travel_properties`.`id` IN (select `model_id` from `has_filters` where `model_type` = 'App\Models\Travel\Property' and `filter_id` = 10) and `ivector_cache_min_price`.`price_rule` = 'adult' and `ivector_cache_flights`.`id` is not null and `ivector_cache_properties`.`id` is not null and `pages`.`_lft` between 3447 and 4028 and `suspended` = 0 and `non_featured` = 0 and `pre_live` = 0 and `travel_properties`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `travel_properties`.`id`, `travel_properties`.`iv_reference_id`, `travel_properties`.`location_id`, `travel_properties`.`layout_id`, `travel_properties`.`type_id`, `travel_properties`.`rating_id`, `travel_properties`.`name`, `travel_properties`.`slug`, `travel_properties`.`top`, `travel_properties`.`latitude`, `travel_properties`.`longitude`, `travel_properties`.`metadata`, travel_properties.metadata->>'$.gallery_id' as gallery_id, `ivector_cache_min_price`.`price` as `price`, (`ivector_cache_flights`.`metadata`->>'$.pp_price.child' + `ivector_cache_properties`.`metadata`->>'$.pp_price.child') AS `child_price`, (`ivector_cache_flights`.`metadata`->>'$.outbound_class') AS `outbound_class`, (`ivector_cache_flights`.`metadata`->>'$.return_class') AS `return_class`, `ivector_cache_flights`.`date` as `date`, `ivector_cache_properties`.`metadata`->>'$.nights' AS `nights`, `ivector_cache_properties`.`metadata`->>'$.room_type' AS `room_type`, `ivector_cache_properties`.`metadata`->>'$.offers' AS `selectedFeatures`, `ivector_meal_bases`.`name` as `meal_basis`, `ivector_airlines`.`name` as `airline` from `travel_properties` left join (select * from `has_promoted_filters` where (`model_type` = 'App\Models\Travel\Property' and `filter_id` = 10) and (`start_date` <= "2025-07-07" OR `start_date` IS NULL) and (`end_date` >= "2025-07-07" OR `end_date` IS NULL)) AS `temp_promoted` on `temp_promoted`.`model_id` = `travel_properties`.`id` left join `pages` on `pages`.`id` = `travel_properties`.`location_id` left join `ivector_cache_min_price` on `ivector_cache_min_price`.`iv_ref_id` = `travel_properties`.`iv_reference_id` left join `ivector_cache_flights` on `ivector_cache_flights`.`id` = `ivector_cache_min_price`.`flight_id` left join `ivector_cache_properties` on `ivector_cache_properties`.`id` = `ivector_cache_min_price`.`cache_id` left join `ivector_meal_bases` on `ivector_cache_properties`.`metadata`->>'$.meal_basis_id' = `ivector_meal_bases`.`id` left join `ivector_airlines` on `ivector_cache_flights`.`metadata`->>'$.airline' = `ivector_airlines`.`metadata`->>'$.code' left join `lists_ratings` on `lists_ratings`.`id` = `travel_properties`.`rating_id` where `travel_properties`.`id` IN (select `model_id` from `has_filters` where `model_type` = 'App\Models\Travel\Property' and `filter_id` = 10) and `ivector_cache_min_price`.`price_rule` = 'adult' and `ivector_cache_flights`.`id` is not null and `ivector_cache_properties`.`id` is not null and `pages`.`_lft` between 3447 and 4028 and `suspended` = 0 and `non_featured` = 0 and `pre_live` = 0 and `travel_properties`.`deleted_at` is null order by COALESCE(`temp_promoted`.`order`, 10000), `temp_promoted`.`filter_id` IS NULL, `pages`.`_lft` asc, `travel_properties`.`top` = 0, `price`, `lists_ratings`.`name` desc limit 10 offset 10
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (1096, 1165, 1173, 1186, 1189, 1190, 1195, 1227, 2449, 2456) and `urls`.`urlable_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `lists_ratings` where `lists_ratings`.`id` in (3, 4, 7)
Metadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` in (146, 150, 151, 152, 161) and `pages`.`drafted_at` is null and `pages`.`deleted_at` is null
Metadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (146, 150, 151, 152, 161) and `urls`.`urlable_type` = 'App\Models\Cms\Page'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1165 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2025-09-20' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1165 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 2456 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2025-12-09' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 2456 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1173 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2026-01-05' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1173 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1189 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2025-07-02' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1189 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1186 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2025-07-02' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1186 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1195 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2025-11-02' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1195 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1190 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2025-12-01' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1190 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1227 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2025-12-08' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1227 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 2449 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2026-02-22' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 2449 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `travel_property_offers` where `travel_property_offers`.`property_id` = 1096 and `travel_property_offers`.`property_id` is not null and '2025-07-07 00:00:00' BETWEEN `booking_date_start` AND `booking_date_end` and '2026-02-25' BETWEEN `travel_date_start` AND `travel_date_end` and `nights` <= 5 and IF(`max_nights` > 0, `max_nights` >= 5, 1)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `metadata`->>'$.link.property' = 1096 and `metadata`->>'$.link.filter_id' = 10 limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`parent_id` = 144 and `pages`.`parent_id` is not null and `active` = 1 and (`type` = 3)
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `active` = 1 and `parent_id` in (906, 1793, 1799, 1798) and `slug` = 'luxury' order by `_lft` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '10555' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 10555 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Hotel Front View.jpg' and `full_path_hash` = '4164648252' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Hotel Reflection.jpg' and `full_path_hash` = '3867446238' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Hotel evening view.jpg' and `full_path_hash` = '2510473886' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Icecream shop.jpg' and `full_path_hash` = '1340566734' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Hotel View.jpg' and `full_path_hash` = '3629566371' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - coconut cocktail.jpg' and `full_path_hash` = '3034618576' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Family time.jpg' and `full_path_hash` = '892301063' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Fruit cocktail.jpg' and `full_path_hash` = '1774247664' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Fruit salad.jpg' and `full_path_hash` = '4157738907' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - girls exercising.jpg' and `full_path_hash` = '4171994850' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - beach umbrella.jpg' and `full_path_hash` = '1019256064' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - room patio.jpg' and `full_path_hash` = '3589758152' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - icecreams.jpg' and `full_path_hash` = '3018738174' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - lunch.jpg' and `full_path_hash` = '1200907705' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Pizza.jpg' and `full_path_hash` = '517864420' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - surfing.jpg' and `full_path_hash` = '4165007847' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Wedding.jpg' and `full_path_hash` = '1951709404' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Hotel Pool.jpg' and `full_path_hash` = '550293010' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - Peddling.jpg' and `full_path_hash` = '3893559403' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/5/Hotel Del Coronado - cocktail.jpg' and `full_path_hash` = '1336607606' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1165 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '14267' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 14267 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/pic__superior-room-slide-03.jpg' and `full_path_hash` = '3785768824' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/1-3-1920x850.jpeg' and `full_path_hash` = '2412891656' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/1-11-1920x850.jpeg' and `full_path_hash` = '2938070276' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/1-2-1920x850.jpeg' and `full_path_hash` = '908727776' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/1-1-1920x850.jpeg' and `full_path_hash` = '660045721' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/1-5-1920x850.jpeg' and `full_path_hash` = '2905283322' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/1-6-1920x850.jpeg' and `full_path_hash` = '3159781507' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/13/Spa-Pendry-Massage-Bed-1920x850.jpg' and `full_path_hash` = '3959642411' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 2456 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '10673' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 10673 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - View from the tram.jpg' and `full_path_hash` = '3993331998' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Aerial Short.jpg' and `full_path_hash` = '4125937898' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Wedding arrangement.jpg' and `full_path_hash` = '1843880748' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Liqour Collection.jpg' and `full_path_hash` = '3759993321' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Lounge.jpg' and `full_path_hash` = '348107212' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Night view.jpg' and `full_path_hash` = '3436269518' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Pub Lunch.jpg' and `full_path_hash` = '518421194' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Restaurant entrance.jpg' and `full_path_hash` = '4213571575' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Restaurant seating.jpg' and `full_path_hash` = '2924835907' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Restaurant.jpg' and `full_path_hash` = '3529400288' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Sea View from the hotel.jpg' and `full_path_hash` = '2379669549' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - View from the room.jpg' and `full_path_hash` = '342490343' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Window view.jpg' and `full_path_hash` = '58598918' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Bar area.jpg' and `full_path_hash` = '2088837210' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Burger.jpg' and `full_path_hash` = '869134275' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Cocktail.jpg' and `full_path_hash` = '3435564521' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Couple at bar.jpg' and `full_path_hash` = '4147917733' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Crab dish.jpg' and `full_path_hash` = '2888407005' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Entrance close up.jpg' and `full_path_hash` = '3692737027' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Entrance.jpg' and `full_path_hash` = '1241290691' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - Family by the hotel.jpg' and `full_path_hash` = '3844241640' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Argonaut Hotel - In room dining.jpg' and `full_path_hash` = '3345093599' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1173 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '10715' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 10715 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Exterior.jpg' and `full_path_hash` = '929256205' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Terrace.jpg' and `full_path_hash` = '2637452773' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Building Deco.jpg' and `full_path_hash` = '2130323252' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Family time.jpg' and `full_path_hash` = '717430880' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Mr. Fairmont.jpg' and `full_path_hash` = '3090888763' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - View from the suite.jpg' and `full_path_hash` = '2261122416' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Bay View.jpg' and `full_path_hash` = '950949255' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Breakfast on terrace.jpg' and `full_path_hash` = '524819241' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Entertainment.jpg' and `full_path_hash` = '826598033' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Lobby.jpg' and `full_path_hash` = '2921264221' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont SFO - Fitness.jpg' and `full_path_hash` = '372449478' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Laurel Court and Bar_001.jpg' and `full_path_hash` = '3765586732' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Fairmont San Francisco - Laurel Court.jpg' and `full_path_hash` = '1223201855' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1189 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '10714' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 10714 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - Classic Lounge.jpg' and `full_path_hash` = '945635997' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - Gym.jpg' and `full_path_hash` = '2910251698' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - Lobby.jpg' and `full_path_hash` = '2567303111' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - Lounge Bar.jpg' and `full_path_hash` = '2312632879' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - Overview.jpg' and `full_path_hash` = '1784402054' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - SFO sUITE.jpg' and `full_path_hash` = '425050811' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - TErrace Lounge.jpg' and `full_path_hash` = '2624571461' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - Terrace.jpg' and `full_path_hash` = '2634008962' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - The Club.jpg' and `full_path_hash` = '2201384862' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - chandilier.jpg' and `full_path_hash` = '1162892831' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - City View.jpg' and `full_path_hash` = '2543271184' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/6/Ritz Carlton San Francisco - Fishermans Wharf View from the htoel.jpg' and `full_path_hash` = '1118245979' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1186 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '14553' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 14553 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/sbarz-aerial-view-7452-hor-clsc.jpg' and `full_path_hash` = '1216708922' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/sbarz-aerial-view-7453-hor-clsc.jpg' and `full_path_hash` = '3582615628' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/sbarz-lobby-6792-hor-clsc.jpg' and `full_path_hash` = '1783040772' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/sbarz-view-6613-hor-clsc.jpg' and `full_path_hash` = '698298733' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/rz-sbarz-fitness-center-15367_Classic-Hor.jpg' and `full_path_hash` = '338240116' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/rz-sbarz-spa-41001_Classic-Hor.jpg' and `full_path_hash` = '202111830' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/sbarz-pool-0024-hor-clsc.jpg' and `full_path_hash` = '3286659174' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/sbarz-residence-0006-hor-clsc.jpg' and `full_path_hash` = '1604779766' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/26/sbarz-spa-0026-hor-clsc.jpg' and `full_path_hash` = '3477772829' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1195 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '14470' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 14470 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/ele-ext-aerial10.jpeg' and `full_path_hash` = '2966722268' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/ele-ext16.jpeg' and `full_path_hash` = '1899656608' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/ele-din-restaurant-dining-room-and-terrace08.jpeg' and `full_path_hash` = '776727143' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/des-north-america-usa-california-santa-barbara-stearns-wharf02.jpeg' and `full_path_hash` = '2775193277' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/ele-gst-pool13.jpeg' and `full_path_hash` = '3235178178' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/ele-occ-venue-arbor-and-lily-pond-corporate06.jpeg' and `full_path_hash` = '3272093884' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/ele-ext13.jpeg' and `full_path_hash` = '569893907' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/23/ele-din-restaurant-dining-room-wine-room01.jpeg' and `full_path_hash` = '831590073' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1190 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '1659' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 1659 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-Andaz Farmers Table.jpg' and `full_path_hash` = '1201478610' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-andaz-napa-1.jpg' and `full_path_hash` = '3416135879' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-andaz-napa.jpg' and `full_path_hash` = '3910641438' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-bar-lounge.jpg' and `full_path_hash` = '1802471325' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-classic-king-guestroom.jpg' and `full_path_hash` = '1864648832' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-Entrance.jpg' and `full_path_hash` = '535620311' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-exterior.jpg' and `full_path_hash` = '464425904' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-guest-room-1.jpg' and `full_path_hash` = '899127916' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-guest-room-2.jpg' and `full_path_hash` = '1916264636' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-guest-room.jpg' and `full_path_hash` = '2109142641' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-lobby-1.jpg' and `full_path_hash` = '522693330' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-lobby.jpg' and `full_path_hash` = '108252893' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-lux-suite.jpg' and `full_path_hash` = '4066523902' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-restaurant-1.jpg' and `full_path_hash` = '2925540277' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-restaurant.jpg' and `full_path_hash` = '522234876' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-suite Balcony.jpg' and `full_path_hash` = '1210423059' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-suite Dining.jpg' and `full_path_hash` = '480476741' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-suite-.jpg' and `full_path_hash` = '2087695507' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-suite-Balcony Dining.jpg' and `full_path_hash` = '1239097244' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-suite-interior.jpg' and `full_path_hash` = '1963432069' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-suite-Living Room.jpg' and `full_path_hash` = '3013011356' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-suite.jpg' and `full_path_hash` = '3941179745' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-Sunroom terrace.jpg' and `full_path_hash` = '2177158100' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-Sunroom.jpg' and `full_path_hash` = '3050038863' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2020/02/13/The Andaz Hotel Napa-Terrace.jpg' and `full_path_hash` = '3861328806' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1227 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '14397' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 14397 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Lady by the pool.jpg' and `full_path_hash` = '4200219619' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Friends playing cornhole.jpg' and `full_path_hash` = '3083324581' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Alfresco dining.jpg' and `full_path_hash` = '2860450380' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Cottage Interior.jpg' and `full_path_hash` = '286057580' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Cottage.jpg' and `full_path_hash` = '1820797055' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Farm restaurant interior.jpg' and `full_path_hash` = '851670446' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Fitness Centre.jpg' and `full_path_hash` = '510412563' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Friends enjoying a fire.jpg' and `full_path_hash` = '2104414672' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Great food.jpg' and `full_path_hash` = '2708072302' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Hilltop dining.jpg' and `full_path_hash` = '3674591778' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Lady relaxing on a day bed.jpg' and `full_path_hash` = '3650622586' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Library.jpg' and `full_path_hash` = '501184297' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Single lady in the pool.jpg' and `full_path_hash` = '3795287182' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Swimming pool.jpg' and `full_path_hash` = '1876683383' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/Vineyard cycling.jpg' and `full_path_hash` = '3492693684' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 2449 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `galleries` where `galleries`.`id` = '10500' and `galleries`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `uploads`.*, `uploadables`.`uploadable_id` as `pivot_uploadable_id`, `uploadables`.`upload_id` as `pivot_upload_id`, `uploadables`.`uploadable_type` as `pivot_uploadable_type`, `uploadables`.`id` as `pivot_id`, `uploadables`.`ord` as `pivot_ord`, `uploadables`.`metadata` as `pivot_metadata`, `uploadables`.`created_at` as `pivot_created_at`, `uploadables`.`updated_at` as `pivot_updated_at` from `uploads` inner join `uploadables` on `uploads`.`id` = `uploadables`.`upload_id` where `uploadables`.`uploadable_id` = 10500 and `uploadables`.`uploadable_type` = 'App\Models\Cms\Gallery' order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - Exterior.jpg' and `full_path_hash` = '4047257148' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - Entrance.jpg' and `full_path_hash` = '2707076812' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - Indoor pool.jpg' and `full_path_hash` = '3374640947' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - river view.jpg' and `full_path_hash` = '3610567347' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - saloon.jpg' and `full_path_hash` = '4014673585' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - Lobby.jpg' and `full_path_hash` = '2836332207' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - spa chair.jpg' and `full_path_hash` = '1177633396' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - spa.jpg' and `full_path_hash` = '4130613320' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - gym.jpg' and `full_path_hash` = '3174648413' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - Club Lounge.jpg' and `full_path_hash` = '2232311425' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - burger.jpg' and `full_path_hash` = '2287911809' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - Side bar and grill breakfast.jpg' and `full_path_hash` = '2212029226' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/4/Sheraton Boston - Market grab interior.jpg' and `full_path_hash` = '1539864598' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `lists_key_features`.*, `has_key_features`.`model_id` as `pivot_model_id`, `has_key_features`.`key_feature_id` as `pivot_key_feature_id`, `has_key_features`.`model_type` as `pivot_model_type` from `lists_key_features` inner join `has_key_features` on `lists_key_features`.`id` = `has_key_features`.`key_feature_id` where `has_key_features`.`model_id` = 1096 and `has_key_features`.`model_type` = 'App\Models\Travel\Property'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'analytics-code' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 721 and `blockables`.`blockable_type` = 'App\Models\Cms\Page' and `location` = 'head' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 14 and `blockables`.`blockable_type` = 'App\Models\Cms\Layout' and `location` = 'head' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `settings` where `key` = 'contact_phone' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `identifier` = 'holiday-enquiry-form' and `active` = 1 and `pages`.`drafted_at` is null and `pages`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (883) and `urls`.`urlable_type` = 'App\Models\Cms\Page'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `identifier` = 'cruise-enquiry' and `active` = 1 and `pages`.`drafted_at` is null and `pages`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (2200) and `urls`.`urlable_type` = 'App\Models\Cms\Page'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`_lft` between 3448 and 4028 and (`active` = 1 and `type` = 3) and `pages`.`drafted_at` is null and `pages`.`deleted_at` is null order by `_lft` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 160, 161, 164, 165, 166, 167, 169, 170, 172, 174, 906, 1793, 1796, 1798, 1799, 1855, 1861, 1862, 1863, 1864, 1878, 1891, 1946, 1960, 2013, 2026, 2031, 2047, 2236, 2254, 2273) and `urls`.`urlable_type` = 'App\Models\Cms\Page'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where (`identifier` = 'uk') limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
(select CONCAT('A', ivector_airports.id) AS `id`, `ivector_airports`.`name`, `ivector_airports`.`name` as `display_name`, `pages`.`_lft` from `ivector_airports` left join `pages` on `pages`.`id` = `ivector_airports`.`location_id` where `pages`.`_lft` between 4231 and 4274 and `pages`.`_lft` is not null order by `pages`.`_lft` asc) union (select CONCAT('G', ivector_airport_groups.id) AS `id`, `ivector_airport_groups`.`name`, IF(ivector_airport_groups.metadata->>'$.display_name' != '' && ivector_airport_groups.metadata->>'$.display_name' != 'null', ivector_airport_groups.metadata->>'$.display_name', ivector_airport_groups.name) AS display_name, `pages`.`_lft` from `ivector_airport_groups` left join `pages` on `pages`.`id` = `ivector_airport_groups`.`location_id` where `pages`.`_lft` between 4231 and 4274 and `pages`.`_lft` is not null order by `pages`.`_lft` asc) order by _lft, name
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `_lft`, `_rgt`, `parent_id`, `name`, `metadata` from `pages` where `active` = 1 and `type` = 3 order by `_lft` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'loading_image' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `settings` where `key` = 'loading_text' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/Caribbean.jpg' and `full_path_hash` = '2320842550' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2022/10/10/shutterstock_428018086.jpg' and `full_path_hash` = '996961897' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/Indian Ocean.jpg' and `full_path_hash` = '3669765450' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/18/Indian Ocean.jpg' and `full_path_hash` = '582956455' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/18/shutterstock_2500762789.jpg' and `full_path_hash` = '1292415452' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/18/shutterstock_2485771063.jpg' and `full_path_hash` = '3408717338' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/18/shutterstock_1180035313.jpg' and `full_path_hash` = '3433214522' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/Europe.jpg' and `full_path_hash` = '3899716554' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2022/10/18/shutterstock_1147756190.jpg' and `full_path_hash` = '258022607' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/Florida.jpg' and `full_path_hash` = '1629005230' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/Thailand.jpg' and `full_path_hash` = '2851397478' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/Asia.jpg' and `full_path_hash` = '3740763679' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/USA.jpg' and `full_path_hash` = '2716099049' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/20/shutterstock_694527892.jpg' and `full_path_hash` = '2098167506' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/06/21/GPS18_JWMarriott_43_001.jpg' and `full_path_hash` = '72494160' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/09/6/shutterstock_97706066.jpg' and `full_path_hash` = '2098968423' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/09/19/shutterstock_382968685.jpg' and `full_path_hash` = '1377385997' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/09/19/shutterstock_1125525113.jpg' and `full_path_hash` = '1971137957' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/09/19/shutterstock_503999926.jpg' and `full_path_hash` = '907980542' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2023/09/19/shutterstock_1260429463_001.jpg' and `full_path_hash` = '3358121938' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/11/Hawaii.jpg' and `full_path_hash` = '357867628' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2022/10/10/shutterstock_1061444126.jpg' and `full_path_hash` = '592181610' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `name`, `metadata` from `pages` where `type` = '3' and (`active` = 1) and (`metadata`->>'$.search.region_id' IS NOT NULL OR `metadata`->>'$.search.resort_id' IS NOT NULL) and `metadata`->>'$.search.flight.fly_drive' = 1 order by `_lft` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 721 and `blockables`.`blockable_type` = 'App\Models\Cms\Page' and `location` = 'top' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 14 and `blockables`.`blockable_type` = 'App\Models\Cms\Layout' and `location` = 'top' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 721 and `blockables`.`blockable_type` = 'App\Models\Cms\Page' and `location` = 'header' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 14 and `blockables`.`blockable_type` = 'App\Models\Cms\Layout' and `location` = 'header' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 721 and `blockables`.`blockable_type` = 'App\Models\Cms\Page' and `location` = 'footer' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `blocks`.*, `blockables`.`blockable_id` as `pivot_blockable_id`, `blockables`.`block_id` as `pivot_block_id`, `blockables`.`blockable_type` as `pivot_blockable_type`, `blockables`.`id` as `pivot_id`, `blockables`.`location` as `pivot_location`, `blockables`.`ord` as `pivot_ord`, `blockables`.`created_at` as `pivot_created_at`, `blockables`.`updated_at` as `pivot_updated_at` from `blocks` inner join `blockables` on `blocks`.`id` = `blockables`.`block_id` where `blockables`.`blockable_id` = 14 and `blockables`.`blockable_type` = 'App\Models\Cms\Layout' and `location` = 'footer' and `active` = 1 and ((`start_date` is null or date(`start_date`) <= '2025-07-07') and (`end_date` is null or date(`end_date`) >= '2025-07-07')) and `blocks`.`drafted_at` is null and `blocks`.`deleted_at` is null order by `ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `partners` where `active` = 1 and (`metadata`->>'$.hide_on_scroller' IS NULL OR `metadata`->>'$.hide_on_scroller' != 1) and (JSON_CONTAINS(`metadata`, CAST(144 AS CHAR(10)), '$.destinations')) and `partners`.`drafted_at` is null and `partners`.`deleted_at` is null order by `meta_ord` asc
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `urls` where `urls`.`urlable_id` in (8, 29, 31, 65, 129, 131) and `urls`.`urlable_type` = 'App\Models\Cms\Partner'
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/01/20/americanairlines.png' and `full_path_hash` = '2451179920' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2022/10/14/British-Airways-Logo.png' and `full_path_hash` = '1761271379' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/10/22/Virgin-Atlantic-Logo.png' and `full_path_hash` = '3306011900' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2021/04/21/HHR-Logo-Color_HR.png' and `full_path_hash` = '1043305224' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/02/20/RitzCarlton.svg.png' and `full_path_hash` = '1383108444' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `uploads` where `full_path` = '2024/07/8/Virgin Hotels.png' and `full_path_hash` = '58602532' limit 1
Metadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
200
0 of 0array:1 [▼ "page" => "2" ]
[]
0 of 0array:15 [▼ "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "sandbox.kenwoodtravel.net" ] ]
0 of 0array:43 [▼ "USER" => "www-data" "HOME" => "/var/www" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "sandbox.kenwoodtravel.net" "PATH_INFO" => "" "SCRIPT_FILENAME" => "/var/www/sandboxkenwood/public/index.php" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "sandbox.kenwoodtravel.net" "SERVER_PORT" => "443" "SERVER_ADDR" => "172.26.9.6" "REMOTE_USER" => "" "REMOTE_PORT" => "2237" "REMOTE_ADDR" => "216.73.216.145" "SERVER_SOFTWARE" => "nginx/1.27.4" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/var/www/sandboxkenwood/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/usa-holidays/luxury?page=2" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "page=2" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1751872197.5074 "REQUEST_TIME" => 1751872197 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 07 Jul 2025 07:09:57 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InU0ZCtqYUM1STgwRkpUKzVNTDJqL1E9PSIsInZhbHVlIjoiekhqd2pWZ2owa3EwVSs3UCtMTEZzQW9qTk8zN0lNaFh5eHBsMXlRKzI4V04wcllGcGJFMXJzV3BBN0c3VWlNWEgwcHZmcDVWbW9NajhzZVJuN3JqWjIwNEFJNFNRcFFMam4zenJwSFNUaTNDUnkrUXNWdEJ3eEh2N0xDbWRXUk0iLCJtYWMiOiIxZmJjOWIwMzRjM2VmMWY1YjFhM2I1YTE0OTA3NjIzYjg4YWJkMThhNDIyNzQ0Zjc1Njc1MDVkZjVhMGY3MjEwIiwidGFnIjoiIn0%3D; expires=Tue, 08 Jul 2025 07:09:58 GMT; Max-Age=86400; path=/; domain=.kenwoodtravel.net; secure; samesite=none ◀XSRF-TOKEN=eyJpdiI6InU0ZCtqYUM1STgwRkpUKzVNTDJqL1E9PSIsInZhbHVlIjoiekhqd2pWZ2owa3EwVSs3UCtMTEZzQW9qTk8zN0lNaFh5eHBsMXlRKzI4V04wcllGcGJFMXJzV3BBN0c3VWlNWEgwcHZmc ▶" 1 => "kenwood_travel_session=eyJpdiI6InE4eEQyS0Z0QmxtVFppSGRyQzFxemc9PSIsInZhbHVlIjoiM3JHSmxYa2VxZ2NvaDZmNUJGMGhZbThlOUI4ZHlCVXo3dTlEY29HaWRrRWo4ZHFmbW5zL0FleXBlelcxK2U3QzZPNFNkd2ozTUF0a0xQL1hURCtXT21vb1lYQTN3WlRQdkI3cWhnYmEvd1BjUXNxYzhOVEE5b1c0TEovOGQrV1oiLCJtYWMiOiJlNGU5OTgxZmQ4NmM2OGRlZWM4YzJmY2FhM2ZiOTVkNzA3ZGQ1MmI2MmViNWU5ZjY5ZDE0ZWMwODUzNWU4YzlmIiwidGFnIjoiIn0%3D; expires=Tue, 08 Jul 2025 07:09:58 GMT; Max-Age=86400; path=/; domain=.kenwoodtravel.net; secure; httponly; samesite=none ◀kenwood_travel_session=eyJpdiI6InE4eEQyS0Z0QmxtVFppSGRyQzFxemc9PSIsInZhbHVlIjoiM3JHSmxYa2VxZ2NvaDZmNUJGMGhZbThlOUI4ZHlCVXo3dTlEY29HaWRrRWo4ZHFmbW5zL0FleXBlelcxK ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InU0ZCtqYUM1STgwRkpUKzVNTDJqL1E9PSIsInZhbHVlIjoiekhqd2pWZ2owa3EwVSs3UCtMTEZzQW9qTk8zN0lNaFh5eHBsMXlRKzI4V04wcllGcGJFMXJzV3BBN0c3VWlNWEgwcHZmcDVWbW9NajhzZVJuN3JqWjIwNEFJNFNRcFFMam4zenJwSFNUaTNDUnkrUXNWdEJ3eEh2N0xDbWRXUk0iLCJtYWMiOiIxZmJjOWIwMzRjM2VmMWY1YjFhM2I1YTE0OTA3NjIzYjg4YWJkMThhNDIyNzQ0Zjc1Njc1MDVkZjVhMGY3MjEwIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 07:09:58 GMT; domain=.kenwoodtravel.net; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InU0ZCtqYUM1STgwRkpUKzVNTDJqL1E9PSIsInZhbHVlIjoiekhqd2pWZ2owa3EwVSs3UCtMTEZzQW9qTk8zN0lNaFh5eHBsMXlRKzI4V04wcllGcGJFMXJzV3BBN0c3VWlNWEgwcHZmc ▶" 1 => "kenwood_travel_session=eyJpdiI6InE4eEQyS0Z0QmxtVFppSGRyQzFxemc9PSIsInZhbHVlIjoiM3JHSmxYa2VxZ2NvaDZmNUJGMGhZbThlOUI4ZHlCVXo3dTlEY29HaWRrRWo4ZHFmbW5zL0FleXBlelcxK2U3QzZPNFNkd2ozTUF0a0xQL1hURCtXT21vb1lYQTN3WlRQdkI3cWhnYmEvd1BjUXNxYzhOVEE5b1c0TEovOGQrV1oiLCJtYWMiOiJlNGU5OTgxZmQ4NmM2OGRlZWM4YzJmY2FhM2ZiOTVkNzA3ZGQ1MmI2MmViNWU5ZjY5ZDE0ZWMwODUzNWU4YzlmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 07:09:58 GMT; domain=.kenwoodtravel.net; path=/; secure; httponly ◀kenwood_travel_session=eyJpdiI6InE4eEQyS0Z0QmxtVFppSGRyQzFxemc9PSIsInZhbHVlIjoiM3JHSmxYa2VxZ2NvaDZmNUJGMGhZbThlOUI4ZHlCVXo3dTlEY29HaWRrRWo4ZHFmbW5zL0FleXBlelcxK ▶" ] ]
0 of 0array:4 [▼ "_token" => "lEN1luxGlMb5xsLt37K7kKjnDe9OWnOoLDYoBDqb" "_previous" => array:1 [▶ "url" => "https://sandbox.kenwoodtravel.net/usa-holidays/luxury?page=2" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]