Query Metrics
7
Database Queries
7
Different statements
143.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.25 ms (82.56%) |
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 386316 395781 401966 411135 413742 418224 419179 424282 427493 427783 437437 437444 437705 446715 452533 457919 465556 470390 470558 475362 478394 483570 484906 490271 496688 501512 502085 508614 508767 509546 515827 520192 522518 522708 523527 525420 533840 538259 540380 546494 549565 559148 559387 560733 564242 567177 567308 569652 571700 574280 580073 585552 591005 599142 605002 615579 618032 621464 625472 627900 632144 648976 650076 660821 664519 670620 672833 674486 675169 675172 675968 679685 682932 693343 695790 697742 699844 700696 703457 703501 707506 707935 710506 711673 725425 725468 731457 732774 732929 739021 742755 744392 746525 749633 756324 756848 758510 761095 766306 768797 769077 777498 779423 786635 788048 788799 789103 791759 793497 795538 795659 797563 801552 802750 807774 808681 810157 812174 812180 817376 ] |
||||||||||||||||||||||||||||||
|
16.04 ms (11.20%) |
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 810157 812180 437705 525420 496688 567308 569652 546494 682932 571700 621464 786635 732929 769077 795659 424282 502085 509546 520192 538259 470558 475362 664519 707506 672833 693343 697742 700696 703457 632144 591005 725468 756324 801552 744392 761095 739021 756848 710506 788799 401966 437444 478394 418224 427783 457919 483570 411135 675968 386316 446715 522708 508614 523527 580073 650076 660821 695790 703501 670620 674486 675169 559148 574280 615579 807774 742755 749633 797563 812174 766306 758510 777498 791759 490271 533840 560733 567177 549565 675172 679685 707935 795538 725425 768797 508767 419179 817376 470390 522518 711673 699844 564242 779423 802750 788048 746525 427493 413742 465556 540380 484906 648976 559387 625472 585552 618032 599142 605002 793497 789103 731457 732774 627900 808681 437437 452533 501512 515827 395781 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.70%) |
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 386316 395781 401966 411135 413742 418224 419179 424282 427493 427783 437437 437444 437705 446715 452533 457919 465556 470390 470558 475362 478394 483570 484906 490271 496688 501512 502085 508614 508767 509546 515827 520192 522518 522708 523527 525420 533840 538259 540380 546494 549565 559148 559387 560733 564242 567177 567308 569652 571700 574280 580073 585552 591005 599142 605002 615579 618032 621464 625472 627900 632144 648976 650076 660821 664519 670620 672833 674486 675169 675172 675968 679685 682932 693343 695790 697742 699844 700696 703457 703501 707506 707935 710506 711673 725425 725468 731457 732774 732929 739021 742755 744392 746525 749633 756324 756848 758510 761095 766306 768797 769077 777498 779423 786635 788048 788799 789103 791759 793497 795538 795659 797563 801552 802750 807774 808681 810157 812174 812180 817376 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"came sex"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"came секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"came секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.98%) |
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.