Query Metrics
7
Database Queries
7
Different statements
190.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.72 ms (85.22%) |
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 381878 382266 390231 394685 398284 398955 415594 418974 421571 423505 424477 424478 428685 434609 448042 449105 449109 454273 457804 459520 459878 460722 460975 463758 465731 465930 467617 470513 471685 473255 475590 477037 477154 477376 477968 479285 480976 481920 487860 491909 494000 499417 508679 511019 513978 521701 525192 527061 530450 533258 533264 534018 537927 538957 541586 542095 542373 542397 542411 544501 545471 545484 546219 547428 548568 549268 549413 550010 550224 550333 551026 555889 556511 559139 559726 561074 561740 563183 564373 565484 568117 568477 569579 569722 569756 570151 570797 574222 576655 576662 594338 596868 599591 600274 600356 600732 601052 601714 602054 604596 610209 614407 615322 615392 619358 619469 624753 627726 639982 648259 699325 711275 716835 717859 719807 720308 731814 739866 799362 809811 ] |
||||||||||||||||||||||||||||||
|
18.31 ms (9.59%) |
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 499417 508679 511019 513978 521701 525192 527061 530450 533258 533264 534018 537927 538957 459878 477154 487860 491909 494000 542411 549268 559139 541586 542095 542373 547428 548568 550333 559726 565484 568477 569722 574222 576662 542397 544501 546219 550010 556511 561740 564373 568117 569756 570151 576655 648259 699325 716835 717859 719807 545471 545484 549413 550224 551026 555889 561074 563183 569579 570797 600274 600356 601714 639982 594338 599591 600732 624753 627726 596868 610209 615392 619469 601052 614407 619358 809811 731814 739866 602054 604596 615322 711275 720308 799362 381878 382266 398284 460722 473255 398955 421571 428685 434609 449105 465731 470513 475590 477376 479285 480976 481920 418974 423505 424477 459520 477968 390231 394685 415594 448042 449109 454273 457804 471685 477037 424478 460975 463758 465930 467617 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.53%) |
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 381878 382266 390231 394685 398284 398955 415594 418974 421571 423505 424477 424478 428685 434609 448042 449105 449109 454273 457804 459520 459878 460722 460975 463758 465731 465930 467617 470513 471685 473255 475590 477037 477154 477376 477968 479285 480976 481920 487860 491909 494000 499417 508679 511019 513978 521701 525192 527061 530450 533258 533264 534018 537927 538957 541586 542095 542373 542397 542411 544501 545471 545484 546219 547428 548568 549268 549413 550010 550224 550333 551026 555889 556511 559139 559726 561074 561740 563183 564373 565484 568117 568477 569579 569722 569756 570151 570797 574222 576655 576662 594338 596868 599591 600274 600356 600732 601052 601714 602054 604596 610209 614407 615322 615392 619358 619469 624753 627726 639982 648259 699325 711275 716835 717859 719807 720308 731814 739866 799362 809811 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.83%) |
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.