Query Metrics
7
Database Queries
7
Different statements
159.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.51 ms (82.83%) |
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 31329 358449 387021 388557 389211 390807 391237 391655 392565 395908 395925 397850 397863 400820 409935 418080 439709 439746 439758 439810 439821 440996 441001 443408 443756 443788 443913 444104 452187 452963 454224 454232 457450 460925 463839 466018 466199 466247 467008 467055 467233 467550 470190 470275 474629 474635 474790 476274 476363 477994 478387 480814 482541 488953 490896 490907 490930 493103 496028 509515 510775 511522 519739 520859 520860 521667 522003 524362 526738 529999 536433 544466 544859 546962 557971 558005 560400 562961 563058 563421 565724 609268 609274 615693 619223 619522 620264 621337 625036 675590 715458 721388 721427 721467 727732 731088 734323 740530 741027 741699 741773 754227 757933 761022 768049 781665 781733 781741 781761 782160 782279 788823 790193 794678 794718 794830 803522 807336 824584 825585 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (9.89%) |
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 731088 782160 788823 794678 794718 734323 757933 741027 768049 740530 721388 782279 392565 395925 395908 824584 825585 544859 557971 544466 558005 563058 563421 546962 715458 721427 721467 609274 619223 621337 609268 781733 794830 807336 781761 803522 754227 781665 781741 727732 761022 625036 478387 480814 358449 474790 390807 391237 467550 476363 409935 439709 511522 519739 536433 522003 521667 493103 31329 452963 466199 490930 510775 520860 397863 482541 524362 460925 565724 560400 562961 620264 619522 391655 441001 443788 467008 389211 418080 439758 439810 467055 470190 474629 474635 397850 400820 452187 470275 439746 439821 454224 457450 477994 440996 454232 466018 466247 467233 496028 490907 526738 490896 444104 488953 520859 509515 529999 476274 675590 790193 741773 741699 615693 387021 388557 443756 443913 443408 463839 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (2.39%) |
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 31329 358449 387021 388557 389211 390807 391237 391655 392565 395908 395925 397850 397863 400820 409935 418080 439709 439746 439758 439810 439821 440996 441001 443408 443756 443788 443913 444104 452187 452963 454224 454232 457450 460925 463839 466018 466199 466247 467008 467055 467233 467550 470190 470275 474629 474635 474790 476274 476363 477994 478387 480814 482541 488953 490896 490907 490930 493103 496028 509515 510775 511522 519739 520859 520860 521667 522003 524362 526738 529999 536433 544466 544859 546962 557971 558005 560400 562961 563058 563421 565724 609268 609274 615693 619223 619522 620264 621337 625036 675590 715458 721388 721427 721467 727732 731088 734323 740530 741027 741699 741773 754227 757933 761022 768049 781665 781733 781741 781761 782160 782279 788823 790193 794678 794718 794830 803522 807336 824584 825585 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mature 2023"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mature"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mature"
]
|
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.