8.1.27PHP Version20.07msRequest Duration2MBMemory UsageGET listingRoute
    • Booting (8.38ms)
    • Application (11.61ms)
    • 1 x Application (57.88%)
      11.61ms
      1 x Booting (41.74%)
      8.38ms
      5 templates were rendered
      • theme.modern.listing (resources/views/theme/modern/listing.blade.php)13blade
        Params
        0
        ads
        1
        title
        2
        categories
        3
        countries
        4
        selected_categories
        5
        selected_sub_categories
        6
        selected_countries
        7
        selected_states
        8
        personal_ads_count
        9
        business_ads_count
        10
        premium_ads
        11
        lUser
        12
        enable_monetize
      • pagination::tailwind (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/tailwind.blade.php)4blade
        Params
        0
        paginator
        1
        elements
        2
        lUser
        3
        enable_monetize
      • layout.main (resources/views/layout/main.blade.php)24blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        ads
        4
        title
        5
        categories
        6
        countries
        7
        selected_categories
        8
        selected_sub_categories
        9
        selected_countries
        10
        selected_states
        11
        personal_ads_count
        12
        business_ads_count
        13
        premium_ads
        14
        lUser
        15
        enable_monetize
        16
        __currentLoopData
        17
        category
        18
        loop
        19
        sub_category
        20
        country_usage
        21
        allAdTab
        22
        personalAdTab
        23
        businessAdTab
      • layout.header (resources/views/layout/header.blade.php)24blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        ads
        4
        title
        5
        categories
        6
        countries
        7
        selected_categories
        8
        selected_sub_categories
        9
        selected_countries
        10
        selected_states
        11
        personal_ads_count
        12
        business_ads_count
        13
        premium_ads
        14
        lUser
        15
        enable_monetize
        16
        __currentLoopData
        17
        category
        18
        loop
        19
        sub_category
        20
        country_usage
        21
        allAdTab
        22
        personalAdTab
        23
        businessAdTab
      • layout.footer (resources/views/layout/footer.blade.php)24blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        ads
        4
        title
        5
        categories
        6
        countries
        7
        selected_categories
        8
        selected_sub_categories
        9
        selected_countries
        10
        selected_states
        11
        personal_ads_count
        12
        business_ads_count
        13
        premium_ads
        14
        lUser
        15
        enable_monetize
        16
        __currentLoopData
        17
        category
        18
        loop
        19
        sub_category
        20
        country_usage
        21
        allAdTab
        22
        personalAdTab
        23
        businessAdTab
      uri
      GET listing
      middleware
      web
      as
      listing
      controller
      App\Http\Controllers\AdsController@listing
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/AdsController.php:571-716
      13 statements were executed2.39ms
      • select count(*) as aggregate from `ads` where `status` = '1' and `category_id` = '13'220μsu695830545_medauc
        Metadata
        Bindings
        • 0. 1
        • 1. 13
      • select * from `ads` where `status` = '1' and `price_plan` = 'premium' and `category_id` = '13' and `max_impression` < '50' and `created_at` >= '2024-12-07 15:58:03' order by `id` desc limit 3290μsu695830545_medauc
        Metadata
        Bindings
        • 0. 1
        • 1. premium
        • 2. 13
        • 3. 50
        • 4. 2024-12-07 15:58:03
        Hints
        • Use SELECT * only if you need all columns from table
      • select count(*) as aggregate from `ads` where `status` = '1' and `type` = 'business' and `category_id` = '13'190μsu695830545_medauc
        Metadata
        Bindings
        • 0. 1
        • 1. business
        • 2. 13
      • select count(*) as aggregate from `ads` where `status` = '1' and `type` = 'personal' and `category_id` = '13'170μsu695830545_medauc
        Metadata
        Bindings
        • 0. 1
        • 1. personal
        • 2. 13
      • select * from `categories` where `category_id` = 0280μsu695830545_medauc
        Metadata
        Bindings
        • 0. 0
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `countries`140μsu695830545_medauc
        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 `categories` where `categories`.`id` = '13' limit 1160μsu695830545_medauc
        Metadata
        Bindings
        • 0. 13
        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 `categories` where `categories`.`id` is null limit 1100μsu695830545_medauc
        Metadata
        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 `countries` where `countries`.`id` is null limit 190μsu695830545_medauc
        Metadata
        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 `states` where `states`.`id` is null limit 190μsu695830545_medauc
        Metadata
        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 `categories` where `categories`.`category_id` = 13 and `categories`.`category_id` is not null260μsu695830545_medauc
        Metadata
        Bindings
        • 0. 13
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `posts` where `status` = '1' and `show_in_header_menu` = 1210μsu695830545_medauc
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `posts` where `status` = '1' and `show_in_footer_menu` = 1190μsu695830545_medauc
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
      App\Sub_Category
      4
      App\Country
      1
      App\Category
      24
        _token
        EcxXnrlGzdt7DaE3prPhWk1027Pke5gLSqZUpF65
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /listing
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:2 [ "category" => "13" "shortBy" => "price_low_to_high" ]
        request_request
        0 of 0
        array:2 [ "category" => "13" "shortBy" => "price_low_to_high" ]
        request_headers
        0 of 0
        array:15 [ "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, br, zstd" ] "host" => array:1 [ 0 => "medauc.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
        request_server
        0 of 0
        array:54 [ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "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, br, zstd" "HTTP_HOST" => "medauc.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/u695830545/domains/medauc.com/public_html" "REMOTE_ADDR" => "3.129.250.222" "REMOTE_PORT" => "61738" "SERVER_ADDR" => "153.92.8.32" "SERVER_NAME" => "medauc.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/listing?category=13&shortBy=price_low_to_high" "REDIRECT_URL" => "/listing" "REDIRECT_QUERY_STRING" => "category=13&shortBy=price_low_to_high" "REDIRECT_REQUEST_METHOD" => "GET" "HTTPS" => "on" "CRAWLER_USLEEP" => "1000" "CRAWLER_LOAD_LIMIT_ENFORCE" => "25" "H_PLATFORM" => "Hostinger" "H_TYPE" => "shared" "H_CANARY" => "false" "H_STAGING" => "false" "REDIRECT_STATUS" => "200" "X_SPDY" => "HTTP2" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256" "SSL_CIPHER_USEKEYSIZE" => "128" "SSL_CIPHER_ALGKEYSIZE" => "128" "SCRIPT_FILENAME" => "/home/u695830545/domains/medauc.com/public_html/index.php" "QUERY_STRING" => "category=13&shortBy=price_low_to_high" "SCRIPT_URI" => "https://medauc.com/listing" "SCRIPT_URL" => "/listing" "SCRIPT_NAME" => "/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on,crawler,esi,combine" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1736161083.79 "REQUEST_TIME" => 1736161083 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 06 Jan 2025 10:58:03 GMT" ] ]
        session_attributes
        0 of 0
        array:2 [ "_token" => "EcxXnrlGzdt7DaE3prPhWk1027Pke5gLSqZUpF65" "PHPDEBUGBAR_STACK_DATA" => [] ]