Query Metrics
7
Database Queries
7
Different statements
257.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
231.23 ms (89.80%) |
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 426728 427709 432749 441424 461935 464239 469732 478651 484440 490778 490800 506192 509163 533276 537504 539244 542348 546284 557018 564344 569736 570930 578131 580241 583151 585357 589325 593562 596905 607301 607802 608729 610156 611047 621404 622477 623542 638898 644720 651097 663738 664755 665404 675030 675856 680229 680282 684305 686459 707662 713301 714949 715700 717664 717673 717712 721811 721936 724030 726932 728410 729666 730473 731280 731311 734331 734411 734928 734929 734961 735708 736222 736231 736293 736618 740935 742852 744755 753316 755408 757870 758929 760338 761462 761497 765248 766681 766883 768465 770469 771737 773409 775330 778627 779681 785317 785684 786749 786940 788224 788552 788858 791252 794171 797705 799516 799668 800466 801225 801253 802328 802825 806864 807082 810186 812845 812853 812858 812859 826206 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (5.54%) |
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 680229 717664 665404 714949 664755 715700 622477 585357 589325 607802 610156 638898 775330 785684 788552 794171 797705 812858 785317 788858 799516 802825 734411 736231 742852 744755 753316 761497 771737 786940 800466 802328 806864 726932 731280 728410 730473 731311 734961 758929 760338 773409 729666 736618 734928 621404 717712 778627 779681 788224 812859 432749 461935 427709 484440 684305 478651 441424 426728 826206 464239 469732 490800 490778 506192 509163 533276 537504 539244 570930 580241 542348 546284 557018 564344 569736 651097 675856 680282 713301 717673 707662 721811 663738 675030 686459 721936 578131 583151 607301 644720 593562 611047 596905 608729 623542 801225 812853 786749 791252 799668 801253 724030 736222 740935 761462 765248 768465 770469 807082 810186 812845 734331 757870 766681 766883 734929 735708 736293 755408 ] |
||||||||||||||||||||||||||||||
|
4.55 ms (1.77%) |
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 426728 427709 432749 441424 461935 464239 469732 478651 484440 490778 490800 506192 509163 533276 537504 539244 542348 546284 557018 564344 569736 570930 578131 580241 583151 585357 589325 593562 596905 607301 607802 608729 610156 611047 621404 622477 623542 638898 644720 651097 663738 664755 665404 675030 675856 680229 680282 684305 686459 707662 713301 714949 715700 717664 717673 717712 721811 721936 724030 726932 728410 729666 730473 731280 731311 734331 734411 734928 734929 734961 735708 736222 736231 736293 736618 740935 742852 744755 753316 755408 757870 758929 760338 761462 761497 765248 766681 766883 768465 770469 771737 773409 775330 778627 779681 785317 785684 786749 786940 788224 788552 788858 791252 794171 797705 799516 799668 800466 801225 801253 802328 802825 806864 807082 810186 812845 812853 812858 812859 826206 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"scream and crying"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крича вперв крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.56%) |
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.