Query Metrics
7
Database Queries
7
Different statements
209.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.04 ms (86.93%) |
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 207775 232978 381994 383464 384457 388780 391419 395227 396033 396070 397935 398651 401378 419299 419990 421376 421806 423548 423605 424582 425352 431593 434278 435413 435743 437150 441289 441584 441958 444370 449545 449894 450448 451275 452429 455871 455991 458293 458371 459055 465291 468426 474039 476489 484003 485254 488242 492622 492966 499721 500413 504005 508104 509209 509725 518164 521030 524138 527619 528129 541868 546423 546826 564133 569497 576501 584068 587332 587609 590517 591870 591943 593571 593780 593806 594282 604215 609811 616501 632246 640807 656548 661987 670908 676612 677189 683584 700309 703591 709896 710002 714091 720140 738502 738854 752147 756875 757135 758264 761143 761596 761712 762817 764161 764165 764234 772084 773847 776204 792316 794384 803371 804935 806301 809015 813482 814437 814728 819857 825553 ] |
||||||||||||||||||||||||||||||
|
16.55 ms (7.90%) |
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 803371 809015 207775 459055 431593 474039 383464 384457 395227 381994 391419 397935 423605 435413 444370 421806 421376 437150 825553 450448 468426 465291 485254 488242 500413 504005 524138 541868 564133 576501 584068 661987 703591 714091 656548 676612 677189 700309 710002 670908 683584 720140 546423 546826 569497 591870 593571 593806 609811 591943 593780 616501 590517 594282 587332 587609 604215 640807 776204 792316 806301 757135 772084 804935 813482 758264 761143 738854 756875 764161 764165 738502 752147 762817 764234 761596 761712 773847 632246 709896 794384 441584 455871 232978 398651 423548 424582 508104 518164 388780 396070 396033 401378 425352 435743 441289 419299 434278 419990 441958 814437 819857 814728 449894 455991 492622 492966 451275 452429 458293 484003 449545 458371 476489 499721 509209 509725 528129 527619 521030 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie riding"
]
|
||||||||||||||||||||||||||||||
|
2.25 ms (1.07%) |
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 207775 232978 381994 383464 384457 388780 391419 395227 396033 396070 397935 398651 401378 419299 419990 421376 421806 423548 423605 424582 425352 431593 434278 435413 435743 437150 441289 441584 441958 444370 449545 449894 450448 451275 452429 455871 455991 458293 458371 459055 465291 468426 474039 476489 484003 485254 488242 492622 492966 499721 500413 504005 508104 509209 509725 518164 521030 524138 527619 528129 541868 546423 546826 564133 569497 576501 584068 587332 587609 590517 591870 591943 593571 593780 593806 594282 604215 609811 616501 632246 640807 656548 661987 670908 676612 677189 683584 700309 703591 709896 710002 714091 720140 738502 738854 752147 756875 757135 758264 761143 761596 761712 762817 764161 764165 764234 772084 773847 776204 792316 794384 803371 804935 806301 809015 813482 814437 814728 819857 825553 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie riding"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie riding"
]
|
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.