Query Metrics
7
Database Queries
7
Different statements
165.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.58 ms (82.44%) |
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 256218 395572 416693 420757 428929 429603 437218 443431 445277 447138 447619 449255 449322 449470 451118 451693 455697 458008 460003 461312 467994 469096 472129 475408 478022 480174 490504 491629 492726 498114 498543 498857 502800 504717 505638 507468 511113 512221 517975 518901 520252 522152 525365 534604 534772 541284 541303 547835 550759 552584 554371 554756 555795 555973 558902 560325 560872 561020 562556 570867 572260 577584 579726 580239 580242 581220 583665 584987 587851 588017 588828 589296 591107 592958 593050 594500 595275 596359 602015 603108 613791 615984 617014 618101 627846 639139 653520 660001 665796 673797 693781 699916 707539 726849 730975 732681 735195 739145 741756 746101 746136 747194 757724 770410 772233 776400 777043 785066 785972 788519 791641 796976 797353 799027 800535 806384 809064 809075 814038 819706 ] |
||||||||||||||||||||||||||||||
|
16.84 ms (10.17%) |
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 458008 460003 512221 555973 577584 554756 570867 579726 592958 707539 428929 449470 498114 518901 445277 416693 814038 819706 584987 447619 475408 480174 490504 449322 451118 455697 449255 472129 491629 498543 505638 534604 534772 467994 469096 541284 541303 560325 552584 561020 562556 581220 583665 547835 554371 560872 580239 580242 693781 653520 660001 665796 673797 550759 555795 558902 572260 588017 596359 602015 639139 587851 588828 589296 594500 603108 613791 615984 618101 593050 591107 595275 776400 777043 785972 806384 809064 809075 791641 796976 800535 730975 732681 741756 757724 785066 797353 746101 739145 746136 747194 772233 726849 735195 770410 617014 627846 699916 788519 799027 395572 429603 451693 437218 447138 420757 256218 443431 461312 478022 492726 502800 522152 525365 511113 517975 520252 498857 504717 507468 ] |
||||||||||||||||||||||||||||||
|
4.32 ms (2.61%) |
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 256218 395572 416693 420757 428929 429603 437218 443431 445277 447138 447619 449255 449322 449470 451118 451693 455697 458008 460003 461312 467994 469096 472129 475408 478022 480174 490504 491629 492726 498114 498543 498857 502800 504717 505638 507468 511113 512221 517975 518901 520252 522152 525365 534604 534772 541284 541303 547835 550759 552584 554371 554756 555795 555973 558902 560325 560872 561020 562556 570867 572260 577584 579726 580239 580242 581220 583665 584987 587851 588017 588828 589296 591107 592958 593050 594500 595275 596359 602015 603108 613791 615984 617014 618101 627846 639139 653520 660001 665796 673797 693781 699916 707539 726849 730975 732681 735195 739145 741756 746101 746136 747194 757724 770410 772233 776400 777043 785066 785972 788519 791641 796976 797353 799027 800535 806384 809064 809075 814038 819706 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"she masturbation"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"she мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"she мастурбац"
]
|
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.