Query Metrics
7
Database Queries
7
Different statements
168.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.61 ms (83.24%) |
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 324288 381776 387437 414767 417782 420358 423581 423721 436304 445771 447557 449450 453228 455855 469824 470067 472244 472350 472471 479352 480419 484819 484851 489489 491650 491659 491716 491719 491720 491726 492773 495818 501325 511709 511735 511751 511753 511762 511820 512247 513007 513280 513696 513771 516818 519492 522569 522791 522792 523529 524579 525957 526868 527540 527620 527625 527626 527632 527792 528963 529069 529173 529188 534977 534992 534996 535051 536913 538221 543821 552954 558844 567765 573630 573873 574498 574512 574538 574580 574863 574873 575066 575079 575087 575094 575112 575150 575470 575522 575726 575729 575748 575784 575791 575792 575795 575799 575803 575811 576023 576025 576041 576046 576079 576100 576345 576360 576372 576401 576403 599162 600049 649566 650326 671816 679389 694028 708741 722915 774178 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (10.52%) |
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 479352 447557 528963 491720 522791 527792 538221 484819 491659 522569 523529 420358 381776 469824 512247 529069 575522 575799 575811 576046 576100 576403 574498 575079 575150 575470 575803 576360 576372 558844 573630 573873 574512 574580 574863 575726 575748 575784 575792 576345 576401 671816 694028 722915 567765 575112 576025 576041 576079 774178 708741 470067 472350 511753 522792 527620 491716 491719 511709 525957 491650 491726 492773 511751 527625 511735 511762 513280 513771 526868 527626 423721 453228 480419 529188 511820 529173 524579 527540 536913 575066 552954 574873 599162 600049 387437 516818 527632 575087 575094 575729 575795 576023 575791 679389 574538 472471 519492 489489 484851 324288 436304 414767 423581 417782 445771 449450 455855 472244 501325 534992 534977 535051 534996 495818 513007 513696 543821 649566 650326 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.90%) |
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 324288 381776 387437 414767 417782 420358 423581 423721 436304 445771 447557 449450 453228 455855 469824 470067 472244 472350 472471 479352 480419 484819 484851 489489 491650 491659 491716 491719 491720 491726 492773 495818 501325 511709 511735 511751 511753 511762 511820 512247 513007 513280 513696 513771 516818 519492 522569 522791 522792 523529 524579 525957 526868 527540 527620 527625 527626 527632 527792 528963 529069 529173 529188 534977 534992 534996 535051 536913 538221 543821 552954 558844 567765 573630 573873 574498 574512 574538 574580 574863 574873 575066 575079 575087 575094 575112 575150 575470 575522 575726 575729 575748 575784 575791 575792 575795 575799 575803 575811 576023 576025 576041 576046 576079 576100 576345 576360 576372 576401 576403 599162 600049 649566 650326 671816 679389 694028 708741 722915 774178 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 teen porn"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 teen porn"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 teen porn"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.96%) |
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.