Query Metrics
7
Database Queries
7
Different statements
230.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.17 ms (88.59%) |
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 53755 322090 384325 384509 385278 385693 395184 396265 398047 398604 404354 417272 417366 417807 418689 420630 421475 423714 429291 441037 444624 448699 451610 451676 451718 455255 458503 461085 462228 469650 471570 473035 475607 487205 494305 499285 500743 517154 517777 520643 525252 529715 537245 538069 540039 611922 619829 629194 632563 632727 696976 700912 712025 715860 723206 726453 728431 729065 730781 730946 731693 732452 735001 738538 743236 744046 744938 745003 745715 745809 746142 746477 747324 748272 750747 751206 751688 752836 756104 756687 756766 757183 758523 758826 758976 759736 759910 761062 761838 762702 763460 764030 766568 766886 767365 767795 768089 768829 770456 772654 774221 774416 785582 786713 788928 794811 801722 803277 804903 805671 807536 807755 810549 816999 819082 820340 820884 820913 821152 821616 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (6.74%) |
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 785582 794811 729065 735001 743236 744046 751206 756104 758826 758976 759910 766568 766886 788928 803277 807536 807755 730946 731693 738538 745809 750747 758523 761062 761838 762702 768829 772654 726453 730781 744938 745715 746142 751688 763460 767795 770456 728431 732452 746477 752836 756687 756766 759736 764030 767365 745003 747324 748272 757183 768089 774221 611922 619829 629194 632727 696976 700912 712025 715860 723206 786713 801722 804903 805671 810549 471570 53755 421475 461085 473035 322090 395184 398604 420630 444624 451718 469650 462228 517777 632563 385693 384325 385278 384509 396265 398047 404354 418689 423714 417366 441037 417272 417807 429291 774416 816999 819082 820913 821616 820340 820884 821152 451610 475607 448699 451676 455255 458503 487205 494305 517154 520643 529715 537245 538069 540039 499285 500743 525252 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.21%) |
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 53755 322090 384325 384509 385278 385693 395184 396265 398047 398604 404354 417272 417366 417807 418689 420630 421475 423714 429291 441037 444624 448699 451610 451676 451718 455255 458503 461085 462228 469650 471570 473035 475607 487205 494305 499285 500743 517154 517777 520643 525252 529715 537245 538069 540039 611922 619829 629194 632563 632727 696976 700912 712025 715860 723206 726453 728431 729065 730781 730946 731693 732452 735001 738538 743236 744046 744938 745003 745715 745809 746142 746477 747324 748272 750747 751206 751688 752836 756104 756687 756766 757183 758523 758826 758976 759736 759910 761062 761838 762702 763460 764030 766568 766886 767365 767795 768089 768829 770456 772654 774221 774416 785582 786713 788928 794811 801722 803277 804903 805671 807536 807755 810549 816999 819082 820340 820884 820913 821152 821616 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite xxx"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite xxx"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite xxx"
]
|
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.