Query Metrics
7
Database Queries
7
Different statements
151.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.90 ms (83.97%) |
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 274758 392984 423332 426413 440968 445814 446138 448043 453104 460917 466831 467223 486565 487096 493160 500331 515557 521219 524247 525671 530062 533595 543172 561736 570169 587047 589807 590345 592428 593482 603879 604715 608544 614424 615810 622205 662158 668374 673133 676374 680934 685878 693340 696230 697273 700328 708749 715281 716158 719095 719524 720494 722854 724135 724284 724903 726320 726947 729587 732698 733126 734407 736999 737371 741122 743939 745951 748741 749121 750941 755461 755469 756047 756721 765444 770110 770464 772808 775679 777036 780125 780577 782022 790957 797608 800009 800215 802395 802425 802833 803173 803541 807605 809466 810690 811045 814779 815518 816026 816802 816922 817227 817628 817666 817948 818495 818895 819039 820453 820680 823621 823973 824951 825037 825161 825262 826163 826694 826774 827522 ] |
||||||||||||||||||||||||||||||
|
13.16 ms (8.71%) |
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 515557 525671 426413 814779 446138 448043 487096 467223 676374 745951 460917 486565 530062 500331 748741 423332 445814 570169 590345 587047 809466 790957 824951 827522 826774 719524 668374 696230 741122 800009 770110 800215 807605 392984 816802 818895 823621 815518 816922 818495 825037 825262 820680 825161 543172 697273 720494 589807 608544 622205 604715 603879 797608 802395 802425 782022 803173 803541 724284 734407 755461 724135 743939 755469 772808 614424 775679 780125 780577 802833 274758 826694 823973 820453 561736 685878 722854 593482 724903 726320 732698 750941 756047 715281 716158 719095 810690 440968 466831 453104 521219 493160 524247 817948 816026 533595 673133 817628 817666 826163 817227 819039 680934 693340 662158 700328 592428 615810 777036 737371 749121 811045 729587 733126 765444 726947 736999 756721 770464 708749 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.79%) |
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 274758 392984 423332 426413 440968 445814 446138 448043 453104 460917 466831 467223 486565 487096 493160 500331 515557 521219 524247 525671 530062 533595 543172 561736 570169 587047 589807 590345 592428 593482 603879 604715 608544 614424 615810 622205 662158 668374 673133 676374 680934 685878 693340 696230 697273 700328 708749 715281 716158 719095 719524 720494 722854 724135 724284 724903 726320 726947 729587 732698 733126 734407 736999 737371 741122 743939 745951 748741 749121 750941 755461 755469 756047 756721 765444 770110 770464 772808 775679 777036 780125 780577 782022 790957 797608 800009 800215 802395 802425 802833 803173 803541 807605 809466 810690 811045 814779 815518 816026 816802 816922 817227 817628 817666 817948 818495 818895 819039 820453 820680 823621 823973 824951 825037 825161 825262 826163 826694 826774 827522 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy licking big"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy лиза большие"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy лиза большие"
]
|
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.