Query Metrics
7
Database Queries
7
Different statements
173.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.00 ms (84.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 73246 221799 311201 383541 387953 391394 394704 406330 414088 426224 426256 441788 442088 456890 457167 459976 482144 496589 499359 508258 513323 536421 538527 540092 541270 546046 553440 553749 554101 554795 554860 554866 555670 558777 583547 589221 591558 595316 600335 604405 610044 613651 615358 618644 619533 620061 630233 638872 640847 650519 651423 653907 660583 662074 664772 673328 677724 681002 681140 705472 706381 710516 711628 713449 714895 715517 726455 726768 726906 726966 727743 727778 730301 730943 731032 731254 735805 742712 744086 744952 750233 750374 750747 755589 756310 759860 759891 769624 774427 774672 775228 775888 776176 781455 790817 790842 794927 795331 795752 796139 796571 796718 796726 802253 802554 803157 805352 809242 812391 813887 814962 815141 817063 817119 817948 818106 818281 824496 825457 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (8.75%) |
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 750233 756310 759860 769624 604405 710516 795752 796718 803157 805352 809242 394704 499359 426256 536421 583547 553440 664772 714895 775228 727743 796139 759891 726455 727778 731254 610044 790842 383541 221799 311201 73246 391394 387953 406330 426224 441788 414088 442088 817948 774427 813887 815141 817063 818106 824496 814962 818281 825457 817119 457167 456890 508258 496589 540092 513323 538527 459976 482144 553749 554860 554866 541270 546559 558777 554795 555670 650519 651423 660583 715517 673328 706381 653907 662074 677724 681002 681140 705472 711628 713449 546046 554101 615358 638872 595316 618644 620061 589221 600335 619533 630233 591558 613651 640847 774672 781455 790817 794927 802253 812391 775888 776176 796726 802554 744086 744952 750374 755589 795331 796571 730301 730943 731032 735805 750747 726906 726966 742712 726768 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.62%) |
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 73246 221799 311201 383541 387953 391394 394704 406330 414088 426224 426256 441788 442088 456890 457167 459976 482144 496589 499359 508258 513323 536421 538527 540092 541270 546046 553440 553749 554101 554795 554860 554866 555670 558777 583547 589221 591558 595316 600335 604405 610044 613651 615358 618644 619533 620061 630233 638872 640847 650519 651423 653907 660583 662074 664772 673328 677724 681002 681140 705472 706381 710516 711628 713449 714895 715517 726455 726768 726906 726966 727743 727778 730301 730943 731032 731254 735805 742712 744086 744952 750233 750374 750747 755589 756310 759860 759891 769624 774427 774672 775228 775888 776176 781455 790817 790842 794927 795331 795752 796139 796571 796718 796726 802253 802554 803157 805352 809242 812391 813887 814962 815141 817063 817119 817948 818106 818281 824496 825457 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.14%) |
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.