Query Metrics
7
Database Queries
7
Different statements
215.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.51 ms (87.17%) |
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 108925 154374 256821 304572 383285 390212 420383 443244 444645 454019 454633 455603 458766 458780 463840 465070 465618 475508 478542 481943 489338 490953 492762 493535 497691 503861 507824 508759 511053 511489 515364 517425 520489 520495 521775 522187 524094 526943 527285 527677 529632 531360 531403 532830 532943 533982 534114 536914 542137 542142 543842 543893 544439 545395 546854 550536 554286 555089 562052 564293 574763 586901 588929 593867 602444 604080 618259 622025 626439 630869 633755 638885 639328 639782 650145 652915 654257 656905 674043 678713 681388 686183 687347 690684 693628 698385 709838 710233 713196 717859 718678 718835 718987 719573 721521 722520 726946 731448 745918 745927 751035 753244 757905 765721 769885 781300 782653 784398 785584 786232 788800 796326 796509 796872 800097 800538 803268 807170 813206 823484 ] |
||||||||||||||||||||||||||||||
|
17.59 ms (8.18%) |
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 458780 492762 489338 678713 718678 604080 654257 681388 686183 618259 796326 807170 786232 745927 698385 709838 718835 508759 532943 533982 630869 493535 465070 511489 478542 455603 475508 520489 444645 554286 443244 463840 481943 522187 652915 593867 390212 490953 154374 420383 454019 532830 526943 534114 542137 543893 564293 542142 545395 717859 674043 693628 626439 633755 586901 796509 800538 765721 781300 784398 751035 726946 745918 719573 458766 527285 454633 108925 465618 536914 520495 497691 531360 574763 562052 550536 602444 638885 383285 515364 524094 503861 521775 531403 544439 546854 555089 690684 639782 782653 757905 788800 517425 507824 256821 823484 527677 529632 650145 687347 713196 718987 722520 710233 656905 721521 639328 588929 622025 800097 803268 731448 769885 785584 813206 753244 796872 304572 511053 543842 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.42%) |
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 108925 154374 256821 304572 383285 390212 420383 443244 444645 454019 454633 455603 458766 458780 463840 465070 465618 475508 478542 481943 489338 490953 492762 493535 497691 503861 507824 508759 511053 511489 515364 517425 520489 520495 521775 522187 524094 526943 527285 527677 529632 531360 531403 532830 532943 533982 534114 536914 542137 542142 543842 543893 544439 545395 546854 550536 554286 555089 562052 564293 574763 586901 588929 593867 602444 604080 618259 622025 626439 630869 633755 638885 639328 639782 650145 652915 654257 656905 674043 678713 681388 686183 687347 690684 693628 698385 709838 710233 713196 717859 718678 718835 718987 719573 721521 722520 726946 731448 745918 745927 751035 753244 757905 765721 769885 781300 782653 784398 785584 786232 788800 796326 796509 796872 800097 800538 803268 807170 813206 823484 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член дилд"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick and dildo"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.71%) |
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.