Query Metrics
7
Database Queries
7
Different statements
264.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.33 ms (91.03%) |
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 390521 397777 398617 422350 450851 474706 480220 486767 508921 514644 523171 529430 530373 531118 536687 541202 548831 555067 563960 573752 589030 597146 599964 599969 601584 616800 620250 626449 642039 674607 696720 698247 700874 707732 710208 710218 714133 715897 716601 722189 728834 729863 730714 733196 733348 734304 734892 739411 745314 759079 759674 760426 763250 763532 763777 763877 764131 764749 765410 767807 768190 769686 769939 772218 772290 772361 772376 774265 774931 776372 777961 778068 778756 779283 780238 781184 781531 781553 783066 784084 786580 786684 787034 787161 787785 790181 790757 791009 791017 791156 793740 793929 796032 799488 799690 799991 800140 802863 803416 803418 803432 804910 810493 813632 816156 817741 825344 825381 825455 825472 825977 826019 826145 826197 826452 826582 826929 827144 828794 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (5.83%) |
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 698247 799690 763250 777961 450851 486767 599964 541202 474706 826929 828794 536687 514644 826197 601584 597146 800140 799991 781184 803416 803432 769939 764749 774265 772361 787161 826452 790757 787785 531118 599969 826019 530373 825977 825472 816156 767807 422350 825344 827144 529430 573752 813632 616800 716601 825455 783066 786684 729863 763777 710218 791009 793740 802863 781553 784084 790181 793929 803418 772376 730714 733196 745314 728834 707732 781531 787034 796032 824638 817741 825381 826582 523171 548831 674607 710208 763877 791156 397777 826145 772290 398617 715897 480220 563960 700874 696720 714133 776372 778756 786580 810493 774931 780238 804910 733348 734892 764131 760426 763532 772218 759079 759674 626449 779283 791017 769686 642039 620250 508921 589030 734304 768190 765410 722189 778068 390521 799488 739411 555067 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.87%) |
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 390521 397777 398617 422350 450851 474706 480220 486767 508921 514644 523171 529430 530373 531118 536687 541202 548831 555067 563960 573752 589030 597146 599964 599969 601584 616800 620250 626449 642039 674607 696720 698247 700874 707732 710208 710218 714133 715897 716601 722189 728834 729863 730714 733196 733348 734304 734892 739411 745314 759079 759674 760426 763250 763532 763777 763877 764131 764749 765410 767807 768190 769686 769939 772218 772290 772361 772376 774265 774931 776372 777961 778068 778756 779283 780238 781184 781531 781553 783066 784084 786580 786684 787034 787161 787785 790181 790757 791009 791017 791156 793740 793929 796032 799488 799690 799991 800140 802863 803416 803418 803432 804910 810493 813632 816156 817741 825344 825381 825455 825472 825977 826019 826145 826197 826452 826582 826929 827144 828794 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob with cum"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс cum"
]
|
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.