Query Metrics
7
Database Queries
7
Different statements
229.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.51 ms (88.31%) |
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 30208 70123 333653 383297 385192 386761 391269 403291 410235 413163 426477 447092 449316 452210 452861 453083 454239 454783 457807 460573 466470 466568 472274 472279 476942 483951 485716 486640 492402 499719 528103 531053 533717 536831 539537 548699 548841 550042 555631 562150 566054 580881 584609 585075 587063 587204 595701 597756 598000 598260 598328 598373 610318 617220 623755 626149 636162 649692 650786 655449 661590 662499 666439 675355 679904 681876 682741 687097 687376 698853 699237 699456 709006 709065 709460 711560 716583 719028 721590 723069 724553 725980 738094 738375 740991 742666 745293 754170 757368 759133 762704 768297 768675 770946 772165 775254 779425 781207 783498 785787 789096 790512 791298 793337 794279 795015 798014 799299 799775 801145 804993 809651 811215 812707 814218 816485 816703 819995 820671 821523 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (7.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 598000 454239 333653 70123 30208 413163 410235 820671 819995 454783 476942 485716 536831 539537 499719 531053 460573 472279 566054 584609 650786 662499 675355 681876 687376 699456 709065 716583 699237 655449 666439 682741 721590 548699 555631 562150 623755 610318 626149 597756 598328 636162 791298 799299 812707 781207 785787 811215 725980 738094 783498 794279 795015 768297 738375 742666 754170 762704 724553 740991 789096 790512 804993 391269 449316 383297 386761 452861 426477 385192 403291 585075 816703 814218 816485 821523 486640 452210 466568 447092 453083 457807 466470 472274 492402 528103 533717 483951 548841 580881 661590 687097 698853 709006 719028 723069 649692 711560 679904 709460 550042 595701 598373 617220 587063 598260 587204 775254 779425 793337 799775 801145 759133 770946 798014 809651 745293 772165 768675 757368 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.16%) |
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 30208 70123 333653 383297 385192 386761 391269 403291 410235 413163 426477 447092 449316 452210 452861 453083 454239 454783 457807 460573 466470 466568 472274 472279 476942 483951 485716 486640 492402 499719 528103 531053 533717 536831 539537 548699 548841 550042 555631 562150 566054 580881 584609 585075 587063 587204 595701 597756 598000 598260 598328 598373 610318 617220 623755 626149 636162 649692 650786 655449 661590 662499 666439 675355 679904 681876 682741 687097 687376 698853 699237 699456 709006 709065 709460 711560 716583 719028 721590 723069 724553 725980 738094 738375 740991 742666 745293 754170 757368 759133 762704 768297 768675 770946 772165 775254 779425 781207 783498 785787 789096 790512 791298 793337 794279 795015 798014 799299 799775 801145 804993 809651 811215 812707 814218 816485 816703 819995 820671 821523 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs perfect"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs perfect"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs perfect"
]
|
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.