Query Metrics
7
Database Queries
7
Different statements
200.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.05 ms (80.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 117610 150785 154157 154516 352211 381810 382121 382578 382813 386858 387661 391926 395479 402630 403439 408613 415966 416523 416668 416686 416708 418477 418718 419819 419824 423435 423787 429410 434346 437926 441050 442430 443233 443247 445969 451336 459170 467939 468943 470473 473413 476054 478489 480450 487286 488956 491642 494531 498318 498720 500288 507691 509168 516458 518884 521435 521831 523176 523358 531579 534447 535959 537822 545439 550891 551598 562503 569302 583358 584871 586994 592681 596389 597190 597691 598141 602251 608550 620891 625227 634071 638674 638744 641807 641997 643159 648649 671045 680249 683297 686106 695869 698405 707432 717514 738496 739125 739131 739145 749259 751546 752632 752633 752636 752660 752683 752767 756773 763739 765712 766415 770270 782791 788118 796640 799693 807590 808265 808998 810852 ] |
||||||||||||||||||||||||||||||
|
27.22 ms (13.61%) |
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 671045 680249 683297 686106 695869 545439 551598 583358 620891 634071 641807 592681 597691 608550 638744 597190 598141 625227 641997 788118 810852 796640 752683 799693 807590 808265 808998 739125 752632 766415 739131 739145 749259 752660 738496 751546 770270 752633 752636 752767 763739 765712 602251 707432 717514 416708 423787 434346 442430 443233 476054 382578 386858 391926 416686 468943 478489 403439 480450 416523 416668 419819 423435 437926 451336 459170 470473 441050 509168 491642 518884 531579 498318 521435 117610 154157 154516 352211 382121 381810 387661 402630 408613 429410 445969 498720 516458 523176 494531 535959 537822 507691 534447 488956 584871 562503 550891 648649 698405 596389 586994 638674 643159 756773 782791 150785 395479 418477 382813 418718 487286 415966 419824 443247 473413 467939 500288 521831 523358 569302 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.33%) |
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 117610 150785 154157 154516 352211 381810 382121 382578 382813 386858 387661 391926 395479 402630 403439 408613 415966 416523 416668 416686 416708 418477 418718 419819 419824 423435 423787 429410 434346 437926 441050 442430 443233 443247 445969 451336 459170 467939 468943 470473 473413 476054 478489 480450 487286 488956 491642 494531 498318 498720 500288 507691 509168 516458 518884 521435 521831 523176 523358 531579 534447 535959 537822 545439 550891 551598 562503 569302 583358 584871 586994 592681 596389 597190 597691 598141 602251 608550 620891 625227 634071 638674 638744 641807 641997 643159 648649 671045 680249 683297 686106 695869 698405 707432 717514 738496 739125 739131 739145 749259 751546 752632 752633 752636 752660 752683 752767 756773 763739 765712 766415 770270 782791 788118 796640 799693 807590 808265 808998 810852 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд xxx"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд xxx"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo xxx"
]
|
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.