/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/Xa3d0ea1f57dd009fc68b84406ad055ab.json (37941B)
{"__meta":{"id":"Xa3d0ea1f57dd009fc68b84406ad055ab","datetime":"2021-07-28 01:30:25","utime":1627435825.20636,"method":"GET","uri":"\/ajax\/products?collection_id=1","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627435822.913169,"end":1627435825.206437,"duration":2.2932682037353516,"duration_str":"2.29s","measures":[{"label":"Booting","start":1627435822.913169,"relative_start":0,"end":1627435824.018538,"relative_end":1627435824.018538,"duration":1.1053690910339355,"duration_str":"1.11s","params":[],"collector":null},{"label":"Application","start":1627435824.027973,"relative_start":1.1148040294647217,"end":1627435825.206449,"relative_end":1.1920928955078125e-5,"duration":1.178476095199585,"duration_str":"1.18s","params":[],"collector":null}]},"memory":{"peak_usage":36605792,"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\/products","middleware":"web, core","controller":"Theme\\Shopwise\\Http\\Controllers\\ShopwiseController@ajaxGetProducts","namespace":"Theme\\Shopwise\\Http\\Controllers","prefix":null,"where":[],"as":"public.ajax.products","file":"platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:31-70"},"queries":{"nb_statements":10,"nb_failed_statements":0,"accumulated_duration":0.12745,"accumulated_duration_str":"127ms","statements":[{"sql":"select distinct `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` left join `ec_product_collection_products` on `ec_products`.`id` = `ec_product_collection_products`.`product_id` left join `ec_product_collections` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where (`ec_product_collections`.`id` in ('1')) 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","1","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":509},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":232},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":285},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.04467,"duration_str":"44.67ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":0,"width_percent":35.049},{"sql":"select * from `slugs` where `slugs`.`reference_id` in (2, 7, 10, 12, 15, 17, 21, 22, 25, 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":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":509},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":232},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":285},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00133,"duration_str":"1.33ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":35.049,"width_percent":1.044},{"sql":"select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` in (2, 7, 10, 12, 15, 17, 21, 22, 25, 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":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":509},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":232},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":285},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00492,"duration_str":"4.92ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":36.093,"width_percent":3.86},{"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, 7, 10, 12, 15, 17, 21, 22, 25, 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":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":509},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":232},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":285},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.0146,"duration_str":"14.6ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":39.953,"width_percent":11.455},{"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, 7, 10, 12, 15, 17, 21, 22, 25, 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":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":509},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":232},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":285},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.05668,"duration_str":"56.68ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":51.408,"width_percent":44.472},{"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.0007199999999999999,"duration_str":"720\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":95.881,"width_percent":0.565},{"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 (2, 7, 10, 12, 15, 17, 21, 22, 25, 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":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":509},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":232},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":285},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.00199,"duration_str":"1.99ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":96.446,"width_percent":1.561},{"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, 7, 10, 12, 15, 17, 21, 22, 25, 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":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/ProductRepository.php","line":509},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/ProductCacheDecorator.php","line":232},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/products.php","line":285},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"duration":0.0010500000000000002,"duration_str":"1.05ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:414","connection":"shopwise","start_percent":98.007,"width_percent":0.824},{"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.00075,"duration_str":"750\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":98.831,"width_percent":0.588},{"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.00074,"duration_str":"740\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":99.419,"width_percent":0.581}]},"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":4,"Botble\\Ecommerce\\Models\\ProductVariation":108,"Botble\\Slug\\Models\\Slug":10,"Botble\\Ecommerce\\Models\\Product":10},"count":137},"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\/products","status_code":"
200<\/span>\n<\/pre>