Query Metrics
7
Database Queries
7
Different statements
423.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
392.52 ms (92.71%) |
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 181693 285321 304300 393136 401062 402252 402557 403283 418655 433676 435610 438397 441691 444880 444894 447334 449321 449326 453839 456147 464251 473523 484286 484514 489207 492276 493339 496317 504515 513692 519496 524844 529500 534430 536072 543431 548418 551952 552037 554791 558808 559320 566301 569851 574030 581377 582492 586744 587134 591527 598566 603014 605387 606054 609402 610520 615451 623812 625708 630129 660342 660346 665600 666669 666724 668016 672776 674285 679098 679676 680754 681526 692669 693779 699674 700663 705368 713152 724448 726816 726891 734613 735581 736476 739021 740848 741785 742031 750090 751110 759705 769998 770775 776784 777463 777782 778498 778529 782618 784297 784453 784664 785255 795102 795998 796682 797046 800791 802519 803335 804641 806362 806413 806878 807881 809922 812496 815505 816255 826931 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (3.74%) |
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 666724 674285 680754 692669 548418 586744 587134 605387 778498 784453 803335 809922 726816 750090 759705 769998 735581 770775 630129 777463 777782 812496 433676 456147 435610 447334 403283 713152 826931 815505 679098 551952 623812 554791 615451 736476 751110 402557 304300 816255 543431 700663 784297 402252 529500 552037 609402 800791 804641 802519 806878 742031 504515 524844 438397 449326 484286 513692 489207 519496 496317 534430 536072 492276 569851 582492 574030 681526 699674 598566 603014 795102 806413 734613 726891 776784 796682 401062 453839 464251 181693 393136 285321 418655 441691 444894 444880 449321 484514 473523 493339 558808 668016 666669 679676 660342 660346 665600 672776 693779 559320 566301 581377 606054 591527 610520 625708 778529 782618 806362 807881 724448 740848 784664 785255 795998 739021 741785 705368 797046 ] |
||||||||||||||||||||||||||||||
|
5.03 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.32 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрые pussy секс"
]
|
||||||||||||||||||||||||||||||
|
3.07 ms (0.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 181693 285321 304300 393136 401062 402252 402557 403283 418655 433676 435610 438397 441691 444880 444894 447334 449321 449326 453839 456147 464251 473523 484286 484514 489207 492276 493339 496317 504515 513692 519496 524844 529500 534430 536072 543431 548418 551952 552037 554791 558808 559320 566301 569851 574030 581377 582492 586744 587134 591527 598566 603014 605387 606054 609402 610520 615451 623812 625708 630129 660342 660346 665600 666669 666724 668016 672776 674285 679098 679676 680754 681526 692669 693779 699674 700663 705368 713152 724448 726816 726891 734613 735581 736476 739021 740848 741785 742031 750090 751110 759705 769998 770775 776784 777463 777782 778498 778529 782618 784297 784453 784664 785255 795102 795998 796682 797046 800791 802519 803335 804641 806362 806413 806878 807881 809922 812496 815505 816255 826931 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wet pussy fuck"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мокрые pussy секс"
]
|
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.