Query Metrics
7
Database Queries
7
Different statements
170.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.10 ms (82.27%) |
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 191179 366354 382154 393298 396314 400151 400493 402101 405830 407296 407458 408313 411694 412702 415112 416998 418416 418948 418971 428531 439630 439671 441022 447403 450368 453129 455354 458378 464941 465001 466164 466192 467949 468650 470074 474830 477097 479685 485698 488308 492322 492455 496104 498300 501547 508487 509836 509993 511780 512873 513131 523171 523803 524872 525046 530690 530757 532747 532753 533010 533471 534228 536676 536687 536789 537184 550099 550436 555997 556014 557503 557569 558019 558614 561356 562068 562373 564407 565528 566075 568053 568580 575716 577409 581401 582480 588343 590542 591595 592034 597028 604051 606508 609906 621463 622398 628396 628397 630524 630540 633732 634153 637729 663537 668525 680118 683508 709257 717189 726486 726689 726696 771023 776638 786455 792634 806722 810774 814699 814701 ] |
||||||||||||||||||||||||||||||
|
20.01 ms (11.75%) |
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 771023 726696 726486 726689 776638 786455 792634 407296 455354 400493 418948 418971 411694 479685 492322 532753 530757 525046 533471 508487 536687 536789 550099 558614 568053 562373 577409 568580 680118 556014 565528 575716 606508 630540 597028 590542 591595 415112 418416 441022 416998 524872 492455 477097 428531 474830 581401 582480 668525 683508 592034 621463 630524 634153 628396 637729 628397 633732 470074 393298 366354 396314 402101 408313 814701 814699 453129 465001 485698 458378 513131 523803 509836 512873 558019 566075 561356 717189 709257 806722 810774 407458 412702 439630 466164 466192 405830 447403 450368 464941 501547 550436 523171 530690 536676 532747 537184 562068 564407 663537 622398 604051 609906 488308 191179 382154 400151 439671 467949 468650 509993 511780 533010 496104 498300 534228 557503 557569 555997 588343 ] |
||||||||||||||||||||||||||||||
|
3.24 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 191179 366354 382154 393298 396314 400151 400493 402101 405830 407296 407458 408313 411694 412702 415112 416998 418416 418948 418971 428531 439630 439671 441022 447403 450368 453129 455354 458378 464941 465001 466164 466192 467949 468650 470074 474830 477097 479685 485698 488308 492322 492455 496104 498300 501547 508487 509836 509993 511780 512873 513131 523171 523803 524872 525046 530690 530757 532747 532753 533010 533471 534228 536676 536687 536789 537184 550099 550436 555997 556014 557503 557569 558019 558614 561356 562068 562373 564407 565528 566075 568053 568580 575716 577409 581401 582480 588343 590542 591595 592034 597028 604051 606508 609906 621463 622398 628396 628397 630524 630540 633732 634153 637729 663537 668525 680118 683508 709257 717189 726486 726689 726696 771023 776638 786455 792634 806722 810774 814699 814701 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young cum"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young cum"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young cum"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.95%) |
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.