Query Metrics
7
Database Queries
7
Different statements
150.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.21 ms (86.43%) |
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 260590 435409 444956 445108 446560 450894 455579 459585 469379 477434 487351 496144 501358 503000 507550 509963 510257 521002 521968 523008 527309 531383 532509 541061 546415 555469 565510 566925 567621 571130 579865 583744 585141 588727 588865 591719 591956 619752 626015 635002 644447 670197 677332 680589 690629 703781 709845 714082 715638 716967 718613 720012 726126 728905 729053 730079 730166 732176 732192 733573 733724 735649 735987 736754 738560 743925 744576 744824 746929 747962 748003 748515 749972 751621 753153 755568 757166 757687 758659 759909 763526 765550 766365 767292 768990 771914 771931 773240 773451 773601 775313 781121 784003 784155 785601 786649 787648 790100 791870 793038 793052 793054 795875 795876 795907 799736 801395 801922 804409 805255 808044 808209 810394 810859 813410 819319 823736 824589 825584 825844 ] |
||||||||||||||||||||||||||||||
|
10.87 ms (7.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 795876 732192 808209 810859 726126 729053 736754 757687 768990 735649 743925 748515 746929 709845 260590 509963 546415 718613 690629 799736 751621 738560 748003 477434 823736 824589 825844 819319 765550 566925 444956 635002 801922 804409 810394 753153 758659 744824 728905 735987 749972 773240 644447 716967 805255 521002 825584 531383 541061 555469 579865 567621 583744 715638 720012 588727 591719 591956 786649 795907 775313 793054 813410 732176 767292 787648 791870 793038 793052 795875 757166 766365 773601 747962 730079 733724 744576 763526 771914 773451 730166 759909 771931 703781 781121 785601 790100 801395 585141 487351 507550 510257 523008 532509 527309 496144 503000 571130 565510 677332 680589 670197 714082 588865 619752 626015 784003 784155 755568 808044 733573 455579 469379 450894 459585 446560 435409 445108 501358 521968 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.85%) |
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 260590 435409 444956 445108 446560 450894 455579 459585 469379 477434 487351 496144 501358 503000 507550 509963 510257 521002 521968 523008 527309 531383 532509 541061 546415 555469 565510 566925 567621 571130 579865 583744 585141 588727 588865 591719 591956 619752 626015 635002 644447 670197 677332 680589 690629 703781 709845 714082 715638 716967 718613 720012 726126 728905 729053 730079 730166 732176 732192 733573 733724 735649 735987 736754 738560 743925 744576 744824 746929 747962 748003 748515 749972 751621 753153 755568 757166 757687 758659 759909 763526 765550 766365 767292 768990 771914 771931 773240 773451 773601 775313 781121 784003 784155 785601 786649 787648 790100 791870 793038 793052 793054 795875 795876 795907 799736 801395 801922 804409 805255 808044 808209 810394 810859 813410 819319 823736 824589 825584 825844 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm on pussy"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм pussy"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм 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.