Query Metrics
7
Database Queries
7
Different statements
230.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.39 ms (88.85%) |
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 88486 422320 431691 445424 487930 523762 566561 601143 601744 602194 604988 611330 612700 618341 627153 630316 641010 641435 641444 641767 645844 666733 669923 677749 680741 713058 718744 718746 718793 722321 724122 726113 726122 729069 738276 740457 740458 742317 744185 746663 747111 748509 750021 750599 750900 751408 751486 751590 752194 752865 752915 753187 753573 753612 756043 757216 758215 758287 760148 760158 760590 760733 763874 770122 770137 770231 772637 773259 776473 777592 777638 777642 777654 777715 778712 781269 781309 781832 781960 782563 783308 784738 787337 788319 788714 790691 790699 798578 800657 800666 800676 800680 800682 802222 802555 802739 803771 803774 804403 805145 806470 807210 808411 808542 809032 810444 810801 811242 811331 811915 812106 812489 812631 812639 819351 819759 826514 826715 ] |
||||||||||||||||||||||||||||||
|
14.22 ms (6.18%) |
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 612700 618341 627153 641435 641767 777654 777715 781832 787337 800676 800680 802739 810444 810801 811331 812489 812631 812639 777592 778712 788714 800657 803771 804403 809032 812106 742317 751486 752915 753187 758287 760158 760733 770231 773259 781269 783308 790691 803774 807210 724122 726122 740457 740458 748509 752194 752865 759378 760148 763874 770122 747111 753573 757216 758215 760590 770137 729069 738276 750599 750900 751590 753612 726113 750021 641010 713058 722321 776473 781960 788319 790699 800682 802555 806470 811242 718744 808411 751408 680741 826514 819351 566561 645844 669923 718746 666733 677749 601143 604988 604910 630316 641444 777638 784738 805145 746663 772637 782563 798578 744185 718793 777642 811915 422320 88486 487930 601744 826715 819759 602194 611330 431691 445424 523762 800666 802222 781309 808542 756043 ] |
||||||||||||||||||||||||||||||
|
3.81 ms (1.65%) |
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 88486 422320 431691 445424 487930 523762 566561 601143 601744 602194 604988 611330 612700 618341 627153 630316 641010 641435 641444 641767 645844 666733 669923 677749 680741 713058 718744 718746 718793 722321 724122 726113 726122 729069 738276 740457 740458 742317 744185 746663 747111 748509 750021 750599 750900 751408 751486 751590 752194 752865 752915 753187 753573 753612 756043 757216 758215 758287 760148 760158 760590 760733 763874 770122 770137 770231 772637 773259 776473 777592 777638 777642 777654 777715 778712 781269 781309 781832 781960 782563 783308 784738 787337 788319 788714 790691 790699 798578 800657 800666 800676 800680 800682 802222 802555 802739 803771 803774 804403 805145 806470 807210 808411 808542 809032 810444 810801 811242 811331 811915 812106 812489 812631 812639 819351 819759 826514 826715 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom solo masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom соло мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom соло мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.76%) |
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.