Query Metrics
7
Database Queries
7
Different statements
198.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.99 ms (88.74%) |
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 365546 392676 418382 419081 419312 425095 428598 432380 436631 438455 438490 440659 442842 447217 450588 452754 454106 457913 459403 460593 463827 474968 478145 487987 492967 497853 505097 511435 517641 519206 525937 527842 528844 530368 531561 535072 535698 535984 546331 546903 547565 560399 566915 568181 577865 587337 589931 595071 595208 595991 600616 605699 626217 627010 633207 633537 634215 643249 656635 656891 662886 672343 673954 693761 699444 700693 714079 715436 728926 735004 735382 736207 738353 741702 742653 743790 745915 746235 752669 756776 756841 757690 758777 759356 760454 765767 768233 770522 770817 772035 772053 776032 779720 781262 783849 787466 787516 795211 796327 801003 803543 803635 803877 804114 804159 804527 804557 804568 806075 806422 806834 807112 807310 807362 808091 808971 811700 813215 814492 ] |
||||||||||||||||||||||||||||||
|
12.47 ms (6.29%) |
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 595991 633537 634215 589931 787466 795211 807362 811700 776032 804557 806075 806422 808091 808971 756841 781262 803543 770817 756776 759356 772053 738353 742653 765767 770522 633207 715436 779720 803877 804114 807112 425095 428598 454106 492967 519206 517641 568181 547565 560399 595208 546331 365546 442842 814492 459403 447217 463827 457913 460593 487987 511435 497853 528844 535072 535984 505097 530368 531561 546903 566915 577865 656635 656891 672343 693761 700693 662886 673954 595071 600616 643249 587337 626217 627010 783849 801003 804527 804568 736207 768233 772035 787516 803635 813215 741702 752669 758777 745915 760454 728926 735004 735382 746235 757690 699444 714079 796327 804159 806834 807310 432380 450588 392676 440659 438455 525937 605699 474968 527842 743790 826077 438490 418382 419081 436631 419312 535698 452754 478145 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.47%) |
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 365546 392676 418382 419081 419312 425095 428598 432380 436631 438455 438490 440659 442842 447217 450588 452754 454106 457913 459403 460593 463827 474968 478145 487987 492967 497853 505097 511435 517641 519206 525937 527842 528844 530368 531561 535072 535698 535984 546331 546903 547565 560399 566915 568181 577865 587337 589931 595071 595208 595991 600616 605699 626217 627010 633207 633537 634215 643249 656635 656891 662886 672343 673954 693761 699444 700693 714079 715436 728926 735004 735382 736207 738353 741702 742653 743790 745915 746235 752669 756776 756841 757690 758777 759356 760454 765767 768233 770522 770817 772035 772053 776032 779720 781262 783849 787466 787516 795211 796327 801003 803543 803635 803877 804114 804159 804527 804557 804568 806075 806422 806834 807112 807310 807362 808091 808971 811700 813215 814492 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife riding"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен riding"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен riding"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
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.