Query Metrics
7
Database Queries
7
Different statements
205.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.54 ms (87.70%) |
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 145280 277607 388410 401374 414749 427053 429591 431465 435593 437369 438465 444086 444241 446170 450302 452861 455568 457799 459028 460029 461953 466030 466488 469427 470024 471048 475605 475775 479604 480984 483884 495251 498079 498648 499390 505771 512439 513681 516498 520182 533774 534170 536800 539808 541018 543670 544058 546384 547608 547803 564640 573973 591420 591425 592656 598728 600325 608188 618769 659212 660283 663336 672809 680676 689762 698233 701854 704613 711364 713768 715261 719475 725431 725507 731581 733437 733670 736804 736869 740906 743105 743246 745352 745720 747423 751025 751318 752805 753599 754657 755045 755287 756492 756520 758076 759068 762171 763407 764057 764743 764750 766173 767908 774099 779698 782520 783175 783288 791439 791955 792308 796511 802259 803384 806638 809577 809939 812389 826995 828026 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (6.40%) |
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 736804 740906 751318 758076 764750 779698 783288 809577 809939 812389 533774 539808 543670 659212 672809 680676 660283 598728 608188 618769 782520 791955 796511 725507 743105 751025 736869 745720 745352 764057 731581 762171 711364 713768 792308 427053 512439 444241 826995 828026 541018 547608 719475 689762 698233 715261 546384 591425 783175 791439 806638 725431 747423 763407 756492 756520 759068 766173 752805 753599 755045 767908 733670 743246 755287 764743 774099 701854 802259 414749 145280 388410 536800 754657 573973 803384 733437 663336 437369 446170 471048 450302 469427 483884 544058 547803 564640 704613 592656 591420 600325 431465 461953 475605 479604 435593 438465 455568 457799 459028 466030 475775 401374 452861 277607 429591 444086 460029 470024 480984 466488 534170 498648 505771 516498 495251 498079 499390 513681 520182 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.15%) |
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 145280 277607 388410 401374 414749 427053 429591 431465 435593 437369 438465 444086 444241 446170 450302 452861 455568 457799 459028 460029 461953 466030 466488 469427 470024 471048 475605 475775 479604 480984 483884 495251 498079 498648 499390 505771 512439 513681 516498 520182 533774 534170 536800 539808 541018 543670 544058 546384 547608 547803 564640 573973 591420 591425 592656 598728 600325 608188 618769 659212 660283 663336 672809 680676 689762 698233 701854 704613 711364 713768 715261 719475 725431 725507 731581 733437 733670 736804 736869 740906 743105 743246 745352 745720 747423 751025 751318 752805 753599 754657 755045 755287 756492 756520 758076 759068 762171 763407 764057 764743 764750 766173 767908 774099 779698 782520 783175 783288 791439 791955 792308 796511 802259 803384 806638 809577 809939 812389 826995 828026 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.79%) |
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.