Query Metrics
7
Database Queries
7
Different statements
180.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.06 ms (86.56%) |
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 1117 314397 381735 385892 388630 395388 398009 407159 412880 420001 420425 422110 434539 452996 458127 459771 482569 499621 512390 531340 534580 538822 542967 546434 551585 580512 584664 600098 601705 609675 626267 626800 635117 635755 636143 636835 649561 663098 666391 669890 675509 677347 692734 692829 694130 703445 715981 716603 716648 718530 719113 720217 720221 724014 724560 730382 730482 734461 734705 736407 739258 739437 739989 742084 742126 742567 742592 743439 748876 748921 756055 756295 757804 760787 761546 762443 763502 764790 767555 767836 769556 771343 771359 772280 773363 775168 775625 778079 778741 779339 779548 779729 779814 779845 779966 780022 780770 781361 781602 787040 787156 790268 790618 790771 790997 791217 791585 791825 792659 792717 793347 795055 796051 796556 797507 811462 819000 824972 825759 827189 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (7.64%) |
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 795055 395388 538822 694130 720217 635755 775168 790268 797507 767555 743439 763502 739258 790771 791825 792717 385892 420425 819000 730482 742126 407159 825759 542967 584664 692734 779966 792659 760787 742084 767836 762443 742567 742592 420001 499621 796556 720221 636143 779339 748921 724560 716648 663098 434539 452996 531340 546434 719113 649561 580512 626800 636835 790618 791217 778079 779814 779845 791585 757804 739437 736407 771343 703445 718530 398009 459771 512390 692829 551585 600098 635117 779729 739989 748876 764790 769556 771359 626267 787040 787156 790997 412880 422110 482569 534580 669890 609675 780770 796051 793347 724014 756055 756295 761546 314397 1117 781602 781361 772280 778741 715981 601705 775625 779548 381735 388630 827189 824972 458127 675509 677347 716603 666391 780022 734461 734705 773363 811462 730382 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.41%) |
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 1117 314397 381735 385892 388630 395388 398009 407159 412880 420001 420425 422110 434539 452996 458127 459771 482569 499621 512390 531340 534580 538822 542967 546434 551585 580512 584664 600098 601705 609675 626267 626800 635117 635755 636143 636835 649561 663098 666391 669890 675509 677347 692734 692829 694130 703445 715981 716603 716648 718530 719113 720217 720221 724014 724560 730382 730482 734461 734705 736407 739258 739437 739989 742084 742126 742567 742592 743439 748876 748921 756055 756295 757804 760787 761546 762443 763502 764790 767555 767836 769556 771343 771359 772280 773363 775168 775625 778079 778741 779339 779548 779729 779814 779845 779966 780022 780770 781361 781602 787040 787156 790268 790618 790771 790997 791217 791585 791825 792659 792717 793347 795055 796051 796556 797507 811462 819000 824972 825759 827189 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex oral"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс oral"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс oral"
]
|
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.