Query Metrics
7
Database Queries
7
Different statements
195.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.84 ms (90.02%) |
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 13450 383504 393422 449972 457722 463135 478357 479373 488806 497056 504828 520856 530346 530587 532034 532189 533169 533303 534097 537606 537608 538371 541282 541494 542479 543052 544711 545130 548268 548411 554846 558023 563519 563937 565148 572403 576450 577308 577610 579850 609611 631141 646662 648587 660068 681926 698916 701179 703769 717258 719978 720784 721806 723591 724325 725267 725290 727486 728910 729050 729294 730589 731623 731878 732904 732950 734786 734796 735622 735682 735812 736811 738575 738861 739381 742467 743986 744317 744762 746396 746479 748044 750775 756403 758604 759626 760761 761224 761767 772193 779663 787148 788663 793535 806030 810615 812023 812214 814761 814819 814941 817785 818672 818870 819002 819192 819454 820724 821205 821665 822712 822775 825636 826329 827684 827784 827953 ] |
||||||||||||||||||||||||||||||
|
10.59 ms (5.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 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 13450 817785 545130 554846 660068 681926 698916 719978 779663 787148 750775 731623 806030 812214 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 542479 548411 558023 576450 541282 541494 548268 572403 577610 646662 648587 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.39%) |
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 13450 383504 393422 449972 457722 463135 478357 479373 488806 497056 504828 520856 530346 530587 532034 532189 533169 533303 534097 537606 537608 538371 541282 541494 542479 543052 544711 545130 548268 548411 554846 558023 563519 563937 565148 572403 576450 577308 577610 579850 609611 631141 646662 648587 660068 681926 698916 701179 703769 717258 719978 720784 721806 723591 724325 725267 725290 727486 728910 729050 729294 730589 731623 731878 732904 732950 734786 734796 735622 735682 735812 736811 738575 738861 739381 742467 743986 744317 744762 746396 746479 748044 750775 756403 758604 759626 760761 761224 761767 772193 779663 787148 788663 793535 806030 810615 812023 812214 814761 814819 814941 817785 818672 818870 819002 819192 819454 820724 821205 821665 822712 822775 825636 826329 827684 827784 827953 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock fucking"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock fucking"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock fucking"
]
|
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.