Query Metrics
7
Database Queries
7
Different statements
380.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.87 ms (54.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
148.14 ms (38.92%) |
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 11330 11947 12132 154844 188066 310190 365912 383571 385070 387951 390323 392373 397167 398824 398928 400511 407115 407158 410242 416448 419604 424238 425620 425988 427207 433418 434849 437044 440796 447657 449692 456075 457577 459435 464206 466281 478029 479105 488383 493781 497486 498188 510555 512019 513204 515855 516924 517131 520378 526541 528112 529340 529654 530011 542386 543279 546176 549568 550827 554405 555857 568899 582558 590288 593104 593346 596169 596335 600777 603656 604219 604222 604426 605514 608516 616700 621578 626492 639861 667209 670718 680562 691259 720970 741046 741855 752410 755318 758114 759935 760777 760867 764832 766787 770831 776860 778191 782235 782370 788073 790936 793070 801028 801681 803015 803091 803425 803725 804731 805913 805914 805944 817838 818069 820191 823705 824772 825285 825809 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (4.64%) |
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 397167 488383 550827 449692 456520 416448 425988 464206 516924 493781 549568 479105 407158 512019 437044 526541 755318 604426 513204 752410 424238 457577 529340 542386 466281 515855 528112 600777 555857 447657 385070 604219 387951 365912 400511 817838 824772 825809 818069 820191 823705 825285 497486 543279 546176 720970 670718 596335 605514 790936 801028 803425 804731 776860 778191 803015 803725 805944 782370 805913 760867 764832 770831 759935 805914 11330 407115 530011 590288 425620 410242 434849 456075 520378 498188 517131 392373 12132 510555 398928 596169 459435 383571 154844 188066 310190 11947 390323 398824 433418 419604 440796 478029 529654 554405 582558 667209 691259 680562 568899 616700 639861 604222 621578 593346 603656 626492 593104 608516 782235 788073 801681 803091 760777 766787 741855 741046 758114 793070 427207 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (0.87%) |
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 11330 11947 12132 154844 188066 310190 365912 383571 385070 387951 390323 392373 397167 398824 398928 400511 407115 407158 410242 416448 419604 424238 425620 425988 427207 433418 434849 437044 440796 447657 449692 456075 457577 459435 464206 466281 478029 479105 488383 493781 497486 498188 510555 512019 513204 515855 516924 517131 520378 526541 528112 529340 529654 530011 542386 543279 546176 549568 550827 554405 555857 568899 582558 590288 593104 593346 596169 596335 600777 603656 604219 604222 604426 605514 608516 616700 621578 626492 639861 667209 670718 680562 691259 720970 741046 741855 752410 755318 758114 759935 760777 760867 764832 766787 770831 776860 778191 782235 782370 788073 790936 793070 801028 801681 803015 803091 803425 803725 804731 805913 805914 805944 817838 818069 820191 823705 824772 825285 825809 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass stockings"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.