Query Metrics
7
Database Queries
7
Different statements
142.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.27 ms (84.20%) |
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 121824 385238 386147 391114 398213 401195 411150 414236 426639 437926 527914 530974 530981 531017 531793 535519 536189 536769 537158 540283 540584 546368 546402 546413 546740 547542 552111 552554 554092 554959 557283 570849 571204 576610 592803 605135 607305 630988 646819 663719 692041 695476 695814 697339 706582 708090 713477 716393 717279 729089 735672 736070 737801 738123 738248 746308 746817 749069 751387 752429 752494 752562 752573 753014 753662 753714 754250 754313 754564 754682 754708 754717 755009 755098 755284 756372 758060 760662 763467 765874 768436 768817 768901 769336 773159 774189 774198 776736 777150 777705 778557 779373 783286 783393 786809 788110 790227 790275 790434 790641 791549 793105 798753 802921 811512 812211 813724 816848 816859 818205 819088 821517 822916 823321 823894 824888 824928 825406 825626 826234 ] |
||||||||||||||||||||||||||||||
|
12.04 ms (8.43%) |
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 547542 546413 716393 717279 708090 783286 738248 756372 768817 753714 765874 385238 816859 824888 825406 816848 823894 824928 818205 821517 823321 825626 531793 535519 537158 530974 536189 536769 540584 576610 546402 552111 570849 571204 646819 713477 663719 692041 695814 697339 552554 554092 607305 630988 592803 783393 786809 790641 791549 811512 777705 778557 793105 737801 753014 754717 769336 774198 788110 790227 790434 736070 738123 754708 755009 755098 774189 729089 746817 752429 754250 755284 773159 753662 754564 754682 763467 749069 751387 752562 758060 760662 706582 776736 790275 411150 546368 437926 527914 813724 530981 531017 540283 554959 557283 695476 546740 605135 777150 779373 812211 735672 746308 754313 752494 768901 752573 414236 398213 426639 798753 391114 802921 768436 386147 121824 401195 822916 826234 819088 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.46%) |
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 121824 385238 386147 391114 398213 401195 411150 414236 426639 437926 527914 530974 530981 531017 531793 535519 536189 536769 537158 540283 540584 546368 546402 546413 546740 547542 552111 552554 554092 554959 557283 570849 571204 576610 592803 605135 607305 630988 646819 663719 692041 695476 695814 697339 706582 708090 713477 716393 717279 729089 735672 736070 737801 738123 738248 746308 746817 749069 751387 752429 752494 752562 752573 753014 753662 753714 754250 754313 754564 754682 754708 754717 755009 755098 755284 756372 758060 760662 763467 765874 768436 768817 768901 769336 773159 774189 774198 776736 777150 777705 778557 779373 783286 783393 786809 788110 790227 790275 790434 790641 791549 793105 798753 802921 811512 812211 813724 816848 816859 818205 819088 821517 822916 823321 823894 824888 824928 825406 825626 826234 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls solo"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк соло"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.