Query Metrics
7
Database Queries
7
Different statements
205.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.92 ms (88.58%) |
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 389790 426611 427555 430393 446216 454136 464975 466559 468096 472305 472346 472703 473959 480037 512965 516107 524778 525028 536408 536431 546638 564304 566042 568054 575719 584246 594554 609194 618344 621443 634415 637106 637749 649932 650339 674125 675405 689673 690510 698969 707304 710455 712930 715908 716074 717911 718683 725035 727825 728170 733149 735031 740450 741906 744937 749237 753492 757747 759756 761042 763005 766651 766758 766884 767118 767289 770102 770310 774176 774200 775436 778055 780541 780634 786129 786458 788305 788544 788978 790955 790963 791567 792635 793009 793343 793749 793772 794705 796238 796491 796527 796956 799011 800052 800488 802177 804940 805563 807948 807994 811883 814418 814470 814582 816014 817423 818395 819777 820048 820517 821436 822441 822581 823070 823306 824227 824937 826414 827178 827533 ] |
||||||||||||||||||||||||||||||
|
13.31 ms (6.48%) |
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 634415 766758 796491 740450 609194 717911 512965 536408 690510 618344 621443 536431 525028 594554 427555 814418 814470 446216 466559 468096 472703 568054 564304 718683 649932 689673 650339 637106 791567 793749 796956 778055 780634 811883 786129 788978 741906 767118 735031 744937 753492 766651 770102 774176 761042 774200 788544 807948 807994 430393 454136 817423 637749 805563 675405 824227 826414 767289 770310 716074 472305 473959 575719 766884 464975 426611 472346 516107 524778 389790 823306 821436 823070 674125 790963 786458 800052 757747 775436 796238 790955 480037 698969 710455 584246 802177 788305 800488 796527 759756 733149 749237 728170 819777 566042 712930 793343 727825 820517 822441 816014 818395 827178 827533 814582 820048 822581 824937 707304 715908 546638 792635 793772 794705 780541 804940 763005 793009 799011 725035 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.55%) |
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 389790 426611 427555 430393 446216 454136 464975 466559 468096 472305 472346 472703 473959 480037 512965 516107 524778 525028 536408 536431 546638 564304 566042 568054 575719 584246 594554 609194 618344 621443 634415 637106 637749 649932 650339 674125 675405 689673 690510 698969 707304 710455 712930 715908 716074 717911 718683 725035 727825 728170 733149 735031 740450 741906 744937 749237 753492 757747 759756 761042 763005 766651 766758 766884 767118 767289 770102 770310 774176 774200 775436 778055 780541 780634 786129 786458 788305 788544 788978 790955 790963 791567 792635 793009 793343 793749 793772 794705 796238 796491 796527 796956 799011 800052 800488 802177 804940 805563 807948 807994 811883 814418 814470 814582 816014 817423 818395 819777 820048 820517 821436 822441 822581 823070 823306 824227 824937 826414 827178 827533 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal sex saggy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал секс saggy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал секс saggy"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.