Query Metrics
7
Database Queries
7
Different statements
165.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.36 ms (86.44%) |
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 400442 411623 413783 413934 415299 420311 420561 420757 421514 423580 423981 431768 434156 447825 452441 455807 457480 460437 461645 464194 469272 471408 471518 473533 474094 474112 474414 474447 477587 482533 486834 486894 487500 491860 493037 494146 495126 496086 497520 499904 502505 506156 507909 509225 510424 510819 513435 515269 518997 523428 524550 524596 525196 526165 528328 528508 533644 536282 540307 543286 546712 551776 554908 555396 564051 566067 566760 572736 574237 574387 576214 577038 577600 580103 580319 581228 581348 583541 585266 585300 586372 586395 586408 587795 593080 596359 596785 602099 604549 610047 615919 617047 620056 622054 623887 652007 664823 669276 675281 683906 683973 685004 690882 702125 703947 714309 725583 732899 733271 748206 752653 766896 770392 776531 786454 811220 819271 824791 827684 ] |
||||||||||||||||||||||||||||||
|
12.49 ms (7.53%) |
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 460437 457480 474112 499904 510819 536282 524550 526165 533644 540307 509225 524596 528328 474094 554908 555396 564051 577038 551776 566760 574387 580319 581228 566067 574237 583541 652007 683973 664823 669276 675281 683906 702125 703947 576214 580103 585266 585300 596359 610047 586372 620056 586395 586408 587795 615919 622054 593080 617047 776531 733271 748206 786454 732899 752653 770392 602099 604549 623887 421514 464194 471408 420757 474447 420311 471518 455807 507909 518997 523428 494146 506156 510424 515269 487500 528508 431768 496086 411623 486894 827684 819271 400442 434156 413783 413934 415299 423580 420561 824791 482533 447825 473533 486834 477587 491860 493037 452441 461645 474414 495126 502505 497520 513435 525196 469272 543286 577600 714309 714349 690882 685004 546712 572736 581348 596785 811220 766896 725583 423981 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.77%) |
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 400442 411623 413783 413934 415299 420311 420561 420757 421514 423580 423981 431768 434156 447825 452441 455807 457480 460437 461645 464194 469272 471408 471518 473533 474094 474112 474414 474447 477587 482533 486834 486894 487500 491860 493037 494146 495126 496086 497520 499904 502505 506156 507909 509225 510424 510819 513435 515269 518997 523428 524550 524596 525196 526165 528328 528508 533644 536282 540307 543286 546712 551776 554908 555396 564051 566067 566760 572736 574237 574387 576214 577038 577600 580103 580319 581228 581348 583541 585266 585300 586372 586395 586408 587795 593080 596359 596785 602099 604549 610047 615919 617047 620056 622054 623887 652007 664823 669276 675281 683906 683973 685004 690882 702125 703947 714309 725583 732899 733271 748206 752653 766896 770392 776531 786454 811220 819271 824791 827684 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy fucking"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая fucking"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая fucking"
]
|
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.