Query Metrics
7
Database Queries
7
Different statements
191.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.29 ms (86.84%) |
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 182213 417348 444064 444485 462225 497471 531852 532639 535290 539898 545551 550262 550857 553877 554170 560026 569391 575171 582076 583420 584047 588157 589526 590831 595229 607107 616117 619026 621382 622427 622723 630752 636907 640081 640306 642076 642158 654257 656879 657567 663234 663317 663751 671520 672894 686338 688367 697582 698385 705378 705571 713186 720101 720448 739791 739804 743208 745201 745931 746096 749207 749603 751706 753918 754425 760200 760513 760545 760594 764724 765164 772242 772257 772272 774881 776034 777760 777767 778449 779291 781251 781420 782046 782080 782141 782334 782861 782952 783048 784035 788530 788531 790091 791122 791503 791880 791886 792697 792730 793017 794307 796689 796716 796965 796994 798591 799938 803613 806657 806764 806819 811913 812031 812399 813796 814671 824191 824632 827111 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (7.80%) |
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 753918 531852 582076 663234 550262 745201 760594 813796 814671 539898 532639 619026 782952 788530 790091 774881 782046 788531 791122 796965 781420 793017 765164 754425 760545 764724 777767 779291 781251 782334 791503 796689 796994 803613 806764 812031 462225 782141 782080 663317 796716 745931 792697 417348 444485 569391 444064 636907 656879 824191 553877 554170 583420 663751 688367 672894 621382 622723 630752 622427 697582 182213 584047 654257 686338 588157 589526 705378 497471 575171 545551 671520 720101 794307 792730 772257 824632 827111 798591 535290 560026 657567 720448 550857 616117 642158 640081 640306 590831 776034 777760 811913 812399 778449 782861 806657 739791 749207 751706 772272 749603 739804 743208 760200 772242 746096 760513 769574 698385 783048 784035 791886 799938 806819 713186 595229 607107 642076 705571 791880 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.72%) |
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 182213 417348 444064 444485 462225 497471 531852 532639 535290 539898 545551 550262 550857 553877 554170 560026 569391 575171 582076 583420 584047 588157 589526 590831 595229 607107 616117 619026 621382 622427 622723 630752 636907 640081 640306 642076 642158 654257 656879 657567 663234 663317 663751 671520 672894 686338 688367 697582 698385 705378 705571 713186 720101 720448 739791 739804 743208 745201 745931 746096 749207 749603 751706 753918 754425 760200 760513 760545 760594 764724 765164 772242 772257 772272 774881 776034 777760 777767 778449 779291 781251 781420 782046 782080 782141 782334 782861 782952 783048 784035 788530 788531 790091 791122 791503 791880 791886 792697 792730 793017 794307 796689 796716 796965 796994 798591 799938 803613 806657 806764 806819 811913 812031 812399 813796 814671 824191 824632 827111 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo amateur"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд любительск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
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.