Query Metrics
7
Database Queries
7
Different statements
217.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.83 ms (88.13%) |
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 340613 405712 414339 415905 416943 418130 420768 420804 434314 434318 434345 434443 435343 437518 444322 446745 447550 454594 457812 457837 463855 466588 467888 474539 476164 476214 476417 478055 478775 493022 494411 494807 499872 500288 511372 514034 524219 530789 531173 531194 531261 532737 532741 532779 532837 533371 533556 534988 535644 536340 536579 536608 537771 539557 540291 542904 546200 547241 554742 555062 568742 578258 584351 584355 587184 598105 598233 600290 621653 623265 630869 634122 639762 639803 640530 656568 657514 663567 671054 676107 677022 677801 677986 678161 685807 690623 690634 697101 704526 706466 707678 718955 724912 736802 742327 742342 743563 747140 749691 750448 753554 757012 757586 758861 764082 770382 781260 782616 782731 786932 791303 792871 795542 795919 805975 807235 814132 815536 818307 818905 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (7.19%) |
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 743563 749691 757012 706466 791303 447550 416943 584351 499872 420804 524219 457812 707678 805975 598105 494807 578258 511372 587184 542904 568742 555062 474539 446745 478055 434443 546200 500288 476164 444322 554742 418130 435343 437518 434345 434314 466588 434318 457837 454594 476214 494411 493022 405712 414339 420768 532779 533371 536340 536608 537771 540291 532737 532741 533556 536579 531173 531261 532837 535644 530789 531194 678161 677801 677986 704526 676107 640530 639762 600290 634122 747140 770382 463855 478775 415905 467888 598233 547241 630869 534988 340613 656568 476417 814132 815536 818307 818905 514034 539557 584355 657514 671054 697101 718955 663567 677022 685807 690623 690634 621653 639803 623265 782616 782731 795542 795919 807235 781260 792871 742327 750448 753554 758861 786932 724912 757586 742342 764082 736802 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.47%) |
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 340613 405712 414339 415905 416943 418130 420768 420804 434314 434318 434345 434443 435343 437518 444322 446745 447550 454594 457812 457837 463855 466588 467888 474539 476164 476214 476417 478055 478775 493022 494411 494807 499872 500288 511372 514034 524219 530789 531173 531194 531261 532737 532741 532779 532837 533371 533556 534988 535644 536340 536579 536608 537771 539557 540291 542904 546200 547241 554742 555062 568742 578258 584351 584355 587184 598105 598233 600290 621653 623265 630869 634122 639762 639803 640530 656568 657514 663567 671054 676107 677022 677801 677986 678161 685807 690623 690634 697101 704526 706466 707678 718955 724912 736802 742327 742342 743563 747140 749691 750448 753554 757012 757586 758861 764082 770382 781260 782616 782731 786932 791303 792871 795542 795919 805975 807235 814132 815536 818307 818905 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo small tits"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.56%) |
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.