Query Metrics
7
Database Queries
7
Different statements
223.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.47 ms (88.44%) |
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 32637 97694 249637 382821 385809 387766 390820 395147 396609 398140 400739 401203 409119 416069 417333 418028 420356 423339 425004 425903 430504 431105 440680 445321 449868 452079 453737 459488 462829 463083 463825 464681 466481 468467 470848 472341 472496 473467 474058 475514 478668 478676 484785 492177 492839 493197 496552 499886 502921 512693 516781 523418 524841 527762 529286 530729 530753 531540 532567 534273 534298 536916 538032 538276 542582 543515 550307 551025 553296 554394 556958 562332 562340 562348 564719 565132 573940 575437 577211 580589 582035 582590 584740 586556 587251 587495 590501 599192 599556 600061 604574 605288 606836 615812 615839 615898 615915 629893 636108 639235 640723 644005 646001 669695 672804 675515 710767 710871 716282 723046 756468 759472 788283 804491 807635 807990 811837 812320 813152 821262 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (6.94%) |
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 492177 417333 32637 423339 425903 453737 463083 524841 573940 462829 475514 249637 534273 562348 416069 445321 580589 390820 534298 542582 710871 636108 97694 420356 470848 492839 523418 536916 554394 551025 587495 605288 788283 807635 756468 398140 590501 646001 615898 639235 615915 425004 387766 478676 599192 565132 449868 466481 530753 553296 463825 599556 538276 812320 473467 493197 527762 496552 577211 582590 564719 672804 587251 644005 615812 813152 474058 502921 452079 556958 472496 716282 382821 396609 409119 529286 562332 759472 472341 615839 395147 385809 710767 629893 401203 530729 516781 532567 586556 606836 640723 804491 811837 584740 418028 807990 464681 531540 478668 575437 723046 512693 675515 484785 499886 430504 431105 604574 538032 400739 440680 468467 821262 669695 459488 543515 600061 550307 562340 582035 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.22%) |
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 32637 97694 249637 382821 385809 387766 390820 395147 396609 398140 400739 401203 409119 416069 417333 418028 420356 423339 425004 425903 430504 431105 440680 445321 449868 452079 453737 459488 462829 463083 463825 464681 466481 468467 470848 472341 472496 473467 474058 475514 478668 478676 484785 492177 492839 493197 496552 499886 502921 512693 516781 523418 524841 527762 529286 530729 530753 531540 532567 534273 534298 536916 538032 538276 542582 543515 550307 551025 553296 554394 556958 562332 562340 562348 564719 565132 573940 575437 577211 580589 582035 582590 584740 586556 587251 587495 590501 599192 599556 600061 604574 605288 606836 615812 615839 615898 615915 629893 636108 639235 640723 644005 646001 669695 672804 675515 710767 710871 716282 723046 756468 759472 788283 804491 807635 807990 811837 812320 813152 821262 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial big tits"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.65%) |
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.