Query Metrics
7
Database Queries
7
Different statements
145.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.34 ms (82.61%) |
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 13229 24855 66768 188169 188254 362726 382281 390582 391108 398532 398553 407761 407799 407938 408245 408978 409941 412988 413302 413678 426548 454288 472608 472690 474399 475919 484243 493172 502718 510815 531275 544504 545175 552817 560389 591046 592914 610034 618033 619523 620014 640724 642109 642820 644529 663987 664315 664956 665364 666841 667860 668183 670904 683052 693325 694379 695410 702381 707379 707383 712563 714505 716221 718995 719893 720121 721983 724286 724846 725348 731815 735992 736307 741091 742734 744452 750289 753244 758823 759629 761147 765302 770028 770144 772340 775649 777233 781995 786282 789619 790611 793587 794473 795101 795844 796899 798051 800699 801259 802455 807335 807534 807625 807633 808544 811485 817551 818054 818817 823585 823613 823976 824360 824457 825360 825456 826702 826731 827035 827312 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (10.22%) |
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 618033 735992 426548 188169 591046 398553 390582 66768 407938 826731 818817 719893 707383 789619 702381 413678 824360 824457 818054 823585 823976 694379 718995 664315 664956 683052 666841 610034 644529 790611 807633 800699 725348 772340 770144 753244 640724 793587 795101 796899 802455 13229 398532 714505 795844 744452 770028 794473 807625 407761 408245 472608 560389 544504 716221 693325 721983 592914 781995 801259 807335 720121 474399 475919 493172 502718 510815 454288 552817 758823 750289 188254 408978 409941 413302 823613 827312 472690 484243 531275 665364 667860 670904 712563 663987 668183 642820 620014 786282 808544 798051 807534 736307 724286 724846 731815 765302 759629 741091 761147 619523 24855 407799 382281 391108 825456 826702 827035 825360 695410 707379 545175 642109 811485 777233 742734 775649 412988 362726 817551 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.18%) |
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 13229 24855 66768 188169 188254 362726 382281 390582 391108 398532 398553 407761 407799 407938 408245 408978 409941 412988 413302 413678 426548 454288 472608 472690 474399 475919 484243 493172 502718 510815 531275 544504 545175 552817 560389 591046 592914 610034 618033 619523 620014 640724 642109 642820 644529 663987 664315 664956 665364 666841 667860 668183 670904 683052 693325 694379 695410 702381 707379 707383 712563 714505 716221 718995 719893 720121 721983 724286 724846 725348 731815 735992 736307 741091 742734 744452 750289 753244 758823 759629 761147 765302 770028 770144 772340 775649 777233 781995 786282 789619 790611 793587 794473 795101 795844 796899 798051 800699 801259 802455 807335 807534 807625 807633 808544 811485 817551 818054 818817 823585 823613 823976 824360 824457 825360 825456 826702 826731 827035 827312 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature fucked"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature fucked"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature fucked"
]
|
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.