Query Metrics
7
Database Queries
7
Different statements
1010.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
636.47 ms (62.97%) |
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 612049 701139 706356 802059 44055 398160 401533 407902 432338 597183 222010 161731 178326 395577 397000 816085 820151 821469 817171 821362 823018 815393 818518 513787 560091 564704 566723 554974 581600 653551 693866 697374 699164 699723 679055 679143 689595 694071 702949 702975 712809 622210 607285 811867 801473 806649 809403 731417 774335 784074 800210 729217 745378 724283 746574 755191 771374 729258 770838 697278 703059 703514 704268 722877 802107 471545 194507 393453 338098 29971 7055 403262 409313 820512 820560 822426 816039 827304 816392 816917 821216 815738 818523 821147 825073 509006 466787 551320 554907 649610 699684 651173 651896 653829 663241 663274 665519 682138 697359 701040 663882 690294 716848 718486 722489 614581 623718 640694 606575 603225 789712 789102 804675 805166 805959 723726 741068 748985 760247 773123 ] |
||||||||||||||||||||||||||||||
|
362.90 ms (35.91%) |
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 7055 29971 44055 161731 178326 194507 222010 338098 393453 395577 397000 398160 401533 403262 407902 409313 432338 466787 471545 509006 513787 551320 554907 554974 560091 564704 566723 581600 597183 603225 606575 607285 612049 614581 622210 623718 640694 649610 651173 651896 653551 653829 663241 663274 663882 665519 679055 679143 682138 689595 690294 693866 694071 697278 697359 697374 699164 699684 699723 701040 701139 702949 702975 703059 703514 704268 706356 712809 716848 718486 722489 722877 723726 724283 729217 729258 731417 741068 745378 746574 748985 755191 760247 770838 771374 773123 774335 784074 789102 789712 800210 801473 802059 802107 804675 805166 805959 806649 809403 811867 815393 815738 816039 816085 816392 816917 817171 818518 818523 820151 820512 820560 821147 821216 821362 821469 822426 823018 825073 827304 ] |
||||||||||||||||||||||||||||||
|
3.85 ms (0.38%) |
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 7055 29971 44055 161731 178326 194507 222010 338098 393453 395577 397000 398160 401533 403262 407902 409313 432338 466787 471545 509006 513787 551320 554907 554974 560091 564704 566723 581600 597183 603225 606575 607285 612049 614581 622210 623718 640694 649610 651173 651896 653551 653829 663241 663274 663882 665519 679055 679143 682138 689595 690294 693866 694071 697278 697359 697374 699164 699684 699723 701040 701139 702949 702975 703059 703514 704268 706356 712809 716848 718486 722489 722877 723726 724283 729217 729258 731417 741068 745378 746574 748985 755191 760247 770838 771374 773123 774335 784074 789102 789712 800210 801473 802059 802107 804675 805166 805959 806649 809403 811867 815393 815738 816039 816085 816392 816917 817171 818518 818523 820151 820512 820560 821147 821216 821362 821469 822426 823018 825073 827304 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"trio ffm"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.15%) |
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.