Query Metrics
7
Database Queries
7
Different statements
226.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.53 ms (86.02%) |
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 419773 421564 427983 428301 429943 443529 445737 451256 471691 477473 507696 530491 530624 531172 531230 532741 532790 532837 532852 532960 533926 533949 534627 536285 536290 536339 536562 536579 536616 536628 536651 537763 537908 539239 541853 543614 543615 543627 544803 544812 550196 552278 554462 559061 561117 566786 574247 597269 597275 599950 599953 600008 600194 600219 600366 601512 601625 601636 617412 617414 617437 627806 629411 630511 630536 632579 632655 632706 633773 633787 634155 634812 635171 636321 637022 637042 637122 637125 641681 641698 641950 641958 641977 642053 643376 644280 645952 647320 647663 647885 647914 648815 649595 650175 650762 651079 651188 653447 666866 666903 674978 675019 676091 676092 677296 678121 678517 678533 679728 696998 704715 716882 723620 745245 759624 775818 801923 801975 805288 805558 ] |
||||||||||||||||||||||||||||||
|
19.05 ms (8.42%) |
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 641950 600008 633787 634155 634812 637122 637125 601636 599950 599953 630511 641958 641977 642053 617412 617414 629411 632655 633773 641681 644280 805288 477473 421564 532790 532852 536628 533926 537763 676091 759624 451256 641698 541853 566786 677296 627806 632579 632706 443529 427983 530491 530624 533949 561117 647320 550196 601625 636321 600194 643376 801923 805558 637022 428301 635171 574247 696998 704715 600366 597269 597275 801975 601512 666903 552278 617437 471691 445737 745245 775818 630536 429943 507696 637042 600219 419773 723620 531230 534627 536285 536290 536562 536651 537908 539239 532741 532960 536339 536579 531172 532837 536616 543614 554462 559061 543615 543627 544803 544812 647663 650175 666866 674978 678517 679728 650762 651079 653447 678121 678533 716882 645952 647885 647914 648815 649595 651188 675019 676092 ] |
||||||||||||||||||||||||||||||
|
4.49 ms (1.98%) |
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 419773 421564 427983 428301 429943 443529 445737 451256 471691 477473 507696 530491 530624 531172 531230 532741 532790 532837 532852 532960 533926 533949 534627 536285 536290 536339 536562 536579 536616 536628 536651 537763 537908 539239 541853 543614 543615 543627 544803 544812 550196 552278 554462 559061 561117 566786 574247 597269 597275 599950 599953 600008 600194 600219 600366 601512 601625 601636 617412 617414 617437 627806 629411 630511 630536 632579 632655 632706 633773 633787 634155 634812 635171 636321 637022 637042 637122 637125 641681 641698 641950 641958 641977 642053 643376 644280 645952 647320 647663 647885 647914 648815 649595 650175 650762 651079 651188 653447 666866 666903 674978 675019 676091 676092 677296 678121 678517 678533 679728 696998 704715 716882 723620 745245 759624 775818 801923 801975 805288 805558 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape ass gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк жоп gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.78%) |
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.