Query Metrics
7
Database Queries
7
Different statements
183.16 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.38 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.68 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation girl masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 20.54 ms |
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 826569 827698 562605 652959 709724 637046 733420 735994 754391 754739 770443 690017 787019 385941 381947 527789 543444 667097 637756 774198 774189 754250 751387 381815 34035 20051 824650 820166 822319 825134 827137 817179 826568 828019 828394 828207 828838 547056 718392 554547 562574 639512 812512 741208 754631 764797 739939 773197 388135 536360 800353 150060 383091 824526 824653 823601 826093 828296 828192 828500 828505 828614 526000 709398 801567 732158 796781 804580 802038 471184 700701 782062 608456 787697 788024 743247 783295 663719 692041 695814 630988 736070 754682 381908 816858 828501 601540 752902 755324 98843 823241 824232 814199 818535 824159 825334 816108 818752 537466 531652 536800 666604 663020 673045 628517 615572 787245 812240 733400 796281 758944 755367 774039 735928 743281 754657 752992 783188 794054 811601 ] |
||||||||||||||||||||||||||||||
| 4 | 3.62 ms |
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 20051 34035 98843 150060 381815 381908 381947 383091 385941 388135 471184 526000 527789 531652 536360 536800 537466 543444 547056 554547 562574 562605 601540 608456 615572 628517 630988 637046 637756 639512 652959 663020 663719 666604 667097 673045 690017 692041 695814 700701 709398 709724 718392 732158 733400 733420 735928 735994 736070 739939 741208 743247 743281 751387 752902 752992 754250 754391 754631 754657 754682 754739 755324 755367 758944 764797 770443 773197 774039 774189 774198 782062 783188 783295 787019 787245 787697 788024 794054 796281 796781 800353 801567 802038 804580 811601 812240 812512 814199 816108 816858 817179 818535 818752 820166 823241 823601 824159 824526 824653 825334 826568 826569 827137 827698 828019 828192 828207 828296 828394 828500 828501 828505 828614 828838 ] |
||||||||||||||||||||||||||||||
| 5 | 149.49 ms |
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 20051 34035 98843 150060 381815 381908 381947 383091 385941 388135 471184 526000 527789 531652 536360 536800 537466 543444 547056 554547 562574 562605 601540 608456 615572 628517 630988 637046 637756 639512 652959 663020 663719 666604 667097 673045 690017 692041 695814 700701 709398 709724 718392 732158 733400 733420 735928 735994 736070 739939 741208 743247 743281 751387 752902 752992 754250 754391 754631 754657 754682 754739 755324 755367 758944 764797 770443 773197 774039 774189 774198 782062 783188 783295 787019 787245 787697 788024 794054 796281 796781 800353 801567 802038 804580 811601 812240 812512 814199 816108 816858 817179 818535 818752 820166 823241 823601 824159 824526 824653 825334 826568 826569 827137 827698 828019 828192 828207 828296 828394 828500 828501 828505 828614 828838 ] |
||||||||||||||||||||||||||||||
| 6 | 2.23 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.23 ms |
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.