Query Metrics
7
Database Queries
7
Different statements
566.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.64 ms (36.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock член"
]
|
||||||||||||||||||||||||||||||
|
208.53 ms (36.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"to cock dick"
]
|
||||||||||||||||||||||||||||||
|
131.23 ms (23.17%) |
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 185038 357845 386367 388423 413046 419309 422343 426932 427181 443227 443539 448735 449853 456555 461670 462168 469399 470000 471489 474449 474669 476970 478346 480030 488609 494756 499616 507921 508863 509682 512484 512794 513896 532821 535948 539614 540792 545099 550792 552804 561476 563100 563124 578049 589739 590932 602634 604486 605963 607099 607650 608581 613903 614733 635514 638542 649989 653004 654305 663877 663977 664274 664857 665114 665342 665364 665476 665830 666754 666798 666841 667263 667578 667656 667669 668881 669206 669753 672421 673359 674184 681022 693103 693870 694141 696350 715277 716535 732695 734047 734227 735299 736049 738302 742591 750782 762470 764518 766447 766878 767561 768978 773201 773826 775896 776290 782659 806341 806767 809186 809737 809743 811038 816011 816822 816959 817371 820106 822235 822646 ] |
||||||||||||||||||||||||||||||
|
12.46 ms (2.20%) |
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 413046 422343 388423 471489 474449 499616 386367 185038 357845 443539 443227 427181 480030 419309 469399 478346 540792 764518 563124 578049 665114 666798 667578 674184 696350 715277 663977 665830 668881 681022 694141 666841 693870 607099 635514 638542 605963 589739 776290 809186 811038 732695 734227 736049 766447 773201 773826 768978 762470 735299 607650 614733 716535 775896 806341 476970 449853 470000 539614 462168 512794 602634 734047 512484 816011 822235 822646 508863 509682 513896 488609 590932 766878 474669 552804 608581 806767 750782 782659 809737 456555 550792 649989 742591 767561 809743 738302 604486 507921 535948 426932 448735 532821 494756 545099 613903 461670 817371 820106 816822 816959 663877 665476 667656 669206 669753 693103 653004 665342 665364 667263 673359 654305 664274 664857 666754 667669 672421 561476 563100 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.42%) |
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 185038 357845 386367 388423 413046 419309 422343 426932 427181 443227 443539 448735 449853 456555 461670 462168 469399 470000 471489 474449 474669 476970 478346 480030 488609 494756 499616 507921 508863 509682 512484 512794 513896 532821 535948 539614 540792 545099 550792 552804 561476 563100 563124 578049 589739 590932 602634 604486 605963 607099 607650 608581 613903 614733 635514 638542 649989 653004 654305 663877 663977 664274 664857 665114 665342 665364 665476 665830 666754 666798 666841 667263 667578 667656 667669 668881 669206 669753 672421 673359 674184 681022 693103 693870 694141 696350 715277 716535 732695 734047 734227 735299 736049 738302 742591 750782 762470 764518 766447 766878 767561 768978 773201 773826 775896 776290 782659 806341 806767 809186 809737 809743 811038 816011 816822 816959 817371 820106 822235 822646 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock член"
]
|
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.