全板総合勢いランキング

キーワードが「サブカル」と一致するスレを表示しています【検索条件を解除する場合はこのリンクをクリック】

総件数 1件　
< 前へ次へ >

2ch.netもしくは2ch.scのリンクをクリックすると２ｃｈ掲示板へ飛びます

No	スレッド名	更新時刻	レス	勢い
1	【4325】清水ミチコはサブカルだよね【ミッチャン】 2ch.net 2ch.sc サブカルミッチャン清水ミチコサブカル	01/16 8:47:51	357	1

総件数 1件　
< 前へ次へ >

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerRankingItems
- actionindex
- named(empty)
- pass(empty)
- paging(array)
  ThreadItems(array)
  page1
  current1
  count1
  prevPage(false)
  nextPage(false)
  pageCount1
  order(null)
  limit20
  options(empty)
  paramTypenamed
Post data

No post data.

Query string
- intervalL
- title
- keywordサブカル
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerRankingItems
  actionindex
  plugin(null)
- template/
====

Sql Log

Sql Logs

default

Total Time: 15 ms
Total Queries: 6 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `ThreadItems`., `Threadact`., `Threadactsc`., `Catlist`., `ThreadItems`.`id` FROM `data_matome`.`threaddiffL` AS `ThreadItems` INNER JOIN `data_matome`.`threadact` AS `Threadact` ON (`ThreadItems`.`id` = `Threadact`.`id`) LEFT JOIN `data_matome`.`threadactsc` AS `Threadactsc` ON (`Threadact`.`dat` = `Threadactsc`.`dat` AND `Threadact`.`title` = `Threadactsc`.`title`) INNER JOIN `data_matome`.`catlist` AS `Catlist` ON (`Threadact`.`cat` = `Catlist`.`catno`) WHERE ThreadItems.id IN (SELECT Mecabword.id FROM mecabword AS `Mecabword` WHERE `Mecabword`.`keyword` = 'サブカル') ORDER BY `ThreadItems`.`diffcnt` DESC LIMIT 20	1	1	12	maybe slow
SELECT `Mecabword`.`id`, `Mecabword`.`keyword`, `Mecabword`.`bunrui3`, `Mecabword`.`createTime` FROM `data_matome`.`mecabword` AS `Mecabword` WHERE `Mecabword`.`id` = ('1351170402683')	3	3	1	maybe slow
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'サブカル'	1	1	1
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'ミッチャン'	1	1	0
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '清水ミチコ'	1	1	0
SELECT COUNT(*) AS `count` FROM `data_matome`.`threaddiffL` AS `ThreadItems` INNER JOIN `data_matome`.`threadact` AS `Threadact` ON (`ThreadItems`.`id` = `Threadact`.`id`) LEFT JOIN `data_matome`.`threadactsc` AS `Threadactsc` ON (`Threadact`.`dat` = `Threadactsc`.`dat` AND `Threadact`.`title` = `Threadactsc`.`title`) INNER JOIN `data_matome`.`catlist` AS `Catlist` ON (`Threadact`.`cat` = `Catlist`.`catno`) WHERE ThreadItems.id IN (SELECT Mecabword.id FROM mecabword AS `Mecabword` WHERE `Mecabword`.`keyword` = 'サブカル')	1	1	1

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 7.17 MB

Message	Memory use
Component initialization	3.39 MB
Controller action start	3.65 MB
Controller render start	4.61 MB
View render complete	5.86 MB

Timers

Total Request Time: 72 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	28.52
Event: Controller.initialize	0.03
Event: Controller.startup	0.19
Controller action	23.35
Event: Controller.beforeRender	2.72
» Processing toolbar data	2.67
Rendering View	7.10
» Event: View.beforeRender	0.02
» Rendering APP/View/RankingItems/index.ctp	6.50
» » Rendering APP/View/Elements/header.ctp	1.20
» » Rendering APP/View/Elements/searchform.ctp	3.51
» » Rendering APP/View/Elements/paging.ctp	0.39
» » Rendering APP/View/Elements/paging.ctp #2	0.19
» » Rendering APP/View/Elements/footer.ctp	0.05
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	0.08
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- datalist(array)
  0(array)
  ThreadItems(array)
  id1351170402683
  diffcnt1
  createTime2019-02-16 10:24:29
  Threadact(array)
  createTime2019-01-16 08:47:51
  id1351170402683
  dat1170402683
  urlhttp://hayabusa6.2ch.net/test/read.cgi/subcal/1170402683
  cat135
  title【4325】清水ミチコはサブカルだよね【ミッチャン】
  cnt357
  Threadactsc(array)
  createTime2019-02-16 06:45:04
  id1041170402683
  dat1170402683
  url/test/read.cgi/subcal/1170402683
  cat104
  title【4325】清水ミチコはサブカルだよね【ミッチャン】
  Catlist(array)
  catno135
  catnameサブカル
  subbackhttp://mao.5ch.net/subcal/subback.html
  ng
  updateTime2019-02-16 10:13:48
  threadcnt611
  Mecabword(array)
  0(array)
  id1351170402683
  keywordサブカル
  bunrui3一般
  createTime2018-04-13 02:05:30
  Mecabwordhit(array)
  keywordサブカル
  bunrui3一般
  kensu198
  1(array)
  id1351170402683
  keywordミッチャン
  bunrui3人名
  createTime2018-04-13 02:05:30
  Mecabwordhit(array)
  keywordミッチャン
  bunrui3人名
  kensu1
  2(array)
  id1351170402683
  keyword清水ミチコ
  bunrui3人名
  createTime2018-04-13 02:05:30
  Mecabwordhit(array)
  keyword清水ミチコ
  bunrui3人名
  kensu10
- CTLSET_title
- CTLSET_keywordサブカル
- CTLSET_intervalL
- $request->data(empty)
- $this->validationErrors(array)
  ThreadItems(empty)
  Mecabword(empty)
  Mecabwordhit(empty)
- Loaded Helpers(array)
  0Number
  1SimpleGraph
  2Paginator
  3DebugTimer
  4Toolbar
  5Html
  6Form
  7html
  8HtmlToolbar
====

Environment

App Constants

No application environment available.

CakePHP Constants

Constant	Value
APP	/home/jnk/ranking/ranking2matome.click/public/
APP_DIR	public
APPLIBS	/home/jnk/ranking/ranking2matome.click/public/Lib/
CACHE	/home/jnk/ranking/ranking2matome.click/public/tmp/cache/
CAKE	/home/jnk/ranking/ranking2matome.click/cake/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/jnk/ranking/ranking2matome.click/cake/lib
CORE_PATH	/home/jnk/ranking/ranking2matome.click/cake/lib/
CAKE_VERSION	2.7.8
CSS	/home/jnk/ranking/ranking2matome.click/public/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://ranking2matome.click
IMAGES	/home/jnk/ranking/ranking2matome.click/public/webroot/img/
IMAGES_URL	img/
JS	/home/jnk/ranking/ranking2matome.click/public/webroot/js/
JS_URL	js/
LOGS	/home/jnk/ranking/ranking2matome.click/public/tmp/logs/
ROOT	/home/jnk/ranking/ranking2matome.click
TESTS	/home/jnk/ranking/ranking2matome.click/public/Test/
TMP	/home/jnk/ranking/ranking2matome.click/public/tmp/
VENDORS	/home/jnk/ranking/ranking2matome.click/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/jnk/ranking/ranking2matome.click/public/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.0.29-1+ubuntu14.04.1+deb.sury.org+1
User	www-data
Home	/var/www
Http Accept Encoding	gzip
Http Connection	Keep-Alive
Http Host	ranking2matome.click
Http If Modified Since	Thu, 15 Nov 2018 02:16:46 GMT
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Script Filename	/home/jnk/ranking/ranking2matome.click/public/webroot/index.php
Redirect Status	200
Server Name	ranking2matome.click
Server Port	80
Server Addr	133.18.31.167
Remote Port	54124
Remote Addr	3.84.243.246
Server Software	nginx/1.14.0
Gateway Interface	CGI/1.1
Request Scheme	http
Server Protocol	HTTP/1.1
Document Root	/home/jnk/ranking/ranking2matome.click/public/webroot
Document Uri	/index.php
Request Uri	/?interval=L&title=&keyword=%E3%82%B5%E3%83%96%E3%82%AB%E3%83%AB
Script Name	/index.php
Content Length
Content Type
Request Method	GET
Query String	interval=L&title=&keyword=%E3%82%B5%E3%83%96%E3%82%AB%E3%83%AB
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1550280694.8089
Request Time	1550280694

====

Include
+
Included Files

Include Paths
- 1/usr/share/php
- 2-> /home/jnk/ranking/ranking2matome.click/cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/RankingItemsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/ThreadItems.php
  1APP/Model/AppModel.php
  2APP/Model/Mecabword.php
  3APP/Model/Mecabwordhit.php
  Other(array)
  0APP/webroot/index.php
- plugins(empty)
====

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 15 ms Total Queries: 6 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 15 ms
Total Queries: 6 queries