Query Metrics
7
Database Queries
7
Different statements
176.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.54 ms (87.57%) |
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 401636 489880 490491 493783 496385 505571 510335 514189 525473 531017 533075 533215 533302 533787 535562 536006 536260 537039 537690 540934 541918 542402 543588 543634 544794 546031 546672 547542 557919 558929 566492 572353 572680 577296 579080 579298 579472 579699 582832 593028 604407 611494 622813 626100 627560 627562 633692 639204 645226 645721 650032 651499 651518 670729 676741 685275 686121 688773 691982 692154 694038 696149 696157 704238 711117 712202 717279 717447 721642 723208 733198 734618 735206 736638 737234 737352 737825 739105 739654 740184 740703 743925 744730 745168 746924 749533 752017 752042 752046 752462 753714 754980 755205 755482 757943 758616 760399 760606 764192 767343 769083 769336 773649 777325 777481 777532 778325 778557 783158 790267 790434 791609 792198 806617 811809 816190 826999 827244 827457 828290 ] |
||||||||||||||||||||||||||||||
|
11.50 ms (6.51%) |
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 692154 622813 755482 493783 696157 828290 778557 769336 790434 734618 577296 670729 760399 696149 542402 531017 537690 401636 826999 827457 496385 533075 543634 717447 723208 712202 593028 790267 777325 778325 791609 792198 740703 767343 737825 752046 757943 773649 743925 752462 777532 783158 544794 827244 572353 566492 579080 579699 806617 764192 769083 752017 754980 739105 745168 749533 737234 721642 490491 547542 717279 753714 816190 489880 514189 525473 533787 533302 533215 535562 505571 582832 543588 546031 546672 558929 645226 645721 676741 685275 711117 651518 686121 694038 704238 650032 651499 688773 691982 572680 579298 579472 604407 626100 611494 639204 627560 777481 737352 739654 752042 811809 736638 746924 733198 735206 744730 758616 755205 740184 760606 627562 633692 510335 536260 537039 536006 540934 557919 541918 ] |
||||||||||||||||||||||||||||||
|
3.02 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 401636 489880 490491 493783 496385 505571 510335 514189 525473 531017 533075 533215 533302 533787 535562 536006 536260 537039 537690 540934 541918 542402 543588 543634 544794 546031 546672 547542 557919 558929 566492 572353 572680 577296 579080 579298 579472 579699 582832 593028 604407 611494 622813 626100 627560 627562 633692 639204 645226 645721 650032 651499 651518 670729 676741 685275 686121 688773 691982 692154 694038 696149 696157 704238 711117 712202 717279 717447 721642 723208 733198 734618 735206 736638 737234 737352 737825 739105 739654 740184 740703 743925 744730 745168 746924 749533 752017 752042 752046 752462 753714 754980 755205 755482 757943 758616 760399 760606 764192 767343 769083 769336 773649 777325 777481 777532 778325 778557 783158 790267 790434 791609 792198 806617 811809 816190 826999 827244 827457 828290 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl amateur"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк любительск"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 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.