Query Metrics
7
Database Queries
7
Different statements
177.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.52 ms (86.30%) |
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 392739 394433 395523 398747 411346 533491 562997 563083 563185 565648 568343 577174 657776 675359 680619 686620 689079 689369 698958 700611 708259 709346 711650 712321 712642 712669 713438 714750 714888 714908 714966 716460 716586 717927 718119 718967 719246 720517 721392 721754 723565 725588 726568 728919 729255 729662 730998 731399 734081 734173 735518 736575 737944 739555 740974 742723 743011 744160 747251 749416 749760 750305 750396 753732 754990 756325 757848 758200 760989 761278 765305 771685 777159 777675 779533 781496 781650 781710 781747 789350 792523 794598 794603 795046 795299 795475 796001 796044 797150 798676 798888 799253 801269 801436 803080 804431 804500 805713 806166 809968 811562 814303 817567 817692 818510 819661 819851 819929 820736 823591 823637 824057 824350 824451 825261 825277 825296 825825 826996 ] |
||||||||||||||||||||||||||||||
|
14.22 ms (7.99%) |
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 562997 577174 714966 689079 714888 719246 563185 794598 811562 779533 795046 804431 743011 731399 734081 739555 747251 756325 750305 760989 737944 740974 750396 771685 777159 798888 395523 804500 729255 714750 392739 394433 723565 824350 712669 686620 714908 720517 675359 711650 718967 798676 794603 801269 806166 789350 728919 725588 744160 712642 713438 779805 819929 712321 777675 799253 809968 753732 761278 796001 735518 734173 749760 765305 781650 398747 823637 826996 817567 818510 819661 823591 825296 819851 820736 824057 825261 825825 533491 563083 565648 568343 708259 721392 680619 698958 657776 689369 716460 717927 781710 781496 781747 801436 754990 795299 805713 730998 736575 758200 742723 757848 726568 700611 709346 716586 718119 721754 792523 795475 797150 817692 749416 729662 411346 814303 824451 825277 796044 803080 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.81%) |
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 392739 394433 395523 398747 411346 533491 562997 563083 563185 565648 568343 577174 657776 675359 680619 686620 689079 689369 698958 700611 708259 709346 711650 712321 712642 712669 713438 714750 714888 714908 714966 716460 716586 717927 718119 718967 719246 720517 721392 721754 723565 725588 726568 728919 729255 729662 730998 731399 734081 734173 735518 736575 737944 739555 740974 742723 743011 744160 747251 749416 749760 750305 750396 753732 754990 756325 757848 758200 760989 761278 765305 771685 777159 777675 779533 781496 781650 781710 781747 789350 792523 794598 794603 795046 795299 795475 796001 796044 797150 798676 798888 799253 801269 801436 803080 804431 804500 805713 806166 809968 811562 814303 817567 817692 818510 819661 819851 819929 820736 823591 823637 824057 824350 824451 825261 825277 825296 825825 826996 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс stepson"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck stepson"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс stepson"
]
|
||||||||||||||||||||||||||||||
|
1.57 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.