Query Metrics
7
Database Queries
7
Different statements
246.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
220.67 ms (89.63%) |
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 13265 101789 381819 385267 387423 408707 409340 414130 414226 414229 416689 416692 420823 429144 432283 439027 439218 444614 446641 450683 451651 451727 452567 452572 452777 454711 454749 478489 499942 506070 516597 527524 529004 529606 542450 544402 548113 553198 553507 557921 558407 559828 562573 563965 572184 575616 575935 576564 580779 584558 594375 595464 597505 601519 604134 608769 622117 628602 628850 631609 637081 646789 651840 652221 661028 666857 671097 674885 681787 690200 696504 699544 700244 702981 707264 708544 708562 735983 740850 740937 742231 743179 743185 743261 744013 744139 746805 750495 750947 751065 751392 752976 754579 754912 756817 758943 763416 773637 774462 783568 784050 784544 785552 785606 789074 792102 793278 796863 797196 800507 803122 803138 810491 810742 812185 812421 814391 826353 ] |
||||||||||||||||||||||||||||||
|
14.32 ms (5.81%) |
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 792102 797196 810742 803138 743179 743185 756817 789074 735983 744139 751065 763416 740937 743261 750495 812185 13265 785606 803122 454749 451651 387423 785552 408707 548113 544402 696504 699544 702981 690200 553198 637081 783568 784050 752976 754579 754912 773637 751392 740850 744013 784544 812421 444614 414229 101789 821958 758943 742231 628602 506070 575935 646789 414130 451727 559828 584558 601519 478489 631609 826353 529606 558407 652221 700244 666857 671097 800507 810491 750947 414226 450683 432283 416689 416692 439027 452572 452777 446641 452567 439218 499942 814391 542450 563965 661028 553507 622117 594375 608769 793278 746805 796863 409340 385267 557921 381819 420823 429144 774462 823492 454711 516597 527524 529004 562573 572184 576564 580779 681787 707264 708544 708562 651840 674885 575616 604134 628850 595464 597505 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (1.54%) |
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 13265 101789 381819 385267 387423 408707 409340 414130 414226 414229 416689 416692 420823 429144 432283 439027 439218 444614 446641 450683 451651 451727 452567 452572 452777 454711 454749 478489 499942 506070 516597 527524 529004 529606 542450 544402 548113 553198 553507 557921 558407 559828 562573 563965 572184 575616 575935 576564 580779 584558 594375 595464 597505 601519 604134 608769 622117 628602 628850 631609 637081 646789 651840 652221 661028 666857 671097 674885 681787 690200 696504 699544 700244 702981 707264 708544 708562 735983 740850 740937 742231 743179 743185 743261 744013 744139 746805 750495 750947 751065 751392 752976 754579 754912 756817 758943 763416 773637 774462 783568 784050 784544 785552 785606 789074 792102 793278 796863 797196 800507 803122 803138 810491 810742 812185 812421 814391 826353 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло teen девушк"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo teen girls"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло teen девушк"
]
|
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.