Query Metrics
7
Database Queries
7
Different statements
169.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.98 ms (85.99%) |
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 181926 182139 182185 182686 276646 382410 383571 384829 385067 392422 398116 414337 416656 417980 418102 418122 428308 428773 429566 429598 430369 434307 434313 434318 434332 434345 435343 435395 437605 439112 439328 439424 446751 448000 448065 450255 452803 452817 452823 452829 452833 453997 457812 458761 461312 463621 468237 468255 469054 469176 469199 469733 471125 471686 475407 475457 476191 477500 481961 485279 486244 486768 494546 499914 500789 502772 502774 502776 502777 509776 509978 510280 514083 514117 516458 518508 518885 521429 523885 526492 542163 550891 564170 564567 574192 578301 585430 620743 637197 642134 671520 713500 715288 717620 720160 723361 738475 738476 738500 738513 744383 752687 756771 758324 758941 762007 783034 788271 791010 791549 791882 796648 796694 796709 800543 802182 803547 807562 828500 828725 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (8.23%) |
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 452823 494546 502777 585430 620743 429598 434313 437605 439328 448065 450255 510280 521429 417980 418122 398116 637197 791882 383571 392422 416656 435395 428308 429566 453997 457812 486244 469176 502774 509776 486768 574192 717620 720160 564170 807562 434332 468255 471686 428773 481961 502772 182185 452833 476191 414337 828500 756771 796694 384829 181926 276646 475457 713500 723361 788271 758941 796709 452817 475407 526492 578301 468237 469199 434307 738500 452803 418102 182139 671520 738475 796648 382410 518508 430369 435343 434345 469054 448000 452829 500789 802182 434318 463621 439112 461312 469733 502776 499914 509978 518885 385067 791549 477500 514083 514117 642134 803547 783034 762007 744383 791010 542163 564567 752687 800543 738476 182686 828725 715288 738513 758324 516458 550891 439424 458761 446751 485279 471125 523885 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.81%) |
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 181926 182139 182185 182686 276646 382410 383571 384829 385067 392422 398116 414337 416656 417980 418102 418122 428308 428773 429566 429598 430369 434307 434313 434318 434332 434345 435343 435395 437605 439112 439328 439424 446751 448000 448065 450255 452803 452817 452823 452829 452833 453997 457812 458761 461312 463621 468237 468255 469054 469176 469199 469733 471125 471686 475407 475457 476191 477500 481961 485279 486244 486768 494546 499914 500789 502772 502774 502776 502777 509776 509978 510280 514083 514117 516458 518508 518885 521429 523885 526492 542163 550891 564170 564567 574192 578301 585430 620743 637197 642134 671520 713500 715288 717620 720160 723361 738475 738476 738500 738513 744383 752687 756771 758324 758941 762007 783034 788271 791010 791549 791882 796648 796694 796709 800543 802182 803547 807562 828500 828725 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexmachine dildo"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин дилд"
]
|
||||||||||||||||||||||||||||||
|
1.35 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.