Query Metrics
7
Database Queries
7
Different statements
144.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.97 ms (85.05%) |
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 389683 390907 392086 400883 418565 441808 446345 462681 463312 474816 479324 487205 510637 510788 520856 526351 531394 543702 546273 547917 566287 578722 581739 590328 595538 600874 608545 615184 616379 616604 620974 622853 625937 639243 641153 647119 652169 658837 659324 662443 664473 668085 668099 668944 678711 678876 680370 684477 684487 689994 690931 691527 695552 696198 697496 701897 704169 705139 707148 708578 710015 710092 710893 712386 713335 715800 716359 716994 717758 718614 719225 719280 720026 721091 722434 723010 727564 730858 733176 734277 734330 734401 737856 739324 742069 742121 744060 747368 748334 756144 765099 765456 770810 776042 777875 778155 782297 784292 784883 786056 787252 791246 791538 792683 796382 796916 798834 800975 806681 806821 818826 820757 822651 822838 823359 825645 825794 825996 827784 ] |
||||||||||||||||||||||||||||||
|
12.37 ms (8.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 792683 723010 778155 510788 659324 652169 595538 791538 739324 756144 742069 744060 717758 668085 696198 668944 705139 647119 668099 715800 608545 641153 616604 796916 784292 791246 734330 734401 737856 747368 625937 776042 441808 474816 487205 446345 479324 719225 765099 390907 392086 418565 547917 566287 678876 684477 689994 708578 710092 691527 712386 546273 581739 590328 639243 777875 784883 786056 787252 798834 806821 796382 782297 806681 742121 730858 734277 389683 713335 658837 620974 800975 770810 772131 733176 765456 727564 748334 510637 526351 695552 600874 823359 462681 463312 684487 400883 820757 822838 825996 822651 825645 825794 818826 827784 531394 520856 578722 543702 664473 697496 707148 720026 721091 701897 704169 716994 718614 719280 662443 678711 680370 690931 710015 710893 716359 722434 615184 616379 622853 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.95%) |
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 389683 390907 392086 400883 418565 441808 446345 462681 463312 474816 479324 487205 510637 510788 520856 526351 531394 543702 546273 547917 566287 578722 581739 590328 595538 600874 608545 615184 616379 616604 620974 622853 625937 639243 641153 647119 652169 658837 659324 662443 664473 668085 668099 668944 678711 678876 680370 684477 684487 689994 690931 691527 695552 696198 697496 701897 704169 705139 707148 708578 710015 710092 710893 712386 713335 715800 716359 716994 717758 718614 719225 719280 720026 721091 722434 723010 727564 730858 733176 734277 734330 734401 737856 739324 742069 742121 744060 747368 748334 756144 765099 765456 770810 776042 777875 778155 782297 784292 784883 786056 787252 791246 791538 792683 796382 796916 798834 800975 806681 806821 818826 820757 822651 822838 823359 825645 825794 825996 827784 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real teen girl"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.