/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/X9d3bf231f8e9438379fa42fefc0df7b6.json (36673B)
{"__meta":{"id":"X9d3bf231f8e9438379fa42fefc0df7b6","datetime":"2021-07-28 01:30:27","utime":1627435827.194143,"method":"GET","uri":"\/ajax\/top-rated-products","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627435825.444014,"end":1627435827.194194,"duration":1.7501800060272217,"duration_str":"1.75s","measures":[{"label":"Booting","start":1627435825.444014,"relative_start":0,"end":1627435826.80272,"relative_end":1627435826.80272,"duration":1.358705997467041,"duration_str":"1.36s","params":[],"collector":null},{"label":"Application","start":1627435826.81091,"relative_start":1.3668959140777588,"end":1627435827.194201,"relative_end":6.9141387939453125e-6,"duration":0.38329100608825684,"duration_str":"383ms","params":[],"collector":null}]},"memory":{"peak_usage":36131904,"peak_usage_str":"34MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":3,"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"}]},"route":{"uri":"GET ajax\/top-rated-products","middleware":"web, core","controller":"Theme\\Shopwise\\Http\\Controllers\\ShopwiseController@ajaxGetTopRatedProducts","namespace":"Theme\\Shopwise\\Http\\Controllers","prefix":null,"where":[],"as":"public.ajax.top-rated-products","file":"platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:198-233"},"queries":{"nb_statements":11,"nb_failed_statements":0,"accumulated_duration":0.01598,"accumulated_duration_str":"15.98ms","statements":[{"sql":"select ec_reviews.product_id, avg(ec_reviews.star) AS star from `ec_reviews` where (`ec_reviews`.`status` = 'published') group by `ec_reviews`.`product_id` order by `star` desc limit 10","type":"query","params":[],"bindings":["published"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":205},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197}],"duration":0.00099,"duration_str":"990\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/helpers\/products.php:205","connection":"shopwise","start_percent":0,"width_percent":6.195},{"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 and `ec_products`.`id` in (2, 21, 42, 45, 72, 53, 106, 27, 84, 52) order by `ec_products`.`order` asc, `ec_products`.`created_at` desc","type":"query","params":[],"bindings":["published","published","published","0","2","21","42","45","72","53","106","27","84","52"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":428},{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":291},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":200},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":51},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00509,"duration_str":"5.09ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:428","connection":"shopwise","start_percent":6.195,"width_percent":31.852},{"sql":"select * from `slugs` where `slugs`.`reference_id` in (2, 21, 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":428},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":291},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":200},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":51},{"index":27,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.0008,"duration_str":"800\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:428","connection":"shopwise","start_percent":38.048,"width_percent":5.006},{"sql":"select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` in (2, 21, 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":428},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":291},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":200},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":51},{"index":27,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00062,"duration_str":"620\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:428","connection":"shopwise","start_percent":43.054,"width_percent":3.88},{"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 (2, 21, 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":428},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":291},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":200},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":51},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00166,"duration_str":"1.66ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:428","connection":"shopwise","start_percent":46.934,"width_percent":10.388},{"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 (2, 21, 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":428},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":291},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":200},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":51},{"index":27,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00281,"duration_str":"2.81ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:428","connection":"shopwise","start_percent":57.322,"width_percent":17.584},{"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.00057,"duration_str":"570\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":74.906,"width_percent":3.567},{"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 (2, 21, 27)","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":428},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":291},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":200},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":51},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00102,"duration_str":"1.02ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:428","connection":"shopwise","start_percent":78.473,"width_percent":6.383},{"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 (2, 21, 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":428},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":291},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":200},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":51},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00083,"duration_str":"830\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:428","connection":"shopwise","start_percent":84.856,"width_percent":5.194},{"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":90.05,"width_percent":3.88},{"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.0009699999999999999,"duration_str":"970\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":93.93,"width_percent":6.07}]},"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":30,"Botble\\Slug\\Models\\Slug":3,"Botble\\Ecommerce\\Models\\Product":3},"count":41},"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\/top-rated-products","status_code":"
200<\/span>\n<\/pre>