Query Metrics
7
Database Queries
7
Different statements
363.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.80 ms (58.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член cum вебкамер"
]
|
||||||||||||||||||||||||||||||
|
132.90 ms (36.55%) |
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 417034 419231 420655 427469 427911 433707 453920 454037 458127 460845 461026 478148 480983 489699 507915 515327 534731 542082 545920 546563 559709 580247 583314 585280 589030 591753 597448 613150 616450 620581 629581 631032 635782 639503 640254 643807 644384 659172 677440 690717 695182 695759 697900 698249 700361 703968 706750 711633 712141 716781 719033 719337 721148 724747 726313 726399 726888 726899 727729 727944 728711 729018 729255 729304 730199 730766 731120 733184 734036 734623 734934 739592 741521 741932 743364 743795 743990 745554 747396 747982 749640 749913 750340 750591 751943 756296 756354 759089 759617 760445 760591 763335 764124 764135 767277 772376 774711 782043 783086 785526 786851 788419 788496 790706 791028 791663 791667 793488 794971 797217 800357 801445 803440 803909 806712 810845 813305 813946 820316 826195 ] |
||||||||||||||||||||||||||||||
|
10.66 ms (2.93%) |
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 698249 706750 716781 546563 620581 640254 639503 644384 597448 635782 613150 782043 791028 791663 810845 813305 786851 793488 794971 726888 727729 729018 730199 751943 767277 800357 803440 803909 734036 759089 759617 772376 724747 726313 726899 733184 734623 745554 747396 750340 750591 756296 764124 764135 728711 729255 730766 739592 743364 743990 747982 760445 729304 731120 734934 741521 743795 749640 749913 756354 760591 763335 629581 631032 643807 697900 700361 703968 711633 712141 719337 788419 801445 806712 460845 507915 417034 453920 677440 719033 790706 797217 727944 726399 741932 433707 515327 534731 454037 419231 480983 420655 478148 427469 542082 695182 427911 813946 820316 826195 458127 461026 489699 580247 545920 559709 690717 659172 695759 721148 583314 585280 589030 591753 616450 774711 783086 785526 788496 791667 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (0.89%) |
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 417034 419231 420655 427469 427911 433707 453920 454037 458127 460845 461026 478148 480983 489699 507915 515327 534731 542082 545920 546563 559709 580247 583314 585280 589030 591753 597448 613150 616450 620581 629581 631032 635782 639503 640254 643807 644384 659172 677440 690717 695182 695759 697900 698249 700361 703968 706750 711633 712141 716781 719033 719337 721148 724747 726313 726399 726888 726899 727729 727944 728711 729018 729255 729304 730199 730766 731120 733184 734036 734623 734934 739592 741521 741932 743364 743795 743990 745554 747396 747982 749640 749913 750340 750591 751943 756296 756354 759089 759617 760445 760591 763335 764124 764135 767277 772376 774711 782043 783086 785526 786851 788419 788496 790706 791028 791663 791667 793488 794971 797217 800357 801445 803440 803909 806712 810845 813305 813946 820316 826195 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick cum webcam"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член cum вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.43%) |
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.