hotelId
activityId
result
address_list
planner_id
tripPlanner
__env
app
errors
date1
date2
diff
days
__currentLoopData
row
loop
europeCountries
northCountries
asiaCountries
africaCountries
southCountries
oceaniaCountries
antarcticaCountries
restCountries
select * from `trip_planner` where `id` = '784' limit 1
select * from `trip_destination` where `trip_destination`.`trip_id` in (784)
(select hotels.latitude,hotels.longitude,hotels.slug,hotels.description,hotels.id,hotels.stars,hotels.hotel_name,trip_detail.id,trip_detail.order_no as order_all,trip_detail.category_id,photo,instance_id from `trip_detail` inner join `hotels` on `hotels`.`id` = `trip_detail`.`place_id` inner join `photos` on `hotels`.`id` = `photos`.`instance_id` where `trip_id` = '784' and `trip_detail`.`category_id` = 3 and `photos`.`category_id` = 3 and `date` = '2019-12-12' group by `photos`.`instance_id`) union (select addresses.latitude,addresses.longitude,places.slug,places.description,places.id,places.stars,places.place_name,trip_detail.id,trip_detail.order_no as order_all,trip_detail.category_id,photo,instance_id from `trip_detail` inner join `places` on `places`.`id` = `trip_detail`.`place_id` inner join `addresses` on `addresses`.`instant_id` = `places`.`id` inner join `photos` on `places`.`id` = `photos`.`instance_id` where `trip_id` = '784' and (`trip_detail`.`category_id` = 4 or `trip_detail`.`category_id` = 2) and (`addresses`.`category_id` = 4 or `addresses`.`category_id` = 2) and (`photos`.`category_id` = 4 or `photos`.`category_id` = 2) and `date` = '2019-12-12' group by `photos`.`instance_id`) union (select addresses.latitude,addresses.longitude,restaurants.slug,restaurants.description,restaurants.id,restaurants.stars,restaurants.restaurant_name,trip_detail.id,trip_detail.order_no as order_all,trip_detail.category_id,photo,instance_id from `trip_detail` inner join `restaurants` on `restaurants`.`id` = `trip_detail`.`place_id` inner join `addresses` on `addresses`.`instant_id` = `restaurants`.`id` inner join `photos` on `restaurants`.`id` = `photos`.`instance_id` where `trip_id` = '784' and `photos`.`category_id` = 1 and `addresses`.`category_id` = 1 and `trip_detail`.`category_id` = 1 and `date` = '2019-12-12' group by `photos`.`instance_id`) order by order_all ASC
select `code`, `name`, `continent`, `continentName`, `isoNumeric`, `currencyCode` from `countries` where `status` = 'Active' and `countries`.`order_no` != '0' order by `countries`.`order_no` asc
200
[]
0 of 0 array:16 [▼ "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" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "host" => array:1 [▶ 0 => "visitanycity.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "x-https" => array:1 [▶ 0 => "1" ] ]
0 of 0 array:53 [▼ "PATH" => "/usr/local/bin:/bin:/usr/bin" "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_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_HOST" => "visitanycity.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "HTTP_X_HTTPS" => "1" "DOCUMENT_ROOT" => "/home/ua815598/public_html/visitanycity.com/public" "REMOTE_ADDR" => "3.128.202.17" "REMOTE_PORT" => "64948" "SERVER_ADDR" => "138.201.211.238" "SERVER_NAME" => "visitanycity.com" "SERVER_ADMIN" => "webmaster@visitanycity.ua815598.serversignin.com" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/trip-planner/trip-detail/784" "REDIRECT_URL" => "/trip-planner/trip-detail/784" "REDIRECT_REQUEST_METHOD" => "GET" "GEOIP_ADDR" => "3.128.202.17" "GEOIP_COUNTRY_CODE" => "US" "GEOIP_CONTINENT_CODE" => "NA" "GEOIP_LATITUDE" => "37.75100" "GEOIP_LONGITUDE" => "-97.82200" "HTTPS" => "on" "LANG" => "en_US.UTF-8" "REDIRECT_STATUS" => "200" "X_SPDY" => "HTTP2" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256" "SSL_CIPHER_USEKEYSIZE" => "128" "SSL_CIPHER_ALGKEYSIZE" => "128" "SCRIPT_FILENAME" => "/home/ua815598/public_html/visitanycity.com/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://visitanycity.com/trip-planner/trip-detail/784" "SCRIPT_URL" => "/trip-planner/trip-detail/784" "SCRIPT_NAME" => "/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1749038630.0506 "REQUEST_TIME" => 1749038630 ]
0 of 0 array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 04 Jun 2025 12:03:50 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImVuS3hES0ludytyME5va3pqUzBIeVE9PSIsInZhbHVlIjoicUFBdXZ1cWM3ZlNhaXZOMmlueTVSbm0zQkczaWQzOFpTTEJSOUN6cUJ5VGdFNndCWVdZZS9lMkJhTGRJVHBZNUt1UHh1MUx2MTR0L3B2Vnp2b0Jqc0REdThBekRML1Q5aHR5RFZOS3M0R1dqMHNybWduSDRYT1VsOG40WG1xUzQiLCJtYWMiOiIzYzFlYjc0ZTc0MDc2M2MzMTcwZjM1MDkyZTAyZTYzOTg1ZGFjZjQzZmFmNzBlZDY5MjczZmRkM2UxNmY5MGE3IiwidGFnIjoiIn0%3D; expires=Wed, 04-Jun-2025 14:03:50 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImVuS3hES0ludytyME5va3pqUzBIeVE9PSIsInZhbHVlIjoicUFBdXZ1cWM3ZlNhaXZOMmlueTVSbm0zQkczaWQzOFpTTEJSOUN6cUJ5VGdFNndCWVdZZS9lMkJhTGRJVHBZNUt1UHh1M ▶" 1 => "laravel_session=eyJpdiI6IkllQmdGb1NJWkdGakl2NXV0NXBPeHc9PSIsInZhbHVlIjoiaGpXSW5MWGhUM0lvR2lFRTAzRnRKV1VuWnVMM1dkVzBkd1g3U1QrNTNsMWw3d252ODk1dDlURFh6NHpTUmptbFY5Tkx0SUQxYXlJKzdlcmI3Rnh1dlBuVDZ1bXdIbjErVW90TzZuekc4Vjc4TVNYU2xaV3hEbTRaVGYwLzZMQTciLCJtYWMiOiIxZmYyMDM2ODUzMzg0ZmIyZjNlMmE4YmRmM2JkMTcwMjIzZDUzZTE4NzQ0ZTI4Y2ZiNDkzMTkzNTA4NmI1ZWMwIiwidGFnIjoiIn0%3D; expires=Wed, 04-Jun-2025 14:03:50 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkllQmdGb1NJWkdGakl2NXV0NXBPeHc9PSIsInZhbHVlIjoiaGpXSW5MWGhUM0lvR2lFRTAzRnRKV1VuWnVMM1dkVzBkd1g3U1QrNTNsMWw3d252ODk1dDlURFh6NHpTUmptbFY5 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImVuS3hES0ludytyME5va3pqUzBIeVE9PSIsInZhbHVlIjoicUFBdXZ1cWM3ZlNhaXZOMmlueTVSbm0zQkczaWQzOFpTTEJSOUN6cUJ5VGdFNndCWVdZZS9lMkJhTGRJVHBZNUt1UHh1MUx2MTR0L3B2Vnp2b0Jqc0REdThBekRML1Q5aHR5RFZOS3M0R1dqMHNybWduSDRYT1VsOG40WG1xUzQiLCJtYWMiOiIzYzFlYjc0ZTc0MDc2M2MzMTcwZjM1MDkyZTAyZTYzOTg1ZGFjZjQzZmFmNzBlZDY5MjczZmRkM2UxNmY5MGE3IiwidGFnIjoiIn0%3D; expires=Wed, 04-Jun-2025 14:03:50 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVuS3hES0ludytyME5va3pqUzBIeVE9PSIsInZhbHVlIjoicUFBdXZ1cWM3ZlNhaXZOMmlueTVSbm0zQkczaWQzOFpTTEJSOUN6cUJ5VGdFNndCWVdZZS9lMkJhTGRJVHBZNUt1UHh1M ▶" 1 => "laravel_session=eyJpdiI6IkllQmdGb1NJWkdGakl2NXV0NXBPeHc9PSIsInZhbHVlIjoiaGpXSW5MWGhUM0lvR2lFRTAzRnRKV1VuWnVMM1dkVzBkd1g3U1QrNTNsMWw3d252ODk1dDlURFh6NHpTUmptbFY5Tkx0SUQxYXlJKzdlcmI3Rnh1dlBuVDZ1bXdIbjErVW90TzZuekc4Vjc4TVNYU2xaV3hEbTRaVGYwLzZMQTciLCJtYWMiOiIxZmYyMDM2ODUzMzg0ZmIyZjNlMmE4YmRmM2JkMTcwMjIzZDUzZTE4NzQ0ZTI4Y2ZiNDkzMTkzNTA4NmI1ZWMwIiwidGFnIjoiIn0%3D; expires=Wed, 04-Jun-2025 14:03:50 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkllQmdGb1NJWkdGakl2NXV0NXBPeHc9PSIsInZhbHVlIjoiaGpXSW5MWGhUM0lvR2lFRTAzRnRKV1VuWnVMM1dkVzBkd1g3U1QrNTNsMWw3d252ODk1dDlURFh6NHpTUmptbFY5 ▶" ] ]
0 of 0 array:4 [▼ "_token" => "sLCS2SaBxegIUFdxZBlZrlU90JpnwNgYlRlcbvTO" "_previous" => array:1 [▶ "url" => "https://visitanycity.com/trip-planner/trip-detail/784" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]