dbfdg {"__meta":{"id":"Xad44279d022abe6cb0e85834dcbbf013","datetime":"2024-09-11 06:26:30","utime":1726035990.99238491058349609375,"method":"GET","uri":"\/stripe\/eyJpdiI6Impjam1rc3FDYkpWVWlUcnEyZjZCTGc9PSIsInZhbHVlIjoieGZpWkdpM0swTjBtckNaaWdTd2YzZz09IiwibWFjIjoiMDQ3Y2Y2YzgwZmFlODRhMDhlOWMxYjAxOThlMDI4YjliMmRmYTg5ZmYyY2RmYTc1MTlmNDM2MTcxYTMxOThmMSIsInRhZyI6IiJ9","ip":"49.36.83.199"},"php":{"version":"8.1.29","interface":"fpm-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1726035990.67603302001953125,"end":1726035990.99240207672119140625,"duration":0.31636905670166015625,"duration_str":"316ms","measures":[{"label":"Booting","start":1726035990.67603302001953125,"relative_start":0,"end":1726035990.8351409435272216796875,"relative_end":1726035990.8351409435272216796875,"duration":0.1591079235076904296875,"duration_str":"159ms","memory":0,"memory_str":"0B","params":[],"collector":null},{"label":"Application","start":1726035990.835319042205810546875,"relative_start":0.159286022186279296875,"end":1726035990.992404937744140625,"relative_end":2.86102294921875e-6,"duration":0.157085895538330078125,"duration_str":"157ms","memory":0,"memory_str":"0B","params":[],"collector":null}]},"memory":{"peak_usage":46825400,"peak_usage_str":"45MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":7,"templates":[{"name":"stripe (resources\/views\/stripe.blade.php)","param_count":2,"params":["plan","admin_payment_setting"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/stripe.blade.php&line=0"},{"name":"layouts.admin (resources\/views\/layouts\/admin.blade.php)","param_count":7,"params":["__env","app","errors","plan","admin_payment_setting","dir","dir_payment"],"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":18,"params":["__env","app","errors","plan","admin_payment_setting","dir","dir_payment","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":18,"params":["__env","app","errors","plan","admin_payment_setting","dir","dir_payment","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":18,"params":["__env","app","errors","plan","admin_payment_setting","dir","dir_payment","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":21,"params":["__env","app","errors","plan","admin_payment_setting","dir","dir_payment","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":18,"params":["__env","app","errors","plan","admin_payment_setting","dir","dir_payment","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 stripe\/{code}","middleware":"web, verified, auth, XSS, revalidate","controller":"App\\Http\\Controllers\\StripePaymentController@stripe","namespace":"App\\Http\\Controllers","prefix":"","where":[],"as":"stripe","file":"app\/Http\/Controllers\/StripePaymentController.php:71-90<\/a>"},"queries":{"nb_statements":16,"nb_failed_statements":0,"accumulated_duration":0.01554999999999999958644192332712918869219720363616943359375,"accumulated_duration_str":"15.55ms","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.0035400000000000001777744618181031910353340208530426025390625,"duration_str":"3.54ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:59","connection":"erpalfadhel_erp","start_percent":0,"width_percent":22.7650000000000005684341886080801486968994140625},{"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.000560000000000000059362237347926338770776055753231048583984375,"duration_str":"560\u03bcs","stmt_id":"\/app\/Models\/Utility.php:58","connection":"erpalfadhel_erp","start_percent":22.7650000000000005684341886080801486968994140625,"width_percent":3.60099999999999997868371792719699442386627197265625},{"sql":"select * from `plans` where `plans`.`id` = 2 limit 1","type":"query","params":[],"bindings":["2"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/app\/Http\/Controllers\/StripePaymentController.php","line":80},{"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":43},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.000609999999999999973666897634672068306826986372470855712890625,"duration_str":"610\u03bcs","stmt_id":"\/app\/Http\/Controllers\/StripePaymentController.php:80","connection":"erpalfadhel_erp","start_percent":26.367000000000000881072992342524230480194091796875,"width_percent":3.9230000000000000426325641456060111522674560546875},{"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\/StripePaymentController.php","line":81},{"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.0015400000000000001361410983946598207694478332996368408203125,"duration_str":"1.54ms","stmt_id":"\/app\/Models\/Utility.php:3602","connection":"erpalfadhel_erp","start_percent":30.2890000000000014779288903810083866119384765625,"width_percent":9.903999999999999914734871708787977695465087890625},{"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.00073999999999999998938349232702194058219902217388153076171875,"duration_str":"740\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":40.1929999999999978399500832892954349517822265625,"width_percent":4.7590000000000003410605131648480892181396484375},{"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.0004799999999999999579503029423221960314549505710601806640625,"duration_str":"480\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":44.951999999999998181010596454143524169921875,"width_percent":3.087000000000000188293824976426549255847930908203125},{"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.0005100000000000000366373598126301658339798450469970703125,"duration_str":"510\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":48.0390000000000014779288903810083866119384765625,"width_percent":3.279999999999999804600747665972448885440826416015625},{"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.000489999999999999984179321899091519298963248729705810546875,"duration_str":"490\u03bcs","stmt_id":"\/app\/Models\/EmailTemplate.php:27","connection":"erpalfadhel_erp","start_percent":51.3179999999999978399500832892954349517822265625,"width_percent":3.150999999999999801048033987171947956085205078125},{"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.000870000000000000005100087019371812857571057975292205810546875,"duration_str":"870\u03bcs","stmt_id":"\/app\/Models\/Plan.php:65","connection":"erpalfadhel_erp","start_percent":54.46900000000000119371179607696831226348876953125,"width_percent":5.59499999999999975131004248396493494510650634765625},{"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.000830000000000000008604228440844963188283145427703857421875,"duration_str":"830\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php:305","connection":"erpalfadhel_erp","start_percent":60.06400000000000005684341886080801486968994140625,"width_percent":5.33800000000000007815970093361102044582366943359375},{"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.000619999999999999999895916591441391574335284531116485595703125,"duration_str":"620\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php:188","connection":"erpalfadhel_erp","start_percent":65.4020000000000010231815394945442676544189453125,"width_percent":3.9870000000000000994759830064140260219573974609375},{"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.000830000000000000008604228440844963188283145427703857421875,"duration_str":"830\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":69.3889999999999957935870043002068996429443359375,"width_percent":5.33800000000000007815970093361102044582366943359375},{"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.00183000000000000002942091015256664832122623920440673828125,"duration_str":"1.83ms","stmt_id":"\/app\/Models\/Utility.php:519","connection":"erpalfadhel_erp","start_percent":74.727000000000003865352482534945011138916015625,"width_percent":11.768000000000000682121026329696178436279296875},{"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.000699999999999999992887633748495090912911109626293182373046875,"duration_str":"700\u03bcs","stmt_id":"\/app\/Models\/Utility.php:525","connection":"erpalfadhel_erp","start_percent":86.4950000000000045474735088646411895751953125,"width_percent":4.50199999999999977973175191436894237995147705078125},{"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.000830000000000000008604228440844963188283145427703857421875,"duration_str":"830\u03bcs","stmt_id":"view::partials.admin.header:18","connection":"erpalfadhel_erp","start_percent":90.9969999999999998863131622783839702606201171875,"width_percent":5.33800000000000007815970093361102044582366943359375},{"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.00056999999999999997717103905614521863753907382488250732421875,"duration_str":"570\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":96.33400000000000318323145620524883270263671875,"width_percent":3.665999999999999925393012745189480483531951904296875}]},"models":{"data":{"Spatie\\Permission\\Models\\Role":1,"App\\Models\\EmailTemplate":1,"App\\Models\\Plan":2,"App\\Models\\User":1},"count":5},"gate":{"count":105,"messages":[{"message":"[ability => show hrm dashboard, result => true, user => 2, arguments => []]","message_html":"
array:4<\/span> [\n  \"ability<\/span>\" => \"show hrm dashboard<\/span>\"\n  \"result<\/span>\" => true<\/span>\n  \"user<\/span>\" => 2<\/span>\n  \"arguments<\/span>\" => \"[]<\/span>\"\n<\/samp>]\n<\/pre>