Query Metrics
7
Database Queries
7
Different statements
157.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.07 ms (84.62%) |
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 39114 80035 271197 330409 338731 385447 385454 385496 389618 393122 397837 418265 418572 437845 439617 450155 456977 457172 462832 472664 475802 487320 487609 489260 490260 494643 496479 499100 501036 501510 503000 504110 506271 506339 509575 509903 510095 518763 519257 521730 526881 527236 528633 530201 534131 534603 537380 539634 545057 552853 553896 555460 558691 558997 568798 576810 579128 581146 582694 586153 587703 588019 588767 591167 591762 591927 592096 594957 604052 617059 619017 622886 626026 627756 629635 630145 632722 648169 691951 699912 717085 717958 720082 722085 723691 725617 726444 730604 731238 733130 733158 733372 736499 738315 739542 740997 741818 746174 763547 768446 769913 772371 777110 782359 783978 790100 791835 792349 793658 793820 794434 794586 794590 795814 796009 798045 801940 803714 809926 812380 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (8.56%) |
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 699912 720082 592096 626026 629635 792349 793658 794434 733372 739542 769913 772371 726444 733158 731238 717085 717958 791835 506271 632722 794586 496479 622886 591762 582694 741818 528633 456977 586153 499100 510095 439617 501036 691951 617059 397837 768446 457172 798045 385496 494643 527236 537380 555460 576810 591927 619017 630145 738315 782359 503000 801940 736499 722085 519257 581146 518763 763547 475802 790100 795814 587703 490260 489260 338731 812380 723691 271197 530201 509575 509903 504110 793820 796009 437845 80035 389618 450155 558997 487609 385447 39114 487320 462832 521730 552853 588019 627756 777110 794590 733130 730604 740997 783978 803714 809926 418572 553896 558691 418265 534131 545057 648169 591167 506339 725617 385454 330409 746174 472664 534603 539634 588767 594957 604052 526881 501510 568798 579128 393122 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (2.40%) |
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 39114 80035 271197 330409 338731 385447 385454 385496 389618 393122 397837 418265 418572 437845 439617 450155 456977 457172 462832 472664 475802 487320 487609 489260 490260 494643 496479 499100 501036 501510 503000 504110 506271 506339 509575 509903 510095 518763 519257 521730 526881 527236 528633 530201 534131 534603 537380 539634 545057 552853 553896 555460 558691 558997 568798 576810 579128 581146 582694 586153 587703 588019 588767 591167 591762 591927 592096 594957 604052 617059 619017 622886 626026 627756 629635 630145 632722 648169 691951 699912 717085 717958 720082 722085 723691 725617 726444 730604 731238 733130 733158 733372 736499 738315 739542 740997 741818 746174 763547 768446 769913 772371 777110 782359 783978 790100 791835 792349 793658 793820 794434 794586 794590 795814 796009 798045 801940 803714 809926 812380 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен секс сперм"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife fuck sperm"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.