Query Metrics
7
Database Queries
7
Different statements
210.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.29 ms (87.86%) |
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 357750 382188 382771 382883 383005 402611 403027 404127 407141 416434 420332 431427 436628 436859 441820 448119 448652 450530 450656 450968 452360 456982 457451 457767 459760 469672 469675 469820 469825 471305 474050 475859 476366 477168 481284 481873 482069 488467 488558 490706 496720 497057 498869 499371 499444 500178 503215 505062 507168 510244 513396 516536 518328 518347 520599 521318 522014 525533 527029 527660 538333 541033 550425 555944 568081 569622 583280 584389 591115 593762 599433 600577 600607 615004 615674 616798 617743 620317 628758 644486 663540 668765 682268 695292 697178 715853 720458 722098 726520 726544 726595 735530 737921 743810 748663 749528 749623 750782 756363 756460 761422 770096 773174 773182 779965 788215 792775 794425 798674 800296 801666 803566 803966 808241 813188 818317 820009 824724 824788 827828 ] |
||||||||||||||||||||||||||||||
|
16.08 ms (7.62%) |
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 726520 792775 750782 404127 450968 500178 628758 644486 794425 403027 497057 436859 469672 499444 827828 620317 593762 382771 800296 748663 448652 382883 420332 818317 803966 383005 820009 749528 452360 518347 475859 569622 615004 726544 715853 441820 407141 722098 798674 743810 773182 496720 668765 448119 457767 481873 490706 583280 591115 726595 482069 503215 513396 525533 600607 550425 720458 735530 788215 469675 824724 695292 761422 538333 498869 555944 499371 510244 527029 568081 516536 520599 522014 436628 682268 456982 808241 697178 481284 615674 457451 469820 801666 773174 803566 756460 505062 488467 402611 813188 450530 599433 382188 431427 521318 770096 779965 476366 616798 617743 488558 824788 416434 459760 477168 450656 469825 471305 584389 749623 756363 737921 518328 507168 541033 527660 663540 357750 474050 600577 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.38%) |
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 357750 382188 382771 382883 383005 402611 403027 404127 407141 416434 420332 431427 436628 436859 441820 448119 448652 450530 450656 450968 452360 456982 457451 457767 459760 469672 469675 469820 469825 471305 474050 475859 476366 477168 481284 481873 482069 488467 488558 490706 496720 497057 498869 499371 499444 500178 503215 505062 507168 510244 513396 516536 518328 518347 520599 521318 522014 525533 527029 527660 538333 541033 550425 555944 568081 569622 583280 584389 591115 593762 599433 600577 600607 615004 615674 616798 617743 620317 628758 644486 663540 668765 682268 695292 697178 715853 720458 722098 726520 726544 726595 735530 737921 743810 748663 749528 749623 750782 756363 756460 761422 770096 773174 773182 779965 788215 792775 794425 798674 800296 801666 803566 803966 808241 813188 818317 820009 824724 824788 827828 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage amateur"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж любительск"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.