วิดีโอโป๊เด่น

Mem: 3.19 / 4 MB

Time: 8.82 ms

Curl: 1 (In 0.97 ms);

DB: 6 (In 2.57 ms);

Memory: 3.19 / 4 MB; Total time: 8.82 ms; Curl: 1 (In 0.97 ms); DB: 6 (In 2.57 ms);

Timeline Cache [5] Curl [1] DB [6] View [13] Session Cookies Route

0.62 ms (7%) - App bootstrap

0.62 ms (7%) - Find route

0.01 ms (0.1%) - Cache.get (miss) - "a:6:{i:0;a:4:{s:3:"dsn";s:33:"mysql:host=flix-mysql;dbname=edge";s:8:"username";s:5:"local";s:8:"password";s:5:"local";s:7:"option .....

0.17 ms (1.9%) - Connect to: "mysql:host=flix-mysql;dbname=edge;charset=utf8"

0.24 ms (2.8%) - SELECT `shortname` FROM `category`

0.00 ms (0%) - Cache.get (miss) - "s:34:"home:featured:page:16:duration:all";"

0.97 ms (11%) - <b>Raw:</b> GET http://clickhouse:8123?query=SELECT+vids%0A++++++++++++++++FROM+tnaflix.cache_replacing+%0A++++++++++++++++WHERE+cache_key+%3D+%7Bkey% .....

0.01 ms (0.1%) - Cache.get (miss) - "a:6:{i:0;a:4:{s:3:"dsn";s:33:"mysql:host=flix-mysql;dbname=edge";s:8:"username";s:5:"local";s:8:"password";s:5:"local";s:7:"option .....

0.40 ms (4.5%) - SELECT video.id FROM `video` WHERE (is_shown = 1 OR is_shown = 3) ORDER BY `featured_time` DESC LIMIT 60 OFFSET 900

1.46 ms (16.5%) - SELECT `id`, `first_thumb`, `n_views`, `duration`, `title`, `viddir`, `storage`, `quality`, `old_trailer_url`, `n_likes`, `n_dislikes`, `slug`, `categ .....

2.95 ms (33.4%) - View.render - ".view"

1.23 ms (13.9%) - View.render - "video._listEdge"

0.02 ms (0.3%) - View.render - "_partials.pagination"

1.63 ms (18.4%) - View.render - "layouts.main"

0.14 ms (1.6%) - View.render - "_partials.header"

0.03 ms (0.4%) - View.render - "live::user.topMenu"

0.11 ms (1.2%) - View.render - "_partials.right_mobile_sidebar"

0.02 ms (0.2%) - View.render - "live::user.mobileSidebarHead"

0.00 ms (0%) - View.render - "live::user.mobileSidebarMenu"

0.88 ms (9.9%) - View.render - "_partials.sidebar_categories"

0.00 ms (0%) - Cache.get (miss) - "s:17:"sideBarCategories";"

0.21 ms (2.4%) - SELECT * FROM `category` WHERE `active` = 1 ORDER BY `descrip` ASC

0.05 ms (0.5%) - View.render - "_partials.footer"

0.30 ms (3.4%) - View.render - "layouts.baseLayout"

0.01 ms (0.2%) - View.render - "_partials.favicons"

0.00 ms (0%) - Cache.get (miss) - "a:6:{i:0;a:4:{s:3:"dsn";s:33:"mysql:host=flix-mysql;dbname=edge";s:8:"username";s:5:"local";s:8:"password";s:5:"local";s:7:"option .....

0.09 ms (1%) - SELECT `utm_source`, `iid` FROM `control_export_queue`

0.19 ms (2.2%) - App end

#	Took	Trace	Info [Total time: 0.02 ms]
1	0.01 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/@categorySlug[.@sort][.@page]/_r.php:11	Cache.get (miss) - "a:6:{i:0;a:4:{s:3:"dsn";s:33:"mysql:host=flix-mysql;dbname=edge";s:8:"username";s:5:"local";s:8:"password";s:5:"local";s:7:"options";a:4:{i:3;i:2;i:19;i:2;i:20;b:1;i:12;b:1;}}i:1;s:6:"column";i:2;s:34:"SELECT `shortname` FROM `category`";i:3;N;i:4;a:0:{}i:5;a:0:{}}"
2	0.00 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:84	Cache.get (miss) - "s:34:"home:featured:page:16:duration:all";"
3	0.01 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:101	Cache.get (miss) - "a:6:{i:0;a:4:{s:3:"dsn";s:33:"mysql:host=flix-mysql;dbname=edge";s:8:"username";s:5:"local";s:8:"password";s:5:"local";s:7:"options";a:4:{i:3;i:2;i:19;i:2;i:20;b:1;i:12;b:1;}}i:1;N;i:2;s:115:"SELECT video.id FROM `video` WHERE (is_shown = 1 OR is_shown = 3) ORDER BY `featured_time` DESC LIMIT 60 OFFSET 900";i:3;N;i:4;a:1:{i:0;a:2:{i:0;s:16:"paginated_videos";i:1;a:3:{s:8:"criteria";s:19:"video.id = video.id";s:10:"onlyUnique";b:1;s:6:"isMany";b:0;}}}i:5;a:1:{i:0;s:6:"cb_n_0";}}"
4	0.00 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:27 /app/views/_partials/sidebar_categories.php:15 /app/App/Utils/Utils.php:421	Cache.get (miss) - "s:17:"sideBarCategories";"
5	0.00 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/baseLayout.php:62	Cache.get (miss) - "a:6:{i:0;a:4:{s:3:"dsn";s:33:"mysql:host=flix-mysql;dbname=edge";s:8:"username";s:5:"local";s:8:"password";s:5:"local";s:7:"options";a:4:{i:3;i:2;i:19;i:2;i:20;b:1;i:12;b:1;}}i:1;N;i:2;s:54:"SELECT `utm_source`, `iid` FROM `control_export_queue`";i:3;N;i:4;a:0:{}i:5;a:0:{}}"

#	Took	Trace	Info [Total time: 0.97 ms]
1	0.97 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:84 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:42 /app/App/Database/Clickhouse.php:48	<b>Raw:</b> GET http://clickhouse:8123?query=SELECT+vids%0A++++++++++++++++FROM+tnaflix.cache_replacing+%0A++++++++++++++++WHERE+cache_key+%3D+%7Bkey%3AString%7D%0A++++++++++++++++AND+page+%3D+%7Bpage%3AInt16%7D%0A++++++++++++++++ORDER+BY+version+DESC%0A++++++++++++++++LIMIT+1+FORMAT+JSON&param_key=featured-all&param_page=16<br><br><b>Decoded:</b> GET http://clickhouse:8123?query=SELECT vids FROM tnaflix.cache_replacing WHERE cache_key = {key:String} AND page = {page:Int16} ORDER BY version DESC LIMIT 1 FORMAT JSON&param_key=featured-all&param_page=16

#	Took	Trace	Info [Total time: 2.57 ms]
1	0.17 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/@categorySlug[.@sort][.@page]/_r.php:11	Connect to: "mysql:host=flix-mysql;dbname=edge;charset=utf8"
2	0.24 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/@categorySlug[.@sort][.@page]/_r.php:11	SELECT `shortname` FROM `category`
3	0.40 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:101	SELECT video.id FROM `video` WHERE (is_shown = 1 OR is_shown = 3) ORDER BY `featured_time` DESC LIMIT 60 OFFSET 900
4	1.46 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:101	SELECT `id`, `first_thumb`, `n_views`, `duration`, `title`, `viddir`, `storage`, `quality`, `old_trailer_url`, `n_likes`, `n_dislikes`, `slug`, `category_slug`, `serialized_pornstars`, `serialized_uploader`, `serialized_translations` FROM `video` WHERE `id` IN ('225','295','957','1778','44','556','183','1958','1284','1493','1852','541','27','700','273','963','310','1621','452','2030','1107','1297','1263','1118','1011','435','47','1724','1148','1598','542','768','1404','1506','1843','639','1573','8','1798','840','887','886','521','1973','99','817','1683','489','941','1233','1869','1968','2017','1227','1360','169','1906','1975','485','1')
5	0.21 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:27 /app/views/_partials/sidebar_categories.php:15 /app/App/Utils/Utils.php:421 /app/App/Utils/Utils.php:409	SELECT * FROM `category` WHERE `active` = 1 ORDER BY `descrip` ASC
6	0.09 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/baseLayout.php:62	SELECT `utm_source`, `iid` FROM `control_export_queue`

#	Took	Trace	Info [Total time: 2.95 ms]
1	2.95 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118	View.render - ".view"
2	1.23 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/routes/(nginx cache)/[@sort[.@page]]/view.php:45	View.render - "video._listEdge"
3	0.02 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/routes/(nginx cache)/[@sort[.@page]]/view.php:45 /app/views/video/_listEdge.php:95	View.render - "_partials.pagination"
4	1.63 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118	View.render - "layouts.main"
5	0.14 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:14	View.render - "_partials.header"
6	0.03 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:14 /app/views/_partials/header.php:28	View.render - "live::user.topMenu"
7	0.11 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:15	View.render - "_partials.right_mobile_sidebar"
8	0.02 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:15 /app/views/_partials/right_mobile_sidebar.php:5	View.render - "live::user.mobileSidebarHead"
9	0.00 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:15 /app/views/_partials/right_mobile_sidebar.php:61	View.render - "live::user.mobileSidebarMenu"
10	0.88 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:27	View.render - "_partials.sidebar_categories"
11	0.05 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/main.php:53	View.render - "_partials.footer"
12	0.30 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118	View.render - "layouts.baseLayout"
13	0.01 ms	[Show] [Hide] /app/public/index.php:9 /app/routes/(nginx cache)/[@sort[.@page]]/!home.php:118 /app/views/layouts/baseLayout.php:14	View.render - "_partials.favicons"

array(1) {
  ["_csrf"]=>
  string(40) "32aa199852722ad2c68ee63ff740926372f479ea"
}

array(2) {
  ["_fsd"]=>
  string(152) "EHxwcTPyJ8Kvzcpk+UCMRCTlrPPLxZysiKJMwtgiEAqR5Eh2sWT3ib2svEs0yYnjwCO8wXv1Wa3bKvnbVXUplLnEJIZ/yyEKr1NNGE+a4h1VJTf0xe/3jf33At7DQzWCHRip06HMsZgZgaFSblWOKA=="
  ["session_token"]=>
  string(32) "9288f8c5147f6e97aa9ef1f2cc9d4fdf"
}

f::route()->currentId(100) : routes.(nginx cache).[@sort[.@page]].!home

f::route()->currentArgs() :

array(3) {
  ["_locale"]=>
  string(2) "th"
  ["sort"]=>
  string(8) "featured"
  ["page"]=>
  string(2) "16"
}