Query Metrics
7
Database Queries
7
Different statements
177.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.59 ms (87.48%) |
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 391677 398907 399986 400263 402164 418665 429232 429257 455917 457618 467800 489155 490698 492016 495599 500444 510100 512647 533763 534111 536217 536825 538798 545167 547103 552159 552210 554121 557005 560984 569361 574233 577813 582648 591393 592141 594014 594063 594072 597259 599028 600439 603617 603955 610504 616573 618187 627141 628843 628948 636486 649862 654881 655184 657536 657860 674600 679296 679304 684812 690530 697462 700052 701526 702375 702382 707774 711273 713684 714080 719045 721771 723373 723935 725141 732775 734907 736022 736258 736980 738618 739318 740166 740597 743455 745804 748416 748632 748798 754205 755689 755854 758540 758560 762483 762855 763435 767381 773533 774794 775127 782387 785175 785718 785728 787936 787937 788282 788720 796789 800284 804862 805346 807886 809857 812908 812955 814419 817626 827347 ] |
||||||||||||||||||||||||||||||
|
11.95 ms (6.72%) |
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 723373 545167 560984 592141 599028 628948 597259 603955 594014 600439 610504 591393 594072 636486 788720 804862 805346 725141 736022 736980 755854 758540 758560 763435 785175 723935 732775 743455 745804 748632 754205 755689 740597 762855 739318 748416 719045 774794 775127 785718 812955 399986 429257 400263 455917 457618 391677 467800 512647 490698 495599 510100 398907 402164 827347 817626 538798 574233 582648 552210 557005 655184 679304 684812 690530 700052 702382 707774 657860 679296 697462 701526 711273 654881 657536 713684 547103 569361 577813 628843 616573 603617 594063 785728 800284 807886 809857 767381 787937 788282 796789 736258 734907 738618 748798 762483 740166 773533 618187 627141 702375 721771 782387 787936 812908 418665 429232 814419 489155 492016 536217 534111 536825 533763 500444 552159 554121 649862 674600 714080 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.49%) |
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 391677 398907 399986 400263 402164 418665 429232 429257 455917 457618 467800 489155 490698 492016 495599 500444 510100 512647 533763 534111 536217 536825 538798 545167 547103 552159 552210 554121 557005 560984 569361 574233 577813 582648 591393 592141 594014 594063 594072 597259 599028 600439 603617 603955 610504 616573 618187 627141 628843 628948 636486 649862 654881 655184 657536 657860 674600 679296 679304 684812 690530 697462 700052 701526 702375 702382 707774 711273 713684 714080 719045 721771 723373 723935 725141 732775 734907 736022 736258 736980 738618 739318 740166 740597 743455 745804 748416 748632 748798 754205 755689 755854 758540 758560 762483 762855 763435 767381 773533 774794 775127 782387 785175 785718 785728 787936 787937 788282 788720 796789 800284 804862 805346 807886 809857 812908 812955 814419 817626 827347 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"19 year"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"19 year"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"19 year"
]
|
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.