Query Metrics
7
Database Queries
7
Different statements
194.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.37 ms (87.47%) |
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 400516 401657 418884 420794 426999 427186 438027 443920 444198 444840 451494 453505 455505 461233 464484 465907 468883 475560 477860 477904 478385 478421 480013 482723 489444 491433 491462 492234 492460 495446 500230 501633 503079 503442 505472 505845 508801 509163 514066 528633 535638 542444 548410 553968 555067 560335 561275 572358 579467 590555 592548 593485 597514 612404 616554 616783 619898 623966 626866 664649 672795 680673 691395 694614 695780 702280 702316 745482 749891 751007 755013 757120 758409 764036 765717 765842 767073 767078 768423 768446 768450 768760 769275 777749 778293 779748 779846 783754 784225 784776 786269 786403 786952 789180 789631 791968 792545 792932 793206 793942 794728 795360 796196 796208 801537 801800 804823 804930 805352 809307 810026 812452 812709 813576 816744 818678 824994 825556 825611 825710 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (6.92%) |
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 477904 443920 451494 461233 444198 477860 500230 505472 514066 491433 508801 528633 495446 503442 501633 749891 812452 420794 813576 825556 818678 824994 825611 816744 825710 480013 478421 509163 535638 555067 542444 672795 695780 664649 680673 694614 702280 691395 619898 590555 616554 616783 623966 597514 779846 786403 789631 794728 795360 796196 796208 809307 777749 779748 784225 793206 801537 812709 745482 755013 768446 786269 786952 789180 791968 792545 804930 810026 765842 768423 768450 757120 758409 764036 751007 765717 767073 768760 769275 767078 702316 778293 783754 793942 801800 804823 805352 427186 444840 438027 426999 475560 505845 491462 400516 418884 478385 503079 792932 561275 572358 455505 464484 492234 489444 593485 482723 492460 548410 560335 579467 553968 626866 612404 592548 784776 453505 465907 401657 468883 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.63%) |
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 400516 401657 418884 420794 426999 427186 438027 443920 444198 444840 451494 453505 455505 461233 464484 465907 468883 475560 477860 477904 478385 478421 480013 482723 489444 491433 491462 492234 492460 495446 500230 501633 503079 503442 505472 505845 508801 509163 514066 528633 535638 542444 548410 553968 555067 560335 561275 572358 579467 590555 592548 593485 597514 612404 616554 616783 619898 623966 626866 664649 672795 680673 691395 694614 695780 702280 702316 745482 749891 751007 755013 757120 758409 764036 765717 765842 767073 767078 768423 768446 768450 768760 769275 777749 778293 779748 779846 783754 784225 784776 786269 786403 786952 789180 789631 791968 792545 792932 793206 793942 794728 795360 796196 796208 801537 801800 804823 804930 805352 809307 810026 812452 812709 813576 816744 818678 824994 825556 825611 825710 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf pov russian"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf пов русск"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf пов русск"
]
|
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.