Query Metrics
7
Database Queries
7
Different statements
174.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.03 ms (86.03%) |
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 413309 445535 447092 447643 453083 453963 459065 465291 465874 471377 471912 472274 480619 482001 485254 486640 487252 487431 494159 497391 499134 500500 501961 505429 506977 512011 514633 516206 518039 519820 521402 528103 530800 534812 535247 540021 540451 542616 547740 548841 561313 574060 580000 580341 580881 581229 583398 584750 586144 587063 587204 589530 589785 589987 590023 590091 590120 594468 598260 598350 599488 617220 620248 624890 627349 630282 635456 636558 641134 647941 651376 651944 652617 653215 653697 655496 666730 676073 677028 677350 679904 691330 694612 698780 698853 700309 700338 702518 704241 705428 705442 705791 709083 709460 711560 712073 712874 713589 713880 719028 720732 723069 727759 736656 739537 740718 747655 757368 757888 768233 768675 770946 772350 783267 795092 796009 798014 801873 809651 813418 ] |
||||||||||||||||||||||||||||||
|
15.11 ms (8.66%) |
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 486640 453963 465291 480619 485254 445535 447092 453083 459065 471912 472274 499134 514633 540021 497391 518039 500500 501961 506977 540451 528103 534812 535247 547740 548841 580341 581229 583398 542616 580000 580881 574060 652617 666730 691330 698853 700338 702518 705428 705791 713589 713880 719028 723069 647941 700309 711560 712073 651376 651944 653215 653697 677028 677350 679904 694612 698780 704241 709083 709460 584750 594468 617220 589530 589785 598350 636558 587063 589987 590091 590120 598260 599488 620248 624890 586144 587204 590023 635456 783267 795092 796009 768233 770946 798014 809651 757888 736656 747655 768675 772350 757368 727759 739537 740718 627349 630282 641134 705442 712874 720732 801873 813418 413309 447643 471377 465874 482001 487252 521402 516206 487431 494159 505429 512011 519820 530800 561313 655496 676073 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.38%) |
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 413309 445535 447092 447643 453083 453963 459065 465291 465874 471377 471912 472274 480619 482001 485254 486640 487252 487431 494159 497391 499134 500500 501961 505429 506977 512011 514633 516206 518039 519820 521402 528103 530800 534812 535247 540021 540451 542616 547740 548841 561313 574060 580000 580341 580881 581229 583398 584750 586144 587063 587204 589530 589785 589987 590023 590091 590120 594468 598260 598350 599488 617220 620248 624890 627349 630282 635456 636558 641134 647941 651376 651944 652617 653215 653697 655496 666730 676073 677028 677350 679904 691330 694612 698780 698853 700309 700338 702518 704241 705428 705442 705791 709083 709460 711560 712073 712874 713589 713880 719028 720732 723069 727759 736656 739537 740718 747655 757368 757888 768233 768675 770946 772350 783267 795092 796009 798014 801873 809651 813418 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"perfect cock"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"perfect cock"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"perfect cock"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.86%) |
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.