Query Metrics
7
Database Queries
7
Different statements
370.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.19 ms (56.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие натуральная натуральные большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
136.09 ms (36.75%) |
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 389611 409937 415876 427191 446964 447612 448108 467281 471669 497905 510822 542217 545434 546841 547412 548234 548458 550516 551093 551568 551682 552024 554407 555735 558121 561459 561738 563116 564234 564496 566570 577805 578169 580585 587725 588065 588246 591045 594144 599801 604515 607002 607254 607288 607636 613000 613572 618691 621485 624006 625784 635734 636429 638533 639024 652806 664477 665747 675533 685509 689252 697196 697473 699325 701237 704152 712123 719937 723885 726871 728363 730338 730523 730659 732567 739778 740099 740754 741692 745390 750691 751017 751410 760862 766503 766596 768500 770097 774176 776059 776756 778866 781917 781927 782464 786792 787556 790206 790986 794229 794230 794664 796805 796819 796905 797089 797139 800103 800502 801401 802233 803824 804004 804452 808416 823437 825014 826498 827286 827393 ] |
||||||||||||||||||||||||||||||
|
15.92 ms (4.30%) |
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 558121 564496 578169 542217 550516 554407 561459 577805 685509 652806 699325 701237 665747 675533 697196 545434 551093 552024 561738 563116 580585 587725 588065 588246 591045 599801 607288 607636 613000 621485 639024 607002 618691 607254 638533 604515 624006 636429 778866 781917 790986 794229 796805 803824 776756 800502 801401 726871 740099 740754 766596 782464 797139 800103 802233 808416 730338 732567 745390 751017 766503 723885 730523 741692 760862 774176 728363 739778 768500 770097 750691 751410 712123 719937 781927 787556 790206 794230 796819 796905 804004 804452 447612 409937 389611 827393 823437 827286 547412 564234 551568 555735 566570 664477 704152 689252 625784 635734 613572 730659 786792 794664 797089 497905 776059 448108 546841 551682 594144 471669 427191 446964 415876 467281 826498 825014 510822 548234 548458 697473 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (0.80%) |
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 389611 409937 415876 427191 446964 447612 448108 467281 471669 497905 510822 542217 545434 546841 547412 548234 548458 550516 551093 551568 551682 552024 554407 555735 558121 561459 561738 563116 564234 564496 566570 577805 578169 580585 587725 588065 588246 591045 594144 599801 604515 607002 607254 607288 607636 613000 613572 618691 621485 624006 625784 635734 636429 638533 639024 652806 664477 665747 675533 685509 689252 697196 697473 699325 701237 704152 712123 719937 723885 726871 728363 730338 730523 730659 732567 739778 740099 740754 741692 745390 750691 751017 751410 760862 766503 766596 768500 770097 774176 776059 776756 778866 781917 781927 782464 786792 787556 790206 790986 794229 794230 794664 796805 796819 796905 797089 797139 800103 800502 801401 802233 803824 804004 804452 808416 823437 825014 826498 827286 827393 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big natural gape"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.42%) |
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.