Query Metrics
7
Database Queries
7
Different statements
413.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.68 ms (50.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old cum"
]
|
||||||||||||||||||||||||||||||
|
180.37 ms (43.57%) |
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 124361 388647 388739 389310 391761 395427 397542 399223 400718 401037 401960 401996 407700 409408 413472 413474 422618 426129 428079 439200 443468 445667 452369 462510 477097 483108 484129 515138 537849 550377 550443 558320 560186 562514 563425 568578 574236 580326 588312 591720 592141 597929 600204 601871 612207 612925 622531 622565 622923 626330 626461 628948 644956 652667 658224 658225 663192 671523 671832 674087 680794 686210 693410 694034 708347 713156 714167 717222 717845 719124 719918 720818 721487 722677 722717 725211 727393 730317 730758 733598 737070 738260 738353 738756 743933 743952 747944 749733 755380 756074 759906 770980 771104 788151 788672 789957 790256 790896 792765 798359 804689 805197 807669 807674 809705 811019 811528 811909 812038 813904 814257 815027 816561 818915 819584 822042 823682 825499 826182 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (3.49%) |
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 807669 807674 811909 725211 730317 756074 727393 759906 770980 733598 738260 743933 755380 771104 738353 743952 717222 719124 804689 811528 812038 484129 550443 580326 515138 397542 401960 426129 413474 644956 819584 816561 818915 823682 825499 452369 671832 674087 686210 722677 652667 708347 720818 601871 626461 588312 622923 600204 622531 612207 612925 622565 788151 788672 790256 789957 792765 798359 809705 811019 749733 766889 730758 737070 738756 747944 719918 790896 805197 400718 409408 443468 407700 391761 401037 462510 477097 124361 395427 388739 389310 388647 399223 401996 422618 413472 428079 439200 814257 826182 813904 815027 822042 445667 537849 483108 558320 550377 563425 574236 663192 671523 680794 693410 694034 714167 658224 713156 722717 658225 717845 721487 560186 562514 568578 592141 597929 628948 591720 626330 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (0.69%) |
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 124361 388647 388739 389310 391761 395427 397542 399223 400718 401037 401960 401996 407700 409408 413472 413474 422618 426129 428079 439200 443468 445667 452369 462510 477097 483108 484129 515138 537849 550377 550443 558320 560186 562514 563425 568578 574236 580326 588312 591720 592141 597929 600204 601871 612207 612925 622531 622565 622923 626330 626461 628948 644956 652667 658224 658225 663192 671523 671832 674087 680794 686210 693410 694034 708347 713156 714167 717222 717845 719124 719918 720818 721487 722677 722717 725211 727393 730317 730758 733598 737070 738260 738353 738756 743933 743952 747944 749733 755380 756074 759906 770980 771104 788151 788672 789957 790256 790896 792765 798359 804689 805197 807669 807674 809705 811019 811528 811909 812038 813904 814257 815027 816561 818915 819584 822042 823682 825499 826182 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old cum"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old cum"
]
|
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.