Query Metrics
7
Database Queries
7
Different statements
161.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.29 ms (84.41%) |
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 398499 403875 404150 418117 418146 418158 418622 431396 434328 435562 439244 441396 444378 446686 456050 461664 472622 496345 497013 502774 507713 515874 521652 526501 528407 542181 546423 547580 547795 555026 555821 559368 564757 567828 574319 577608 579863 587244 587899 592989 595339 607963 618750 620981 622065 624845 627446 634638 652766 655517 659343 665641 677839 678834 683061 688818 692743 705800 719152 720576 721083 723929 729068 734017 735987 740894 742067 744457 744493 744782 748488 749972 751329 756786 756950 757730 765221 766721 767360 767753 768278 768946 769338 772602 773254 773868 777984 778897 783921 783939 784097 784138 784862 785197 786075 786610 791857 792018 793201 794462 795818 798299 801560 801795 801811 801842 803568 803619 804064 806997 807578 808629 808674 809617 820057 820170 825685 826032 826143 826973 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (9.06%) |
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 729068 768278 620981 497013 826032 587244 778897 786075 748488 735987 749972 768946 659343 567828 655517 618750 446686 546423 803619 783939 784862 742067 756786 766721 607963 808674 435562 692743 472622 555026 624845 652766 688818 820057 820170 719152 723929 677839 720576 772602 803568 595339 404150 456050 507713 564757 785197 773254 783921 791857 807578 765221 756950 403875 526501 592989 801560 418158 792018 547580 665641 784138 744493 418622 418146 441396 559368 461664 496345 515874 502774 705800 801811 809617 767360 786610 801795 804064 808629 418117 434328 431396 444378 678834 622065 777984 826143 826973 825685 794462 744457 767753 769338 773868 744782 521652 555821 721083 574319 795818 806997 784097 798299 740894 757730 793201 801842 542181 734017 751329 528407 577608 683061 634638 579863 547795 587899 627446 439244 398499 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.61%) |
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 398499 403875 404150 418117 418146 418158 418622 431396 434328 435562 439244 441396 444378 446686 456050 461664 472622 496345 497013 502774 507713 515874 521652 526501 528407 542181 546423 547580 547795 555026 555821 559368 564757 567828 574319 577608 579863 587244 587899 592989 595339 607963 618750 620981 622065 624845 627446 634638 652766 655517 659343 665641 677839 678834 683061 688818 692743 705800 719152 720576 721083 723929 729068 734017 735987 740894 742067 744457 744493 744782 748488 749972 751329 756786 756950 757730 765221 766721 767360 767753 768278 768946 769338 772602 773254 773868 777984 778897 783921 783939 784097 784138 784862 785197 786075 786610 791857 792018 793201 794462 795818 798299 801560 801795 801811 801842 803568 803619 804064 806997 807578 808629 808674 809617 820057 820170 825685 826032 826143 826973 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt homemade"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
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.