Query Metrics
7
Database Queries
7
Different statements
198.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.29 ms (87.42%) |
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 194216 388604 392789 393441 395565 400718 415623 419272 422514 424227 439650 441877 450515 453269 458058 467357 479048 480891 483139 507005 509147 522528 523516 526018 530270 539791 545522 545739 545914 550327 553949 556320 558064 561667 562523 567539 597820 603191 603214 603436 604732 608392 609568 611346 614144 615041 618568 620768 621316 630490 636811 640738 640812 650955 660963 665397 665698 667331 669206 670112 670414 671381 672140 677075 680177 681319 682489 692169 693077 704010 706909 712824 720825 721298 723580 723932 725409 730270 730299 741275 742449 744265 744328 746995 748427 753476 755219 756025 759658 771868 774000 775985 780556 780645 784259 787309 795572 798533 798864 800331 800373 800535 801952 805045 805372 807322 807610 810701 811495 811606 817432 817448 818261 818720 819588 821850 825598 827936 828068 ] |
||||||||||||||||||||||||||||||
|
15.34 ms (7.74%) |
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 800535 805372 744328 755219 774000 759658 640738 467357 458058 526018 807610 723932 553949 388604 825598 507005 545522 660963 681319 677075 680177 603214 621316 640812 603191 636811 810701 800331 800373 730299 618568 620768 424227 523516 480891 441877 530270 556320 818261 773406 393441 615041 771868 400718 453269 479048 194216 817432 828068 539791 780556 807322 780645 795572 395565 509147 483139 522528 650955 784259 415623 422514 723580 817448 821850 819588 450515 545914 562523 545739 567539 706909 665698 670112 671381 712824 665397 672140 682489 692169 693077 720825 550327 558064 614144 630490 609568 608392 604732 775985 801952 805045 811495 725409 742449 787309 811606 730270 744265 746995 756025 741275 603436 611346 704010 721298 439650 419272 748427 392789 818720 670414 667331 561667 597820 798533 798864 753476 827936 669206 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.38%) |
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 194216 388604 392789 393441 395565 400718 415623 419272 422514 424227 439650 441877 450515 453269 458058 467357 479048 480891 483139 507005 509147 522528 523516 526018 530270 539791 545522 545739 545914 550327 553949 556320 558064 561667 562523 567539 597820 603191 603214 603436 604732 608392 609568 611346 614144 615041 618568 620768 621316 630490 636811 640738 640812 650955 660963 665397 665698 667331 669206 670112 670414 671381 672140 677075 680177 681319 682489 692169 693077 704010 706909 712824 720825 721298 723580 723932 725409 730270 730299 741275 742449 744265 744328 746995 748427 753476 755219 756025 759658 771868 774000 775985 780556 780645 784259 787309 795572 798533 798864 800331 800373 800535 801952 805045 805372 807322 807610 810701 811495 811606 817432 817448 818261 818720 819588 821850 825598 827936 828068 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young handjob"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young дрочк член"
]
|
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.