Query Metrics
7
Database Queries
7
Different statements
170.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.54 ms (83.21%) |
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 382492 396345 397396 398900 428724 440641 440644 440711 444027 446049 446656 447712 449575 450162 450968 451163 452363 457993 459098 465680 469937 476801 477247 481516 484939 494313 496959 498332 500947 503370 504791 507628 508672 510199 510200 517749 522846 525315 525729 526069 527016 527271 528124 531867 537857 544011 547868 556501 556550 556586 556967 562224 562456 567875 568134 568738 568759 572266 574243 574742 586028 586665 587212 592605 595612 597689 598975 599503 600436 603330 603757 604782 607679 611192 613530 613676 614549 617596 619175 621661 623622 627724 628037 678989 683658 683661 684704 690648 695898 701199 714084 718044 721311 727997 730906 734825 736164 740556 747673 755554 764213 777989 781429 781853 781925 785213 786726 791042 797750 800887 801722 806683 808573 809081 809891 810596 811736 812531 814043 825561 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (10.59%) |
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 721311 567875 396345 764213 382492 574742 814043 481516 494313 498332 690648 781429 810596 484939 556550 568134 587212 603330 781925 531867 528124 809891 537857 678989 617596 800887 801722 736164 781853 457993 526069 730906 611192 446049 797750 508672 477247 450162 527271 683658 718044 695898 747673 791042 440711 465680 599503 604782 628037 600436 613676 811736 755554 785213 727997 701199 547868 777989 740556 806683 449575 459098 447712 469937 503370 556586 544011 786726 808573 812531 734825 397396 440641 450968 614549 527016 525315 517749 398900 825561 446656 562224 627724 595612 809081 444027 496959 440644 556967 568738 556501 684704 562456 572266 714084 683661 592605 607679 603757 621661 500947 568759 613530 451163 525729 586665 574243 504791 598975 522846 507628 510200 586028 510199 476801 452363 428724 623622 619175 597689 ] |
||||||||||||||||||||||||||||||
|
4.05 ms (2.38%) |
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 382492 396345 397396 398900 428724 440641 440644 440711 444027 446049 446656 447712 449575 450162 450968 451163 452363 457993 459098 465680 469937 476801 477247 481516 484939 494313 496959 498332 500947 503370 504791 507628 508672 510199 510200 517749 522846 525315 525729 526069 527016 527271 528124 531867 537857 544011 547868 556501 556550 556586 556967 562224 562456 567875 568134 568738 568759 572266 574243 574742 586028 586665 587212 592605 595612 597689 598975 599503 600436 603330 603757 604782 607679 611192 613530 613676 614549 617596 619175 621661 623622 627724 628037 678989 683658 683661 684704 690648 695898 701199 714084 718044 721311 727997 730906 734825 736164 740556 747673 755554 764213 777989 781429 781853 781925 785213 786726 791042 797750 800887 801722 806683 808573 809081 809891 810596 811736 812531 814043 825561 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits shaking"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ shaking"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ shaking"
]
|
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.