Query Metrics
7
Database Queries
7
Different statements
137.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.58 ms (84.20%) |
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 233517 397417 474242 485343 485929 489728 494963 502538 502805 502868 520916 533771 536944 539637 543702 552816 563291 572928 603745 605730 615467 617625 623745 631280 635133 652552 652905 662443 668133 673908 674292 675769 675817 677343 679352 685406 687447 689167 693273 694164 704169 704673 705111 712952 713921 715435 716992 722253 722434 730819 731075 731123 731197 733651 739459 742208 747429 751963 760515 761650 763462 763472 763993 764060 764623 765091 765101 765109 766159 766253 766303 766370 766885 768472 772559 776001 776369 777227 778175 778256 779981 782307 782721 783887 784612 784813 786227 786320 787286 787524 790297 791709 792519 798809 804872 807361 809575 809965 809976 813331 818268 818826 819895 819940 819941 820156 820167 820196 820202 820203 820214 824546 824849 825645 825794 825829 825861 825867 ] |
||||||||||||||||||||||||||||||
|
12.15 ms (8.85%) |
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 502868 784612 813331 572928 677343 787524 790297 807361 536944 520916 675769 552816 766253 675817 778175 820214 820202 825861 689167 615467 685406 791709 825867 687447 760515 778256 673908 818268 766159 233517 776369 763462 819940 766303 704169 694164 603745 776001 763472 623745 747429 674292 820196 494963 766885 765101 765109 809976 782307 635133 779981 782721 786320 533771 668133 787286 502538 824849 563291 792519 766370 777227 798809 489728 783887 804872 731197 768472 764060 824546 731075 502805 825794 819941 652905 751963 819895 652552 662443 786227 764623 763993 605730 704673 705111 713921 733651 820167 825645 543702 742208 765091 772559 693273 712952 617625 732108 739943 474242 818826 820156 539637 679352 722434 784813 731123 631280 716992 761650 485929 730819 809575 825829 820203 722253 715435 739459 809965 397417 485343 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (2.02%) |
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 233517 397417 474242 485343 485929 489728 494963 502538 502805 502868 520916 533771 536944 539637 543702 552816 563291 572928 603745 605730 615467 617625 623745 631280 635133 652552 652905 662443 668133 673908 674292 675769 675817 677343 679352 685406 687447 689167 693273 694164 704169 704673 705111 712952 713921 715435 716992 722253 722434 730819 731075 731123 731197 733651 739459 742208 747429 751963 760515 761650 763462 763472 763993 764060 764623 765091 765101 765109 766159 766253 766303 766370 766885 768472 772559 776001 776369 777227 778175 778256 779981 782307 782721 783887 784612 784813 786227 786320 787286 787524 790297 791709 792519 798809 804872 807361 809575 809965 809976 813331 818268 818826 819895 819940 819941 820156 820167 820196 820202 820203 820214 824546 824849 825645 825794 825829 825861 825867 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ukrainian real sex"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск real секс"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск real секс"
]
|
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.