Query Metrics
7
Database Queries
7
Different statements
182.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.79 ms (85.16%) |
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 394962 402859 404899 411757 412772 418426 420354 420383 429824 457079 459305 460894 461796 465055 465205 469982 470555 470558 472575 475973 476018 477751 480357 482274 485337 488441 492304 496661 498485 504515 510175 522861 531698 531706 531720 545635 545644 546573 549308 550264 552101 552580 552589 552593 562960 568703 571190 574358 574374 574663 580193 580338 583009 604544 606989 607631 616625 619667 631615 638477 648570 656197 659396 660299 660462 661590 666777 668437 668696 669391 672896 678313 687245 692732 701501 702627 705737 715788 721042 722382 722864 724604 727335 728226 734693 743471 750891 751150 754104 754174 757244 761129 766853 767247 770612 774214 776617 784429 786479 788299 789666 790076 790209 794045 794440 797262 799420 802594 804864 806043 811081 811350 811757 812109 812982 815723 819320 821376 825044 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (8.79%) |
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 776617 734693 797262 741836 757244 794045 461796 504515 420354 429824 459305 492304 546573 580193 580338 583009 571190 722382 552593 604544 619667 607631 631615 790076 799420 812982 728226 743471 750891 767247 770612 482274 480357 488441 812109 815723 678313 660299 786479 457079 522861 789666 754174 402859 472575 531698 470558 545635 545644 552589 574358 660462 656197 574374 788299 727335 794440 766853 606989 715788 475973 412772 469982 465205 819320 825044 552580 701501 804864 811081 724604 702627 394962 420383 821376 498485 485337 552101 666777 668437 669391 659396 687245 806043 774214 754104 751150 761129 705737 722864 790209 802594 470555 404899 411757 460894 476018 510175 418426 465055 477751 496661 531706 531720 549308 574663 562960 661590 668696 648570 692732 672896 721042 550264 568703 616625 638477 811350 811757 784429 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.77%) |
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 394962 402859 404899 411757 412772 418426 420354 420383 429824 457079 459305 460894 461796 465055 465205 469982 470555 470558 472575 475973 476018 477751 480357 482274 485337 488441 492304 496661 498485 504515 510175 522861 531698 531706 531720 545635 545644 546573 549308 550264 552101 552580 552589 552593 562960 568703 571190 574358 574374 574663 580193 580338 583009 604544 606989 607631 616625 619667 631615 638477 648570 656197 659396 660299 660462 661590 666777 668437 668696 669391 672896 678313 687245 692732 701501 702627 705737 715788 721042 722382 722864 724604 727335 728226 734693 743471 750891 751150 754104 754174 757244 761129 766853 767247 770612 774214 776617 784429 786479 788299 789666 790076 790209 794045 794440 797262 799420 802594 804864 806043 811081 811350 811757 812109 812982 815723 819320 821376 825044 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"игр секс"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"game sex"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.