Query Metrics
7
Database Queries
7
Different statements
148.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.86 ms (86.92%) |
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 382118 394031 394338 401968 421828 422294 433685 434066 437670 439683 442978 448710 448943 450827 457855 458727 465561 466723 467682 476630 489933 492650 499274 521719 523385 530509 531774 546126 562960 563003 563012 565757 567214 577578 578218 593067 607096 613837 614843 619791 620307 626351 628648 636242 638565 644093 649377 649940 653395 659945 660006 668509 670755 674756 682304 682358 688335 693238 697402 709298 714884 718040 719361 720105 726506 728255 738281 738325 738679 742861 746021 746121 746259 747094 749601 750301 756289 759722 769474 772117 773352 780676 780745 784206 786179 788281 788338 788942 789541 791737 792540 792639 792773 794106 794236 794243 794306 794766 795313 795731 796106 796160 799352 800529 800753 800754 800859 801264 802208 803073 803569 803776 804235 806356 808484 808685 808759 813750 813920 823370 ] |
||||||||||||||||||||||||||||||
|
10.51 ms (7.09%) |
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 422294 439683 401968 421828 448710 457855 521719 394031 394338 382118 437670 433685 442978 434066 813750 813920 823370 448943 458727 476630 450827 465561 466723 530509 523385 531774 499274 467682 489933 492650 578218 565757 562960 563003 563012 659945 668509 682358 688335 718040 720105 649377 649940 674756 682304 693238 714884 653395 660006 670755 719361 546126 567214 577578 613837 620307 626351 636242 619791 593067 607096 614843 628648 638565 644093 780745 788942 792773 794106 794243 796106 799352 803073 803569 803776 808685 780676 788338 795313 800753 801264 802208 726506 742861 746121 746259 772117 784206 786179 791737 792639 794766 795731 800529 800754 738281 738679 746021 773352 728255 738325 749601 750301 759722 747094 756289 769474 697402 709298 788281 789541 792540 794236 794306 796160 800859 804235 806356 808484 808759 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.74%) |
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 382118 394031 394338 401968 421828 422294 433685 434066 437670 439683 442978 448710 448943 450827 457855 458727 465561 466723 467682 476630 489933 492650 499274 521719 523385 530509 531774 546126 562960 563003 563012 565757 567214 577578 578218 593067 607096 613837 614843 619791 620307 626351 628648 636242 638565 644093 649377 649940 653395 659945 660006 668509 670755 674756 682304 682358 688335 693238 697402 709298 714884 718040 719361 720105 726506 728255 738281 738325 738679 742861 746021 746121 746259 747094 749601 750301 756289 759722 769474 772117 773352 780676 780745 784206 786179 788281 788338 788942 789541 791737 792540 792639 792773 794106 794236 794243 794306 794766 795313 795731 796106 796160 799352 800529 800753 800754 800859 801264 802208 803073 803569 803776 804235 806356 808484 808685 808759 813750 813920 823370 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature stepmom"
]
|
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.