Query Metrics
7
Database Queries
7
Different statements
221.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.17 ms (87.14%) |
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 6715 21731 23884 53932 69871 80699 185820 223345 253864 270415 365903 384892 385162 387448 388850 391208 397631 410808 422657 431105 439733 439772 443103 444356 467973 470472 473980 477439 482536 485712 486864 494312 498775 500221 504895 506143 506807 510877 513477 513838 519013 520573 521099 521204 521236 522238 523021 526366 528400 530185 531067 535255 535805 536703 537174 538953 539633 540338 540657 545747 554349 554579 555968 561544 565472 567757 574137 575979 577314 577409 587998 588722 592834 596599 599102 599361 599450 599540 600477 601423 601828 601900 601990 605762 605794 611642 613808 614442 617214 620309 624430 624489 624762 631600 639345 642041 649558 652533 654840 659612 660524 666899 666901 671697 674952 675167 675588 676911 696220 728397 755184 782764 784315 794959 799711 813955 814050 816148 816165 825741 ] |
||||||||||||||||||||||||||||||
|
18.64 ms (8.41%) |
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 506807 537174 528400 535255 554579 555968 545747 611642 596599 588722 617214 439733 473980 587998 270415 504895 601900 624762 605762 613808 470472 385162 6715 410808 513838 521236 500221 494312 666899 601423 601828 784315 513477 510877 631600 535805 521204 526366 654840 575979 599540 620309 601990 439772 477439 825741 539633 600477 391208 599102 605794 624489 567757 675588 816148 554349 649558 467973 523021 614442 522238 520573 521099 531067 388850 538953 660524 794959 23884 397631 443103 540338 540657 506143 482536 577409 674952 666901 676911 642041 485712 814050 577314 671697 675167 799711 755184 639345 384892 574137 599361 80699 53932 387448 813955 592834 782764 69871 223345 253864 365903 422657 431105 728397 536703 486864 519013 624430 599450 185820 21731 444356 498775 816165 530185 561544 565472 652533 659612 696220 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.45%) |
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 6715 21731 23884 53932 69871 80699 185820 223345 253864 270415 365903 384892 385162 387448 388850 391208 397631 410808 422657 431105 439733 439772 443103 444356 467973 470472 473980 477439 482536 485712 486864 494312 498775 500221 504895 506143 506807 510877 513477 513838 519013 520573 521099 521204 521236 522238 523021 526366 528400 530185 531067 535255 535805 536703 537174 538953 539633 540338 540657 545747 554349 554579 555968 561544 565472 567757 574137 575979 577314 577409 587998 588722 592834 596599 599102 599361 599450 599540 600477 601423 601828 601900 601990 605762 605794 611642 613808 614442 617214 620309 624430 624489 624762 631600 639345 642041 649558 652533 654840 659612 660524 666899 666901 671697 674952 675167 675588 676911 696220 728397 755184 782764 784315 794959 799711 813955 814050 816148 816165 825741 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"рот в рот"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рот в рот"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.