Query Metrics
7
Database Queries
7
Different statements
151.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.14 ms (86.31%) |
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 390929 393742 396887 397473 400672 418484 439142 451595 464280 473955 480420 492649 495158 512762 514470 515158 515193 515290 518933 522695 524312 527536 530809 542976 545357 550602 552599 563961 569427 569674 575636 578498 583696 590328 595538 604417 604467 620333 620801 622303 624238 626543 626755 628851 636405 646343 655062 657434 664794 670074 670762 671819 675514 675742 678763 678897 683524 683536 683774 684187 684211 684224 684238 684943 685562 685612 687187 687461 687796 698657 699009 702087 702461 706321 708955 709703 715326 716468 718627 719129 720328 720376 720505 721223 726284 731098 737417 738274 738320 744316 750352 750638 751500 755100 756090 760466 760481 766858 770061 776028 779014 786491 788963 793588 800119 800761 801281 803181 805591 814490 817410 817630 817701 817702 817713 819550 819605 820086 820205 826942 ] |
||||||||||||||||||||||||||||||
|
11.77 ms (7.75%) |
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 439142 512762 396887 826942 817701 819550 530809 527536 542976 698657 670074 671819 678897 683524 684224 684238 684943 687796 718627 721223 626543 626755 793588 776028 786491 788963 751500 800761 801281 803181 805591 726284 750638 755100 760466 766858 731098 738274 738320 750352 756090 760481 770061 702461 708955 393742 418484 492649 524312 518933 515193 550602 569427 569674 578498 684211 664794 687461 583696 604467 620801 744316 604417 480420 390929 473955 451595 464280 515290 515158 495158 397473 400672 814490 817410 817713 819605 820205 817630 817702 820086 522695 514470 552599 563961 575636 545357 655062 657434 675514 683536 683774 685612 699009 715326 716468 720376 720505 646343 670762 675742 678763 684187 685562 706321 687187 702087 709703 719129 720328 590328 622303 624238 628851 595538 620333 636405 800119 779014 737417 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.48%) |
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 390929 393742 396887 397473 400672 418484 439142 451595 464280 473955 480420 492649 495158 512762 514470 515158 515193 515290 518933 522695 524312 527536 530809 542976 545357 550602 552599 563961 569427 569674 575636 578498 583696 590328 595538 604417 604467 620333 620801 622303 624238 626543 626755 628851 636405 646343 655062 657434 664794 670074 670762 671819 675514 675742 678763 678897 683524 683536 683774 684187 684211 684224 684238 684943 685562 685612 687187 687461 687796 698657 699009 702087 702461 706321 708955 709703 715326 716468 718627 719129 720328 720376 720505 721223 726284 731098 737417 738274 738320 744316 750352 750638 751500 755100 756090 760466 760481 766858 770061 776028 779014 786491 788963 793588 800119 800761 801281 803181 805591 814490 817410 817630 817701 817702 817713 819550 819605 820086 820205 826942 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen and old"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old"
]
|
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.