Query Metrics
7
Database Queries
7
Different statements
199.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.74 ms (88.51%) |
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 395311 405048 423338 425395 427432 428062 436756 438276 440485 440867 441943 446537 449546 455297 457563 462681 465439 470810 471554 475560 478986 485622 492135 502194 505344 507608 509054 509907 520608 523486 525247 526382 527079 527497 528222 531380 531937 532977 534354 538716 548373 551047 560182 562366 563834 565275 568163 568304 570832 577564 583564 585595 589945 593022 599318 604221 606912 609042 614018 616839 617625 621083 625435 628828 630736 639882 647296 647607 652278 657735 669347 672396 673187 675930 690884 699231 704673 705111 710092 710094 716364 725352 727407 736146 737334 737425 738464 743892 747533 747563 749618 757773 762199 763589 765394 765518 775002 776320 776581 780207 787286 789114 793279 793787 794975 795089 795192 795262 795919 797773 799659 800975 802800 806849 807347 816052 817688 822154 824320 825201 ] |
||||||||||||||||||||||||||||||
|
13.45 ms (6.74%) |
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 604221 625435 606912 776320 793279 743892 794975 749618 738464 780207 802800 427432 509907 527497 528222 593022 505344 570832 507608 577564 621083 471554 531380 562366 647296 789114 776581 470810 440867 609042 478986 457563 526382 428062 551047 710092 775002 793787 795192 817688 825201 647607 652278 673187 585595 599318 787286 795089 737334 765518 799659 727407 737425 806849 475560 509054 523486 548373 762199 747563 824320 589945 807347 405048 690884 699231 628828 736146 527079 525247 822154 563834 669347 672396 716364 614018 795919 800975 725352 797773 757773 763589 639882 438276 423338 436756 455297 534354 568163 565275 747533 765394 568304 630736 425395 440485 441943 446537 502194 532977 485622 395311 449546 520608 465439 795262 538716 462681 492135 816052 531937 675930 704673 705111 710094 657735 560182 583564 616839 617625 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.33%) |
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 395311 405048 423338 425395 427432 428062 436756 438276 440485 440867 441943 446537 449546 455297 457563 462681 465439 470810 471554 475560 478986 485622 492135 502194 505344 507608 509054 509907 520608 523486 525247 526382 527079 527497 528222 531380 531937 532977 534354 538716 548373 551047 560182 562366 563834 565275 568163 568304 570832 577564 583564 585595 589945 593022 599318 604221 606912 609042 614018 616839 617625 621083 625435 628828 630736 639882 647296 647607 652278 657735 669347 672396 673187 675930 690884 699231 704673 705111 710092 710094 716364 725352 727407 736146 737334 737425 738464 743892 747533 747563 749618 757773 762199 763589 765394 765518 775002 776320 776581 780207 787286 789114 793279 793787 794975 795089 795192 795262 795919 797773 799659 800975 802800 806849 807347 816052 817688 822154 824320 825201 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real big tits"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.45 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.