Query Metrics
7
Database Queries
7
Different statements
168.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.57 ms (84.08%) |
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 193342 282626 386271 395587 395839 395849 413707 417486 420201 422074 423428 424449 434491 435400 435406 441566 443224 445397 447086 448374 448403 448874 452818 456214 459520 464302 468462 468704 470087 470181 470973 474776 477073 477587 478048 479295 480414 482804 484438 488909 491474 491947 493172 494698 495813 496733 496758 496772 497005 504668 504672 504970 508832 508876 511259 511269 512459 513475 513690 515511 518919 519002 519719 521051 521339 525418 526077 528057 528437 531093 531212 533932 536667 536801 537669 537912 541618 543552 543851 545204 546202 546838 548300 561008 565252 571671 574222 584234 587951 597267 604408 605437 607374 626539 629886 636269 637413 638137 643233 648589 650320 661608 661616 662183 680137 683955 686573 692378 716739 727180 729919 732917 733340 733862 738674 739868 748949 755705 788130 817156 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (9.39%) |
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 733340 739868 604408 788130 395587 470973 508832 495813 607374 637413 447086 434491 420201 423428 488909 470087 525418 536667 518919 511269 477073 565252 548300 587951 424449 445397 470181 435406 484438 496733 496758 193342 395839 441566 417486 452818 464302 482804 494698 468704 545204 584234 574222 686573 546202 561008 626539 643233 456214 435400 459520 508876 513690 729919 733862 443224 817156 448374 504672 541618 543851 680137 716739 692378 650320 661608 661616 662183 638137 748949 738674 386271 395849 282626 422074 413707 448403 474776 480414 448874 521051 521339 526077 497005 511259 515511 531093 496772 504668 512459 533932 536801 537669 537912 478048 546838 543552 648589 683955 571671 605437 636269 629886 597267 732917 755705 727180 479295 468462 519719 491947 528057 513475 519002 528437 491474 493172 504970 477587 531212 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.71%) |
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 193342 282626 386271 395587 395839 395849 413707 417486 420201 422074 423428 424449 434491 435400 435406 441566 443224 445397 447086 448374 448403 448874 452818 456214 459520 464302 468462 468704 470087 470181 470973 474776 477073 477587 478048 479295 480414 482804 484438 488909 491474 491947 493172 494698 495813 496733 496758 496772 497005 504668 504672 504970 508832 508876 511259 511269 512459 513475 513690 515511 518919 519002 519719 521051 521339 525418 526077 528057 528437 531093 531212 533932 536667 536801 537669 537912 541618 543552 543851 545204 546202 546838 548300 561008 565252 571671 574222 584234 587951 597267 604408 605437 607374 626539 629886 636269 637413 638137 643233 648589 650320 661608 661616 662183 680137 683955 686573 692378 716739 727180 729919 732917 733340 733862 738674 739868 748949 755705 788130 817156 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave anal"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован анал"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
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.