Query Metrics
7
Database Queries
7
Different statements
153.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.62 ms (80.54%) |
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 182118 391986 392687 399083 400638 402649 404028 410686 413388 414071 414125 414157 414271 414306 414374 418112 418989 424574 426511 430353 432289 432656 441095 443242 443243 446695 448464 451042 451252 451337 452136 452953 454000 458007 460804 464971 465470 467882 468664 470034 471124 471668 473743 480454 481943 482773 482776 484673 486761 486767 486775 486831 493122 493840 495126 496340 497905 500902 505345 514235 518611 518766 521256 522187 529323 530011 530503 530659 531248 532729 536542 537894 541570 541832 541850 544964 546083 547488 555306 568379 573175 575300 576916 586407 594491 599894 599915 599916 600280 601575 606576 609097 614968 629808 632121 633111 633819 639717 639784 649583 650476 660399 665238 665957 666859 673035 705817 721103 722392 726315 738814 738827 747468 756192 768258 782804 802345 808155 811296 824577 ] |
||||||||||||||||||||||||||||||
|
20.32 ms (13.24%) |
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 432656 555306 541832 451042 452136 484673 458007 414271 443243 413388 432289 443242 448464 486775 464971 471124 481943 529323 496340 521256 522187 473743 660399 665957 546083 576916 811296 738814 614968 424574 467882 391986 402649 430353 451337 414125 426511 454000 505345 486831 518766 410686 414157 486767 514235 541570 573175 650476 609097 470034 480454 486761 824577 768258 802345 530503 537894 530011 599915 639784 633819 633111 639717 452953 493122 530659 482776 182118 400638 418112 418989 441095 414071 482773 446695 468664 493840 451252 495126 536542 531248 532729 497905 465470 547488 541850 575300 673035 705817 721103 649583 665238 666859 544964 599894 606576 594491 600280 629808 599916 601575 808155 782804 756192 747468 726315 738827 632121 722392 399083 392687 404028 460804 414306 500902 568379 518611 586407 414374 471668 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.86%) |
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 182118 391986 392687 399083 400638 402649 404028 410686 413388 414071 414125 414157 414271 414306 414374 418112 418989 424574 426511 430353 432289 432656 441095 443242 443243 446695 448464 451042 451252 451337 452136 452953 454000 458007 460804 464971 465470 467882 468664 470034 471124 471668 473743 480454 481943 482773 482776 484673 486761 486767 486775 486831 493122 493840 495126 496340 497905 500902 505345 514235 518611 518766 521256 522187 529323 530011 530503 530659 531248 532729 536542 537894 541570 541832 541850 544964 546083 547488 555306 568379 573175 575300 576916 586407 594491 599894 599915 599916 600280 601575 606576 609097 614968 629808 632121 633111 633819 639717 639784 649583 650476 660399 665238 665957 666859 673035 705817 721103 722392 726315 738814 738827 747468 756192 768258 782804 802345 808155 811296 824577 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature huge dildo"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature огромные дилд"
]
|
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.