Avail some more offers !
1 x Application (81.95%) | 239ms |
1 x Booting (18.05%) | 52.67ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
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 |
|
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 |
|
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 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 `id`, `icon`, `image`, `slug`, `type_id`, `can_add_products`, `parent_id`, `sub_cat_banners` from `categories` where `slug` = 'reg' and `categories`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `category_id`, `tag` from `category_tags` where `category_tags`.`category_id` in (27)
Metadata | |
---|---|
Backtrace |
|
select `brand_categories`.`category_id`, `brand_categories`.`brand_id`, `brands`.`id`, `brands`.`image` from `brand_categories` inner join `brands` on `brands`.`id` = `brand_categories`.`brand_id` where `brand_categories`.`category_id` in (27)
Metadata | |
---|---|
Backtrace |
|
select `id`, `title` as `redirect_to`, `service_type` from `types` where `types`.`id` in (1)
Metadata | |
---|---|
Backtrace |
|
select `categories`.`id`, `categories`.`slug`, `categories`.`parent_id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`image`, `type_id`, `types`.`title` as `redirect_to` from `categories` inner join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`parent_id` in (27) and `categories`.`deleted_at` is null order by `position` asc
Metadata | |
---|---|
Backtrace |
|
select `category_translations`.`name`, `category_translations`.`meta_title`, `category_translations`.`meta_description`, `category_translations`.`meta_keywords`, `category_translations`.`category_id` from `category_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `category_translations`.`language_id` inner join `languages` on `category_translations`.`language_id` = `languages`.`id` where `cl`.`is_active` = 1 and `category_translations`.`category_id` in (27) and `category_translations`.`language_id` = 1 order by `cl`.`is_primary` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `slug`, `parent_id` from `categories` where `categories`.`id` in (1) and `categories`.`deleted_at` is null
Metadata | |
---|---|
Backtrace |
|
select `id`, `slug`, `parent_id` from `categories` where 0 = 1 and `categories`.`deleted_at` is null
Metadata | |
---|---|
Backtrace |
|
select `business_type`, `p2p_check` from `client_preferences` limit 1
Metadata | |
---|---|
Backtrace |
|
select * from `clients` 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('vendor_online_status')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `name` from `vendors` where `status` != 2
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_variant_sets`.`product_id`, `product_variant_sets`.`product_variant_id`, `product_variant_sets`.`variant_type_id`, `vr`.`type`, `vt`.`title` from `product_variant_sets` inner join `variants` as `vr` on `product_variant_sets`.`variant_type_id` = `vr`.`id` inner join `variant_translations` as `vt` on `vt`.`variant_id` = `vr`.`id` where `vt`.`language_id` = 1 and `vr`.`status` = 1 and `product_variant_sets`.`product_id` in (select `product_id` from `product_categories` where `category_id` = 27) group by `product_variant_sets`.`variant_type_id`
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `client_currencies` where `currency_id` = 147 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `products` where `products`.`is_live` = 1 and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `status` = 1 and `status` = 1) and `products`.`category_id` = 27 and `products`.`vendor_id` in (2, 3, 4, 5, 6) and `products`.`deleted_at` is null
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`.`averageRating`, `products`.`inquiry_only`, `products`.`minimum_order_count`, `products`.`batch_count`, `products`.`updated_at` from `products` where `products`.`is_live` = 1 and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `status` = 1 and `status` = 1) and `products`.`category_id` = 27 and `products`.`vendor_id` in (2, 3, 4, 5, 6) and `products`.`deleted_at` is null limit 12 offset 0
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `slug`, `name`, `name_ar`, `desc`, `desc_ar`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude`, `need_sync_with_order`, `is_seller`, `fixed_service_charge`, `service_charge_amount`, `pick_drop`, `return_request`, `phone_no`, `dial_code`, `same_day_delivery`, `next_day_delivery`, `hyper_local_delivery`, `cutOff_time`, `service_fee_percent`, `service_charges_tax_id`, `service_charges_tax`, `orders_per_slot` from `vendors` where `status` = 1 and `vendors`.`id` in (4, 5)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (162, 163, 164, 165, 166, 167, 168, 193, 194, 196, 197, 198)
Metadata | |
---|---|
Backtrace |
|
select `id`, `media_type`, `path` from `vendor_media` where `vendor_media`.`id` in (436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541)
Metadata | |
---|---|
Backtrace |
|
select `product_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (162, 163, 164, 165, 166, 167, 168, 193, 194, 196, 197, 198)
Metadata | |
---|---|
Backtrace |
|
select * from `product_attributes` where `product_attributes`.`product_id` in (162, 163, 164, 165, 166, 167, 168, 193, 194, 196, 197, 198)
Metadata | |
---|---|
Backtrace |
|
select `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (162, 163, 164, 165, 166, 167, 168, 193, 194, 196, 197, 198) and `language_id` = 1 group by `language_id`, `product_id`
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `sku`, `product_id`, `quantity`, `price`, `barcode`, `id`, `compare_at_price` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (162, 163, 164, 165, 166, 167, 168, 193, 194, 196, 197, 198) group by `product_id` order by `id` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `cart_products` where exists (select * from `carts` where `cart_products`.`cart_id` = `carts`.`id` and `unique_identifier` = '4C4OiplI7RQFAxMOoHcyzgkR6zn05mFFarQDqq5m') and `cart_products`.`variant_id` in (165, 166, 167, 168, 169, 170, 171, 196, 197, 199, 200, 201)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 193 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `add_markup_price` from `vendors` where `id` = 4 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 194 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 196 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 197 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 198 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 162 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `add_markup_price` from `vendors` where `id` = 5 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 163 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 164 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 165 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 166 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 167 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `vendor_id`, `tax_category_id` from `products` where `id` = 168 and `products`.`deleted_at` is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT MAX(product_variants.price) as max_price FROM product_variants INNER JOIN products ON products.id = product_variants.product_id WHERE product_variants.status = 1 AND products.is_live = 1 AND products.category_id = 27
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute', 'is_postpay_enable', 'is_cab_pooling', 'is_bid_ride_enable', 'is_particular_driver', 'is_recurring_booking', 'is_share_ride_users')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from information_schema.tables where table_schema = 'royo_trendsetter' and table_name = 'product_attributes' and table_type = 'BASE TABLE'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_token_currency_enable')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')
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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('chat_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('call_button')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `category_translations`.*, `languages`.`id` as `langId`, `languages`.`name` as `langName`, `cl`.`is_primary` from `category_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `category_translations`.`language_id` inner join `languages` on `category_translations`.`language_id` = `languages`.`id` where `category_translations`.`category_id` = 27 and `category_translations`.`category_id` is not null and `cl`.`is_active` = 1 order by `cl`.`is_primary` desc
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 |
|
200
[]
[]
0 of 0array:15 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "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_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_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_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" => "8087" "REMOTE_ADDR" => "216.73.216.215" "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" => "/category/reg" "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" => 1752473577.8461 "REQUEST_TIME" => 1752473577 ]
[]
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 => "Mon, 14 Jul 2025 06:12:58 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImdGZnBBRmF2c3htU2twMHdFTWdkQlE9PSIsInZhbHVlIjoiMGQwQStUTFFmcndyVXU3MUI1b0dmVlZDZFIvWUVJTHd3OWEzd1hHVUtNaHJZdnNhTWdObERSdzNSWTArMGhuMG9ORlVzRGt3Smw1TUlLQWgvNXEvamJwVmx4L2VkRU5UbTZpUUxNS2RBTHVscHpxWWVpWVdDbFpyV0plQWJISDMiLCJtYWMiOiJhNmIyMDg4N2EzZmQ1MWFmNjUxMGZlOWY1NWJiMTkxZWNjZWU1MTEyYjdlMmUwZDgzYzljZWZkODUwYzA4NTFiIiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 06:12:58 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImdGZnBBRmF2c3htU2twMHdFTWdkQlE9PSIsInZhbHVlIjoiMGQwQStUTFFmcndyVXU3MUI1b0dmVlZDZFIvWUVJTHd3OWEzd1hHVUtNaHJZdnNhTWdObERSdzNSWTArMGhuMG9ORlVzR ▶" 1 => "trendsetter_session=eyJpdiI6InhqMEZzVm9Rd3F1ZWFVbmhLMWpCclE9PSIsInZhbHVlIjoiTlJNcG90S2RTK2hudHROT3ZVZDU2QUd5cy9vM25YSWdOaC9GSDZGYzQzTFpOZVpBOFkwN2NxYm4xMUJRR2hDNzhCbWNudFNaZ1lLRHFyT2djU2ZjWWgwa3E4OWJCeVQ2dEFEcVlESCtvRnRqTWEyL3c4anZPUEs2bmUyL0xNbVMiLCJtYWMiOiI2ZTlmN2VhNmJhNmYxYmNkY2JhYmY1MWJkMzAwZmY5ODgwY2FhMDgxOTlhMmM3ODdiMTE5ZmFmYTc5NmExNzY3IiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 06:12:58 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀trendsetter_session=eyJpdiI6InhqMEZzVm9Rd3F1ZWFVbmhLMWpCclE9PSIsInZhbHVlIjoiTlJNcG90S2RTK2hudHROT3ZVZDU2QUd5cy9vM25YSWdOaC9GSDZGYzQzTFpOZVpBOFkwN2NxYm4xMUJRR2hD ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImdGZnBBRmF2c3htU2twMHdFTWdkQlE9PSIsInZhbHVlIjoiMGQwQStUTFFmcndyVXU3MUI1b0dmVlZDZFIvWUVJTHd3OWEzd1hHVUtNaHJZdnNhTWdObERSdzNSWTArMGhuMG9ORlVzRGt3Smw1TUlLQWgvNXEvamJwVmx4L2VkRU5UbTZpUUxNS2RBTHVscHpxWWVpWVdDbFpyV0plQWJISDMiLCJtYWMiOiJhNmIyMDg4N2EzZmQ1MWFmNjUxMGZlOWY1NWJiMTkxZWNjZWU1MTEyYjdlMmUwZDgzYzljZWZkODUwYzA4NTFiIiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 06:12:58 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImdGZnBBRmF2c3htU2twMHdFTWdkQlE9PSIsInZhbHVlIjoiMGQwQStUTFFmcndyVXU3MUI1b0dmVlZDZFIvWUVJTHd3OWEzd1hHVUtNaHJZdnNhTWdObERSdzNSWTArMGhuMG9ORlVzR ▶" 1 => "trendsetter_session=eyJpdiI6InhqMEZzVm9Rd3F1ZWFVbmhLMWpCclE9PSIsInZhbHVlIjoiTlJNcG90S2RTK2hudHROT3ZVZDU2QUd5cy9vM25YSWdOaC9GSDZGYzQzTFpOZVpBOFkwN2NxYm4xMUJRR2hDNzhCbWNudFNaZ1lLRHFyT2djU2ZjWWgwa3E4OWJCeVQ2dEFEcVlESCtvRnRqTWEyL3c4anZPUEs2bmUyL0xNbVMiLCJtYWMiOiI2ZTlmN2VhNmJhNmYxYmNkY2JhYmY1MWJkMzAwZmY5ODgwY2FhMDgxOTlhMmM3ODdiMTE5ZmFmYTc5NmExNzY3IiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 06:12:58 GMT; path=/; httponly ◀trendsetter_session=eyJpdiI6InhqMEZzVm9Rd3F1ZWFVbmhLMWpCclE9PSIsInZhbHVlIjoiTlJNcG90S2RTK2hudHROT3ZVZDU2QUd5cy9vM25YSWdOaC9GSDZGYzQzTFpOZVpBOFkwN2NxYm4xMUJRR2hD ▶" ] ]
0 of 0array:21 [▼ "_token" => "4C4OiplI7RQFAxMOoHcyzgkR6zn05mFFarQDqq5m" "client_config" => {#4390 ▶ +"name": "trendsetter" +"email": "admin@trendsetter.com" +"phone_number": "07887898989" +"is_deleted": 0 +"is_blocked": 0 +"logo": {#4391 ▶ +"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" "vendorType" => "delivery" "default_country_code" => "AF" "default_country_phonecode" => 93 "preferences" => App\Models\ClientPreference {#4014 ▶ #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 {#4392 ▶ #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: [] } "userCode" => "37447b" "vendors" => array:5 [▶ 0 => 2 1 => 3 2 => 4 3 => 5 4 => 6 ] "_previous" => array:1 [▶ "url" => "https://trendsetter.ae/category/reg" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]