Query Metrics
7
Database Queries
7
Different statements
228.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.63 ms (87.24%) |
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 34087 54371 98711 198609 383090 396040 408371 416402 439634 460440 469820 471610 492426 533723 535090 536716 539597 539767 545788 547312 557446 557513 561494 566349 567891 577175 582356 585475 593280 593384 594797 595590 596086 601096 601153 620507 621488 622025 623403 626369 633021 635721 639176 647133 652983 669239 693660 694579 695391 703228 707589 710382 710466 712418 719021 723071 724204 738852 739533 741093 742555 744892 745058 746170 752197 755285 755394 768151 769382 771381 771773 771867 772694 774141 774143 775813 776954 779173 781831 791414 792217 795176 795711 797120 797186 797617 798241 798845 799660 801480 802437 803320 803475 805365 805730 805781 806508 807451 807861 808665 809231 811214 813686 815941 815949 818279 819152 819243 823244 823349 824403 824634 825894 826499 826610 826713 826996 828383 828747 828868 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (7.15%) |
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 824634 492426 471610 539597 557513 712418 647133 694579 710466 561494 582356 585475 593280 626369 621488 596086 601153 622025 798845 771381 805730 738852 742555 744892 781831 797617 807861 776954 807451 769382 771867 198609 825894 826499 813686 815941 815949 823244 823349 536716 539767 469820 557446 566349 577175 567891 652983 669239 710382 594797 633021 595590 601096 620507 805365 745058 752197 723071 34087 535090 547312 703228 635721 792217 545788 98711 824403 826610 826713 826996 818279 819152 819243 828868 828383 533723 460440 695391 707589 693660 719021 639176 623403 775813 779173 795176 802437 803320 803475 805781 806508 808665 811214 798241 739533 741093 772694 774143 791414 795711 797186 799660 755394 746170 755285 771773 774141 724204 768151 797120 801480 809231 54371 408371 593384 439634 828747 383090 396040 416402 ] |
||||||||||||||||||||||||||||||
|
4.36 ms (1.91%) |
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 34087 54371 98711 198609 383090 396040 408371 416402 439634 460440 469820 471610 492426 533723 535090 536716 539597 539767 545788 547312 557446 557513 561494 566349 567891 577175 582356 585475 593280 593384 594797 595590 596086 601096 601153 620507 621488 622025 623403 626369 633021 635721 639176 647133 652983 669239 693660 694579 695391 703228 707589 710382 710466 712418 719021 723071 724204 738852 739533 741093 742555 744892 745058 746170 752197 755285 755394 768151 769382 771381 771773 771867 772694 774141 774143 775813 776954 779173 781831 791414 792217 795176 795711 797120 797186 797617 798241 798845 799660 801480 802437 803320 803475 805365 805730 805781 806508 807451 807861 808665 809231 811214 813686 815941 815949 818279 819152 819243 823244 823349 824403 824634 825894 826499 826610 826713 826996 828383 828747 828868 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf big boobs"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf большие boobs"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf большие boobs"
]
|
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.