Query Metrics
7
Database Queries
7
Different statements
176.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.51 ms (86.28%) |
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 50344 109176 389787 398436 400563 401154 408824 410328 446524 449862 480552 488956 493317 500778 513986 526017 530092 530415 530664 530698 537764 540101 541166 541184 541194 542443 542460 547941 550107 550116 550125 550595 554705 554706 554709 554734 557461 566737 570931 573288 580379 580998 592741 602251 607312 608679 611541 618056 621004 625778 627833 640239 648295 649707 651639 652779 652959 660364 661327 661342 661347 661377 661576 662072 669357 669930 670356 672938 680954 681242 692683 692686 692713 692721 692763 696424 705736 708090 709855 713094 732865 735504 736031 738427 742668 744568 746967 751377 751422 754680 768598 768669 770452 773275 779605 780884 783656 784050 784147 786200 787021 787967 788624 789650 792508 798667 799683 805290 805584 811790 812060 812228 812230 812238 814166 816816 819240 825538 827454 827555 ] |
||||||||||||||||||||||||||||||
|
13.62 ms (7.71%) |
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 661327 627833 602251 530415 554705 692683 786200 746967 480552 554734 742668 681242 735504 513986 573288 488956 408824 692686 580998 389787 672938 550116 640239 449862 625778 530698 580379 669357 670356 410328 554706 541184 705736 649707 661347 680954 621004 784050 773275 768669 661377 692763 692721 661342 669930 550595 618056 738427 754680 787021 812060 50344 819240 540101 541194 542460 708090 812228 783656 799683 651639 660364 805290 805584 784147 652779 446524 751422 770452 811790 692713 816816 779605 550107 570931 608679 109176 652959 732865 792508 400563 814166 825538 530664 542443 566737 547941 554709 611541 592741 789650 736031 812230 812238 768598 744568 751377 709855 780884 398436 530092 526017 788624 713094 401154 662072 648295 550125 493317 500778 557461 661576 798667 827454 827555 537764 541166 696424 607312 787967 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.79%) |
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 50344 109176 389787 398436 400563 401154 408824 410328 446524 449862 480552 488956 493317 500778 513986 526017 530092 530415 530664 530698 537764 540101 541166 541184 541194 542443 542460 547941 550107 550116 550125 550595 554705 554706 554709 554734 557461 566737 570931 573288 580379 580998 592741 602251 607312 608679 611541 618056 621004 625778 627833 640239 648295 649707 651639 652779 652959 660364 661327 661342 661347 661377 661576 662072 669357 669930 670356 672938 680954 681242 692683 692686 692713 692721 692763 696424 705736 708090 709855 713094 732865 735504 736031 738427 742668 744568 746967 751377 751422 754680 768598 768669 770452 773275 779605 780884 783656 784050 784147 786200 787021 787967 788624 789650 792508 798667 799683 805290 805584 811790 812060 812228 812230 812238 814166 816816 819240 825538 827454 827555 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public dildo solo"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.