Query Metrics
7
Database Queries
7
Different statements
149.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.18 ms (83.08%) |
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 7206 53768 118258 119495 233915 381944 385838 387352 389124 391572 391760 392055 392075 392554 394208 397852 404247 411116 420736 424146 436938 443950 444129 444236 455242 458360 466078 468879 470816 474215 477633 485645 485971 488961 491125 494835 498171 505240 509519 512777 525283 531554 533647 533675 533752 533766 533778 534084 537981 539374 543566 543572 543619 543642 543694 543703 543704 543710 543711 543724 543738 543741 543762 543973 545527 546685 546876 547982 558343 558925 558926 561255 571419 576127 578937 579124 590416 590420 595373 595521 597475 621358 654083 662780 663330 663546 663740 683287 686397 689225 694175 695210 700272 701400 714560 716591 721603 736185 736842 736845 742919 742938 743508 746800 757774 762273 766510 768290 768463 773638 778363 778657 779328 780450 784313 789090 790783 799909 799910 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (10.06%) |
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 391760 443950 458360 468879 470816 7206 233915 118258 391572 509519 392075 53768 485645 466078 512777 533778 533675 533752 533766 543741 543703 543724 543762 561255 543619 543710 546685 558926 689225 686397 694175 700272 654083 683287 695210 716591 545527 579124 590420 595373 621358 590416 597475 778363 784313 778657 779328 799910 742919 742938 773638 799909 757774 768290 743508 746800 768463 736185 736842 736845 766510 762273 701400 714560 721603 789090 790783 411116 397852 119495 392055 381944 424146 485971 477633 534084 546876 558343 571419 663740 595521 392554 394208 387352 404247 444129 444236 436938 455242 498171 488961 491125 780450 663546 389124 385838 420736 474215 494835 539374 531554 525283 505240 533647 537981 543566 543572 543694 547982 543642 543704 543711 558925 584655 543738 543973 576127 578937 662780 663330 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.86%) |
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 7206 53768 118258 119495 233915 381944 385838 387352 389124 391572 391760 392055 392075 392554 394208 397852 404247 411116 420736 424146 436938 443950 444129 444236 455242 458360 466078 468879 470816 474215 477633 485645 485971 488961 491125 494835 498171 505240 509519 512777 525283 531554 533647 533675 533752 533766 533778 534084 537981 539374 543566 543572 543619 543642 543694 543703 543704 543710 543711 543724 543738 543741 543762 543973 545527 546685 546876 547982 558343 558925 558926 561255 571419 576127 578937 579124 590416 590420 595373 595521 597475 621358 654083 662780 663330 663546 663740 683287 686397 689225 694175 695210 700272 701400 714560 716591 721603 736185 736842 736845 742919 742938 743508 746800 757774 762273 766510 768290 768463 773638 778363 778657 779328 780450 784313 789090 790783 799909 799910 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2023 russian"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
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.