Query Metrics
7
Database Queries
7
Different statements
208.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.79 ms (87.19%) |
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 6739 8824 24374 112637 224590 343398 367863 381757 383225 383701 385059 385632 386994 387180 392915 394447 394543 394780 396566 396791 397023 398395 400985 402948 419353 420319 422406 427035 438051 454891 457205 458068 458423 461468 467847 468028 474224 479229 500738 503911 512657 519249 523690 528740 596500 615444 629445 634385 703308 711514 721900 723738 726704 727329 727450 731703 733161 734996 735965 736088 737976 738573 739954 740859 743757 744240 744243 747376 749993 751384 751974 752173 755751 756972 757587 757843 758392 758394 758416 758547 759728 761586 761904 762144 762145 764691 764880 766205 767557 769105 772585 772962 779273 779889 780294 780510 781640 782403 783958 783993 784232 785457 785771 786030 786772 789800 791481 792371 793777 794909 800831 801503 804846 808760 810639 810941 811411 811658 814034 814666 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (7.34%) |
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 779889 780294 782403 783993 784232 786030 791481 792371 800831 804846 808760 810639 811411 727329 727450 740859 744240 747376 752173 757843 758394 758547 785457 786772 793777 794909 810941 811658 749993 751384 751974 756972 759728 762145 766205 772585 772962 723738 726704 734996 736088 738573 755751 758392 758416 761904 762144 769105 733161 735965 744243 767557 731703 737976 739954 743757 757587 761586 764691 764880 634385 703308 711514 721900 779273 780510 781640 783958 785771 789800 801503 383701 402948 458068 397023 6739 383225 112637 367863 387180 396791 398395 400985 454891 461468 467847 224590 385059 385632 420319 523690 500738 503911 512657 615444 596500 629445 519249 394447 394543 394780 392915 381757 343398 24374 8824 386994 396566 419353 427035 438051 422406 814034 814666 457205 474224 458423 468028 479229 528740 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (1.95%) |
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 6739 8824 24374 112637 224590 343398 367863 381757 383225 383701 385059 385632 386994 387180 392915 394447 394543 394780 396566 396791 397023 398395 400985 402948 419353 420319 422406 427035 438051 454891 457205 458068 458423 461468 467847 468028 474224 479229 500738 503911 512657 519249 523690 528740 596500 615444 629445 634385 703308 711514 721900 723738 726704 727329 727450 731703 733161 734996 735965 736088 737976 738573 739954 740859 743757 744240 744243 747376 749993 751384 751974 752173 755751 756972 757587 757843 758392 758394 758416 758547 759728 761586 761904 762144 762145 764691 764880 766205 767557 769105 772585 772962 779273 779889 780294 780510 781640 782403 783958 783993 784232 785457 785771 786030 786772 789800 791481 792371 793777 794909 800831 801503 804846 808760 810639 810941 811411 811658 814034 814666 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"комната"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"комнат"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
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.