Query Metrics
7
Database Queries
7
Different statements
227.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.81 ms (89.84%) |
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 458805 466172 470827 476007 491818 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 632140 636558 651544 652451 656268 659483 668971 670234 677861 693013 709430 710377 721042 728044 729759 730404 731294 733325 733403 734218 736787 738845 744790 745981 746141 750692 751860 758869 762330 764536 764651 768144 768722 769585 771628 773532 777536 778804 778931 779293 779633 781064 781097 781574 786778 789823 793172 800611 803667 808712 812596 816634 819151 825306 ] |
||||||||||||||||||||||||||||||
|
13.70 ms (6.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 420322 446175 423305 438335 519324 508590 546140 579830 546580 371202 511605 519237 455244 452710 521939 499092 523598 531270 532286 530256 444791 458805 491818 456787 544062 556708 677861 583091 432442 518244 825306 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 746141 750692 745981 751860 769585 738845 764536 771628 731294 733403 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.14%) |
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 458805 466172 470827 476007 491818 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 632140 636558 651544 652451 656268 659483 668971 670234 677861 693013 709430 710377 721042 728044 729759 730404 731294 733325 733403 734218 736787 738845 744790 745981 746141 750692 751860 758869 762330 764536 764651 768144 768722 769585 771628 773532 777536 778804 778931 779293 779633 781064 781097 781574 786778 789823 793172 800611 803667 808712 812596 816634 819151 825306 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot handjob"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.