Query Metrics
7
Database Queries
7
Different statements
161.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.30 ms (85.72%) |
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 388227 395871 396188 396519 401944 402834 410308 415320 417136 417821 426361 426444 427909 428173 428972 430977 441479 443499 444937 446157 446162 447348 450674 451589 457953 458094 458487 461644 461964 463906 463943 463945 463955 465773 465993 470045 484342 484814 488696 491328 492380 493218 494693 495670 496585 496738 497554 501647 501755 502390 505905 508143 510619 512099 519012 519083 523871 526583 529061 543162 552397 561012 575606 583082 595478 597030 597498 597518 597798 597823 598135 598519 598544 598754 600146 621081 624170 630921 633870 636049 639552 640466 647275 650230 652955 654346 656579 656593 657143 659329 660338 662148 670048 671665 671670 671952 672070 672780 680230 683092 694492 695993 696160 707088 712583 717235 717890 719376 720223 720362 720397 722628 722649 731683 777056 795684 807519 810701 814228 821132 ] |
||||||||||||||||||||||||||||||
|
13.85 ms (8.58%) |
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 597030 597498 597518 598519 810701 446157 428173 430977 446162 447348 461964 463906 463943 463955 465773 388227 395871 396188 458094 461644 470045 401944 402834 410308 415320 417136 426361 426444 427909 428972 443499 450674 457953 463945 465993 444937 451589 502390 505905 491328 492380 494693 519083 523871 526583 484342 493218 496738 501647 510619 519012 484814 488696 495670 496585 497554 501755 512099 458487 508143 731683 630921 396519 417821 441479 814228 821132 529061 561012 543162 552397 583082 650230 656579 657143 670048 671665 671952 707088 712583 720362 720397 722628 652955 662148 672070 672780 694492 696160 717890 719376 720223 647275 654346 656593 659329 660338 671670 680230 683092 695993 717235 722649 575606 597798 597823 636049 640466 595478 600146 633870 598544 621081 598135 598754 624170 639552 807519 777056 795684 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.37%) |
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 388227 395871 396188 396519 401944 402834 410308 415320 417136 417821 426361 426444 427909 428173 428972 430977 441479 443499 444937 446157 446162 447348 450674 451589 457953 458094 458487 461644 461964 463906 463943 463945 463955 465773 465993 470045 484342 484814 488696 491328 492380 493218 494693 495670 496585 496738 497554 501647 501755 502390 505905 508143 510619 512099 519012 519083 523871 526583 529061 543162 552397 561012 575606 583082 595478 597030 597498 597518 597798 597823 598135 598519 598544 598754 600146 621081 624170 630921 633870 636049 639552 640466 647275 650230 652955 654346 656579 656593 657143 659329 660338 662148 670048 671665 671670 671952 672070 672780 680230 683092 694492 695993 696160 707088 712583 717235 717890 719376 720223 720362 720397 722628 722649 731683 777056 795684 807519 810701 814228 821132 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen dick"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen член"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.