Query Metrics
7
Database Queries
7
Different statements
161.60 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.72 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.33 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"there home"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.69 ms |
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 712226 717518 722299 645604 646135 648569 659194 659399 660022 672229 673908 674743 678268 680846 685379 694073 697215 697256 697656 698342 709380 712285 714218 714917 714947 716502 720304 547725 548929 550935 553604 578549 584652 590625 592149 604975 613766 616422 625503 626156 641870 589857 593001 601974 607213 610421 617974 619949 630619 642617 592432 607893 610139 640589 643361 597769 599427 626608 641787 643936 775400 778098 780358 783887 788066 790357 790617 791169 792340 792432 775171 776253 776753 778145 779046 779162 782796 785180 785678 787912 789484 789552 794477 795719 805647 810441 812401 813143 725350 725540 726726 736052 736342 739422 743196 745256 752496 760278 761818 762956 765915 785794 789791 789837 796961 797794 798403 801661 805350 805717 811762 813168 813327 724373 727681 727724 730031 738275 740763 741857 ] |
||||||||||||||||||||||||||||||
| 4 | 2.68 ms |
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 547725 548929 550935 553604 578549 584652 589857 590625 592149 592432 593001 597769 599427 601974 604975 607213 607893 610139 610421 613766 616422 617974 619949 625503 626156 626608 630619 640589 641787 641870 642617 643361 643936 645604 646135 648569 659194 659399 660022 672229 673908 674743 678268 680846 685379 694073 697215 697256 697656 698342 709380 712226 712285 714218 714917 714947 716502 717518 720304 722299 724373 725350 725540 726726 727681 727724 730031 736052 736342 738275 739422 740763 741857 743196 745256 752496 760278 761818 762956 765915 775171 775400 776253 776753 778098 778145 779046 779162 780358 782796 783887 785180 785678 785794 787912 788066 789484 789552 789791 789837 790357 790617 791169 792340 792432 794477 795719 796961 797794 798403 801661 805350 805647 805717 810441 811762 812401 813143 813168 813327 ] |
||||||||||||||||||||||||||||||
| 5 | 134.37 ms |
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 547725 548929 550935 553604 578549 584652 589857 590625 592149 592432 593001 597769 599427 601974 604975 607213 607893 610139 610421 613766 616422 617974 619949 625503 626156 626608 630619 640589 641787 641870 642617 643361 643936 645604 646135 648569 659194 659399 660022 672229 673908 674743 678268 680846 685379 694073 697215 697256 697656 698342 709380 712226 712285 714218 714917 714947 716502 717518 720304 722299 724373 725350 725540 726726 727681 727724 730031 736052 736342 738275 739422 740763 741857 743196 745256 752496 760278 761818 762956 765915 775171 775400 776253 776753 778098 778145 779046 779162 780358 782796 783887 785180 785678 785794 787912 788066 789484 789552 789791 789837 790357 790617 791169 792340 792432 794477 795719 796961 797794 798403 801661 805350 805647 805717 810441 811762 812401 813143 813168 813327 ] |
||||||||||||||||||||||||||||||
| 6 | 1.99 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.83 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home"
]
|
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.