Query Metrics
7
Database Queries
7
Different statements
151.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.61 ms (83.42%) |
1 |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 46186 53515 151179 194687 401037 402081 403112 404552 410702 418658 421784 424618 425679 435070 437137 439511 441601 444109 446117 447041 449133 452807 452827 453997 456639 458156 459201 463304 463323 468424 470278 473228 475483 475819 477319 479723 485233 490965 491857 492788 492821 500265 502770 502780 508184 509601 510631 511481 513098 518520 520790 522398 526774 532743 536604 537980 538750 540195 540272 540894 541587 545411 546637 550919 551211 558032 560738 565250 565954 567947 568524 570408 571804 574561 574854 574874 575159 575489 575805 576101 576134 576139 576321 577381 579775 580832 582542 609889 630020 632568 648583 652526 653548 698282 722848 722869 724048 724841 728155 728241 729176 747308 749237 751433 752578 761580 767056 770421 772821 775710 793427 794037 800003 814418 814459 814470 814493 814657 814843 820042 ] |
||||||||||||||||||||||||||||||
|
14.36 ms (9.46%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 794037 800003 728155 761580 770421 724048 728241 767056 729176 747308 749237 751433 772821 724841 752578 609889 630020 632568 698282 722848 722869 775710 793427 46186 53515 402081 446117 456639 458156 194687 439511 401037 424618 473228 475819 492788 502780 541587 437137 475483 522398 565250 648583 470278 526774 510631 513098 151179 403112 404552 425679 444109 418658 421784 435070 410702 441601 814418 814493 814657 814843 814459 820042 814470 452827 453997 468424 479723 492821 447041 449133 485233 452807 459201 477319 520790 532743 500265 518520 536604 538750 502770 509601 537980 540195 508184 511481 540272 463304 463323 490965 491857 540894 545411 551211 558032 560738 565954 567947 571804 575159 575805 577381 582542 546637 550919 568524 570408 576101 576134 576139 574561 574854 574874 575489 576321 579775 580832 652526 653548 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.93%) |
1 |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 46186 53515 151179 194687 401037 402081 403112 404552 410702 418658 421784 424618 425679 435070 437137 439511 441601 444109 446117 447041 449133 452807 452827 453997 456639 458156 459201 463304 463323 468424 470278 473228 475483 475819 477319 479723 485233 490965 491857 492788 492821 500265 502770 502780 508184 509601 510631 511481 513098 518520 520790 522398 526774 532743 536604 537980 538750 540195 540272 540894 541587 545411 546637 550919 551211 558032 560738 565250 565954 567947 568524 570408 571804 574561 574854 574874 575159 575489 575805 576101 576134 576139 576321 577381 579775 580832 582542 609889 630020 632568 648583 652526 653548 698282 722848 722869 724048 724841 728155 728241 729176 747308 749237 751433 752578 761580 767056 770421 772821 775710 793427 794037 800003 814418 814459 814470 814493 814657 814843 820042 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking teen"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking teen"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking teen"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.