Query Metrics
7
Database Queries
7
Different statements
146.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.39 ms (82.21%) |
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 95990 145646 148793 316911 331119 382411 383326 384200 384363 385784 386758 395499 396121 396413 396549 397648 398188 401773 404320 413078 414361 415097 415714 415737 416063 417441 418839 429358 445514 446152 446351 449592 468483 469593 471425 478476 478491 481582 486736 494365 512683 529257 530767 531082 531906 533529 533681 535395 535749 536740 536919 536932 537832 540985 548588 554774 558307 564608 566656 575845 576692 580757 581231 581580 584576 591893 594868 598020 601710 601755 603398 604494 621675 626737 630204 630857 636275 639131 645322 649587 664260 666582 666584 669566 675065 676073 694116 695939 712935 718203 719243 721060 724536 725041 725408 726165 728738 732345 736152 737734 742439 743159 744607 751571 765459 765810 784740 788562 790963 792423 802601 803321 805112 805607 807541 810996 813074 814130 814654 819223 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (11.01%) |
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 630857 603398 478491 396413 386758 384363 576692 414361 548588 580757 718203 429358 469593 396121 416063 413078 418839 554774 645322 649587 581231 581580 591893 621675 736152 481582 417441 415714 819223 446351 664260 666582 695939 584576 790963 807541 805607 802601 724536 725041 728738 732345 737734 751571 742439 765810 604494 784740 810996 397648 148793 404320 814130 537832 669566 805112 813074 744607 726165 721060 415097 449592 494365 594868 792423 446152 383326 331119 396549 415737 814654 468483 535749 530767 536919 558307 575845 676073 675065 639131 598020 636275 765459 725408 601755 630204 471425 384200 401773 145646 385784 529257 316911 382411 478476 533529 536932 531082 540985 566656 564608 626737 788562 803321 743159 601710 398188 395499 719243 666584 95990 445514 486736 533681 512683 531906 535395 536740 694116 712935 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.82%) |
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 95990 145646 148793 316911 331119 382411 383326 384200 384363 385784 386758 395499 396121 396413 396549 397648 398188 401773 404320 413078 414361 415097 415714 415737 416063 417441 418839 429358 445514 446152 446351 449592 468483 469593 471425 478476 478491 481582 486736 494365 512683 529257 530767 531082 531906 533529 533681 535395 535749 536740 536919 536932 537832 540985 548588 554774 558307 564608 566656 575845 576692 580757 581231 581580 584576 591893 594868 598020 601710 601755 603398 604494 621675 626737 630204 630857 636275 639131 645322 649587 664260 666582 666584 669566 675065 676073 694116 695939 712935 718203 719243 721060 724536 725041 725408 726165 728738 732345 736152 737734 742439 743159 744607 751571 765459 765810 784740 788562 790963 792423 802601 803321 805112 805607 807541 810996 813074 814130 814654 819223 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black минет оральн секс"
]
|
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.