Query Metrics
7
Database Queries
7
Different statements
210.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.35 ms (87.59%) |
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 69063 150261 193190 210281 382398 387545 388723 390574 391089 391907 391929 397899 399139 403067 417066 430526 443045 445291 450213 453612 453856 461086 467645 470579 470634 480064 482132 483518 483761 495738 496728 501394 512949 524169 526122 530256 534129 536996 540100 543982 545414 545585 546667 547957 547968 548005 566392 567997 583454 585950 590627 590898 593859 603608 603632 606584 606662 608427 614698 615312 616698 622158 622177 622189 622699 623221 624982 632249 634293 635833 635854 639330 640020 649227 651270 651290 651306 651408 651421 653618 653622 653830 653891 653923 654269 654294 655489 659078 665928 693380 694025 694033 698077 698089 698104 698129 709915 710953 712636 712654 713783 717245 720833 723074 731481 741207 746849 748446 773945 775794 797132 800007 801535 802488 805339 807889 810106 813050 817445 825122 ] |
||||||||||||||||||||||||||||||
|
15.30 ms (7.27%) |
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 69063 461086 712654 443045 495738 807889 470579 651408 653891 622177 624982 480064 603608 470634 391929 445291 567997 547968 655489 694033 720833 651290 651421 653618 654294 651306 665928 698089 622158 635854 614698 616698 150261 391907 450213 453612 797132 623221 397899 593859 748446 483518 496728 536996 540100 693380 649227 653622 622189 639330 640020 606662 482132 615312 583454 545414 746849 810106 606584 399139 403067 512949 634293 731481 710953 210281 543982 723074 775794 713783 653923 632249 590627 524169 530256 698129 659078 709915 802488 805339 801535 698104 717245 382398 391089 800007 817445 603632 608427 430526 546667 651270 653830 694025 698077 548005 635833 388723 387545 825122 545585 654269 741207 483761 534129 773945 622699 526122 566392 590898 585950 467645 417066 712636 453856 501394 193190 390574 547957 813050 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.60%) |
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 69063 150261 193190 210281 382398 387545 388723 390574 391089 391907 391929 397899 399139 403067 417066 430526 443045 445291 450213 453612 453856 461086 467645 470579 470634 480064 482132 483518 483761 495738 496728 501394 512949 524169 526122 530256 534129 536996 540100 543982 545414 545585 546667 547957 547968 548005 566392 567997 583454 585950 590627 590898 593859 603608 603632 606584 606662 608427 614698 615312 616698 622158 622177 622189 622699 623221 624982 632249 634293 635833 635854 639330 640020 649227 651270 651290 651306 651408 651421 653618 653622 653830 653891 653923 654269 654294 655489 659078 665928 693380 694025 694033 698077 698089 698104 698129 709915 710953 712636 712654 713783 717245 720833 723074 731481 741207 746849 748446 773945 775794 797132 800007 801535 802488 805339 807889 810106 813050 817445 825122 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм любительский"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро любительск"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.75%) |
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.