Query Metrics
7
Database Queries
7
Different statements
152.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.49 ms (80.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 2939 47613 78412 79082 130060 392589 393855 396372 396595 396744 402967 422257 424675 431805 437855 443387 443389 443761 444248 445473 445735 446314 447036 450476 451574 453032 453095 453494 453587 453910 454367 458240 462209 470047 470276 470534 470617 476015 484387 484563 484693 485147 485703 486782 490762 499718 500363 500364 500369 506051 506259 509400 509404 513215 516306 516329 520753 520771 525238 525626 526125 526130 529201 531280 535406 543602 544181 545333 545381 545391 545408 545518 560451 565154 565351 570683 576540 581349 583927 584004 589196 593843 594431 603132 604536 606561 606582 606590 617170 621990 626752 632298 635789 636579 636879 649633 651287 654274 666480 667349 670041 674131 675296 679536 681319 687639 690049 708144 716804 726311 726744 775915 776017 784321 793471 803353 818847 819024 823177 825237 ] |
||||||||||||||||||||||||||||||
|
17.13 ms (11.24%) |
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 803353 776017 726311 570683 604536 470276 626752 529201 545391 535406 606582 454367 543602 545518 443761 446314 526125 453032 444248 506259 606590 490762 621990 690049 531280 47613 486782 509404 681319 636579 632298 593843 78412 392589 654274 823177 583927 675296 617170 509400 708144 716804 79082 2939 470534 560451 775915 726744 453587 589196 793471 130060 393855 402967 516306 470617 545381 545408 687639 422257 396595 825237 458240 450476 443387 453910 451574 584004 470047 525238 484387 396372 445473 670041 431805 396744 447036 445735 453095 476015 484563 516329 424675 462209 500369 506051 437855 453494 525626 500364 499718 603132 606561 667349 513215 819024 526130 443389 636879 484693 544181 485703 784321 520771 679536 545333 581349 500363 649633 635789 520753 565351 565154 594431 485147 576540 666480 818847 674131 651287 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (2.83%) |
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 2939 47613 78412 79082 130060 392589 393855 396372 396595 396744 402967 422257 424675 431805 437855 443387 443389 443761 444248 445473 445735 446314 447036 450476 451574 453032 453095 453494 453587 453910 454367 458240 462209 470047 470276 470534 470617 476015 484387 484563 484693 485147 485703 486782 490762 499718 500363 500364 500369 506051 506259 509400 509404 513215 516306 516329 520753 520771 525238 525626 526125 526130 529201 531280 535406 543602 544181 545333 545381 545391 545408 545518 560451 565154 565351 570683 576540 581349 583927 584004 589196 593843 594431 603132 604536 606561 606582 606590 617170 621990 626752 632298 635789 636579 636879 649633 651287 654274 666480 667349 670041 674131 675296 679536 681319 687639 690049 708144 716804 726311 726744 775915 776017 784321 793471 803353 818847 819024 823177 825237 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
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.