Query Metrics
7
Database Queries
7
Different statements
384.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.03 ms (55.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf худые"
]
|
||||||||||||||||||||||||||||||
|
151.22 ms (39.30%) |
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 6965 74434 397888 413109 421215 440651 451455 466057 471552 478768 491143 505524 545549 549973 555703 557352 559589 561920 562849 566550 569164 569736 569871 569924 570390 570851 576121 576526 576621 578692 583314 585985 588748 590190 590292 591753 592075 592419 596090 597514 598009 598339 600142 600626 603200 605145 605186 605625 618553 621979 624849 626133 633115 644499 648211 651128 652856 664842 665950 666661 667128 670465 671189 671647 672945 676862 681508 682908 686035 709396 715097 716186 720118 721810 722534 723668 724188 725353 726379 728964 730341 731762 733789 739705 740890 749465 751620 768018 768591 773477 777160 777940 780679 781489 785729 785944 790654 792925 793243 794713 796844 796889 797287 798901 799058 799225 801918 801925 802678 802976 803367 803633 805206 806833 807567 810565 810814 811830 812764 ] |
||||||||||||||||||||||||||||||
|
13.52 ms (3.51%) |
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 566550 569736 576121 576526 576621 648211 651128 665950 666661 670465 671189 681508 686035 664842 667128 672945 682908 652856 671647 676862 715097 720118 545549 549973 555703 557352 559589 561920 562849 569164 569871 569924 570390 570851 578692 583314 598339 621979 626133 590190 590292 592075 600142 605145 605625 633115 644499 588748 591753 592419 600626 585985 596090 597514 598009 603200 624849 790654 794713 796889 798901 801918 802678 803367 805206 807567 777940 785729 797287 803633 810565 810814 812764 723668 724188 725353 749465 768018 785944 792925 799225 806833 726379 728964 731762 733789 739705 740890 773477 730341 751620 768591 768922 605186 618553 709396 716186 721810 722534 777160 780679 781489 793243 796844 799058 801925 802976 811830 413109 471552 6965 74434 466057 440651 451455 397888 478768 505524 491143 421215 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (0.73%) |
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 6965 74434 397888 413109 421215 440651 451455 466057 471552 478768 491143 505524 545549 549973 555703 557352 559589 561920 562849 566550 569164 569736 569871 569924 570390 570851 576121 576526 576621 578692 583314 585985 588748 590190 590292 591753 592075 592419 596090 597514 598009 598339 600142 600626 603200 605145 605186 605625 618553 621979 624849 626133 633115 644499 648211 651128 652856 664842 665950 666661 667128 670465 671189 671647 672945 676862 681508 682908 686035 709396 715097 716186 720118 721810 722534 723668 724188 725353 726379 728964 730341 731762 733789 739705 740890 749465 751620 768018 768591 773477 777160 777940 780679 781489 785729 785944 790654 792925 793243 794713 796844 796889 797287 798901 799058 799225 801918 801925 802678 802976 803367 803633 805206 806833 807567 810565 810814 811830 812764 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf skinny"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf худые"
]
|
||||||||||||||||||||||||||||||
|
1.54 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.