Query Metrics
7
Database Queries
7
Different statements
164.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.27 ms (83.35%) |
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 34462 206144 383290 393314 401733 410980 415028 418558 421241 430508 431794 444731 447140 447853 448266 453028 454668 454814 457289 459357 464184 465001 469350 469833 471185 486643 488017 492440 501703 507181 507824 513893 524788 526985 530050 530752 530791 531544 532483 532837 533648 535372 536557 536916 547028 550324 553430 553440 565111 566164 569199 574318 575899 576572 576637 577408 577718 580866 580890 587445 590512 603557 613152 613608 614990 615964 622733 625435 625467 626253 626257 634849 635230 636478 643018 649644 650845 651290 652540 664835 664967 666808 667574 668292 671328 689660 694894 701875 707356 709764 715138 716181 719203 722330 727920 729538 732293 732428 736289 736836 740956 743834 745422 745473 748155 749909 750078 751722 752876 755165 758170 760123 761027 765243 775903 781783 781898 785387 801341 807387 ] |
||||||||||||||||||||||||||||||
|
16.91 ms (10.27%) |
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 448266 569199 580890 553440 666808 671328 707356 722330 664835 664967 652540 667574 576572 614990 635230 643018 626253 781783 781898 740956 748155 760123 765243 801341 758170 743834 750078 732293 736836 752876 745473 749909 755165 761027 603557 615964 622733 626257 715138 34462 486643 469350 457289 454668 532483 464184 507824 524788 453028 465001 533648 649644 716181 393314 415028 492440 447853 547028 565111 576637 574318 689660 668292 577408 613152 625435 634849 613608 625467 807387 785387 745422 732428 636478 459357 421241 530791 532837 401733 418558 454814 577718 709764 775903 729538 727920 530050 447140 536916 650845 383290 535372 206144 488017 513893 530752 651290 701875 719203 694894 575899 736289 751722 431794 444731 536557 501703 507181 526985 531544 471185 553430 566164 580866 550324 590512 587445 430508 410980 469833 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.85%) |
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 34462 206144 383290 393314 401733 410980 415028 418558 421241 430508 431794 444731 447140 447853 448266 453028 454668 454814 457289 459357 464184 465001 469350 469833 471185 486643 488017 492440 501703 507181 507824 513893 524788 526985 530050 530752 530791 531544 532483 532837 533648 535372 536557 536916 547028 550324 553430 553440 565111 566164 569199 574318 575899 576572 576637 577408 577718 580866 580890 587445 590512 603557 613152 613608 614990 615964 622733 625435 625467 626253 626257 634849 635230 636478 643018 649644 650845 651290 652540 664835 664967 666808 667574 668292 671328 689660 694894 701875 707356 709764 715138 716181 719203 722330 727920 729538 732293 732428 736289 736836 740956 743834 745422 745473 748155 749909 750078 751722 752876 755165 758170 760123 761027 765243 775903 781783 781898 785387 801341 807387 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge cock"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные cock"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие огромные cock"
]
|
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.