Query Metrics
7
Database Queries
7
Different statements
193.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.31 ms (88.16%) |
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 388290 391545 392554 396215 396235 397353 400026 561906 574813 585781 592357 594162 594267 594430 595446 595447 595515 596594 597552 597553 597801 598001 598451 598476 598489 598508 598712 600104 602014 604143 604259 605329 609645 610688 620554 620904 620978 629243 629598 636530 645202 653229 659324 659432 660342 662047 662204 663231 669288 671660 686387 692259 695264 696107 696111 709037 712174 718656 718693 719640 720386 720388 721417 721424 722782 722899 725133 730764 731984 735085 735112 735930 736682 736887 737298 737553 738818 740373 740651 742188 743391 744270 746423 747402 747447 747574 749328 752673 752725 753155 753302 753800 753911 758887 760942 761482 765278 765573 766788 766844 771134 772991 777138 779010 781052 786522 786963 788540 792485 793663 794809 795858 796731 797389 799785 799862 800575 805669 810210 812288 ] |
||||||||||||||||||||||||||||||
|
12.05 ms (6.24%) |
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 722899 645202 653229 659432 662204 669288 671660 692259 695264 696107 696111 709037 720386 721424 659324 660342 662047 663231 686387 720388 721417 561906 574813 585781 596594 597552 597801 604143 610688 620554 629598 595446 595447 597553 598001 598451 598476 598489 602014 605329 620904 620978 594267 598508 636530 592357 594162 594430 595515 598712 600104 604259 779010 786963 795858 796731 800575 781052 799785 799862 725133 730764 735930 737553 740373 740651 743391 752673 753302 753800 761482 772991 788540 792485 793663 794809 805669 812288 736887 744270 752725 735085 735112 736682 737298 747574 753911 758887 760942 765278 765573 731984 738818 742188 747402 766844 746423 747447 749328 753155 766788 771134 609645 629243 712174 718656 718693 719640 722782 777138 786522 797389 810210 388290 391545 392554 396215 396235 397353 400026 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.64%) |
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 388290 391545 392554 396215 396235 397353 400026 561906 574813 585781 592357 594162 594267 594430 595446 595447 595515 596594 597552 597553 597801 598001 598451 598476 598489 598508 598712 600104 602014 604143 604259 605329 609645 610688 620554 620904 620978 629243 629598 636530 645202 653229 659324 659432 660342 662047 662204 663231 669288 671660 686387 692259 695264 696107 696111 709037 712174 718656 718693 719640 720386 720388 721417 721424 722782 722899 725133 730764 731984 735085 735112 735930 736682 736887 737298 737553 738818 740373 740651 742188 743391 744270 746423 747402 747447 747574 749328 752673 752725 753155 753302 753800 753911 758887 760942 761482 765278 765573 766788 766844 771134 772991 777138 779010 781052 786522 786963 788540 792485 793663 794809 795858 796731 797389 799785 799862 800575 805669 810210 812288 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2023 teen"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.