PrimodishNew

Messages6 Request302 Found Timeline Exceptions Views68 Queries205 Models769 Livewire0 Mails Gate

Settings Request history2983ms10MB10.xGET home/{type?}

warninglog[18:58:20] LOG.warning: json_decode(): Passing null to parameter #1 ($json) of type string is deprec...
warninglog[18:58:20] LOG.warning: urldecode(): Passing null to parameter #1 ($string) of type string is deprec...
warninglog[18:58:20] LOG.warning: json_decode(): Passing null to parameter #1 ($json) of type string is deprec...
warninglog[18:58:21] LOG.warning: json_decode(): Passing null to parameter #1 ($json) of type string is deprec...
warninglog[18:58:21] LOG.warning: json_decode(): Passing null to parameter #1 ($json) of type string is deprec...
warninglog[18:58:21] LOG.warning: json_decode(): Passing null to parameter #1 ($json) of type string is deprec...

status

200 OK

full_url

https://primodishnew.webmavens.com/home

action_name

home

controller_action

App\Http\Controllers\HomeController@search

uri

GET home/{type?}

controller

App\Http\Controllers\HomeController@search

namespace

App\Http\Controllers

file

app/Http/Controllers/HomeController.php:427-608

middleware

web, customheaders

duration

995ms

peak_memory

16MB

response

text/html; charset=UTF-8

request_format

html

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkFaYmh6ckFBbjVycmRnZGdRMTkraUE9PSIsInZhbHVlIjoiM0d6Z0tuWEFVcHQwbXVNYVVtYUdwSVNYMkdJTmVLK1N1aGFicWQ2THNUWW9xbUUrVWgwdUpnV254MGVMbHNQNUFVMTdaSHoyKy9FZEdCOXo1RW50Ym9VR01KN1pjcWFqMk90Z2lmMEFwb0RObGVnUlcyaFNwNzBxUHFqbUVBVHEiLCJtYWMiOiI1Y2NmOTJjMTdiY2I4ZjEyM2I0NDBiN2E3YWU3MzIwY2ZiZWRlOTIxMTlkZjJiODFiZDcyMWU5YWFkM2RiNzQ5IiwidGFnIjoiIn0%3D; primodishnew_session=eyJpdiI6InlBaGxuUTdEYUpyeDlxKytoTkV6Unc9PSIsInZhbHVlIjoicE81M0k1WmVUS2VLZ3pYUHYzaUJKTWNET3d4b0x4ekxEQmR6cWEwRjNiRjEvakQxNUtUY0dRU2JpalR3ZjJQM0NJNUc0cnJGLzJjOUZ2bXhDU3RrMjNGdGlabUt2TU8zaWY0NXkxcjJWQWtRb25HeFFMTzRrSUo1S25tbE9GQTYiLCJtYWMiOiJiYjQ3MmM2ODNkYTE2NTg0OGQ2NzI4Njc2NGMyZjhmZGE5YmZiNTU4OTBjMDUwODQ3NDNiY2VmNjA0YmY3ODkxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkFaYmh6ckFBbjVycmRnZGdRMTkraUE9PSIsInZhbHVlIjoiM0d6Z0tuWEFVcHQwbXVNYVVtYUdwSVNYMkdJTmVLK1N1aGFicWQ2THNUWW9xbUUrVWgwdUpnV254MGVMbHNQNUFVMTdaS ▶"
  ]
  "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "primodishnew.webmavens.com"
  ]
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "8mpXmLYZqLUWewzVvMhnVWAQttJcqOFuhymTx4UP"
  "primodishnew_session" => "seQ5x8zZDRKR44nDlflbcJ60snxdksiTa1JshlIz"
]

response_headers

  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 14 May 2025 23:58:21 GMT"
  ]
]

session_attributes

  0 of 0   
array:10 [▼
  "_token" => "8mpXmLYZqLUWewzVvMhnVWAQttJcqOFuhymTx4UP"
  "lastActivityTime" => 1747267100
  "Latitude" => "30.26715"
  "Longitude" => "-97.74306"
  "formatted_address" => "Austin, TX, USA"
  "failure" => "Visitor Not Found!"
  "_flash" => array:2 [▶
    "new" => []
    "old" => array:1 [▶
      0 => "failure"
    ]
  ]
  "PHPDEBUGBAR_STACK_DATA" => array:1 [▶
    "01JV8KR85JSWRW1J9CJ636NZDX" => null
  ]
  "_previous" => array:1 [▶
    "url" => "https://primodishnew.webmavens.com/visitor_list/121?sortby=ztoa"
  ]
  "searchText" => ""
]

Booting (30.48ms)time
Application (953ms)time
Routing (936μs)
Preparing Response (852ms)
View: searchviews
View: partials.sortformviews
View: partials.filtersformviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.dishlistingviews
View: partials.dishlistingimageviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: pagination::tailwindviews
View: layouts.masterviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
1 x Application (96.9%)
953ms
1 x Preparing Response (86.66%)
852ms
1 x Booting (3.1%)
30.48ms
1 x Routing (0.1%)
936μs
68 x View (0%)
0μs

68 templates were rendered

1x searchsearch.blade.php#?blade
1x partials.sortformsortform.blade.php#?blade
1x partials.filtersformfiltersform.blade.php#?blade
10x partials.dishlistingdishlisting.blade.php#?blade
10x partials.dishlistingimagedishlistingimage.blade.php#?blade
43x partials.popup_login_buttonpopup_login_button.blade.php#?blade
1x pagination::tailwindtailwind.blade.php#?blade
1x layouts.mastermaster.blade.php#?blade

205 statements were executed (191 duplicates)Show only duplicates primodishnew247ms

# Query soft limit for Debugbar is reached after 100 queries, additional 105 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)

HomeController.php#454primodishnewConnection Established

Backtrace

app/Http/Controllers/HomeController.php:454
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

HomeController.php#454primodishnew3.41msselect `name`, `id` from `dish_categories` where `dish_categories`.`deleted_at` is null

Backtrace

app/Http/Controllers/HomeController.php:454
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

HomeController.php#455primodishnew580μsselect `name`, `id` from `m_dietry_considerations` where `m_dietry_considerations`.`deleted_at` is null

Backtrace

app/Http/Controllers/HomeController.php:455
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

EstablishmentController.php#94primodishnew11.25ms

select establishments.*,(3961 * acos(cos(radians(30.26715))
* cos(radians(establishments.lat))
* cos(radians(establishments.lng)
- radians(-97.74306))
+ sin(radians(30.26715))
* sin(radians(establishments.lat)))) AS distance from `establishments` where `establishments`.`deleted_at` is null having `distance` < 5 order by `distance` asc

Bindings	0: 5
Backtrace	app/Http/Controllers/EstablishmentController.php:94 app/Http/Controllers/HomeController.php:934 app/Http/Controllers/HomeController.php:458 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

HomeController.php#581primodishnew17.05ms

select distinct `dishes`.*, (select avg(`reviews`.`rating`) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `latest_reviews_avg_rating`, (select count(*) from `reviews` where `dishes`.`id` = `reviews`.`dish_id` and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null) as `latest_reviews_count` from `dishes` where exists (select * from `establishments` where `dishes`.`restaurant_id` = `establishments`.`id` and `closed` != '1' and `establishments`.`deleted_at` is null) and `moderate` = 'Approved' and `restaurant_id` in (422, 156, 147, 157, 151, 148, 133, 207, 332, 360, 174, 173, 362, 109, 98, 385, 386, 450, 163, 365, 283, 420, 310, 176, 282, 258, 175, 177, 406, 183, 286, 69, 219, 185, 59, 246, 171, 294, 440, 429, 222, 99, 72, 268, 416, 314, 229, 132, 193, 366, 202, 448, 210, 415, 200, 197, 387, 170, 92, 382, 198, 201, 318, 199, 239, 70, 90, 203, 346, 114, 117, 373) and `dishes`.`deleted_at` is null and `moderate` = 'Approved' having `latest_reviews_count` >= 1 order by `latest_reviews_avg_rating` desc

Bindings

0: Approved
1: Approved
2: 1
3: Approved
4: 422
5: 156
6: 147
7: 157
8: 151
9: 148
10: 133
11: 207
12: 332
13: 360
14: 174
15: 173
16: 362
17: 109
18: 98
19: 385
20: 386
21: 450
22: 163
23: 365
24: 283
25: 420
26: 310
27: 176
28: 282
29: 258
30: 175
31: 177
32: 406
33: 183
34: 286
35: 69
36: 219
37: 185
38: 59
39: 246
40: 171
41: 294
42: 440
43: 429
44: 222
45: 99
46: 72
47: 268
48: 416
49: 314
50: 229
51: 132
52: 193
53: 366
54: 202
55: 448
56: 210
57: 415
58: 200
59: 197
60: 387
61: 170
62: 92
63: 382
64: 198
65: 201
66: 318
67: 199
68: 239
69: 70
70: 90
71: 203
72: 346
73: 114
74: 117
75: 373
76: Approved
77: 1

Backtrace

app/Http/Controllers/HomeController.php:581
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

HomeController.php#581primodishnew2.86ms

select * from `establishments` where `establishments`.`id` in (59, 69, 70, 90, 99, 114, 132, 170, 171, 176, 177, 183, 185, 193, 197, 198, 203, 210, 222, 239, 246, 258, 268, 282, 286, 294, 310, 314, 318, 332, 346, 366, 373, 385, 386, 387, 406, 420, 422, 429, 440, 448) and `establishments`.`deleted_at` is null

Backtrace

app/Http/Controllers/HomeController.php:581
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

HomeController.php#581primodishnew6.72ms

select * from `reviews` where `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`dish_id` in (116, 117, 134, 146, 147, 242, 261, 262, 290, 307, 308, 309, 349, 350, 351, 357, 361, 362, 363, 364, 377, 384, 412, 431, 432, 433, 451, 452, 453, 454, 455, 460, 461, 462, 463, 472, 487, 488, 489, 490, 493, 505, 513, 514, 516, 537, 538, 539, 543, 544, 556, 575, 586, 600, 620, 621, 622, 623, 624, 625, 626, 627, 655, 656, 657, 659, 660, 661, 662, 663, 694, 695, 696, 697, 727, 728, 731, 732, 735, 736, 737, 738, 774, 781, 782, 783, 784, 785, 786, 787, 788, 789, 806, 813, 814, 826, 827, 828, 829, 840, 841, 842, 843, 844, 896, 897, 898, 905, 906, 931, 932, 936, 937, 939, 940, 941, 942, 943, 944, 945, 990, 991, 992, 993, 994, 995, 996, 1022, 1023, 1025, 1029, 1030, 1096, 1097, 1098, 1099, 1100, 1107, 1108, 1109, 1110, 1133, 1143, 1144, 1145, 1146, 1147, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1199, 1200, 1238, 1239, 1263, 1278, 1279, 1280, 1281, 1286, 1295, 1316, 1322, 1323, 1324, 1325, 1326, 1381, 1382, 1383, 1407, 1408, 1409) and `reviews`.`deleted_at` is null

Bindings	0: Approved
Backtrace	app/Http/Controllers/HomeController.php:581 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205 vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

HomeController.php#581primodishnew3.12ms

select `m_dietry_considerations`.*, `m_dietry_consideration_review`.`review_id` as `pivot_review_id`, `m_dietry_consideration_review`.`m_dietry_consideration_id` as `pivot_m_dietry_consideration_id` from `m_dietry_considerations` inner join `m_dietry_consideration_review` on `m_dietry_considerations`.`id` = `m_dietry_consideration_review`.`m_dietry_consideration_id` where `m_dietry_consideration_review`.`review_id` in (169, 170, 208, 209, 351, 352, 406, 424, 425, 426, 471, 472, 473, 475, 480, 485, 486, 487, 488, 501, 508, 540, 561, 562, 563, 581, 583, 584, 585, 590, 591, 592, 593, 602, 617, 618, 619, 620, 623, 635, 643, 644, 646, 669, 670, 671, 675, 676, 688, 718, 732, 752, 753, 754, 755, 756, 757, 758, 759, 787, 788, 789, 791, 792, 793, 794, 795, 835, 836, 837, 838, 868, 869, 872, 873, 876, 877, 878, 879, 917, 924, 925, 926, 927, 928, 929, 930, 931, 932, 949, 957, 970, 971, 972, 983, 984, 985, 986, 987, 1040, 1041, 1042, 1049, 1050, 1075, 1076, 1080, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1123, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1169, 1171, 1175, 1176, 1242, 1243, 1244, 1245, 1246, 1253, 1254, 1255, 1256, 1279, 1289, 1290, 1291, 1292, 1293, 1294, 1315, 1316, 1317, 1318, 1319, 1323, 1324, 1328, 1353, 1354, 1355, 1356, 1357, 1408, 1409, 1439, 1454, 1455, 1456, 1457, 1458, 1459, 1464, 1473, 1505, 1506, 1520, 1521, 1522, 1523, 1524, 1584, 1585, 1586, 1611, 1612, 1613, 1628) and `m_dietry_considerations`.`deleted_at` is null

Backtrace

app/Http/Controllers/HomeController.php:581
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

HomeController.php#581primodishnew2.61ms

select `dish_categories`.*, `dish_dish_category`.`dish_id` as `pivot_dish_id`, `dish_dish_category`.`dish_category_id` as `pivot_dish_category_id` from `dish_categories` inner join `dish_dish_category` on `dish_categories`.`id` = `dish_dish_category`.`dish_category_id` where `dish_dish_category`.`dish_id` in (116, 117, 134, 146, 147, 242, 261, 262, 290, 307, 308, 309, 349, 350, 351, 357, 361, 362, 363, 364, 377, 384, 412, 431, 432, 433, 451, 452, 453, 454, 455, 460, 461, 462, 463, 472, 487, 488, 489, 490, 493, 505, 513, 514, 516, 537, 538, 539, 543, 544, 556, 575, 586, 600, 620, 621, 622, 623, 624, 625, 626, 627, 655, 656, 657, 659, 660, 661, 662, 663, 694, 695, 696, 697, 727, 728, 731, 732, 735, 736, 737, 738, 774, 781, 782, 783, 784, 785, 786, 787, 788, 789, 806, 813, 814, 826, 827, 828, 829, 840, 841, 842, 843, 844, 896, 897, 898, 905, 906, 931, 932, 936, 937, 939, 940, 941, 942, 943, 944, 945, 990, 991, 992, 993, 994, 995, 996, 1022, 1023, 1025, 1029, 1030, 1096, 1097, 1098, 1099, 1100, 1107, 1108, 1109, 1110, 1133, 1143, 1144, 1145, 1146, 1147, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1199, 1200, 1238, 1239, 1263, 1278, 1279, 1280, 1281, 1286, 1295, 1316, 1322, 1323, 1324, 1325, 1326, 1381, 1382, 1383, 1407, 1408, 1409) and `dish_categories`.`deleted_at` is null

Backtrace

app/Http/Controllers/HomeController.php:581
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

HomeController.php#581primodishnew2.69ms

select `m_dietry_considerations`.*, `dish_m_dietry_consideration`.`dish_id` as `pivot_dish_id`, `dish_m_dietry_consideration`.`m_dietry_consideration_id` as `pivot_m_dietry_consideration_id` from `m_dietry_considerations` inner join `dish_m_dietry_consideration` on `m_dietry_considerations`.`id` = `dish_m_dietry_consideration`.`m_dietry_consideration_id` where `dish_m_dietry_consideration`.`dish_id` in (116, 117, 134, 146, 147, 242, 261, 262, 290, 307, 308, 309, 349, 350, 351, 357, 361, 362, 363, 364, 377, 384, 412, 431, 432, 433, 451, 452, 453, 454, 455, 460, 461, 462, 463, 472, 487, 488, 489, 490, 493, 505, 513, 514, 516, 537, 538, 539, 543, 544, 556, 575, 586, 600, 620, 621, 622, 623, 624, 625, 626, 627, 655, 656, 657, 659, 660, 661, 662, 663, 694, 695, 696, 697, 727, 728, 731, 732, 735, 736, 737, 738, 774, 781, 782, 783, 784, 785, 786, 787, 788, 789, 806, 813, 814, 826, 827, 828, 829, 840, 841, 842, 843, 844, 896, 897, 898, 905, 906, 931, 932, 936, 937, 939, 940, 941, 942, 943, 944, 945, 990, 991, 992, 993, 994, 995, 996, 1022, 1023, 1025, 1029, 1030, 1096, 1097, 1098, 1099, 1100, 1107, 1108, 1109, 1110, 1133, 1143, 1144, 1145, 1146, 1147, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1199, 1200, 1238, 1239, 1263, 1278, 1279, 1280, 1281, 1286, 1295, 1316, 1322, 1323, 1324, 1325, 1326, 1381, 1382, 1383, 1407, 1408, 1409) and `m_dietry_considerations`.`deleted_at` is null

Backtrace

app/Http/Controllers/HomeController.php:581
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
vendor/laravel/framework/src/Illuminate/Routing/Router.php:806

DishController.php#837primodishnew970μsselect * from `dishes` where `dishes`.`id` = 451 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 451 1: Approved
Backtrace	app/Http/Controllers/DishController.php:837 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

DishController.php#839primodishnew1.28ms

select * from `reviews` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 451 1: Approved
Backtrace	app/Http/Controllers/DishController.php:839 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

InteractsWithMedia.php#545primodishnew1.02msselect * from `media` where `media`.`model_id` in (581) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 app/Http/Controllers/DishController.php:840

dishlistingimage.blade.php#4primodishnew1.57ms

select * from `reviews` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 451 1: Approved
Backtrace	view::partials.dishlistingimage:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

InteractsWithMedia.php#545primodishnew730μsselect * from `media` where `media`.`model_id` in (581) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 view::partials.dishlistingimage:52

InteractsWithMedia.php#545primodishnew900μsselect * from `media` where `media`.`model_id` in (451) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew700μsselect * from `media` where `media`.`model_id` in (59) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew890μsselect * from `media` where `media`.`model_id` in (581) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

Review.php#154primodishnew980μsselect * from `dishes` where `dishes`.`id` = 451 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 451 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

Dish.php#238primodishnew1.57msselect * from `establishments` where `establishments`.`id` = 59 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 59
Backtrace	app/Models/Dish.php:238 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

InteractsWithMedia.php#545primodishnew780μsselect * from `media` where `media`.`model_id` in (451) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew660μsselect * from `media` where `media`.`model_id` in (59) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102

Dish.php#153primodishnew5.64ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 451
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1047 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew5.1ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 451
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1053 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew1.13ms

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 451 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew900μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 451 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew4.95ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 451
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

dishlisting.blade.php#1117primodishnew510μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null

Bindings	0: 451
Backtrace	view::partials.dishlisting:1117 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1118primodishnew620μs

select * from `reviews` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 451
Backtrace	view::partials.dishlisting:1118 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1120primodishnew1.07ms

select * from `reviews` where `reviews`.`dish_id` = 451 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 451
Backtrace	view::partials.dishlisting:1120 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

DishController.php#837primodishnew550μsselect * from `dishes` where `dishes`.`id` = 488 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 488 1: Approved
Backtrace	app/Http/Controllers/DishController.php:837 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

DishController.php#839primodishnew1.05ms

select * from `reviews` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 488 1: Approved
Backtrace	app/Http/Controllers/DishController.php:839 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

InteractsWithMedia.php#545primodishnew590μsselect * from `media` where `media`.`model_id` in (618) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 app/Http/Controllers/DishController.php:840

dishlistingimage.blade.php#4primodishnew1.31ms

select * from `reviews` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 488 1: Approved
Backtrace	view::partials.dishlistingimage:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

InteractsWithMedia.php#545primodishnew630μsselect * from `media` where `media`.`model_id` in (618) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 view::partials.dishlistingimage:52

InteractsWithMedia.php#545primodishnew770μsselect * from `media` where `media`.`model_id` in (488) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew910μsselect * from `media` where `media`.`model_id` in (618) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

Review.php#154primodishnew770μsselect * from `dishes` where `dishes`.`id` = 488 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 488 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

Dish.php#238primodishnew630μsselect * from `establishments` where `establishments`.`id` = 59 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 59
Backtrace	app/Models/Dish.php:238 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

InteractsWithMedia.php#545primodishnew630μsselect * from `media` where `media`.`model_id` in (488) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew580μsselect * from `media` where `media`.`model_id` in (59) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102

Dish.php#153primodishnew5.46ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 488
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1047 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew5.07ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 488
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1053 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew1.12ms

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 488 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew940μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 488 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew5.03ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 488
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

dishlisting.blade.php#1117primodishnew710μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null

Bindings	0: 488
Backtrace	view::partials.dishlisting:1117 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1118primodishnew650μs

select * from `reviews` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 488
Backtrace	view::partials.dishlisting:1118 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1120primodishnew580μs

select * from `reviews` where `reviews`.`dish_id` = 488 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 488
Backtrace	view::partials.dishlisting:1120 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

DishController.php#837primodishnew520μsselect * from `dishes` where `dishes`.`id` = 737 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 737 1: Approved
Backtrace	app/Http/Controllers/DishController.php:837 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

DishController.php#839primodishnew930μs

select * from `reviews` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 737 1: Approved
Backtrace	app/Http/Controllers/DishController.php:839 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

InteractsWithMedia.php#545primodishnew530μsselect * from `media` where `media`.`model_id` in (878) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 app/Http/Controllers/DishController.php:840

dishlistingimage.blade.php#4primodishnew1.17ms

select * from `reviews` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 737 1: Approved
Backtrace	view::partials.dishlistingimage:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

InteractsWithMedia.php#545primodishnew510μsselect * from `media` where `media`.`model_id` in (878) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 view::partials.dishlistingimage:52

InteractsWithMedia.php#545primodishnew650μsselect * from `media` where `media`.`model_id` in (737) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew610μsselect * from `media` where `media`.`model_id` in (878) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

Review.php#154primodishnew540μsselect * from `dishes` where `dishes`.`id` = 737 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 737 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

Dish.php#238primodishnew480μsselect * from `establishments` where `establishments`.`id` = 59 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 59
Backtrace	app/Models/Dish.php:238 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

InteractsWithMedia.php#545primodishnew470μsselect * from `media` where `media`.`model_id` in (737) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew440μsselect * from `media` where `media`.`model_id` in (59) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102

Dish.php#153primodishnew3.23ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 737
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1047 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew2.86ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 737
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1053 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew750μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 737 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew710μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 737 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew2.62ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 737
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

dishlisting.blade.php#1117primodishnew410μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null

Bindings	0: 737
Backtrace	view::partials.dishlisting:1117 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1118primodishnew500μs

select * from `reviews` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 737
Backtrace	view::partials.dishlisting:1118 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1120primodishnew490μs

select * from `reviews` where `reviews`.`dish_id` = 737 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 737
Backtrace	view::partials.dishlisting:1120 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

DishController.php#837primodishnew420μsselect * from `dishes` where `dishes`.`id` = 242 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 242 1: Approved
Backtrace	app/Http/Controllers/DishController.php:837 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

DishController.php#839primodishnew850μs

select * from `reviews` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 242 1: Approved
Backtrace	app/Http/Controllers/DishController.php:839 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

InteractsWithMedia.php#545primodishnew480μsselect * from `media` where `media`.`model_id` in (1353) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 app/Http/Controllers/DishController.php:840

dishlistingimage.blade.php#4primodishnew890μs

select * from `reviews` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 242 1: Approved
Backtrace	view::partials.dishlistingimage:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

InteractsWithMedia.php#545primodishnew420μsselect * from `media` where `media`.`model_id` in (1353) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 view::partials.dishlistingimage:52

InteractsWithMedia.php#545primodishnew460μsselect * from `media` where `media`.`model_id` in (242) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew530μsselect * from `media` where `media`.`model_id` in (90) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew510μsselect * from `media` where `media`.`model_id` in (1353) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

Review.php#154primodishnew510μsselect * from `dishes` where `dishes`.`id` = 242 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 242 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

Dish.php#238primodishnew470μsselect * from `establishments` where `establishments`.`id` = 90 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 90
Backtrace	app/Models/Dish.php:238 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

InteractsWithMedia.php#545primodishnew490μsselect * from `media` where `media`.`model_id` in (242) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew470μsselect * from `media` where `media`.`model_id` in (90) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102

Dish.php#153primodishnew3.21ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 242
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1047 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew3.08ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 242
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1053 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew730μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 242 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#99primodishnew660μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 242 1: Approved
Backtrace	app/Models/Dish.php:99 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew2.7ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 242
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

dishlisting.blade.php#1117primodishnew430μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null

Bindings	0: 242
Backtrace	view::partials.dishlisting:1117 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1118primodishnew500μs

select * from `reviews` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 242
Backtrace	view::partials.dishlisting:1118 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

dishlisting.blade.php#1120primodishnew490μs

select * from `reviews` where `reviews`.`dish_id` = 242 and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

Bindings	0: 242
Backtrace	view::partials.dishlisting:1120 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

DishController.php#837primodishnew400μsselect * from `dishes` where `dishes`.`id` = 813 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 813 1: Approved
Backtrace	app/Http/Controllers/DishController.php:837 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

DishController.php#839primodishnew830μs

select * from `reviews` where `reviews`.`dish_id` = 813 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 813 1: Approved
Backtrace	app/Http/Controllers/DishController.php:839 view::partials.dishlistingimage:3 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

InteractsWithMedia.php#545primodishnew430μsselect * from `media` where `media`.`model_id` in (1506) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 app/Http/Controllers/DishController.php:840

dishlistingimage.blade.php#4primodishnew760μs

select * from `reviews` where `reviews`.`dish_id` = 813 and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = (
SELECT MAX(r2.id)
FROM reviews AS r2
WHERE r2.dish_id = r1.dish_id
AND r2.visitor_id = r1.visitor_id
AND r2.deleted_at IS NULL
)) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = 'Approved') and `reviews`.`deleted_at` is null

Bindings	0: 813 1: Approved
Backtrace	view::partials.dishlistingimage:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

InteractsWithMedia.php#545primodishnew430μsselect * from `media` where `media`.`model_id` in (1506) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 view::partials.dishlistingimage:52

InteractsWithMedia.php#545primodishnew420μsselect * from `media` where `media`.`model_id` in (813) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew450μsselect * from `media` where `media`.`model_id` in (1506) and `media`.`model_type` = 'App\\Models\\Review'

Bindings	0: App\Models\Review
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Review.php:125 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

Review.php#154primodishnew400μsselect * from `dishes` where `dishes`.`id` = 813 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 813 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

Dish.php#238primodishnew440μsselect * from `establishments` where `establishments`.`id` = 90 and `establishments`.`deleted_at` is null limit 1

Bindings	0: 90
Backtrace	app/Models/Dish.php:238 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

InteractsWithMedia.php#545primodishnew390μsselect * from `media` where `media`.`model_id` in (813) and `media`.`model_type` = 'App\\Models\\Dish'

Bindings	0: App\Models\Dish
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Dish.php:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

InteractsWithMedia.php#545primodishnew440μsselect * from `media` where `media`.`model_id` in (90) and `media`.`model_type` = 'App\\Models\\Establishment'

Bindings	0: App\Models\Establishment
Backtrace	vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:545 vendor/spatie/laravel-medialibrary/src/MediaCollections/MediaRepository.php:31 vendor/spatie/laravel-medialibrary/src/InteractsWithMedia.php:271 app/Models/Establishment.php:102

Dish.php#153primodishnew3.12ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 813 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 813
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1047 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

Dish.php#153primodishnew2.8ms

select avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at
FROM reviews
WHERE deleted_at IS NULL
GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = 813 and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null

Bindings	0: 813
Backtrace	app/Models/Dish.php:153 view::partials.dishlisting:1053 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22

primodishnew720μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew710μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew2.68msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew380μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew440μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew460μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew410μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew710μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew420μsselect * from `media` where `media`.`model_id` in (971) and `media`.`model_type` = ?
primodishnew690μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew390μsselect * from `media` where `media`.`model_id` in (971) and `media`.`model_type` = ?
primodishnew480μsselect * from `media` where `media`.`model_id` in (828) and `media`.`model_type` = ?
primodishnew480μsselect * from `media` where `media`.`model_id` in (971) and `media`.`model_type` = ?
primodishnew450μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew470μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
primodishnew420μsselect * from `media` where `media`.`model_id` in (828) and `media`.`model_type` = ?
primodishnew410μsselect * from `media` where `media`.`model_id` in (90) and `media`.`model_type` = ?
primodishnew2.97msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew2.63msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew710μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew650μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew2.56msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew410μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew510μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew470μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew410μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew770μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew400μsselect * from `media` where `media`.`model_id` in (351) and `media`.`model_type` = ?
primodishnew730μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew410μsselect * from `media` where `media`.`model_id` in (351) and `media`.`model_type` = ?
primodishnew420μsselect * from `media` where `media`.`model_id` in (261) and `media`.`model_type` = ?
primodishnew490μsselect * from `media` where `media`.`model_id` in (99) and `media`.`model_type` = ?
primodishnew470μsselect * from `media` where `media`.`model_id` in (351) and `media`.`model_type` = ?
primodishnew440μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew470μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
primodishnew440μsselect * from `media` where `media`.`model_id` in (261) and `media`.`model_type` = ?
primodishnew440μsselect * from `media` where `media`.`model_id` in (99) and `media`.`model_type` = ?
primodishnew3.19msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew2.69msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew680μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew610μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew2.74msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew420μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew470μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew450μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew390μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew740μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew410μsselect * from `media` where `media`.`model_id` in (426) and `media`.`model_type` = ?
primodishnew730μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew420μsselect * from `media` where `media`.`model_id` in (426) and `media`.`model_type` = ?
primodishnew410μsselect * from `media` where `media`.`model_id` in (309) and `media`.`model_type` = ?
primodishnew390μsselect * from `media` where `media`.`model_id` in (114) and `media`.`model_type` = ?
primodishnew400μsselect * from `media` where `media`.`model_id` in (426) and `media`.`model_type` = ?
primodishnew430μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew450μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
primodishnew420μsselect * from `media` where `media`.`model_id` in (309) and `media`.`model_type` = ?
primodishnew390μsselect * from `media` where `media`.`model_id` in (114) and `media`.`model_type` = ?
primodishnew2.96msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew2.66msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew700μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew670μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew2.55msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew570μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew480μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew480μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew400μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew750μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew390μsselect * from `media` where `media`.`model_id` in (592) and `media`.`model_type` = ?
primodishnew740μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew400μsselect * from `media` where `media`.`model_id` in (592) and `media`.`model_type` = ?
primodishnew430μsselect * from `media` where `media`.`model_id` in (462) and `media`.`model_type` = ?
primodishnew380μsselect * from `media` where `media`.`model_id` in (171) and `media`.`model_type` = ?
primodishnew390μsselect * from `media` where `media`.`model_id` in (592) and `media`.`model_type` = ?
primodishnew440μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew440μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
primodishnew440μsselect * from `media` where `media`.`model_id` in (462) and `media`.`model_type` = ?
primodishnew410μsselect * from `media` where `media`.`model_id` in (171) and `media`.`model_type` = ?
primodishnew3.01msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew2.75msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew700μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew620μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew2.65msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew380μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew610μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew450μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew430μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew790μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew450μsselect * from `media` where `media`.`model_id` in (789) and `media`.`model_type` = ?
primodishnew770μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew390μsselect * from `media` where `media`.`model_id` in (789) and `media`.`model_type` = ?
primodishnew420μsselect * from `media` where `media`.`model_id` in (657) and `media`.`model_type` = ?
primodishnew380μsselect * from `media` where `media`.`model_id` in (176) and `media`.`model_type` = ?
primodishnew390μsselect * from `media` where `media`.`model_id` in (789) and `media`.`model_type` = ?
primodishnew450μsselect * from `dishes` where `dishes`.`id` = ? and `dishes`.`deleted_at` is null and `moderate` = ? limit 1
primodishnew450μsselect * from `establishments` where `establishments`.`id` = ? and `establishments`.`deleted_at` is null limit 1
primodishnew410μsselect * from `media` where `media`.`model_id` in (657) and `media`.`model_type` = ?
primodishnew410μsselect * from `media` where `media`.`model_id` in (176) and `media`.`model_type` = ?
primodishnew2.97msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew2.76msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew670μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew620μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `id` in (select `id` from `reviews` as `r1` where `r1`.`deleted_at` is null and `r1`.`dish_id` = `reviews`.`dish_id` and `r1`.`visitor_id` = `reviews`.`visitor_id` and r1.id = ( SELECT MAX(r2.id) FROM reviews AS r2 WHERE r2.dish_id = r1.dish_id AND r2.visitor_id = r1.visitor_id AND r2.deleted_at IS NULL )) and exists (select * from `visitors` where `reviews`.`visitor_id` = `visitors`.`id` and `deleted_at` is null and `visitors`.`deleted_at` is null) and exists (select * from `dishes` where `reviews`.`dish_id` = `dishes`.`id` and `deleted_at` is null and `dishes`.`deleted_at` is null and `moderate` = ?) and `reviews`.`deleted_at` is null
primodishnew2.64msselect avg(`reviews`.`rating`) as aggregate from `reviews` inner join (SELECT dish_id, visitor_id, MAX(created_at) AS max_created_at FROM reviews WHERE deleted_at IS NULL GROUP BY dish_id, visitor_id) AS latest_reviews on `reviews`.`dish_id` = `latest_reviews`.`dish_id` and `reviews`.`visitor_id` = `latest_reviews`.`visitor_id` and `reviews`.`created_at` = `latest_reviews`.`max_created_at` inner join `dishes` on `reviews`.`dish_id` = `dishes`.`id` inner join `visitors` on `reviews`.`visitor_id` = `visitors`.`id` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `dishes`.`deleted_at` is null and `visitors`.`deleted_at` is null and `reviews`.`deleted_at` is null
primodishnew390μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew460μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1
primodishnew470μsselect * from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null order by `created_at` desc limit 1

App\Models\Review: 220Review.php#?
App\Models\Dish: 197Dish.php#?
App\Models\MDietryConsideration: 168MDietryConsideration.php#?
App\Models\Establishment: 124Establishment.php#?
Spatie\MediaLibrary\MediaCollections\Models\Media: 56Media.php#?
App\Models\DishCategory: 4DishCategory.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-14 18:58:20	GET	/visitor_list/121?sortby=ztoa (stacked)	1
#2	2025-05-14 18:58:21	GET	/home	6 68 205 769

Dish Name

Welcome! Just a quick note—

White Rabbit Taiyaki Sundae

White Rabbit Taiyaki Sundae

OMG Squee

Calamansi Pie Mochi Donut

Calamansi Pie Mochi Donut

OMG Squee

Yuzu Meringue Pie Macaron

Yuzu Meringue Pie Macaron

OMG Squee

Bird Bird Bacon

Bird Bird Bacon

Bird Bird Biscuit

Fries

Fries

Bird Bird Biscuit

Dill Mayo

Dill Mayo

Bird Bird Biscuit

Fish & Chips

Fish & Chips

B.D. Riley's Irish Pub at Mueller

R6 Crab Fried Rice

R6 Crab Fried Rice

KHON Thai Kitchen by Seeda

Carrot Cake

Carrot Cake

Quack's 43rd Street Bakery

Pineapple Fried Rice

Pineapple Fried Rice

Thai Fresh

1 x Application (96.9%)	953ms
1 x Preparing Response (86.66%)	852ms
1 x Booting (3.1%)	30.48ms
1 x Routing (0.1%)	936μs
68 x View (0%)	0μs

Dish Name

Welcome! Just a quick note—

Dish Name

Dishes (177)

White Rabbit Taiyaki Sundae

White Rabbit Taiyaki Sundae

OMG Squee

Calamansi Pie Mochi Donut

Calamansi Pie Mochi Donut

OMG Squee

Yuzu Meringue Pie Macaron

Yuzu Meringue Pie Macaron

OMG Squee

Bird Bird Bacon

Bird Bird Bacon

Bird Bird Biscuit

Fries

Fries

Bird Bird Biscuit

Dill Mayo

Dill Mayo

Bird Bird Biscuit

Fish & Chips

Fish & Chips

B.D. Riley's Irish Pub at Mueller

R6 Crab Fried Rice

R6 Crab Fried Rice

KHON Thai Kitchen by Seeda

Carrot Cake

Carrot Cake

Quack's 43rd Street Bakery

Pineapple Fried Rice

Pineapple Fried Rice

Thai Fresh