Query Metrics
7
Database Queries
7
Different statements
174.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.20 ms (86.28%) |
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 417366 463137 473825 481644 488924 517811 526437 529848 538264 538474 539432 542537 545149 547225 559342 563276 564403 566937 577175 582026 583567 583662 586954 589650 591897 599619 601791 610138 610993 615995 621548 625210 628631 629276 629544 631144 640148 642280 650596 650649 650681 650687 660032 660687 661580 662874 666114 666120 668553 669250 669283 673668 709715 712082 712252 716977 716979 718369 720165 720168 724583 730970 734708 734800 734814 734978 735781 736198 736204 736224 737261 737272 738125 738145 738463 739071 739717 740698 740721 740755 740757 740758 742101 749516 750514 751667 753226 753733 757516 760338 761365 766263 782015 788429 788550 793142 794752 794807 794964 795469 795837 795896 796787 797087 800445 802402 808097 810012 810928 811151 811285 811418 811911 811927 812050 816670 820096 825333 826883 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (7.50%) |
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 761365 734814 760338 810012 577175 650681 547225 599619 631144 621548 735781 601791 753226 539432 545149 582026 718369 811151 811285 771975 788550 794752 795837 795896 739071 742101 738463 734800 740757 794807 757516 517811 629544 796787 802402 811418 811927 739717 808097 724583 753733 812050 668553 660032 712252 589650 610993 628631 529848 816670 825333 826883 559342 542537 650649 666114 720168 661580 673668 793142 810928 730970 736198 734978 751667 734708 797087 720165 820096 538474 800445 736224 738145 737272 481644 583662 794964 538264 526437 662874 716979 660687 669250 709715 564403 640148 591897 610138 642280 615995 625210 740755 629276 650596 488924 666120 788429 811911 737261 740721 766263 750514 736204 740698 795469 417366 463137 749516 740758 716977 782015 563276 650687 669283 566937 738125 473825 583567 712082 586954 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.94%) |
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 417366 463137 473825 481644 488924 517811 526437 529848 538264 538474 539432 542537 545149 547225 559342 563276 564403 566937 577175 582026 583567 583662 586954 589650 591897 599619 601791 610138 610993 615995 621548 625210 628631 629276 629544 631144 640148 642280 650596 650649 650681 650687 660032 660687 661580 662874 666114 666120 668553 669250 669283 673668 709715 712082 712252 716977 716979 718369 720165 720168 724583 730970 734708 734800 734814 734978 735781 736198 736204 736224 737261 737272 738125 738145 738463 739071 739717 740698 740721 740755 740757 740758 742101 749516 750514 751667 753226 753733 757516 760338 761365 766263 782015 788429 788550 793142 794752 794807 794964 795469 795837 795896 796787 797087 800445 802402 808097 810012 810928 811151 811285 811418 811911 811927 812050 816670 820096 825333 826883 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"desi домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"desi homemade"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"desi домашн любительск"
]
|
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.