Query Metrics
7
Database Queries
7
Different statements
170.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.59 ms (82.68%) |
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 129935 130022 142773 386050 396753 420136 429793 451531 451945 452034 454348 456142 457812 540195 543407 544393 544395 545408 546682 546684 548698 548729 548736 548738 548741 548744 548786 551050 551274 551992 552009 552162 556389 557439 558843 560432 560595 560602 562251 566264 568001 569021 569202 570414 570418 572736 573789 574247 574534 574781 574791 574846 575501 575506 575765 576029 576083 576098 576359 576367 576368 576402 576405 577374 578363 581676 582143 583728 585281 588966 589196 590188 595759 595813 597242 597254 597269 597793 600366 601512 604062 606200 627803 644311 647910 651855 651856 653154 659295 661271 661284 667232 672355 672396 676345 679099 683802 694118 709261 710516 715798 718955 721949 729881 732954 733172 742162 749918 751752 758979 766603 775783 792757 806422 807196 817451 818516 820882 821042 822154 ] |
||||||||||||||||||||||||||||||
|
19.36 ms (11.39%) |
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 710516 142773 560432 585281 715798 551992 429793 451531 548698 597254 758979 817451 546684 548741 552162 569021 569202 574791 574846 575501 576029 576098 578363 543407 544395 548786 557439 566264 575506 576368 581676 544393 545408 548744 551274 562251 570414 570418 574247 575765 583728 661284 647910 651855 651856 661271 548729 548736 548738 558843 573789 574781 576083 576359 576367 576402 576405 600366 590188 597242 595813 597269 589196 644311 742162 733172 751752 729881 601512 454348 672355 806422 807196 452034 572736 457812 540195 606200 766603 451945 694118 568001 577374 129935 130022 818516 822154 672396 683802 718955 653154 709261 775783 732954 749918 792757 386050 456142 396753 420136 821042 820882 676345 679099 552009 582143 556389 560602 551050 574534 659295 667232 560595 595759 588966 604062 597793 627803 721949 546682 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.68%) |
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 129935 130022 142773 386050 396753 420136 429793 451531 451945 452034 454348 456142 457812 540195 543407 544393 544395 545408 546682 546684 548698 548729 548736 548738 548741 548744 548786 551050 551274 551992 552009 552162 556389 557439 558843 560432 560595 560602 562251 566264 568001 569021 569202 570414 570418 572736 573789 574247 574534 574781 574791 574846 575501 575506 575765 576029 576083 576098 576359 576367 576368 576402 576405 577374 578363 581676 582143 583728 585281 588966 589196 590188 595759 595813 597242 597254 597269 597793 600366 601512 604062 606200 627803 644311 647910 651855 651856 653154 659295 661271 661284 667232 672355 672396 676345 679099 683802 694118 709261 710516 715798 718955 721949 729881 732954 733172 742162 749918 751752 758979 766603 775783 792757 806422 807196 817451 818516 820882 821042 822154 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits group"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ group"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая сиськ group"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.