Query Metrics
7
Database Queries
7
Different statements
197.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.25 ms (89.80%) |
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 387070 388280 392987 395207 417560 427267 448089 450536 450611 450955 451154 452697 459752 461022 466553 468853 474805 474807 494575 521218 528741 539548 550538 577614 579460 590459 603546 628668 631299 633005 637497 646437 657781 705428 708749 720589 727459 730849 731013 733217 734342 737759 740070 740611 743955 744095 750729 760635 764184 768275 772360 775604 775612 778285 779360 780328 786882 790817 792198 793830 793839 793841 794196 795013 795045 795078 796307 800148 800185 801116 801164 802039 802278 802716 803599 808290 812115 812429 820122 820149 820304 820317 820687 824209 824590 824601 824905 825126 825128 825189 825251 825898 825942 826276 826347 826350 826383 826410 826435 826642 826662 826695 826726 826769 826770 826772 826876 826877 826894 826976 827083 827085 827155 827269 827403 828707 828836 ] |
||||||||||||||||||||||||||||||
|
10.67 ms (5.40%) |
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 826435 826431 801116 450536 474807 521218 657781 708749 790817 801164 779360 794196 740070 743955 727459 793841 808290 450611 427267 820304 826383 826642 827269 468853 590459 628668 778285 780328 793830 812115 786882 793839 764184 760635 631299 494575 825898 730849 825189 826726 826877 826976 825511 826347 646437 637497 633005 820122 452697 577614 579460 705428 720589 803599 796307 417560 388280 826662 826769 827083 827403 820687 775612 795045 795078 800148 740611 768275 450955 459752 451154 474805 528741 550538 802716 734342 737759 772360 802278 731013 750729 733217 744095 603546 812429 461022 448089 466553 392987 820317 826770 826876 820149 824601 826350 828707 828594 539548 802039 792198 775604 795013 800185 395207 387070 826276 826695 825128 826410 826772 826894 827155 824590 824905 824209 825126 825251 825942 828836 827085 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.42%) |
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 387070 388280 392987 395207 417560 427267 448089 450536 450611 450955 451154 452697 459752 461022 466553 468853 474805 474807 494575 521218 528741 539548 550538 577614 579460 590459 603546 628668 631299 633005 637497 646437 657781 705428 708749 720589 727459 730849 731013 733217 734342 737759 740070 740611 743955 744095 750729 760635 764184 768275 772360 775604 775612 778285 779360 780328 786882 790817 792198 793830 793839 793841 794196 795013 795045 795078 796307 800148 800185 801116 801164 802039 802278 802716 803599 808290 812115 812429 820122 820149 820304 820317 820687 824209 824590 824601 824905 825126 825128 825189 825251 825898 825942 826276 826347 826350 826383 826410 826435 826642 826662 826695 826726 826769 826770 826772 826876 826877 826894 826976 827083 827085 827155 827269 827403 828707 828836 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy on pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.71%) |
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.