Query Metrics
7
Database Queries
7
Different statements
153.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.53 ms (84.52%) |
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 225519 287436 383249 386771 387006 387678 388078 390776 392632 395825 396088 396186 396190 397063 398425 401135 403904 405088 414194 416898 424386 429323 436627 443489 447137 447634 447912 447999 451594 452864 453663 453790 454790 457030 461738 463912 464903 465315 468094 470273 472353 472450 475250 477082 479987 489888 490076 494062 494409 496750 497467 499134 504672 511722 513299 513690 517990 525523 536262 536271 544782 552430 555801 575065 575484 575618 581229 590165 595512 597041 597560 597968 598479 598599 600159 600945 604180 615148 619780 632118 632593 637851 639959 646662 658728 660321 670997 671616 681198 690439 691217 698434 708413 709589 714667 714994 716633 717902 719292 720749 720967 721322 723539 726176 728404 742161 742242 743069 746802 747153 747502 753304 753327 753351 755677 756687 760908 775919 791663 806332 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (9.00%) |
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 720967 598479 597041 615148 597560 753351 726176 728404 753304 753327 755677 806332 517990 386771 575065 575484 632593 536262 392632 401135 403904 424386 429323 472450 477082 451594 453663 465315 447912 453790 496750 464903 690439 717902 708413 600159 595512 747153 747502 388078 398425 414194 396186 396190 443489 447634 396088 405088 416898 447999 457030 470273 472353 489888 494062 511722 490076 513690 525523 494409 513299 658728 691217 597968 619780 746802 756687 225519 287436 390776 723539 475250 463912 497467 499134 504672 536271 581229 670997 720749 639959 590165 600945 598599 742161 709589 775919 387678 395825 447137 452864 461738 383249 387006 479987 436627 468094 454790 397063 552430 544782 575618 646662 671616 698434 716633 721322 660321 681198 714667 714994 719292 555801 632118 637851 604180 791663 742242 743069 760908 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.08%) |
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 225519 287436 383249 386771 387006 387678 388078 390776 392632 395825 396088 396186 396190 397063 398425 401135 403904 405088 414194 416898 424386 429323 436627 443489 447137 447634 447912 447999 451594 452864 453663 453790 454790 457030 461738 463912 464903 465315 468094 470273 472353 472450 475250 477082 479987 489888 490076 494062 494409 496750 497467 499134 504672 511722 513299 513690 517990 525523 536262 536271 544782 552430 555801 575065 575484 575618 581229 590165 595512 597041 597560 597968 598479 598599 600159 600945 604180 615148 619780 632118 632593 637851 639959 646662 658728 660321 670997 671616 681198 690439 691217 698434 708413 709589 714667 714994 716633 717902 719292 720749 720967 721322 723539 726176 728404 742161 742242 743069 746802 747153 747502 753304 753327 753351 755677 756687 760908 775919 791663 806332 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick teen"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член teen"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член teen"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.92%) |
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.