Query Metrics
7
Database Queries
7
Different statements
141.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.08 ms (84.40%) |
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 69965 81585 388883 419094 431542 437105 438027 440533 449514 457324 458158 461835 475491 476971 480043 528513 531374 533664 536268 546575 546578 549127 553636 553679 563237 567617 567672 575570 577446 577976 578352 578530 578716 584476 584964 585047 593736 595020 595499 602675 612488 616926 627182 629957 639116 640320 643830 652681 653042 655241 657143 657860 662512 668447 676660 687717 690894 709741 712426 716735 717757 722040 726406 734590 736685 737315 743091 749448 757120 759913 761609 762656 762915 765389 767073 767884 769340 772797 773150 773498 776270 778788 778834 778988 779066 779949 782840 782895 784237 785625 786271 786634 786829 787750 788405 790235 793955 794539 794585 795673 800263 803417 803589 803885 804662 804817 804926 809996 811147 811244 812162 813961 817283 818087 818554 818623 818678 823341 826181 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (9.06%) |
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 81585 431542 585047 826181 817283 818623 818678 533664 528513 531374 553679 563237 553636 687717 712426 716735 717757 657860 676660 652681 655241 662512 549127 567617 595020 627182 639116 593736 602675 612488 616926 629957 778988 779066 786271 794585 795673 803417 803885 811147 812162 785625 786829 804662 773150 782895 787750 794539 804926 811244 762656 736685 737315 757120 759913 762915 765389 767073 769340 726406 761609 770445 773498 643830 776270 778788 778834 779949 786634 788405 800263 438027 475491 458158 440533 449514 388883 476971 584476 546578 575570 577976 722040 690894 595499 790235 804817 782840 784237 743091 793955 803589 584964 653042 640320 749448 809996 734590 767884 772797 69965 419094 437105 818087 818554 823341 813961 457324 480043 536268 461835 567672 578352 578716 546575 577446 578530 657143 668447 709741 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.89%) |
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 69965 81585 388883 419094 431542 437105 438027 440533 449514 457324 458158 461835 475491 476971 480043 528513 531374 533664 536268 546575 546578 549127 553636 553679 563237 567617 567672 575570 577446 577976 578352 578530 578716 584476 584964 585047 593736 595020 595499 602675 612488 616926 627182 629957 639116 640320 643830 652681 653042 655241 657143 657860 662512 668447 676660 687717 690894 709741 712426 716735 717757 722040 726406 734590 736685 737315 743091 749448 757120 759913 761609 762656 762915 765389 767073 767884 769340 772797 773150 773498 776270 778788 778834 778988 779066 779949 782840 782895 784237 785625 786271 786634 786829 787750 788405 790235 793955 794539 794585 795673 800263 803417 803589 803885 804662 804817 804926 809996 811147 811244 812162 813961 817283 818087 818554 818623 818678 823341 826181 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов cumshot"
]
|
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.