Query Metrics
7
Database Queries
7
Different statements
155.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.88 ms (82.90%) |
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 7178 385381 393081 397910 398800 401666 402375 409682 413183 414643 422147 422298 433375 443166 460704 468581 480432 510132 523843 563263 585989 586456 596204 601544 601553 601843 602293 604313 607371 612816 613122 625887 626292 626965 630487 638991 642371 644296 705710 708462 711417 716165 716750 723643 725570 725581 725626 732248 733645 738528 740792 740919 741291 741541 741607 742315 744654 747310 748975 749668 751510 751611 756216 756241 766707 767175 774691 775751 775810 777544 777727 777750 778055 778379 782400 786129 787857 789521 790572 791486 792135 792633 795538 797443 797504 798344 798509 799413 800288 800492 801205 801483 803415 804504 805222 805424 805431 805586 805777 806077 806104 806686 806794 807353 807539 810975 811029 811325 813014 813105 813516 815095 815508 817860 818283 818903 820641 821688 825304 826910 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (10.05%) |
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 612816 613122 642371 604313 585989 586456 596204 601544 601553 601843 602293 607371 774691 775751 775810 777750 791486 795538 797504 798344 803415 804504 805222 805431 805586 805777 806104 806794 807353 811325 813105 777727 778055 787857 792135 797443 799413 800288 800492 801205 805424 806686 807539 810975 811029 813516 725626 733645 740792 748975 751611 782400 786129 801483 732248 741607 756216 756241 766707 767175 747310 725581 741291 742315 744654 751510 725570 738528 740919 741541 626292 644296 705710 708462 711417 716165 716750 777544 778379 789521 790572 792633 798509 806077 813014 397910 443166 460704 468581 7178 385381 393081 398800 401666 413183 422147 402375 414643 523843 510132 563263 630487 625887 749668 433375 638991 626965 409682 480432 422298 815095 815508 825304 723643 820641 821688 826910 817860 818283 818903 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (2.02%) |
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 7178 385381 393081 397910 398800 401666 402375 409682 413183 414643 422147 422298 433375 443166 460704 468581 480432 510132 523843 563263 585989 586456 596204 601544 601553 601843 602293 604313 607371 612816 613122 625887 626292 626965 630487 638991 642371 644296 705710 708462 711417 716165 716750 723643 725570 725581 725626 732248 733645 738528 740792 740919 741291 741541 741607 742315 744654 747310 748975 749668 751510 751611 756216 756241 766707 767175 774691 775751 775810 777544 777727 777750 778055 778379 782400 786129 787857 789521 790572 791486 792135 792633 795538 797443 797504 798344 798509 799413 800288 800492 801205 801483 803415 804504 805222 805424 805431 805586 805777 806077 806104 806686 806794 807353 807539 810975 811029 811325 813014 813105 813516 815095 815508 817860 818283 818903 820641 821688 825304 826910 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf mom anal"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf mom анал"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf mom анал"
]
|
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.