Query Metrics
7
Database Queries
7
Different statements
195.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.01 ms (87.35%) |
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 371202 400713 405727 409031 420314 420322 423305 423685 424397 431723 432442 432496 438335 441378 444791 446175 451292 452710 455244 456787 466172 470827 476007 499092 508262 508590 509276 511605 518244 519237 519324 521939 523598 530188 530256 531270 532286 534620 544062 545636 546140 546580 555958 556708 559239 563383 576771 579830 581009 581229 583091 583569 584948 586146 587394 592830 593189 594468 600712 600726 610309 617589 627154 628772 629585 632140 636558 651544 652451 656268 659483 668971 670234 677861 693013 709430 710377 710941 721042 724479 727920 727972 728044 729759 730404 733325 734218 736787 740508 744790 745229 746587 747571 758869 759669 762330 764651 765118 768144 768722 769346 773532 777536 778804 778931 779293 779633 781064 781097 781574 786778 788854 789823 793172 800611 803667 808712 812596 816634 819151 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (7.19%) |
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 724479 727972 759669 765118 740508 745229 746587 747571 727920 769346 629585 710941 788854 420322 446175 423305 438335 519324 508590 546140 579830 546580 371202 511605 519237 455244 452710 521939 499092 523598 531270 532286 530256 444791 456787 544062 556708 677861 583091 432442 518244 405727 431723 420314 555958 584948 651544 659483 709430 587394 803667 736787 762330 793172 508262 400713 583569 632140 779633 800611 808712 812596 777536 778804 781064 730404 773532 786778 764651 768144 768722 627154 778931 779293 781574 530188 409031 509276 545636 559239 586146 432496 476007 424397 423685 451292 466172 534620 470827 441378 819151 816634 581229 563383 576771 581009 668971 652451 656268 670234 693013 710377 721042 594468 600726 636558 600712 610309 617589 628772 592830 593189 781097 729759 744790 758869 789823 728044 733325 734218 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.56%) |
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 371202 400713 405727 409031 420314 420322 423305 423685 424397 431723 432442 432496 438335 441378 444791 446175 451292 452710 455244 456787 466172 470827 476007 499092 508262 508590 509276 511605 518244 519237 519324 521939 523598 530188 530256 531270 532286 534620 544062 545636 546140 546580 555958 556708 559239 563383 576771 579830 581009 581229 583091 583569 584948 586146 587394 592830 593189 594468 600712 600726 610309 617589 627154 628772 629585 632140 636558 651544 652451 656268 659483 668971 670234 677861 693013 709430 710377 710941 721042 724479 727920 727972 728044 729759 730404 733325 734218 736787 740508 744790 745229 746587 747571 758869 759669 762330 764651 765118 768144 768722 769346 773532 777536 778804 778931 779293 779633 781064 781097 781574 786778 788854 789823 793172 800611 803667 808712 812596 816634 819151 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член cumshot"
]
|
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.