Query Metrics
7
Database Queries
7
Different statements
185.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.65 ms (85.93%) |
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 263727 383667 387198 387453 391221 401879 407127 407592 459920 485929 502930 519728 566349 595746 608429 618019 623804 628642 644187 647249 665605 672795 682065 684683 685900 688674 696153 698250 705880 712630 713970 714930 715058 715163 715511 716082 717920 720124 723961 724168 724517 726376 726500 726881 727548 729650 729657 731007 731423 731444 736861 738000 738324 740225 741786 742631 742719 743003 744081 744165 744321 744944 745486 746071 755684 756864 758283 759009 759807 759947 761050 776473 785107 788947 789005 789496 790017 790335 791335 792541 792545 794863 795303 795356 796134 797020 797228 800582 800705 800744 800750 800816 801545 801835 801925 802144 802250 802758 803312 803339 804503 805819 809740 810100 810126 810322 810360 811769 812464 817869 818898 819339 824165 824178 824846 824994 825362 826195 826378 826480 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (9.56%) |
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 731444 740225 726376 742631 744321 724517 742719 756864 759947 698250 713970 715163 776473 794863 797020 803339 810322 812464 459920 805819 688674 759807 383667 387453 826378 818898 825362 819339 824165 824994 826195 824846 485929 502930 566349 665605 672795 684683 714930 715511 647249 705880 712630 715058 717920 685900 696153 644187 595746 618019 628642 785107 800705 802758 804503 788947 789005 790335 791335 795303 796134 800582 800750 810360 724168 726500 731007 743003 744165 746071 755684 759009 792545 801545 802250 803312 809740 810100 811769 731423 741786 744081 726881 727548 736861 738000 744944 745486 729650 758283 608429 623804 716082 790017 797228 800744 800816 801925 802144 519728 401879 407592 826480 789496 738324 810126 391221 263727 682065 795356 723961 729657 761050 720124 792541 801835 387198 407127 824178 817869 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.26%) |
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 263727 383667 387198 387453 391221 401879 407127 407592 459920 485929 502930 519728 566349 595746 608429 618019 623804 628642 644187 647249 665605 672795 682065 684683 685900 688674 696153 698250 705880 712630 713970 714930 715058 715163 715511 716082 717920 720124 723961 724168 724517 726376 726500 726881 727548 729650 729657 731007 731423 731444 736861 738000 738324 740225 741786 742631 742719 743003 744081 744165 744321 744944 745486 746071 755684 756864 758283 759009 759807 759947 761050 776473 785107 788947 789005 789496 790017 790335 791335 792541 792545 794863 795303 795356 796134 797020 797228 800582 800705 800744 800750 800816 801545 801835 801925 802144 802250 802758 803312 803339 804503 805819 809740 810100 810126 810322 810360 811769 812464 817869 818898 819339 824165 824178 824846 824994 825362 826195 826378 826480 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс stepmom"
]
|
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.