Query Metrics
7
Database Queries
7
Different statements
625.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.61 ms (33.65%) |
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 13875 31583 145163 270290 318132 375092 383130 384913 385647 385910 386928 387018 389875 392017 393741 395398 395626 395781 395913 396990 398954 399634 399889 402013 405623 411511 417219 425207 428852 431514 435975 440994 446817 450301 453084 455326 461605 467096 467894 469230 469734 476440 477050 480541 481157 481864 483757 484753 488017 499089 507083 507216 508372 513136 515787 517415 518590 526808 526843 527818 530144 530423 532324 534953 544474 577934 585129 587779 591267 592435 594066 599064 600980 605033 605046 605999 620995 626271 642622 664579 664800 665766 669989 678173 681613 682226 685967 703603 709450 713067 715041 720603 740556 750326 752663 757368 769147 778010 778986 792507 794106 795578 796237 796463 797908 803327 803859 804178 806352 807988 810108 812086 813074 813109 815154 816090 816222 816272 816711 820387 ] |
||||||||||||||||||||||||||||||
|
209.57 ms (33.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"очкастая черноволосая"
]
|
||||||||||||||||||||||||||||||
|
172.72 ms (27.60%) |
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 13875 31583 145163 270290 318132 375092 383130 384913 385647 385910 386928 387018 389875 392017 393741 395398 395626 395781 395913 396990 398954 399634 399889 402013 405623 411511 417219 425207 428852 431514 435975 440994 446817 450301 453084 455326 461605 467096 467894 469230 469734 476440 477050 480541 481157 481864 483757 484753 488017 499089 507083 507216 508372 513136 515787 517415 518590 526808 526843 527818 530144 530423 532324 534953 544474 577934 585129 587779 591267 592435 594066 599064 600980 605033 605046 605999 620995 626271 642622 664579 664800 665766 669989 678173 681613 682226 685967 703603 709450 713067 715041 720603 740556 750326 752663 757368 769147 778010 778986 792507 794106 795578 796237 796463 797908 803327 803859 804178 806352 807988 810108 812086 813074 813109 815154 816090 816222 816272 816711 820387 ] |
||||||||||||||||||||||||||||||
|
27.66 ms (4.42%) |
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 577934 669989 681613 685967 665766 709450 664579 664800 678173 682226 703603 713067 715041 587779 642622 592435 594066 599064 600980 605046 778010 794106 795578 797908 792507 796463 803327 807988 810108 812086 813074 813109 740556 750326 769147 796237 803859 806352 757368 752663 605033 605999 626271 720603 778986 804178 318132 385647 386928 392017 398954 411511 383130 405623 469734 477050 591267 620995 526808 481157 467894 544474 431514 395913 461605 526843 499089 385910 384913 145163 393741 395398 395626 395781 375092 270290 31583 13875 389875 387018 396990 399634 399889 402013 428852 435975 440994 417219 425207 585129 820387 815154 816090 816222 816272 816711 446817 450301 455326 469230 476440 483757 488017 480541 481864 453084 467096 484753 507216 515787 518590 530144 530423 532324 508372 513136 507083 517415 527818 534953 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"очкастая черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"glasses brunette"
]
|
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.