Query Metrics
7
Database Queries
7
Different statements
195.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.50 ms (88.28%) |
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 390771 392978 400579 417107 417471 418155 425192 427112 434885 435798 436648 445764 449102 450437 452695 455882 457486 458909 459075 461604 462860 466553 473535 476637 488179 488594 490351 494896 500689 500745 502447 504594 505327 510729 510737 511633 518014 518309 520363 522755 545712 546057 552180 552250 552988 553210 555400 558573 565834 566395 571312 573936 583510 585554 587967 589945 590806 593076 594254 599409 601814 604056 605393 610365 617580 617583 618479 618799 619509 619573 622791 626902 637186 637959 641779 644821 661590 662383 662842 668814 671558 672345 673874 674475 677240 691989 702962 706442 707900 716229 720200 722216 733437 733852 734466 742641 744251 750728 753895 760697 765398 767116 776963 781609 782057 783391 784409 784596 788779 792441 797918 800041 800513 801722 808100 808562 809729 824362 827653 827785 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (6.36%) |
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 661590 784596 742641 449102 494896 502447 490351 450437 473535 518014 488594 565834 573936 553210 594254 619573 434885 466553 510729 522755 520363 552180 668814 800041 797918 392978 425192 824362 452695 583510 662842 702962 808562 733852 750728 765398 476637 500689 518309 782057 417107 504594 505327 604056 605393 626902 511633 436648 417471 644821 827653 546057 673874 706442 671558 622791 637186 610365 590806 781609 809729 783391 788779 801722 808100 400579 488179 566395 552250 599409 618799 734466 459075 555400 619509 617580 753895 674475 418155 827785 455882 500745 462860 571312 720200 722216 589945 618479 641779 617583 585554 587967 593076 776963 792441 733437 760697 707900 784409 510737 390771 457486 461604 558573 677240 691989 716229 601814 637959 767116 800513 435798 427112 445764 458909 552988 545712 662383 672345 744251 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.73%) |
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 390771 392978 400579 417107 417471 418155 425192 427112 434885 435798 436648 445764 449102 450437 452695 455882 457486 458909 459075 461604 462860 466553 473535 476637 488179 488594 490351 494896 500689 500745 502447 504594 505327 510729 510737 511633 518014 518309 520363 522755 545712 546057 552180 552250 552988 553210 555400 558573 565834 566395 571312 573936 583510 585554 587967 589945 590806 593076 594254 599409 601814 604056 605393 610365 617580 617583 618479 618799 619509 619573 622791 626902 637186 637959 641779 644821 661590 662383 662842 668814 671558 672345 673874 674475 677240 691989 702962 706442 707900 716229 720200 722216 733437 733852 734466 742641 744251 750728 753895 760697 765398 767116 776963 781609 782057 783391 784409 784596 788779 792441 797918 800041 800513 801722 808100 808562 809729 824362 827653 827785 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina sex orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин секс orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин секс orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.