Query Metrics
7
Database Queries
7
Different statements
140.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.59 ms (83.14%) |
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 3826 31563 50436 70186 84120 97598 124308 131462 188600 301920 382656 383111 384796 387436 388204 388897 390857 395888 398515 398779 400727 409114 411404 565811 589707 603322 605021 605035 619472 626627 628295 636926 644338 645259 652248 652262 658562 658736 659666 659814 664281 667100 667681 668827 683288 700885 705356 705365 705887 706864 707282 712835 714646 715095 716491 717279 718501 719118 719746 720272 720540 722106 723214 730077 730242 732132 733468 735340 736772 739725 741914 742582 742734 743251 744350 747076 747077 750338 753371 754482 754649 757060 761414 768529 770040 785888 787187 795073 797581 800688 802986 803729 805923 806189 809528 812522 814725 817013 817517 817672 818606 818813 819063 819631 819753 820689 824092 824939 825323 825391 825976 826344 826658 826690 826865 826890 826928 827032 827092 827596 ] |
||||||||||||||||||||||||||||||
|
13.31 ms (9.49%) |
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 565811 658736 667100 668827 707282 716491 719118 720272 645259 664281 667681 714646 715095 717279 718501 723214 652248 652262 658562 659666 659814 683288 700885 705887 720540 722106 605021 605035 626627 628295 636926 644338 589707 603322 619472 785888 803729 805923 812522 797581 806189 754482 754649 757060 761414 770040 787187 795073 800688 730242 744350 753371 768529 730077 736772 743251 747076 732132 739725 741914 750338 733468 735340 742582 742734 747077 705356 705365 706864 712835 719746 802986 809528 400727 387436 388897 383111 384796 188600 124308 395888 301920 382656 70186 97598 31563 50436 3826 84120 131462 388204 390857 398515 398779 411404 409114 817517 817672 819063 820689 824092 825323 825391 826658 826690 814725 817013 818606 818813 819631 819753 824939 825976 826344 826865 826890 826928 827032 827092 827596 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (2.09%) |
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 3826 31563 50436 70186 84120 97598 124308 131462 188600 301920 382656 383111 384796 387436 388204 388897 390857 395888 398515 398779 400727 409114 411404 565811 589707 603322 605021 605035 619472 626627 628295 636926 644338 645259 652248 652262 658562 658736 659666 659814 664281 667100 667681 668827 683288 700885 705356 705365 705887 706864 707282 712835 714646 715095 716491 717279 718501 719118 719746 720272 720540 722106 723214 730077 730242 732132 733468 735340 736772 739725 741914 742582 742734 743251 744350 747076 747077 750338 753371 754482 754649 757060 761414 768529 770040 785888 787187 795073 797581 800688 802986 803729 805923 806189 809528 812522 814725 817013 817517 817672 818606 818813 819063 819631 819753 820689 824092 824939 825323 825391 825976 826344 826658 826690 826865 826890 826928 827032 827092 827596 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short short"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short short"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short short"
]
|
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.