Query Metrics
7
Database Queries
7
Different statements
183.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.25 ms (85.69%) |
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 250422 403651 418566 425573 425574 428062 435503 440947 453381 457376 459252 462260 475560 477903 486872 487176 488948 490158 494963 503954 506136 515512 522482 526219 528465 534335 538537 549648 549662 551047 554318 563052 563834 565979 568216 570832 575025 579569 583096 584861 593790 601541 601741 610241 649839 651039 664154 669201 693273 696241 706029 707569 713676 715129 716153 719294 720124 722058 723077 725579 727330 727407 727451 731020 731197 733167 734624 741829 755352 756367 756400 757715 758247 760706 761941 765518 768060 775002 777829 778492 781785 782019 785029 787286 790841 792021 793787 794421 795192 797804 801029 801145 802483 803714 806849 807576 810383 813667 813787 814762 814763 815174 815729 815973 816359 816544 816568 817688 817704 820164 821406 822426 823580 824546 824868 824997 825201 827266 827480 ] |
||||||||||||||||||||||||||||||
|
16.14 ms (8.79%) |
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 807576 440947 515512 816568 459252 522482 822426 549648 649839 593790 778492 761941 782019 428062 824997 813787 824546 827480 823580 827266 575025 551047 716153 775002 734624 785029 793787 768060 733167 777829 795192 802483 526219 488948 494963 821406 610241 760706 477903 403651 425573 820164 490158 563834 554318 693273 696241 794421 801029 756400 755352 757715 720124 803714 462260 250422 425574 457376 723077 727330 741829 487176 538537 669201 435503 651039 790841 453381 801145 707569 664154 418566 534335 715129 719294 579569 601541 781785 731020 797804 758247 568216 563052 486872 813667 815174 814762 817704 814763 815729 815973 816359 816544 817688 825201 503954 787286 765518 727451 731197 727407 722058 806849 475560 565979 706029 601741 824868 713676 792021 810383 764584 725579 756367 528465 506136 549662 583096 584861 570832 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.71%) |
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 250422 403651 418566 425573 425574 428062 435503 440947 453381 457376 459252 462260 475560 477903 486872 487176 488948 490158 494963 503954 506136 515512 522482 526219 528465 534335 538537 549648 549662 551047 554318 563052 563834 565979 568216 570832 575025 579569 583096 584861 593790 601541 601741 610241 649839 651039 664154 669201 693273 696241 706029 707569 713676 715129 716153 719294 720124 722058 723077 725579 727330 727407 727451 731020 731197 733167 734624 741829 755352 756367 756400 757715 758247 760706 761941 765518 768060 775002 777829 778492 781785 782019 785029 787286 790841 792021 793787 794421 795192 797804 801029 801145 802483 803714 806849 807576 810383 813667 813787 814762 814763 815174 815729 815973 816359 816544 816568 817688 817704 820164 821406 822426 823580 824546 824868 824997 825201 827266 827480 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real milf tits"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real milf сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real milf сиськ"
]
|
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.