Query Metrics
7
Database Queries
7
Different statements
158.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.50 ms (85.46%) |
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 7308 12090 237950 284922 383112 384960 389431 389936 397599 397834 400587 402042 409076 445583 449398 453233 455639 466786 475188 487605 509878 510568 513943 514408 521937 541460 544570 550403 556169 557471 558375 561725 568550 569847 569875 570036 570207 570211 570526 571598 576017 576124 579131 587927 596033 598926 602109 608714 617680 630567 636801 643738 648206 650282 660711 662033 662783 666868 672701 674216 675801 678947 697113 699205 704040 706021 712175 713240 715175 715754 720483 720946 721096 721805 727393 729370 736822 737356 741616 742005 742035 742886 747316 751613 754078 756081 756152 757074 758561 765868 767201 770838 773000 773319 773453 779381 782471 783003 784067 784585 785967 786354 788894 793099 799859 800451 801331 802024 805067 806444 807255 809002 809163 812596 815274 817039 818798 822276 822735 ] |
||||||||||||||||||||||||||||||
|
14.07 ms (8.88%) |
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 449398 513943 521937 510568 487605 514408 666868 636801 383112 284922 12090 389431 397599 397834 400587 402042 409076 818798 822276 817039 815274 822735 453233 466786 455639 509878 541460 558375 561725 569875 569904 570036 570526 557471 569847 570207 576124 544570 568550 571598 579131 648206 672701 704040 713240 720483 650282 660711 662783 678947 706021 712175 715754 721805 662033 674216 675801 697113 720946 550403 556169 570211 576017 596033 598926 643738 587927 608714 630567 783003 785967 801331 802024 809002 809163 812596 779381 782471 793099 800451 742035 751613 754078 757074 773000 773319 784067 784585 788894 799859 806444 807255 727393 736822 741616 742886 758561 729370 737356 742005 747316 756152 765868 773453 756081 767201 770838 602109 617680 699205 715175 721096 786354 805067 384960 445583 475188 7308 237950 389936 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.71%) |
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 7308 12090 237950 284922 383112 384960 389431 389936 397599 397834 400587 402042 409076 445583 449398 453233 455639 466786 475188 487605 509878 510568 513943 514408 521937 541460 544570 550403 556169 557471 558375 561725 568550 569847 569875 570036 570207 570211 570526 571598 576017 576124 579131 587927 596033 598926 602109 608714 617680 630567 636801 643738 648206 650282 660711 662033 662783 666868 672701 674216 675801 678947 697113 699205 704040 706021 712175 713240 715175 715754 720483 720946 721096 721805 727393 729370 736822 737356 741616 742005 742035 742886 747316 751613 754078 756081 756152 757074 758561 765868 767201 770838 773000 773319 773453 779381 782471 783003 784067 784585 785967 786354 788894 793099 799859 800451 801331 802024 805067 806444 807255 809002 809163 812596 815274 817039 818798 822276 822735 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sexy"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая sexy"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая sexy"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.91%) |
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.