Query Metrics
7
Database Queries
7
Different statements
174.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.52 ms (86.04%) |
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 66559 386037 386371 406347 416092 416837 417454 417797 418673 419793 420249 421790 425937 440971 445949 447337 447447 450286 454221 460980 466989 467387 471352 473234 473891 474004 474078 474379 477992 485305 486798 490645 494185 497964 499818 501615 502713 507013 509512 516975 517740 521003 521907 523163 532641 550354 551921 556609 557298 559607 560485 561999 564899 570399 577354 577379 588432 589442 589718 590469 591260 592607 595758 596193 599904 600381 607126 615599 615738 619752 623364 626008 631993 647941 673051 675801 679091 682033 697333 710454 712049 714981 715564 717940 719115 719250 720176 721103 721841 722003 726466 728235 730324 732777 737206 742811 743836 748236 748997 753492 766071 770897 771482 776426 785494 792005 804462 807451 808167 808804 812020 813530 815789 815851 817376 819481 820658 821316 822642 827639 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (7.82%) |
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 815789 815851 474004 473891 517740 521003 532641 564899 550354 577354 715564 721103 682033 712049 673051 719250 556609 559607 589442 600381 588432 592607 595758 619752 626008 631993 589718 591260 596193 599904 615738 743836 771482 792005 732777 770897 748236 726466 728235 623364 721841 804462 808804 445949 450286 557298 467387 420249 817376 820658 460980 502713 494185 501615 570399 710454 697333 679091 714981 722003 607126 776426 785494 753492 730324 766071 742811 719115 720176 808167 812020 474078 477992 419793 447447 418673 406347 417454 499818 523163 485305 561999 473234 471352 516975 416837 425937 386371 421790 819481 647941 748997 807451 66559 497964 507013 551921 615599 474379 447337 521907 454221 590469 440971 717940 813530 466989 486798 490645 560485 577379 509512 675801 737206 386037 416092 417797 821316 822642 827639 ] |
||||||||||||||||||||||||||||||
|
3.32 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 66559 386037 386371 406347 416092 416837 417454 417797 418673 419793 420249 421790 425937 440971 445949 447337 447447 450286 454221 460980 466989 467387 471352 473234 473891 474004 474078 474379 477992 485305 486798 490645 494185 497964 499818 501615 502713 507013 509512 516975 517740 521003 521907 523163 532641 550354 551921 556609 557298 559607 560485 561999 564899 570399 577354 577379 588432 589442 589718 590469 591260 592607 595758 596193 599904 600381 607126 615599 615738 619752 623364 626008 631993 647941 673051 675801 679091 682033 697333 710454 712049 714981 715564 717940 719115 719250 720176 721103 721841 722003 726466 728235 730324 732777 737206 742811 743836 748236 748997 753492 766071 770897 771482 776426 785494 792005 804462 807451 808167 808804 812020 813530 815789 815851 817376 819481 820658 821316 822642 827639 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits lick"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ лиза"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.