Query Metrics
7
Database Queries
7
Different statements
167.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.92 ms (85.14%) |
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 75762 232995 382287 387556 388438 392449 392964 393408 395513 395929 396758 404302 408465 409027 411419 411588 415342 417509 420320 423033 426096 426480 431321 432679 439638 439679 440966 441295 442353 446731 448055 451705 453129 453981 458716 462698 467841 474863 475505 476252 477991 482299 484425 484460 485687 490567 501838 501901 502717 504173 507005 508000 508746 511808 513503 513525 515160 515182 515841 516817 517265 517554 522792 523731 526030 526483 528320 531903 539497 541879 544300 548559 548642 548712 549968 551627 552179 557571 558033 558245 562887 563066 563142 563233 569291 572766 589661 630572 632930 648259 663404 669200 673963 706286 710933 716296 730550 731194 734102 741268 747398 747993 780609 786172 788461 788787 789889 789984 801937 803991 807068 807551 808017 811863 814364 815944 816892 818907 820228 823608 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (8.71%) |
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 747398 706286 710933 789889 807551 811863 423033 475505 395929 484425 516817 541879 515160 395513 387556 426480 431321 453129 511808 485687 563066 563233 562887 409027 415342 411588 426096 396758 411419 522792 523731 515841 589661 818907 526483 630572 788787 741268 747993 632930 780609 788461 801937 232995 75762 388438 432679 441295 417509 451705 482299 458716 453981 539497 528320 517265 558245 548712 552179 572766 563142 569291 648259 669200 673963 663404 808017 731194 786172 392964 408465 501838 502717 462698 548642 504173 382287 820228 816892 815944 823608 716296 789984 807068 734102 730550 803991 467841 393408 420320 474863 476252 446731 517554 557571 440966 477991 404302 439638 439679 448055 513525 508746 484460 501901 513503 392449 442353 814364 490567 526030 531903 507005 508000 515182 544300 551627 548559 549968 558033 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (2.43%) |
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 75762 232995 382287 387556 388438 392449 392964 393408 395513 395929 396758 404302 408465 409027 411419 411588 415342 417509 420320 423033 426096 426480 431321 432679 439638 439679 440966 441295 442353 446731 448055 451705 453129 453981 458716 462698 467841 474863 475505 476252 477991 482299 484425 484460 485687 490567 501838 501901 502717 504173 507005 508000 508746 511808 513503 513525 515160 515182 515841 516817 517265 517554 522792 523731 526030 526483 528320 531903 539497 541879 544300 548559 548642 548712 549968 551627 552179 557571 558033 558245 562887 563066 563142 563233 569291 572766 589661 630572 632930 648259 663404 669200 673963 706286 710933 716296 730550 731194 734102 741268 747398 747993 780609 786172 788461 788787 789889 789984 801937 803991 807068 807551 808017 811863 814364 815944 816892 818907 820228 823608 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young ван"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young in bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young ван"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.78%) |
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.