Al Alamein Hotel

Egypt North Coast

$0.00

Product Details

Looking for a historic retreat on Egypt’s North Coast? Al Alamein Hotel has been a favorite hangout since the late '50s! When Emaar chose this gem to kickstart their Marassi project, they kn... Read More

Quantity :
Share It
7.4.33PHP Version219msRequest Duration19MBMemory UsageGET {vendor?}/product/{id?}Route
    • Booting (56.79ms)
    • Application (162ms)
    • 1 x Application (74.08%)
      162ms
      1 x Booting (25.92%)
      56.79ms
      15 templates were rendered
      • frontend.product (resources/views/frontend/product.blade.php)25blade
        Params
        0
        productAvailability
        1
        productAttributes
        2
        pickup_time
        3
        drop_time
        4
        user_vendor
        5
        shareComponent
        6
        sets
        7
        vendor_info
        8
        product
        9
        navCategories
        10
        newProducts
        11
        rating_details
        12
        is_inwishlist_btn
        13
        category
        14
        product_in_cart
        15
        is_available
        16
        getAdditionalPreference
        17
        suggested_category_products
        18
        suggested_brand_products
        19
        suggested_vendor_products
        20
        coupon_list
        21
        attr_array
        22
        set_template
        23
        current_time_response
        24
        processorProduct
      • frontend.included_files.products_breadcrumb (resources/views/frontend/included_files/products_breadcrumb.blade.php)47blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
      • frontend.product-part.product-variant (resources/views/frontend/product-part/product-variant.blade.php)54blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
      • layouts.store (resources/views/layouts/store.blade.php)69blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
      • layouts.store.title-meta (resources/views/layouts/store/title-meta.blade.php)70blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
      • layouts.store.head-content (resources/views/layouts/store/head-content.blade.php)71blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        demo
      • layouts.shared.variables-constant-js (resources/views/layouts/shared/variables-constant-js.blade.php)80blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
      • layouts.language (resources/views/layouts/language.blade.php)80blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
      • layouts.store.left-sidebar-template-one (resources/views/layouts/store/left-sidebar-template-one.blade.php)80blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
      • layouts.store.topbar-template-one (resources/views/layouts/store/topbar-template-one.blade.php)85blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
        80
        urlImg
        81
        compId
        82
        languageList
        83
        currencyList
        84
        pages
      • layouts.store.search_template (resources/views/layouts/store/search_template.blade.php)86blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
        80
        urlImg
        81
        compId
        82
        languageList
        83
        currencyList
        84
        pages
        85
        searchPlaceholder
      • layouts.store.search_template (resources/views/layouts/store/search_template.blade.php)86blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
        80
        urlImg
        81
        compId
        82
        languageList
        83
        currencyList
        84
        pages
        85
        searchPlaceholder
      • layouts.store.remove_cart_model (resources/views/layouts/store/remove_cart_model.blade.php)89blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
        80
        urlImg
        81
        compId
        82
        languageList
        83
        currencyList
        84
        pages
        85
        __currentLoopData
        86
        loop
        87
        searchPlaceholder
        88
        cate
      • layouts.store.footer-content-template-one (resources/views/layouts/store/footer-content-template-one.blade.php)80blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
      • layouts.store.footer (resources/views/layouts/store/footer.blade.php)80blade
        Params
        0
        __env
        1
        app
        2
        last_mile_common_set
        3
        favicon
        4
        client_head
        5
        mod_count
        6
        social_media_details
        7
        stripe_publishable_key
        8
        stripe_fpx_publishable_key
        9
        stripe_oxxo_publishable_key
        10
        stripe_ideal_publishable_key
        11
        khalti_api_key
        12
        yoco_public_key
        13
        checkout_public_key
        14
        client_preference_detail
        15
        client_payment_options
        16
        cashfree_test_mode
        17
        payphone_id
        18
        payPhoneToken
        19
        data_trans_script_url
        20
        errors
        21
        productAvailability
        22
        productAttributes
        23
        pickup_time
        24
        drop_time
        25
        user_vendor
        26
        shareComponent
        27
        sets
        28
        vendor_info
        29
        product
        30
        navCategories
        31
        newProducts
        32
        rating_details
        33
        is_inwishlist_btn
        34
        category
        35
        product_in_cart
        36
        is_available
        37
        getAdditionalPreference
        38
        suggested_category_products
        39
        suggested_brand_products
        40
        suggested_vendor_products
        41
        coupon_list
        42
        attr_array
        43
        set_template
        44
        current_time_response
        45
        processorProduct
        46
        clientData
        47
        category_name
        48
        img
        49
        additionalPreference
        50
        content
        51
        maxContentLength
        52
        fullContent
        53
        readMore
        54
        checkSlot
        55
        product_quantity_in_cart
        56
        user
        57
        user_type
        58
        to_message
        59
        from_message
        60
        chat_type
        61
        startChatype
        62
        apiPre
        63
        rePre
        64
        fetchDe
        65
        title
        66
        meta_title
        67
        meta_keyword
        68
        meta_description
        69
        set_common_business_type
        70
        dark_mode
        71
        analytics
        72
        getOnDemandPricingRule
        73
        is_ondemand_multi_pricing
        74
        body_class
        75
        left_sidebar
        76
        footer_content
        77
        selectedTemplate
        78
        p2pClass
        79
        type
      uri
      GET {vendor?}/product/{id?}
      middleware
      web, languageSwitch, subdomain, domain
      domain
      {domain}
      controller
      App\Http\Controllers\Front\ProductController@index
      namespace
      App\Http\Controllers
      prefix
      where
      as
      productDetail
      file
      app/Http/Controllers/Front/ProductController.php:34-466
      138 statements were executed, 61 of which were duplicated, 77 unique51.84ms
      • select * from `client_preferences` where `client_code` = '37447b' limit 1
        1.35msmiddleware::domain:79royo_trendsetter
        Metadata
        Bindings
        • 0. 37447b
        Backtrace
        • 15. middleware::domain:79
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 17. middleware::subdomain:22
        • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 19. middleware::languageSwitch:26
      • select `language_id`, `is_primary` from `client_languages` where `is_primary` = 1 limit 1
        360μsmiddleware::domain:89royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. middleware::domain:89
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 17. middleware::subdomain:22
        • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 19. middleware::languageSwitch:26
      • select * from `languages` where `id` = 1 limit 1
        350μsmiddleware::domain:99royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. middleware::domain:99
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 17. middleware::subdomain:22
        • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 19. middleware::languageSwitch:26
      • select * from `client_currencies` inner join `currencies` as `cu` on `cu`.`id` = `client_currencies`.`currency_id` where `client_currencies`.`is_primary` = 1 limit 1
        480μsmiddleware::domain:104royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. middleware::domain:104
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 17. middleware::subdomain:22
        • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 19. middleware::languageSwitch:26
      • select * from `currencies` where `id` = 147 limit 1
        250μsmiddleware::domain:119royo_trendsetter
        Metadata
        Bindings
        • 0. 147
        Backtrace
        • 15. middleware::domain:119
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 17. middleware::subdomain:22
        • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 19. middleware::languageSwitch:26
      • select * from `clients` limit 1
        320μsmiddleware::domain:128royo_trendsetter
        Metadata
        Backtrace
        • 18. middleware::domain:128
        • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 20. middleware::subdomain:22
        • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 22. middleware::languageSwitch:26
      • select * from `countries` where `id` = 1
        350μsmiddleware::domain:129royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 14. middleware::domain:129
        • 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 16. middleware::subdomain:22
        • 17. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 18. middleware::languageSwitch:26
      • select * from `clients` limit 1
        250μs/app/helpers.php:27royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/helpers.php:27
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_price_by_role')
        300μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_price_by_role
        Backtrace
        • 14. /app/helpers.php:69
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `clients` limit 1
        250μs/app/Http/Controllers/Front/ProductController.php:45royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/Http/Controllers/Front/ProductController.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `business_type`, `p2p_check` from `client_preferences` limit 1
        200μs/app/helpers.php:1340royo_trendsetter
        Metadata
        Backtrace
        • 15. /app/helpers.php:1340
        • 17. /app/Http/Controllers/Front/FrontController.php:212
        • 18. /app/Http/Controllers/Front/ProductController.php:53
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_rental_weekly_monthly_price
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /app/Http/Controllers/Front/FrontController.php:212
        • 18. /app/Http/Controllers/Front/ProductController.php:53
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')
        260μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_rental_weekly_monthly_price
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /app/Http/Controllers/Front/FrontController.php:212
        • 18. /app/Http/Controllers/Front/ProductController.php:53
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `types` where `service_type` in ('products_service')
        310μs/app/helpers.php:1418royo_trendsetter
        Metadata
        Bindings
        • 0. products_service
        Backtrace
        • 13. /app/helpers.php:1418
        • 15. /app/Http/Controllers/Front/FrontController.php:212
        • 16. /app/Http/Controllers/Front/ProductController.php:53
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `client_languages` order by `is_primary` desc limit 1
        210μs/app/Http/Controllers/Front/FrontController.php:298royo_trendsetter
        Metadata
        Backtrace
        • 15. /app/Http/Controllers/Front/FrontController.php:298
        • 16. /app/Http/Controllers/Front/FrontController.php:212
        • 17. /app/Http/Controllers/Front/ProductController.php:53
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `client_preferences` where `id` > 0 limit 1
        570μs/app/Http/Controllers/Front/FrontController.php:425royo_trendsetter
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 15. /app/Http/Controllers/Front/FrontController.php:425
        • 16. /app/Http/Controllers/Front/FrontController.php:315
        • 17. /app/Http/Controllers/Front/FrontController.php:212
        • 18. /app/Http/Controllers/Front/ProductController.php:53
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('vendor_online_status')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. vendor_online_status
        Backtrace
        • 14. /app/helpers.php:69
        • 24. /app/Http/Controllers/Front/FrontController.php:433
        • 25. /app/Http/Controllers/Front/FrontController.php:315
        • 26. /app/Http/Controllers/Front/FrontController.php:212
        • 27. /app/Http/Controllers/Front/ProductController.php:53
      • select `id`, `show_slot` from `vendors` where `delivery` = 1 and `status` = 1
        430μs/app/Http/Controllers/Front/FrontController.php:465royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. /app/Http/Controllers/Front/FrontController.php:465
        • 15. /app/Http/Controllers/Front/FrontController.php:315
        • 16. /app/Http/Controllers/Front/FrontController.php:212
        • 17. /app/Http/Controllers/Front/ProductController.php:53
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 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
        980μs/app/Http/Controllers/Front/FrontController.php:348royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 3
        • 2. 4
        • 3. 5
        • 4. 6
        • 5. 11
        • 6. 2
        • 7. 3
        • 8. 4
        • 9. 5
        • 10. 6
        • 11. 1
        • 12. 4
        • 13. 8
        • 14. 1
        • 15. 5
        • 16. 1
        • 17. 1
        • 18. 1
        • 19. 2
        • 20. 1
        • 21. 1
        • 22. 1
        Backtrace
        • 14. /app/Http/Controllers/Front/FrontController.php:348
        • 15. /app/Http/Controllers/Front/FrontController.php:212
        • 16. /app/Http/Controllers/Front/ProductController.php:53
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
        1.33ms/app/helpers.php:42royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. vendors
        Backtrace
        • 11. /app/helpers.php:42
        • 18. /app/Http/Controllers/Front/ProductController.php:61
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
        1.12ms/app/helpers.php:42royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. vendors
        Backtrace
        • 11. /app/helpers.php:42
        • 18. /app/Http/Controllers/Front/ProductController.php:61
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id`, `vendor_id`, `security_amount` from `products` where `url_slug` = 'gdr' and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'egypt-north-coast' and `status` = 1) and `products`.`deleted_at` is null limit 1
        540μs/app/Http/Controllers/Front/ProductController.php:67royo_trendsetter
        Metadata
        Bindings
        • 0. gdr
        • 1. egypt-north-coast
        • 2. 1
        Backtrace
        • 16. /app/Http/Controllers/Front/ProductController.php:67
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `product_attributes` where `product_attributes`.`product_id` in (105) and `key_name` in ('Cabins', 'Berths', 'Baths')
        360μs/app/Http/Controllers/Front/ProductController.php:67royo_trendsetter
        Metadata
        Bindings
        • 0. Cabins
        • 1. Berths
        • 2. Baths
        Backtrace
        • 21. /app/Http/Controllers/Front/ProductController.php:67
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `processor_products` where `product_id` = 105 limit 1
        370μs/app/Http/Controllers/Front/ProductController.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:69
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `cart_products` where (`product_id` = 105) and exists (select * from `carts` where `cart_products`.`cart_id` = `carts`.`id` and (`unique_identifier` = 'uypDQVN0H5JLkfXip6D7QNaHr3uzkVEODrMbwhhm')) limit 1
        1.35ms/app/Http/Controllers/Front/ProductController.php:80royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        • 1. uypDQVN0H5JLkfXip6D7QNaHr3uzkVEODrMbwhhm
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:80
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from information_schema.tables where table_schema = 'royo_trendsetter' and table_name = 'product_attributes' and table_type = 'BASE TABLE'
        760μs/app/helpers.php:1537royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. product_attributes
        Backtrace
        • 10. /app/helpers.php:1537
        • 12. /app/Http/Controllers/Front/ProductController.php:95
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_rental_weekly_monthly_price
        Backtrace
        • 14. /app/helpers.php:69
        • 16. /app/Http/Controllers/Front/ProductController.php:95
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
        820μs/app/helpers.php:42royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. vendors
        Backtrace
        • 11. /app/helpers.php:42
        • 18. /app/Http/Traits/ProductTrait.php:81
        • 19. /app/Http/Controllers/Front/ProductController.php:95
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
        770μs/app/helpers.php:42royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. vendors
        Backtrace
        • 11. /app/helpers.php:42
        • 18. /app/Http/Traits/ProductTrait.php:81
        • 19. /app/Http/Controllers/Front/ProductController.php:95
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id`, `sku`, `inquiry_only`, `url_slug`, `weight`, `weight_unit`, `vendor_id`, `has_variant`, `has_inventory`, `averageRating`, `sell_when_out_of_stock`, `minimum_order_count`, `batch_count`, `additional_increments_min`, `minimum_duration_min`, `buffer_time_duration_min`, `minimum_duration`, `additional_increments`, `buffer_time_duration`, `tags`, `is_long_term_service`, `service_duration`, `returnable`, `replaceable`, `return_days`, `same_day_delivery`, `next_day_delivery`, `hyper_local_delivery`, `is_recurring_booking`, `security_amount`, `captain_name`, `calories`, `captain_profile`, `captain_description` from `products` where exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'egypt-north-coast' and `status` = 1) and `url_slug` = 'gdr' and `is_live` = 1 and `products`.`deleted_at` is null limit 1
        430μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Bindings
        • 0. egypt-north-coast
        • 1. 1
        • 2. gdr
        • 3. 1
        Backtrace
        • 16. /app/Http/Traits/ProductTrait.php:83
        • 17. /app/Http/Controllers/Front/ProductController.php:95
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `product_availability` where `product_availability`.`product_id` in (105)
        460μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id`, `sku`, `product_id`, `title`, `quantity`, `price`, `position`, `compare_at_price`, `barcode`, `cost_price`, `currency_id`, `tax_category_id`, `container_charges`, `markup_price`, `incremental_price`, `incremental_price_per_min`, `minimum_duration`, `week_price`, `month_price` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (105) group by `product_id` order by `id` asc
        440μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `product_variant_id`, `variant_option_id` from `product_variant_sets` inner join `variant_options` as `opt` on `opt`.`id` = `product_variant_sets`.`variant_option_id` inner join `variants` as `vari` on `vari`.`id` = `opt`.`variant_id` where `product_variant_sets`.`product_variant_id` in (109)
        510μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 26. /app/Http/Traits/ProductTrait.php:83
        • 27. /app/Http/Controllers/Front/ProductController.php:95
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `product_variant_id`, `product_image_id` from `product_variant_images` where `product_variant_images`.`product_variant_id` in (109)
        440μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 26. /app/Http/Traits/ProductTrait.php:83
        • 27. /app/Http/Controllers/Front/ProductController.php:95
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
        810μs/app/helpers.php:42royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. vendors
        Backtrace
        • 11. /app/helpers.php:42
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'
        780μs/app/helpers.php:42royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. vendors
        Backtrace
        • 11. /app/helpers.php:42
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 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 (5)
        300μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id`, `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (105)
        320μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (105) and `language_id` = 1
        420μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `product_addons`.`product_id`, `set`.`min_select`, `set`.`max_select`, `ast`.`title`, `product_addons`.`addon_id` from `product_addons` inner join `addon_sets` as `set` on `set`.`id` = `product_addons`.`addon_id` inner join `addon_set_translations` as `ast` on `ast`.`addon_id` = `set`.`id` where `product_addons`.`product_id` in (105) and `set`.`status` = 1 and `ast`.`language_id` = 1
        700μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `product_variant_sets`.`product_id`, `product_variant_sets`.`product_variant_id`, `product_variant_sets`.`variant_type_id`, `vr`.`type`, `vt`.`title`, `vr`.`position` 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 `product_variant_sets`.`product_id` in (105) and `vt`.`language_id` = 1 and `product_variant_sets`.`product_id` = 105 and `vr`.`status` = 1 group by `variant_type_id` order by `product_variant_id` asc, `vr`.`position` asc
        630μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 105
        • 2. 1
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `product_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (105)
        340μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `categories` where `deleted_at` is null and `categories`.`id` in (26) and `categories`.`deleted_at` is null
        400μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 26. /app/Http/Traits/ProductTrait.php:83
        • 27. /app/Http/Controllers/Front/ProductController.php:95
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id`, `slug`, `parent_id` from `categories` where `categories`.`id` in (1) and `categories`.`deleted_at` is null
        210μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 31. /app/Http/Traits/ProductTrait.php:83
        • 32. /app/Http/Controllers/Front/ProductController.php:95
        • 33. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 34. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 35. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id`, `slug`, `parent_id` from `categories` where 0 = 1 and `categories`.`deleted_at` is null
        170μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 36. /app/Http/Traits/ProductTrait.php:83
        • 37. /app/Http/Controllers/Front/ProductController.php:95
        • 38. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 39. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 40. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `long_term_service_periods` where `long_term_service_periods`.`product_id` in (105)
        390μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id`, `role_id`, `product_id`, `product_variant_id`, `amount`, `quantity` from `product_variant_by_roles` where `product_variant_by_roles`.`product_id` in (105)
        330μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `product_attributes` where `product_attributes`.`product_id` in (105)
        320μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter
        Metadata
        Backtrace
        • 21. /app/Http/Traits/ProductTrait.php:83
        • 22. /app/Http/Controllers/Front/ProductController.php:95
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `order_vendor_products` where `order_vendor_products`.`product_id` = 105 and `order_vendor_products`.`product_id` is not null
        450μs/app/Http/Controllers/Front/ProductController.php:98royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        Backtrace
        • 19. /app/Http/Controllers/Front/ProductController.php:98
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select DATE_FORMAT(date_time, "%Y-%m-%d") as formatted_date from `product_availability` where `product_id` = 105 and `not_available` = 0
        350μs/app/Http/Controllers/Front/ProductController.php:131royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        • 1. 0
        Backtrace
        • 13. /app/Http/Controllers/Front/ProductController.php:131
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `web_styling_options` where `is_selected` = 1 limit 1
        320μs/app/Http/Traits/ProductActionTrait.php:157royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. /app/Http/Traits/ProductActionTrait.php:157
        • 16. /app/Http/Controllers/Front/ProductController.php:133
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `client_currencies` where `currency_id` = 147 limit 1
        350μs/app/Http/Controllers/Front/ProductController.php:137royo_trendsetter
        Metadata
        Bindings
        • 0. 147
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:137
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `product_id`, `related_product_id` from `product_related` where `product_related`.`product_id` = 105 and `product_related`.`product_id` is not null
        330μs/app/Http/Controllers/Front/ProductController.php:144royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        Backtrace
        • 19. /app/Http/Controllers/Front/ProductController.php:144
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `id`, `sku`, `averageRating`, `url_slug`, `is_new`, `is_featured`, `vendor_id`, `inquiry_only`, `minimum_order_count`, `batch_count` from `products` where 0 = 1 and `category_id` is not null and `products`.`deleted_at` is null
        350μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter
        Metadata
        Backtrace
        • 14. /app/Http/Controllers/Front/FrontController.php:607
        • 15. /app/Http/Controllers/Front/ProductController.php:144
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select *, `created_at` as `time_zone_created_at` from `order_product_ratings` where (`product_id` = 105)
        350μs/app/Http/Controllers/Front/ProductController.php:146royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        Backtrace
        • 14. /app/Http/Controllers/Front/ProductController.php:146
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `client_currencies` where `currency_id` = 147 limit 1
        250μs/app/Http/Controllers/Front/FrontController.php:526royo_trendsetter
        Metadata
        Bindings
        • 0. 147
        Backtrace
        • 15. /app/Http/Controllers/Front/FrontController.php:526
        • 16. /app/Http/Controllers/Front/ProductController.php:173
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `business_type`, `p2p_check` from `client_preferences` limit 1
        280μs/app/helpers.php:1340royo_trendsetter
        Metadata
        Backtrace
        • 15. /app/helpers.php:1340
        • 25. /app/Http/Controllers/Front/FrontController.php:528
        • 26. /app/Http/Controllers/Front/ProductController.php:173
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')
        270μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_rental_weekly_monthly_price
        Backtrace
        • 14. /app/helpers.php:69
        • 25. /app/Http/Controllers/Front/FrontController.php:528
        • 26. /app/Http/Controllers/Front/ProductController.php:173
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_rental_weekly_monthly_price
        Backtrace
        • 14. /app/helpers.php:69
        • 25. /app/Http/Controllers/Front/FrontController.php:528
        • 26. /app/Http/Controllers/Front/ProductController.php:173
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `types` where `service_type` in ('products_service')
        300μs/app/helpers.php:1418royo_trendsetter
        Metadata
        Bindings
        • 0. products_service
        Backtrace
        • 13. /app/helpers.php:1418
        • 23. /app/Http/Controllers/Front/FrontController.php:528
        • 24. /app/Http/Controllers/Front/ProductController.php:173
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 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`, `minimum_duration_min` from `products` where exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `type_id` in (1, 3, 4, 5, 6, 11) and `categories`.`deleted_at` is null) and `is_new` = 1 and `vendor_id` in (5) and `is_live` = 1 and `category_id` is not null and `products`.`deleted_at` is null limit 6
        490μs/app/Http/Controllers/Front/FrontController.php:552royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 3
        • 2. 4
        • 3. 5
        • 4. 6
        • 5. 11
        • 6. 1
        • 7. 5
        • 8. 1
        Backtrace
        • 14. /app/Http/Controllers/Front/FrontController.php:552
        • 15. /app/Http/Controllers/Front/ProductController.php:173
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `categories` where `id` = 26 and `categories`.`deleted_at` is null limit 1
        280μs/app/Http/Controllers/Front/ProductController.php:183royo_trendsetter
        Metadata
        Bindings
        • 0. 26
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:183
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `product_variant_sets` where `product_id` = 105
        260μs/app/Http/Controllers/Front/ProductController.php:189royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        Backtrace
        • 14. /app/Http/Controllers/Front/ProductController.php:189
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `vendors` where `id` = 5 limit 1
        550μs/app/Http/Controllers/Front/ProductController.php:253royo_trendsetter
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:253
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `clients` limit 1
        300μs/app/Models/Vendor.php:107royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/Models/Vendor.php:107
        • 26. /app/Http/Controllers/Front/ProductController.php:253
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `clients` limit 1
        250μs/app/Models/VendorSlot.php:13royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/Models/VendorSlot.php:13
        • 26. /app/Models/Vendor.php:110
        • 34. /app/Http/Controllers/Front/ProductController.php:253
        • 35. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 36. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `vendor_slots` where exists (select * from `slot_days` where `vendor_slots`.`id` = `slot_days`.`slot_id` and `day` = 5) and `start_time` < '09:54:28' and `end_time` > '09:54:28' and `vendor_slots`.`vendor_id` in (5)
        560μs/app/Http/Controllers/Front/ProductController.php:253royo_trendsetter
        Metadata
        Bindings
        • 0. 5
        • 1. 09:54:28
        • 2. 09:54:28
        Backtrace
        • 20. /app/Http/Controllers/Front/ProductController.php:253
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `clients` limit 1
        240μs/app/Models/Vendor.php:133royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/Models/Vendor.php:133
        • 26. /app/Http/Controllers/Front/ProductController.php:253
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `vendor_slot_dates` where `specific_date` = '2025-06-19' and `start_time` < '09:54:28' and `end_time` > '09:54:28' and `vendor_slot_dates`.`vendor_id` in (5)
        400μs/app/Http/Controllers/Front/ProductController.php:253royo_trendsetter
        Metadata
        Bindings
        • 0. 2025-06-19
        • 1. 09:54:28
        • 2. 09:54:28
        Backtrace
        • 20. /app/Http/Controllers/Front/ProductController.php:253
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `web_styling_options` where `web_styling_id` = 1 and `is_selected` = 1 limit 1
        290μs/app/Http/Controllers/Front/ProductController.php:294royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:294
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `clients` where `clients`.`id` = 1 limit 1
        300μs/app/helpers.php:401royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. /app/helpers.php:401
        • 21. /app/Http/Controllers/Front/ProductController.php:353
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `promocodes`.`name`, `promocodes`.`short_desc`, `promo_types`.`title` as `promo_type_title`, `promocodes`.`amount`, `promocodes`.`promo_type_id` from `promocodes` inner join `promocode_details` on `promocode_details`.`promocode_id` = `promocodes`.`id` inner join `promo_types` on `promo_types`.`id` = `promocodes`.`promo_type_id` where date(`expiry_date`) >= '2025-06-19 09:54:28' and (`promocodes`.`promo_visibility` = 'public') and `promocodes`.`restriction_on` = '0' and `promocode_details`.`refrence_id` = 105
        690μs/app/Http/Controllers/Front/PromoCodeController.php:407royo_trendsetter
        Metadata
        Bindings
        • 0. 2025-06-19 09:54:28
        • 1. public
        • 2. 0
        • 3. 105
        Backtrace
        • 14. /app/Http/Controllers/Front/PromoCodeController.php:407
        • 15. /app/Http/Controllers/Front/ProductController.php:353
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `promocodes`.`name`, `promocodes`.`short_desc`, `promo_types`.`title` as `promo_type_title`, `promocodes`.`amount`, `promocodes`.`promo_type_id` from `promocodes` inner join `promocode_details` on `promocode_details`.`promocode_id` = `promocodes`.`id` inner join `promo_types` on `promo_types`.`id` = `promocodes`.`promo_type_id` where date(`expiry_date`) >= '2025-06-19 09:54:28' and (`promocodes`.`promo_visibility` = 'public') and `promocodes`.`restriction_on` = '1' and `promocode_details`.`refrence_id` = 5
        320μs/app/Http/Controllers/Front/PromoCodeController.php:410royo_trendsetter
        Metadata
        Bindings
        • 0. 2025-06-19 09:54:28
        • 1. public
        • 2. 1
        • 3. 5
        Backtrace
        • 14. /app/Http/Controllers/Front/PromoCodeController.php:410
        • 15. /app/Http/Controllers/Front/ProductController.php:353
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from information_schema.tables where table_schema = 'royo_trendsetter' and table_name = 'product_attributes' and table_type = 'BASE TABLE'
        900μs/app/helpers.php:1537royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. product_attributes
        Backtrace
        • 10. /app/helpers.php:1537
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from information_schema.tables where table_schema = 'royo_trendsetter' and table_name = 'attributes' and table_type = 'BASE TABLE'
        660μs/app/helpers.php:1537royo_trendsetter
        Metadata
        Bindings
        • 0. royo_trendsetter
        • 1. attributes
        Backtrace
        • 10. /app/helpers.php:1537
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select count(*) as aggregate from `product_bookings` where exists (select * from `order_vendor_products` where `product_bookings`.`id` = `order_vendor_products`.`product_id` and exists (select * from `products` where `order_vendor_products`.`product_id` = `products`.`id` and `vendor_id` = 5)) and `product_bookings`.`deleted_at` is null
        820μs/app/Http/Controllers/Front/ProductController.php:447royo_trendsetter
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:447
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `web_styling_options` where `is_selected` = '1' limit 1
        220μs/app/Http/Controllers/Front/ProductController.php:448royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. /app/Http/Controllers/Front/ProductController.php:448
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `socket_url` from `clients` limit 1
        190μsview::260b530978e2d26a05e9deffacb2be4fe2714a92:2royo_trendsetter
        Metadata
        Backtrace
        • 15. view::260b530978e2d26a05e9deffacb2be4fe2714a92:2
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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` = 26 and `category_translations`.`category_id` is not null and `cl`.`is_active` = 1 order by `cl`.`is_primary` desc
        650μsview::ca7331e0bfe740c9224affdf4010864bad4c04ee:4royo_trendsetter
        Metadata
        Bindings
        • 0. 26
        • 1. 1
        Backtrace
        • 19. view::ca7331e0bfe740c9224affdf4010864bad4c04ee:4
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_token_currency_enable', 'token_currency', 'add_to_cart_btn')
        280μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_token_currency_enable
        • 1. token_currency
        • 2. add_to_cart_btn
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `vendor_id`, `tax_category_id` from `products` where `id` = 105 and `products`.`deleted_at` is null limit 1
        260μs/app/Models/ProductVariant.php:163royo_trendsetter
        Metadata
        Bindings
        • 0. 105
        Backtrace
        • 15. /app/Models/ProductVariant.php:163
        • 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 19. /app/Models/ProductVariant.php:164
        • 25. view::260b530978e2d26a05e9deffacb2be4fe2714a92:269
      • select `add_markup_price` from `vendors` where `id` = 5 limit 1
        240μs/app/Models/ProductVariant.php:168royo_trendsetter
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 16. /app/Models/ProductVariant.php:168
        • 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 20. /app/Models/ProductVariant.php:169
        • 26. view::260b530978e2d26a05e9deffacb2be4fe2714a92:269
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_attribute
        Backtrace
        • 14. /app/helpers.php:69
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        290μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 15. /app/helpers.php:1641
        • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        190μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/helpers.php:1641
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_attribute
        Backtrace
        • 14. /app/helpers.php:69
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_attribute
        Backtrace
        • 14. /app/helpers.php:69
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        280μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 15. /app/helpers.php:1641
        • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        190μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/helpers.php:1641
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_rental_weekly_monthly_price
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_attribute
        Backtrace
        • 14. /app/helpers.php:69
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        190μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 15. /app/helpers.php:1641
        • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        180μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/helpers.php:1641
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `web_styling_options` where `web_styling_id` = 1 and `is_selected` = 1 limit 1
        300μsview::bb0070d6e826c961912540be5a168503b5efb22b:2royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 15. view::bb0070d6e826c961912540be5a168503b5efb22b:2
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('enable_pwa')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. enable_pwa
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_enable_google_analytics')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_enable_google_analytics
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. gtag_id
        • 1. fpixel_id
        • 2. is_service_product_price_from_dispatch
        • 3. is_service_price_selection
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `logo`, `dark_logo` from `clients` where `id` > 0 limit 1
        300μsview::41442c3efe13e76810609d24351acde26798236b:4royo_trendsetter
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 15. view::41442c3efe13e76810609d24351acde26798236b:4
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `client_languages` where `is_active` = 1 order by `is_primary` desc
        240μsview::41442c3efe13e76810609d24351acde26798236b:21royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 14. view::41442c3efe13e76810609d24351acde26798236b:21
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 8)
        220μsview::41442c3efe13e76810609d24351acde26798236b:21royo_trendsetter
        Metadata
        Backtrace
        • 19. view::41442c3efe13e76810609d24351acde26798236b:21
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `client_currencies` order by `is_primary` desc
        320μsview::41442c3efe13e76810609d24351acde26798236b:24royo_trendsetter
        Metadata
        Backtrace
        • 14. view::41442c3efe13e76810609d24351acde26798236b:24
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (1, 147)
        330μsview::41442c3efe13e76810609d24351acde26798236b:24royo_trendsetter
        Metadata
        Backtrace
        • 19. view::41442c3efe13e76810609d24351acde26798236b:24
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        590μsview::41442c3efe13e76810609d24351acde26798236b:34royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. view::41442c3efe13e76810609d24351acde26798236b:34
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 3, 4, 5) and `language_id` = 1
        360μsview::41442c3efe13e76810609d24351acde26798236b:34royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. view::41442c3efe13e76810609d24351acde26798236b:34
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `logo` from `clients` where `id` > 0 limit 1
        270μsview::f220542288b705a90d5521ad395f8225d7ef8a76:2royo_trendsetter
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 15. view::f220542288b705a90d5521ad395f8225d7ef8a76:2
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `client_languages` where `is_active` = 1 order by `is_primary` desc
        230μsview::f220542288b705a90d5521ad395f8225d7ef8a76:4royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 14. view::f220542288b705a90d5521ad395f8225d7ef8a76:4
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 8)
        210μsview::f220542288b705a90d5521ad395f8225d7ef8a76:4royo_trendsetter
        Metadata
        Backtrace
        • 19. view::f220542288b705a90d5521ad395f8225d7ef8a76:4
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `client_currencies` order by `is_primary` desc
        210μsview::f220542288b705a90d5521ad395f8225d7ef8a76:5royo_trendsetter
        Metadata
        Backtrace
        • 14. view::f220542288b705a90d5521ad395f8225d7ef8a76:5
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (1, 147)
        210μsview::f220542288b705a90d5521ad395f8225d7ef8a76:5royo_trendsetter
        Metadata
        Backtrace
        • 19. view::f220542288b705a90d5521ad395f8225d7ef8a76:5
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        400μsview::f220542288b705a90d5521ad395f8225d7ef8a76:6royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. view::f220542288b705a90d5521ad395f8225d7ef8a76:6
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 3, 4, 5) and `language_id` = 1
        320μsview::f220542288b705a90d5521ad395f8225d7ef8a76:6royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. view::f220542288b705a90d5521ad395f8225d7ef8a76:6
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_user_pre_signup')
        230μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_user_pre_signup
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_attribute
        Backtrace
        • 14. /app/helpers.php:69
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        210μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 15. /app/helpers.php:1641
        • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `p2p_check` from `client_preferences` limit 1
        180μs/app/helpers.php:1641royo_trendsetter
        Metadata
        Backtrace
        • 18. /app/helpers.php:1641
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `nomenclatures` where `label` LIKE '%Search%' limit 1
        330μs/app/helpers.php:380royo_trendsetter
        Metadata
        Bindings
        • 0. %Search%
        Backtrace
        • 15. /app/helpers.php:380
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (13) and `language_id` = 1
        340μs/app/helpers.php:380royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 20. /app/helpers.php:380
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `nomenclatures` where `label` LIKE '%Search product,\n vendor, item%' limit 1
        240μs/app/helpers.php:380royo_trendsetter
        Metadata
        Bindings
        • 0. %Search product, vendor, item%
        Backtrace
        • 15. /app/helpers.php:380
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `clients` where `id` > 0 limit 1
        340μsview::89b38f5c702e4146c7d59b11d7934d7718826251:2royo_trendsetter
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 15. view::89b38f5c702e4146c7d59b11d7934d7718826251:2
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        390μsview::89b38f5c702e4146c7d59b11d7934d7718826251:4royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. view::89b38f5c702e4146c7d59b11d7934d7718826251:4
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 3, 4, 5) and `language_id` = 1
        340μsview::89b38f5c702e4146c7d59b11d7934d7718826251:4royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. view::89b38f5c702e4146c7d59b11d7934d7718826251:4
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `client_languages` where `is_active` = 1 order by `is_primary` desc
        250μsview::89b38f5c702e4146c7d59b11d7934d7718826251:9royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 14. view::89b38f5c702e4146c7d59b11d7934d7718826251:9
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 8)
        250μsview::89b38f5c702e4146c7d59b11d7934d7718826251:9royo_trendsetter
        Metadata
        Backtrace
        • 19. view::89b38f5c702e4146c7d59b11d7934d7718826251:9
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `client_currencies` order by `is_primary` desc
        210μsview::89b38f5c702e4146c7d59b11d7934d7718826251:10royo_trendsetter
        Metadata
        Backtrace
        • 14. view::89b38f5c702e4146c7d59b11d7934d7718826251:10
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (1, 147)
        220μsview::89b38f5c702e4146c7d59b11d7934d7718826251:10royo_trendsetter
        Metadata
        Backtrace
        • 19. view::89b38f5c702e4146c7d59b11d7934d7718826251:10
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `payment_methods` where `is_show` = 1
        330μsview::89b38f5c702e4146c7d59b11d7934d7718826251:12royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 14. view::89b38f5c702e4146c7d59b11d7934d7718826251:12
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `client_preference_additional` where `key_name` = 'bottom_name' limit 1
        240μsview::89b38f5c702e4146c7d59b11d7934d7718826251:13royo_trendsetter
        Metadata
        Bindings
        • 0. bottom_name
        Backtrace
        • 15. view::89b38f5c702e4146c7d59b11d7934d7718826251:13
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        330μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        310μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter
        Metadata
        Bindings
        • 0. 2
        • 1. 1
        Backtrace
        • 21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        320μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter
        Metadata
        Bindings
        • 0. 3
        • 1. 1
        Backtrace
        • 21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        320μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter
        Metadata
        Bindings
        • 0. 4
        • 1. 1
        Backtrace
        • 21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • 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
        310μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter
        Metadata
        Bindings
        • 0. 5
        • 1. 1
        Backtrace
        • 21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `show_subscription_plan_on_signups` where `show_subscription_plan_on_signups`.`id` = 1 limit 1
        350μs/app/helpers.php:184royo_trendsetter
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. /app/helpers.php:184
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_map_search_perticular_country')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_map_search_perticular_country
        Backtrace
        • 14. /app/helpers.php:69
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_service_product_price_from_dispatch', 'is_service_price_selection')
        240μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. is_service_product_price_from_dispatch
        • 1. is_service_price_selection
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `credentials`, `test_mode` from `payment_options` where `code` = 'razorpay' and `status` = 1 limit 1
        320μs/app/helpers.php:443royo_trendsetter
        Metadata
        Bindings
        • 0. razorpay
        • 1. 1
        Backtrace
        • 15. /app/helpers.php:443
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `credentials`, `test_mode` from `payment_options` where `code` = 'khalti' and `status` = 1 limit 1
        250μs/app/helpers.php:456royo_trendsetter
        Metadata
        Bindings
        • 0. khalti
        • 1. 1
        Backtrace
        • 15. /app/helpers.php:456
        • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('enable_pwa')
        220μs/app/helpers.php:69royo_trendsetter
        Metadata
        Bindings
        • 0. enable_pwa
        Backtrace
        • 14. /app/helpers.php:69
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      App\Models\ShowSubscriptionPlanOnSignup
      1
      App\Models\Language
      7
      App\Models\ClientCurrency
      9
      App\Models\Currency
      7
      App\Models\Client
      11
      App\Models\Country
      1
      App\Models\ClientPreferenceAdditional
      18
      App\Models\Type
      12
      App\Models\Vendor
      8
      App\Models\Category
      7
      App\Models\ClientLanguage
      8
      App\Models\Product
      3
      App\Models\ProductVariant
      1
      App\Models\ProductTranslation
      1
      App\Models\ProductCategory
      1
      App\Models\WebStylingOption
      4
      App\Models\Category_translation
      1
      App\Models\Page
      15
      App\Models\PageTranslation
      20
      App\Models\Nomenclature
      1
      App\Models\PaymentMethod
      5
      App\Models\ProcessorProduct
      1
      App\Models\ClientPreference
      12
          _token
          uypDQVN0H5JLkfXip6D7QNaHr3uzkVEODrMbwhhm
          client_config
          {#4384 +"name": "trendsetter" +"email": "admin@trendsetter.com" +"phone_number": "07887898989"...
          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 {#4004 #fillable: array:102 [ 0 => "client_code" 1 => "theme_a...
          clientdata
          App\Models\Client {#4386 #guard: "client" #fillable: array:28 [ 0 => "name" 1 => "email"...
          userCode
          37447b
          vendors
          array:5 [ 0 => 2 1 => 3 2 => 4 3 => 5 4 => 6 ]
          _previous
          array:1 [ "url" => "https://trendsetter.ae/egypt-north-coast/product/gdr" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /egypt-north-coast/product/gdr
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "host" => array:1 [ 0 => "trendsetter.ae" ] ]
          request_server
          0 of 0
          array: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" => "34645" "REMOTE_ADDR" => "216.73.216.58" "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" => "/egypt-north-coast/product/gdr" "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" => 1750326867.9995 "REQUEST_TIME" => 1750326867 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 19 Jun 2025 09:54:28 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im16THJFRDlZc3oyejllVFBMU21rUmc9PSIsInZhbHVlIjoiaWhZcEJheVN6d3pLNGZvUEJsdmJpNmRvWWY1TmpXY2ZZNDdRTVNodVF0TVpYL2tZbXdiazdUemRjZGpvV0crNnhRRWt5UDQxVjh0Q0RDQTFhWDNQU1UrTkZkV1IxZjVIQXhWVk1LYlg0UkFPSGdaTGcwWStPallFaS9TQkxpcGkiLCJtYWMiOiIzZTAyZGFiNzQyYTIwOWM1M2I5YzFiYWI4Y2YwMDBmODY0ZTU3NjBlZjhlMzI5ZmE1OWE1Yjg4NGRlMGI4MGRmIiwidGFnIjoiIn0%3D; expires=Fri, 19-Jun-2026 09:54:28 GMT; Max-Age=31536000; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Im16THJFRDlZc3oyejllVFBMU21rUmc9PSIsInZhbHVlIjoiaWhZcEJheVN6d3pLNGZvUEJsdmJpNmRvWWY1TmpXY2ZZNDdRTVNodVF0TVpYL2tZbXdiazdUemRjZGpvV0crNnhRRWt5U" 1 => "trendsetter_session=eyJpdiI6ImNSUEZGYVZXb0I5QW15Zi9GZUVnMWc9PSIsInZhbHVlIjoiTzRteWZjeFNEUlJtMGhabjd3MUhVQ2ZyeDVBTjJSTTJ0YmVtNWNPNEMyWlJBN2R4b0Y2TGJFeHBhUC9RdjFMYkFQTDJPdHlSNE9WNk5hdnZOLy9vWlREd1grNzRJREFzVTNjMm5ieGFtcEcySVEvU3IyeUR5YjdHR2VOQnRScEYiLCJtYWMiOiJmNjJlNDdhYTBkZTU1Y2NlMDE5MjljOTBiOGMxY2MyOWZlMWFiNWI0YzAyMDE3YWYwZTllN2IxNGVjOWZlZmJmIiwidGFnIjoiIn0%3D; expires=Fri, 19-Jun-2026 09:54:28 GMT; Max-Age=31536000; path=/; httponly; samesite=laxtrendsetter_session=eyJpdiI6ImNSUEZGYVZXb0I5QW15Zi9GZUVnMWc9PSIsInZhbHVlIjoiTzRteWZjeFNEUlJtMGhabjd3MUhVQ2ZyeDVBTjJSTTJ0YmVtNWNPNEMyWlJBN2R4b0Y2TGJFeHBhUC9RdjFM" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im16THJFRDlZc3oyejllVFBMU21rUmc9PSIsInZhbHVlIjoiaWhZcEJheVN6d3pLNGZvUEJsdmJpNmRvWWY1TmpXY2ZZNDdRTVNodVF0TVpYL2tZbXdiazdUemRjZGpvV0crNnhRRWt5UDQxVjh0Q0RDQTFhWDNQU1UrTkZkV1IxZjVIQXhWVk1LYlg0UkFPSGdaTGcwWStPallFaS9TQkxpcGkiLCJtYWMiOiIzZTAyZGFiNzQyYTIwOWM1M2I5YzFiYWI4Y2YwMDBmODY0ZTU3NjBlZjhlMzI5ZmE1OWE1Yjg4NGRlMGI4MGRmIiwidGFnIjoiIn0%3D; expires=Fri, 19-Jun-2026 09:54:28 GMT; path=/XSRF-TOKEN=eyJpdiI6Im16THJFRDlZc3oyejllVFBMU21rUmc9PSIsInZhbHVlIjoiaWhZcEJheVN6d3pLNGZvUEJsdmJpNmRvWWY1TmpXY2ZZNDdRTVNodVF0TVpYL2tZbXdiazdUemRjZGpvV0crNnhRRWt5U" 1 => "trendsetter_session=eyJpdiI6ImNSUEZGYVZXb0I5QW15Zi9GZUVnMWc9PSIsInZhbHVlIjoiTzRteWZjeFNEUlJtMGhabjd3MUhVQ2ZyeDVBTjJSTTJ0YmVtNWNPNEMyWlJBN2R4b0Y2TGJFeHBhUC9RdjFMYkFQTDJPdHlSNE9WNk5hdnZOLy9vWlREd1grNzRJREFzVTNjMm5ieGFtcEcySVEvU3IyeUR5YjdHR2VOQnRScEYiLCJtYWMiOiJmNjJlNDdhYTBkZTU1Y2NlMDE5MjljOTBiOGMxY2MyOWZlMWFiNWI0YzAyMDE3YWYwZTllN2IxNGVjOWZlZmJmIiwidGFnIjoiIn0%3D; expires=Fri, 19-Jun-2026 09:54:28 GMT; path=/; httponlytrendsetter_session=eyJpdiI6ImNSUEZGYVZXb0I5QW15Zi9GZUVnMWc9PSIsInZhbHVlIjoiTzRteWZjeFNEUlJtMGhabjd3MUhVQ2ZyeDVBTjJSTTJ0YmVtNWNPNEMyWlJBN2R4b0Y2TGJFeHBhUC9RdjFM" ] ]
          session_attributes
          0 of 0
          array:21 [ "_token" => "uypDQVN0H5JLkfXip6D7QNaHr3uzkVEODrMbwhhm" "client_config" => {#4384 +"name": "trendsetter" +"email": "admin@trendsetter.com" +"phone_number": "07887898989" +"is_deleted": 0 +"is_blocked": 0 +"logo": {#4385 +"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 {#4004 #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 {#4386 #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/egypt-north-coast/product/gdr" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          BESbswy