Query Metrics
7
Database Queries
7
Different statements
167.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.83 ms (80.91%) |
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 25053 410163 415992 416511 416515 416675 416725 418530 437859 441021 441495 449173 451316 451775 461610 463855 506119 535006 536251 536262 546253 548965 549550 561678 583175 584295 598053 599046 599364 604652 607755 610905 613518 616245 619590 623130 628574 629440 630039 637257 643146 644041 674959 684855 693084 693529 698421 702980 705210 715694 716042 719074 720278 722284 722560 724118 724130 725608 728518 729105 731234 734346 734818 734922 736356 737052 740454 742916 743172 743285 744100 744225 745112 745113 745807 747633 752625 754207 756830 760888 765424 767294 768353 769098 770306 773912 773916 775565 776233 779223 779241 779302 780403 783180 783275 783718 785097 786259 788351 788786 790637 792668 792671 793196 795425 796226 796532 797810 797942 799700 799992 800521 801833 802146 803133 805665 806046 807642 809314 812235 ] |
||||||||||||||||||||||||||||||
|
20.85 ms (12.42%) |
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 720278 722284 722560 684855 693084 693529 705210 716042 546253 548965 549550 561678 583175 584295 598053 628574 643146 607755 599364 604652 610905 619590 637257 599046 776233 779223 779241 779302 786259 788351 793196 799992 800521 801833 803133 775565 780403 783718 790637 792671 796532 805665 806046 729105 734346 743172 744100 752625 754207 760888 765424 773916 783180 785097 792668 802146 809314 812235 731234 768353 769098 734818 734922 745113 770306 724118 724130 725608 728518 736356 742916 744225 745112 745807 767294 773912 740454 743285 747633 756830 613518 616245 623130 629440 630039 644041 698421 702980 715694 783275 788786 795425 796226 797810 797942 799700 807642 416725 415992 416515 449173 451316 719074 737052 437859 416511 416675 451775 418530 441021 461610 506119 463855 536251 535006 536262 674959 25053 410163 441495 ] |
||||||||||||||||||||||||||||||
|
3.97 ms (2.36%) |
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 25053 410163 415992 416511 416515 416675 416725 418530 437859 441021 441495 449173 451316 451775 461610 463855 506119 535006 536251 536262 546253 548965 549550 561678 583175 584295 598053 599046 599364 604652 607755 610905 613518 616245 619590 623130 628574 629440 630039 637257 643146 644041 674959 684855 693084 693529 698421 702980 705210 715694 716042 719074 720278 722284 722560 724118 724130 725608 728518 729105 731234 734346 734818 734922 736356 737052 740454 742916 743172 743285 744100 744225 745112 745113 745807 747633 752625 754207 756830 760888 765424 767294 768353 769098 770306 773912 773916 775565 776233 779223 779241 779302 780403 783180 783275 783718 785097 786259 788351 788786 790637 792668 792671 793196 795425 796226 796532 797810 797942 799700 799992 800521 801833 802146 803133 805665 806046 807642 809314 812235 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole teen"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк teen"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дырк teen"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.