Query Metrics
7
Database Queries
7
Different statements
358.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.78 ms (58.23%) |
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 455156 461191 497336 526940 542100 547224 548875 551450 552333 552407 552468 552874 556563 559051 559797 559998 562157 563759 565912 567099 567623 571504 572337 575300 579603 580903 581510 582530 583379 588697 607931 614256 624974 631371 634303 636138 647474 655549 656943 670540 675901 680814 696122 706228 710027 714636 717868 719522 719586 720324 734849 735110 736912 738503 739439 739469 740193 751210 755772 757017 759441 765568 767320 768063 768191 773156 775023 775287 779149 781184 781623 782084 782639 782656 782751 783997 785735 786009 786528 786967 787813 788420 788639 788645 789383 789933 791185 791256 791302 791521 791701 792205 792505 794016 795401 796700 798610 799822 801690 803119 803397 808488 810833 811346 812441 812584 814201 814292 814452 816738 817418 818029 818563 818574 819133 819969 824875 824929 825483 ] |
||||||||||||||||||||||||||||||
|
124.53 ms (34.73%) |
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 455156 461191 497336 526940 542100 547224 548875 551450 552333 552407 552468 552874 556563 559051 559797 559998 562157 563759 565912 567099 567623 571504 572337 575300 579603 580903 581510 582530 583379 588697 607931 614256 624974 631371 634303 636138 647474 655549 656943 670540 675901 680814 696122 706228 710027 714636 717868 719522 719586 720324 734849 735110 736912 738503 739439 739469 740193 751210 755772 757017 759441 765568 767320 768063 768191 773156 775023 775287 779149 781184 781623 782084 782639 782656 782751 783997 785735 786009 786528 786967 787813 788420 788639 788645 789383 789933 791185 791256 791302 791521 791701 792205 792505 794016 795401 796700 798610 799822 801690 803119 803397 808488 810833 811346 812441 812584 814201 814292 814452 816738 817418 818029 818563 818574 819133 819969 824875 824929 825483 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (4.77%) |
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 803397 808488 552468 542100 552874 579603 552333 572337 559797 559998 565912 814292 824929 819969 814452 824875 817418 547224 647474 696122 714636 655549 719522 636138 607931 781623 783997 788645 789933 799822 811346 795401 803119 810833 812441 755772 768063 773156 791521 792505 740193 757017 735110 739469 734849 739439 759441 767320 768191 719586 720324 786009 796700 575300 798610 736912 738503 455156 461191 497336 556563 563759 581510 551450 559051 571504 548875 552407 567623 588697 526940 818029 818563 825483 814201 818574 816738 819133 583379 580903 582530 562157 567099 670540 675901 706228 710027 717868 656943 680814 624974 597175 614256 631371 634303 779149 782084 782639 782751 786528 789383 791701 792205 801690 775023 775287 781184 782656 785735 786967 787813 788420 788639 791185 791256 791302 794016 812584 751210 765568 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans girl"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет девушк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.41%) |
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.