Query Metrics
7
Database Queries
7
Different statements
181.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.09 ms (86.12%) |
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 406046 409421 418165 421398 439714 439765 439780 453508 453730 453734 455846 463858 479608 481204 483039 486366 487466 494849 500059 500500 506246 512954 514263 516274 517326 521665 524786 528329 547658 550921 554960 557922 558662 559933 564122 566108 584779 586616 586734 588550 590759 598128 608261 623293 626978 629193 630146 633243 635878 638527 638873 649066 659399 668122 675410 689164 697593 714564 716227 724747 724820 725183 725517 727445 729087 730212 730780 735885 735890 745950 746512 747981 750340 750729 756318 757522 758923 760634 761097 765788 767415 767607 770455 770637 777497 783823 784436 785422 787150 791802 793364 793880 794435 794712 795015 795567 795613 796679 796728 809590 812046 814497 817048 817374 819830 820468 823718 824323 824804 824966 825080 825400 825607 826107 826372 826582 826633 827377 827999 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (8.06%) |
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 566108 608261 486366 512954 514263 483039 500059 528329 439780 524786 598128 590759 586734 439765 418165 463858 421398 455846 439714 584779 516274 517326 547658 626978 453730 824804 554960 714564 479608 550921 586616 557922 675410 824323 506246 825080 760634 453734 817048 794712 787150 825400 481204 735890 725517 809590 825607 826107 635878 659399 697593 521665 793880 817374 784436 765788 770455 767607 725183 767415 785422 795567 558662 794435 494849 756318 409421 500500 826582 827377 716227 812046 729087 796679 724747 730780 750340 453508 814497 793364 689164 638873 763214 819830 823718 777497 633243 750729 820468 487466 649066 668122 588550 638527 623293 796728 747981 724820 730212 735885 629193 826633 826372 559933 564122 783823 745950 757522 758923 727445 791802 795613 746512 406046 630146 795015 824966 827999 770637 761097 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.82%) |
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 406046 409421 418165 421398 439714 439765 439780 453508 453730 453734 455846 463858 479608 481204 483039 486366 487466 494849 500059 500500 506246 512954 514263 516274 517326 521665 524786 528329 547658 550921 554960 557922 558662 559933 564122 566108 584779 586616 586734 588550 590759 598128 608261 623293 626978 629193 630146 633243 635878 638527 638873 649066 659399 668122 675410 689164 697593 714564 716227 724747 724820 725183 725517 727445 729087 730212 730780 735885 735890 745950 746512 747981 750340 750729 756318 757522 758923 760634 761097 765788 767415 767607 770455 770637 777497 783823 784436 785422 787150 791802 793364 793880 794435 794712 795015 795567 795613 796679 796728 809590 812046 814497 817048 817374 819830 820468 823718 824323 824804 824966 825080 825400 825607 826107 826372 826582 826633 827377 827999 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum her жоп"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum her ass"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum her жоп"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
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.