Query Metrics
7
Database Queries
7
Different statements
145.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.27 ms (84.10%) |
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 508602 515024 518860 529694 530567 530568 532623 532845 533898 535706 536295 536324 536447 536467 537078 537318 538911 539622 539802 542273 543747 545071 545535 548065 548399 551837 556601 558000 570891 571733 574395 574996 577779 582472 585310 585434 589191 591967 592406 592498 593317 594067 594552 599765 600486 602585 604882 607143 608151 617978 618292 618681 618867 619638 623633 627363 627951 628570 628635 639647 643645 644710 649955 660442 663937 663960 663970 664804 665081 665103 665237 665263 665277 665421 665894 666779 666836 667216 667295 667365 667627 667889 668899 669755 669758 670512 690048 695358 695417 697496 698158 701212 702154 704097 710926 714388 715472 716493 718396 720275 815398 819350 819630 820374 823878 824173 824832 824961 825885 826194 826197 827657 827665 827679 828008 828310 828373 828443 828604 828810 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (9.27%) |
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 820374 824173 824832 825885 826197 815398 819350 819630 823878 824961 826194 828310 828810 828008 828373 827657 827665 827679 828604 828443 515024 537078 539802 518860 532845 536324 536467 537318 538911 539622 530567 533898 535706 536295 536447 508602 529694 530568 532623 542273 543747 551837 556601 574395 574996 577779 582472 545535 548399 558000 649955 665263 667365 690048 695358 697496 710926 715472 720275 660442 664804 665081 665103 665277 665894 666836 667216 667295 668899 701212 704097 714388 718396 663937 663960 663970 665237 665421 666779 667627 667889 669755 669758 670512 695417 698158 702154 716493 545071 548065 570891 571733 585310 599765 600486 602585 608151 617978 628635 644710 591967 592406 592498 593317 604882 627363 643645 585434 594067 618292 619638 627951 589191 594552 607143 618681 618867 623633 628570 639647 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.65%) |
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 508602 515024 518860 529694 530567 530568 532623 532845 533898 535706 536295 536324 536447 536467 537078 537318 538911 539622 539802 542273 543747 545071 545535 548065 548399 551837 556601 558000 570891 571733 574395 574996 577779 582472 585310 585434 589191 591967 592406 592498 593317 594067 594552 599765 600486 602585 604882 607143 608151 617978 618292 618681 618867 619638 623633 627363 627951 628570 628635 639647 643645 644710 649955 660442 663937 663960 663970 664804 665081 665103 665237 665263 665277 665421 665894 666779 666836 667216 667295 667365 667627 667889 668899 669755 669758 670512 690048 695358 695417 697496 698158 701212 702154 704097 710926 714388 715472 716493 718396 720275 815398 819350 819630 820374 823878 824173 824832 824961 825885 826194 826197 827657 827665 827679 828008 828310 828373 828443 828604 828810 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy tits chubby"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy сиськ chubby"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy сиськ chubby"
]
|
||||||||||||||||||||||||||||||
|
1.56 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.