Query Metrics
7
Database Queries
7
Different statements
159.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.18 ms (81.70%) |
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 7157 357886 382396 383005 383486 386178 387077 389135 389518 390592 391677 400435 404286 405505 406203 406235 406435 407141 411132 413465 415934 416434 418481 420091 429575 431019 437448 441758 441820 446620 446791 447476 447488 447542 448337 448945 450530 451961 453295 454066 454939 456071 456579 464617 470839 487010 487346 490070 490706 493031 497635 499371 501718 501750 501786 503215 503892 510033 510041 517998 518347 521918 525768 545814 549583 551392 567764 572012 572015 574902 575118 576039 583656 585254 593671 599543 603096 605875 606809 610390 618937 620105 625452 651922 651928 652177 652206 653246 654137 661078 677030 677041 677158 689308 708023 714471 720535 720791 721200 722098 727717 728411 738927 740007 744631 745451 747351 748752 765482 768164 784702 797700 802737 810842 813478 816038 818324 820452 824332 825312 ] |
||||||||||||||||||||||||||||||
|
18.37 ms (11.53%) |
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 497635 824332 818324 689308 501718 389135 620105 456579 447488 521918 448945 572012 593671 765482 406235 391677 661078 721200 437448 518347 603096 606809 406203 653246 720791 651928 652177 583656 618937 728411 745451 748752 456071 454939 503892 501786 413465 545814 383486 575118 714471 390592 493031 720535 708023 585254 415934 501750 825312 447476 7157 389518 441758 551392 429575 411132 487010 525768 487346 549583 431019 797700 383005 416434 490706 454066 503215 654137 677030 738927 747351 652206 784702 744631 490070 406435 446620 464617 510041 567764 418481 420091 441820 447542 446791 448337 510033 407141 574902 802737 599543 727717 610390 810842 677158 400435 357886 722098 450530 499371 517998 405505 404286 740007 382396 470839 651922 453295 386178 451961 387077 816038 820452 813478 768164 576039 572015 625452 677041 605875 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.79%) |
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 7157 357886 382396 383005 383486 386178 387077 389135 389518 390592 391677 400435 404286 405505 406203 406235 406435 407141 411132 413465 415934 416434 418481 420091 429575 431019 437448 441758 441820 446620 446791 447476 447488 447542 448337 448945 450530 451961 453295 454066 454939 456071 456579 464617 470839 487010 487346 490070 490706 493031 497635 499371 501718 501750 501786 503215 503892 510033 510041 517998 518347 521918 525768 545814 549583 551392 567764 572012 572015 574902 575118 576039 583656 585254 593671 599543 603096 605875 606809 610390 618937 620105 625452 651922 651928 652177 652206 653246 654137 661078 677030 677041 677158 689308 708023 714471 720535 720791 721200 722098 727717 728411 738927 740007 744631 745451 747351 748752 765482 768164 784702 797700 802737 810842 813478 816038 818324 820452 824332 825312 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"массаж члена сперма"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж член сперм"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж член сперм"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
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.