Query Metrics
7
Database Queries
7
Different statements
202.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.85 ms (87.29%) |
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 437451 437470 453495 492565 503825 505451 516332 517840 520840 522882 523027 531117 532751 533382 536538 543850 543867 545389 545409 545410 545488 557158 557685 565245 566786 566789 571213 583677 585012 601548 601803 608744 617427 617428 620103 620785 632601 632674 633070 634198 635185 643103 644275 644300 645861 645964 647898 647939 648560 649543 651003 651422 653362 653807 660299 661891 666798 666841 668881 673361 673369 677307 677705 681020 683291 683301 683963 684126 689305 692450 695188 696009 697136 699631 703037 703055 703095 703097 707333 724230 747017 748895 757544 759910 761425 764071 767399 770322 770788 775054 775492 775798 775896 775981 776316 778366 780637 780701 792831 796683 800274 801472 801927 802001 802471 803399 803906 806804 807617 809574 809941 814893 816015 816317 816938 817348 817446 818932 820774 823920 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (7.32%) |
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 775896 536538 780701 818932 695188 666841 759910 532751 677307 492565 565245 666798 653807 668881 809574 505451 816938 566789 648560 689305 807617 583677 816015 816317 653362 683291 683963 645964 660299 684126 697136 633070 778366 792831 770322 780637 796683 545488 634198 585012 557158 681020 620103 775981 800274 761425 757544 801927 437470 817446 814893 820774 677705 649543 632674 635185 806804 531117 747017 617427 776316 566786 643103 775054 809941 522882 699631 823920 557685 802001 651422 803906 770788 632601 608744 803399 817348 748895 764071 775492 517840 647898 801472 520840 533382 617428 802471 437451 673361 545409 523027 724230 696009 673369 703037 703095 661891 703055 545389 545410 503825 703097 775798 620785 644275 453495 645861 543850 601803 543867 516332 707333 692450 644300 683301 767399 601548 571213 647939 651003 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (1.77%) |
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 437451 437470 453495 492565 503825 505451 516332 517840 520840 522882 523027 531117 532751 533382 536538 543850 543867 545389 545409 545410 545488 557158 557685 565245 566786 566789 571213 583677 585012 601548 601803 608744 617427 617428 620103 620785 632601 632674 633070 634198 635185 643103 644275 644300 645861 645964 647898 647939 648560 649543 651003 651422 653362 653807 660299 661891 666798 666841 668881 673361 673369 677307 677705 681020 683291 683301 683963 684126 689305 692450 695188 696009 697136 699631 703037 703055 703095 703097 707333 724230 747017 748895 757544 759910 761425 764071 767399 770322 770788 775054 775492 775798 775896 775981 776316 778366 780637 780701 792831 796683 800274 801472 801927 802001 802471 803399 803906 806804 807617 809574 809941 814893 816015 816317 816938 817348 817446 818932 820774 823920 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double минет оральн секс дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double минет оральн секс дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double blowjob handjob"
]
|
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.