Query Metrics
7
Database Queries
7
Different statements
191.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.46 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 117844 187819 281927 309283 311237 313978 385909 388891 390693 391950 395978 395999 396743 397296 399747 401100 416969 425887 435213 443491 468690 469715 472446 476231 476476 487724 499182 514139 519034 522949 531236 535185 542588 544421 552688 560643 585798 592428 592867 594558 600418 604148 604668 611930 612188 617807 621712 634522 634774 636284 642659 650373 650969 654384 660716 662065 671461 676944 677971 679387 680278 684516 692331 693859 697774 702033 703433 710051 714567 715524 717320 719022 720195 720278 721312 739050 740791 742272 743029 743044 747389 747498 749121 749343 753481 759639 760609 760931 762917 769743 769747 769752 769769 769793 769839 769863 773642 777124 782511 783145 785324 788133 788550 793297 799882 800515 803092 804638 805315 805665 807510 817211 817536 818867 821238 823466 824184 824487 825038 826941 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (7.73%) |
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 740791 747498 753481 773642 611930 617807 697774 714567 721312 777124 782511 783145 395978 187819 396743 499182 531236 542588 679387 585798 759639 621712 435213 476476 469715 634774 552688 604668 600418 788133 804638 807510 388891 390693 416969 476231 472446 487724 560643 662065 769793 769747 769769 769839 769863 769743 769752 397296 468690 309283 401100 519034 636284 443491 522949 385909 117844 818867 823466 514139 544421 650373 660716 719022 671461 684516 702033 604148 612188 634522 642659 785324 800515 788550 760931 742272 743044 760609 762917 749343 703433 720195 803092 391950 425887 311237 395999 399747 281927 313978 824184 817211 826941 817536 821238 824487 825038 535185 650969 680278 693859 715524 654384 717320 720278 676944 677971 692331 710051 592867 592428 594558 793297 805315 799882 805665 739050 743029 747389 749121 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.34%) |
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 117844 187819 281927 309283 311237 313978 385909 388891 390693 391950 395978 395999 396743 397296 399747 401100 416969 425887 435213 443491 468690 469715 472446 476231 476476 487724 499182 514139 519034 522949 531236 535185 542588 544421 552688 560643 585798 592428 592867 594558 600418 604148 604668 611930 612188 617807 621712 634522 634774 636284 642659 650373 650969 654384 660716 662065 671461 676944 677971 679387 680278 684516 692331 693859 697774 702033 703433 710051 714567 715524 717320 719022 720195 720278 721312 739050 740791 742272 743029 743044 747389 747498 749121 749343 753481 759639 760609 760931 762917 769743 769747 769752 769769 769793 769839 769863 773642 777124 782511 783145 785324 788133 788550 793297 799882 800515 803092 804638 805315 805665 807510 817211 817536 818867 821238 823466 824184 824487 825038 826941 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy with anal"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy анал"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.65%) |
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.