Query Metrics
7
Database Queries
7
Different statements
183.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.98 ms (90.12%) |
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 73413 116626 185264 185437 185458 185601 205205 357806 357845 382436 382449 383906 384814 387487 389114 390175 390219 390224 390698 400435 401361 402602 402607 406235 408150 410026 413943 420341 435688 435701 436257 441183 441742 446969 448945 453859 493219 494392 500689 503811 516032 531036 541411 551333 560102 574158 578424 583110 584726 597259 600596 607286 608071 610185 614552 623950 625915 636032 636515 643505 643784 644491 644518 647643 651941 653241 654065 661398 661729 662668 662711 662757 662978 662982 663061 663695 666331 667306 669481 670133 676976 677376 682482 685612 687138 698747 709583 713404 716346 724712 724929 726716 733900 735417 738897 741256 744467 744468 748752 758812 759045 759772 768115 773090 776257 782408 784270 786559 792838 792931 793489 799316 801854 802446 804084 805398 810031 811760 813951 826902 ] |
||||||||||||||||||||||||||||||
|
9.73 ms (5.32%) |
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 383906 713404 661398 776257 786559 644491 116626 811760 390224 574158 643505 793489 744467 726716 205205 448945 185601 654065 662711 709583 669481 614552 792931 801854 792838 738897 759045 773090 441183 357806 185458 387487 560102 647643 666331 676976 389114 390175 551333 663061 667306 636515 643784 185264 384814 813951 662978 357845 644518 578424 744468 733900 748752 784270 390219 410026 636032 805398 782408 185437 382449 661729 662757 662982 663695 698747 662668 670133 682482 799316 802446 804084 402602 541411 610185 584726 503811 500689 73413 390698 435701 597259 625915 401361 406235 435688 446969 516032 382436 408150 453859 531036 651941 653241 685612 687138 716346 677376 583110 600596 607286 623950 724929 741256 759772 735417 724712 758812 413943 493219 400435 420341 494392 441742 826902 402607 436257 768115 608071 810031 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.21%) |
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 73413 116626 185264 185437 185458 185601 205205 357806 357845 382436 382449 383906 384814 387487 389114 390175 390219 390224 390698 400435 401361 402602 402607 406235 408150 410026 413943 420341 435688 435701 436257 441183 441742 446969 448945 453859 493219 494392 500689 503811 516032 531036 541411 551333 560102 574158 578424 583110 584726 597259 600596 607286 608071 610185 614552 623950 625915 636032 636515 643505 643784 644491 644518 647643 651941 653241 654065 661398 661729 662668 662711 662757 662978 662982 663061 663695 666331 667306 669481 670133 676976 677376 682482 685612 687138 698747 709583 713404 716346 724712 724929 726716 733900 735417 738897 741256 744467 744468 748752 758812 759045 759772 768115 773090 776257 782408 784270 786559 792838 792931 793489 799316 801854 802446 804084 805398 810031 811760 813951 826902 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits massage"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.74%) |
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.