Location

Categories

More

Cuisines

More

Tags

More
MessagesTimelineExceptionsViews18RouteQueries44MailsSessionRequest
94.87msRequest Duration6MBMemory UsageGET places/{location?}/{filters?}Route
    • Booting (14.93ms)
    • Application (83.38ms)
      18 templates were rendered
      • places.index (resources/views/places/index.blade.php)6blade
        Params
        0
        places
        1
        categories
        2
        cuisines
        3
        cities
        4
        tags
        5
        placesJson
      • layouts.page (resources/views/layouts/page.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
      • layouts.master (resources/views/layouts/master.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • elements.page-meta (resources/views/elements/page-meta.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • css (resources/views/css.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • header (resources/views/header.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • main-menu (resources/views/main-menu.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • main-menu (resources/views/main-menu.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • footer (resources/views/footer.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
        14
        latestPlaces
        15
        latestReviews
      • auth.modals.login (resources/views/auth/modals/login.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • flash::message (resources/views/vendor/flash/message.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • auth.modals.register (resources/views/auth/modals/register.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • flash::message (resources/views/vendor/flash/message.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • elements.modals.flash-msg (resources/views/elements/modals/flash-msg.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • modal-promotions.download-app (resources/views/modal-promotions/download-app.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • js (resources/views/js.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • elements.tracking.facebook_pixel (resources/views/elements/tracking/facebook_pixel.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      • elements.live-chat (resources/views/elements/live-chat.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        places
        5
        categories
        6
        cuisines
        7
        cities
        8
        tags
        9
        placesJson
        10
        deviceType
        11
        title
        12
        pageClass
        13
        class
      uri
      GET places/{location?}/{filters?}
      middleware
      web
      as
      places.index
      controller
      App\Http\Controllers\PlacesController@index
      namespace
      App\Http\Controllers
      prefix
      null
      where
      file
      app/Http/Controllers/PlacesController.php:36-69
      44 statements were executed28.6ms
      default
      • select `slug` from `categories` where `slug` in ('pizzeria')3.76msdefault
        Metadata
        Bindings
        • 0. pizzeria
      • select `slug` from `cuisines` where `slug` in ('pizzeria')480μsdefault
        Metadata
        Bindings
        • 0. pizzeria
      • select `slug` from `tags` where `type` = 'place' and `slug` in ('pizzeria') order by `order_column` asc510μsdefault
        Metadata
        Bindings
        • 0. place
        • 1. pizzeria
      • select count(*) as aggregate from `places` where `active` = '1'510μsdefault
        Metadata
        Bindings
        • 0. 1
      • select * from `places` where `active` = '1' order by `feature` desc, `popular` desc, `created_at` asc limit 28 offset 0600μsdefault
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `places_location` where `places_location`.`id` in ('42', '45', '46', '47', '48', '49')560μsdefault
        Metadata
        Bindings
        • 0. 42
        • 1. 45
        • 2. 46
        • 3. 47
        • 4. 48
        • 5. 49
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cities` where `cities`.`id` in ('8', '10', '30')540μsdefault
        Metadata
        Bindings
        • 0. 8
        • 1. 10
        • 2. 30
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cities` where `cities`.`id` in ('7')470μsdefault
        Metadata
        Bindings
        • 0. 7
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `media` where `media`.`model_id` in ('42', '45', '46', '47', '48', '49') and `media`.`model_type` = 'App\Models\Place' order by `order_column` asc1.44msdefault
        Metadata
        Bindings
        • 0. 42
        • 1. 45
        • 2. 46
        • 3. 47
        • 4. 48
        • 5. 49
        • 6. App\Models\Place
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `places_contact_info` where `places_contact_info`.`id` in ('42', '45', '46', '47', '48', '49')600μsdefault
        Metadata
        Bindings
        • 0. 42
        • 1. 45
        • 2. 46
        • 3. 47
        • 4. 48
        • 5. 49
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `categories` where `categories`.`id` in ('2', '22', '33', '34', '35', '36')640μsdefault
        Metadata
        Bindings
        • 0. 2
        • 1. 22
        • 2. 33
        • 3. 34
        • 4. 35
        • 5. 36
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `reservation_settings` where `reservation_settings`.`place_id` in ('42', '45', '46', '47', '48', '49')630μsdefault
        Metadata
        Bindings
        • 0. 42
        • 1. 45
        • 2. 46
        • 3. 47
        • 4. 48
        • 5. 49
        Hints
        • Use SELECT * only if you need all columns from table
      • select `name`, `id`, `slug` from `cuisines` order by `sort_order` asc490μsdefault
        Metadata
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
      • select * from `tags` order by `order_column` asc500μsdefault
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
      • select `id`, `name`, `slug` from `cities` where `parent_id` is null or `parent_id` = '0' order by `sort_order` asc560μsdefault
        Metadata
        Bindings
        • 0. 0
      • select `id`, `parent_id`, `name`, `slug` from `cities` where `cities`.`parent_id` in ('1', '7', '13', '23', '26')550μsdefault
        Metadata
        Bindings
        • 0. 1
        • 1. 7
        • 2. 13
        • 3. 23
        • 4. 26
      • select `name`, `id`, `slug` from `categories`450μsdefault
        Metadata
        Hints
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
      • select * from `place_opening_hours` where `place_opening_hours`.`place_id` = '42' and `place_opening_hours`.`place_id` is not null570μsdefault
        Metadata
        Bindings
        • 0. 42
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cuisines`.*, `place_cuisines`.`place_id` as `pivot_place_id`, `place_cuisines`.`cuisine_id` as `pivot_cuisine_id` from `cuisines` inner join `place_cuisines` on `cuisines`.`id` = `place_cuisines`.`cuisine_id` where `place_cuisines`.`place_id` = '42'610μsdefault
        Metadata
        Bindings
        • 0. 42
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `place_opening_hours` where `place_opening_hours`.`place_id` = '48' and `place_opening_hours`.`place_id` is not null490μsdefault
        Metadata
        Bindings
        • 0. 48
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cuisines`.*, `place_cuisines`.`place_id` as `pivot_place_id`, `place_cuisines`.`cuisine_id` as `pivot_cuisine_id` from `cuisines` inner join `place_cuisines` on `cuisines`.`id` = `place_cuisines`.`cuisine_id` where `place_cuisines`.`place_id` = '48'620μsdefault
        Metadata
        Bindings
        • 0. 48
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `place_opening_hours` where `place_opening_hours`.`place_id` = '45' and `place_opening_hours`.`place_id` is not null480μsdefault
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cuisines`.*, `place_cuisines`.`place_id` as `pivot_place_id`, `place_cuisines`.`cuisine_id` as `pivot_cuisine_id` from `cuisines` inner join `place_cuisines` on `cuisines`.`id` = `place_cuisines`.`cuisine_id` where `place_cuisines`.`place_id` = '45'560μsdefault
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `place_opening_hours` where `place_opening_hours`.`place_id` = '46' and `place_opening_hours`.`place_id` is not null500μsdefault
        Metadata
        Bindings
        • 0. 46
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cuisines`.*, `place_cuisines`.`place_id` as `pivot_place_id`, `place_cuisines`.`cuisine_id` as `pivot_cuisine_id` from `cuisines` inner join `place_cuisines` on `cuisines`.`id` = `place_cuisines`.`cuisine_id` where `place_cuisines`.`place_id` = '46'560μsdefault
        Metadata
        Bindings
        • 0. 46
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `place_opening_hours` where `place_opening_hours`.`place_id` = '47' and `place_opening_hours`.`place_id` is not null480μsdefault
        Metadata
        Bindings
        • 0. 47
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cuisines`.*, `place_cuisines`.`place_id` as `pivot_place_id`, `place_cuisines`.`cuisine_id` as `pivot_cuisine_id` from `cuisines` inner join `place_cuisines` on `cuisines`.`id` = `place_cuisines`.`cuisine_id` where `place_cuisines`.`place_id` = '47'550μsdefault
        Metadata
        Bindings
        • 0. 47
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `place_opening_hours` where `place_opening_hours`.`place_id` = '49' and `place_opening_hours`.`place_id` is not null480μsdefault
        Metadata
        Bindings
        • 0. 49
        Hints
        • Use SELECT * only if you need all columns from table
      • select `cuisines`.*, `place_cuisines`.`place_id` as `pivot_place_id`, `place_cuisines`.`cuisine_id` as `pivot_cuisine_id` from `cuisines` inner join `place_cuisines` on `cuisines`.`id` = `place_cuisines`.`cuisine_id` where `place_cuisines`.`place_id` = '49'560μsdefault
        Metadata
        Bindings
        • 0. 49
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `places` where `active` = '1' order by `created_at` desc limit 5670μsdefault
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `categories` where `categories`.`id` in ('22', '33', '34', '35', '36')550μsdefault
        Metadata
        Bindings
        • 0. 22
        • 1. 33
        • 2. 34
        • 3. 35
        • 4. 36
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `places_location` where `places_location`.`id` in ('45', '46', '47', '48', '49')560μsdefault
        Metadata
        Bindings
        • 0. 45
        • 1. 46
        • 2. 47
        • 3. 48
        • 4. 49
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `media` where `media`.`model_id` in ('45', '46', '47', '48', '49') and `media`.`model_type` = 'App\Models\Place' order by `order_column` asc1.33msdefault
        Metadata
        Bindings
        • 0. 45
        • 1. 46
        • 2. 47
        • 3. 48
        • 4. 49
        • 5. App\Models\Place
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `reviews` order by `created_at` desc limit 2490μsdefault
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
      • select * from `places` where `places`.`id` in ('42')520μsdefault
        Metadata
        Bindings
        • 0. 42
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `categories` where `categories`.`id` in ('2')500μsdefault
        Metadata
        Bindings
        • 0. 2
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `places_location` where `places_location`.`id` in ('42')460μsdefault
        Metadata
        Bindings
        • 0. 42
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `users` where `users`.`id` in ('1', '7695')590μsdefault
        Metadata
        Bindings
        • 0. 1
        • 1. 7695
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `cities` where `cities`.`id` = '8' limit 1500μsdefault
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `place_rating` where `place_rating`.`place_id` = '49' and `place_rating`.`place_id` is not null limit 1530μsdefault
        Metadata
        Bindings
        • 0. 49
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `cities` where `cities`.`id` = '10' limit 1480μsdefault
        Metadata
        Bindings
        • 0. 10
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `place_rating` where `place_rating`.`place_id` = '48' and `place_rating`.`place_id` is not null limit 1500μsdefault
        Metadata
        Bindings
        • 0. 48
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `media` where `media`.`model_id` = '1' and `media`.`model_id` is not null and `media`.`model_type` = 'App\Models\User'570μsdefault
        Metadata
        Bindings
        • 0. 1
        • 1. App\Models\User
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `media` where `media`.`model_id` = '7695' and `media`.`model_id` is not null and `media`.`model_type` = 'App\Models\User'600μsdefault
        Metadata
        Bindings
        • 0. 7695
        • 1. App\Models\User
        Hints
        • Use SELECT * only if you need all columns from table
        deviceType
        desktop
        _token
        M5Y3zP6WE5Wn9LoxvesvtrgFQtk3Vhh4i2yTSoAf
        _previous
        array:1 [ "url" => "http://dineincyprus.com/places/cyprus/pizzeria" ]
        PHPDEBUGBAR_STACK_DATA
        []
        format
        html
        content_type
        text/html; charset=UTF-8
        status_text
        OK
        status_code
        200
        request_query
        array:4 [ "cities" => array:1 [ 0 => "cyprus" ] "categories" => array:1 [ 0 => "pizzer...
        request_request
        array:4 [ "cities" => array:1 [ 0 => "cyprus" ] "categories" => array:1 [ 0 => "pizzer...
        request_headers
        array:28 [ "x-real-ip" => array:1 [ 0 => "172.71.254.154" ] "x-forwarded-server" => array:...
        request_server
        array:165 [ "HEALTHCHECK_PATH" => "/healthcheck" "MAIL_PORT" => "1025" "GOOGLE_REDIRECT_URL" =...
        request_cookies
        []
        response_headers
        array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
        path_info
        /places/cyprus/pizzeria
        session_attributes
        array:4 [ "deviceType" => "desktop" "_token" => "M5Y3zP6WE5Wn9LoxvesvtrgFQtk3Vhh4i2yTSoAf" "_p...