Query Metrics
7
Database Queries
7
Different statements
198.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.15 ms (86.66%) |
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 146944 402043 413861 417888 419556 421968 424817 425987 430467 432337 437679 437838 443743 443780 443793 444439 446135 446286 447853 449096 450794 450802 453082 453825 454231 454298 454663 455329 457108 458587 461151 466340 466818 467635 469079 472657 477886 478507 482074 485430 486805 490584 490870 492329 496841 500467 503859 504123 511611 512542 513931 516468 517387 521256 525998 540086 542567 548833 550210 550214 552028 564598 568288 583851 585318 585780 590920 590924 592229 592900 593288 595819 603248 614613 622198 630686 639335 644643 644968 645320 645599 649563 649766 663951 665864 669418 669753 679048 681286 682198 682562 694470 696121 704280 717129 718828 720301 722504 727017 727972 730331 747036 755108 756041 771495 775919 789841 793605 803781 805296 806422 808050 808754 811246 812089 816822 816959 817115 822289 822654 ] |
||||||||||||||||||||||||||||||
|
15.36 ms (7.73%) |
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 469079 419556 455329 466818 472657 437679 500467 525998 513931 811246 443793 454663 822289 614613 717129 449096 517387 417888 458587 446286 649766 467635 548833 817115 644968 466340 447853 669418 816959 669753 645320 550214 730331 727972 540086 808050 812089 727017 496841 755108 432337 450802 421968 696121 603248 477886 424817 454298 644643 454231 595819 568288 808754 649563 593288 747036 564598 756041 146944 490870 822654 816822 585780 771495 704280 542567 552028 630686 805296 450794 663951 789841 425987 453825 583851 679048 694470 590924 521256 793605 806422 413861 512542 718828 622198 490584 503859 486805 681286 775919 478507 453082 504123 682198 722504 444439 511611 585318 803781 720301 550210 430467 402043 485430 437838 592900 590920 639335 665864 492329 446135 443743 645599 443780 516468 461151 682562 592229 457108 482074 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (1.91%) |
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 146944 402043 413861 417888 419556 421968 424817 425987 430467 432337 437679 437838 443743 443780 443793 444439 446135 446286 447853 449096 450794 450802 453082 453825 454231 454298 454663 455329 457108 458587 461151 466340 466818 467635 469079 472657 477886 478507 482074 485430 486805 490584 490870 492329 496841 500467 503859 504123 511611 512542 513931 516468 517387 521256 525998 540086 542567 548833 550210 550214 552028 564598 568288 583851 585318 585780 590920 590924 592229 592900 593288 595819 603248 614613 622198 630686 639335 644643 644968 645320 645599 649563 649766 663951 665864 669418 669753 679048 681286 682198 682562 694470 696121 704280 717129 718828 720301 722504 727017 727972 730331 747036 755108 756041 771495 775919 789841 793605 803781 805296 806422 808050 808754 811246 812089 816822 816959 817115 822289 822654 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy blowjob handjob"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая минет оральн секс дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая минет оральн секс дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.