PrimodishNew

Messages16 Request Timeline Exceptions Views97 Queries172 Models10763 Livewire0 Mails Gate

Settings Request history1.1s11MB10.xGET visitors-lists/{visitors_list}

warninglog[19:41:33] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:33] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:33] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:33] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:33] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:33] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[19:41:34] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...

status

200 OK

full_url

https://primodishnew.webmavens.com/visitors-lists/1010?page=2&sortby=age

action_name

visitors-lists.show

controller_action

App\Http\Controllers\VisitorsListController@show

uri

GET visitors-lists/{visitors_list}

controller

App\Http\Controllers\VisitorsListController@show

namespace

App\Http\Controllers

file

app/Http/Controllers/VisitorsListController.php:98-232

middleware

web

duration

1.15s

peak_memory

16MB

response

text/html; charset=UTF-8

request_format

html

request_query

  0 of 0   
array:2 [▼
  "page" => "2"
  "sortby" => "age"
]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "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

[]

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 => "Tue, 15 Jul 2025 00:41:33 GMT"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "gL2phaVq4nFP3RAcyun59IZFBbeVZQLGvkBssrzt"
  "lastActivityTime" => 1752540093
  "Latitude" => "30.26715"
  "Longitude" => "-97.74306"
  "formatted_address" => "Austin, TX, USA"
]

Booting (11.83ms)time
Application (1.08s)time
Routing (1.24ms)
Preparing Response (1.07s)
View: visitors-listviews
View: partials.profileHeaderviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
View: partials.listlistingreviewviews
View: partials.dishlistingviews
View: partials.reviewimageslistingviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.popup_login_buttonviews
View: partials.profileHeaderviews
View: partials.reviewboxviews
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 (98.92%)
1.08s
1 x Preparing Response (97.89%)
1.07s
1 x Booting (1.08%)
11.83ms
1 x Routing (0.11%)
1.24ms
97 x View (0%)
0μs

97 templates were rendered

1x visitors-listvisitors-list.blade.php#?blade
11x partials.profileHeaderprofileHeader.blade.php#?blade
10x partials.listlistingreviewlistlistingreview.blade.php#?blade
10x partials.dishlistingdishlisting.blade.php#?blade
10x partials.reviewimageslistingreviewimageslisting.blade.php#?blade
43x partials.popup_login_buttonpopup_login_button.blade.php#?blade
10x partials.reviewboxreviewbox.blade.php#?blade
1x pagination::tailwindtailwind.blade.php#?blade
1x layouts.mastermaster.blade.php#?blade

172 statements were executed (122 duplicates)Show only duplicates primodishnew374ms

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

ImplicitRouteBinding.php#61primodishnewConnection Established

Backtrace

vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61
vendor/laravel/framework/src/Illuminate/Routing/Router.php:959
vendor/livewire/livewire/src/Features/SupportPageComponents/SupportPageComponents.php:214
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

ImplicitRouteBinding.php#61primodishnew1.6msselect * from `visitors_lists` where `id` = '1010' and `visitors_lists`.`deleted_at` is null limit 1

Bindings	0: 1010
Backtrace	vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61 vendor/laravel/framework/src/Illuminate/Routing/Router.php:959 vendor/livewire/livewire/src/Features/SupportPageComponents/SupportPageComponents.php:214 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

VisitorsListController.php#117primodishnew830μsselect * from `list_dishes` where `list_id` = 1010 and `list_id` is not null and `list_dishes`.`deleted_at` is null

Bindings	0: 1010
Backtrace	app/Http/Controllers/VisitorsListController.php:117 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

VisitorsListController.php#117primodishnew840μs

select * from `reviews` where `deleted_at` is null and `reviews`.`id` in (328, 351, 417, 426, 435, 483, 511, 512, 515, 516, 520, 581, 582, 592, 664, 694, 697, 744, 746, 749, 771, 774, 789, 791, 813, 838, 854, 885, 900, 908, 910, 921, 922, 927, 948, 953, 973, 976, 992, 1025, 1059, 1085, 1104, 1105, 1113, 1175, 1237, 1240, 1248, 1284, 1286, 1306, 1319, 1329, 1470, 1502, 1601) and `reviews`.`deleted_at` is null

Backtrace

app/Http/Controllers/VisitorsListController.php:117
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

VisitorsListController.php#117primodishnew460μsselect * from `visitors` where `visitors`.`id` in (22) and `visitors`.`deleted_at` is null

Backtrace

app/Http/Controllers/VisitorsListController.php:117
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

visitors-list.blade.php#6primodishnew440μsselect * from `visitors` where `visitors`.`id` = 22 and `visitors`.`deleted_at` is null limit 1

Bindings	0: 22
Backtrace	view::visitors-list:6 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#545primodishnew490μsselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = 'App\\Models\\Visitor'

Bindings	0: App\Models\Visitor
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/Visitor.php:256 view::partials.profileHeader:5

Visitor.php#179primodishnew2.15msselect MAX(id) AS id from `reviews` where `visitor_id` = 22 and `reviews`.`deleted_at` is null group by `dish_id`

Bindings	0: 22
Backtrace	app/Models/Visitor.php:179 app/Models/Visitor.php:191 view::partials.profileHeader:37 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Visitor.php#191primodishnew13.41ms

select `dish_id` from `reviews` where `reviews`.`visitor_id` = 22 and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (153, 160, 166, 169, 170, 1356, 197, 209, 240, 260, 1353, 333, 346, 347, 349, 350, 351, 352, 353, 354, 356, 357, 365, 404, 1375, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 1374, 442, 443, 447, 450, 451, 452, 453, 454, 455, 460, 470, 472, 473, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 1320, 1401, 1321, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 1564, 566, 567, 568, 569, 570, 571, 572, 574, 575, 576, 577, 579, 580, 581, 1328, 583, 584, 585, 589, 590, 591, 592, 593, 594, 595, 596, 597, 1478, 599, 600, 602, 603, 607, 608, 609, 610, 612, 613, 614, 615, 616, 617, 618, 619, 620, 630, 631, 632, 633, 634, 635, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 657, 658, 1373, 660, 661, 662, 663, 664, 665, 666, 669, 670, 671, 672, 673, 674, 675, 676, 689, 690, 691, 692, 693, 694, 695, 1503, 697, 1502, 699, 700, 701, 704, 705, 706, 1457, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 733, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 835, 836, 837, 838, 840, 845, 846, 847, 848, 849, 850, 851, 852, 853, 1372, 855, 856, 858, 859, 860, 861, 862, 863, 864, 865, 866, 1632, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 881, 882, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 910, 911, 914, 915, 916, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 1506, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 1354, 970, 971, 972, 1366, 1367, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 996, 1414, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1424, 1425, 1018, 1417, 1415, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1500, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1355, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1371, 1100, 1101, 1102, 1103, 1104, 1105, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1164, 1165, 1166, 1167, 1291, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1359, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1565, 1265, 1266, 1267, 1268, 1269, 1270, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1288, 1289, 1290, 1292, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1323, 1324, 1509, 1508, 1327, 1329, 1330, 1331, 1332, 1333, 1474, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1350, 1351, 1357, 1454, 1360, 1361, 1362, 1363, 1364, 1365, 1399, 1400, 1402, 1403, 1406, 1407, 1412, 1413, 1416, 1420, 1421, 1422, 1423, 1426, 1427, 1428, 1429, 1430, 1431, 1432, 1433, 1434, 1436, 1437, 1438, 1439, 1441, 1443, 1445, 1446, 1447, 1448, 1449, 1451, 1452, 1453, 1455, 1456, 1458, 1459, 1460, 1461, 1462, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1477, 1479, 1480, 1481, 1482, 1483, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1501, 1504, 1505, 1507, 1510, 1511, 1518, 1519, 1521, 1522, 1523, 1524, 1525, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1563, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1588, 1589, 1590, 1591, 1592, 1599, 1600, 1601, 1603, 1604, 1605, 1606, 1607, 1608, 1633, 1613, 1627, 1628) 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: 22
1: Approved
2: 153
3: 160
4: 166
5: 169
6: 170
7: 1356
8: 197
9: 209
10: 240
11: 260
12: 1353
13: 333
14: 346
15: 347
16: 349
17: 350
18: 351
19: 352
20: 353
21: 354
22: 356
23: 357
24: 365
25: 404
26: 1375
27: 406
28: 407
29: 408
30: 409
31: 410
32: 411
33: 412
34: 413
35: 414
36: 415
37: 416
38: 417
39: 418
40: 419
41: 424
42: 425
43: 426
44: 427
45: 428
46: 429
47: 431
48: 432
49: 433
50: 434
51: 1374
52: 442
53: 443
54: 447
55: 450
56: 451
57: 452
58: 453
59: 454
60: 455
61: 460
62: 470
63: 472
64: 473
65: 483
66: 484
67: 485
68: 486
69: 487
70: 488
71: 489
72: 490
73: 491
74: 492
75: 493
76: 494
77: 495
78: 496
79: 497
80: 498
81: 499
82: 500
83: 501
84: 502
85: 503
86: 504
87: 505
88: 506
89: 507
90: 508
91: 509
92: 510
93: 511
94: 1320
95: 1401
96: 1321
97: 515
98: 516
99: 517
100: 518
101: 519
102: 520
103: 521
104: 522
105: 523
106: 524
107: 525
108: 535
109: 536
110: 537
111: 538
112: 539
113: 540
114: 541
115: 542
116: 543
117: 544
118: 545
119: 552
120: 553
121: 554
122: 555
123: 556
124: 557
125: 558
126: 559
127: 560
128: 561
129: 562
130: 563
131: 564
132: 1564
133: 566
134: 567
135: 568
136: 569
137: 570
138: 571
139: 572
140: 574
141: 575
142: 576
143: 577
144: 579
145: 580
146: 581
147: 1328
148: 583
149: 584
150: 585
151: 589
152: 590
153: 591
154: 592
155: 593
156: 594
157: 595
158: 596
159: 597
160: 1478
161: 599
162: 600
163: 602
164: 603
165: 607
166: 608
167: 609
168: 610
169: 612
170: 613
171: 614
172: 615
173: 616
174: 617
175: 618
176: 619
177: 620
178: 630
179: 631
180: 632
181: 633
182: 634
183: 635
184: 637
185: 638
186: 639
187: 640
188: 641
189: 642
190: 643
191: 644
192: 645
193: 646
194: 647
195: 648
196: 649
197: 650
198: 651
199: 652
200: 653
201: 654
202: 657
203: 658
204: 1373
205: 660
206: 661
207: 662
208: 663
209: 664
210: 665
211: 666
212: 669
213: 670
214: 671
215: 672
216: 673
217: 674
218: 675
219: 676
220: 689
221: 690
222: 691
223: 692
224: 693
225: 694
226: 695
227: 1503
228: 697
229: 1502
230: 699
231: 700
232: 701
233: 704
234: 705
235: 706
236: 1457
237: 708
238: 709
239: 710
240: 711
241: 712
242: 713
243: 714
244: 715
245: 716
246: 717
247: 718
248: 719
249: 720
250: 721
251: 722
252: 723
253: 733
254: 735
255: 736
256: 737
257: 738
258: 739
259: 740
260: 741
261: 742
262: 743
263: 744
264: 745
265: 746
266: 747
267: 748
268: 749
269: 750
270: 751
271: 752
272: 753
273: 754
274: 755
275: 756
276: 757
277: 758
278: 759
279: 760
280: 761
281: 762
282: 763
283: 764
284: 765
285: 766
286: 767
287: 768
288: 769
289: 770
290: 771
291: 772
292: 773
293: 774
294: 775
295: 776
296: 777
297: 778
298: 779
299: 780
300: 781
301: 782
302: 783
303: 784
304: 785
305: 786
306: 787
307: 788
308: 789
309: 790
310: 791
311: 792
312: 793
313: 794
314: 795
315: 797
316: 798
317: 799
318: 800
319: 801
320: 802
321: 803
322: 804
323: 805
324: 806
325: 807
326: 808
327: 809
328: 810
329: 811
330: 812
331: 813
332: 814
333: 815
334: 816
335: 817
336: 818
337: 819
338: 820
339: 821
340: 835
341: 836
342: 837
343: 838
344: 840
345: 845
346: 846
347: 847
348: 848
349: 849
350: 850
351: 851
352: 852
353: 853
354: 1372
355: 855
356: 856
357: 858
358: 859
359: 860
360: 861
361: 862
362: 863
363: 864
364: 865
365: 866
366: 1632
367: 868
368: 869
369: 870
370: 871
371: 872
372: 873
373: 874
374: 875
375: 876
376: 877
377: 878
378: 879
379: 881
380: 882
381: 884
382: 885
383: 886
384: 887
385: 888
386: 889
387: 890
388: 891
389: 892
390: 893
391: 894
392: 895
393: 896
394: 897
395: 898
396: 899
397: 900
398: 901
399: 902
400: 903
401: 904
402: 905
403: 906
404: 907
405: 908
406: 910
407: 911
408: 914
409: 915
410: 916
411: 919
412: 920
413: 921
414: 922
415: 923
416: 924
417: 925
418: 926
419: 927
420: 928
421: 929
422: 930
423: 931
424: 932
425: 933
426: 934
427: 935
428: 936
429: 937
430: 938
431: 939
432: 940
433: 941
434: 942
435: 943
436: 944
437: 945
438: 946
439: 947
440: 948
441: 949
442: 950
443: 951
444: 952
445: 953
446: 954
447: 955
448: 1506
449: 957
450: 958
451: 959
452: 960
453: 961
454: 962
455: 963
456: 964
457: 965
458: 966
459: 967
460: 968
461: 1354
462: 970
463: 971
464: 972
465: 1366
466: 1367
467: 975
468: 976
469: 977
470: 978
471: 979
472: 980
473: 981
474: 982
475: 983
476: 984
477: 985
478: 986
479: 987
480: 988
481: 989
482: 990
483: 991
484: 992
485: 993
486: 994
487: 996
488: 1414
489: 998
490: 999
491: 1000
492: 1001
493: 1002
494: 1003
495: 1004
496: 1005
497: 1006
498: 1008
499: 1009
500: 1010
501: 1011
502: 1012
503: 1013
504: 1014
505: 1015
506: 1424
507: 1425
508: 1018
509: 1417
510: 1415
511: 1021
512: 1022
513: 1023
514: 1024
515: 1025
516: 1026
517: 1027
518: 1500
519: 1029
520: 1030
521: 1031
522: 1032
523: 1033
524: 1034
525: 1035
526: 1036
527: 1037
528: 1038
529: 1039
530: 1040
531: 1041
532: 1042
533: 1043
534: 1044
535: 1045
536: 1046
537: 1047
538: 1048
539: 1049
540: 1050
541: 1051
542: 1052
543: 1053
544: 1054
545: 1055
546: 1056
547: 1057
548: 1058
549: 1059
550: 1060
551: 1061
552: 1062
553: 1063
554: 1064
555: 1065
556: 1066
557: 1067
558: 1068
559: 1069
560: 1070
561: 1071
562: 1072
563: 1073
564: 1074
565: 1075
566: 1076
567: 1077
568: 1078
569: 1079
570: 1080
571: 1355
572: 1082
573: 1083
574: 1084
575: 1085
576: 1086
577: 1087
578: 1088
579: 1089
580: 1090
581: 1091
582: 1092
583: 1093
584: 1094
585: 1095
586: 1096
587: 1097
588: 1098
589: 1371
590: 1100
591: 1101
592: 1102
593: 1103
594: 1104
595: 1105
596: 1108
597: 1109
598: 1110
599: 1111
600: 1112
601: 1113
602: 1114
603: 1115
604: 1116
605: 1117
606: 1118
607: 1119
608: 1120
609: 1121
610: 1122
611: 1126
612: 1127
613: 1128
614: 1129
615: 1130
616: 1131
617: 1132
618: 1133
619: 1134
620: 1135
621: 1164
622: 1165
623: 1166
624: 1167
625: 1291
626: 1169
627: 1170
628: 1171
629: 1172
630: 1173
631: 1174
632: 1175
633: 1176
634: 1177
635: 1178
636: 1179
637: 1180
638: 1181
639: 1182
640: 1183
641: 1184
642: 1185
643: 1186
644: 1187
645: 1188
646: 1189
647: 1190
648: 1191
649: 1192
650: 1193
651: 1194
652: 1195
653: 1196
654: 1197
655: 1198
656: 1199
657: 1200
658: 1201
659: 1202
660: 1203
661: 1204
662: 1205
663: 1206
664: 1207
665: 1208
666: 1209
667: 1210
668: 1211
669: 1212
670: 1213
671: 1214
672: 1215
673: 1216
674: 1217
675: 1218
676: 1219
677: 1220
678: 1221
679: 1222
680: 1223
681: 1224
682: 1225
683: 1226
684: 1227
685: 1228
686: 1229
687: 1230
688: 1231
689: 1232
690: 1233
691: 1234
692: 1235
693: 1236
694: 1359
695: 1238
696: 1239
697: 1240
698: 1241
699: 1242
700: 1243
701: 1244
702: 1245
703: 1246
704: 1247
705: 1248
706: 1249
707: 1250
708: 1251
709: 1252
710: 1253
711: 1254
712: 1255
713: 1256
714: 1257
715: 1258
716: 1259
717: 1260
718: 1261
719: 1262
720: 1263
721: 1565
722: 1265
723: 1266
724: 1267
725: 1268
726: 1269
727: 1270
728: 1272
729: 1273
730: 1274
731: 1275
732: 1276
733: 1277
734: 1278
735: 1279
736: 1280
737: 1281
738: 1282
739: 1283
740: 1284
741: 1285
742: 1286
743: 1288
744: 1289
745: 1290
746: 1292
747: 1293
748: 1294
749: 1295
750: 1296
751: 1297
752: 1298
753: 1299
754: 1300
755: 1301
756: 1304
757: 1305
758: 1306
759: 1307
760: 1308
761: 1309
762: 1310
763: 1311
764: 1312
765: 1313
766: 1314
767: 1315
768: 1316
769: 1317
770: 1318
771: 1319
772: 1323
773: 1324
774: 1509
775: 1508
776: 1327
777: 1329
778: 1330
779: 1331
780: 1332
781: 1333
782: 1474
783: 1336
784: 1337
785: 1338
786: 1339
787: 1340
788: 1341
789: 1342
790: 1343
791: 1344
792: 1345
793: 1346
794: 1347
795: 1348
796: 1350
797: 1351
798: 1357
799: 1454
800: 1360
801: 1361
802: 1362
803: 1363
804: 1364
805: 1365
806: 1399
807: 1400
808: 1402
809: 1403
810: 1406
811: 1407
812: 1412
813: 1413
814: 1416
815: 1420
816: 1421
817: 1422
818: 1423
819: 1426
820: 1427
821: 1428
822: 1429
823: 1430
824: 1431
825: 1432
826: 1433
827: 1434
828: 1436
829: 1437
830: 1438
831: 1439
832: 1441
833: 1443
834: 1445
835: 1446
836: 1447
837: 1448
838: 1449
839: 1451
840: 1452
841: 1453
842: 1455
843: 1456
844: 1458
845: 1459
846: 1460
847: 1461
848: 1462
849: 1465
850: 1466
851: 1467
852: 1468
853: 1469
854: 1470
855: 1471
856: 1472
857: 1473
858: 1477
859: 1479
860: 1480
861: 1481
862: 1482
863: 1483
864: 1488
865: 1489
866: 1490
867: 1491
868: 1492
869: 1493
870: 1494
871: 1495
872: 1496
873: 1497
874: 1498
875: 1499
876: 1501
877: 1504
878: 1505
879: 1507
880: 1510
881: 1511
882: 1518
883: 1519
884: 1521
885: 1522
886: 1523
887: 1524
888: 1525
889: 1527
890: 1529
891: 1530
892: 1531
893: 1532
894: 1533
895: 1534
896: 1535
897: 1536
898: 1537
899: 1538
900: 1539
901: 1540
902: 1541
903: 1542
904: 1543
905: 1544
906: 1545
907: 1546
908: 1547
909: 1548
910: 1549
911: 1550
912: 1551
913: 1552
914: 1553
915: 1554
916: 1555
917: 1556
918: 1557
919: 1563
920: 1568
921: 1569
922: 1570
923: 1571
924: 1572
925: 1573
926: 1574
927: 1575
928: 1576
929: 1577
930: 1578
931: 1579
932: 1580
933: 1581
934: 1582
935: 1583
936: 1584
937: 1585
938: 1586
939: 1588
940: 1589
941: 1590
942: 1591
943: 1592
944: 1599
945: 1600
946: 1601
947: 1603
948: 1604
949: 1605
950: 1606
951: 1607
952: 1608
953: 1633
954: 1613
955: 1627
956: 1628
957: Approved

Backtrace

app/Models/Visitor.php:191
view::partials.profileHeader:37
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

profileHeader.blade.php#37primodishnew570μs

select * from `visitors_followings` where `visitors_followings`.`follow_visitors_id` = 22 and `visitors_followings`.`follow_visitors_id` is not null and `visitors_followings`.`deleted_at` is null

Bindings	0: 22
Backtrace	view::partials.profileHeader:37 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#545primodishnew540μsselect * from `media` where `media`.`model_id` in (520) 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/Pagination/LengthAwarePaginator.php:196

Review.php#154primodishnew5.08msselect * from `dishes` where `dishes`.`id` = 396 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 396 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew670μsselect * from `establishments` where `establishments`.`id` = 145 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 145
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew1.27msselect * from `media` where `media`.`model_id` in (22) and `media`.`model_type` = 'App\\Models\\Visitor'

Bindings	0: App\Models\Visitor
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/Visitor.php:256 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew510μsselect * from `media` where `media`.`model_id` in (396) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew2.47msselect * from `media` where `media`.`model_id` in (145) 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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew560μ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/Pagination/LengthAwarePaginator.php:196

Review.php#154primodishnew670μ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/Pagination/LengthAwarePaginator.php:196 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#236primodishnew500μsselect * from `establishments` where `establishments`.`id` = 59 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 59
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew480μ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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew390μ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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew420μsselect * from `media` where `media`.`model_id` in (582) 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/Pagination/LengthAwarePaginator.php:196

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

Bindings	0: 452 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew400μsselect * from `establishments` where `establishments`.`id` = 59 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 59
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew440μsselect * from `media` where `media`.`model_id` in (452) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew380μ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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew380μsselect * from `media` where `media`.`model_id` in (592) 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/Pagination/LengthAwarePaginator.php:196

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

Bindings	0: 462 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew440μsselect * from `establishments` where `establishments`.`id` = 171 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 171
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew380μsselect * from `media` where `media`.`model_id` in (462) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew330μsselect * from `media` where `media`.`model_id` in (171) 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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew340μsselect * from `media` where `media`.`model_id` in (664) 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/Pagination/LengthAwarePaginator.php:196

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

Bindings	0: 534 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew450μsselect * from `establishments` where `establishments`.`id` = 75 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 75
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew370μsselect * from `media` where `media`.`model_id` in (534) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew350μsselect * from `media` where `media`.`model_id` in (75) 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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew430μsselect * from `media` where `media`.`model_id` in (694) 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/Pagination/LengthAwarePaginator.php:196

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

Bindings	0: 562 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew410μsselect * from `establishments` where `establishments`.`id` = 136 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 136
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew410μsselect * from `media` where `media`.`model_id` in (562) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew340μsselect * from `media` where `media`.`model_id` in (136) 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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew350μsselect * from `media` where `media`.`model_id` in (697) 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/Pagination/LengthAwarePaginator.php:196

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

Bindings	0: 565 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew400μsselect * from `establishments` where `establishments`.`id` = 224 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 224
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew400μsselect * from `media` where `media`.`model_id` in (565) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew470μsselect * from `media` where `media`.`model_id` in (224) 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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew470μsselect * from `media` where `media`.`model_id` in (744) 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/Pagination/LengthAwarePaginator.php:196

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

Bindings	0: 612 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew820μsselect * from `establishments` where `establishments`.`id` = 242 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 242
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew400μsselect * from `media` where `media`.`model_id` in (612) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew370μsselect * from `media` where `media`.`model_id` in (242) 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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew370μsselect * from `media` where `media`.`model_id` in (746) 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/Pagination/LengthAwarePaginator.php:196

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

Bindings	0: 614 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew440μsselect * from `establishments` where `establishments`.`id` = 242 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 242
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew400μsselect * from `media` where `media`.`model_id` in (614) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew340μsselect * from `media` where `media`.`model_id` in (242) 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/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew360μsselect * from `media` where `media`.`model_id` in (749) 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/Pagination/LengthAwarePaginator.php:196

Review.php#154primodishnew5.49msselect * from `dishes` where `dishes`.`id` = 617 and `dishes`.`deleted_at` is null and `moderate` = 'Approved' limit 1

Bindings	0: 617 1: Approved
Backtrace	app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196 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#236primodishnew540μsselect * from `establishments` where `establishments`.`id` = 75 and `establishments`.`deleted_at` is null limit 1
Bindings
0: 75
Backtrace
app/Models/Dish.php:236
app/Models/Review.php:154
vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew530μsselect * from `media` where `media`.`model_id` in (617) 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:212 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

InteractsWithMedia.php#545primodishnew440μsselect * from `media` where `media`.`model_id` in (75) 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/Pagination/LengthAwarePaginator.php:196

visitors-list.blade.php#177primodishnew1.15ms

select * from `list_dishes` where `list_dishes`.`list_id` = 1010 and `list_dishes`.`list_id` is not null and exists (select * from `reviews` where `list_dishes`.`review_id` = `reviews`.`id` and `deleted_at` is null and `deleted_at` is null and `reviews`.`deleted_at` is null) and `list_dishes`.`deleted_at` is null

Bindings	0: 1010
Backtrace	view::visitors-list:177 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#151primodishnew3.16ms

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` = 396 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: 396
Backtrace	app/Models/Dish.php:151 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#151primodishnew3.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` = 396 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: 396
Backtrace	app/Models/Dish.php:151 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#97primodishnew700μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 396 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: 396 1: Approved
Backtrace	app/Models/Dish.php:97 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#97primodishnew650μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 396 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: 396 1: Approved
Backtrace	app/Models/Dish.php:97 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#151primodishnew3.38ms

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` = 396 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: 396
Backtrace	app/Models/Dish.php:151 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#1117primodishnew420μs

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

Bindings	0: 396
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#1118primodishnew520μs

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

Bindings	0: 396
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#1120primodishnew510μs

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

Bindings	0: 396
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

Visitor.php#179primodishnew2.04msselect MAX(id) AS id from `reviews` where `visitor_id` = 22 and `reviews`.`deleted_at` is null group by `dish_id`

Bindings	0: 22
Backtrace	app/Models/Visitor.php:179 app/Models/Visitor.php:191 view::partials.profileHeader:37 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Visitor.php#191primodishnew12.87ms

select `dish_id` from `reviews` where `reviews`.`visitor_id` = 22 and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (153, 160, 166, 169, 170, 1356, 197, 209, 240, 260, 1353, 333, 346, 347, 349, 350, 351, 352, 353, 354, 356, 357, 365, 404, 1375, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 1374, 442, 443, 447, 450, 451, 452, 453, 454, 455, 460, 470, 472, 473, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 1320, 1401, 1321, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 1564, 566, 567, 568, 569, 570, 571, 572, 574, 575, 576, 577, 579, 580, 581, 1328, 583, 584, 585, 589, 590, 591, 592, 593, 594, 595, 596, 597, 1478, 599, 600, 602, 603, 607, 608, 609, 610, 612, 613, 614, 615, 616, 617, 618, 619, 620, 630, 631, 632, 633, 634, 635, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 657, 658, 1373, 660, 661, 662, 663, 664, 665, 666, 669, 670, 671, 672, 673, 674, 675, 676, 689, 690, 691, 692, 693, 694, 695, 1503, 697, 1502, 699, 700, 701, 704, 705, 706, 1457, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 733, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 835, 836, 837, 838, 840, 845, 846, 847, 848, 849, 850, 851, 852, 853, 1372, 855, 856, 858, 859, 860, 861, 862, 863, 864, 865, 866, 1632, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 881, 882, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 910, 911, 914, 915, 916, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 1506, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 1354, 970, 971, 972, 1366, 1367, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 996, 1414, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1424, 1425, 1018, 1417, 1415, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1500, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1355, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1371, 1100, 1101, 1102, 1103, 1104, 1105, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1164, 1165, 1166, 1167, 1291, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1359, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1565, 1265, 1266, 1267, 1268, 1269, 1270, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1288, 1289, 1290, 1292, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1323, 1324, 1509, 1508, 1327, 1329, 1330, 1331, 1332, 1333, 1474, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1350, 1351, 1357, 1454, 1360, 1361, 1362, 1363, 1364, 1365, 1399, 1400, 1402, 1403, 1406, 1407, 1412, 1413, 1416, 1420, 1421, 1422, 1423, 1426, 1427, 1428, 1429, 1430, 1431, 1432, 1433, 1434, 1436, 1437, 1438, 1439, 1441, 1443, 1445, 1446, 1447, 1448, 1449, 1451, 1452, 1453, 1455, 1456, 1458, 1459, 1460, 1461, 1462, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1477, 1479, 1480, 1481, 1482, 1483, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1501, 1504, 1505, 1507, 1510, 1511, 1518, 1519, 1521, 1522, 1523, 1524, 1525, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1563, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1588, 1589, 1590, 1591, 1592, 1599, 1600, 1601, 1603, 1604, 1605, 1606, 1607, 1608, 1633, 1613, 1627, 1628) 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: 22
1: Approved
2: 153
3: 160
4: 166
5: 169
6: 170
7: 1356
8: 197
9: 209
10: 240
11: 260
12: 1353
13: 333
14: 346
15: 347
16: 349
17: 350
18: 351
19: 352
20: 353
21: 354
22: 356
23: 357
24: 365
25: 404
26: 1375
27: 406
28: 407
29: 408
30: 409
31: 410
32: 411
33: 412
34: 413
35: 414
36: 415
37: 416
38: 417
39: 418
40: 419
41: 424
42: 425
43: 426
44: 427
45: 428
46: 429
47: 431
48: 432
49: 433
50: 434
51: 1374
52: 442
53: 443
54: 447
55: 450
56: 451
57: 452
58: 453
59: 454
60: 455
61: 460
62: 470
63: 472
64: 473
65: 483
66: 484
67: 485
68: 486
69: 487
70: 488
71: 489
72: 490
73: 491
74: 492
75: 493
76: 494
77: 495
78: 496
79: 497
80: 498
81: 499
82: 500
83: 501
84: 502
85: 503
86: 504
87: 505
88: 506
89: 507
90: 508
91: 509
92: 510
93: 511
94: 1320
95: 1401
96: 1321
97: 515
98: 516
99: 517
100: 518
101: 519
102: 520
103: 521
104: 522
105: 523
106: 524
107: 525
108: 535
109: 536
110: 537
111: 538
112: 539
113: 540
114: 541
115: 542
116: 543
117: 544
118: 545
119: 552
120: 553
121: 554
122: 555
123: 556
124: 557
125: 558
126: 559
127: 560
128: 561
129: 562
130: 563
131: 564
132: 1564
133: 566
134: 567
135: 568
136: 569
137: 570
138: 571
139: 572
140: 574
141: 575
142: 576
143: 577
144: 579
145: 580
146: 581
147: 1328
148: 583
149: 584
150: 585
151: 589
152: 590
153: 591
154: 592
155: 593
156: 594
157: 595
158: 596
159: 597
160: 1478
161: 599
162: 600
163: 602
164: 603
165: 607
166: 608
167: 609
168: 610
169: 612
170: 613
171: 614
172: 615
173: 616
174: 617
175: 618
176: 619
177: 620
178: 630
179: 631
180: 632
181: 633
182: 634
183: 635
184: 637
185: 638
186: 639
187: 640
188: 641
189: 642
190: 643
191: 644
192: 645
193: 646
194: 647
195: 648
196: 649
197: 650
198: 651
199: 652
200: 653
201: 654
202: 657
203: 658
204: 1373
205: 660
206: 661
207: 662
208: 663
209: 664
210: 665
211: 666
212: 669
213: 670
214: 671
215: 672
216: 673
217: 674
218: 675
219: 676
220: 689
221: 690
222: 691
223: 692
224: 693
225: 694
226: 695
227: 1503
228: 697
229: 1502
230: 699
231: 700
232: 701
233: 704
234: 705
235: 706
236: 1457
237: 708
238: 709
239: 710
240: 711
241: 712
242: 713
243: 714
244: 715
245: 716
246: 717
247: 718
248: 719
249: 720
250: 721
251: 722
252: 723
253: 733
254: 735
255: 736
256: 737
257: 738
258: 739
259: 740
260: 741
261: 742
262: 743
263: 744
264: 745
265: 746
266: 747
267: 748
268: 749
269: 750
270: 751
271: 752
272: 753
273: 754
274: 755
275: 756
276: 757
277: 758
278: 759
279: 760
280: 761
281: 762
282: 763
283: 764
284: 765
285: 766
286: 767
287: 768
288: 769
289: 770
290: 771
291: 772
292: 773
293: 774
294: 775
295: 776
296: 777
297: 778
298: 779
299: 780
300: 781
301: 782
302: 783
303: 784
304: 785
305: 786
306: 787
307: 788
308: 789
309: 790
310: 791
311: 792
312: 793
313: 794
314: 795
315: 797
316: 798
317: 799
318: 800
319: 801
320: 802
321: 803
322: 804
323: 805
324: 806
325: 807
326: 808
327: 809
328: 810
329: 811
330: 812
331: 813
332: 814
333: 815
334: 816
335: 817
336: 818
337: 819
338: 820
339: 821
340: 835
341: 836
342: 837
343: 838
344: 840
345: 845
346: 846
347: 847
348: 848
349: 849
350: 850
351: 851
352: 852
353: 853
354: 1372
355: 855
356: 856
357: 858
358: 859
359: 860
360: 861
361: 862
362: 863
363: 864
364: 865
365: 866
366: 1632
367: 868
368: 869
369: 870
370: 871
371: 872
372: 873
373: 874
374: 875
375: 876
376: 877
377: 878
378: 879
379: 881
380: 882
381: 884
382: 885
383: 886
384: 887
385: 888
386: 889
387: 890
388: 891
389: 892
390: 893
391: 894
392: 895
393: 896
394: 897
395: 898
396: 899
397: 900
398: 901
399: 902
400: 903
401: 904
402: 905
403: 906
404: 907
405: 908
406: 910
407: 911
408: 914
409: 915
410: 916
411: 919
412: 920
413: 921
414: 922
415: 923
416: 924
417: 925
418: 926
419: 927
420: 928
421: 929
422: 930
423: 931
424: 932
425: 933
426: 934
427: 935
428: 936
429: 937
430: 938
431: 939
432: 940
433: 941
434: 942
435: 943
436: 944
437: 945
438: 946
439: 947
440: 948
441: 949
442: 950
443: 951
444: 952
445: 953
446: 954
447: 955
448: 1506
449: 957
450: 958
451: 959
452: 960
453: 961
454: 962
455: 963
456: 964
457: 965
458: 966
459: 967
460: 968
461: 1354
462: 970
463: 971
464: 972
465: 1366
466: 1367
467: 975
468: 976
469: 977
470: 978
471: 979
472: 980
473: 981
474: 982
475: 983
476: 984
477: 985
478: 986
479: 987
480: 988
481: 989
482: 990
483: 991
484: 992
485: 993
486: 994
487: 996
488: 1414
489: 998
490: 999
491: 1000
492: 1001
493: 1002
494: 1003
495: 1004
496: 1005
497: 1006
498: 1008
499: 1009
500: 1010
501: 1011
502: 1012
503: 1013
504: 1014
505: 1015
506: 1424
507: 1425
508: 1018
509: 1417
510: 1415
511: 1021
512: 1022
513: 1023
514: 1024
515: 1025
516: 1026
517: 1027
518: 1500
519: 1029
520: 1030
521: 1031
522: 1032
523: 1033
524: 1034
525: 1035
526: 1036
527: 1037
528: 1038
529: 1039
530: 1040
531: 1041
532: 1042
533: 1043
534: 1044
535: 1045
536: 1046
537: 1047
538: 1048
539: 1049
540: 1050
541: 1051
542: 1052
543: 1053
544: 1054
545: 1055
546: 1056
547: 1057
548: 1058
549: 1059
550: 1060
551: 1061
552: 1062
553: 1063
554: 1064
555: 1065
556: 1066
557: 1067
558: 1068
559: 1069
560: 1070
561: 1071
562: 1072
563: 1073
564: 1074
565: 1075
566: 1076
567: 1077
568: 1078
569: 1079
570: 1080
571: 1355
572: 1082
573: 1083
574: 1084
575: 1085
576: 1086
577: 1087
578: 1088
579: 1089
580: 1090
581: 1091
582: 1092
583: 1093
584: 1094
585: 1095
586: 1096
587: 1097
588: 1098
589: 1371
590: 1100
591: 1101
592: 1102
593: 1103
594: 1104
595: 1105
596: 1108
597: 1109
598: 1110
599: 1111
600: 1112
601: 1113
602: 1114
603: 1115
604: 1116
605: 1117
606: 1118
607: 1119
608: 1120
609: 1121
610: 1122
611: 1126
612: 1127
613: 1128
614: 1129
615: 1130
616: 1131
617: 1132
618: 1133
619: 1134
620: 1135
621: 1164
622: 1165
623: 1166
624: 1167
625: 1291
626: 1169
627: 1170
628: 1171
629: 1172
630: 1173
631: 1174
632: 1175
633: 1176
634: 1177
635: 1178
636: 1179
637: 1180
638: 1181
639: 1182
640: 1183
641: 1184
642: 1185
643: 1186
644: 1187
645: 1188
646: 1189
647: 1190
648: 1191
649: 1192
650: 1193
651: 1194
652: 1195
653: 1196
654: 1197
655: 1198
656: 1199
657: 1200
658: 1201
659: 1202
660: 1203
661: 1204
662: 1205
663: 1206
664: 1207
665: 1208
666: 1209
667: 1210
668: 1211
669: 1212
670: 1213
671: 1214
672: 1215
673: 1216
674: 1217
675: 1218
676: 1219
677: 1220
678: 1221
679: 1222
680: 1223
681: 1224
682: 1225
683: 1226
684: 1227
685: 1228
686: 1229
687: 1230
688: 1231
689: 1232
690: 1233
691: 1234
692: 1235
693: 1236
694: 1359
695: 1238
696: 1239
697: 1240
698: 1241
699: 1242
700: 1243
701: 1244
702: 1245
703: 1246
704: 1247
705: 1248
706: 1249
707: 1250
708: 1251
709: 1252
710: 1253
711: 1254
712: 1255
713: 1256
714: 1257
715: 1258
716: 1259
717: 1260
718: 1261
719: 1262
720: 1263
721: 1565
722: 1265
723: 1266
724: 1267
725: 1268
726: 1269
727: 1270
728: 1272
729: 1273
730: 1274
731: 1275
732: 1276
733: 1277
734: 1278
735: 1279
736: 1280
737: 1281
738: 1282
739: 1283
740: 1284
741: 1285
742: 1286
743: 1288
744: 1289
745: 1290
746: 1292
747: 1293
748: 1294
749: 1295
750: 1296
751: 1297
752: 1298
753: 1299
754: 1300
755: 1301
756: 1304
757: 1305
758: 1306
759: 1307
760: 1308
761: 1309
762: 1310
763: 1311
764: 1312
765: 1313
766: 1314
767: 1315
768: 1316
769: 1317
770: 1318
771: 1319
772: 1323
773: 1324
774: 1509
775: 1508
776: 1327
777: 1329
778: 1330
779: 1331
780: 1332
781: 1333
782: 1474
783: 1336
784: 1337
785: 1338
786: 1339
787: 1340
788: 1341
789: 1342
790: 1343
791: 1344
792: 1345
793: 1346
794: 1347
795: 1348
796: 1350
797: 1351
798: 1357
799: 1454
800: 1360
801: 1361
802: 1362
803: 1363
804: 1364
805: 1365
806: 1399
807: 1400
808: 1402
809: 1403
810: 1406
811: 1407
812: 1412
813: 1413
814: 1416
815: 1420
816: 1421
817: 1422
818: 1423
819: 1426
820: 1427
821: 1428
822: 1429
823: 1430
824: 1431
825: 1432
826: 1433
827: 1434
828: 1436
829: 1437
830: 1438
831: 1439
832: 1441
833: 1443
834: 1445
835: 1446
836: 1447
837: 1448
838: 1449
839: 1451
840: 1452
841: 1453
842: 1455
843: 1456
844: 1458
845: 1459
846: 1460
847: 1461
848: 1462
849: 1465
850: 1466
851: 1467
852: 1468
853: 1469
854: 1470
855: 1471
856: 1472
857: 1473
858: 1477
859: 1479
860: 1480
861: 1481
862: 1482
863: 1483
864: 1488
865: 1489
866: 1490
867: 1491
868: 1492
869: 1493
870: 1494
871: 1495
872: 1496
873: 1497
874: 1498
875: 1499
876: 1501
877: 1504
878: 1505
879: 1507
880: 1510
881: 1511
882: 1518
883: 1519
884: 1521
885: 1522
886: 1523
887: 1524
888: 1525
889: 1527
890: 1529
891: 1530
892: 1531
893: 1532
894: 1533
895: 1534
896: 1535
897: 1536
898: 1537
899: 1538
900: 1539
901: 1540
902: 1541
903: 1542
904: 1543
905: 1544
906: 1545
907: 1546
908: 1547
909: 1548
910: 1549
911: 1550
912: 1551
913: 1552
914: 1553
915: 1554
916: 1555
917: 1556
918: 1557
919: 1563
920: 1568
921: 1569
922: 1570
923: 1571
924: 1572
925: 1573
926: 1574
927: 1575
928: 1576
929: 1577
930: 1578
931: 1579
932: 1580
933: 1581
934: 1582
935: 1583
936: 1584
937: 1585
938: 1586
939: 1588
940: 1589
941: 1590
942: 1591
943: 1592
944: 1599
945: 1600
946: 1601
947: 1603
948: 1604
949: 1605
950: 1606
951: 1607
952: 1608
953: 1633
954: 1613
955: 1627
956: 1628
957: Approved

Backtrace

app/Models/Visitor.php:191
view::partials.profileHeader:37
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

profileHeader.blade.php#37primodishnew500μs

select * from `visitors_followings` where `visitors_followings`.`follow_visitors_id` = 22 and `visitors_followings`.`follow_visitors_id` is not null and `visitors_followings`.`deleted_at` is null

Bindings	0: 22
Backtrace	view::partials.profileHeader:37 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

reviewbox.blade.php#67primodishnew470μs

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` = 520 and `m_dietry_considerations`.`deleted_at` is null

Bindings	0: 520
Backtrace	view::partials.reviewbox:67 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#151primodishnew3.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` = 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:151 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#151primodishnew2.77ms

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:151 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#97primodishnew710μ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:97 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#97primodishnew640μ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:97 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#151primodishnew2.57ms

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:151 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#1117primodishnew370μ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#1118primodishnew540μ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#1120primodishnew480μ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: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

Visitor.php#179primodishnew2.01msselect MAX(id) AS id from `reviews` where `visitor_id` = 22 and `reviews`.`deleted_at` is null group by `dish_id`

Bindings	0: 22
Backtrace	app/Models/Visitor.php:179 app/Models/Visitor.php:191 view::partials.profileHeader:37 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Visitor.php#191primodishnew13.44ms

select `dish_id` from `reviews` where `reviews`.`visitor_id` = 22 and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (153, 160, 166, 169, 170, 1356, 197, 209, 240, 260, 1353, 333, 346, 347, 349, 350, 351, 352, 353, 354, 356, 357, 365, 404, 1375, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 1374, 442, 443, 447, 450, 451, 452, 453, 454, 455, 460, 470, 472, 473, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 1320, 1401, 1321, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 1564, 566, 567, 568, 569, 570, 571, 572, 574, 575, 576, 577, 579, 580, 581, 1328, 583, 584, 585, 589, 590, 591, 592, 593, 594, 595, 596, 597, 1478, 599, 600, 602, 603, 607, 608, 609, 610, 612, 613, 614, 615, 616, 617, 618, 619, 620, 630, 631, 632, 633, 634, 635, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 657, 658, 1373, 660, 661, 662, 663, 664, 665, 666, 669, 670, 671, 672, 673, 674, 675, 676, 689, 690, 691, 692, 693, 694, 695, 1503, 697, 1502, 699, 700, 701, 704, 705, 706, 1457, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 733, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 835, 836, 837, 838, 840, 845, 846, 847, 848, 849, 850, 851, 852, 853, 1372, 855, 856, 858, 859, 860, 861, 862, 863, 864, 865, 866, 1632, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 881, 882, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 910, 911, 914, 915, 916, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 1506, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 1354, 970, 971, 972, 1366, 1367, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 996, 1414, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1424, 1425, 1018, 1417, 1415, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1500, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1355, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1371, 1100, 1101, 1102, 1103, 1104, 1105, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1164, 1165, 1166, 1167, 1291, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1359, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1565, 1265, 1266, 1267, 1268, 1269, 1270, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1288, 1289, 1290, 1292, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1323, 1324, 1509, 1508, 1327, 1329, 1330, 1331, 1332, 1333, 1474, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1350, 1351, 1357, 1454, 1360, 1361, 1362, 1363, 1364, 1365, 1399, 1400, 1402, 1403, 1406, 1407, 1412, 1413, 1416, 1420, 1421, 1422, 1423, 1426, 1427, 1428, 1429, 1430, 1431, 1432, 1433, 1434, 1436, 1437, 1438, 1439, 1441, 1443, 1445, 1446, 1447, 1448, 1449, 1451, 1452, 1453, 1455, 1456, 1458, 1459, 1460, 1461, 1462, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1477, 1479, 1480, 1481, 1482, 1483, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1501, 1504, 1505, 1507, 1510, 1511, 1518, 1519, 1521, 1522, 1523, 1524, 1525, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1563, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1588, 1589, 1590, 1591, 1592, 1599, 1600, 1601, 1603, 1604, 1605, 1606, 1607, 1608, 1633, 1613, 1627, 1628) 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: 22
1: Approved
2: 153
3: 160
4: 166
5: 169
6: 170
7: 1356
8: 197
9: 209
10: 240
11: 260
12: 1353
13: 333
14: 346
15: 347
16: 349
17: 350
18: 351
19: 352
20: 353
21: 354
22: 356
23: 357
24: 365
25: 404
26: 1375
27: 406
28: 407
29: 408
30: 409
31: 410
32: 411
33: 412
34: 413
35: 414
36: 415
37: 416
38: 417
39: 418
40: 419
41: 424
42: 425
43: 426
44: 427
45: 428
46: 429
47: 431
48: 432
49: 433
50: 434
51: 1374
52: 442
53: 443
54: 447
55: 450
56: 451
57: 452
58: 453
59: 454
60: 455
61: 460
62: 470
63: 472
64: 473
65: 483
66: 484
67: 485
68: 486
69: 487
70: 488
71: 489
72: 490
73: 491
74: 492
75: 493
76: 494
77: 495
78: 496
79: 497
80: 498
81: 499
82: 500
83: 501
84: 502
85: 503
86: 504
87: 505
88: 506
89: 507
90: 508
91: 509
92: 510
93: 511
94: 1320
95: 1401
96: 1321
97: 515
98: 516
99: 517
100: 518
101: 519
102: 520
103: 521
104: 522
105: 523
106: 524
107: 525
108: 535
109: 536
110: 537
111: 538
112: 539
113: 540
114: 541
115: 542
116: 543
117: 544
118: 545
119: 552
120: 553
121: 554
122: 555
123: 556
124: 557
125: 558
126: 559
127: 560
128: 561
129: 562
130: 563
131: 564
132: 1564
133: 566
134: 567
135: 568
136: 569
137: 570
138: 571
139: 572
140: 574
141: 575
142: 576
143: 577
144: 579
145: 580
146: 581
147: 1328
148: 583
149: 584
150: 585
151: 589
152: 590
153: 591
154: 592
155: 593
156: 594
157: 595
158: 596
159: 597
160: 1478
161: 599
162: 600
163: 602
164: 603
165: 607
166: 608
167: 609
168: 610
169: 612
170: 613
171: 614
172: 615
173: 616
174: 617
175: 618
176: 619
177: 620
178: 630
179: 631
180: 632
181: 633
182: 634
183: 635
184: 637
185: 638
186: 639
187: 640
188: 641
189: 642
190: 643
191: 644
192: 645
193: 646
194: 647
195: 648
196: 649
197: 650
198: 651
199: 652
200: 653
201: 654
202: 657
203: 658
204: 1373
205: 660
206: 661
207: 662
208: 663
209: 664
210: 665
211: 666
212: 669
213: 670
214: 671
215: 672
216: 673
217: 674
218: 675
219: 676
220: 689
221: 690
222: 691
223: 692
224: 693
225: 694
226: 695
227: 1503
228: 697
229: 1502
230: 699
231: 700
232: 701
233: 704
234: 705
235: 706
236: 1457
237: 708
238: 709
239: 710
240: 711
241: 712
242: 713
243: 714
244: 715
245: 716
246: 717
247: 718
248: 719
249: 720
250: 721
251: 722
252: 723
253: 733
254: 735
255: 736
256: 737
257: 738
258: 739
259: 740
260: 741
261: 742
262: 743
263: 744
264: 745
265: 746
266: 747
267: 748
268: 749
269: 750
270: 751
271: 752
272: 753
273: 754
274: 755
275: 756
276: 757
277: 758
278: 759
279: 760
280: 761
281: 762
282: 763
283: 764
284: 765
285: 766
286: 767
287: 768
288: 769
289: 770
290: 771
291: 772
292: 773
293: 774
294: 775
295: 776
296: 777
297: 778
298: 779
299: 780
300: 781
301: 782
302: 783
303: 784
304: 785
305: 786
306: 787
307: 788
308: 789
309: 790
310: 791
311: 792
312: 793
313: 794
314: 795
315: 797
316: 798
317: 799
318: 800
319: 801
320: 802
321: 803
322: 804
323: 805
324: 806
325: 807
326: 808
327: 809
328: 810
329: 811
330: 812
331: 813
332: 814
333: 815
334: 816
335: 817
336: 818
337: 819
338: 820
339: 821
340: 835
341: 836
342: 837
343: 838
344: 840
345: 845
346: 846
347: 847
348: 848
349: 849
350: 850
351: 851
352: 852
353: 853
354: 1372
355: 855
356: 856
357: 858
358: 859
359: 860
360: 861
361: 862
362: 863
363: 864
364: 865
365: 866
366: 1632
367: 868
368: 869
369: 870
370: 871
371: 872
372: 873
373: 874
374: 875
375: 876
376: 877
377: 878
378: 879
379: 881
380: 882
381: 884
382: 885
383: 886
384: 887
385: 888
386: 889
387: 890
388: 891
389: 892
390: 893
391: 894
392: 895
393: 896
394: 897
395: 898
396: 899
397: 900
398: 901
399: 902
400: 903
401: 904
402: 905
403: 906
404: 907
405: 908
406: 910
407: 911
408: 914
409: 915
410: 916
411: 919
412: 920
413: 921
414: 922
415: 923
416: 924
417: 925
418: 926
419: 927
420: 928
421: 929
422: 930
423: 931
424: 932
425: 933
426: 934
427: 935
428: 936
429: 937
430: 938
431: 939
432: 940
433: 941
434: 942
435: 943
436: 944
437: 945
438: 946
439: 947
440: 948
441: 949
442: 950
443: 951
444: 952
445: 953
446: 954
447: 955
448: 1506
449: 957
450: 958
451: 959
452: 960
453: 961
454: 962
455: 963
456: 964
457: 965
458: 966
459: 967
460: 968
461: 1354
462: 970
463: 971
464: 972
465: 1366
466: 1367
467: 975
468: 976
469: 977
470: 978
471: 979
472: 980
473: 981
474: 982
475: 983
476: 984
477: 985
478: 986
479: 987
480: 988
481: 989
482: 990
483: 991
484: 992
485: 993
486: 994
487: 996
488: 1414
489: 998
490: 999
491: 1000
492: 1001
493: 1002
494: 1003
495: 1004
496: 1005
497: 1006
498: 1008
499: 1009
500: 1010
501: 1011
502: 1012
503: 1013
504: 1014
505: 1015
506: 1424
507: 1425
508: 1018
509: 1417
510: 1415
511: 1021
512: 1022
513: 1023
514: 1024
515: 1025
516: 1026
517: 1027
518: 1500
519: 1029
520: 1030
521: 1031
522: 1032
523: 1033
524: 1034
525: 1035
526: 1036
527: 1037
528: 1038
529: 1039
530: 1040
531: 1041
532: 1042
533: 1043
534: 1044
535: 1045
536: 1046
537: 1047
538: 1048
539: 1049
540: 1050
541: 1051
542: 1052
543: 1053
544: 1054
545: 1055
546: 1056
547: 1057
548: 1058
549: 1059
550: 1060
551: 1061
552: 1062
553: 1063
554: 1064
555: 1065
556: 1066
557: 1067
558: 1068
559: 1069
560: 1070
561: 1071
562: 1072
563: 1073
564: 1074
565: 1075
566: 1076
567: 1077
568: 1078
569: 1079
570: 1080
571: 1355
572: 1082
573: 1083
574: 1084
575: 1085
576: 1086
577: 1087
578: 1088
579: 1089
580: 1090
581: 1091
582: 1092
583: 1093
584: 1094
585: 1095
586: 1096
587: 1097
588: 1098
589: 1371
590: 1100
591: 1101
592: 1102
593: 1103
594: 1104
595: 1105
596: 1108
597: 1109
598: 1110
599: 1111
600: 1112
601: 1113
602: 1114
603: 1115
604: 1116
605: 1117
606: 1118
607: 1119
608: 1120
609: 1121
610: 1122
611: 1126
612: 1127
613: 1128
614: 1129
615: 1130
616: 1131
617: 1132
618: 1133
619: 1134
620: 1135
621: 1164
622: 1165
623: 1166
624: 1167
625: 1291
626: 1169
627: 1170
628: 1171
629: 1172
630: 1173
631: 1174
632: 1175
633: 1176
634: 1177
635: 1178
636: 1179
637: 1180
638: 1181
639: 1182
640: 1183
641: 1184
642: 1185
643: 1186
644: 1187
645: 1188
646: 1189
647: 1190
648: 1191
649: 1192
650: 1193
651: 1194
652: 1195
653: 1196
654: 1197
655: 1198
656: 1199
657: 1200
658: 1201
659: 1202
660: 1203
661: 1204
662: 1205
663: 1206
664: 1207
665: 1208
666: 1209
667: 1210
668: 1211
669: 1212
670: 1213
671: 1214
672: 1215
673: 1216
674: 1217
675: 1218
676: 1219
677: 1220
678: 1221
679: 1222
680: 1223
681: 1224
682: 1225
683: 1226
684: 1227
685: 1228
686: 1229
687: 1230
688: 1231
689: 1232
690: 1233
691: 1234
692: 1235
693: 1236
694: 1359
695: 1238
696: 1239
697: 1240
698: 1241
699: 1242
700: 1243
701: 1244
702: 1245
703: 1246
704: 1247
705: 1248
706: 1249
707: 1250
708: 1251
709: 1252
710: 1253
711: 1254
712: 1255
713: 1256
714: 1257
715: 1258
716: 1259
717: 1260
718: 1261
719: 1262
720: 1263
721: 1565
722: 1265
723: 1266
724: 1267
725: 1268
726: 1269
727: 1270
728: 1272
729: 1273
730: 1274
731: 1275
732: 1276
733: 1277
734: 1278
735: 1279
736: 1280
737: 1281
738: 1282
739: 1283
740: 1284
741: 1285
742: 1286
743: 1288
744: 1289
745: 1290
746: 1292
747: 1293
748: 1294
749: 1295
750: 1296
751: 1297
752: 1298
753: 1299
754: 1300
755: 1301
756: 1304
757: 1305
758: 1306
759: 1307
760: 1308
761: 1309
762: 1310
763: 1311
764: 1312
765: 1313
766: 1314
767: 1315
768: 1316
769: 1317
770: 1318
771: 1319
772: 1323
773: 1324
774: 1509
775: 1508
776: 1327
777: 1329
778: 1330
779: 1331
780: 1332
781: 1333
782: 1474
783: 1336
784: 1337
785: 1338
786: 1339
787: 1340
788: 1341
789: 1342
790: 1343
791: 1344
792: 1345
793: 1346
794: 1347
795: 1348
796: 1350
797: 1351
798: 1357
799: 1454
800: 1360
801: 1361
802: 1362
803: 1363
804: 1364
805: 1365
806: 1399
807: 1400
808: 1402
809: 1403
810: 1406
811: 1407
812: 1412
813: 1413
814: 1416
815: 1420
816: 1421
817: 1422
818: 1423
819: 1426
820: 1427
821: 1428
822: 1429
823: 1430
824: 1431
825: 1432
826: 1433
827: 1434
828: 1436
829: 1437
830: 1438
831: 1439
832: 1441
833: 1443
834: 1445
835: 1446
836: 1447
837: 1448
838: 1449
839: 1451
840: 1452
841: 1453
842: 1455
843: 1456
844: 1458
845: 1459
846: 1460
847: 1461
848: 1462
849: 1465
850: 1466
851: 1467
852: 1468
853: 1469
854: 1470
855: 1471
856: 1472
857: 1473
858: 1477
859: 1479
860: 1480
861: 1481
862: 1482
863: 1483
864: 1488
865: 1489
866: 1490
867: 1491
868: 1492
869: 1493
870: 1494
871: 1495
872: 1496
873: 1497
874: 1498
875: 1499
876: 1501
877: 1504
878: 1505
879: 1507
880: 1510
881: 1511
882: 1518
883: 1519
884: 1521
885: 1522
886: 1523
887: 1524
888: 1525
889: 1527
890: 1529
891: 1530
892: 1531
893: 1532
894: 1533
895: 1534
896: 1535
897: 1536
898: 1537
899: 1538
900: 1539
901: 1540
902: 1541
903: 1542
904: 1543
905: 1544
906: 1545
907: 1546
908: 1547
909: 1548
910: 1549
911: 1550
912: 1551
913: 1552
914: 1553
915: 1554
916: 1555
917: 1556
918: 1557
919: 1563
920: 1568
921: 1569
922: 1570
923: 1571
924: 1572
925: 1573
926: 1574
927: 1575
928: 1576
929: 1577
930: 1578
931: 1579
932: 1580
933: 1581
934: 1582
935: 1583
936: 1584
937: 1585
938: 1586
939: 1588
940: 1589
941: 1590
942: 1591
943: 1592
944: 1599
945: 1600
946: 1601
947: 1603
948: 1604
949: 1605
950: 1606
951: 1607
952: 1608
953: 1633
954: 1613
955: 1627
956: 1628
957: Approved

Backtrace

app/Models/Visitor.php:191
view::partials.profileHeader:37
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

reviewbox.blade.php#67primodishnew630μs

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` = 581 and `m_dietry_considerations`.`deleted_at` is null

Bindings	0: 581
Backtrace	view::partials.reviewbox:67 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#151primodishnew3.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` = 452 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: 452
Backtrace	app/Models/Dish.php:151 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#151primodishnew2.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` = 452 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: 452
Backtrace	app/Models/Dish.php:151 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#97primodishnew780μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 452 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: 452 1: Approved
Backtrace	app/Models/Dish.php:97 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#97primodishnew650μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 452 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: 452 1: Approved
Backtrace	app/Models/Dish.php:97 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#151primodishnew2.72ms

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` = 452 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: 452
Backtrace	app/Models/Dish.php:151 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#1117primodishnew400μs

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

Bindings	0: 452
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#1118primodishnew490μs

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

Bindings	0: 452
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#1120primodishnew470μs

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

Bindings	0: 452
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

Visitor.php#179primodishnew2.25msselect MAX(id) AS id from `reviews` where `visitor_id` = 22 and `reviews`.`deleted_at` is null group by `dish_id`

Bindings	0: 22
Backtrace	app/Models/Visitor.php:179 app/Models/Visitor.php:191 view::partials.profileHeader:37 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Visitor.php#191primodishnew13.25ms

select `dish_id` from `reviews` where `reviews`.`visitor_id` = 22 and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (153, 160, 166, 169, 170, 1356, 197, 209, 240, 260, 1353, 333, 346, 347, 349, 350, 351, 352, 353, 354, 356, 357, 365, 404, 1375, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 1374, 442, 443, 447, 450, 451, 452, 453, 454, 455, 460, 470, 472, 473, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 1320, 1401, 1321, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 1564, 566, 567, 568, 569, 570, 571, 572, 574, 575, 576, 577, 579, 580, 581, 1328, 583, 584, 585, 589, 590, 591, 592, 593, 594, 595, 596, 597, 1478, 599, 600, 602, 603, 607, 608, 609, 610, 612, 613, 614, 615, 616, 617, 618, 619, 620, 630, 631, 632, 633, 634, 635, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 657, 658, 1373, 660, 661, 662, 663, 664, 665, 666, 669, 670, 671, 672, 673, 674, 675, 676, 689, 690, 691, 692, 693, 694, 695, 1503, 697, 1502, 699, 700, 701, 704, 705, 706, 1457, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 733, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 835, 836, 837, 838, 840, 845, 846, 847, 848, 849, 850, 851, 852, 853, 1372, 855, 856, 858, 859, 860, 861, 862, 863, 864, 865, 866, 1632, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 881, 882, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 910, 911, 914, 915, 916, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 1506, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 1354, 970, 971, 972, 1366, 1367, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 996, 1414, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1424, 1425, 1018, 1417, 1415, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1500, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1355, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1371, 1100, 1101, 1102, 1103, 1104, 1105, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1164, 1165, 1166, 1167, 1291, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1359, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1565, 1265, 1266, 1267, 1268, 1269, 1270, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1288, 1289, 1290, 1292, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1323, 1324, 1509, 1508, 1327, 1329, 1330, 1331, 1332, 1333, 1474, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1350, 1351, 1357, 1454, 1360, 1361, 1362, 1363, 1364, 1365, 1399, 1400, 1402, 1403, 1406, 1407, 1412, 1413, 1416, 1420, 1421, 1422, 1423, 1426, 1427, 1428, 1429, 1430, 1431, 1432, 1433, 1434, 1436, 1437, 1438, 1439, 1441, 1443, 1445, 1446, 1447, 1448, 1449, 1451, 1452, 1453, 1455, 1456, 1458, 1459, 1460, 1461, 1462, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1477, 1479, 1480, 1481, 1482, 1483, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1501, 1504, 1505, 1507, 1510, 1511, 1518, 1519, 1521, 1522, 1523, 1524, 1525, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1563, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1588, 1589, 1590, 1591, 1592, 1599, 1600, 1601, 1603, 1604, 1605, 1606, 1607, 1608, 1633, 1613, 1627, 1628) 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: 22
1: Approved
2: 153
3: 160
4: 166
5: 169
6: 170
7: 1356
8: 197
9: 209
10: 240
11: 260
12: 1353
13: 333
14: 346
15: 347
16: 349
17: 350
18: 351
19: 352
20: 353
21: 354
22: 356
23: 357
24: 365
25: 404
26: 1375
27: 406
28: 407
29: 408
30: 409
31: 410
32: 411
33: 412
34: 413
35: 414
36: 415
37: 416
38: 417
39: 418
40: 419
41: 424
42: 425
43: 426
44: 427
45: 428
46: 429
47: 431
48: 432
49: 433
50: 434
51: 1374
52: 442
53: 443
54: 447
55: 450
56: 451
57: 452
58: 453
59: 454
60: 455
61: 460
62: 470
63: 472
64: 473
65: 483
66: 484
67: 485
68: 486
69: 487
70: 488
71: 489
72: 490
73: 491
74: 492
75: 493
76: 494
77: 495
78: 496
79: 497
80: 498
81: 499
82: 500
83: 501
84: 502
85: 503
86: 504
87: 505
88: 506
89: 507
90: 508
91: 509
92: 510
93: 511
94: 1320
95: 1401
96: 1321
97: 515
98: 516
99: 517
100: 518
101: 519
102: 520
103: 521
104: 522
105: 523
106: 524
107: 525
108: 535
109: 536
110: 537
111: 538
112: 539
113: 540
114: 541
115: 542
116: 543
117: 544
118: 545
119: 552
120: 553
121: 554
122: 555
123: 556
124: 557
125: 558
126: 559
127: 560
128: 561
129: 562
130: 563
131: 564
132: 1564
133: 566
134: 567
135: 568
136: 569
137: 570
138: 571
139: 572
140: 574
141: 575
142: 576
143: 577
144: 579
145: 580
146: 581
147: 1328
148: 583
149: 584
150: 585
151: 589
152: 590
153: 591
154: 592
155: 593
156: 594
157: 595
158: 596
159: 597
160: 1478
161: 599
162: 600
163: 602
164: 603
165: 607
166: 608
167: 609
168: 610
169: 612
170: 613
171: 614
172: 615
173: 616
174: 617
175: 618
176: 619
177: 620
178: 630
179: 631
180: 632
181: 633
182: 634
183: 635
184: 637
185: 638
186: 639
187: 640
188: 641
189: 642
190: 643
191: 644
192: 645
193: 646
194: 647
195: 648
196: 649
197: 650
198: 651
199: 652
200: 653
201: 654
202: 657
203: 658
204: 1373
205: 660
206: 661
207: 662
208: 663
209: 664
210: 665
211: 666
212: 669
213: 670
214: 671
215: 672
216: 673
217: 674
218: 675
219: 676
220: 689
221: 690
222: 691
223: 692
224: 693
225: 694
226: 695
227: 1503
228: 697
229: 1502
230: 699
231: 700
232: 701
233: 704
234: 705
235: 706
236: 1457
237: 708
238: 709
239: 710
240: 711
241: 712
242: 713
243: 714
244: 715
245: 716
246: 717
247: 718
248: 719
249: 720
250: 721
251: 722
252: 723
253: 733
254: 735
255: 736
256: 737
257: 738
258: 739
259: 740
260: 741
261: 742
262: 743
263: 744
264: 745
265: 746
266: 747
267: 748
268: 749
269: 750
270: 751
271: 752
272: 753
273: 754
274: 755
275: 756
276: 757
277: 758
278: 759
279: 760
280: 761
281: 762
282: 763
283: 764
284: 765
285: 766
286: 767
287: 768
288: 769
289: 770
290: 771
291: 772
292: 773
293: 774
294: 775
295: 776
296: 777
297: 778
298: 779
299: 780
300: 781
301: 782
302: 783
303: 784
304: 785
305: 786
306: 787
307: 788
308: 789
309: 790
310: 791
311: 792
312: 793
313: 794
314: 795
315: 797
316: 798
317: 799
318: 800
319: 801
320: 802
321: 803
322: 804
323: 805
324: 806
325: 807
326: 808
327: 809
328: 810
329: 811
330: 812
331: 813
332: 814
333: 815
334: 816
335: 817
336: 818
337: 819
338: 820
339: 821
340: 835
341: 836
342: 837
343: 838
344: 840
345: 845
346: 846
347: 847
348: 848
349: 849
350: 850
351: 851
352: 852
353: 853
354: 1372
355: 855
356: 856
357: 858
358: 859
359: 860
360: 861
361: 862
362: 863
363: 864
364: 865
365: 866
366: 1632
367: 868
368: 869
369: 870
370: 871
371: 872
372: 873
373: 874
374: 875
375: 876
376: 877
377: 878
378: 879
379: 881
380: 882
381: 884
382: 885
383: 886
384: 887
385: 888
386: 889
387: 890
388: 891
389: 892
390: 893
391: 894
392: 895
393: 896
394: 897
395: 898
396: 899
397: 900
398: 901
399: 902
400: 903
401: 904
402: 905
403: 906
404: 907
405: 908
406: 910
407: 911
408: 914
409: 915
410: 916
411: 919
412: 920
413: 921
414: 922
415: 923
416: 924
417: 925
418: 926
419: 927
420: 928
421: 929
422: 930
423: 931
424: 932
425: 933
426: 934
427: 935
428: 936
429: 937
430: 938
431: 939
432: 940
433: 941
434: 942
435: 943
436: 944
437: 945
438: 946
439: 947
440: 948
441: 949
442: 950
443: 951
444: 952
445: 953
446: 954
447: 955
448: 1506
449: 957
450: 958
451: 959
452: 960
453: 961
454: 962
455: 963
456: 964
457: 965
458: 966
459: 967
460: 968
461: 1354
462: 970
463: 971
464: 972
465: 1366
466: 1367
467: 975
468: 976
469: 977
470: 978
471: 979
472: 980
473: 981
474: 982
475: 983
476: 984
477: 985
478: 986
479: 987
480: 988
481: 989
482: 990
483: 991
484: 992
485: 993
486: 994
487: 996
488: 1414
489: 998
490: 999
491: 1000
492: 1001
493: 1002
494: 1003
495: 1004
496: 1005
497: 1006
498: 1008
499: 1009
500: 1010
501: 1011
502: 1012
503: 1013
504: 1014
505: 1015
506: 1424
507: 1425
508: 1018
509: 1417
510: 1415
511: 1021
512: 1022
513: 1023
514: 1024
515: 1025
516: 1026
517: 1027
518: 1500
519: 1029
520: 1030
521: 1031
522: 1032
523: 1033
524: 1034
525: 1035
526: 1036
527: 1037
528: 1038
529: 1039
530: 1040
531: 1041
532: 1042
533: 1043
534: 1044
535: 1045
536: 1046
537: 1047
538: 1048
539: 1049
540: 1050
541: 1051
542: 1052
543: 1053
544: 1054
545: 1055
546: 1056
547: 1057
548: 1058
549: 1059
550: 1060
551: 1061
552: 1062
553: 1063
554: 1064
555: 1065
556: 1066
557: 1067
558: 1068
559: 1069
560: 1070
561: 1071
562: 1072
563: 1073
564: 1074
565: 1075
566: 1076
567: 1077
568: 1078
569: 1079
570: 1080
571: 1355
572: 1082
573: 1083
574: 1084
575: 1085
576: 1086
577: 1087
578: 1088
579: 1089
580: 1090
581: 1091
582: 1092
583: 1093
584: 1094
585: 1095
586: 1096
587: 1097
588: 1098
589: 1371
590: 1100
591: 1101
592: 1102
593: 1103
594: 1104
595: 1105
596: 1108
597: 1109
598: 1110
599: 1111
600: 1112
601: 1113
602: 1114
603: 1115
604: 1116
605: 1117
606: 1118
607: 1119
608: 1120
609: 1121
610: 1122
611: 1126
612: 1127
613: 1128
614: 1129
615: 1130
616: 1131
617: 1132
618: 1133
619: 1134
620: 1135
621: 1164
622: 1165
623: 1166
624: 1167
625: 1291
626: 1169
627: 1170
628: 1171
629: 1172
630: 1173
631: 1174
632: 1175
633: 1176
634: 1177
635: 1178
636: 1179
637: 1180
638: 1181
639: 1182
640: 1183
641: 1184
642: 1185
643: 1186
644: 1187
645: 1188
646: 1189
647: 1190
648: 1191
649: 1192
650: 1193
651: 1194
652: 1195
653: 1196
654: 1197
655: 1198
656: 1199
657: 1200
658: 1201
659: 1202
660: 1203
661: 1204
662: 1205
663: 1206
664: 1207
665: 1208
666: 1209
667: 1210
668: 1211
669: 1212
670: 1213
671: 1214
672: 1215
673: 1216
674: 1217
675: 1218
676: 1219
677: 1220
678: 1221
679: 1222
680: 1223
681: 1224
682: 1225
683: 1226
684: 1227
685: 1228
686: 1229
687: 1230
688: 1231
689: 1232
690: 1233
691: 1234
692: 1235
693: 1236
694: 1359
695: 1238
696: 1239
697: 1240
698: 1241
699: 1242
700: 1243
701: 1244
702: 1245
703: 1246
704: 1247
705: 1248
706: 1249
707: 1250
708: 1251
709: 1252
710: 1253
711: 1254
712: 1255
713: 1256
714: 1257
715: 1258
716: 1259
717: 1260
718: 1261
719: 1262
720: 1263
721: 1565
722: 1265
723: 1266
724: 1267
725: 1268
726: 1269
727: 1270
728: 1272
729: 1273
730: 1274
731: 1275
732: 1276
733: 1277
734: 1278
735: 1279
736: 1280
737: 1281
738: 1282
739: 1283
740: 1284
741: 1285
742: 1286
743: 1288
744: 1289
745: 1290
746: 1292
747: 1293
748: 1294
749: 1295
750: 1296
751: 1297
752: 1298
753: 1299
754: 1300
755: 1301
756: 1304
757: 1305
758: 1306
759: 1307
760: 1308
761: 1309
762: 1310
763: 1311
764: 1312
765: 1313
766: 1314
767: 1315
768: 1316
769: 1317
770: 1318
771: 1319
772: 1323
773: 1324
774: 1509
775: 1508
776: 1327
777: 1329
778: 1330
779: 1331
780: 1332
781: 1333
782: 1474
783: 1336
784: 1337
785: 1338
786: 1339
787: 1340
788: 1341
789: 1342
790: 1343
791: 1344
792: 1345
793: 1346
794: 1347
795: 1348
796: 1350
797: 1351
798: 1357
799: 1454
800: 1360
801: 1361
802: 1362
803: 1363
804: 1364
805: 1365
806: 1399
807: 1400
808: 1402
809: 1403
810: 1406
811: 1407
812: 1412
813: 1413
814: 1416
815: 1420
816: 1421
817: 1422
818: 1423
819: 1426
820: 1427
821: 1428
822: 1429
823: 1430
824: 1431
825: 1432
826: 1433
827: 1434
828: 1436
829: 1437
830: 1438
831: 1439
832: 1441
833: 1443
834: 1445
835: 1446
836: 1447
837: 1448
838: 1449
839: 1451
840: 1452
841: 1453
842: 1455
843: 1456
844: 1458
845: 1459
846: 1460
847: 1461
848: 1462
849: 1465
850: 1466
851: 1467
852: 1468
853: 1469
854: 1470
855: 1471
856: 1472
857: 1473
858: 1477
859: 1479
860: 1480
861: 1481
862: 1482
863: 1483
864: 1488
865: 1489
866: 1490
867: 1491
868: 1492
869: 1493
870: 1494
871: 1495
872: 1496
873: 1497
874: 1498
875: 1499
876: 1501
877: 1504
878: 1505
879: 1507
880: 1510
881: 1511
882: 1518
883: 1519
884: 1521
885: 1522
886: 1523
887: 1524
888: 1525
889: 1527
890: 1529
891: 1530
892: 1531
893: 1532
894: 1533
895: 1534
896: 1535
897: 1536
898: 1537
899: 1538
900: 1539
901: 1540
902: 1541
903: 1542
904: 1543
905: 1544
906: 1545
907: 1546
908: 1547
909: 1548
910: 1549
911: 1550
912: 1551
913: 1552
914: 1553
915: 1554
916: 1555
917: 1556
918: 1557
919: 1563
920: 1568
921: 1569
922: 1570
923: 1571
924: 1572
925: 1573
926: 1574
927: 1575
928: 1576
929: 1577
930: 1578
931: 1579
932: 1580
933: 1581
934: 1582
935: 1583
936: 1584
937: 1585
938: 1586
939: 1588
940: 1589
941: 1590
942: 1591
943: 1592
944: 1599
945: 1600
946: 1601
947: 1603
948: 1604
949: 1605
950: 1606
951: 1607
952: 1608
953: 1633
954: 1613
955: 1627
956: 1628
957: Approved

Backtrace

app/Models/Visitor.php:191
view::partials.profileHeader:37
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

reviewbox.blade.php#67primodishnew640μs

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` = 582 and `m_dietry_considerations`.`deleted_at` is null

Bindings	0: 582
Backtrace	view::partials.reviewbox:67 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#151primodishnew3.19ms

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` = 462 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: 462
Backtrace	app/Models/Dish.php:151 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#151primodishnew2.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` = 462 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: 462
Backtrace	app/Models/Dish.php:151 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#97primodishnew760μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 462 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: 462 1: Approved
Backtrace	app/Models/Dish.php:97 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#97primodishnew660μs

select count(*) as aggregate from `reviews` where `reviews`.`dish_id` = 462 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: 462 1: Approved
Backtrace	app/Models/Dish.php:97 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#151primodishnew2.76ms

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` = 462 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: 462
Backtrace	app/Models/Dish.php:151 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

primodishnew420μ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
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
primodishnew2.11msselect MAX(id) AS id from `reviews` where `visitor_id` = ? and `reviews`.`deleted_at` is null group by `dish_id`
primodishnew12.97msselect `dish_id` from `reviews` where `reviews`.`visitor_id` = ? and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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
primodishnew640μsselect `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` = ? and `m_dietry_considerations`.`deleted_at` is null
primodishnew3.15msselect 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
primodishnew3.99msselect 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
primodishnew630μ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
primodishnew370μ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
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
primodishnew3.37msselect MAX(id) AS id from `reviews` where `visitor_id` = ? and `reviews`.`deleted_at` is null group by `dish_id`
primodishnew18.65msselect `dish_id` from `reviews` where `reviews`.`visitor_id` = ? and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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.71msselect `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` = ? and `m_dietry_considerations`.`deleted_at` is null
primodishnew5.39msselect 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
primodishnew4.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
primodishnew950μ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
primodishnew820μ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
primodishnew4.73msselect 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
primodishnew450μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew760μ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
primodishnew490μ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
primodishnew3.22msselect MAX(id) AS id from `reviews` where `visitor_id` = ? and `reviews`.`deleted_at` is null group by `dish_id`
primodishnew24.11msselect `dish_id` from `reviews` where `reviews`.`visitor_id` = ? and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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
primodishnew800μsselect `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` = ? and `m_dietry_considerations`.`deleted_at` is null
primodishnew5.37msselect 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
primodishnew4.98msselect 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
primodishnew970μ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
primodishnew880μ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
primodishnew4.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
primodishnew470μsselect count(*) as aggregate from `reviews` where `reviews`.`dish_id` = ? and `reviews`.`dish_id` is not null and `reviews`.`deleted_at` is null
primodishnew640μ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
primodishnew550μ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
primodishnew3.45msselect MAX(id) AS id from `reviews` where `visitor_id` = ? and `reviews`.`deleted_at` is null group by `dish_id`
primodishnew18.13msselect `dish_id` from `reviews` where `reviews`.`visitor_id` = ? and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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
primodishnew510μsselect `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` = ? and `m_dietry_considerations`.`deleted_at` is null
primodishnew3.04msselect 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.78msselect 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
primodishnew690μ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.62msselect 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
primodishnew400μ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
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
primodishnew1.97msselect MAX(id) AS id from `reviews` where `visitor_id` = ? and `reviews`.`deleted_at` is null group by `dish_id`
primodishnew12.93msselect `dish_id` from `reviews` where `reviews`.`visitor_id` = ? and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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
primodishnew480μsselect `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` = ? and `m_dietry_considerations`.`deleted_at` is null
primodishnew2.92msselect 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.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
primodishnew740μ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
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
primodishnew2.62msselect 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
primodishnew400μ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
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
primodishnew2.85msselect MAX(id) AS id from `reviews` where `visitor_id` = ? and `reviews`.`deleted_at` is null group by `dish_id`
primodishnew12.98msselect `dish_id` from `reviews` where `reviews`.`visitor_id` = ? and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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
primodishnew550μsselect `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` = ? and `m_dietry_considerations`.`deleted_at` is null
primodishnew3.07msselect 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.8msselect 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
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
primodishnew640μ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
primodishnew3.92msselect 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
primodishnew430μ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
primodishnew2.08msselect MAX(id) AS id from `reviews` where `visitor_id` = ? and `reviews`.`deleted_at` is null group by `dish_id`
primodishnew13.04msselect `dish_id` from `reviews` where `reviews`.`visitor_id` = ? and `reviews`.`visitor_id` is not 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 `deleted_at` is null and `id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 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
primodishnew490μsselect `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` = ? and `m_dietry_considerations`.`deleted_at` is null

App\Models\Review: 10582Review.php#?
App\Models\ListDish: 114ListDish.php#?
Spatie\MediaLibrary\MediaCollections\Models\Media: 22Media.php#?
App\Models\VisitorsFollowing: 16VisitorsFollowing.php#?
App\Models\Dish: 10Dish.php#?
App\Models\Establishment: 10Establishment.php#?
App\Models\MDietryConsideration: 6MDietryConsideration.php#?
App\Models\Visitor: 2Visitor.php#?
App\Models\VisitorsList: 1VisitorsList.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-07-14 19:41:34	GET	/visitors-lists/1010?page=2&sortby=age	16 97 172 10763

1 x Application (98.92%)	1.08s
1 x Preparing Response (97.89%)	1.07s
1 x Booting (1.08%)	11.83ms
1 x Routing (0.11%)	1.24ms
97 x View (0%)	0μs

Bindings	0: 145
Backtrace	app/Models/Dish.php:236 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

Bindings	0: 59
Backtrace	app/Models/Dish.php:236 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

Bindings	0: 171
Backtrace	app/Models/Dish.php:236 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

Bindings	0: 75
Backtrace	app/Models/Dish.php:236 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

Bindings	0: 136
Backtrace	app/Models/Dish.php:236 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

Bindings	0: 224
Backtrace	app/Models/Dish.php:236 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

Bindings	0: 242
Backtrace	app/Models/Dish.php:236 app/Models/Review.php:154 vendor/laravel/framework/src/Illuminate/Pagination/LengthAwarePaginator.php:196

Dish Name

Dish Name

Fritz

Austin, TX Favorites 🤘

Creamy Jalapeño

Creamy Jalapeño

Chuy's

Fritz

White Rabbit Taiyaki Sundae

White Rabbit Taiyaki Sundae

OMG Squee

Fritz

Salted Caramel Cheese Tea Mochi Donut

Salted Caramel Cheese Tea Mochi Donut

OMG Squee

Fritz

Carrot Cake

Carrot Cake

Quack's 43rd Street Bakery

Fritz

Espresso Crème Brûlée

Espresso Crème Brûlée

Ka-Prow Thai and Sushi Bistro

Fritz

Macaroni Creamy Sausage & Mushrooms

Macaroni Creamy Sausage & Mushrooms

ARTIPASTA Italian Food

Fritz

Parmesan Truffle Fries

Parmesan Truffle Fries

Lil'Doddy Burger Lab

Fritz

Caesar Salad

Caesar Salad

Carrabba's Italian Grill

Fritz

Chicken Bryan

Chicken Bryan

Carrabba's Italian Grill

Fritz

Saigon Noodles

Saigon Noodles

Ka-Prow Thai and Sushi Bistro

Fritz