Query Metrics
7
Database Queries
7
Different statements
149.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.90 ms (84.83%) |
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 70476 386944 387648 397502 397761 425751 428286 469048 508523 511004 512642 529600 531572 539204 556143 568852 576810 580283 583545 588441 591231 600924 608380 616634 618660 629193 633695 634585 649160 653693 666683 669957 675450 675715 682652 685521 695890 711686 713167 716960 722834 724753 727553 727715 732646 737287 738118 740259 740836 742539 744874 745175 747005 756152 756269 757567 757671 760939 764560 765636 766491 767223 767327 770713 772108 772290 772357 772368 772979 776994 777915 778717 779659 779891 780025 780082 780316 780378 781308 781920 783232 783652 783941 783966 785011 785747 787703 787975 788203 788463 788498 789149 791753 793880 794122 794171 799771 799825 800171 802686 802736 803325 805996 806192 807263 810246 810507 810913 811682 815372 816159 818220 825074 825207 825689 826799 ] |
||||||||||||||||||||||||||||||
|
12.40 ms (8.29%) |
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 649160 783232 811682 740259 740836 764560 608380 633695 776994 780025 469048 387648 397502 825074 825207 826799 815372 816159 828272 531572 529600 580283 583545 576810 556143 675450 682652 653693 666683 675715 634585 588441 591231 616634 778717 779891 780378 781920 788203 791753 793880 794171 780082 787975 789149 800171 727715 738118 770713 772368 773517 787703 794122 802686 802736 803325 806192 744874 762013 747005 760939 727553 732646 742539 745175 772108 772290 772357 757671 618660 629193 711686 716960 777915 780316 783652 785747 70476 397761 508523 386944 428286 818220 825689 511004 539204 568852 685521 695890 713167 600924 623097 785011 788463 799771 799825 805996 810246 779659 807263 810507 767223 767327 772979 781308 810913 724753 756269 737287 757567 766491 765636 722834 783941 783966 788498 425751 512642 669957 756152 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.08%) |
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 70476 386944 387648 397502 397761 425751 428286 469048 508523 511004 512642 529600 531572 539204 556143 568852 576810 580283 583545 588441 591231 600924 608380 616634 618660 629193 633695 634585 649160 653693 666683 669957 675450 675715 682652 685521 695890 711686 713167 716960 722834 724753 727553 727715 732646 737287 738118 740259 740836 742539 744874 745175 747005 756152 756269 757567 757671 760939 764560 765636 766491 767223 767327 770713 772108 772290 772357 772368 772979 776994 777915 778717 779659 779891 780025 780082 780316 780378 781308 781920 783232 783652 783941 783966 785011 785747 787703 787975 788203 788463 788498 789149 791753 793880 794122 794171 799771 799825 800171 802686 802736 803325 805996 806192 807263 810246 810507 810913 811682 815372 816159 818220 825074 825207 825689 826799 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"all девушк"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"all girl"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"all девушк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.10%) |
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.