Query Metrics
7
Database Queries
7
Different statements
147.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.37 ms (82.90%) |
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 21642 185567 386209 391066 403132 407401 424853 426706 428718 434113 434961 437322 444797 452037 454759 457944 465310 475942 480613 488561 489688 495864 496096 500067 509383 514315 515369 525168 527481 529029 531946 533712 535397 537127 537322 539208 539312 542718 542901 543203 547009 548143 549076 549450 555855 557690 559589 562020 568086 571520 577626 580047 591569 594797 601019 607278 620996 622011 631620 647728 648894 657309 657653 658323 659569 659675 684678 686064 715879 716158 719726 726362 735844 737535 738693 743283 744728 747858 753870 756539 771678 773019 774334 775013 775883 778002 780761 784143 784482 785070 786324 787383 789509 790647 792769 795291 797258 798211 799620 801466 805007 811718 811857 812563 812990 814441 814444 817816 818047 818632 818794 819064 819535 821791 824646 824916 825335 825701 826032 827408 ] |
||||||||||||||||||||||||||||||
|
14.69 ms (9.96%) |
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 500067 496096 452037 514315 386209 539208 515369 555855 631620 775013 795291 798211 784143 426706 437322 509383 537322 547009 591569 185567 21642 391066 407401 818632 821791 825335 814441 827408 818047 825701 814444 818794 826032 531946 533712 525168 527481 535397 539312 537127 549450 562020 648894 684678 601019 607278 786324 789509 778002 797258 811718 812563 771678 774334 716158 792769 811857 428718 817816 819064 824646 819535 824916 454759 480613 529029 495864 489688 577626 542718 543203 548143 557690 549076 719726 647728 659569 659675 715879 657309 657653 658323 686064 559589 568086 580047 594797 620996 775883 784482 790647 799620 747858 753870 735844 737535 744728 756539 773019 726362 743283 738693 622011 780761 785070 787383 801466 805007 812990 444797 457944 542901 571520 403132 434113 465310 475942 424853 434961 488561 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.05%) |
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 21642 185567 386209 391066 403132 407401 424853 426706 428718 434113 434961 437322 444797 452037 454759 457944 465310 475942 480613 488561 489688 495864 496096 500067 509383 514315 515369 525168 527481 529029 531946 533712 535397 537127 537322 539208 539312 542718 542901 543203 547009 548143 549076 549450 555855 557690 559589 562020 568086 571520 577626 580047 591569 594797 601019 607278 620996 622011 631620 647728 648894 657309 657653 658323 659569 659675 684678 686064 715879 716158 719726 726362 735844 737535 738693 743283 744728 747858 753870 756539 771678 773019 774334 775013 775883 778002 780761 784143 784482 785070 786324 787383 789509 790647 792769 795291 797258 798211 799620 801466 805007 811718 811857 812563 812990 814441 814444 817816 818047 818632 818794 819064 819535 821791 824646 824916 825335 825701 826032 827408 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"leggings tits"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лосин сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лосин сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.