Query Metrics
7
Database Queries
7
Different statements
381.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.45 ms (54.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
146.81 ms (38.47%) |
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 390197 390275 391317 398853 401949 402768 402870 408776 408787 408841 415203 416951 420720 424006 424764 426635 426687 443749 443863 444192 451679 458627 463815 466057 467817 469906 470510 471552 472352 473975 473995 482073 488489 491071 491085 491143 492770 495606 496449 505905 507356 509036 509426 509448 510380 512312 513724 518330 522535 522814 523276 523286 523660 524727 524748 528389 528808 528809 529606 536173 538214 538556 539092 540698 541726 542158 543664 544106 544939 547377 552166 552190 552218 555658 560874 562278 562322 563663 565707 569883 570270 570314 570641 571544 572073 572089 572475 579105 580676 582530 597040 598607 654810 655063 655391 656064 656372 656406 657104 657388 660503 660535 660934 678625 717722 743443 818024 818026 818040 819890 819895 819973 821802 823911 824290 824397 825592 826674 828738 ] |
||||||||||||||||||||||||||||||
|
16.52 ms (4.33%) |
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 415203 482073 505905 509448 528809 495606 513724 523276 496449 518330 528389 509036 523660 524748 528808 538214 491071 597040 473995 473975 470510 469906 509426 463815 579105 398853 401949 426635 443863 819895 552190 562278 580676 570270 572475 656372 660535 678625 655063 656406 657104 654810 655391 656064 657388 660503 660934 717722 570641 598607 743443 390275 408776 424006 426687 471552 391317 402768 402870 408841 458627 466057 420720 424764 472352 416951 444192 443749 451679 467817 523286 512312 524727 492770 510380 522814 488489 491085 491143 522535 390197 408787 818026 818040 821802 826674 818024 819973 823911 819890 824290 824397 825195 825592 828738 507356 529606 539092 538556 540698 536173 543664 544939 547377 552166 562322 563663 569883 570314 571544 572089 542158 544106 552218 555658 560874 565707 572073 582530 541726 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (0.83%) |
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 390197 390275 391317 398853 401949 402768 402870 408776 408787 408841 415203 416951 420720 424006 424764 426635 426687 443749 443863 444192 451679 458627 463815 466057 467817 469906 470510 471552 472352 473975 473995 482073 488489 491071 491085 491143 492770 495606 496449 505905 507356 509036 509426 509448 510380 512312 513724 518330 522535 522814 523276 523286 523660 524727 524748 528389 528808 528809 529606 536173 538214 538556 539092 540698 541726 542158 543664 544106 544939 547377 552166 552190 552218 555658 560874 562278 562322 563663 565707 569883 570270 570314 570641 571544 572073 572089 572475 579105 580676 582530 597040 598607 654810 655063 655391 656064 656372 656406 657104 657388 660503 660535 660934 678625 717722 743443 818024 818026 818040 819890 819895 819973 821802 823911 824290 824397 825592 826674 828738 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian 2023 skinny"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск худые"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.