Query Metrics
7
Database Queries
7
Different statements
147.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.21 ms (84.74%) |
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 39167 122661 142528 143019 204778 213432 308832 321450 329296 382256 383239 387817 396357 396789 398705 401873 404020 407220 408178 411812 491178 529611 545260 547268 557139 557146 562020 601090 601116 616060 620999 636506 641125 649144 651000 680630 687957 691230 691997 695984 696067 700840 707626 709242 710239 715187 716809 717084 721174 724666 726392 728340 729225 730452 732050 736380 741086 741802 742216 743404 746619 746678 747027 749394 749399 749980 750841 752516 752966 755615 755842 764323 768182 769450 776269 778046 778939 779319 779855 781004 781468 784918 784977 785501 787146 787924 790212 790820 793456 793709 795533 797305 797648 799500 803008 803588 805019 806532 807168 807630 808132 809198 809203 811467 813524 813896 815614 818743 818811 821372 822246 822808 822913 823042 823093 823135 823319 823375 827891 ] |
||||||||||||||||||||||||||||||
|
12.06 ms (8.16%) |
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 729225 732050 736380 122661 716809 396789 204778 822913 803008 142528 815614 707626 651000 616060 785501 790212 793709 730452 749394 749399 387817 401873 750841 691997 715187 743404 742216 749980 717084 808132 769450 768182 805019 601116 781004 383239 411812 382256 822246 601090 641125 813524 778939 39167 809198 793456 823291 821372 823375 529611 741802 396357 407220 321450 778046 784977 803588 809203 807168 408178 547268 784918 787146 822808 823093 823319 818811 823042 823135 827891 562020 649144 696067 695984 710239 721174 687957 620999 787924 752516 755615 755842 797305 811467 747027 728340 746678 752966 746619 790820 797648 404020 329296 557146 308832 700840 741086 709242 398705 818743 807630 776269 781468 491178 680630 545260 143019 691230 724666 213432 795533 764323 813896 557139 726392 636506 779855 779319 799500 806532 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (2.11%) |
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 39167 122661 142528 143019 204778 213432 308832 321450 329296 382256 383239 387817 396357 396789 398705 401873 404020 407220 408178 411812 491178 529611 545260 547268 557139 557146 562020 601090 601116 616060 620999 636506 641125 649144 651000 680630 687957 691230 691997 695984 696067 700840 707626 709242 710239 715187 716809 717084 721174 724666 726392 728340 729225 730452 732050 736380 741086 741802 742216 743404 746619 746678 747027 749394 749399 749980 750841 752516 752966 755615 755842 764323 768182 769450 776269 778046 778939 779319 779855 781004 781468 784918 784977 785501 787146 787924 790212 790820 793456 793709 795533 797305 797648 799500 803008 803588 805019 806532 807168 807630 808132 809198 809203 811467 813524 813896 815614 818743 818811 821372 822246 822808 822913 823042 823093 823135 823319 823375 827891 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob big tits"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.07%) |
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.