Query Metrics
7
Database Queries
7
Different statements
168.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.09 ms (86.50%) |
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 451083 476614 485238 496952 507549 519253 520178 526328 528574 529368 530203 532373 534044 539162 539574 540169 542967 546193 548247 554108 556269 567978 574260 574423 581885 583432 585553 588138 589191 591914 591946 592598 601504 604199 605632 609208 610115 616517 616636 617356 617754 618175 621005 621615 621990 625831 626121 627479 628921 628942 629622 630144 631073 631816 632679 633981 635755 637224 639278 643786 644227 645071 645328 646545 646713 648144 649866 653100 653102 653126 654329 654417 656538 656580 656616 656632 658933 661427 664454 664473 665080 666660 666678 668068 669310 674494 675150 678249 679879 680300 686794 690214 692372 692919 693677 694130 697578 700271 701212 701669 707412 707562 710007 712477 714194 715379 715521 716952 717150 718346 718614 719500 719987 720217 720319 722046 722810 722880 ] |
||||||||||||||||||||||||||||||
|
12.41 ms (7.35%) |
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 828024 451083 485238 528574 539162 540169 496952 507549 520178 532373 526328 529368 530203 534044 539574 519253 476614 556269 567978 542967 554108 574423 581885 583432 653100 653102 658933 661427 664454 664473 665080 666660 674494 679879 694130 707412 712477 715521 716952 717150 719500 722810 645071 645328 646545 646713 653126 654417 656538 656580 656616 678249 680300 686794 688681 690214 692372 692919 700271 701212 715379 718346 718614 719987 720217 722880 648144 649866 654329 656632 666678 668068 669310 675150 693677 697578 701669 707562 710007 714194 720319 722046 546193 548247 574260 601504 605632 609208 616636 618175 626121 628942 630144 631073 633981 643786 585553 591914 604199 610115 617356 617754 621005 621615 621990 629622 631816 632679 637224 639278 644227 616517 625831 627479 628921 635755 588138 589191 591946 592598 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.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 451083 476614 485238 496952 507549 519253 520178 526328 528574 529368 530203 532373 534044 539162 539574 540169 542967 546193 548247 554108 556269 567978 574260 574423 581885 583432 585553 588138 589191 591914 591946 592598 601504 604199 605632 609208 610115 616517 616636 617356 617754 618175 621005 621615 621990 625831 626121 627479 628921 628942 629622 630144 631073 631816 632679 633981 635755 637224 639278 643786 644227 645071 645328 646545 646713 648144 649866 653100 653102 653126 654329 654417 656538 656580 656616 656632 658933 661427 664454 664473 665080 666660 666678 668068 669310 674494 675150 678249 679879 680300 686794 690214 692372 692919 693677 694130 697578 700271 701212 701669 707412 707562 710007 712477 714194 715379 715521 716952 717150 718346 718614 719500 719987 720217 720319 722046 722810 722880 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie cock"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie cock"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie cock"
]
|
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.