Query Metrics
7
Database Queries
7
Different statements
199.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.32 ms (86.84%) |
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 418119 441080 460323 499904 534529 540051 541228 541575 541783 542397 542456 550560 552604 554828 555220 555360 558953 563333 565119 565263 566325 566766 592576 597234 597260 597267 600359 601830 604636 609244 614428 619807 629458 632638 632887 634169 637432 641561 641985 643728 647844 647938 648589 649543 651082 651620 656507 656523 659009 659034 661974 662217 664166 665328 666422 666579 666584 666734 671070 673039 678502 680164 680172 680192 680204 691381 692714 704268 704275 710265 712311 714612 716088 718576 718581 718766 720421 720598 721949 723643 723933 728768 729287 731825 732869 736265 743380 743470 745188 748975 750308 750549 752616 762173 762222 765517 766348 767208 767329 771623 784161 784308 784567 790370 791370 794669 800495 801899 803450 806268 809909 811010 811450 811844 817317 818377 818475 820774 820778 825342 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (7.93%) |
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 641561 541228 659009 662217 732869 704275 534529 692714 666734 691381 555220 632887 800495 771623 629458 718581 542456 720421 729287 541783 811844 723643 592576 743470 540051 666422 716088 600359 731825 752616 767329 704268 550560 619807 601830 790370 803450 748975 766348 806268 743380 745188 762173 720598 418119 609244 664166 641985 784567 811450 762222 765517 666579 671070 710265 680204 552604 801899 750308 721949 441080 825342 460323 499904 566766 680192 647844 648589 680164 712311 634169 597267 750549 791370 554828 604636 818475 818377 817317 820774 820778 542397 651082 666584 680172 649543 673039 794669 736265 767208 784308 728768 784161 811010 632638 566325 555360 565119 565263 714612 597260 723933 809909 665328 647938 643728 614428 656523 541575 563333 656507 661974 718766 651620 659034 678502 718576 558953 597234 637432 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.70%) |
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 418119 441080 460323 499904 534529 540051 541228 541575 541783 542397 542456 550560 552604 554828 555220 555360 558953 563333 565119 565263 566325 566766 592576 597234 597260 597267 600359 601830 604636 609244 614428 619807 629458 632638 632887 634169 637432 641561 641985 643728 647844 647938 648589 649543 651082 651620 656507 656523 659009 659034 661974 662217 664166 665328 666422 666579 666584 666734 671070 673039 678502 680164 680172 680192 680204 691381 692714 704268 704275 710265 712311 714612 716088 718576 718581 718766 720421 720598 721949 723643 723933 728768 729287 731825 732869 736265 743380 743470 745188 748975 750308 750549 752616 762173 762222 765517 766348 767208 767329 771623 784161 784308 784567 790370 791370 794669 800495 801899 803450 806268 809909 811010 811450 811844 817317 818377 818475 820774 820778 825342 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал pissing"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал pissing"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal pissing"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.73%) |
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.