Query Metrics
7
Database Queries
7
Different statements
177.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.88 ms (85.41%) |
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 7170 54378 282099 373798 373981 384325 385710 388007 388175 389315 393331 396528 397072 399888 401814 408489 410374 411937 415048 416303 420118 429898 432366 432536 433304 434863 443582 444956 447209 447888 452539 455783 458272 458583 459382 466572 466599 466612 472712 475317 476157 476957 478593 481216 484110 486055 486316 492392 494384 495153 505441 511481 514386 515226 518566 520790 525043 525102 526564 528459 540175 544535 545189 548280 566786 567947 569511 574244 576307 577362 581677 595384 604560 611616 613471 620399 621686 622068 623209 626752 627730 632051 634561 636277 659637 678799 686061 687928 696977 705521 713037 719244 722557 729873 730464 737390 741113 744006 744852 753448 753890 759543 761576 775993 776015 779704 786004 799948 799980 812115 814138 817057 819519 821091 821667 822142 823479 826800 ] |
||||||||||||||||||||||||||||||
|
16.73 ms (9.41%) |
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 634561 447888 416303 447209 466572 466599 472712 476957 429898 444956 459382 514386 525102 486316 492392 518566 526564 528459 515226 525043 604560 384325 393331 373981 7170 389315 388007 396528 397072 399888 814138 821091 822142 823479 817057 819519 821667 826800 466612 478593 458583 458272 475317 494384 569511 678799 686061 659637 696977 722557 687928 705521 718662 576307 581677 613471 620399 621686 622068 626752 632051 636277 595384 775993 799980 812115 786004 729873 744852 753890 761576 759543 769740 730464 737390 744006 753448 741113 623209 713037 719244 776015 779704 799948 432366 432536 282099 373798 411937 54378 408489 484110 495153 577362 566786 574244 611616 627730 486055 385710 388175 401814 420118 410374 415048 434863 443582 433304 455783 476157 481216 452539 520790 505441 540175 511481 544535 548280 567947 545189 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.54%) |
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 7170 54378 282099 373798 373981 384325 385710 388007 388175 389315 393331 396528 397072 399888 401814 408489 410374 411937 415048 416303 420118 429898 432366 432536 433304 434863 443582 444956 447209 447888 452539 455783 458272 458583 459382 466572 466599 466612 472712 475317 476157 476957 478593 481216 484110 486055 486316 492392 494384 495153 505441 511481 514386 515226 518566 520790 525043 525102 526564 528459 540175 544535 545189 548280 566786 567947 569511 574244 576307 577362 581677 595384 604560 611616 613471 620399 621686 622068 623209 626752 627730 632051 634561 636277 659637 678799 686061 687928 696977 705521 713037 719244 722557 729873 730464 737390 741113 744006 744852 753448 753890 759543 761576 775993 776015 779704 786004 799948 799980 812115 814138 817057 819519 821091 821667 822142 823479 826800 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen man sperm"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen мужчин сперм"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen мужчин сперм"
]
|
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.