Query Metrics
7
Database Queries
7
Different statements
166.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.17 ms (84.16%) |
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 303771 407007 420719 421428 421543 423482 424353 424384 427367 433539 437381 438353 444086 446387 448468 449431 449863 451421 451785 454922 455813 456171 456504 459669 463132 464491 465541 470226 477775 481194 483188 485247 486613 491010 492288 492308 492564 492911 493209 494645 496148 498896 506442 510744 522225 523231 523248 524255 526147 527072 535206 535572 536060 541393 552858 555321 558562 558630 564742 566858 567311 572649 574421 581745 584441 584465 585922 588231 597674 599501 606054 606604 607526 607964 610931 612131 612458 612476 617435 617865 619718 621104 630129 632562 639124 639873 642092 657781 660032 662055 666706 668776 674285 680588 680820 685943 689436 704079 708505 708989 709217 711637 715834 722149 725152 734164 740814 740848 753190 755652 759659 781272 784792 784958 786856 787520 789756 795725 808154 808343 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (9.52%) |
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 536060 510744 498896 572649 566858 704079 711637 660032 668776 708505 708989 657781 612476 639124 808343 784958 740814 753190 781272 786856 787520 789756 808154 607526 607964 612131 795725 427367 446387 423482 421543 420719 424384 421428 437381 470226 477775 486613 456504 459669 491010 523248 524255 535572 485247 558630 574421 584441 558562 666706 689436 685943 715834 606604 599501 612458 619718 639873 588231 632562 725152 617865 438353 481194 492911 494645 493209 506442 526147 523231 496148 522225 535206 567311 541393 584465 662055 552858 597674 621104 585922 610931 755652 492564 465541 564742 555321 581745 680820 722149 674285 680588 606054 784792 740848 734164 759659 617435 630129 642092 709217 444086 527072 303771 407007 424353 433539 449431 449863 463132 464491 483188 492288 448468 451421 456171 492308 451785 454922 455813 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (2.08%) |
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 303771 407007 420719 421428 421543 423482 424353 424384 427367 433539 437381 438353 444086 446387 448468 449431 449863 451421 451785 454922 455813 456171 456504 459669 463132 464491 465541 470226 477775 481194 483188 485247 486613 491010 492288 492308 492564 492911 493209 494645 496148 498896 506442 510744 522225 523231 523248 524255 526147 527072 535206 535572 536060 541393 552858 555321 558562 558630 564742 566858 567311 572649 574421 581745 584441 584465 585922 588231 597674 599501 606054 606604 607526 607964 610931 612131 612458 612476 617435 617865 619718 621104 630129 632562 639124 639873 642092 657781 660032 662055 666706 668776 674285 680588 680820 685943 689436 704079 708505 708989 709217 711637 715834 722149 725152 734164 740814 740848 753190 755652 759659 781272 784792 784958 786856 787520 789756 795725 808154 808343 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мокрые в сперме"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрые сперм"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
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.