Query Metrics
7
Database Queries
7
Different statements
160.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.70 ms (85.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 6999 82252 150488 412605 420738 422388 423299 435816 442473 447834 451691 457028 462658 462782 474324 476563 493134 509431 527580 530929 535001 535859 538499 541167 548373 548919 563408 564185 568312 572734 573596 573656 573711 574573 575160 576614 587591 592930 594182 601021 601163 601251 603723 623525 628828 638542 643835 645844 645846 645853 645919 648963 651083 662723 664573 669504 671407 671891 672752 678185 689998 690308 692252 692583 696322 698010 698483 700733 702549 704638 705691 709685 718416 724315 726948 727698 730762 731607 731689 731816 732104 732995 733072 734790 735241 735250 736447 736687 737129 738443 739446 741356 743552 745797 745842 745956 747904 747921 749608 750065 750509 750851 753945 757155 758903 759422 769930 785351 796572 799103 799568 800863 810027 810954 814711 816620 818559 820024 823439 827573 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (8.91%) |
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 739446 736687 732995 738443 733072 698010 645844 796572 799568 150488 6999 530929 671891 704638 757155 759422 750065 442473 592930 420738 818559 827573 814711 509431 564185 548919 664573 576614 799103 810027 734790 736447 737129 745956 758903 769930 749608 623525 698483 800863 412605 573596 548373 718416 705691 700733 573711 628828 690308 462782 823439 816620 820024 568312 572734 678185 709685 692252 753945 741356 747904 747921 735250 735241 750509 702549 726948 645846 645853 648963 662723 692583 594182 638542 601251 601021 730762 745797 745842 743552 731607 731689 643835 435816 422388 535859 574573 671407 689998 696322 645919 750851 731816 462658 493134 672752 451691 457028 538499 527580 535001 651083 563408 587591 601163 603723 810954 724315 785351 575160 669504 573656 732104 541167 727698 82252 423299 474324 447834 476563 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.70%) |
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 6999 82252 150488 412605 420738 422388 423299 435816 442473 447834 451691 457028 462658 462782 474324 476563 493134 509431 527580 530929 535001 535859 538499 541167 548373 548919 563408 564185 568312 572734 573596 573656 573711 574573 575160 576614 587591 592930 594182 601021 601163 601251 603723 623525 628828 638542 643835 645844 645846 645853 645919 648963 651083 662723 664573 669504 671407 671891 672752 678185 689998 690308 692252 692583 696322 698010 698483 700733 702549 704638 705691 709685 718416 724315 726948 727698 730762 731607 731689 731816 732104 732995 733072 734790 735241 735250 736447 736687 737129 738443 739446 741356 743552 745797 745842 745956 747904 747921 749608 750065 750509 750851 753945 757155 758903 759422 769930 785351 796572 799103 799568 800863 810027 810954 814711 816620 818559 820024 823439 827573 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big natural porn"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие натуральная натуральные porn"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие натуральная натуральные porn"
]
|
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.