Query Metrics
7
Database Queries
7
Different statements
216.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.56 ms (90.93%) |
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 334950 392984 404451 410807 430542 431504 446948 460176 465471 490665 537162 539607 546263 548394 556001 578166 584048 593043 597910 615604 617578 623912 625208 631451 635133 636405 648183 654955 661049 667834 668374 668761 669867 670770 679674 681288 687691 694568 695715 707504 708828 719173 723998 724659 726376 726725 726908 727554 727987 728958 729259 732837 734344 734404 734664 735544 744834 746709 747251 748076 748118 748876 748990 754153 755221 756253 756318 757525 760262 760619 767462 768105 771426 774759 776879 779202 784307 784357 789174 790833 792258 792556 792825 794000 794194 794291 794413 795374 795805 796456 796535 798677 800009 800056 801343 801859 802368 802520 802523 802769 803718 804233 804348 804400 804463 804738 805123 807171 809781 814578 817355 817527 817872 819149 819225 820131 825936 826017 828414 828689 ] |
||||||||||||||||||||||||||||||
|
10.61 ms (4.91%) |
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 578166 654955 695715 648183 668374 667834 668761 679674 719173 597910 615604 617578 636405 774759 794194 794291 794413 795374 802520 792258 796456 802523 804233 804463 804738 809781 723998 726725 734664 748876 748990 760262 784357 790833 792556 792825 800009 802769 803718 728958 732837 734344 744834 748076 756253 767462 726376 734404 746709 756318 729259 735544 748118 757525 768105 771426 625208 631451 794000 801343 802368 804400 807171 392984 661049 776879 556001 828414 828689 548394 334950 404451 431504 465471 539607 460176 490665 681288 593043 760619 727554 784307 798677 410807 446948 430542 537162 546263 817872 819225 825936 826017 819149 820131 817527 814578 817355 707504 670770 708828 669867 687691 694568 584048 623912 635133 779202 789174 795805 801859 805123 754153 796535 800056 804348 755221 724659 726908 727987 747251 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.16%) |
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 334950 392984 404451 410807 430542 431504 446948 460176 465471 490665 537162 539607 546263 548394 556001 578166 584048 593043 597910 615604 617578 623912 625208 631451 635133 636405 648183 654955 661049 667834 668374 668761 669867 670770 679674 681288 687691 694568 695715 707504 708828 719173 723998 724659 726376 726725 726908 727554 727987 728958 729259 732837 734344 734404 734664 735544 744834 746709 747251 748076 748118 748876 748990 754153 755221 756253 756318 757525 760262 760619 767462 768105 771426 774759 776879 779202 784307 784357 789174 790833 792258 792556 792825 794000 794194 794291 794413 795374 795805 796456 796535 798677 800009 800056 801343 801859 802368 802520 802523 802769 803718 804233 804348 804400 804463 804738 805123 807171 809781 814578 817355 817527 817872 819149 819225 820131 825936 826017 828414 828689 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf pussy"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf 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.