Query Metrics
7
Database Queries
7
Different statements
268.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
239.48 ms (89.15%) |
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 233426 382003 388819 395923 398676 399396 400138 401426 403657 404371 405531 408326 409144 411222 412081 423242 424330 437853 440624 447685 449778 454215 462234 471587 473981 475441 476255 478883 481591 482085 482743 484731 487439 487582 490923 498003 501710 514692 515142 515217 515236 516411 517190 517869 519931 521925 543089 548796 549778 552099 556852 560588 562248 562840 564431 565507 565959 565992 569120 569134 570214 571629 574930 575086 576161 585329 587220 592758 596407 596577 597852 598203 598606 598813 600049 600192 603661 604066 604567 606793 610635 622230 623521 633145 639067 639975 643986 645011 649196 663482 664955 674757 676973 693075 693078 698456 699459 699628 706946 714082 720381 721541 724440 724507 727057 732055 732441 734428 744259 746499 800272 802123 812141 812153 814799 821904 821909 822365 823303 825116 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (5.99%) |
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 664955 481591 714082 490923 449778 587220 519931 501710 412081 454215 517869 724440 598813 592758 399396 411222 447685 562840 622230 734428 732441 233426 597852 473981 487582 517190 404371 423242 516411 569120 565992 576161 676973 574930 598606 746499 633145 482085 403657 398676 482743 462234 476255 569134 724507 400138 440624 405531 514692 487439 388819 821909 822365 821904 825116 515236 549778 560588 565507 543089 674757 699628 706946 649196 663482 698456 699459 645011 552099 556852 562248 585329 604567 600192 604066 639975 600049 606793 639067 800272 802123 812153 732055 744259 721541 812141 478883 395923 521925 401426 408326 437853 814799 515142 571629 693078 720381 564431 596577 610635 727057 603661 623521 475441 409144 498003 424330 823303 548796 565959 575086 693075 570214 596407 598203 643986 471587 484731 515217 382003 ] |
||||||||||||||||||||||||||||||
|
4.34 ms (1.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 233426 382003 388819 395923 398676 399396 400138 401426 403657 404371 405531 408326 409144 411222 412081 423242 424330 437853 440624 447685 449778 454215 462234 471587 473981 475441 476255 478883 481591 482085 482743 484731 487439 487582 490923 498003 501710 514692 515142 515217 515236 516411 517190 517869 519931 521925 543089 548796 549778 552099 556852 560588 562248 562840 564431 565507 565959 565992 569120 569134 570214 571629 574930 575086 576161 585329 587220 592758 596407 596577 597852 598203 598606 598813 600049 600192 603661 604066 604567 606793 610635 622230 623521 633145 639067 639975 643986 645011 649196 663482 664955 674757 676973 693075 693078 698456 699459 699628 706946 714082 720381 721541 724440 724507 727057 732055 732441 734428 744259 746499 800272 802123 812141 812153 814799 821904 821909 822365 823303 825116 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny ffm"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.73%) |
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.