[]
[]
0 of 0array:22 [▼ "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-connecting-ip" => array:1 [▶ 0 => "3.16.214.124" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-for" => array:1 [▶ 0 => "3.16.214.124" ] "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" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "cf-ray" => array:1 [▶ 0 => "93da52136b582323-ORD" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "host" => array:1 [▶ 0 => "stg.bizzakat.com.my" ] ]
[]
0 of 0array:3 [▼ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 10 May 2025 15:02:59 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] ]
0 of 0array:1 [▼ "_token" => "ex2ojiAn6y94bgVgEEFoLmDtBS4xrKG3Nea0S9AT" ]
| 1 x Application (99.01%) | 2.10s |
| 1 x Preparing Response (94.94%) | 2.01s |
| 1 x Booting (0.99%) | 20.99ms |
| 1 x Routing (0.07%) | 1.42ms |
| 1 x View (0%) | 0μs |
| Backtrace |
|
select * from "merchant_categories" where "slug" in ('syarikat-perkhidmatan') and "merchant_categories"."deleted_at" is null limit 1| Bindings |
|
| Backtrace |
|
select * from "merchant_categories" where "merchant_categories"."parent_id" in (52) and "merchant_categories"."deleted_at" is null| Backtrace |
|
select count(*) as aggregate from "merchants" where exists (select * from "merchant_categories" where "merchants"."merchant_category_id" = "merchant_categories"."id" and "id" in (52) and "merchant_categories"."deleted_at" is null) and "status_id" = 5 and "merchants"."deleted_at" is null| Bindings |
|
| Backtrace |
|
select * from "merchants" where exists (select * from "merchant_categories" where "merchants"."merchant_category_id" = "merchant_categories"."id" and "id" in (52) and "merchant_categories"."deleted_at" is null) and "status_id" = 5 and "merchants"."deleted_at" is null order by "title" asc limit 50 offset 0| Bindings |
|
| Backtrace |
|
select * from "cities" where "cities"."id" in (838, 1047, 1052, 1081, 1082, 1164, 1202, 1206, 1208, 1213, 1246, 1320, 1339, 1351, 1354, 1356, 1358, 1366, 1568, 1569, 1571, 1576, 1577, 1579, 1580, 1604, 1605, 1606, 1607, 1621, 1624, 1692, 1693, 2125)| Backtrace |
|
select * from "states" where "states"."id" in (4, 5, 8, 9, 12, 14)| Backtrace |
|
select * from "cities" where "cities"."state_id" in (4, 5, 8, 9, 12, 14) order by "postcode" asc| Backtrace |
|
select * from "merchant_categories" where "merchant_categories"."id" in (52) and "merchant_categories"."deleted_at" is null| Backtrace |
|
select "merchant_transactions".* from "merchant_transactions" inner join (select MAX("merchant_transactions"."id") as "id_aggregate", min("merchant_transactions"."payment_at") as "payment_at_aggregate", "merchant_transactions"."merchant_id" from "merchant_transactions" inner join (select MAX("merchant_transactions"."payment_at") as "payment_at_aggregate", "merchant_transactions"."merchant_id" from "merchant_transactions" where "merchant_transactions"."merchant_id" in (32, 73, 246, 287, 317, 393, 462, 520, 522, 524, 602, 655, 725, 824, 828, 865, 929, 969, 1002, 1006, 1008, 1088, 1126, 1198, 1277, 1348, 1493, 1523, 1526, 1528, 1569, 1570, 1575, 1576, 1614, 1615, 1798, 1801, 1891, 1892, 1894, 1957, 1986, 2029, 2072, 2249, 4996, 4997, 5082, 5136) and "merchant_transactions"."deleted_at" is null group by "merchant_transactions"."merchant_id") as "latestOfMany" on "latestOfMany"."payment_at_aggregate" = "merchant_transactions"."payment_at" and "latestOfMany"."merchant_id" = "merchant_transactions"."merchant_id" where "merchant_transactions"."deleted_at" is null group by "merchant_transactions"."merchant_id") as "latestOfMany" on "latestOfMany"."id_aggregate" = "merchant_transactions"."id" and "latestOfMany"."payment_at_aggregate" = "merchant_transactions"."payment_at" and "latestOfMany"."merchant_id" = "merchant_transactions"."merchant_id" where "merchant_transactions"."deleted_at" is null| Backtrace |
|
select * from "merchant_levels" where "merchant_levels"."id" in (0, 1, 2, 3, 4) and "merchant_levels"."deleted_at" is null| Backtrace |
|
select * from "media" where "media"."model_id" in (32, 73, 246, 287, 317, 393, 462, 520, 522, 524, 602, 655, 725, 824, 828, 865, 929, 969, 1002, 1006, 1008, 1088, 1126, 1198, 1277, 1348, 1493, 1523, 1526, 1528, 1569, 1570, 1575, 1576, 1614, 1615, 1798, 1801, 1891, 1892, 1894, 1957, 1986, 2029, 2072, 2249, 4996, 4997, 5082, 5136) and "media"."model_type" = 'App\Models\Merchant'| Bindings |
|
| Backtrace |
|