Query Metrics
7
Database Queries
7
Different statements
171.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.84 ms (82.93%) |
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 404216 424205 426779 428154 432491 432526 432563 433049 433218 433386 433461 433584 433742 433789 434220 435437 437260 437924 437977 438730 446914 451541 454873 454876 455390 456119 456453 457340 459214 459225 459872 463654 465873 467751 470284 473229 473236 473626 473673 478022 478400 478999 483040 483056 483888 483952 487259 489630 489633 490205 490271 491084 491573 494814 499021 503947 508141 508309 508549 508741 510424 510519 511078 513017 519664 519738 521478 521979 521984 522118 522793 525807 526076 527675 528918 534494 536038 542090 547392 548555 548599 549555 549604 552591 558624 558918 559387 561330 562716 564379 568572 568845 571972 576134 578858 581573 582665 583426 584666 584689 592181 599460 600982 601863 606010 612426 612489 614938 616807 619213 619538 652199 661555 661990 682625 687937 692819 701527 816687 818080 ] |
||||||||||||||||||||||||||||||
|
19.47 ms (11.38%) |
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 433789 404216 437977 438730 459214 473236 437260 483888 490271 513017 490205 521478 433049 424205 470284 542090 568572 568845 600982 434220 456119 459225 473673 435437 451541 454873 459872 465873 433461 437924 446914 454876 456453 467751 478999 426779 428154 432526 432563 433218 457340 463654 473229 473626 478400 433742 455390 478022 522793 525807 489633 508141 510519 521979 521984 483040 483056 508309 508549 510424 526076 527675 487259 489630 491573 494814 499021 503947 519664 519738 522118 528918 534494 433584 432491 508741 483952 511078 433386 816687 818080 536038 491084 561330 564379 581573 584689 548599 549555 549604 562716 576134 583426 584666 547392 548555 552591 571972 582665 652199 661555 682625 661990 687937 692819 701527 558624 558918 559387 578858 592181 601863 606010 616807 619213 612426 612489 614938 619538 599460 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.82%) |
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 404216 424205 426779 428154 432491 432526 432563 433049 433218 433386 433461 433584 433742 433789 434220 435437 437260 437924 437977 438730 446914 451541 454873 454876 455390 456119 456453 457340 459214 459225 459872 463654 465873 467751 470284 473229 473236 473626 473673 478022 478400 478999 483040 483056 483888 483952 487259 489630 489633 490205 490271 491084 491573 494814 499021 503947 508141 508309 508549 508741 510424 510519 511078 513017 519664 519738 521478 521979 521984 522118 522793 525807 526076 527675 528918 534494 536038 542090 547392 548555 548599 549555 549604 552591 558624 558918 559387 561330 562716 564379 568572 568845 571972 576134 578858 581573 582665 583426 584666 584689 592181 599460 600982 601863 606010 612426 612489 614938 616807 619213 619538 652199 661555 661990 682625 687937 692819 701527 816687 818080 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sister russian"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sister русск"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sister русск"
]
|
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.