Query Metrics
7
Database Queries
7
Different statements
158.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.01 ms (82.15%) |
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 5565 8497 69816 172662 185567 197445 203946 383411 386677 393347 403736 409862 413208 413244 413289 420598 420619 421652 423646 424671 425330 425725 427794 429711 430110 430683 432742 449031 462521 464115 464379 466188 466682 469069 469849 471912 472962 473259 473898 474840 475577 475997 476231 476461 477869 479996 480009 481166 481409 484404 486150 487147 487737 489413 490781 492749 495296 497586 500781 502778 507903 510078 511179 512258 517232 517911 519187 519427 519717 525959 526226 538172 546704 549804 562522 562524 564128 567666 569920 582783 584320 584434 585452 589435 597500 620852 626737 626852 633746 649107 653697 658608 672092 681796 690461 693536 707009 709848 712715 715411 716568 719006 722035 730699 735382 737151 741996 756494 760480 771384 773248 775297 779239 781632 788119 798863 803734 808468 814450 826050 ] |
||||||||||||||||||||||||||||||
|
17.47 ms (11.04%) |
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 803734 633746 462521 5565 413244 423646 479996 172662 469849 497586 511179 517911 512258 562522 474840 427794 473898 517232 8497 413208 476461 569920 546704 567666 584434 584320 582783 626737 620852 788119 449031 420598 432742 464115 421652 403736 409862 429711 430683 420619 430110 469069 475997 481166 484404 489413 495296 525959 526226 519187 519717 197445 672092 693536 707009 715411 597500 413289 826050 658608 649107 690461 730699 756494 781632 185567 562524 681796 383411 549804 564128 69816 798863 386677 424671 466682 466188 475577 425725 477869 425330 464379 480009 473259 492749 502778 507903 500781 486150 510078 519427 393347 814450 719006 589435 760480 203946 472962 487737 490781 471912 476231 538172 481409 487147 716568 709848 653697 712715 722035 585452 626852 775297 779239 808468 741996 773248 737151 735382 771384 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.81%) |
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 5565 8497 69816 172662 185567 197445 203946 383411 386677 393347 403736 409862 413208 413244 413289 420598 420619 421652 423646 424671 425330 425725 427794 429711 430110 430683 432742 449031 462521 464115 464379 466188 466682 469069 469849 471912 472962 473259 473898 474840 475577 475997 476231 476461 477869 479996 480009 481166 481409 484404 486150 487147 487737 489413 490781 492749 495296 497586 500781 502778 507903 510078 511179 512258 517232 517911 519187 519427 519717 525959 526226 538172 546704 549804 562522 562524 564128 567666 569920 582783 584320 584434 585452 589435 597500 620852 626737 626852 633746 649107 653697 658608 672092 681796 690461 693536 707009 709848 712715 715411 716568 719006 722035 730699 735382 737151 741996 756494 760480 771384 773248 775297 779239 781632 788119 798863 803734 808468 814450 826050 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big this beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.08%) |
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.