Query Metrics
7
Database Queries
7
Different statements
365.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.61 ms (59.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск student"
]
|
||||||||||||||||||||||||||||||
|
127.02 ms (34.77%) |
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 394004 400006 420828 421606 441424 441490 441507 441530 451012 451776 461361 465939 470396 472885 485873 488260 500444 502999 511835 514691 520385 525629 525969 533706 546086 547782 549146 554180 557478 561916 563561 565010 567171 580843 581568 584814 585359 592066 592429 598869 598960 599462 602567 608288 611495 611518 615494 620060 621183 649715 650898 651832 656493 659330 663796 666977 671437 671516 674910 677132 683046 683720 696194 699492 706826 708869 714583 716918 718068 718649 719324 721889 723764 724396 726297 726914 729424 731213 732268 737321 740168 742983 745086 745971 748639 757534 758316 758999 760241 760713 761777 763518 764179 766472 766652 768739 769084 772948 778149 778743 779152 779367 779894 781041 782785 782943 783830 785441 786022 788422 789089 795386 806054 807560 810720 812440 814164 827103 827812 ] |
||||||||||||||||||||||||||||||
|
13.20 ms (3.61%) |
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 394004 441424 827103 827812 451776 525629 563561 581568 546086 674910 716918 650898 683046 567171 598960 778743 779894 788422 779367 789089 758316 758999 760241 769084 786022 807560 740168 757534 766472 723764 726297 726914 737321 745971 763518 771059 772948 719324 779152 795386 400006 764179 732268 748639 718068 768739 441490 814164 671516 580843 778149 781041 783830 806054 810720 812440 782785 782943 729424 766652 742983 724396 731213 699492 441530 420828 485873 714583 514691 533706 502999 520385 525969 649715 659330 671437 706826 708869 651832 677132 656493 663796 666977 683720 557478 585359 592066 620060 592429 602567 611518 598869 611495 621183 608288 615494 718649 470396 511835 441507 472885 500444 465939 561916 696194 565010 599462 785441 760713 451012 761777 745086 421606 461361 488260 549146 554180 721889 547782 584814 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (0.91%) |
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 394004 400006 420828 421606 441424 441490 441507 441530 451012 451776 461361 465939 470396 472885 485873 488260 500444 502999 511835 514691 520385 525629 525969 533706 546086 547782 549146 554180 557478 561916 563561 565010 567171 580843 581568 584814 585359 592066 592429 598869 598960 599462 602567 608288 611495 611518 615494 620060 621183 649715 650898 651832 656493 659330 663796 666977 671437 671516 674910 677132 683046 683720 696194 699492 706826 708869 714583 716918 718068 718649 719324 721889 723764 724396 726297 726914 729424 731213 732268 737321 740168 742983 745086 745971 748639 757534 758316 758999 760241 760713 761777 763518 764179 766472 766652 768739 769084 772948 778149 778743 779152 779367 779894 781041 782785 782943 783830 785441 786022 788422 789089 795386 806054 807560 810720 812440 814164 827103 827812 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск student"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade student"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.42%) |
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.