Query Metrics
7
Database Queries
7
Different statements
169.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.05 ms (86.39%) |
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 392005 392937 420013 435576 469896 471977 488277 489848 494667 499681 505763 533694 533756 537237 537852 544874 545905 546150 547761 552805 558610 575897 578323 584830 595438 595508 596796 599247 602807 605792 617017 618951 619863 620647 630037 642291 644016 647111 655545 664175 669856 669858 669868 669890 672829 683036 700830 702864 704100 704295 708131 714350 714443 714459 714484 714493 714763 722328 735958 739920 739967 740553 741520 741849 742317 742336 742337 742355 743778 744176 744772 746984 751534 751553 754638 755140 757550 758215 758245 758287 758711 760633 763874 766450 777829 778684 778686 783342 786655 786977 790691 791075 795721 796378 797359 798743 799932 800657 800682 802241 802555 803396 804831 809640 810505 811139 812287 816184 816691 818173 819959 824000 824196 824684 825795 825870 826706 827539 ] |
||||||||||||||||||||||||||||||
|
13.76 ms (8.14%) |
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 420013 435576 469896 489848 392937 816184 824196 825870 826706 818173 824684 825795 827539 819959 824000 533756 533694 537852 494667 499681 537237 575897 584830 552805 544874 547761 655545 672829 714763 647111 669856 669858 669868 669890 700830 702864 704100 704295 714350 664175 683036 708131 546150 595438 602807 619863 642291 617017 630037 595508 605792 618951 644016 778684 786655 791075 799932 778686 800657 802241 803396 810505 812287 740553 742317 742336 743778 744176 744772 758287 760633 790691 796378 797359 809640 739920 741520 759378 763874 741849 758215 758711 742337 746984 751534 754638 766450 735958 739967 742355 751553 755140 758245 763722 722328 777829 783342 786977 795721 800682 802555 804831 811139 392005 471977 505763 578323 816691 488277 558610 545905 714493 714443 714484 599247 596796 620647 798743 757550 714459 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.46%) |
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 392005 392937 420013 435576 469896 471977 488277 489848 494667 499681 505763 533694 533756 537237 537852 544874 545905 546150 547761 552805 558610 575897 578323 584830 595438 595508 596796 599247 602807 605792 617017 618951 619863 620647 630037 642291 644016 647111 655545 664175 669856 669858 669868 669890 672829 683036 700830 702864 704100 704295 708131 714350 714443 714459 714484 714493 714763 722328 735958 739920 739967 740553 741520 741849 742317 742336 742337 742355 743778 744176 744772 746984 751534 751553 754638 755140 757550 758215 758245 758287 758711 760633 763874 766450 777829 778684 778686 783342 786655 786977 790691 791075 795721 796378 797359 798743 799932 800657 800682 802241 802555 803396 804831 809640 810505 811139 812287 816184 816691 818173 819959 824000 824196 824684 825795 825870 826706 827539 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf russian"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf русск"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf русск"
]
|
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.