Query Metrics
7
Database Queries
7
Different statements
183.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.38 ms (84.16%) |
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 393391 398909 400839 404710 410272 411344 415926 430446 432704 447025 448825 452254 452977 457294 457469 464959 466404 469092 470064 475410 475414 476176 476676 477424 478215 480393 501557 502043 504980 508442 509983 509988 512938 515358 516574 516686 517004 519497 519825 521681 522184 522785 523885 525634 533186 535010 535332 537195 539319 541602 543374 550128 550579 550643 550672 555722 561970 565127 569750 570099 571194 576690 582277 583223 583508 584118 585007 591692 593363 595041 595176 596235 599359 599967 600021 600173 600354 600798 601448 604627 604865 604918 606636 607599 614858 617418 622366 630546 634131 637442 639722 639741 640751 649949 652190 652316 667748 699397 702061 716878 750611 751565 751582 760649 763724 770123 772573 775539 780375 785909 786120 803129 803455 807589 807619 808151 809009 815370 816086 819235 ] |
||||||||||||||||||||||||||||||
|
18.96 ms (10.34%) |
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 807589 809009 775539 785909 751582 770123 607599 807619 404710 522184 516574 522785 593363 604865 452977 523885 509988 515358 699397 637442 614858 640751 411344 512938 519497 599359 585007 815370 452254 537195 519825 533186 464959 569750 550672 600173 600798 595176 803129 772573 760649 808151 476176 447025 599967 539319 667748 803455 477424 432704 475414 509983 398909 630546 600021 751565 502043 521681 535332 393391 457294 525634 652316 570099 780375 750611 763724 478215 430446 508442 476676 561970 583508 601448 819235 652190 535010 470064 816086 457469 541602 634131 591692 617418 600354 596235 702061 475410 480393 584118 555722 571194 550643 649949 583223 604918 504980 639722 516686 639741 466404 582277 410272 543374 550128 576690 550579 716878 595041 786120 448825 604627 400839 415926 469092 565127 606636 622366 501557 517004 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.62%) |
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 393391 398909 400839 404710 410272 411344 415926 430446 432704 447025 448825 452254 452977 457294 457469 464959 466404 469092 470064 475410 475414 476176 476676 477424 478215 480393 501557 502043 504980 508442 509983 509988 512938 515358 516574 516686 517004 519497 519825 521681 522184 522785 523885 525634 533186 535010 535332 537195 539319 541602 543374 550128 550579 550643 550672 555722 561970 565127 569750 570099 571194 576690 582277 583223 583508 584118 585007 591692 593363 595041 595176 596235 599359 599967 600021 600173 600354 600798 601448 604627 604865 604918 606636 607599 614858 617418 622366 630546 634131 637442 639722 639741 640751 649949 652190 652316 667748 699397 702061 716878 750611 751565 751582 760649 763724 770123 772573 775539 780375 785909 786120 803129 803455 807589 807619 808151 809009 815370 816086 819235 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom дилд toys"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom дилд toys"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom dildo toys"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
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.