Query Metrics
7
Database Queries
7
Different statements
178.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.87 ms (86.64%) |
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 31941 50537 63344 117905 388135 416240 422064 423982 438127 438655 444187 447138 448396 459472 459515 469464 473129 473764 478520 495172 499302 499350 499941 504553 515531 519158 530413 534443 542423 544147 549502 554699 555573 555738 568803 577309 581645 584355 585645 593545 596144 596623 596905 597435 604800 618329 620219 628261 628756 636587 636702 639652 642995 650113 650143 650928 659237 660283 663293 675397 678761 678924 679266 690667 694751 699655 700981 701968 702375 702376 704662 706720 708989 709061 713940 717453 718817 719431 726164 732567 736052 741237 743184 749645 754434 759115 759146 762155 764414 770039 776427 778448 780266 780357 782305 782831 785821 786932 787069 787275 789054 791479 791896 794082 802946 804440 804937 805234 806010 806468 807028 808335 808540 809704 810041 810390 811785 812751 824102 826720 ] |
||||||||||||||||||||||||||||||
|
14.21 ms (7.95%) |
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 447138 448396 459472 438127 444187 473129 499302 504553 495172 499350 50537 63344 826720 469464 581645 544147 702376 650113 659237 679266 701968 713940 718817 660283 675397 678761 690667 704662 709061 719431 549502 554699 555573 568803 628261 618329 620219 604800 639652 642995 596905 780357 805234 808335 776427 780266 782831 806010 736052 787069 794082 804937 762155 754434 700981 702375 791896 802946 804440 807028 810041 31941 759146 423982 416240 459515 694751 650928 585645 596144 628756 778448 789054 808540 810390 422064 473764 478520 388135 809704 596623 438655 812751 732567 117905 824102 519158 530413 499941 515531 534443 542423 584355 555738 577309 706720 663293 699655 708989 717453 650143 678924 636587 593545 597435 636702 785821 806468 741237 782305 786932 787275 791479 811785 726164 770039 759115 764414 743184 749645 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.61%) |
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 31941 50537 63344 117905 388135 416240 422064 423982 438127 438655 444187 447138 448396 459472 459515 469464 473129 473764 478520 495172 499302 499350 499941 504553 515531 519158 530413 534443 542423 544147 549502 554699 555573 555738 568803 577309 581645 584355 585645 593545 596144 596623 596905 597435 604800 618329 620219 628261 628756 636587 636702 639652 642995 650113 650143 650928 659237 660283 663293 675397 678761 678924 679266 690667 694751 699655 700981 701968 702375 702376 704662 706720 708989 709061 713940 717453 718817 719431 726164 732567 736052 741237 743184 749645 754434 759115 759146 762155 764414 770039 776427 778448 780266 780357 782305 782831 785821 786932 787069 787275 789054 791479 791896 794082 802946 804440 804937 805234 806010 806468 807028 808335 808540 809704 810041 810390 811785 812751 824102 826720 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð©ÐÅ ð┤ÐâÐê ð▓ð░ð¢ð¢ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац ван ван"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.75%) |
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.