Query Metrics
7
Database Queries
7
Different statements
151.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.63 ms (84.24%) |
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 394173 394581 414302 419474 422495 426180 427486 432389 432785 443020 452766 453049 459122 473134 479538 481244 484520 494096 507006 509342 513836 514865 516832 519106 520939 522300 524071 524352 528191 531707 532326 539956 551688 552209 552597 552948 553689 554626 555076 555088 560186 560424 562482 563104 564452 567767 568116 568568 577509 584450 585873 586254 588338 588649 590485 591461 594305 598399 601183 604760 613183 618104 620237 620820 624600 624938 625206 630448 636574 656320 670295 672317 674388 677153 689415 690050 691462 692816 693628 711555 714620 714895 716566 719461 724888 724954 728625 733498 734256 739847 744313 746154 754158 757467 759121 759754 761949 764247 764806 766707 767769 772517 772759 775992 778584 779904 780030 781234 785624 785947 788828 794183 795963 796155 798053 800470 802001 807522 809354 812448 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (9.61%) |
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 479538 484520 507006 522300 524071 524352 531707 532326 539956 516832 528191 509342 519106 520939 494096 513836 514865 473134 551688 552948 553689 554626 564452 568568 552209 552597 584450 562482 563104 567767 568116 577509 656320 674388 677153 689415 692816 711555 690050 714620 714895 670295 672317 691462 693628 719461 555076 555088 560186 560424 585873 588649 590485 594305 598399 604760 636574 620237 624938 625206 630448 586254 588338 591461 601183 613183 618104 620820 624600 778584 779904 781234 785947 796155 812448 780030 798053 800470 807522 809354 724954 728625 764247 772517 772759 794183 795963 802001 734256 754158 759754 764806 766707 759121 767769 744313 746154 757467 724888 733498 739847 761949 716566 775992 785624 788828 394581 419474 427486 432389 432785 443020 394173 414302 422495 452766 453049 481244 426180 459122 ] |
||||||||||||||||||||||||||||||
|
2.98 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 394173 394581 414302 419474 422495 426180 427486 432389 432785 443020 452766 453049 459122 473134 479538 481244 484520 494096 507006 509342 513836 514865 516832 519106 520939 522300 524071 524352 528191 531707 532326 539956 551688 552209 552597 552948 553689 554626 555076 555088 560186 560424 562482 563104 564452 567767 568116 568568 577509 584450 585873 586254 588338 588649 590485 591461 594305 598399 601183 604760 613183 618104 620237 620820 624600 624938 625206 630448 636574 656320 670295 672317 674388 677153 689415 690050 691462 692816 693628 711555 714620 714895 716566 719461 724888 724954 728625 733498 734256 739847 744313 746154 754158 757467 759121 759754 761949 764247 764806 766707 767769 772517 772759 775992 778584 779904 780030 781234 785624 785947 788828 794183 795963 796155 798053 800470 802001 807522 809354 812448 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot cum"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot cum"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot cum"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.97%) |
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.