Query Metrics
7
Database Queries
7
Different statements
200.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.28 ms (86.95%) |
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 30208 39478 70123 107104 187443 256898 382372 383989 385379 387276 390487 391043 396762 400619 408837 423019 426104 434012 441315 443046 445576 448253 448886 449194 452853 454701 454763 454822 454902 474381 476942 479873 485716 507631 514972 529880 536831 589923 589927 589928 594232 599075 607650 610342 616615 619282 620805 621073 621079 621092 621958 629117 632830 634021 641171 644010 710807 714528 723744 726788 728667 728684 730741 735964 737216 740258 742648 746477 748663 751760 754447 756994 758494 759460 762547 762703 765669 768200 768258 768724 770749 771709 771847 776557 778945 780227 781645 782756 784677 786562 788280 788618 791337 793670 793700 796086 797724 801384 801718 802273 802455 802958 804352 805654 806865 807364 807536 809363 811378 811537 812481 813116 814406 816818 819223 820563 820671 823316 824588 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (7.91%) |
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 620805 621958 644010 589927 610342 619282 621073 634021 589923 589928 594232 599075 616615 621092 776557 778945 784677 801384 811537 813116 780227 782756 788280 793670 796086 802273 805654 809363 812481 728667 737216 754447 768200 768724 781645 791337 793700 797724 801718 802958 807536 728684 723744 740258 748663 751760 758494 759460 762703 726788 735964 746477 765669 768258 771847 728648 730741 742648 756994 762547 770749 771709 607650 621079 629117 632830 641171 710807 714528 786562 788618 802455 804352 806865 807364 811378 385379 391043 396762 400619 426104 434012 256898 383989 408837 448886 387276 423019 452853 39478 454763 474381 529880 514972 507631 107104 187443 382372 70123 30208 390487 441315 443046 814406 820671 816818 819223 820563 823316 824588 449194 454822 445576 448253 454701 454902 476942 479873 485716 536831 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.55%) |
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 30208 39478 70123 107104 187443 256898 382372 383989 385379 387276 390487 391043 396762 400619 408837 423019 426104 434012 441315 443046 445576 448253 448886 449194 452853 454701 454763 454822 454902 474381 476942 479873 485716 507631 514972 529880 536831 589923 589927 589928 594232 599075 607650 610342 616615 619282 620805 621073 621079 621092 621958 629117 632830 634021 641171 644010 710807 714528 723744 726788 728667 728684 730741 735964 737216 740258 742648 746477 748663 751760 754447 756994 758494 759460 762547 762703 765669 768200 768258 768724 770749 771709 771847 776557 778945 780227 781645 782756 784677 786562 788280 788618 791337 793670 793700 796086 797724 801384 801718 802273 802455 802958 804352 805654 806865 807364 807536 809363 811378 811537 812481 813116 814406 816818 819223 820563 820671 823316 824588 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"body to body"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"body body"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"body body"
]
|
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.