Query Metrics
7
Database Queries
7
Different statements
182.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.04 ms (86.65%) |
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 385077 391871 400945 410877 412332 415220 415815 420598 423808 427244 435320 437368 443297 443919 444053 444338 444705 447485 450653 451581 454581 455114 457510 458152 460568 460722 461562 462004 462034 462316 462512 464668 466144 468863 469848 469917 470776 472360 472380 473239 474082 474880 479758 481194 483275 483672 484037 484920 485792 487676 489579 489663 489784 490278 491307 491717 492979 494401 496753 498234 500238 501003 501099 502048 502366 502722 504993 508505 509168 509489 509847 510190 510778 511726 513932 514423 520366 520535 521959 521984 523315 523730 524691 525028 525788 526263 528169 543587 543637 545726 546368 548612 549486 551619 552326 552924 556715 559018 559270 559514 560095 561357 561418 561705 563672 565298 568356 569449 571510 572981 574851 588878 594938 598466 600982 602722 635203 701660 816118 825789 ] |
||||||||||||||||||||||||||||||
|
15.06 ms (8.26%) |
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 470776 412332 420598 427244 444338 450653 462004 479758 825789 501003 549486 458152 447485 474082 464668 510190 494401 502048 508505 509847 520366 523730 525788 483275 484037 489663 510778 816118 563672 391871 460722 460568 415815 487676 560095 565298 546368 561357 501099 423808 468863 457510 462316 410877 500238 513932 502366 489784 498234 559018 561418 473239 455114 415220 454581 543637 602722 635203 385077 443919 543587 552326 556715 571510 559514 572981 574851 588878 451581 400945 469848 469917 481194 509168 511726 489579 514423 525028 491717 523315 701660 492979 551619 559270 545726 548612 561705 552924 568356 569449 594938 600982 598466 443297 462512 435320 437368 461562 444705 462034 472360 472380 444053 466144 474880 520535 521959 490278 491307 496753 521984 524691 526263 528169 485792 502722 504993 509489 483672 484920 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.43%) |
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 385077 391871 400945 410877 412332 415220 415815 420598 423808 427244 435320 437368 443297 443919 444053 444338 444705 447485 450653 451581 454581 455114 457510 458152 460568 460722 461562 462004 462034 462316 462512 464668 466144 468863 469848 469917 470776 472360 472380 473239 474082 474880 479758 481194 483275 483672 484037 484920 485792 487676 489579 489663 489784 490278 491307 491717 492979 494401 496753 498234 500238 501003 501099 502048 502366 502722 504993 508505 509168 509489 509847 510190 510778 511726 513932 514423 520366 520535 521959 521984 523315 523730 524691 525028 525788 526263 528169 543587 543637 545726 546368 548612 549486 551619 552326 552924 556715 559018 559270 559514 560095 561357 561418 561705 563672 565298 568356 569449 571510 572981 574851 588878 594938 598466 600982 602722 635203 701660 816118 825789 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus girls"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.70%) |
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.