Query Metrics
7
Database Queries
7
Different statements
196.24 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.29 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.39 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens solo masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.47 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 750351 750632 751625 752805 753599 755045 767908 773597 774185 733670 743192 743246 751741 759833 768481 731367 746826 755287 757193 764743 767724 774099 601716 614297 633434 637902 701854 791884 794937 802259 803976 807026 414241 414749 323899 401413 388410 412164 571778 777774 765479 455709 398277 816841 816866 821343 816719 827227 827293 827335 827700 820984 821221 824858 825029 821034 824655 531737 528943 530239 535995 538286 471904 575629 576584 715288 656856 664526 696586 626818 628040 603746 643118 621502 638471 642666 788027 793125 810486 812482 785216 793244 749053 753994 755886 757056 760570 774055 774096 788475 796362 807205 748313 753574 753658 754984 738513 741224 743148 753604 754400 754478 754530 754979 755251 760427 760587 761206 774113 744125 748268 751436 753643 754529 756512 768430 738100 758324 708639 790758 ] |
||||||||||||||||||||||||||||||
| 4 | 3.14 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 323899 388410 398277 401413 412164 414241 414749 455709 471904 528943 530239 531737 535995 538286 571778 575629 576584 601716 603746 614297 621502 626818 628040 633434 637902 638471 642666 643118 656856 664526 696586 701854 708639 715288 731367 733670 738100 738513 741224 743148 743192 743246 744125 746826 748268 748313 749053 750351 750632 751436 751625 751741 752805 753574 753599 753604 753643 753658 753994 754400 754478 754529 754530 754979 754984 755045 755251 755287 755886 756512 757056 757193 758324 759833 760427 760570 760587 761206 764743 765479 767724 767908 768430 768481 773597 774055 774096 774099 774113 774185 777774 785216 788027 788475 790758 791884 793125 793244 794937 796362 802259 803976 807026 807205 810486 812482 816719 816841 816866 820984 821034 821221 821343 824655 824858 825029 827227 827293 827335 827700 ] |
||||||||||||||||||||||||||||||
| 5 | 173.26 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 323899 388410 398277 401413 412164 414241 414749 455709 471904 528943 530239 531737 535995 538286 571778 575629 576584 601716 603746 614297 621502 626818 628040 633434 637902 638471 642666 643118 656856 664526 696586 701854 708639 715288 731367 733670 738100 738513 741224 743148 743192 743246 744125 746826 748268 748313 749053 750351 750632 751436 751625 751741 752805 753574 753599 753604 753643 753658 753994 754400 754478 754529 754530 754979 754984 755045 755251 755287 755886 756512 757056 757193 758324 759833 760427 760570 760587 761206 764743 765479 767724 767908 768430 768481 773597 774055 774096 774099 774113 774185 777774 785216 788027 788475 790758 791884 793125 793244 794937 796362 802259 803976 807026 807205 810486 812482 816719 816841 816866 820984 821034 821221 821343 824655 824858 825029 827227 827293 827335 827700 ] |
||||||||||||||||||||||||||||||
| 6 | 1.80 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens соло мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.90 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens соло мастурбац"
]
|
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.