Query Metrics
7
Database Queries
7
Different statements
144.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.28 ms (81.68%) |
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 12983 150820 193462 592428 593342 604337 607568 610473 619900 620144 624419 630212 630403 630711 630828 634415 707551 708813 712786 713153 717911 718119 719916 725237 726926 727259 727565 727573 728354 728778 729247 729814 729917 730084 734319 734329 734469 734965 735448 737148 737195 738602 740450 740632 742626 742723 743029 746705 747505 748830 750169 752621 752638 755601 756782 757000 758304 758701 759571 760841 761011 761072 761579 764180 765341 765434 766692 767095 767599 768195 768870 769782 771361 771477 773391 773407 775102 775701 777031 778530 782043 784305 788629 788981 790840 790939 791364 794169 794351 794363 795141 795310 796285 796314 796491 797109 798814 800388 800455 800594 800616 800800 802051 802147 802514 804705 805099 805315 805784 807586 808053 808341 810354 810424 811474 811555 811989 812017 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (11.52%) |
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 634415 592428 593342 610473 620144 630828 619900 630212 630403 630711 604337 624419 777031 778530 782043 800455 800800 805315 775102 775701 790939 795141 795310 796285 804705 808053 808341 729917 730084 737195 743029 746705 752638 755601 757000 757075 759571 761011 761579 765341 767599 771477 790840 794169 794363 796314 796491 797109 800616 802051 802147 805099 805784 807586 811989 727573 728354 734319 734469 740450 747505 766692 771361 725237 726926 727259 729814 734965 735448 737148 740632 748830 750169 758701 760841 768195 773407 729247 734329 742723 756782 758304 765549 767095 768870 773391 727565 728778 738602 742626 752621 761072 764180 765434 769782 607568 707551 708813 712786 713153 717911 718119 719916 784305 788629 788981 791364 794351 798814 800388 800594 802514 810354 810424 811474 811555 812017 12983 150820 193462 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.85%) |
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 12983 150820 193462 592428 593342 604337 607568 610473 619900 620144 624419 630212 630403 630711 630828 634415 707551 708813 712786 713153 717911 718119 719916 725237 726926 727259 727565 727573 728354 728778 729247 729814 729917 730084 734319 734329 734469 734965 735448 737148 737195 738602 740450 740632 742626 742723 743029 746705 747505 748830 750169 752621 752638 755601 756782 757000 758304 758701 759571 760841 761011 761072 761579 764180 765341 765434 766692 767095 767599 768195 768870 769782 771361 771477 773391 773407 775102 775701 777031 778530 782043 784305 788629 788981 790840 790939 791364 794169 794351 794363 795141 795310 796285 796314 796491 797109 798814 800388 800455 800594 800616 800800 802051 802147 802514 804705 805099 805315 805784 807586 808053 808341 810354 810424 811474 811555 811989 812017 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал анал анал"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал анал анал"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal anal anal"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.12%) |
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.