Query Metrics
7
Database Queries
7
Different statements
239.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.21 ms (90.00%) |
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 392632 394154 395310 400947 401135 401993 403904 414222 417721 427252 428639 429323 434709 441567 462804 497874 514794 514892 515291 523190 529061 536245 543162 552397 561012 583082 592336 595478 595497 597029 597798 597823 598012 598135 598544 598754 600146 603052 611930 620805 621081 624170 633870 636049 639552 640390 640466 642687 650230 652955 656579 656593 657143 658728 659329 660338 662148 671665 671670 672070 672780 675001 680230 683092 691217 694492 696160 699403 707088 712583 714567 717890 718687 719376 720223 720362 720397 721302 721851 722538 722628 722649 722834 725405 725549 729160 730346 736959 741529 742833 742942 744907 747443 747498 747519 749329 750316 750727 753340 753818 753898 754180 755634 756073 758983 761778 763493 769802 770295 777056 779706 785582 795684 795859 800587 805961 806331 807519 814228 821132 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (5.68%) |
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 514892 598012 592336 462804 428639 401993 514794 523190 675001 497874 642687 814228 821132 515291 536245 529061 561012 543162 552397 583082 650230 656579 657143 658728 671665 707088 712583 720362 720397 722628 652955 662148 672070 672780 694492 696160 717890 719376 720223 656593 659329 660338 671670 680230 683092 691217 722538 722649 597798 597823 603052 636049 640466 595478 595497 600146 620805 633870 598544 621081 597029 598135 598754 624170 639552 795859 805961 807519 777056 785582 795684 725405 742833 747519 750316 753818 754180 755634 769802 806331 741529 744907 761778 730346 747443 749329 753898 725549 742942 750727 763493 770295 729160 736959 747498 753340 756073 758983 611930 640390 699403 714567 718687 721302 721851 722834 779706 800587 394154 395310 392632 400947 401135 403904 434709 414222 427252 441567 417721 429323 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (1.47%) |
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 392632 394154 395310 400947 401135 401993 403904 414222 417721 427252 428639 429323 434709 441567 462804 497874 514794 514892 515291 523190 529061 536245 543162 552397 561012 583082 592336 595478 595497 597029 597798 597823 598012 598135 598544 598754 600146 603052 611930 620805 621081 624170 633870 636049 639552 640390 640466 642687 650230 652955 656579 656593 657143 658728 659329 660338 662148 671665 671670 672070 672780 675001 680230 683092 691217 694492 696160 699403 707088 712583 714567 717890 718687 719376 720223 720362 720397 721302 721851 722538 722628 722649 722834 725405 725549 729160 730346 736959 741529 742833 742942 744907 747443 747498 747519 749329 750316 750727 753340 753818 753898 754180 755634 756073 758983 761778 763493 769802 770295 777056 779706 785582 795684 795859 800587 805961 806331 807519 814228 821132 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big but teen"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие teen"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие teen"
]
|
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.