Query Metrics
7
Database Queries
7
Different statements
171.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.60 ms (86.52%) |
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 415814 420330 423775 424240 424265 438031 451526 470022 488887 492758 497919 502729 508300 512560 513501 514888 519456 521192 523528 529604 539138 542346 542444 542741 542784 542926 542979 544931 547741 547743 556471 558683 560008 560021 560866 562192 562743 569394 569398 576239 579189 580363 581135 582479 590227 590238 598541 599535 602806 603767 609422 659984 663249 667774 669893 686177 702235 707373 709540 713384 714324 716738 721603 726593 745462 750699 751536 751567 751603 751803 753507 755132 757568 758171 758804 760881 763079 765837 765859 766385 767697 768290 768553 771375 772763 777739 777759 777861 778741 778748 778749 779347 779902 780088 783335 784237 784776 788467 788829 789276 791248 792006 793955 795521 796852 800934 802033 803562 805145 806762 808894 811233 811294 811329 811887 812440 812461 814028 820107 825590 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (7.87%) |
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 796852 812461 415814 686177 751603 763079 659984 590227 590238 609422 451526 542784 560021 784776 423775 420330 544931 438031 529604 768290 542444 792006 802033 811329 811887 812440 791248 783335 808894 811233 811294 767697 726593 778741 779347 788829 424240 542346 576239 702235 492758 556471 751567 750699 502729 825590 772763 721603 542926 581135 542741 569394 582479 669893 579189 820107 814028 547743 716738 667774 562743 805145 806762 777759 778749 780088 803562 755132 766385 795521 760881 765837 771375 758804 745462 751803 768553 751536 753507 757568 758171 602806 777739 777861 778748 779902 800934 560008 558683 519456 547741 789276 765859 569398 470022 508300 512560 514888 497919 784237 793955 580363 521192 539138 560866 562192 713384 714324 598541 599535 603767 709540 707373 663249 424265 523528 513501 788467 488887 542979 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.40%) |
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 415814 420330 423775 424240 424265 438031 451526 470022 488887 492758 497919 502729 508300 512560 513501 514888 519456 521192 523528 529604 539138 542346 542444 542741 542784 542926 542979 544931 547741 547743 556471 558683 560008 560021 560866 562192 562743 569394 569398 576239 579189 580363 581135 582479 590227 590238 598541 599535 602806 603767 609422 659984 663249 667774 669893 686177 702235 707373 709540 713384 714324 716738 721603 726593 745462 750699 751536 751567 751603 751803 753507 755132 757568 758171 758804 760881 763079 765837 765859 766385 767697 768290 768553 771375 772763 777739 777759 777861 778741 778748 778749 779347 779902 780088 783335 784237 784776 788467 788829 789276 791248 792006 793955 795521 796852 800934 802033 803562 805145 806762 808894 811233 811294 811329 811887 812440 812461 814028 820107 825590 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее милфа русски…"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск милф русск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
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.