Query Metrics
7
Database Queries
7
Different statements
370.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.60 ms (55.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русский молодой анал"
]
|
||||||||||||||||||||||||||||||
|
138.54 ms (37.41%) |
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 7011 391042 391156 393330 411257 422330 423676 424011 426702 427192 441427 441577 455715 458156 461443 462108 463331 474263 481409 487973 489329 497641 505072 519778 542937 547405 570260 578325 580343 581467 581470 588843 595467 599350 607136 619934 621161 623379 624761 626878 629711 643516 647108 652605 652906 652929 653491 653556 656484 656906 661607 663715 664491 668331 670988 671829 673456 677347 685531 685789 699587 707461 713301 714660 715009 715620 718676 718700 721453 722646 722694 722867 724027 725132 727877 731595 734472 739237 740604 746157 746979 747092 747375 747450 751213 753438 753484 754192 757915 762976 764868 766742 769047 769069 769075 769749 770434 771572 773662 774251 779737 782349 783104 785813 786496 787554 789753 790520 792706 793893 793991 796196 796886 800793 801282 811634 811657 812996 826153 ] |
||||||||||||||||||||||||||||||
|
19.90 ms (5.37%) |
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 769749 786496 792706 505072 487973 391156 422330 424011 441427 441577 427192 481409 542937 570260 7011 393330 458156 463331 391042 423676 426702 461443 462108 411257 497641 489329 519778 826153 474263 455715 581467 581470 578325 652605 653556 673456 677347 685531 713301 714660 715620 718700 721453 722646 652929 656484 656906 661607 663715 664491 668331 670988 685789 722867 647108 652906 653491 671829 699587 707461 715009 718676 722694 547405 580343 599350 607136 619934 643516 624761 626878 629711 588843 595467 621161 623379 779737 783104 785813 787554 793893 796196 782349 789753 790520 796886 800793 801282 811657 812996 724027 727877 731595 734472 734988 746157 747092 747450 754192 793991 811634 725132 746979 753438 753484 766742 770434 739237 764868 769047 769069 773662 774251 740604 747375 751213 757915 762976 769075 771572 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (0.66%) |
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 7011 391042 391156 393330 411257 422330 423676 424011 426702 427192 441427 441577 455715 458156 461443 462108 463331 474263 481409 487973 489329 497641 505072 519778 542937 547405 570260 578325 580343 581467 581470 588843 595467 599350 607136 619934 621161 623379 624761 626878 629711 643516 647108 652605 652906 652929 653491 653556 656484 656906 661607 663715 664491 668331 670988 671829 673456 677347 685531 685789 699587 707461 713301 714660 715009 715620 718676 718700 721453 722646 722694 722867 724027 725132 727877 731595 734472 739237 740604 746157 746979 747092 747375 747450 751213 753438 753484 754192 757915 762976 764868 766742 769047 769069 769075 769749 770434 771572 773662 774251 779737 782349 783104 785813 786496 787554 789753 790520 792706 793893 793991 796196 796886 800793 801282 811634 811657 812996 826153 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск молодой анал"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.