Query Metrics
7
Database Queries
7
Different statements
179.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.73 ms (86.53%) |
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 197609 265847 421610 462225 469422 476705 485296 535972 539197 539706 539954 546231 550945 554940 556261 557060 558403 562161 571379 572881 574090 585260 587108 588058 588074 588427 589604 591869 600650 610065 610196 615977 622485 622511 627671 628048 628340 636440 637197 637328 637375 643447 649738 649799 650538 652321 661427 661674 663345 670318 671056 671200 677232 677250 677689 681538 684890 686481 687366 694193 698459 700033 700062 703019 704292 706771 707481 708131 711197 722252 722285 722433 722963 725269 727277 727582 736340 737866 738479 739805 740270 746711 747415 749011 749046 749074 749591 749696 751339 752371 752440 753640 754153 761473 769031 770880 777738 782542 782744 784480 785100 785200 785340 785473 789231 791882 793108 796385 796394 796397 796401 796411 796738 797083 800648 802231 805065 805480 807879 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (7.36%) |
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 574090 722252 722285 677689 684890 704292 649799 671056 671200 615977 636440 637197 588074 589604 600650 622511 628340 785100 791882 796411 796738 793108 805480 727582 737866 746711 749074 749591 752371 752440 753640 754153 770880 800648 725269 736340 749011 749696 739805 740270 738479 727277 747415 751339 761473 769031 610196 628048 698459 700062 711197 722433 796394 796401 805065 485296 558403 556261 585260 785200 777738 802231 796385 749046 782542 785473 535972 661674 722963 708131 785340 789231 797083 782744 784480 796397 807879 469422 421610 462225 197609 265847 476705 539706 532226 539197 539954 571379 572881 550945 557060 546231 554940 652321 661427 663345 670318 677232 694193 706771 707481 649738 677250 681538 686481 700033 650538 687366 703019 562161 588058 643447 622485 637328 637375 587108 588427 591869 610065 627671 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.43%) |
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 197609 265847 421610 462225 469422 476705 485296 535972 539197 539706 539954 546231 550945 554940 556261 557060 558403 562161 571379 572881 574090 585260 587108 588058 588074 588427 589604 591869 600650 610065 610196 615977 622485 622511 627671 628048 628340 636440 637197 637328 637375 643447 649738 649799 650538 652321 661427 661674 663345 670318 671056 671200 677232 677250 677689 681538 684890 686481 687366 694193 698459 700033 700062 703019 704292 706771 707481 708131 711197 722252 722285 722433 722963 725269 727277 727582 736340 737866 738479 739805 740270 746711 747415 749011 749046 749074 749591 749696 751339 752371 752440 753640 754153 761473 769031 770880 777738 782542 782744 784480 785100 785200 785340 785473 789231 791882 793108 796385 796394 796397 796401 796411 796738 797083 800648 802231 805065 805480 807879 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"моя влажная мастурбац…"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрая мастурбац"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
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.