Query Metrics
7
Database Queries
7
Different statements
181.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.09 ms (88.66%) |
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 396421 422129 425733 432757 435232 450448 457522 459008 459765 460380 485178 489160 493019 517789 529851 540858 546181 546321 546562 546852 587745 597187 606886 612511 629776 629979 631211 634599 634614 634615 636224 651757 662062 675149 696127 699316 700219 703720 703750 706008 706014 706018 707229 712569 713133 714359 716937 716947 723712 723949 724671 727024 730730 730754 731148 736460 742139 742785 743361 743609 753178 755605 761235 763955 764191 764983 765536 768199 768624 771931 772461 777535 780182 780225 780976 781128 781130 781437 782738 783676 786206 786690 787668 788026 788347 789490 790869 791655 791769 793500 793527 793669 793868 794262 794583 794680 795627 795814 802137 805001 808840 816709 818735 819281 819326 819785 819829 823656 823842 824053 824144 824948 825080 825460 825723 825792 826452 827562 828560 ] |
||||||||||||||||||||||||||||||
|
10.36 ms (5.70%) |
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 771931 777535 795814 789490 493019 825080 825460 540858 823656 823842 824948 826151 826452 825723 827562 816709 818735 819281 819785 819829 824053 825792 819326 824144 828560 529851 546321 546852 546562 699316 703720 703750 700219 706008 716937 696127 712569 714359 546181 612511 629776 631211 634599 636224 780225 780976 781128 786690 793527 793868 781130 786206 794262 794583 795627 723712 723949 743361 753178 772461 781437 787668 791769 730730 736460 764191 764983 768624 730754 743609 755605 765536 742785 629979 706018 780182 783676 788347 517789 396421 425733 450448 485178 662062 713133 606886 587745 634615 597187 634614 793500 790869 724671 731148 788026 794680 808840 763955 782738 422129 432757 651757 716947 675149 707229 802137 805001 727024 761235 768199 793669 742139 706014 791655 435232 459008 459765 460380 489160 457522 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.54%) |
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 396421 422129 425733 432757 435232 450448 457522 459008 459765 460380 485178 489160 493019 517789 529851 540858 546181 546321 546562 546852 587745 597187 606886 612511 629776 629979 631211 634599 634614 634615 636224 651757 662062 675149 696127 699316 700219 703720 703750 706008 706014 706018 707229 712569 713133 714359 716937 716947 723712 723949 724671 727024 730730 730754 731148 736460 742139 742785 743361 743609 753178 755605 761235 763955 764191 764983 765536 768199 768624 771931 772461 777535 780182 780225 780976 781128 781130 781437 782738 783676 786206 786690 787668 788026 788347 789490 790869 791655 791769 793500 793527 793669 793868 794262 794583 794680 795627 795814 802137 805001 808840 816709 818735 819281 819326 819785 819829 823656 823842 824053 824144 824948 825080 825460 825723 825792 826452 827562 828560 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum close up"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum close up"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum close up"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.