Query Metrics
7
Database Queries
7
Different statements
192.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.59 ms (86.75%) |
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 383701 386649 395623 396249 404346 404471 408468 415534 417031 419441 420147 420335 425740 426159 426683 426826 427301 430110 433770 436728 436756 437804 441417 445005 446077 453782 455386 455709 459308 460816 463118 464309 465081 466142 469009 472471 472817 475083 479754 479759 484502 485564 485882 487432 488079 490571 492376 494990 500861 508128 512349 515529 517098 518086 520994 522839 526019 526378 528929 531599 533009 536516 557485 557507 559835 562239 565943 566277 566654 570241 570600 573871 598466 610199 611236 614601 615691 615899 620455 622212 623411 627580 629293 631710 634829 642124 659803 659849 660892 669535 673030 680919 687313 688202 698386 704073 717256 718968 722858 728359 729674 733541 740127 740627 750500 751625 758243 760490 770989 777602 777671 781806 788092 796463 798711 800483 801234 804490 821713 822489 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (8.24%) |
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 615691 427301 536516 526378 570241 557507 669535 704073 614601 620455 610199 796463 733541 615899 777602 777671 395623 425740 533009 464309 475083 420147 437804 485564 426159 417031 508128 404346 426826 436756 821713 463118 494990 531599 559835 562239 718968 573871 622212 436728 445005 455709 460816 430110 526019 500861 515529 722858 634829 446077 517098 404471 520994 472817 557485 565943 687313 566654 642124 798711 804490 800483 770989 788092 698386 383701 570600 688202 717256 781806 750500 751625 629293 419441 433770 479754 492376 396249 426683 472471 522839 441417 453782 518086 680919 627580 740627 740127 408468 415534 420335 459308 469009 484502 566277 631710 598466 801234 728359 623411 466142 479759 465081 455386 490571 485882 487432 488079 528929 512349 386649 822489 660892 659803 673030 659849 729674 758243 760490 611236 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.55%) |
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 383701 386649 395623 396249 404346 404471 408468 415534 417031 419441 420147 420335 425740 426159 426683 426826 427301 430110 433770 436728 436756 437804 441417 445005 446077 453782 455386 455709 459308 460816 463118 464309 465081 466142 469009 472471 472817 475083 479754 479759 484502 485564 485882 487432 488079 490571 492376 494990 500861 508128 512349 515529 517098 518086 520994 522839 526019 526378 528929 531599 533009 536516 557485 557507 559835 562239 565943 566277 566654 570241 570600 573871 598466 610199 611236 614601 615691 615899 620455 622212 623411 627580 629293 631710 634829 642124 659803 659849 660892 669535 673030 680919 687313 688202 698386 704073 717256 718968 722858 728359 729674 733541 740127 740627 750500 751625 758243 760490 770989 777602 777671 781806 788092 796463 798711 800483 801234 804490 821713 822489 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие девушк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big girls"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие девушк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.80%) |
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.