This website requires cookies to provide all of its features. By using our website, you agree to our use of cookies. More info
row
disable_lazyload
wrap_class
rows
list_location
region_location
car_min_max_price
markers
blank
seo_meta
layout
attributes
__env
app
errors
search_fields
__currentLoopData
field
loop
paginator
elements
favicon
file
logo_id
logo
info_contact
list_widget_footers
item
key
select count(*) as aggregate from (select `bravo_cars`.*, CASE WHEN IFNULL( bravo_cars.sale_price, 0 ) > 0 THEN bravo_cars.sale_price ELSE bravo_cars.price END AS tmp_min_price from `bravo_cars` where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null group by `bravo_cars`.`id`) as `aggregate_table`
select `bravo_cars`.*, CASE WHEN IFNULL( bravo_cars.sale_price, 0 ) > 0 THEN bravo_cars.sale_price ELSE bravo_cars.price END AS tmp_min_price from `bravo_cars` where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null group by `bravo_cars`.`id` order by `tmp_min_price` asc limit 9 offset 0
select * from `bravo_locations` where 0 = 1 and `bravo_locations`.`deleted_at` is null
SELECT *
select * from `user_wishlist` where `object_model` = 'car' and `user_id` = 0 and `user_wishlist`.`object_id` in (10, 14, 20, 21, 22, 23, 24)
select * from `bravo_car_translations` where `locale` = 'fr' and `bravo_car_translations`.`origin_id` in (10, 14, 20, 21, 22, 23, 24) and `bravo_car_translations`.`deleted_at` is null
select * from `media_files` where `media_files`.`id` = '155' and `media_files`.`deleted_at` is null limit 1
LIMIT
ORDER BY
select * from `media_files` where `media_files`.`id` = '156' and `media_files`.`deleted_at` is null limit 1
select * from `media_files` where `media_files`.`id` = '157' and `media_files`.`deleted_at` is null limit 1
select * from `media_files` where `media_files`.`id` = '158' and `media_files`.`deleted_at` is null limit 1
select * from `media_files` where `media_files`.`id` = '159' and `media_files`.`deleted_at` is null limit 1
select * from `media_files` where `media_files`.`id` = '160' and `media_files`.`deleted_at` is null limit 1
select * from `media_files` where `media_files`.`id` = '161' and `media_files`.`deleted_at` is null limit 1
select * from `cathay_countries` where `name` is null limit 1
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1
select * from `bravo_locations` where `status` = 'publish' and `parent_id` = 70 and `bravo_locations`.`deleted_at` is null order by `name` asc limit 1000
select * from `bravo_location_translations` where `locale` = 'fr' and `bravo_location_translations`.`origin_id` in (11, 12, 13, 14, 15, 16, 17, 18, 90, 93, 95, 97, 99, 104)
select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 1000
select * from `bravo_location_translations` where `locale` = 'fr' and `bravo_location_translations`.`origin_id` in (11, 12, 13, 14, 15, 16, 17, 18, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188)
select MIN( CASE WHEN sale_price > 0 THEN sale_price ELSE ( price ) END ) AS min_price , MAX( CASE WHEN sale_price > 0 THEN sale_price ELSE ( price ) END ) AS max_price from `bravo_cars` where `status` = 'publish' and `bravo_cars`.`deleted_at` is null limit 1
select * from `bravo_attrs` where `service` = 'car' and `bravo_attrs`.`deleted_at` is null order by `position` desc
select `bravo_terms`.*, (select count(*) from `bravo_cars` inner join `bravo_car_term` on `bravo_cars`.`id` = `bravo_car_term`.`target_id` where `bravo_terms`.`id` = `bravo_car_term`.`term_id` and `bravo_cars`.`deleted_at` is null) as `car_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (9, 10) and `bravo_terms`.`deleted_at` is null
select * from `bravo_terms_translations` where `locale` = 'fr' and `bravo_terms_translations`.`origin_id` in (61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74)
select * from `bravo_attrs_translations` where `locale` = 'fr' and `bravo_attrs_translations`.`origin_id` in (9, 10)
select * from `media_files` where `media_files`.`id` = '10' and `media_files`.`deleted_at` is null limit 1
select * from `media_files` where `media_files`.`id` = '62' and `media_files`.`deleted_at` is null limit 1
select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'fr' limit 1
select * from `core_pages` where `core_pages`.`id` = '' and `core_pages`.`deleted_at` is null limit 1
200
0 of 0 array:1 [▼ "orderby" => "price_low_high" ]
[]
0 of 0 array:20 [▼ "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImgzVlNUdk9scnJpQUhKcmF3WmZhZkE9PSIsInZhbHVlIjoidm5yQmlCZkhhRC9xNGdKaHRrUytWMlh1ZUdyMlVXeU1EK0p6WWxvd1RSaVlhZlJodVRZMkxhQW5XaTBsWWlKZHBFclNGRGF0UkhVMXRleGlPUzBKQmJVZ3N2dk9aOW1uM3dpckxxVmtTeTM5eG1ITGxnSjV4TmJRQ3llVDc1R2kiLCJtYWMiOiJhNDMxM2Y0MTFkYjVjN2QzNGI2ZjRhMzI5NGFiMjg4MjM3NTRjZGVhMzI4MDI0NTRkNDZmMTg5MGZkMTVjNGYzIiwidGFnIjoiIn0%3D; cathay_tours_session=eyJpdiI6IlNzMDBTY1lYQTFXNWw2NDE3TWJWZVE9PSIsInZhbHVlIjoiUGhlNExMS0FuVVA2SHVyaTRVVk1YR3hFdHlXUDZyZHllck43cnlOa2pmTHJIQi9iQjhIUUNMZllQaDh2cXozaWFRZkY1OThDdHdKZHZDZVRYU2tRMTFPcUljNXhMRW5VTkgwSmg4eXRPRTBwTTZVUC9jSFFUb0VpbDYySXJWUE0iLCJtYWMiOiJjMWVmMDEyNWYyNTc4N2E3YTZhOWNmNWRiMjk2MjI3MGEyY2VkMzBmZTI2Y2FmM2YwOTgxZTdiMzZmZmJkYjJjIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImgzVlNUdk9scnJpQUhKcmF3WmZhZkE9PSIsInZhbHVlIjoidm5yQmlCZkhhRC9xNGdKaHRrUytWMlh1ZUdyMlVXeU1EK0p6WWxvd1RSaVlhZlJodVRZMkxhQW5XaTBsWWlKZHBFclNGR ▶" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "close" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-for" => array:1 [▶ 0 => "3.135.203.93" ] "x-server-addr" => array:1 [▶ 0 => "178.63.83.98" ] "host" => array:1 [▶ 0 => "cathayv2.b-wi.mu" ] ]
0 of 0 array:54 [▼ "USER" => "runcloud" "HOME" => "/home/runcloud" "SCRIPT_NAME" => "/public/index.php" "REQUEST_URI" => "/fr/car?orderby=price_low_high" "QUERY_STRING" => "orderby=price_low_high" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "orderby=price_low_high" "REDIRECT_URL" => "/public/fr/car" "REMOTE_PORT" => "57974" "SCRIPT_FILENAME" => "/home/runcloud/webapps/Cathay-V2/public/index.php" "SERVER_ADMIN" => "you@example.com" "CONTEXT_DOCUMENT_ROOT" => "/home/runcloud/webapps/Cathay-V2/" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "http" "DOCUMENT_ROOT" => "/home/runcloud/webapps/Cathay-V2/" "REMOTE_ADDR" => "3.135.203.93" "SERVER_PORT" => "80" "SERVER_ADDR" => "127.0.0.1" "SERVER_NAME" => "cathayv2.b-wi.mu" "SERVER_SOFTWARE" => "Apache/2.4.63 (Unix) OpenSSL/3.0.2" "SERVER_SIGNATURE" => "" "LD_LIBRARY_PATH" => "/RunCloud/Packages/apache2-rc/lib" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6ImgzVlNUdk9scnJpQUhKcmF3WmZhZkE9PSIsInZhbHVlIjoidm5yQmlCZkhhRC9xNGdKaHRrUytWMlh1ZUdyMlVXeU1EK0p6WWxvd1RSaVlhZlJodVRZMkxhQW5XaTBsWWlKZHBFclNGRGF0UkhVMXRleGlPUzBKQmJVZ3N2dk9aOW1uM3dpckxxVmtTeTM5eG1ITGxnSjV4TmJRQ3llVDc1R2kiLCJtYWMiOiJhNDMxM2Y0MTFkYjVjN2QzNGI2ZjRhMzI5NGFiMjg4MjM3NTRjZGVhMzI4MDI0NTRkNDZmMTg5MGZkMTVjNGYzIiwidGFnIjoiIn0%3D; cathay_tours_session=eyJpdiI6IlNzMDBTY1lYQTFXNWw2NDE3TWJWZVE9PSIsInZhbHVlIjoiUGhlNExMS0FuVVA2SHVyaTRVVk1YR3hFdHlXUDZyZHllck43cnlOa2pmTHJIQi9iQjhIUUNMZllQaDh2cXozaWFRZkY1OThDdHdKZHZDZVRYU2tRMTFPcUljNXhMRW5VTkgwSmg4eXRPRTBwTTZVUC9jSFFUb0VpbDYySXJWUE0iLCJtYWMiOiJjMWVmMDEyNWYyNTc4N2E3YTZhOWNmNWRiMjk2MjI3MGEyY2VkMzBmZTI2Y2FmM2YwOTgxZTdiMzZmZmJkYjJjIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImgzVlNUdk9scnJpQUhKcmF3WmZhZkE9PSIsInZhbHVlIjoidm5yQmlCZkhhRC9xNGdKaHRrUytWMlh1ZUdyMlVXeU1EK0p6WWxvd1RSaVlhZlJodVRZMkxhQW5XaTBsWWlKZHBFclNGR ▶" "HTTP_PRIORITY" => "u=0, i" "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "close" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_FOR" => "3.135.203.93" "HTTP_X_SERVER_ADDR" => "178.63.83.98" "HTTP_HOST" => "cathayv2.b-wi.mu" "HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_HTTPS" => "on" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_HTTPS" => "on" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1745924820.9677 "REQUEST_TIME" => 1745924820 ]
0 of 0 array:2 [▼ "XSRF-TOKEN" => "QJnmqOEka2rGcO61mXTz5XLMccQpiQY0UYMqdJUu" "cathay_tours_session" => "baR2K86Qg242foevRnEHTMPkL0WdLMuAz8lKtxti" ]
0 of 0 array:7 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Tue, 29 Apr 2025 11:07:01 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InhHOGMxRHNSdm9YQXJHVkpiUWlNQmc9PSIsInZhbHVlIjoiSTVQZjRRUlM3WVpnUW5kZkFhTkZVM3ZDbVk3UUN2eUw4dm0xRFQwYVc4YnMyNmx6MVJQYWsyTGhJSVpybHp1SXZMY09DTElaTDY2WElZdUdIaXgwaGFuM3NBSEVnUmRMTlZ3Vks4Qzg1aXZsZEU3YTBaWWMxNmpBQXJYRlVGR0EiLCJtYWMiOiI5NjA3NmZmMWQ5YTY3OWI2YzE2MWY1MWM0NDY5YTYxYWM0NzAzZDFkMmEyZjMzNDY0ZDIzOWU3NjJjMTNiYTRhIiwidGFnIjoiIn0%3D; expires=Tue, 29 Apr 2025 13:07:01 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InhHOGMxRHNSdm9YQXJHVkpiUWlNQmc9PSIsInZhbHVlIjoiSTVQZjRRUlM3WVpnUW5kZkFhTkZVM3ZDbVk3UUN2eUw4dm0xRFQwYVc4YnMyNmx6MVJQYWsyTGhJSVpybHp1SXZMY09DT ▶" 1 => "cathay_tours_session=eyJpdiI6IlRiQmttMjlWTVZhV0RIenAzL2RSSWc9PSIsInZhbHVlIjoiYnZrT3AzVFJNVTRDRWhIMTYvWHNoeGI0U016Ym1qWDNEQXFJYlRDZ2lCVnYvTFR5NE50eFVGaTRaWTFySlIwVEdub2syTnJ0VFljOHB6MmlsTU56M2c0TDIvQTB6SmhUamxmd1ZuUzg1bWNxOGNKc01NNUlyckxzUUNWUHd2bG4iLCJtYWMiOiI1Y2U5OGIwYWQzYzAzNzg4YTI4MDJmYjhlZTExYWI5ZmY3Y2FjY2E5NmFlNjllYWQ0NzA3YjRhYjU3OWRmYTg4IiwidGFnIjoiIn0%3D; expires=Tue, 29 Apr 2025 13:07:01 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cathay_tours_session=eyJpdiI6IlRiQmttMjlWTVZhV0RIenAzL2RSSWc9PSIsInZhbHVlIjoiYnZrT3AzVFJNVTRDRWhIMTYvWHNoeGI0U016Ym1qWDNEQXFJYlRDZ2lCVnYvTFR5NE50eFVGaTRaWTFySlI ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InhHOGMxRHNSdm9YQXJHVkpiUWlNQmc9PSIsInZhbHVlIjoiSTVQZjRRUlM3WVpnUW5kZkFhTkZVM3ZDbVk3UUN2eUw4dm0xRFQwYVc4YnMyNmx6MVJQYWsyTGhJSVpybHp1SXZMY09DTElaTDY2WElZdUdIaXgwaGFuM3NBSEVnUmRMTlZ3Vks4Qzg1aXZsZEU3YTBaWWMxNmpBQXJYRlVGR0EiLCJtYWMiOiI5NjA3NmZmMWQ5YTY3OWI2YzE2MWY1MWM0NDY5YTYxYWM0NzAzZDFkMmEyZjMzNDY0ZDIzOWU3NjJjMTNiYTRhIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 13:07:01 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InhHOGMxRHNSdm9YQXJHVkpiUWlNQmc9PSIsInZhbHVlIjoiSTVQZjRRUlM3WVpnUW5kZkFhTkZVM3ZDbVk3UUN2eUw4dm0xRFQwYVc4YnMyNmx6MVJQYWsyTGhJSVpybHp1SXZMY09DT ▶" 1 => "cathay_tours_session=eyJpdiI6IlRiQmttMjlWTVZhV0RIenAzL2RSSWc9PSIsInZhbHVlIjoiYnZrT3AzVFJNVTRDRWhIMTYvWHNoeGI0U016Ym1qWDNEQXFJYlRDZ2lCVnYvTFR5NE50eFVGaTRaWTFySlIwVEdub2syTnJ0VFljOHB6MmlsTU56M2c0TDIvQTB6SmhUamxmd1ZuUzg1bWNxOGNKc01NNUlyckxzUUNWUHd2bG4iLCJtYWMiOiI1Y2U5OGIwYWQzYzAzNzg4YTI4MDJmYjhlZTExYWI5ZmY3Y2FjY2E5NmFlNjllYWQ0NzA3YjRhYjU3OWRmYTg4IiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 13:07:01 GMT; path=/; httponly ◀cathay_tours_session=eyJpdiI6IlRiQmttMjlWTVZhV0RIenAzL2RSSWc9PSIsInZhbHVlIjoiYnZrT3AzVFJNVTRDRWhIMTYvWHNoeGI0U016Ym1qWDNEQXFJYlRDZ2lCVnYvTFR5NE50eFVGaTRaWTFySlI ▶" ] ]
0 of 0 array:5 [▼ "_token" => "QJnmqOEka2rGcO61mXTz5XLMccQpiQY0UYMqdJUu" "bc_current_currency" => "gbp" "_previous" => array:1 [▶ "url" => "https://cathayv2.b-wi.mu/fr/car?orderby=price_low_high" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]