Query Metrics
7
Database Queries
7
Different statements
144.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.02 ms (81.73%) |
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 182036 386732 413008 429892 432683 434361 434903 435136 435529 439340 443432 446251 447337 448854 467588 467875 468148 468616 475420 477496 477516 485472 494530 508917 508924 510729 511053 513220 513522 518505 531879 534443 551589 562578 563154 567245 578731 588169 589166 591527 596440 601460 602281 607683 607706 613690 617577 619570 621391 624688 626082 634750 640242 647383 653028 659057 662151 666974 674625 676416 679929 680754 687369 696584 697543 700042 700690 700906 704072 709937 710233 713186 715802 716001 718987 722390 726066 730461 730781 738461 738501 739126 739140 739146 739802 739821 740503 751044 753120 753190 760598 767267 772230 772654 774883 777761 778864 779718 782052 785816 785967 785979 788528 791600 796872 797773 798243 798291 801627 802650 808446 811690 811723 820162 823353 824630 827287 827393 ] |
||||||||||||||||||||||||||||||
|
16.33 ms (11.31%) |
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 435529 477516 508924 510729 494530 518505 448854 607706 468616 563154 596440 824630 827393 823353 826398 508917 386732 439340 827287 820162 531879 534443 551589 567245 653028 679929 709937 718987 647383 662151 674625 676416 687369 700906 710233 700690 722390 624688 607683 634750 588169 617577 619570 621391 774883 785816 786867 801627 808446 738501 753190 760598 797773 811723 726066 739146 751044 772654 730781 739126 739140 740503 753120 738461 739821 767267 772230 739802 602281 777761 778864 782052 785979 791600 796872 802650 182036 511053 477496 434361 447337 435136 443432 468148 475420 513220 485472 589166 798243 811690 730461 626082 798291 446251 467588 467875 429892 513522 715802 713186 432683 434903 413008 562578 659057 666974 704072 696584 716001 680754 697543 700042 578731 640242 591527 601460 613690 779718 785967 788528 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.76%) |
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 182036 386732 413008 429892 432683 434361 434903 435136 435529 439340 443432 446251 447337 448854 467588 467875 468148 468616 475420 477496 477516 485472 494530 508917 508924 510729 511053 513220 513522 518505 531879 534443 551589 562578 563154 567245 578731 588169 589166 591527 596440 601460 602281 607683 607706 613690 617577 619570 621391 624688 626082 634750 640242 647383 653028 659057 662151 666974 674625 676416 679929 680754 687369 696584 697543 700042 700690 700906 704072 709937 710233 713186 715802 716001 718987 722390 726066 730461 730781 738461 738501 739126 739140 739146 739802 739821 740503 751044 753120 753190 760598 767267 772230 772654 774883 777761 778864 779718 782052 785816 785967 785979 788528 791600 796872 797773 798243 798291 801627 802650 808446 811690 811723 820162 823353 824630 827287 827393 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo pussy"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд pussy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд pussy"
]
|
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.