Query Metrics
7
Database Queries
7
Different statements
206.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.22 ms (86.25%) |
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 8824 53805 322773 357302 371263 382652 383659 384015 386071 386636 391175 393767 395978 396605 397371 400984 402721 406501 409410 410867 417884 450833 456978 457155 458127 458573 470693 514715 515198 529742 530731 539228 539516 543177 560263 566522 581981 582934 594347 597972 604536 608398 625370 650099 652903 664618 668479 675160 675173 677046 678977 683560 684208 684267 694214 713098 715415 719827 723123 728173 733007 734500 735404 736917 740603 744260 744331 748427 748747 752154 755784 755935 763239 764519 766698 767928 767950 770343 771159 772319 773490 774079 774160 774595 776879 780491 780498 784439 786071 788000 789679 790388 794600 795074 798907 798980 800119 800506 800943 802417 803263 807638 810399 810622 810989 811488 813721 814977 816026 817044 818123 818430 819490 819508 819911 821645 822003 823813 824490 826070 ] |
||||||||||||||||||||||||||||||
|
18.53 ms (8.97%) |
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 776879 780491 450833 675173 771159 786071 733007 748747 755935 764519 773490 470693 406501 357302 457155 694214 784439 748427 529742 581981 798907 417884 788000 8824 456978 458127 539516 664618 650099 322773 393767 53805 566522 800119 810989 770343 386636 402721 400984 715415 736917 774160 774079 409410 766698 814977 594347 386071 384015 515198 790388 803263 822003 543177 391175 813721 798980 802417 810399 767950 800943 382652 677046 744260 604536 560263 582934 723123 772319 794600 795074 734500 763239 740603 810622 530731 668479 678977 625370 774595 800506 755784 752154 397371 396605 410867 819911 826070 817044 819490 819508 458573 652903 684208 713098 683560 684267 719827 597972 608398 789679 811488 767928 728173 735404 744331 807638 395978 383659 539228 675160 780498 514715 371263 821645 818123 818430 824490 816026 823813 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.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 8824 53805 322773 357302 371263 382652 383659 384015 386071 386636 391175 393767 395978 396605 397371 400984 402721 406501 409410 410867 417884 450833 456978 457155 458127 458573 470693 514715 515198 529742 530731 539228 539516 543177 560263 566522 581981 582934 594347 597972 604536 608398 625370 650099 652903 664618 668479 675160 675173 677046 678977 683560 684208 684267 694214 713098 715415 719827 723123 728173 733007 734500 735404 736917 740603 744260 744331 748427 748747 752154 755784 755935 763239 764519 766698 767928 767950 770343 771159 772319 773490 774079 774160 774595 776879 780491 780498 784439 786071 788000 789679 790388 794600 795074 798907 798980 800119 800506 800943 802417 803263 807638 810399 810622 810989 811488 813721 814977 816026 817044 818123 818430 819490 819508 819911 821645 822003 823813 824490 826070 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет оральный секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.