Query Metrics
7
Database Queries
7
Different statements
174.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.61 ms (87.42%) |
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 397417 400883 417733 418334 420303 425928 440892 449283 520856 526464 529057 529224 531394 539350 543702 551221 572662 578722 585595 585899 588278 593613 601182 609081 614001 614385 615184 616379 619350 620980 622849 622853 625957 626678 627162 628594 630345 630769 634648 639111 645485 648655 660008 662076 662443 664473 664623 668100 678216 678711 680370 690931 692829 693881 697496 699304 701897 704169 704727 707148 710015 710893 713143 713181 716359 716994 718562 718614 719280 720026 721091 722434 723826 726327 730924 731580 734124 741983 743005 744210 747475 748263 757575 761484 768706 773836 774111 776048 776079 777829 783528 785650 786232 786756 791895 792200 794082 794827 794909 794924 795371 805588 806965 809911 809965 811914 815352 815515 816934 818826 820757 822651 822838 823778 825645 825794 825996 827784 828285 ] |
||||||||||||||||||||||||||||||
|
11.69 ms (6.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 648655 660008 662076 668100 678216 692829 572662 609081 619350 630769 593613 614001 639111 588278 626678 792200 805588 776048 783528 794827 811914 723826 734124 761484 768706 794909 794924 726327 731580 759773 774111 730924 741983 743005 744210 757575 773836 625957 628594 713143 718562 777829 795371 809911 809965 417733 397417 418334 449283 425928 529057 526464 551221 693881 664623 634648 585595 585899 614385 620980 627162 630345 776079 786756 806965 747475 785650 786232 791895 794082 748263 704727 400883 420303 440892 815352 820757 822838 825996 816934 822651 825645 825794 815515 818826 823778 828285 827784 531394 539350 529224 520856 578722 543702 645485 664473 697496 699304 707148 720026 721091 701897 704169 716994 718614 719280 662443 678711 680370 690931 710015 710893 713181 716359 722434 615184 616379 622853 622849 601182 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.71%) |
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 397417 400883 417733 418334 420303 425928 440892 449283 520856 526464 529057 529224 531394 539350 543702 551221 572662 578722 585595 585899 588278 593613 601182 609081 614001 614385 615184 616379 619350 620980 622849 622853 625957 626678 627162 628594 630345 630769 634648 639111 645485 648655 660008 662076 662443 664473 664623 668100 678216 678711 680370 690931 692829 693881 697496 699304 701897 704169 704727 707148 710015 710893 713143 713181 716359 716994 718562 718614 719280 720026 721091 722434 723826 726327 730924 731580 734124 741983 743005 744210 747475 748263 757575 761484 768706 773836 774111 776048 776079 777829 783528 785650 786232 786756 791895 792200 794082 794827 794909 794924 795371 805588 806965 809911 809965 811914 815352 815515 816934 818826 820757 822651 822838 823778 825645 825794 825996 827784 828285 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real girls"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real девушк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real девушк"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
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.