Query Metrics
7
Database Queries
7
Different statements
151.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.40 ms (84.09%) |
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 11582 383250 388028 388746 391202 398689 405468 415588 421654 424304 425829 430306 431522 431730 433231 433232 433280 433334 433498 433675 438001 447466 448801 449021 452418 453625 453877 454228 455816 456891 457590 457789 462280 463094 463756 465070 465590 466554 469200 470449 470987 471392 472544 474538 474549 474826 478074 478828 481591 481965 486589 488897 491678 491768 492338 502288 502505 507675 511422 517668 522107 524285 525158 525747 527249 527452 530834 531510 541370 542579 550325 557182 562840 568423 582972 586103 587470 588281 595781 596141 596556 605333 606496 606575 615538 615756 615761 619495 620130 622174 624172 624841 630106 632020 633139 636545 669637 674118 676326 676342 676851 703540 705935 710781 716394 721739 729270 762513 768352 768357 768378 790026 798881 805069 807923 809440 809702 815566 816267 827078 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (9.91%) |
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 716394 606496 415588 383250 433280 827078 587470 669637 768357 457789 606575 388746 550325 405468 674118 531510 492338 447466 466554 421654 588281 721739 768352 486589 768378 619495 705935 703540 790026 455816 502505 511422 527452 463756 474549 433498 525747 457590 478828 11582 452418 527249 815566 809440 478074 488897 462280 507675 433231 542579 568423 710781 615538 807923 398689 596556 620130 465070 431522 630106 433675 541370 502288 676342 798881 633139 557182 433334 431730 517668 624172 809702 762513 605333 525158 474826 624841 596141 729270 453625 433232 491768 676851 524285 632020 636545 454228 582972 471392 481591 430306 448801 470449 438001 469200 453877 463094 470987 424304 472544 491678 425829 449021 522107 388028 562840 622174 586103 481965 391202 530834 474538 456891 816267 465590 676326 595781 615761 805069 615756 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.64%) |
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 11582 383250 388028 388746 391202 398689 405468 415588 421654 424304 425829 430306 431522 431730 433231 433232 433280 433334 433498 433675 438001 447466 448801 449021 452418 453625 453877 454228 455816 456891 457590 457789 462280 463094 463756 465070 465590 466554 469200 470449 470987 471392 472544 474538 474549 474826 478074 478828 481591 481965 486589 488897 491678 491768 492338 502288 502505 507675 511422 517668 522107 524285 525158 525747 527249 527452 530834 531510 541370 542579 550325 557182 562840 568423 582972 586103 587470 588281 595781 596141 596556 605333 606496 606575 615538 615756 615761 619495 620130 622174 624172 624841 630106 632020 633139 636545 669637 674118 676326 676342 676851 703540 705935 710781 716394 721739 729270 762513 768352 768357 768378 790026 798881 805069 807923 809440 809702 815566 816267 827078 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ffm compilation"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро подборк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.93%) |
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.