Query Metrics
7
Database Queries
7
Different statements
152.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.81 ms (78.35%) |
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 418368 418867 420685 421238 422395 427555 427657 430805 433742 435320 438978 446082 446456 446569 446584 448375 451549 452622 453668 454264 456233 457899 457961 458119 459745 463644 463677 463847 466913 469094 469577 470041 470719 471743 474840 475015 475811 476917 479481 479754 480611 480919 485223 489793 491531 491659 491772 492370 492380 492836 497075 497375 504885 506932 507483 509449 509978 510118 510221 510472 510603 511814 512129 512158 512476 515796 516946 518093 518208 518267 518375 519496 522819 533145 535531 536494 544444 545783 548633 549517 549774 550011 551277 558599 560432 564864 565051 565179 566022 567120 568121 569402 569593 569988 570019 571361 571884 574599 576097 576341 576343 581058 581531 586385 589677 592569 595013 595860 596017 596989 598971 599169 602136 608715 629042 649520 677364 689660 751424 780191 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (8.52%) |
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 457961 689660 479481 466913 446584 536494 545783 560432 574599 581531 576341 548633 550011 448375 475811 476917 492380 506932 491659 512158 497075 511814 489793 629042 454264 492836 485223 515796 571884 480919 420685 558599 430805 418368 446456 456233 535531 549774 567120 602136 598971 596989 599169 418867 509978 589677 469094 479754 421238 576343 586385 446569 549517 470719 470041 492370 569593 427555 512129 480611 569402 451549 433742 512476 518267 564864 581058 452622 474840 510603 566022 571361 565179 649520 608715 463677 422395 504885 519496 510118 510472 518093 518375 427657 453668 458119 459745 469577 570019 576097 565051 592569 596017 595013 475015 435320 463644 446082 507483 518208 491772 516946 457899 463847 509449 497375 544444 568121 569988 677364 751424 491531 510221 780191 522819 595860 438978 533145 551277 471743 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (8.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.40 ms (1.57%) |
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 418368 418867 420685 421238 422395 427555 427657 430805 433742 435320 438978 446082 446456 446569 446584 448375 451549 452622 453668 454264 456233 457899 457961 458119 459745 463644 463677 463847 466913 469094 469577 470041 470719 471743 474840 475015 475811 476917 479481 479754 480611 480919 485223 489793 491531 491659 491772 492370 492380 492836 497075 497375 504885 506932 507483 509449 509978 510118 510221 510472 510603 511814 512129 512158 512476 515796 516946 518093 518208 518267 518375 519496 522819 533145 535531 536494 544444 545783 548633 549517 549774 550011 551277 558599 560432 564864 565051 565179 566022 567120 568121 569402 569593 569988 570019 571361 571884 574599 576097 576341 576343 581058 581531 586385 589677 592569 595013 595860 596017 596989 598971 599169 602136 608715 629042 649520 677364 689660 751424 780191 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl tits"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.87%) |
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.