Query Metrics
7
Database Queries
7
Different statements
135.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.36 ms (85.01%) |
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 42536 92281 101353 229024 382781 384293 385021 385204 386063 387473 390678 391759 392751 393872 398416 400534 497813 513570 517658 526492 529791 530587 531824 536101 537966 538063 540924 550807 550890 550943 560546 562575 574090 576552 580062 584048 586409 590275 601821 605173 612913 613796 618242 618297 623681 624484 627512 629725 630419 631461 634317 634734 634735 638999 639347 639381 643181 643187 643200 643235 645673 650770 653602 661036 679173 704990 705028 706038 707376 708069 709360 709559 710194 715434 722389 749023 752541 752638 761265 763292 785075 788598 789479 792079 792272 792753 793430 793456 794322 795052 796768 796837 796859 797284 797285 800279 800317 801478 801797 802347 803483 803542 803576 806864 806976 813114 814261 814315 817124 819861 825220 825848 827853 827872 827874 827877 827892 827899 827969 ] |
||||||||||||||||||||||||||||||
|
11.03 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 590275 613796 639347 597175 612913 643235 550943 618242 627512 706038 715434 386063 384293 393872 392751 391759 92281 42536 825848 814261 817124 819861 825220 536101 538063 513570 540924 574090 550807 550890 576552 580062 584048 618297 634734 586409 794322 796768 797284 792079 797285 800279 802347 803576 752541 792272 803542 382781 390678 709559 385021 385204 497813 803483 814315 788598 793456 763292 229024 623681 624484 526492 709360 400534 537966 827969 638999 796859 792753 806864 827877 827872 827874 827853 827899 827892 529791 653602 645673 679173 634317 634735 639381 643187 643200 708069 517658 530587 562575 629725 630419 101353 796837 643181 707376 387473 398416 531824 560546 704990 705028 650770 661036 710194 722389 601821 605173 631461 801797 806976 789479 800317 813114 749023 752638 761265 785075 793430 795052 801478 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (2.05%) |
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 42536 92281 101353 229024 382781 384293 385021 385204 386063 387473 390678 391759 392751 393872 398416 400534 497813 513570 517658 526492 529791 530587 531824 536101 537966 538063 540924 550807 550890 550943 560546 562575 574090 576552 580062 584048 586409 590275 601821 605173 612913 613796 618242 618297 623681 624484 627512 629725 630419 631461 634317 634734 634735 638999 639347 639381 643181 643187 643200 643235 645673 650770 653602 661036 679173 704990 705028 706038 707376 708069 709360 709559 710194 715434 722389 749023 752541 752638 761265 763292 785075 788598 789479 792079 792272 792753 793430 793456 794322 795052 796768 796837 796859 797284 797285 800279 800317 801478 801797 802347 803483 803542 803576 806864 806976 813114 814261 814315 817124 819861 825220 825848 827853 827872 827874 827877 827892 827899 827969 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (1.04%) |
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.