Query Metrics
7
Database Queries
7
Different statements
193.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.49 ms (88.04%) |
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 382755 385267 387376 388805 388891 394165 396354 401993 402195 411025 415748 421378 424384 428639 428870 433216 445498 445851 449337 453535 454278 457594 457955 462026 462804 473959 479758 479759 481166 483461 484745 491712 497924 512419 514892 520969 528850 528929 530476 536251 536718 537910 537929 537987 538743 545152 558821 563965 570462 574026 576070 576107 585475 585963 592336 598012 598556 598768 601153 604130 618514 618927 620399 626255 626256 630567 631612 631620 632288 633062 647899 648546 656263 658608 666869 666871 668437 668545 682320 686088 691992 692051 693026 701439 705530 712421 735800 738198 748605 753023 757448 760124 761592 771145 771301 774672 782431 783514 784742 796227 803827 813399 817724 817726 818909 819088 821430 821493 823041 823453 825834 825951 825993 826553 828541 828600 828664 828668 828677 828763 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (7.08%) |
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 585475 601153 828763 828600 618927 826553 813399 388891 545152 761592 648546 668437 668545 570462 585963 784742 454278 396354 530476 598768 774672 479758 457594 693026 760124 387376 825993 483461 647899 631612 626256 626255 457955 479759 491712 512419 528929 520969 538743 574026 537929 537910 828677 712421 620399 738198 757448 823453 445498 445851 473959 537987 576107 453535 394165 796227 563965 692051 748605 385267 701439 771301 382755 528850 433216 514892 598012 592336 462804 428639 401993 481166 825834 817726 771145 825951 828664 686088 666871 735800 632288 388805 402195 536718 630567 783514 449337 497924 656263 631620 803827 428870 424384 558821 705530 666869 691992 682320 618514 753023 421378 411025 415748 462026 823041 818909 821430 821493 828668 828541 658608 576070 633062 598556 817724 819088 604130 782431 484745 536251 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen boobs big"
]
|
||||||||||||||||||||||||||||||
|
2.40 ms (1.24%) |
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 382755 385267 387376 388805 388891 394165 396354 401993 402195 411025 415748 421378 424384 428639 428870 433216 445498 445851 449337 453535 454278 457594 457955 462026 462804 473959 479758 479759 481166 483461 484745 491712 497924 512419 514892 520969 528850 528929 530476 536251 536718 537910 537929 537987 538743 545152 558821 563965 570462 574026 576070 576107 585475 585963 592336 598012 598556 598768 601153 604130 618514 618927 620399 626255 626256 630567 631612 631620 632288 633062 647899 648546 656263 658608 666869 666871 668437 668545 682320 686088 691992 692051 693026 701439 705530 712421 735800 738198 748605 753023 757448 760124 761592 771145 771301 774672 782431 783514 784742 796227 803827 813399 817724 817726 818909 819088 821430 821493 823041 823453 825834 825951 825993 826553 828541 828600 828664 828668 828677 828763 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen boobs большие"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen boobs большие"
]
|
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.