Query Metrics
7
Database Queries
7
Different statements
385.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.97 ms (53.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young beautiful"
]
|
||||||||||||||||||||||||||||||
|
157.09 ms (40.80%) |
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 407851 416875 475716 485902 487370 488004 494695 515134 518559 527513 537767 544303 549315 551706 560556 562300 565367 572563 581349 590311 591779 600903 601597 605341 607167 618886 624296 624827 628175 654602 655375 655392 656747 657022 657097 657613 659605 663477 666821 667852 671670 674381 674748 676167 678491 678806 682511 684303 684998 687238 688578 689758 691838 693882 702088 706293 707786 709621 712830 712900 713838 714478 721414 722537 722684 731428 739074 740059 740500 741454 746478 759588 775049 777641 780951 788039 788471 788950 789806 793583 799788 801938 805052 806277 807020 810623 810929 811903 813474 814068 814167 815846 816591 816747 817305 817316 818118 818220 819176 819616 820699 820786 820958 821041 821717 821862 821873 822043 822097 822288 822725 822905 822925 823236 825502 827862 827941 827977 827980 ] |
||||||||||||||||||||||||||||||
|
15.12 ms (3.93%) |
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 485902 527513 488004 518559 581349 565367 628175 475716 487370 515134 494695 407851 416875 814068 817305 817316 820786 822097 822725 825502 814167 816747 819616 821717 821862 822043 816591 818118 821041 822905 823236 815846 818220 819176 820699 820958 821873 822288 822925 827961 827862 827977 827980 827941 537767 549315 560556 562300 544303 551706 654602 657097 678491 678806 682511 684303 687238 693882 712900 655375 659605 667852 676167 702088 706293 709621 712830 713838 714478 722684 655392 656747 657022 657613 663477 666821 671670 674381 674748 684998 688578 689758 691838 707786 721414 722537 572563 624827 605341 618886 624296 600903 590311 591779 601597 607167 788471 799788 801938 807020 810623 810929 775049 777641 780951 788039 788950 805052 811903 740059 789806 793583 806277 813474 731428 739074 740500 741454 746478 759588 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (0.74%) |
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 407851 416875 475716 485902 487370 488004 494695 515134 518559 527513 537767 544303 549315 551706 560556 562300 565367 572563 581349 590311 591779 600903 601597 605341 607167 618886 624296 624827 628175 654602 655375 655392 656747 657022 657097 657613 659605 663477 666821 667852 671670 674381 674748 676167 678491 678806 682511 684303 684998 687238 688578 689758 691838 693882 702088 706293 707786 709621 712830 712900 713838 714478 721414 722537 722684 731428 739074 740059 740500 741454 746478 759588 775049 777641 780951 788039 788471 788950 789806 793583 799788 801938 805052 806277 807020 810623 810929 811903 813474 814068 814167 815846 816591 816747 817305 817316 818118 818220 819176 819616 820699 820786 820958 821041 821717 821862 821873 822043 822097 822288 822725 822905 822925 823236 825502 827862 827941 827977 827980 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young красивая"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young красивая"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.42%) |
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.