Query Metrics
7
Database Queries
7
Different statements
176.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.16 ms (87.80%) |
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 20051 50408 65834 82143 263548 298293 382294 383659 387303 392864 417218 422140 427803 437568 440761 445717 445763 445768 449281 449297 500519 510912 513831 513851 517360 519846 521342 527469 527475 527482 533549 536096 538726 553436 558264 559414 559736 562605 576499 581195 581542 613943 617571 618547 622568 640899 643146 643886 647211 669655 684843 684855 684888 684891 685758 697759 706024 709679 709694 712967 728568 734537 736056 739939 740509 742652 742914 743985 744138 746789 746967 747594 751016 751018 752573 754171 754391 757518 758450 768458 774065 774484 780331 785090 790443 790447 790551 795921 796405 801816 802864 804185 807060 807648 809630 810328 811252 812263 819105 819278 824320 824526 824811 824868 824955 825901 825919 826352 826569 827030 828019 828195 828207 828242 828503 828505 828838 ] |
||||||||||||||||||||||||||||||
|
12.08 ms (6.84%) |
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 757518 618547 706024 709679 780331 802864 82143 263548 383659 437568 445768 825901 827030 826352 828195 828242 828503 538726 819105 533549 736056 768458 751016 440761 449281 685758 559736 513831 521342 510912 517360 553436 558264 581542 669655 684888 684891 697759 712967 684843 684855 643146 622568 613943 617571 640899 801816 807648 728568 742652 743985 785090 790443 809630 734537 746967 742914 790447 795921 20051 824526 824650 822319 826569 828019 828207 828838 828505 562605 739939 754391 65834 392864 382294 387303 824811 819278 826566 825919 709694 647211 559414 774484 796405 744138 758450 790551 807060 812263 751018 754171 746789 740509 747594 752573 774065 643886 804185 810328 811252 298293 50408 417218 422140 427803 824320 824868 824955 449297 445717 445763 519846 500519 527469 527475 536096 513851 527482 576499 581195 ] |
||||||||||||||||||||||||||||||
|
2.50 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 20051 50408 65834 82143 263548 298293 382294 383659 387303 392864 417218 422140 427803 437568 440761 445717 445763 445768 449281 449297 500519 510912 513831 513851 517360 519846 521342 527469 527475 527482 533549 536096 538726 553436 558264 559414 559736 562605 576499 581195 581542 613943 617571 618547 622568 640899 643146 643886 647211 669655 684843 684855 684888 684891 685758 697759 706024 709679 709694 712967 728568 734537 736056 739939 740509 742652 742914 743985 744138 746789 746967 747594 751016 751018 752573 754171 754391 757518 758450 768458 774065 774484 780331 785090 790443 790447 790551 795921 796405 801816 802864 804185 807060 807648 809630 810328 811252 812263 819105 819278 824320 824526 824811 824868 824955 825901 825919 826352 826569 827030 828019 828195 828207 828242 828503 828505 828838 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation pussy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац pussy"
]
|
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.