Query Metrics
7
Database Queries
7
Different statements
347.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.30 ms (60.16%) |
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 429974 452913 546671 549363 551993 552176 553516 556694 562304 563452 566923 568852 570571 570810 573631 573853 586035 590295 591520 596039 596074 596222 596230 596381 597499 598787 600110 600596 600830 603125 604266 604970 615539 619420 620317 621451 623950 624709 630660 631260 632719 635117 642314 644234 645826 654356 654514 654619 654670 654721 654826 654833 655679 655750 656360 656785 657393 657705 658296 658403 658670 659140 659502 659650 659759 660296 660974 661249 661440 661885 665453 669435 670405 671325 671597 683559 686453 692625 692627 698048 702010 703510 704347 709466 712028 715332 720488 720588 720766 721317 722764 723346 725378 728995 729835 730718 733659 735985 736373 740262 742215 743240 746146 746978 754355 754505 765598 766542 775621 786191 789307 793982 794079 796232 798247 798661 800390 803147 804569 809904 ] |
||||||||||||||||||||||||||||||
|
121.29 ms (34.86%) |
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 429974 452913 546671 549363 551993 552176 553516 556694 562304 563452 566923 568852 570571 570810 573631 573853 586035 590295 591520 596039 596074 596222 596230 596381 597499 598787 600110 600596 600830 603125 604266 604970 615539 619420 620317 621451 623950 624709 630660 631260 632719 635117 642314 644234 645826 654356 654514 654619 654670 654721 654826 654833 655679 655750 656360 656785 657393 657705 658296 658403 658670 659140 659502 659650 659759 660296 660974 661249 661440 661885 665453 669435 670405 671325 671597 683559 686453 692625 692627 698048 702010 703510 704347 709466 712028 715332 720488 720588 720766 721317 722764 723346 725378 728995 729835 730718 733659 735985 736373 740262 742215 743240 746146 746978 754355 754505 765598 766542 775621 786191 789307 793982 794079 796232 798247 798661 800390 803147 804569 809904 ] |
||||||||||||||||||||||||||||||
|
10.16 ms (2.92%) |
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 686453 692625 692627 645826 654356 654670 654721 655750 656360 657393 658296 658403 659502 659759 660296 660974 661249 661440 661885 669435 670405 671597 683559 720766 654514 654619 654826 654833 655679 656785 657705 658670 659140 659650 665453 698048 702010 715332 720488 720588 722764 723346 546671 553516 556694 562304 563452 566923 570810 573631 573853 586035 596381 597499 600596 620317 644234 590295 591520 600830 632719 596074 596222 598787 604266 604970 615539 623950 631260 635117 642314 596039 596230 600110 603125 794079 786191 798661 803147 809904 728995 729835 735985 742215 743240 766542 793982 798247 804569 725378 736373 740262 765598 746146 730718 754355 746978 754505 624709 703510 704347 709466 712028 721317 775621 789307 796232 800390 429974 630660 452913 549363 733659 568852 570571 551993 552176 671325 619420 621451 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits skinny"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ худые"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая сиськ худые"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.46%) |
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.