Query Metrics
7
Database Queries
7
Different statements
352.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.03 ms (59.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old homemade"
]
|
||||||||||||||||||||||||||||||
|
124.50 ms (35.33%) |
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 396734 397762 429259 438486 461096 471887 477415 492016 514976 532126 536330 550565 554121 554180 558655 558779 567942 570127 570131 570909 590496 603489 613293 613350 618773 624334 626240 637403 649059 670238 677569 697462 702375 708655 716403 716515 717235 721685 723744 726476 726479 726492 726493 726509 726557 726681 727969 729928 730821 730931 732090 733012 735516 735832 736659 737927 738070 738860 740417 740500 742698 742892 743355 744082 744461 747230 748651 749501 749578 749896 750774 752467 757200 759223 761171 762483 767223 767399 767565 768417 768691 773534 773903 777641 781308 781631 782387 784083 785728 787937 789139 789879 790602 793694 794154 795089 795942 796101 800284 801718 801719 802487 805650 805652 807268 807886 809790 809857 810548 816747 817861 821862 821869 824152 824178 825155 825492 825502 827184 ] |
||||||||||||||||||||||||||||||
|
11.99 ms (3.40%) |
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 570131 570909 558779 677569 697462 567942 570127 624334 785728 795942 796101 800284 805652 781631 793694 795089 807886 809857 757200 767565 773534 787937 789879 801719 802487 809790 732090 761171 747230 749578 762483 749896 759223 702375 782387 784083 794154 805650 807268 429259 396734 438486 558655 708655 471887 397762 824178 825492 825502 816747 817861 821862 827184 824152 825155 821869 477415 461096 492016 532126 536330 514976 554180 554121 721685 649059 716403 670238 716515 717235 550565 590496 613293 613350 626240 603489 618773 637403 810548 777641 790602 737927 743355 752467 767223 781308 785193 789139 801718 730821 730931 740417 740500 744461 748651 768691 723744 726476 726479 726492 726509 726557 733012 736659 738860 742698 749501 750774 768417 729928 735516 735832 738070 742892 744082 767399 773903 726493 726681 727969 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (0.77%) |
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 396734 397762 429259 438486 461096 471887 477415 492016 514976 532126 536330 550565 554121 554180 558655 558779 567942 570127 570131 570909 590496 603489 613293 613350 618773 624334 626240 637403 649059 670238 677569 697462 702375 708655 716403 716515 717235 721685 723744 726476 726479 726492 726493 726509 726557 726681 727969 729928 730821 730931 732090 733012 735516 735832 736659 737927 738070 738860 740417 740500 742698 742892 743355 744082 744461 747230 748651 749501 749578 749896 750774 752467 757200 759223 761171 762483 767223 767399 767565 768417 768691 773534 773903 777641 781308 781631 782387 784083 785728 787937 789139 789879 790602 793694 794154 795089 795942 796101 800284 801718 801719 802487 805650 805652 807268 807886 809790 809857 810548 816747 817861 821862 821869 824152 824178 825155 825492 825502 827184 ] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old домашн любительск"
]
|
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.