Query Metrics
7
Database Queries
7
Different statements
394.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.88 ms (53.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother orgasm"
]
|
||||||||||||||||||||||||||||||
|
159.32 ms (40.44%) |
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 383484 418879 425592 428685 429900 438655 453702 459634 467893 473369 473535 486775 492016 494068 501322 503999 504339 505061 506350 506584 506914 513450 516039 518014 521798 521799 525310 528541 534828 534925 535847 539078 542181 548085 550576 550859 551525 554930 555390 555560 564889 566788 571726 579218 579319 580355 584118 594989 597660 603897 605742 606197 606601 607288 608215 609057 609083 609696 613109 616072 616397 618589 622527 627414 629629 636477 636493 637186 642022 643380 646084 648918 657781 678834 689897 692733 698156 709524 710161 710849 713031 713749 728187 732771 733155 738247 744952 746748 748620 748626 750603 751329 756273 756658 761218 768517 771213 785148 788655 789023 789848 791921 792996 793218 794212 794416 794437 794453 795825 796384 801841 802267 808573 810070 811816 813206 813720 816691 824473 826601 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (3.93%) |
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 642022 605742 467893 506350 516039 521798 551525 418879 453702 826601 813720 459634 492016 501322 534828 534925 506584 521799 528541 535847 513450 525310 539078 579319 550576 550859 555560 542181 564889 692733 710849 698156 646084 657781 678834 713031 713749 597660 616397 627414 637186 606601 609696 636477 636493 613109 622527 629629 788655 789023 794453 801841 802267 795825 733155 744952 789848 796384 810070 813206 732771 748620 761218 748626 768517 728187 738247 746748 751329 616072 793218 794212 794437 811816 425592 383484 503999 429900 438655 824473 816691 473369 473535 494068 504339 505061 506914 518014 584118 580355 555390 648918 689897 548085 579218 607288 594989 643380 606197 608215 785148 794416 792996 808573 771213 756273 756658 750603 603897 618589 791921 428685 486775 571726 554930 566788 709524 710161 609057 609083 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.58%) |
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 383484 418879 425592 428685 429900 438655 453702 459634 467893 473369 473535 486775 492016 494068 501322 503999 504339 505061 506350 506584 506914 513450 516039 518014 521798 521799 525310 528541 534828 534925 535847 539078 542181 548085 550576 550859 551525 554930 555390 555560 564889 566788 571726 579218 579319 580355 584118 594989 597660 603897 605742 606197 606601 607288 608215 609057 609083 609696 613109 616072 616397 618589 622527 627414 629629 636477 636493 637186 642022 643380 646084 648918 657781 678834 689897 692733 698156 709524 710161 710849 713031 713749 728187 732771 733155 738247 744952 746748 748620 748626 750603 751329 756273 756658 761218 768517 771213 785148 788655 789023 789848 791921 792996 793218 794212 794416 794437 794453 795825 796384 801841 802267 808573 810070 811816 813206 813720 816691 824473 826601 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин orgasm"
]
|
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.