Query Metrics
7
Database Queries
7
Different statements
142.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.98 ms (81.98%) |
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 43748 117388 397065 406847 417116 428052 432769 437302 445536 453778 459629 461091 461376 462588 485407 486617 493271 499860 499874 500060 502855 502893 504846 509114 509984 510332 511387 512150 512603 512804 512956 512962 513369 514094 514199 516348 518320 519355 520381 520394 521005 524078 525151 525495 525505 525757 526273 527406 528359 530032 532319 540311 540548 543970 547428 547584 547828 549081 550077 552854 557472 560952 560993 562083 563176 563300 564040 566337 568588 573362 575283 576527 576932 577178 580425 581462 584456 584698 584921 585095 588082 590498 593671 597584 598387 598457 598469 598512 598539 598897 599142 604293 604605 605183 607353 610016 611206 621095 624551 627076 628059 628708 631549 632163 645935 645949 650726 654380 656525 660080 670425 671131 675049 675303 675705 677352 678891 680102 680459 684934 ] |
||||||||||||||||||||||||||||||
|
16.08 ms (11.27%) |
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 524078 525757 528359 540548 512150 514094 518320 520381 520394 526273 532319 461376 563176 564040 577178 584456 543970 547428 550077 560952 562083 575283 584921 563300 568588 645949 656525 675049 680102 645935 654380 670425 675303 677352 678891 684934 650726 660080 680459 547828 552854 560993 573362 576527 593671 597584 598897 604293 610016 598387 598457 598512 598539 604605 627076 628708 632163 598469 599142 621095 607353 611206 628059 445536 462588 117388 428052 43748 397065 417116 437302 504846 512603 500060 502855 502893 521005 493271 509984 519355 485407 486617 510332 432769 585095 511387 513369 514199 512804 499860 547584 566337 576932 581462 584698 549081 557472 675705 580425 590498 624551 588082 605183 631549 406847 671131 461091 453778 459629 512962 525495 525505 527406 530032 509114 525151 540311 499874 512956 516348 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.76%) |
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 43748 117388 397065 406847 417116 428052 432769 437302 445536 453778 459629 461091 461376 462588 485407 486617 493271 499860 499874 500060 502855 502893 504846 509114 509984 510332 511387 512150 512603 512804 512956 512962 513369 514094 514199 516348 518320 519355 520381 520394 521005 524078 525151 525495 525505 525757 526273 527406 528359 530032 532319 540311 540548 543970 547428 547584 547828 549081 550077 552854 557472 560952 560993 562083 563176 563300 564040 566337 568588 573362 575283 576527 576932 577178 580425 581462 584456 584698 584921 585095 588082 590498 593671 597584 598387 598457 598469 598512 598539 598897 599142 604293 604605 605183 607353 610016 611206 621095 624551 627076 628059 628708 631549 632163 645935 645949 650726 654380 656525 660080 670425 671131 675049 675303 675705 677352 678891 680102 680459 684934 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп бок"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопу боком"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.97%) |
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.