Query Metrics
7
Database Queries
7
Different statements
146.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.97 ms (83.27%) |
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 214988 384761 386323 387647 390207 391190 393043 398018 398275 398354 398847 403904 404278 408047 410265 412038 413732 416294 422747 423019 423060 423202 429547 429698 429936 446355 457752 457812 468753 472949 473755 473774 499041 499818 510595 512182 515883 539946 540187 546039 550639 550727 550772 550996 551978 552931 554423 554866 556412 557114 557206 559898 566013 566014 568553 577184 579389 584339 586542 586624 588060 593606 595641 596519 597823 610531 614529 615713 619474 620511 622200 622652 623510 632682 635351 642442 642816 643671 645571 652126 676542 677581 677620 680900 687021 695565 699602 702343 713877 714848 725751 727656 729094 735387 737900 739480 743897 744884 748639 748682 755328 761537 761571 761582 763068 767327 770273 771830 771876 772487 778141 785191 786928 793739 793934 811015 813659 815717 823295 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (10.04%) |
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 413732 429547 546039 550639 551978 566013 550772 619474 410265 416294 457752 472949 510595 387647 398275 473755 550996 568553 577184 566014 390207 499818 515883 473774 556412 632682 468753 767327 614529 559898 687021 597823 743897 770273 398847 512182 552931 676542 627735 785191 772487 823295 554423 695565 714848 677620 680900 643671 610531 786928 744884 748639 763068 793934 579389 813659 539946 554866 584339 677581 586542 622200 615713 595641 727656 737900 735387 771830 739480 771876 699602 702343 398018 423019 815717 645571 557206 596519 620511 793739 811015 729094 748682 725751 755328 778141 412038 391190 713877 635351 550727 386323 540187 429698 499041 642816 761571 761537 761582 623510 393043 422747 423202 457812 557114 652126 622652 586624 642442 588060 404278 429936 408047 384761 593606 214988 398354 403904 423060 446355 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (2.01%) |
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 214988 384761 386323 387647 390207 391190 393043 398018 398275 398354 398847 403904 404278 408047 410265 412038 413732 416294 422747 423019 423060 423202 429547 429698 429936 446355 457752 457812 468753 472949 473755 473774 499041 499818 510595 512182 515883 539946 540187 546039 550639 550727 550772 550996 551978 552931 554423 554866 556412 557114 557206 559898 566013 566014 568553 577184 579389 584339 586542 586624 588060 593606 595641 596519 597823 610531 614529 615713 619474 620511 622200 622652 623510 632682 635351 642442 642816 643671 645571 652126 676542 677581 677620 680900 687021 695565 699602 702343 713877 714848 725751 727656 729094 735387 737900 739480 743897 744884 748639 748682 755328 761537 761571 761582 763068 767327 770273 771830 771876 772487 778141 785191 786928 793739 793934 811015 813659 815717 823295 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex asian"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
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.