Query Metrics
7
Database Queries
7
Different statements
133.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.20 ms (85.40%) |
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 361679 386344 397014 401660 416933 417600 418389 420825 423637 437957 441749 444246 458126 460676 460715 460939 460950 464239 470142 484096 494122 506192 527638 537604 540523 547763 602635 607261 607394 638052 643879 644543 698124 702491 707376 717102 720418 721141 721943 724704 730432 732556 733299 733392 734703 734927 737898 739072 739149 740697 740964 743738 744920 750021 752532 754503 756716 757655 757957 759907 760210 761675 761967 764504 766283 766876 767362 769905 771790 774079 774562 775217 778693 779681 780474 780723 781594 783445 784890 785998 787070 787909 788617 790855 793523 793596 793914 795793 796440 796876 796920 802414 802773 804866 805645 807574 810843 813571 813846 814427 815958 815978 817427 817785 817921 818396 818448 818452 818629 818802 819432 820538 821386 821556 822178 824353 824506 825187 826102 ] |
||||||||||||||||||||||||||||||
|
10.05 ms (7.51%) |
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 732556 733299 733392 752532 754503 757957 759907 760210 762206 766876 767362 771790 724704 730432 734703 734927 737898 739072 739149 740697 740964 743738 744920 750021 756716 757655 761675 761967 764504 766283 769905 774079 607394 638052 643879 644543 702491 707376 717102 720418 721141 721943 774562 775217 778693 779681 780474 780723 781594 783445 784890 785998 787070 787909 788617 790855 793523 793596 793914 795793 796440 796876 796920 802414 802773 804866 805645 807574 810843 458126 423637 397014 444246 418389 437957 547763 602635 460715 494122 698124 607261 386344 361679 401660 420825 441749 417600 416933 814427 818448 818629 820538 821386 825187 826102 813571 817785 824353 813846 817427 818396 818452 818802 824506 815958 815978 817921 819432 821556 822178 460939 464239 460676 460950 470142 484096 506192 527638 537604 540523 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.89%) |
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 361679 386344 397014 401660 416933 417600 418389 420825 423637 437957 441749 444246 458126 460676 460715 460939 460950 464239 470142 484096 494122 506192 527638 537604 540523 547763 602635 607261 607394 638052 643879 644543 698124 702491 707376 717102 720418 721141 721943 724704 730432 732556 733299 733392 734703 734927 737898 739072 739149 740697 740964 743738 744920 750021 752532 754503 756716 757655 757957 759907 760210 761675 761967 764504 766283 766876 767362 769905 771790 774079 774562 775217 778693 779681 780474 780723 781594 783445 784890 785998 787070 787909 788617 790855 793523 793596 793914 795793 796440 796876 796920 802414 802773 804866 805645 807574 810843 813571 813846 814427 815958 815978 817427 817785 817921 818396 818448 818452 818629 818802 819432 820538 821386 821556 822178 824353 824506 825187 826102 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long hard"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные hard"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"длинные hard"
]
|
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.