Query Metrics
7
Database Queries
7
Different statements
158.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.90 ms (85.23%) |
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 8900 294327 394433 413123 424764 431702 461683 467046 468284 471042 471043 475682 476836 490634 510947 536468 536567 538696 539348 539352 562145 566679 570127 574440 578202 583937 584383 588748 590496 591904 598321 602222 605628 607213 607434 615260 619620 629529 650146 650610 665419 665456 666070 666111 666114 666130 681621 697175 697219 700804 710847 715935 716293 718498 718570 719100 720455 724768 725243 725395 726457 728381 728629 730297 732977 735391 735976 736044 736090 738292 740457 740662 744182 744208 744773 744989 746044 746109 749567 754770 756538 756620 758923 759701 760485 768153 773621 776148 776464 776469 776842 778058 788490 789265 789477 789704 790388 793195 794421 794430 794460 794698 794700 799103 800737 804251 804600 807827 808464 810057 810100 811887 814302 815243 817960 823774 823978 824886 825341 826892 ] |
||||||||||||||||||||||||||||||
|
12.75 ms (8.05%) |
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 735391 740457 754770 746044 756538 736044 615260 716293 794460 807827 490634 598321 467046 468284 735976 824886 583937 566679 825341 814302 461683 584383 650610 650146 681621 718498 665419 666111 718570 719100 562145 570127 605628 607213 619620 588748 591904 776469 789704 790388 811887 776842 789265 794700 808464 724768 738292 744208 794430 804251 810100 744773 759701 725395 726457 728381 744989 756620 744182 730297 736090 768153 773621 697219 700804 776464 778058 800737 810057 424764 413123 510947 476836 475682 789477 394433 817960 823774 823978 826892 574440 740662 815243 794698 629529 793195 431702 471043 294327 8900 536468 536567 538696 539348 539352 471042 578202 666070 666114 666130 697175 715935 665456 710847 720455 590496 602222 607434 794421 799103 804600 776148 788490 725243 746109 760485 728629 749567 758923 732977 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.87%) |
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 8900 294327 394433 413123 424764 431702 461683 467046 468284 471042 471043 475682 476836 490634 510947 536468 536567 538696 539348 539352 562145 566679 570127 574440 578202 583937 584383 588748 590496 591904 598321 602222 605628 607213 607434 615260 619620 629529 650146 650610 665419 665456 666070 666111 666114 666130 681621 697175 697219 700804 710847 715935 716293 718498 718570 719100 720455 724768 725243 725395 726457 728381 728629 730297 732977 735391 735976 736044 736090 738292 740457 740662 744182 744208 744773 744989 746044 746109 749567 754770 756538 756620 758923 759701 760485 768153 773621 776148 776464 776469 776842 778058 788490 789265 789477 789704 790388 793195 794421 794430 794460 794698 794700 799103 800737 804251 804600 807827 808464 810057 810100 811887 814302 815243 817960 823774 823978 824886 825341 826892 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая saggy"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy saggy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая saggy"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.88%) |
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.