Query Metrics
7
Database Queries
7
Different statements
159.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.50 ms (83.90%) |
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 303771 383991 390381 392980 400004 400365 400539 403392 410848 413575 416367 420727 420847 427764 429847 435117 436530 437265 447857 453802 454468 454873 456115 456578 457320 458572 458662 460369 461060 463501 463527 463563 463567 463584 463594 463612 465477 468968 470882 472258 472624 473193 475061 475733 475956 476799 478095 478163 479584 479752 480590 483168 483687 484302 484503 484544 485251 486278 487635 495868 500860 500885 503496 505222 513060 513614 514844 515621 515855 520850 520930 521388 522320 522993 524234 525674 525952 527696 527805 527930 528112 529939 530146 530448 532020 534524 535763 535769 536358 537168 537282 538523 539008 542303 553823 592795 601753 665042 675703 723024 723035 730035 735704 755462 755897 758744 762611 766119 771025 793136 811489 815683 815793 824736 826007 826290 828430 828644 828845 ] |
||||||||||||||||||||||||||||||
|
15.39 ms (9.67%) |
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 513614 484302 665042 828430 537168 400365 723035 793136 755897 539008 447857 537282 503496 461060 413575 400004 437265 521388 383991 484544 436530 487635 456578 485251 675703 522320 303771 400539 403392 435117 420727 410848 416367 465477 472258 479584 458572 463527 463584 463612 470882 480590 456115 457320 463567 468968 478095 522993 527696 529939 530448 538523 495868 505222 525952 534524 513060 524234 527805 530146 535763 463501 463563 463594 475061 483168 486278 601753 735704 453802 454873 390381 420847 427764 500860 525674 483687 484503 472624 458662 475956 476799 478163 520850 515621 515855 528112 532020 454468 520930 479752 429847 473193 527930 475733 460369 392980 592795 500885 542303 553823 766119 730035 723024 815683 815793 828845 828644 535769 514844 762611 811489 755462 758744 826007 824398 824736 826290 536358 771025 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.83%) |
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 303771 383991 390381 392980 400004 400365 400539 403392 410848 413575 416367 420727 420847 427764 429847 435117 436530 437265 447857 453802 454468 454873 456115 456578 457320 458572 458662 460369 461060 463501 463527 463563 463567 463584 463594 463612 465477 468968 470882 472258 472624 473193 475061 475733 475956 476799 478095 478163 479584 479752 480590 483168 483687 484302 484503 484544 485251 486278 487635 495868 500860 500885 503496 505222 513060 513614 514844 515621 515855 520850 520930 521388 522320 522993 524234 525674 525952 527696 527805 527930 528112 529939 530146 530448 532020 534524 535763 535769 536358 537168 537282 538523 539008 542303 553823 592795 601753 665042 675703 723024 723035 730035 735704 755462 755897 758744 762611 766119 771025 793136 811489 815683 815793 824736 826007 826290 828430 828644 828845 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in white panties"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white трусик нижн бел"
]
|
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.