Query Metrics
7
Database Queries
7
Different statements
162.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.03 ms (81.78%) |
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 415241 419128 419300 421880 422169 422190 424210 424303 424362 425321 426988 427093 427210 430446 439530 439670 439705 440538 440893 440926 440955 441000 441383 441401 441414 441619 442965 445093 450965 453324 456362 456695 456736 462351 462901 463858 464921 465379 468697 469169 470125 472147 475258 475266 478365 481161 482254 482645 484283 486539 488423 490520 497311 497344 509256 509642 510074 510965 512514 513848 521166 522186 523021 523351 523841 525265 526951 528343 528410 549027 551904 558206 558880 559567 563246 563544 567356 569131 575890 579371 589573 590759 590865 596057 605378 627316 640708 662534 680251 707579 718707 744602 750706 751984 755627 765040 772051 773358 773856 775809 776969 777905 784750 786398 787131 787154 790338 790504 791399 794105 796184 797949 799985 801742 801775 806843 809413 811549 812831 825888 ] |
||||||||||||||||||||||||||||||
|
19.33 ms (11.88%) |
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 596057 627316 776969 790338 796184 812831 773856 794105 755627 765040 772051 773358 707579 786398 790504 801775 462901 513848 468697 680251 526951 825888 419300 445093 425321 441000 450965 482645 456736 465379 472147 481161 470125 558880 579371 569131 551904 563246 567356 640708 605378 797949 809413 784750 799985 751984 787131 424210 427210 439670 441383 441401 441619 478365 421880 424362 441414 482254 419128 430446 427093 456362 464921 469169 522186 497344 510965 718707 475258 662534 777905 787154 811549 791399 806843 415241 424303 440926 490520 456695 525265 528410 510074 523351 549027 559567 563544 589573 590759 590865 475266 440955 462351 422169 422190 439530 440893 442965 463858 439705 509642 484283 512514 486539 509256 521166 488423 523841 528343 750706 523021 453324 575890 775809 440538 426988 497311 558206 801742 744602 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.82%) |
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 415241 419128 419300 421880 422169 422190 424210 424303 424362 425321 426988 427093 427210 430446 439530 439670 439705 440538 440893 440926 440955 441000 441383 441401 441414 441619 442965 445093 450965 453324 456362 456695 456736 462351 462901 463858 464921 465379 468697 469169 470125 472147 475258 475266 478365 481161 482254 482645 484283 486539 488423 490520 497311 497344 509256 509642 510074 510965 512514 513848 521166 522186 523021 523351 523841 525265 526951 528343 528410 549027 551904 558206 558880 559567 563246 563544 567356 569131 575890 579371 589573 590759 590865 596057 605378 627316 640708 662534 680251 707579 718707 744602 750706 751984 755627 765040 772051 773358 773856 775809 776969 777905 784750 786398 787131 787154 790338 790504 791399 794105 796184 797949 799985 801742 801775 806843 809413 811549 812831 825888 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs pov anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs пов анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs пов анал"
]
|
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.