Query Metrics
7
Database Queries
7
Different statements
207.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.29 ms (87.17%) |
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 383225 413116 414082 416868 418022 428360 429033 452933 471977 488797 490622 500825 503008 525293 529771 530991 535290 536641 540146 542705 542905 544417 544936 545042 545508 546758 548217 549561 550914 551541 552092 554211 556595 557341 557640 557655 557690 558163 558457 565512 567531 568744 571295 572921 574125 574134 575662 577160 579609 582648 583420 587292 596963 597043 603463 605094 621974 635812 639481 663730 711715 729859 733654 734863 736760 739149 739368 739930 740846 743160 745276 745375 749493 749593 750529 751372 752557 752680 754355 754516 754540 754944 755892 756691 756822 757013 759158 764724 764736 764741 764782 778120 782334 782908 782949 783288 784696 784869 785257 785644 786900 788913 790720 791138 791170 791340 791391 792407 792845 795156 796397 798287 800096 802240 806734 807068 807246 809000 812287 826715 ] |
||||||||||||||||||||||||||||||
|
16.91 ms (8.13%) |
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 784869 786900 791170 791391 795156 798287 800096 807068 782908 785644 790720 791138 791340 792407 792845 802240 812287 734863 736760 752680 782949 784696 785257 796397 806734 807246 740846 745276 754944 757013 764741 729859 739930 745375 750529 754516 755892 759158 743160 749493 754355 756691 764736 733654 739149 749593 751372 752557 754540 756822 764724 764782 603463 621974 635812 639481 711715 778120 782334 783288 788913 383225 471977 428360 558457 663730 596963 597043 429033 488797 416868 826715 809000 739368 577160 568744 542705 536641 545508 546758 587292 605094 452933 418022 414082 413116 490622 503008 530991 540146 500825 525293 535290 529771 544417 545042 548217 549561 552092 554211 557341 557640 557655 558163 565512 571295 572921 574125 574134 582648 583420 542905 544936 550914 551541 556595 557690 567531 575662 579609 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.17%) |
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 383225 413116 414082 416868 418022 428360 429033 452933 471977 488797 490622 500825 503008 525293 529771 530991 535290 536641 540146 542705 542905 544417 544936 545042 545508 546758 548217 549561 550914 551541 552092 554211 556595 557341 557640 557655 557690 558163 558457 565512 567531 568744 571295 572921 574125 574134 575662 577160 579609 582648 583420 587292 596963 597043 603463 605094 621974 635812 639481 663730 711715 729859 733654 734863 736760 739149 739368 739930 740846 743160 745276 745375 749493 749593 750529 751372 752557 752680 754355 754516 754540 754944 755892 756691 756822 757013 759158 764724 764736 764741 764782 778120 782334 782908 782949 783288 784696 784869 785257 785644 786900 788913 790720 791138 791170 791340 791391 792407 792845 795156 796397 798287 800096 802240 806734 807068 807246 809000 812287 826715 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые соло вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny solo webcam"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.79%) |
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.