Welcome To Meahbazar ltd Home

Messages17 Timeline Exceptions Views257 Route Queries628 Models5457 Mails Gate Session Request

Request history8.2.271.84s82MBGET /

warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[07:56:12] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[07:56:12] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[07:56:12] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[07:56:12] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[07:56:12] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...

Booting (539ms)time
Application (1.3s)time
1 x Application (70.65%)
1.30s
1 x Booting (29.35%)
539ms

257 templates were rendered

1x web-views.homehome.blade.php#?blade
1x web-views.partials._home-top-slider_home-top-slider.blade.php#?blade
1x web-views.partials._vendor-category-section-home_vendor-category-section-home.blade.php#?blade
1x web-views.partials._category-section-home_category-section-home.blade.php#?blade
1x web-views.partials._flash-deal_flash-deal.blade.php#?blade
15x web-views.partials._feature-product_feature-product.blade.php#?blade
3x web-views.partials._product-card-1_product-card-1.blade.php#?blade
1x web-views.partials._top-sellers_top-sellers.blade.php#?blade
1x web-views.partials._deal-of-the-day_deal-of-the-day.blade.php#?blade
8x web-views.partials._inline-single-product_inline-single-product.blade.php#?blade
8x web-views.partials._product-card-2_product-card-2.blade.php#?blade
1x web-views.partials._best-selling_best-selling.blade.php#?blade
1x web-views.partials._top-rated_top-rated.blade.php#?blade
1x web-views.partials._brand-section-home_brand-section-home.blade.php#?blade
23x web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
178x web-views.partials._category-single-product_category-single-product.blade.php#?blade
1x web-views.partials._company-reliability_company-reliability.blade.php#?blade
1x layouts.front-end.appapp.blade.php#?blade
1x web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
1x layouts.front-end.partials._modals_modals.blade.php#?blade
1x layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
1x layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
1x layouts.front-end.partials._header_header.blade.php#?blade
1x layouts.front-end.partials._cart_cart.blade.php#?blade
1x layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
1x layouts.front-end.partials._footer_footer.blade.php#?blade
1x layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
1x layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade

uri: GET /
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\HomeController@index
namespace: App\Http\Controllers\Web
prefix
where
as: home
file: app/Http/Controllers/Web/HomeController.php:50-59

628 statements were executed, 271 of which were duplicates, 357 unique. Show only duplicated398ms

# Query soft and hard limit for Debugbar are reached. Only the first 100 queries show details. Queries after the first 500 are ignored. Limits can be raised in the config (debugbar.options.db.soft/hard_limit).

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.223.21.202', '2025-04-03 07:56:11', '2025-04-03 07:56:11')

320μsu544682054_meahbazarGuestMiddleware.php#24

Bindings	0: 18.223.21.202 1: 2025-04-03 07:56:11 2: 2025-04-03 07:56:11
Backtrace	21. middleware::guestCheck:24 22. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 23. middleware::maintenance_mode:30 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 25. middleware::api_lang:22

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` = 0

21.77msu544682054_meahbazarcategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 0
Backtrace	15. app/Utils/category-manager.php:86 16. app/Http/Controllers/Web/HomeController.php:63 17. app/Http/Controllers/Web/HomeController.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 36, 37, 38, 56, 57, 62, 66, 68, 120, 135, 138, 149, 155, 185, 187, 212, 213, 221) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')

32.53msu544682054_meahbazarcategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	20. app/Utils/category-manager.php:86 21. app/Http/Controllers/Web/HomeController.php:63 22. app/Http/Controllers/Web/HomeController.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 114, 116, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 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, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 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, 796, 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, 822, 823, 824, 825, 826, 827, 828, 829, 830, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 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, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1089, 1090, 1091, 1093, 1094, 1095, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1179, 1181, 1182, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1197, 1198, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1506, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

1.99msu544682054_meahbazarcategory-manager.php#86

Bindings	0: App\Models\Product 1: en
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:63 27. app/Http/Controllers/Web/HomeController.php:54 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `reviews` where `reviews`.`product_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 114, 116, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 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, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 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, 796, 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, 822, 823, 824, 825, 826, 827, 828, 829, 830, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 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, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1089, 1090, 1091, 1093, 1094, 1095, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1179, 1181, 1182, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1197, 1198, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1506, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `delivery_man_id` is null and `status` = 1

1.07msu544682054_meahbazarcategory-manager.php#86

Bindings	0: 1
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:63 27. app/Http/Controllers/Web/HomeController.php:54 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 36, 37, 38, 56, 57, 62, 66, 68, 120, 135, 138, 149, 155, 185, 187, 212, 213, 221) and `position` = 1 order by `priority` asc

92.83msu544682054_meahbazarcategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	20. app/Utils/category-manager.php:86 21. app/Http/Controllers/Web/HomeController.php:63 22. app/Http/Controllers/Web/HomeController.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (14, 15, 16, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 58, 63, 64, 65, 67, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 82, 83, 84, 85, 86, 87, 89, 91, 93, 94, 96, 97, 98, 99, 100, 102, 103, 108, 109, 110, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 136, 137, 139, 141, 142, 143, 145, 146, 147, 148, 153, 154, 156, 159, 160, 161, 172, 173, 174, 175, 177, 178, 179, 180, 181, 182, 183, 186, 188, 189, 190, 191, 195, 196, 197, 198, 199, 200, 201, 202, 203, 205, 206, 207, 208, 209, 210, 211, 214, 215, 216, 217, 222, 223, 224) and `position` = 2 order by `priority` asc

8.83msu544682054_meahbazarcategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 2
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:63 27. app/Http/Controllers/Web/HomeController.php:54 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (32, 33, 35, 157, 158, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 184, 204, 218, 219, 220) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

320μsu544682054_meahbazarcategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	30. app/Utils/category-manager.php:86 31. app/Http/Controllers/Web/HomeController.php:63 32. app/Http/Controllers/Web/HomeController.php:54 33. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 34. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (14, 15, 16, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 58, 63, 64, 65, 67, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 82, 83, 84, 85, 86, 87, 89, 91, 93, 94, 96, 97, 98, 99, 100, 102, 103, 108, 109, 110, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 136, 137, 139, 141, 142, 143, 145, 146, 147, 148, 153, 154, 156, 159, 160, 161, 172, 173, 174, 175, 177, 178, 179, 180, 181, 182, 183, 186, 188, 189, 190, 191, 195, 196, 197, 198, 199, 200, 201, 202, 203, 205, 206, 207, 208, 209, 210, 211, 214, 215, 216, 217, 222, 223, 224) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

400μsu544682054_meahbazarcategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:63 27. app/Http/Controllers/Web/HomeController.php:54 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 36, 37, 38, 56, 57, 62, 66, 68, 120, 135, 138, 149, 155, 185, 187, 212, 213, 221) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

200μsu544682054_meahbazarcategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	20. app/Utils/category-manager.php:86 21. app/Http/Controllers/Web/HomeController.php:63 22. app/Http/Controllers/Web/HomeController.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'category_list_priority') limit 1

160μsu544682054_meahbazarsettings.php#15

Bindings	0: category_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Utils/category-manager.php:86 19. app/Http/Controllers/Web/HomeController.php:63 20. app/Http/Controllers/Web/HomeController.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `flash_deals`.*, (select count(*) from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id`) as `products_count` from `flash_deals` where (`deal_type` = 'flash_deal' and `status` = 1) and date(`start_date`) <= '2025-04-03' and date(`end_date`) >= '2025-04-03' limit 1

290μsu544682054_meahbazarproduct-manager.php#1472

Bindings	0: flash_deal 1: 1 2: 2025-04-03 3: 2025-04-03
Backtrace	16. app/Utils/product-manager.php:1472 17. app/Http/Controllers/Web/HomeController.php:65 18. app/Http/Controllers/Web/HomeController.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (3) and `translations`.`translationable_type` = 'App\Models\FlashDeal' and `locale` = 'en'

220μsu544682054_meahbazarproduct-manager.php#1472

Bindings	0: App\Models\FlashDeal 1: en
Backtrace	21. app/Utils/product-manager.php:1472 22. app/Http/Controllers/Web/HomeController.php:65 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'flash_deal_priority') limit 1

200μsu544682054_meahbazarsettings.php#15

Bindings	0: flash_deal_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Utils/product-manager.php:1475 19. app/Http/Controllers/Web/HomeController.php:65 20. app/Http/Controllers/Web/HomeController.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and exists (select * from `flash_deal_products` where `products`.`id` = `flash_deal_products`.`product_id` and exists (select * from `flash_deals` where `flash_deal_products`.`flash_deal_id` = `flash_deals`.`id` and `id` = 3 and (`deal_type` = 'flash_deal' and `status` = 1)))

790μsu544682054_meahbazarproduct-manager.php#1542

Bindings	0: 1 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: digital 8: physical 9: 3 10: flash_deal 11: 1
Backtrace	15. app/Utils/product-manager.php:1542 16. app/Utils/product-manager.php:1475 17. app/Http/Controllers/Web/HomeController.php:65 18. app/Http/Controllers/Web/HomeController.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `sellers` where `sellers`.`id` in (4)

140μsu544682054_meahbazarproduct-manager.php#1542

Backtrace

20. app/Utils/product-manager.php:1542
21. app/Utils/product-manager.php:1475
22. app/Http/Controllers/Web/HomeController.php:65
23. app/Http/Controllers/Web/HomeController.php:54
24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (1481, 1483, 1523) and `status` = 1 group by `product_id`

160μsu544682054_meahbazarproduct-manager.php#1542

Bindings	0: 1
Backtrace	20. app/Utils/product-manager.php:1542 21. app/Utils/product-manager.php:1475 22. app/Http/Controllers/Web/HomeController.php:65 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (1481, 1483, 1523) and `delivery_man_id` is null and `status` = 1

150μsu544682054_meahbazarproduct-manager.php#1542

Bindings	0: 1
Backtrace	20. app/Utils/product-manager.php:1542 21. app/Utils/product-manager.php:1475 22. app/Http/Controllers/Web/HomeController.php:65 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `wishlists` where `wishlists`.`product_id` in (1481, 1483, 1523) and `customer_id` = 0

110μsu544682054_meahbazarproduct-manager.php#1542

Bindings	0: 0
Backtrace	20. app/Utils/product-manager.php:1542 21. app/Utils/product-manager.php:1475 22. app/Http/Controllers/Web/HomeController.php:65 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `product_compares` where `product_compares`.`product_id` in (1481, 1483, 1523) and `user_id` = 0

120μsu544682054_meahbazarproduct-manager.php#1542

Bindings	0: 0
Backtrace	20. app/Utils/product-manager.php:1542 21. app/Utils/product-manager.php:1475 22. app/Http/Controllers/Web/HomeController.php:65 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (1481, 1483, 1523) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

150μsu544682054_meahbazarproduct-manager.php#1542

Bindings	0: App\Models\Product 1: en
Backtrace	20. app/Utils/product-manager.php:1542 21. app/Utils/product-manager.php:1475 22. app/Http/Controllers/Web/HomeController.php:65 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where `type` = 'product_brand' limit 1

130μsu544682054_meahbazarHomeController.php#68

Bindings	0: product_brand
Backtrace	16. app/Http/Controllers/Web/HomeController.php:68 17. app/Http/Controllers/Web/HomeController.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `categories` where `home_status` = 1 order by `priority` asc

340μsu544682054_meahbazarHomeController.php#69

Bindings	0: 1
Backtrace	15. app/Http/Controllers/Web/HomeController.php:69 16. app/Http/Controllers/Web/HomeController.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 36, 37, 38, 56, 57, 62, 66, 68, 120, 138, 149) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

200μsu544682054_meahbazarHomeController.php#69

Bindings	0: App\Models\Category 1: en
Backtrace	20. app/Http/Controllers/Web/HomeController.php:69 21. app/Http/Controllers/Web/HomeController.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

230μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"1\"%'

7.02msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"1"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

320μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"12\"%'

2.35msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"12"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

200μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"2\"%'

2.23msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"2"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

240μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"37\"%'

2.19msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"37"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"37\"%' order by `order_details_count` desc limit 12 offset 0

2.8msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"37"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (1489, 1490, 1491) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

230μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (1489, 1490, 1491) and `delivery_man_id` is null and `status` = 1

160μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

200μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"62\"%'

1.94msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"62"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"62\"%' order by `order_details_count` desc limit 12 offset 0

8.32msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"62"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (256, 258, 259, 260, 261, 768, 769, 770, 771, 772, 773, 1500) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

240μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (256, 258, 259, 260, 261, 768, 769, 770, 771, 772, 773, 1500) and `delivery_man_id` is null and `status` = 1

170μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

230μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"120\"%'

2.24msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"120"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"120\"%' order by `order_details_count` desc limit 12 offset 0

3.51msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"120"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

240μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89) and `delivery_man_id` is null and `status` = 1

190μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

360μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"149\"%'

1.59msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"149"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"149\"%' order by `order_details_count` desc limit 12 offset 0

3.12msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"149"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (1431) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

240μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (1431) and `delivery_man_id` is null and `status` = 1

190μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

250μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"5\"%'

2.51msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"5"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

250μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"38\"%'

2.51msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"38"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"38\"%' order by `order_details_count` desc limit 12 offset 0

3.43msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"38"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (847, 848, 851, 855, 857, 859, 861, 864, 868, 874, 877, 879) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

260μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (847, 848, 851, 855, 857, 859, 861, 864, 868, 874, 877, 879) and `delivery_man_id` is null and `status` = 1

210μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

220μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"138\"%'

2.43msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"138"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"138\"%' order by `order_details_count` desc limit 12 offset 0

3.63msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"138"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

340μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543) and `delivery_man_id` is null and `status` = 1

150μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

190μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"3\"%'

1.62msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"3"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

180μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"68\"%'

1.52msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"68"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"68\"%' order by `order_details_count` desc limit 12 offset 0

2.85msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"68"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

210μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844) and `delivery_man_id` is null and `status` = 1

180μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

220μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"4\"%'

1.68msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"4"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"4\"%' order by `order_details_count` desc limit 12 offset 0

2.07msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"4"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (1506, 1509, 1510, 1511, 1512, 1513) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

180μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (1506, 1509, 1510, 1511, 1512, 1513) and `delivery_man_id` is null and `status` = 1

130μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

170μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"6\"%'

1.4msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"6"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"6\"%' order by `order_details_count` desc limit 12 offset 0

2.25msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"6"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (92, 94, 95, 96, 97, 102, 104, 108, 110, 1433, 1434, 1481) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

210μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (92, 94, 95, 96, 97, 102, 104, 108, 110, 1433, 1434, 1481) and `delivery_man_id` is null and `status` = 1

180μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

170μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"66\"%'

1.46msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"66"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"66\"%' order by `order_details_count` desc limit 12 offset 0

2.14msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"66"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (1497, 1503, 1504, 1505) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

250μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (1497, 1503, 1504, 1505) and `delivery_man_id` is null and `status` = 1

170μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

210μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"7\"%'

2.45msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"7"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

260μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"13\"%'

1.71msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"13"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

170μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"9\"%'

1.39msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"9"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"9\"%' order by `order_details_count` desc limit 12 offset 0

2.56msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"9"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1498, 1514) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

180μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1498, 1514) and `delivery_man_id` is null and `status` = 1

140μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

140μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"10\"%'

1.42msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"10"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"10\"%' order by `order_details_count` desc limit 12 offset 0

2.3msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"10"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

220μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335) and `delivery_man_id` is null and `status` = 1

160μsu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:75 27. app/Http/Controllers/Web/HomeController.php:70 28. app/Http/Controllers/Web/HomeController.php:54 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

170μsu544682054_meahbazarsettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:75 23. app/Http/Controllers/Web/HomeController.php:70 24. app/Http/Controllers/Web/HomeController.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"11\"%'

2.55msu544682054_meahbazarproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"11"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:75 22. app/Http/Controllers/Web/HomeController.php:70 23. app/Http/Controllers/Web/HomeController.php:54 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"11\"%' order by `order_details_count` desc limit 12 offset 0
3.08msu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (1485, 1494, 1495, 1496) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
250μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (1485, 1494, 1495, 1496) and `delivery_man_id` is null and `status` = 1
160μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
210μsu544682054_meahbazar
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"36\"%'
2.47msu544682054_meahbazar
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"36\"%' order by `order_details_count` desc limit 12 offset 0
3.78msu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1430) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
230μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1430) and `delivery_man_id` is null and `status` = 1
140μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
190μsu544682054_meahbazar
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"56\"%'
2.45msu544682054_meahbazar
select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
210μsu544682054_meahbazar
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_ids` like '%\"57\"%'
2.37msu544682054_meahbazar
select `shops`.*, (select count(*) from `products` where `shops`.`seller_id` = `products`.`user_id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'seller' and `status` = 1 and `request_status` = 1)) as `products_count` from `shops` where exists (select * from `sellers` where `shops`.`seller_id` = `sellers`.`id` and (`status` = 'approved'))
4.04msu544682054_meahbazar
select `sellers`.*, (select count(*) from `orders` where `sellers`.`id` = `orders`.`seller_id`) as `orders_count` from `sellers` where `sellers`.`id` in (14, 19, 20, 27, 28)
450μsu544682054_meahbazar
select * from `products` where (`added_by` = 'seller') and `products`.`user_id` in (14, 19, 20, 27, 28) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
13.42msu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (114, 116, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 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, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 754, 755, 756, 757, 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, 796, 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, 822, 823, 824, 825, 826, 827, 828, 829, 830, 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, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1089, 1090, 1091, 1093, 1094, 1095, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1179, 1181, 1182, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1197, 1198, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1506, 1509, 1510, 1511, 1512, 1513) and `delivery_man_id` is null and `status` = 1
690μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (114, 116, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 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, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 754, 755, 756, 757, 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, 796, 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, 822, 823, 824, 825, 826, 827, 828, 829, 830, 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, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1089, 1090, 1091, 1093, 1094, 1095, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1179, 1181, 1182, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1197, 1198, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1506, 1509, 1510, 1511, 1512, 1513) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
880μsu544682054_meahbazar
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin')
7.78msu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `delivery_man_id` is null and `status` = 1
480μsu544682054_meahbazar
select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `status` = 1 group by `product_id`
680μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
580μsu544682054_meahbazar
select count(*) as aggregate from `reviews` where `status` = 1 and `product_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `status` = 1
620μsu544682054_meahbazar
select `rating` from `reviews` where `status` = 1 and `product_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `status` = 1
590μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'vacation_add') limit 1
180μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'company_name') limit 1
120μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'shop_address') limit 1
160μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'company_phone') limit 1
130μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'company_fav_icon') limit 1
150μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'bottom_banner') limit 1
180μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'offer_banner') limit 1
290μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'temporary_close') limit 1
170μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'temporary_close') limit 1
230μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'shop_banner') limit 1
170μsu544682054_meahbazar
select * from `admins` where (`id` = 1) limit 1
190μsu544682054_meahbazar
select * from `admins` where (`id` = 1) limit 1
190μsu544682054_meahbazar
select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (41, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 102, 104, 108, 109, 110, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 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, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1224, 1225, 1226, 1227, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1240, 1242, 1243, 1244, 1245, 1246, 1247, 1251, 1253, 1254, 1256, 1257, 1258, 1264, 1265, 1266, 1267, 1268, 1269, 1272, 1274, 1275, 1276, 1277, 1278, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1304, 1305, 1306, 1307, 1308, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1446, 1448, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1502, 1503, 1504, 1505, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `status` = 1
660μsu544682054_meahbazar
select count(*) as aggregate from `orders` where (`seller_is` = 'admin')
170μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'top_vendor_list_priority') limit 1
220μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'featured_product_priority') limit 1
170μsu544682054_meahbazar
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`featured` = 1)
1.54msu544682054_meahbazar
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`featured` = 1) order by `id` desc limit 12 offset 0
880μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
180μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `delivery_man_id` is null and `status` = 1
180μsu544682054_meahbazar
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') order by `id` desc limit 8
420μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `delivery_man_id` is null and `status` = 1
170μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
180μsu544682054_meahbazar
select * from `business_settings` where (`type` = 'new_arrival_product_list_priority') limit 1
200μsu544682054_meahbazar
select count(*) as aggregate from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
1.34msu544682054_meahbazar
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') order by `order_details_count` desc limit 8 offset 0
12.42msu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (256, 512, 768, 1430, 1481, 1498, 1500, 1514) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
260μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (256, 512, 768, 1430, 1481, 1498, 1500, 1514) and `delivery_man_id` is null and `status` = 1
170μsu544682054_meahbazar
select * from `brands` where `status` = 1 limit 32
230μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
200μsu544682054_meahbazar
select * from `vendor_categories` where `status` = 1 limit 32
250μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (7, 8, 9, 10, 11, 12, 13, 16, 17, 18, 19, 20, 24, 25, 26, 28) and `translations`.`translationable_type` = 'App\Models\VendorCategory' and `locale` = 'en'
160μsu544682054_meahbazar
select `product_id`, COUNT(product_id) as count from `order_details` where exists (select * from `products` where `order_details`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) group by `product_id` order by `count` desc limit 6
360μsu544682054_meahbazar
select * from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` = 'App\Models\OrderDetail'
510μsu544682054_meahbazar
select * from `products` where `status` = 1 and `products`.`id` in (1430, 1481, 1498, 1500, 1514)
410μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (1430, 1481, 1498, 1500, 1514) and `delivery_man_id` is null and `status` = 1
130μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (1430, 1481, 1498, 1500, 1514) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
180μsu544682054_meahbazar
select `product_id`, AVG(rating) as count from `reviews` where exists (select * from `products` where `reviews`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) and `status` = 1 group by `product_id` order by `count` desc limit 6
300μsu544682054_meahbazar
select * from `products` where `products`.`id` in (1498)
230μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (1498) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
130μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (1498) and `delivery_man_id` is null and `status` = 1
110μsu544682054_meahbazar
select `deal_of_the_days`.*, `products`.`unit_price` from `deal_of_the_days` inner join `products` on `products`.`id` = `deal_of_the_days`.`product_id` where `products`.`status` = 1 and `deal_of_the_days`.`status` = 1 limit 1
210μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (4) and `translations`.`translationable_type` = 'App\Models\DealOfTheDay' and `locale` = 'en'
160μsu544682054_meahbazar
select * from `banners` where (`banner_type` = 'Main Banner' and `theme` = 'default' and `published` = 1) order by `created_at` desc
180μsu544682054_meahbazar
select * from `banners` where (`banner_type` = 'Main Section Banner' and `theme` = 'default' and `published` = 1) order by `id` desc, `created_at` desc limit 1
150μsu544682054_meahbazar
select * from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') order by RAND() limit 1
18.82msu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (240) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
180μsu544682054_meahbazar
select * from `reviews` where `reviews`.`product_id` in (240) and `delivery_man_id` is null and `status` = 1
120μsu544682054_meahbazar
select * from `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc
160μsu544682054_meahbazar
select * from `categories`
610μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 32, 33, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 56, 57, 58, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 82, 83, 84, 85, 86, 87, 89, 91, 93, 94, 96, 97, 98, 99, 100, 102, 103, 108, 109, 110, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 141, 142, 143, 145, 146, 147, 148, 149, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
530μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 1 and `categories`.`parent_id` is not null order by `priority` asc
280μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (28, 29, 70) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 29 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 70 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 28 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 2 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (14, 26, 27) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 14 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 26 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 27 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (32, 33) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 3 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (25, 65, 110) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 110 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 65 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 25 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 4 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (24, 83, 84, 85, 206, 207, 208, 209) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 83 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 84 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 85 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 207 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 208 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 209 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 24 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 206 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 5 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (80, 86, 190) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 86 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 190 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 80 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 6 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (22, 23, 79, 87, 121, 122, 191, 195, 199, 202, 203) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 121 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 122 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 191 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 195 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 199 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 202 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (204) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 203 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 79 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 87 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 22 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 23 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 7 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (20, 21, 108) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 108 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 20 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 21 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 9 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (19, 49, 50, 51, 52, 53, 54, 74, 75, 76, 77, 78, 175) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 49 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 77 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 175 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 50 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 51 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 74 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 52 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 75 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 19 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (35) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 53 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 54 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 76 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 78 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 10 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (64, 89, 91, 112, 177, 178, 179, 180, 181, 182, 183) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 89 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 91 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 112 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 177 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (184) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 178 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 179 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 180 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 181 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 182 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 183 and `categories`.`parent_id` is not null order by `priority` asc
230μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 64 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 11 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (16, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 67, 71, 72, 73, 100, 172) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 39 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 16 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 40 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 72 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 100 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 172 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 41 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 73 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 42 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 71 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 43 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 67 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 44 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 45 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 46 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 47 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 48 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 12 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (15, 102, 103) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 15 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 102 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 103 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 13 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (118) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 118 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 14 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 15 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 16 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 19 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (35) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 35 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 20 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 21 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 22 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 23 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 24 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 25 and `categories`.`parent_id` is not null order by `priority` asc
200μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 26 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 27 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (32, 33) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 32 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 33 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 28 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 29 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 32 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 33 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 35 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 36 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (159, 160, 161) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 159 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (162, 165, 166, 168, 171) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 160 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 161 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 37 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (82, 93, 94, 97, 98, 99, 113, 205) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 99 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 113 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 93 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 94 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 97 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 98 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 205 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 82 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 38 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 39 and `categories`.`parent_id` is not null order by `priority` asc
940μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 40 and `categories`.`parent_id` is not null order by `priority` asc
370μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 41 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 42 and `categories`.`parent_id` is not null order by `priority` asc
100μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 43 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 44 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 45 and `categories`.`parent_id` is not null order by `priority` asc
240μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 46 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 47 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 48 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 49 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 50 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 51 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 52 and `categories`.`parent_id` is not null order by `priority` asc
100μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 53 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 54 and `categories`.`parent_id` is not null order by `priority` asc
100μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 56 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (109, 173, 174) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 109 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 174 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 173 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 57 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (58, 114, 115, 116, 117, 119) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 116 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 119 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 58 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 115 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 117 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 114 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 58 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 62 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (63, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 63 and `categories`.`parent_id` is not null order by `priority` asc
130μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 123 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 133 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 134 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 124 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 125 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 126 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 127 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 128 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 129 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 130 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 131 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 132 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 63 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 64 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 65 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 66 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 67 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 68 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (69, 96, 145, 146, 147, 148, 153, 154) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 69 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 96 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 153 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 146 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 147 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 154 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 148 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 145 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 69 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 70 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 71 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 72 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 73 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 74 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 75 and `categories`.`parent_id` is not null order by `priority` asc
120μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 76 and `categories`.`parent_id` is not null order by `priority` asc
110μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 77 and `categories`.`parent_id` is not null order by `priority` asc
230μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 78 and `categories`.`parent_id` is not null order by `priority` asc
200μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 79 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 80 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 82 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 83 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 84 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 85 and `categories`.`parent_id` is not null order by `priority` asc
230μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 86 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 87 and `categories`.`parent_id` is not null order by `priority` asc
240μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 89 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 91 and `categories`.`parent_id` is not null order by `priority` asc
240μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 93 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 94 and `categories`.`parent_id` is not null order by `priority` asc
250μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 96 and `categories`.`parent_id` is not null order by `priority` asc
200μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 97 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 98 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 99 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 100 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 102 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 103 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 108 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 109 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 110 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 112 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 113 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 114 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 115 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 116 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 117 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 118 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 119 and `categories`.`parent_id` is not null order by `priority` asc
250μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 120 and `categories`.`parent_id` is not null order by `priority` asc
310μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (196, 197, 198, 200) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
240μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 196 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 197 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 198 and `categories`.`parent_id` is not null order by `priority` asc
520μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 200 and `categories`.`parent_id` is not null order by `priority` asc
250μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 121 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 122 and `categories`.`parent_id` is not null order by `priority` asc
250μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 123 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 124 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 125 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 126 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 127 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 128 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 129 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 130 and `categories`.`parent_id` is not null order by `priority` asc
240μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 131 and `categories`.`parent_id` is not null order by `priority` asc
200μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 132 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 133 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 134 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 135 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (136, 137) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
270μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 136 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 137 and `categories`.`parent_id` is not null order by `priority` asc
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 136 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 137 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 138 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (139, 141, 142, 143) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 141 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 139 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 143 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 142 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 139 and `categories`.`parent_id` is not null order by `priority` asc
140μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 141 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 142 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 143 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 145 and `categories`.`parent_id` is not null order by `priority` asc
160μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 146 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 147 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 148 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 149 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (189, 210, 211) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 189 and `categories`.`parent_id` is not null order by `priority` asc
200μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 210 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 211 and `categories`.`parent_id` is not null order by `priority` asc
200μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 153 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 154 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 155 and `categories`.`parent_id` is not null order by `priority` asc
150μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (156, 201) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 201 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 156 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (157, 158, 163, 164, 167, 169, 170) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
230μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 156 and `categories`.`parent_id` is not null order by `priority` asc
430μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (157, 158, 163, 164, 167, 169, 170) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
240μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 167 and `categories`.`parent_id` is not null order by `priority` asc
250μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 157 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 158 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 164 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 169 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 163 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 170 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 157 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 158 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 159 and `categories`.`parent_id` is not null order by `priority` asc
220μsu544682054_meahbazar
select * from `translations` where `translations`.`translationable_id` in (162, 165, 166, 168, 171) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
210μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 162 and `categories`.`parent_id` is not null order by `priority` asc
200μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 165 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 166 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 168 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 171 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 160 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 161 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 162 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 163 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 164 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 165 and `categories`.`parent_id` is not null order by `priority` asc
170μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 166 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 167 and `categories`.`parent_id` is not null order by `priority` asc
190μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 168 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
select * from `categories` where `categories`.`parent_id` = 169 and `categories`.`parent_id` is not null order by `priority` asc
180μsu544682054_meahbazar
... 128 additional queries are executed but now shown because of Debugbar query limits. Limits can be raised in the config (debugbar.options.db.soft/hard_limit)

App\Models\Product: 4442Product.php#?
App\Models\Category: 789Category.php#?
App\Models\Brand: 108Brand.php#?
App\Models\BusinessSetting: 59BusinessSetting.php#?
App\Models\VendorCategory: 16VendorCategory.php#?
App\Models\Review: 10Review.php#?
App\Models\Storage: 7Storage.php#?
App\Models\Banner: 6Banner.php#?
App\Models\Shop: 5Shop.php#?
App\Models\Seller: 5Seller.php#?
App\Models\OrderDetail: 5OrderDetail.php#?
App\Models\FlashDeal: 2FlashDeal.php#?
App\Models\Admin: 2Admin.php#?
App\Models\DealOfTheDay: 1DealOfTheDay.php#?

local: en
direction: ltr
system_default_currency_info: App\Models\Currency {#4307 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: BDT
currency_symbol: ৳
currency_exchange_rate: 84
usd: 1
_token: IppKCYMA5WuFO4dDx2B6ESWYJZ0Lq987jGejodZZ
guest_id: 22209
_previous: array:1 [ "url" => "https://meahbazar.com" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:22 [▼
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "accept-encoding" => array:1 [▶
    0 => "br"
  ]
  "host" => array:1 [▶
    0 => "meahbazar.com"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.223.21.202"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.223.21.202"
  ]
  "x-real-port" => array:1 [▶
    0 => "20643"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "443"
  ]
  "x-port" => array:1 [▶
    0 => "443"
  ]
  "x-lscache" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 03 Apr 2025 01:56:11 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlM2Umx4YkpOdndzUEhmTlV5VTBTOFE9PSIsInZhbHVlIjoic21vOG9VNk9GTXMyUEdUNUZhQXFIZytzYnZuMHNhcWRJWjJ2MFpteGpTREI2cnNoNEhZOVJKTm5GUWlzZXdLeVZBOWQ1eC9aaVI4MkhSaXVmdTJlcGV6QU5wMmtQTjdOTkZ3Ry80NUIrZ1hHcEtnak5NV0JXNFhWSERNL0lBSmEiLCJtYWMiOiI3ZTM4ZWQ4MjA4ZTQzMDM5ZDZmN2M2NGM3MWMzZjU1ODQ4YjdjNGVhNTI1ZTRkOGIxOWNjYzY1MjhmMTI3MzE1IiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 02:56:12 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IlM2Umx4YkpOdndzUEhmTlV5VTBTOFE9PSIsInZhbHVlIjoic21vOG9VNk9GTXMyUEdUNUZhQXFIZytzYnZuMHNhcWRJWjJ2MFpteGpTREI2cnNoNEhZOVJKTm5GUWlzZXdLeVZBOWQ1e ▶"
    1 => "6valley1728745193_session=eyJpdiI6IlRBeFlaU01GQlR4N2ZueGpRMWJsYlE9PSIsInZhbHVlIjoiYklwblc1K1ZGU2JoQWY0NHh4U2VQaU1JMzBFcnZBZXFSa3IvRldiNmdlVE9XMzRHaERNRGptSXRFVUNsRTRmRjVidnNLRnRJZTN6bUNmd2dYekxtZHA3RXRIVFIrKzh6eEd1YXZRaGlVZ0EwQUVaYmRpN2x3SkxmcDBCWXEwM0giLCJtYWMiOiI0OTAzYzUzOWQ1Y2ZhMTZkZTA5MDkyODI4NjE5NDc4M2NlZjYwOWUyYmI5OGIzMjI2ODRiZjVmZWQwYzEwMDZlIiwidGFnIjoiIn0%3D; expires=Thu, 03 Apr 2025 02:56:12 GMT; Max-Age=3600; path=/; httponly ◀6valley1728745193_session=eyJpdiI6IlRBeFlaU01GQlR4N2ZueGpRMWJsYlE9PSIsInZhbHVlIjoiYklwblc1K1ZGU2JoQWY0NHh4U2VQaU1JMzBFcnZBZXFSa3IvRldiNmdlVE9XMzRHaERNRGptSXRFVU ▶"
    2 => "popup_banner=eyJpdiI6IlliY0JwREdNbFdidGJQVjVQREtwYUE9PSIsInZhbHVlIjoiR1ZMTmxEODVXVncwVGZodlFHZ2hnNEYrclJnbnZiaVVVeldzRHltMjlCQzlRVEZPMFBIR1VNTVgvKzdVNmNlYyIsIm1hYyI6IjYzZjk3YTg4NDRmNDAwOWRmM2E0MWNiYjhlYTg1YjM3MzY0MjQ2ODhmZWI2OTNiNDExNGE2ZDQzYWUwYmVlMDMiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 03 Apr 2025 01:57:12 GMT; Max-Age=60; path=/; httponly ◀popup_banner=eyJpdiI6IlliY0JwREdNbFdidGJQVjVQREtwYUE9PSIsInZhbHVlIjoiR1ZMTmxEODVXVncwVGZodlFHZ2hnNEYrclJnbnZiaVVVeldzRHltMjlCQzlRVEZPMFBIR1VNTVgvKzdVNmNlYyIsIm1 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlM2Umx4YkpOdndzUEhmTlV5VTBTOFE9PSIsInZhbHVlIjoic21vOG9VNk9GTXMyUEdUNUZhQXFIZytzYnZuMHNhcWRJWjJ2MFpteGpTREI2cnNoNEhZOVJKTm5GUWlzZXdLeVZBOWQ1eC9aaVI4MkhSaXVmdTJlcGV6QU5wMmtQTjdOTkZ3Ry80NUIrZ1hHcEtnak5NV0JXNFhWSERNL0lBSmEiLCJtYWMiOiI3ZTM4ZWQ4MjA4ZTQzMDM5ZDZmN2M2NGM3MWMzZjU1ODQ4YjdjNGVhNTI1ZTRkOGIxOWNjYzY1MjhmMTI3MzE1IiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 02:56:12 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlM2Umx4YkpOdndzUEhmTlV5VTBTOFE9PSIsInZhbHVlIjoic21vOG9VNk9GTXMyUEdUNUZhQXFIZytzYnZuMHNhcWRJWjJ2MFpteGpTREI2cnNoNEhZOVJKTm5GUWlzZXdLeVZBOWQ1e ▶"
    1 => "6valley1728745193_session=eyJpdiI6IlRBeFlaU01GQlR4N2ZueGpRMWJsYlE9PSIsInZhbHVlIjoiYklwblc1K1ZGU2JoQWY0NHh4U2VQaU1JMzBFcnZBZXFSa3IvRldiNmdlVE9XMzRHaERNRGptSXRFVUNsRTRmRjVidnNLRnRJZTN6bUNmd2dYekxtZHA3RXRIVFIrKzh6eEd1YXZRaGlVZ0EwQUVaYmRpN2x3SkxmcDBCWXEwM0giLCJtYWMiOiI0OTAzYzUzOWQ1Y2ZhMTZkZTA5MDkyODI4NjE5NDc4M2NlZjYwOWUyYmI5OGIzMjI2ODRiZjVmZWQwYzEwMDZlIiwidGFnIjoiIn0%3D; expires=Thu, 03-Apr-2025 02:56:12 GMT; path=/; httponly ◀6valley1728745193_session=eyJpdiI6IlRBeFlaU01GQlR4N2ZueGpRMWJsYlE9PSIsInZhbHVlIjoiYklwblc1K1ZGU2JoQWY0NHh4U2VQaU1JMzBFcnZBZXFSa3IvRldiNmdlVE9XMzRHaERNRGptSXRFVU ▶"
    2 => "popup_banner=eyJpdiI6IlliY0JwREdNbFdidGJQVjVQREtwYUE9PSIsInZhbHVlIjoiR1ZMTmxEODVXVncwVGZodlFHZ2hnNEYrclJnbnZiaVVVeldzRHltMjlCQzlRVEZPMFBIR1VNTVgvKzdVNmNlYyIsIm1hYyI6IjYzZjk3YTg4NDRmNDAwOWRmM2E0MWNiYjhlYTg1YjM3MzY0MjQ2ODhmZWI2OTNiNDExNGE2ZDQzYWUwYmVlMDMiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 03-Apr-2025 01:57:12 GMT; path=/; httponly ◀popup_banner=eyJpdiI6IlliY0JwREdNbFdidGJQVjVQREtwYUE9PSIsInZhbHVlIjoiR1ZMTmxEODVXVncwVGZodlFHZ2hnNEYrclJnbnZiaVVVeldzRHltMjlCQzlRVEZPMFBIR1VNTVgvKzdVNmNlYyIsIm1 ▶"
  ]
]

session_attributes

  0 of 0   
array:12 [▼
  "local" => "en"
  "direction" => "ltr"
  "system_default_currency_info" => App\Models\Currency {#4307 ▶
    #connection: "mysql"
    #table: "currencies"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:8 [▶
      "id" => 2
      "name" => "BDT"
      "symbol" => "৳"
      "code" => "BDT"
      "exchange_rate" => "84"
      "status" => 1
      "created_at" => null
      "updated_at" => "2021-07-06 11:52:58"
    ]
    #original: array:8 [▶
      "id" => 2
      "name" => "BDT"
      "symbol" => "৳"
      "code" => "BDT"
      "exchange_rate" => "84"
      "status" => 1
      "created_at" => null
      "updated_at" => "2021-07-06 11:52:58"
    ]
    #changes: []
    #casts: array:4 [▶
      "id" => "integer"
      "status" => "boolean"
      "created_at" => "datetime"
      "updated_at" => "datetime"
    ]
    #classCastCache: []
    #attributeCastCache: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    +usesUniqueIds: false
    #hidden: []
    #visible: []
    #fillable: array:5 [▶
      0 => "name"
      1 => "symbol"
      2 => "code"
      3 => "exchange_rate"
      4 => "status"
    ]
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "currency_code" => "BDT"
  "currency_symbol" => "৳"
  "currency_exchange_rate" => "84"
  "usd" => 1
  "_token" => "IppKCYMA5WuFO4dDx2B6ESWYJZ0Lq987jGejodZZ"
  "guest_id" => 22209
  "_previous" => array:1 [▶
    "url" => "https://meahbazar.com"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-03 07:56:12	GET	/	17 257 628 5457

1 x Application (70.65%)	1.30s
1 x Booting (29.35%)	539ms

Shopping cart