Query Metrics
7
Database Queries
7
Different statements
146.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.66 ms (84.44%) |
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 382263 462182 482335 494849 537401 537666 541573 542091 549195 555411 569517 574382 582469 593250 627567 629637 629780 632754 636438 648655 650095 655602 671472 674101 701451 703814 710478 710817 715530 716611 718349 726097 726408 727327 727562 728457 729863 730686 732598 740072 744221 744720 745610 747946 752176 753428 754161 755166 756947 758029 759812 760340 760426 761400 761438 761681 763036 763558 763704 765036 766483 766493 766518 772168 772357 772836 775518 777521 779048 779829 780245 781408 781555 782326 782838 783090 783294 785085 786030 787150 787216 787796 788091 791017 791049 791474 791494 791965 792519 794976 797745 800534 802069 802608 802638 803435 804517 804910 806731 807302 808071 808256 809235 811443 813897 814283 817175 817757 817758 818029 819300 819714 819966 823255 823256 825977 826006 ] |
||||||||||||||||||||||||||||||
|
11.99 ms (8.19%) |
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 817757 818029 823255 823256 825977 817175 826006 817758 819300 819714 819966 549195 674101 710478 716611 718349 629780 787796 753428 760340 792519 758029 763704 732598 761400 794976 807302 710817 593250 811443 772836 783090 788091 791474 772357 727327 744720 791494 814283 752176 759812 791049 813897 482335 462182 537401 494849 574382 541573 542091 555411 569517 650095 715530 703814 648655 632754 636438 629637 627567 779829 802069 804517 808071 780245 786030 791017 791965 800534 802608 803435 804910 740072 744221 754161 755166 763036 766493 766518 773517 781324 781408 782326 782838 786930 787150 797745 806731 726097 756947 766483 726408 727562 745610 730686 747946 760426 763558 728457 761438 761681 765036 772168 701451 775518 777521 779048 781555 783294 785085 787216 802638 809235 382263 537666 582469 671472 655602 808256 729863 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.74%) |
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 382263 462182 482335 494849 537401 537666 541573 542091 549195 555411 569517 574382 582469 593250 627567 629637 629780 632754 636438 648655 650095 655602 671472 674101 701451 703814 710478 710817 715530 716611 718349 726097 726408 727327 727562 728457 729863 730686 732598 740072 744221 744720 745610 747946 752176 753428 754161 755166 756947 758029 759812 760340 760426 761400 761438 761681 763036 763558 763704 765036 766483 766493 766518 772168 772357 772836 775518 777521 779048 779829 780245 781408 781555 782326 782838 783090 783294 785085 786030 787150 787216 787796 788091 791017 791049 791474 791494 791965 792519 794976 797745 800534 802069 802608 802638 803435 804517 804910 806731 807302 808071 808256 809235 811443 813897 814283 817175 817757 817758 818029 819300 819714 819966 823255 823256 825977 826006 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm of face"
]
|
||||||||||||||||||||||||||||||
|
2.31 ms (1.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм face"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм face"
]
|
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.