Query Metrics
7
Database Queries
7
Different statements
158.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.45 ms (86.36%) |
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 386266 419361 444169 444337 455861 466825 495768 500531 509290 511841 512528 516900 517493 546562 567559 571770 609783 627167 632450 633649 644022 700195 703715 703729 705418 707742 710032 711510 712359 712667 714360 718463 718583 718629 723712 723957 725054 725410 728492 728947 729111 730730 730782 731214 738019 738560 739662 744164 746576 746637 747684 750902 752396 753178 755605 757865 762133 763250 764191 764759 765536 768343 768624 770067 771238 772461 775244 775631 778928 779147 779859 779936 780182 780225 780469 783988 786206 786690 787596 787847 789902 791581 793158 793527 793868 795809 798791 813687 816811 818097 819828 819829 823656 823841 824113 824140 824144 824163 824220 824529 824815 824973 824979 825006 825068 825080 825460 825615 825705 825723 826003 826252 826263 826464 826478 826586 827059 828550 828555 ] |
||||||||||||||||||||||||||||||
|
11.50 ms (7.28%) |
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 728947 750902 723957 725410 731214 739662 728492 738560 746637 757865 763250 725054 762133 764759 632450 633649 644022 700195 703715 703729 705418 707742 710032 711510 712359 712667 714360 718463 718583 718629 775631 780396 789902 795809 500531 512528 517493 516900 609783 444337 444169 455861 509290 495768 511841 419361 386266 823841 791581 824220 824529 824815 825006 825080 825460 825705 826478 826586 823656 825723 826003 827059 813687 819829 824113 824979 825615 825068 824144 828550 828555 466825 567559 546562 571770 627167 775244 778928 779859 779936 780225 786690 793527 793868 779147 780469 783988 786206 723712 752396 753178 772461 787596 793158 730782 747684 768343 730730 764191 768624 729111 744164 755605 765536 738019 746576 770067 771238 780182 787847 798791 816811 824163 824973 826252 824140 818097 819828 826263 826464 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.22%) |
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 386266 419361 444169 444337 455861 466825 495768 500531 509290 511841 512528 516900 517493 546562 567559 571770 609783 627167 632450 633649 644022 700195 703715 703729 705418 707742 710032 711510 712359 712667 714360 718463 718583 718629 723712 723957 725054 725410 728492 728947 729111 730730 730782 731214 738019 738560 739662 744164 746576 746637 747684 750902 752396 753178 755605 757865 762133 763250 764191 764759 765536 768343 768624 770067 771238 772461 775244 775631 778928 779147 779859 779936 780182 780225 780469 783988 786206 786690 787596 787847 789902 791581 793158 793527 793868 795809 798791 813687 816811 818097 819828 819829 823656 823841 824113 824140 824144 824163 824220 824529 824815 824973 824979 825006 825068 825080 825460 825615 825705 825723 826003 826252 826263 826464 826478 826586 827059 828550 828555 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur cum"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск cum"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.92%) |
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.