/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/X5eb1d9a2447448826914e37c044dee18.json (36784B)
{"__meta":{"id":"X5eb1d9a2447448826914e37c044dee18","datetime":"2021-07-28 01:30:27","utime":1627435827.377289,"method":"GET","uri":"\/ajax\/featured-products","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627435825.386478,"end":1627435827.377401,"duration":1.9909231662750244,"duration_str":"1.99s","measures":[{"label":"Booting","start":1627435825.386478,"relative_start":0,"end":1627435826.787866,"relative_end":1627435826.787866,"duration":1.401388168334961,"duration_str":"1.4s","params":[],"collector":null},{"label":"Application","start":1627435826.79531,"relative_start":1.40883207321167,"end":1627435827.377416,"relative_end":1.4781951904296875e-5,"duration":0.5821058750152588,"duration_str":"582ms","params":[],"collector":null}]},"memory":{"peak_usage":36421264,"peak_usage_str":"35MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":10,"templates":[{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"},{"name":"theme.shopwise::partials.product-item (platform\/themes\/shopwise\/partials\/product-item.blade.php)","param_count":1,"params":["product"],"type":"blade"}]},"route":{"uri":"GET ajax\/featured-products","middleware":"web, core","controller":"Theme\\Shopwise\\Http\\Controllers\\ShopwiseController@ajaxGetFeaturedProducts","namespace":"Theme\\Shopwise\\Http\\Controllers","prefix":null,"where":[],"as":"public.ajax.featured-products","file":"platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:151-191"},"queries":{"nb_statements":10,"nb_failed_statements":0,"accumulated_duration":0.02033,"accumulated_duration_str":"20.33ms","statements":[{"sql":"select `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(star) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg` from `ec_products` where `ec_products`.`is_featured` = 1 and `ec_products`.`is_variation` = 0 and `ec_products`.`status` = 'published' order by `ec_products`.`created_at` desc limit 10","type":"query","params":[],"bindings":["published","published","1","0","published"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":17,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":272},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":145},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.00271,"duration_str":"2.71ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":0,"width_percent":13.33},{"sql":"select * from `slugs` where `slugs`.`reference_id` in (5, 6, 7, 8, 9, 10, 11, 12, 13, 14) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product'","type":"query","params":[],"bindings":["Botble\\Ecommerce\\Models\\Product"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":22,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":272},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":145},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.00106,"duration_str":"1.06ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":13.33,"width_percent":5.214},{"sql":"select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` in (5, 6, 7, 8, 9, 10, 11, 12, 13, 14)","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":22,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":272},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":145},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.00623,"duration_str":"6.23ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":18.544,"width_percent":30.644},{"sql":"select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` in (5, 6, 7, 8, 9, 10, 11, 12, 13, 14)","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":21,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":272},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":145},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.0008,"duration_str":"800\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":49.188,"width_percent":3.935},{"sql":"select `ec_product_attributes`.*, `ec_product_variations`.*, `ec_product_variation_items`.*, `ec_product_attribute_sets`.*, `ec_product_attributes`.`title` as `attribute_title` from `ec_product_variations` inner join `ec_product_variation_items` on `ec_product_variation_items`.`variation_id` = `ec_product_variations`.`id` inner join `ec_product_attributes` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` inner join `ec_product_attribute_sets` on `ec_product_attribute_sets`.`id` = `ec_product_attributes`.`attribute_set_id` where `ec_product_attribute_sets`.`status` = 'published' and `ec_product_attribute_sets`.`is_use_in_product_listing` = 1 and `ec_product_variations`.`configurable_product_id` in (5, 6, 7, 8, 9, 10, 11, 12, 13, 14)","type":"query","params":[],"bindings":["published","1"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":22,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":272},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":145},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.00451,"duration_str":"4.51ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":53.123,"width_percent":22.184},{"sql":"select * from `ec_customers` where `id` = '1' limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":68},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":179},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":149},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":575}],"duration":0.00158,"duration_str":"1.58ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":75.307,"width_percent":7.772},{"sql":"select `ec_discounts`.*, `ec_discount_products`.`product_id` as `pivot_product_id`, `ec_discount_products`.`discount_id` as `pivot_discount_id` from `ec_discounts` inner join `ec_discount_products` on `ec_discounts`.`id` = `ec_discount_products`.`discount_id` left join `ec_discount_product_collections` on `ec_discounts`.`id` = `ec_discount_product_collections`.`discount_id` left join `ec_discount_customers` on `ec_discounts`.`id` = `ec_discount_customers`.`discount_id` where `type` = 'promotion' and `start_date` <= '2021-07-28 01:30:26' and (((`target` = 'specific-product' or `target` = 'product-variant') and `ec_discount_products`.`product_id` is null) or (`target` = 'group-products' and 0 = 1) or (`target` = 'customer' and `ec_discount_customers`.`customer_id` = -1)) and (`end_date` is null or `end_date` >= '2021-07-28 01:30:27') and `product_quantity` = 1 and `ec_discount_products`.`product_id` in (5, 6, 7, 8, 9, 10, 11, 12, 13, 14)","type":"query","params":[],"bindings":["promotion","2021-07-28 01:30:26","specific-product","product-variant","group-products","customer","-1","2021-07-28 01:30:27","1"],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":21,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":272},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":145},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.00115,"duration_str":"1.15ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":83.079,"width_percent":5.657},{"sql":"select `ec_flash_sales`.*, `ec_flash_sale_products`.`product_id` as `pivot_product_id`, `ec_flash_sale_products`.`flash_sale_id` as `pivot_flash_sale_id`, `ec_flash_sale_products`.`price` as `pivot_price`, `ec_flash_sale_products`.`quantity` as `pivot_quantity`, `ec_flash_sale_products`.`sold` as `pivot_sold` from `ec_flash_sales` inner join `ec_flash_sale_products` on `ec_flash_sales`.`id` = `ec_flash_sale_products`.`flash_sale_id` where `status` = 'published' and `end_date` >= '2021-07-28' and `ec_flash_sale_products`.`product_id` in (5, 6, 7, 8, 9, 10, 11, 12, 13, 14) order by `created_at` desc","type":"query","params":[],"bindings":["published","2021-07-28"],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":21,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":272},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":145},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.00098,"duration_str":"980\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":88.736,"width_percent":4.82},{"sql":"select * from `ec_currencies` where `is_default` = 1 limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":260},{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":168},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/CurrencySupport.php","line":82},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/CurrencySupport.php","line":57},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/currencies.php","line":147}],"duration":0.00062,"duration_str":"620\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":93.556,"width_percent":3.05},{"sql":"select * from `users` where `id` = '1' limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":68},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":179},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":149},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","line":54},{"index":23,"namespace":null,"name":"\/platform\/packages\/theme\/src\/Http\/Middleware\/AdminBarMiddleware.php","line":54}],"duration":0.00069,"duration_str":"690\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":96.606,"width_percent":3.394}]},"models":{"data":{"Botble\\ACL\\Models\\User":1,"Botble\\Ecommerce\\Models\\Currency":1,"Botble\\Ecommerce\\Models\\FlashSale":2,"Botble\\Ecommerce\\Models\\Customer":1,"Botble\\Ecommerce\\Models\\ProductLabel":3,"Botble\\Ecommerce\\Models\\ProductVariation":84,"Botble\\Slug\\Models\\Slug":10,"Botble\\Ecommerce\\Models\\Product":10},"count":112},"swiftmailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"ZOMUza2rN2cWiNPvsr1Y6NAuNwAZPnkiy3BsxCw9","_previous":"array:1 [\n \"url\" => \"http:\/\/shopwise.local\"\n]","_flash":"array:2 [\n \"old\" => []\n \"new\" => []\n]"},"request":{"path_info":"\/ajax\/featured-products","status_code":"
200<\/span>\n<\/pre>