Query Metrics
7
Database Queries
7
Different statements
381.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.17 ms (53.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina creampie"
]
|
||||||||||||||||||||||||||||||
|
152.38 ms (39.92%) |
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 338338 395947 400620 403421 414730 415092 417113 417130 417788 420405 422415 423602 447733 449800 450190 450597 452275 453958 458604 493885 496460 509971 536145 541559 542256 555763 559311 559423 561860 562819 563684 572360 572770 578756 587582 591186 591766 591818 603611 610123 613688 616429 616475 616595 617682 619684 620378 622562 626443 626599 635004 645667 653070 664224 666684 687147 689040 693425 700689 707236 707753 714392 719924 720067 720579 722109 722329 725065 726725 734661 738743 738911 739879 740905 746039 747967 750680 751524 755119 757914 759697 761354 761904 769008 769201 770506 770774 773639 773691 774540 775484 776363 777557 778604 778938 781077 781132 781154 781522 782573 785079 787263 787433 790041 791046 791530 791684 791835 793521 794511 794931 795011 795107 795826 795916 797718 801343 804463 807721 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (3.94%) |
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 739879 747967 751524 759697 769008 770506 620378 714392 719924 722329 776363 777557 778938 781077 781154 782573 787433 790041 791046 791835 807721 417130 559311 555763 610123 616475 591766 591818 757914 422415 572360 617682 338338 496460 563684 572770 562819 622562 591186 616429 587582 626599 613688 400620 414730 415092 420405 423602 447733 449800 450190 452275 458604 536145 541559 542256 559423 664224 693425 689040 707236 722109 645667 653070 666684 687147 707753 720067 720579 561860 578756 619684 626443 603611 635004 774540 775484 778604 781132 791530 794511 794931 795107 795826 804463 725065 726725 734661 750680 755119 770774 773639 785079 787263 791684 738911 760972 761904 773691 738743 769201 740905 746039 761354 616595 700689 781522 793521 795011 795916 797718 801343 395947 493885 403421 417113 417788 453958 450597 509971 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.74%) |
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 338338 395947 400620 403421 414730 415092 417113 417130 417788 420405 422415 423602 447733 449800 450190 450597 452275 453958 458604 493885 496460 509971 536145 541559 542256 555763 559311 559423 561860 562819 563684 572360 572770 578756 587582 591186 591766 591818 603611 610123 613688 616429 616475 616595 617682 619684 620378 622562 626443 626599 635004 645667 653070 664224 666684 687147 689040 693425 700689 707236 707753 714392 719924 720067 720579 722109 722329 725065 726725 734661 738743 738911 739879 740905 746039 747967 750680 751524 755119 757914 759697 761354 761904 769008 769201 770506 770774 773639 773691 774540 775484 776363 777557 778604 778938 781077 781132 781154 781522 782573 785079 787263 787433 790041 791046 791530 791684 791835 793521 794511 794931 795011 795107 795826 795916 797718 801343 804463 807721 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин creampie"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин creampie"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.