Query Metrics
7
Database Queries
7
Different statements
181.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.50 ms (86.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 13803 35405 92019 101932 212132 212914 213429 222292 313222 383328 387874 389793 396783 397658 408620 409008 424975 426897 427062 444914 445036 454701 463398 491681 510739 514976 525305 528094 528155 530666 530794 533227 537678 538630 539189 543063 546825 551694 556940 558203 559882 568090 569220 572739 584047 585107 589958 598324 600307 605312 610923 615048 622947 641418 644462 647745 651873 652992 653649 655699 656081 657025 658400 659151 659757 659795 661005 661055 667906 670404 671421 673027 682611 692156 692756 704874 710828 711600 714531 716771 719090 720463 740637 750187 755287 764242 766266 766793 767187 774936 775209 776774 778730 778824 779376 784659 785755 787557 792458 795211 800863 806167 807381 808085 808862 810221 811689 814955 815807 815814 816517 816606 817065 817300 820933 821661 822032 822162 823400 826230 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (7.85%) |
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 774936 776774 778824 785755 787557 808862 212132 313222 213429 445036 13803 212914 35405 585107 537678 525305 514976 556940 661005 652992 622947 766266 610923 800863 427062 543063 551694 658400 659757 704874 655699 656081 659795 659151 671421 598324 792458 807381 778730 766793 755287 719090 389793 408620 651873 661055 641418 409008 424975 528094 653649 673027 600307 605312 811689 810221 764242 740637 615048 714531 716771 779376 784659 806167 383328 387874 397658 426897 454701 538630 710828 711600 589958 795211 808085 750187 767187 644462 775209 92019 444914 101932 222292 396783 815807 815814 821661 822032 816606 826230 816517 817300 820933 814955 817065 822162 823400 463398 491681 530666 533227 539189 510739 528155 530794 546825 558203 584047 559882 569220 572739 568090 667906 670404 682611 692156 692756 720463 657025 647745 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.34%) |
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 13803 35405 92019 101932 212132 212914 213429 222292 313222 383328 387874 389793 396783 397658 408620 409008 424975 426897 427062 444914 445036 454701 463398 491681 510739 514976 525305 528094 528155 530666 530794 533227 537678 538630 539189 543063 546825 551694 556940 558203 559882 568090 569220 572739 584047 585107 589958 598324 600307 605312 610923 615048 622947 641418 644462 647745 651873 652992 653649 655699 656081 657025 658400 659151 659757 659795 661005 661055 667906 670404 671421 673027 682611 692156 692756 704874 710828 711600 714531 716771 719090 720463 740637 750187 755287 764242 766266 766793 767187 774936 775209 776774 778730 778824 779376 784659 785755 787557 792458 795211 800863 806167 807381 808085 808862 810221 811689 814955 815807 815814 816517 816606 817065 817300 820933 821661 822032 822162 823400 826230 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babe ass"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babe жоп"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babe жоп"
]
|
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.