Query Metrics
7
Database Queries
7
Different statements
158.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.95 ms (85.22%) |
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 393972 473977 478770 511317 512641 519401 529806 539500 569277 571513 593065 593130 593196 606055 606804 611171 612395 617729 620528 631551 633071 637303 645681 652424 660321 667990 684893 694598 701427 705452 707481 709797 717105 718301 719292 722248 722326 723487 725573 726016 728601 729748 729867 730068 732166 732996 735124 736305 736365 737051 738736 741079 742093 748320 749583 749722 751220 752963 753476 754261 755112 755262 757087 757184 759383 759525 760083 761114 763959 764058 767092 767614 768528 769199 773166 777248 778180 780309 780354 781224 781376 781582 782528 784474 784869 785654 788621 788987 790764 790861 791448 791511 791593 795724 796233 799241 799644 799993 800177 801720 805029 808041 810537 810758 811892 812234 813551 814195 814197 814203 814231 816694 816773 817642 817679 819137 822837 822913 826652 ] |
||||||||||||||||||||||||||||||
|
13.26 ms (8.38%) |
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 776246 785654 796233 799993 810758 780354 781224 784474 791593 730068 791448 791511 799241 742093 757184 764058 753476 757087 761114 725573 736365 768528 732166 737051 749722 763959 701427 777248 780309 790861 801720 812234 473977 393972 512641 784869 778180 814203 593196 782528 814231 539500 694598 722248 652424 569277 571513 617729 637303 781582 741079 760083 722326 814197 816773 817679 813551 816694 822837 814195 817642 819137 822913 826652 511317 519401 529806 478770 645681 667990 684893 707481 717105 723487 705452 660321 709797 718301 719292 606804 606055 612395 620528 633071 593130 611171 593065 631551 811892 781376 788987 795724 799644 800177 805029 808041 726016 729748 736305 752963 755112 769199 788621 790764 810537 748320 749583 767092 729867 735124 754261 773166 751220 759383 759525 767614 728601 732996 738736 755262 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.84%) |
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 393972 473977 478770 511317 512641 519401 529806 539500 569277 571513 593065 593130 593196 606055 606804 611171 612395 617729 620528 631551 633071 637303 645681 652424 660321 667990 684893 694598 701427 705452 707481 709797 717105 718301 719292 722248 722326 723487 725573 726016 728601 729748 729867 730068 732166 732996 735124 736305 736365 737051 738736 741079 742093 748320 749583 749722 751220 752963 753476 754261 755112 755262 757087 757184 759383 759525 760083 761114 763959 764058 767092 767614 768528 769199 773166 777248 778180 780309 780354 781224 781376 781582 782528 784474 784869 785654 788621 788987 790764 790861 791448 791511 791593 795724 796233 799241 799644 799993 800177 801720 805029 808041 810537 810758 811892 812234 813551 814195 814197 814203 814231 816694 816773 817642 817679 819137 822837 822913 826652 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl horny"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк horny"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк horny"
]
|
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.