Query Metrics
7
Database Queries
7
Different statements
158.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.30 ms (76.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 91532 379619 414799 414957 417799 429300 434836 443490 443971 446794 448399 451786 453142 453368 456428 457527 471310 471934 477013 477037 477073 479082 479791 482564 482958 494379 495233 497593 499485 502019 503535 504672 510618 511259 512174 514295 515344 517729 519273 519595 520448 520669 521092 521743 522343 523819 525187 525392 525867 526605 527425 528122 532483 533192 533261 534853 536691 538463 540095 541890 543974 548262 551063 555264 556042 558331 560286 565839 569150 569589 574431 575757 576112 576363 579851 588835 620210 622690 623337 624788 625913 631503 634850 651934 667917 668012 694532 699480 713399 716739 722545 722843 738009 749187 754081 759624 761805 763276 767786 777537 784724 784910 786573 789862 789874 801977 802105 802125 805003 806868 807547 807568 813422 815838 818068 819564 819584 820715 821585 821866 ] |
||||||||||||||||||||||||||||||
|
26.24 ms (16.51%) |
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 448399 417799 414957 429300 477037 502019 503535 525187 525392 526605 528122 510618 517729 521092 579851 527425 534853 574431 634850 738009 763276 699480 713399 784724 471934 515344 511259 519595 520669 499485 532483 477073 555264 558331 569589 541890 667917 551063 560286 565839 631503 749187 414799 446794 495233 623337 536691 479791 576112 625913 451786 453368 443971 479082 457527 514295 520448 522343 523819 91532 379619 443490 434836 815838 818068 819564 819584 821585 821866 820715 482564 456428 453142 471310 482958 519273 540095 497593 525867 533192 533261 494379 504672 538463 512174 521743 477013 543974 575757 548262 569150 576363 668012 716739 651934 722545 722843 694532 556042 620210 624788 622690 588835 786573 789874 801977 777537 784910 789862 802125 807568 813422 754081 761805 802105 805003 806868 807547 759624 767786 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.66%) |
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 91532 379619 414799 414957 417799 429300 434836 443490 443971 446794 448399 451786 453142 453368 456428 457527 471310 471934 477013 477037 477073 479082 479791 482564 482958 494379 495233 497593 499485 502019 503535 504672 510618 511259 512174 514295 515344 517729 519273 519595 520448 520669 521092 521743 522343 523819 525187 525392 525867 526605 527425 528122 532483 533192 533261 534853 536691 538463 540095 541890 543974 548262 551063 555264 556042 558331 560286 565839 569150 569589 574431 575757 576112 576363 579851 588835 620210 622690 623337 624788 625913 631503 634850 651934 667917 668012 694532 699480 713399 716739 722545 722843 738009 749187 754081 759624 761805 763276 767786 777537 784724 784910 786573 789862 789874 801977 802105 802125 805003 806868 807547 807568 813422 815838 818068 819564 819584 820715 821585 821866 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gag sperm"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.31%) |
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:
[
"бдсм сперм"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.02%) |
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.