Query Metrics
7
Database Queries
7
Different statements
150.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.31 ms (86.44%) |
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 391792 391890 398625 403214 414730 441918 444682 461864 478687 489688 493885 515844 517256 524894 535200 535300 538578 538621 540062 540462 540895 541010 541704 542292 544723 545780 548415 553259 553498 553806 556087 556171 557587 557876 561201 567655 569517 577298 577623 579739 579756 585319 592087 592099 592134 592148 592159 598913 601376 604099 604318 610772 611093 618082 618099 619815 622460 626146 627329 629443 630259 630704 634921 635011 635057 635061 635063 635355 635641 643854 644773 645575 647703 647788 647915 649713 660343 667435 673818 675142 676554 682988 684874 685919 687908 696958 697661 702497 703710 707079 712484 715378 719928 720841 726344 728360 733043 733126 736083 736454 742618 743913 760690 765705 766986 767221 767693 769846 772158 775430 778934 780254 787881 791105 791423 796318 796895 809904 810946 ] |
||||||||||||||||||||||||||||||
|
11.59 ms (7.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 667435 685919 696958 660343 673818 707079 618099 592099 644773 592148 643854 610772 611093 775430 535300 535200 541010 556087 548415 720841 635641 592159 736083 772158 810946 733126 760690 604099 403214 541704 719928 796895 767221 766986 391890 553259 682988 622460 540062 703710 647788 676554 687908 561201 635061 604318 635011 592087 618082 627329 630259 634921 478687 553806 567655 569517 577298 647915 726344 556171 545780 619815 626146 780254 809904 791423 635063 444682 414730 461864 542292 684874 557876 778934 775594 733043 736454 743913 765705 796318 398625 391792 630704 675142 629443 553498 557587 649713 697661 645575 647703 712484 598913 635355 538578 544723 540895 791105 493885 515844 538621 524894 579739 579756 715378 702497 585319 592134 601376 769846 728360 742618 767693 635057 517256 441918 540462 489688 577623 787881 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.75%) |
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 391792 391890 398625 403214 414730 441918 444682 461864 478687 489688 493885 515844 517256 524894 535200 535300 538578 538621 540062 540462 540895 541010 541704 542292 544723 545780 548415 553259 553498 553806 556087 556171 557587 557876 561201 567655 569517 577298 577623 579739 579756 585319 592087 592099 592134 592148 592159 598913 601376 604099 604318 610772 611093 618082 618099 619815 622460 626146 627329 629443 630259 630704 634921 635011 635057 635061 635063 635355 635641 643854 644773 645575 647703 647788 647915 649713 660343 667435 673818 675142 676554 682988 684874 685919 687908 696958 697661 702497 703710 707079 712484 715378 719928 720841 726344 728360 733043 733126 736083 736454 742618 743913 760690 765705 766986 767221 767693 769846 772158 775430 778934 780254 787881 791105 791423 796318 796895 809904 810946 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"quickie amateur"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"quickie любительск"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"quickie любительск"
]
|
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.