Query Metrics
7
Database Queries
7
Different statements
178.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.27 ms (83.61%) |
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 131772 384395 420399 426281 427251 428100 434668 445472 445473 447031 451108 453243 453845 455863 458486 460596 461288 462179 466320 466930 467596 469551 470495 470624 471611 472120 473362 474625 479109 483326 485480 486637 488776 494273 494949 495970 496597 499807 499968 500830 503826 505241 509021 511100 511571 517702 519618 520574 520746 524867 526185 526719 526929 527057 527089 528399 532649 536034 538449 538542 542542 542553 545117 547949 548742 549769 550821 560877 562523 567436 569012 569039 570997 579422 586632 591613 591928 594846 596628 607719 608392 609619 615675 618563 627330 635974 645247 645273 660148 665288 667288 669736 673537 680977 684802 703492 707889 709650 716085 716157 719808 720882 734263 737922 755850 760237 761145 773358 775473 784908 789851 799951 802117 803344 811495 813265 814210 815064 815121 ] |
||||||||||||||||||||||||||||||
|
17.98 ms (10.07%) |
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 472120 451108 471611 511571 517702 532649 536034 645247 755850 470495 483326 488776 526929 527057 560877 131772 814210 461288 445472 467596 473362 549769 665288 669736 627330 784908 775473 803344 789851 799951 761145 773358 737922 426281 427251 815064 445473 453845 460596 474625 455863 462179 526185 496597 499968 570997 567436 618563 591613 594846 813265 470624 453243 527089 519618 466320 538449 542542 547949 569012 542553 569039 673537 545117 548742 586632 591928 596628 760237 609619 703492 505241 734263 479109 509021 384395 434668 420399 815121 494273 524867 550821 562523 680977 684802 719808 720882 645273 660148 667288 707889 709650 615675 607719 608392 635974 802117 811495 716085 716157 486637 511100 495970 458486 499807 526719 494949 520574 447031 697939 428100 466930 469551 485480 503826 520746 538542 500830 528399 579422 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.76%) |
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 131772 384395 420399 426281 427251 428100 434668 445472 445473 447031 451108 453243 453845 455863 458486 460596 461288 462179 466320 466930 467596 469551 470495 470624 471611 472120 473362 474625 479109 483326 485480 486637 488776 494273 494949 495970 496597 499807 499968 500830 503826 505241 509021 511100 511571 517702 519618 520574 520746 524867 526185 526719 526929 527057 527089 528399 532649 536034 538449 538542 542542 542553 545117 547949 548742 549769 550821 560877 562523 567436 569012 569039 570997 579422 586632 591613 591928 594846 596628 607719 608392 609619 615675 618563 627330 635974 645247 645273 660148 665288 667288 669736 673537 680977 684802 703492 707889 709650 716085 716157 719808 720882 734263 737922 755850 760237 761145 773358 775473 784908 789851 799951 802117 803344 811495 813265 814210 815064 815121 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob in condom"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член condom"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член condom"
]
|
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.