dbfdg {"__meta":{"id":"X53ff13ac04f043528f65a96d081bc938","datetime":"2024-09-11 06:26:04","utime":1726035964.41366291046142578125,"method":"GET","uri":"\/stripe\/eyJpdiI6Impjam1rc3FDYkpWVWlUcnEyZjZCTGc9PSIsInZhbHVlIjoieGZpWkdpM0swTjBtckNaaWdTd2YzZz09IiwibWFjIjoiMDQ3Y2Y2YzgwZmFlODRhMDhlOWMxYjAxOThlMDI4YjliMmRmYTg5ZmYyY2RmYTc1MTlmNDM2MTcxYTMxOThmMSIsInRhZyI6IiJ9","ip":"49.36.83.199"},"php":{"version":"8.1.29","interface":"fpm-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1726035964.1021258831024169921875,"end":1726035964.4136779308319091796875,"duration":0.3115520477294921875,"duration_str":"312ms","measures":[{"label":"Booting","start":1726035964.1021258831024169921875,"relative_start":0,"end":1726035964.2653539180755615234375,"relative_end":1726035964.2653539180755615234375,"duration":0.16322803497314453125,"duration_str":"163ms","memory":0,"memory_str":"0B","params":[],"collector":null},{"label":"Application","start":1726035964.265571117401123046875,"relative_start":0.1634452342987060546875,"end":1726035964.41368007659912109375,"relative_end":2.1457672119140625e-6,"duration":0.148108959197998046875,"duration_str":"148ms","memory":0,"memory_str":"0B","params":[],"collector":null}]},"memory":{"peak_usage":47065912,"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.0111299999999999975341946623075273237191140651702880859375,"accumulated_duration_str":"11.13ms","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.003000000000000000062450045135165055398829281330108642578125,"duration_str":"3ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:59","connection":"erpalfadhel_erp","start_percent":0,"width_percent":26.95400000000000062527760746888816356658935546875},{"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.000689999999999999966658614791725767645402811467647552490234375,"duration_str":"690\u03bcs","stmt_id":"\/app\/Models\/Utility.php:58","connection":"erpalfadhel_erp","start_percent":26.95400000000000062527760746888816356658935546875,"width_percent":6.1989999999999998436805981327779591083526611328125},{"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.00073999999999999998938349232702194058219902217388153076171875,"duration_str":"740\u03bcs","stmt_id":"\/app\/Http\/Controllers\/StripePaymentController.php:80","connection":"erpalfadhel_erp","start_percent":33.15400000000000346744855050928890705108642578125,"width_percent":6.64900000000000002131628207280300557613372802734375},{"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.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\u03bcs","stmt_id":"\/app\/Models\/Utility.php:3602","connection":"erpalfadhel_erp","start_percent":39.80199999999999960209606797434389591217041015625,"width_percent":3.055000000000000159872115546022541821002960205078125},{"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.000599999999999999947437878677902745039318688213825225830078125,"duration_str":"600\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":42.856999999999999317878973670303821563720703125,"width_percent":5.3910000000000000142108547152020037174224853515625},{"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.0003899999999999999929396754527743951257434673607349395751953125,"duration_str":"390\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":48.24799999999999755573298898525536060333251953125,"width_percent":3.504000000000000003552713678800500929355621337890625},{"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.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":51.75200000000000244426701101474463939666748046875,"width_percent":3.3239999999999998436805981327779591083526611328125},{"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.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\u03bcs","stmt_id":"\/app\/Models\/EmailTemplate.php:27","connection":"erpalfadhel_erp","start_percent":55.07600000000000051159076974727213382720947265625,"width_percent":2.6059999999999998721023075631819665431976318359375},{"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.0004699999999999999859313926098280944643192924559116363525390625,"duration_str":"470\u03bcs","stmt_id":"\/app\/Models\/Plan.php:65","connection":"erpalfadhel_erp","start_percent":57.6820000000000021600499167107045650482177734375,"width_percent":4.22299999999999986499688020558096468448638916015625},{"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.00070999999999999991069643545671397077967412769794464111328125,"duration_str":"710\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php:305","connection":"erpalfadhel_erp","start_percent":61.905000000000001136868377216160297393798828125,"width_percent":6.3789999999999995594635038287378847599029541015625},{"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.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php:188","connection":"erpalfadhel_erp","start_percent":68.2840000000000060254023992456495761871337890625,"width_percent":3.68400000000000016342482922482304275035858154296875},{"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.00072999999999999996315447337025261731469072401523590087890625,"duration_str":"730\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":71.9680000000000035242919693700969219207763671875,"width_percent":6.55900000000000016342482922482304275035858154296875},{"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.001340000000000000045241588253475129022262990474700927734375,"duration_str":"1.34ms","stmt_id":"\/app\/Models\/Utility.php:519","connection":"erpalfadhel_erp","start_percent":78.5270000000000010231815394945442676544189453125,"width_percent":12.03999999999999914734871708787977695465087890625},{"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.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","stmt_id":"\/app\/Models\/Utility.php:525","connection":"erpalfadhel_erp","start_percent":90.566000000000002501110429875552654266357421875,"width_percent":3.145000000000000017763568394002504646778106689453125},{"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.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","stmt_id":"view::partials.admin.header:18","connection":"erpalfadhel_erp","start_percent":93.7109999999999985220711096189916133880615234375,"width_percent":3.145000000000000017763568394002504646778106689453125},{"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.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":96.8550000000000039790393202565610408782958984375,"width_percent":3.145000000000000017763568394002504646778106689453125}]},"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>