Query Metrics
7
Database Queries
7
Different statements
420.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.85 ms (51.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член парен"
]
|
||||||||||||||||||||||||||||||
|
178.98 ms (42.52%) |
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 185352 187349 194309 203504 384016 384415 386555 389065 395934 398604 403870 407491 410008 415556 418225 419038 420360 420524 423842 423890 426477 429611 431685 432379 432477 432522 432526 432569 433433 438023 439721 440390 440681 441334 442802 444373 446088 446215 446527 446763 448429 449397 450690 451465 455383 458821 459157 460107 462954 463289 467370 470571 473206 474951 475213 475517 478662 486467 489791 490732 491342 491494 492543 500890 501348 511161 511609 512720 515324 516473 516904 517174 517500 517589 519431 524115 530999 538060 548555 567080 567701 568728 568809 574022 576351 576556 580017 583426 591724 609823 654492 659697 692676 704873 727384 739690 739700 739739 742598 745336 746460 746467 748439 756058 758302 767755 769223 772513 772694 773904 778556 784913 786982 792538 801439 803379 808698 813444 825651 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (3.88%) |
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 432379 524115 470571 462954 511609 512720 475213 463289 808698 739690 739700 448429 515324 450690 444373 459157 460107 548555 473206 478662 784913 432569 432526 511161 500890 517500 492543 486467 803379 489791 384415 441334 491342 446088 467370 519431 491494 423890 568809 420524 451465 756058 403870 446527 654492 746460 415556 475517 187349 398604 792538 772694 516904 574022 567080 530999 825651 773904 727384 769223 185352 420360 778556 446763 418225 194309 4324 746467 772513 739739 758302 389065 433433 659697 704873 745336 609823 432477 432522 386555 419038 516473 384016 431685 438023 440681 395934 442802 429611 440390 449397 583426 567701 692676 576351 591724 458821 407491 474951 517174 501348 538060 813444 439721 786982 490732 455383 410008 568728 446215 426477 801439 748439 767755 742598 576556 580017 517589 423842 203504 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (0.87%) |
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 185352 187349 194309 203504 384016 384415 386555 389065 395934 398604 403870 407491 410008 415556 418225 419038 420360 420524 423842 423890 426477 429611 431685 432379 432477 432522 432526 432569 433433 438023 439721 440390 440681 441334 442802 444373 446088 446215 446527 446763 448429 449397 450690 451465 455383 458821 459157 460107 462954 463289 467370 470571 473206 474951 475213 475517 478662 486467 489791 490732 491342 491494 492543 500890 501348 511161 511609 512720 515324 516473 516904 517174 517500 517589 519431 524115 530999 538060 548555 567080 567701 568728 568809 574022 576351 576556 580017 583426 591724 609823 654492 659697 692676 704873 727384 739690 739700 739739 742598 745336 746460 746467 748439 756058 758302 767755 769223 772513 772694 773904 778556 784913 786982 792538 801439 803379 808698 813444 825651 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член парен"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob boy"
]
|
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.