Query Metrics
7
Database Queries
7
Different statements
215.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.12 ms (86.55%) |
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 78412 129916 130022 309758 384593 386062 386300 393855 399395 417879 430428 453088 470276 474055 486790 494408 515223 522160 538962 541643 542864 543858 545363 545389 545409 545410 545418 545488 545773 550207 553272 562068 562814 562825 565245 566789 577331 579113 581193 583925 593843 597272 597963 598806 604536 606570 608431 608756 609196 615696 615717 618326 620711 620785 622042 622651 623196 624270 625423 627812 628082 628333 628384 628398 630524 631196 633449 633497 633718 634187 634462 634769 637074 637422 637729 644275 644300 647898 648543 649148 652253 666868 668525 680176 680186 680207 682404 695127 696568 701310 702163 703037 703040 703095 703535 704523 705906 707391 708144 715521 726209 726744 735430 748926 748949 756766 767185 775947 775986 775990 776017 778040 784148 789981 796430 801927 817450 817719 818377 824051 ] |
||||||||||||||||||||||||||||||
|
18.37 ms (8.54%) |
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 633497 581193 648543 633718 637422 628384 628398 637729 701310 668525 704523 630524 515223 550207 562068 542864 566789 702163 545773 634769 628082 647898 565245 597272 631196 543858 623196 608431 615717 680176 577331 545363 579113 553272 633449 545488 680186 666868 680207 634187 597963 608756 545389 545409 707391 695127 625423 545410 627812 598806 545418 541643 628333 624270 637074 562814 609196 562825 615696 618326 538962 309758 593843 776017 796430 652253 715521 622042 417879 583925 696568 703535 824051 735430 767185 78412 494408 606570 775986 817719 703040 622651 775990 778040 682404 620785 703037 453088 649148 634462 644275 703095 470276 130022 789981 726209 756766 604536 775947 386062 474055 486790 129916 784148 430428 818377 393855 399395 522160 644300 748949 620711 386300 384593 817450 708144 726744 748926 705906 801927 ] |
||||||||||||||||||||||||||||||
|
3.94 ms (1.83%) |
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 78412 129916 130022 309758 384593 386062 386300 393855 399395 417879 430428 453088 470276 474055 486790 494408 515223 522160 538962 541643 542864 543858 545363 545389 545409 545410 545418 545488 545773 550207 553272 562068 562814 562825 565245 566789 577331 579113 581193 583925 593843 597272 597963 598806 604536 606570 608431 608756 609196 615696 615717 618326 620711 620785 622042 622651 623196 624270 625423 627812 628082 628333 628384 628398 630524 631196 633449 633497 633718 634187 634462 634769 637074 637422 637729 644275 644300 647898 648543 649148 652253 666868 668525 680176 680186 680207 682404 695127 696568 701310 702163 703037 703040 703095 703535 704523 705906 707391 708144 715521 726209 726744 735430 748926 748949 756766 767185 775947 775986 775990 776017 778040 784148 789981 796430 801927 817450 817719 818377 824051 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк gangbang"
]
|
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.