Query Metrics
7
Database Queries
7
Different statements
206.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.96 ms (86.56%) |
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 33727 96761 191393 233670 326039 359134 366011 412980 439569 443766 446622 455051 458012 462324 464382 464449 471893 474784 477959 478446 482333 485686 488883 488951 493187 493210 504214 508082 511257 512063 531434 531452 534851 535532 537599 537857 544960 546939 552250 553305 554328 563223 567338 567423 579938 584073 595992 601843 619482 621319 622377 622829 623362 624474 634849 646833 647984 649971 650494 651077 661568 663501 664322 666115 666791 666849 668192 669771 670482 671701 673365 673649 681154 681182 683826 684934 689012 711997 712827 715537 717724 717880 721563 722099 724403 724532 724706 725596 729214 729266 730735 730758 732799 735829 736393 740125 741607 753204 756246 757244 759877 760002 773897 792686 792822 795143 801210 801475 803081 803088 803424 803776 804991 813255 815772 817412 817781 817843 820068 820679 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.45%) |
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 671701 681154 711997 717880 649971 721563 681182 722099 544960 579938 624474 803776 804991 795143 724532 740125 803088 813255 724706 753204 724403 729266 725596 730758 735829 736393 773897 757244 96761 359134 443766 233670 366011 512063 504214 511257 493210 584073 563223 567338 623362 474784 462324 326039 33727 191393 439569 412980 820068 820679 815772 817412 817781 817843 464382 471893 477959 488883 493187 446622 464449 478446 485686 488951 455051 458012 534851 535532 537599 537857 508082 531434 531452 482333 553305 552250 554328 646833 650494 661568 666115 666791 669771 717724 663501 664322 666849 668192 673649 683826 684934 647984 651077 670482 673365 689012 712827 715537 546939 567423 621319 634849 595992 622829 601843 619482 622377 792686 792822 801210 801475 803424 729214 730735 732799 760002 803081 741607 756246 759877 ] |
||||||||||||||||||||||||||||||
|
4.71 ms (2.28%) |
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 33727 96761 191393 233670 326039 359134 366011 412980 439569 443766 446622 455051 458012 462324 464382 464449 471893 474784 477959 478446 482333 485686 488883 488951 493187 493210 504214 508082 511257 512063 531434 531452 534851 535532 537599 537857 544960 546939 552250 553305 554328 563223 567338 567423 579938 584073 595992 601843 619482 621319 622377 622829 623362 624474 634849 646833 647984 649971 650494 651077 661568 663501 664322 666115 666791 666849 668192 669771 670482 671701 673365 673649 681154 681182 683826 684934 689012 711997 712827 715537 717724 717880 721563 722099 724403 724532 724706 725596 729214 729266 730735 730758 732799 735829 736393 740125 741607 753204 756246 757244 759877 760002 773897 792686 792822 795143 801210 801475 803081 803088 803424 803776 804991 813255 815772 817412 817781 817843 820068 820679 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature kissing"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature kissing"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature kissing"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.73%) |
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.