Query Metrics
7
Database Queries
7
Different statements
216.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.19 ms (91.13%) |
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 31822 83083 145666 186151 399540 400563 402936 449272 494863 531391 536193 539388 543427 547542 550928 552479 560495 561763 573288 577677 578301 582758 583653 624794 628040 635371 639109 665626 666142 669898 674046 676696 686491 693086 695857 701405 703571 712573 715261 733368 733670 738113 740509 740573 744125 744138 744350 745168 746789 746826 747423 750656 753024 754984 755113 757017 759061 760427 768719 768817 773176 773186 782848 785508 785649 786091 787535 790447 790544 793125 798708 804240 804457 804789 807257 809630 810328 812466 812482 816157 816161 816643 816698 816733 817053 817565 817566 817576 817584 817675 818783 819406 819409 819713 819766 819814 820000 820161 820688 823251 824552 824655 824667 824753 825408 825649 826349 826357 826466 826679 826773 827049 827093 827335 827544 828472 828723 828725 ] |
||||||||||||||||||||||||||||||
|
9.45 ms (4.37%) |
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 744138 746789 773186 740509 635371 810328 31822 550928 703571 712573 695857 145666 826679 818783 827335 820161 824655 828725 828472 531391 665626 624794 628040 793125 812482 804240 759061 754984 760427 744125 745168 755113 798708 812466 817053 825649 819814 816157 817576 824552 819409 826466 828723 449272 543427 547542 577677 674046 582758 790544 782848 804457 750656 785508 744350 768817 753024 733368 738113 773176 399540 785649 786091 809630 740573 768719 790447 186151 816161 494863 583653 715261 639109 807257 787535 747423 757017 733670 746826 804789 402936 83083 578301 400563 816698 817565 817675 820688 823734 826357 816733 819406 819713 824667 825408 826773 827049 827093 827544 816643 817566 817584 820000 823251 819766 828293 824753 826349 536193 539388 552479 573288 560495 561763 669898 676696 686491 693086 666142 701405 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.54%) |
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 31822 83083 145666 186151 399540 400563 402936 449272 494863 531391 536193 539388 543427 547542 550928 552479 560495 561763 573288 577677 578301 582758 583653 624794 628040 635371 639109 665626 666142 669898 674046 676696 686491 693086 695857 701405 703571 712573 715261 733368 733670 738113 740509 740573 744125 744138 744350 745168 746789 746826 747423 750656 753024 754984 755113 757017 759061 760427 768719 768817 773176 773186 782848 785508 785649 786091 787535 790447 790544 793125 798708 804240 804457 804789 807257 809630 810328 812466 812482 816157 816161 816643 816698 816733 817053 817565 817566 817576 817584 817675 818783 819406 819409 819713 819766 819814 820000 820161 820688 823251 824552 824655 824667 824753 825408 825649 826349 826357 826466 826679 826773 827049 827093 827335 827544 828472 828723 828725 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation and orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац orgasm"
]
|
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.