Query Metrics
7
Database Queries
7
Different statements
191.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.75 ms (85.91%) |
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 383437 385229 387372 387446 399156 426769 428062 469189 478348 528999 530346 530349 533796 533800 537095 542479 550990 564698 565999 577308 582816 583930 587537 595963 596284 609073 616535 617245 624406 627583 628254 635030 636556 637170 641501 645733 650048 650066 650292 652269 653576 655841 661444 662030 665954 668007 668787 681745 681755 682841 686584 688500 690771 690830 691521 692214 692802 694452 694465 695204 695213 695242 696358 698425 698481 710015 712172 713285 716963 719850 724872 725779 728887 734793 739263 740707 743895 745792 745957 750552 752275 755148 763649 763844 765061 765096 765553 765735 766344 766479 768101 773421 776018 779814 781008 782314 782640 783993 788938 791202 791397 791561 793308 795831 796792 796894 805661 809965 810924 814219 820206 820511 821039 821789 822137 823131 823409 828110 828398 ] |
||||||||||||||||||||||||||||||
|
16.14 ms (8.41%) |
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 700018 641501 788938 795831 752275 724872 766344 385229 828398 533800 582816 645733 681745 650066 662030 681755 694452 698425 668007 692802 583930 609073 628254 595963 781008 791561 765061 763844 766479 745957 712172 796792 814219 821789 820511 823409 820206 821039 533796 537095 528999 564698 565999 650292 655841 665954 688500 713285 716963 695204 650048 653576 668787 682841 691521 692214 710015 596284 616535 624406 636556 627583 637170 776018 782314 739263 740707 768101 765096 745792 773421 635030 698481 810924 791397 387372 550990 690830 782640 743895 399156 822137 530349 694465 661444 652269 617245 779814 750552 765553 755148 763649 809965 383437 428062 823131 469189 695213 690771 696358 719850 686584 587537 791202 793308 783993 796894 728887 734793 765735 725779 805661 426769 387446 828110 530346 478348 577308 542479 695242 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (1.88%) |
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 383437 385229 387372 387446 399156 426769 428062 469189 478348 528999 530346 530349 533796 533800 537095 542479 550990 564698 565999 577308 582816 583930 587537 595963 596284 609073 616535 617245 624406 627583 628254 635030 636556 637170 641501 645733 650048 650066 650292 652269 653576 655841 661444 662030 665954 668007 668787 681745 681755 682841 686584 688500 690771 690830 691521 692214 692802 694452 694465 695204 695213 695242 696358 698425 698481 710015 712172 713285 716963 719850 724872 725779 728887 734793 739263 740707 743895 745792 745957 750552 752275 755148 763649 763844 765061 765096 765553 765735 766344 766479 768101 773421 776018 779814 781008 782314 782640 783993 788938 791202 791397 791561 793308 795831 796792 796894 805661 809965 810924 814219 820206 820511 821039 821789 822137 823131 823409 828110 828398 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck video"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс video"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс video"
]
|
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.