Query Metrics
7
Database Queries
7
Different statements
195.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.44 ms (85.35%) |
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 382081 382744 382948 420135 420201 429125 431702 443843 445972 447358 454899 462230 463747 467085 470960 471005 471014 471031 473096 474475 474691 475682 476153 478516 483792 484221 485673 486475 490592 500690 502022 508103 510916 522193 529372 538927 545246 551993 556382 557228 561725 562109 568051 571049 571050 572121 578178 584974 586422 588615 588811 591955 593431 595705 596039 597725 600583 600830 601695 605145 606345 611066 612211 613002 618456 619420 622626 623265 623840 625699 628558 644234 661540 661693 667395 672743 679146 683559 694619 694638 697298 701059 702634 709810 709871 710182 713251 718994 719143 719159 719193 720183 726457 726459 726860 728995 729798 730339 736376 742310 743231 743236 743262 743272 744801 744807 749593 750514 774186 774665 792763 802273 803189 810498 810504 811942 813575 818408 825459 ] |
||||||||||||||||||||||||||||||
|
16.63 ms (8.53%) |
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 661540 728995 588615 571049 462230 618456 667395 571050 818408 744801 744807 485673 701059 420135 572121 719193 672743 713251 522193 718994 719159 803189 810498 726860 736376 606345 475682 382948 471005 611066 810504 743262 743272 749593 710182 622626 792763 454899 545246 463747 471031 556382 702634 623840 720183 613002 774665 726457 726459 730339 471014 709810 601695 557228 679146 597725 467085 478516 584974 484221 508103 623265 802273 811942 743236 774186 476153 474691 593431 470960 490592 568051 683559 644234 600830 596039 431702 486475 510916 825459 826420 538927 500690 551993 619420 562109 382744 445972 473096 529372 561725 694619 694638 697298 628558 588811 612211 750514 729798 709871 719143 443843 420201 578178 813575 382081 483792 502022 743231 742310 474475 429125 661693 586422 591955 595705 600583 605145 625699 447358 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.16%) |
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 382081 382744 382948 420135 420201 429125 431702 443843 445972 447358 454899 462230 463747 467085 470960 471005 471014 471031 473096 474475 474691 475682 476153 478516 483792 484221 485673 486475 490592 500690 502022 508103 510916 522193 529372 538927 545246 551993 556382 557228 561725 562109 568051 571049 571050 572121 578178 584974 586422 588615 588811 591955 593431 595705 596039 597725 600583 600830 601695 605145 606345 611066 612211 613002 618456 619420 622626 623265 623840 625699 628558 644234 661540 661693 667395 672743 679146 683559 694619 694638 697298 701059 702634 709810 709871 710182 713251 718994 719143 719159 719193 720183 726457 726459 726860 728995 729798 730339 736376 742310 743231 743236 743262 743272 744801 744807 749593 750514 774186 774665 792763 802273 803189 810498 810504 811942 813575 818408 825459 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy small hair"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая маленькая hair"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая маленькая hair"
]
|
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.