Query Metrics
7
Database Queries
7
Different statements
143.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.24 ms (84.36%) |
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 7502 95748 96944 117221 316575 341608 351640 373798 383238 386062 394636 397348 398666 399904 400944 403255 406091 406982 412779 414058 428786 445279 447086 448651 452632 471601 480920 488713 488721 500910 505143 525577 528315 531249 534060 545453 545505 549785 550563 551057 566689 569072 583710 585963 587407 589185 590949 607107 620785 633447 634159 640523 644274 644275 649133 650392 652966 654078 670997 672130 673371 674733 681804 683183 683564 683584 686501 688660 690749 693049 695096 695930 696250 697361 697785 697839 697973 697987 698597 699632 699667 699755 700282 703037 703055 703095 705520 705829 713699 715176 717805 719057 720202 721318 722607 722655 723468 738812 739012 741213 742363 750154 752785 759485 761150 767283 769418 770298 770821 775798 775931 784732 791101 791772 801275 806514 813275 817450 827855 827872 ] |
||||||||||||||||||||||||||||||
|
12.72 ms (8.85%) |
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 775798 750154 767283 769418 791101 742363 752785 741213 759485 738812 739012 620785 640523 644274 644275 697987 703037 703095 705829 715176 717805 775931 784732 791772 373798 403255 827872 607107 452632 531249 569072 634159 383238 394636 96944 117221 400944 414058 428786 817450 500910 505143 528315 566689 683183 650392 587407 585963 589185 633447 806514 813275 770298 761150 713699 480920 397348 406091 412779 471601 351640 534060 488721 827855 316575 445279 448651 583710 590949 770821 801275 399904 95748 406982 488713 525577 545505 447086 386062 341608 7502 398666 545453 549785 551057 550563 652966 654078 670997 686501 688660 695930 696250 697785 697839 697973 700282 721318 672130 683564 695096 697361 698597 705520 722607 722655 723468 649133 673371 674733 681804 683584 690749 693049 699632 699667 699755 703055 719057 720202 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (2.11%) |
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 7502 95748 96944 117221 316575 341608 351640 373798 383238 386062 394636 397348 398666 399904 400944 403255 406091 406982 412779 414058 428786 445279 447086 448651 452632 471601 480920 488713 488721 500910 505143 525577 528315 531249 534060 545453 545505 549785 550563 551057 566689 569072 583710 585963 587407 589185 590949 607107 620785 633447 634159 640523 644274 644275 649133 650392 652966 654078 670997 672130 673371 674733 681804 683183 683564 683584 686501 688660 690749 693049 695096 695930 696250 697361 697785 697839 697973 697987 698597 699632 699667 699755 700282 703037 703055 703095 705520 705829 713699 715176 717805 719057 720202 721318 722607 722655 723468 738812 739012 741213 742363 750154 752785 759485 761150 767283 769418 770298 770821 775798 775931 784732 791101 791772 801275 806514 813275 817450 827855 827872 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double анал teens"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double anal teens"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double анал teens"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.08%) |
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.