Query Metrics
7
Database Queries
7
Different statements
150.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.19 ms (84.07%) |
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 366036 388180 391187 391527 411374 412533 421600 423837 423936 424011 424107 426784 426886 427147 427148 428651 429696 435528 435698 435883 438459 439281 439285 440217 442155 443248 450520 452425 454078 455119 459622 462131 462143 470023 470195 471333 474206 474214 477137 481226 483854 485294 486857 486933 487299 489378 491149 492959 494598 501130 502559 503099 503706 509298 513667 521202 523606 523687 523695 524402 526747 531745 543546 546986 557896 558919 559811 574076 599245 599985 600272 602048 630453 637727 648664 664181 668700 685742 689207 694102 701963 706442 715965 717095 720113 722924 734251 740561 740852 744952 744953 751680 754577 754915 754921 766174 768431 773654 774146 774824 777677 778037 779641 781381 782466 783247 786601 786770 790730 800143 801430 808507 811142 811441 812039 812060 813587 813626 814449 826233 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (9.21%) |
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 777677 813626 814449 826233 509298 531745 543546 559811 715965 722924 694102 648664 689207 701963 717095 600272 602048 630453 599985 786601 786770 808507 811142 812039 781381 782466 783247 811441 740852 766174 800143 754915 744953 751680 754921 773654 768431 774146 740561 754577 637727 720113 774824 778037 812060 366036 426784 424011 423837 435528 424107 513667 501130 477137 546986 557896 574076 599245 426886 435698 438459 439281 459622 462131 462143 470195 412533 428651 440217 443248 388180 391187 411374 421600 429696 435883 439285 450520 455119 470023 474214 423936 442155 454078 481226 427147 452425 503099 523687 523695 524402 526747 483854 485294 486933 487299 489378 503706 486857 491149 521202 523606 502559 391527 494598 427148 813587 474206 471333 492959 558919 668700 706442 685742 664181 779641 801430 734251 744952 790730 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.13%) |
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 366036 388180 391187 391527 411374 412533 421600 423837 423936 424011 424107 426784 426886 427147 427148 428651 429696 435528 435698 435883 438459 439281 439285 440217 442155 443248 450520 452425 454078 455119 459622 462131 462143 470023 470195 471333 474206 474214 477137 481226 483854 485294 486857 486933 487299 489378 491149 492959 494598 501130 502559 503099 503706 509298 513667 521202 523606 523687 523695 524402 526747 531745 543546 546986 557896 558919 559811 574076 599245 599985 600272 602048 630453 637727 648664 664181 668700 685742 689207 694102 701963 706442 715965 717095 720113 722924 734251 740561 740852 744952 744953 751680 754577 754915 754921 766174 768431 773654 774146 774824 777677 778037 779641 781381 782466 783247 786601 786770 790730 800143 801430 808507 811142 811441 812039 812060 813587 813626 814449 826233 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
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.