Query Metrics
7
Database Queries
7
Different statements
136.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.01 ms (84.83%) |
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 555820 588635 588636 588653 595316 597026 597507 606285 617007 620328 623176 625026 627131 630492 631728 631768 632664 641543 671609 675474 676295 691934 692165 702344 722834 729612 738250 738252 738297 740434 740499 740836 741083 743154 743257 744151 745310 749557 750080 753818 757040 757321 758438 759588 760485 763946 764338 765456 765507 765678 767172 767330 768648 769153 769571 773201 773226 773427 773447 774943 776708 777134 777254 777496 777587 778757 779657 779755 780029 780047 782256 782323 782584 782622 784029 784520 786421 787457 787731 789245 789291 789436 789736 790502 791476 791997 793110 793287 793616 795219 797053 797409 798017 798373 798964 798983 799094 799422 799566 799568 799872 800012 800878 801637 802655 802683 802733 803562 803579 804125 805509 805996 807365 807371 807662 810666 811038 811181 812679 813024 ] |
||||||||||||||||||||||||||||||
|
11.34 ms (8.29%) |
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 671609 676295 675474 691934 692165 555820 606285 630492 631728 631768 641543 595316 597026 620328 623176 632664 588653 597507 617007 588635 588636 776708 779657 779755 780029 782323 782622 789291 791997 793287 793616 798964 799094 799422 801637 802733 805996 807371 811181 812679 774943 777587 778757 780047 789736 790502 797409 798983 799566 803562 803579 811038 729612 738252 753818 757040 758438 760485 767172 768648 784029 784520 787731 793110 795219 798017 800012 805509 807365 740434 743257 745310 749557 759588 765456 769153 773201 773226 773427 740499 757321 763946 764338 769571 738297 743154 744151 765507 765678 773447 738250 740836 741083 750080 767330 625026 627131 702344 722834 777134 777254 777496 782256 782584 786421 787457 789245 789436 791476 797053 798373 799568 799872 800878 802655 802683 804125 807662 810666 813024 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (2.14%) |
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 555820 588635 588636 588653 595316 597026 597507 606285 617007 620328 623176 625026 627131 630492 631728 631768 632664 641543 671609 675474 676295 691934 692165 702344 722834 729612 738250 738252 738297 740434 740499 740836 741083 743154 743257 744151 745310 749557 750080 753818 757040 757321 758438 759588 760485 763946 764338 765456 765507 765678 767172 767330 768648 769153 769571 773201 773226 773427 773447 774943 776708 777134 777254 777496 777587 778757 779657 779755 780029 780047 782256 782323 782584 782622 784029 784520 786421 787457 787731 789245 789291 789436 789736 790502 791476 791997 793110 793287 793616 795219 797053 797409 798017 798373 798964 798983 799094 799422 799566 799568 799872 800012 800878 801637 802655 802683 802733 803562 803579 804125 805509 805996 807365 807371 807662 810666 811038 811181 812679 813024 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red hair tattoo"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red hair татуированные"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red hair татуированные"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.