Query Metrics
7
Database Queries
7
Different statements
248.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
223.04 ms (89.76%) |
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 12331 39356 117221 123994 187567 250457 314541 326305 362000 383297 383609 385745 391686 392048 393039 393313 393672 395408 395654 396262 396748 397805 398281 400450 404120 404216 405176 405712 408547 411451 417421 417701 418690 419410 420760 426431 430298 430800 431234 432789 445206 445567 448321 452288 461585 462878 462907 465543 469689 476198 476753 489523 491776 492147 492788 494601 509975 519001 526105 526503 529963 541965 554472 560224 565053 568355 569122 571598 573298 576728 601102 604350 604690 605606 605680 607631 609812 621174 624220 640776 651606 662826 665392 668370 672579 674100 677934 686057 689665 695872 697150 699608 702954 703435 706541 709994 711899 715102 717899 719058 722848 728225 734505 740965 745363 746157 756012 759574 761619 770929 771141 775492 775895 775978 779860 787632 788107 801640 804813 811630 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (6.34%) |
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 775895 770929 771141 740965 722848 404216 39356 385745 526105 573298 391686 418690 560224 677934 674100 686057 703435 787632 804813 417701 432789 445206 461585 601102 383609 746157 526503 393672 430298 476198 519001 462907 565053 665392 695872 697150 715102 576728 607631 621174 801640 745363 445567 431234 494601 775492 395408 408547 420760 393039 419410 699608 719058 426431 405176 491776 123994 117221 717899 672579 702954 788107 187567 12331 509975 711899 640776 759574 775978 400450 395654 448321 476753 393313 492147 529963 571598 706541 568355 605680 728225 761619 250457 383297 452288 668370 314541 396262 396748 397805 398281 411451 430800 462878 469689 465543 541965 569122 651606 689665 709994 604690 604350 756012 624220 811630 326305 417421 362000 405712 662826 605606 779860 734505 404120 392048 489523 492788 554472 609812 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.05%) |
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 12331 39356 117221 123994 187567 250457 314541 326305 362000 383297 383609 385745 391686 392048 393039 393313 393672 395408 395654 396262 396748 397805 398281 400450 404120 404216 405176 405712 408547 411451 417421 417701 418690 419410 420760 426431 430298 430800 431234 432789 445206 445567 448321 452288 461585 462878 462907 465543 469689 476198 476753 489523 491776 492147 492788 494601 509975 519001 526105 526503 529963 541965 554472 560224 565053 568355 569122 571598 573298 576728 601102 604350 604690 605606 605680 607631 609812 621174 624220 640776 651606 662826 665392 668370 672579 674100 677934 686057 689665 695872 697150 699608 702954 703435 706541 709994 711899 715102 717899 719058 722848 728225 734505 740965 745363 746157 756012 759574 761619 770929 771141 775492 775895 775978 779860 787632 788107 801640 804813 811630 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde teen fuck"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая teen секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая teen секс"
]
|
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.