Query Metrics
7
Database Queries
7
Different statements
175.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.04 ms (87.18%) |
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 4250 188034 310679 383237 385851 389406 407958 414319 421215 426003 427981 428111 433217 435472 440937 449023 454239 465217 472299 478427 515506 553130 569544 576590 591862 591944 598018 600283 617711 619857 623380 626231 628709 640731 641663 641683 641914 644075 644315 660400 660994 674452 674723 693210 695733 700760 701470 702268 708817 717088 720717 721737 722379 724366 726922 728204 728427 729286 729644 736519 744593 750294 751585 752736 756719 765302 765489 766668 766690 767166 770541 770610 770963 773737 777581 777728 779069 782429 784170 788425 789469 789540 789997 790042 790371 790859 791572 792643 793587 793597 794124 794781 797178 797505 798495 798572 800472 800527 801090 801344 803457 803656 803673 804528 806180 810274 811480 815197 815408 815606 816887 817276 817868 818727 820345 820707 821010 823471 826241 827432 ] |
||||||||||||||||||||||||||||||
|
12.19 ms (6.95%) |
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 674452 693210 695733 720717 660400 660994 701470 708817 717088 553130 591944 598018 600283 626231 644315 644075 591862 617711 619857 777581 788425 789997 790371 791572 798572 777728 779069 782429 789469 790859 793597 800527 810274 729644 789540 792643 797178 797505 801344 803457 803656 803673 804528 766668 773737 726922 744593 751585 765302 765489 770610 770963 724366 728427 729286 752736 770541 728204 756719 766690 640731 641663 700760 722379 790042 798495 800472 806180 4250 426003 414319 515506 454239 641683 569544 385851 383237 188034 310679 815197 823471 818727 821010 827432 815408 815606 816887 817276 820345 820707 826241 817868 478427 674723 721737 576590 628709 641914 736519 750294 767166 794124 794781 801090 702268 784170 793587 811480 472299 623380 427981 389406 421215 433217 407958 428111 435472 440937 449023 465217 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.81%) |
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 4250 188034 310679 383237 385851 389406 407958 414319 421215 426003 427981 428111 433217 435472 440937 449023 454239 465217 472299 478427 515506 553130 569544 576590 591862 591944 598018 600283 617711 619857 623380 626231 628709 640731 641663 641683 641914 644075 644315 660400 660994 674452 674723 693210 695733 700760 701470 702268 708817 717088 720717 721737 722379 724366 726922 728204 728427 729286 729644 736519 744593 750294 751585 752736 756719 765302 765489 766668 766690 767166 770541 770610 770963 773737 777581 777728 779069 782429 784170 788425 789469 789540 789997 790042 790371 790859 791572 792643 793587 793597 794124 794781 797178 797505 798495 798572 800472 800527 801090 801344 803457 803656 803673 804528 806180 810274 811480 815197 815408 815606 816887 817276 817868 818727 820345 820707 821010 823471 826241 827432 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal boobs"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал boobs"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал boobs"
]
|
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.