Query Metrics
7
Database Queries
7
Different statements
361.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.68 ms (58.51%) |
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 397542 412841 416428 424918 427373 428082 431731 432235 440606 441971 442586 444843 444964 446921 449545 450676 451494 452962 453984 453993 455047 455477 455478 456122 457909 457922 458781 461775 461887 462058 463394 468991 478275 485111 487051 490417 500505 505389 506072 507214 509812 511242 527440 534722 535536 536147 539335 544600 546223 548055 556888 557193 558562 559275 560522 562482 563300 563785 571820 574068 578182 578745 579576 580672 581064 586463 587721 588317 591358 594557 609811 609998 610322 612703 615686 621477 621485 623947 626330 628948 644785 666055 667917 683073 684511 684695 695048 696484 700715 700727 707436 707510 709435 714868 723369 725062 726941 729049 730800 737996 738818 741655 741785 744513 756659 757590 759762 763590 779666 784039 792428 793820 794161 794176 794396 796343 802150 807462 808236 813904 ] |
||||||||||||||||||||||||||||||
|
128.85 ms (35.61%) |
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 397542 412841 416428 424918 427373 428082 431731 432235 440606 441971 442586 444843 444964 446921 449545 450676 451494 452962 453984 453993 455047 455477 455478 456122 457909 457922 458781 461775 461887 462058 463394 468991 478275 485111 487051 490417 500505 505389 506072 507214 509812 511242 527440 534722 535536 536147 539335 544600 546223 548055 556888 557193 558562 559275 560522 562482 563300 563785 571820 574068 578182 578745 579576 580672 581064 586463 587721 588317 591358 594557 609811 609998 610322 612703 615686 621477 621485 623947 626330 628948 644785 666055 667917 683073 684511 684695 695048 696484 700715 700727 707436 707510 709435 714868 723369 725062 726941 729049 730800 737996 738818 741655 741785 744513 756659 757590 759762 763590 779666 784039 792428 793820 794161 794176 794396 796343 802150 807462 808236 813904 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (4.20%) |
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 792428 794176 796343 725062 757590 729049 737996 738818 741785 744513 615686 709435 779666 794396 463394 427373 442586 416428 511242 458781 446921 556888 571820 580672 558562 700727 696484 667917 586463 457909 397542 412841 432235 441971 444964 450676 455478 457922 462058 455477 456122 461887 461775 535536 500505 505389 507214 560522 579576 581064 578745 723369 684511 707510 695048 700715 546223 548055 559275 587721 609811 644785 623947 793820 802150 794161 741655 763590 807462 808236 730800 759762 726941 756659 784039 440606 424918 451494 478275 527440 509812 431731 428082 444843 813904 453984 455047 487051 453993 485111 449545 452962 534722 536147 506072 539335 468991 490417 557193 574068 544600 562482 563300 707436 666055 683073 684695 714868 563785 578182 588317 609998 612703 621477 621485 628948 594557 610322 626330 591358 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy cum inside"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy cum inside"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy cum inside"
]
|
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.