Query Metrics
7
Database Queries
7
Different statements
197.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.15 ms (86.05%) |
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 6609 394548 410967 423584 426818 435263 437727 451983 456849 469827 481166 487712 504994 505937 521770 528811 533193 539609 543418 544047 549695 550585 557509 561595 562780 571819 574328 576841 591778 592752 596051 598315 600795 603021 604322 604864 605961 606396 609935 610215 610223 612574 613849 616118 616851 619011 627777 628677 630080 631129 637956 644526 644536 644780 654315 665313 680580 682741 686514 688333 709372 710066 710807 716033 724553 726398 727523 731014 733309 735019 736260 738962 739551 741083 741625 741796 743933 743957 745347 745682 746207 747421 748753 756400 758306 758314 758594 760602 762205 764137 767017 767864 768163 768944 770181 772314 773187 778444 779738 779817 780565 781136 783966 784970 785364 786549 787435 788562 793162 793624 794421 794659 795354 798765 804594 806632 811237 811390 813264 827919 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (7.87%) |
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 604864 612574 628677 637956 610215 600795 603021 781136 733309 758306 768163 772314 773187 794659 798765 813264 746207 726398 727523 762205 764137 741796 745347 738962 739551 768944 609935 616118 627777 644536 644780 709372 710066 778444 793162 795354 806632 504994 557509 456849 665313 767864 505937 6609 410967 539609 533193 544047 561595 562780 574328 596051 610223 591778 606396 619011 794421 756400 758314 785364 811390 741625 747421 745682 758594 767017 631129 710807 779817 783966 786549 528811 571819 644526 804594 394548 688333 793624 735019 521770 543418 788562 481166 487712 423584 827919 469827 576841 550585 549695 680580 682741 686514 716033 592752 598315 616851 605961 784970 811237 779738 760602 787435 731014 736260 770181 743933 748753 724553 743957 630080 780565 435263 437727 604322 426818 741083 451983 654315 613849 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (2.11%) |
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 6609 394548 410967 423584 426818 435263 437727 451983 456849 469827 481166 487712 504994 505937 521770 528811 533193 539609 543418 544047 549695 550585 557509 561595 562780 571819 574328 576841 591778 592752 596051 598315 600795 603021 604322 604864 605961 606396 609935 610215 610223 612574 613849 616118 616851 619011 627777 628677 630080 631129 637956 644526 644536 644780 654315 665313 680580 682741 686514 688333 709372 710066 710807 716033 724553 726398 727523 731014 733309 735019 736260 738962 739551 741083 741625 741796 743933 743957 745347 745682 746207 747421 748753 756400 758306 758314 758594 760602 762205 764137 767017 767864 768163 768944 770181 772314 773187 778444 779738 779817 780565 781136 783966 784970 785364 786549 787435 788562 793162 793624 794421 794659 795354 798765 804594 806632 811237 811390 813264 827919 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife on massage"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен массаж"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.