Query Metrics
7
Database Queries
7
Different statements
412.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.29 ms (51.18%) |
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 11947 391921 398039 398979 400470 409251 411081 419435 419619 429857 435567 443830 446756 450549 452205 456045 457379 459718 464663 464996 466992 467089 470023 476675 478988 482441 484969 486322 487155 490598 491766 514250 518197 520398 521841 522632 522646 527829 527832 530106 534946 542530 542926 545219 548644 551607 552373 554980 555001 555131 556805 569572 571707 575947 577310 582440 583390 593525 596948 599239 599817 604935 612937 613903 624910 631238 645813 664987 672831 678716 693244 694098 701223 714487 718771 721958 723674 725440 725441 725460 730307 735948 741011 741750 742760 750852 759760 762232 762263 763744 763745 765836 769158 772574 774350 781322 781917 783984 785920 787343 788690 791492 791501 792412 792614 795409 795709 795720 796452 796860 796999 801401 801421 803374 803752 805318 808947 810086 812388 816592 ] |
||||||||||||||||||||||||||||||
|
178.77 ms (43.30%) |
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 11947 391921 398039 398979 400470 409251 411081 419435 419619 429857 435567 443830 446756 450549 452205 456045 457379 459718 464663 464996 466992 467089 470023 476675 478988 482441 484969 486322 487155 490598 491766 514250 518197 520398 521841 522632 522646 527829 527832 530106 534946 542530 542926 545219 548644 551607 552373 554980 555001 555131 556805 569572 571707 575947 577310 582440 583390 593525 596948 599239 599817 604935 612937 613903 624910 631238 645813 664987 672831 678716 693244 694098 701223 714487 718771 721958 723674 725440 725441 725460 730307 735948 741011 741750 742760 750852 759760 762232 762263 763744 763745 765836 769158 772574 774350 781322 781917 783984 785920 787343 788690 791492 791501 792412 792614 795409 795709 795720 796452 796860 796999 801401 801421 803374 803752 805318 808947 810086 812388 816592 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (3.83%) |
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 781322 788690 805318 795709 808947 812388 741750 787343 810086 759760 723674 735948 750852 763745 742760 701223 783984 795720 796452 796860 796999 435567 522646 694098 450549 467089 464996 490598 514250 571707 569572 714487 599239 604935 419619 398979 409251 482441 575947 583390 542530 718771 645813 721958 551607 613903 631238 795409 803374 741011 769158 725441 763744 765836 792412 398039 419435 459718 470023 391921 527829 487155 11947 400470 816592 452205 457379 446756 464663 478988 484969 534946 518197 530106 542926 577310 582440 545219 548644 552373 554980 555001 555131 693244 664987 556805 599817 593525 596948 612937 624910 781917 801421 803752 791501 801401 725460 772574 730307 762263 762232 774350 725440 785920 791492 429857 443830 476675 522632 491766 521841 486322 520398 527832 411081 672831 678716 792614 456045 466992 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf masturbates"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf masturbates"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf masturbates"
]
|
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.