Query Metrics
7
Database Queries
7
Different statements
148.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.54 ms (80.76%) |
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 400828 402141 405804 406041 410132 413141 414686 428157 452286 461291 466445 469469 473739 474601 477239 479279 484819 488991 493819 494857 496544 501724 504376 504840 505844 509320 511617 512192 514577 516230 517245 518881 519740 520440 520463 520627 520838 520909 521666 522057 522783 522843 525286 528695 532023 532246 535255 535937 540977 540996 547864 548429 549214 551941 553108 556785 556913 557324 558035 558563 560786 561291 561389 561836 561919 565235 566330 567290 568796 569613 574137 580670 583039 585181 590587 591439 591980 593162 593939 595068 595503 596436 597146 597966 598172 598486 598545 599057 605089 605359 605445 605458 605812 606949 607387 611266 613055 613268 615560 616890 619598 621170 621770 622601 622772 623623 624367 624489 624911 642751 644567 647090 650660 653464 654464 654466 654503 659217 675798 684802 ] |
||||||||||||||||||||||||||||||
|
18.48 ms (12.48%) |
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 580670 414686 535255 623623 624489 561291 520627 410132 517245 402141 512192 684802 522057 461291 566330 474601 493819 488991 520463 496544 516230 518881 540977 644567 511617 561836 596436 547864 595068 605458 519740 505844 556785 647090 642751 551941 567290 558563 583039 675798 561919 466445 622772 522843 593162 654464 659217 569613 504376 469469 525286 484819 611266 521666 549214 406041 557324 560786 501724 535937 654466 561389 605359 400828 606949 520838 593939 590587 479279 585181 597146 653464 452286 522783 532023 520440 650660 613055 621170 548429 477239 428157 509320 591980 605089 532246 619598 540996 597966 598545 591439 616890 565235 504840 514577 654503 568796 598172 595503 605812 574137 624367 413141 621770 556913 613268 494857 622601 553108 615560 473739 405804 520909 607387 528695 558035 598486 605445 599057 624911 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.05%) |
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 400828 402141 405804 406041 410132 413141 414686 428157 452286 461291 466445 469469 473739 474601 477239 479279 484819 488991 493819 494857 496544 501724 504376 504840 505844 509320 511617 512192 514577 516230 517245 518881 519740 520440 520463 520627 520838 520909 521666 522057 522783 522843 525286 528695 532023 532246 535255 535937 540977 540996 547864 548429 549214 551941 553108 556785 556913 557324 558035 558563 560786 561291 561389 561836 561919 565235 566330 567290 568796 569613 574137 580670 583039 585181 590587 591439 591980 593162 593939 595068 595503 596436 597146 597966 598172 598486 598545 599057 605089 605359 605445 605458 605812 606949 607387 611266 613055 613268 615560 616890 619598 621170 621770 622601 622772 623623 624367 624489 624911 642751 644567 647090 650660 653464 654464 654466 654503 659217 675798 684802 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нежно сосет член"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"нежн минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 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.