Query Metrics
7
Database Queries
7
Different statements
173.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.21 ms (84.94%) |
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 82143 150495 191199 233364 364655 385190 389593 395398 397246 411001 416258 417887 417975 418297 419151 424490 426098 429728 430832 436675 436948 440692 444727 449911 453082 453693 454680 457917 459716 460686 461459 463086 468141 469055 471753 474579 476377 479398 480779 484242 486582 491634 491978 494040 494122 495194 497615 497887 499157 501252 503369 504210 504820 506539 510399 510802 512912 515236 517929 522808 523692 528090 542464 544414 552008 552251 554211 554536 562809 567160 567403 571901 574186 579890 580015 581053 581394 582780 583108 583985 584408 587957 587963 591128 593693 602973 608427 613845 622170 623307 626438 629723 631927 634768 649989 656802 660943 665957 683787 719892 732340 734271 734283 738814 746546 758919 773742 779706 786074 786625 801370 804005 805712 806030 807860 816343 817099 817309 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (8.49%) |
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 591128 624967 424490 567403 544414 587957 418297 440692 567160 385190 816343 554211 593693 734271 634768 806030 459716 469055 486582 552008 494040 503369 417887 579890 582780 436675 522808 364655 411001 426098 454680 468141 523692 504210 510802 581053 580015 562809 583108 587963 786625 807860 453693 476377 389593 436948 499157 501252 480779 604755 758919 491978 649989 801370 732340 471753 494122 430832 429728 515236 554536 583985 581394 683787 660943 622170 631927 613845 817099 817309 719892 656802 626438 629723 805712 786074 734283 746546 665957 738814 474579 495194 584408 552251 602973 773742 150495 397246 419151 453082 484242 497887 608427 517929 504820 571901 574186 542464 623307 804005 779706 82143 461459 233364 479398 457917 510399 191199 395398 417975 416258 444727 460686 463086 491634 449911 497615 506539 528090 512912 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.76%) |
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 82143 150495 191199 233364 364655 385190 389593 395398 397246 411001 416258 417887 417975 418297 419151 424490 426098 429728 430832 436675 436948 440692 444727 449911 453082 453693 454680 457917 459716 460686 461459 463086 468141 469055 471753 474579 476377 479398 480779 484242 486582 491634 491978 494040 494122 495194 497615 497887 499157 501252 503369 504210 504820 506539 510399 510802 512912 515236 517929 522808 523692 528090 542464 544414 552008 552251 554211 554536 562809 567160 567403 571901 574186 579890 580015 581053 581394 582780 583108 583985 584408 587957 587963 591128 593693 602973 608427 613845 622170 623307 626438 629723 631927 634768 649989 656802 660943 665957 683787 719892 732340 734271 734283 738814 746546 758919 773742 779706 786074 786625 801370 804005 805712 806030 807860 816343 817099 817309 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long fuck"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные секс"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.08%) |
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.