Query Metrics
7
Database Queries
7
Different statements
171.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.11 ms (86.53%) |
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 428940 542717 545612 548082 549098 549405 549561 550283 550645 550730 551221 551292 551481 552022 552176 552189 552225 553503 554019 556328 558629 560105 560384 561166 562278 564616 565040 565725 566589 566618 566830 566845 567531 567742 568188 568509 568650 569736 569772 569776 569853 570370 570416 570571 570608 570930 571049 571753 572087 573668 573824 573858 574631 575248 576121 576162 578581 579023 580676 580864 581467 582026 583420 583711 584350 585016 585444 590062 590089 590094 592136 594885 595478 596854 600105 604145 605477 618859 622023 623004 624709 626580 629540 652882 656027 656028 656373 657030 659329 660467 661414 665712 709466 712028 721317 721600 722498 725378 728260 729815 730070 730636 731278 736814 740262 746142 746978 751760 754355 754505 766542 773259 775621 790692 793982 804569 806342 807200 813925 814542 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (8.01%) |
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 766542 773259 793982 804569 725378 730636 740262 729815 736814 754355 731278 746978 754505 622023 624709 709466 712028 721317 722498 775621 548082 569776 570571 552176 556328 545612 552189 566845 570608 660467 665712 721600 656027 561166 585444 623004 595478 605477 618859 596854 600105 604145 807200 746142 751760 790692 806342 428940 566830 571753 578581 583711 552022 568509 661414 549098 565040 626580 594885 590089 730070 728260 629540 659329 592136 590062 553503 580864 590094 585016 814542 813925 542717 549561 550645 551481 552225 554019 560384 562278 565725 570416 570930 573668 573824 574631 576162 580676 581467 583420 564616 566589 567531 569772 569853 571049 584350 549405 550283 550730 551221 551292 558629 560105 566618 567742 568188 568650 569736 570370 572087 573858 575248 576121 579023 582026 652882 656028 656373 657030 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.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 428940 542717 545612 548082 549098 549405 549561 550283 550645 550730 551221 551292 551481 552022 552176 552189 552225 553503 554019 556328 558629 560105 560384 561166 562278 564616 565040 565725 566589 566618 566830 566845 567531 567742 568188 568509 568650 569736 569772 569776 569853 570370 570416 570571 570608 570930 571049 571753 572087 573668 573824 573858 574631 575248 576121 576162 578581 579023 580676 580864 581467 582026 583420 583711 584350 585016 585444 590062 590089 590094 592136 594885 595478 596854 600105 604145 605477 618859 622023 623004 624709 626580 629540 652882 656027 656028 656373 657030 659329 660467 661414 665712 709466 712028 721317 721600 722498 725378 728260 729815 730070 730636 731278 736814 740262 746142 746978 751760 754355 754505 766542 773259 775621 790692 793982 804569 806342 807200 813925 814542 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair ass"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair жоп"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair жоп"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.90%) |
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.