Query Metrics
7
Database Queries
7
Different statements
224.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.83 ms (90.71%) |
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 505745 543694 546251 548284 548444 549009 550923 564753 583642 585761 592908 595041 596542 596558 598181 599074 613715 618184 623123 626894 630045 630570 632907 636938 637929 638511 639632 642252 643801 647077 648371 649818 653071 657216 662522 663169 674527 676441 683426 689405 693700 696293 698917 705145 707726 715027 715444 717379 720027 722278 724534 724715 726350 727550 728554 729907 731186 731331 733504 734495 740275 744163 744406 745656 747416 750136 750347 750962 754863 761767 762299 762781 762974 764505 764581 764918 766355 766870 767681 768653 768911 773569 775407 780162 780949 781030 781329 782166 783362 783853 784056 786556 789121 791207 791262 791832 793071 793157 793556 794410 794580 795086 799856 801657 802292 804593 804810 808289 810144 811184 817105 817633 817635 818964 819149 820186 825677 825716 826004 826113 ] |
||||||||||||||||||||||||||||||
|
11.52 ms (5.13%) |
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 707726 683426 693700 696293 585761 613715 618184 623123 596542 596558 643801 775407 781030 791207 804810 808289 729907 747416 762299 783853 789121 791832 793071 793556 794580 802292 811184 727550 744406 750962 773569 762781 764505 744163 750347 754863 762974 750136 764581 784056 786556 794410 595041 826113 548444 639632 780949 793157 795086 720027 662522 705145 825677 826004 817633 819149 825716 817105 817635 818964 820186 505745 543694 550923 564753 583642 546251 549009 647077 663169 648371 649818 653071 676441 698917 722278 657216 674527 689405 715027 715444 717379 548284 630045 630570 632907 636938 598181 599074 637929 642252 592908 626894 638511 801657 780162 767681 781329 782166 783362 791262 799856 804593 810144 724534 728554 745656 764918 766355 724715 731186 731331 740275 768911 726350 733504 734495 761767 766870 768653 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.25%) |
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 505745 543694 546251 548284 548444 549009 550923 564753 583642 585761 592908 595041 596542 596558 598181 599074 613715 618184 623123 626894 630045 630570 632907 636938 637929 638511 639632 642252 643801 647077 648371 649818 653071 657216 662522 663169 674527 676441 683426 689405 693700 696293 698917 705145 707726 715027 715444 717379 720027 722278 724534 724715 726350 727550 728554 729907 731186 731331 733504 734495 740275 744163 744406 745656 747416 750136 750347 750962 754863 761767 762299 762781 762974 764505 764581 764918 766355 766870 767681 768653 768911 773569 775407 780162 780949 781030 781329 782166 783362 783853 784056 786556 789121 791207 791262 791832 793071 793157 793556 794410 794580 795086 799856 801657 802292 804593 804810 808289 810144 811184 817105 817633 817635 818964 819149 820186 825677 825716 826004 826113 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love жен"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love wife"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love жен"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.68%) |
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.