Query Metrics
7
Database Queries
7
Different statements
225.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.18 ms (87.92%) |
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 3311 146006 186592 396796 398522 423972 462977 463976 474087 476230 486024 487928 491765 504855 505236 505696 506772 517683 518297 522166 529804 530569 533843 536521 536531 537641 539751 547004 551111 551891 570883 574440 575980 582444 591917 595116 602667 607444 610031 614236 614333 615920 617805 619899 624791 624856 628826 629528 639578 653087 663911 664528 667762 681184 697227 700837 702615 710483 713432 715419 717379 718155 724457 725518 726646 726795 733110 733318 733504 735882 753037 755065 761254 761854 770194 770259 774400 781790 781858 781926 781940 781989 789545 795046 795321 797241 803875 804586 808012 812284 815358 816832 819273 819324 819336 819799 819962 823758 823778 823848 823868 823983 825056 825136 825148 825320 825361 825433 826173 826582 826598 826811 826927 826980 827181 827392 827498 827517 827594 827712 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (6.29%) |
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 825136 537641 570883 574440 663911 713432 681184 697227 717379 551891 602667 614236 591917 624791 804586 795046 795321 733318 803875 812284 724457 770194 726646 733110 753037 733504 755065 735882 624856 718155 761854 491765 615920 146006 3311 396796 819336 819273 823778 536521 536531 530569 533843 522166 529804 539751 547004 575980 653087 664528 710483 702615 667762 628826 629528 595116 614333 619899 639578 781858 781926 781940 789545 808012 726795 770259 725518 761254 607444 700837 715419 781790 781989 398522 423972 617805 462977 504855 506772 474087 476230 582444 551111 797241 486024 487928 517683 505696 610031 463976 518297 505236 186592 816832 823758 823983 825056 825361 826173 774400 823848 815358 819799 825148 825320 825433 826582 826598 823868 826811 826927 826980 827181 827594 827392 827498 827517 827712 819324 819962 ] |
||||||||||||||||||||||||||||||
|
5.42 ms (2.40%) |
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 3311 146006 186592 396796 398522 423972 462977 463976 474087 476230 486024 487928 491765 504855 505236 505696 506772 517683 518297 522166 529804 530569 533843 536521 536531 537641 539751 547004 551111 551891 570883 574440 575980 582444 591917 595116 602667 607444 610031 614236 614333 615920 617805 619899 624791 624856 628826 629528 639578 653087 663911 664528 667762 681184 697227 700837 702615 710483 713432 715419 717379 718155 724457 725518 726646 726795 733110 733318 733504 735882 753037 755065 761254 761854 770194 770259 774400 781790 781858 781926 781940 781989 789545 795046 795321 797241 803875 804586 808012 812284 815358 816832 819273 819324 819336 819799 819962 823758 823778 823848 823868 823983 825056 825136 825148 825320 825361 825433 826173 826582 826598 826811 826927 826980 827181 827392 827498 827517 827594 827712 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy сиськ chubby"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy tits chubby"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy сиськ chubby"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.81%) |
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.