Query Metrics
7
Database Queries
7
Different statements
180.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.88 ms (87.06%) |
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 399908 420303 435625 438641 449111 454086 458277 468252 470075 488908 489131 505601 508899 515443 517493 540590 541043 541149 542101 550968 552713 554693 555403 555451 556023 577034 583727 586891 595625 647111 655452 663195 665076 668651 669858 671558 671559 680597 688829 689849 689871 689902 693695 695552 698156 699304 702639 703011 705769 706057 707867 708748 709983 713153 716081 718036 720648 725428 726057 728536 730526 740636 741200 741503 745715 746199 747427 747433 748262 750626 750641 750662 750764 751281 751310 752849 754986 756538 766317 768229 773183 775646 777715 777869 777876 782855 783363 784001 784048 784647 785250 785505 786366 788659 791024 791450 795027 795362 796388 797918 798769 799854 800116 801780 801999 803396 809150 810082 810180 810917 814202 818690 818722 820011 824554 825991 826832 827394 827439 ] |
||||||||||||||||||||||||||||||
|
14.57 ms (8.09%) |
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 783363 797918 799854 810917 748262 750641 740636 750764 741200 751281 756538 768229 773183 747427 766317 703011 720648 777876 784647 785505 791024 795362 796388 801780 814202 505601 508899 706057 688829 791450 785250 745715 438641 489131 517493 435625 663195 708748 595625 782855 750662 752849 709983 707867 449111 454086 470075 698156 671558 689849 716081 809150 810180 750626 784048 747433 754986 784001 468252 399908 515443 420303 825991 824734 555403 555451 542101 699304 705769 668651 788659 801999 810082 777869 741503 746199 795027 725428 730526 726057 728536 713153 798769 695552 751310 541149 818722 820011 824554 826832 827439 827394 818690 458277 488908 540590 556023 541043 550968 552713 554693 655452 665076 671559 680597 702639 647111 669858 693695 718036 689871 689902 577034 583727 586891 777715 786366 775646 800116 803396 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.17%) |
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 399908 420303 435625 438641 449111 454086 458277 468252 470075 488908 489131 505601 508899 515443 517493 540590 541043 541149 542101 550968 552713 554693 555403 555451 556023 577034 583727 586891 595625 647111 655452 663195 665076 668651 669858 671558 671559 680597 688829 689849 689871 689902 693695 695552 698156 699304 702639 703011 705769 706057 707867 708748 709983 713153 716081 718036 720648 725428 726057 728536 730526 740636 741200 741503 745715 746199 747427 747433 748262 750626 750641 750662 750764 751281 751310 752849 754986 756538 766317 768229 773183 775646 777715 777869 777876 782855 783363 784001 784048 784647 785250 785505 786366 788659 791024 791450 795027 795362 796388 797918 798769 799854 800116 801780 801999 803396 809150 810082 810180 810917 814202 818690 818722 820011 824554 825991 826832 827394 827439 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк мастурбац orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbation orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк мастурбац orgasm"
]
|
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.