Query Metrics
7
Database Queries
7
Different statements
168.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.33 ms (86.13%) |
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 398257 409822 420874 425610 435401 444109 445203 455783 458425 473409 477537 486076 490965 494894 500815 508607 517660 525446 526849 527440 528372 528374 528475 531767 539500 540868 541718 541722 542701 548973 549574 552621 555801 559403 565234 571756 575614 583107 594447 595513 604206 615841 620585 621521 625580 629169 633005 635339 637851 646662 650046 654401 655143 656530 665747 669543 672277 684455 687146 692094 694432 713206 715396 718054 720102 720418 725021 727649 728322 736610 737852 743069 743087 744689 745081 746432 746703 747716 749702 753316 756436 762588 763061 764840 765398 765730 766897 767042 768703 771575 771901 772860 775909 776216 777026 777029 781327 782544 783710 787755 788414 791770 793319 794142 797104 804228 805722 807532 810039 813207 816627 821397 825542 826294 826624 826976 827564 828563 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (8.35%) |
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 756436 813207 766889 473409 425610 435401 527440 494894 575614 646662 692094 555801 637851 783710 781327 743069 782544 793319 794142 805722 737852 728322 743087 762588 744689 629169 635339 777029 825542 621521 765398 816627 826976 771575 633005 420874 444109 445203 540868 455783 458425 486076 525446 528372 528374 500815 517660 528475 477537 490965 549574 542701 672277 650046 665747 718054 604206 615841 620585 713206 409822 508607 583107 655143 694432 571756 746703 768703 767042 398257 821397 826624 541718 548973 541722 552621 669543 687146 720102 654401 684455 595513 625580 776216 787755 788414 775909 804228 725021 753316 772860 791770 797104 807532 810039 747716 763061 766897 770352 745081 746432 765730 749702 771901 715396 720418 777026 826294 827564 828563 559403 594447 736610 764840 727649 531767 539500 526849 565234 656530 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.53%) |
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 398257 409822 420874 425610 435401 444109 445203 455783 458425 473409 477537 486076 490965 494894 500815 508607 517660 525446 526849 527440 528372 528374 528475 531767 539500 540868 541718 541722 542701 548973 549574 552621 555801 559403 565234 571756 575614 583107 594447 595513 604206 615841 620585 621521 625580 629169 633005 635339 637851 646662 650046 654401 655143 656530 665747 669543 672277 684455 687146 692094 694432 713206 715396 718054 720102 720418 725021 727649 728322 736610 737852 743069 743087 744689 745081 746432 746703 747716 749702 753316 756436 762588 763061 764840 765398 765730 766897 767042 768703 771575 771901 772860 775909 776216 777026 777029 781327 782544 783710 787755 788414 791770 793319 794142 797104 804228 805722 807532 810039 813207 816627 821397 825542 826294 826624 826976 827564 828563 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen close-up"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen close up"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen close up"
]
|
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.