Query Metrics
7
Database Queries
7
Different statements
165.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.62 ms (84.61%) |
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 398655 400952 401666 406641 415077 423318 428425 432586 432675 432702 432741 435505 445661 446022 448829 450288 450965 454537 454541 463852 463960 464206 464617 464815 478320 478587 487632 513750 523049 524755 527649 531137 534226 549178 554455 559139 564510 565648 568560 585989 589067 596204 612816 626136 627288 627781 628522 642376 643376 649971 656219 663162 673791 682250 686860 689012 703458 703487 704928 712777 713507 716189 716286 723573 724109 726317 726657 731086 731372 737182 738528 739675 742100 744654 753542 760055 761169 762383 762437 765648 766592 766656 767163 767252 767268 769291 769315 770520 770522 770823 771835 774691 777537 785092 788262 788576 794162 795686 796139 797443 798344 798509 800854 805563 805855 806077 806104 807749 810945 811906 814707 815054 815144 815765 816574 817242 817546 820683 822002 825909 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (9.02%) |
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 534226 559139 564510 689012 742100 769291 800854 454537 398655 435505 415077 445661 450965 464206 478587 428425 432586 523049 448829 643376 788262 626136 820683 673791 788576 765648 487632 723573 817242 822002 817546 463852 649971 712777 716189 628522 589067 777537 767163 642376 805563 565648 400952 406641 432675 432702 432741 814707 815054 454541 463960 464617 524755 531137 554455 568560 656219 663162 682250 704928 549178 612816 585989 596204 774691 798344 806104 794162 795686 797443 811906 726317 760055 796139 810945 766592 766656 761169 744654 769315 738528 767252 770520 770823 798509 806077 401666 513750 825909 815144 816574 815765 527649 478320 703458 686860 703487 713507 716286 627288 627781 724109 762437 805855 807749 731086 737182 726657 739675 753542 762383 731372 767268 770522 771835 785092 423318 450288 464815 446022 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (2.12%) |
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 398655 400952 401666 406641 415077 423318 428425 432586 432675 432702 432741 435505 445661 446022 448829 450288 450965 454537 454541 463852 463960 464206 464617 464815 478320 478587 487632 513750 523049 524755 527649 531137 534226 549178 554455 559139 564510 565648 568560 585989 589067 596204 612816 626136 627288 627781 628522 642376 643376 649971 656219 663162 673791 682250 686860 689012 703458 703487 704928 712777 713507 716189 716286 723573 724109 726317 726657 731086 731372 737182 738528 739675 742100 744654 753542 760055 761169 762383 762437 765648 766592 766656 767163 767252 767268 769291 769315 770520 770522 770823 771835 774691 777537 785092 788262 788576 794162 795686 796139 797443 798344 798509 800854 805563 805855 806077 806104 807749 810945 811906 814707 815054 815144 815765 816574 817242 817546 820683 822002 825909 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina mature anal"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская mature анал"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская mature анал"
]
|
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.