Query Metrics
7
Database Queries
7
Different statements
204.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.72 ms (86.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 387391 418138 423804 427218 427406 435529 443855 443958 446118 447604 450814 470302 471378 472244 474119 475103 475986 478065 479389 479964 482368 492977 497921 499183 502762 503178 503498 504132 505068 506240 506940 513310 513589 517143 519262 520898 522056 524100 524165 524180 525186 526895 528324 530307 532898 534744 534988 536903 541396 541886 541893 542094 544202 549729 553505 554614 554952 555000 560382 563722 565143 565687 565903 566020 572675 576638 579648 586403 586483 588609 588953 595986 601147 601234 606680 614715 615535 615716 620252 621201 621698 622785 622830 623973 625437 625696 633140 637044 642389 645935 645939 646199 650276 651604 667966 669175 669192 671863 671888 672752 677098 677106 717410 726718 727812 732559 733451 750816 767018 776911 780517 781873 784157 788886 795084 803292 806218 810902 811084 818471 ] |
||||||||||||||||||||||||||||||
|
16.54 ms (8.07%) |
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 560382 669192 645935 667966 677098 553505 554614 572675 615535 781873 795084 803292 811084 733451 750816 776911 806218 435529 479389 423804 443958 387391 524180 505068 506240 502762 497921 544202 601147 637044 522056 646199 499183 534988 727812 625696 474119 503178 482368 601234 620252 788886 810902 732559 524100 472244 520898 532898 503498 504132 517143 549729 579648 542094 563722 555000 645939 669175 565687 606680 623973 633140 586483 588953 614715 622785 726718 780517 447604 471378 450814 525186 492977 524165 625437 475103 576638 526895 621698 615716 443855 671863 541886 621201 478065 470302 536903 427406 427218 818471 475986 513589 519262 528324 513310 534744 506940 530307 541396 541893 565903 554952 565143 566020 650276 672752 677106 717410 651604 671888 586403 642389 588609 595986 767018 784157 622830 479964 418138 446118 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.50%) |
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 387391 418138 423804 427218 427406 435529 443855 443958 446118 447604 450814 470302 471378 472244 474119 475103 475986 478065 479389 479964 482368 492977 497921 499183 502762 503178 503498 504132 505068 506240 506940 513310 513589 517143 519262 520898 522056 524100 524165 524180 525186 526895 528324 530307 532898 534744 534988 536903 541396 541886 541893 542094 544202 549729 553505 554614 554952 555000 560382 563722 565143 565687 565903 566020 572675 576638 579648 586403 586483 588609 588953 595986 601147 601234 606680 614715 615535 615716 620252 621201 621698 622785 622830 623973 625437 625696 633140 637044 642389 645935 645939 646199 650276 651604 667966 669175 669192 671863 671888 672752 677098 677106 717410 726718 727812 732559 733451 750816 767018 776911 780517 781873 784157 788886 795084 803292 806218 810902 811084 818471 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother porn"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин porn"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин porn"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.