Query Metrics
7
Database Queries
7
Different statements
141.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.95 ms (84.61%) |
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 47128 382844 383096 384498 388118 390197 390284 394335 394582 401326 408581 522920 526232 530624 543843 546888 558348 559316 567836 571451 573172 599826 601304 606828 612042 614747 615596 616016 617422 618739 632284 649948 655648 655755 657931 659547 659623 662838 664487 684302 684367 685675 686938 687971 698120 702151 702281 704887 706508 709495 717650 718895 719397 719813 719947 720378 722854 723249 726641 731097 731398 736003 736139 736286 739514 740741 741271 742467 744343 744740 744758 745520 751762 754258 755412 755671 757077 759544 760388 762359 763368 763776 764081 768187 768444 771690 771757 772588 777132 778547 779252 779763 780022 781070 783579 783637 783802 786514 786602 789427 790138 791586 792498 793989 794476 795500 799612 800251 805939 808099 810651 812207 813614 813897 814307 819792 820829 821140 821784 822427 ] |
||||||||||||||||||||||||||||||
|
11.39 ms (8.04%) |
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 632284 779763 543843 819792 800251 786514 755412 763368 530624 772588 526232 698120 558348 822427 821140 717650 685675 616016 779252 783802 731398 744343 754258 790138 812207 614747 686938 390197 617422 599826 612042 615596 820829 546888 684302 723249 655648 655755 659547 649948 794476 789427 792498 805939 739514 741271 808099 755671 771690 702281 719947 394335 722854 795500 813897 571451 559316 573172 702151 684367 704887 745520 751762 744758 719397 786602 810651 601304 813614 719813 383096 394582 778547 763776 814307 388118 793989 760388 799612 762359 768187 781070 759544 47128 522920 780022 736286 768444 791586 382844 706508 718895 567836 606828 736003 740741 764081 742467 757077 709495 783637 384498 390284 408581 659623 618739 777132 783579 731097 736139 401326 726641 744740 720378 771757 821784 657931 662838 664487 687971 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.22%) |
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 47128 382844 383096 384498 388118 390197 390284 394335 394582 401326 408581 522920 526232 530624 543843 546888 558348 559316 567836 571451 573172 599826 601304 606828 612042 614747 615596 616016 617422 618739 632284 649948 655648 655755 657931 659547 659623 662838 664487 684302 684367 685675 686938 687971 698120 702151 702281 704887 706508 709495 717650 718895 719397 719813 719947 720378 722854 723249 726641 731097 731398 736003 736139 736286 739514 740741 741271 742467 744343 744740 744758 745520 751762 754258 755412 755671 757077 759544 760388 762359 763368 763776 764081 768187 768444 771690 771757 772588 777132 778547 779252 779763 780022 781070 783579 783637 783802 786514 786602 789427 790138 791586 792498 793989 794476 795500 799612 800251 805939 808099 810651 812207 813614 813897 814307 819792 820829 821140 821784 822427 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sweet blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.11%) |
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.