Query Metrics
7
Database Queries
7
Different statements
173.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.53 ms (86.15%) |
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 411344 416644 418144 418215 419454 419628 424751 430425 436178 436186 436230 438013 439558 439653 439705 444069 445026 445493 447936 448696 450722 450889 451042 452363 453409 454552 454800 460535 463973 465918 467684 467872 467878 467888 467904 470219 470278 471113 473963 476417 478775 483553 484673 484692 484699 485695 487362 488734 489310 496809 498717 502885 502941 508541 508565 509636 510884 511721 520489 520813 521438 521535 522363 523033 530011 531524 532954 533461 535620 536337 536676 537236 537988 540808 543659 546987 547767 552272 556483 556524 562282 569386 571194 581083 582697 584046 587272 590411 590507 591333 592970 600071 609154 621259 624779 631249 647340 647936 651647 660696 664431 666968 693269 695477 711761 714211 747597 749935 772471 776212 782653 791078 791405 805139 805144 807303 808321 809951 825560 825864 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (8.37%) |
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 511721 584046 416644 454800 540808 825560 772471 809951 448696 508541 496809 502885 509636 520813 546987 590507 591333 609154 533461 489310 520489 454552 470278 418144 467888 483553 484699 695477 791078 791405 465918 825864 581083 547767 660696 693269 664431 805139 460535 467872 419454 782653 556483 444069 590411 439653 467878 452363 445026 463973 473963 571194 484673 467684 471113 531524 536337 535620 537988 569386 631249 587272 805144 445493 478775 510884 522363 419628 451042 592970 808321 749935 747597 711761 430425 502941 470219 418215 600071 436186 488734 582697 439705 450722 532954 530011 562282 552272 453409 450889 436230 476417 521535 498717 543659 651647 523033 714211 487362 666968 776212 447936 647936 411344 508565 521438 624779 436178 484692 556524 621259 438013 485695 807303 536676 439558 467904 647340 424751 537236 ] |
||||||||||||||||||||||||||||||
|
3.92 ms (2.26%) |
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 411344 416644 418144 418215 419454 419628 424751 430425 436178 436186 436230 438013 439558 439653 439705 444069 445026 445493 447936 448696 450722 450889 451042 452363 453409 454552 454800 460535 463973 465918 467684 467872 467878 467888 467904 470219 470278 471113 473963 476417 478775 483553 484673 484692 484699 485695 487362 488734 489310 496809 498717 502885 502941 508541 508565 509636 510884 511721 520489 520813 521438 521535 522363 523033 530011 531524 532954 533461 535620 536337 536676 537236 537988 540808 543659 546987 547767 552272 556483 556524 562282 569386 571194 581083 582697 584046 587272 590411 590507 591333 592970 600071 609154 621259 624779 631249 647340 647936 651647 660696 664431 666968 693269 695477 711761 714211 747597 749935 772471 776212 782653 791078 791405 805139 805144 807303 808321 809951 825560 825864 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo russian"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд русск"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные дилд русск"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.