Query Metrics
7
Database Queries
7
Different statements
147.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.96 ms (83.91%) |
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 4199 145677 383504 384368 387180 391985 415430 431471 471536 476146 484221 490665 502033 519152 536120 539348 539352 541116 547573 549031 557707 558674 559313 562153 565931 576475 576597 578171 588890 589467 590496 595910 602222 603345 606515 610128 612169 612621 615260 620880 625803 626176 628563 630436 634961 635028 656147 664968 665219 691235 693526 695140 697288 700893 705305 707542 712140 712784 713440 713442 714389 714739 715935 717126 719100 719159 719178 720182 720648 722109 722122 722125 722457 724719 725243 725395 726860 728948 728980 728989 728996 729049 729058 730267 730276 730996 731482 734661 740457 740662 743249 746107 746109 749478 751230 753729 754057 756538 758923 776473 778058 780418 781771 783414 794173 794408 794417 794585 799103 799104 799618 803136 804241 806719 810504 817100 818197 823862 823978 826892 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (9.10%) |
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 714389 722122 712784 714739 719159 610128 603345 634961 731482 804241 726860 730276 728948 754057 612621 635028 722125 780418 794417 799104 502033 476146 490665 557707 562153 695140 625803 818197 823978 740662 590496 746109 746107 753729 565931 431471 391985 145677 519152 547573 712140 719100 626176 628563 794408 794585 729058 730267 725395 606515 778058 749478 484221 730996 4199 539348 539352 715935 602222 799103 725243 758923 728980 743249 794173 384368 415430 471536 620880 729049 817100 826892 823862 536120 558674 576475 578171 549031 541116 559313 697288 717126 722457 656147 665219 691235 705305 713442 719178 720182 722109 664968 693526 700893 576597 589467 595910 588890 612169 630436 799618 810504 803136 806719 734661 751230 781771 783414 724719 740457 728989 728996 756538 615260 707542 713440 720648 776473 387180 383504 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.20%) |
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 4199 145677 383504 384368 387180 391985 415430 431471 471536 476146 484221 490665 502033 519152 536120 539348 539352 541116 547573 549031 557707 558674 559313 562153 565931 576475 576597 578171 588890 589467 590496 595910 602222 603345 606515 610128 612169 612621 615260 620880 625803 626176 628563 630436 634961 635028 656147 664968 665219 691235 693526 695140 697288 700893 705305 707542 712140 712784 713440 713442 714389 714739 715935 717126 719100 719159 719178 720182 720648 722109 722122 722125 722457 724719 725243 725395 726860 728948 728980 728989 728996 729049 729058 730267 730276 730996 731482 734661 740457 740662 743249 746107 746109 749478 751230 753729 754057 756538 758923 776473 778058 780418 781771 783414 794173 794408 794417 794585 799103 799104 799618 803136 804241 806719 810504 817100 818197 823862 823978 826892 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая большие pussy"
]
|
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.