Query Metrics
7
Database Queries
7
Different statements
184.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.72 ms (85.49%) |
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 30515 91512 191312 384883 392785 396768 397255 401103 401861 402892 403236 403660 404054 412274 422464 425738 428828 459822 466078 490324 494250 505771 512648 515734 535331 539219 543115 545125 547350 549913 549927 574208 576176 589508 596853 612854 638574 660302 672506 675033 675783 677030 677825 689342 693454 693563 695638 698983 703641 710523 713513 717545 723726 727653 731860 735973 738508 740937 741240 743640 744841 755228 757122 757894 758601 769217 777620 778761 780602 781022 782741 785899 786040 786794 788798 795173 795511 795517 797606 797677 797746 803983 805154 805452 807466 807579 810655 811094 814196 814354 815189 816089 816584 816659 817715 817920 818047 818416 818434 818437 819066 819589 819803 819978 820417 820561 820787 820938 821367 822677 823636 823650 823873 825303 825923 825954 827241 827556 827930 827946 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (8.45%) |
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 397255 401103 412274 817715 819803 823873 825303 827556 819066 819589 823636 825923 825954 827946 827930 466078 459822 547350 574208 549927 543115 660302 693454 695638 675033 703641 675783 677030 689342 713513 549913 589508 596853 778761 782741 807466 777620 803983 811094 731860 757122 735973 744841 741240 757894 769217 755228 740937 743640 786794 795517 797606 797677 805452 810655 91512 384883 404054 402892 512648 490324 422464 403236 817920 815189 820417 820938 539219 576176 693563 698983 672506 677825 710523 717545 545125 638574 612854 797746 807579 786040 723726 727653 758601 785899 795173 738508 780602 781022 788798 795511 805154 401861 425738 392785 191312 396768 403660 428828 494250 505771 515734 535331 30515 814354 816089 816584 818434 820561 816659 818416 818437 819978 822677 823650 827241 814196 818047 820787 821367 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.73%) |
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 30515 91512 191312 384883 392785 396768 397255 401103 401861 402892 403236 403660 404054 412274 422464 425738 428828 459822 466078 490324 494250 505771 512648 515734 535331 539219 543115 545125 547350 549913 549927 574208 576176 589508 596853 612854 638574 660302 672506 675033 675783 677030 677825 689342 693454 693563 695638 698983 703641 710523 713513 717545 723726 727653 731860 735973 738508 740937 741240 743640 744841 755228 757122 757894 758601 769217 777620 778761 780602 781022 782741 785899 786040 786794 788798 795173 795511 795517 797606 797677 797746 803983 805154 805452 807466 807579 810655 811094 814196 814354 815189 816089 816584 816659 817715 817920 818047 818416 818434 818437 819066 819589 819803 819978 820417 820561 820787 820938 821367 822677 823636 823650 823873 825303 825923 825954 827241 827556 827930 827946 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot beauty"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot beauty"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot beauty"
]
|
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.