Query Metrics
7
Database Queries
7
Different statements
169.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.55 ms (84.32%) |
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 45853 325648 397407 400855 405922 433037 439565 461141 474364 480593 491967 498492 501528 517076 525891 530431 534791 545101 546370 547239 551267 556800 567757 574621 578338 578690 584437 600808 603807 606521 609297 609610 610140 617778 630403 641490 673177 675182 680649 689379 689419 692523 696386 704144 710410 710686 711378 713153 715604 716135 716250 716621 717188 718460 718743 722168 723636 724607 724756 725142 727534 735298 736811 740244 747490 747505 747760 748183 752875 754065 756908 759973 764515 767672 767702 768541 773912 779662 780837 782067 782956 786151 787567 789282 790548 791845 791890 794735 795296 796050 796081 796225 796510 796512 796765 796951 799377 799945 802944 803206 806163 806166 807328 809365 816135 816712 817025 817567 818051 818945 819009 820103 823673 823817 824235 825159 826143 828788 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (10.44%) |
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 546370 740244 747760 534791 603807 567757 609610 716250 743671 754065 689379 501528 461141 517076 716621 689419 600808 782956 735298 764515 641490 807328 819009 767672 802944 551267 439565 474364 491967 818945 817025 547239 718743 704144 715604 630403 796050 796225 803206 756908 773912 610140 713153 780837 786151 45853 820103 325648 825159 816135 818051 823817 824235 480593 578690 711378 696386 779662 791890 799377 796951 806166 725142 747490 787567 806163 727534 748183 752875 767702 768541 724756 736811 759973 782067 789282 790548 791845 794735 796081 809365 498492 680649 796510 617778 796512 747505 710686 609297 606521 710410 724607 397407 400855 405922 433037 723636 826143 816712 817567 823673 828788 525891 530431 545101 578338 584437 556800 574621 692523 722168 716135 673177 675182 717188 718460 778213 799945 795296 796765 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.51%) |
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 45853 325648 397407 400855 405922 433037 439565 461141 474364 480593 491967 498492 501528 517076 525891 530431 534791 545101 546370 547239 551267 556800 567757 574621 578338 578690 584437 600808 603807 606521 609297 609610 610140 617778 630403 641490 673177 675182 680649 689379 689419 692523 696386 704144 710410 710686 711378 713153 715604 716135 716250 716621 717188 718460 718743 722168 723636 724607 724756 725142 727534 735298 736811 740244 747490 747505 747760 748183 752875 754065 756908 759973 764515 767672 767702 768541 773912 779662 780837 782067 782956 786151 787567 789282 790548 791845 791890 794735 795296 796050 796081 796225 796510 796512 796765 796951 799377 799945 802944 803206 806163 806166 807328 809365 816135 816712 817025 817567 818051 818945 819009 820103 823673 823817 824235 825159 826143 828788 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс жен колготк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"выебали жену в колгот%…"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс жен колготк"
]
|
||||||||||||||||||||||||||||||
|
1.49 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.