Query Metrics
7
Database Queries
7
Different statements
157.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.21 ms (82.55%) |
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 3973 34087 61168 96118 96530 123955 221923 326081 382792 382929 391075 395862 396989 406621 427515 435645 464343 475812 477471 488560 492697 500551 500617 506544 510426 511011 514719 517184 519242 530140 539533 544702 546679 552034 557937 557944 560368 577437 586737 590631 592449 598833 600188 604555 607113 613381 622005 622110 622121 622201 639726 640697 645493 645999 648984 649127 650835 651888 651889 653589 653712 654268 654471 654505 657252 659287 663946 664796 665406 665624 668416 670488 671747 672492 675906 681682 692457 693164 693765 699630 703055 708094 710544 713474 716017 717313 720673 721184 731431 731784 732060 732377 737618 739052 739606 743644 746082 746533 748664 762707 770268 775998 778372 780688 784442 788791 790060 790654 792511 797164 808873 809779 817518 817748 818447 820152 823282 825202 826217 826230 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (10.46%) |
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 693164 670488 681682 671747 790654 61168 396989 640697 3973 817748 818447 653712 692457 645493 648984 649127 663946 665406 622201 784442 797164 826217 654268 654471 650835 654505 668416 546679 780688 743644 713474 778372 34087 825202 530140 665624 808873 586737 96530 406621 826230 716017 792511 395862 645999 560368 577437 590631 510426 500551 622110 427515 475812 672492 731431 488560 506544 653589 703055 613381 790060 746533 770268 788791 519242 604555 391075 732060 731784 748664 464343 492697 477471 123955 817518 435645 511011 557937 557944 539533 664796 552034 739052 699630 720673 326081 607113 651888 651889 622005 746082 708094 500617 823282 598833 514719 657252 659287 717313 622121 809779 739606 762707 732377 710544 639726 693765 675906 517184 382792 820152 544702 592449 600188 775998 737618 721184 221923 382929 96118 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.00%) |
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 3973 34087 61168 96118 96530 123955 221923 326081 382792 382929 391075 395862 396989 406621 427515 435645 464343 475812 477471 488560 492697 500551 500617 506544 510426 511011 514719 517184 519242 530140 539533 544702 546679 552034 557937 557944 560368 577437 586737 590631 592449 598833 600188 604555 607113 613381 622005 622110 622121 622201 639726 640697 645493 645999 648984 649127 650835 651888 651889 653589 653712 654268 654471 654505 657252 659287 663946 664796 665406 665624 668416 670488 671747 672492 675906 681682 692457 693164 693765 699630 703055 708094 710544 713474 716017 717313 720673 721184 731431 731784 732060 732377 737618 739052 739606 743644 746082 746533 748664 762707 770268 775998 778372 780688 784442 788791 790060 790654 792511 797164 808873 809779 817518 817748 818447 820152 823282 825202 826217 826230 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм жмж негритянки"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро жмж секс втро чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.07%) |
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.