Query Metrics
7
Database Queries
7
Different statements
145.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.54 ms (83.42%) |
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 6863 185606 280674 383681 385316 395148 395153 395736 398037 398715 400042 401766 421057 423299 428074 433536 435420 436476 436860 443877 447070 448662 454897 456472 460715 462284 466332 466401 478721 481018 489117 489772 497374 500152 504902 507152 511095 522675 525767 539515 543879 546718 554893 558648 559867 562772 566365 571147 577887 578456 584448 585494 599139 605030 606018 608828 615625 617211 618696 618774 622361 625134 625259 648762 664318 664832 672851 674617 676924 677015 677697 679692 690649 693331 693341 695733 695790 695804 696396 697230 699197 708237 715123 720243 722686 723439 727284 728257 734794 743021 744300 745445 747226 748146 748632 754216 757027 758554 764097 765638 766838 770938 777381 777823 785932 789542 790016 792059 792507 795102 796991 798640 810954 811118 811786 814225 817612 817733 826607 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (9.62%) |
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 436860 460715 497374 814225 679692 695733 664318 690649 615625 748146 777381 507152 559867 395736 554893 817733 817612 577887 571147 770938 280674 400042 398715 695804 722686 578456 606018 625134 757027 811118 747226 708237 789542 796991 466332 383681 395153 428074 423299 456472 466401 525767 462284 584448 699197 618485 790016 795102 785932 792507 734794 743021 765638 605030 826607 566365 696396 622361 810954 728257 764097 398037 489117 511095 385316 539515 720243 754216 443877 447070 489772 558648 546718 723439 693331 695790 648762 674617 677697 608828 625259 618696 585494 727284 745445 448662 481018 500152 185606 6863 617211 543879 676924 693341 618774 792059 798640 744300 435420 504902 395148 401766 454897 522675 562772 672851 677015 697230 715123 664832 599139 811786 758554 766838 748632 777823 433536 478721 436476 421057 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.98%) |
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 6863 185606 280674 383681 385316 395148 395153 395736 398037 398715 400042 401766 421057 423299 428074 433536 435420 436476 436860 443877 447070 448662 454897 456472 460715 462284 466332 466401 478721 481018 489117 489772 497374 500152 504902 507152 511095 522675 525767 539515 543879 546718 554893 558648 559867 562772 566365 571147 577887 578456 584448 585494 599139 605030 606018 608828 615625 617211 618696 618774 622361 625134 625259 648762 664318 664832 672851 674617 676924 677015 677697 679692 690649 693331 693341 695733 695790 695804 696396 697230 699197 708237 715123 720243 722686 723439 727284 728257 734794 743021 744300 745445 747226 748146 748632 754216 757027 758554 764097 765638 766838 770938 777381 777823 785932 789542 790016 792059 792507 795102 796991 798640 810954 811118 811786 814225 817612 817733 826607 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teacher секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teacher fuck"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teacher секс"
]
|
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.