Query Metrics
7
Database Queries
7
Different statements
182.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.22 ms (88.67%) |
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 114730 330414 383656 385895 386839 387009 390220 400492 402659 404185 417696 421444 438650 445010 462334 466704 470906 493094 494630 504175 507451 507631 507769 515626 515734 528054 542671 548425 551394 557781 557910 558694 564662 568652 569017 569847 570454 591544 603282 605087 605581 605719 607180 607263 610199 622416 624390 624751 626354 627168 628747 633483 639801 650447 651066 676769 682924 683330 684531 687616 689989 690625 693701 695432 702992 705136 706442 710581 715152 715754 716534 719156 724605 727890 729370 736822 738919 740848 744242 745445 745552 748285 749929 750454 750996 755838 756081 757829 758561 759074 762568 763729 769382 770815 773026 776651 784673 784677 784678 786635 787078 788430 794421 794899 795205 795612 796283 797046 797182 801094 803176 804303 806444 810021 811435 813467 816062 817371 818582 ] |
||||||||||||||||||||||||||||||
|
11.14 ms (6.09%) |
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 558694 569017 542671 548425 650447 687616 706442 695432 651066 568652 605719 624751 784677 787078 794421 773026 784678 794899 727890 744242 757829 605087 803176 385895 507631 817371 816062 569904 569847 570454 683330 676769 684531 689989 705136 715754 693701 716534 639801 628747 797182 811435 813467 740848 749929 806444 724605 736822 745552 750454 758561 729370 763729 756081 784673 795205 797046 466704 400492 421444 462334 494630 515734 624390 383656 386839 390220 818582 507451 528054 493094 557910 557781 564662 682924 690625 702992 719156 551394 603282 607180 633483 591544 622416 626354 605581 607263 610199 627168 776651 786635 795612 796283 801094 810021 788430 804303 762568 770815 738919 748285 745445 755838 759074 750996 769382 710581 715152 445010 470906 404185 438650 417696 504175 507769 515626 114730 330414 387009 402659 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.69%) |
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 114730 330414 383656 385895 386839 387009 390220 400492 402659 404185 417696 421444 438650 445010 462334 466704 470906 493094 494630 504175 507451 507631 507769 515626 515734 528054 542671 548425 551394 557781 557910 558694 564662 568652 569017 569847 570454 591544 603282 605087 605581 605719 607180 607263 610199 622416 624390 624751 626354 627168 628747 633483 639801 650447 651066 676769 682924 683330 684531 687616 689989 690625 693701 695432 702992 705136 706442 710581 715152 715754 716534 719156 724605 727890 729370 736822 738919 740848 744242 745445 745552 748285 749929 750454 750996 755838 756081 757829 758561 759074 762568 763729 769382 770815 773026 776651 784673 784677 784678 786635 787078 788430 794421 794899 795205 795612 796283 797046 797182 801094 803176 804303 806444 810021 811435 813467 816062 817371 818582 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot sexy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot and sexy"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot sexy"
]
|
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.