Query Metrics
7
Database Queries
7
Different statements
201.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.19 ms (87.30%) |
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 3869 78412 390934 391643 398348 402128 402893 408657 418793 427620 431495 433057 451275 461670 471590 479814 480721 480968 481409 495296 500905 503336 505191 507500 520512 536022 538634 541782 542927 543939 546291 547741 556237 557491 566226 568821 569582 575426 576597 581408 583277 593182 593456 595390 599407 626664 631385 632971 639151 648600 648758 676388 681796 700251 705382 708725 714606 717499 717801 718117 719352 721260 722035 723957 726593 729118 730987 735382 735678 736185 736580 739081 739612 741261 742763 743753 745484 746480 746711 752012 753524 754885 755046 755526 757286 757667 759696 762240 763533 764107 764745 767835 771384 775297 778622 778661 778708 780199 781012 783154 784312 785360 789568 790690 791557 791920 792449 793150 793495 795105 798716 800509 802046 802787 802958 803961 808468 811819 811834 813903 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (8.03%) |
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 811834 739081 754885 764745 767835 723957 753524 755526 757286 736185 741261 743753 764107 631385 719352 721260 778708 789568 792449 795105 3869 390934 566226 507500 599407 726593 742763 408657 495296 520512 480968 481409 547741 648758 722035 568821 775297 808468 735678 757667 735382 771384 783154 398348 480721 391643 461670 714606 576597 791557 730987 759696 705382 431495 471590 78412 739612 802958 813903 538634 536022 581408 583277 541782 543939 542927 546291 681796 700251 717499 648600 708725 718117 556237 593182 595390 639151 593456 626664 800509 778661 780199 781012 790690 791920 798716 811819 729118 736580 745484 746711 763533 784312 793150 802046 802787 803961 762240 746480 755046 752012 632971 717801 778622 785360 793495 433057 402893 557491 479814 503336 427620 402128 418793 451275 505191 500905 569582 575426 676388 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.15%) |
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 3869 78412 390934 391643 398348 402128 402893 408657 418793 427620 431495 433057 451275 461670 471590 479814 480721 480968 481409 495296 500905 503336 505191 507500 520512 536022 538634 541782 542927 543939 546291 547741 556237 557491 566226 568821 569582 575426 576597 581408 583277 593182 593456 595390 599407 626664 631385 632971 639151 648600 648758 676388 681796 700251 705382 708725 714606 717499 717801 718117 719352 721260 722035 723957 726593 729118 730987 735382 735678 736185 736580 739081 739612 741261 742763 743753 745484 746480 746711 752012 753524 754885 755046 755526 757286 757667 759696 762240 763533 764107 764745 767835 771384 775297 778622 778661 778708 780199 781012 783154 784312 785360 789568 790690 791557 791920 792449 793150 793495 795105 798716 800509 802046 802787 802958 803961 808468 811819 811834 813903 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful wife"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая жен"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.64%) |
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.