Query Metrics
7
Database Queries
7
Different statements
192.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.33 ms (87.53%) |
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 12775 58408 121824 387604 390049 390717 392415 396037 397985 401552 401555 401865 403061 403560 403759 411834 414116 420082 425824 432737 441245 441844 441864 445554 445582 446697 450840 455929 466658 472274 475482 490168 501137 505061 531882 536427 540021 547136 551756 563237 563326 577514 588446 589137 590121 592902 593149 595561 600543 606950 626376 628642 629194 630259 630679 632048 632108 635124 636673 637309 643264 643777 649776 654257 655184 666730 676327 676381 677189 678959 681936 687908 693593 696514 710689 724444 727474 750727 758476 759384 760739 761066 764344 766666 769502 773791 774293 784144 784337 784933 787104 787742 790801 793727 796607 799467 801010 804283 804596 804979 807995 810214 810215 810262 810894 810993 814958 818577 818853 819081 820342 821142 821153 821627 821643 822608 822951 823050 823324 828172 ] |
||||||||||||||||||||||||||||||
|
12.66 ms (6.59%) |
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 810215 804283 724444 630259 796607 810993 401555 818577 446697 676381 790801 774293 761066 769502 445554 390049 727474 632108 455929 600543 635124 588446 807995 750727 766666 629194 403560 760739 472274 121824 822951 818853 823324 821643 773791 414116 531882 441864 505061 441245 432737 466658 403061 821627 823050 501137 547136 563237 551756 563326 654257 655184 710689 649776 676327 693593 632048 606950 643777 595561 628642 636673 637309 643264 593149 804596 810262 758476 784144 784933 810894 764344 759384 804979 397985 828172 687908 401865 403759 799467 58408 450840 540021 666730 677189 696514 787742 810214 445582 390717 475482 401552 425824 12775 490168 577514 592902 590121 411834 678959 681936 589137 793727 784337 441844 396037 821142 821153 822608 820342 819081 630679 801010 787104 420082 387604 814958 536427 626376 392415 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (1.96%) |
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 12775 58408 121824 387604 390049 390717 392415 396037 397985 401552 401555 401865 403061 403560 403759 411834 414116 420082 425824 432737 441245 441844 441864 445554 445582 446697 450840 455929 466658 472274 475482 490168 501137 505061 531882 536427 540021 547136 551756 563237 563326 577514 588446 589137 590121 592902 593149 595561 600543 606950 626376 628642 629194 630259 630679 632048 632108 635124 636673 637309 643264 643777 649776 654257 655184 666730 676327 676381 677189 678959 681936 687908 693593 696514 710689 724444 727474 750727 758476 759384 760739 761066 764344 766666 769502 773791 774293 784144 784337 784933 787104 787742 790801 793727 796607 799467 801010 804283 804596 804979 807995 810214 810215 810262 810894 810993 814958 818577 818853 819081 820342 821142 821153 821627 821643 822608 822951 823050 823324 828172 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina big ass"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.