Query Metrics
7
Database Queries
7
Different statements
366.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.14 ms (57.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
132.05 ms (36.06%) |
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 8028 37232 89199 154123 340613 383347 386877 388024 388535 395769 401809 406857 408625 411072 412152 419970 420171 420799 421600 431691 446780 450845 453002 455071 457807 459472 459833 462143 466341 466470 471074 471128 476068 476672 483315 486375 492814 495170 496345 496714 496723 498541 499922 500282 507909 509596 518200 518561 518921 520848 526244 530044 534169 543057 547944 548185 558158 564234 568635 575972 579218 579990 580225 580782 584320 584705 589400 591162 596778 599145 617585 622592 624974 641118 660818 668703 673232 683485 684678 691466 700239 714727 715291 726829 733376 733403 735998 741701 743783 749054 752371 753745 758277 759146 768144 772453 782152 782987 790193 790683 793782 794249 796779 801600 801667 801976 801977 802005 802231 802934 804486 804622 808712 808713 811644 816668 824653 825181 825610 826892 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (4.34%) |
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 793782 801976 801667 802231 782152 782987 753745 758277 483315 589400 543057 660818 673232 684678 624974 617585 772453 749054 804486 496345 520848 568635 383347 492814 395769 476672 476068 500282 599145 340613 462143 421600 453002 526244 668703 691466 591162 801977 804622 802005 735998 759146 726829 733403 796779 496714 89199 388535 401809 412152 450845 446780 457807 466470 496723 499922 548185 714727 406857 420799 518561 498541 495170 471128 518921 419970 471074 547944 584705 558158 575972 579990 584320 580225 622592 790193 741701 459472 466341 420171 507909 733376 518200 534169 431691 8028 388024 825181 816668 826892 825610 459833 530044 564234 700239 683485 752371 790683 801600 802934 743783 154123 408625 715291 641118 808712 794249 808713 768144 386877 811644 455071 824653 509596 580782 579218 596778 486375 37232 411072 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (0.70%) |
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 8028 37232 89199 154123 340613 383347 386877 388024 388535 395769 401809 406857 408625 411072 412152 419970 420171 420799 421600 431691 446780 450845 453002 455071 457807 459472 459833 462143 466341 466470 471074 471128 476068 476672 483315 486375 492814 495170 496345 496714 496723 498541 499922 500282 507909 509596 518200 518561 518921 520848 526244 530044 534169 543057 547944 548185 558158 564234 568635 575972 579218 579990 580225 580782 584320 584705 589400 591162 596778 599145 617585 622592 624974 641118 660818 668703 673232 683485 684678 691466 700239 714727 715291 726829 733376 733403 735998 741701 743783 749054 752371 753745 758277 759146 768144 772453 782152 782987 790193 790683 793782 794249 796779 801600 801667 801976 801977 802005 802231 802934 804486 804622 808712 808713 811644 816668 824653 825181 825610 826892 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam tits masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер сиськ мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.37%) |
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.