Query Metrics
7
Database Queries
7
Different statements
203.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.14 ms (87.73%) |
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 261088 382418 390427 408327 415517 417986 420781 423060 425921 427077 427432 431740 432169 435420 441420 441468 442550 443020 446388 448198 456993 457316 457504 458056 469722 470224 470720 470865 473649 475058 476363 478724 480934 484831 491472 491588 496510 497615 498776 499527 500152 501519 502852 507472 508616 509933 521179 521597 523655 523716 523935 524092 524973 526759 528892 533618 540724 540729 542782 545485 545694 546927 549477 550342 557380 560461 562262 562395 562772 570757 571370 576216 577184 582500 582584 594824 602874 603969 604313 623831 625018 625037 625878 641649 642442 661306 672851 673260 673858 676432 677015 682573 685055 689191 693246 693278 695873 696389 703141 706912 715123 715395 727040 729836 731060 732308 732774 738756 744290 745445 748632 773926 777823 798640 803458 806354 808380 814351 817010 821864 ] |
||||||||||||||||||||||||||||||
|
14.69 ms (7.24%) |
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 731060 729836 745445 744290 738756 441420 475058 528892 540724 500152 521179 432169 814351 821864 470865 642442 623831 625878 798640 773926 458056 435420 457316 382418 423060 497615 540729 526759 542782 562772 582584 672851 677015 693246 715395 715123 562395 603969 604313 602874 806354 748632 727040 777823 443020 446388 261088 415517 417986 441468 442550 523655 484831 491472 498776 501519 470224 496510 521597 507472 545485 550342 562262 570757 576216 582500 673858 689191 706912 661306 695873 696389 546927 557380 625037 594824 641649 803458 732308 732774 625018 808380 390427 425921 431740 457504 427077 476363 427432 478724 480934 420781 523935 524973 499527 502852 508616 524092 408327 817010 448198 456993 469722 470720 473649 491588 523716 533618 509933 545694 549477 560461 571370 577184 673260 703141 685055 693278 676432 682573 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.54%) |
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 261088 382418 390427 408327 415517 417986 420781 423060 425921 427077 427432 431740 432169 435420 441420 441468 442550 443020 446388 448198 456993 457316 457504 458056 469722 470224 470720 470865 473649 475058 476363 478724 480934 484831 491472 491588 496510 497615 498776 499527 500152 501519 502852 507472 508616 509933 521179 521597 523655 523716 523935 524092 524973 526759 528892 533618 540724 540729 542782 545485 545694 546927 549477 550342 557380 560461 562262 562395 562772 570757 571370 576216 577184 582500 582584 594824 602874 603969 604313 623831 625018 625037 625878 641649 642442 661306 672851 673260 673858 676432 677015 682573 685055 689191 693246 693278 695873 696389 703141 706912 715123 715395 727040 729836 731060 732308 732774 738756 744290 745445 748632 773926 777823 798640 803458 806354 808380 814351 817010 821864 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex xxx student"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс xxx student"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс xxx student"
]
|
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.