Query Metrics
7
Database Queries
7
Different statements
160.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.70 ms (85.97%) |
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 281738 384419 385783 411161 411304 417386 424026 436828 439159 442527 446524 451080 456590 468229 472329 473607 487804 494641 500598 509028 523601 523627 525925 532654 532884 533827 534635 534663 535143 539364 540113 540679 544457 545337 545561 545965 548634 550119 550123 551524 554848 558713 561801 568709 573202 576462 580649 581050 584980 585338 602222 614192 615603 617976 625473 636468 636469 639795 640393 643706 648045 649062 649470 651725 669914 669933 670623 679504 680971 685527 692109 692697 701198 705708 715166 721178 725512 726886 727320 732084 735904 739669 742212 745908 745986 745991 746038 751743 753621 755183 757207 760227 768680 769447 774052 780137 788655 789090 794019 796577 796952 800229 801364 803384 803705 803841 812229 812236 812521 813730 814291 819424 819862 823251 826110 827351 827655 828326 828363 828411 ] |
||||||||||||||||||||||||||||||
|
12.39 ms (7.73%) |
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 826110 827351 823251 819424 828411 828326 828363 523627 535143 540113 540679 544457 561801 649062 692697 701198 545561 625473 640393 639795 796952 745991 800229 812521 739669 751743 755183 774052 727320 745986 705708 715166 721178 789090 580649 649470 281738 468229 550119 456590 581050 685527 757207 417386 813730 500598 532654 669933 692109 648045 680971 554848 558713 617976 636469 742212 768680 803705 745908 411304 539364 725512 411161 545337 584980 576462 794019 801364 760227 732084 446524 550123 803841 509028 545965 439159 384419 442527 473607 585338 780137 494641 643706 534663 568709 551524 573202 651725 670623 669914 602222 614192 615603 788655 753621 746038 769447 812236 436828 472329 525925 819862 451080 523601 679504 548634 636468 796577 812229 385783 814291 534635 735904 424026 803384 726886 827655 487804 532884 533827 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.91%) |
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 281738 384419 385783 411161 411304 417386 424026 436828 439159 442527 446524 451080 456590 468229 472329 473607 487804 494641 500598 509028 523601 523627 525925 532654 532884 533827 534635 534663 535143 539364 540113 540679 544457 545337 545561 545965 548634 550119 550123 551524 554848 558713 561801 568709 573202 576462 580649 581050 584980 585338 602222 614192 615603 617976 625473 636468 636469 639795 640393 643706 648045 649062 649470 651725 669914 669933 670623 679504 680971 685527 692109 692697 701198 705708 715166 721178 725512 726886 727320 732084 735904 739669 742212 745908 745986 745991 746038 751743 753621 755183 757207 760227 768680 769447 774052 780137 788655 789090 794019 796577 796952 800229 801364 803384 803705 803841 812229 812236 812521 813730 814291 819424 819862 823251 826110 827351 827655 828326 828363 828411 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public bathroom masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц ван мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.04%) |
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.