Query Metrics
7
Database Queries
7
Different statements
154.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.96 ms (82.26%) |
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 229834 358481 388716 388739 395660 397871 411765 413476 430549 440801 440871 467484 467498 467507 468906 474941 482516 500857 502288 511314 514681 522056 522079 522760 522972 528621 530849 533613 533740 538970 541325 545524 549826 549851 554321 556728 557118 558013 558301 560359 582615 585358 593028 598877 601135 603455 608352 609274 646889 646929 665893 666780 667010 724086 724702 725575 727924 731751 731752 731754 731756 731769 731772 731776 731788 731796 731800 742706 744767 744805 746460 747949 748467 749025 758438 761414 770123 770157 770177 770190 770200 770207 770226 770946 772104 772875 776827 781654 781665 781685 781733 781761 781807 782235 782284 788680 788877 789997 789998 794665 799044 799141 799630 800916 801402 802139 802195 802739 802986 804213 810477 812742 816635 818368 820106 820225 820280 823847 824604 824806 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (9.86%) |
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 776827 770157 601135 770226 799044 770207 799630 781665 804213 799141 770177 440801 770190 812742 514681 782235 467484 770200 802739 770123 598877 522760 585358 538970 802139 731800 746460 522972 522056 560359 528621 744767 770946 824604 724086 801402 500857 556728 467498 818368 533740 502288 582615 789998 810477 522079 388716 388739 820280 823847 788877 782284 731772 747949 802195 397871 593028 731754 468906 549826 603455 772875 724702 824806 820225 558301 788680 731776 557118 761414 802986 430549 545524 541325 482516 474941 554321 666780 558013 609274 781733 781761 727924 411765 358481 229834 395660 511314 667010 646929 794665 758438 781654 731756 731769 731796 725575 731751 816635 800916 744805 731752 749025 533613 646889 467507 413476 440871 820106 530849 665893 549851 608352 789997 781807 742706 772104 731788 748467 781685 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.69%) |
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 229834 358481 388716 388739 395660 397871 411765 413476 430549 440801 440871 467484 467498 467507 468906 474941 482516 500857 502288 511314 514681 522056 522079 522760 522972 528621 530849 533613 533740 538970 541325 545524 549826 549851 554321 556728 557118 558013 558301 560359 582615 585358 593028 598877 601135 603455 608352 609274 646889 646929 665893 666780 667010 724086 724702 725575 727924 731751 731752 731754 731756 731769 731772 731776 731788 731796 731800 742706 744767 744805 746460 747949 748467 749025 758438 761414 770123 770157 770177 770190 770200 770207 770226 770946 772104 772875 776827 781654 781665 781685 781733 781761 781807 782235 782284 788680 788877 789997 789998 794665 799044 799141 799630 800916 801402 802139 802195 802739 802986 804213 810477 812742 816635 818368 820106 820225 820280 823847 824604 824806 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red hair mature"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red hair mature"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red hair mature"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.17%) |
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.