Query Metrics
7
Database Queries
7
Different statements
428.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.88 ms (48.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
197.88 ms (46.13%) |
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 382642 388990 394158 397423 398885 399190 400032 403136 412632 416453 419316 420898 421033 422099 422140 426690 427037 429618 430862 432859 434488 435580 436649 437093 437369 437434 437950 438984 441092 445713 446656 447390 448077 449310 449502 449517 450014 450509 455547 458368 459650 461898 464233 466478 466485 475622 478370 478520 479311 487548 487633 490675 496828 498332 502765 502854 506290 513723 515570 519744 525801 533494 558048 558323 564744 568098 569594 573284 581762 593076 597519 602783 608287 624857 626437 626609 663195 703969 709914 713240 722216 727561 730504 735308 738286 740575 745229 751283 751748 760093 764071 764728 765887 769328 773313 773670 779135 782471 784743 786432 787520 787982 788874 789930 790730 791301 791500 797719 800954 802570 802805 807070 807255 807271 808100 808107 809150 812073 813009 813598 ] |
||||||||||||||||||||||||||||||
|
13.32 ms (3.10%) |
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 791301 800954 809150 751748 769328 787520 787982 789930 790730 807070 808107 727561 760093 730504 773313 764071 735308 740575 788874 797719 808100 403136 427037 397423 399190 429618 388990 438984 455547 466485 382642 422099 515570 502854 416453 458368 479311 490675 446656 487633 461898 581762 558323 569594 564744 568098 602783 626437 773670 478370 421033 437434 400032 420898 448077 475622 519744 513723 487548 496828 525801 426690 447390 533494 434488 422140 432859 436649 437369 435580 437950 813598 445713 449502 449517 450014 449310 459650 506290 502765 498332 464233 573284 703969 713240 663195 709914 722216 558048 608287 597519 624857 626609 593076 779135 791500 782471 813009 764728 784743 786432 802805 807255 738286 745229 765887 751283 802570 807271 812073 419316 450509 466478 394158 437093 478520 398885 412632 430862 441092 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (0.72%) |
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 382642 388990 394158 397423 398885 399190 400032 403136 412632 416453 419316 420898 421033 422099 422140 426690 427037 429618 430862 432859 434488 435580 436649 437093 437369 437434 437950 438984 441092 445713 446656 447390 448077 449310 449502 449517 450014 450509 455547 458368 459650 461898 464233 466478 466485 475622 478370 478520 479311 487548 487633 490675 496828 498332 502765 502854 506290 513723 515570 519744 525801 533494 558048 558323 564744 568098 569594 573284 581762 593076 597519 602783 608287 624857 626437 626609 663195 703969 709914 713240 722216 727561 730504 735308 738286 740575 745229 751283 751748 760093 764071 764728 765887 769328 773313 773670 779135 782471 784743 786432 787520 787982 788874 789930 790730 791301 791500 797719 800954 802570 802805 807070 807255 807271 808100 808107 809150 812073 813009 813598 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая orgasm"
]
|
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.