Query Metrics
7
Database Queries
7
Different statements
228.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.64 ms (88.67%) |
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 514348 585924 585948 588160 596558 606361 607068 610725 611545 615519 615953 616290 617609 619343 621381 621390 622484 626582 627243 627545 627697 627983 629376 630035 630087 632300 632319 632472 637809 639237 641172 642365 644734 700691 701400 701639 703300 705031 706797 708943 709102 717790 718058 718086 718629 720937 721260 723795 723824 724816 724899 725168 725248 725259 725379 725750 727159 727317 728639 729046 729171 730394 730591 731499 731554 732451 732685 733132 733617 733943 734709 734798 735215 735280 736067 738131 738753 739081 739122 739632 740625 741081 741261 741370 742271 744523 746940 747621 747659 747770 748043 748409 748482 749428 749536 749765 752025 753179 755110 756381 756408 760334 762299 762631 763695 764128 768656 773879 776390 785237 787261 791244 794049 794350 804075 812638 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (6.81%) |
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 617609 622484 627983 633059 641172 642365 585924 585948 588160 596558 606361 607068 621381 621390 626582 627545 627697 639237 644734 776390 785237 791244 794350 804075 724899 728639 729046 733617 734709 734798 741081 742271 753179 755110 755730 762299 762631 794049 725168 725248 730591 732451 732685 733943 739081 739632 744523 747659 748043 748482 749536 749765 756408 763695 723795 723824 724816 725379 727317 729171 730394 731554 733132 734751 738753 739122 740625 746940 747621 747770 752025 725750 738131 741261 760334 764465 768656 773879 725259 727159 731499 735215 735280 736067 741370 748409 749428 756381 764128 610725 611545 615519 615953 616290 619343 627243 629376 630035 630087 632300 632319 632472 637809 700691 701400 701639 703300 705031 706797 708943 709102 717790 718058 718086 718629 720937 721260 787261 812638 514348 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.14%) |
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 514348 585924 585948 588160 596558 606361 607068 610725 611545 615519 615953 616290 617609 619343 621381 621390 622484 626582 627243 627545 627697 627983 629376 630035 630087 632300 632319 632472 637809 639237 641172 642365 644734 700691 701400 701639 703300 705031 706797 708943 709102 717790 718058 718086 718629 720937 721260 723795 723824 724816 724899 725168 725248 725259 725379 725750 727159 727317 728639 729046 729171 730394 730591 731499 731554 732451 732685 733132 733617 733943 734709 734798 735215 735280 736067 738131 738753 739081 739122 739632 740625 741081 741261 741370 742271 744523 746940 747621 747659 747770 748043 748409 748482 749428 749536 749765 752025 753179 755110 756381 756408 760334 762299 762631 763695 764128 768656 773879 776390 785237 787261 791244 794049 794350 804075 812638 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife big dick"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.76%) |
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.