Query Metrics
7
Database Queries
7
Different statements
170.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.27 ms (86.04%) |
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 7172 338149 346082 416675 441027 443917 479788 483735 516699 529089 534092 537667 541992 544181 552692 567684 582842 590035 590046 592855 610911 611491 616743 625967 629167 631436 632935 636049 637259 640090 643647 646138 654906 655131 656494 656579 656812 656826 657225 661951 663208 663303 674866 675612 679576 686521 707088 707181 711328 712779 716561 719249 719454 721148 722403 724163 724971 726243 730362 733668 734895 734928 736196 737049 741177 743081 743578 747625 755552 758068 759397 760249 760932 761748 761774 762424 762449 764834 765327 765617 765760 765926 766794 766888 766897 769788 771353 775554 776184 777953 778095 788057 790821 790941 791423 791777 791783 792067 792089 792970 793977 796679 797101 797194 799995 800394 800431 800528 804335 804550 804695 812941 813747 814580 816185 823831 825890 826414 827434 828788 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (7.04%) |
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 759397 441027 760932 416675 721148 479788 760249 483735 529089 7172 722403 743081 541992 643647 792970 776184 346082 711328 674866 743578 443917 813747 656579 719454 663208 663303 590046 616743 636049 610911 611491 804335 762449 826414 707181 816185 828788 796679 764834 825890 827434 791777 707088 625967 629167 799995 733668 552692 814580 537667 582842 567684 654906 655131 656812 675612 656494 686521 656826 637259 590035 632935 592855 778095 788057 800528 804550 812941 747625 755552 791423 797194 800394 762424 766897 726243 730362 765327 765760 724163 736196 761748 765926 734895 734928 758068 765617 631436 716561 790821 790941 792089 793977 823831 534092 544181 646138 719249 777953 769788 800431 338149 516699 679576 712779 657225 661951 792067 804695 775554 797101 737049 741177 766794 771353 724971 766888 761774 640090 791783 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.95%) |
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 7172 338149 346082 416675 441027 443917 479788 483735 516699 529089 534092 537667 541992 544181 552692 567684 582842 590035 590046 592855 610911 611491 616743 625967 629167 631436 632935 636049 637259 640090 643647 646138 654906 655131 656494 656579 656812 656826 657225 661951 663208 663303 674866 675612 679576 686521 707088 707181 711328 712779 716561 719249 719454 721148 722403 724163 724971 726243 730362 733668 734895 734928 736196 737049 741177 743081 743578 747625 755552 758068 759397 760249 760932 761748 761774 762424 762449 764834 765327 765617 765760 765926 766794 766888 766897 769788 771353 775554 776184 777953 778095 788057 790821 790941 791423 791777 791783 792067 792089 792970 793977 796679 797101 797194 799995 800394 800431 800528 804335 804550 804695 812941 813747 814580 816185 823831 825890 826414 827434 828788 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal riding ass"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал riding жоп"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал riding жоп"
]
|
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.