Query Metrics
7
Database Queries
7
Different statements
171.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.76 ms (85.11%) |
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 385681 395424 397694 490700 492064 530205 531035 534799 535791 550943 563243 575636 577270 594359 595964 614297 616290 622646 631098 637361 640396 646359 647064 647173 649338 675460 675745 679089 687114 700033 703275 703729 704489 707729 713474 713642 715087 716532 716726 719215 724017 728633 731098 734955 735735 736063 736756 738430 740243 740933 742081 747160 752167 753520 754431 758738 762677 766292 772492 773151 774138 776365 778892 781918 782095 782492 782704 783383 783436 783676 783809 783995 784230 784411 786222 787740 788122 791774 792452 793033 793430 796222 796709 799113 799544 803085 803285 805591 805880 806245 806646 806997 807634 808645 809991 813634 813910 818296 818416 818676 819109 819889 820090 820525 820802 821183 821304 821815 822910 823178 823839 824128 824307 825003 825440 825634 826272 827464 827649 828346 ] |
||||||||||||||||||||||||||||||
|
13.70 ms (8.00%) |
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 783676 806245 397694 577270 675460 647173 637361 640396 595964 782095 773151 754431 614297 783383 799544 492064 740933 531035 793033 826272 818296 818676 824128 824307 825634 828346 535791 534799 703275 719215 716726 646359 649338 631098 594359 783809 776365 782492 787740 728633 734955 752167 792452 735735 736756 747160 753520 616290 703729 782704 803085 803285 827649 530205 550943 679089 687114 707729 704489 778892 781918 799113 772492 805880 740243 738430 713474 783436 788122 796222 808645 395424 820090 675745 713642 791774 758738 793430 806646 766292 827464 820802 822910 821183 825440 563243 715087 700033 783995 806997 724017 784411 786222 805591 809991 731098 742081 762677 774138 622646 784230 796709 807634 575636 716532 736063 385681 813910 819109 823178 825003 813634 818416 821304 821815 823839 819889 820525 490700 647064 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (2.52%) |
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 385681 395424 397694 490700 492064 530205 531035 534799 535791 550943 563243 575636 577270 594359 595964 614297 616290 622646 631098 637361 640396 646359 647064 647173 649338 675460 675745 679089 687114 700033 703275 703729 704489 707729 713474 713642 715087 716532 716726 719215 724017 728633 731098 734955 735735 736063 736756 738430 740243 740933 742081 747160 752167 753520 754431 758738 762677 766292 772492 773151 774138 776365 778892 781918 782095 782492 782704 783383 783436 783676 783809 783995 784230 784411 786222 787740 788122 791774 792452 793033 793430 796222 796709 799113 799544 803085 803285 805591 805880 806245 806646 806997 807634 808645 809991 813634 813910 818296 818416 818676 819109 819889 820090 820525 820802 821183 821304 821815 822910 823178 823839 824128 824307 825003 825440 825634 826272 827464 827649 828346 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"all девушк"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"all девушк"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"all girl"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.