Query Metrics
7
Database Queries
7
Different statements
378.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.03 ms (56.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"close up член"
]
|
||||||||||||||||||||||||||||||
|
142.94 ms (37.79%) |
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 391840 485645 526317 529570 530266 532277 533441 545310 555187 555622 555907 556308 559277 561384 563693 566353 590654 632450 664737 667371 692075 698254 701259 713463 714360 716651 718533 718893 719212 722115 722158 724057 725410 730581 732143 734061 734534 739253 739981 742908 744499 746321 746725 747541 748094 755242 757791 758341 761297 761523 763525 763634 763655 764540 764550 767801 767845 768162 768216 769473 771471 771736 772349 773815 775078 775913 776197 778687 779807 781030 781031 781284 781344 782575 782617 782701 783802 785782 787084 787222 787266 787459 787467 789505 791727 792226 792525 792827 793168 793894 794551 795232 795294 795559 795801 795804 797283 798745 800072 802858 803358 804577 808261 808289 809227 811985 813159 817380 818676 822292 823664 823783 823882 824006 824332 824944 825380 ] |
||||||||||||||||||||||||||||||
|
12.64 ms (3.34%) |
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 818676 822292 823664 823783 824006 824332 825380 817380 824944 485645 533441 530266 555907 555622 556308 561384 563693 664737 692075 713463 718893 667371 698254 701259 718533 555187 566353 776197 779807 780496 783802 792226 792525 794551 795804 798745 803358 804577 809227 777101 778687 781031 781344 782575 782701 789505 793894 795559 797283 800072 808289 739253 742908 746321 746725 768748 787084 787266 787459 791727 792827 793168 795232 802858 808261 813159 757791 758341 771471 725410 739981 764540 764550 767845 769473 773815 732143 747541 755242 763634 767801 772349 748094 763525 763655 768162 768216 771736 632450 714360 775078 775913 781284 782617 785782 787222 787467 795294 795801 811985 391840 526317 734534 734061 823882 529570 532277 545310 559277 722158 719212 590654 781030 724057 761523 730581 744499 761297 716651 722115 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (0.84%) |
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 391840 485645 526317 529570 530266 532277 533441 545310 555187 555622 555907 556308 559277 561384 563693 566353 590654 632450 664737 667371 692075 698254 701259 713463 714360 716651 718533 718893 719212 722115 722158 724057 725410 730581 732143 734061 734534 739253 739981 742908 744499 746321 746725 747541 748094 755242 757791 758341 761297 761523 763525 763634 763655 764540 764550 767801 767845 768162 768216 769473 771471 771736 772349 773815 775078 775913 776197 778687 779807 781030 781031 781284 781344 782575 782617 782701 783802 785782 787084 787222 787266 787459 787467 789505 791727 792226 792525 792827 793168 793894 794551 795232 795294 795559 795801 795804 797283 798745 800072 802858 803358 804577 808261 808289 809227 811985 813159 817380 818676 822292 823664 823783 823882 824006 824332 824944 825380 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"close up dick"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"close up член"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.44%) |
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.