Query Metrics
7
Database Queries
7
Different statements
205.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.26 ms (84.51%) |
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 209216 386147 388133 391950 392676 398038 406935 409454 419435 420219 429884 429892 431540 441041 442064 444117 449017 450274 450281 452950 452968 453409 454725 457292 457294 457998 458673 460465 462840 464978 465728 467908 469084 469393 471022 472421 472665 476191 479204 493717 506674 507909 517485 523381 528551 545342 554526 554610 560409 566761 569271 569309 574657 580265 587157 587235 588549 595028 595049 596796 596935 598375 601672 601825 602056 604104 604106 604423 604842 607717 611238 613615 617047 619230 623610 634071 642928 664579 666712 695096 700821 700965 702125 707757 710590 713247 713332 738477 744197 752663 753033 760686 770247 770269 773926 776861 784648 786687 787867 793053 797068 799042 800753 800767 802912 803441 803824 804159 804427 806427 807422 808068 808319 808385 809548 810409 812552 817271 818686 ] |
||||||||||||||||||||||||||||||
|
21.89 ms (10.68%) |
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 517485 566761 398038 469084 528551 569271 580265 595028 601672 604621 598375 601825 617047 465728 472421 507909 406935 431540 569309 442064 419435 818686 449017 700821 666712 713247 700965 554610 587157 812552 800767 809548 770247 604104 776861 802912 803441 808385 479204 450281 386147 452950 444117 545342 695096 664579 588549 604106 619230 595049 604842 642928 793053 786687 800753 808319 753033 738477 752663 784648 804159 634071 388133 450274 469393 574657 604423 607717 623610 458673 392676 506674 476191 457292 462840 452968 467908 429884 817271 710590 707757 613615 596796 596935 797068 803824 807422 810409 773926 808068 760686 770269 602056 611238 713332 787867 799042 806427 409454 391950 441041 209216 429892 560409 457998 464978 493717 471022 744197 554526 453409 454725 457294 472665 587235 420219 523381 460465 702125 804427 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.31%) |
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 209216 386147 388133 391950 392676 398038 406935 409454 419435 420219 429884 429892 431540 441041 442064 444117 449017 450274 450281 452950 452968 453409 454725 457292 457294 457998 458673 460465 462840 464978 465728 467908 469084 469393 471022 472421 472665 476191 479204 493717 506674 507909 517485 523381 528551 545342 554526 554610 560409 566761 569271 569309 574657 580265 587157 587235 588549 595028 595049 596796 596935 598375 601672 601825 602056 604104 604106 604423 604842 607717 611238 613615 617047 619230 623610 634071 642928 664579 666712 695096 700821 700965 702125 707757 710590 713247 713332 738477 744197 752663 753033 760686 770247 770269 773926 776861 784648 786687 787867 793053 797068 799042 800753 800767 802912 803441 803824 804159 804427 806427 807422 808068 808319 808385 809548 810409 812552 817271 818686 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy dildo solo"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.77%) |
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.