Query Metrics
7
Database Queries
7
Different statements
144.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.78 ms (84.39%) |
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 315815 399426 418389 424917 437996 438212 445497 458248 482247 491015 497117 503075 509949 509967 516427 522653 523473 523494 529134 549495 552287 556268 561948 565195 566005 569164 573391 574937 581191 581237 588134 592432 601940 601947 613942 614821 618738 621447 621721 623299 629667 632418 636118 644049 644115 649268 650062 656830 667014 670319 672820 674068 674743 688279 689514 693256 709320 710858 713362 716929 718050 719813 721575 724739 724820 727331 729711 731280 734350 738780 745256 745872 748939 754060 756920 757180 757519 757587 760436 762304 766484 768244 768340 773552 775646 777471 778054 778074 778639 778758 779162 779890 780015 781631 785542 785946 786883 787417 787821 788550 788933 789755 791838 792277 792328 792483 793775 800643 803308 804896 806217 810559 813098 814499 816152 821827 823632 827271 827883 827910 ] |
||||||||||||||||||||||||||||||
|
13.35 ms (9.25%) |
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 497117 522653 523494 523473 529134 561948 573391 601940 424917 503075 438212 827271 816152 827910 482247 581191 656830 670319 716929 588134 621447 636118 629667 644049 644115 803308 789755 792328 806217 813098 724739 731280 757519 727331 762304 745872 757587 621721 778074 778639 601947 437996 516427 814499 556268 649268 710858 632418 793775 775646 786883 810559 760436 748939 724820 768244 787821 800643 418389 792277 315815 650062 688279 458248 581237 719813 768340 509967 549495 667014 672820 693256 689514 569164 618738 623299 785946 788550 738780 754060 399426 821827 713362 721575 778054 778758 766484 757180 773552 734350 780015 565195 823632 827883 445497 491015 509949 552287 574937 566005 674068 709320 674743 718050 614821 613942 592432 777471 779890 785542 779162 781631 788933 792483 729711 745256 756920 787417 791838 804896 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.57%) |
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 315815 399426 418389 424917 437996 438212 445497 458248 482247 491015 497117 503075 509949 509967 516427 522653 523473 523494 529134 549495 552287 556268 561948 565195 566005 569164 573391 574937 581191 581237 588134 592432 601940 601947 613942 614821 618738 621447 621721 623299 629667 632418 636118 644049 644115 649268 650062 656830 667014 670319 672820 674068 674743 688279 689514 693256 709320 710858 713362 716929 718050 719813 721575 724739 724820 727331 729711 731280 734350 738780 745256 745872 748939 754060 756920 757180 757519 757587 760436 762304 766484 768244 768340 773552 775646 777471 778054 778074 778639 778758 779162 779890 780015 781631 785542 785946 786883 787417 787821 788550 788933 789755 791838 792277 792328 792483 793775 800643 803308 804896 806217 810559 813098 814499 816152 821827 823632 827271 827883 827910 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister sex"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister секс"
]
|
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.