Query Metrics
7
Database Queries
7
Different statements
204.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.81 ms (87.35%) |
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 414967 436066 457216 466686 469988 489254 494732 508884 512860 513119 514752 516604 517746 522139 529708 533238 533818 534800 541899 543209 544229 544414 546827 549505 549565 550068 551828 553006 555889 557917 558794 565598 567192 570732 574824 585301 590624 590638 595048 595712 595747 596621 596665 596819 599981 606756 610938 612302 621099 622061 625314 630077 630984 635144 643095 644175 647140 653678 656629 662206 666556 667809 673217 675303 675841 676644 678811 679228 682822 684359 689133 689136 692653 695828 712527 712552 716607 716834 728134 731110 732915 734180 734234 737932 740481 743067 746335 747646 749282 749618 750115 756165 756955 760782 760895 763350 767952 768797 770370 771724 775892 779489 779632 780030 787802 790475 791106 791706 793364 793593 793629 796581 797435 799523 800747 805635 809146 809657 810388 811745 ] |
||||||||||||||||||||||||||||||
|
16.86 ms (8.23%) |
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 643095 793629 517746 534800 712552 775892 457216 533818 466686 692653 675841 662206 676644 644175 625314 630077 779632 749282 767952 793593 514752 543209 653678 551828 558794 596621 731110 805635 436066 469988 494732 516604 546827 550068 565598 541899 544414 557917 678811 679228 673217 595712 596665 599981 595747 791706 732915 743067 797435 809146 811745 734234 734180 749618 760895 737932 747646 612302 791106 522139 508884 513119 544229 553006 574824 549565 682822 666556 689136 695828 712527 555889 570732 610938 622061 596819 630984 780030 799523 800747 810388 728134 768797 760782 763350 635144 716607 787802 796581 414967 489254 512860 533238 529708 549505 567192 684359 656629 667809 675303 647140 689133 716834 585301 590624 590638 621099 595048 606756 779489 790475 793364 770370 809657 746335 756955 740481 750115 756165 771724 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.34%) |
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 414967 436066 457216 466686 469988 489254 494732 508884 512860 513119 514752 516604 517746 522139 529708 533238 533818 534800 541899 543209 544229 544414 546827 549505 549565 550068 551828 553006 555889 557917 558794 565598 567192 570732 574824 585301 590624 590638 595048 595712 595747 596621 596665 596819 599981 606756 610938 612302 621099 622061 625314 630077 630984 635144 643095 644175 647140 653678 656629 662206 666556 667809 673217 675303 675841 676644 678811 679228 682822 684359 689133 689136 692653 695828 712527 712552 716607 716834 728134 731110 732915 734180 734234 737932 740481 743067 746335 747646 749282 749618 750115 756165 756955 760782 760895 763350 767952 768797 770370 771724 775892 779489 779632 780030 787802 790475 791106 791706 793364 793593 793629 796581 797435 799523 800747 805635 809146 809657 810388 811745 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"горлом ебет"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горл секс"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.63%) |
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.