E-Fish Report

Total AquaCulture

468367.75

Fresh Water Aquaculture

332279.67

Brackish Water Aquaculture

63158.47

Total Farmers

66928

  1. All
S.No. District Total Aquaculture Fresh water Aquaculture Brackish water Aquaculture Total Farmers
1 Srikakulam 1964.98 812.93 1131.29 444
2 Vizianagaram 503.12 428.66 54.46 50
3 Visakhapatnam 29.57 23.16 4.94 5
4 East Godavari 1322.6 684.41 0 398
5 West Godavari 104959.94 87106.15 802.33 18600
6 Krishna 98433.31 66046.96 20175.22 10015
7 Guntur 181.52 178.81 0 52
8 Prakasam 6813.49 2830.19 3966.9 1096
9 SPSR Nellore 32329.6 19575.3 7131.4 7871
10 Chittoor 1 1 0 1
11 YSR Kadapa 126.53 126.53 0 9
12 Ananthapuramu 70.41 70.41 0 5
13 Kurnool 660.42 659.22 0 51
14 Parvathipuram Manyam 157.54 157.54 0 20
15 Alluri Sitarama Raju 12.01 10.51 0 6
16 Anakapalle 1844.47 740.61 872.33 214
17 Kakinada 17662.67 12192.36 2272.03 4124
18 Konaseema 34086.35 14876.69 8900.78 6360
19 Eluru 139484.98 117270.32 350.69 12567
20 NTR 212.87 202.62 0 29
21 Bapatla 19448.75 4866.89 13242.67 3833
22 Palnadu 1904.97 1625.94 0 220
23 Tirupati 6078.21 1719.53 4253.42 1474
24 Nandyal 78.44 72.94 0 14
Total 468367.75 332279.68 63158.46 67458
MessagesTimelineExceptionsViews3RouteQueries5Models51MailsGateSessionRequest
7.4.14PHP Version9.51sRequest Duration5MBMemory UsageGET dashboardRoute
    • Booting (50.06ms)
    • Application (9.46s)
    • 1 x Application (99.47%)
      9.46s
      1 x Booting (0.53%)
      50.06ms
      3 templates were rendered
      • applications::efish_dashboard (Modules/Applications/Resources/views/efish_dashboard.blade.php)3blade
        Params
        0
        ptitle
        1
        district_id
        2
        efish_data
      • applications::efish-dashboard-widget (Modules/Applications/Resources/views/efish-dashboard-widget.blade.php)7blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        ptitle
        5
        district_id
        6
        efish_data
      • theme.admin::layouts.dashboard (public/themes/admin/layouts/dashboard.blade.php)0blade
      uri
      GET dashboard
      middleware
      web
      controller
      Modules\Applications\Http\Controllers\DashboardController@dashboard
      namespace
      Modules\Applications\Http\Controllers
      prefix
      where
      file
      Modules/Applications/Http/Controllers/DashboardController.php:26-105
      5 statements were executed, 3 of which were duplicated, 2 unique9.44s
      efish_survey
      • select * from `settings`
        3.93ms/public/themes/admin/config.php:38efish_survey
        Metadata
        Backtrace
        • 15. /public/themes/admin/config.php:38
        • 16. /vendor/facuz/laravel-themes/src/Theme.php:493
        • 17. /vendor/facuz/laravel-themes/src/Theme.php:523
        • 18. /vendor/facuz/laravel-themes/src/Theme.php:539
        • 20. /Modules/Applications/Http/Controllers/DashboardController.php:30
      • select `W`.`DIST_CODE`, `D`.`district_name` as `DIST_NAME`, `W`.`MAND_NAME`, `W`.`MAND_CODE`, ROUND(SUM(L.CULTIVABLE_EXTENT), 2) as TOTAL_EXT, COUNT(DISTINCT L.FARMER_ID) as FARMERS_TOTAL, ROUND(SUM(CASE WHEN P.TYPES_OF_CULTURE_ID NOT IN (2, 3) THEN L.CULTIVABLE_EXTENT ELSE 0 END),2) as FRESH_WATER_ACRS, ROUND(SUM(CASE WHEN P.TYPES_OF_CULTURE_ID IN (2, 3) THEN L.CULTIVABLE_EXTENT ELSE 0 END),2) as BRACK_WATER_ACRS from `TBL_FARMER_LAND_MAP` as `L` left join (SELECT ASSESSMENT_NO, FARMER_ID, TYPES_OF_CULTURE_ID FROM TBL_POND_DETAILS WHERE STATUS=1 GROUP BY ASSESSMENT_NO, FARMER_ID) as P on `P`.`ASSESSMENT_NO` = `L`.`ASSESSMENT_NO` and `P`.`FARMER_ID` = `L`.`FARMER_ID` left join `TBL_WEBLAND_DATA` as `W` on `L`.`WEBLAND_ID` = `W`.`ID` left join `nic_district_master` as `D` on `D`.`wbdcode` = `W`.`DIST_CODE` where `L`.`STATUS` = 1 and `W`.`DIST_CODE` is not null
        4.54s/Modules/Applications/Http/Controllers/DashboardController.php:66efish_survey
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 12. /Modules/Applications/Http/Controllers/DashboardController.php:66
        • 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 `W`.`DIST_CODE`, `D`.`district_name` as `DIST_NAME`, `W`.`MAND_NAME`, `W`.`MAND_CODE`, ROUND(SUM(L.CULTIVABLE_EXTENT), 2) as TOTAL_EXT, COUNT(DISTINCT L.FARMER_ID) as FARMERS_TOTAL, ROUND(SUM(CASE WHEN P.TYPES_OF_CULTURE_ID NOT IN (2, 3) THEN L.CULTIVABLE_EXTENT ELSE 0 END),2) as FRESH_WATER_ACRS, ROUND(SUM(CASE WHEN P.TYPES_OF_CULTURE_ID IN (2, 3) THEN L.CULTIVABLE_EXTENT ELSE 0 END),2) as BRACK_WATER_ACRS from `TBL_FARMER_LAND_MAP` as `L` left join (SELECT ASSESSMENT_NO, FARMER_ID, TYPES_OF_CULTURE_ID FROM TBL_POND_DETAILS WHERE STATUS=1 GROUP BY ASSESSMENT_NO, FARMER_ID) as P on `P`.`ASSESSMENT_NO` = `L`.`ASSESSMENT_NO` and `P`.`FARMER_ID` = `L`.`FARMER_ID` left join `TBL_WEBLAND_DATA` as `W` on `L`.`WEBLAND_ID` = `W`.`ID` left join `nic_district_master` as `D` on `D`.`wbdcode` = `W`.`DIST_CODE` where `L`.`STATUS` = 1 and `W`.`DIST_CODE` is not null group by `W`.`DIST_CODE`
        4.9s/Modules/Applications/Http/Controllers/DashboardController.php:74efish_survey
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 12. /Modules/Applications/Http/Controllers/DashboardController.php:74
        • 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 `settings`
        630μs/public/themes/admin/config.php:38efish_survey
        Metadata
        Backtrace
        • 15. /public/themes/admin/config.php:38
        • 16. /vendor/facuz/laravel-themes/src/Theme.php:493
        • 17. /vendor/facuz/laravel-themes/src/Theme.php:523
        • 18. /vendor/facuz/laravel-themes/src/Theme.php:539
        • 20. /Modules/Applications/Http/Controllers/DashboardController.php:104
      • select * from `settings`
        450μs/public/themes/admin/config.php:38efish_survey
        Metadata
        Backtrace
        • 15. /public/themes/admin/config.php:38
        • 16. /vendor/facuz/laravel-themes/src/Theme.php:493
        • 17. /vendor/facuz/laravel-themes/src/Theme.php:523
        • 18. /vendor/facuz/laravel-themes/src/Theme.php:539
        • 19. /vendor/facuz/laravel-themes/src/Theme.php:237
      Modules\Cms\Entities\Setting
      51
          _token
          oYj8XNXI0hBhWbPFHQkAfHVB5XIwkTol9uW2l7QH
          _previous
          array:1 [ "url" => "https://ematsyakar.com/efish/dashboard" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /dashboard
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          request_request
          []
          request_headers
            0 of 0   
          array:15 [▼
  "host" => array:1 [▶
    0 => "ematsyakar.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "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"
  ]
  "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"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]
          request_server
            0 of 0   
          array:46 [▼
  "REDIRECT_UNIQUE_ID" => "aCzXI1KBIjHaWtzrfLg7xAAAAAk"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "ematsyakar.com"
  "REDIRECT_STATUS" => "200"
  "UNIQUE_ID" => "aCzXI1KBIjHaWtzrfLg7xAAAAAk"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "ematsyakar.com"
  "HTTP_HOST" => "ematsyakar.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "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_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin"
  "SERVER_SIGNATURE" => ""
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_NAME" => "ematsyakar.com"
  "SERVER_ADDR" => "10.0.8.226"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "18.220.45.179"
  "DOCUMENT_ROOT" => "/var/www/html"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html"
  "SERVER_ADMIN" => "root@localhost"
  "SCRIPT_FILENAME" => "/var/www/html/efish/index.php"
  "REMOTE_PORT" => "49944"
  "REDIRECT_URL" => "/efish/dashboard"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/efish/dashboard"
  "SCRIPT_NAME" => "/efish/index.php"
  "PHP_SELF" => "/efish/index.php"
  "REQUEST_TIME_FLOAT" => 1747769123.9261
  "REQUEST_TIME" => 1747769123
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:7 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=0, must-revalidate, no-store, nocache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 20 May 2025 19:25:33 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "Sun, 02 Jan 1990 00:00:00 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImlUcURZQ3B5aE1ucytocVdwcjBIQWc9PSIsInZhbHVlIjoiWEh5eGI4Nzd0WlZjbkUvVnE5MnNHeVJvbUZPSWk4SktoMFFwWWZud1VuT2JESnV2QlBLVGU2R2JVTk9sd2x3YWdzTTBIVisrZzJkdmgzT0FhT0E2T2dnV2U0NUdiTXBzZEJROXFQUWZ1bjlDMyswNG9IUXorNjM3N2pHWTJCMkUiLCJtYWMiOiIzZDNjYzQ1MzQ4NTlmZjY2YmM4MzAzNTZjNWYyMTE2M2Q4Y2YwYjQxYWMwODkzMTRiZmE2MjFhZGZkYjRiNjhmIn0%3D; expires=Tue, 20-May-2025 20:05:33 GMT; Max-Age=2400; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6ImlUcURZQ3B5aE1ucytocVdwcjBIQWc9PSIsInZhbHVlIjoiWEh5eGI4Nzd0WlZjbkUvVnE5MnNHeVJvbUZPSWk4SktoMFFwWWZud1VuT2JESnV2QlBLVGU2R2JVTk9sd2x3YWdzTTBIV ▶"
    1 => "laravel_session=eyJpdiI6IjBzdnNnWDBuWm50bms1blRSaCtjc2c9PSIsInZhbHVlIjoiMDRhLzI0dXRQVERFR1RWcm9jcC81ZFlScFg5bldyWHV1N1p5dHBkL253WWdmZ1R6bUZydDU5VGJIWTdocENrVlZRc2NtS3JMcXJRS1JqQUM4ZFhSN1Uyd2ErLzQvTzFHeHZzbmx4dXNLQzJ5VU8xNGU5Y0RjS3BibnFsbWNQa1UiLCJtYWMiOiJhYmQ4ZmNiMTQ0N2E0YTc1ZTQyY2ZlNmZlMDBkYzgyOTE1ZDE0Zjg3YjlhNmE0ZTc3ODk0YmQxNGI0YTc3MWM3In0%3D; expires=Tue, 20-May-2025 20:05:33 GMT; Max-Age=2400; path=/; secure; httponly; samesite=strict ◀laravel_session=eyJpdiI6IjBzdnNnWDBuWm50bms1blRSaCtjc2c9PSIsInZhbHVlIjoiMDRhLzI0dXRQVERFR1RWcm9jcC81ZFlScFg5bldyWHV1N1p5dHBkL253WWdmZ1R6bUZydDU5VGJIWTdocENrVlZR ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImlUcURZQ3B5aE1ucytocVdwcjBIQWc9PSIsInZhbHVlIjoiWEh5eGI4Nzd0WlZjbkUvVnE5MnNHeVJvbUZPSWk4SktoMFFwWWZud1VuT2JESnV2QlBLVGU2R2JVTk9sd2x3YWdzTTBIVisrZzJkdmgzT0FhT0E2T2dnV2U0NUdiTXBzZEJROXFQUWZ1bjlDMyswNG9IUXorNjM3N2pHWTJCMkUiLCJtYWMiOiIzZDNjYzQ1MzQ4NTlmZjY2YmM4MzAzNTZjNWYyMTE2M2Q4Y2YwYjQxYWMwODkzMTRiZmE2MjFhZGZkYjRiNjhmIn0%3D; expires=Tue, 20-May-2025 20:05:33 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImlUcURZQ3B5aE1ucytocVdwcjBIQWc9PSIsInZhbHVlIjoiWEh5eGI4Nzd0WlZjbkUvVnE5MnNHeVJvbUZPSWk4SktoMFFwWWZud1VuT2JESnV2QlBLVGU2R2JVTk9sd2x3YWdzTTBIV ▶"
    1 => "laravel_session=eyJpdiI6IjBzdnNnWDBuWm50bms1blRSaCtjc2c9PSIsInZhbHVlIjoiMDRhLzI0dXRQVERFR1RWcm9jcC81ZFlScFg5bldyWHV1N1p5dHBkL253WWdmZ1R6bUZydDU5VGJIWTdocENrVlZRc2NtS3JMcXJRS1JqQUM4ZFhSN1Uyd2ErLzQvTzFHeHZzbmx4dXNLQzJ5VU8xNGU5Y0RjS3BibnFsbWNQa1UiLCJtYWMiOiJhYmQ4ZmNiMTQ0N2E0YTc1ZTQyY2ZlNmZlMDBkYzgyOTE1ZDE0Zjg3YjlhNmE0ZTc3ODk0YmQxNGI0YTc3MWM3In0%3D; expires=Tue, 20-May-2025 20:05:33 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IjBzdnNnWDBuWm50bms1blRSaCtjc2c9PSIsInZhbHVlIjoiMDRhLzI0dXRQVERFR1RWcm9jcC81ZFlScFg5bldyWHV1N1p5dHBkL253WWdmZ1R6bUZydDU5VGJIWTdocENrVlZR ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▼
  "_token" => "oYj8XNXI0hBhWbPFHQkAfHVB5XIwkTol9uW2l7QH"
  "_previous" => array:1 [▶
    "url" => "https://ematsyakar.com/efish/dashboard"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]