Query Metrics
7
Database Queries
7
Different statements
161.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.47 ms (81.81%) |
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 461921 476225 491131 496061 506303 518535 538268 547419 549069 557828 562105 569971 576977 577638 581109 584145 591750 596293 609267 610946 612886 616747 618848 619391 620614 620940 627490 632156 633637 634825 638033 638770 646085 652929 655192 660572 662139 662171 664532 665904 665905 671665 680774 692703 697491 698725 704264 704654 711273 714986 715014 715934 716050 717235 717666 718358 718676 719582 720212 720232 720235 720820 721556 725645 725748 726171 726287 726929 729283 730346 731100 731243 734390 735968 737898 739894 741577 742233 742644 743083 743905 744771 747474 747492 748963 751438 754200 755125 755843 756685 757298 759439 759914 760988 761484 761521 763059 767502 771863 773314 773350 773381 773384 773417 776937 777694 783029 785557 786790 788525 792268 794359 794369 794674 795816 796054 804411 804413 806324 811618 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (10.62%) |
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 549069 697491 788525 655192 717666 619391 743083 773314 609267 634825 794359 735968 476225 491131 627490 776937 785557 783029 729283 773350 633637 806324 718358 720212 660572 692703 720820 715934 618848 796054 744771 761484 773384 760988 731100 748963 767502 771863 737898 742644 704264 715014 795816 811618 719582 652929 680774 718676 726287 759439 725748 720235 665904 665905 612886 741577 773381 711273 662171 576977 596293 610946 792268 804411 742233 755843 725645 756685 757298 747474 714986 616747 739894 716050 786790 730346 506303 671665 620940 591750 664532 569971 638770 731243 794369 496061 584145 720232 717235 638033 620614 726171 751438 726929 747492 734390 755125 773417 698725 804413 704654 743905 577638 777694 761521 754200 763059 759914 461921 518535 562105 581109 547419 646085 721556 662139 794674 632156 538268 557828 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.13%) |
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 461921 476225 491131 496061 506303 518535 538268 547419 549069 557828 562105 569971 576977 577638 581109 584145 591750 596293 609267 610946 612886 616747 618848 619391 620614 620940 627490 632156 633637 634825 638033 638770 646085 652929 655192 660572 662139 662171 664532 665904 665905 671665 680774 692703 697491 698725 704264 704654 711273 714986 715014 715934 716050 717235 717666 718358 718676 719582 720212 720232 720235 720820 721556 725645 725748 726171 726287 726929 729283 730346 731100 731243 734390 735968 737898 739894 741577 742233 742644 743083 743905 744771 747474 747492 748963 751438 754200 755125 755843 756685 757298 759439 759914 760988 761484 761521 763059 767502 771863 773314 773350 773381 773384 773417 776937 777694 783029 785557 786790 788525 792268 794359 794369 794674 795816 796054 804411 804413 806324 811618 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"painful sex"
]
|
||||||||||||||||||||||||||||||
|
2.31 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крича вперв секс"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.22%) |
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.