Query Metrics
7
Database Queries
7
Different statements
394.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.11 ms (54.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
156.28 ms (39.61%) |
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 69797 88031 88174 88614 212959 290847 392023 402278 402619 414114 416678 416681 419439 421257 421369 427364 428235 429596 435689 443240 449173 455078 455918 462845 467568 471148 473453 477021 480251 487291 499921 506105 511857 531827 531874 532890 533990 536524 537155 545462 547235 547494 548926 554551 556885 557108 559784 561038 574065 587306 588045 595571 596684 596694 604105 604781 607706 619802 621496 624191 627147 630091 641804 642110 644335 648705 650770 654988 663317 669079 669346 669386 672754 678713 687305 701285 703651 710528 712268 713500 714365 717687 722385 722394 735906 742577 745126 745201 749271 752644 752661 752676 756749 760594 761265 765248 770253 776209 776400 783600 784681 786864 788271 792600 792713 796692 796694 796716 803009 803134 807570 809015 811714 811733 812409 819218 819223 821033 821964 822975 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (3.60%) |
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 811733 477021 587306 607706 630091 506105 511857 812409 703651 669346 69797 88031 480251 648705 717687 722385 557108 574065 588045 595571 786864 742577 756749 212959 672754 471148 462845 290847 416678 429596 467568 449173 559784 556885 392023 455078 427364 443240 621496 487291 428235 455918 499921 547235 554551 596684 596694 776400 776209 752676 784681 745126 770253 735906 752644 421257 532890 536524 537155 531827 531874 545462 548926 710528 687305 701285 663317 644335 792600 792713 803009 796716 745201 760594 604105 796694 88614 402619 712268 402278 749271 803134 809015 435689 419439 416681 473453 547494 561038 678713 669079 669386 619802 624191 627147 604781 752661 414114 421369 819223 819218 765248 714365 88174 822975 821964 821033 533990 654988 650770 713500 722394 642110 641804 807570 811714 788271 796692 761265 783600 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (0.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 69797 88031 88174 88614 212959 290847 392023 402278 402619 414114 416678 416681 419439 421257 421369 427364 428235 429596 435689 443240 449173 455078 455918 462845 467568 471148 473453 477021 480251 487291 499921 506105 511857 531827 531874 532890 533990 536524 537155 545462 547235 547494 548926 554551 556885 557108 559784 561038 574065 587306 588045 595571 596684 596694 604105 604781 607706 619802 621496 624191 627147 630091 641804 642110 644335 648705 650770 654988 663317 669079 669346 669386 672754 678713 687305 701285 703651 710528 712268 713500 714365 717687 722385 722394 735906 742577 745126 745201 749271 752644 752661 752676 756749 760594 761265 765248 770253 776209 776400 783600 784681 786864 788271 792600 792713 796692 796694 796716 803009 803134 807570 809015 811714 811733 812409 819218 819223 821033 821964 822975 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo huge dildo"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.40%) |
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.