Query Metrics
7
Database Queries
7
Different statements
177.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.57 ms (86.97%) |
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 402949 407274 411436 423455 432430 432679 432854 434531 437999 440292 441353 441406 453254 454541 455573 460503 469402 471458 504027 506312 507429 518819 536448 547740 554960 555425 573249 584961 586031 590297 590826 592872 597150 599682 641528 668006 670904 682296 696336 702310 710177 710563 712643 714564 715001 715538 717621 720195 725154 725547 726229 726370 726376 726621 727771 729002 730355 731265 734473 734968 738834 739608 739925 739950 740954 743003 744165 745476 746104 746163 746305 746865 750711 754158 758288 758317 761077 761164 761784 769137 769463 769855 778289 787479 787614 788011 788793 789127 789750 791965 793498 793700 793765 794272 795312 795935 795970 795984 796018 796155 796172 796752 797174 797461 800520 803082 803311 805978 806849 810114 810294 813005 823354 823736 825046 825420 825891 826094 828581 ] |
||||||||||||||||||||||||||||||
|
11.82 ms (6.65%) |
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 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 454541 471458 460503 682296 788793 796155 778289 797461 754158 726621 727771 432854 437999 823736 825046 825891 826094 828581 592872 518819 536448 554960 702310 714564 641528 793765 789127 793700 750711 740954 432430 455573 507429 547740 738834 423455 434531 440292 825420 453254 469402 555425 670904 787614 787479 402949 573249 668006 696336 712643 715538 710177 710563 715001 599682 803311 791965 794272 796752 803082 725154 745476 746163 758288 769137 796172 810114 734473 726376 769463 726370 731265 746104 746865 758317 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.75%) |
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 402949 407274 411436 423455 432430 432679 432854 434531 437999 440292 441353 441406 453254 454541 455573 460503 469402 471458 504027 506312 507429 518819 536448 547740 554960 555425 573249 584961 586031 590297 590826 592872 597150 599682 641528 668006 670904 682296 696336 702310 710177 710563 712643 714564 715001 715538 717621 720195 725154 725547 726229 726370 726376 726621 727771 729002 730355 731265 734473 734968 738834 739608 739925 739950 740954 743003 744165 745476 746104 746163 746305 746865 750711 754158 758288 758317 761077 761164 761784 769137 769463 769855 778289 787479 787614 788011 788793 789127 789750 791965 793498 793700 793765 794272 795312 795935 795970 795984 796018 796155 796172 796752 797174 797461 800520 803082 803311 805978 806849 810114 810294 813005 823354 823736 825046 825420 825891 826094 828581 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in mother"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
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.