Query Metrics
7
Database Queries
7
Different statements
191.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.18 ms (86.69%) |
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 429471 429825 451677 454780 470014 528314 529774 530405 538770 539977 545303 552838 556160 556591 574886 577226 582070 584723 584849 584957 589903 589927 589938 589953 589966 593545 596860 599075 606714 607532 607650 616615 620805 621073 621079 623439 629040 629117 632830 637468 641171 644010 649936 650447 652817 653187 661694 661714 672188 674909 679957 688984 691343 692840 693679 697657 708653 708989 709169 710807 714578 719563 728667 728684 730741 732872 734002 734472 737216 739222 740297 744170 746477 747840 750392 750438 751760 754243 754447 754865 756187 757328 758494 759460 762547 762703 763518 765669 765890 770749 771847 773576 776557 778945 781645 782430 784340 784677 788280 791337 797661 797724 801193 801384 801718 802273 802760 802958 803170 804737 805160 807536 808740 809363 811338 811537 814285 818866 822834 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (8.70%) |
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 734472 739222 744170 782430 784340 802760 804737 805160 808740 811338 756187 732872 734002 740297 747840 750392 773576 754243 754865 757328 750438 763518 765890 607532 623439 629040 797661 801193 803170 451677 454780 429825 470014 429471 814285 822834 818866 528314 530405 538770 539977 529774 552838 577226 584723 584849 556160 556591 582070 650447 661714 688984 692840 708653 653187 661694 674909 679957 693679 697657 708989 709169 649936 652817 672188 691343 714578 719563 545303 574886 584957 589903 589938 589953 589966 637468 593545 596860 606714 620805 644010 589927 621073 599075 616615 776557 778945 784677 801384 811537 788280 802273 809363 728667 737216 754447 781645 791337 797724 801718 802958 807536 728684 751760 758494 759460 762703 746477 765669 771847 728648 730741 762547 770749 607650 621079 629117 632830 641171 710807 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.19%) |
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 429471 429825 451677 454780 470014 528314 529774 530405 538770 539977 545303 552838 556160 556591 574886 577226 582070 584723 584849 584957 589903 589927 589938 589953 589966 593545 596860 599075 606714 607532 607650 616615 620805 621073 621079 623439 629040 629117 632830 637468 641171 644010 649936 650447 652817 653187 661694 661714 672188 674909 679957 688984 691343 692840 693679 697657 708653 708989 709169 710807 714578 719563 728667 728684 730741 732872 734002 734472 737216 739222 740297 744170 746477 747840 750392 750438 751760 754243 754447 754865 756187 757328 758494 759460 762547 762703 763518 765669 765890 770749 771847 773576 776557 778945 781645 782430 784340 784677 788280 791337 797661 797724 801193 801384 801718 802273 802760 802958 803170 804737 805160 807536 808740 809363 811338 811537 814285 818866 822834 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"body hair"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"body hair"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"body hair"
]
|
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.