Query Metrics
7
Database Queries
7
Different statements
205.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.42 ms (86.49%) |
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 403264 421652 424238 426779 432451 432477 432491 432496 432526 432532 432538 433078 433218 433461 433584 433742 433890 434093 434220 435437 436447 437156 437580 437613 438349 444429 446608 454067 454876 455787 456453 457340 457542 459580 459872 460439 460570 460684 463654 464516 465738 470284 472145 473626 478022 478400 478743 478999 483040 483051 483056 483952 487259 489370 489372 489630 489633 491332 491573 492911 492975 494814 499021 499757 504320 504731 505694 505952 506098 506577 508141 508309 508549 510706 511078 511588 512394 512742 515638 519664 520560 520615 521062 521979 521984 522793 525213 525807 526076 527675 527722 528110 528908 528918 534494 534512 542090 554098 555563 558630 558874 566939 568097 568572 569432 571256 571495 583632 586741 598198 600982 601879 603721 609571 609861 615004 616481 617203 647876 673244 ] |
||||||||||||||||||||||||||||||
|
17.97 ms (8.76%) |
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 470284 542090 568572 600982 434220 435437 459872 433461 454876 456453 478999 426779 432526 433218 457340 463654 473626 478400 433742 478022 522793 525807 489633 508141 521979 521984 483040 483056 508309 508549 526076 527675 487259 489630 491573 494814 499021 519664 528918 534494 433584 432491 483952 511078 609861 601879 433890 558630 571256 583632 558874 647876 673244 554098 568097 569432 616481 586741 603721 609571 615004 617203 436447 437613 438349 457542 432538 460439 403264 421652 432451 432532 437156 437580 446608 459580 464516 434093 444429 454067 465738 432496 460570 472145 478743 511588 512394 489370 491332 492911 492975 504320 505952 520560 520615 528110 528908 534512 489372 499757 504731 505694 506098 506577 510706 515638 521062 525213 483051 512742 527722 424238 571495 566939 555563 598198 432477 455787 460684 433078 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.40%) |
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 403264 421652 424238 426779 432451 432477 432491 432496 432526 432532 432538 433078 433218 433461 433584 433742 433890 434093 434220 435437 436447 437156 437580 437613 438349 444429 446608 454067 454876 455787 456453 457340 457542 459580 459872 460439 460570 460684 463654 464516 465738 470284 472145 473626 478022 478400 478743 478999 483040 483051 483056 483952 487259 489370 489372 489630 489633 491332 491573 492911 492975 494814 499021 499757 504320 504731 505694 505952 506098 506577 508141 508309 508549 510706 511078 511588 512394 512742 515638 519664 520560 520615 521062 521979 521984 522793 525213 525807 526076 527675 527722 528110 528908 528918 534494 534512 542090 554098 555563 558630 558874 566939 568097 568572 569432 571256 571495 583632 586741 598198 600982 601879 603721 609571 609861 615004 616481 617203 647876 673244 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister русск"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister russian"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step 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.