Query Metrics
7
Database Queries
7
Different statements
196.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.59 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.79 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs mom"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.27 ms |
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 818483 818506 821493 822262 823618 823690 824376 825764 514795 537698 537874 495384 529895 534686 557444 566682 568241 568691 574182 543934 570829 580900 540972 543995 544970 558110 568242 646865 650431 687127 700288 702973 714384 717961 652268 694195 710350 712026 720528 673793 692405 696165 699654 716191 548040 549967 561486 563908 571184 604867 622695 639683 596853 598390 638278 598556 603733 624153 626563 629796 629846 630281 643111 593204 610308 618377 630178 774773 776775 778678 788478 790731 797298 798733 799105 799147 802095 802235 802468 802698 803169 804616 806837 807437 811986 813451 775569 781488 784653 789706 789720 789752 793643 798047 801887 803025 803710 804302 805337 807178 811094 811336 813475 733366 742918 752195 759445 766514 769223 769908 774116 786466 787362 788152 788401 790156 792534 796841 797913 800409 ] |
||||||||||||||||||||||||||||||
| 4 | 3.13 ms |
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 495384 514795 529895 534686 537698 537874 540972 543934 543995 544970 548040 549967 557444 558110 561486 563908 566682 568241 568242 568691 570829 571184 574182 580900 593204 596853 598390 598556 603733 604867 610308 618377 622695 624153 626563 629796 629846 630178 630281 638278 639683 643111 646865 650431 652268 673793 687127 692405 694195 696165 699654 700288 702973 710350 712026 714384 716191 717961 720528 733366 742918 752195 759445 766514 769223 769908 774116 774773 775569 776775 778678 781488 784653 786466 787362 788152 788401 788478 789706 789720 789752 790156 790731 792534 793643 796841 797298 797913 798047 798733 799105 799147 800409 801887 802095 802235 802468 802698 803025 803169 803710 804302 804616 805337 806837 807178 807437 811094 811336 811986 813451 813475 818483 818506 821493 822262 823618 823690 824376 825764 ] |
||||||||||||||||||||||||||||||
| 5 | 174.94 ms |
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 495384 514795 529895 534686 537698 537874 540972 543934 543995 544970 548040 549967 557444 558110 561486 563908 566682 568241 568242 568691 570829 571184 574182 580900 593204 596853 598390 598556 603733 604867 610308 618377 622695 624153 626563 629796 629846 630178 630281 638278 639683 643111 646865 650431 652268 673793 687127 692405 694195 696165 699654 700288 702973 710350 712026 714384 716191 717961 720528 733366 742918 752195 759445 766514 769223 769908 774116 774773 775569 776775 778678 781488 784653 786466 787362 788152 788401 788478 789706 789720 789752 790156 790731 792534 793643 796841 797298 797913 798047 798733 799105 799147 800409 801887 802095 802235 802468 802698 803025 803169 803710 804302 804616 805337 806837 807178 807437 811094 811336 811986 813451 813475 818483 818506 821493 822262 823618 823690 824376 825764 ] |
||||||||||||||||||||||||||||||
| 6 | 2.13 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.79 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs mom"
]
|
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.