Query Metrics
7
Database Queries
7
Different statements
211.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.84 ms (89.23%) |
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 11870 21109 39356 325922 386095 386893 388764 389319 389676 390321 397417 397641 397688 398195 398665 402473 403195 413739 413769 427246 512295 530476 537910 537929 560637 579872 594355 594366 594473 595423 595440 595513 597499 598474 600112 604323 620907 625580 634540 635061 637447 654401 664277 668370 673534 677366 684455 696400 697458 699026 699505 701850 705798 713320 715396 719180 720102 720418 720465 720793 721390 722603 722712 725021 727854 729703 732261 737971 740710 742223 743180 743385 745081 746432 746803 747410 747716 748327 748434 749702 752761 753269 753277 753316 753348 753368 753369 753397 753398 753404 753422 753885 756827 758740 760909 763061 765730 766461 766810 766897 766959 770431 771901 772860 775909 776216 777026 782446 786294 787755 788414 791770 797104 804228 807531 807532 809757 810039 823721 ] |
||||||||||||||||||||||||||||||
|
11.90 ms (5.62%) |
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 699505 713320 719180 721390 722603 668370 673534 696400 720102 720793 654401 664277 677366 684455 697458 720465 722712 560637 579872 594355 597499 598474 635061 637447 594366 594473 595440 600112 620907 595423 595513 604323 625580 776216 787755 788414 775909 782446 804228 725021 740710 743180 743385 753277 753316 758740 766461 766959 772860 791770 797104 807532 810039 732261 747716 748327 753269 753368 753404 753422 760909 763061 766810 766897 770352 770431 727854 742223 745081 746432 748434 756827 765730 746803 747410 752761 753348 753369 753397 753885 729703 737971 749702 753398 771901 634540 699026 701850 705798 715396 720418 777026 786294 807531 809757 325922 390321 397417 403195 397688 21109 389676 388764 537929 530476 537910 427246 512295 386095 39356 11870 389319 386893 397641 398195 398665 402473 413739 413769 823721 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.48%) |
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 11870 21109 39356 325922 386095 386893 388764 389319 389676 390321 397417 397641 397688 398195 398665 402473 403195 413739 413769 427246 512295 530476 537910 537929 560637 579872 594355 594366 594473 595423 595440 595513 597499 598474 600112 604323 620907 625580 634540 635061 637447 654401 664277 668370 673534 677366 684455 696400 697458 699026 699505 701850 705798 713320 715396 719180 720102 720418 720465 720793 721390 722603 722712 725021 727854 729703 732261 737971 740710 742223 743180 743385 745081 746432 746803 747410 747716 748327 748434 749702 752761 753269 753277 753316 753348 753368 753369 753397 753398 753404 753422 753885 756827 758740 760909 763061 765730 766461 766810 766897 766959 770431 771901 772860 775909 776216 777026 782446 786294 787755 788414 791770 797104 804228 807531 807532 809757 810039 823721 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2024 teen"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen"
]
|
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.