Query Metrics
7
Database Queries
7
Different statements
159.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.09 ms (81.54%) |
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 389273 391026 404724 417618 419931 422402 422500 423283 437963 459117 462854 464367 471141 474845 478439 481615 484019 490419 495066 499180 500392 509069 511067 512059 512857 512871 512877 512879 512923 517431 518628 521454 522139 522180 522847 524435 524793 527927 528840 530109 531521 532508 532912 536470 537714 542074 542083 542085 543844 543864 543872 546833 548258 548833 550068 550745 551063 551902 552067 552069 554825 556511 557502 558620 559197 559856 561074 562816 569722 569756 573223 573268 576722 577594 578492 581501 582053 582209 586889 588814 591088 595064 598078 598612 599007 600111 601052 601338 602232 603034 604019 605427 605659 614428 614942 615605 615658 618645 623832 623847 624505 626538 628199 637120 640684 640685 645005 648634 651144 678893 730380 730907 736837 763218 763304 765734 789820 800851 802921 817152 ] |
||||||||||||||||||||||||||||||
|
17.74 ms (11.12%) |
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 522139 531521 536470 550068 569722 556511 569756 577594 561074 562816 588814 640684 599007 601052 604019 800851 763304 765734 391026 532508 543844 512879 521454 559197 548833 602232 605659 512877 550745 542083 542085 557502 678893 546833 578492 595064 600111 730380 736837 763218 478439 527927 542074 558620 598612 618645 605427 437963 404724 495066 499180 524435 518628 543864 582053 552067 559856 598078 591088 614942 419931 462854 423283 512059 573223 582209 586889 517431 417618 464367 474845 484019 459117 522180 512923 530109 581501 551902 551063 615605 789820 640685 389273 817152 422402 512857 481615 554825 573268 648634 626538 628199 637120 615658 623847 614428 522847 528840 651144 601338 603034 645005 509069 511067 512871 576722 552069 623832 524793 422500 543872 624505 537714 802921 532912 548258 730907 471141 490419 500392 ] |
||||||||||||||||||||||||||||||
|
4.09 ms (2.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.80%) |
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 389273 391026 404724 417618 419931 422402 422500 423283 437963 459117 462854 464367 471141 474845 478439 481615 484019 490419 495066 499180 500392 509069 511067 512059 512857 512871 512877 512879 512923 517431 518628 521454 522139 522180 522847 524435 524793 527927 528840 530109 531521 532508 532912 536470 537714 542074 542083 542085 543844 543864 543872 546833 548258 548833 550068 550745 551063 551902 552067 552069 554825 556511 557502 558620 559197 559856 561074 562816 569722 569756 573223 573268 576722 577594 578492 581501 582053 582209 586889 588814 591088 595064 598078 598612 599007 600111 601052 601338 602232 603034 604019 605427 605659 614428 614942 615605 615658 618645 623832 623847 624505 626538 628199 637120 640684 640685 645005 648634 651144 678893 730380 730907 736837 763218 763304 765734 789820 800851 802921 817152 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls slave"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.78%) |
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.