Query Metrics
7
Database Queries
7
Different statements
171.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.40 ms (85.37%) |
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 384108 391992 415879 416607 416668 416682 416712 419644 423787 424606 432613 432673 439031 441120 443236 443260 444283 444537 448351 448791 449406 451336 452800 455080 459198 466739 467633 467634 468943 469737 470473 470479 471074 476163 476710 477506 477761 479832 483730 485471 487414 500338 507935 512027 512442 514233 518187 518884 522143 524346 531583 531866 534574 541394 541421 546129 547854 550925 552710 557720 560337 561034 564291 567172 581064 597691 604228 607569 609889 622720 625780 629602 632887 641997 642022 655010 662448 669057 670368 672925 672939 680249 683297 688990 696593 703619 722395 724459 735563 739145 748491 749221 749255 752617 752623 752636 752643 752711 757466 764280 766415 766433 766943 770254 772579 776031 778172 782050 796640 796678 796695 801643 807142 808548 809015 809371 811696 816126 824733 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (8.99%) |
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 807147 808548 749221 766943 748491 764280 770254 752617 622720 801643 809015 604228 816126 541394 811696 642022 432613 424606 439031 416607 416682 432673 470479 471074 485471 487414 448351 512442 518187 467633 476163 567172 561034 672939 722395 669057 670368 680249 683297 597691 641997 796640 766415 739145 752636 423787 468943 416668 451336 470473 518884 415879 443260 444537 452800 455080 448791 469737 483730 534574 500338 662448 449406 724459 524346 531583 531866 522143 541421 564291 547854 550925 672925 703619 655010 546129 552710 632887 629602 607569 776031 778172 796695 807142 766433 772579 752643 752711 752623 757466 749255 609889 796678 809371 824733 479832 384108 441120 443236 416712 444283 467634 507935 514233 557720 391992 477761 459198 688990 560337 466739 477506 625780 782050 735563 419644 476710 512027 581064 696593 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.62%) |
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 384108 391992 415879 416607 416668 416682 416712 419644 423787 424606 432613 432673 439031 441120 443236 443260 444283 444537 448351 448791 449406 451336 452800 455080 459198 466739 467633 467634 468943 469737 470473 470479 471074 476163 476710 477506 477761 479832 483730 485471 487414 500338 507935 512027 512442 514233 518187 518884 522143 524346 531583 531866 534574 541394 541421 546129 547854 550925 552710 557720 560337 561034 564291 567172 581064 597691 604228 607569 609889 622720 625780 629602 632887 641997 642022 655010 662448 669057 670368 672925 672939 680249 683297 688990 696593 703619 722395 724459 735563 739145 748491 749221 749255 752617 752623 752636 752643 752711 757466 764280 766415 766433 766943 770254 772579 776031 778172 782050 796640 796678 796695 801643 807142 808548 809015 809371 811696 816126 824733 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo homemade"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.90%) |
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.