Query Metrics
7
Database Queries
7
Different statements
186.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.86 ms (84.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 382261 416092 417192 419271 427351 434573 434895 436335 436343 437233 440629 441757 441812 441815 443602 446370 447115 447237 447359 453043 454103 458571 461558 461742 463312 463376 464817 467084 470390 471180 474849 475427 476745 477098 479647 482007 484403 486544 488452 491059 498525 500265 501287 508469 509911 517223 517746 524078 527206 534040 535427 536421 539546 542522 544747 548607 550469 551597 551614 559139 559554 561396 564672 567527 570144 570372 570970 574372 574717 577182 604643 646413 647085 661390 662436 683963 688220 695902 706411 710530 715368 716624 716728 720305 722101 723629 728228 728309 728655 736476 745585 745622 749733 758312 758483 759290 759587 761691 761806 764528 781194 784239 787632 792565 793102 797420 799394 806868 810256 813345 813916 815057 817794 818475 818779 820771 821418 823425 824405 825694 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (9.60%) |
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 792565 797420 806868 749733 759290 759587 736476 745622 764528 745585 728228 728309 728655 758312 758483 761691 761806 604643 781194 784239 787632 793102 799394 810256 813345 382261 434895 437233 441815 471180 477098 434573 436335 436343 458571 461558 475427 463312 464817 484403 517223 488452 527206 815057 498525 416092 440629 427351 419271 441757 443602 417192 441812 818475 818779 723629 813916 825694 817794 820771 821418 823425 824405 447359 461742 470390 474849 486544 446370 447237 454103 463376 476745 447115 453043 482007 508469 500265 501287 509911 517746 524078 539546 534040 535427 536421 467084 479647 491059 548607 559139 564672 570144 551597 551614 559554 574372 574717 542522 544747 550469 561396 567527 570372 570970 577182 662436 688220 695902 710530 715368 716624 716728 646413 661390 683963 706411 720305 722101 647085 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (1.95%) |
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 382261 416092 417192 419271 427351 434573 434895 436335 436343 437233 440629 441757 441812 441815 443602 446370 447115 447237 447359 453043 454103 458571 461558 461742 463312 463376 464817 467084 470390 471180 474849 475427 476745 477098 479647 482007 484403 486544 488452 491059 498525 500265 501287 508469 509911 517223 517746 524078 527206 534040 535427 536421 539546 542522 544747 548607 550469 551597 551614 559139 559554 561396 564672 567527 570144 570372 570970 574372 574717 577182 604643 646413 647085 661390 662436 683963 688220 695902 706411 710530 715368 716624 716728 720305 722101 723629 728228 728309 728655 736476 745585 745622 749733 758312 758483 759290 759587 761691 761806 764528 781194 784239 787632 792565 793102 797420 799394 806868 810256 813345 813916 815057 817794 818475 818779 820771 821418 823425 824405 825694 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rough hair"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"rough hair"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"rough hair"
]
|
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.