dbfdg {"__meta":{"id":"Xa10014e86c583fb02ab34733e6404692","datetime":"2024-09-11 06:26:00","utime":1726035960.9007499217987060546875,"method":"GET","uri":"\/plans","ip":"49.36.83.199"},"php":{"version":"8.1.29","interface":"fpm-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1726035960.612987041473388671875,"end":1726035960.9007670879364013671875,"duration":0.2877800464630126953125,"duration_str":"288ms","measures":[{"label":"Booting","start":1726035960.612987041473388671875,"relative_start":0,"end":1726035960.7630789279937744140625,"relative_end":1726035960.7630789279937744140625,"duration":0.1500918865203857421875,"duration_str":"150ms","memory":0,"memory_str":"0B","params":[],"collector":null},{"label":"Application","start":1726035960.76327800750732421875,"relative_start":0.150290966033935546875,"end":1726035960.9007689952850341796875,"relative_end":1.9073486328125e-6,"duration":0.1374909877777099609375,"duration_str":"137ms","memory":0,"memory_str":"0B","params":[],"collector":null}]},"memory":{"peak_usage":47304000,"peak_usage_str":"45MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":7,"templates":[{"name":"plan.index (resources\/views\/plan\/index.blade.php)","param_count":2,"params":["plans","admin_payment_setting"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/plan\/index.blade.php&line=0"},{"name":"layouts.admin (resources\/views\/layouts\/admin.blade.php)","param_count":9,"params":["__env","app","errors","plans","admin_payment_setting","dir","__currentLoopData","plan","loop"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/layouts\/admin.blade.php&line=0"},{"name":"partials.admin.menu (resources\/views\/partials\/admin\/menu.blade.php)","param_count":20,"params":["__env","app","errors","plans","admin_payment_setting","dir","__currentLoopData","plan","loop","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/partials\/admin\/menu.blade.php&line=0"},{"name":"partials.admin.header (resources\/views\/partials\/admin\/header.blade.php)","param_count":20,"params":["__env","app","errors","plans","admin_payment_setting","dir","__currentLoopData","plan","loop","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/partials\/admin\/header.blade.php&line=0"},{"name":"partials.admin.footer (resources\/views\/partials\/admin\/footer.blade.php)","param_count":20,"params":["__env","app","errors","plans","admin_payment_setting","dir","__currentLoopData","plan","loop","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/partials\/admin\/footer.blade.php&line=0"},{"name":"layouts.cookie_consent (resources\/views\/layouts\/cookie_consent.blade.php)","param_count":23,"params":["__env","app","errors","plans","admin_payment_setting","dir","__currentLoopData","plan","loop","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo","settings","setting_arr","message"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/layouts\/cookie_consent.blade.php&line=0"},{"name":"Chatify::layouts.footerLinks (resources\/views\/vendor\/Chatify\/layouts\/footerLinks.blade.php)","param_count":20,"params":["__env","app","errors","plans","admin_payment_setting","dir","__currentLoopData","plan","loop","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/vendor\/Chatify\/layouts\/footerLinks.blade.php&line=0"}]},"route":{"uri":"GET plans","middleware":"web, verified, auth, XSS, revalidate","as":"plans.index","controller":"App\\Http\\Controllers\\PlanController@index","namespace":"App\\Http\\Controllers","prefix":"","where":[],"file":"app\/Http\/Controllers\/PlanController.php:13-34<\/a>"},"queries":{"nb_statements":16,"nb_failed_statements":0,"accumulated_duration":0.0128599999999999999034105968576113809831440448760986328125,"accumulated_duration_str":"12.86ms","statements":[{"sql":"select * from `users` where `id` = 2 limit 1","type":"query","params":[],"bindings":["2"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":159},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":18,"namespace":"middleware","name":"auth","line":76},{"index":19,"namespace":"middleware","name":"auth","line":55}],"duration":0.00208000000000000025146551507759795640595257282257080078125,"duration_str":"2.08ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:59","connection":"erpalfadhel_erp","start_percent":0,"width_percent":16.17399999999999948840923025272786617279052734375},{"sql":"select * from `settings` where `created_by` = 2","type":"query","params":[],"bindings":["2"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":58},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":299},{"index":14,"namespace":"middleware","name":"XSS","line":28},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180},{"index":16,"namespace":"middleware","name":"verified","line":41}],"duration":0.000630000000000000026124935548210714841843582689762115478515625,"duration_str":"630\u03bcs","stmt_id":"\/app\/Models\/Utility.php:58","connection":"erpalfadhel_erp","start_percent":16.17399999999999948840923025272786617279052734375,"width_percent":4.89900000000000002131628207280300557613372802734375},{"sql":"select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` = 2 and `model_has_permissions`.`model_type` = 'App\\Models\\User'","type":"query","params":[],"bindings":["2","App\\Models\\User"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":305},{"index":20,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":193},{"index":21,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":244},{"index":22,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","line":136},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Access\/Gate.php","line":566}],"duration":0.00091000000000000000159594559789866252685897052288055419921875,"duration_str":"910\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php:305","connection":"erpalfadhel_erp","start_percent":21.07300000000000039790393202565610408782958984375,"width_percent":7.07599999999999962341235004714690148830413818359375},{"sql":"select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` in (2) and `model_has_roles`.`model_type` = 'App\\Models\\User'","type":"query","params":[],"bindings":["App\\Models\\User"],"hints":null,"show_copy":false,"backtrace":[{"index":21,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php","line":188},{"index":22,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":291},{"index":23,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":193},{"index":24,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":244},{"index":25,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","line":136}],"duration":0.000460000000000000013912482277333992897183634340763092041015625,"duration_str":"460\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php:188","connection":"erpalfadhel_erp","start_percent":28.1490000000000009094947017729282379150390625,"width_percent":3.5769999999999999573674358543939888477325439453125},{"sql":"select * from `plans` where `is_disable` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/app\/Http\/Controllers\/PlanController.php","line":24},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.00073999999999999998938349232702194058219902217388153076171875,"duration_str":"740\u03bcs","stmt_id":"\/app\/Http\/Controllers\/PlanController.php:24","connection":"erpalfadhel_erp","start_percent":31.7259999999999990905052982270717620849609375,"width_percent":5.7539999999999995594635038287378847599029541015625},{"sql":"select * from `admin_payment_settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":3602},{"index":13,"namespace":null,"name":"\/app\/Http\/Controllers\/PlanController.php","line":26},{"index":14,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00166000000000000001720845688168992637656629085540771484375,"duration_str":"1.66ms","stmt_id":"\/app\/Models\/Utility.php:3602","connection":"erpalfadhel_erp","start_percent":37.48100000000000164845914696343243122100830078125,"width_percent":12.9079999999999994741983755375258624553680419921875},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"layouts.admin","line":5},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.000790000000000000012108369862318113518995232880115509033203125,"duration_str":"790\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":50.38900000000000289901436190120875835418701171875,"width_percent":6.14299999999999979394260662957094609737396240234375},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"layouts.admin","line":28},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":56.5319999999999964757080306299030780792236328125,"width_percent":2.6440000000000001278976924368180334568023681640625},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"partials.admin.menu","line":4},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.000630000000000000026124935548210714841843582689762115478515625,"duration_str":"630\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":59.1760000000000019326762412674725055694580078125,"width_percent":4.89900000000000002131628207280300557613372802734375},{"sql":"select * from `email_templates` limit 1","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/app\/Models\/EmailTemplate.php","line":27},{"index":19,"namespace":"view","name":"partials.admin.menu","line":10},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.00108000000000000001380839886877538447151891887187957763671875,"duration_str":"1.08ms","stmt_id":"\/app\/Models\/EmailTemplate.php:27","connection":"erpalfadhel_erp","start_percent":64.0750000000000028421709430404007434844970703125,"width_percent":8.397999999999999687361196265555918216705322265625},{"sql":"select * from `plans` where `plans`.`id` = 1 limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/app\/Models\/Plan.php","line":65},{"index":20,"namespace":"view","name":"partials.admin.menu","line":13},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.0005200000000000000628663787693994891014881432056427001953125,"duration_str":"520\u03bcs","stmt_id":"\/app\/Models\/Plan.php:65","connection":"erpalfadhel_erp","start_percent":72.4729999999999989768184605054557323455810546875,"width_percent":4.04399999999999959499064061674289405345916748046875},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"partials.admin.header","line":3},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.000800000000000000038337388819087436786503531038761138916015625,"duration_str":"800\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":76.5160000000000053432813729159533977508544921875,"width_percent":6.221000000000000085265128291212022304534912109375},{"sql":"select * from information_schema.tables where table_schema = 'erpalfadhel_erp' and table_name = 'languages' and table_type = 'BASE TABLE'","type":"query","params":[],"bindings":["erpalfadhel_erp","languages"],"hints":null,"show_copy":false,"backtrace":[{"index":11,"namespace":null,"name":"\/app\/Models\/Utility.php","line":519},{"index":12,"namespace":"view","name":"partials.admin.header","line":4},{"index":14,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.00106999999999999998757937991200606120401062071323394775390625,"duration_str":"1.07ms","stmt_id":"\/app\/Models\/Utility.php:519","connection":"erpalfadhel_erp","start_percent":82.736999999999994770405464805662631988525390625,"width_percent":8.32000000000000028421709430404007434844970703125},{"sql":"select `full_name`, `code` from `languages`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"\/app\/Models\/Utility.php","line":525},{"index":17,"namespace":"view","name":"partials.admin.header","line":4},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.000359999999999999968462727206741647023591212928295135498046875,"duration_str":"360\u03bcs","stmt_id":"\/app\/Models\/Utility.php:525","connection":"erpalfadhel_erp","start_percent":91.0580000000000069348971010185778141021728515625,"width_percent":2.798999999999999932498440102790482342243194580078125},{"sql":"select count(*) as aggregate from `ch_messages` where `to_id` = 2 and `seen` = 0","type":"query","params":[],"bindings":["2","0"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":"view","name":"partials.admin.header","line":18},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"duration":0.0004699999999999999859313926098280944643192924559116363525390625,"duration_str":"470\u03bcs","stmt_id":"view::partials.admin.header:18","connection":"erpalfadhel_erp","start_percent":93.856999999999999317878973670303821563720703125,"width_percent":3.654999999999999804600747665972448885440826416015625},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":5902},{"index":14,"namespace":"view","name":"partials.admin.footer","line":5},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.0003200000000000000261769772524900190546759404242038726806640625,"duration_str":"320\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":97.51200000000000045474735088646411895751953125,"width_percent":2.487999999999999989341858963598497211933135986328125}]},"models":{"data":{"App\\Models\\EmailTemplate":1,"App\\Models\\Plan":3,"Spatie\\Permission\\Models\\Role":1,"App\\Models\\User":1},"count":6},"gate":{"count":107,"messages":[{"message":"[ability => manage plan, result => true, user => 2, arguments => []]","message_html":"
array:4<\/span> [\n  \"ability<\/span>\" => \"manage plan<\/span>\"\n  \"result<\/span>\" => true<\/span>\n  \"user<\/span>\" => 2<\/span>\n  \"arguments<\/span>\" => \"[]<\/span>\"\n<\/samp>]\n<\/pre>