Query Metrics
7
Database Queries
7
Different statements
188.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.52 ms (86.80%) |
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 390615 392100 394006 413151 418912 420317 421777 425312 426797 435816 435883 455099 461381 461697 461807 462044 466083 466830 469114 470062 472577 472600 489786 494561 506136 506786 511420 522285 523606 528058 529931 532449 535037 537472 539875 546975 549740 551674 551834 552501 555458 556141 558872 559656 564908 570403 573592 574151 576509 578739 579330 579405 579451 583304 583574 584241 585397 587745 595258 597763 600500 609962 611164 612421 619230 625326 630913 630924 636936 641554 653755 654658 655050 657325 662429 682803 689042 695330 696982 696986 697738 705696 712795 713583 719131 724878 725987 726506 726516 729589 732635 732829 736017 736021 749401 750601 755924 757776 765384 768085 768142 768575 768586 769378 769960 777860 781928 783053 784005 787713 788969 789613 791013 801094 801535 802005 803142 806403 806421 812180 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (8.43%) |
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 469114 470062 472600 551674 558872 574151 583574 549740 551834 556141 564908 570403 583304 552501 555458 576509 653755 705696 655050 657325 682803 689042 695330 654658 662429 696982 697738 712795 713583 559656 578739 584241 625326 587745 600500 612421 641554 585397 597763 619230 636936 595258 609962 630913 630924 777860 787713 791013 801094 806403 788969 806421 726506 726516 736021 768575 801535 802005 736017 749401 768586 769960 724878 729589 732829 768085 768142 732635 755924 765384 769378 725987 750601 757776 611164 696986 719131 781928 783053 784005 789613 803142 812180 390615 392100 418912 461697 394006 413151 420317 435816 435883 461807 455099 461381 462044 425312 426797 466083 466830 506786 523606 494561 511420 421777 472577 489786 522285 532449 539875 529931 506136 528058 535037 537472 579330 579405 579451 546975 573592 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.10%) |
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 390615 392100 394006 413151 418912 420317 421777 425312 426797 435816 435883 455099 461381 461697 461807 462044 466083 466830 469114 470062 472577 472600 489786 494561 506136 506786 511420 522285 523606 528058 529931 532449 535037 537472 539875 546975 549740 551674 551834 552501 555458 556141 558872 559656 564908 570403 573592 574151 576509 578739 579330 579405 579451 583304 583574 584241 585397 587745 595258 597763 600500 609962 611164 612421 619230 625326 630913 630924 636936 641554 653755 654658 655050 657325 662429 682803 689042 695330 696982 696986 697738 705696 712795 713583 719131 724878 725987 726506 726516 729589 732635 732829 736017 736021 749401 750601 755924 757776 765384 768085 768142 768575 768586 769378 769960 777860 781928 783053 784005 787713 788969 789613 791013 801094 801535 802005 803142 806403 806421 812180 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно смотрит"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"порн смотр"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.