Query Metrics
7
Database Queries
7
Different statements
169.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.55 ms (82.85%) |
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 7891 81065 396088 396314 396408 397299 402351 406890 412220 413472 418365 419147 426862 427149 428104 433404 434836 436343 437419 437790 439446 439450 447140 447830 450567 450779 452429 455042 456797 458511 458526 459969 460370 460814 463397 474813 484088 488297 491175 495280 496124 499556 500519 500553 504516 505550 510478 512594 512599 524395 529115 530216 539372 541582 542345 543489 556553 556766 560320 560791 562424 565859 579664 584127 586175 590807 591827 594536 598300 603354 604836 605396 606332 612581 619867 625582 627333 627841 636449 641227 650034 668770 677064 715370 718980 720083 722154 723155 723432 725451 726965 731697 735867 738336 741808 744581 746604 747128 757145 761459 763146 763561 764574 764638 767399 767403 767653 775009 775013 782409 790681 790746 792062 794037 795862 796243 797474 803258 803604 809743 ] |
||||||||||||||||||||||||||||||
|
17.93 ms (10.57%) |
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 720083 603354 795862 790681 797474 767653 741808 747128 746604 763146 767399 731697 738336 767403 606332 641227 790746 529115 500519 500553 562424 722154 586175 782409 796243 809743 757145 764638 726965 763561 619867 7891 396408 402351 437419 463397 434836 499556 496124 543489 715370 668770 723432 604836 590807 627841 775009 775013 744581 764574 794037 627333 406890 436343 412220 530216 439450 413472 439446 433404 452429 447830 459969 495280 460814 556766 542345 723155 718980 579664 598300 792062 735867 803258 803604 427149 81065 396088 418365 450779 491175 524395 397299 437790 456797 458526 450567 556553 584127 541582 560320 650034 677064 565859 591827 594536 725451 761459 636449 428104 474813 426862 488297 484088 512594 512599 460370 396314 419147 455042 447140 458511 504516 505550 510478 539372 560791 625582 605396 612581 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.53%) |
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 7891 81065 396088 396314 396408 397299 402351 406890 412220 413472 418365 419147 426862 427149 428104 433404 434836 436343 437419 437790 439446 439450 447140 447830 450567 450779 452429 455042 456797 458511 458526 459969 460370 460814 463397 474813 484088 488297 491175 495280 496124 499556 500519 500553 504516 505550 510478 512594 512599 524395 529115 530216 539372 541582 542345 543489 556553 556766 560320 560791 562424 565859 579664 584127 586175 590807 591827 594536 598300 603354 604836 605396 606332 612581 619867 625582 627333 627841 636449 641227 650034 668770 677064 715370 718980 720083 722154 723155 723432 725451 726965 731697 735867 738336 741808 744581 746604 747128 757145 761459 763146 763561 764574 764638 767399 767403 767653 775009 775013 782409 790681 790746 792062 794037 795862 796243 797474 803258 803604 809743 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"load cum"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"load cum"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"load cum"
]
|
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.