Query Metrics
7
Database Queries
7
Different statements
147.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.39 ms (82.96%) |
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 3444 80314 184359 189743 383493 391692 391923 392952 393848 394661 397457 398364 401845 412604 417242 418533 418836 420254 421828 421883 421891 424114 424123 425894 426393 428580 439727 441106 441107 441124 441780 441784 441841 441984 442080 442107 443896 446500 451213 456701 456995 459635 460411 461282 463991 465460 468366 470052 478411 486046 492292 493223 493676 493749 506097 518916 531561 537760 544447 547858 554936 566763 566777 566875 584339 584961 594300 595329 602293 619544 632111 637054 642390 680290 680434 687325 710455 711660 713422 724307 725475 726245 726747 728146 728308 733149 736235 739608 740889 745952 746168 747083 749672 750257 750260 758780 758790 759756 761164 761496 770242 791580 794720 794858 794866 794874 794895 795295 796504 800372 803537 809654 816622 817192 823746 824936 826589 826739 826827 827178 ] |
||||||||||||||||||||||||||||||
|
14.93 ms (10.12%) |
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 451213 465460 794858 800372 745952 421828 184359 826827 827178 544447 747083 739608 80314 441984 441106 566763 460411 189743 816622 478411 537760 566777 687325 412604 680434 594300 383493 791580 725475 761496 795295 439727 3444 443896 418533 486046 463991 710455 728308 733149 749672 637054 456701 441107 442080 459635 506097 566875 758780 418836 713422 632111 758790 796504 426393 441780 493676 750257 724307 461282 397457 824936 826589 826739 554936 584961 794866 794720 794895 746168 761164 391923 401845 817192 595329 531561 518916 602293 394661 398364 424114 441124 442107 446500 493749 470052 493223 642390 809654 759756 770242 728146 736235 492292 794874 619544 391692 392952 425894 441841 468366 803537 424123 421883 441784 393848 421891 680290 420254 417242 823746 456995 584339 711660 726245 726747 750260 740889 428580 547858 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.15%) |
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 3444 80314 184359 189743 383493 391692 391923 392952 393848 394661 397457 398364 401845 412604 417242 418533 418836 420254 421828 421883 421891 424114 424123 425894 426393 428580 439727 441106 441107 441124 441780 441784 441841 441984 442080 442107 443896 446500 451213 456701 456995 459635 460411 461282 463991 465460 468366 470052 478411 486046 492292 493223 493676 493749 506097 518916 531561 537760 544447 547858 554936 566763 566777 566875 584339 584961 594300 595329 602293 619544 632111 637054 642390 680290 680434 687325 710455 711660 713422 724307 725475 726245 726747 728146 728308 733149 736235 739608 740889 745952 746168 747083 749672 750257 750260 758780 758790 759756 761164 761496 770242 791580 794720 794858 794866 794874 794895 795295 796504 800372 803537 809654 816622 817192 823746 824936 826589 826739 826827 827178 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby анал любительск"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby anal amateur"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby анал любительск"
]
|
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.