Query Metrics
7
Database Queries
7
Different statements
180.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.04 ms (86.83%) |
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 2258 33562 80999 312616 340206 381945 382703 382895 384440 386033 388512 388811 391084 391491 393049 395166 397835 415280 417954 419911 419927 422300 423750 424263 425496 434889 435835 436066 443461 451614 452623 460109 466587 466593 469333 472296 475943 479432 483159 484466 487248 488844 494284 494686 503034 517746 519670 521496 529425 530610 532259 541549 541899 554931 555125 562718 564035 565086 565598 581067 591885 595695 595715 596665 597602 598624 600669 602973 627635 639938 644148 648169 652470 656175 662386 670622 675841 686583 712244 712517 712552 712870 716601 716650 734234 738347 739596 740033 740038 744869 747646 763538 763626 764522 766866 766903 767952 769667 778671 780853 781194 782402 783415 783704 784208 787111 788409 788965 791106 791679 793466 793746 797435 799335 803697 804824 806855 810226 811369 811451 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (7.66%) |
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 784208 764522 739596 744869 763538 769667 712517 781194 788409 803697 804824 562718 554931 783704 397835 806855 738347 763626 517746 712552 555125 740038 766866 652470 598624 791679 787111 799335 788965 541549 627635 386033 529425 675841 712870 600669 811451 767952 782402 793466 381945 388512 451614 530610 648169 595715 602973 810226 80999 716601 595695 780853 793746 494284 340206 415280 436066 565598 541899 656175 596665 639938 797435 734234 747646 766903 783415 791106 424263 581067 475943 519670 393049 391084 391491 434889 435835 422300 460109 479432 483159 564035 565086 686583 662386 670622 644148 597602 591885 811369 712244 778671 423750 452623 466587 395166 472296 417954 488844 312616 716650 740033 382895 384440 382703 33562 2258 388811 419927 425496 419911 443461 469333 484466 466593 487248 494686 503034 521496 532259 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.52%) |
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 2258 33562 80999 312616 340206 381945 382703 382895 384440 386033 388512 388811 391084 391491 393049 395166 397835 415280 417954 419911 419927 422300 423750 424263 425496 434889 435835 436066 443461 451614 452623 460109 466587 466593 469333 472296 475943 479432 483159 484466 487248 488844 494284 494686 503034 517746 519670 521496 529425 530610 532259 541549 541899 554931 555125 562718 564035 565086 565598 581067 591885 595695 595715 596665 597602 598624 600669 602973 627635 639938 644148 648169 652470 656175 662386 670622 675841 686583 712244 712517 712552 712870 716601 716650 734234 738347 739596 740033 740038 744869 747646 763538 763626 764522 766866 766903 767952 769667 778671 780853 781194 782402 783415 783704 784208 787111 788409 788965 791106 791679 793466 793746 797435 799335 803697 804824 806855 810226 811369 811451 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob kasar deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс kasar глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс kasar глубокийминет минет оральн секс"
]
|
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.