- Quick Links
- My Account
Service Details
Date & Time
Payment
| 1 x Application (75.29%) | 168ms |
| 1 x Booting (24.71%) | 54.99ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
select `theme_admin`, `distance_unit`, `currency_id`, `date_format`, `time_format`, `fb_login`, `fb_client_id`, `fb_client_secret`, `fb_client_url`, `twitter_login`, `twitter_client_id`, `twitter_client_secret`, `twitter_client_url`, `google_login`, `google_client_id`, `google_client_secret`, `google_client_url`, `apple_login`, `apple_client_id`, `apple_client_secret`, `apple_client_url`, `Default_location_name`, `Default_latitude`, `Default_longitude`, `map_provider`, `map_key`, `sms_provider`, `verify_email`, `verify_phone`, `web_template_id`, `is_hyperlocal`, `need_delivery_service`, `need_dispacher_ride`, `delivery_service_key`, `dispatcher_key`, `primary_color`, `secondary_color`, `fcm_api_key`, `fcm_auth_domain`, `fcm_project_id`, `fcm_storage_bucket`, `fcm_messaging_sender_id`, `fcm_app_id`, `fcm_measurement_id`, `distance_unit_for_time`, `distance_to_time_multiplier`, `delay_order`, `product_order_form`, `digit_after_decimal` from `client_preferences` where `client_code` = 'fb0df5' 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` = 165 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `clients` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `countries` where `id` = 224| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `icon`, `image`, `slug`, `type_id`, `can_add_products`, `parent_id` from `categories` where `slug` = 'homecare' and `categories`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id`, `tag` from `category_tags` where `category_tags`.`category_id` in (22)| 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 (22)| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `title` as `redirect_to` from `types` where `types`.`id` in (8)| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `slug`, `parent_id`, `icon`, `icon_two`, `image`, `type_id` from `categories` where `categories`.`parent_id` in (22) and `categories`.`deleted_at` is null| 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 (23, 24, 25, 38) and `category_translations`.`language_id` = 1 order by `cl`.`is_primary` desc| Metadata | |
|---|---|
| Bindings |
|
| 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 (22) 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 * from `client_languages` order by `is_primary` desc limit 1| Metadata | |
|---|---|
| Backtrace |
|
select distinct `categories`.`id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`slug`, `categories`.`parent_id`, `cts`.`name` from `categories` inner join `category_translations` as `cts` on `categories`.`id` = `cts`.`category_id` left join `types` on `types`.`id` = `categories`.`type_id` where `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 `id` order by `position` asc, `categories`.`parent_id` asc| 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` = 22) group by `product_variant_sets`.`variant_type_id`| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 165 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `products` where `products`.`is_live` = 1 and `products`.`category_id` = 22 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` from `products` where `products`.`is_live` = 1 and `products`.`category_id` = 22 and `products`.`deleted_at` is null limit 12 offset 0| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `hourly_rate_per_worker` from `vendors` where `vendors`.`id` in (20)| Metadata | |
|---|---|
| Backtrace |
|
select `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (160)| Metadata | |
|---|---|
| Backtrace |
|
select `product_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (160)| Metadata | |
|---|---|
| Backtrace |
|
select `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (160) and `language_id` = 1 group by `language_id`, `product_id`| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `sku`, `product_id`, `quantity`, `price`, `barcode`, `id` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (160) group by `product_id`| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `cart_products` where exists (select * from `carts` where `cart_products`.`cart_id` = `carts`.`id` and `unique_identifier` = 'BgbZfJppb9S9Q3g2Mc6Jr42aiwto1hF8yruINY8U') and `cart_products`.`variant_id` in (165)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 165 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `sku`, `url_slug`, `weight_unit`, `weight`, `vendor_id`, `has_variant`, `has_inventory`, `sell_when_out_of_stock`, `requires_shipping`, `Requires_last_mile`, `averageRating`, `inquiry_only`, `minimum_order_count`, `batch_count` from `products` where `is_new` = 1 and `vendor_id` in (1, 13, 15, 17, 20, 21, 22) and `is_live` = 1 and `category_id` is not null and `products`.`deleted_at` is null limit 6| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (116, 118, 119, 123, 124, 127)| Metadata | |
|---|---|
| Backtrace |
|
select * from `categories` where `deleted_at` is null and `categories`.`id` in (34, 37) and `categories`.`deleted_at` is null| Metadata | |
|---|---|
| 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 `cl`.`is_active` = 1 and `category_translations`.`category_id` in (34, 37) and `category_translations`.`language_id` = 1 order by `cl`.`is_primary` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `hourly_rate_per_worker` from `vendors` where `vendors`.`id` in (1)| Metadata | |
|---|---|
| Backtrace |
|
select `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (116, 118, 119, 123, 124, 127) group by `product_id`| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `media_type`, `path` from `vendor_media` where `vendor_media`.`id` in (128, 130, 131, 135, 136, 139)| Metadata | |
|---|---|
| Backtrace |
|
select `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (116, 118, 119, 123, 124, 127) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `sku`, `product_id`, `quantity`, `price`, `barcode` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (116, 118, 119, 123, 124, 127) group by `product_id` order by `price` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `countries`| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `is_gift`, `item_count`, `scheduled_date_time` from `carts` where `status` = '0' and `unique_identifier` = 'BgbZfJppb9S9Q3g2Mc6Jr42aiwto1hF8yruINY8U' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_languages` order by `is_primary` desc limit 1| Metadata | |
|---|---|
| Backtrace |
|
select distinct `categories`.`id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`slug`, `categories`.`parent_id`, `cts`.`name` from `categories` inner join `category_translations` as `cts` on `categories`.`id` = `cts`.`category_id` left join `types` on `types`.`id` = `categories`.`type_id` where `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 `id` order by `position` asc, `categories`.`parent_id` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_currencies` where `currency_id` = 165 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 `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)| 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 (165)| 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) 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)| 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 (165)| 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) and `language_id` = 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 `nomenclatures` where `label` LIKE '%Delivery%' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (7) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures` where `label` LIKE '%Takeaway%' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (3) and `language_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures` where `label` LIKE '%Search%' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (4) 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) 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)| 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 (165)| Metadata | |
|---|---|
| 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 `client_preferences` where (`id` = 1) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `credentials`, `test_mode` from `payment_options` where `code` = 'razorpay' and `status` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `client_preferences` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `clients` limit 1| Metadata | |
|---|---|
| Backtrace |
|
select * from `clients` limit 1| Metadata | |
|---|---|
| Backtrace |
|
200
0 of 0array:2 [▼ "step" => "2" "dataset" => "1" ]
0 of 0array:2 [▼ "step" => "2" "dataset" => "1" ]
0 of 0array:16 [▼ "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImhYVmxTN2NVT25YWklkU3pCcjAzbXc9PSIsInZhbHVlIjoieUFFMlJzQ1NmSEpMYXNqZUhVRmxhaHFZak9vaGYrMkVpN2w3TTBtTzRIa0FhSEN1WU9RMnh1K2VZS01QeXlCSU1udzduT1cxLzFZc0M1ZEZubTcxYlEyNFljdkgyKzUwUHF4c0lCWEtNSjdpYzVZdklnQUF2TjZwSmx6RTFzYSsiLCJtYWMiOiI1Yjk5MDhiN2I2OGMzMGFlM2ZjM2JiNmZiYTk4N2Y5ZDI5MDhjZjIwMTZiMWQxZGY2MTM5MjNiMWZkNDdiM2ZjIiwidGFnIjoiIn0%3D; royoorders_session=eyJpdiI6ImlzWUJGN3dSRnZuZ1YwYmVCc1VPQUE9PSIsInZhbHVlIjoicnpqOUp2ZERoS3FKRk9hTXV2bVhPcTc3bk1UenUzSXpKMnF0TFZvNWc5V0RLdk43NnB3WDRxTGloZ3hHVXQwVkhha09BaFVwMUpVNUt6Wkx1bmZTK0lhQS9WL2RSQnJEcDNORlJTYWw3Ry9yR20zNVFTWXI3M21LQmx0RFNmL04iLCJtYWMiOiJmMmM1MjMyZmU5YzUxNDhjMTE0ZmFhNDc5NzJmZTU1ODk2NGFkNzJkNGViZWVmNGM1ZmZiOWQ1MjJlMjdkYTcyIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImhYVmxTN2NVT25YWklkU3pCcjAzbXc9PSIsInZhbHVlIjoieUFFMlJzQ1NmSEpMYXNqZUhVRmxhaHFZak9vaGYrMkVpN2w3TTBtTzRIa0FhSEN1WU9RMnh1K2VZS01QeXlCSU1udzduT ▶" ] "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 => "ored.co" ] ]
0 of 0array:42 [▼ "USER" => "www-data" "HOME" => "/var/www" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6ImhYVmxTN2NVT25YWklkU3pCcjAzbXc9PSIsInZhbHVlIjoieUFFMlJzQ1NmSEpMYXNqZUhVRmxhaHFZak9vaGYrMkVpN2w3TTBtTzRIa0FhSEN1WU9RMnh1K2VZS01QeXlCSU1udzduT1cxLzFZc0M1ZEZubTcxYlEyNFljdkgyKzUwUHF4c0lCWEtNSjdpYzVZdklnQUF2TjZwSmx6RTFzYSsiLCJtYWMiOiI1Yjk5MDhiN2I2OGMzMGFlM2ZjM2JiNmZiYTk4N2Y5ZDI5MDhjZjIwMTZiMWQxZGY2MTM5MjNiMWZkNDdiM2ZjIiwidGFnIjoiIn0%3D; royoorders_session=eyJpdiI6ImlzWUJGN3dSRnZuZ1YwYmVCc1VPQUE9PSIsInZhbHVlIjoicnpqOUp2ZERoS3FKRk9hTXV2bVhPcTc3bk1UenUzSXpKMnF0TFZvNWc5V0RLdk43NnB3WDRxTGloZ3hHVXQwVkhha09BaFVwMUpVNUt6Wkx1bmZTK0lhQS9WL2RSQnJEcDNORlJTYWw3Ry9yR20zNVFTWXI3M21LQmx0RFNmL04iLCJtYWMiOiJmMmM1MjMyZmU5YzUxNDhjMTE0ZmFhNDc5NzJmZTU1ODk2NGFkNzJkNGViZWVmNGM1ZmZiOWQ1MjJlMjdkYTcyIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImhYVmxTN2NVT25YWklkU3pCcjAzbXc9PSIsInZhbHVlIjoieUFFMlJzQ1NmSEpMYXNqZUhVRmxhaHFZak9vaGYrMkVpN2w3TTBtTzRIa0FhSEN1WU9RMnh1K2VZS01QeXlCSU1udzduT ▶" "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" => "ored.co" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "ored.co" "SERVER_PORT" => "443" "SERVER_ADDR" => "172.31.6.48" "REMOTE_PORT" => "54884" "REMOTE_ADDR" => "18.188.188.143" "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/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/category/homecare?step=2&dataset=1" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "step=2&dataset=1" "SCRIPT_FILENAME" => "/var/www/html/order/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746505770.8474 "REQUEST_TIME" => 1746505770 ]
0 of 0array:2 [▼ "XSRF-TOKEN" => "BgbZfJppb9S9Q3g2Mc6Jr42aiwto1hF8yruINY8U" "royoorders_session" => "hLvFhvbvi5UeKeMEOFDlZFpQmmIx3y6R3RgK7QN3" ]
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 => "Tue, 06 May 2025 04:29:31 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ii9NYk9pSGVBN29ZUkFLakNMTzQ1Umc9PSIsInZhbHVlIjoiNTlNaFpteWpBUHpIMmg1ZVBNbGs5SzJnTHdLZEFSWm5ybUMzc2l0djQ3dkFGcjdDanRGU0FzUlRhTklGNzV1Z2VJajdNRndYaUVZbmhzcTJnNmFXQ0JiN0lrVGVRWXBicFR4ZG9PVEQ2b0VtcGM3Z3YySXJianBzOEkxelR3MWQiLCJtYWMiOiJjNDhiODM1YmU2YjlhNjhmOTJlZTliMzQ3NGJjYmJmNjRjMmJjNTkwZDYwNWJlYTQwZGRiMWU3YTAzYmIwNmIwIiwidGFnIjoiIn0%3D; expires=Wed, 06-May-2026 04:29:31 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ii9NYk9pSGVBN29ZUkFLakNMTzQ1Umc9PSIsInZhbHVlIjoiNTlNaFpteWpBUHpIMmg1ZVBNbGs5SzJnTHdLZEFSWm5ybUMzc2l0djQ3dkFGcjdDanRGU0FzUlRhTklGNzV1Z2VJajdNR ▶" 1 => "royoorders_session=eyJpdiI6IkVYMHlaaXJoK0dnMWpYN2h6ZDlDSVE9PSIsInZhbHVlIjoiU0NrRHZLb21XNU56OTU0V2k3VzRjaEdvUllKalBRRXdkSVJUem9Pc2VHN2FWV3FQaUhYSzRTbFdtNUhPdXhZN1dram9VVitMVkRGRG55bnhTVUtyM2tkVXhXREdHenBjcmprLzBjQlQvM0I3dUJlT2FXVEgxYnpoenhYZFpqZDgiLCJtYWMiOiI1NzE3YWFmZTI3N2Q1NDU4YzM3ODk1ZDUwZmZiMGQ0ZDA4NzJhMDFjMzNlMmFjNDdhOTllNWI2M2Y3NGU2NmUyIiwidGFnIjoiIn0%3D; expires=Wed, 06-May-2026 04:29:31 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀royoorders_session=eyJpdiI6IkVYMHlaaXJoK0dnMWpYN2h6ZDlDSVE9PSIsInZhbHVlIjoiU0NrRHZLb21XNU56OTU0V2k3VzRjaEdvUllKalBRRXdkSVJUem9Pc2VHN2FWV3FQaUhYSzRTbFdtNUhPdXhZN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ii9NYk9pSGVBN29ZUkFLakNMTzQ1Umc9PSIsInZhbHVlIjoiNTlNaFpteWpBUHpIMmg1ZVBNbGs5SzJnTHdLZEFSWm5ybUMzc2l0djQ3dkFGcjdDanRGU0FzUlRhTklGNzV1Z2VJajdNRndYaUVZbmhzcTJnNmFXQ0JiN0lrVGVRWXBicFR4ZG9PVEQ2b0VtcGM3Z3YySXJianBzOEkxelR3MWQiLCJtYWMiOiJjNDhiODM1YmU2YjlhNjhmOTJlZTliMzQ3NGJjYmJmNjRjMmJjNTkwZDYwNWJlYTQwZGRiMWU3YTAzYmIwNmIwIiwidGFnIjoiIn0%3D; expires=Wed, 06-May-2026 04:29:31 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ii9NYk9pSGVBN29ZUkFLakNMTzQ1Umc9PSIsInZhbHVlIjoiNTlNaFpteWpBUHpIMmg1ZVBNbGs5SzJnTHdLZEFSWm5ybUMzc2l0djQ3dkFGcjdDanRGU0FzUlRhTklGNzV1Z2VJajdNR ▶" 1 => "royoorders_session=eyJpdiI6IkVYMHlaaXJoK0dnMWpYN2h6ZDlDSVE9PSIsInZhbHVlIjoiU0NrRHZLb21XNU56OTU0V2k3VzRjaEdvUllKalBRRXdkSVJUem9Pc2VHN2FWV3FQaUhYSzRTbFdtNUhPdXhZN1dram9VVitMVkRGRG55bnhTVUtyM2tkVXhXREdHenBjcmprLzBjQlQvM0I3dUJlT2FXVEgxYnpoenhYZFpqZDgiLCJtYWMiOiI1NzE3YWFmZTI3N2Q1NDU4YzM3ODk1ZDUwZmZiMGQ0ZDA4NzJhMDFjMzNlMmFjNDdhOTllNWI2M2Y3NGU2NmUyIiwidGFnIjoiIn0%3D; expires=Wed, 06-May-2026 04:29:31 GMT; path=/; httponly ◀royoorders_session=eyJpdiI6IkVYMHlaaXJoK0dnMWpYN2h6ZDlDSVE9PSIsInZhbHVlIjoiU0NrRHZLb21XNU56OTU0V2k3VzRjaEdvUllKalBRRXdkSVJUem9Pc2VHN2FWV3FQaUhYSzRTbFdtNUhPdXhZN ▶" ] ]
0 of 0array:16 [▼ "_token" => "BgbZfJppb9S9Q3g2Mc6Jr42aiwto1hF8yruINY8U" "client_config" => {#3767 ▶ +"name": "Ored" +"email": "admin@ored.com" +"phone_number": "501692300" +"is_deleted": 0 +"is_blocked": 0 +"logo": {#3768 ▶ +"proxy_url": "https://images.ored.co/insecure/fill/" +"image_path": "/ce/0/plain/https://ored-assets.s3.me-south-1.amazonaws.com/default/default_logo.png@webp" +"image_fit": "https://images.ored.co/insecure/fit/" +"original": "https://ored-assets.s3.me-south-1.amazonaws.com/default/default_logo.png" +"logo_db_value": "default/default_logo.png" } +"company_name": "Ored" +"company_address": "Chandigarh" +"status": 1 +"code": "fb0df5" +"database_name": "ored" +"database_host": "ored-db-cluster.cjzxojwknufw.me-south-1.rds.amazonaws.com" +"database_port": "3306" +"database_username": "oredadmin" +"database_password": "pVc2StHd8xRJU3KX" +"custom_domain": "www.ored.co" +"sub_domain": "ored" } "login_user_type" => "client" "customerLanguage" => 1 "applocale" => "en" "customerCurrency" => 165 "currencySymbol" => "د.إ" "currencyMultiplier" => "1.00000000" "iso_code" => "AED" "default_country_code" => "AE" "default_country_phonecode" => 971 "preferences" => App\Models\ClientPreference {#3366 ▶ #fillable: array:63 [▶ 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" ] #connection: "royo_ored" #table: "client_preferences" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:49 [▶ "theme_admin" => "light" "distance_unit" => "metric" "currency_id" => null "date_format" => "YYYY-MM-DD" "time_format" => "24" "fb_login" => 0 "fb_client_id" => "admin@ored.com" "fb_client_secret" => "admin@520" "fb_client_url" => null "twitter_login" => 0 "twitter_client_id" => null "twitter_client_secret" => null "twitter_client_url" => null "google_login" => 0 "google_client_id" => null "google_client_secret" => null "google_client_url" => null "apple_login" => 0 "apple_client_id" => null "apple_client_secret" => null "apple_client_url" => null "Default_location_name" => "Chandigarh, India" "Default_latitude" => "30.538994400000" "Default_longitude" => "75.955032900000" "map_provider" => null "map_key" => "AIzaSyBelgPz9p9_Wsej13kKZH-ApSnFjOxib_4" "sms_provider" => 1 "verify_email" => 0 "verify_phone" => 0 "web_template_id" => null "is_hyperlocal" => 0 "need_delivery_service" => 1 "need_dispacher_ride" => 1 "delivery_service_key" => "Obm8qdJU4aWpfgx2BwR4sT7GMM7UAB" "dispatcher_key" => null "primary_color" => "#32B5FC" "secondary_color" => "#41A2E6" "fcm_api_key" => "AIzaSyDvvgzrINlQu6cFrKf_UTrYFgOFqvTK9h4" "fcm_auth_domain" => "ored-2cc63.firebaseapp.com" "fcm_project_id" => "ored-2cc63" "fcm_storage_bucket" => "ored-2cc63.appspot.com" "fcm_messaging_sender_id" => "727222041107" "fcm_app_id" => "1:727222041107:web:c03af81d36e4979c425de6" "fcm_measurement_id" => "G-39YK60YKNJ" "distance_unit_for_time" => null "distance_to_time_multiplier" => 0 "delay_order" => 0 "product_order_form" => 1 "digit_after_decimal" => 2 ] #original: array:49 [▶ "theme_admin" => "light" "distance_unit" => "metric" "currency_id" => null "date_format" => "YYYY-MM-DD" "time_format" => "24" "fb_login" => 0 "fb_client_id" => "admin@ored.com" "fb_client_secret" => "admin@520" "fb_client_url" => null "twitter_login" => 0 "twitter_client_id" => null "twitter_client_secret" => null "twitter_client_url" => null "google_login" => 0 "google_client_id" => null "google_client_secret" => null "google_client_url" => null "apple_login" => 0 "apple_client_id" => null "apple_client_secret" => null "apple_client_url" => null "Default_location_name" => "Chandigarh, India" "Default_latitude" => "30.538994400000" "Default_longitude" => "75.955032900000" "map_provider" => null "map_key" => "AIzaSyBelgPz9p9_Wsej13kKZH-ApSnFjOxib_4" "sms_provider" => 1 "verify_email" => 0 "verify_phone" => 0 "web_template_id" => null "is_hyperlocal" => 0 "need_delivery_service" => 1 "need_dispacher_ride" => 1 "delivery_service_key" => "Obm8qdJU4aWpfgx2BwR4sT7GMM7UAB" "dispatcher_key" => null "primary_color" => "#32B5FC" "secondary_color" => "#41A2E6" "fcm_api_key" => "AIzaSyDvvgzrINlQu6cFrKf_UTrYFgOFqvTK9h4" "fcm_auth_domain" => "ored-2cc63.firebaseapp.com" "fcm_project_id" => "ored-2cc63" "fcm_storage_bucket" => "ored-2cc63.appspot.com" "fcm_messaging_sender_id" => "727222041107" "fcm_app_id" => "1:727222041107:web:c03af81d36e4979c425de6" "fcm_measurement_id" => "G-39YK60YKNJ" "distance_unit_for_time" => null "distance_to_time_multiplier" => 0 "delay_order" => 0 "product_order_form" => 1 "digit_after_decimal" => 2 ] #changes: [] #casts: [] #classCastCache: [] #attributeCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] } "skip_addons" => "1" "_previous" => array:1 [▶ "url" => "https://ored.co/category/homecare?dataset=1&step=2" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]