Query Metrics
7
Database Queries
7
Different statements
243.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.70 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"but milf hard"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.77 ms |
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 490641 504214 465472 583756 724636 453261 388150 407339 443160 815808 815844 824283 817100 819773 820014 825163 827431 815182 815452 819160 819505 821126 824706 825254 826231 813924 820060 823890 450686 459638 463868 493578 536972 501073 531765 494760 497840 506257 537237 467360 559176 577599 562899 564578 564682 549129 550242 550276 562186 645836 652803 654187 693286 696599 702288 714799 648183 680284 689529 697185 712647 650051 651253 697192 708164 716697 720588 549393 587160 587689 593023 602595 608980 625818 603113 603589 617835 618751 776584 780048 780849 794859 795191 797043 799717 811655 811691 776642 778111 778281 793113 794160 796039 796749 803082 803242 804493 811469 729835 733160 736231 738410 740000 740048 748081 748198 757287 763570 783116 786858 788565 789110 791506 791585 793487 793564 795180 796157 799996 800101 ] |
||||||||||||||||||||||||||||||
| 4 | 4.02 ms |
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 388150 407339 443160 450686 453261 459638 463868 465472 467360 490641 493578 494760 497840 501073 504214 506257 531765 536972 537237 549129 549393 550242 550276 559176 562186 562899 564578 564682 577599 583756 587160 587689 593023 602595 603113 603589 608980 617835 618751 625818 645836 648183 650051 651253 652803 654187 680284 689529 693286 696599 697185 697192 702288 708164 712647 714799 716697 720588 724636 729835 733160 736231 738410 740000 740048 748081 748198 757287 763570 776584 776642 778111 778281 780048 780849 783116 786858 788565 789110 791506 791585 793113 793487 793564 794160 794859 795180 795191 796039 796157 796749 797043 799717 799996 800101 803082 803242 804493 811469 811655 811691 813924 815452 815808 815844 817100 819160 819505 819773 820014 820060 821126 823890 824283 824706 825163 825254 826231 827431 ] |
||||||||||||||||||||||||||||||
| 5 | 220.39 ms |
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 388150 407339 443160 450686 453261 459638 463868 465472 467360 490641 493578 494760 497840 501073 504214 506257 531765 536972 537237 549129 549393 550242 550276 559176 562186 562899 564578 564682 577599 583756 587160 587689 593023 602595 603113 603589 608980 617835 618751 625818 645836 648183 650051 651253 652803 654187 680284 689529 693286 696599 697185 697192 702288 708164 712647 714799 716697 720588 724636 729835 733160 736231 738410 740000 740048 748081 748198 757287 763570 776584 776642 778111 778281 780048 780849 783116 786858 788565 789110 791506 791585 793113 793487 793564 794160 794859 795180 795191 796039 796157 796749 797043 799717 799996 800101 803082 803242 804493 811469 811655 811691 813924 815452 815808 815844 817100 819160 819505 819773 820014 820060 821126 823890 824283 824706 825163 825254 826231 827431 ] |
||||||||||||||||||||||||||||||
| 6 | 1.85 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf hard"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.67 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf hard"
]
|
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.