Query Metrics
7
Database Queries
7
Different statements
376.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.00 ms (56.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old старый"
]
|
||||||||||||||||||||||||||||||
|
136.66 ms (36.30%) |
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 185334 351473 382450 383773 385913 385948 387268 389310 393752 393777 398595 400421 400624 403052 409050 413295 418449 420423 422684 430303 456865 458058 458926 461961 463161 464307 464312 465786 470707 470844 472246 482798 487915 494352 505004 512047 513326 515073 515097 515216 519639 520774 523802 529564 538774 539001 544356 547642 550440 550443 550447 550449 550601 550612 554307 562312 564000 566514 567160 568575 568579 570077 578446 578481 584495 585141 586629 587929 597264 598777 598820 605469 607173 607193 618882 618893 642779 644696 654363 655861 663374 663482 663947 665247 666767 666810 668857 675537 676951 676968 687929 696973 700544 700659 701345 712923 714441 714452 722913 734842 740300 740854 743131 744301 744312 744328 748139 748143 748544 758198 767956 771180 777345 788582 810286 810312 810600 812138 812141 827523 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (4.69%) |
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 812138 403052 472246 420423 539001 505004 393752 398595 400624 430303 585141 487915 482798 550449 578446 578481 584495 598820 456865 458926 465786 385948 464312 464307 515097 529564 513326 538774 461961 520774 523802 550443 568575 568579 675537 586629 383773 387268 827523 512047 515216 554307 550601 566514 550440 562312 567160 655861 676968 654363 663374 663482 666767 676951 687929 696973 722913 668857 714452 587929 598777 597264 607193 605469 607173 618882 618893 777345 743131 748139 788582 810286 810312 740854 748143 771180 734842 740300 758198 767956 744312 744328 642779 812141 382450 418449 463161 470844 400421 413295 470707 458058 494352 393777 409050 519639 550612 547642 544356 666810 665247 712923 644696 810600 744301 748544 700544 701345 570077 663947 550447 385913 185334 351473 389310 422684 515073 564000 700659 714441 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (0.86%) |
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 185334 351473 382450 383773 385913 385948 387268 389310 393752 393777 398595 400421 400624 403052 409050 413295 418449 420423 422684 430303 456865 458058 458926 461961 463161 464307 464312 465786 470707 470844 472246 482798 487915 494352 505004 512047 513326 515073 515097 515216 519639 520774 523802 529564 538774 539001 544356 547642 550440 550443 550447 550449 550601 550612 554307 562312 564000 566514 567160 568575 568579 570077 578446 578481 584495 585141 586629 587929 597264 598777 598820 605469 607173 607193 618882 618893 642779 644696 654363 655861 663374 663482 663947 665247 666767 666810 668857 675537 676951 676968 687929 696973 700544 700659 701345 712923 714441 714452 722913 734842 740300 740854 743131 744301 744312 744328 748139 748143 748544 758198 767956 771180 777345 788582 810286 810312 810600 812138 812141 827523 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old старый"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old grandfather"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.44%) |
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.