Query Metrics
7
Database Queries
7
Different statements
197.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.91 ms (86.23%) |
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 285233 290304 417317 419319 419590 425319 427237 429234 429603 432552 435267 439301 445192 445987 453323 456103 456452 461617 467739 471780 471944 473106 476601 478140 479452 480070 480183 482070 483636 485234 487635 488128 488153 489265 489829 492005 493059 493193 495617 499177 499194 503389 504717 505878 506415 507327 507685 508962 509439 510183 511985 516487 516493 516501 516532 517363 518548 518555 518627 520861 520918 522241 522645 524091 525261 525399 525474 527157 527251 527836 528203 528212 528657 539369 545722 548381 548441 548984 556704 559945 560097 560758 560791 564744 568115 572882 577529 580620 582828 592958 603742 608227 609078 612437 613576 614768 621186 626684 628515 629580 644154 659217 668807 673845 680819 696484 706567 714468 726986 732681 741733 745309 761875 762064 762191 782452 789310 800156 807687 814832 ] |
||||||||||||||||||||||||||||||
|
17.02 ms (8.64%) |
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 696484 706567 564744 612437 609078 603742 644154 608227 626684 789310 782452 732681 800156 745309 761875 741733 762191 726986 629580 429603 478140 480070 456103 461617 425319 479452 417317 445192 445987 516487 516501 495617 518555 524091 527836 489265 516532 493059 499177 504717 505878 427237 453323 487635 489829 492005 511985 517363 507327 527251 528657 520918 527157 508962 510183 471944 545722 548381 568115 577529 572882 560758 668807 673845 548441 556704 559945 560791 592958 628515 614768 621186 467739 290304 432552 476601 480183 518548 507685 522645 499194 516493 525399 419319 429234 483636 525474 548984 659217 807687 762064 714468 471780 482070 503389 522241 528212 528203 488128 488153 493193 525261 539369 285233 419590 814832 485234 473106 506415 560097 680819 580620 613576 435267 439301 456452 518627 520861 509439 582828 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.46%) |
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 285233 290304 417317 419319 419590 425319 427237 429234 429603 432552 435267 439301 445192 445987 453323 456103 456452 461617 467739 471780 471944 473106 476601 478140 479452 480070 480183 482070 483636 485234 487635 488128 488153 489265 489829 492005 493059 493193 495617 499177 499194 503389 504717 505878 506415 507327 507685 508962 509439 510183 511985 516487 516493 516501 516532 517363 518548 518555 518627 520861 520918 522241 522645 524091 525261 525399 525474 527157 527251 527836 528203 528212 528657 539369 545722 548381 548441 548984 556704 559945 560097 560758 560791 564744 568115 572882 577529 580620 582828 592958 603742 608227 609078 612437 613576 614768 621186 626684 628515 629580 644154 659217 668807 673845 680819 696484 706567 714468 726986 732681 741733 745309 761875 762064 762191 782452 789310 800156 807687 814832 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"moans"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"moans"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"moans"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
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.