Query Metrics
7
Database Queries
7
Different statements
612.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
226.35 ms (36.98%) |
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 727741 735404 761555 773470 731310 733416 738583 738868 753072 760730 602806 607149 614748 630376 639655 714256 778864 785540 793934 794995 796270 134506 187819 122767 428089 485986 523596 454549 499921 502590 536427 632018 729999 727334 762848 527258 387192 814092 822426 814713 815521 818613 823944 826232 472690 456067 531275 533679 521157 537665 531161 478524 548419 548458 578759 580561 680442 681012 681106 699599 666712 674284 680436 681076 683290 661023 670210 717900 569764 590441 595767 605950 598433 599796 624800 590691 617817 774609 787294 788803 789605 793438 798572 800667 775841 776749 786511 789109 791974 805607 809241 809470 731417 734373 740847 747135 748757 770143 783281 796354 811470 726278 757867 726651 727754 733024 740599 744593 749553 757226 765515 773482 728738 729286 751581 763561 735017 761306 770530 604353 ] |
||||||||||||||||||||||||||||||
|
214.19 ms (35.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
161.61 ms (26.41%) |
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 122767 134506 187819 387192 428089 454549 456067 472690 478524 485986 499921 502590 521157 523596 527258 531161 531275 533679 536427 537665 548419 548458 569764 578759 580561 590441 590691 595767 598433 599796 602806 604353 605950 607149 614748 617817 624800 630376 632018 639655 661023 666712 670210 674284 680436 680442 681012 681076 681106 683290 699599 714256 717900 726278 726651 727334 727741 727754 728738 729286 729999 731310 731417 733024 733416 734373 735017 735404 738583 738868 740599 740847 744593 747135 748757 749553 751581 753072 757226 757867 760730 761306 761555 762848 763561 765515 770143 770530 773470 773482 774609 775841 776749 778864 783281 785540 786511 787294 788803 789109 789605 791974 793438 793934 794995 796270 796354 798572 800667 805607 809241 809470 811470 814092 814713 815521 818613 822426 823944 826232 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (0.57%) |
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 122767 134506 187819 387192 428089 454549 456067 472690 478524 485986 499921 502590 521157 523596 527258 531161 531275 533679 536427 537665 548419 548458 569764 578759 580561 590441 590691 595767 598433 599796 602806 604353 605950 607149 614748 617817 624800 630376 632018 639655 661023 666712 670210 674284 680436 680442 681012 681076 681106 683290 699599 714256 717900 726278 726651 727334 727741 727754 728738 729286 729999 731310 731417 733024 733416 734373 735017 735404 738583 738868 740599 740847 744593 747135 748757 749553 751581 753072 757226 757867 760730 761306 761555 762848 763561 765515 770143 770530 773470 773482 774609 775841 776749 778864 783281 785540 786511 787294 788803 789109 789605 791974 793438 793934 794995 796270 796354 798572 800667 805607 809241 809470 811470 814092 814713 815521 818613 822426 823944 826232 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.30%) |
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.