Query Metrics
7
Database Queries
7
Different statements
156.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.00 ms (85.90%) |
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 74135 208554 385355 385713 386193 388930 389541 391674 391940 392839 394130 394620 395252 396119 399036 401239 401353 401764 403754 403806 413673 415977 416704 416738 428195 435593 441092 441834 443095 456048 470136 471671 476142 481905 483791 485338 497864 500621 505597 505649 511862 512074 512087 512357 521338 521716 534540 537138 539272 580216 593105 602485 604228 604453 618280 622720 632114 648224 651963 665588 665928 666109 671038 672315 673217 678707 696607 708153 713174 716828 717516 727965 728215 736307 740932 748491 749221 752617 757128 761621 761632 766943 770210 770254 771887 784775 791772 792376 792749 792761 793693 794213 794250 794472 796647 798251 799696 800543 801628 801629 801643 801832 802756 802898 803509 803582 804198 804417 805281 805354 809015 811700 811765 811771 813205 817074 827829 827859 827897 827932 ] |
||||||||||||||||||||||||||||||
|
12.73 ms (8.16%) |
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 794250 799696 805281 805354 811700 811771 813205 784775 792376 792761 793693 798251 803509 803582 804198 740932 800543 801832 811765 727965 736307 749221 761621 766943 771887 748491 770254 728215 752617 622720 791772 794213 801629 801643 802756 804417 809015 399036 392839 435593 386193 388930 395252 512087 512357 521338 505597 396119 443095 511862 512074 505649 537138 648224 672315 696607 671038 717516 796647 770210 391940 401239 403754 385713 74135 385355 394130 391674 389541 401353 817074 394620 441092 794472 678707 497864 483791 618280 716828 665928 708153 401764 827859 827829 827897 500621 539272 665588 651963 666109 604228 602485 604453 632114 521716 713174 593105 802898 580216 673217 416704 428195 485338 208554 827932 534540 470136 481905 801628 761632 757128 792749 403806 413673 441834 416738 415977 456048 476142 471671 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.56%) |
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 74135 208554 385355 385713 386193 388930 389541 391674 391940 392839 394130 394620 395252 396119 399036 401239 401353 401764 403754 403806 413673 415977 416704 416738 428195 435593 441092 441834 443095 456048 470136 471671 476142 481905 483791 485338 497864 500621 505597 505649 511862 512074 512087 512357 521338 521716 534540 537138 539272 580216 593105 602485 604228 604453 618280 622720 632114 648224 651963 665588 665928 666109 671038 672315 673217 678707 696607 708153 713174 716828 717516 727965 728215 736307 740932 748491 749221 752617 757128 761621 761632 766943 770210 770254 771887 784775 791772 792376 792749 792761 793693 794213 794250 794472 796647 798251 799696 800543 801628 801629 801643 801832 802756 802898 803509 803582 804198 804417 805281 805354 809015 811700 811765 811771 813205 817074 827829 827859 827897 827932 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.