Query Metrics
7
Database Queries
7
Different statements
176.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.38 ms (88.85%) |
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 2808 51972 233500 366284 389749 397388 401575 404178 417293 423527 424146 443436 443950 461974 464775 465428 469696 470101 470107 470637 477970 489728 490479 494835 495308 509246 531553 533580 533779 534117 535604 537971 537983 543533 543540 543670 543714 560005 560339 560433 571432 590970 597978 598028 600119 600142 601565 601986 603834 608188 608945 616682 616771 617654 623155 628804 639156 653371 659212 660283 661512 661534 661909 662147 663842 667186 672809 673170 675876 680676 687426 689161 689217 695788 696330 700476 702283 703948 704673 705111 709511 711716 713768 714615 715628 717654 731197 731659 732171 733644 733695 736675 742405 747429 758182 760382 760520 764176 765877 766162 767972 768163 768491 776121 778206 779255 780218 782307 782678 786094 788381 793063 793195 794073 803232 803233 804863 804904 ] |
||||||||||||||||||||||||||||||
|
10.48 ms (5.95%) |
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 766162 767972 732171 717654 778206 786094 788381 793063 804904 389749 397388 469696 601565 617654 736675 464775 401575 533779 535604 477970 543714 663842 661534 695788 623155 779255 764176 794073 768491 747429 758182 793195 443436 2808 417293 495308 494835 776121 804863 765877 733695 715628 366284 233500 461974 667186 424146 470637 703948 779905 51972 742405 443950 543533 733644 571432 661909 537971 780218 543540 608945 560433 782307 489728 531553 537983 470101 543670 560339 659212 675876 702283 661512 672809 673170 680676 696330 653371 660283 687426 689161 689217 711716 597978 598028 616771 590970 600142 608188 600119 616682 628804 639156 642091 760520 768163 731197 760382 731659 713768 470107 423527 465428 490479 509246 662147 704673 705111 714615 560005 603834 601986 700476 709511 534117 533580 782678 803232 803233 404178 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.51%) |
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 2808 51972 233500 366284 389749 397388 401575 404178 417293 423527 424146 443436 443950 461974 464775 465428 469696 470101 470107 470637 477970 489728 490479 494835 495308 509246 531553 533580 533779 534117 535604 537971 537983 543533 543540 543670 543714 560005 560339 560433 571432 590970 597978 598028 600119 600142 601565 601986 603834 608188 608945 616682 616771 617654 623155 628804 639156 653371 659212 660283 661512 661534 661909 662147 663842 667186 672809 673170 675876 680676 687426 689161 689217 695788 696330 700476 702283 703948 704673 705111 709511 711716 713768 714615 715628 717654 731197 731659 732171 733644 733695 736675 742405 747429 758182 760382 760520 764176 765877 766162 767972 768163 768491 776121 778206 779255 780218 782307 782678 786094 788381 793063 793195 794073 803232 803233 804863 804904 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашние порно русски…"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск порн русск"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.