our new go-to destination for discovering unfiltered insider insights that regular guidebooks, travel blogs, or YouTube videos don’t offer.
Now, are you ready to up level your travel experience like never before?
You most probably know me as Dooomziii, and you most likely reached here after you saw my travel content on social media. All this started 25 years ago, when I went on a quest to visit the most beautiful places on the planet. When I fall in love with a city, I go all in— I stay, I connect, and I don’t just become like a local, I become the one from whom the locals seek insights. But as much as this journey was fun, it wasn’t always smooth. I made wrong decisions, fell for scams, visited overrated places, and missed out on incredible experiences because I didn't know better—and, of course, it resulted in both time and financial losses. Personally, I found that frustrating because nobody gave me those insights.
That's why wherever I go, I make it a point to share all the genuine insider tips with you. My goal is to help you not only avoid these mistakes but also have a remarkable time—one that you not only get to enjoy but also excitedly share with everyone you know. Yet, here's the thing, as much as I'd love to, I can't personally respond to each one of you. Because you know, I can’t clone myself :-) That's why, to help you better, and in response to many of you requesting to package my knowledge in a centralized platform, here we are... introducing the Trendsetter app!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Trendsetter saved me so much time and money on my last trip to Sahel in Egypt. The insider tips were spot on!
Join unique travelers who trust Trendsetter for the best insider tips & Triendest spots
| 1 x Application (84.48%) | 303ms |
| 1 x Booting (15.52%) | 55.66ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| 60 | |
| 61 | |
| 62 | |
| 63 | |
| 64 | |
| 65 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| 60 | |
| 61 | |
| 62 | |
| 63 | |
| 64 | |
| 65 | |
| 66 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| 60 | |
| 61 | |
| 62 | |
| 63 | |
| 64 | |
| 65 | |
| 66 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| 60 | |
| 61 | |
| 62 | |
| 63 | |
| 64 | |
| 65 | |
| 66 | |
| 67 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | |
| 53 | |
| 54 | |
| 55 | |
| 56 | |
| 57 | |
| 58 | |
| 59 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
select * from `clients` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_token_currency_enable', 'token_currency', 'is_long_term_service', 'is_admin_vendor_rating', 'is_service_product_price_from_dispatch', 'is_service_price_selection', 'is_cache_enable_for_home', 'cache_reset_time_for_home', 'cache_radius_for_home')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_preferences` where `client_code` = '37447b' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `language_id`, `is_primary` from `client_languages` where `is_primary` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `languages` where `id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_currencies` inner join `currencies` as `cu` on `cu`.`id` = `client_currencies`.`currency_id` where `client_currencies`.`is_primary` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `currencies` where `id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `clients` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `countries` where `id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `clients` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_token_currency_enable', 'token_currency', 'is_long_term_service', 'is_admin_vendor_rating', 'is_service_product_price_from_dispatch', 'is_service_price_selection')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_languages` order by `is_primary` desc limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_preferences` where `id` > 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('vendor_online_status')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `show_slot` from `vendors` where `delivery` = 1 and `status` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select distinct `categories`.`id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`slug`, `categories`.`parent_id`, `cts`.`name`, `categories`.`type_id` from `categories` inner join `category_translations` as `cts` on `categories`.`id` = `cts`.`category_id` left join `vendor_categories` as `vct` on `categories`.`id` = `vct`.`category_id` left join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`type_id` in (1, 3, 4, 5, 6, 11) and (`vct`.`vendor_id` in (2, 3, 4, 5, 6) and `vct`.`status` = 1 or (`categories`.`type_id` in (4, 8))) and `categories`.`id` > '1' and `categories`.`type_id` is not null and `categories`.`type_id` != 5 and `categories`.`id` > '1' and `categories`.`is_visible` = 1 and `categories`.`is_core` = 1 and `categories`.`status` != 2 and `cts`.`language_id` = 1 and (`cts`.`language_id` = 1 or `cts`.`language_id` = 1) and `categories`.`vendor_id` is null and `categories`.`deleted_at` is null group by `categories`.`id` order by `position` asc, `categories`.`parent_id` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`ba`.`image`,
`ba`.`name`,
`ba`.`link`,
`ba`.`link_url`,
`ct`.`slug` AS `category_slug`,
`vn`.`slug` AS `vendor_slug`
FROM banners AS `ba` LEFT JOIN `categories` AS `ct` ON `ct`.`id` = `ba`.`redirect_category_id` AND `ct`.`deleted_at` IS NULL LEFT JOIN `vendors` AS `vn` ON `vn`.`id` = `ba`.`redirect_vendor_id` WHERE `ba`.`status` =1 AND `ba`.`validity_on` = 1 AND (`ba`.`start_date_time` is null or (date(`ba`.`start_date_time`) <= '2025-07-10 11:56:00' and date(`ba`.`end_date_time`) >= '2025-07-10 11:56:00')) ORDER BY `ba`.`sorting` ASC| Metadata | |
|---|---|
| Backtrace |
|
SELECT
`ba`.`image`,
`ba`.`name`,
`ba`.`link`,
`ba`.`link_url`,
`ct`.`slug` AS `category_slug`,
`vn`.`slug` AS `vendor_slug`
FROM mobile_banners AS `ba` LEFT JOIN `categories` AS `ct` ON `ct`.`id` = `ba`.`redirect_category_id` AND `ct`.`deleted_at` IS NULL LEFT JOIN `vendors` AS `vn` ON `vn`.`id` = `ba`.`redirect_vendor_id` WHERE `ba`.`status` =1 AND `ba`.`validity_on` = 1 AND (`ba`.`start_date_time` is null or (date(`ba`.`start_date_time`) <= '2025-07-10 11:56:00' and date(`ba`.`end_date_time`) >= '2025-07-10 11:56:00')) ORDER BY `ba`.`sorting` ASC| Metadata | |
|---|---|
| Backtrace |
|
select * from `cab_booking_layouts` where `is_active` = 1 and `type` = 1 and `for_no_product_found_html` = 0 order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `cab_booking_layout_transaltions` where `cab_booking_layout_transaltions`.`cab_booking_layout_id` in (1, 2, 3, 4, 5, 6, 9) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `web_styling_options` where `web_styling_id` = 1 and `is_selected` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `slug` from `cab_booking_layouts` where `type` = 1 and `is_active` = 1 order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 order by `is_primary` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `title`, `cab_booking_layout_id` from `cab_booking_layout_transaltions` where `language_id` = 1 and exists (select * from `cab_booking_layouts` where `cab_booking_layout_transaltions`.`cab_booking_layout_id` = `cab_booking_layouts`.`id` and `slug` in ('featured_products', 'vendors', 'new_products', 'on_sale', 'brands', 'best_sellers', 'recent_orders', 'banner', 'selected_products', 'trending')) and `title` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `cab_booking_layouts` where `cab_booking_layouts`.`id` in (7)| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('vendor_online_status')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `vendors` where `status` = 1 and `delivery` = 1 order by RAND()| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `home_page_labels`| Metadata | |
|---|---|
| Backtrace |
|
select * from `home_page_label_transaltions` where `home_page_label_transaltions`.`home_page_label_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)| Metadata | |
|---|---|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_languages` order by `is_primary` desc limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_preferences` where `id` > 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('vendor_online_status')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `show_slot` from `vendors` where `delivery` = 1 and `status` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select distinct `categories`.`id` from `categories` inner join `category_translations` as `cts` on `categories`.`id` = `cts`.`category_id` left join `vendor_categories` as `vct` on `categories`.`id` = `vct`.`category_id` left join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`type_id` in (1, 3, 4, 5, 6, 11) and (`vct`.`vendor_id` in (2, 3, 4, 5, 6) and `vct`.`status` = 1 or (`categories`.`type_id` in (4, 8))) and `categories`.`id` > '1' and `categories`.`type_id` is not null and `categories`.`type_id` != 5 and `categories`.`id` > '1' and `categories`.`is_visible` = 1 and `categories`.`is_core` = 1 and `categories`.`status` != 2 and `cts`.`language_id` = 1 and (`cts`.`language_id` = 1 or `cts`.`language_id` = 1) and `categories`.`vendor_id` is null and `categories`.`deleted_at` is null group by `categories`.`id` order by `position` asc, `categories`.`parent_id` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT `br`.`id`,
`br`.`image`,
`br`.`title`,
REPLACE('https://trendsetter.ae/brand/brands_id', 'brands_id', `br`.`id`) AS `redirect_url`,
(CASE WHEN `bt`.`title` IS NULL THEN `br`.`title` ELSE `bt`.`title` END) AS `translation_title`
FROM `brands` AS `br`
LEFT JOIN `brand_categories` AS `bc` on `bc`.`brand_id` = `br`.id
LEFT JOIN `brand_translations` AS `bt` ON `bt`.`brand_id` = `br`.`id` AND `bt`.`language_id` = 1
WHERE `br`.`status` !=2 AND `bc`.`category_id` in (26,27,28,29)
GROUP BY `br`.`id`| Metadata | |
|---|---|
| Backtrace |
|
SELECT `vendors`.`id`,
`vendors`.`name`,
`vendors`.`name_ar`,
`vendors`.`address`,
`vendors`.`order_pre_time`,
`vendors`.`logo`,
`vendors`.`banner`,
`vendors`.`slug`,
`vendors`.`show_slot`,
`vendors`.`admin_rating`,
`vendors`.`rating`,
`vendors`.`desc`,
`vendors`.`desc_ar`,
`vendors`.`short_desc`,
`vendors`.`closed_store_order_scheduled`,
`vendors`.`delivery_fee_minimum`,
SUM(`categories`.`Hotels`) as hotels_count,
SUM(`categories`.`Beaches`) as beaches_count,
SUM(`categories`.`WhatsNew`) as whatsnew_count,
SUM(`categories`.`FineDIning`) as finedining_count,
(
SELECT CASE WHEN COUNT(*) > 0 THEN 1 ELSE 0 END
FROM user_vendor_wishlists
WHERE user_vendor_wishlists.vendor_id = vendors.id
AND user_vendor_wishlists.user_id = ''
) AS is_wishlist,
(SELECT (CASE WHEN `promo`.`promo_type_id` = 1 THEN CONCAT(CAST(`promo`.`amount` AS DECIMAL(2,0)), '% OFF | use ', `promo`.`name`) ELSE CONCAT('FLAT ', '$', '', CAST(`promo`.`amount`* 1.00000000 AS DECIMAL(2,0)), ' OFF | use ', `promo`.`name`) END) FROM `promocodes` AS `promo` left join `promocode_details` AS `promo_info` ON `promo_info`.`promocode_id` = `promo`.`id` WHERE `promo`.`restriction_on` = 1 AND ((`promo`.`restriction_type` = 0 AND `promo_info`.`refrence_id` = `vendors`.`id`) OR (`promo`.`restriction_type` = 1 AND `promo_info`.`refrence_id` != `vendors`.`id`)) AND `promo`.`expiry_date` >= 2025-07-10 AND `promo`.`amount` > 0 ORDER BY `promo`.`amount` DESC LIMIT 1) as `promo_discount`,
(select MIN(`price`) FROM `product_variants` AS `pv` JOIN `products` AS `pr` ON `pr`.`id` = `pv`.`product_id` where `pr`.`vendor_id` = `vendors`.`id`) AS `minimum_price`,
GROUP_CONCAT(DISTINCT `category_translations`.`name` SEPARATOR ', ') AS `categoriesList`,
(SELECT count(`order_vendors`.`id`) FROM `order_vendors` WHERE `order_vendors`.`vendor_id` = `vendors`.`id`) AS `selling_count`,
(SELECT CONCAT(`vendor_slot_dates`.`start_time`, '##', `vendor_slot_dates`.`end_time`) FROM `vendor_slot_dates` WHERE `vendor_slot_dates`.`vendor_id` = `vendors`.`id` LIMIT 0,1) AS `slotdate_start_end_time`,
(SELECT CONCAT(`vendor_slots`.`start_time`, '##', `vendor_slots`.`end_time`) FROM `vendor_slots` left join `slot_days` on `vendor_slots`.`id` = `slot_days`.`slot_id` WHERE `vendor_slots`.`vendor_id` = `vendors`.`id` AND `slot_days`.`day` = 5 AND `vendor_slots`.`start_time` < CAST('11:56:00' AS time) AND `vendor_slots`.`end_time` > CAST('11:56:00' AS time) LIMIT 0,1) AS `slot_start_end_time`,
ROUND( 6371 * acos(cos(radians(30.538994400000))
* cos(radians(`vendors`.`latitude`))
* cos(radians(`vendors`.`longitude`) - radians(75.955032900000))
+ sin(radians(30.538994400000))
* sin(radians(`vendors`.`latitude`))),2
) AS `lineOfSightDistance` FROM `vendors` LEFT JOIN `vendor_categories` ON `vendor_categories`.`vendor_id`= `vendors`.`id` LEFT JOIN `categories` ON `categories`.`id`= `vendor_categories`.`category_id` LEFT JOIN `category_translations` ON `category_translations`.`category_id`= `categories`.`id` AND `category_translations`.`language_id` = 1 WHERE `vendors`.`status` = 1 AND `vendor_categories`.`status` = 1 AND `vendors`.`id` IN (5,4,6,3,2) GROUP BY `vendors`.`id` ORDER BY `lineOfSightDistance` ASC LIMIT 10| Metadata | |
|---|---|
| Backtrace |
|
select * from `vendors` where `id` in (5, 6, 4, 3, 2)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `users`.*, `user_vendor_wishlists`.`vendor_id` as `pivot_vendor_id`, `user_vendor_wishlists`.`user_id` as `pivot_user_id` from `users` inner join `user_vendor_wishlists` on `users`.`id` = `user_vendor_wishlists`.`user_id` where `user_vendor_wishlists`.`vendor_id` = 2 and `user_id` is null and `users`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 2 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Hotels` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 2 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Beaches` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 2 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `WhatsNew` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 2 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `FineDIning` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `users`.*, `user_vendor_wishlists`.`vendor_id` as `pivot_vendor_id`, `user_vendor_wishlists`.`user_id` as `pivot_user_id` from `users` inner join `user_vendor_wishlists` on `users`.`id` = `user_vendor_wishlists`.`user_id` where `user_vendor_wishlists`.`vendor_id` = 3 and `user_id` is null and `users`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 3 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Hotels` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 3 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Beaches` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 3 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `WhatsNew` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 3 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `FineDIning` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `users`.*, `user_vendor_wishlists`.`vendor_id` as `pivot_vendor_id`, `user_vendor_wishlists`.`user_id` as `pivot_user_id` from `users` inner join `user_vendor_wishlists` on `users`.`id` = `user_vendor_wishlists`.`user_id` where `user_vendor_wishlists`.`vendor_id` = 4 and `user_id` is null and `users`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 4 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Hotels` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (26) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (26) and `is_live` = 1 and `vendor_id` = 4 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 4 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Beaches` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (28) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (28) and `is_live` = 1 and `vendor_id` = 4 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 4 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `WhatsNew` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (27) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (27) and `is_live` = 1 and `vendor_id` = 4 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 4 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `FineDIning` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (29) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (29) and `is_live` = 1 and `vendor_id` = 4 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `users`.*, `user_vendor_wishlists`.`vendor_id` as `pivot_vendor_id`, `user_vendor_wishlists`.`user_id` as `pivot_user_id` from `users` inner join `user_vendor_wishlists` on `users`.`id` = `user_vendor_wishlists`.`user_id` where `user_vendor_wishlists`.`vendor_id` = 5 and `user_id` is null and `users`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 5 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Hotels` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (26) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (26) and `is_live` = 1 and `vendor_id` = 5 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 5 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Beaches` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (28) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (28) and `is_live` = 1 and `vendor_id` = 5 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 5 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `WhatsNew` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (27) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (27) and `is_live` = 1 and `vendor_id` = 5 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 5 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `FineDIning` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (29) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (29) and `is_live` = 1 and `vendor_id` = 5 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `users`.*, `user_vendor_wishlists`.`vendor_id` as `pivot_vendor_id`, `user_vendor_wishlists`.`user_id` as `pivot_user_id` from `users` inner join `user_vendor_wishlists` on `users`.`id` = `user_vendor_wishlists`.`user_id` where `user_vendor_wishlists`.`vendor_id` = 6 and `user_id` is null and `users`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 6 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Hotels` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (26) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (26) and `is_live` = 1 and `vendor_id` = 6 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 6 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `Beaches` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (28) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (28) and `is_live` = 1 and `vendor_id` = 6 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 6 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `WhatsNew` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (27) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (27) and `is_live` = 1 and `vendor_id` = 6 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `vendor_categories` where `vendor_categories`.`vendor_id` = 6 and `vendor_categories`.`vendor_id` is not null and exists (select * from `categories` where `vendor_categories`.`category_id` = `categories`.`id` and `FineDIning` = 1 and `categories`.`deleted_at` is null)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (29) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `products`.`category_id` in (29) and `is_live` = 1 and `vendor_id` = 6 and `products`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`products`.`id`
FROM
`products` LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `products`.`is_new` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `products`.is_new = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`products`.`id`
FROM
`products` LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `products`.`is_featured` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `products`.is_featured = 1 AND `products`.`id` IN (95,98,101)
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `cab_booking_layouts` where `slug` = 'banner'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `cab_booking_layout_banners` where `cab_booking_layout_banners`.`cab_booking_layout_id` in (9)| Metadata | |
|---|---|
| Backtrace |
|
select * from `web_styling_options` where `is_selected` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `web_styling_options` where `is_selected` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id` from `product_recently_viewed` where `token_id` = 'VlIzhZ26hSKyLUEgfljVfPvGLL89InlJuCxq8QQY' order by `updated_at` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id` from `product_recently_viewed` where `token_id` = 'VlIzhZ26hSKyLUEgfljVfPvGLL89InlJuCxq8QQY' order by `updated_at` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `products`.spotlight_deals = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `home_products` where `slug` = 'single_category_products' order by `created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `home_products` where `slug` = 'single_category_products' order by `created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `home_products` where `slug` = 'selected_products' order by `created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `home_products` where `slug` = 'selected_products' order by `created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select id, product_id, count(product_id) as total from `order_vendor_products` where exists (select * from `vendor_order_statuses` where `order_vendor_products`.`order_id` = `vendor_order_statuses`.`order_id` and `order_status_option_id` = 6) group by `product_id` order by `total` desc limit 5| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select id, product_id, count(product_id) as total from `product_recently_viewed` group by `product_id` order by `total` desc limit 5| Metadata | |
|---|---|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select id, product_id, count(product_id) as total from `order_vendor_products` where exists (select * from `vendor_order_statuses` where `order_vendor_products`.`order_id` = `vendor_order_statuses`.`order_id` and `order_status_option_id` = 6) group by `product_id` order by `total` desc limit 5| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select id, product_id, count(product_id) as total from `product_recently_viewed` group by `product_id` order by `total` desc limit 5| Metadata | |
|---|---|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select id, product_id, count(product_id) as total from `order_product_ratings` group by `product_id` order by `total` desc limit 10| Metadata | |
|---|---|
| Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `types` where `service_type` in ('products_service')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select id, product_id, count(product_id) as total from `order_product_ratings` group by `product_id` order by `total` desc limit 10| Metadata | |
|---|---|
| Backtrace |
|
SELECT
`products`.`id`,
`products`.`sku`,
`products`.`url_slug`,
`products`.`weight_unit`,
`products`.`weight`,
`products`.`vendor_id`,
`products`.`has_variant`,
`products`.`has_inventory`,
`products`.`sell_when_out_of_stock`,
`products`.`requires_shipping`,
`products`.`Requires_last_mile`,
`products`.`inquiry_only`,
`products`.`updated_at`,
`products`.`is_featured`,
`products`.`is_new`,
`products`.`category_id`,
`products`.`calories`,
`categories`.`id` as `category_id` ,
`categories`.`type_id`,
`product_images`.`media_id`,
`vendor_media`.`path`,
`product_translation`.`title`,
`product_translation`.`meta_title`,
`product_translation`.`meta_keyword`,
`product_translation`.`meta_description`,
`vendors`.`address`,
`product_translation`.`language_id`,
CAST(`product_variant`.`compare_at_price` * 1.00000000 AS DECIMAL(10,2)) as `compare_price_numeric`,
CAST(`product_variant`.`price` * 1.00000000 AS DECIMAL(10,2)) as `price_numeric`,
`category_translation`.`name` as `category_name` ,
`category_translation`.`meta_title` as `category_meta_title` ,
`category_translation`.`meta_keywords` as `category_meta_keyword` ,
`category_translation`.`meta_description` as `category_meta_description`,
CAST((`products`.`averageRating`) AS DECIMAL(2,1)) AS averageRating,
CASE
when `product_variant`.`compare_at_price` > 0 then CAST((`product_variant`.`compare_at_price` - `product_variant`.`price`)/`product_variant`.`compare_at_price`*100 as decimal(12,2))
else 0
end as discount_percentage,
`vendors`.`name` as `vendor_name`,
`vendors`.`id` as `vendor_id`,
`vendors`.`slug` as `vendor_slug`,
IFNULL(`products`.`is_long_term_service`, 0) AS `is_long_term_service`,
-- Retrieve product attributes as a JSON object
(
SELECT JSON_OBJECTAGG(`key_name`,
CASE
WHEN `pa`.`attribute_option_id` = `pa`.`key_value`
THEN (SELECT `title` FROM `attribute_options` WHERE `id` = `pa`.`attribute_option_id`)
ELSE `pa`.`key_value`
END
)
FROM `product_attributes` AS `pa`
WHERE `pa`.`product_id` = `products`.`id`
) AS `product_attributes`
FROM `products`
LEFT JOIN `categories` as `categories` ON `products`.`category_id` = `categories`.`id` AND `categories`.`type_id` != 7
LEFT JOIN `product_images` as `product_images` ON `product_images`.`product_id` = `products`.`id`
LEFT JOIN `vendors` as `vendors` ON `vendors`.`id` = `products`.`vendor_id` AND `vendors`.`status` = 1
LEFT JOIN `vendor_media` as `vendor_media` ON `vendor_media`.`id` = `product_images`.`media_id`
LEFT JOIN `product_translations` as `product_translation` ON `product_translation`.`product_id` = `products`.`id` AND `product_translation`.`language_id` = 1
LEFT JOIN `product_variants` as `product_variant` ON `product_variant`.`product_id` = `products`.`id`
LEFT JOIN `category_translations` as `category_translation` ON `category_translation`.`category_id` = `products`.`category_id` AND `category_translation`.`language_id` = 1
WHERE
`products`.`deleted_at` IS NULL
AND `vendors`.`status` = 1
AND `products`.`is_live` = 1
AND `vendors`.`id` IN (5,4,6,3,2)
and `categories`.`type_id` IN (1,3,4,5,6,11)
GROUP BY `products`.`id`
LIMIT 6| Metadata | |
|---|---|
| Backtrace |
|
select count(*) as aggregate from `onboard_settings` where `key_value` = 'home_page_cab_booking'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `cab_booking_layouts` where `type` = 1 and `is_active` = 1 and `for_no_product_found_html` = 0 order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `cab_booking_layout_transaltions` where `cab_booking_layout_transaltions`.`cab_booking_layout_id` in (1, 2, 3, 4, 5, 6, 9)| Metadata | |
|---|---|
| Backtrace |
|
select * from `cab_booking_layouts` where `type` = 1 and `is_active` = 1 and `for_no_product_found_html` = 1 order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures` where `label` LIKE '%vendors%' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (9) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures` where `label` LIKE '%Best Sellers%' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `web_styling_options` where `web_styling_id` = 1 and `is_selected` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('enable_pwa')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_enable_google_analytics')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('gtag_id', 'fpixel_id', 'is_service_product_price_from_dispatch', 'is_service_price_selection')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `logo`, `dark_logo` from `clients` where `id` > 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_languages` where `is_active` = 1 order by `is_primary` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 8)| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` order by `is_primary` desc| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (1, 147)| Metadata | |
|---|---|
| Backtrace |
|
select * from `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 1)) order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 3, 4, 5) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `logo` from `clients` where `id` > 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_languages` where `is_active` = 1 order by `is_primary` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 8)| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` order by `is_primary` desc| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (1, 147)| Metadata | |
|---|---|
| Backtrace |
|
select * from `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 1)) order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 3, 4, 5) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_user_pre_signup')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select `p2p_check` from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `nomenclatures` where `label` LIKE '%Search%' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (13) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures` where `label` LIKE '%Search product,\n vendor, item%' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `clients` where `id` > 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 1)) order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 3, 4, 5) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_languages` where `is_active` = 1 order by `is_primary` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 8)| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_currencies` order by `is_primary` desc| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (1, 147)| Metadata | |
|---|---|
| Backtrace |
|
select * from `payment_methods` where `is_show` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_preference_additional` where `key_name` = 'bottom_name' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 1 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 2 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 3 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 4 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 5 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `show_subscription_plan_on_signups` where `show_subscription_plan_on_signups`.`id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_map_search_perticular_country')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_service_product_price_from_dispatch', 'is_service_price_selection')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `credentials`, `test_mode` from `payment_options` where `code` = 'razorpay' and `status` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `credentials`, `test_mode` from `payment_options` where `code` = 'khalti' and `status` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('enable_pwa')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 1)) order by `order_by` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 3, 4, 5) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
0 of 0array:2 [▼ "type" => "delivery" "noTinJson" => 1 ]
0 of 0array:2 [▼ "type" => "delivery" "noTinJson" => 1 ]
0 of 0array:15 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "trendsetter.ae" ] ]
0 of 0array:42 [▼ "USER" => "www-data" "HOME" => "/var/www" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_HOST" => "trendsetter.ae" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "trendsetter.ae" "SERVER_PORT" => "443" "SERVER_ADDR" => "10.0.0.72" "REMOTE_USER" => "" "REMOTE_PORT" => "61201" "REMOTE_ADDR" => "216.73.216.250" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/var/www/html/order/trendsetter_order/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "SCRIPT_FILENAME" => "/var/www/html/order/trendsetter_order/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1752148560.0798 "REQUEST_TIME" => 1752148560 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 10 Jul 2025 11:56:00 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InZNZ3dMSEswQXY3S29mNmdhT05XeGc9PSIsInZhbHVlIjoidXZZNjFBaExxOXcvcFYxRWplSjA0SVpiZDl0aFpTOGNSeSs4VTVKR3g5b1d1bElZa0d3ZXYyZXV3aEVka2UycTdzTWNkTmR6eXc2MUV6aS9FeThaQjJQbkR1SDZNR0JXNGNIQW5ueFdvbDErU2JaTU0wbVFnMURTdHRkTDVRSCsiLCJtYWMiOiIzNDRmMWU3ZmE0M2Q4ZTE1OTc3YTI1MmVjNTc3ZDNkYWYwZGRmZmM2YzYzMGNlNjgyMDVlYzE5OTU0NzI2Y2FmIiwidGFnIjoiIn0%3D; expires=Fri, 10-Jul-2026 11:56:00 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InZNZ3dMSEswQXY3S29mNmdhT05XeGc9PSIsInZhbHVlIjoidXZZNjFBaExxOXcvcFYxRWplSjA0SVpiZDl0aFpTOGNSeSs4VTVKR3g5b1d1bElZa0d3ZXYyZXV3aEVka2UycTdzTWNkT ▶" 1 => "trendsetter_session=eyJpdiI6InNqWURaVXFuc0VzUVFJZXRMdmZvdWc9PSIsInZhbHVlIjoiRUQ3ZGJOTGp2Y0lKRGpETTRPZEs2YVFmdHl5NlNUZWIwMGs3Tm9DdWdGcTNVNGYwZkY3Zlg4aVBYeDF2aitReWNJTnpESkJKejhsL1d6a0c5OEVCdFNvdm5hMEFGM1VNTkcvN0xzYlB4S24vUU1ab1c3SUpjc0RpcEZkcUViUnoiLCJtYWMiOiI2NmY1MGY3ZjBlNzAwZWQ4YjY2ZmM4YWQyMjVjZmE4YmY2ZGE4YmZlZjgwNjY5MzU4MGNlZDQ5NWVlOGQ3MDQ1IiwidGFnIjoiIn0%3D; expires=Fri, 10-Jul-2026 11:56:00 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀trendsetter_session=eyJpdiI6InNqWURaVXFuc0VzUVFJZXRMdmZvdWc9PSIsInZhbHVlIjoiRUQ3ZGJOTGp2Y0lKRGpETTRPZEs2YVFmdHl5NlNUZWIwMGs3Tm9DdWdGcTNVNGYwZkY3Zlg4aVBYeDF2aitR ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InZNZ3dMSEswQXY3S29mNmdhT05XeGc9PSIsInZhbHVlIjoidXZZNjFBaExxOXcvcFYxRWplSjA0SVpiZDl0aFpTOGNSeSs4VTVKR3g5b1d1bElZa0d3ZXYyZXV3aEVka2UycTdzTWNkTmR6eXc2MUV6aS9FeThaQjJQbkR1SDZNR0JXNGNIQW5ueFdvbDErU2JaTU0wbVFnMURTdHRkTDVRSCsiLCJtYWMiOiIzNDRmMWU3ZmE0M2Q4ZTE1OTc3YTI1MmVjNTc3ZDNkYWYwZGRmZmM2YzYzMGNlNjgyMDVlYzE5OTU0NzI2Y2FmIiwidGFnIjoiIn0%3D; expires=Fri, 10-Jul-2026 11:56:00 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InZNZ3dMSEswQXY3S29mNmdhT05XeGc9PSIsInZhbHVlIjoidXZZNjFBaExxOXcvcFYxRWplSjA0SVpiZDl0aFpTOGNSeSs4VTVKR3g5b1d1bElZa0d3ZXYyZXV3aEVka2UycTdzTWNkT ▶" 1 => "trendsetter_session=eyJpdiI6InNqWURaVXFuc0VzUVFJZXRMdmZvdWc9PSIsInZhbHVlIjoiRUQ3ZGJOTGp2Y0lKRGpETTRPZEs2YVFmdHl5NlNUZWIwMGs3Tm9DdWdGcTNVNGYwZkY3Zlg4aVBYeDF2aitReWNJTnpESkJKejhsL1d6a0c5OEVCdFNvdm5hMEFGM1VNTkcvN0xzYlB4S24vUU1ab1c3SUpjc0RpcEZkcUViUnoiLCJtYWMiOiI2NmY1MGY3ZjBlNzAwZWQ4YjY2ZmM4YWQyMjVjZmE4YmY2ZGE4YmZlZjgwNjY5MzU4MGNlZDQ5NWVlOGQ3MDQ1IiwidGFnIjoiIn0%3D; expires=Fri, 10-Jul-2026 11:56:00 GMT; path=/; httponly ◀trendsetter_session=eyJpdiI6InNqWURaVXFuc0VzUVFJZXRMdmZvdWc9PSIsInZhbHVlIjoiRUQ3ZGJOTGp2Y0lKRGpETTRPZEs2YVFmdHl5NlNUZWIwMGs3Tm9DdWdGcTNVNGYwZkY3Zlg4aVBYeDF2aitR ▶" ] ]
0 of 0array:24 [▼ "userCode" => "37447b" "_token" => "VlIzhZ26hSKyLUEgfljVfPvGLL89InlJuCxq8QQY" "client_config" => {#4422 ▶ +"name": "trendsetter" +"email": "admin@trendsetter.com" +"phone_number": "07887898989" +"is_deleted": 0 +"is_blocked": 0 +"logo": {#4377 ▶ +"proxy_url": "https://images.royoorders.com/insecure/fill/" +"image_path": "/ce/0/plain/https://s3.us-west-2.amazonaws.com/royoorders2.0-assets/default/default_logo.png@webp" +"image_fit": "https://images.royoorders.com/insecure/fit/" +"original": "https://s3.us-west-2.amazonaws.com/royoorders2.0-assets/default/default_logo.png" +"logo_db_value": "default/default_logo.png" } +"company_name": "trendsetter" +"company_address": "CDCL Building, 28B, Sector 28, Chandigarh, India" +"status": 1 +"code": "37447b" +"database_name": "trendsetter" +"database_host": "localhost" +"database_port": "3306" +"database_username": "root" +"database_password": "adg78t82g8iio92" +"custom_domain": "trendsetter.ae" +"sub_domain": "trendsetter" } "login_user_type" => "client" "customerLanguage" => 1 "applocale" => "en" "client_primary_currency" => "USD" "customerCurrency" => 147 "currencySymbol" => "$" "currencyMultiplier" => "1.00000000" "iso_code" => "USD" "selectedAddress" => "Chandigarh, Punjab, India" "default_country_code" => "AF" "default_country_phonecode" => 93 "preferences" => App\Models\ClientPreference {#4421 ▶ #fillable: array:102 [▶ 0 => "client_code" 1 => "theme_admin" 2 => "distance_unit" 3 => "currency_id" 4 => "language_id" 5 => "date_format" 6 => "time_format" 7 => "fb_client_id" 8 => "fb_client_secret" 9 => "fb_client_url" 10 => "twitter_client_id" 11 => "twitter_client_secret" 12 => "twitter_client_url" 13 => "google_client_id" 14 => "google_client_secret" 15 => "google_client_url" 16 => "apple_client_id" 17 => "apple_client_secret" 18 => "apple_client_url" 19 => "Default_location_name" 20 => "Default_latitude" 21 => "Default_longitude" 22 => "map_provider" 23 => "map_key" 24 => "map_secret" 25 => "sms_provider" 26 => "sms_key" 27 => "sms_secret" 28 => "sms_from" 29 => "verify_email" 30 => "verify_phone" 31 => "pharmacy_check" 32 => "web_template_id" 33 => "app_template_id" 34 => "is_hyperlocal" 35 => "need_delivery_service" 36 => "dispatcher_key_1" 37 => "dispatcher_key_2" 38 => "need_dispacher_home_other_service" 39 => "dispacher_home_other_service_key" 40 => "dispacher_home_other_service_key_url" 41 => "dispacher_home_other_service_key_code" 42 => "last_mile_team" 43 => "tip_before_order" 44 => "tip_after_order" 45 => "off_scheduling_at_cart" 46 => "distance_unit_for_time" 47 => "distance_to_time_multiplier" 48 => "business_type" 49 => "need_laundry_service" 50 => "laundry_service_key" 51 => "laundry_service_key_url" 52 => "laundry_service_key_code" 53 => "laundry_pickup_team" 54 => "laundry_dropoff_team" 55 => "delay_order" 56 => "product_order_form" 57 => "sms_credentials" 58 => "is_edit_order_admin" 59 => "is_edit_order_vendor" 60 => "is_edit_order_driver" 61 => "tools_mode" 62 => "map_key_for_app" 63 => "map_key_for_ios_app" 64 => "vendor_fcm_server_key" 65 => "concise_signup" 66 => "slots_with_service_area" 67 => "is_service_area_for_banners" 68 => "stop_order_acceptance_for_users" 69 => "map_on_search_screen" 70 => "is_tax_price_inclusive" 71 => "rating_check" 72 => "dashboard_theme_color" 73 => "enquire_mode" 74 => "pharmacy_check" 75 => "isolate_single_vendor_order" 76 => "subscription_mode" 77 => "subscription_tab_taxi" 78 => "auto_implement_5_percent_tip" 79 => "gifting" 80 => "pickup_delivery_service_area" 81 => "minimum_order_batch" 82 => "static_delivey_fee" 83 => "max_safety_mod" 84 => "hide_order_address" 85 => "category_kyc_documents" 86 => "vendor_return_request" 87 => "hide_order_prepare_time" 88 => "is_cancel_order_user" 89 => "book_for_friend" 90 => "is_static_dropoff" 91 => "is_scan_qrcode_bag" 92 => "is_vendor_tags" 93 => "dinein_check" 94 => "takeaway_check" 95 => "delivery_check" 96 => "rental_check" 97 => "pick_drop_check" 98 => "on_demand_check" 99 => "laundry_check" 100 => "appointment_check" 101 => "p2p_check" ] #connection: "royo_trendsetter" #table: "client_preferences" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:197 [▶ "id" => 1 "business_type" => "food_grocery_ecommerce" "rating_check" => 0 "enquire_mode" => 0 "hide_nav_bar" => 0 "show_dark_mode" => 2 "show_payment_icons" => 0 "loyalty_check" => 0 "show_icons" => 0 "show_wishlist" => 0 "show_contact_us" => 0 "age_restriction" => 0 "age_restriction_title" => null "subscription_mode" => 0 "cart_enable" => 0 "client_code" => "37447b" "theme_admin" => "light" "distance_unit" => "metric" "currency_id" => null "language_id" => null "date_format" => "YYYY-MM-DD" "time_format" => "24" "fb_login" => 1 "fb_client_id" => "admin@trendsetter.com" "fb_client_secret" => "12345678" "fb_client_url" => null "twitter_login" => 0 "twitter_client_id" => "admin@trendsetter.com" "twitter_client_secret" => "12345678" "twitter_client_url" => null "google_login" => 1 "google_client_id" => null "google_client_secret" => null "google_client_url" => null "apple_login" => 1 "apple_client_id" => null "apple_client_secret" => null "apple_client_url" => null "Default_location_name" => "Chandigarh, Punjab, India" "Default_latitude" => "30.538994400000" "Default_longitude" => "75.955032900000" "map_provider" => 1 "map_key" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo" "map_secret" => null "sms_provider" => 1 "sms_key" => "AC6025a83ef123b62b06c5454a8b40c28b" "sms_secret" => "34748004eca0c04b23391454549d2e33" "sms_from" => "TrendSetter" "verify_email" => 0 "verify_phone" => 0 "web_template_id" => 1 "app_template_id" => 2 "personal_access_token_v1" => null "personal_access_token_v2" => null "mail_type" => "smtp" "mail_driver" => null "mail_host" => null "mail_port" => null "mail_username" => null "mail_password" => null "mail_encryption" => null "mail_from" => null "is_hyperlocal" => 0 "need_delivery_service" => 0 "need_dispacher_ride" => 0 "delivery_service_key" => null "primary_color" => "#32B5FC" "secondary_color" => "#41A2E6" "site_top_header_color" => "#4c4c4c" "dispatcher_key" => null "created_at" => null "updated_at" => "2024-10-09 11:16:32" "celebrity_check" => 0 "delivery_service_key_url" => null "delivery_service_key_code" => null "reffered_by_amount" => "0.00000000" "reffered_to_amount" => "0.00000000" "favicon" => null "web_color" => null "pharmacy_check" => 0 "dinein_check" => 0 "takeaway_check" => 0 "delivery_check" => 1 "rental_check" => 0 "car_rental_check" => 0 "pick_drop_check" => 0 "on_demand_check" => 0 "laundry_check" => 0 "appointment_check" => 0 "pickup_delivery_service_key" => null "pickup_delivery_service_key_url" => null "pickup_delivery_service_key_code" => null "need_dispacher_home_other_service" => null "dispacher_home_other_service_key" => null "dispacher_home_other_service_key_url" => null "dispacher_home_other_service_key_code" => null "last_mile_team" => null "tip_before_order" => 0 "tip_after_order" => 0 "off_scheduling_at_cart" => 0 "isolate_single_vendor_order" => 0 "fcm_server_key" => null "fcm_api_key" => null "fcm_auth_domain" => null "fcm_project_id" => null "fcm_storage_bucket" => null "fcm_messaging_sender_id" => null "fcm_app_id" => null "fcm_measurement_id" => null "distance_unit_for_time" => null "distance_to_time_multiplier" => 0 "android_app_link" => null "ios_link" => null "single_vendor" => 0 "stripe_connect" => 0 "need_laundry_service" => 0 "laundry_service_key" => null "laundry_service_key_url" => null "laundry_service_key_code" => null "laundry_pickup_team" => null "laundry_dropoff_team" => null "admin_email" => null "delay_order" => 0 "gifting" => 0 "product_order_form" => 0 "sms_credentials" => "{"sms_key": "AC6025a83ef123b62b06c5454a8b40c28b", "sms_from": "TrendSetter", "sms_secret": "34748004eca0c04b23391454549d2e33", "static_otp": 0}" "pickup_delivery_service_area" => 0 "customer_support" => null "customer_support_key" => null "customer_support_application_id" => null "shipping_mode" => 0 "minimum_order_batch" => 0 "is_edit_order_admin" => 0 "is_edit_order_vendor" => 0 "is_edit_order_driver" => 0 "static_delivey_fee" => 0 "header_quick_link" => 0 "get_estimations" => 0 "view_get_estimation_in_category" => 0 "tools_mode" => 0 "max_safety_mod" => 0 "hide_order_address" => 0 "digit_after_decimal" => 2 "is_cancel_order_user" => 1 "age_restriction_on_product_mode" => 0 "show_qr_on_footer" => 0 "auto_implement_5_percent_tip" => 0 "need_xero" => 0 "category_kyc_documents" => 0 "vendor_return_request" => 1 "db_audit_logs" => 0 "deliveryicon" => null "dineinicon" => null "takewayicon" => null "rentalicon" => null "pick_dropicon" => null "on_demandicon" => null "laundryicon" => null "p2picon" => null "appointmenticon" => null "third_party_accounting" => 0 "hide_order_prepare_time" => 0 "map_key_for_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo" "map_key_for_ios_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo" "subscription_tab_taxi" => 0 "need_inventory_service" => 0 "inventory_service_key" => null "inventory_service_key_url" => null "inventory_service_key_code" => null "enable_inventory_service" => 0 "scheduling_with_slots" => 0 "same_day_delivery_for_schedule" => 0 "same_day_orders_for_rescheduing" => 0 "book_for_friend" => 0 "order_cancellation_time" => null "cancellation_percentage" => null "estimation_matching_logic" => null "vendor_fcm_server_key" => null "sos" => 0 "sos_police_contact" => null "sos_ambulance_contact" => null "concise_signup" => 0 "is_static_dropoff" => 0 "is_scan_qrcode_bag" => 0 "slots_with_service_area" => 0 "is_vendor_tags" => 0 "is_service_area_for_banners" => 0 "stop_order_acceptance_for_users" => 0 "need_appointment_service" => null "appointment_service_key" => null "appointment_service_key_url" => null "appointment_service_key_code" => null "signup_image" => null "map_on_search_screen" => 0 "p2p_check" => 0 "dashboard_theme_color" => "#4c4c4c" "is_hourly_pickup_rental" => 0 ] #original: array:197 [▶ "id" => 1 "business_type" => "food_grocery_ecommerce" "rating_check" => 0 "enquire_mode" => 0 "hide_nav_bar" => 0 "show_dark_mode" => 2 "show_payment_icons" => 0 "loyalty_check" => 0 "show_icons" => 0 "show_wishlist" => 0 "show_contact_us" => 0 "age_restriction" => 0 "age_restriction_title" => null "subscription_mode" => 0 "cart_enable" => 0 "client_code" => "37447b" "theme_admin" => "light" "distance_unit" => "metric" "currency_id" => null "language_id" => null "date_format" => "YYYY-MM-DD" "time_format" => "24" "fb_login" => 1 "fb_client_id" => "admin@trendsetter.com" "fb_client_secret" => "12345678" "fb_client_url" => null "twitter_login" => 0 "twitter_client_id" => "admin@trendsetter.com" "twitter_client_secret" => "12345678" "twitter_client_url" => null "google_login" => 1 "google_client_id" => null "google_client_secret" => null "google_client_url" => null "apple_login" => 1 "apple_client_id" => null "apple_client_secret" => null "apple_client_url" => null "Default_location_name" => "Chandigarh, Punjab, India" "Default_latitude" => "30.538994400000" "Default_longitude" => "75.955032900000" "map_provider" => 1 "map_key" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo" "map_secret" => null "sms_provider" => 1 "sms_key" => "AC6025a83ef123b62b06c5454a8b40c28b" "sms_secret" => "34748004eca0c04b23391454549d2e33" "sms_from" => "TrendSetter" "verify_email" => 0 "verify_phone" => 0 "web_template_id" => 1 "app_template_id" => 2 "personal_access_token_v1" => null "personal_access_token_v2" => null "mail_type" => "smtp" "mail_driver" => null "mail_host" => null "mail_port" => null "mail_username" => null "mail_password" => null "mail_encryption" => null "mail_from" => null "is_hyperlocal" => 0 "need_delivery_service" => 0 "need_dispacher_ride" => 0 "delivery_service_key" => null "primary_color" => "#32B5FC" "secondary_color" => "#41A2E6" "site_top_header_color" => "#4c4c4c" "dispatcher_key" => null "created_at" => null "updated_at" => "2024-10-09 11:16:32" "celebrity_check" => 0 "delivery_service_key_url" => null "delivery_service_key_code" => null "reffered_by_amount" => "0.00000000" "reffered_to_amount" => "0.00000000" "favicon" => null "web_color" => null "pharmacy_check" => 0 "dinein_check" => 0 "takeaway_check" => 0 "delivery_check" => 1 "rental_check" => 0 "car_rental_check" => 0 "pick_drop_check" => 0 "on_demand_check" => 0 "laundry_check" => 0 "appointment_check" => 0 "pickup_delivery_service_key" => null "pickup_delivery_service_key_url" => null "pickup_delivery_service_key_code" => null "need_dispacher_home_other_service" => null "dispacher_home_other_service_key" => null "dispacher_home_other_service_key_url" => null "dispacher_home_other_service_key_code" => null "last_mile_team" => null "tip_before_order" => 0 "tip_after_order" => 0 "off_scheduling_at_cart" => 0 "isolate_single_vendor_order" => 0 "fcm_server_key" => null "fcm_api_key" => null "fcm_auth_domain" => null "fcm_project_id" => null "fcm_storage_bucket" => null "fcm_messaging_sender_id" => null "fcm_app_id" => null "fcm_measurement_id" => null "distance_unit_for_time" => null "distance_to_time_multiplier" => 0 "android_app_link" => null "ios_link" => null "single_vendor" => 0 "stripe_connect" => 0 "need_laundry_service" => 0 "laundry_service_key" => null "laundry_service_key_url" => null "laundry_service_key_code" => null "laundry_pickup_team" => null "laundry_dropoff_team" => null "admin_email" => null "delay_order" => 0 "gifting" => 0 "product_order_form" => 0 "sms_credentials" => "{"sms_key": "AC6025a83ef123b62b06c5454a8b40c28b", "sms_from": "TrendSetter", "sms_secret": "34748004eca0c04b23391454549d2e33", "static_otp": 0}" "pickup_delivery_service_area" => 0 "customer_support" => null "customer_support_key" => null "customer_support_application_id" => null "shipping_mode" => 0 "minimum_order_batch" => 0 "is_edit_order_admin" => 0 "is_edit_order_vendor" => 0 "is_edit_order_driver" => 0 "static_delivey_fee" => 0 "header_quick_link" => 0 "get_estimations" => 0 "view_get_estimation_in_category" => 0 "tools_mode" => 0 "max_safety_mod" => 0 "hide_order_address" => 0 "digit_after_decimal" => 2 "is_cancel_order_user" => 1 "age_restriction_on_product_mode" => 0 "show_qr_on_footer" => 0 "auto_implement_5_percent_tip" => 0 "need_xero" => 0 "category_kyc_documents" => 0 "vendor_return_request" => 1 "db_audit_logs" => 0 "deliveryicon" => null "dineinicon" => null "takewayicon" => null "rentalicon" => null "pick_dropicon" => null "on_demandicon" => null "laundryicon" => null "p2picon" => null "appointmenticon" => null "third_party_accounting" => 0 "hide_order_prepare_time" => 0 "map_key_for_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo" "map_key_for_ios_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo" "subscription_tab_taxi" => 0 "need_inventory_service" => 0 "inventory_service_key" => null "inventory_service_key_url" => null "inventory_service_key_code" => null "enable_inventory_service" => 0 "scheduling_with_slots" => 0 "same_day_delivery_for_schedule" => 0 "same_day_orders_for_rescheduing" => 0 "book_for_friend" => 0 "order_cancellation_time" => null "cancellation_percentage" => null "estimation_matching_logic" => null "vendor_fcm_server_key" => null "sos" => 0 "sos_police_contact" => null "sos_ambulance_contact" => null "concise_signup" => 0 "is_static_dropoff" => 0 "is_scan_qrcode_bag" => 0 "slots_with_service_area" => 0 "is_vendor_tags" => 0 "is_service_area_for_banners" => 0 "stop_order_acceptance_for_users" => 0 "need_appointment_service" => null "appointment_service_key" => null "appointment_service_key_url" => null "appointment_service_key_code" => null "signup_image" => null "map_on_search_screen" => 0 "p2p_check" => 0 "dashboard_theme_color" => "#4c4c4c" "is_hourly_pickup_rental" => 0 ] #changes: [] #casts: [] #classCastCache: [] #attributeCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] } "clientdata" => App\Models\Client {#4375 ▶ #guard: "client" #fillable: array:28 [▶ 0 => "name" 1 => "email" 2 => "password" 3 => "encpass" 4 => "phone_number" 5 => "database_path" 6 => "database_name" 7 => "database_username" 8 => "database_password" 9 => "logo" 10 => "company_name" 11 => "company_address" 12 => "custom_domain" 13 => "status" 14 => "code" 15 => "country_id" 16 => "timezone" 17 => "is_deleted" 18 => "is_blocked" 19 => "sub_domain" 20 => "socket_url" 21 => "admin_chat" 22 => "driver_chat" 23 => "customer_chat" 24 => "dark_logo" 25 => "lumen_timestamp" 26 => "is_lumen_key_expired" 27 => "contact_email" ] #hidden: array:1 [▶ 0 => "remember_token" ] #casts: array:1 [▶ "email_verified_at" => "datetime" ] #connection: "royo_trendsetter" #table: "clients" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:42 [▶ "id" => 1 "name" => "trendsetter" "email" => "admin@trendsetter.com" "phone_number" => "07887898989" "password" => "$2y$10$WIFJni0hHBjqwzyjq2EbsOSUZKw4BQCJIDEuuetgSr3pDHKdnLb/G" "encpass" => null "country_id" => 1 "timezone" => "Africa/Abidjan" "custom_domain" => "trendsetter.ae" "sub_domain" => "trendsetter" "is_deleted" => 0 "is_blocked" => 0 "database_path" => "" "database_name" => "trendsetter" "database_username" => "root" "database_password" => "adg78t82g8iio92" "logo" => "Clientlogo/664c4518ba101.png" "company_name" => "trendsetter" "company_address" => "CDCL Building, 28B, Sector 28, Chandigarh, India" "language_id" => null "status" => 1 "code" => "37447b" "contact_email" => null "contact_address" => null "contact_phone_number" => null "created_at" => null "updated_at" => "2024-05-21 06:54:16" "database_host" => "localhost" "database_port" => "3306" "is_superadmin" => 1 "whatsapp_url" => null "socket_url" => null "admin_chat" => 2 "driver_chat" => 2 "customer_chat" => 2 "dark_logo" => "Clientlogo/664c4518c83d7.png" "is_lumen_enabled" => 0 "lumen_access_token" => null "campaign_service" => 1 "lumen_timestamp" => null "is_lumen_key_expired" => 0 "logo_image_url" => "https://s3.us-west-2.amazonaws.com/royoorders2.0-assets/Clientlogo/664c4518ba101.png" ] #original: array:41 [▶ "id" => 1 "name" => "trendsetter" "email" => "admin@trendsetter.com" "phone_number" => "07887898989" "password" => "$2y$10$WIFJni0hHBjqwzyjq2EbsOSUZKw4BQCJIDEuuetgSr3pDHKdnLb/G" "encpass" => null "country_id" => 1 "timezone" => "Africa/Abidjan" "custom_domain" => "trendsetter.ae" "sub_domain" => "trendsetter" "is_deleted" => 0 "is_blocked" => 0 "database_path" => "" "database_name" => "trendsetter" "database_username" => "root" "database_password" => "adg78t82g8iio92" "logo" => "Clientlogo/664c4518ba101.png" "company_name" => "trendsetter" "company_address" => "CDCL Building, 28B, Sector 28, Chandigarh, India" "language_id" => null "status" => 1 "code" => "37447b" "contact_email" => null "contact_address" => null "contact_phone_number" => null "created_at" => null "updated_at" => "2024-05-21 06:54:16" "database_host" => "localhost" "database_port" => "3306" "is_superadmin" => 1 "whatsapp_url" => null "socket_url" => null "admin_chat" => 2 "driver_chat" => 2 "customer_chat" => 2 "dark_logo" => "Clientlogo/664c4518c83d7.png" "is_lumen_enabled" => 0 "lumen_access_token" => null "campaign_service" => 1 "lumen_timestamp" => null "is_lumen_key_expired" => 0 ] #changes: [] #classCastCache: [] #attributeCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #visible: [] #guarded: array:1 [▶ 0 => "*" ] #rememberTokenName: "remember_token" #excludedAttributes: [] +auditEvent: null +auditCustomOld: null +auditCustomNew: null +isCustomEvent: false +preloadedResolverData: [] } "vendors" => array:5 [▶ 0 => 5 1 => 4 2 => 6 3 => 3 4 => 2 ] "navCategories" => array:4 [▶ 0 => App\Models\Category {#4741 ▶ #fillable: array:18 [▶ 0 => "slug" 1 => "icon" 2 => "icon_two" 3 => "image" 4 => "is_visible" 5 => "status" 6 => "position" 7 => "is_core" 8 => "can_add_products" 9 => "parent_id" 10 => "vendor_id" 11 => "client_code" 12 => "display_mode" 13 => "type_id" 14 => "warning_page_id" 15 => "template_type_id" 16 => "warning_page_design" 17 => "is_p2p" ] +timestamps: true #connection: "royo_trendsetter" #table: "categories" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:7 [▶ "id" => 26 "icon" => null "icon_two" => null "slug" => "efer" "parent_id" => 1 "name" => "Hotels" "type_id" => 1 ] #original: array:7 [▶ "id" => 26 "icon" => null "icon_two" => null "slug" => "efer" "parent_id" => 1 "name" => "Hotels" "type_id" => 1 ] #changes: [] #casts: array:1 [▶ "deleted_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] #forceDeleting: false } 1 => App\Models\Category {#4744 ▶ #fillable: array:18 [▶ 0 => "slug" 1 => "icon" 2 => "icon_two" 3 => "image" 4 => "is_visible" 5 => "status" 6 => "position" 7 => "is_core" 8 => "can_add_products" 9 => "parent_id" 10 => "vendor_id" 11 => "client_code" 12 => "display_mode" 13 => "type_id" 14 => "warning_page_id" 15 => "template_type_id" 16 => "warning_page_design" 17 => "is_p2p" ] +timestamps: true #connection: "royo_trendsetter" #table: "categories" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:7 [▶ "id" => 27 "icon" => null "icon_two" => null "slug" => "reg" "parent_id" => 1 "name" => "What's New" "type_id" => 1 ] #original: array:7 [▶ "id" => 27 "icon" => null "icon_two" => null "slug" => "reg" "parent_id" => 1 "name" => "What's New" "type_id" => 1 ] #changes: [] #casts: array:1 [▶ "deleted_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] #forceDeleting: false } 2 => App\Models\Category {#4740 ▶ #fillable: array:18 [▶ 0 => "slug" 1 => "icon" 2 => "icon_two" 3 => "image" 4 => "is_visible" 5 => "status" 6 => "position" 7 => "is_core" 8 => "can_add_products" 9 => "parent_id" 10 => "vendor_id" 11 => "client_code" 12 => "display_mode" 13 => "type_id" 14 => "warning_page_id" 15 => "template_type_id" 16 => "warning_page_design" 17 => "is_p2p" ] +timestamps: true #connection: "royo_trendsetter" #table: "categories" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:7 [▶ "id" => 28 "icon" => null "icon_two" => null "slug" => "dsv" "parent_id" => 1 "name" => "Beaches" "type_id" => 1 ] #original: array:7 [▶ "id" => 28 "icon" => null "icon_two" => null "slug" => "dsv" "parent_id" => 1 "name" => "Beaches" "type_id" => 1 ] #changes: [] #casts: array:1 [▶ "deleted_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] #forceDeleting: false } 3 => App\Models\Category {#4742 ▶ #fillable: array:18 [▶ 0 => "slug" 1 => "icon" 2 => "icon_two" 3 => "image" 4 => "is_visible" 5 => "status" 6 => "position" 7 => "is_core" 8 => "can_add_products" 9 => "parent_id" 10 => "vendor_id" 11 => "client_code" 12 => "display_mode" 13 => "type_id" 14 => "warning_page_id" 15 => "template_type_id" 16 => "warning_page_design" 17 => "is_p2p" ] +timestamps: true #connection: "royo_trendsetter" #table: "categories" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:7 [▶ "id" => 29 "icon" => null "icon_two" => null "slug" => "brt" "parent_id" => 1 "name" => "Fine Dining" "type_id" => 1 ] #original: array:7 [▶ "id" => 29 "icon" => null "icon_two" => null "slug" => "brt" "parent_id" => 1 "name" => "Fine Dining" "type_id" => 1 ] #changes: [] #casts: array:1 [▶ "deleted_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] #forceDeleting: false } ] "vendorType" => "delivery" "latitude" => "30.538994400000" "longitude" => "75.955032900000" "_previous" => array:1 [▶ "url" => "https://trendsetter.ae" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]