Query Metrics
7
Database Queries
7
Different statements
169.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.38 ms (85.98%) |
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 382433 384978 389593 390707 408429 418801 432504 447083 447111 454511 464650 466354 470071 470288 470674 472107 475911 476430 478771 480689 483194 483846 487826 491320 497205 499006 500710 502328 502648 503315 509614 520154 522813 526882 538384 538406 547726 553645 555970 566485 567190 569846 569878 569887 570239 570277 570463 570503 570647 571855 571890 571891 571906 572809 572811 573097 573662 573840 576396 584479 595654 596184 596578 596673 597075 597472 597827 597831 598749 599879 600364 619101 623484 628997 630172 633480 633692 652996 653264 668845 669414 669646 671104 671146 672790 673552 674245 689819 689976 695752 702908 704892 715068 717708 721288 731092 731660 741764 745389 754078 767682 772743 773185 781115 781354 790946 793894 794728 803155 812513 816750 819916 824757 825634 825920 826680 827556 828450 828551 828789 ] |
||||||||||||||||||||||||||||||
|
14.96 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 597075 470674 499006 522813 447111 432504 483194 633480 576396 478771 731660 569878 570647 447083 584479 754078 553645 567190 597827 389593 487826 569846 571906 596673 509614 502328 717708 472107 454511 491320 596578 520154 572809 597472 500710 598749 480689 475911 470071 476430 600364 464650 502648 570277 470288 671104 597831 668845 628997 573662 824757 623484 773185 794728 702908 547726 573097 731092 570463 704892 569887 599879 571890 570239 573840 595654 781354 538384 538406 497205 503315 745389 825920 571855 630172 483846 671146 689976 669414 803155 772743 382433 741764 526882 828789 672790 781115 384978 816750 466354 695752 673552 767682 633692 418801 408429 826680 653264 596184 790946 570503 555970 572811 715068 390707 819916 827556 825634 828551 828450 566485 571891 689819 721288 652996 669646 674245 619101 812513 793894 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.44%) |
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 382433 384978 389593 390707 408429 418801 432504 447083 447111 454511 464650 466354 470071 470288 470674 472107 475911 476430 478771 480689 483194 483846 487826 491320 497205 499006 500710 502328 502648 503315 509614 520154 522813 526882 538384 538406 547726 553645 555970 566485 567190 569846 569878 569887 570239 570277 570463 570503 570647 571855 571890 571891 571906 572809 572811 573097 573662 573840 576396 584479 595654 596184 596578 596673 597075 597472 597827 597831 598749 599879 600364 619101 623484 628997 630172 633480 633692 652996 653264 668845 669414 669646 671104 671146 672790 673552 674245 689819 689976 695752 702908 704892 715068 717708 721288 731092 731660 741764 745389 754078 767682 772743 773185 781115 781354 790946 793894 794728 803155 812513 816750 819916 824757 825634 825920 826680 827556 828450 828551 828789 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy русск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy russian"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy русск"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.89%) |
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.