Query Metrics
7
Database Queries
7
Different statements
153.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.61 ms (80.27%) |
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 381785 393055 395970 398209 405850 407800 418519 427100 428895 440780 448069 449886 449950 453714 455197 456034 462708 464327 466059 466109 466317 466750 467009 467975 470506 472793 474216 476992 482945 484577 484583 485463 488380 488951 489178 489851 491943 493539 494563 502712 502715 505636 507711 509192 510425 512085 513506 513521 513788 513857 516718 517989 519354 520870 522494 523465 524245 525884 527989 528143 528452 530504 531316 532352 533801 535546 545538 545914 546761 546937 549772 556009 558819 563213 564825 581021 584791 586582 591546 595783 597867 610285 629781 640687 643933 650662 653794 697000 715509 724476 724532 725350 725568 730091 733097 736137 742771 742873 748236 748695 766349 766523 769310 770245 770882 784427 784621 785435 789534 789535 789537 790986 796804 796881 800654 801961 802413 804004 804435 813408 ] |
||||||||||||||||||||||||||||||
|
19.45 ms (12.63%) |
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 789537 789535 725350 733097 801961 724476 742771 586582 591546 522494 789534 546937 563213 742873 748695 804435 509192 505636 766349 398209 748236 466109 650662 610285 800654 549772 453714 489178 523465 785435 381785 474216 407800 724532 766523 715509 784621 476992 489851 730091 517989 488951 790986 725568 804004 513788 493539 502712 513521 564825 440780 449950 448069 533801 535546 532352 558819 581021 813408 769310 736137 770882 427100 462708 484577 482945 494563 395970 455197 484583 520870 456034 513857 545914 584791 653794 796881 796804 802413 770245 784427 466750 528143 502715 519354 491943 393055 507711 556009 464327 531316 528452 513506 405850 466059 530504 466317 510425 524245 525884 467009 485463 470506 449886 512085 488380 595783 643933 697000 428895 467975 418519 516718 472793 527989 546761 545538 629781 640687 597867 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.05%) |
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 381785 393055 395970 398209 405850 407800 418519 427100 428895 440780 448069 449886 449950 453714 455197 456034 462708 464327 466059 466109 466317 466750 467009 467975 470506 472793 474216 476992 482945 484577 484583 485463 488380 488951 489178 489851 491943 493539 494563 502712 502715 505636 507711 509192 510425 512085 513506 513521 513788 513857 516718 517989 519354 520870 522494 523465 524245 525884 527989 528143 528452 530504 531316 532352 533801 535546 545538 545914 546761 546937 549772 556009 558819 563213 564825 581021 584791 586582 591546 595783 597867 610285 629781 640687 643933 650662 653794 697000 715509 724476 724532 725350 725568 730091 733097 736137 742771 742873 748236 748695 766349 766523 769310 770245 770882 784427 784621 785435 789534 789535 789537 790986 796804 796881 800654 801961 802413 804004 804435 813408 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home mature pussy"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home mature pussy"
]
|
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.