Query Metrics
7
Database Queries
7
Different statements
196.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.49 ms (85.77%) |
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 384809 391400 411751 414315 414621 418363 452638 452977 472910 475414 475833 476676 476905 481904 487938 488724 491446 508699 510815 511812 518493 519497 522606 522870 522889 522895 522906 523859 526470 530384 530796 531202 531235 532343 532913 532995 533372 533373 535054 535456 537114 537203 537595 537672 537773 541698 541806 543652 550831 559162 561119 562823 562836 569154 571028 576691 576711 583700 584063 586673 588286 593877 596082 596851 599833 599862 599863 599914 599955 599965 599976 600019 600171 600296 600342 601613 602018 604902 617416 622979 632659 632663 634543 634774 634782 636295 636320 637036 639027 640531 641141 641455 641690 642063 643376 643933 644918 646025 646841 648235 648853 651631 662000 666892 668534 671746 677674 688108 702061 704531 708447 711283 718695 756413 778359 788262 792576 801960 807175 809520 ] |
||||||||||||||||||||||||||||||
|
18.15 ms (9.24%) |
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 586673 596082 600342 634782 639027 641141 641455 643376 801960 792576 756413 617416 640531 643933 702061 718695 778359 788262 809520 414621 452977 411751 391400 475833 508699 518493 522895 523859 510815 571028 584063 600296 599863 599965 600019 418363 519497 588286 644918 475414 476905 487938 488724 452638 526470 535054 522606 522889 541806 559162 562823 562836 576691 569154 646025 662000 668534 677674 671746 708447 550831 576711 622979 593877 599914 602018 632659 641690 384809 472910 511812 491446 535456 522906 522870 561119 532995 533372 533373 537114 537773 476676 541698 648235 688108 651631 711283 646841 648853 666892 596851 599976 600171 642063 599955 599862 634543 636295 601613 632663 704531 414315 637036 543652 583700 634774 604902 636320 599833 807175 481904 530384 530796 537672 531202 532343 532913 537203 537595 531235 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.46%) |
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 384809 391400 411751 414315 414621 418363 452638 452977 472910 475414 475833 476676 476905 481904 487938 488724 491446 508699 510815 511812 518493 519497 522606 522870 522889 522895 522906 523859 526470 530384 530796 531202 531235 532343 532913 532995 533372 533373 535054 535456 537114 537203 537595 537672 537773 541698 541806 543652 550831 559162 561119 562823 562836 569154 571028 576691 576711 583700 584063 586673 588286 593877 596082 596851 599833 599862 599863 599914 599955 599965 599976 600019 600171 600296 600342 601613 602018 604902 617416 622979 632659 632663 634543 634774 634782 636295 636320 637036 639027 640531 641141 641455 641690 642063 643376 643933 644918 646025 646841 648235 648853 651631 662000 666892 668534 671746 677674 688108 702061 704531 708447 711283 718695 756413 778359 788262 792576 801960 807175 809520 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double anal mom"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double анал mom"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double анал mom"
]
|
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.