Query Metrics
7
Database Queries
7
Different statements
173.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.12 ms (85.26%) |
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 146317 385742 399253 399367 402664 406711 420541 426606 428637 429982 444128 456496 458739 459751 466623 471521 471927 472249 476381 477440 478337 481288 481322 484822 485882 489806 491067 491198 492512 502292 502899 504797 504964 514593 515109 515186 515225 519607 522454 533514 538668 539519 540776 543822 544270 550433 550612 559705 563877 580664 583856 585169 612842 626543 626755 628300 635897 652600 655685 656381 657730 658419 659601 665247 666810 673985 680864 681862 682091 683505 683524 684224 684943 684965 685632 686794 688591 695921 698657 698958 701384 702958 711894 712906 712913 712923 715832 716391 718627 719989 721434 731098 734715 735570 738274 739478 741453 744301 747926 748544 751500 755735 759584 759847 760466 802433 814074 814915 815259 816791 818078 818410 818665 819595 820427 821625 821825 822194 823024 827844 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (8.31%) |
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 428637 429982 444128 456496 458739 459751 466623 471521 481288 146317 385742 399253 399367 402664 406711 476381 426606 471927 472249 477440 478337 481322 504797 515109 515225 519607 484822 502899 514593 522454 485882 489806 491067 502292 504964 491198 492512 533514 420541 583856 550433 515186 818078 818410 818665 821825 822194 540776 816791 814074 815259 823024 814915 819595 820427 821625 827844 539519 538668 543822 550612 544270 563877 580664 652600 657730 666810 681862 682091 698657 701384 658419 673985 684965 685632 686794 695921 698958 702958 711894 712913 715832 716391 655685 656381 659601 665247 680864 683505 683524 684224 684943 688591 712906 712923 718627 719989 721434 559705 628300 635897 585169 612842 626543 626755 734715 739478 751500 755735 802433 759847 760466 731098 735570 738274 744301 747926 759584 741453 748544 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.56%) |
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 146317 385742 399253 399367 402664 406711 420541 426606 428637 429982 444128 456496 458739 459751 466623 471521 471927 472249 476381 477440 478337 481288 481322 484822 485882 489806 491067 491198 492512 502292 502899 504797 504964 514593 515109 515186 515225 519607 522454 533514 538668 539519 540776 543822 544270 550433 550612 559705 563877 580664 583856 585169 612842 626543 626755 628300 635897 652600 655685 656381 657730 658419 659601 665247 666810 673985 680864 681862 682091 683505 683524 684224 684943 684965 685632 686794 688591 695921 698657 698958 701384 702958 711894 712906 712913 712923 715832 716391 718627 719989 721434 731098 734715 735570 738274 739478 741453 744301 747926 748544 751500 755735 759584 759847 760466 802433 814074 814915 815259 816791 818078 818410 818665 819595 820427 821625 821825 822194 823024 827844 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock old мужчин"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock old man"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock old мужчин"
]
|
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.