|
Mem: 3.25 / 2 MB
Time: 7.59 ms
Curl: 1 (In 0.85 ms);
DB: 6 (In 2.00 ms);
Memory: 3.25 / 2 MB; Total time: 7.59 ms; Curl: 1 (In 0.85 ms); DB: 6 (In 2.00 ms);
0.43 ms (5.7%) - App bootstrap
0.42 ms (5.6%) - 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.13 ms (1.8%) - Connect to: "mysql:host=flix-mysql;dbname=edge;charset=utf8"
0.11 ms (1.5%) - SELECT `shortname` FROM `category`
0.00 ms (0%) - Cache.get (miss) - "s:33:"home:toprated:page:8:duration:all";"
0.85 ms (11.2%) - <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.26 ms (3.4%) - SELECT video.id FROM `video` WHERE (is_shown = 1 OR is_shown = 3) ORDER BY `n_like_dislike_diff` DESC LIMIT 60 OFFSET 420
1.22 ms (16.1%) - SELECT `id`, `first_thumb`, `n_views`, `duration`, `title`, `viddir`, `storage`, `quality`, `old_trailer_url`, `n_likes`, `n_dislikes`, `slug`, `categ .....
2.67 ms (35.2%) - View.render - ".view"
1.16 ms (15.3%) - View.render - "video._listEdge"
0.02 ms (0.3%) - View.render - "_partials.pagination"
1.43 ms (18.8%) - View.render - "layouts.main"
0.14 ms (1.8%) - View.render - "_partials.header"
0.03 ms (0.4%) - View.render - "live::user.topMenu"
0.11 ms (1.4%) - 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.86 ms (11.3%) - View.render - "_partials.sidebar_categories"
0.00 ms (0%) - Cache.get (miss) - "s:17:"sideBarCategories";"
0.20 ms (2.6%) - SELECT * FROM `category` WHERE `active` = 1 ORDER BY `descrip` ASC
0.04 ms (0.6%) - View.render - "_partials.footer"
0.23 ms (3%) - View.render - "layouts.baseLayout"
0.01 ms (0.1%) - View.render - "_partials.favicons"
0.00 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.08 ms (1.1%) - SELECT `utm_source`, `iid` FROM `control_export_queue`
0.23 ms (3%) - App end
# Took Trace Info [Total time: 0.02 ms]
1 0.01 ms
[Show]
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]
Cache.get (miss) - "s:33:"home:toprated:page:8:duration:all";"
3 0.01 ms
[Show]
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:121:"SELECT video.id FROM `video` WHERE (is_shown = 1 OR is_shown = 3) ORDER BY `n_like_dislike_diff` DESC LIMIT 60 OFFSET 420";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]
Cache.get (miss) - "s:17:"sideBarCategories";"
5 0.00 ms
[Show]
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.85 ms]
1 0.85 ms
[Show]
<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=toprated-all&param_page=8<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=toprated-all&param_page=8
# Took Trace Info [Total time: 2.00 ms]
1 0.13 ms
[Show]
Connect to: "mysql:host=flix-mysql;dbname=edge;charset=utf8"
2 0.11 ms
[Show]
SELECT `shortname` FROM `category`
3 0.26 ms
[Show]
SELECT video.id FROM `video` WHERE (is_shown = 1 OR is_shown = 3) ORDER BY `n_like_dislike_diff` DESC LIMIT 60 OFFSET 420
4 1.22 ms
[Show]
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 ('1443','1669','1163','2063','130','1143','774','995','1307','1943','199','1631','458','563','1230','1689','1522','85','1550','364','604','1905','1306','1038','1382','62','812','1655','1135','210','1871','1986','548','1851','692','1123','721','53','2045','1585','166','1419','1646','1477','923','1312','1841','641','1859','1964','933','486','1354','1333','578','1787','1659','639','1427','2003')
5 0.20 ms
[Show]
SELECT * FROM `category` WHERE `active` = 1 ORDER BY `descrip` ASC
6 0.08 ms
[Show]
SELECT `utm_source`, `iid` FROM `control_export_queue`
# Took Trace Info [Total time: 2.67 ms]
1 2.67 ms
[Show]
View.render - ".view"
2 1.16 ms
[Show]
View.render - "video._listEdge"
3 0.02 ms
[Show]
View.render - "_partials.pagination"
4 1.43 ms
[Show]
View.render - "layouts.main"
5 0.14 ms
[Show]
View.render - "_partials.header"
6 0.03 ms
[Show]
View.render - "live::user.topMenu"
7 0.11 ms
[Show]
View.render - "_partials.right_mobile_sidebar"
8 0.02 ms
[Show]
View.render - "live::user.mobileSidebarHead"
9 0.00 ms
[Show]
View.render - "live::user.mobileSidebarMenu"
10 0.86 ms
[Show]
View.render - "_partials.sidebar_categories"
11 0.04 ms
[Show]
View.render - "_partials.footer"
12 0.23 ms
[Show]
View.render - "layouts.baseLayout"
13 0.01 ms
[Show]
View.render - "_partials.favicons"
array(1) {
  ["_csrf"]=>
  string(40) "9016349f6fc99a30a21f1d9b4a239e9eb4fc55c0"
}
array(2) {
  ["session_token"]=>
  string(32) "d228fed13776c00eda503412c1bb8e91"
  ["_fsd"]=>
  string(152) "0ibvWLwvy1wS4b3oNB2TFO2/TY/ep+W64fFVIDgtFuW9xqpvoxlwTCHknc3WVZNBm6H0ZXo7DQMSxTI6WKn9bl4II9nM7F9Ff8hajThEpwu6YKzFpZoTwxCogTQDz6ChmqNT7/F3oEzyGIaj6x/pZw=="
}
f::route()->currentId(100) : routes.(nginx cache).[@sort[.@page]].!home
f::route()->currentArgs() :
array(2) {
  ["sort"]=>
  string(8) "toprated"
  ["page"]=>
  string(1) "8"
}