Query Metrics
7
Database Queries
7
Different statements
408.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
386.31 ms (94.60%) |
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 401388 403027 420303 449181 497013 509659 517360 555403 555451 568755 596372 618071 622869 626398 628570 680593 680597 689057 689871 689877 689902 692096 692733 704584 710189 712146 713031 713153 714563 714794 716125 718029 719987 733151 736187 736333 741143 743860 746199 748305 751004 757237 758008 759052 762580 767303 767545 767547 771903 772606 773054 773116 775590 775627 775658 777836 777884 778184 780028 781756 782109 782773 783050 783250 784415 784886 785653 786091 786200 786433 786699 786863 788659 789221 789797 790230 792253 792451 792709 792769 793793 795027 795063 795370 795950 796398 796408 796433 797127 798769 801067 801806 801813 801999 803368 803487 804345 804405 804709 806809 808052 808602 810095 810148 810170 811024 814177 817128 817567 818700 819273 820009 824643 825129 826461 826611 827084 827218 827711 828228 ] |
||||||||||||||||||||||||||||||
|
11.44 ms (2.80%) |
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 743860 767547 771903 773054 712146 713153 714794 775590 780028 795370 798769 403027 792769 618071 778184 497013 704584 692096 710189 827711 714563 772606 680597 689057 680593 689871 810148 692733 751004 713031 449181 757237 804405 808052 689902 622869 596372 733151 401388 420303 814177 826611 818700 824643 827084 817567 819273 820009 817128 825129 828228 826461 827218 509659 517360 555403 555451 568755 716125 718029 689877 719987 626398 628570 775627 775658 784886 785653 788659 792253 792451 793793 795063 801067 801806 801813 801999 803368 803487 806809 810170 777836 777884 782773 786091 789797 796408 804345 804709 808602 810095 811024 736187 736333 741143 746199 748305 758008 759052 762580 767303 767545 773116 781756 782109 783050 783250 784415 786200 786433 786699 786863 789221 790230 792709 795027 795950 796398 796433 797127 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (0.88%) |
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 401388 403027 420303 449181 497013 509659 517360 555403 555451 568755 596372 618071 622869 626398 628570 680593 680597 689057 689871 689877 689902 692096 692733 704584 710189 712146 713031 713153 714563 714794 716125 718029 719987 733151 736187 736333 741143 743860 746199 748305 751004 757237 758008 759052 762580 767303 767545 767547 771903 772606 773054 773116 775590 775627 775658 777836 777884 778184 780028 781756 782109 782773 783050 783250 784415 784886 785653 786091 786200 786433 786699 786863 788659 789221 789797 790230 792253 792451 792709 792769 793793 795027 795063 795370 795950 796398 796408 796433 797127 798769 801067 801806 801813 801999 803368 803487 804345 804405 804709 806809 808052 808602 810095 810148 810170 811024 814177 817128 817567 818700 819273 820009 824643 825129 826461 826611 827084 827218 827711 828228 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife amateur orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен любительск orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.38%) |
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.