Query Metrics
7
Database Queries
7
Different statements
167.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.86 ms (87.21%) |
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 161969 384883 396965 429561 431749 448954 485061 491963 491978 499332 509712 510074 512843 519278 527425 535961 537562 537574 539501 540207 551508 556799 563853 567981 570818 574405 576194 605542 617639 621378 622695 623325 624153 629796 651327 651665 652268 694551 697441 699703 702973 703873 704522 704535 712520 713035 714646 718511 722191 733601 740158 744325 744582 745452 754235 754851 776171 777607 784653 784850 785081 785888 786794 788152 789500 789752 789985 789994 797298 797952 799147 799664 800873 802468 802698 802726 802998 803061 804606 805135 813651 814583 815231 815860 816525 816563 816783 817043 817134 817292 817332 817455 817715 817835 817873 818113 818222 818225 818394 818414 818513 818588 818869 819248 819778 819988 820017 821142 821448 821757 821776 822471 822589 822979 823763 824021 825176 ] |
||||||||||||||||||||||||||||||
|
10.49 ms (6.27%) |
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 815860 816563 817873 822471 813651 816783 817292 819778 818394 822589 535961 574405 570818 651665 694551 704522 745452 800873 802998 744582 789985 537574 540207 699703 396965 817134 818222 567981 652268 722191 629796 784850 799147 802698 805135 789500 789752 754851 786794 161969 431749 448954 485061 527425 429561 509712 519278 491963 491978 499332 510074 512843 817715 817835 818869 821142 823763 818113 818588 815947 821757 822979 824021 817043 821448 537562 556799 576194 651327 702973 703873 704535 712520 697441 713035 718511 622695 621378 624153 623325 797298 797952 802468 784653 785081 740158 788152 802726 804606 754235 733601 744325 799664 803061 384883 814583 817332 819988 821776 825176 815231 816525 817455 820017 825782 818225 818414 818513 819248 821958 539501 563853 551508 714646 617639 605542 777607 785888 789994 776171 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.46%) |
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 161969 384883 396965 429561 431749 448954 485061 491963 491978 499332 509712 510074 512843 519278 527425 535961 537562 537574 539501 540207 551508 556799 563853 567981 570818 574405 576194 605542 617639 621378 622695 623325 624153 629796 651327 651665 652268 694551 697441 699703 702973 703873 704522 704535 712520 713035 714646 718511 722191 733601 740158 744325 744582 745452 754235 754851 776171 777607 784653 784850 785081 785888 786794 788152 789500 789752 789985 789994 797298 797952 799147 799664 800873 802468 802698 802726 802998 803061 804606 805135 813651 814583 815231 815860 816525 816563 816783 817043 817134 817292 817332 817455 817715 817835 817873 818113 818222 818225 818394 818414 818513 818588 818869 819248 819778 819988 820017 821142 821448 821757 821776 822471 822589 822979 823763 824021 825176 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex mom 2022"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom"
]
|
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.