Query Metrics
7
Database Queries
7
Different statements
137.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.06 ms (86.42%) |
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 402893 490437 493328 495803 498745 535311 539658 546852 552807 557719 561214 568817 572185 588503 601727 602876 610191 614438 615199 617114 619210 620378 620999 625744 626825 628510 629776 630152 634700 646713 647817 664518 682992 699316 706008 710164 710545 712135 712569 714141 715055 716437 717806 719991 721228 721256 721962 722054 723161 723269 723701 728404 728951 730185 730748 731260 732950 733242 735213 736320 740988 742275 743749 746036 752146 758996 761336 763090 763767 765088 767807 767884 768622 768634 773615 775319 778606 778972 779195 779319 779533 779892 780773 781242 781336 782345 783037 783089 783217 783673 783865 784686 785959 786135 786392 787340 787409 787436 787764 788339 789125 791323 791805 791831 791835 792443 799718 800945 800949 800996 803439 803811 807727 808201 810325 810854 811433 826750 ] |
||||||||||||||||||||||||||||||
|
10.23 ms (7.42%) |
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 619210 620999 625744 626825 628510 783037 800996 784686 731260 732950 742275 746036 736320 601727 614438 620378 630152 714141 717806 721228 779195 490437 493328 715055 552807 783865 791805 779319 800945 803439 807727 763090 787436 789125 768634 765088 761336 768622 743749 763767 767807 780773 783217 783673 791835 783089 730185 539658 561214 568817 710164 664518 402893 535311 546852 647817 699316 706008 712569 615199 602876 610191 629776 735213 733242 646713 682992 767884 826750 495803 498745 557719 572185 710545 721256 721962 723161 723269 712135 716437 719991 722054 617114 634700 588503 779892 791831 792443 799718 800949 803811 775319 778606 778972 779533 781242 781336 782345 786135 786392 787340 787764 788339 811433 723701 730748 740988 752146 758996 767576 767890 773615 785959 787409 791323 808201 810325 810854 728404 728951 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.66%) |
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 402893 490437 493328 495803 498745 535311 539658 546852 552807 557719 561214 568817 572185 588503 601727 602876 610191 614438 615199 617114 619210 620378 620999 625744 626825 628510 629776 630152 634700 646713 647817 664518 682992 699316 706008 710164 710545 712135 712569 714141 715055 716437 717806 719991 721228 721256 721962 722054 723161 723269 723701 728404 728951 730185 730748 731260 732950 733242 735213 736320 740988 742275 743749 746036 752146 758996 761336 763090 763767 765088 767807 767884 768622 768634 773615 775319 778606 778972 779195 779319 779533 779892 780773 781242 781336 782345 783037 783089 783217 783673 783865 784686 785959 786135 786392 787340 787409 787436 787764 788339 789125 791323 791805 791831 791835 792443 799718 800945 800949 800996 803439 803811 807727 808201 810325 810854 811433 826750 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm homemade"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (1.02%) |
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.