Query Metrics
7
Database Queries
7
Different statements
230.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.69 ms (86.37%) |
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 7286 214988 338587 382381 382971 390849 396094 411829 419904 420050 421056 422514 422546 422575 422590 422599 422603 422633 422646 423401 424063 425435 429411 429608 431540 433239 435646 449435 453929 457758 476151 478032 478427 492907 497392 498119 499931 511263 511809 512500 517855 519437 529810 533968 538270 539020 542904 543872 551987 566469 568478 582303 586886 590812 597229 597499 598478 606674 615713 619199 619442 621410 622649 623513 623572 629374 630533 641663 643671 650167 651699 651974 658215 672222 676542 688093 693057 698513 699767 712162 713877 717756 717947 718672 726237 742431 742461 743232 749268 750118 752694 755332 755334 757443 757762 758724 758726 761369 762980 765449 766611 766718 767029 767043 767050 769741 770304 776184 790821 799862 799992 800479 800619 809157 815022 815151 815717 816266 821536 823295 ] |
||||||||||||||||||||||||||||||
|
19.92 ms (8.66%) |
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 752694 766718 742431 790821 533968 799992 758726 338587 590812 382381 433239 422575 478032 492907 422546 422646 499931 423401 511263 757762 650167 429608 517855 497392 623513 7286 529810 651974 717756 651699 761369 758724 767029 770304 622649 776184 425435 586886 816266 566469 693057 698513 597499 629374 726237 742461 551987 543872 390849 815151 568478 757443 422514 542904 396094 449435 511809 476151 519437 382971 419904 429411 606674 619199 457758 713877 676542 717947 750118 765449 767043 749268 623572 435646 630533 821536 815022 539020 658215 688093 699767 619442 597229 598478 800479 743232 712162 422603 422633 422599 431540 411829 453929 512500 422590 755334 769741 823295 478427 643671 615713 800619 718672 538270 582303 672222 799862 755332 762980 767050 766611 641663 621410 809157 498119 424063 214988 420050 421056 815717 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.51%) |
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 7286 214988 338587 382381 382971 390849 396094 411829 419904 420050 421056 422514 422546 422575 422590 422599 422603 422633 422646 423401 424063 425435 429411 429608 431540 433239 435646 449435 453929 457758 476151 478032 478427 492907 497392 498119 499931 511263 511809 512500 517855 519437 529810 533968 538270 539020 542904 543872 551987 566469 568478 582303 586886 590812 597229 597499 598478 606674 615713 619199 619442 621410 622649 623513 623572 629374 630533 641663 643671 650167 651699 651974 658215 672222 676542 688093 693057 698513 699767 712162 713877 717756 717947 718672 726237 742431 742461 743232 749268 750118 752694 755332 755334 757443 757762 758724 758726 761369 762980 765449 766611 766718 767029 767043 767050 769741 770304 776184 790821 799862 799992 800479 800619 809157 815022 815151 815717 816266 821536 823295 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк анал азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian anal asian"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.75%) |
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.