Query Metrics
7
Database Queries
7
Different statements
170.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.55 ms (83.44%) |
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 343227 384581 387215 391705 420541 428080 429292 456495 504764 552027 558779 566303 569361 570127 570131 570909 571730 574233 574960 577561 577813 586918 589655 590478 592292 594063 603519 608358 614802 615937 616491 618187 618603 622518 623145 625065 627265 628569 628843 630389 642951 655214 657536 660845 661665 664842 665877 667568 679296 679304 682647 684815 696508 697462 700052 701526 702375 705054 707774 710439 711273 712625 716527 716586 718498 721084 721771 723733 725138 726539 726564 727915 729832 730370 731339 732607 733387 733588 733946 734715 734778 734929 736866 738310 738314 738404 738618 739787 740645 742889 742894 742912 742949 743679 743800 746710 749578 749940 752787 757996 767381 768575 779199 780667 781747 782387 782394 785650 787937 789976 790082 794154 795942 796101 800284 802487 803294 807886 809790 812232 ] |
||||||||||||||||||||||||||||||
|
18.54 ms (10.85%) |
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 574233 577561 570131 570909 574960 558779 571730 679304 684815 700052 707774 712625 655214 664842 679296 682647 697462 701526 705054 711273 718498 657536 661665 667568 569361 570127 577813 614802 615937 623145 628843 592292 603519 618603 589655 628569 630389 594063 616491 627265 642951 790082 795942 796101 800284 807886 727915 731339 733387 738404 740645 742889 743679 746710 767381 782394 785650 787937 789976 802487 803294 809790 812232 733946 734778 738310 742949 749940 757996 723733 726564 730370 734929 738314 738618 752787 726539 739787 742912 743800 749578 733588 618187 625065 702375 710439 721771 780667 782387 794154 391705 343227 504764 420541 429292 608358 384581 428080 566303 552027 660845 768575 456495 696508 665877 781747 729832 734715 716586 721084 736866 725138 387215 716527 590478 586918 622518 779199 732607 742894 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.54%) |
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 343227 384581 387215 391705 420541 428080 429292 456495 504764 552027 558779 566303 569361 570127 570131 570909 571730 574233 574960 577561 577813 586918 589655 590478 592292 594063 603519 608358 614802 615937 616491 618187 618603 622518 623145 625065 627265 628569 628843 630389 642951 655214 657536 660845 661665 664842 665877 667568 679296 679304 682647 684815 696508 697462 700052 701526 702375 705054 707774 710439 711273 712625 716527 716586 718498 721084 721771 723733 725138 726539 726564 727915 729832 730370 731339 732607 733387 733588 733946 734715 734778 734929 736866 738310 738314 738404 738618 739787 740645 742889 742894 742912 742949 743679 743800 746710 749578 749940 752787 757996 767381 768575 779199 780667 781747 782387 782394 785650 787937 789976 790082 794154 795942 796101 800284 802487 803294 807886 809790 812232 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"the wife old"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен old"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен old"
]
|
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.