Query Metrics
7
Database Queries
7
Different statements
191.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.79 ms (87.85%) |
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 147073 450682 454981 490952 491424 496793 500815 510102 516226 516496 531006 538066 539454 541064 541301 542474 544417 546420 547402 548909 550965 553417 554846 555411 555457 555992 556876 574118 578773 584577 588550 599464 600358 600942 604760 630143 631538 633857 634902 640366 645006 647111 662914 668105 678997 681344 681609 684486 686107 689040 696291 697188 699323 699519 705478 707238 708532 708561 709850 710244 710503 714402 714587 719074 721037 723642 725081 725154 728373 730103 730154 736981 738534 739645 742066 745684 747981 748028 748034 752532 756827 757290 767474 768348 773639 773691 775294 776216 777422 777992 784631 784974 786101 786858 790415 792681 793905 794418 797969 801788 801986 802319 802597 803311 803477 803486 804695 806681 807887 809625 810114 811875 813122 814421 816596 823272 824075 824644 825086 827539 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (6.75%) |
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 454981 510102 450682 633857 631538 490952 516496 645006 516226 555992 496793 757290 147073 824075 723642 814421 827539 823272 825086 555457 574118 541301 547402 541064 548909 555411 684486 686107 696291 647111 689040 707238 662914 668105 681344 708561 710244 721037 553417 578773 588550 634902 640366 599464 600942 776216 777422 777992 784631 790415 794418 801788 803311 804695 775294 797969 725081 725154 730103 742066 748028 748034 767474 773639 786101 786858 802319 802597 806681 807887 810114 739645 728373 745684 756827 773691 730154 747981 752532 768348 736981 738534 630143 697188 699323 710503 714402 714587 784974 792681 793905 801986 803477 803486 809625 811875 500815 709850 604760 600358 813122 491424 556876 719074 824644 816596 539454 538066 531006 542474 544417 584577 546420 550965 554846 678997 681609 699519 705478 708532 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.78%) |
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 147073 450682 454981 490952 491424 496793 500815 510102 516226 516496 531006 538066 539454 541064 541301 542474 544417 546420 547402 548909 550965 553417 554846 555411 555457 555992 556876 574118 578773 584577 588550 599464 600358 600942 604760 630143 631538 633857 634902 640366 645006 647111 662914 668105 678997 681344 681609 684486 686107 689040 696291 697188 699323 699519 705478 707238 708532 708561 709850 710244 710503 714402 714587 719074 721037 723642 725081 725154 728373 730103 730154 736981 738534 739645 742066 745684 747981 748028 748034 752532 756827 757290 767474 768348 773639 773691 775294 776216 777422 777992 784631 784974 786101 786858 790415 792681 793905 794418 797969 801788 801986 802319 802597 803311 803477 803486 804695 806681 807887 809625 810114 811875 813122 814421 816596 823272 824075 824644 825086 827539 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole cum"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк cum"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дырк cum"
]
|
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.