/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/X10bf8287a7be594ecc5a7faff3555a52.json (36770B)
{"__meta":{"id":"X10bf8287a7be594ecc5a7faff3555a52","datetime":"2021-07-28 01:30:25","utime":1627435825.257944,"method":"GET","uri":"\/ajax\/trending-products","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627435822.91511,"end":1627435825.258044,"duration":2.3429338932037354,"duration_str":"2.34s","measures":[{"label":"Booting","start":1627435822.91511,"relative_start":0,"end":1627435824.033859,"relative_end":1627435824.033859,"duration":1.1187489032745361,"duration_str":"1.12s","params":[],"collector":null},{"label":"Application","start":1627435824.046553,"relative_start":1.1314427852630615,"end":1627435825.258059,"relative_end":1.5020370483398438e-5,"duration":1.2115061283111572,"duration_str":"1.21s","params":[],"collector":null}]},"memory":{"peak_usage":36536568,"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\/trending-products","middleware":"web, core","controller":"Theme\\Shopwise\\Http\\Controllers\\ShopwiseController@ajaxGetTrendingProducts","namespace":"Theme\\Shopwise\\Http\\Controllers","prefix":null,"where":[],"as":"public.ajax.trending-products","file":"platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:93-128"},"queries":{"nb_statements":10,"nb_failed_statements":0,"accumulated_duration":0.09111999999999999,"accumulated_duration_str":"91.12ms","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`.`status` = 'published' and `ec_products`.`is_variation` = 0 order by `ec_products`.`views` desc limit 10","type":"query","params":[],"bindings":["published","published","published","0"],"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":230},{"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.038759999999999996,"duration_str":"38.76ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":0,"width_percent":42.537},{"sql":"select * from `slugs` where `slugs`.`reference_id` in (1, 4, 7, 9, 14, 16, 17, 20, 26, 27) 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":230},{"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.0007700000000000001,"duration_str":"770\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":42.537,"width_percent":0.845},{"sql":"select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` in (1, 4, 7, 9, 14, 16, 17, 20, 26, 27)","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":230},{"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.00279,"duration_str":"2.79ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":43.382,"width_percent":3.062},{"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 (1, 4, 7, 9, 14, 16, 17, 20, 26, 27)","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":230},{"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.024579999999999998,"duration_str":"24.58ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":46.444,"width_percent":26.975},{"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 (1, 4, 7, 9, 14, 16, 17, 20, 26, 27)","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":230},{"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.00532,"duration_str":"5.32ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":73.42,"width_percent":5.838},{"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.00204,"duration_str":"2.04ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":79.258,"width_percent":2.239},{"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:24' 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:24') and `product_quantity` = 1 and `ec_discount_products`.`product_id` in (1, 4, 7, 9, 14, 16, 17, 20, 26, 27)","type":"query","params":[],"bindings":["promotion","2021-07-28 01:30:24","specific-product","product-variant","group-products","customer","-1","2021-07-28 01:30:24","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":230},{"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.010960000000000001,"duration_str":"10.96ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":81.497,"width_percent":12.028},{"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 (1, 4, 7, 9, 14, 16, 17, 20, 26, 27) 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":230},{"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.00438,"duration_str":"4.38ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":93.525,"width_percent":4.807},{"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.00074,"duration_str":"740\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":98.332,"width_percent":0.812},{"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.00078,"duration_str":"780\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":99.144,"width_percent":0.856}]},"models":{"data":{"Botble\\ACL\\Models\\User":1,"Botble\\Ecommerce\\Models\\Currency":1,"Botble\\Ecommerce\\Models\\Customer":1,"Botble\\Ecommerce\\Models\\ProductLabel":2,"Botble\\Ecommerce\\Models\\ProductVariation":84,"Botble\\Slug\\Models\\Slug":10,"Botble\\Ecommerce\\Models\\Product":10},"count":109},"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\/trending-products","status_code":"
200<\/span>\n<\/pre>