Query Metrics
7
Database Queries
7
Different statements
181.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.27 ms (87.11%) |
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 517437 531285 533758 533768 534044 534046 534127 537378 538239 543625 543662 543682 543685 543715 543763 545535 545878 546178 546231 547037 549610 551937 552620 558262 566481 579089 590652 595405 595428 597218 597500 597828 598053 598074 598527 609194 614008 617653 619908 642095 650292 651715 661523 661908 663840 672518 673439 675885 679541 683299 683715 685429 688544 695093 696199 696781 699005 704169 712967 713758 715298 717654 717725 720641 721423 721593 721849 722313 723912 725474 731168 731669 732171 740632 741010 741389 742916 743025 743051 743711 743812 747010 753665 760335 760466 761643 761896 762298 764142 764662 766162 766220 767972 768096 768703 768709 769136 769196 773164 778206 778217 778548 782030 783658 784697 786094 790268 790770 791139 792521 793939 795359 796785 799840 802893 804888 805090 805140 809958 811141 ] |
||||||||||||||||||||||||||||||
|
13.23 ms (7.28%) |
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 534046 517437 533768 534044 534127 537378 538239 531285 533758 543625 549610 551937 579089 543662 543682 543763 558262 566481 543685 543715 545535 545878 546231 650292 675885 683299 695093 715298 720641 721423 721849 651715 661523 661908 673439 685429 688544 696199 696781 704169 712967 663840 672518 679541 683715 699005 721593 722313 546178 547037 552620 597218 598053 598074 598527 614008 595405 619908 590652 595428 597500 597828 778548 782030 783658 790268 796785 805090 805140 793939 795359 799840 811141 723912 725474 731669 741010 743051 760335 762298 769136 769196 773164 790770 791139 792521 802893 804888 809958 741389 747010 760466 766220 768703 731168 740632 761896 764142 764662 766162 767972 732171 742916 743025 743711 753665 768709 743812 761643 768096 609194 617653 642095 713758 717654 717725 778206 778217 784697 786094 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.33%) |
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 517437 531285 533758 533768 534044 534046 534127 537378 538239 543625 543662 543682 543685 543715 543763 545535 545878 546178 546231 547037 549610 551937 552620 558262 566481 579089 590652 595405 595428 597218 597500 597828 598053 598074 598527 609194 614008 617653 619908 642095 650292 651715 661523 661908 663840 672518 673439 675885 679541 683299 683715 685429 688544 695093 696199 696781 699005 704169 712967 713758 715298 717654 717725 720641 721423 721593 721849 722313 723912 725474 731168 731669 732171 740632 741010 741389 742916 743025 743051 743711 743812 747010 753665 760335 760466 761643 761896 762298 764142 764662 766162 766220 767972 768096 768703 768709 769136 769196 773164 778206 778217 778548 782030 783658 784697 786094 790268 790770 791139 792521 793939 795359 796785 799840 802893 804888 805090 805140 809958 811141 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русскому"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.97%) |
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.