Query Metrics
7
Database Queries
7
Different statements
190.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.40 ms (85.77%) |
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 396572 396581 402013 405508 407223 409484 411841 418400 446333 456048 459229 468791 470131 476739 478665 485556 487191 488085 488088 516206 520477 528024 529204 533960 536242 543260 547663 552398 553109 555508 557562 561392 564528 565054 565932 570718 572028 573874 574097 575830 576329 577976 579281 580713 581092 581825 586692 589950 590078 592062 595150 596131 597700 601332 603955 604222 604425 605941 606152 623330 633085 636279 639459 643233 648150 649903 654026 660351 660732 662162 662436 671296 671396 671523 672588 675049 676776 679297 683663 690154 693182 698282 712803 719934 720803 722529 728730 731869 742224 744291 744652 744846 745075 747690 748129 748660 755630 758554 758876 759541 762646 765357 776196 776219 782089 786720 791975 803097 805675 807945 808909 809718 811507 812109 812876 819597 820766 821463 823480 825693 ] |
||||||||||||||||||||||||||||||
|
16.15 ms (8.48%) |
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 698282 803097 396572 405508 459229 516206 529204 488088 555508 821463 478665 476739 488085 605941 633085 487191 786720 520477 418400 543260 552398 623330 812876 731869 762646 805675 485556 528024 581825 411841 407223 396581 402013 409484 819597 825693 820766 823480 446333 456048 468791 470131 533960 536242 565932 572028 574097 564528 565054 570718 575830 547663 553109 561392 576329 577976 579281 580713 581092 649903 654026 660351 662162 662436 671523 675049 683663 690154 693182 712803 719934 648150 660732 671396 672588 676776 679297 722529 671296 720803 557562 573874 589950 590078 592062 606152 595150 596131 603955 604222 604425 639459 643233 586692 597700 601332 636279 782089 791975 811507 776196 776219 807945 809718 758554 758876 808909 812109 744846 748129 755630 742224 744291 747690 748660 759541 765357 728730 744652 745075 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.86%) |
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 396572 396581 402013 405508 407223 409484 411841 418400 446333 456048 459229 468791 470131 476739 478665 485556 487191 488085 488088 516206 520477 528024 529204 533960 536242 543260 547663 552398 553109 555508 557562 561392 564528 565054 565932 570718 572028 573874 574097 575830 576329 577976 579281 580713 581092 581825 586692 589950 590078 592062 595150 596131 597700 601332 603955 604222 604425 605941 606152 623330 633085 636279 639459 643233 648150 649903 654026 660351 660732 662162 662436 671296 671396 671523 672588 675049 676776 679297 683663 690154 693182 698282 712803 719934 720803 722529 728730 731869 742224 744291 744652 744846 745075 747690 748129 748660 755630 758554 758876 759541 762646 765357 776196 776219 782089 786720 791975 803097 805675 807945 808909 809718 811507 812109 812876 819597 820766 821463 823480 825693 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite big cock"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite большие cock"
]
|
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.