Query Metrics
7
Database Queries
7
Different statements
192.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.62 ms (86.78%) |
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 383504 393422 449972 457722 463135 478357 479373 488806 497056 504828 520856 530346 530587 532034 532189 533169 533303 534097 537606 537608 538371 543052 544711 545130 554846 563519 563937 565148 577308 579850 609611 631141 660068 681926 685757 691050 701179 703769 717258 720784 721806 723591 724325 724681 725267 725290 727486 728910 729050 729294 730589 731878 732904 732950 733318 734565 734786 734796 735237 735622 735682 735812 736167 736374 736811 738147 738575 738861 739087 739381 740741 742467 743911 743986 744317 744762 746396 746479 748044 750775 756403 758604 759626 760213 760761 761224 761767 766095 772193 772960 779663 788643 788651 788663 790669 793535 806030 810615 812023 814761 814819 814941 818672 818870 819002 819192 819454 820724 821205 821665 822712 822775 825636 826329 827684 827784 827953 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (7.42%) |
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 733318 734565 735237 736167 736374 738147 739087 740741 743911 760213 766095 772960 788643 788651 790669 724681 725290 728910 729050 729294 730589 735622 744762 746396 748044 725267 732950 734796 736811 738575 742467 758604 759626 724325 727486 731878 732904 734786 735682 735812 739381 743986 744317 746479 760761 761224 761767 772193 738861 756403 609611 631141 701179 703769 717258 720784 721806 721975 788663 793535 810615 812023 393422 545130 554846 660068 681926 685757 691050 779663 750775 806030 383504 814761 818870 819002 723591 814941 818672 819454 822056 826329 814819 819192 820724 821205 821665 822712 822775 825636 827953 827784 827684 479373 488806 449972 457722 478357 463135 533303 534097 538371 497056 504828 530346 530587 532189 537606 537608 520856 532034 533169 535845 543052 544711 563519 563937 565148 577308 579850 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.60%) |
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 383504 393422 449972 457722 463135 478357 479373 488806 497056 504828 520856 530346 530587 532034 532189 533169 533303 534097 537606 537608 538371 543052 544711 545130 554846 563519 563937 565148 577308 579850 609611 631141 660068 681926 685757 691050 701179 703769 717258 720784 721806 723591 724325 724681 725267 725290 727486 728910 729050 729294 730589 731878 732904 732950 733318 734565 734786 734796 735237 735622 735682 735812 736167 736374 736811 738147 738575 738861 739087 739381 740741 742467 743911 743986 744317 744762 746396 746479 748044 750775 756403 758604 759626 760213 760761 761224 761767 766095 772193 772960 779663 788643 788651 788663 790669 793535 806030 810615 812023 814761 814819 814941 818672 818870 819002 819192 819454 820724 821205 821665 822712 822775 825636 826329 827684 827784 827953 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking cock"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking cock"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking cock"
]
|
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.