Query Metrics
7
Database Queries
7
Different statements
191.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.30 ms (85.96%) |
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 395654 395839 396214 397406 416195 417486 417952 420201 420384 423428 423505 424449 432777 434491 435400 435406 435454 441111 441476 441566 441838 443224 444828 444829 446079 447086 448374 451670 452818 453788 456214 457804 458086 459520 464302 465277 468704 470087 470173 470181 470320 470973 471685 477073 477553 479530 481812 482804 484438 484476 488909 494698 495067 496733 496758 504672 508679 508832 508876 509063 509064 510368 511090 511269 512922 513114 513366 513690 518005 518919 525418 528853 533544 536667 537927 541618 542895 543869 545204 545471 546202 546780 547428 548253 548300 550560 552131 560286 565252 574222 584234 588786 600104 604207 604329 604408 614566 626539 634563 636285 643233 661933 662009 694479 695620 720739 725619 726292 729919 729957 731960 739868 743380 746722 751503 799362 814640 817156 827876 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (9.05%) |
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 470320 423505 457804 471685 484476 694479 695620 614566 543869 604207 432777 560286 441111 417952 420384 444828 458086 465277 477553 513366 528853 495067 508679 537927 552131 547428 662009 720739 545471 550560 636285 604329 726292 746722 743380 751503 725619 799362 470173 481812 395654 441476 435454 509064 512922 513114 518005 397406 446079 453788 510368 731960 396214 416195 479530 509063 827876 814640 451670 533544 542895 661933 600104 729957 739868 604408 470973 508832 546780 634563 729919 434491 420201 444829 423428 488909 470087 525418 536667 518919 511269 477073 565252 548253 548300 588786 424449 470181 435406 484438 496733 496758 193342 395839 441838 441566 417486 452818 464302 482804 494698 468704 545204 584234 574222 546202 626539 643233 456214 435400 459520 508876 513690 447086 443224 817156 448374 504672 511090 541618 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.34%) |
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 395654 395839 396214 397406 416195 417486 417952 420201 420384 423428 423505 424449 432777 434491 435400 435406 435454 441111 441476 441566 441838 443224 444828 444829 446079 447086 448374 451670 452818 453788 456214 457804 458086 459520 464302 465277 468704 470087 470173 470181 470320 470973 471685 477073 477553 479530 481812 482804 484438 484476 488909 494698 495067 496733 496758 504672 508679 508832 508876 509063 509064 510368 511090 511269 512922 513114 513366 513690 518005 518919 525418 528853 533544 536667 537927 541618 542895 543869 545204 545471 546202 546780 547428 548253 548300 550560 552131 560286 565252 574222 584234 588786 600104 604207 604329 604408 614566 626539 634563 636285 643233 661933 662009 694479 695620 720739 725619 726292 729919 729957 731960 739868 743380 746722 751503 799362 814640 817156 827876 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"domination anal"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"domination анал"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"domination анал"
]
|
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.