Query Metrics
7
Database Queries
7
Different statements
164.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.54 ms (86.17%) |
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 38028 102441 116701 272566 338338 339415 382061 392434 392956 494622 501656 519189 531144 531319 532085 538032 538526 538804 539576 540294 540519 542558 547369 549276 556154 562593 566300 577196 583847 599912 601600 602979 604172 604174 604523 605032 612296 614426 615142 615989 616667 616672 619488 624175 627809 632618 632979 633758 635487 637121 638421 639117 641391 642041 642043 642691 644684 646230 648817 649078 650509 651012 652693 653818 654650 655113 656384 657491 668150 678128 680877 681363 688551 690939 704740 705790 709845 716887 725308 729185 729885 732564 732568 732638 733208 733580 740772 741189 745452 748065 748555 778059 788995 789327 803867 804505 816031 818494 819757 820149 820917 821727 821729 821905 822471 822578 822728 822922 823837 824209 824624 824775 825914 826120 828104 828115 828216 828600 828871 ] |
||||||||||||||||||||||||||||||
|
12.27 ms (7.47%) |
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 531144 540294 494622 648817 678128 627809 635487 637121 601600 604172 642691 632618 632979 599912 624175 642041 604523 633758 642043 716887 272566 825914 820917 821905 822656 816031 822578 823837 824624 820149 828115 828871 828104 828600 501656 531319 538804 538032 562593 583847 651012 652693 649078 690939 688551 705790 644684 612296 615989 602979 604174 804505 725308 732638 748065 732568 605032 709845 788995 789327 38028 102441 116701 392434 392956 338338 339415 382061 818494 821729 822471 821727 822728 822922 819757 824209 824775 826120 828216 540519 519189 532085 538526 539576 542558 577196 547369 556154 566300 646230 655113 668150 704740 653818 657491 650509 654650 656384 680877 681363 549276 615142 616667 616672 638421 619488 639117 614426 641391 803867 778059 733580 740772 741189 745452 748555 729185 729885 732564 733208 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.14%) |
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 38028 102441 116701 272566 338338 339415 382061 392434 392956 494622 501656 519189 531144 531319 532085 538032 538526 538804 539576 540294 540519 542558 547369 549276 556154 562593 566300 577196 583847 599912 601600 602979 604172 604174 604523 605032 612296 614426 615142 615989 616667 616672 619488 624175 627809 632618 632979 633758 635487 637121 638421 639117 641391 642041 642043 642691 644684 646230 648817 649078 650509 651012 652693 653818 654650 655113 656384 657491 668150 678128 680877 681363 688551 690939 704740 705790 709845 716887 725308 729185 729885 732564 732568 732638 733208 733580 740772 741189 745452 748065 748555 778059 788995 789327 803867 804505 816031 818494 819757 820149 820917 821727 821729 821905 822471 822578 822728 822922 823837 824209 824624 824775 825914 826120 828104 828115 828216 828600 828871 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial xxx"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов xxx"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"межрасов xxx"
]
|
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.