Query Metrics
7
Database Queries
7
Different statements
150.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.10 ms (83.18%) |
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 389511 407274 411436 432573 432679 432854 435572 437999 438012 440947 441353 441406 452308 453508 454541 455949 458918 460503 460845 461026 464894 471458 490264 493402 504027 506312 507915 518186 518819 536448 554960 584961 586031 590297 590826 592872 597150 605560 620245 662889 682296 683978 686119 694559 696104 709346 712574 715879 715908 717621 720195 722125 724092 725547 726229 726621 726966 727771 729002 729039 730355 732744 733484 734968 735984 736378 736519 739608 739925 739950 743003 744165 746305 754158 756354 761077 761164 761784 763870 769855 778289 783145 787147 788011 788793 789750 793498 794710 795312 795935 795970 795984 796001 796018 796147 796155 797174 797461 800520 801368 803709 805978 806849 810294 813005 813627 813946 816596 817249 819431 820345 823354 823736 823836 825046 825891 826094 826739 827037 828581 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (9.61%) |
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 803709 794710 796001 733484 724092 729039 756354 763870 605560 709346 722125 787147 460845 518186 432573 736378 435572 493402 735984 820345 455949 694559 736519 801368 726966 783145 507915 453508 452308 796147 440947 438012 813946 813627 826739 823836 827037 817249 816596 819431 461026 683978 712574 686119 696104 715879 715908 662889 584961 590826 597150 590297 586031 797174 813005 795970 796018 800520 805978 725547 743003 744165 746305 761784 788011 789750 795935 795984 810294 730355 761077 726229 729002 734968 739925 739950 769855 739608 761164 717621 720195 793498 795312 806849 504027 506312 823354 389511 411436 441353 441406 407274 432679 490264 454541 458918 471458 460503 464894 682296 620245 788793 796155 778289 797461 754158 726621 727771 732744 432854 437999 823736 825046 825891 826094 828581 592872 518819 536448 554960 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.21%) |
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 389511 407274 411436 432573 432679 432854 435572 437999 438012 440947 441353 441406 452308 453508 454541 455949 458918 460503 460845 461026 464894 471458 490264 493402 504027 506312 507915 518186 518819 536448 554960 584961 586031 590297 590826 592872 597150 605560 620245 662889 682296 683978 686119 694559 696104 709346 712574 715879 715908 717621 720195 722125 724092 725547 726229 726621 726966 727771 729002 729039 730355 732744 733484 734968 735984 736378 736519 739608 739925 739950 743003 744165 746305 754158 756354 761077 761164 761784 763870 769855 778289 783145 787147 788011 788793 789750 793498 794710 795312 795935 795970 795984 796001 796018 796147 796155 797174 797461 800520 801368 803709 805978 806849 810294 813005 813627 813946 816596 817249 819431 820345 823354 823736 823836 825046 825891 826094 826739 827037 828581 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother cum"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин cum"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин cum"
]
|
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.