Query Metrics
7
Database Queries
7
Different statements
149.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.04 ms (82.83%) |
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 79742 385040 389304 395326 398738 420608 423942 428405 432384 441762 448496 452744 469768 470014 472095 472860 512434 517789 535804 550467 551622 559616 564286 571946 578237 586221 591753 597522 598523 600235 608313 614597 617061 617353 626235 626309 630837 630917 652665 655260 656167 658553 659353 662074 663344 664455 666663 668987 682883 683044 701182 707928 710448 710486 713753 716204 716725 717756 717949 718351 719106 719109 719130 719233 726373 729789 730496 731108 732147 732884 734140 734333 734964 738314 741841 743904 744658 745327 745486 747665 748768 752505 752701 759951 761302 767393 768423 769069 769443 769855 771159 773187 776290 777212 777482 778592 779266 779716 779722 779748 781533 781569 784240 785359 786653 787203 789859 791218 791667 793498 795198 796018 796656 806849 809329 810373 811349 818270 819387 820378 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (9.72%) |
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 726373 767393 747665 626309 389304 729789 795198 734964 768423 719130 395326 818270 448496 517789 564286 550467 578237 666663 663344 717756 718351 719233 682883 586221 591753 630837 600235 784240 791667 777212 779716 779748 786653 796018 732147 781533 738314 748768 626235 793498 820378 701182 716204 707928 734333 759951 730496 769069 769855 806849 470014 472095 617061 559616 597522 752505 398738 423942 571946 656167 779266 773187 732884 745486 785359 796656 385040 771159 752701 652665 719109 658553 662074 608313 779722 769443 745327 713753 719106 420608 79742 452744 472860 655260 598523 787203 809329 761302 734140 614597 432384 441762 512434 535804 551622 668987 710448 716725 659353 664455 683044 717949 617353 630917 778592 776290 789859 811349 741841 781569 743904 731108 744658 710486 810373 777482 791218 428405 819387 469768 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck to cum"
]
|
||||||||||||||||||||||||||||||
|
2.68 ms (1.79%) |
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 79742 385040 389304 395326 398738 420608 423942 428405 432384 441762 448496 452744 469768 470014 472095 472860 512434 517789 535804 550467 551622 559616 564286 571946 578237 586221 591753 597522 598523 600235 608313 614597 617061 617353 626235 626309 630837 630917 652665 655260 656167 658553 659353 662074 663344 664455 666663 668987 682883 683044 701182 707928 710448 710486 713753 716204 716725 717756 717949 718351 719106 719109 719130 719233 726373 729789 730496 731108 732147 732884 734140 734333 734964 738314 741841 743904 744658 745327 745486 747665 748768 752505 752701 759951 761302 767393 768423 769069 769443 769855 771159 773187 776290 777212 777482 778592 779266 779716 779722 779748 781533 781569 784240 785359 786653 787203 789859 791218 791667 793498 795198 796018 796656 806849 809329 810373 811349 818270 819387 820378 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс cum"
]
|
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.