Query Metrics
7
Database Queries
7
Different statements
196.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.71 ms (89.51%) |
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 124519 396302 477802 486645 487466 488261 494849 500094 539632 541347 546563 547992 555649 570134 570962 584106 588001 588550 591863 600082 606804 608528 613150 619900 623293 625743 629696 636954 638455 638527 645073 649066 649322 650682 651530 652521 654397 660418 663831 666628 668006 668122 668579 668823 677158 680619 683468 687326 690214 697478 697725 705435 707684 710380 712265 713002 718916 719280 719408 720337 720845 720852 723141 723151 724820 728759 730212 734265 735885 736832 747981 756318 767415 772357 777542 777675 779048 781156 782359 782433 783058 783090 783673 785889 785968 787150 787473 793713 793756 793880 794712 795824 795996 796348 796728 797023 799976 801677 805070 810872 814433 816827 818372 818693 819936 820196 820377 823614 824544 824706 825510 825890 826811 827517 827520 828433 828443 828764 ] |
||||||||||||||||||||||||||||||
|
11.03 ms (5.62%) |
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 719408 779746 783058 783673 805070 124519 488261 794712 787150 779048 660418 666628 793880 783090 772357 728759 707684 816827 824706 825510 494849 487466 547992 649066 668006 668122 718916 588550 638527 623293 796728 810872 785968 734265 736832 756318 774309 747981 767415 724820 730212 735885 782359 797023 396302 814433 818372 820377 819936 820196 823614 826811 827517 827520 818693 824544 825890 828764 828433 828443 486645 477802 500094 539632 541347 570134 570962 584106 555649 668823 687326 697478 697725 712265 720337 645073 649322 650682 680619 683468 690214 705435 713002 719280 723141 651530 652521 654397 663831 668579 677158 710380 720845 720852 723151 546563 591863 606804 600082 608528 629696 619900 636954 588001 613150 625743 638455 777542 777675 781156 787473 793713 793756 795824 795996 796348 799976 801677 782433 785889 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.37%) |
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 124519 396302 477802 486645 487466 488261 494849 500094 539632 541347 546563 547992 555649 570134 570962 584106 588001 588550 591863 600082 606804 608528 613150 619900 623293 625743 629696 636954 638455 638527 645073 649066 649322 650682 651530 652521 654397 660418 663831 666628 668006 668122 668579 668823 677158 680619 683468 687326 690214 697478 697725 705435 707684 710380 712265 713002 718916 719280 719408 720337 720845 720852 723141 723151 724820 728759 730212 734265 735885 736832 747981 756318 767415 772357 777542 777675 779048 781156 782359 782433 783058 783090 783673 785889 785968 787150 787473 793713 793756 793880 794712 795824 795996 796348 796728 797023 799976 801677 805070 810872 814433 816827 818372 818693 819936 820196 820377 823614 824544 824706 825510 825890 826811 827517 827520 828433 828443 828764 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum on her"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum her"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum her"
]
|
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.