Query Metrics
7
Database Queries
7
Different statements
140.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.33 ms (83.73%) |
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 185950 206202 383436 385706 390497 393779 393782 395654 395942 396184 396522 398595 399515 400454 400715 402013 404127 404360 404552 410147 412227 413243 461906 463168 482798 492392 501442 515140 515234 524001 545959 550094 562312 567153 569677 572197 575723 586624 587431 595470 598989 601829 610021 614386 618774 626539 626735 627748 628300 632835 640144 643653 649130 656761 662436 665512 671598 674400 675729 676445 677015 677311 677690 684965 685588 685687 685891 693075 693341 701444 701846 702740 705808 706601 706909 716719 717649 717895 718627 721846 723492 724509 728242 734715 737168 739518 740704 745388 751500 753815 753954 755735 773098 774512 775979 780713 783906 788686 788958 789032 789202 789457 790249 793464 797247 799292 800275 804894 811239 812105 815855 815999 817317 817482 819573 819613 821068 822694 826672 827328 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (9.69%) |
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 739518 773098 737168 705808 396522 492392 400454 463168 383436 718627 628300 614386 734715 755735 783906 515234 569677 677690 685588 610021 626539 790249 789457 740704 395654 399515 501442 515140 693075 185950 396184 402013 815855 822694 575723 572197 662436 693341 717895 545959 586624 595470 598989 601829 627748 618774 804894 797247 812105 724509 800275 404127 753815 567153 721846 461906 390497 393779 482798 676445 701846 745388 793464 716719 206202 775979 524001 706909 412227 413243 665512 701444 675729 684965 717649 685891 751500 811239 728242 789032 393782 562312 723492 398595 395942 789202 706601 385706 400715 404360 404552 410147 817482 826672 815999 819573 819613 827328 817317 821068 550094 656761 671598 677015 674400 685687 649130 677311 702740 640144 643653 626735 632835 587431 780713 788686 788958 799292 774512 753954 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.97%) |
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 185950 206202 383436 385706 390497 393779 393782 395654 395942 396184 396522 398595 399515 400454 400715 402013 404127 404360 404552 410147 412227 413243 461906 463168 482798 492392 501442 515140 515234 524001 545959 550094 562312 567153 569677 572197 575723 586624 587431 595470 598989 601829 610021 614386 618774 626539 626735 627748 628300 632835 640144 643653 649130 656761 662436 665512 671598 674400 675729 676445 677015 677311 677690 684965 685588 685687 685891 693075 693341 701444 701846 702740 705808 706601 706909 716719 717649 717895 718627 721846 723492 724509 728242 734715 737168 739518 740704 745388 751500 753815 753954 755735 773098 774512 775979 780713 783906 788686 788958 789032 789202 789457 790249 793464 797247 799292 800275 804894 811239 812105 815855 815999 817317 817482 819573 819613 821068 822694 826672 827328 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob young"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс young"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (1.00%) |
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.