Query Metrics
7
Database Queries
7
Different statements
178.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.83 ms (88.21%) |
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 417733 427544 443871 487205 526464 527536 528710 548723 552180 568944 575591 585899 588278 590029 590328 593613 595538 599032 605730 608545 609081 609107 614001 616604 619241 620980 621548 625958 625978 625992 626678 626755 630345 632295 637726 639111 641153 647119 652552 656576 658837 662076 668085 668086 668099 668100 668102 668111 668331 673908 677265 684888 687140 695467 695882 696198 702623 705139 707214 711802 712397 712582 715765 715800 716992 719373 719932 719949 722052 723826 726327 729871 734124 748825 752580 753037 755246 756144 756746 761484 761728 765059 765061 765091 765096 765098 765101 765103 765109 769046 769768 771912 772865 773421 774698 775416 775996 776048 777227 777410 777633 781579 784292 786578 789437 791246 791481 791729 794909 794924 796916 797810 800024 805665 809965 817203 818753 823359 826353 ] |
||||||||||||||||||||||||||||||
|
12.30 ms (6.88%) |
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 729871 658837 528710 487205 826353 575591 719373 605730 800024 781579 765101 765109 769046 753037 765061 755246 771912 775996 777227 427544 823359 789437 527536 668086 684888 712397 652552 656576 719932 668111 695467 599032 625958 619241 637726 625978 626755 777410 791729 805665 765091 765096 752580 765059 765103 748825 756746 761728 772865 773421 716992 722052 797810 548723 443871 817203 552180 568944 668102 687140 707214 711802 702623 715765 662076 668100 590328 609081 593613 614001 625992 639111 588278 595538 626678 632295 774698 776048 777633 791481 723826 734124 761484 765098 794909 794924 726327 756144 759773 769768 775416 809965 417733 818753 526464 668085 695882 696198 712582 719949 668331 677265 705139 647119 668099 673908 715800 608545 641153 609107 621548 590029 616604 585899 620980 630345 796916 784292 786578 791246 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.44%) |
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 417733 427544 443871 487205 526464 527536 528710 548723 552180 568944 575591 585899 588278 590029 590328 593613 595538 599032 605730 608545 609081 609107 614001 616604 619241 620980 621548 625958 625978 625992 626678 626755 630345 632295 637726 639111 641153 647119 652552 656576 658837 662076 668085 668086 668099 668100 668102 668111 668331 673908 677265 684888 687140 695467 695882 696198 702623 705139 707214 711802 712397 712582 715765 715800 716992 719373 719932 719949 722052 723826 726327 729871 734124 748825 752580 753037 755246 756144 756746 761484 761728 765059 765061 765091 765096 765098 765101 765103 765109 769046 769768 771912 772865 773421 774698 775416 775996 776048 777227 777410 777633 781579 784292 786578 789437 791246 791481 791729 794909 794924 796916 797810 800024 805665 809965 817203 818753 823359 826353 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real teen"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real teen"
]
|
||||||||||||||||||||||||||||||
|
1.16 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real teen"
]
|
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.