Query Metrics
7
Database Queries
7
Different statements
198.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.51 ms (88.26%) |
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 411346 419197 423177 439243 464370 468974 483778 487862 492693 494820 494847 496559 499163 501581 506050 511995 515303 515327 518274 526040 526640 527297 530235 530257 535639 543913 545000 545861 546610 549495 550796 550985 551587 552131 554441 555010 557018 562953 566221 566354 568081 569827 570756 570852 571753 571874 578877 587797 588190 588367 588843 589276 590369 590842 591218 591516 592132 592675 592770 593884 595545 596739 599483 605523 605624 606608 606967 616217 616564 624012 625646 626985 641154 641599 642996 644929 658951 663365 668084 668732 668746 668752 671474 686410 690703 695042 699082 710168 710433 713840 716984 718358 720028 720168 725627 726123 727724 729975 733789 734594 736338 736638 743937 746837 751672 757195 762109 768706 779152 781368 784322 787051 788072 792466 792504 799865 804138 811443 813695 816827 ] |
||||||||||||||||||||||||||||||
|
12.57 ms (6.32%) |
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 530257 518274 526640 535639 549495 551587 545861 546610 557018 570852 713840 716984 668732 710168 658951 592132 595545 625646 589276 588843 642996 746837 757195 792466 733789 751672 762109 725627 726123 734594 616217 720028 779152 566354 578877 804138 550985 501581 527297 496559 464370 550796 494820 799865 515303 668746 743937 515327 494847 686410 545000 596739 483778 511995 710433 599483 644929 690703 555010 590369 624012 588367 736338 671474 605624 616564 590842 606967 411346 816827 813695 530235 668084 695042 718358 641599 593884 811443 781368 768706 784322 788072 729975 699082 787051 792504 571874 626985 526040 668752 663365 605523 492693 423177 562953 554441 592770 552131 419197 506050 591516 727724 736638 571753 439243 499163 566221 568081 570756 569827 587797 588190 592675 606608 591218 543913 720168 641154 468974 487862 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.41%) |
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 411346 419197 423177 439243 464370 468974 483778 487862 492693 494820 494847 496559 499163 501581 506050 511995 515303 515327 518274 526040 526640 527297 530235 530257 535639 543913 545000 545861 546610 549495 550796 550985 551587 552131 554441 555010 557018 562953 566221 566354 568081 569827 570756 570852 571753 571874 578877 587797 588190 588367 588843 589276 590369 590842 591218 591516 592132 592675 592770 593884 595545 596739 599483 605523 605624 606608 606967 616217 616564 624012 625646 626985 641154 641599 642996 644929 658951 663365 668084 668732 668746 668752 671474 686410 690703 695042 699082 710168 710433 713840 716984 718358 720028 720168 725627 726123 727724 729975 733789 734594 736338 736638 743937 746837 751672 757195 762109 768706 779152 781368 784322 787051 788072 792466 792504 799865 804138 811443 813695 816827 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small dick wife"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая член жен"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.80%) |
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.