Query Metrics
7
Database Queries
7
Different statements
191.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.51 ms (86.65%) |
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 27593 34428 98951 384796 386430 386925 389355 390455 392676 394035 396779 407176 425095 428598 442842 447217 454106 459403 466793 490807 505097 511435 515662 528844 530112 531561 535072 535694 535984 539591 544704 546500 546903 547100 548305 549897 570824 571785 578598 582435 584223 595071 595386 595389 595991 601199 613780 618675 623941 627010 633207 634215 639986 647306 672343 693701 695707 709848 720193 721712 723774 726115 730620 732971 738852 751245 752669 757650 757715 758777 759343 759356 760454 762118 765767 767675 768233 768937 770522 787254 787466 787516 793482 793676 793815 796327 796706 799382 800537 801686 802415 803543 803635 803877 804114 804527 804557 804568 806075 806422 807112 807310 807362 807787 811120 811251 811700 817563 817570 819262 824560 824868 824962 826161 828415 828760 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (7.99%) |
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 799382 800537 767675 793815 796706 762118 738852 757650 757715 618675 801686 811120 407176 490807 802415 793482 390455 571785 613780 98951 768937 34428 386925 819262 824868 466793 530112 535694 721712 695707 720193 693701 578598 595389 595991 634215 787466 807362 811700 804557 806075 806422 803543 759356 765767 770522 633207 803877 804114 807112 425095 428598 454106 824210 828760 828415 726115 822371 539591 549897 27593 824560 793676 732971 759343 751245 822273 822882 623941 389355 442842 459403 447217 511435 528844 535072 535984 505097 531561 544704 546903 582435 584223 672343 709848 595071 601199 595386 627010 804527 804568 768233 787516 803635 752669 758777 760454 796327 807310 807787 392676 515662 723774 386430 384796 394035 396779 817563 817570 824962 547100 546500 548305 570824 647306 639986 787254 811251 730620 826161 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.63%) |
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 27593 34428 98951 384796 386430 386925 389355 390455 392676 394035 396779 407176 425095 428598 442842 447217 454106 459403 466793 490807 505097 511435 515662 528844 530112 531561 535072 535694 535984 539591 544704 546500 546903 547100 548305 549897 570824 571785 578598 582435 584223 595071 595386 595389 595991 601199 613780 618675 623941 627010 633207 634215 639986 647306 672343 693701 695707 709848 720193 721712 723774 726115 730620 732971 738852 751245 752669 757650 757715 758777 759343 759356 760454 762118 765767 767675 768233 768937 770522 787254 787466 787516 793482 793676 793815 796327 796706 799382 800537 801686 802415 803543 803635 803877 804114 804527 804557 804568 806075 806422 807112 807310 807362 807787 811120 811251 811700 817563 817570 819262 824560 824868 824962 826161 828415 828760 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding milf"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding milf"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding milf"
]
|
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.