Query Metrics
7
Database Queries
7
Different statements
153.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.35 ms (83.53%) |
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 33781 34104 38857 75626 181096 187699 191509 365293 369221 382490 382731 386028 387677 389057 389602 390209 390275 395949 401000 401801 422824 423387 423844 426429 426668 426777 428793 432458 432477 432486 432507 432517 433792 437587 439600 448679 459532 465602 472624 476768 481960 485065 492905 499467 510819 515736 531390 534017 535315 538548 539438 544024 549682 551943 553685 554053 554887 555137 556471 559807 561836 563330 582997 587789 589400 589587 592968 593340 600023 605232 607288 607583 607607 614467 626247 626647 641940 643032 645939 646105 657788 672843 673204 689621 702367 704149 709646 715451 716187 718054 723035 725108 726166 729841 730772 738120 741724 750034 754303 754321 754347 754537 755966 764051 774105 776816 787212 791029 797245 797275 800666 800920 807349 810454 811336 811496 828449 828451 828769 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (9.51%) |
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 582997 556471 709646 38857 828451 800666 34104 626647 626247 555137 432517 645939 607583 741724 422824 559807 390209 551943 607607 811336 561836 433792 539438 428793 439600 589400 614467 538548 716187 715451 535315 828449 643032 382490 689621 776816 764051 729841 750034 811496 481960 510819 369221 459532 448679 554887 723035 754303 791029 544024 549682 828527 531390 476768 657788 563330 600023 401801 465602 389057 75626 754321 389602 704149 673204 702367 589587 797245 807349 738120 800920 181096 426668 672843 587789 187699 387677 423387 485065 492905 553685 726166 725108 432486 432507 534017 423844 365293 499467 437587 592968 386028 382731 401000 605232 774105 810454 730772 593340 718054 426429 426777 472624 432458 432477 515736 554053 33781 395949 641940 797275 755966 754347 754537 787212 390275 191509 646105 828769 607288 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.15%) |
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 33781 34104 38857 75626 181096 187699 191509 365293 369221 382490 382731 386028 387677 389057 389602 390209 390275 395949 401000 401801 422824 423387 423844 426429 426668 426777 428793 432458 432477 432486 432507 432517 433792 437587 439600 448679 459532 465602 472624 476768 481960 485065 492905 499467 510819 515736 531390 534017 535315 538548 539438 544024 549682 551943 553685 554053 554887 555137 556471 559807 561836 563330 582997 587789 589400 589587 592968 593340 600023 605232 607288 607583 607607 614467 626247 626647 641940 643032 645939 646105 657788 672843 673204 689621 702367 704149 709646 715451 716187 718054 723035 725108 726166 729841 730772 738120 741724 750034 754303 754321 754347 754537 755966 764051 774105 776816 787212 791029 797245 797275 800666 800920 807349 810454 811336 811496 828449 828451 828769 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings tits"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 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.