Query Metrics
7
Database Queries
7
Different statements
400.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.15 ms (53.01%) |
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 420405 422010 422316 493820 521082 523554 531645 533816 533820 536114 536131 538289 550564 550800 558082 573351 575636 577717 581930 583641 588542 591899 594413 595438 604141 607903 617651 621430 621600 621986 628851 636946 648512 648619 651724 654405 654430 657723 659576 660317 660345 661583 664252 665760 671546 677191 678763 678876 693425 708570 709814 713300 714692 715332 718971 719262 721217 721448 722403 722617 722666 722829 723520 724774 726608 728959 732401 736636 740749 742799 742884 746088 746355 747496 748011 748338 750769 751426 752416 753437 753441 753455 753479 754196 757188 757223 760896 762577 764406 766718 767798 767871 769768 773519 775453 775484 776782 782744 785079 785123 786498 789785 792437 795552 801574 803219 803382 805545 810168 811818 817364 817630 817699 817708 817713 818226 818322 822363 825273 ] |
||||||||||||||||||||||||||||||
|
173.27 ms (43.29%) |
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 420405 422010 422316 493820 521082 523554 531645 533816 533820 536114 536131 538289 550564 550800 558082 573351 575636 577717 581930 583641 588542 591899 594413 595438 604141 607903 617651 621430 621600 621986 628851 636946 648512 648619 651724 654405 654430 657723 659576 660317 660345 661583 664252 665760 671546 677191 678763 678876 693425 708570 709814 713300 714692 715332 718971 719262 721217 721448 722403 722617 722666 722829 723520 724774 726608 728959 732401 736636 740749 742799 742884 746088 746355 747496 748011 748338 750769 751426 752416 753437 753441 753455 753479 754196 757188 757223 760896 762577 764406 766718 767798 767871 769768 773519 775453 775484 776782 782744 785079 785123 786498 789785 792437 795552 801574 803219 803382 805545 810168 811818 817364 817630 817699 817708 817713 818226 818322 822363 825273 ] |
||||||||||||||||||||||||||||||
|
9.07 ms (2.27%) |
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 422316 420405 422010 817699 818226 818322 822363 723520 817713 817630 817708 825273 817364 493820 521082 536131 533816 533820 536114 523554 531645 538289 573351 575636 577717 581930 583641 550564 558082 648512 651724 659576 664252 677191 678876 693425 648619 661583 665760 678763 708570 709814 713300 714692 721448 722666 722829 654405 654430 657723 660317 660345 671546 715332 721217 722403 722617 550800 591899 594413 607903 621986 595438 621600 628851 588542 636946 604141 621430 775484 776782 785123 786498 792437 801574 803382 805545 775453 795552 803219 752416 753437 757188 773519 782744 785079 789785 810168 811818 728959 732401 742799 746355 747496 748338 751426 753479 736636 748011 753441 754196 757223 760896 764406 766718 769768 726608 742884 746088 750769 753455 767871 770317 724774 740749 762577 767798 617651 718971 719262 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaved teen pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бритая teen pussy"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.15 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бритая teen pussy"
]
|
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.