Query Metrics
7
Database Queries
7
Different statements
157.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.64 ms (87.63%) |
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 7449 7456 181422 187542 385603 387977 392971 397186 469552 534554 560923 560933 565693 606767 627358 646267 648210 651114 666378 694062 715037 716805 719245 725556 726219 726260 729153 729272 729285 729301 731095 731274 731333 731363 734471 734723 734970 737598 738718 740878 742534 742748 747500 749322 750283 761587 762104 762288 762792 765497 765634 765789 766684 768328 768372 768761 769035 769917 773268 773424 773686 774076 776981 783372 783382 785196 788193 788982 788985 790978 791155 791560 791561 791860 792946 794364 794366 794385 794773 795297 795680 796081 796963 798811 800313 800439 800448 800509 800713 801298 804237 805231 806296 810045 810290 810407 810415 812094 815402 815950 817194 817256 818959 819020 819269 819719 819749 820039 820197 823444 824679 824763 825418 825670 826242 827147 827383 827490 828539 ] |
||||||||||||||||||||||||||||||
|
10.47 ms (6.67%) |
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 798811 800509 776981 783382 794385 795680 800313 800439 800713 801298 805231 725556 729272 729301 731274 731333 761587 762792 774076 783372 785196 791561 792946 794364 795297 796963 800448 810045 810290 726219 729285 731095 762288 768328 729153 734471 749322 762104 765497 766684 768761 773424 773686 740878 742748 765634 769035 731363 738718 747500 765789 769917 627358 788985 796081 806296 810407 7449 812094 715037 469552 181422 187542 392971 7456 817194 825670 826242 817256 819020 827383 818959 819749 824763 819269 819719 820197 824679 825418 827490 828539 534554 565693 666378 716805 560923 560933 791155 791560 794366 804237 794309 788193 773268 726260 768372 734970 742534 750283 606767 719245 788982 790978 791860 794773 810415 387977 397186 385603 823444 734723 815402 827147 820039 815950 694062 646267 648210 651114 737598 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.64%) |
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 7449 7456 181422 187542 385603 387977 392971 397186 469552 534554 560923 560933 565693 606767 627358 646267 648210 651114 666378 694062 715037 716805 719245 725556 726219 726260 729153 729272 729285 729301 731095 731274 731333 731363 734471 734723 734970 737598 738718 740878 742534 742748 747500 749322 750283 761587 762104 762288 762792 765497 765634 765789 766684 768328 768372 768761 769035 769917 773268 773424 773686 774076 776981 783372 783382 785196 788193 788982 788985 790978 791155 791560 791561 791860 792946 794364 794366 794385 794773 795297 795680 796081 796963 798811 800313 800439 800448 800509 800713 801298 804237 805231 806296 810045 810290 810407 810415 812094 815402 815950 817194 817256 818959 819020 819269 819719 819749 820039 820197 823444 824679 824763 825418 825670 826242 827147 827383 827490 828539 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"маму в задницу"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин анал"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.88%) |
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.