Query Metrics
7
Database Queries
7
Different statements
172.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.31 ms (83.44%) |
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 338311 386782 390021 390209 391110 397037 406206 410967 414973 418949 423584 426777 427550 430811 454677 456849 462870 464955 469827 472169 475082 480368 489958 492266 495259 505534 505836 509278 519713 520253 523219 527065 530730 530777 539609 541618 542737 545394 548601 549695 550585 563079 565985 570218 571819 586590 586678 596051 598268 599674 606396 608359 609780 610241 610255 625928 639310 644091 647645 650338 661873 663088 665840 672554 674035 674751 676421 676538 676575 678910 680580 680745 682741 688333 690179 693302 693643 697311 704987 707324 710807 716897 724502 724553 727684 731014 731898 732422 740036 741625 746141 756400 769584 770181 773131 774761 775770 777782 779738 779817 780565 782729 786428 786549 787435 788290 789760 794238 798968 799402 799727 801526 804594 811237 811390 814293 814797 814837 814847 815542 ] |
||||||||||||||||||||||||||||||
|
17.28 ms (9.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 672554 693643 596051 606396 608359 386782 625928 814837 814847 542737 688333 495259 390021 410967 815542 680745 690179 565985 798968 794238 756400 799727 811390 741625 732422 710807 464955 426777 727684 427550 489958 456849 682741 338311 539609 779817 786549 505836 480368 530777 545394 549695 665840 676538 647645 650338 680580 811237 789760 724502 731898 724553 492266 520253 571819 423584 814797 814293 469827 550585 570218 663088 697311 609780 787435 731014 780565 475082 472169 563079 414973 430811 586590 530730 548601 704987 707324 390209 678910 774761 779738 788290 773131 770181 777782 391110 418949 541618 674035 674751 693302 610241 586678 598268 775770 746141 769584 527065 676575 599674 639310 782729 804594 801526 716897 661873 519713 676421 644091 397037 462870 523219 505534 740036 454677 406206 610255 509278 786428 799402 ] |
||||||||||||||||||||||||||||||
|
3.80 ms (2.20%) |
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 338311 386782 390021 390209 391110 397037 406206 410967 414973 418949 423584 426777 427550 430811 454677 456849 462870 464955 469827 472169 475082 480368 489958 492266 495259 505534 505836 509278 519713 520253 523219 527065 530730 530777 539609 541618 542737 545394 548601 549695 550585 563079 565985 570218 571819 586590 586678 596051 598268 599674 606396 608359 609780 610241 610255 625928 639310 644091 647645 650338 661873 663088 665840 672554 674035 674751 676421 676538 676575 678910 680580 680745 682741 688333 690179 693302 693643 697311 704987 707324 710807 716897 724502 724553 727684 731014 731898 732422 740036 741625 746141 756400 769584 770181 773131 774761 775770 777782 779738 779817 780565 782729 786428 786549 787435 788290 789760 794238 798968 799402 799727 801526 804594 811237 811390 814293 814797 814837 814847 815542 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs massage"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs массаж"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs массаж"
]
|
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.