Query Metrics
7
Database Queries
7
Different statements
212.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.94 ms (86.09%) |
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 382476 382541 383947 390986 420317 423837 424317 432316 445080 447025 451727 452777 454745 460157 463832 466341 471060 477435 479148 482307 504535 511611 515264 515319 527826 541992 547940 548454 554620 554857 558158 567860 568271 573275 580911 583384 585849 586394 588320 588628 597085 601566 603772 604737 605046 607461 613646 616936 620880 629285 630930 636707 641095 648671 650247 661331 661375 663811 673560 677918 687325 703369 703379 708597 712153 713247 714558 714833 716378 720101 728586 730547 733424 740472 740523 751040 758320 758807 760176 760345 760713 776927 777932 780864 782417 782999 784980 785267 785974 786050 787641 795434 795567 796453 796778 796933 800508 800638 802907 803202 803489 803512 803757 805203 806437 807406 807408 808978 812332 812552 812870 813815 814174 814192 816817 818551 819421 819649 827496 827534 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (8.08%) |
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 827496 818551 827534 471060 527826 568271 650247 708597 677918 687325 703369 720101 648671 663811 673560 714558 573275 588320 597085 604737 607461 636707 630930 588628 601566 629285 796453 796778 802907 805203 807406 795567 796933 807408 808978 740523 751040 760176 760345 800638 758807 740472 733424 758320 760713 703379 782417 785974 786050 803757 445080 482307 567860 463832 447025 432316 423837 814192 547940 605046 420317 454745 390986 452777 451727 460157 477435 558158 641095 806437 424317 479148 466341 515264 816817 730547 383947 382541 382476 819421 819649 813815 814174 511611 515319 504535 541992 554857 580911 548454 554620 583384 661375 714833 661331 713247 712153 716378 586394 613646 603772 616936 620880 585849 776927 782999 784980 795434 803202 812552 812870 777932 780864 785267 787641 800508 803489 803512 812332 728586 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (2.03%) |
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 382476 382541 383947 390986 420317 423837 424317 432316 445080 447025 451727 452777 454745 460157 463832 466341 471060 477435 479148 482307 504535 511611 515264 515319 527826 541992 547940 548454 554620 554857 558158 567860 568271 573275 580911 583384 585849 586394 588320 588628 597085 601566 603772 604737 605046 607461 613646 616936 620880 629285 630930 636707 641095 648671 650247 661331 661375 663811 673560 677918 687325 703369 703379 708597 712153 713247 714558 714833 716378 720101 728586 730547 733424 740472 740523 751040 758320 758807 760176 760345 760713 776927 777932 780864 782417 782999 784980 785267 785974 786050 787641 795434 795567 796453 796778 796933 800508 800638 802907 803202 803489 803512 803757 805203 806437 807406 807408 808978 812332 812552 812870 813815 814174 814192 816817 818551 819421 819649 827496 827534 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер очкастая мастурбац"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam glasses masturbation"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер очкастая мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.