Query Metrics
7
Database Queries
7
Different statements
353.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.50 ms (60.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм mouth"
]
|
||||||||||||||||||||||||||||||
|
121.16 ms (34.27%) |
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 69883 336884 393164 398679 407159 503388 506238 517739 520364 535806 537178 552385 553701 563382 575238 581289 584956 586978 591919 623407 624028 634597 642041 644883 655503 663223 663309 664564 666402 674616 695693 696220 697731 710819 717958 719821 720082 724685 724688 728866 731572 733138 733198 733584 734007 734025 736154 739542 740005 740187 742973 746357 746693 752082 755615 760302 764749 765041 765085 766366 766966 767346 767781 767805 767807 768803 769840 772361 772371 772826 774265 777452 777508 779533 779759 780233 780281 780405 782787 783682 784686 786821 787116 787213 787273 787409 788090 788316 790127 790131 790577 795572 795700 800046 805096 809541 810216 813634 817001 819718 821429 823875 823897 824113 824948 824973 825006 825045 825108 825180 825208 825425 825460 826240 826586 827108 828193 ] |
||||||||||||||||||||||||||||||
|
10.32 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 810216 336884 823875 824973 817001 823897 826240 827108 821429 825108 825180 828193 696220 766366 733198 769840 813634 695693 720082 777452 739542 772371 731572 765041 767807 717958 642041 517739 825045 520364 503388 393164 398679 825006 825460 826137 826586 825425 824948 825208 819718 824113 733138 69883 506238 535806 537178 552385 553701 563382 663223 655503 666402 674616 697731 663309 710819 575238 581289 584956 586978 624028 623407 591919 634597 777508 780405 787116 790577 800046 779533 780281 783682 787273 788090 788316 790127 809541 742973 746357 746693 755615 767805 772826 782787 784686 787213 787409 790131 805096 724688 734007 740187 764749 765085 766966 774265 724685 733584 734025 752082 760302 765378 728866 740005 767346 767781 768803 772361 736154 764819 719821 779759 780233 786821 795572 795700 407159 644883 664564 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.68%) |
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 69883 336884 393164 398679 407159 503388 506238 517739 520364 535806 537178 552385 553701 563382 575238 581289 584956 586978 591919 623407 624028 634597 642041 644883 655503 663223 663309 664564 666402 674616 695693 696220 697731 710819 717958 719821 720082 724685 724688 728866 731572 733138 733198 733584 734007 734025 736154 739542 740005 740187 742973 746357 746693 752082 755615 760302 764749 765041 765085 766366 766966 767346 767781 767805 767807 768803 769840 772361 772371 772826 774265 777452 777508 779533 779759 780233 780281 780405 782787 783682 784686 786821 787116 787213 787273 787409 788090 788316 790127 790131 790577 795572 795700 800046 805096 809541 810216 813634 817001 819718 821429 823875 823897 824113 824948 824973 825006 825045 825108 825180 825208 825425 825460 826240 826586 827108 828193 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm to mouth"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм mouth"
]
|
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.