Query Metrics
7
Database Queries
7
Different statements
236.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.79 ms (89.89%) |
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 384119 391951 397325 426728 427709 432749 441424 455888 461935 478651 484440 506192 517834 533276 537504 539244 542348 546284 555215 557018 564344 566919 570930 571421 583151 583909 585357 589325 593562 596905 607802 610156 611047 620499 622477 638898 644720 654974 663738 664755 675856 680229 686459 706531 707662 713301 714949 715700 717664 717673 717712 721811 721936 724030 726932 728410 729666 730473 731280 731311 733339 734331 734411 734928 734929 734961 735708 736222 736231 736293 736618 740935 742647 742852 744755 757870 758096 758929 760338 760892 761053 761462 761497 765248 766681 766883 767417 768465 769864 770469 771737 773409 775330 778627 779681 785317 785684 786940 788224 788552 788858 791097 791252 794171 799516 801253 802328 802668 802825 806864 807082 812845 812853 812858 812859 813824 820011 824167 826206 826834 ] |
||||||||||||||||||||||||||||||
|
12.83 ms (5.42%) |
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 761053 802668 397325 607802 566919 571421 654974 680229 664755 622477 610156 638898 785317 461935 583909 484440 826834 517834 717664 714949 715700 585357 589325 775330 785684 812858 788858 734411 736231 744755 771737 731280 730473 731311 734961 758929 773409 729666 736618 734928 717712 779681 620499 384119 813824 820011 824167 555215 788552 794171 799516 802825 742852 761497 786940 802328 806864 726932 728410 760338 778627 788224 812859 432749 427709 706531 533276 570930 557018 675856 713301 707662 721811 663738 686459 583151 644720 611047 596905 812845 426728 537504 564344 593562 742647 391951 455888 441424 539244 542348 546284 721936 724030 736222 740935 761462 768465 734331 766883 734929 735708 736293 760892 769864 733339 758096 791097 478651 826206 506192 717673 812853 791252 801253 765248 770469 807082 757870 766681 767417 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (1.52%) |
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 384119 391951 397325 426728 427709 432749 441424 455888 461935 478651 484440 506192 517834 533276 537504 539244 542348 546284 555215 557018 564344 566919 570930 571421 583151 583909 585357 589325 593562 596905 607802 610156 611047 620499 622477 638898 644720 654974 663738 664755 675856 680229 686459 706531 707662 713301 714949 715700 717664 717673 717712 721811 721936 724030 726932 728410 729666 730473 731280 731311 733339 734331 734411 734928 734929 734961 735708 736222 736231 736293 736618 740935 742647 742852 744755 757870 758096 758929 760338 760892 761053 761462 761497 765248 766681 766883 767417 768465 769864 770469 771737 773409 775330 778627 779681 785317 785684 786940 788224 788552 788858 791097 791252 794171 799516 801253 802328 802668 802825 806864 807082 812845 812853 812858 812859 813824 820011 824167 826206 826834 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur scream"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.67%) |
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.