Query Metrics
7
Database Queries
7
Different statements
369.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.72 ms (57.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск горничн"
]
|
||||||||||||||||||||||||||||||
|
135.50 ms (36.71%) |
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 544917 563452 591000 596179 598081 602796 610380 618695 619299 619307 641049 642245 642291 652997 654398 658014 669344 675755 677919 689784 692833 699877 700513 704113 705007 705861 708164 710959 712467 714929 718543 721463 724848 725273 725434 725494 730693 730784 731042 733161 735943 735958 736338 738279 738315 739459 741468 741761 742317 742766 743801 744423 745830 746760 747801 748437 749801 750034 751289 752077 752103 757612 757762 757803 757860 758093 764158 764624 766411 766518 766861 767670 769076 771407 771447 772150 772794 773185 773394 776572 776577 779316 779421 779475 779686 781416 781686 781690 782122 782284 783546 783602 785242 786294 786396 786478 786655 787302 789649 789813 789919 791315 792032 792707 792723 794698 795060 795207 795677 795960 796481 797745 799817 799846 801120 801270 804898 806040 807849 809977 ] |
||||||||||||||||||||||||||||||
|
13.15 ms (3.56%) |
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 669344 675755 689784 692833 705007 712467 714929 721463 652997 654398 658014 677919 699877 705861 708164 710959 544917 563452 598081 619307 642245 602796 610380 642291 596179 619299 591000 783602 786396 786655 791315 799817 801270 804898 807849 776572 779316 779475 779686 782284 783546 789813 789919 792032 792723 794698 795060 795677 806040 809977 725273 725434 725494 736338 738315 742317 746760 752077 766518 769076 771447 781690 782122 789649 792707 795207 795960 796481 797745 799846 801120 731042 735943 741468 741761 743801 745830 747801 751289 757762 757803 772150 724848 739459 744423 752103 757860 764158 764624 766411 767670 773185 730693 733161 738279 758093 766861 771407 772794 773394 730784 735958 742766 748437 749801 750034 757612 618695 641049 700513 704113 718543 776577 779421 781416 781686 785242 786294 786478 787302 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (0.86%) |
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 544917 563452 591000 596179 598081 602796 610380 618695 619299 619307 641049 642245 642291 652997 654398 658014 669344 675755 677919 689784 692833 699877 700513 704113 705007 705861 708164 710959 712467 714929 718543 721463 724848 725273 725434 725494 730693 730784 731042 733161 735943 735958 736338 738279 738315 739459 741468 741761 742317 742766 743801 744423 745830 746760 747801 748437 749801 750034 751289 752077 752103 757612 757762 757803 757860 758093 764158 764624 766411 766518 766861 767670 769076 771407 771447 772150 772794 773185 773394 776572 776577 779316 779421 779475 779686 781416 781686 781690 782122 782284 783546 783602 785242 786294 786396 786478 786655 787302 789649 789813 789919 791315 792032 792707 792723 794698 795060 795207 795677 795960 796481 797745 799817 799846 801120 801270 804898 806040 807849 809977 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian maid"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.51%) |
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.