Query Metrics
7
Database Queries
7
Different statements
212.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.85 ms (88.39%) |
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 384935 387615 393550 396370 398547 398926 430991 440986 450686 456877 465887 472579 482321 525481 550974 556328 570601 572077 576392 583255 584332 594964 600311 623544 657692 662768 667832 667834 669451 671325 678580 679105 689758 696164 696324 700544 708405 710020 715538 716576 716910 717752 719190 720378 722794 722819 722833 722886 723093 724499 725574 726110 726263 726322 732841 733020 733095 737225 739074 741195 743955 744631 744740 746142 750920 753340 754198 755635 756525 757241 765824 769997 770185 771481 772732 773599 774427 774597 776415 776632 778111 779028 779915 780682 781781 781967 786371 786985 788458 790377 792768 795552 797263 797453 798642 799445 800506 800905 802438 802727 803219 804820 805735 806233 807171 807200 809458 810641 810849 811075 812191 812881 813247 813395 813470 813699 818307 819009 821645 822154 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (6.82%) |
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 765824 726110 744740 773599 700544 716576 720378 722794 722819 722886 779028 779915 786985 788458 792768 797453 804820 810641 810849 813470 393550 774427 669451 600311 774597 781781 769997 710020 583255 803219 472579 716910 440986 396370 584332 799445 456877 384935 398547 813699 450686 525481 576392 715538 667832 667834 723093 809458 778111 795552 725574 800905 802727 733095 750920 776632 781967 798642 812881 770185 657692 819009 465887 696324 780682 786371 813395 732841 741195 757241 726263 771481 726322 756525 797263 807171 398926 821645 818307 822154 556328 678580 719190 722833 662768 708405 671325 679105 689758 696164 717752 790377 805735 743955 754198 800506 807200 811075 724499 739074 733020 746142 744631 755635 753340 772732 623544 802438 812191 813247 387615 430991 570601 572077 594964 482321 737225 550974 776415 806233 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.43%) |
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 384935 387615 393550 396370 398547 398926 430991 440986 450686 456877 465887 472579 482321 525481 550974 556328 570601 572077 576392 583255 584332 594964 600311 623544 657692 662768 667832 667834 669451 671325 678580 679105 689758 696164 696324 700544 708405 710020 715538 716576 716910 717752 719190 720378 722794 722819 722833 722886 723093 724499 725574 726110 726263 726322 732841 733020 733095 737225 739074 741195 743955 744631 744740 746142 750920 753340 754198 755635 756525 757241 765824 769997 770185 771481 772732 773599 774427 774597 776415 776632 778111 779028 779915 780682 781781 781967 786371 786985 788458 790377 792768 795552 797263 797453 798642 799445 800506 800905 802438 802727 803219 804820 805735 806233 807171 807200 809458 810641 810849 811075 812191 812881 813247 813395 813470 813699 818307 819009 821645 822154 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking tits"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.75%) |
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.