Query Metrics
8
Database Queries
8
Different statements
183.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.62 ms (86.29%) |
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 150654 383972 417252 462060 490664 496203 514109 530119 534608 535090 535258 537651 547772 558996 563114 564364 564391 580132 583343 586020 589593 591489 593065 593130 595072 601189 602663 611171 616985 617563 617788 617835 627153 636099 645693 664504 664595 669890 670928 692703 702288 702363 707229 707404 710074 710535 712226 712680 714466 717188 717541 718036 718119 720064 721039 723749 724090 725199 725412 726019 728586 728601 728936 729287 729640 732144 732169 732913 734698 735783 738427 742618 743806 745997 746593 750770 753690 754532 761036 761594 780309 780849 783425 784024 784823 786283 787207 791965 792994 793907 794816 794955 795359 796044 797074 797175 798829 801065 801617 802727 802918 803196 803725 803799 804463 804489 804652 804674 807710 809645 809877 810866 812854 818722 819153 824670 824990 826508 827295 828686 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (7.07%) |
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 720064 717188 586020 602663 593130 611171 593065 636099 787207 793907 794816 795359 803725 723749 725199 725412 735783 724090 726019 738427 745997 753690 732144 750770 728601 728936 617788 718119 780309 792994 802918 809877 710535 462060 707404 601189 784823 417252 707229 712226 804489 664595 664504 732169 490664 563114 580132 717541 547772 595072 797175 812854 783425 804652 728586 761594 794955 761036 732913 729640 743806 721039 798829 804674 150654 670928 801065 714466 383972 537651 710074 564364 617563 803196 742618 807710 729287 818722 826508 824670 827295 819153 824990 828686 530119 535258 514109 534608 496203 535090 583343 564391 645693 702288 702363 669890 692703 718036 712680 558996 589593 616985 591489 617835 627153 780849 784024 786283 796044 791965 797074 801617 803799 804463 734698 746593 754532 802727 809645 810866 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.54%) |
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 150654 383972 417252 462060 490664 496203 514109 530119 534608 535090 535258 537651 547772 558996 563114 564364 564391 580132 583343 586020 589593 591489 593065 593130 595072 601189 602663 611171 616985 617563 617788 617835 627153 636099 645693 664504 664595 669890 670928 692703 702288 702363 707229 707404 710074 710535 712226 712680 714466 717188 717541 718036 718119 720064 721039 723749 724090 725199 725412 726019 728586 728601 728936 729287 729640 732144 732169 732913 734698 735783 738427 742618 743806 745997 746593 750770 753690 754532 761036 761594 780309 780849 783425 784024 784823 786283 787207 791965 792994 793907 794816 794955 795359 796044 797074 797175 798829 801065 801617 802727 802918 803196 803725 803799 804463 804489 804652 804674 807710 809645 809877 810866 812854 818722 819153 824670 824990 826508 827295 828686 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf horny wife"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.12%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01ôöFÈôp¶çÁ\x102#ÉÌã"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf horny жен"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf horny жен"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.