Query Metrics
7
Database Queries
7
Different statements
659.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.14 ms (32.61%) |
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 14966 53477 65568 118164 129748 285321 345630 365056 383638 384117 385245 385713 386193 388341 388662 388672 388930 391674 392452 392839 393765 395428 401583 401585 407290 409075 413095 413391 414021 420363 425495 432683 432824 435559 442035 446888 447985 459429 461275 463845 471899 476296 477496 487280 493873 494385 498453 506516 510820 510822 512087 512357 512683 535261 542413 546829 548458 554498 555026 559789 568259 568529 574951 576494 581477 583455 584183 592500 618276 621682 622479 622720 624193 631131 634076 639960 640242 646044 650498 673838 688181 696584 707571 713163 724580 727552 728215 730074 735995 736307 741220 741980 742938 743947 744021 744795 746177 748287 752616 752627 758322 770712 772104 772744 780656 785073 787564 788528 792761 796887 798251 799349 801629 803134 804198 807569 811765 812057 812332 819545 ] |
||||||||||||||||||||||||||||||
|
212.29 ms (32.18%) |
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 14966 53477 65568 118164 129748 285321 345630 365056 383638 384117 385245 385713 386193 388341 388662 388672 388930 391674 392452 392839 393765 395428 401583 401585 407290 409075 413095 413391 414021 420363 425495 432683 432824 435559 442035 446888 447985 459429 461275 463845 471899 476296 477496 487280 493873 494385 498453 506516 510820 510822 512087 512357 512683 535261 542413 546829 548458 554498 555026 559789 568259 568529 574951 576494 581477 583455 584183 592500 618276 621682 622479 622720 624193 631131 634076 639960 640242 646044 650498 673838 688181 696584 707571 713163 724580 727552 728215 730074 735995 736307 741220 741980 742938 743947 744021 744795 746177 748287 752616 752627 758322 770712 772104 772744 780656 785073 787564 788528 792761 796887 798251 799349 801629 803134 804198 807569 811765 812057 812332 819545 ] |
||||||||||||||||||||||||||||||
|
210.04 ms (31.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy хардкор"
]
|
||||||||||||||||||||||||||||||
|
16.82 ms (2.55%) |
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 535261 476296 555026 581477 592500 787564 730074 618276 407290 414021 432824 65568 383638 345630 393765 401585 498453 741980 741220 425495 477496 506516 493873 574951 646044 622479 631131 780656 735995 742938 727552 770712 772744 385713 385245 384117 129748 118164 391674 395428 365056 285321 53477 388672 388341 388662 420363 442035 432683 413095 435559 409075 413391 819545 446888 447985 459429 487280 463845 471899 510820 512683 510822 546829 583455 542413 548458 554498 568529 688181 713163 673838 696584 650498 707571 559789 568259 576494 584183 634076 640242 621682 639960 624193 788528 796887 807569 792761 798251 804198 812332 752616 758322 811765 736307 724580 746177 772104 743947 744021 744795 728215 748287 752627 622720 785073 799349 801629 803134 812057 392452 401583 392839 461275 386193 14966 388930 512087 512357 494385 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy extreme"
]
|
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.