Query Metrics
7
Database Queries
7
Different statements
205.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.76 ms (87.99%) |
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 385682 392214 426479 427252 435146 444674 451033 453591 453599 460484 462589 465996 470805 470809 478452 482906 485594 486167 486175 494540 501923 504168 505438 506744 507862 509053 520609 521930 527766 537290 543483 543485 543741 544787 548756 550472 552479 558658 597093 606664 611712 614049 620294 622040 622904 624973 648246 668584 672405 675369 678419 684302 685165 685675 686155 686627 688765 689093 691431 695334 696287 697441 701208 703907 705104 705230 705583 712026 712078 712701 713251 713279 714390 715160 718908 719718 721457 721677 727317 728603 729179 733132 734691 740179 741491 742003 743874 746022 747347 754258 762031 768993 786431 789243 793366 793895 795660 796520 797295 800172 812121 814609 816146 817470 817477 817486 817488 818337 818725 818881 819445 819869 821037 822339 826690 826809 826932 827375 828053 828315 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (6.64%) |
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 465996 426479 462589 451033 453599 501923 485594 482906 385682 826932 817488 821037 818881 826809 648246 675369 697441 721457 685675 793895 793366 742003 741491 727317 733132 754258 734691 768993 786431 812121 453591 427252 435146 470809 470805 494540 521930 505438 486167 550472 558658 444674 460484 486175 506744 504168 527766 817470 817486 827375 818337 828053 828315 520609 715160 701208 614049 796520 800172 740179 746022 729179 728603 747347 789243 795660 797295 543483 712701 743874 762031 719718 537290 548756 606664 392214 826690 817477 818725 819445 819869 822339 814609 816146 478452 507862 509053 543485 543741 552479 678419 684302 688765 703907 713251 714390 718908 686155 689093 691431 705104 705230 712026 721677 668584 672405 685165 686627 695334 696287 705583 712078 713279 544787 622904 624973 620294 622040 597093 611712 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (1.93%) |
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 385682 392214 426479 427252 435146 444674 451033 453591 453599 460484 462589 465996 470805 470809 478452 482906 485594 486167 486175 494540 501923 504168 505438 506744 507862 509053 520609 521930 527766 537290 543483 543485 543741 544787 548756 550472 552479 558658 597093 606664 611712 614049 620294 622040 622904 624973 648246 668584 672405 675369 678419 684302 685165 685675 686155 686627 688765 689093 691431 695334 696287 697441 701208 703907 705104 705230 705583 712026 712078 712701 713251 713279 714390 715160 718908 719718 721457 721677 727317 728603 729179 733132 734691 740179 741491 742003 743874 746022 747347 754258 762031 768993 786431 789243 793366 793895 795660 796520 797295 800172 812121 814609 816146 817470 817477 817486 817488 818337 818725 818881 819445 819869 821037 822339 826690 826809 826932 827375 828053 828315 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex hidden"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.