Query Metrics
7
Database Queries
7
Different statements
194.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.89 ms (87.64%) |
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 416391 426870 428304 436832 441570 459746 460485 496310 513493 522062 534518 539429 543384 545052 557807 565869 572706 577213 577996 579589 579813 603307 627237 628187 628718 628720 629354 631526 633823 638585 650069 651370 652449 660994 663881 664732 667057 668848 669444 683457 692845 693779 697005 700222 704023 706266 717461 718128 719849 720193 724372 725511 725950 727721 728855 729832 729842 730297 731195 731276 733521 734790 735488 736169 741672 741828 744800 745181 747160 750797 752079 752544 756755 760278 760929 762430 765078 765389 765842 767839 768287 771795 773267 780462 782766 782868 783737 784388 785107 785944 786233 786291 787982 788318 789005 789909 790746 791222 792168 792970 793881 794143 795430 796214 798491 799563 802271 802766 804526 805358 807852 809143 811782 816761 818967 819503 824346 826307 827977 ] |
||||||||||||||||||||||||||||||
|
14.23 ms (7.30%) |
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 785107 788318 791222 792970 794143 795430 809143 783737 786233 789005 792168 727721 760278 784388 785944 752544 765842 741672 745181 725511 729842 735488 750797 752079 765389 768287 730297 631526 697005 704023 793881 798491 799563 460485 787982 441570 667057 773267 733521 426870 496310 818967 651370 627237 782868 728855 700222 628718 513493 534518 664732 683457 660994 720193 650069 565869 736169 764584 629354 633823 579813 717461 756755 459746 522062 579589 729832 428304 816761 819503 669444 747160 789909 543384 824346 826307 827977 572706 652449 692845 628187 603307 802271 804526 805358 780462 744800 782766 786291 796214 725950 734790 741828 760929 765078 724372 767839 718128 790746 807852 577213 557807 811782 771795 577996 802766 545052 731195 719849 762430 731276 436832 539429 693779 628720 663881 668848 706266 638585 416391 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.32%) |
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 416391 426870 428304 436832 441570 459746 460485 496310 513493 522062 534518 539429 543384 545052 557807 565869 572706 577213 577996 579589 579813 603307 627237 628187 628718 628720 629354 631526 633823 638585 650069 651370 652449 660994 663881 664732 667057 668848 669444 683457 692845 693779 697005 700222 704023 706266 717461 718128 719849 720193 724372 725511 725950 727721 728855 729832 729842 730297 731195 731276 733521 734790 735488 736169 741672 741828 744800 745181 747160 750797 752079 752544 756755 760278 760929 762430 765078 765389 765842 767839 768287 771795 773267 780462 782766 782868 783737 784388 785107 785944 786233 786291 787982 788318 789005 789909 790746 791222 792168 792970 793881 794143 795430 796214 798491 799563 802271 802766 804526 805358 807852 809143 811782 816761 818967 819503 824346 826307 827977 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck his wife"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс his жен"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс his жен"
]
|
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.