Query Metrics
7
Database Queries
7
Different statements
183.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.66 ms (84.18%) |
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 202134 303771 325910 381855 387716 395715 412609 413584 417823 425281 425555 430807 432487 434936 443092 448263 450344 450778 451157 451650 452985 453332 454710 455333 455811 456833 459005 460226 462703 462817 463302 470226 472335 472539 472706 473258 474005 478036 479015 485297 488934 490002 491010 492288 493022 496213 498303 500186 504717 509430 510324 513748 518822 520789 520791 522453 523231 524796 527959 528562 528572 528657 532727 533443 538514 540428 545442 548157 548966 554008 554431 558573 559520 560609 561078 561734 562110 562254 567097 567311 569418 570355 572569 573545 575504 577934 578485 584465 588228 589607 592300 594389 594981 595690 603361 607248 607697 617580 618992 622294 623238 624281 625165 630558 634533 639527 651909 659390 660311 661915 666716 689436 738625 746126 781904 796120 807293 809429 815196 816067 ] |
||||||||||||||||||||||||||||||
|
17.98 ms (9.79%) |
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 456833 202134 303771 816067 450344 492288 470226 520791 527959 554008 548966 661915 607697 618992 589607 623238 781904 807293 738625 412609 455811 474005 500186 425555 462817 520789 488934 584465 578485 460226 430807 473258 485297 490002 387716 432487 572569 577934 660311 607248 451650 498303 513748 325910 651909 567097 573545 595690 417823 395715 413584 453332 472706 523231 528562 533443 567311 569418 659390 594389 443092 479015 522453 560609 575504 559520 561734 594981 809429 381855 472335 450778 462703 491010 538514 540428 548157 561078 666716 689436 603361 630558 617580 639527 528572 493022 510324 524796 504717 518822 454710 532727 545442 625165 496213 558573 622294 592300 459005 434936 452985 528657 746126 509430 472539 588228 796120 448263 478036 455333 815196 634533 451157 570355 554431 562254 463302 562110 624281 425281 ] |
||||||||||||||||||||||||||||||
|
3.73 ms (2.03%) |
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 202134 303771 325910 381855 387716 395715 412609 413584 417823 425281 425555 430807 432487 434936 443092 448263 450344 450778 451157 451650 452985 453332 454710 455333 455811 456833 459005 460226 462703 462817 463302 470226 472335 472539 472706 473258 474005 478036 479015 485297 488934 490002 491010 492288 493022 496213 498303 500186 504717 509430 510324 513748 518822 520789 520791 522453 523231 524796 527959 528562 528572 528657 532727 533443 538514 540428 545442 548157 548966 554008 554431 558573 559520 560609 561078 561734 562110 562254 567097 567311 569418 570355 572569 573545 575504 577934 578485 584465 588228 589607 592300 594389 594981 595690 603361 607248 607697 617580 618992 622294 623238 624281 625165 630558 634533 639527 651909 659390 660311 661915 666716 689436 738625 746126 781904 796120 807293 809429 815196 816067 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wet ass fuck"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрые жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.85%) |
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.