Query Metrics
7
Database Queries
7
Different statements
170.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.14 ms (85.07%) |
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 91510 184943 186790 317166 326081 340613 382240 382720 382820 383903 386408 388350 388555 390362 395841 395932 397740 404349 405020 405288 414139 414759 414866 415435 415451 416131 417887 419032 419157 420050 420067 420474 420499 421147 422484 425163 428858 430264 431667 432794 433558 434271 447386 449097 457516 460211 463209 463747 464465 466646 470218 471860 472698 473025 473087 475140 481506 489820 490646 494040 496008 496644 503924 506092 510571 517846 521631 521752 525345 527524 529507 545913 546618 546786 547548 554435 564650 571187 571594 573596 577268 581360 583852 585210 593107 598783 603425 614836 639310 646081 648896 650551 652890 661034 661063 661092 670751 670949 675382 682543 683854 687199 697290 711875 770514 800976 815813 816854 817185 818441 819130 819230 820738 822430 823545 826844 827864 827937 827972 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (8.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 529507 510571 546786 585210 466646 496644 670949 415435 404349 432794 395841 405020 425163 475140 460211 489820 494040 382820 431667 472698 421147 405288 395932 471860 490646 382720 422484 447386 473025 503924 573596 581360 564650 546618 340613 449097 433558 388350 416131 419157 430264 463747 506092 397740 417887 414139 415451 434271 470218 521752 496008 547548 583852 545913 571594 675382 646081 661034 593107 598783 599432 614836 639310 800976 770514 91510 414866 419032 420067 420499 428858 464465 481506 326081 390362 463209 420050 317166 457516 473087 414759 521631 525345 517846 386408 383903 186790 184943 382240 388555 420474 818441 819230 820738 826844 815813 819130 822430 823545 816854 817185 827972 827937 827864 527524 571187 577268 554435 652890 661063 661092 697290 711875 670751 682543 683854 687199 648896 650551 603425 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.65%) |
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 91510 184943 186790 317166 326081 340613 382240 382720 382820 383903 386408 388350 388555 390362 395841 395932 397740 404349 405020 405288 414139 414759 414866 415435 415451 416131 417887 419032 419157 420050 420067 420474 420499 421147 422484 425163 428858 430264 431667 432794 433558 434271 447386 449097 457516 460211 463209 463747 464465 466646 470218 471860 472698 473025 473087 475140 481506 489820 490646 494040 496008 496644 503924 506092 510571 517846 521631 521752 525345 527524 529507 545913 546618 546786 547548 554435 564650 571187 571594 573596 577268 581360 583852 585210 593107 598783 603425 614836 639310 646081 648896 650551 652890 661034 661063 661092 670751 670949 675382 682543 683854 687199 697290 711875 770514 800976 815813 816854 817185 818441 819130 819230 820738 822430 823545 826844 827864 827937 827972 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful hairy"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.01%) |
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.