Q&A

AIMA UGAT Coaching Institutes

Boost your preparation with Top AIMA UGAT Coachings Institute

FOUND 11 COACHING

Online

"We are a coaching institute exclusively for CAT/MBA test preparation in Bhopal. It is run & managed by a team of highly acclaimed & experienced aptitude trainers with proven track record. We aim to bring out the best in every student wi ...

Write a Review @ACE CAT
CAT
IPM
AIMA UGAT
7.4.3PHP Version210msRequest Duration7MBMemory UsageGET best-{exam}-{tab}-coaching/{city?}Route
    • Booting (19.42ms)
    • Application (190ms)
    • 1 x Application (90.65%)
      190.19ms
      1 x Booting (9.26%)
      19.42ms
      6 templates were rendered
      • website.coaching_search (resources/views/website/coaching_search.blade.php)11blade
        Params
        0
        metatitle
        1
        header
        2
        footer
        3
        searching
        4
        cities_group_by_state
        5
        coachings
        6
        online_coachings
        7
        filters
        8
        metadescription
        9
        metakeywords
        10
        requestedData
      • website.layouts.header (resources/views/website/layouts/header.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        header
        4
        footer
        5
        errors
        6
        metatitle
        7
        searching
        8
        cities_group_by_state
        9
        coachings
        10
        online_coachings
        11
        filters
        12
        metadescription
        13
        metakeywords
        14
        requestedData
      • website.layouts.website_theme (resources/views/website/layouts/website_theme.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        header
        4
        footer
        5
        errors
        6
        metatitle
        7
        searching
        8
        cities_group_by_state
        9
        coachings
        10
        online_coachings
        11
        filters
        12
        metadescription
        13
        metakeywords
        14
        requestedData
        15
        url
      • pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2blade
        Params
        0
        paginator
        1
        elements
      • website.layouts.footer (resources/views/website/layouts/footer.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        header
        4
        footer
        5
        errors
        6
        metatitle
        7
        searching
        8
        cities_group_by_state
        9
        coachings
        10
        online_coachings
        11
        filters
        12
        metadescription
        13
        metakeywords
        14
        requestedData
        15
        city
        16
        exam
        17
        in
        18
        text
        19
        tab
        20
        city_name
        21
        __currentLoopData
        22
        course
        23
        loop
        24
        name
        25
        cities
        26
        state
        27
        cityname
        28
        coaching
        29
        image
        30
        discount_price
        31
        final_price
        32
        newsdata
        33
        newsdata2
        34
        counter
        35
        limit
        36
        courses_detail
        37
        newsdata3
      • alert_msg (resources/views/alert_msg.blade.php)43blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        header
        4
        footer
        5
        errors
        6
        metatitle
        7
        searching
        8
        cities_group_by_state
        9
        coachings
        10
        online_coachings
        11
        filters
        12
        metadescription
        13
        metakeywords
        14
        requestedData
        15
        city
        16
        exam
        17
        in
        18
        text
        19
        tab
        20
        city_name
        21
        __currentLoopData
        22
        course
        23
        loop
        24
        name
        25
        cities
        26
        state
        27
        cityname
        28
        coaching
        29
        image
        30
        discount_price
        31
        final_price
        32
        newsdata
        33
        newsdata2
        34
        counter
        35
        limit
        36
        courses_detail
        37
        newsdata3
        38
        i
        39
        category
        40
        category_slug
        41
        stream_slug
        42
        question_paper_subject
      uri
      GET best-{exam}-{tab}-coaching/{city?}
      middleware
      web, slug-generate
      controller
      App\Http\Controllers\Website\CoachingSearchController@coaching_search_new
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/Website/CoachingSearchController.php:21-129
      42 statements were executed, 16 of which were duplicated, 26 unique117ms
      • select distinct `coaching_courses`.`name`, `coaching`.`offering` from `coaching` inner join `coaching_courses` on `coaching_courses`.`coaching_id` = `coaching`.`id` inner join `courses` on `courses`.`name` = `coaching_courses`.`name` where `coaching`.`status` = 'enable' and `courses`.`status` = 'enable' and `coaching_courses`.`status` = 'enable' and `courses`.`type` = 'coaching'
        13.5ms/app/Http/Controllers/Website/CoachingSearchController.php:234coachingselect
        Metadata
        Bindings
        • 0. enable
        • 1. enable
        • 2. enable
        • 3. coaching
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:234
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:34
        • 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 `states`.`name` as `state`, `cities`.`name` as `name` from `cities` inner join `coaching_centers` on `coaching_centers`.`name` = `cities`.`name` inner join `coaching_centers_branches` on `coaching_centers`.`id` = `coaching_centers_branches`.`coaching_centers_id` inner join `states` on `states`.`id` = `cities`.`state_id` where `coaching_centers`.`status` = 'enable' and `coaching_centers_branches`.`status` = 'enable' group by `cities`.`name`
        10.64ms/app/Http/Controllers/Website/CoachingSearchController.php:271coachingselect
        Metadata
        Bindings
        • 0. enable
        • 1. enable
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:271
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:38
        • 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 count(distinct `coaching`.`id`) as aggregate from `coaching` inner join `coaching_courses` on `coaching_courses`.`coaching_id` = `coaching`.`id` inner join `coaching_courses_detail` on `coaching_courses`.`id` = `coaching_courses_detail`.`coaching_courses_id` where `coaching`.`status` = 'enable' and `coaching_courses`.`name` = 'AIMA UGAT' and `coaching_courses`.`status` = 'enable' and `coaching_courses_detail`.`status` = 'enable'
        7.53ms/app/Http/Controllers/Website/CoachingSearchController.php:446coachingselect
        Metadata
        Bindings
        • 0. enable
        • 1. AIMA UGAT
        • 2. enable
        • 3. enable
        Backtrace
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:446
        • 16. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select distinct `coaching`.* from `coaching` inner join `coaching_courses` on `coaching_courses`.`coaching_id` = `coaching`.`id` inner join `coaching_courses_detail` on `coaching_courses`.`id` = `coaching_courses_detail`.`coaching_courses_id` where `coaching`.`status` = 'enable' and `coaching_courses`.`name` = 'AIMA UGAT' and `coaching_courses`.`status` = 'enable' and `coaching_courses_detail`.`status` = 'enable' order by `offering` desc, `admin_rating` desc limit 10 offset 10
        8.35ms/app/Http/Controllers/Website/CoachingSearchController.php:446coachingselect
        Metadata
        Bindings
        • 0. enable
        • 1. AIMA UGAT
        • 2. enable
        • 3. enable
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:446
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select SUM(faculty_stars) as faculty_stars, SUM(study_materials_stars) as study_materials_stars, SUM(doubt_clearing_stars) as doubt_clearing_stars, SUM(mentorship_stars) as mentorship_stars, SUM(tech_support_stars) as tech_support_stars from `coaching_reviews` where `coaching_id` = 362 limit 1
        870μs/app/Http/Controllers/Website/CoachingSearchController.php:1183coachingselect
        Metadata
        Bindings
        • 0. 362
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1183
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:480
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `coaching_reviews` where `coaching_id` = 362
        450μs/app/Http/Controllers/Website/CoachingSearchController.php:1190coachingselect
        Metadata
        Bindings
        • 0. 362
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:1190
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:480
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • update `coaching` set `ratings` = '5.0' where `id` = 362
        3.15ms/app/Http/Controllers/Website/CoachingSearchController.php:484coachingselect
        Metadata
        Bindings
        • 0. 5.0
        • 1. 362
        Backtrace
        • 10. /app/Http/Controllers/Website/CoachingSearchController.php:484
        • 11. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select * from `coaching_facility` inner join `facility` on `facility`.`name` = `coaching_facility`.`name` where `coaching_facility`.`coaching_id` = 362 and `coaching_facility`.`status` = 'enable'
        7.81ms/app/Http/Controllers/Website/CoachingSearchController.php:505coachingselect
        Metadata
        Bindings
        • 0. 362
        • 1. enable
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:505
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 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_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` = 362 and `coaching_courses`.`status` = 'enable' and `coaching_courses`.`status` = 'enable' and `coaching_courses_detail`.`status` = 'enable'
        11.32ms/app/Http/Controllers/Website/CoachingSearchController.php:514coachingselect
        Metadata
        Bindings
        • 0. 362
        • 1. enable
        • 2. enable
        • 3. enable
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:514
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 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 `offer_percentage` from `coaching_courses_detail` where `coaching_id` = 362 order by `offer_percentage` desc limit 1
        2.2ms/app/Http/Controllers/Website/CoachingSearchController.php:525coachingselect
        Metadata
        Bindings
        • 0. 362
        Backtrace
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:525
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:72
        • 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 `coaching`.* from `coaching` inner join `coaching_courses_detail` on `coaching_courses_detail`.`coaching_id` = `coaching`.`id` where `coaching`.`status` = 'enable' and `coaching_courses_detail`.`is_featured` = 1 and `coaching_courses_detail`.`offering` LIKE '%online%' group by `coaching_courses_detail`.`name` order by `coaching_courses_detail`.`offer_percentage` desc
        3.67ms/app/Http/Controllers/Website/CoachingSearchController.php:963coachingselect
        Metadata
        Bindings
        • 0. enable
        • 1. 1
        • 2. %online%
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:963
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 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 `coaching_courses_detail` where `coaching_id` = 58 and `offering` LIKE '%online%' and `is_featured` = 1 order by `offer_percentage` desc limit 1
        5.8ms/app/Http/Controllers/Website/CoachingSearchController.php:984coachingselect
        Metadata
        Bindings
        • 0. 58
        • 1. %online%
        • 2. 1
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:984
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select count(*) as aggregate from `coaching_courses_detail` where `coaching_id` = 58
        2.16ms/app/Http/Controllers/Website/CoachingSearchController.php:999coachingselect
        Metadata
        Bindings
        • 0. 58
        Backtrace
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:999
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 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(faculty_stars) as faculty_stars, SUM(study_materials_stars) as study_materials_stars, SUM(doubt_clearing_stars) as doubt_clearing_stars, SUM(mentorship_stars) as mentorship_stars, SUM(tech_support_stars) as tech_support_stars from `coaching_reviews` where `coaching_id` = 58 limit 1
        630μs/app/Http/Controllers/Website/CoachingSearchController.php:1183coachingselect
        Metadata
        Bindings
        • 0. 58
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1183
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `coaching_reviews` where `coaching_id` = 58
        430μs/app/Http/Controllers/Website/CoachingSearchController.php:1190coachingselect
        Metadata
        Bindings
        • 0. 58
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:1190
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `coaching_courses_detail` where `coaching_id` = 69 and `offering` LIKE '%online%' and `is_featured` = 1 and `name` not in ('Maths') order by `offer_percentage` desc limit 1
        5.7ms/app/Http/Controllers/Website/CoachingSearchController.php:989coachingselect
        Metadata
        Bindings
        • 0. 69
        • 1. %online%
        • 2. 1
        • 3. Maths
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:989
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select count(*) as aggregate from `coaching_courses_detail` where `coaching_id` = 69
        1.6ms/app/Http/Controllers/Website/CoachingSearchController.php:999coachingselect
        Metadata
        Bindings
        • 0. 69
        Backtrace
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:999
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 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(faculty_stars) as faculty_stars, SUM(study_materials_stars) as study_materials_stars, SUM(doubt_clearing_stars) as doubt_clearing_stars, SUM(mentorship_stars) as mentorship_stars, SUM(tech_support_stars) as tech_support_stars from `coaching_reviews` where `coaching_id` = 69 limit 1
        610μs/app/Http/Controllers/Website/CoachingSearchController.php:1183coachingselect
        Metadata
        Bindings
        • 0. 69
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1183
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `coaching_reviews` where `coaching_id` = 69
        450μs/app/Http/Controllers/Website/CoachingSearchController.php:1190coachingselect
        Metadata
        Bindings
        • 0. 69
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:1190
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `coaching_courses_detail` where `coaching_id` = 69 and `offering` LIKE '%online%' and `is_featured` = 1 and `name` not in ('Maths', 'JEE 1 Year Course') order by `offer_percentage` desc limit 1
        5.69ms/app/Http/Controllers/Website/CoachingSearchController.php:989coachingselect
        Metadata
        Bindings
        • 0. 69
        • 1. %online%
        • 2. 1
        • 3. Maths
        • 4. JEE 1 Year Course
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:989
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select count(*) as aggregate from `coaching_courses_detail` where `coaching_id` = 69
        950μs/app/Http/Controllers/Website/CoachingSearchController.php:999coachingselect
        Metadata
        Bindings
        • 0. 69
        Backtrace
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:999
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 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(faculty_stars) as faculty_stars, SUM(study_materials_stars) as study_materials_stars, SUM(doubt_clearing_stars) as doubt_clearing_stars, SUM(mentorship_stars) as mentorship_stars, SUM(tech_support_stars) as tech_support_stars from `coaching_reviews` where `coaching_id` = 69 limit 1
        410μs/app/Http/Controllers/Website/CoachingSearchController.php:1183coachingselect
        Metadata
        Bindings
        • 0. 69
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1183
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `coaching_reviews` where `coaching_id` = 69
        450μs/app/Http/Controllers/Website/CoachingSearchController.php:1190coachingselect
        Metadata
        Bindings
        • 0. 69
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:1190
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `coaching_courses_detail` where `coaching_id` = 964 and `offering` LIKE '%online%' and `is_featured` = 1 and `name` not in ('Maths', 'JEE 1 Year Course', 'NEET 1 Year Course') order by `offer_percentage` desc limit 1
        4.64ms/app/Http/Controllers/Website/CoachingSearchController.php:989coachingselect
        Metadata
        Bindings
        • 0. 964
        • 1. %online%
        • 2. 1
        • 3. Maths
        • 4. JEE 1 Year Course
        • 5. NEET 1 Year Course
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:989
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select count(*) as aggregate from `coaching_courses_detail` where `coaching_id` = 964
        910μs/app/Http/Controllers/Website/CoachingSearchController.php:999coachingselect
        Metadata
        Bindings
        • 0. 964
        Backtrace
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:999
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 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(faculty_stars) as faculty_stars, SUM(study_materials_stars) as study_materials_stars, SUM(doubt_clearing_stars) as doubt_clearing_stars, SUM(mentorship_stars) as mentorship_stars, SUM(tech_support_stars) as tech_support_stars from `coaching_reviews` where `coaching_id` = 964 limit 1
        390μs/app/Http/Controllers/Website/CoachingSearchController.php:1183coachingselect
        Metadata
        Bindings
        • 0. 964
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1183
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `coaching_reviews` where `coaching_id` = 964
        270μs/app/Http/Controllers/Website/CoachingSearchController.php:1190coachingselect
        Metadata
        Bindings
        • 0. 964
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:1190
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `coaching_courses_detail` where `coaching_id` = 982 and `offering` LIKE '%online%' and `is_featured` = 1 and `name` not in ('Maths', 'JEE 1 Year Course', 'NEET 1 Year Course', 'NMAT 2023') order by `offer_percentage` desc limit 1
        4.29ms/app/Http/Controllers/Website/CoachingSearchController.php:989coachingselect
        Metadata
        Bindings
        • 0. 982
        • 1. %online%
        • 2. 1
        • 3. Maths
        • 4. JEE 1 Year Course
        • 5. NEET 1 Year Course
        • 6. NMAT 2023
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:989
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
      • select count(*) as aggregate from `coaching_courses_detail` where `coaching_id` = 982
        990μs/app/Http/Controllers/Website/CoachingSearchController.php:999coachingselect
        Metadata
        Bindings
        • 0. 982
        Backtrace
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:999
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 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(faculty_stars) as faculty_stars, SUM(study_materials_stars) as study_materials_stars, SUM(doubt_clearing_stars) as doubt_clearing_stars, SUM(mentorship_stars) as mentorship_stars, SUM(tech_support_stars) as tech_support_stars from `coaching_reviews` where `coaching_id` = 982 limit 1
        670μs/app/Http/Controllers/Website/CoachingSearchController.php:1183coachingselect
        Metadata
        Bindings
        • 0. 982
        Backtrace
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1183
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 15. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `id` from `coaching_reviews` where `coaching_id` = 982
        390μs/app/Http/Controllers/Website/CoachingSearchController.php:1190coachingselect
        Metadata
        Bindings
        • 0. 982
        Backtrace
        • 12. /app/Http/Controllers/Website/CoachingSearchController.php:1190
        • 13. /app/Http/Controllers/Website/CoachingSearchController.php:1001
        • 14. /app/Http/Controllers/Website/CoachingSearchController.php:90
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `courses_details` from `college` where `status` = 1 order by `college`.`created_at` asc
        950μ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
        760μs/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
        880μs/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
        710μs/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
        1.12ms/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
        880μs/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
        950μs/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
        780μ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` = 'small' and `position` is null and `status` = 'enable' and `start_date` <= '2025-08-16' and `end_date` >= '2025-08-16' order by RAND() limit 1
        1.06ms/app/Http/Controllers/Website/HeaderController.php:239coachingselect
        Metadata
        Bindings
        • 0. small
        • 1. enable
        • 2. 2025-08-16
        • 3. 2025-08-16
        Backtrace
        • 13. /app/Http/Controllers/Website/HeaderController.php:239
        • 14. view::50a79f7d5f6ed61c3097c4d5c623d6cad6a10043:488
        • 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-16' and `end_date` >= '2025-08-16' order by RAND() limit 1
        780μs/app/Http/Controllers/Website/HeaderController.php:239coachingselect
        Metadata
        Bindings
        • 0. full
        • 1. enable
        • 2. 2025-08-16
        • 3. 2025-08-16
        Backtrace
        • 13. /app/Http/Controllers/Website/HeaderController.php:239
        • 14. view::50a79f7d5f6ed61c3097c4d5c623d6cad6a10043:521
        • 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-16' and `end_date` >= '2025-08-16' order by RAND() limit 1
        850μs/app/Http/Controllers/Website/HeaderController.php:239coachingselect
        Metadata
        Bindings
        • 0. full
        • 1. enable
        • 2. 2025-08-16
        • 3. 2025-08-16
        Backtrace
        • 13. /app/Http/Controllers/Website/HeaderController.php:239
        • 14. view::50a79f7d5f6ed61c3097c4d5c623d6cad6a10043:798
        • 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
          c7jGkdA6kv922OtUWk0dFEjnqftE5SIcezTBgGIy
          _previous
          array:1 [ "url" => "http://64.227.150.69/best-AIMA-UGAT-all-coaching?page=2" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /best-AIMA-UGAT-all-coaching
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "page" => "2" ]
          request_request
          0 of 0
          array:1 [ "page" => "2" ]
          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-tcdsg (squid/6.10)" ] "x-forwarded-for" => array:1 [ 0 => "10.2.126.71" ] "cache-control" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] ]
          request_server
          0 of 0
          array:36 [ "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-tcdsg (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.2.126.71" "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.44" "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" => "34880" "REDIRECT_URL" => "/best-AIMA-UGAT-all-coaching" "REDIRECT_QUERY_STRING" => "page=2" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "page=2" "REQUEST_URI" => "/best-AIMA-UGAT-all-coaching?page=2" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1755323964.178 "REQUEST_TIME" => 1755323964 ]
          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 => "Sat, 16 Aug 2025 05:59:24 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ild3QUhKVldoZ2R0Uk9UWTlmMWJUYmc9PSIsInZhbHVlIjoiSTJieHl2Sndxc0hxVGw1YlQ0VzVtTXR0dkhmdHBleGpDUmpHa01leGlMeFRUaERkTFVXYXJ4MEhBbjNTOWMwWHREYjVmT24zb01JNXBxdjRzdzBncXIyU3ZvUEdReGl6SDJuc2Qzbk1JR2wvTVZsR2JtazVJd01VdXNnTGgwTnYiLCJtYWMiOiJkZWFkM2E1Y2U3OWFlNTg0NDdjMTQ1MzU1MmMwM2JlNjI1MjhiMTYzOGMyZjlhNmE5N2E0NWM2MTE5YzY3MWYyIn0%3D; expires=Sun, 16-Aug-2026 05:59:24 GMT; Max-Age=31536000; path=/XSRF-TOKEN=eyJpdiI6Ild3QUhKVldoZ2R0Uk9UWTlmMWJUYmc9PSIsInZhbHVlIjoiSTJieHl2Sndxc0hxVGw1YlQ0VzVtTXR0dkhmdHBleGpDUmpHa01leGlMeFRUaERkTFVXYXJ4MEhBbjNTOWMwWHREYjVmT" 1 => "coachingselect_session=eyJpdiI6IjJHSTVvby85aVd0aU81NzRWckNsVEE9PSIsInZhbHVlIjoiRWc5SGk4YWdIREcvTFdsYldvZ2FIcUhYL1VZbEh6WmxxdHBtbnptSGtDSUpqRERjQnhJTGNDRWJWYmJRNGhtcWMvUVlMbkIreHkvRVVrZi9POW9jcjB6ZzV2SDh1VVh6Ly9ONEFBcUhlWUFMWkdlOFIwKzNiLzlBbW8zNEdxNDciLCJtYWMiOiI0NTJkMGE3NjBhNDY4YmZiMTM2M2M2ZTczMjRkMDIzYmRlNzVlZDE1ZWFhYzQxMzEzYjM2NDViZjI2NjljMDgyIn0%3D; expires=Sun, 16-Aug-2026 05:59:24 GMT; Max-Age=31536000; path=/; httponlycoachingselect_session=eyJpdiI6IjJHSTVvby85aVd0aU81NzRWckNsVEE9PSIsInZhbHVlIjoiRWc5SGk4YWdIREcvTFdsYldvZ2FIcUhYL1VZbEh6WmxxdHBtbnptSGtDSUpqRERjQnhJTGNDRWJWYmJRN" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ild3QUhKVldoZ2R0Uk9UWTlmMWJUYmc9PSIsInZhbHVlIjoiSTJieHl2Sndxc0hxVGw1YlQ0VzVtTXR0dkhmdHBleGpDUmpHa01leGlMeFRUaERkTFVXYXJ4MEhBbjNTOWMwWHREYjVmT24zb01JNXBxdjRzdzBncXIyU3ZvUEdReGl6SDJuc2Qzbk1JR2wvTVZsR2JtazVJd01VdXNnTGgwTnYiLCJtYWMiOiJkZWFkM2E1Y2U3OWFlNTg0NDdjMTQ1MzU1MmMwM2JlNjI1MjhiMTYzOGMyZjlhNmE5N2E0NWM2MTE5YzY3MWYyIn0%3D; expires=Sun, 16-Aug-2026 05:59:24 GMT; path=/XSRF-TOKEN=eyJpdiI6Ild3QUhKVldoZ2R0Uk9UWTlmMWJUYmc9PSIsInZhbHVlIjoiSTJieHl2Sndxc0hxVGw1YlQ0VzVtTXR0dkhmdHBleGpDUmpHa01leGlMeFRUaERkTFVXYXJ4MEhBbjNTOWMwWHREYjVmT" 1 => "coachingselect_session=eyJpdiI6IjJHSTVvby85aVd0aU81NzRWckNsVEE9PSIsInZhbHVlIjoiRWc5SGk4YWdIREcvTFdsYldvZ2FIcUhYL1VZbEh6WmxxdHBtbnptSGtDSUpqRERjQnhJTGNDRWJWYmJRNGhtcWMvUVlMbkIreHkvRVVrZi9POW9jcjB6ZzV2SDh1VVh6Ly9ONEFBcUhlWUFMWkdlOFIwKzNiLzlBbW8zNEdxNDciLCJtYWMiOiI0NTJkMGE3NjBhNDY4YmZiMTM2M2M2ZTczMjRkMDIzYmRlNzVlZDE1ZWFhYzQxMzEzYjM2NDViZjI2NjljMDgyIn0%3D; expires=Sun, 16-Aug-2026 05:59:24 GMT; path=/; httponlycoachingselect_session=eyJpdiI6IjJHSTVvby85aVd0aU81NzRWckNsVEE9PSIsInZhbHVlIjoiRWc5SGk4YWdIREcvTFdsYldvZ2FIcUhYL1VZbEh6WmxxdHBtbnptSGtDSUpqRERjQnhJTGNDRWJWYmJRN" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "c7jGkdA6kv922OtUWk0dFEjnqftE5SIcezTBgGIy" "_previous" => array:1 [ "url" => "http://64.227.150.69/best-AIMA-UGAT-all-coaching?page=2" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]