Query Metrics
7
Database Queries
7
Different statements
421.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.91 ms (50.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teens секс"
]
|
||||||||||||||||||||||||||||||
|
192.88 ms (45.71%) |
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 408776 516738 522531 530223 533050 541914 544371 548738 554331 557009 568102 570686 571692 575245 579069 584884 586767 590584 594440 597764 600595 608020 609601 610725 616406 616646 617655 619343 619384 619387 620969 622813 624603 626826 628792 633881 633932 635871 636905 638051 646712 648332 649640 649647 650246 652535 653172 653592 657138 661420 661922 663219 673915 679535 680495 681741 681793 683252 683304 687841 688756 689246 689810 690049 692446 692463 692851 693264 694047 694858 697149 698340 700877 703402 703673 703747 704481 706752 708048 708107 712566 713309 713862 713989 714412 715742 718016 719803 722057 725756 726381 731699 733420 734798 735674 737464 747263 752040 759498 760359 760478 763250 763902 764796 767803 769621 772278 776179 781034 781090 782484 786646 787375 795128 796528 819798 824612 825593 ] |
||||||||||||||||||||||||||||||
|
9.57 ms (2.27%) |
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 689810 697149 713862 650246 653592 657138 661922 679535 681741 689246 694047 694858 719803 579069 616406 633881 586767 616646 624603 626826 638051 597764 633932 781090 734798 747263 760359 767803 772278 786646 737464 752040 760478 763250 764796 763902 610725 617655 619343 619384 700877 703673 712566 649647 590584 731699 819798 693264 722057 781034 796528 787375 735674 825655 533050 704481 706752 661420 681793 782484 795128 824612 698340 708107 522531 516738 646712 683304 663219 692851 703747 594440 622813 600595 609601 759498 548738 649640 726381 408776 733420 673915 690049 575245 608020 635871 619387 683252 648332 680495 688756 568102 620969 628792 776179 780455 769621 725756 703402 557009 713989 692463 825593 530223 554331 571692 584884 541914 544371 570686 708048 714412 653172 687841 713309 652535 692446 715742 718016 636905 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.64%) |
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 408776 516738 522531 530223 533050 541914 544371 548738 554331 557009 568102 570686 571692 575245 579069 584884 586767 590584 594440 597764 600595 608020 609601 610725 616406 616646 617655 619343 619384 619387 620969 622813 624603 626826 628792 633881 633932 635871 636905 638051 646712 648332 649640 649647 650246 652535 653172 653592 657138 661420 661922 663219 673915 679535 680495 681741 681793 683252 683304 687841 688756 689246 689810 690049 692446 692463 692851 693264 694047 694858 697149 698340 700877 703402 703673 703747 704481 706752 708048 708107 712566 713309 713862 713989 714412 715742 718016 719803 722057 725756 726381 731699 733420 734798 735674 737464 747263 752040 759498 760359 760478 763250 763902 764796 767803 769621 772278 776179 781034 781090 782484 786646 787375 795128 796528 819798 824612 825593 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teens секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teens sex"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.33%) |
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.