Query Metrics
7
Database Queries
7
Different statements
184.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.70 ms (86.72%) |
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 77381 381995 386283 389793 393151 398262 400534 433057 464166 474319 491621 521712 529689 532517 536192 545101 547705 628615 629123 644819 681773 692704 697994 698811 714141 714361 717085 717126 718025 723701 723998 724567 724842 725201 726444 727914 728148 728893 728951 729050 731186 733158 734421 734491 734657 736739 738543 739585 740541 743070 744724 747251 748693 749615 752846 757712 757887 758759 758808 758996 761259 761394 762654 762655 764695 765420 765802 766329 766934 766964 767716 768081 768328 769913 772371 772872 779442 786996 789547 790092 792327 793155 794268 794570 794584 794586 797258 797714 797723 798747 798812 800039 800173 801207 801501 801932 802179 802265 802272 803439 803922 803943 804857 805561 808258 809869 810394 812441 819454 824079 824081 824093 824799 825433 825826 826745 827433 828008 828765 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (7.75%) |
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 797258 797723 801501 803439 809869 810394 812441 723701 725201 734657 740541 749615 757887 758996 761394 766964 767890 768081 769913 772371 792327 800039 800173 801207 804857 726444 727914 728148 728951 729050 734421 734491 736739 761259 764695 768328 724567 728893 731186 733158 743070 744724 747251 758759 765802 766329 738543 739585 752846 762654 762655 765420 766934 767716 772872 629123 697994 698811 714141 714361 717085 779442 789547 790092 793155 794586 797714 798747 798812 803922 805561 389793 433057 381995 77381 824079 681773 692704 718025 628615 758808 794570 757712 748693 724842 794584 802272 717126 801932 802179 802265 723998 786996 803943 794268 808258 386283 393151 398262 400534 644819 825826 819454 825433 826745 824081 824093 824799 828765 828008 827433 464166 474319 491621 532517 521712 529689 536192 547705 545101 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.55%) |
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 77381 381995 386283 389793 393151 398262 400534 433057 464166 474319 491621 521712 529689 532517 536192 545101 547705 628615 629123 644819 681773 692704 697994 698811 714141 714361 717085 717126 718025 723701 723998 724567 724842 725201 726444 727914 728148 728893 728951 729050 731186 733158 734421 734491 734657 736739 738543 739585 740541 743070 744724 747251 748693 749615 752846 757712 757887 758759 758808 758996 761259 761394 762654 762655 764695 765420 765802 766329 766934 766964 767716 768081 768328 769913 772371 772872 779442 786996 789547 790092 792327 793155 794268 794570 794584 794586 797258 797714 797723 798747 798812 800039 800173 801207 801501 801932 802179 802265 802272 803439 803922 803943 804857 805561 808258 809869 810394 812441 819454 824079 824081 824093 824799 825433 825826 826745 827433 828008 828765 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot жен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot wife"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot жен"
]
|
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.