Query Metrics
7
Database Queries
7
Different statements
164.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.66 ms (86.01%) |
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 459735 478452 493670 517888 530584 531744 531756 533577 534117 535765 538015 540831 542450 543533 544124 545185 546417 549073 564303 565440 566846 575046 575635 585761 586736 587984 590828 590845 593576 594359 594375 604655 605741 606979 610208 616598 616665 616712 622117 629686 631063 633062 635521 636885 640384 641172 642814 645342 653686 655252 655523 657139 657156 660269 661028 662015 662794 664585 670802 675607 677735 680233 683527 686129 688939 690200 691600 691601 691662 691879 693125 693170 693176 693207 693691 694831 699544 702981 713022 713513 715562 717204 718154 718240 720703 724057 776286 776956 777034 777575 778725 779005 779893 781589 782493 783089 784050 784541 785081 785512 792102 792806 793330 793331 794764 795470 796218 796528 820000 820521 820896 821493 821629 823041 826042 826108 826131 827275 827531 ] |
||||||||||||||||||||||||||||||
|
12.44 ms (7.55%) |
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 823041 540831 820521 821629 827275 827531 820000 820896 821493 826108 826131 826566 826042 459735 478452 493670 517888 534117 535765 530584 531744 531756 533577 538015 543533 546417 565440 542450 544124 545185 549073 564303 566846 575046 662015 675607 677735 683527 688939 693170 693691 699544 702981 713022 715562 718240 720703 655252 655523 657139 660269 661028 662794 670802 686129 690200 691600 691662 693207 694831 645342 653686 657156 664585 680233 691601 691879 693125 693176 713513 717204 718154 575635 585761 586736 604655 605741 606979 610208 622117 635521 640384 594359 594375 616665 629686 633062 590828 590845 616712 636885 641172 587984 593576 616598 631063 642814 779893 782493 783089 792102 793330 793331 794764 795470 796218 776286 776956 777034 777575 778725 779005 781589 784050 784541 785081 785512 792806 796528 724057 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.06%) |
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 459735 478452 493670 517888 530584 531744 531756 533577 534117 535765 538015 540831 542450 543533 544124 545185 546417 549073 564303 565440 566846 575046 575635 585761 586736 587984 590828 590845 593576 594359 594375 604655 605741 606979 610208 616598 616665 616712 622117 629686 631063 633062 635521 636885 640384 641172 642814 645342 653686 655252 655523 657139 657156 660269 661028 662015 662794 664585 670802 675607 677735 680233 683527 686129 688939 690200 691600 691601 691662 691879 693125 693170 693176 693207 693691 694831 699544 702981 713022 713513 715562 717204 718154 718240 720703 724057 776286 776956 777034 777575 778725 779005 779893 781589 782493 783089 784050 784541 785081 785512 792102 792806 793330 793331 794764 795470 796218 796528 820000 820521 820896 821493 821629 823041 826042 826108 826131 827275 827531 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen close up"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen close up"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen close up"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.00%) |
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.