Messages Timeline Exceptions Views5 Route Queries34 Models0 Mails Gate Session Request

7.4.3203ms7MBGET coaching/{coaching_name_slug}/{branch_slug?}

Booting (20.48ms)
Application (183ms)
1 x Application (89.84%)
182.65ms
1 x Booting (10.07%)
20.48ms

5 templates were rendered

website.overview (resources/views/website/overview.blade.php)9blade


metatitle
header
footer
coaching
coaching_logo_link
centers
getStates
metadescription
metakeywords

website.layouts.header (resources/views/website/layouts/header.blade.php)13blade


obLevel
__env
app
header
footer
errors
metatitle
coaching
coaching_logo_link
centers
getStates
metadescription
metakeywords

website.layouts.website_theme (resources/views/website/layouts/website_theme.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
header
4
footer
5
errors
6
metatitle
7
coaching
8
coaching_logo_link
9
centers
10
getStates
11
metadescription
12
metakeywords
13
url

website.layouts.footer (resources/views/website/layouts/footer.blade.php)32blade


obLevel
__env
app
header
footer
errors
metatitle
coaching
coaching_logo_link
centers
getStates
metadescription
metakeywords
image
__currentLoopData
loop
total_box
courses_detail
course
results
removeBtn
i
limit
result
coachingname
facility
iii
showedit
year
logo_link
coaching_name_slug
http_response_header

alert_msg (resources/views/alert_msg.blade.php)37blade


obLevel
__env
app
header
footer
errors
metatitle
coaching
coaching_logo_link
centers
getStates
metadescription
metakeywords
image
__currentLoopData
loop
total_box
courses_detail
course
results
removeBtn
i
limit
result
coachingname
facility
iii
showedit
year
logo_link
coaching_name_slug
http_response_header
category
category_slug
exam
stream_slug
question_paper_subject

uri: GET coaching/{coaching_name_slug}/{branch_slug?}
middleware: web, slug-generate
controller: App\Http\Controllers\Website\CoachingController@overview
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/Website/CoachingController.php:19-302

34 statements were executed, 12 of which were duplicated, 22 unique74.11ms

select * from `coaching` where `name` = 'Dr Bhatia Medical Coaching Institute DBMCI' and `status` = 'enable' limit 1

2.12ms/app/Http/Controllers/Website/CoachingController.php:29coachingselect

Metadata
Bindings	0. Dr Bhatia Medical Coaching Institute DBMCI 1. enable
Backtrace	13. /app/Http/Controllers/Website/CoachingController.php:29 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `coaching_centers`.* from `coaching_centers` inner join `coaching_centers_branches` on `coaching_centers_branches`.`coaching_centers_id` = `coaching_centers`.`id` where `coaching_centers`.`coaching_id` = 638 and `coaching_centers_branches`.`status` = 'enable' group by `coaching_centers`.`name`

3.47ms/app/Http/Controllers/Website/CoachingController.php:43coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:43 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select exists(select * from `coaching` where `id` = 638 and `status` = 'enable') as `exists`

890μs/app/Http/Controllers/Website/CoachingController.php:1229coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	9. /app/Http/Controllers/Website/CoachingController.php:1229 10. /app/Http/Controllers/Website/CoachingController.php:44 11. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 12. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 13. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select `coaching_centers`.* from `coaching_centers` inner join `coaching_centers_branches` on `coaching_centers_branches`.`coaching_centers_id` = `coaching_centers`.`id` where `coaching_centers`.`coaching_id` = 638 and `coaching_centers_branches`.`status` = 'enable' group by `coaching_centers`.`name`

4.16ms/app/Http/Controllers/Website/CoachingController.php:104coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:104 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `coaching_centers_branches`.*, `coaching_centers`.`name` as `center_name` from `coaching_centers_branches` inner join `coaching_centers` on `coaching_centers`.`id` = `coaching_centers_branches`.`coaching_centers_id` where `coaching_centers_branches`.`coaching_id` = 638 and `coaching_centers_branches`.`status` = 'enable' limit 1

1.82ms/app/Http/Controllers/Website/CoachingController.php:111coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	13. /app/Http/Controllers/Website/CoachingController.php:111 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `name` from `coaching_centers_branches` where `coaching_centers_id` = '684' and `name` != 'Dadar' and `status` = 'enable'

1.27ms/app/Http/Controllers/Website/CoachingController.php:119coachingselect

Metadata
Bindings	0. 684 1. Dadar 2. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:119 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `coaching_facility` inner join `facility` on `facility`.`name` = `coaching_facility`.`name` where `coaching_facility`.`coaching_id` = 638 and `coaching_facility`.`status` = 'enable'

6.6ms/app/Http/Controllers/Website/CoachingController.php:135coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:135 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `coaching_faculty` where `coaching_faculty`.`coaching_id` = 638 and `coaching_faculty`.`status` = 'enable'

920μs/app/Http/Controllers/Website/CoachingController.php:140coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:140 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `coaching_results`.*, `courses`.`name` as `courses_name` from `coaching_results` inner join `courses` on `courses`.`id` = `coaching_results`.`coaching_courses_id` where `coaching_results`.`coaching_id` = 638 and `coaching_results`.`status` = 'enable'

750μs/app/Http/Controllers/Website/CoachingController.php:148coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:148 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `coaching_testimonials`.*, `courses`.`name` as `coaching_courses_name` from `coaching_testimonials` inner join `courses` on `courses`.`id` = `coaching_testimonials`.`coaching_courses_id` where `coaching_testimonials`.`coaching_id` = 638 and `coaching_testimonials`.`status` = 'enable' and `courses`.`status` = 'enable'

570μs/app/Http/Controllers/Website/CoachingController.php:161coachingselect

Metadata
Bindings	0. 638 1. enable 2. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:161 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `coaching_photos` where `coaching_photos`.`coaching_id` = 638 and `coaching_photos`.`status` = 'enable'

420μs/app/Http/Controllers/Website/CoachingController.php:171coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:171 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `coaching_videos` where `coaching_videos`.`coaching_id` = 638 and `coaching_videos`.`status` = 'enable'

520μs/app/Http/Controllers/Website/CoachingController.php:176coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:176 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `image`, `name` from `coaching` where `status` = 'enable' and `is_featured` = 1

3.52ms/app/Http/Controllers/Website/CoachingController.php:182coachingselect

Metadata
Bindings	0. enable 1. 1
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:182 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `coaching_courses_detail`.*, `coaching_courses`.`name` as `coaching_courses_name` from `coaching_courses_detail` inner join `coaching_courses` on `coaching_courses`.`id` = `coaching_courses_detail`.`coaching_courses_id` where `coaching_courses`.`coaching_id` = 638 and `coaching_courses`.`status` = 'enable' and `coaching_courses_detail`.`status` = 'enable'

10.54ms/app/Http/Controllers/Website/CoachingController.php:190coachingselect

Metadata
Bindings	0. 638 1. enable 2. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:190 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `coaching_courses` where `coaching_id` = 638 and `status` = 'enable'

2.78ms/app/Http/Controllers/Website/CoachingController.php:200coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:200 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select sum(`faculty_stars`) as aggregate from `coaching_reviews` where `coaching_id` = 638 and `status` = 'enable'

970μs/app/Http/Controllers/Website/CoachingController.php:895coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	14. /app/Http/Controllers/Website/CoachingController.php:895 15. /app/Http/Controllers/Website/CoachingController.php:249 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select sum(`study_materials_stars`) as aggregate from `coaching_reviews` where `coaching_id` = 638 and `status` = 'enable'

1.05ms/app/Http/Controllers/Website/CoachingController.php:900coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	14. /app/Http/Controllers/Website/CoachingController.php:900 15. /app/Http/Controllers/Website/CoachingController.php:249 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select sum(`doubt_clearing_stars`) as aggregate from `coaching_reviews` where `coaching_id` = 638 and `status` = 'enable'

480μs/app/Http/Controllers/Website/CoachingController.php:905coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	14. /app/Http/Controllers/Website/CoachingController.php:905 15. /app/Http/Controllers/Website/CoachingController.php:249 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select sum(`mentorship_stars`) as aggregate from `coaching_reviews` where `coaching_id` = 638 and `status` = 'enable'

410μs/app/Http/Controllers/Website/CoachingController.php:910coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	14. /app/Http/Controllers/Website/CoachingController.php:910 15. /app/Http/Controllers/Website/CoachingController.php:249 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select sum(`tech_support_stars`) as aggregate from `coaching_reviews` where `coaching_id` = 638 and `status` = 'enable'

620μs/app/Http/Controllers/Website/CoachingController.php:915coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	14. /app/Http/Controllers/Website/CoachingController.php:915 15. /app/Http/Controllers/Website/CoachingController.php:249 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select `id` from `coaching_reviews` where `coaching_id` = 638 and `status` = 'enable'

660μs/app/Http/Controllers/Website/CoachingController.php:925coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:925 13. /app/Http/Controllers/Website/CoachingController.php:249 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select `coaching_reviews`.*, `students`.`name` as `student_name`, `students`.`image` from `coaching_reviews` inner join `students` on `students`.`id` = `coaching_reviews`.`user_id` where `coaching_id` = 638 and `coaching_reviews`.`status` = 'enable' order by `coaching_reviews`.`created_at` desc

960μs/app/Http/Controllers/Website/CoachingController.php:1042coachingselect

Metadata
Bindings	0. 638 1. enable
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:1042 13. /app/Http/Controllers/Website/CoachingController.php:251 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select * from `states` where `country_id` = 101

730μs/app/Http/Controllers/Website/CoachingController.php:253coachingselect

Metadata
Bindings	0. 101
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:253 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `coaching`.`image`, `coaching`.`name`, 6367 * acos(cos(radians(19.015948))
* cos(radians(coaching_centers_branches.latitude)) * cos(radians(coaching_centers_branches.longitude) - radians(72.84429329999999))
+ sin(radians(19.015948)) * sin(radians(coaching_centers_branches.latitude))) AS distance from `coaching_centers` inner join `coaching_centers_branches` on `coaching_centers_branches`.`coaching_centers_id` = `coaching_centers`.`id` inner join `coaching` on `coaching`.`id` = `coaching_centers`.`coaching_id` where `coaching_centers_branches`.`status` = 'enable' and `coaching_centers`.`status` = 'enable' and `coaching`.`status` = 'enable' and `coaching`.`id` != 638 group by `coaching`.`id` having `distance` < 3000 order by `distance` asc

14.14ms/app/Http/Controllers/Website/CoachingController.php:291coachingselect

Metadata
Bindings	0. enable 1. enable 2. enable 3. 638 4. 3000
Backtrace	12. /app/Http/Controllers/Website/CoachingController.php:291 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `courses_details` from `college` where `status` = 1 order by `college`.`created_at` asc

990μs/app/Http/Controllers/Website/HeaderController.php:499coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:499 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:530 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `stream_id` from `college` where `status` = 1

1.09ms/app/Http/Controllers/Website/HeaderController.php:532coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:532 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:530 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `courses_details` from `college` where `status` = 1 order by `college`.`created_at` asc

1.25ms/app/Http/Controllers/Website/HeaderController.php:499coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:499 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:534 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `stream_id` from `college` where `status` = 1

1.11ms/app/Http/Controllers/Website/HeaderController.php:532coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:532 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:534 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `courses_details` from `college` where `status` = 1 order by `college`.`created_at` asc

2.18ms/app/Http/Controllers/Website/HeaderController.php:499coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:499 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:944 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `stream_id` from `college` where `status` = 1

1.45ms/app/Http/Controllers/Website/HeaderController.php:532coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:532 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:944 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `courses_details` from `college` where `status` = 1 order by `college`.`created_at` asc

1.28ms/app/Http/Controllers/Website/HeaderController.php:499coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:499 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:948 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `stream_id` from `college` where `status` = 1

910μs/app/Http/Controllers/Website/HeaderController.php:532coachingselect

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Website/HeaderController.php:532 13. view::4230e27c3c186462b9587fd775c65c77fbde0374:948 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 17. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `advertisement` where `type` = 'full' and `position` is null and `status` = 'enable' and `start_date` <= '2025-08-13' and `end_date` >= '2025-08-13' order by RAND() limit 1

1.91ms/app/Http/Controllers/Website/HeaderController.php:239coachingselect

Metadata
Bindings	0. full 1. enable 2. 2025-08-13 3. 2025-08-13
Backtrace	13. /app/Http/Controllers/Website/HeaderController.php:239 14. view::b1eb23f4d8a9b14efcab1aeb45c39a521a2f7a33:1100 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 18. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `advertisement` where `type` = 'full' and `position` is null and `status` = 'enable' and `start_date` <= '2025-08-13' and `end_date` >= '2025-08-13' order by RAND() limit 1

1.57ms/app/Http/Controllers/Website/HeaderController.php:239coachingselect

Metadata
Bindings	0. full 1. enable 2. 2025-08-13 3. 2025-08-13
Backtrace	13. /app/Http/Controllers/Website/HeaderController.php:239 14. view::b1eb23f4d8a9b14efcab1aeb45c39a521a2f7a33:2651 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 18. /vendor/laravel/framework/src/Illuminate/View/View.php:139

_token: Yv3BJfHbhyRCgtUWhKE1Cn65mbpVINEEwhC6XKkz
_previous: array:1 [ "url" => "http://64.227.150.69/coaching/Dr-Bhatia-Medical-Coaching-Institute-DBMCI" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/coaching/Dr-Bhatia-Medical-Coaching-Institute-DBMCI

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:10 [▼
  "host" => array:1 [▶
    0 => "64.227.150.69"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-qdf5w (squid/6.10)"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.3.26.172"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
]

request_server

  0 of 0   
array:35 [▼
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "64.227.150.69"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate"
  "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-qdf5w (squid/6.10)"
  "HTTP_X_FORWARDED_FOR" => "10.3.26.172"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.41 (Ubuntu) Server at 64.227.150.69 Port 80</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.41 (Ubuntu)"
  "SERVER_NAME" => "64.227.150.69"
  "SERVER_ADDR" => "64.227.150.69"
  "SERVER_PORT" => "80"
  "REMOTE_ADDR" => "216.73.216.96"
  "DOCUMENT_ROOT" => "/var/www/html"
  "REQUEST_SCHEME" => "http"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html"
  "SERVER_ADMIN" => "webmaster@localhost"
  "SCRIPT_FILENAME" => "/var/www/html/index.php"
  "REMOTE_PORT" => "43877"
  "REDIRECT_URL" => "/coaching/Dr-Bhatia-Medical-Coaching-Institute-DBMCI"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/coaching/Dr-Bhatia-Medical-Coaching-Institute-DBMCI"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1755109381.564
  "REQUEST_TIME" => 1755109381
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 13 Aug 2025 18:23:01 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZBUUtKU0lIdXZ1SU9WK2t5RHJmcGc9PSIsInZhbHVlIjoieFRJMjYrV1RZc3pDTVdURlg0d0lUV2JUbXpIRVdVcFlIdnR6QXUzNU1jNUJPVkU3UlZrODhlM0d5N1BmRVFCb2Z0RStuZWovQkwyUnpGd1pmbHVjaW5NMHJqY3pqeVFxeTNBNFlCcE9LaDUzejNNSkJ2VVRGNXprd2E4eFpzTDQiLCJtYWMiOiI1ZWFmOGU5ZWRjNGYyZTc3YTgwNGFmMzlkMzBlZTI1YWJmOGNkNDIxZDBiOGY1ODFmODU1Zjc2NWUxYzExODQ5In0%3D; expires=Thu, 13-Aug-2026 18:23:01 GMT; Max-Age=31536000; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZBUUtKU0lIdXZ1SU9WK2t5RHJmcGc9PSIsInZhbHVlIjoieFRJMjYrV1RZc3pDTVdURlg0d0lUV2JUbXpIRVdVcFlIdnR6QXUzNU1jNUJPVkU3UlZrODhlM0d5N1BmRVFCb2Z0RStuZ ▶"
    1 => "coachingselect_session=eyJpdiI6ImR2bU9rN1VIYnBWMDBNZmMxN2NKbGc9PSIsInZhbHVlIjoibnhXUDgxOUN5bjFJUzlFc0tWVzdEQTRDcjVXMktKL3dvSWk5VlZDQlRVQnN3Y25TUUhTUk9Ub0NjRkhPTUdqZGlSbnA5QUtWM2t6WHdEeExwNWRwQ004d0lrbUdaK1FObzFrRmhuZzlkYkgraHlsVW0vRFpXQWk2bExTd2pTZUUiLCJtYWMiOiI1NDhmOGY0ZTZmNzMzZWYyMjgyMjRjMGNmNjVhNTFjNzk1OTI1ZDkwYzQ2MDAyMmZhNWNiZTM3ZjNmZDQ1YjViIn0%3D; expires=Thu, 13-Aug-2026 18:23:01 GMT; Max-Age=31536000; path=/; httponly ◀coachingselect_session=eyJpdiI6ImR2bU9rN1VIYnBWMDBNZmMxN2NKbGc9PSIsInZhbHVlIjoibnhXUDgxOUN5bjFJUzlFc0tWVzdEQTRDcjVXMktKL3dvSWk5VlZDQlRVQnN3Y25TUUhTUk9Ub0NjRkhPT ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZBUUtKU0lIdXZ1SU9WK2t5RHJmcGc9PSIsInZhbHVlIjoieFRJMjYrV1RZc3pDTVdURlg0d0lUV2JUbXpIRVdVcFlIdnR6QXUzNU1jNUJPVkU3UlZrODhlM0d5N1BmRVFCb2Z0RStuZWovQkwyUnpGd1pmbHVjaW5NMHJqY3pqeVFxeTNBNFlCcE9LaDUzejNNSkJ2VVRGNXprd2E4eFpzTDQiLCJtYWMiOiI1ZWFmOGU5ZWRjNGYyZTc3YTgwNGFmMzlkMzBlZTI1YWJmOGNkNDIxZDBiOGY1ODFmODU1Zjc2NWUxYzExODQ5In0%3D; expires=Thu, 13-Aug-2026 18:23:01 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZBUUtKU0lIdXZ1SU9WK2t5RHJmcGc9PSIsInZhbHVlIjoieFRJMjYrV1RZc3pDTVdURlg0d0lUV2JUbXpIRVdVcFlIdnR6QXUzNU1jNUJPVkU3UlZrODhlM0d5N1BmRVFCb2Z0RStuZ ▶"
    1 => "coachingselect_session=eyJpdiI6ImR2bU9rN1VIYnBWMDBNZmMxN2NKbGc9PSIsInZhbHVlIjoibnhXUDgxOUN5bjFJUzlFc0tWVzdEQTRDcjVXMktKL3dvSWk5VlZDQlRVQnN3Y25TUUhTUk9Ub0NjRkhPTUdqZGlSbnA5QUtWM2t6WHdEeExwNWRwQ004d0lrbUdaK1FObzFrRmhuZzlkYkgraHlsVW0vRFpXQWk2bExTd2pTZUUiLCJtYWMiOiI1NDhmOGY0ZTZmNzMzZWYyMjgyMjRjMGNmNjVhNTFjNzk1OTI1ZDkwYzQ2MDAyMmZhNWNiZTM3ZjNmZDQ1YjViIn0%3D; expires=Thu, 13-Aug-2026 18:23:01 GMT; path=/; httponly ◀coachingselect_session=eyJpdiI6ImR2bU9rN1VIYnBWMDBNZmMxN2NKbGc9PSIsInZhbHVlIjoibnhXUDgxOUN5bjFJUzlFc0tWVzdEQTRDcjVXMktKL3dvSWk5VlZDQlRVQnN3Y25TUUhTUk9Ub0NjRkhPT ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "Yv3BJfHbhyRCgtUWhKE1Cn65mbpVINEEwhC6XKkz"
  "_previous" => array:1 [▶
    "url" => "http://64.227.150.69/coaching/Dr-Bhatia-Medical-Coaching-Institute-DBMCI"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Student Login

Create your account

Register your account

Dr Bhatia Medical Coaching Institute DBMCI

About Dr Bhatia Medical Coaching Institute DBMCI

Login to get Contact Information

Courses

Library

Medical

Study Material

Worksheets

Doubt Classes

Lectures

Test Series

WiFi

Mobile App

EBook

Leave a Review for Dr Bhatia Medical Coaching Institute DBMCI

Params
0	`metatitle`
1	`header`
2	`footer`
3	`coaching`
4	`coaching_logo_link`
5	`centers`
6	`getStates`
7	`metadescription`
8	`metakeywords`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`header`
4	`footer`
5	`errors`
6	`metatitle`
7	`coaching`
8	`coaching_logo_link`
9	`centers`
10	`getStates`
11	`metadescription`
12	`metakeywords`

1 x Application (89.84%)	182.65ms
1 x Booting (10.07%)	20.48ms

Params
0	`obLevel`
1	`__env`
2	`app`
3	`header`
4	`footer`
5	`errors`
6	`metatitle`
7	`coaching`
8	`coaching_logo_link`
9	`centers`
10	`getStates`
11	`metadescription`
12	`metakeywords`
13	`image`
14	`__currentLoopData`
15	`loop`
16	`total_box`
17	`courses_detail`
18	`course`
19	`results`
20	`removeBtn`
21	`i`
22	`limit`
23	`result`
24	`coachingname`
25	`facility`
26	`iii`
27	`showedit`
28	`year`
29	`logo_link`
30	`coaching_name_slug`
31	`http_response_header`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`header`
4	`footer`
5	`errors`
6	`metatitle`
7	`coaching`
8	`coaching_logo_link`
9	`centers`
10	`getStates`
11	`metadescription`
12	`metakeywords`
13	`image`
14	`__currentLoopData`
15	`loop`
16	`total_box`
17	`courses_detail`
18	`course`
19	`results`
20	`removeBtn`
21	`i`
22	`limit`
23	`result`
24	`coachingname`
25	`facility`
26	`iii`
27	`showedit`
28	`year`
29	`logo_link`
30	`coaching_name_slug`
31	`http_response_header`
32	`category`
33	`category_slug`
34	`exam`
35	`stream_slug`
36	`question_paper_subject`

Civil Services

Counseling

Other Exams

Railway

Commerce

Design

Defence

Hotel Management

Engineering

Medical

LAW

MBA

Management

Engineering

Medical

LAW

MBA

Management

UPSC

SSC

Bank

Engineering

Medical

School

UPSC

LAW

MBA

Study Abroad

SSC

Top Colleges

Courses

Technology Partners

Dr Bhatia Medical Coaching Institute DBMCI

About Dr Bhatia Medical Coaching Institute DBMCI

Login to get Contact Information

Courses

Library

Medical

Study Material

Worksheets

Doubt Classes

Lectures

Test Series

WiFi

Mobile App

EBook

Leave a Review for Dr Bhatia Medical Coaching Institute DBMCI

Civil Services

Counseling

Other Exams

Railway

Commerce

Design

Defence

Hotel Management

Engineering

Medical

LAW

MBA

Management

Engineering

Medical

LAW

MBA

Management

UPSC

SSC

Bank

Engineering

Medical

School

UPSC

LAW

MBA

Study Abroad

SSC

Top Colleges

Courses

Technology Partners