Query Metrics
7
Database Queries
7
Different statements
143.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.59 ms (84.99%) |
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 385600 438665 506238 511013 546563 592127 615471 616344 627218 635812 640879 659424 671915 678647 709284 720845 721803 722094 722117 722151 723216 724874 725053 726316 726356 727510 728711 728936 729304 730165 730269 730482 731125 731183 731212 731218 731407 733196 733447 734355 735769 736145 737973 739634 740864 741184 741765 743006 743821 746219 746301 748917 749827 752273 752933 753641 755830 756296 761282 761401 763232 763502 764313 765145 765369 766092 767519 767521 767721 769074 769599 770026 770693 772256 772307 772376 772443 773375 773378 773502 777489 777521 777542 778929 779410 779511 779550 779822 781036 781531 781553 781612 784084 784685 785889 785987 786067 787147 787229 787230 791608 791630 791825 792210 793245 793473 793929 795028 797319 797363 798503 799758 800951 803418 805111 810361 813297 826345 827407 ] |
||||||||||||||||||||||||||||||
|
11.41 ms (7.98%) |
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 659424 720845 721803 546563 640879 592127 615471 777542 779822 781612 785987 787229 791630 793245 793473 797363 798503 799758 779511 781036 785889 792210 795028 800951 805111 724874 725053 730165 730482 731183 731407 733447 734355 737973 743006 746219 748917 752273 755830 761282 761401 763232 767521 770693 772256 772307 781553 784084 786067 793929 797319 803418 727510 739634 753641 769074 770026 772376 726316 726356 733196 735769 736145 741765 743821 752933 756296 763502 764313 765145 772443 728711 730269 740864 749827 765369 767519 769599 728936 729304 731125 731212 731218 741184 746301 766092 767721 773375 773378 773502 722094 722117 722151 723216 777489 778929 779550 781531 784685 787147 787230 787316 791608 791825 438665 511013 671915 777521 678647 709284 627218 616344 635812 826345 827407 506238 779410 813297 810361 385600 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.31%) |
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 385600 438665 506238 511013 546563 592127 615471 616344 627218 635812 640879 659424 671915 678647 709284 720845 721803 722094 722117 722151 723216 724874 725053 726316 726356 727510 728711 728936 729304 730165 730269 730482 731125 731183 731212 731218 731407 733196 733447 734355 735769 736145 737973 739634 740864 741184 741765 743006 743821 746219 746301 748917 749827 752273 752933 753641 755830 756296 761282 761401 763232 763502 764313 765145 765369 766092 767519 767521 767721 769074 769599 770026 770693 772256 772307 772376 772443 773375 773378 773502 777489 777521 777542 778929 779410 779511 779550 779822 781036 781531 781553 781612 784084 784685 785889 785987 786067 787147 787229 787230 791608 791630 791825 792210 793245 793473 793929 795028 797319 797363 798503 799758 800951 803418 805111 810361 813297 826345 827407 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mouth любительск"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mouth amateur"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mouth любительск"
]
|
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.