Query Metrics
7
Database Queries
7
Different statements
148.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.59 ms (81.89%) |
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 359918 396471 396558 398230 402105 404443 415550 415796 418018 426167 427942 436047 444645 445366 450455 451029 454842 455034 461894 462436 462922 469579 472429 472688 477404 481470 495905 498511 500669 510222 512514 513757 514047 518458 519701 522600 525352 525433 526206 526261 526549 527054 529725 529883 530060 530480 530753 530790 530792 531082 531539 534804 535707 536491 536550 536574 536620 536638 542635 545454 560180 562004 562012 562019 575924 580532 580670 583049 586289 589710 592673 592951 597857 597875 600476 602811 609886 614412 615812 615823 615832 615892 618066 619488 621457 621796 624921 631203 632084 634688 648560 650177 656672 660147 663984 664444 671356 672740 677064 679761 681539 688003 709729 716840 717924 720206 741878 756025 764321 775982 785437 797722 800422 802337 810839 818134 819738 826005 828847 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (11.04%) |
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 562004 589710 810839 764321 451029 455034 427942 426167 583049 650177 512514 536638 530060 402105 481470 450455 535707 461894 469579 560180 562019 580670 562012 656672 660147 672740 671356 688003 709729 597875 631203 741878 615823 785437 472688 415550 454842 529883 716840 621796 436047 398230 525352 536550 545454 664444 802337 756025 800422 498511 510222 396558 827979 514047 536491 597857 404443 359918 472429 530792 531082 534804 677064 717924 600476 615832 775982 648560 477404 526206 513757 526261 527054 526549 530753 531539 495905 522600 663984 575924 592951 586289 536620 530790 679761 592673 621457 618066 609886 720206 518458 415796 396471 536574 529725 542635 818134 619488 418018 445366 580532 462922 462436 530480 519701 681539 602811 614412 632084 615892 615812 634688 500669 797722 525433 826005 828847 444645 624921 819738 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.87%) |
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 359918 396471 396558 398230 402105 404443 415550 415796 418018 426167 427942 436047 444645 445366 450455 451029 454842 455034 461894 462436 462922 469579 472429 472688 477404 481470 495905 498511 500669 510222 512514 513757 514047 518458 519701 522600 525352 525433 526206 526261 526549 527054 529725 529883 530060 530480 530753 530790 530792 531082 531539 534804 535707 536491 536550 536574 536620 536638 542635 545454 560180 562004 562012 562019 575924 580532 580670 583049 586289 589710 592673 592951 597857 597875 600476 602811 609886 614412 615812 615823 615832 615892 618066 619488 621457 621796 624921 631203 632084 634688 648560 650177 656672 660147 663984 664444 671356 672740 677064 679761 681539 688003 709729 716840 717924 720206 741878 756025 764321 775982 785437 797722 800422 802337 810839 818134 819738 826005 828847 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge cock"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные cock"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие огромные cock"
]
|
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.