Query Metrics
7
Database Queries
7
Different statements
148.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.82 ms (83.51%) |
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 390904 417795 418131 421612 430278 431396 431702 434531 438696 440728 446579 449168 456342 456495 465098 467776 470703 474210 475231 476833 483778 494313 497241 498872 499922 500019 500519 501622 501903 502201 504214 505597 511652 514610 515048 515672 516369 518561 519778 520277 520586 524321 526035 532486 535145 537459 538043 541428 541525 542445 543640 544607 560680 561260 565834 567215 569558 574624 576245 582720 590153 607246 615686 619295 619559 660285 664729 680622 682877 689989 690666 690748 692026 692943 693310 693343 694619 697540 697742 703245 704644 704687 705641 705834 708182 709523 722377 723264 727844 729345 743109 750662 752603 752712 754078 755821 761611 762169 763974 766939 770817 770818 779485 781621 785073 785588 786137 786823 789802 793896 796719 799340 807255 809147 809536 810390 812038 812690 812997 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (10.22%) |
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 417795 499922 475231 434531 518561 535145 574624 543640 567215 680622 704687 532486 438696 430278 456495 465098 467776 497241 520586 502201 504214 519778 565834 781621 483778 449168 498872 500019 524321 526035 538043 500519 511652 515048 494313 476833 541428 542445 549533 541525 544607 560680 664729 682877 690666 692943 697540 709523 723264 689989 690748 693310 694619 705834 692026 693343 697742 705641 722377 569558 576245 590153 619559 607246 619295 785588 793896 809147 812690 812997 786137 786823 810390 727844 729345 743109 752603 754078 755821 770818 789802 807255 752712 761611 766939 770817 750662 762169 763974 615686 703245 704644 708182 779485 785073 799340 812038 390904 440728 505597 515672 456342 516369 431702 501622 582720 809536 561260 537459 474210 520277 514610 660285 796719 418131 421612 470703 501903 446579 431396 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.80%) |
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 390904 417795 418131 421612 430278 431396 431702 434531 438696 440728 446579 449168 456342 456495 465098 467776 470703 474210 475231 476833 483778 494313 497241 498872 499922 500019 500519 501622 501903 502201 504214 505597 511652 514610 515048 515672 516369 518561 519778 520277 520586 524321 526035 532486 535145 537459 538043 541428 541525 542445 543640 544607 560680 561260 565834 567215 569558 574624 576245 582720 590153 607246 615686 619295 619559 660285 664729 680622 682877 689989 690666 690748 692026 692943 693310 693343 694619 697540 697742 703245 704644 704687 705641 705834 708182 709523 722377 723264 727844 729345 743109 750662 752603 752712 754078 755821 761611 762169 763974 766939 770817 770818 779485 781621 785073 785588 786137 786823 789802 793896 796719 799340 807255 809147 809536 810390 812038 812690 812997 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam small tits"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.