Query Metrics
7
Database Queries
7
Different statements
142.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.99 ms (82.87%) |
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 533863 535488 541591 541593 541598 541821 541830 541877 543471 543984 546611 547328 549296 549368 549415 549933 549941 549964 550014 550019 550033 552027 552136 554068 557289 557333 557346 559909 560375 563535 563537 563860 566978 572762 573909 580193 583819 588062 592415 592514 601172 604063 608444 616099 618862 622975 622977 628328 637018 641120 643007 643114 648208 649152 651630 670103 670110 670761 670913 671724 671726 672151 672181 674572 676122 681107 681427 681444 683567 685667 687130 687249 688032 688116 699667 702975 703037 703046 703059 703432 703514 703521 705514 705520 705521 705537 705546 705913 706899 707323 708099 708421 708424 708476 708525 712001 712718 712722 713527 717641 719099 719101 719137 720471 722208 722521 722731 723632 726205 727284 732906 744276 744280 744287 744294 750061 755460 800625 802832 818278 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (10.35%) |
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 687130 702975 705521 707323 712718 549415 616099 618862 637018 800625 744276 732906 744287 703037 703046 703059 703514 703521 541598 550033 543471 573909 583819 563537 592514 535488 723632 549941 566978 552027 580193 550014 705514 722731 681107 681444 703432 705520 719137 674572 688032 699667 708525 720471 550019 601172 643114 727284 744280 744294 750061 712001 719101 572762 563535 622975 719099 685667 818278 533863 541591 549368 557333 557346 560375 543984 547328 557289 563860 546611 549296 552136 554068 559909 648208 649152 670110 670913 683567 687249 708421 708424 712722 713527 722208 722521 651630 670761 672151 672181 676122 681427 688116 670103 671724 705537 705546 705913 708476 549933 549964 588062 608444 628328 604063 622977 592415 643007 641120 802832 755460 726205 706899 708099 717641 541593 541830 541821 541877 671726 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.83%) |
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 533863 535488 541591 541593 541598 541821 541830 541877 543471 543984 546611 547328 549296 549368 549415 549933 549941 549964 550014 550019 550033 552027 552136 554068 557289 557333 557346 559909 560375 563535 563537 563860 566978 572762 573909 580193 583819 588062 592415 592514 601172 604063 608444 616099 618862 622975 622977 628328 637018 641120 643007 643114 648208 649152 651630 670103 670110 670761 670913 671724 671726 672151 672181 674572 676122 681107 681427 681444 683567 685667 687130 687249 688032 688116 699667 702975 703037 703046 703059 703432 703514 703521 705514 705520 705521 705537 705546 705913 706899 707323 708099 708421 708424 708476 708525 712001 712718 712722 713527 717641 719099 719101 719137 720471 722208 722521 722731 723632 726205 727284 732906 744276 744280 744287 744294 750061 755460 800625 802832 818278 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens film"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens фильм"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens фильм"
]
|
||||||||||||||||||||||||||||||
|
1.56 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.