Query Metrics
7
Database Queries
7
Different statements
150.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.87 ms (82.41%) |
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 6626 6840 126458 236472 373897 391478 396215 396753 397436 404113 409820 486044 487973 505459 535618 536245 544186 551556 576145 576524 597553 597995 598036 599530 605798 619187 621451 625745 636238 652206 652874 652911 652955 654346 655281 656488 661673 662194 665865 670048 671252 673459 677181 677344 678981 685471 692040 699899 702150 713335 716559 718656 718681 720087 720798 721338 721429 722538 722701 722719 723178 724773 725609 727643 727770 734973 735462 735866 741529 742239 744907 744976 746802 746894 747142 747154 747407 747452 748701 753453 753469 753473 753478 754180 755727 755731 757784 758963 761677 762183 762225 766622 766798 766801 766868 769749 769750 769755 769772 769778 769802 769809 769860 769868 777083 782527 783194 783609 786762 791365 799837 799995 800423 804317 804871 807519 810125 811629 814134 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (9.80%) |
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 536245 505459 713335 722538 605798 799995 807519 769750 769772 769755 769778 769809 769860 769749 487973 486044 535618 544186 678981 576145 597553 597995 783609 791945 762225 747407 718656 396215 397436 404113 409820 6840 236472 6626 126458 396753 373897 391478 814134 551556 656488 661673 665865 670048 673459 685471 699899 720087 720798 721338 721429 652911 652955 662194 671252 692040 702150 716559 718681 722701 722719 652206 652874 654346 655281 677181 677344 723178 576524 598036 625745 619187 636238 599530 621451 791365 811629 777083 782527 804317 725609 746802 746894 747142 747452 753469 754180 755731 761677 766798 769802 783194 786762 799837 800423 804871 810125 724773 735866 741529 744907 753453 753473 753478 757784 766801 766868 769868 727643 734973 735462 742239 744976 747154 748701 755727 758963 762183 766622 727770 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.29%) |
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 6626 6840 126458 236472 373897 391478 396215 396753 397436 404113 409820 486044 487973 505459 535618 536245 544186 551556 576145 576524 597553 597995 598036 599530 605798 619187 621451 625745 636238 652206 652874 652911 652955 654346 655281 656488 661673 662194 665865 670048 671252 673459 677181 677344 678981 685471 692040 699899 702150 713335 716559 718656 718681 720087 720798 721338 721429 722538 722701 722719 723178 724773 725609 727643 727770 734973 735462 735866 741529 742239 744907 744976 746802 746894 747142 747154 747407 747452 748701 753453 753469 753473 753478 754180 755727 755731 757784 758963 761677 762183 762225 766622 766798 766801 766868 769749 769750 769755 769772 769778 769802 769809 769860 769868 777083 782527 783194 783609 786762 791365 799837 799995 800423 804317 804871 807519 810125 811629 814134 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"уговорил русскую в попу"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.25%) |
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.