/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/Xb91f98dbde798e36be6fa65e0d72d07a.json (36693B)
{"__meta":{"id":"Xb91f98dbde798e36be6fa65e0d72d07a","datetime":"2021-07-28 01:30:27","utime":1627435827.254374,"method":"GET","uri":"\/ajax\/on-sale-products","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627435825.657752,"end":1627435827.254618,"duration":1.5968658924102783,"duration_str":"1.6s","measures":[{"label":"Booting","start":1627435825.657752,"relative_start":0,"end":1627435826.806578,"relative_end":1627435826.806578,"duration":1.1488258838653564,"duration_str":"1.15s","params":[],"collector":null},{"label":"Application","start":1627435826.815838,"relative_start":1.1580860614776611,"end":1627435827.254639,"relative_end":2.09808349609375e-5,"duration":0.4388008117675781,"duration_str":"439ms","params":[],"collector":null}]},"memory":{"peak_usage":36323224,"peak_usage_str":"35MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":7,"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"}]},"route":{"uri":"GET ajax\/on-sale-products","middleware":"web, core","controller":"Theme\\Shopwise\\Http\\Controllers\\ShopwiseController@ajaxGetOnSaleProducts","namespace":"Theme\\Shopwise\\Http\\Controllers","prefix":null,"where":[],"as":"public.ajax.on-sale-products","file":"platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:240-279"},"queries":{"nb_statements":10,"nb_failed_statements":0,"accumulated_duration":0.02301,"accumulated_duration_str":"23.01ms","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 ((`sale_type` = 0 and `sale_price` > 0) or ((`sale_type` = 1 and `start_date` is not null and `end_date` is not null and `start_date` <= '2021-07-28 01:30:26' and `end_date` >= '2021-07-28 00:00:00') or (`sale_type` = 1 and `start_date` is not null and `start_date` <= '2021-07-28 01:30:26' and `end_date` is null))) and `ec_products`.`status` = 'published' and `ec_products`.`is_variation` = 0 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 10","type":"query","params":[],"bindings":["published","published","0","0","1","2021-07-28 01:30:26","2021-07-28 00:00:00","1","2021-07-28 01:30:26","published","0"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":414},{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":422},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":216},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":120},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.01342,"duration_str":"13.42ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":0,"width_percent":58.322},{"sql":"select * from `slugs` where `slugs`.`reference_id` in (4, 8, 12, 16, 20, 24, 28) 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":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":422},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":216},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":120},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00087,"duration_str":"870\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":58.322,"width_percent":3.781},{"sql":"select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` in (4, 8, 12, 16, 20, 24, 28)","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":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":422},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":216},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":120},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00073,"duration_str":"730\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":62.103,"width_percent":3.173},{"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 (4, 8, 12, 16, 20, 24, 28)","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":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":422},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":216},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":120},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00079,"duration_str":"790\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":65.276,"width_percent":3.433},{"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 (4, 8, 12, 16, 20, 24, 28)","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":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":422},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":216},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":120},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.0028799999999999997,"duration_str":"2.88ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":68.709,"width_percent":12.516},{"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.00063,"duration_str":"630\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":81.226,"width_percent":2.738},{"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:27' 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 (4, 8, 12, 16, 20, 24, 28)","type":"query","params":[],"bindings":["promotion","2021-07-28 01:30:27","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":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":422},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":216},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":120},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00103,"duration_str":"1.03ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":83.963,"width_percent":4.476},{"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 (4, 8, 12, 16, 20, 24, 28) 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":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":422},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":216},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":120},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00082,"duration_str":"820\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":88.44,"width_percent":3.564},{"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.0006,"duration_str":"600\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":92.003,"width_percent":2.608},{"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.00124,"duration_str":"1.24ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":94.611,"width_percent":5.389}]},"models":{"data":{"Botble\\ACL\\Models\\User":1,"Botble\\Ecommerce\\Models\\Currency":1,"Botble\\Ecommerce\\Models\\FlashSale":1,"Botble\\Ecommerce\\Models\\Customer":1,"Botble\\Ecommerce\\Models\\ProductLabel":2,"Botble\\Ecommerce\\Models\\ProductVariation":72,"Botble\\Slug\\Models\\Slug":7,"Botble\\Ecommerce\\Models\\Product":7},"count":92},"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\/on-sale-products","status_code":"
200<\/span>\n<\/pre>