Query Metrics
7
Database Queries
7
Different statements
196.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.80 ms (83.85%) |
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 145314 393729 393767 395192 397473 398805 400984 402087 402588 494718 514470 515096 538271 539915 546703 566522 566984 572611 589699 601689 603940 605321 605543 606124 606260 609866 610089 610243 614538 618901 624238 628516 635247 644681 650002 652252 653220 653737 661905 663377 663502 664492 674256 675514 680036 683536 683608 683774 683804 684583 684596 686065 687492 689579 691197 693217 696260 699009 702674 703510 704788 706298 706321 708399 708431 709539 709703 710959 712919 715415 716482 722656 724572 730579 730600 737417 739934 744897 747568 747832 748584 752149 755961 759660 761071 774079 775621 786824 787948 787955 789203 789299 789313 800119 802632 807537 807938 808266 810316 810587 815845 815888 817014 817064 817475 817621 817893 818073 818351 818723 819376 819563 820592 821699 822938 823083 823424 824521 825804 827964 ] |
||||||||||||||||||||||||||||||
|
19.10 ms (9.72%) |
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 702674 704788 709703 710959 712919 546703 572611 606124 606260 610089 628516 589699 601689 624238 603940 605543 610243 614538 618901 644681 605321 786824 789203 800119 724572 737417 787955 730600 748584 739934 752149 761071 730579 755961 759660 744897 774079 609866 635247 703510 775621 787948 789299 789313 802632 807537 807938 808266 810316 810587 393729 145314 398805 684596 747832 747568 393767 395192 397473 400984 402087 402588 817014 817893 820592 822938 817064 818351 818723 819563 823424 817475 817621 823083 824521 825804 815845 815888 818073 819376 821699 827964 515096 514470 494718 538271 539915 566522 566984 652252 653220 653737 664492 675514 680036 683536 683608 683774 683804 691197 699009 706298 708399 708431 709539 716482 661905 663377 663502 674256 684583 686065 687492 689579 696260 706321 715415 722656 650002 693217 ] |
||||||||||||||||||||||||||||||
|
5.10 ms (2.60%) |
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 145314 393729 393767 395192 397473 398805 400984 402087 402588 494718 514470 515096 538271 539915 546703 566522 566984 572611 589699 601689 603940 605321 605543 606124 606260 609866 610089 610243 614538 618901 624238 628516 635247 644681 650002 652252 653220 653737 661905 663377 663502 664492 674256 675514 680036 683536 683608 683774 683804 684583 684596 686065 687492 689579 691197 693217 696260 699009 702674 703510 704788 706298 706321 708399 708431 709539 709703 710959 712919 715415 716482 722656 724572 730579 730600 737417 739934 744897 747568 747832 748584 752149 755961 759660 761071 774079 775621 786824 787948 787955 789203 789299 789313 800119 802632 807537 807938 808266 810316 810587 815845 815888 817014 817064 817475 817621 817893 818073 818351 818723 819376 819563 820592 821699 822938 823083 823424 824521 825804 827964 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"a young girl"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк"
]
|
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.