Query Metrics
7
Database Queries
7
Different statements
145.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.31 ms (84.00%) |
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 117596 193890 209384 229555 385306 392455 395392 397188 405682 466045 488806 499621 505561 508719 513236 535444 537608 539251 543359 545091 545218 547130 547220 551466 555632 560030 560754 564466 565993 570777 578635 578789 588117 588124 604110 605537 614006 624235 631994 632989 635789 637232 639361 639929 644681 645730 645826 653347 659482 673159 682253 694228 712593 712687 718499 719087 720269 721729 723279 723433 724359 726284 729662 730921 730924 731131 732650 734270 735664 736239 742113 742592 742766 743458 744573 749629 750552 753208 754505 756290 758017 762029 764751 766411 768447 769675 772011 772398 772551 776835 781746 783055 783536 784140 787054 787102 787711 788047 791842 793412 797019 797329 798245 798862 802855 803590 809904 809991 813315 813426 813901 817658 818046 818841 820103 823445 825217 825325 825394 827535 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (8.89%) |
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 788047 798245 809991 726284 736239 756290 769675 732650 734270 735664 743458 768447 772551 742592 753208 772011 631994 719087 723279 783055 784140 813315 499621 817658 395392 385306 229555 209384 653347 694228 545091 723433 791842 405682 639361 803590 776835 729662 754505 392455 825394 823445 578635 565993 682253 712687 645826 645730 673159 570777 578789 639929 635789 781746 787711 787054 793412 809904 731131 758017 764751 742113 762029 750552 766411 632989 798862 466045 508719 193890 397188 820103 825325 813901 827535 818046 825217 513236 535444 560030 555632 551466 560754 564466 712593 659482 720269 721729 718499 547130 547220 604110 614006 637232 588117 644681 588124 605537 783536 797019 802855 787102 797329 730921 749629 724359 730924 744573 772398 742766 624235 813426 505561 117596 818841 488806 537608 539251 543359 545218 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (2.02%) |
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 117596 193890 209384 229555 385306 392455 395392 397188 405682 466045 488806 499621 505561 508719 513236 535444 537608 539251 543359 545091 545218 547130 547220 551466 555632 560030 560754 564466 565993 570777 578635 578789 588117 588124 604110 605537 614006 624235 631994 632989 635789 637232 639361 639929 644681 645730 645826 653347 659482 673159 682253 694228 712593 712687 718499 719087 720269 721729 723279 723433 724359 726284 729662 730921 730924 731131 732650 734270 735664 736239 742113 742592 742766 743458 744573 749629 750552 753208 754505 756290 758017 762029 764751 766411 768447 769675 772011 772398 772551 776835 781746 783055 783536 784140 787054 787102 787711 788047 791842 793412 797019 797329 798245 798862 802855 803590 809904 809991 813315 813426 813901 817658 818046 818841 820103 823445 825217 825325 825394 827535 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck friend"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс friend"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс friend"
]
|
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.