Query Metrics
7
Database Queries
7
Different statements
182.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.49 ms (87.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 122634 408911 415879 416531 416690 424765 427132 432670 438455 438880 440659 443260 448115 448791 452780 452800 455080 459403 460765 483730 494531 500338 518550 519352 525279 530688 534574 535290 541858 550857 554983 560026 565621 576888 582636 585818 590831 594053 600958 605566 608650 616117 618799 634686 635129 640081 640266 640306 642158 648898 649372 657567 659209 659944 669546 682822 686331 706894 710434 714205 720448 729327 739084 739130 739139 739791 739804 740858 743208 744018 744047 745066 746096 749207 751314 753105 756779 757459 758098 759198 760200 760513 761191 761430 769029 769364 770261 772242 772272 776011 776034 777760 777838 778449 778610 778779 780185 780274 782047 783048 783056 784035 786232 787469 787815 791080 791389 791886 796685 796753 799938 803506 804000 806819 807122 807560 808604 809686 812399 814970 ] |
||||||||||||||||||||||||||||||
|
12.18 ms (6.68%) |
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 494531 415879 443260 438880 424765 452800 455080 448791 460765 483730 534574 500338 427132 518550 416531 408911 416690 432670 459403 448115 565621 554983 582636 659209 600958 803506 744047 770261 739139 452780 440659 438455 525279 122634 669546 808604 541858 682822 686331 659944 594053 585818 608650 618799 605566 634686 814970 519352 530688 535290 560026 576888 648898 649372 710434 657567 706894 714205 720448 550857 616117 642158 640081 640266 640306 590831 776034 777760 780274 787815 807122 812399 777838 778449 791080 796685 739791 740858 744018 749207 761430 772272 782047 783056 786232 787469 791389 796753 807560 809686 729327 751314 739130 745066 739084 739804 743208 758098 760200 761191 772242 746096 753105 756779 757459 759198 760513 769029 769364 635129 776011 778610 778779 780185 783048 784035 791886 799938 804000 806819 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.76%) |
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 122634 408911 415879 416531 416690 424765 427132 432670 438455 438880 440659 443260 448115 448791 452780 452800 455080 459403 460765 483730 494531 500338 518550 519352 525279 530688 534574 535290 541858 550857 554983 560026 565621 576888 582636 585818 590831 594053 600958 605566 608650 616117 618799 634686 635129 640081 640266 640306 642158 648898 649372 657567 659209 659944 669546 682822 686331 706894 710434 714205 720448 729327 739084 739130 739139 739791 739804 740858 743208 744018 744047 745066 746096 749207 751314 753105 756779 757459 758098 759198 760200 760513 761191 761430 769029 769364 770261 772242 772272 776011 776034 777760 777838 778449 778610 778779 780185 780274 782047 783048 783056 784035 786232 787469 787815 791080 791389 791886 796685 796753 799938 803506 804000 806819 807122 807560 808604 809686 812399 814970 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur webcam dildo"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск вебкамер дилд"
]
|
||||||||||||||||||||||||||||||
|
1.61 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.