Query Metrics
7
Database Queries
7
Different statements
159.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.46 ms (82.22%) |
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 4324 131474 185352 194309 203504 384016 384415 386555 391739 395934 398412 398428 398601 398604 403870 407491 410008 412632 415556 415956 418225 419038 419053 419281 420360 423842 423890 426477 431685 432407 432477 432522 433433 433953 438023 440390 440681 440951 441334 442802 443402 444774 446088 446215 446527 446763 447797 448198 449397 451465 455383 456610 458295 458821 461876 467370 469684 474951 475517 484312 486467 489703 489791 490732 491342 492543 494180 501348 502220 510641 511161 516473 516904 517174 517500 517589 519431 530999 538060 567080 567701 568559 568728 568809 576351 576556 580017 591724 609823 654492 654722 659697 665443 692676 704873 727384 733799 739739 742598 745336 746460 746467 748439 756058 758302 767755 769223 772513 772694 773904 778556 786982 792473 792538 800639 801439 802099 803379 813444 825651 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (10.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 511161 412632 517500 492543 486467 803379 489791 384415 441334 448198 458295 484312 491342 446088 433953 444774 447797 456610 467370 519431 502220 423890 568809 419281 131474 451465 510641 756058 403870 419053 446527 654492 746460 415556 475517 398604 792538 772694 516904 443402 567080 530999 825651 773904 727384 769223 398601 185352 420360 778556 446763 418225 194309 4324 746467 772513 739739 758302 433433 659697 704873 745336 792473 415956 609823 432477 432407 432522 386555 568559 419038 516473 384016 391739 431685 438023 469684 440681 395934 442802 440390 440951 449397 567701 692676 576351 591724 458821 398412 407491 474951 517174 489703 501348 494180 538060 813444 786982 490732 455383 410008 568728 446215 426477 800639 801439 802099 748439 767755 742598 398428 576556 580017 517589 423842 461876 203504 665443 654722 733799 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.80%) |
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 4324 131474 185352 194309 203504 384016 384415 386555 391739 395934 398412 398428 398601 398604 403870 407491 410008 412632 415556 415956 418225 419038 419053 419281 420360 423842 423890 426477 431685 432407 432477 432522 433433 433953 438023 440390 440681 440951 441334 442802 443402 444774 446088 446215 446527 446763 447797 448198 449397 451465 455383 456610 458295 458821 461876 467370 469684 474951 475517 484312 486467 489703 489791 490732 491342 492543 494180 501348 502220 510641 511161 516473 516904 517174 517500 517589 519431 530999 538060 567080 567701 568559 568728 568809 576351 576556 580017 591724 609823 654492 654722 659697 665443 692676 704873 727384 733799 739739 742598 745336 746460 746467 748439 756058 758302 767755 769223 772513 772694 773904 778556 786982 792473 792538 800639 801439 802099 803379 813444 825651 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен дрочк член"
]
|
||||||||||||||||||||||||||||||
|
2.33 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен дрочк член"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy handjob"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
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.