Query Metrics
7
Database Queries
7
Different statements
151.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.03 ms (84.66%) |
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 73560 148101 148582 152056 181438 188025 188293 222222 342317 373494 383701 386080 387324 388714 607668 609241 625778 630379 634646 634696 635554 698238 700175 714865 719175 729799 730090 730520 730675 732096 732725 732939 733474 733495 733524 733529 735231 735761 736418 738497 738573 739008 739752 740048 741023 741316 741320 742609 742627 745840 747111 748061 751489 751508 753160 753937 754934 755549 757249 758547 759772 760526 762291 762591 762700 765164 765839 766077 767192 767557 768613 771484 772141 775520 776875 777819 777829 782890 784636 786574 787757 788254 788398 788426 790334 790821 794982 795230 796477 796607 799968 800831 800909 801004 801061 801208 801318 801516 801706 802672 802798 803325 803640 805426 806787 809209 809323 810012 810628 810717 811636 812558 812900 812941 813183 813294 813411 ] |
||||||||||||||||||||||||||||||
|
13.32 ms (8.81%) |
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 609241 634646 775520 777819 782890 788254 788398 788426 790334 794982 795230 796477 800909 801004 801061 801208 802798 800831 801706 802672 805426 806787 812558 812941 730090 735761 736418 740048 742609 745840 753160 758547 762591 771484 784636 787757 801318 803325 803640 809209 811636 812900 813183 813411 730675 733495 733524 733529 741316 748061 754934 759772 762700 763853 765164 765839 730520 732939 733474 738497 738573 747111 757249 760526 772129 729799 732096 732725 739752 751489 755549 767557 768613 772141 735231 739008 741023 741320 742627 751508 753937 762291 766077 767192 607668 620715 625778 630379 634696 635554 698238 700175 714865 719175 776875 777829 786574 790821 796607 799968 801516 809323 810012 810628 810717 813294 181438 188025 342317 373494 383701 387324 388714 148101 148582 188293 73560 152056 222222 386080 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.73%) |
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 73560 148101 148582 152056 181438 188025 188293 222222 342317 373494 383701 386080 387324 388714 607668 609241 625778 630379 634646 634696 635554 698238 700175 714865 719175 729799 730090 730520 730675 732096 732725 732939 733474 733495 733524 733529 735231 735761 736418 738497 738573 739008 739752 740048 741023 741316 741320 742609 742627 745840 747111 748061 751489 751508 753160 753937 754934 755549 757249 758547 759772 760526 762291 762591 762700 765164 765839 766077 767192 767557 768613 771484 772141 775520 776875 777819 777829 782890 784636 786574 787757 788254 788398 788426 790334 790821 794982 795230 796477 796607 799968 800831 800909 801004 801061 801208 801318 801516 801706 802672 802798 803325 803640 805426 806787 809209 809323 810012 810628 810717 811636 812558 812900 812941 813183 813294 813411 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs riding"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs riding"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs riding"
]
|
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.