Query Metrics
7
Database Queries
7
Different statements
161.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.63 ms (82.14%) |
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 400334 403843 411535 418589 419453 420898 423338 435635 437368 437382 438465 438634 438648 446578 449584 450020 450038 450074 450076 451305 452902 461418 469162 478370 478520 478983 480019 487548 496828 497720 499531 499711 504617 509584 510737 513801 513831 518121 518885 523156 524369 525435 526460 527474 528144 529505 529997 544057 545334 556096 558143 563363 567217 569594 571341 577458 592355 638878 648444 651758 658924 660434 661590 662425 672822 677838 680822 688914 698882 700468 703021 703945 704334 704687 709006 709510 739827 741824 750662 751274 751283 751389 752713 753193 757215 758078 760697 764728 765887 773059 777782 782539 782894 783319 784513 784732 785012 785267 785348 786079 786088 786432 786912 787526 787771 787850 791500 793230 794841 796392 796452 797082 801804 807066 807255 808540 808562 808971 810461 811125 ] |
||||||||||||||||||||||||||||||
|
18.12 ms (11.22%) |
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 786912 787526 787771 791500 808540 808562 810461 785267 794841 797082 808971 741824 764728 782539 782894 783319 784513 785348 786079 786088 786432 793230 796392 801804 807255 752713 773059 750662 751389 760697 765887 739827 751274 751283 753193 757215 758078 638878 703021 703945 704687 777782 784732 785012 787850 796452 807066 403843 438465 437382 450020 478520 438648 525435 499531 518121 510737 423338 452902 563363 569594 677838 592355 437368 478370 513831 509584 487548 496828 499711 518885 528144 544057 811125 446578 420898 529505 400334 418589 411535 419453 435635 438634 450076 478983 451305 461418 469162 480019 449584 450038 450074 504617 524369 526460 497720 529997 513801 523156 527474 556096 567217 571341 545334 558143 577458 658924 661590 698882 700468 709006 709510 648444 662425 680822 704334 651758 660434 672822 688914 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.01%) |
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 400334 403843 411535 418589 419453 420898 423338 435635 437368 437382 438465 438634 438648 446578 449584 450020 450038 450074 450076 451305 452902 461418 469162 478370 478520 478983 480019 487548 496828 497720 499531 499711 504617 509584 510737 513801 513831 518121 518885 523156 524369 525435 526460 527474 528144 529505 529997 544057 545334 556096 558143 563363 567217 569594 571341 577458 592355 638878 648444 651758 658924 660434 661590 662425 672822 677838 680822 688914 698882 700468 703021 703945 704334 704687 709006 709510 739827 741824 750662 751274 751283 751389 752713 753193 757215 758078 760697 764728 765887 773059 777782 782539 782894 783319 784513 784732 785012 785267 785348 786079 786088 786432 786912 787526 787771 787850 791500 793230 794841 796392 796452 797082 801804 807066 807255 808540 808562 808971 810461 811125 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam solo orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер соло orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер соло orgasm"
]
|
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.